tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139033d1328042768-conditional-formatting-based-on-a-date-from-another-cell-sample
Sheet: Sheet1

 |  |  |  |  |  | Month --> | January |  |  |  | February
 |  |  |  |  |  | Week --> | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4
Project | Assigned | Start Date | Due Date | Last Update | Duration | Status
English Script for Admin Error | TBD | 2012-01-01 00:00:00 | 2012-02-03 00:00:00
 | TBD
Spreadsheet: 886130d1736167942-sorting-data-from-a-dynamic-list-sorting-data-from-a-dynamic-list
Sheet: Stop List

 | STOP NUMBER |  | BUS STOP NAME | ON STREET / ROAD | POINT LETTER | ROUTES | Closure Type
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
Spreadsheet: 843823d1695660524-blood-pressure-chart-help-please-
Sheet: Sheet1

 | מספר ימים מוצגים |  | 7
 | שבוע הבדיקות |  | 2023-09-18 00:00:00
תאריך בדיקה | בוקר |  | צהריים |  | ערב |  |  |  |  |  |  |  | תאריך בדיקה | בוקר |  | צהריים |  | ערב
 | Sys | [NAME] | Sys | [NAME] | Sys | [NAME] |  |  |  |  |  |  |  | Sys | [NAME] | Sys | [NAME] | Sys | [NAME]
2023-09-18 00:00:00 | 129 | 79 | 133 | 76 | 126 | 76 |  |  |  |  |  |  |  | 129 | 79 | 133 | 76 | 126 | 76
2023-09-19 00:00:00 | 128 | 73 | 117 | 74 | 128 | 71 |  |  |  |  |  |  | 2023-09-19 00:00:00 | 128 | 73 | 117 | 74 | 128 | 71
2023-09-20 00:00:00 | 128 | 76 | 118 | 71 | 109 | 70 |  |  |  |  |  |  | 2023-09-20 00:00:00 | 128 | 76 | 118 | 71 | 109 | 70
2023-09-21 00:00:00 | 124 | 72 | 123 | 75 | 124 | 73 |  |  |  |  |  |  | 2023-09-21 00:00:00 | 124 | 72 | 123 | 75 | 124 | 73
2023-09-22 00:00:00 | - | - | - | - | - | - |  |  |  |  |  |  | 2023-09-22 00:00:00 | - | - | - | - | - | -
2023-09-23 00:00:00 | - | - | - | - | 117 | 70 |  |  |  |  |  |  | 2023-09-23 00:00:00 | - | - | - | - | 117 | 70
2023-09-24 00:00:00 | - | - | 122 | 73 | 130 | 78 |  |  |  |  |  |  | 2023-09-24 00:00:00 | - | - | 122 | 73 | 130 | 78
2023-09-25 00:00:00 | - | - | 127 | 75
2023-09-26 00:00:00
2023-09-27 00:00:00
2023-09-28 00:00:00
2023-09-29 00:00:00
2023-09-30 00:00:00
2023-10-01 00:00:00
2023-10-02 00:00:00
2023-10-03 00:00:00
2023-10-04 00:00:00
2023-10-05 00:00:00
2023-10-06 00:00:00
2023-10-07 00:00:00
2023-10-08 00:00:00
2023-10-09 00:00:00
2023-10-10 00:00:00
2023-10-11 00:00:00
2023-10-12 00:00:00
2023-10-13 00:00:00
2023-10-14 00:00:00
2023-10-15 00:00:00
2023-10-16 00:00:00
2023-10-17 00:00:00
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00
2023-10-22 00:00:00
2023-10-23 00:00:00
2023-10-24 00:00:00
2023-10-25 00:00:00
2023-10-26 00:00:00
2023-10-27 00:00:00
2023-10-28 00:00:00
2023-10-29 00:00:00
2023-10-30 00:00:00
2023-10-31 00:00:00
2023-11-01 00:00:00
2023-11-02 00:00:00
Spreadsheet: 873181d1719606430-how-can-i-edit-the-formula-not-the-name-of-a-named-formula-continuation-sheet-excelhelpforum
Sheet: Continuation Sheet

 | Project Name | CONTINUATION SHEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw Number: | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Report Date: | 2020-05-02 00:00:00
 | Phase | Current Budget | % Complete | Previous Work Complete | Draw 1 | Draw 2 | Draw 3 | Draw 4 | Draw 5 | Draw 6 | Draw 7 | Draw 8 | Draw 9 | Draw 10 | Draw 11 | Draw 12 | Draw 13 | Draw 14 | Current Work Complete | Total Work Complete | Balance to Finish |  | check "Previous Work Complete" | check "Current Work Complete" | check "Total Work Complete" | check "Balance to Finish"
 | SOFT COSTS
 | Division 0  Soft Costs
 | 00.028 Fire Safety Planners | 20 |  |  | 1 | 2 | 3 | 4
 | 00.105 Documentation | 1 |  |  | 1
 | 00.205 Permits | 1 |  |  | 1
 | 00.300 xxx | 1 |  |  | 1
 | Division 1      General Conditions
 | HARD COSTS
 | Division 1  General Conditions
 | 01.042 Superintendent | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 01.044 [NAME] | 1 |  |  | 1
 | 01.045 Labourer | 1 |  |  | 1
 | 01.312 Head Office Charges | 1 |  |  | 1
 | 01.364 Builder's Risk Insurance | 1 |  |  | 1
 | 01.511 Temporary Power | 1 |  |  | 1
 | 01.512 Temporary Lighting | 1 |  |  | 1
 | 01.513 Temporary Heat | 1 |  |  | 1
 | 01.514 Temporary Telephone | 1 |  |  | 1
 | 01.517 Temporary Sanitary Facilities | 1 |  |  | 1
 | 01.526 Hoisting | 1 |  |  | 1
 | 01.527 [NAME]. Scaffold | 1 |  |  | 1
 | 01.529 First Aid Supplies | 1 |  |  | 1
 | 01.562 Containers/Waste Removal | 1 |  |  | 1
 | 01.601 Small Tools | 1 |  |  | 1
 | 01.602 Sundry Supplies | 1 |  |  | 1
 | 01.610 Cartage & Courier | 1 |  |  | 1
 | 01.742 Progress Cleaning | 1 |  |  | 1
 | 01.746 Final Cleaning | 1 |  |  | 1
 | 01.770 [NAME] | 1 |  |  | 1
 | 01.780 Project Record Documents | 1 |  |  | 1
 | Division 1      General Conditions
 | PROJECT TOTALS
 | [NAME] | Vendor #1
 |  | Vendor #2
 |  | Vendor #3
 |  | Job cost amount of invoices
 |  | Holdback totals
Spreadsheet: 751570d1634189379-nested-if-with-multiple-criteria-if_to_check_due_how_many_days
Sheet: Alternative_add_helper_column

 |  |  |  |  | DUE |  | OVERDUE
 |  | Date | Actual Date | Target (7 days) | Due? | Due how many days? | Overdue? | Overdue how many days?
 |  | 2021-01-01 00:00:00 | 2021-01-05 00:00:00
 |  | 2021-02-01 00:00:00 | 2021-02-10 00:00:00
 |  | 2021-03-01 00:00:00
Spreadsheet: 217641d1362138654-hlookup-and-average-formula-book5
Sheet: Cdata

sys_RespNum | Importance_Brand | Importance_HeadsetDesign | Importance_ConnectiontoGamingConsole | Importance_Compatibility | Importance_Sound | Importance_Microphone | Importance_EqualizerApp | Importance_BeatEnhancingTechnology | Importance_VoiceMorphing | Importance_SideTone | Importance_GameandChatSoundMixer | Importance_USBChargingCable | Importance_StorageDevice | Importance_Price
4 | 4.30821 | 2.86889 | 0 | 7.00788 | 13.13755 | 0 | 1.67609 | 0.99327 | 1.11584 | 0.22838 | 1.73117 | 2.453 | 5.57336 | 58.90635
6 | 4.56197 | 7.9652 | 13.29123 | 25.77373 | 19.71363 | 8.11687 | 3.08855 | 1.86788 | 0 | 0.33391 | 0 | 0 | 5.89806 | 9.38898
7 | 6.16854 | 9.51489 | 0 | 1.01916 | 7.3981 | 4.33602 | 2.00931 | 6.82484 | 0.19241 | 0 | 0 | 9.89449 | 5.09157 | 47.55067
11 | 10.35212 | 12.83469 | 5.56201 | 7.58652 | 10.77313 | 5.37327 | 1.35925 | 6.92421 | 2.02841 | 0 | 3.13633 | 0 | 7.39269 | 26.67736
16 | 16.23263 | 7.2875 | 0.24642 | 6.66942 | 20.84484 | 6.43332 | 1.64225 | 7.18801 | 0 | 0 | 0 | 7.01283 | 5.52329 | 20.91948
25 | 2.03858 | 17.97273 | 15.24325 | 1.06662 | 12.91268 | 8.15127 | 4.80601 | 6.02178 | 0 | 0 | 4.68777 | 0 | 3.72388 | 23.37545
27 | 5.65708 | 0 | 16.5816 | 18.39275 | 26.89936 | 0 | 2.41746 | 5.24109 | 0 | 0 | 0 | 4.66815 | 9.50819 | 10.63432
29 | 8.45438 | 4.21667 | 0 | 4.41867 | 2.78342 | 7.85708 | 1.19663 | 1.88786 | 0 | 0 | 0 | 3.82545 | 7.21194 | 58.1479
30 | 11.49345 | 10.1977 | 0.26856 | 10.63716 | 8.80577 | 6.04653 | 6.79371 | 7.87839 | 0 | 0 | 7.53826 | 3.37712 | 6.37684 | 20.58652
35 | 2.29867 | 6.05398 | 16.55399 | 13.4659 | 15.98552 | 7.99232 | 1.56519 | 1.92516 | 0 | 0 | 0 | 0 | 4.65 | 29.50928
36 | 4.74991 | 8.26055 | 5.94376 | 0 | 9.43865 | 7.36489 | 7.27098 | 4.98999 | 0 | 6.95875 | 5.10902 | 0 | 4.65713 | 35.25638
40 | 0.59134 | 12.40032 | 9.8024 | 10.59528 | 18.04847 | 5.85504 | 4.43309 | 5.80936 | 8.86675 | 0 | 0 | 2.92959 | 7.80432 | 12.86404
41 | 8.04199 | 14.9792 | 4.91338 | 4.04556 | 15.2656 | 0 | 6.3348 | 9.09712 | 0 | 0 | 0 | 5.02116 | 4.19041 | 28.11078
Spreadsheet: 37563d1235597144-sum-if-tuition-reimbursed-meets-date-criteria-testtuition-reimbursement
Sheet: Sheet1

Amount to be Reimbursed | Month
750 | 2008-08-01 00:00:00
750 | 2008-04-01 00:00:00
0 | 2008-05-01 00:00:00
0 | 2008-01-01 00:00:00
0 | 2008-04-01 00:00:00
60 | 2008-10-01 00:00:00
50 | 2009-01-09 00:00:00
Total Amount Allotted for quarter: $5000.00
I want to add all the amounts to be reimbursed that were distributed after
the June 2008 and deduct that from the total alloted for both quarters
so:
I would be adding c2+c7+c8= 860
and then deducting it from the $5000.00 to keep a running balance which ='s $4140.00
Spreadsheet: 835436d1688580094-calculate-complete-by-date-based-on-a-schedule-book1-hd
Sheet: Sheet1

Category | Mon | Tue | Wed | Thu | Fri |  | Category | Due Date | Complete by
A | X |  |  |  |  |  | A | 2023-06-08 00:00:00
B |  |  |  |  | X |  | A | 2023-06-12 00:00:00
C |  | X |  | X |  |  | A | 2023-06-13 00:00:00
D | X |  | X |  | X |  | B | 2023-06-06 00:00:00
E | X | X | X | X | X |  | B | 2023-06-09 00:00:00
 |  |  |  |  |  |  | B | 2023-06-12 00:00:00
 |  |  |  |  |  |  | C | 2023-06-05 00:00:00
 |  |  |  |  |  |  | C | 2023-06-06 00:00:00
 |  |  |  |  |  |  | C | 2023-06-11 00:00:00
 |  |  |  |  |  |  | D | 2023-06-12 00:00:00
 |  |  |  |  |  |  | D | 2023-06-13 00:00:00
 |  |  |  |  |  |  | D | 2023-06-14 00:00:00
 |  |  |  |  |  |  | E | 2023-06-08 00:00:00
 |  |  |  |  |  |  | E | 2023-06-09 00:00:00
 |  |  |  |  |  |  | E | 2023-06-10 00:00:00
Spreadsheet: 472451d1469604973-formula-vlookup-to-calculate-running-total-of-master-inventory-sheet-jgarcia79-final-inventory-2
Sheet: Items Issued

Name | Department | Item | QTY | Issue Date | Event | Charge Code |  | Stock Held
[NAME] | CE | Promo: Bag Green, Black, Mesh | 1
 |  | Displays: Tablecloth-Skins 6' | 2
Spreadsheet: 810073d1671532690-compare-for-max-for-duplicate-samplefile-1
Sheet: Sheet3

Name | Class | Benefit | Age From | Age To | Gender | [NAME] | Relation | Net | H1 | H2 | H3 | Gross | H4
Std R3 | Class VIP+ Z4 |  | 36 | 40 | Female | Married | Spouse | 14 |  |  |  | 14
Std R3 | Class VIP Z4 |  | 36 | 40 | Female | Married | Spouse | 78 |  |  |  | 78
Std R3 | Class A+ Z4 |  | 36 | 40 | Female | Married | Spouse | 63 |  |  |  | 63
Std R3 | Class A - Z4 |  | 36 | 40 | Female | Married | Spouse | 60 |  |  |  | 60
Std R3 | Class [NAME] |  | 36 | 40 | Female | Married | Spouse | 78 |  |  |  | 78 |  | Higher Than ClassClass A - Z4
Std R3 | Class B - Z4 |  | 36 | 40 | Female | Married | Spouse | 47 |  |  |  | 47
Std R3 | Class C+ Z4 |  | 36 | 40 | Female | Married | Spouse | 29 |  |  |  | 29
Std R3 | Class CC Z4 |  | 36 | 40 | Female | Married | Spouse | 30 |  |  |  | 30 |  | Higher Than ClassClass C+ Z4
Std R3 | Class C-Ref Z4 |  | 36 | 40 | Female | Married | Spouse | 28 |  |  |  | 28
Spreadsheet: 853071d1703021731-count-lines-in-a-cell-and-in-an-column-using-scan-function-using-scan-function
Sheet: Planilha1

A | 100 200 300 400 500 600 700 800
B | 300 400 500 600 |  |  |  |  | 4;710 730 740 |  |  |  |  |  |  |  | 0;8;4
C | 710 730 740 |  |  |  |  | 3;250 |  |  |  |  |  |  |  | 0;8;4;3
D | 250 |  |  |  |  | 1; |  |  |  |  |  |  |  | 0;8;4;3;1
E |  |  |  |  |  | 1;231 232 |  |  |  |  |  |  |  | 0;8;4;3;1;1
F | 231 232 |  |  |  |  | 2;233 234 |  |  |  |  |  |  |  | 0;8;4;3;1;1;2
G | 233 234 |  |  |  |  | 2;511 520 611 620 |  |  |  |  |  |  |  | 0;8;4;3;1;1;2;2
H | 511 520 611 620 |  |  |  |  | 4;334 344 |  |  |  |  |  |  |  | 0;8;4;3;1;1;2;2;4
I | 334 344 |  |  |  |  | 2;321 |  |  |  |  |  |  |  | 0;8;4;3;1;1;2;2;4;2
J | 321 |  |  |  |  | 1; |  |  |  |  |  |  |  | 0;8;4;3;1;1;2;2;4;2;1
Spreadsheet: 60550d1261067078-payroll-taxes-example-docpay-05-09
Sheet: PENSION

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Current | LIMIT
 | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 | 2009-08-09 00:00:00 | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | 2009-12-09 00:00:00 | YTD TOTAL | Payroll | 41137
SMITH | 6275.918164231873 | 4920.881108277023 | 5100.287563500688 | 6524.290350450144 |  |  |  |  |  |  |  |  | 22821.37718645973 | 4712.315104992414 |  | 13603.30770854786
Spreadsheet: adb8cd25-bc61-4f07-ac02-4081f3025299
Sheet: U13 BD

 |  |  |  | BE CORNWALL SILVER U13
 |  |  |  |  | BOYS DOUBLES 2011
 |  | GROUP MATCHES   Best of 3 games to 15
 |  |  |  |  |  |  |  | Games
 |  | GROUP A |  | 1 | 2 | 3 | 4 | Won | Points
 | 1 | M Bennetts/L Mills | Co/Co |  | 3.7. | 8.5. | 5.8. | 0 | 36
 | 2 | T/Sillifant/L Skinner | Co/Dv | 15.15. |  | 15.15. | 15.15. | 6 | 90 |  |  | SILLIFANT-SKINNER
 | 3 | O Cavill/Mpearson | Co/Co | 15.15. | 12.7. |  | 15.14. | 2 | 78 |  |  | FINAL
 | 4 | T Reddaway/T Foote | So/Co | 15.15. | 8.10. | 17.16. |  | 4 | 81
 |  |  |  |  |  |  |  |  |  |  |  |  | SEAH-CHEUNG 15.11. 15.13.
 |  |  |  |  |  |  |  |  | Games |  |  |  | WINNER
 |  | GROUP B |  | 1 | 2 | 3 | 4 | 5 | Won | Points
 | 1 | L Sillifant/W Freer | Co/Co |  | 8.7. | 8.6. | 15.15. | 15.8.15. | 4 | 97
 | 2 | T Seah/ C Cheung | Dv/Dv | 15.15. |  | 15.15. | 15.15. | 15.15. | 6 | 120
 | 3 | T Cooper/J Cole | Dv/Dv | 15.15. | 11.6. |  | 15.15. | 15.15. | 6 | 107 |  | FINAL
 | 4 | R Johnson/ J Lush | Co/Co | 9.6. | 4.2. | 5.6. |  | 4.4. | 0 | 40 |  | SEAH-CHEUNG
 | 5 | X Swallow/E Dyer | Co/Co | 12.15.17. | 10.7. | 9.12. | 15.15. |  | 4 | 112
Spreadsheet: 36325d1234212874-if-with-vlookup-muster-test
Sheet: Sheet1

Muster | Cabin No. |  |  |  | Last Name | First Name | Shift | Position | Team? | Nationality
PORT | 715 | A | G | q | Cruzvergara | [NAME] | Midnight-Noon | DPO | Fire | USA
PORT | 715 | B | G | q | Meader | [NAME] | Midnight-Noon | DPO | Fire | USA
PORT | 717 | A | G | q | Jennings | Bethany | 6AM-6PM | Chief Mate | Fire | USA
PORT | 603 | A | G | q | Hixon | [NAME] | Sat | SAT Diver | HRC | USA
PORT | 603 | B | G | q | Dikes | Braxton | Midnight-Noon | Dive Supervisor | HRC | USA
PORT | 605 | A | G | q | Hinds | [NAME] | Sat | SAT Diver | HRC | USA
PORT | 605 | B | G | q | Groseclose | Todd | Noon-Midnight | Dive Supervisor | HRC | USA
PORT | 606 | A | G | q | [NAME] | [NAME] | 6AM-6PM | Dive Superintendent | HRC | USA
STBD | 605 | A | G | q | Komuda | Arek | Midnight-Noon | 3rd Engineer | Fire | USA
STBD | 605 | B | G | q | McCollum | Mark | Noon-Midnight | Marine Engineer | Fire | USA
#N/A
Spreadsheet: 852039d1702123177-formula-for-plus-and-minus-specific-values-amt-st-09-12-23
Sheet: 17933690

SRI AMBIKA SOLVEX LIMITED AKOLA
ACCOUNT STATEMENT
From 01-APR-23 To 09-DEC-23
MANDI AMRAVATI
Opening : |  |  |  |  |  |  |  |  |  | 9942972.00 CR
 |  | Date | Document No | Mode | Particular | Cheq.No. | Debit |  |  | Credit | Balance
 |  | 2023-04-05 00:00:00 | 165 | BP | [NAME] To Party Against Purchase Of Soya Seed M/S Nandkishor Nathuji Kakde | RTGS | 224865 | 224865 | 165 | 0 | 9718107 | CR
 |  | 2023-04-06 00:00:00 | 31 | BP | Being [NAME] No.576370 Issue To Party Against Purchase Of Soya Seed M/S Nilesh Mukandrao Deshmukh | 576370 | 29177 | 128966 | 31 | 0 | 9589141 | CR
 |  | 2023-04-06 00:00:00 | 31 | BP | Being Chaque No.576363 Issue To Party Against Purchase Of Soya Seed M/S Jai Salasar Traders | 576363 | 64978 |  | 31 | 566 | 9589141 | CR
 |  | 2023-04-06 00:00:00 | 31 | BP | Being Chaque No.576367 Issue To Party Against Purchase Of Soya Seed M/S Khanteshwari Traders | 576367 | 34811 |  | 31 | 452 | 9589141 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576419 Issue To Party Against Purchase Of Soya Seed M/S Jai Shivalay Traders | 576419 | 328877 | 906236 | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576376 Issue To Party Against Purchase Of Soya Seed M/S Rahul Traders | 576376 | 125858 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being [NAME] To Party Against Purchase Of Soya Seed M/S Khanteshwari Traders | 576373 | 94631 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576418 Issue To Party Against Purchase Of Soya Seed M/S Manthan Traders | 576418 | 60798 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576374 Issue To Party Against Purchase Of Soya Seed M/S Jayshri Traders | 576374 | 296072 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-07 00:00:00 | 166 | BP | Being Cheque No. 576364 Issue To Party Aginst Purchase Of Soya Seed M/S Rajesh Mahadeoprasad Agarwal | 576364 | 114852 | 114852 | 166 | 0 | 8568053 | CR
 |  | 2023-04-10 00:00:00 | 44 | BP | [NAME] To Party Aginst Purchase Of Soya Seed M/S Tushar Suresh Karale | RTGS | 433590 | 815133 | 44 | 0 | 7752920 | CR
Spreadsheet: 81593d1281711718-vacation-and-sick-tracking-vacation-sick
Sheet: Sheet1

 |  |  |  |  | Hrs
 | Full Years of Service | 1 |  | Sick Time Earned | 35
 | Vac. Carry over (hrs) | 24 |  | Sick Time Used | 8
 | Sick Time Remaining | 27 |  | Vac. Time Earned | 94
 | Vacation Time Remaining | 86 |  | Vac. Time Used | 8
Date | S/V | Time Taken (hrs)
2010-01-12 00:00:00 | S | 8
2010-04-12 00:00:00 | V | 8
Spreadsheet: 482698d1475188660-is-it-possible-to-have-two-search-functions-in-one-sheet-with-conditional-formatting-excelforum-2-
Sheet: Sheet1

 |  | Search1: |  |  | Search2: | bccc
AAAB | AABB | ABBB | BBBB | BBBC | BBCC | BCCC | CCCC | CCCD | CCDD
BBBC | AAAB | AABB | ABBB | BBBB | BBBC | BBCC | BCCC | CCCC | CCCD
[NAME] | DDDE | AAAB | AABB | ABBB | BBBB | BBBC | BBCC | BCCC | CCCC
DDEE | CCCC | ABBB | AAAB | AABB | ABBB | BBBB | BBBC | BBCC | BCCC
Spreadsheet: jeff_dasovich__14062__PEP_OAT_KO financials and ratios
Sheet: Coke Ratios

 |  |  | COKE RATIO ANALYSIS
ROE
Leverage
ROA
Asset Turn
Net Margin
Total Debt/Equity
Growth
Sales
EBIT
Net income
Spreadsheet: 158876d1338420319-lookup-in-split-ranges-as-in-one-copy2-copy
Sheet: Sheet1

Code | Category 1 |  |  |  | Category 2 |  |  |  |  |  |  |  | RANK
 | ProductA | ProductB | ProductC | TOTAL | ProductD | ProductE | ProductG | ProductH | TOTAL | etc. |  |  | HLOOKUP
123 | 10 | 40 | 20 |  | 5 | 15 | 25 | 30
456 | 432 | 4 | 45 | 54353 | 435 | 23 | 123 | 5 | 3432342
789 | 134 | 34 | 600 |  | 11 | 345 | 678 | 454
etc. |  |  |  |  |  |  |  |  |  |  |  | Need to:
 |  |  |  |  |  |  |  |  |  |  |  | 1. [NAME] that would: based on a Code return Top X value of a product EXCLUDING totals
 |  |  |  |  |  |  |  |  |  |  |  | 2. [NAME] that would: based on a Code return Top X name of a product EXCLUDING totals
 |  |  |  |  |  |  |  |  |  |  |  | Example:
 |  |  |  |  |  |  |  |  |  |  |  | Enter Code: |  | 456 |  | < user inputs any code
 |  |  |  |  |  |  |  |  |  |  |  |  | Top 5 | Value | Name
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | < formulas in O and P
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | return values based on data above to the left
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula needed here
Spreadsheet: 743526d1628577411-formula-s-for-choosing-and-calculating-milage-rates-expenses_sheet_main-_jt
Sheet: February

Employee Business Kilometres & Subsistence Expenses Claim |  |  |  |  |  | Period Ended:
Employee Name: |  |  |  |  | Car Reg
 |  |  |  |  | Engine Size
Home Address:
 |  |  |  |  | Start Odometer Reading
 |  |  |  |  | Current Odometer Reading
Mileage |  |  |  |  |  | Subsistence
 |  |  |  |  |  | <10HR | >10HR | O/N
Date | Reason for Journey |  | To | From | Total | 15.41 | 36.97 | 147
 |  |  |  |  | 100
 |  |  |  |  | 300
 |  |  |  |  | 240
 |  |  |  |  | 160
 |  |  |  |  | 180
 |  |  |  |  | 200
 |  |  |  |  | 245
 |  |  |  |  | 10
 |  | This Month | Last Month | Annual to date
Total Business Kilometres |  |  |  |  | Total
Rate Applicable
Value of Mileage Claim (KM x rate) |  |  |  |  | Total Claim (mileage & subsistence)
Rates per Kilometre are determined by Engine Size
 |  | Distance (KM) | Under 1200cc | 1201 to 1500cc | 1501 and over
 |  | 0 - 1500 | 0.3795 | 0.3986 | 0.4479
 |  | 1501 - 5500 | 0.7 | 0.7321 | 0.8353
 |  | 5501 - 25000 | 0.2755 | 0.2903 | 0.3221
 |  | *Rates change after completing 1500/5500 business kilometres
Signed |  |  |  |  | Date
Approved by |  |  |  |  | Date
Return this form within seven days of month end to accounts department
Spreadsheet: 586881d1534706474-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: GroupB

GROUP B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Turkey
Belarus
Poland
Estonia
ROUND 1 |  |  |  |  |  |  | Table
 |  |  | :
 |  | 71 | : | 50 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  | 86 | : | 48
 |  |  | :
 |  | 68 | : | 87
 |  | 80 | : | 63
ROUND 2
 |  | 54 | : | 64
 |  | 62 | : | 70
 |  | 56 | : | 81
 |  | 73 | : | 53
 |  |  | :
 |  |  | :
ROUND 3
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 4
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
Spreadsheet: 695341d1600161791-filling-cells-with-script-formula-test-excel
Sheet: Full Check works

![NAME] | [NAME] | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | TOPRINT | MEMO |  |  | PO | Entry Date | Total | Vendor
!SPL | SPLID | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | QNTY | MEMO |  |  | EB2000000362 | 09/09/2020 | 258.08 | A Test
!ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB1000124706 | 09/09/2020 | 16 | B Test
TRNS |  | Credit Card |  | Chase |  | Web |  | N | N |  |  |  | EB2000000298 | 09/08/2020 | 317.22 | A Test
SPL |  | Credit Card |  | Cost of Goods Sold |  | Web |  | N | N |  |  |  | EB2000000319 | 09/08/2020 | 16.17 | A Test
ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000329 | 09/08/2020 | 35.08 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000008 | 09/02/2020 | 44.32 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB1000126195 | 08/27/2020 | 299.17 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB1000126195 | 08/27/2020 | 0 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000317 | 09/08/2020 | 12.46 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB1000125937 | 08/26/2020 | 74.41 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000323 | 09/08/2020 | 146.57 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000324 | 09/08/2020 | 108.23 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000332 | 09/08/2020 | 39.52 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000337 | 09/08/2020 | 119.17 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000331 | 09/08/2020 | 576.08 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000326 | 09/08/2020 | 42.55 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000308 | 09/08/2020 | 42.45 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000335 | 09/08/2020 | 102.73 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000318 | 09/08/2020 | 46.96 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000322 | 09/08/2020 | 103.6 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000301 | 09/08/2020 | 40.66 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000344 | 09/09/2020 | 45.47 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000330 | 09/08/2020 | 62.05 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000312 | 09/08/2020 | 168.58 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000300 | 09/08/2020 | 119.17 | A Test
Spreadsheet: abf1e3e3-dcb1-49dd-a5de-0b220a4a5ac5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSCA1 | Test | FSCA1 | [NAME] (SCA) Type 1 | SCA 1 DNA | Polymerase Chain Reaction (PCR)/Fragment Analysis by Capillary Electrophoresis | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | Draw blood in a lavender-top (EDTA) tube(s), and send 20 mL of EDTA whole blood at ambient temperature.  Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed By:  Athena Diagnostics 		        377 Plantation St. 		         Four Biotech Park 		        Worcester, MA  01605 | Monday | 7-14 days | 8-15 days | 1 | 81479 |  |  |  |  | Athena Diagnostics
FSCA1 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FSCA1 | Result | Z0094 | SCA 1 DNA | SCA 1 DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process