tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 21

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
10-1 | [NAME] زمين درتاريخ ترازنامه متشکل ازاقلام زيرمی باشد: |  | یاداشت |  | 1390/3/31 |  | 1389/9/30
 |  |  |  |  | ريال |  | ريال
 | [NAME] ساختمان [NAME] به [NAME] |  |  |  | 112000000 |  | 112000000
 | يک قطعه زمين به [NAME] واقع درشهرک صنعتی طولادرجزيره قشم |  | 10-1-1 |  | 75000000 |  | 75000000
 | حق [NAME] |  |  |  | 25012800 |  | 25012800
 | [NAME] قطعه زمين 510متری جمعا"به [NAME] واقع درکوی کيان [NAME] اهواز |  | 10-1-2 |  | 864957382 |  | 864957382
 | [NAME] واحد ويلاهاي بابلسر جمعا به مساحت 1925/16 متر مربع واقع در شهرستان بابلسر |  | 10-1-3 |  | 8392969 |  | 8392969
 | یک قطعه زمین به [NAME] متر مربع واقع در حصار امیر [NAME] |  | 10-1-4 |  | 648141505 |  | 648141505
10-1-1 | زمين قشم به مساحت2500مترمربع که درجزيره قشم-شهرک صنعتی طولاواقع [NAME] تاسيس دفترنمايندگی درمنطقه آزاد قشم خريداری گردید .
 | با انحلال نمايندگی مانا-قشم زمين مذکور در [NAME] و تصميم گـيری در خصوص حفظ و انجام فعاليت های اجرائی ويا [NAME] آن  بالحاظ داشتن  صرفه و
 | [NAME] اقدام می باشد.
10-1-2 | از پنج قطعه زمين واقع در کيانپارس اهواز دو قطعه از آنها بر اساس [NAME] اهواز در طرح احداث خیابان قرارگرفته که بر اساس نظر کارشناس رسمی دادگستری
 | ارزش روز آن معادل  10،064،000،000  ریال برآورد گردیده است و  شهرداری اهواز  ملزم به اعطای معوض و  یا پرداخت وجه آن گردیده و [NAME] قطعه دیگر قبلا" مورد
 | ادعای سازمان زمین شهری اهواز  بوده [NAME] به  فروش یک قطعه زمین در سال  85  ادعای سازمان مذکور عملا" مرتفع و احیاء سه  قطعه [NAME]براساس
 | [NAME]  ساخت در دست پیگیری قرار دارد.
10-1-3 | [NAME] [NAME] بابلسر جمعا به مساحت 1925/16 متر مربع واقع در مجتمع خزر كنار شهرستان بابلسر می باشد.
10-1-4 | [NAME] حصار [NAME] به مساحت178431مترمربع معادل 21% سهم شرکت مانا اززمینهای مذکور می باشد [NAME] به توافق نامه مورخ 87/10/8 و وکالت نامه
 | شماره 860909 مورخ 87/10/10 جهت اخذ سند تفکیکی در پایان سال 87 به حساب دارایی منظور گردیده است.
10-2 | [NAME] ساختمان درتاريخ ترازنامه متشکل از اقلام زیر می باشد: |  |  |  | 1390/3/31 |  | 1389/9/30
 |  |  |  |  | ريال |  | ريال
 | ساختمان اداری،تولید،رستوران،مهمانسرا،انبارو محوطه تیربتنی |  |  |  | 3985071284 |  | 3985071284
 | ساختمان 4 واحد ويلاي بابلسر |  |  |  | 977642397 |  | 977642397
 | ساختمان دفترمرکزی شرکت |  |  |  | 1117264446 |  | 1117264446
 |  |  |  |  |  |  | .
Spreadsheet: 456049d1460623216-subtotal-in-if-function-book1
Sheet: Sheet2

Sum of Total | Column Labels
Row Labels | 8 | 30 | 60 | Grand Total
1 |  |  | 650 | 650
2 |  |  | 150 | 150
3 |  | 850 |  | 850
4 |  | 250 |  | 250
5 |  |  | 3150 | 3150
6 |  |  | 578.5 | 578.5
7 |  |  | 882.9 | 882.9
8 |  |  | 572.4 | 572.4
9 |  |  | 572.4 | 572.4
10 |  |  | 211.68 | 211.68
11 |  |  | 10500 | 10500
12 |  |  | 572.4 | 572.4
13 |  |  | 10500 | 10500
14 |  |  | 133.25 | 133.25
15 |  |  | 133.25 | 133.25
16 |  |  | 276.25 | 276.25
17 |  |  | 450 | 450
18 |  |  | 615 | 615
19 |  |  | 410 | 410
20 |  |  | 4125 | 4125
21 |  |  | 114473.75 | 114473.75
22 |  |  | 170.95 | 170.95
23 |  |  | 442 | 442
24 |  |  | 180.7 | 180.7
25 |  |  | 263.25 | 263.25
26 |  |  | 263.25 | 263.25
27 |  |  | 434103 | 434103
28 |  |  | 20500 | 20500
29 |  |  | 42000 | 42000
30 |  |  | 63825.3 | 63825.3
31 |  |  | 3500 | 3500
32 |  | 1050 |  | 1050
33 |  |  | 500 | 500
34 |  |  | 650 | 650
35 |  |  | 150 | 150
36 |  |  | 1350 | 1350
37 |  | 10000 |  | 10000
38 |  |  | 2312 | 2312
39 |  |  | 6001 | 6001
40 |  |  | 21539 | 21539
41 |  | 30000 |  | 30000
42 | 10000 |  |  | 10000
43 |  |  | 1785 | 1785
44 |  |  | 5525 | 5525
45 |  |  | 6500 | 6500
46 |  | 26780 |  | 26780
47 |  | 7000 |  | 7000
Grand Total | 10000 | 75930 | 760517.2300000001 | 846447.2300000001
Spreadsheet: 681452d1591578810-index-match-on-non-adjacent-columns-index-match-question
Sheet: Sheet1

 | Index(Match) Question
 | How do I use column B & D in an Index(Match) formula?
 | I don't know what to insert in the shaded cells, B37 and B38.
 | Date | Col 1 | Col 2
 | 2019-01-31 00:00:00 | 110800 | 52000
 | 2019-02-28 00:00:00 | 111255 | 50000
 | 2019-03-31 00:00:00 | 112544 | 51000
 | 2019-04-30 00:00:00 | 110585 | 52500
 | 2019-05-31 00:00:00 | 114200 | 56000
 | 2019-06-30 00:00:00 | 106500 | 58000
 | 2019-07-31 00:00:00 | 108600 | 60000
 | 2019-08-31 00:00:00 | 115900 | 62000
 | 2019-09-30 00:00:00 | 115700 | 58000
 | 2019-10-31 00:00:00 | 109200 | 56000
 | 2019-11-30 00:00:00 | 108500 | 54000
 | 2019-12-31 00:00:00 | 107300 | 52000
 | Solved for Column C
 |  | Last Closing Value
 |  | [NAME]
 |  | Delta of the Max Closing Value and the last Closing Value
 |  | Date of the highest Closing Value
 |  | Nearest Closing Value to current Closing Value
 |  | Date of nearest [NAME] to current Closing Value
 |  | Weeks between last Closing Value and nearest [NAME]
 | Solved for Column D
 |  | Last Closing Value
 |  | [NAME]
 |  | Delta of the Max Closing Value and the last Closing Value
 |  | Date of the highest Closing Value
 |  | Nearest Closing Value to current Closing Value
 |  | Date of nearest [NAME] to current Closing Value
 |  | Weeks between last Closing Value and nearest [NAME]
Spreadsheet: joe_parks__14715__POSTION05_02
Sheet: JUN_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  | 94 | 3.395 |  |  |  |  | MTM
 | 14 | 3.428 |  |  | 2 | 3.424 |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  | 13 | 3.425 |  |  |  |  | NEW DEALS
 |  |  |  |  | 13 | 3.429
 |  |  |  |  | 30 | 3.43 |  |  |  |  | TOTAL  P&L
 | 15 | 3.47
 | 25 | 3.47
 |  |  |  |  | 15 | 3.495 |  |  |  |  | POSTION
 |  |  |  |  | 15 | 3.49 |  |  |  |  | ROLL OFF
 |  |  |  |  | 15 | 3.48 |  |  |  |  | NET POSTION
 |  |  |  |  | 15 | 3.465
 |  |  |  |  |  |  |  |  | Position |  |  | 50000
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 717294d1612555297-compare-between-2-columns-to-find-missing-names-and-put-it-in-new-column-missing-name
Sheet: Missing Names

Name
زهراء حميد نجم
خديجة رزاق هادي
زهراء شاكر أحمد
يوسف عبد الرزاق جبار سرهيد
هادي فاضل عبد الزهره عبد علي
مصطفى محمد عزيز حسين
نور جاسم محمد [NAME]
[NAME] سامي جواد
محمد حيدر صالح مطلق
فاطمه عبد العالي كريم علوان
علي [NAME] هاشم
زهراء مؤيد حمزه عبود
عبير علي جليل جاسم
زهراء احمد عبد الساده علي
جعفر محمد عبد الحميد ضيدان
حسين علي جاسم عبد
زهراء حسين داود شبيب
ايات صفاء نجم عبد الحسين
محمد احمد شهاب ذياب
عباس علي جبار ضهد
زينب جاسم فنجان حسن
زهراء عقيل عبد الكاظم جبار
حيدر علي ظاهر حبيب
Spreadsheet: john_griffith__16011__2_4_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 145 | 158 | 54.9 | 59.9 | 0.72 | 2002-02-04 10:05:00
 | CL J2 | 20.5 | 257 | 270 | 48.3 | 50.7 | 0.64 | 2002-02-04 10:05:00
 | CL K2 | 20.5 | 342 | 357 | 47.5 | 49.6 | 0.63 | 2002-02-04 10:05:00
 | CL M2 | 21 | 390 | 405 | 44.8 | 46.6 | 0.6 | 2002-02-04 10:05:00
 | CL N2 | 21 | 430 | 450 | 43.2 | 45.3 | 0.58 | 2002-02-04 10:05:00
 | CL Q2 | 21 | 460 | 475 | 42 | 43.3 | 0.56 | 2002-02-04 10:05:00
 | CL U2 | 21 | 475 | 490 | 40.1 | 41.4 | 0.54 | 2002-02-04 10:05:00
 | [NAME] | 21 | 490 | 510 | 38.4 | 39.9 | 0.52 | 2002-02-04 10:05:00
 | CL X2 | 21 | 495 | 515 | 36.5 | 38 | 0.49 | 2002-02-04 10:05:00
 | [NAME] | 21 | 500 | 520 | 35.1 | 36.5 | 0.47 | 2002-02-04 10:05:00
 | CL F3 | 21 | 500 | 525 | 33.5 | 35.2 | 0.45 | 2002-02-04 10:05:00
 | CL G3 | 21 | 505 | 530 | 32.4 | 34.1 | 0.44 | 2002-02-04 10:05:00
 | CL M3 | 21 | 540 | 570 | 30.4 | 32.1 | 0.41 | 2002-02-04 10:05:00
 | CL Z3 | 21 | 540 | 575 | 26.5 | 28.2 | 0.36 | 2002-02-04 10:05:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: na

Noons. Con |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 5ba84f0b-a61f-4f19-a4e0-dd05a12ccaf7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259482 | 73761 | Marcelo | [NAME] | BRA |  | 00:16:54 | 00:00:57 | 00:31:35 | [NAME] | 00:22:02 | 1 | 01:12:24
259482 | 25030 | [NAME] | Maia | BRA |  | 00:13:11 | 00:01:11 | 00:33:13 | 00:01:26 | 00:24:43 | 2 | 01:13:45
259482 | 52207 | Mauro | Duarte | BRA |  | 00:14:03 | 00:00:59 | 00:35:14 | 00:01:01 | [NAME] | 3 | 01:16:26
259482 | 73572 | [NAME] | Perovano | BRA |  | 00:16:01 | 00:01:14 | 00:34:41 | 00:00:49 | 00:24:16 | 4 | 01:17:04
259482 | 73573 | [NAME] | Matias | BRA |  | 00:15:44 | 00:01:18 | 00:32:22 | 00:00:48 | 00:28:18 | 5 | 01:18:32
259482 | 73574 | [NAME] | Carballal | BRA |  | 00:20:09 | 00:02:03 | 00:36:38 | 00:01:58 | 00:34:55 | 6 | 01:35:46
Spreadsheet: 769479d1645551639-extract-text-between-parentheses-cost-center
Sheet: Sheet1

WO | District | LeadTech | Amount | Cost Center |  |  |  | WO | District | LeadTech | Amount | Cost Center
 | Administration(920): |  |  |  |  |  |  |  | Administration(920):
A00100 | North | [NAME] | 360 |  |  |  |  | A00100 | North | [NAME] | 360
A00101 | South | Lopez | 90.0416 |  |  |  |  | A00101 | South | Lopez | 90.0416
A00102 | Central | [NAME] | 120 |  |  |  |  | A00102 | Central | [NAME] | 120
A00103 | South | Lopez | 16.25 |  |  |  |  | A00103 | South | Lopez | 16.25
A00104 | Northwest | [NAME] | 45.2374 |  |  |  |  | A00104 | Northwest | [NAME] | 45.2374
A00105 | South | Lopez | 97.6263 |  |  |  |  | A00105 | South | Lopez | 97.6263
A00106 | Central | [NAME] | 29.13 |  |  |  |  | A00106 | Central | [NAME] | 29.13
A00107 | South | Lopez | 35.1 |  |  |  |  | A00107 | South | Lopez | 35.1
A00108 | Northwest | [NAME] | 76.7 |  |  |  |  | A00108 | Northwest | [NAME] | 76.7
A00109 | Central | [NAME] | 374.0794 |  |  |  |  | A00109 | Central | [NAME] | 374.0794
A00110 | West | [NAME] | 832.1583 |  |  |  |  | A00110 | West | [NAME] | 832.1583
 | [NAME]): |  |  |  |  |  |  |  | [NAME]):
A00111 | South | Lopez | 70.213 |  |  |  |  | A00111 | South | Lopez | 70.213
A00112 | West | [NAME] | 150 |  |  |  |  | A00112 | West | [NAME] | 150
A00113 | Central | [NAME] | 275 |  |  |  |  | A00113 | Central | [NAME] | 275
A00114 | Northwest | [NAME] | 938 |  |  |  |  | A00114 | Northwest | [NAME] | 938
A00115 | South | Lopez | 61.2497 |  |  |  |  | A00115 | South | Lopez | 61.2497
A00116 | West | [NAME] | 48 |  |  |  |  | A00116 | West | [NAME] | 48
A00117 | Northwest | [NAME] | 204.284 |  |  |  |  | A00117 | Northwest | [NAME] | 204.284
A00118 | Northwest | [NAME] | 240 |  |  |  |  | A00118 | Northwest | [NAME] | 240
 | Administration(554): |  |  |  |  |  |  |  | Administration(554):
A00130 | Southwest | [NAME] | 155.3931 |  |  |  |  | A00130 | Southwest | [NAME] | 155.3931
A00131 | Northwest | [NAME] | 204.284 |  |  |  |  | A00131 | Northwest | [NAME] | 204.284
A00132 | Northwest | [NAME] | 37.9174 |  |  |  |  | A00132 | Northwest | [NAME] | 37.9174
A00133 | West | [NAME] | 88.4057 |  |  |  |  | A00133 | West | [NAME] | 88.4057
A00134 | West | [NAME] | 202.2864 |  |  |  |  | A00134 | West | [NAME] | 202.2864
A00135 | Northwest | [NAME] | 120 |  |  |  |  | A00135 | Northwest | [NAME] | 120
Spreadsheet: 101135d1299265245-if-formula-giving-a-false-return-2011-ncaa-tournament-bracket-and-squares
Sheet: Workbook Contents

Page Name: |  | Contents:
• Square Entry |  | Place each players name in a square. If player has paid enter a lower case (a)* in the box next to the name.
 |  | White Cells: Not Sold |  |  | Red Cells: Sold but not Paid |  |  |  | Blue Cells: Sold and Paid
 |  | Entry fee (controlled from 'Team Entry' page)
 |  | A running total of paid entries.
 |  | The number of squares not yet sold.
 |  | The amount won for all games that have been paid.
 |  | The amount left in the pot from games not yet played.
• Team Entry |  | All data except game scores and player names are entered on this page. |  |  |  |  |  |  |  |  | (parts of this sheet are protected to prevent accidental data entry)
• Scores |  | Enter scores as a game is completed (be sure to mark the game complete in column "I" with a lower case (a)* to compute total winnings).
 |  | After teams have been entered the cell will turn RED. Click "sort" button to turn the cell to GREEN.
 |  | NOTE: Do not change scores after a game has been entered, it may cause data to become corrupt.
 |  | In the event this happens deleat the game data using the "Deleat All Data" button. Do not deleat the team scores just reenter the games.
 |  | (parts of this sheet are protected to prevent accidental data entry)
• Results |  | View the winners as well as their wining totals. |  |  |  |  |  | (this sheet is protected to prevent accidental data entry)
• [NAME] |  | Tournament bracket automatically updates the field as scores are entered. |  |  |  |  |  |  |  |  | (this sheet is protected to prevent accidental data entry)
• Players |  | A hidden list of the players entered and the numbers chosen. |  |  |  |  |  |  |  | (this sheet is protected to prevent accidental data entry)
 |  | * (a) cells are formated to turn into a check mark when a lower case "a" is entered.
 |  |  | Call me for any questions.
 |  |  | [NAME]: (614) 557-8429    (614) 268-3121
Spreadsheet: 35551d1233156667-macro-required-to-added-week-numbers-to-columns-week-numbers
Sheet: Sheet1

Code | Name | Week Number | Hrs WK01 | Hrs WK02 | Hrs WK03 | Hrs WK04
123 | [NAME] |  | 9 | 0 | 0 | 0
456 | [NAME] |  | 9 | 0 | 0 | 0
123 | [NAME] |  | 9 | 0 | 0 | 0
456 | [NAME] |  | 9 | 0 | 0 | 0
123 | [NAME] |  | 9 | 0 | 0 | 0
444 | [NAME] |  | 1 | 0 | 0 | 0
123 | [NAME] |  |  | 2
123 | [NAME] |  |  | 10
444 | [NAME] |  |  | 21
123 | [NAME] |  |  | 12
999 | [NAME] |  |  | 12
456 | [NAME] |  |  |  | 23
123 | [NAME] |  |  |  | 25
444 | [NAME] |  |  |  | 25
123 | [NAME] |  |  |  | 12
123 | [NAME] |  |  |  |  | 15
444 | [NAME] |  |  |  |  | 12
123 | [NAME] |  |  |  |  | 12
999 | [NAME] |  |  |  |  | 19
123 | [NAME] |  |  |  |  | 15
444 | [NAME]
Spreadsheet: 751543d1634160916-index-match-difficulties-sample-workbook
Sheet: Sheet1

[NAME] | Customer Name | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Total
1 | Customer A
2 | Customer B
3 | Customer C
4 | Customer D
5 | Customer E
6 | Customer F
Spreadsheet: 682010d1591877157-cell-contents-not-displaying-in-top-cell-contents-display-box-locking-protection-
Sheet: Sheet1

 | HUSID | SURNAME | FNAMES | FNMECHNGE | EMAIL1 | UKMOB1 | UKTEL1 | INTTEL1
REF1 | [NAME] | SURNAME | FIRST NAME | [NAME] | EMAILS | MOBILE | HOME | OTHER
RX | [PHONE] | BURTH | RANDY |  | [EMAIL] | [PHONE] | [PHONE]
RS | [PHONE] | SHONE | CARYS |  | [EMAIL] | [PHONE] | [PHONE]
RT | [PHONE] | SAYNE | OLIVA |  | [EMAIL] | [PHONE] | [PHONE]
RD | [PHONE] | MORSE | RUTH |  | [EMAIL] | [PHONE] | [PHONE]
RM | [PHONE] | DOVE | RHYS |  | [EMAIL] | [PHONE] | [PHONE]
Spreadsheet: 224225d1364491813-merge-24-seperate-workbooks-into-one-2012-1-15-log-inv
Sheet: Inventory Report

Sum of Quantity |  |  |  |  |  |  | Transtype
Owner Org Unit | Inventory Account | Global Location Name | Grade | [NAME] | Grade Name | Lot | Init. Bal. | x End Bal.
MKT | 147010 | LOGISTEC MONTREAL PQ - CA | MA1005 | 2 X 1/2 | H C FE MN, 78 min Mn | MKT-NO-1691 | 580432.44 | 580432.44
 |  |  |  | 2 X 1/4 | H C FE MN, 78 min Mn | MKT-IT-13762 | 3306933.45 | 3306933.45
 |  |  | MA1005 Total |  |  |  | 3887365.89 | 3887365.89
 |  |  | MA2010 | 2 X 1/4 | M C FE MN | MKT-IT-13763 | 6393404.67 | 6393404.67
 |  |  |  |  |  | MKT-NO-1609 | 18759.71 | 18759.71
 |  |  |  |  |  | MKT-NO-1673 | 250330.84 | 250330.84
 |  |  |  |  |  | MKT-NO-1715 | 199496.93 | 199496.93
 |  |  | MA2010 Total |  |  |  | 6861992.149999999 | 6861992.149999999
 |  |  | MA3012 | 3 X 1/2 | L C FE MN, 0.5C MAX L N | MKT-IT-13764 | 1763697.84 | 1763697.84
 |  |  |  |  |  | MKT-NO-1693 | 65888.63 | 65888.63
 |  |  |  |  |  | MKT-NO-1717 | 1312895 | 1312895
 |  |  | MA3012 Total |  |  |  | 3142481.47 | 3142481.47
 |  |  | MA4001 | 2 X 1/2 | SiMn, 2% C [NAME] | MKT-IT-13766 | 3086471.22 | 3086471.22
 |  |  |  |  |  | MKT-KV-316 | 197691.35 | 197691.35
 |  |  |  |  |  | MKT-KV-319 | 2530542 | 2530542
 |  |  | MA4001 Total |  |  |  | 5814704.57 | 5814704.57
 |  |  | MA5001 | 2 X 1/2 | Low [NAME] (LCSiMn) | MKT-KV-308 | 182740.79 | 182740.79
 |  |  |  |  |  | MKT-KV-325 | 659360 | 659360
 |  |  |  | 3 X 1 | Low [NAME] (LCSiMn) | MKT-IT-13765 | 881848.92 | 881848.92
 |  |  |  | 3 X 1/2 | Low [NAME] (LCSiMn) | MKT-KV-276 | 308020 | 308020
 |  |  |  |  |  | MKT-KV-306 | 1330554 | 1330554
 |  |  |  |  |  | MKT-KV-323 | 1775226 | 1775226
 |  |  | MA5001 Total |  |  |  | 5137749.71 | 5137749.71
 |  | LOGISTEC MONTREAL PQ - CA Total |  |  |  |  | 24844293.79 | 24844293.79
 | 147010 Total |  |  |  |  |  | 24844293.79 | 24844293.79
MKT Total |  |  |  |  |  |  | 24844293.79 | 24844293.79
Spreadsheet: 4ee498cb-f01e-49bb-aa97-26cedf40af20
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43480681 | 2014-10-07 19:44:42 | ALLIES | 1 | 7 | 5 | 1546936 | KATANA PAPA | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
43493590 | 2014-10-08 18:15:42 | ALLIES | 0 | 6 | 7 | 653605 | Le Pelican | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
43494066 | 2014-10-08 18:53:13 | AXIS | 1 | 7 | 6 | 653605 | Le Pelican | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
43504665 | 2014-10-09 13:27:19 | ALLIES | 1 | 7 | 2 | 1634140 | [NAME] | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
43565435 | 2014-10-13 17:21:39 | ALLIES | 1 | 6 | 3 | 603439 | MickeyScott01 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43577836 | 2014-10-14 13:54:31 | ALLIES | 1 | 6 | 5 | 1651852 | player1651852 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43622625 | 2014-10-17 21:22:47 | ALLIES | 1 | 6 | 2 | 418671 | anejauneetbleu | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43623040 | 2014-10-17 21:45:52 | AXIS | 1 | 6 | 3 | 418671 | anejauneetbleu | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
Spreadsheet: 705320d1606023699-duplicate-value-with-in-a-cell-test
Sheet: Sheet1

Details | observations | Function results
1334778 | 3 & 7 are duplicate | 3,7
1255669 | 6 is duplicate | 6
2334568 | 3is duplicate | 3
1112467 | 1 is triplicate | 1
1114567 | 1 is triplicate | 1
2456799 | 9 is duplicate | 9
2256799 | 2 & 9 are duplicate | 2,9
2233444 | 2,3,4 has multiple counts | 1,3,4
1234123456
01234567891234567890
[NAME] number in cell= 7 digits
Spreadsheet: 818687d1676999039-allocate-amount-by-matching-month-s-with-percentages-distribution-by-month-by-percentage
Sheet: Sheet1

 |  |  | At Month | 2 Months After | 4 Months After | 8 Months After
 |  |  | 0.1 | 0.2 | 0.3 | 0.4
 | Amount | Start |  | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00
 |  | 2023-01-31 00:00:00
 | 130 | 2023-04-30 00:00:00
 | 1000 | 2023-02-28 00:00:00
 | 398 | 2023-06-30 00:00:00
 |  |  |  | 0 | 50 | 0 | 75 | 0 | 0 | 0 | 100
 |  |  | 0 | 0 | 0 | 13 | 0 | 26 | 0 | 39 | 0
 |  |  | 0 | 100 | 0 | 200 | 0 | 300 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 39.8 | 0 | 79.60000000000001 | 0
Spreadsheet: 700838d1603367596-how-can-i-split-data-in-cells-splitting-example
Sheet: Sheet1

 |  | What I currently have. |  |  |  |  |  | What I would like to have.
 |  | Subtotal can't decifer with the units. ------> |  |  |  |  |  | Subtotal can decifer now that the units are seperated. --->
 |  |  | Amount |  |  |  |  | Amount |  | Value | Units
 |  |  | 0.125 lb |  |  |  |  | 0.125 lb | ----> | 0.125 | lb
 |  |  | 1.5 gal |  |  |  |  | 1.5 gal | ----> | 1.5 | gal
 |  |  | 2,536 fl oz |  |  |  |  | 2,536 fl oz | ----> | 2536 | fl oz
 |  |  | 2.5 gal |  |  |  |  | 2.5 gal | ----> | 2.5 | gal
 |  |  | 24 fl oz |  |  |  |  | 24 fl oz | ----> | 24 | fl oz
 |  |  | 320 fl oz |  |  |  |  | 320 fl oz | ----> | 320 | fl oz
 |  |  | 38.5 lb |  |  |  |  | 38.5 lb | ----> | 38.5 | lb
 |  |  | 45,096 fl oz |  |  |  |  | 45,096 fl oz | ----> | 45096 | fl oz
 |  |  | 5 lb |  |  |  |  | 5 lb | ----> | 5 | lb
Spreadsheet: 800163d1665510872-date-formula-to-show-on-time-and-late-with-exceptions-help
Sheet: Sheet1

TAFQAR Date | Mfg | Mfg docs to QA | TAFQAR STATUS MFG |  |  | DAYS OLD
2022-10-03 00:00:00 | 2022-09-16 00:00:00 | 2022-10-03 00:00:00 |  |  |  |  |  |  |  | The date in in cell [NAME] has to be 5 days before the date in A2 to be considered "On Time", but if there are no dates in the B column then the D column should show "On Time".
2022-10-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-04 00:00:00
2022-10-11 00:00:00 | 2022-09-25 00:00:00
 |  |  |  |  |  |  |  |  |  | F2 = Late ( C2 is not 5 days before A2) F3 = On Time ([NAME] is at least 5 days before A3) F4 = On Time (B4 is blank meaning no documents required so it cant be late)  If C column is empty and still 5 days before the TAQFAR date then F column should still be on time as well.