tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f1e7679d-5cd2-401d-87db-913f3ec6ad4a
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (25 [NAME]):
 | 5 Labortechnische Geräte 5.1 Laborgeräte und -maschinen 5.1.8 Labor Geräte 5.1.8.8 Labortechnische [NAME], sonstige
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | MPW Med-instruments Spoldzielnia Pracy | [NAME] | Warsaw | 04-347 | B2.410
2 | Auxilab | Spanien | Beriain (Navarra) | 31191 | B1.530
3 | BioFluidix GmbH | Deutschland | Freiburg | 79110 | B1.523
4 | [NAME] bm-log c/o [NAME] | Deutschland | Leipzig | 04109 | A3.341
5 | Capp ApS | [NAME] | Odense | 5260 | B1.505
6 | Chemical Products R. Borghgraef S.A. | Belgien | Brüssel | 1190 | A2.540
7 | CRYOPAL - a member of AIR LIQUIDE Group CRYOBIO | Frankreich | Marne la Vallée | 77607 | A3.155
8 | DYMO - NWL Germany Office Products GmbH | Deutschland | Hamburg | 22525 | B2.117
9 | Erweka GmbH | Deutschland | Heusenstamm | 63150 | A1.303
10 | [NAME] | Deutschland | Wörth | 85457 | B1.222
11 | GFL Gesellschaft für Labortechnik mbH | Deutschland | [NAME] | 30938 | B1.121/220
12 | Van der Heijden Labortechnik GmbH | Deutschland | [NAME] | 32694 | B2.403
13 | Kirsch, [NAME] | Deutschland | Offenburg | 77652 | B1.313/414
14 | Labconco Corporation | USA | Kansas City | MO 64034 | B2.125
15 | Laborgerätebörse GmbH | Deutschland | Burladingen | 72393 | A2.313/412
16 | Miele & Cie. KG [NAME] | Deutschland | Gütersloh | 33332 | B1.201/302
17 | Parker Hannifin GmbH | Deutschland | Kaarst | 41564 | A1.515
18 | PHARMA TEST Apparatebau AG | Deutschland | Hainburg | 63512 | A1.506
19 | Poulten & Graf GmbH | Deutschland | Wertheim | 97877 | B1.128
20 | ROGO-SAMPAIC | Frankreich | Wissous | 91325 | B1.530
21 | schuett-biotec GmbH | Deutschland | Göttingen | 37079 | B1.403
22 | SonoAce GmbH | Deutschland | Marl | 45768 | B2.310
23 | Steinbrenner Laborsysteme GmbH | Deutschland | Wiesenbach | 69257 | A3.535
24 | Th. Geyer GmbH & Co. [NAME] | Deutschland | Renningen | 71272 | B1.430
25 | WLD-TEC GmbH | Deutschland | Arenshausen | 37318 | B1.300
Spreadsheet: 755516d1636926264-help-me-with-formula-to-correctly-calculate-unsocial-hours-worked-sample-timesheet-2-
Sheet: Sheet1

Date | Duty Periods |  |  |  | Total Hours | Details of Duties/Comments
 | From | To | Core | OT
Monday | 00:30:00
 | 01:30:00
 | 02:30:00
 | 03:30:00
Tuesday | 04:30:00
 | 05:30:00
 | 06:30:00
 | 07:30:00
Wednesday | 08:30:00
 | 09:30:00
 | 10:30:00
 | 11:30:00
Thursday | 12:30:00
 | 13:30:00
 | 14:30:00
 | 15:30:00
Friday | 16:30:00
 | 17:30:00
 | 18:30:00
 | 19:30:00
Saturday | 20:30:00
 | 21:30:00
Sunday | 22:30:00
 | 23:30:00
 |  |  |  |  |  | Total Hours Worked
 |  |  |  |  |  | Carried  Forward |  |  | Basic Rate
 |  |  |  |  |  | Hours Taken |  |  | Unsocial
 |  |  |  |  |  | Hours Due |  |  | Initialed
Spreadsheet: 165138d1341047423-conditional-formatting-location
Sheet: Drop Down

Russia |  | OPEN
Germany |  | CLOSED
France |  | RESOLVED
United Kingdom
Italy
Spain
Ukraine
Poland
Romania
Netherlands
Greece
Belgium
Portugal
Czech Republic
Hungary
Serbia
Belarus
Sweden
Austria
Switzerland
Bulgaria
Denmark
Slovakia
Finland
Norway
Ireland
Croatia
Bosnia and Herzegovina
Moldova
Lithuania
Albania
Latvia
Macedonia
Slovenia
Estonia
Montenegro
Luxembourg
Malta
Iceland
Andorra
Isle of Man (UK)
Faroe Islands (Denmark)
[NAME]
Monaco
[NAME]
Gibraltar (UK)[4]
Vatican City
Spreadsheet: 854df1b0-e7ef-4b6d-9725-c60955599e3c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
FEDERAL FUNDING REQUEST
For All Federal SAPT Block Grant Funding
Ohio Department of Alcohol & Drug Addiction Services
1. Header Information:
Agency/Board Name:
Federal Tax Id #:
ODADAS Grant Award #: |  |  |  | Purchase Order #:                                            (If applicable)
2. Expenses  SFY 2010
Service Category | Actual Expenses Thru              (Enter Date) | Projected Expenses Thru                (Enter Date) | Total | Funds Received To Date | Period Request | Total SFY Award | Available Balance
Prevention | (A) | (B) | (C=A+B) | (D) | (E=C-D) | (F) | (G=F-D-E)
2000C - Per Capita Prevention |  |  | 0 |  | 0 |  | 0
2000F - Board Request Special Needs Prevention |  |  | 0 |  | 0 |  | 0
2010C - UMADAOP |  |  | 0 |  | 0 |  | 0
2010G - Women's Prevention Grants |  |  | 0 |  | 0 |  | 0
2020C - Drug Free Coalitions |  |  | 0 |  | 0 |  | 0
2020E - Higher Education |  |  | 0 |  | 0 |  | 0
2020F - Prevention at Work |  |  | 0 |  | 0 |  | 0
2020I - Community Prevention |  |  | 0 |  | 0 |  | 0
2020J - Targeted Prevention Initiatives |  |  | 0 |  | 0 |  | 0
2030C - Parent Engagement |  |  | 0 |  | 0 |  | 0
2030E - Youth-Led Prevention |  |  | 0 |  | 0 |  | 0
2030G - Circle for Recovery |  |  | 0 |  | 0 |  | 0
2030M - Prevention Services |  |  | 0 |  | 0 |  | 0
Total Prevention | 0 | 0 | 0 | 0 | 0 | 0 | 0
Treatment
2050C - Per Capita Treatment |  |  | 0 |  | 0 |  | 0
2060E - Women's Treatment Grants |  |  | 0 |  | 0 |  | 0
2070C - Adolescent Treatment |  |  | 0 |  | 0 |  | 0
2070G - TANF Treatment |  |  | 0 |  | 0 |  | 0
2070H - Targeted Treatment Initatives |  |  | 0 |  | 0 |  | 0
2080C - Therapeutic Community |  |  | 0 |  | 0 |  | 0
2080D - TC Expansion |  |  | 0 |  | 0 |  | 0
2080E - TASC |  |  | 0 |  | 0 |  | 0
2080F - Drug Courts |  |  | 0 |  | 0 |  | 0
2080I  - DYS Aftercare |  |  | 0 |  | 0 |  | 0
2080M - Circle for Recovery |  |  | 0 |  | 0 |  | 0
2100D - Outreach |  |  | 0 |  | 0 |  | 0
2100I - SAMI |  |  | 0 |  | 0 |  | 0
Total Treatment | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0
Federal regulations require that all federal funds be drawn down on a reimbursement basis and/or no more than thirty (30) days in advance of projected expenditures.  NO FUNDS WILL BE DISBURSED UNLESS COLUMNS A-G ARE COMPLETED.
3. CERTIFICATION
I certify that the financial information shown in this funding request is correct.
Requestor's Signature/Title |  |  | Phone Number |  |  | Date
Board Executive Director's Signature |  |  | Phone Number |  |  | Date
Spreadsheet: 787429d1657797238-require-a-formula-to-extract-2-dates-from-a-string-and-place-them-into-2-separate-cells-book1-2-
Sheet: Sheet1

AND 10 dates from & including 02/07/2021 - 03/08/2021 |  | 2021-08-03 00:00:00
AND 2021/68 02/07/21 - 03/08/22 |  | 2022-08-03 00:00:00
AND 2022/85 02/07/2021 & 03/08/2021 |  | 2021-08-03 00:00:00
AND 10 dates between 02/07/2021 - 03/08/2021 |  | 2021-08-03 00:00:00
19/11/2021- 05/12/2011 |  | 2011-12-05 00:00:00
OLD 2022/1 area = from 04/04/2022- 24/11/2022 |  | 2022-11-24 00:00:00
OLD 2022/1 area = from 04/04/2022-24/11/2022 |  | 2022-11-24 00:00:00
Spreadsheet: aa8ea562-5a41-4c93-bbf7-99a684672ed6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2576 | 14369 | [NAME] | Scott | USA | 473 | 01:33:23 | 00:00:00 | [NAME] | 00:00:00 | 04:10:46 | 1 | 10:41:53
Spreadsheet: 63030d1264000724-help-compiling-data-on-a-summary-page-depending-on-drop-down-menu-choices-example-a-
Sheet: Summary

DESIRED SUMMARY
 |  | % DAYS AVAILBLE
RESPONSIBLE STAFF |  | YEAR 1 | YEAR 2
A |  | 0.07 | 0.13
B |  | 0.09 | 0
C |  | 0.15 | 0.03
D |  | 0.01 | 0
E |  | 0.02 | 0
H |  | 0 | 0.09
N |  | 0 | 0.01
O |  | 0 | 0.1
Spreadsheet: 118275d1313586217-help-with-formula-for-league-table-league-table
Sheet: Sheet2

Number of people | 6
 | Player A | Player B | Combined | Names
 | 1 | 2
Spreadsheet: 90040d1289806497-sumproduct-4-conditions-book1
Sheet: Sheet1

 | Stakeholder Groups / Current Position | Blank | On Target | -1 - Not Committed | 0 - Not Aware / Confused | 2 - Understand | 3 - Committed
A | Team | 1 | 1 | 1 | 1
division | b | Stakeholder Groups / Business Unit | Title | Contact | c | d | Current Position | Target Position | Interests / Concerns / Issues | Engagement Forums | Division | Business Unit | Relationship to Program/ project | Validation
a |  | Team | abc | bde | text | text | -1 - Not Committed | 2 - Understand |  |  | Ubank | LT | Team | F
a |  | Team | abc | bde | text | text | 0 - Not Aware / Confused | 2 - Understand |  |  | Ubank | LT | Team | F
a |  | Team | abc | bde | text | text | 2 - Understand | 2 - Understand |  |  | Ubank | LT | Team | T
a |  | Team | abc | bde | text | text |  | 2 - Understand |  |  | Ubank | LT | Team | F
Spreadsheet: 700632d1603274545-identify-cells-that-havent-been-modified-in-the-last-2-weeks-subnet-decommisioning-tracker-27012020-2-
Sheet: Sheet6

 | Calculator
 | CIDR | Usable IPs | Number of subents | Number of IPs
 | /32 | 1
 | /31 | 0
 | /30 | 2
 | /29 | 6
 | /28 | 14
 | /27 | 30
 | /26 | 62
 | /25 | 126
 | /24 | 254
 | /23 | 510
 | /22 | 1022
 | /21 | 2046
 | /20 | 4094
 | /19 | 8190
 | /18 | 16382
 | /17 | 32766
 | /16 | 65534
 | /15 | 131070
 | /14 | 262142
 | /13 | 524286
 | /12 | 1048574
 | /11 | 2097150
 | /10 | 4194302
 | /9 | 8388606
 | /8 | 16777214
 | [NAME] | 33554430
 | /6 | 67108862
 | /5 | 134217726
 | /4 | 268435454
 | /3 | 536870910
 | /2 | 1073741822
 | /1 | 2147483646
 | /0 | 4294967294
 | BLANK | 0
Spreadsheet: 882185d1730446161-generate-reports-for-students-in-a-school-reports-test
Sheet: Sheet1

 | Name | Progress | Behaviour | Progress Text | Behaviour Text
1 | Greg | 1 | 1
2 | [NAME] | 2 | 2
3 | Scott | 3 | 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
Spreadsheet: 755696d1637042849-formulas-with-multiple-range-criteria-not-returning-result-sample1-2-
Sheet: Sheet2

Customer Name | [NAME] | Dr Del Date | Int Date | Dr Doc No | Dr Type | Dr GST [NAME] | Billing Type | Debit | @EP | [NAME] | Clrearing Date | [NAME] | [NAME] | Cr GST Bill No | Credit | D1 | D2 | [NAME] | DR Int%13.00 | DR Int%16.00 | EP Dis%7.50 | Ad Dis%0.00 |  | SUMPRODUCT
xyx | 2021-07-01 00:00:00 |  | 2021-07-01 00:00:00 |  |  |  |  | 0 |  |  | 2021-07-01 00:00:00 | Opn |  |  | 6428.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0.1 | 0.1
xyx | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-13 00:00:00 | [PHONE] | RV | SI3001111565 | ZSOR | 1179449 | Y | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | [PHONE] | 1X |  | 6428.65 | -13 | -13 | 0 | 0 | 0 | 11 | 0 |  |  | 7 | 0.13
xyx | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-13 00:00:00 | [PHONE] | RV | SI3001111565 | ZSOR | 1173020.35 | Y | 2021-07-26 00:00:00 | 2021-07-26 00:00:00 | [PHONE] | DG |  | 1901.05 | 26 | 13 | 2250 | 2507 | 0 | 0 | 0 |  |  | 52 | 0.16
xyx | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-13 00:00:00 | [PHONE] | RV | SI3001111565 | ZSOR | 1171119.3 | Y | 2021-08-10 00:00:00 | 2021-08-10 00:00:00 | [PHONE] | DX |  | 1150000 | 15 | 28 | 0 | 6257 | 0 | 0 | 0
xyx | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-13 00:00:00 | [PHONE] | RV | SI3001111565 | ZSOR | 21119.3 | Y | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 |  |  |  | 0 | 52 | 80 | 0 | 181 | 259 | 0 | 0
xyx | 2021-07-26 00:00:00 | 2021-07-26 00:00:00 | 2021-07-26 00:00:00 | [PHONE] | DN |  |  | 42527.55 |  | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 |  |  |  | 0 | 66 | 67 | 175 | 682 | 131 | 0 | 0
xyx | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-21 00:00:00 | [PHONE] | RV | SI3001112214 | ZSOR | 1299026 | Y | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 |  |  |  | 0 | 40 | 41 | 2491 | 15731 | 0 | 0 | 0
Spreadsheet: 41189d1239711170-linking-and-finding-information-678358b
Sheet: Sheet3

Name | Amount | Unit | Price | total
E | 22 | st |  | 0
A | 31 | st |  | 0
D | 213 | st |  | 0
Q | 32 | st |  | 0
Spreadsheet: 8c46b279-f2b7-4fb6-8c03-97f60e069aad
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259508 | 65445 | Marleide | [NAME] | BRA | 3 | 00:23:18 | 00:02:06 | 00:40:49 | 00:01:15 | 00:33:57 | 1 | 01:41:27
Spreadsheet: b89bc50a-ba43-4311-b126-09ea3fba7fdc
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
FHIST | Test | FHIST | MVista Histoplasma Antigen, Serum | MVista Histoplasma Ag, S | Enzyme Immunoassay (EIA) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top or serum gel tube(s). Spin down and send 2 mL of serum refrigerated. | 1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reference interval: None Detected   Results reported as ng/mL in 0.4 - 19 ng/mL    Results above the limit of detection but below 0.4 ng/mL are reported as Positive, Below the Limit of Quantification.   Results above 19 ng/mL are reported as 'Positive, Above the Limit of Quantification'   Test Performed by :  MiraVista Diagnostics                                 4705 Decatur Blvd.                                 Indianapolis, IN 46241 | Monday through Friday | 2 days | 4 - 8 days | 1 | 87385 |  |  |  |  | MiraVista Diagnostics
FHIST | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FHIST | Result | Z1711 | Result: | Result: | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FHIST | Result | Z1035 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 034af40e-e6d4-464e-bff2-7b09b12e5c9d
Sheet: Operating Costs

Service Center Calculations
ANNUAL BUDGETED OPERATING COSTS
Purpose: To detail non-salary and non-equipment costs associated with the service center services
Sheet Instructions
Fill in only the yellow highlighted areas
You may insert additional lines as necessary.
 |  | SERVICE 1 |  | SERVICE 2
Travel
Description | Annual Amt | % | Amount | % | Amount
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
SUBTOTAL TRAVEL
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS | 0 | 0 |  | 0
TOTAL TRAVEL
 |  | SERVICE 1 |  | SERVICE 2
Operating Expenses
Description | Annual Amt | % | Amount | % | Amount
0 | 0 | 0 |  | 0
0 | 0 | 0 |  | 0
0 | 0 | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
SUBTOTAL OPERATING EXPENSES
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS | 0 | 0 |  | 0
SUBTOTAL OPERATING EXPENSES
 |  | SERVICE 1 |  | SERVICE 2
Equipment < $5,000*
Description | Annual Amt | % | Amount | % | Amount
Equipment - non R&R | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
SUBTOTAL EQUIPMENT <$5,000
SUBSIDY - AMOUNT THAT WILL NOT BE CHARGED TO CUSTOMERS | 0 | 0 |  | 0
SUBTOTAL EQUIPMENT <$5,000>
Equipment >$5,000 - See next worksheet
Spreadsheet: 876761d1723489211-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Install

Installed  On | MarkNo. | Qty (Nos) | [NAME]. | GROSS WEIGHT | Assembly Name
2024-06-23 00:00:00 | QLGF-C2001 | 1 | 1/1
2024-06-23 00:00:00 | QLGF-C2002 | 1 | 1/2
2024-06-24 00:00:00 | QLGF-C2002 | 1 | 1/2
2024-06-23 00:00:00 | QLGF-C2003 | 1 | 1/1
2024-06-24 00:00:00 | QLGF-BM2003 | 1 | 1/1
2024-06-24 00:00:00 | QLGF-BM2004 | 1 | 1/1 | 205.7
2024-06-24 00:00:00 | QLGF-HB2005 | 1 | 1/1
2024-06-24 00:00:00 | QLGF-HB2009 | 1 | 1/1
2024-06-25 00:00:00 | QL-1-BM2002 | 1 | 1/1 | 673.6
2024-06-25 00:00:00 | QL-1-BM2003 | 1 | 1/1
2024-06-25 00:00:00 | QL-1-BM2004 | 1 | 1/1
Spreadsheet: 822117d1679110034-monte-carlo-simulation-monte-carlo-simulation-becool-
Sheet: Pivot Table and Chart

Date | Count of Date | Cumulative Count
2/1/2023 - 2/3/2023 | 1 | 0.001
2/4/2023 - 2/6/2023 | 2 | 0.003
2/7/2023 - 2/9/2023 | 4 | 0.007
2/10/2023 - 2/12/2023 | 11 | 0.018
2/13/2023 - 2/15/2023 | 27 | 0.045
2/16/2023 - 2/18/2023 | 55 | 0.1
2/19/2023 - 2/21/2023 | 85 | 0.185
2/22/2023 - 2/24/2023 | 129 | 0.314
2/25/2023 - 2/27/2023 | 134 | 0.448
2/28/2023 - 3/2/2023 | 148 | 0.596
3/3/2023 - 3/5/2023 | 154 | 0.75
3/6/2023 - 3/8/2023 | 87 | 0.837
3/9/2023 - 3/11/2023 | 83 | 0.92
3/12/2023 - 3/14/2023 | 36 | 0.956
3/15/2023 - 3/17/2023 | 23 | 0.979
3/18/2023 - 3/20/2023 | 12 | 0.991
3/21/2023 - 3/23/2023 | 4 | 0.995
3/24/2023 - 3/26/2023 | 2 | 0.997
3/27/2023 - 3/29/2023 | 1 | 0.998
3/30/2023 - 4/1/2023 | 1 | 0.999
>4/2/2023 | 1 | 1
Grand Total | 1000
Spreadsheet: 688645d1595887050-help-with-sumifs-formula-across-multiple-sheets-sample-worksheet
Sheet: GB

Client Name:
DOB:
Insurance:
Member ID:
Clinician: | ANGIE
NPI:
Dx Code:
Number of Sessions Billed This Year
Submission Claim ID # | DOS | Date Claim Submitted | Total Claim | Carrier Payment
 |  | 2020-07-10 00:00:00 | 225 | 182.59 | ANGIE
 |  |  |  |  | ANGIE
 |  | 2020-07-10 00:00:00 | 700 | Voided | ANGIE
 |  |  |  |  | ANGIE
 |  |  |  |  | ANGIE
 |  | 2020-07-10 00:00:00 | 350 | 221.14 | ANGIE
 |  |  |  |  | ANGIE
 |  | 2020-07-12 00:00:00 | 350 | 221.14 | ANGIE
 |  |  |  |  | ANGIE
 |  | Totals:
 |  |  | Billed | Recieved
Spreadsheet: 687077d1594943925-calculate-total-in-range-that-are-before-specific-time-sample
Sheet: TGDR Revised

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700
 |  |  |  |  |  |  |  |  | Time Opened | Time Closed | Hours   Open |  |  |  |  |  | 1800
 |  |  |  |  |  |  |  | A | 1700 | 2200 | 3 |  |  |  |  |  | 1900
 |  |  |  |  |  |  |  | B | 1700 | 2150 | 2.75 |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  | C | 1700 | 2305 | 6 |  |  |  |  |  | 2100
 |  |  |  |  |  |  |  | D | 1700 | 2315 | 6.25 |  |  |  |  |  | 2200
 |  |  |  |  |  |  |  | E | 1700 | 2110 | 2.25 |  |  |  |  |  | 2300
 |  |  |  |  |  |  |  | F | 1700 | 1820 | 1.25 |  |  |  |  |  | 2400
Time | Open
1700 | 6
 | 6
 | 6
 | 6
 | 6
 | 6
 | 6
 | 6
Total
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk2

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 709848d1608576830-fill-in-attendance-sheet-automatically-from-list-demo-file
Sheet: Attendance Sheet

 | Location |  | Location Address |  |  |  | Room
 |  |  |  | Trainer | Start Date | End Date | Actual Start Time | Actual End Time
 |  |  |  |  | 2020-03-02 00:00:00
 | If any information is incomplete in the boxes below please complete. |  |  |  | Actual Break Times (HH:MM - HH:MM):
 | Special Number | Name |  |  | ATT. (Y/N) | REMARKS | ID Given | Employee Signature
 | Notes:
Spreadsheet: 793913d1661789513-array-formula-that-looks-up-and-returns-values-from-a-table-sequence-example
Sheet: Formulas

Year |  | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022
Month |  | Jan | Jan | Jan | Feb | Feb | Feb | Feb | Mar | Mar | Mar | Mar | Mar | Apr | Apr | Apr | Apr | May | May | May | May | Jun | Jun | Jun | Jun | Jun | Jul | Jul | Jul | Jul | Aug | Aug | Aug | Aug | Sep | Sep | Sep | Sep | Sep | Oct | Oct | Oct | Oct | Nov | Nov | Nov | Nov | Dec | Dec | Dec | Dec | Dec
Week |  | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 5
Holiday ([NAME], not working) |  | 16 | 0 | 24 | 8 | 8 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0 | #N/A | #N/A | #N/A | #N/A | 0 | #N/A | 0 | 0 | 0 | 0 | #N/A | #N/A | 0 | #N/A | #N/A | 0 | 0 | 0 | 0 | #N/A | #N/A | 0 | #N/A | #N/A | #N/A | 0 | #N/A | #N/A
Holiday (not array)
Spreadsheet: 688520d1595839149-radio-button-disabled-radio-button-disabled
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 3 | 1
 |  | Selection
 |  | Model |  | Car Model |  | [NAME] |  | Motor Model
 |  | Car |  | Toyota |  | Isuzu |  | Yamaha
 |  | [NAME] |  | Honda |  | [NAME] |  | Honda
 |  | Motor |  | Madza |  | Mitsubishi |  | [NAME]