tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 717015d1612452933-set-day-if-statement-is-true-as-return-value-workbook-sample
Sheet: Master Worksheet

Item | Status | Date Completed
Item1 |  | No date here
Item2 |  | Automatically show date that B3 becomes completed status
Item3
Item4
Item5
Item6
Item7
Item8
Spreadsheet: 214983d1361217108-autosum-between-sheets-forum-question
Sheet: Week 1

 | Child Support | 0 |  |  |  |  |  |  |  |  | PayRoll Amount
 | Deductions | 0 | Employee Witholdings | 0 | [NAME] | 0 |  | Total Taxes
EIN | First Name | Last Name | Rate Per Hour | Reg Hours | Account | Hours | Vac Time | Sick Time | OT/HWD | Holiday | Deductions | Total
410-000
410-001
410-002
410-003
410-004
410-005
410-006
410-007
410-008
410-009
410-010
410-011
410-012
410-013
411-000
411-001
411-002
411-003
411-004
411-005
412-000
412-001
412-002
413-000
413-001
413-002
414-000
414-001
414-002
414-003
414-004
414-005
414-006
415-000
416-000
417-000
417-001
417-002
417-003
417-004
418-000
419-000
419-001
419-002
420-000
420-001
420-002
420-100
421-000
421-001
421-002
421-003
421-004
421-005
421-006
421-007
422-000
423-000
423-001
423-002
424-000
424-001
424-002
424-003
424-004
424-005
424-006
424-007
424-008
424-009
424-010
424-011
424-012
424-013
425-000
425-001
425-002
426-000
426-002
426-003
426-004
426-005
426-006
426-007
426-008
426-009
426-010
427-000
427-001
427-002
428-000
428-001
429-000
430-000
431-000
432-000
433-000
434-000
435-000
436-001
436-002
436-003
437-000
437-001
437-002
437-003
438-000
438-001
438-002
438-003
439-000
439-001
439-002
440-000
441-000
411-000
Spreadsheet: 791359d1660309705-solved-if-g2-h2-not-empty-then-hightlight-green-esle-if-j2-not-empty-hightlight-yellow-sample_students_courses
Sheet: STUDENTS_COURSES

STUDENTID | STUDENT | COHORT | COM | COUNSELOR | COURSE 1 | C1 ENR | C1 CMP | COURSE 2 | C2 ENR | C2 CMP | COURSE 3 | [NAME] | [NAME] | COURSE 4 | C4 ENR | [NAME] | COURSE 5 | C5 ENR | [NAME] | COURSE 6 | C6 ENR | C6 CMP | NOTES
123
456
789
111
Spreadsheet: 709866d1608585974-if-formula-giving-a-3-different-outcomes-outcome-sheet
Sheet: Sheet1

 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Target | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
[NAME] running target
Actual | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Run rate %
Q1 Outcome
[NAME]
Q3 outcome
[NAME]
Spreadsheet: 875331d1721916400-find-duplicates-rows-assess-difference-in-date-and-add-adjacent-column-single-vs-multiple-payments-examplev3
Sheet: Example Sheet

 |  |  | *If payments occur within 6 months of each other then the objective is to merge in to one 'record' as a 'single tranche'. If outside of 6 months they should b eleft as Multiple Tranche
 |  |  | A. Single Payment (no action needed)
 |  |  | B. Converted Single Payment (sum up with other relevant rows)
 |  |  | C. Payment falling within 6 months of first payment (now ignore)
 |  |  | D. One of Multiple Payments (Treat seperately)
Company Name | Date Money Received | Amount | Categorisation | (If appropriate) Combined Amount | Final amount to be used (uses column C or column E, where appropriate)
AAA | 2019-01-01 00:00:00 | 500 | B. Converted Single Payment (sum up with other relevant rows) | 2000 | 2000
BBB | 2020-01-01 00:00:00 | 2500 |  | N/a | 2500
CCC | 2020-01-01 00:00:00 | 3000 |  |  | 4500
DDD | 2019-01-01 00:00:00 | 1200 | C. Payment falling within 6 months of first payment (now ignore) | N/a | 1200
EEE | 2019-01-01 00:00:00 | 800 | Converted Single Payment (other relevant rows added) | 1700 | 1700
EEE | 2019-04-01 00:00:00 | 900 | C. Payment falling within 6 months of first payment (now ignore) | -
EEE | 2022-01-01 00:00:00 | 750 | D. One of Multiple Payments (Treat seperately) | N/a | 750
FFF | 2023-01-01 00:00:00 | 2000 |  | N/a | 2000
GGG | 2023-04-04 00:00:00 | 3500 | B. Converted Single Payment (sum up with other relevant rows) | 8000 | 8000
GGG | 2023-06-08 00:00:00 | 4500 | C. Payment falling within 6 months of first payment (now ignore) | -
MMM | 2019-01-01 00:00:00 | 4500 |  | N/a | 4500
RRR | 2019-04-01 00:00:00 | 2000 | D. One of Multiple Payments (Treat seperately) | N/a | 2000
RRR | 2022-01-01 00:00:00 | 4500 | D. One of Multiple Payments (Treat seperately) | N/a | 4500
CCC | 2020-03-01 00:00:00 | 4500 | C. Payment falling within 6 months of first payment (now ignore) | -
AAA | 2019-05-01 00:00:00 | 1500 | C. Payment falling within 6 months of first payment (now ignore) | -
Spreadsheet: 879687d1727262137-vlookup-but-source-has-zeroes-before-the-value-example_problem
Sheet: Sheet1

Example from table 1 |  |  |  | Example from table 2
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
'[PHONE]' |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
 |  |  |  | [PHONE]
Spreadsheet: 160391d1339076048-data-validation-how-to-display-values-in-cells-rather-than-drop-down-list-example1-1-
Sheet: Sheet1

SOURCE CODE/DEFINITIONS
MAKE |  | MODELS |  | TRIMS
Make |  | BMW |  | ThreeSeries
BMW |  | Three Series |  | 328i
Mercedes |  | Five Series |  | 328xi
Audi |  | Six Series |  | 335i
 |  |  |  | 335xi
USER INTERFACE
Make |  | Model |  | Trim
BMW |  | Three Series |  | 328i
 |  |  |  | 328xi
 |  |  |  | 335i
 |  |  |  | 335xi
Spreadsheet: 98882d1297709854-how-can-i-have-data-inserted-based-on-typed-in-dates-vekkor-1
Sheet: Monday,January 03, 2011

Daily Cash Receipts Register
Monday, January 03, 2011
Name | Payment Type | Receipt # | Credit/Debit Amt | Check Amt | Check # | Cash | [NAME] # | Total
[NAME] | $5.00 coupon | 555910 |  |  |  | 20
[NAME] | Retail | 555911 |  | 25
[NAME] | Retail | 555912 | 25
[NAME] | Retail | 555913 |  |  |  | 25
Totals:
Spreadsheet: daren_farmer__5222__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 357174.781662146
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 0442c9f2-30dc-4cc0-8949-0c2e0acac3ed
Sheet: AMH CMH Patients Served

 |  | Children's Mental Health |  |  | Adult Mental Health
 |  | Number of children served this Month | Number of children served SFY2014 |  | Number of adults served this Month | Number of adults served SFY2014
Region 1 | Benewah | 79 | 123 |  | 379 | 630
 | [NAME]
 | Boundary
 | Kootenai
 | Shoshone
Region 2 | Clearwater | 75 | 94 |  | 195 | 330
 | Idaho
 | Latah
 | Lewis
 | Nez Perce
Region 3 | Adams | 86 | 129 |  | 676 | 1249
 | Canyon
 | Gem
 | Owyhee
 | Payette
 | Washington
Region 4 | [NAME] | 162 | 247 |  | 676 | 1564
 | Boise
 | Elmore
 | Valley
Region 5 | Blaine | 91 | 123 |  | 262 | 540
 | [NAME]
 | Cassia
 | Gooding
 | [NAME]
 | Lincoln
 | Minidoka
 | [NAME]
Region 6 | Bannock | 60 | 91 |  | 270 | 500
 | Bear Lake
 | [NAME]
 | Franklin
 | Oneida
 | Power
Region 7 | Bingham | 164 | 287 |  | 583 | 965
 | [NAME]
 | [NAME]
 | [NAME]
 | Custer
 | Fremont
 | [NAME]
 | Lemhi
 | [NAME]
 | Teton
Unknown
Statewide
 |  | AMH Clients Served October | AMH Clients Served SFY12 |  | CMH Clients Served October | CMH Clients Served SFY13
 |  | 318 | 516 |  | 57 | 95
 |  | 226 | 366 |  | 66 | 85 |  |  | 76 | 114 | 45 | 48
 |  | 444 | 634 |  | 58 | 102 |  |  | 83 | 147 | 68 | 66
 |  | 587 | 1224 |  | 126 | 208
 |  | 216 | 463 |  | 54 | 99
 |  | 213 | 399 |  | 54 | 90
 |  | 442 | 796 |  | 165 | 270
 |  | 2446 | 4398 |  | 580 | 949
 |  | 326 | 414 |  | 63 | 80
 |  | 205 | 266 |  | 69 | 75
 |  | 430 | 527 |  | 76 | 83
 |  | 605 | 830 |  | 114 | 147 | 63 | 69 |  |  |  |  | 186
 |  | 236 | 362 |  | 45 | 68 | 80 | 75 | 430 | 605 | 236 | 244 | 213
 |  | 244 | 315 |  | 48 | 66 |  |  | 527 | 830 | 362 | 315
 |  | 543 | 656 |  | 186 | 213
 |  |  |  |  |  |  | 326 | 205 |  |  |  |  | 543
 |  |  |  |  |  |  | 414 | 266 |  |  |  |  | 656
 |  |  |  |  |  |  | 326 | 414
 |  |  |  |  |  |  | 205 | 266
 |  |  |  |  |  |  | 430 | 527
 |  |  |  |  |  |  | 605 | 830
 |  |  |  |  |  |  | 236 | 362
 |  |  |  |  |  |  | 244 | 315
 |  |  |  |  |  |  | 543 | 656
Spreadsheet: 155171d1336694109-average-median-max-and-min-of-a-specific-range-excel-question
Sheet: Results

Enterprise Value | Seller Note [Agg Amt] % of Enterprise Value
325000
496465
1089543
3000000
3000000
3100000
6000000 | 0.1666666666666667
6000000
6750000
6950000
7508000
8000000
9000000
10200000
12000000
12000000 | 0.3333333333333333
12000000 | 0.1875
15000000
15000000
15000000 | 0.15
16000000
16750000
16880000 | 0.1981635071090047
17500000
18000000
19200000
19300000
19750000 | 0.0759493670886076
20000000
20000000 | 0.05
22419000 | 0.1338150675766091
22500000
22500000
22500000
23963159
27050000
27250000
29500000
30500000
31000000
32000000
34000000
34513000
36000000
38200000
42000000
43750000
43875000
47000000
48000000
50000000
50289750
55000000
55000000
55000000
61236000
62000000
63200000
66000000
66500000
70000000
72000000
72000000
72750000 | 0.2611683848797251
75000000
80000000
80000000
83500000
84000000
84000000
85000000
86500000
90000000
100000000
100000000
100000000
101250000
105000000
105000000
115000000 | 0.005900034782608696
120000000
128700000
133000000
133000000
133000000
135000000
145000000
149700000
155000000
161050000
170000000
175000000
180000000 | 0.02777777777777778
185000000
187125000
190000000
192000000
198400000 | 0.08064516129032258
210000000
210000000
220000000
227500000
245000000
250000000 | 0.29947412
260000000
265000000
270000000
280000000
282500000
310000000
320000000
320000000
365000000
380000000
414000000 | 0.05314009661835749
461600000
487000000
520000000
550000000
612500000
640000000
685000000
755000000
775000000
890000000
975000000
1500000000
1800000000
2250000000 | 0.1333333333333333
2500000000
Spreadsheet: 149975d1334233324-two-graphs-in-one-chart-but-with-different-number-of-values-example
Sheet: Ark1

 | Time | First graph | Second graph
 | 10:00:00 | 5
 | 10:05:00 | 3
 | 10:10:00 | 1
 | 10:15:00 | 4 | 13
 | 10:20:00 | 7
 | 10:25:00 | 7
 | 10:30:00 | 2 | 14
 | 10:35:00 | 3
 | 10:40:00 | 5 | 12
 | 10:45:00 | 4
 | 10:50:00 | 9
 | 10:55:00 | 7
 | 11:00:00 | 6 | 17
Spreadsheet: 886886d1736981295-need-to-search-for-multiple-items-in-a-cell-separated-by-commas-from-another-sheet-multi-lookoup-and-return-test
Sheet: Cases

CaseId | OutletActivityId | CaseClients | Client names in Case
03HA000H2 |  | 03HC000NS
03HA000HP |  | 03HC000QF
03HA000HQ |  | 03HC000ZP
03HA000HR |  | 03HC000ZJ
03HA000HV |  | 03HC000NV
03HA000HZ |  | 03HC000ZK
03HA000J7 |  | 03HC000ZS
03HA000JP |  | 03HC000Z6
03HA000KN |  | 03HC000VB
03HA000KP |  | 03HC000PQ
03HA000MF |  | 03HC00232
03HA000MG |  | 03HC00233
03HA000MH |  | 03HC00236
03HA000MJ |  | 03HC00235
03HA000NR |  | 03HC0023B
03HA000NS |  | 03HC0023D
03HA000PL |  | 03HC0005N,03HC000CQ,03HC000GR,03HC000JV,03HC000QJ,03HC000S9,03HC0024J,03HC0024Q,03HC0028G
03HA000PN |  | 03HC00238
03HA000PP |  | 03HC0027M
03HA000QF |  | 03HC0027L
03HA000SM |  | 03HC00242
03HA000SN |  | 03HC000Z4
03HA000SZ |  | 03HC002DR
03HA000T1 |  | 03HC000NZ
03HA000T6 |  | 03HC000QF,03HC000Z6,03HC000ZJ,03HC000ZK,03HC000ZP
03HA000VX |  | 03HC002HC
03HA000WL |  | 03HC000ZT
03HA000WT |  | 03HC002J1
03HA000WV |  | 03HC002J2
03HA000ZP |  | 03HC000ZQ
03HA0022P |  | 03HC002J3
03HA0022Q |  | 03HC000NS,03HC000ZQ,03HC000ZS
03HA0022R |  | 03HC00099
Spreadsheet: 81988d1282069389-only-one-entry-per-month-in-pivot-table-performance-new
Sheet: F

Incident | Date | ID | Cause | Delay Code | Manager | Comm | Incident Location | Cost | Delays
179419 | 2010-07-26 00:00:00 | 0N31 | LATE START NBLYGBF | T | FPEF | F |  | 1213.92 | 36
188250 | 2010-07-30 00:00:00 | 4R51 | 23 BREAKDOWN EGBRGBF | T | APEF | F |  | 101.16 | 3
185853 | 2010-07-29 00:00:00 | 4R51 | WTG ACC KNTNGEJ-SHFTHLJ | T | APEF | F | KNOTTINGLEY EAST JN | 640.68 | 19
183757 | 2010-07-28 00:00:00 | 6C31 | STOPPED SHORT DON | C | FPEF | F | DONCASTER | 539.52 | 16
204357 | 2010-08-06 00:00:00 | 6S45 | 3 LOST MRPTNJN WNGTJN | S | FPEF | F | MORPETH | 134.88 | 4
179354 | 2010-07-26 00:00:00 | 6S45 | TRAFFIC NBLYGBF | T | APEF | F | NORTH BLYTH ALCAN | 3001.08 | 89
Spreadsheet: 169458d1342866362-problem-with-if-or-within-my-time-sheet-or-perhaps-its-just-too-early-june-wages
Sheet: December

DAY | IN | OUT | Tot | OT | [NAME] |  |  | Sat | Sun
2012-12-01 00:00:00
2012-12-02 00:00:00
2012-12-03 00:00:00
2012-12-04 00:00:00
2012-12-05 00:00:00
2012-12-06 00:00:00
2012-12-07 00:00:00
2012-12-08 00:00:00
2012-12-09 00:00:00
2012-12-10 00:00:00
2012-12-11 00:00:00
2012-12-12 00:00:00
2012-12-13 00:00:00
2012-12-14 00:00:00
2012-12-15 00:00:00
2012-12-16 00:00:00
2012-12-17 00:00:00
2012-12-18 00:00:00
2012-12-19 00:00:00
2012-12-20 00:00:00
2012-12-21 00:00:00
2012-12-22 00:00:00
2012-12-23 00:00:00
2012-12-24 00:00:00
2012-12-25 00:00:00
2012-12-26 00:00:00
2012-12-27 00:00:00
2012-12-28 00:00:00
2012-12-29 00:00:00
2012-12-30 00:00:00
2012-12-31 00:00:00
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 15

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
5-2- مانده حساب مشارکتها به شرح زيرتفکيک می شود:
شـــــــرح |  | 1390/03/31-ريال |  |  |  | 1389/09/30
 |  | بهای تمام شده دارائیهای ثابت | استهلاک انباشته | ارزش دفتری دارائیهای ثابت | وديعه تلفن | طلب | بدهی
 |  |  |  |  |  | ریال | ریال
[NAME]  بين [NAME] |  | 86129800 | -43422427 | 42707373 | 0 | 1551243893 | 0
مشارکت لوله های بدون درز |  | 237884563 | 0 | 237884563 | 1855000 | 239739563 | 0
مشارکت [NAME] |  | 1095491800 | -824342138 | 271149662 | 0 | 0 | 1873955013
مشارکت مترو |  | 14416667 | -9025882 | 5390785 | 2020000 | 0 | 286450583
مشارکت دانشگاه صنعتی اميرکبير |  | 111162300 | -91826098 | 19336202 | 8280000 | 785350361 | 0
[NAME]
 | چگونگی ارزيابی وانعکاس مشارکتها درصورتهای مالی دريادداشت شماره 8-3خلاصه اهم رويه های حسابداری توصيف شده است .
 | شرکت درسنوات گذشته به منظوراجرای پروژه های فوق اقدام به انعقاد قرارداد مشارکت با اشخاص [NAME] وحقوقی [NAME] ای مسائل قراردادهای مذکورعمدتاً درسنوات
 | 1379و1380متوقف گردیده مفتوح بودن پرونده اينگونه قراردادها درمراجع قضايی تسويه حساب با طرفهای قرارداد منوط به صدوررای قطعی ازسوی مراجع يادشده ميباشد.
 | حسابهای تعدادی ازقراردادهای مشارکت براساس [NAME] نامه های منعقده بين طرفين مشخص واثرات ريالی آنها درحسابهای شرکت منعکس [NAME] [NAME].
 | تعدادی ازقراردادهای مشارکت به [NAME] توافق نهايی با طرفهای شريک تا کنون نهائی نگرديده ومترصد تعيين تکليف ازطريق مراجع قضائی ميباشد.
Spreadsheet: 810049d1671511899-find-student-id-and-fill-coressponding-data-in-rows-results
Sheet: LABs

[NAME] | LAB01 | LAB02 | LAB03 | LAB04 | LAB05 | LAB06 | [NAME]
1 | 6 | 7 |  | 2 | 4 | 7 | 8
2 | 4 | 9 | 8 | 2 | 9 | 3 | 5
3 | 8 | 8 | 7 | 5 | 7 | 8 | 5
4 | 6 | 7 |  | 2 | 4 | 7 | 8
5 | 4 | 9 | 8 | 2 | 9 | 3 | 5
6 | 8 | 8 | 7 | 5 | 7 | 8 | 5
7 | 6 | 7 |  | 2 | 4 | 7 | 8
8 | 4 | 9 | 8 | 2 | 9 | 3 | 5
9 | 8 | 8 | 7 | 5 | 7 | 8 | 5
10 | 6 | 7 |  | 2 | 4 | 7 | 8
11 | 4 | 9 | 8 | 2 | 9 | 3 | 5
12 | 8 | 8 | 7 | 5 | 7 | 8 | 5
13 | 6 | 7 |  | 2 | 4 | 7 | 8 |  |  |  | Find ID Numbers from this sheet
14 | 4 | 9 | 8 | 2 | 9 | 3 | 5
15 | 8 | 8 | 7 | 5 | 7 | 8 | 5
16 | 6 | 7 |  | 2 | 4 | 7 | 8
17 | 4 | 9 | 8 | 2 | 9 | 3 | 5
18 | 8 | 8 | 7 | 5 | 7 | 8 | 5
19 | 6 | 7 |  | 2 | 4 | 7 | 8
20 | 4 | 9 | 8 | 2 | 9 | 3 | 5
21 | 8 | 8 | 7 | 5 | 7 | 8 | 5
22 | 4 | 9 | 8 | 2 | 9 | 3 | 5
23 | 8 | 8 | 7 | 5 | 7 | 8 | 5
24 | 6 | 7 |  | 2 | 4 | 7 | 8
25 | 4 | 9 | 8 | 2 | 9 | 3 | 5
26 | 8 | 8 | 7 | 5 | 7 | 8 | 5
27 | 6 | 7 |  | 2 | 4 | 7 | 8
28 | 4 | 9 | 8 | 2 | 9 | 3 | 5
29 | 8 | 8 | 7 | 5 | 7 | 8 | 5
30 | 4 | 9 | 8 | 2 | 9 | 3 | 5
31 | 8 | 8 | 7 | 5 | 7 | 8 | 5
32 | 6 | 7 |  | 2 | 4 | 7 | 8
33 | 4 | 9 | 8 | 2 | 9 | 3 | 5
Spreadsheet: 725857d1616931532-need-help-to-simplify-the-formula-eosb-computation
Sheet: EOSB Computation 

 | Nature of Leaving | Basic Salary | Joining Date | Leaving Date | Years of Service | Calculated EOSB
 | Termination | 5000 | 2012-11-01 00:00:00
Row # | Nature of Leaving | Year of Service | Entitlement
A9 | Termination | upto 1 Year | No end of service benefits
A10 | Termination | 1 to 5 Years | 21 days of salary for every completed years of service
A11 | Termination | 5 years and above | 31 days of salary for every completed years of service
A12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resignation
A13 | Resignation | upto 1 Year | No end of service benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termination
A14 | Resignation | 1 to 3 Years | One third of total entitlement computed as per above slabs ([NAME] and A11)
A15 | Resignation | 3 to 5 Years | Two third of total entitlement computed as per above slabs (Rows 9,10 and 11)
A16 | Resignation | 5 years and above | Full entitlement as per the computation done in accordance with above slabs ([NAME] and A11)
Spreadsheet: 464839d1465336373-list-unique-values-unique-records
Sheet: Sheet1

ID | Date | Report |  | [NAME]
743 | 2016-04-15 00:00:00 | 47
752 | 2016-04-30 00:00:00 | 48
159 | 2016-05-03 00:00:00 | 49
987 | 2016-05-04 00:00:00 | 50
743 | 2016-05-05 00:00:00 | 51
752 | 2016-05-06 00:00:00 | 52 |  | =IFERROR(INDEX(Sheet1!$A$2:$A$29,MATCH(1,INDEX((COUNTIF($A$1:E1,Sheet1!$A$2:$A$29)=0)*(Sheet1!$A$2:$A$29<>""),0),0)),"")
159 | 2016-05-07 00:00:00 | 53
987 | 2016-05-08 00:00:00 | 54
743 | 2016-05-09 00:00:00 | 55
752 | 2016-05-10 00:00:00 | 56
159 | 2016-05-11 00:00:00 | 57
987 | 2016-05-12 00:00:00 | 58
743 | 2016-05-13 00:00:00 | 59
752 | 2016-05-14 00:00:00 | 60
159 | 2016-05-15 00:00:00 | 61
987 | 2016-05-16 00:00:00 | 62
743 | 2016-05-17 00:00:00 | 63
752 | 2016-05-18 00:00:00 | 64
159 | 2016-05-19 00:00:00 | 65
987 | 2016-05-20 00:00:00 | 66
743 | 2016-05-21 00:00:00 | 67
752 | 2016-06-01 00:00:00 | 68
159 | 2016-06-02 00:00:00 | 69
987 | 2016-06-03 00:00:00 | 70
743 | 2016-06-04 00:00:00 | 71
752 | 2016-06-05 00:00:00 | 72
159 | 2016-06-06 00:00:00 | 73
987 | 2016-06-07 00:00:00 | 74
Spreadsheet: 34957d1232419865-countif-to-find-total-sales-salesexample
Sheet: Sales

DATE | CUSTOMER | AMOUNT | Scent
2006-07-05 00:00:00 | [NAME] | 10 | [NAME]
2006-07-05 00:00:00 | [NAME] | 10 | [NAME]
2006-11-03 00:00:00 | [NAME] | 10 | [NAME]
2006-11-03 00:00:00 | Davidovitch | 10 | [NAME]
2006-11-07 00:00:00 | Mathieson | 10 | [NAME]
2006-11-07 00:00:00 | Brandenburg | 10 | [NAME]
2006-11-11 00:00:00 | [NAME] | 10 | [NAME]
2006-11-11 00:00:00 | Tingey | 10 | [NAME]
2006-11-16 00:00:00 | Santiago | 10 | [NAME]
2006-11-16 00:00:00 | [NAME] | 10 | [NAME]
2006-11-27 00:00:00 | Leser | 10 | Honeysuckle
2006-11-27 00:00:00 | Leser | 10 | [NAME]
2006-11-27 00:00:00 | Crews | 10 | Plumeria
2006-11-29 00:00:00 | Tingey | 10 | [NAME]
2006-11-29 00:00:00 | [NAME] | 10 | [NAME]
2006-12-01 00:00:00 | Snyder | 10 | [NAME]
2006-12-01 00:00:00 | Grant | 10 | [NAME]
2006-12-01 00:00:00 | Vadney | 10 | Maple Walnut
2006-12-04 00:00:00 | Davidovitch | 100 | [NAME]
2006-12-04 00:00:00 | [NAME] | 10 | [NAME]
2006-12-04 00:00:00 | Cox | 10 | Maple Walnut
2006-12-04 00:00:00 | Mills | 10 | [NAME]
2006-12-06 00:00:00 | Crews | 50 | Plumeria
Spreadsheet: 883181d1731679860-calculate-average-mileage-average-mileage-sample
Sheet: Sheet1

 |  | Average mileage | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | Driver A | 1519 | 1851 | 3496 | 4791 | 6029 | 7772 | 8738 | 9703 | 11645 | 12886 | 14000 | 16165 | 18082 | 19221 | 20771 | 22686 | 24313
 | Driver B | 713 | N/A | N/A | N/A | N/A | N/A | N/A | 1331 | 2383 | 2655 | 3841 | 4389 | 4987 | 5369 | 5817 | 6389 | 7134
 | Driver C | 735 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 689 | 1247 | 2011 | 2753 | 3678