tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: Data Reporting 2020

Accident/Incident/Near Miss Totals 2020
First Aid |  |  | Daily Pre Start - Foremen | ✓ OR AWAY | [NAME] or [NAME] | % |  | Weekly Workplace Inspection  - Foremen | ✓ | REMINDED  or ❌ | %
Near Miss |  |  | Dameon |  |  |  |  | Dameon
Lost Time |  |  | [NAME] |  |  |  |  | [NAME]
Damage to Property |  |  | [NAME] |  |  |  |  | [NAME]
Fatality |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | Harley |  |  |  |  | Harley
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | Nathan |  |  |  |  | Nathan
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | Tyson |  |  |  |  | Tyson
 |  |  | Will |  |  |  |  | Will
 |  |  | Daily Pre Start - Contractors | ✓ | [NAME] or [NAME] | % |  | Weekly Workplace Inspection  - Contractors | ✓ | [NAME] or [NAME] | %
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  |  | [NAME]
 |  |  | Fortnightly [NAME] Foremen | ✓ | [NAME] or [NAME] | %
 |  |  | Dameon
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Harley
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Nathan
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Tyson
 |  |  | Will
 |  |  | Fortnightly [NAME] | ✓ | [NAME] or [NAME] | %
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 80186d1280391093-retrieve-values-on-multiple-conditions-packages
Sheet: PACKIGING

Material code | Customer | Type 1 | Type 2 | Type 3 | Type 4 | Type 5 | Type 6 | Type 7 | Type 8 | Type 9 | Type 10
123 | A | 1 | 5 | 8 | 10 | 15 | 100 | 1000 | 2000 | 2500 | 3000
123 | G | 3 | 4 | 8 | 10 | 15 | 100 | 1000 | 2000 | 2500 | 3000
124 | B | 2 | 7 | 8 | 40 | 500 | 1000 | 2000 | 5000 | 6000 | 7000
125 | C | 3 | 7.33333333333333 | 8 | 50 | 500 | 1300 | 2500 | 6000 | 7200 | 7500
126 | D | 3 | 7.33333333333333 | 8 | 50 | 500 | 1300 | 2500 | 6000 | 7200 | 7500
126 | E | 3.6 | 8.53333333333333 | 8 | 68 | 750 | 1840 | 3150 | 7800 | 9310 | 9650
126 | H | 4 | 9.33333333333333 | 8 | 80 | 900 | 2200 | 3600 | 9000 | 10720 | 11000
127 | E | 4.4 | 10.1333333333333 | 8 | 92 | 1039.57142857143 | 2560 | 4050 | 10200 | 12130 | 12350
128 | F | 4.8 | 10.9333333333333 | 8 | 104 | 1200 | 2920 | 4500 | 11400 | 13540 | 13700
129 | G | 5.2 | 11.7333333333333 | 8 | 116 | 1300 | 3280 | 4950 | 12600 | 14950 | 15050
130 | H | 5.6 | 12.5333333333333 | 8 | 128 | 1500 | 3640 | 5400 | 13800 | 16360 | 16400
131 | I | 6 | 13.3333333333333 | 8 | 140 | 1500 | 4000 | 5850 | 15000 | 17770 | 17750
132 | J | 6.4 | 14.1333333333333 | 8 | 152 | 1500 | 4360 | 6300 | 16200 | 19180 | 19100
133 | A | 6.8 | 14.9333333333333 | 8 | 164 | 2000 | 4720 | 6750 | 17400 | 20590 | 20450
134 | B | 7.2 | 15.7333333333333 | 8 | 176 | 2000 | 5080 | 7200 | 18600 | 22000 | 21800
135 | C | 7.6 | 16.5333333333333 | 8 | 188 | 2000 | 5440 | 7650 | 19800 | 23410 | 23150
136 | D | 8 | 17.3333333333333 | 8 | 200 | 2374.91746031746 | 5800 | 8100 | 21000 | 24820 | 24500
137 | E | 8.4 | 18.1333333333333 | 8 | 212 | 2522.64603174604 | 6160 | 8550 | 22200 | 26230 | 25850
138 | F | 8.8 | 18.9333333333333 | 8 | 224 | 2670.37460317461 | 6520 | 9000 | 23400 | 27640 | 27200
139 | G | 9.2 | 19.7333333333333 | 8 | 236 | 2818.10317460318 | 6880 | 9450 | 24600 | 29050 | 28550
140 | H | 9.6 | 20.5333333333333 | 8 | 248 | 2965.83174603175 | 7240 | 9900 | 25800 | 30460 | 29900
141 | I | 10 | 21.3333333333333 | 8 | 260 | 3113.56031746032 | 7600 | 10350 | 27000 | 31870 | 31250
142 | J | 10.4 | 22.1333333333333 | 8 | 272 | 3261.28888888889 | 7960 | 10800 | 28200 | 33280 | 32600
Spreadsheet: 3e0495be-c307-4df7-8b49-b8ca0ae395a8
Sheet: Equity Low Ave

 |  | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | FY 2012 | FY 2013
Referendum Revenue
 | School Districts
 | New Ref Growth
 | SD Fudge District
 | Ref Aid Penalty | 0 | 0 | 119137 | 53967 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 130643.55 | 718858 | 750462 | 0 | 0 | 0
 | TOTAL
 | (excludes underlevies) |  |  | Since underlevy built into model for FY 2009 and 2010,
 |  |  |  | need to subtract out.  (State average before underlevy.)
RMCPU
 | School Districts
 | SD Fudge District
 | TOTAL
REF REV/RMCPU
REF REV/RMCPU - History
 | EOS10 Forecast Estimates | 561.08 | 628.88 | 676.49 | 760.51 | 827.94 | 848.94 | 935.65 | 1037.55
 | EOS09 Forecast Estimates | 561.08 | 628.88 | 676.75 | 760.99 | 822.5 | 942.54 | 1020.77 | 1116.85
 | EOS08 Forecast Estimates | 561.08 | 628.88 | 676.84 | 760.75 | 849.65 | 962.46 | 962.46 | 962.46
 | EOS07 Forecast Estimates | 561.08 | 630.87 | 675.21 | 766.79 | 827.03 | 901.34 | 901.34 | 901.34
Q Comp SD State Average |  |  |  |  | ***** NOT UPDATED *****
Q Comp Revenue
 | SD Q Comp
 | Grandfather |  | 3122304 | 3123755 | 3123755 | 0 | 0 | 0 | 0
 | Total
Q Comp Enrollment
 | School Districts |  | 179923 |  | 245901 | 245901 | 245901 | 245901 | 245901
 | SD Fudge District |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL
QCREV/AMCPU
Spreadsheet: mary_fischer__25605__926
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0926
COMPANY NAME Artemis Associates
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 2465a6fc-dbda-4ff7-98e5-bdebe945ae11
Sheet: All Inclusive CPC Pricing

All Inclusive CPC Pricing (for DHS only)
 |  |  | Standley
 | Category | Speed Band | Model | B/W CPC | Color CPC
 | Category 1 | 10 to 19
 | Category 2 | 20 to 29
 | Category 4 | 40 to 49
 | Category 8 | 80 +
 | Category 10a | 10 to 19 color
 | PLEASE NOTE:
 | 1. The numbers above only reflect the price of base model plus the accessories/features listed under "Required" and those considered required by OKDHS (including IPDS) in the price sheets.  Actual pricing may vary depending upon installed options
Spreadsheet: 85008d1285082761-time-and-a-half-working-a-holiday-toms-time-sheet1
Sheet: Weekly Timesheet2

Name: | [NAME]
Time Period: | 2010-09-06 00:00:00
Department: | Express Pro
Client: | Autoport
Date | Day of Week | Time |  |  |  | [NAME] |  |  |  | Daily Total
 |  | Start Work | Lunch Out | Lunch In | End Work | Straight | Overtime | Sick | Vacation
2010-09-06 00:00:00 | 2010-09-06 00:00:00 | 07:00:00 | 12:00:00 | 12:30:00 | 17:30:00 | 8 | 1.999999999999998 | 0 | 0 | 9.999999999999998
2010-09-07 00:00:00 | 2010-09-07 00:00:00 | 07:00:00 | 12:00:00 | 12:30:00 | 18:30:00 | 8 | 3 | 0 | 0 | 11
2010-09-08 00:00:00 | 2010-09-08 00:00:00 | 07:00:00 | 12:00:00 | 12:30:00 | 18:30:00 | 8 | 3 | 0 | 0 | 11
2010-09-09 00:00:00 | 2010-09-09 00:00:00 | 07:00:00 | 12:00:00 | 12:30:00 | 19:00:00 | 8 | 3.499999999999998 | 0 | 0 | 11.5
2010-09-10 00:00:00 | 2010-09-10 00:00:00 | 07:00:00 | 12:00:00 | 12:30:00 | 19:00:00 | 8 | 3.499999999999998 | 0 | 0 | 11.5
2010-09-11 00:00:00 | 2010-09-11 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0
2010-09-12 00:00:00 | 2010-09-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0
Weekly Totals |  |  |  |  |  | 40 | 14.99999999999999 | 0 | 0 | 54.99999999999999
Spreadsheet: 150288d1334390662-sort-variable-length-column-for-min-value-number-of-rows-is-variable-calcminofgroupings
Sheet: Sheet1

1 | Data
2 | TOT | 0
 | 56
 | 54
 | 48
 | 62
 | 63
8 | TOT | 48
 | 45
 | 64
 | 66
 | 69
 | 55
 | 48
15 | TOT | 45
 | 63
 | 44
 | 55
19 | TOT | 44
Spreadsheet: phillip_allen__28908__version 12_17
Sheet: Proforma

 | One Bedroom Rate | 625
 | Two Bedroom Rate | 575
 | Three Bedroom Rate | 500
 | Four Bedroom Rate | 425
 | CATEGORIES |  |  |  | ONE BEDROOM |  |  |  | TWO BEDROOM |  |  |  | THREE BEDROOM |  |  |  | FOUR BEDROOM |  |  |  | PROJECT TOTAL
 |  |  |  |  | TOTAL | Per Unit | Per SF |  | TOTAL | Per Unit | Per SF |  | TOTAL | Per Unit | Per SF |  | TOTAL | Per Unit | Per SF |  | TOTAL | Per Unit | Per SF
 | Bedrooms/Baths |  |  |  | 1 | 2.5 |  |  | 2 | 2.5 |  |  | 3 | 3.5 |  |  | 4 | 2.5
 | [NAME]. Ft |  |  |  | 500 |  |  |  | 1107
 | Stories |  |  |  | Two Story |  |  |  | Two Story |  |  |  | Two Story |  |  |  | Two Story
 | Unit [NAME] |  |  |  | 15.83 | LF |  |  | 15.83 | LF |  |  | 26 | LF |  |  | 26 | LF
 | Mix - Units |  |  |  | 0 |  |  |  | 72 |  |  |  |  |  |  |  | 0
 | Mix - %
 | INCOME:
 | Rental Income
 | Vacancy Allowance-5% | 0.05 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | Security Deposit Forfeit
 | Internet Use Fees | 30
 | Vending Commissions | 1000 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL INCOME:
 | EXPENSES:
 | Management Fee - 5% Total Income | 0.05
 | Manager's Unit & Office
 | Unit Maintenance | 250/YR/Unit
 | Grounds Maint. | $0.02/sf
 | Cable TV & T-1 | CATV $13+$20 T-1
 | Utilities
 | Advertising/Promotion | 1200/YR
 | Property Taxes
 | Property Insurance
 | Liability Insurance
 | Legal
 | Rental Commissions
 | TOTAL OPERATING EXPENSES:
 | MONTHLY NOI:
 | Replacement Reserve $350/u/y
 | Mortgage: 30Y, 7.5%, 80% Value
 | MONTHLY NET CASH INCOME: | 0.025
 | VALUE @ 10.5% CAP RATE | 0.105
 | LOAN AMOUNTS @ 80%LTV
 | VALUE @ 10% CAP RATE
 | VALUE @ 10.5% CAP RATE
 | VALUE @ 11% CAP RATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation 30 yrs @ cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taxable Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taxable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tax @ 40%
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Income @ 95% Occupancy
Spreadsheet: 679348d1590343461-getting-data-from-multiple-workbooks-to-different-sheets-of-a-workbook-new-workbook
Sheet: Sheet2

Source.Name | Column1 | Column2
B.xlsx | workbook B data | 1
B.xlsx |  | 2
B.xlsx |  | 3
B.xlsx |  | 4
B.xlsx |  | 5
B.xlsx |  | 6
B.xlsx |  | 7
B.xlsx |  | 8
B.xlsx |  | 9
B.xlsx |  | 10
Spreadsheet: 598618d1542628126-most-frequent-word-is-not-working-most-frequent-word
Sheet: Sheet1

a | 0.2
b | 0.1
c | 0.3
d | 0.33
e | 0.35
 |  |  |  |  | it should return "b"
 | In case like this when we have 1 unique word it should take into consideration %. The lowest amount should be return (in this case "b")
 | But, if there would be more than 1 unique, then it should return this result (the most frequent)
case 2 |  |  |  |  |  |  |  |  |  |  |  |  | my needs:
a | 0.2 |  |  |  |  |  |  |  |  |  |  |  | the best result in terms of frequency: |  |  |  | a | (in fact it is "a" and "b" but excel will show first result which is true to conditions
b | 0.1 |  |  |  |  |  |  |  |  |  |  |  | the best result in terms of % |  |  |  | b | (10%+5%+8%) is closer to 0 than (20%, 30%, 25%)
c | 0.3
d | 0.33
e | 0.35
a | 0.3
a | 0.25
b | 0.05
b | 0.08
The best result should be b, because if would sum these percentages, then b% is closer to 0
Spreadsheet: 154216d1336320149-how-to-extract-fist-number-last-number-from-string-and-sum-sum
Sheet: Sheet1

 |  |  |  |  | Result 1 | Result 2 |  | Explain :
List 1 | 12MD5 | 13HG1 | HGF | 2TH | 28 | 6 |  | Result 1 = 12+13+2 --- Sum of Fist character |  |  |  |  | Result 2 = 5+1 --- Sum of Last character
List 2 | 2.5KK | 13KK1 | GH1.5 | GHH | 15.5 | 2.5 |  | Result 1 = 2.5+13--- Sum of Fist character |  |  |  |  | Result 2 = 1+1.5 --- Sum of Last character
List 3 | 12HG1 | HG | 14GH | 1.2HG | 27.2 | 1 |  | Result 1 = 12+14+1.2--- Sum of Fist character |  |  |  |  | Result 2 = 1 Sum of Last character
........
Spreadsheet: 809436d1671092126-combining-if-and-vlookup-functions-scoring-sheet
Sheet: Scoring Standards

< 30 BMI |  |  | >= 30 BMI
Push Up # (2mins) | Score % |  | Push Up # (2mins) | Score %
>=30 | 1 |  | >=13 | 1
29 | 0.96 |  | 12 | 0.95
28 | 0.92 |  | 11 | 0.9
27 | 0.88 |  | 10 | 0.85
26 | 0.84 |  | 9 | 0.8
25 | 0.8 |  | 8 | 0.75
24 | 0.76 |  | 7 | 0.7
23 | 0.72 |  | 6 | 0.65
22 | 0.68 |  | 5 | 0.6
21 | 0.64 |  | 4 | 0.5
20 | 0.6 |  | 3 | 0.4
19 | 0.56 |  | 2 | 0.3
18 | 0.52 |  | 1 | 0.2
17 | 0.48 |  | 0 | 0
16 | 0.44
15 | 0.4
14 | 0.36
13 | 0.32
12 | 0.28
11 | 0.24
10 | 0.2
9 | 0.18
8 | 0.16
7 | 0.14
6 | 0.12
5 | 0.1
4 | 0.08
3 | 0.06
2 | 0.04
1 | 0.02
0 | 0
Spreadsheet: 0f0ad938-56c8-4462-b8bc-8f292ca48fc1
Sheet: Service codes

 |  | SFY 2013 STATE CODE SHEET
SFY 2013 STATE EDRS-UFARS codes crosswalk
UFARS Object Codes to EDRS Service Codes
UFARS OBJECT CODE | EDRS SERVICE CODE | [NAME]
See PTC | A | Payroll Personnel (Salaries Only)
See PTC | B | Contracted Personnel/Agency Services for Pupil
305 | b | Contracted Personnel/Agency Services for Staff
393 | C | Contracted Pupil Placements
366 | F | Staff Travel (ECSE  - Home Based Travel Only) (Requries an Activity Code)
350 | G | Repair and Maintenance
433 | H | Individalized Instructional Supplies and Test Materials
370 | J | Rent or Lease for Direct Services
370 | j | Purchase of Services for Leased Instructional Equipment
556 | P | Equipment for Instruction
399 | p | Purchase of Contracted Services
396 | U | Purchase of Services (Salaried personnel from other districts)
433 | u | Purchase of Instructional Supplies/Material
No Code | V | Non-Resident Pupil Served by One-to-One Pearaprofessional (no expentiture required)
185 | 4 | [NAME] (Can only be used with Personnel Type Code 99) New
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10
11 |  |  |  | 200
12
13
14
15
16
17 |  |  |  | 3000
18 |  |  |  | 3000
19 |  |  |  | 3000
20 |  |  |  | 3000
21 |  |  |  | 3000
22 |  |  |  | 3000
23 |  |  | 5091 | 3000
24 |  |  | 5164 | 3000
25 |  |  | 5850 | 3000
26 |  |  | 5773 | 3000
27 |  |  | 5761 | 3000
28 |  |  | 5738 | 3000
29 |  |  | 5631 | 3000
30 |  |  | 5367 | 3000
31
2001-12-31 00:00:00 |  |  |  |  | 34262
2002-01-30 00:00:00
CBS Volume
 |  |  | 748
Spreadsheet: 824423d1680576123-error-occurred-when-it-comes-to-month-end-rolling-programme-excel-forum-
Sheet: Summary Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00
 | Annual Test 年檢
 | Annual Test  (AT) |  |  |  | 5Y Full-Load (FL)
 | Leave and Holiday Duty 放假及當更
Spreadsheet: 700709d1603297791-if-formula-problems-clin-tracking-base-year-10012020lkf
Sheet: INVOICEDSERVICE

 |  |  |  | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
PR/PO # | VENDOR | DATE | AMOUNT | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER
 |  | Total
 |  | 0.0868
 |  | Total
Spreadsheet: 727945d1618227280-year-to-date-profit-and-loss-excel-formula-year-to-date-profit-and-loss-1-
Sheet: Year to Date

I'm asking for a formula to automate Year to date Profit and Loss. Please note that; Donations, Insurance & Licence, Printing & Stationery, Security ,
and other items with zero amount are excluded from this Year to Date Profit and Loss.
Desired outcome
ZWL |  | YTD
Revenue
 |  | 6200
Other Income
Bus Fares |  | 900
Swimmnig |  | 360
Donations |  | 30
Total Other Income |  | 1290
Expenses |  | 0
Accounting Fees |  | 65
Cleaning |  | 21
Rental - Knight frank |  | 200
[NAME] |  | 60
Electricity |  | 20
Fuel & Oils |  | 26
Miscellaneous |  | 95
Salaries & Wages |  | 500
Property Repairs & Maintenance |  | 140
Telephone & Internet |  | 125
Board Members Allowance |  | 10
Subscriptions |  | 10
Workshops & Conferances |  | 10
 |  | 0
Total Expenses |  | 1282
Profit |  | 6208
Spreadsheet: 02149c56-fd98-4a8d-a035-a53342e01e36
Sheet: Sheet1

Construction Draw Tracking Form
Property Address: | Address | Project Manager: | Name
Notice to Proceed: | Date | Estimated Completion: | Date
Const. Mgr. | Construction Manager Name | Contractor: | [NAME]
Instructions: Utilize this form to track contract status for active construction contracts. Utilize column B (contract amount) to track base bid, alternates selected, and change order adjustments. Utilize column C to track the amounts wired to the title company. Utilize column D to track amounts authorized for disbursement from the title company to the Contractor. Each time an entry is made, include the date that the change order/wire/draw was fully approved. When a final draw is completed, the totals for columns B, C, and D should match. For Draws, initial by the draw authorization to indicate your approval of the disbursement.
 | Column A | Column B | Column C | Column D
Revision Date | Description | Contract amount | Funds wired to title | [NAME]
 | Totals
 | [NAME]
 | Amount to Wire
Spreadsheet: 843486d1695300810-sorting-overtime-hours-to-day-and-night-test_ot_night-day
Sheet: Sheet1

 |  |  |  |  |  |  |  | Shift length |  |  | Night start | Night end
 |  |  |  |  |  |  |  | 08:00:00 |  |  | 22:00:00 | 06:00:00
 |  |  |  |  |  |  |  |  |  | problematic ones
 |  | # test | Start of the work | End of the work |  |  |  | Total hours worked | Overtime total | Day overtime | Night overtime | Night hours worked | testing if ok |  | Expected results
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day OT | Night OT | Total OT | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 |  | 1. | 13:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | 1.1. | 15:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 1.2. | 15:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  | 2. | 15:00:00 | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 2.1. | 13:00:00 | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | 3. | 19:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7 | 8 | 9 | 10 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  | 3.5 | 21:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3
 |  | 4. | 23:00:00 | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 4.5 | 22:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  | 5. | 23:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 5.5 | 00:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2
 |  | 6. | 02:00:00 | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | 6.5 | 02:00:00 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 7. | 08:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  | 7.1 | 06:00:00 | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  |  |  |  | K68 | [NAME] | M68
 |  |  |  |  |  |  |  | 1000.34 | 999.33 | 1.01
Spreadsheet: 859691d1707990471-array-formula-for-sum-across-row-dynamtic-ytd-1-
Sheet: Sheet1

Type | Amount | Period |  |  | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-02 00:00:00 | 2023-11-02 00:00:00 | 2023-12-03 00:00:00 | 2024-01-03 00:00:00 | 2024-02-03 00:00:00 | 2024-03-05 00:00:00 | YTD
Toy | 50 | 2023-04-30 00:00:00 |  |  | 50 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Food | 60 | 2023-04-30 00:00:00 |  | Food | 60 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150
Computer | 70 | 2023-04-30 00:00:00 |  | Computer | 70 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 170
Toy | 80 | 2023-05-31 00:00:00
Food | 90 | 2023-05-31 00:00:00
Computer | 100 | 2023-05-31 00:00:00
Spreadsheet: 48949d1248237758-match-function-example
Sheet: Sheet1

AAA | b1 |  |  | Match | a1 |  | b1 |  | c1 |  | a2 |  | b2 |  | c2 |  | a3 |  | b3 |  | c3
BBB | a2
CCC | a1
DDD | c1
EEE | b1
FFF | b1
GGG | b3
HHH | b1
III | b2
JJJ | c1
KKK | c2
LLL | c1
MMM | a3
NNN | b1
OOO | c3
PPP | c3
QQQ | b1
RRR | c1
SSS | c1
TTT | a1
UUU | b1
VVV | c1
WWW | b2
[NAME] | b1
YYY | b3
ZZZ | b3