tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730707d1619864728-group-countif-formula-with-multiple-conditions-book1-1-
Sheet: Sheet1

TABLE-1 |  |  |  |  |  |  | TABLE-2 |  |  |  |  |  |  |  |  | Answer should be
Item | A | B | C | D | E |  | Item | A | B | C | D | E |  |  |  |  | No. of Item | Valid count | Compliance %
AA | M |  |  |  | M |  | AA | 2022-01-15 00:00:00 |  |  | 2022-01-05 00:00:00 | 2022-02-04 00:00:00 |  |  |  | A
AB |  | M |  |  |  |  | AB |  | 2020-12-31 00:00:00 |  |  |  |  |  |  | B
AC |  |  | M |  |  |  | AC | 2023-01-15 00:00:00 |  | 2022-01-15 00:00:00 |  |  |  |  |  | C
AD |  |  |  | M |  |  | AD |  |  |  | 2020-12-31 00:00:00 |  |  |  |  | D
AE | M |  |  |  | M |  | AE | 2022-05-01 00:00:00 |  |  |  | 2022-01-15 00:00:00 |  |  |  | E
AG |  |  | M |  |  |  | AG |  |  | 2022-05-01 00:00:00
AH |  |  |  | M |  |  | AH |  | 2022-06-05 00:00:00 |  | 2022-05-01 00:00:00
BA |  |  | M |  |  |  | BA |  |  | 2020-01-01 00:00:00 |  |  |  |  | Conditions
BB | M |  |  |  |  |  | BB | 2023-04-06 00:00:00 |  |  |  |  |  |  | 1 | I have to count dates based against the Item
BC |  |  |  |  | M |  | BC |  |  |  |  | 2023-04-06 00:00:00 |  |  | 2 | I have to count only the cells which are having dates and is  greater than today
BD |  | M |  |  |  |  | BD |  | 2020-01-01 00:00:00 |  |  |  |  |  | 3 | Count if only if the second table matches with the first table criteria (M)
BE |  | M |  |  |  |  | BE |  | 2022-01-01 00:00:00 | 2023-03-04 00:00:00
BG |  |  |  | M |  |  | BG |  |  |  | 2022-01-01 00:00:00 | 2023-08-17 00:00:00
BH | M |  |  |  |  |  | BH | 2022-01-01 00:00:00
CG |  | M |  |  |  |  | CG |  | 2023-04-06 00:00:00
CF |  |  |  | M | M |  | CF |  |  |  |  | 2023-04-06 00:00:00
CH |  |  | M |  |  |  | CH |  |  | 2022-01-15 00:00:00
CO | M |  |  |  | M |  | CO | 2020-12-31 00:00:00 |  |  |  | 2022-05-01 00:00:00
 | Legend : M - Mandatory
Spreadsheet: 701338d1603713625-index-and-match-that-looks-at-a-date-test
Sheet: Sheet1

Part | Description | August | September | October | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00 |  |  | August | September | October | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00
72400103 | MAG    NPLATE SURR MOULD | 0 | 1449 | 100 | 0 | 0 | 0 | 0 | 0 |  | QPP
72400101 | MAG LH  B/WARE MOULD | 0 | 1945 | 761 | 0 | 0 | 0 | 0 | 0 |  | JLR Covers
72400102 | MAG RH  B/WARE MOULD | 0 | 1928 | 760 | 0 | 0 | 0 | 0 | 0
72300101 | TEC     METER HOUSING | 0 | 4215 | 11880 | 0 | 0 | 0 | 0 | 0
72400106 | MAG RH  FRONT CARRIER VM | 0 | 20 | 1542 | 0 | 0 | 0 | 0 | 0
72100111 | AAR WHT CAP | 0 | 5117 | 26600 | 0 | 0 | 0 | 0 | 0
72100112 | AAR WHT LOCATION BODY | 0 | 2560 | 13750 | 0 | 0 | 0 | 0 | 0
72100113 | AAR WHT BRACKET BODY | 0 | 2560 | 14430 | 0 | 0 | 0 | 0 | 0
72100119 | CON WHT WALL BRKT CAP | 0 | 0 | 19851 | 0 | 0 | 0 | 0 | 0
72100118 | CON WHT WALL BRACKET | 0 | 0 | 19894 | 0 | 0 | 0 | 0 | 0
72400104 | MAG LH  FRONT CARRIER VM | 0 | 0 | 1562 | 0 | 0 | 0 | 0 | 0
72400105 | MAG LH  REAR CARRIER VM | 0 | 0 | 1562 | 0 | 0 | 0 | 0 | 0
72400107 | MAG RH  REAR CARRIER VM | 0 | 0 | 1562 | 0 | 0 | 0 | 0 | 0
72100115 | JOS WHT SOAP DISH | 0 | 0 | 18245 | 0 | 0 | 0 | 0 | 0
72100116 | JOS WHT WALL BRACKET | 0 | 0 | 10108 | 0 | 0 | 0 | 0 | 0
72100117 | JOS WHT WALL BRKT CAP | 0 | 0 | 10406 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
72100121 | AAR NAT CAP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
72100122 | [NAME] BODY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
72100126 | JOS NAT WALL BRACKET | 0 | 0 | 3888 | 0 | 0 | 0 | 0 | 0
72100127 | JOS NAT WALL BRKT CAP | 0 | 0 | 3888 | 0 | 0 | 0 | 0 | 0
72100125 | JOS CLR SOAP DISH | 0 | 0 | 5000 | 0 | 0 | 0 | 0 | 0
QPP |  | 0 | 19794 | 165789 | 0 | 0 | 0 | 0 | 0
 |  | August | September | October | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00
68931618 | 405 COV VIRGIN COVER T65 | 10856 | 18696 | 38640 | 552 | 0 | 0 | 0 | 0
68931620 | 405 RHL VIRGIN CAP T65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
68931619 | 405 LHL VIRGIN CAP T65 | 0 | 0 | 6920 | 0 | 0 | 0 | 0 | 0
68931621 | 405 N/L VIRGIN CAP T65 | 0 | 10301 | 65500 | 500 | 0 | 0 | 0 | 0
68930580 | 405 COV VIRGIN COVER T45 | 0 | 0 | 3964 | 0 | 0 | 0 | 0 | 0
68930053 | 405 N/L VIRGIN CAP T45 | 0 | 0 | 4109 | 0 | 0 | 0 | 0 | 0
68930051 | 405 LHL VIRGIN CAP T45 | 0 | 0 | 500 | 0 | 0 | 0 | 0 | 0
JLR Covers |  | 10856 | 28997 | 119633 | 1052 | 0 | 0 | 0 | 0
Spreadsheet: 864673d1711758466-total-up-the-quantity-total-pump-
Sheet: Main (2)

 |  |  |  |  |  | Date: 03/2024
 | Date | Customer name | Acre | Pump | Responsible person | TOTAL PUMP
 | 2024-03-02 00:00:00 | customer C | 2 | 1 | WORKER 1 | 4
 | 2024-03-02 00:00:00 | customer C | 2 | 1 | WORKER 2
 | 2024-03-02 00:00:00 | customer C | 2 | 2 | WORKER 3
 | 2024-03-02 00:00:00 | customer C | 8 | 6 | WORKER 1 | 20
 | 2024-03-02 00:00:00 | customer C | 8 | 7 | WORKER 2
 | 2024-03-02 00:00:00 | customer C | 8 | 7 | WORKER 3
 | 2024-03-03 00:00:00 | customer D | 8 | 0 | WORKER 1 | 2
 | 2024-03-03 00:00:00 | customer D | 8 | 1 | WORKER 2
 | 2024-03-03 00:00:00 | customer D | 8 | 1 | WORKER 3
Spreadsheet: 846864d1698009472-help-with-projections-money-projections-help
Sheet: Sheet1

Workers | Weekday | Saturday | Sunday |  | Service Cost Weekday | Service Cost Saturday | Service Cost Sunday | Profit p/h Weekday | Profit p/h Saturday | Profit p/h Sunday | Weekday Hours | Saturday Hours | Sunday Hours | Fortnightly Profit
Staff A | 42.79 | 59.9 | 77.02 |  | 65.47 | 92.12 | 118.78 |  |  |  | 0
Staff B | 42.79 | 59.9 | 77.02 |  | 65.47 | 92.12 | 118.78 |  |  |  | 25
Staff C | 40.26 | 56.37 | 72.47 |  | 65.47 | 92.12 | 118.78 |  |  |  | 20
Staff D | 40.26 | 56.37 | 72.47 |  | 65.47 | 92.12 | 118.78 |  |  |  | 31
Staff E | 40.26 | 56.37 | 72.47 |  | 65.47 | 92.12 | 118.78 |  |  |  | 30
Staff F | 40.26 | 56.37 | 72.47 |  | 65.47 | 92.12 | 118.78 |  |  |  | 8
Staff G | 40.26 | 56.37 | 72.47 |  | 65.47 | 92.12 | 118.78 |  |  |  | 4
Staff H | 40.26 | 56.37 | 72.47 |  | 65.47 | 92.12 | 118.78
Staff I | 42.79 | 59.9 | 77.02 |  | 65.47 | 92.12 | 118.78 |  |  |  | 0
 | Super Contribution
Staff A |  |  |  |  |  |  |  |  |  |  |  |  | Profit before expendetures
Staff B |  |  |  |  |  |  |  |  |  |  |  |  | SAFE Work SA
Staff C |  |  |  |  |  |  |  |  |  |  |  |  | Shift Care Cost
Staff D |  |  |  |  |  |  |  |  |  |  |  |  | Xero
Staff E |  |  |  |  |  |  |  |  |  |  |  |  | Insurance  (annual $2035) | 78
Staff F
Staff G |  |  |  |  |  |  |  |  |  |  |  |  | Total
Staff H
Staff I
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 12a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending December 21, by product type and cleared status (value of all trades in millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: sally_beck__33832__global standards daily reporting phase 1
Sheet: B 01

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards B
Report B 01:
Purpose: | To capture when reporting to DPR group was received late (to be performed only by Houston Risk Controls group).
Date | Exported | By | Reason (to be supplied by commodity group) | Key contact
2000-10-27 00:00:00 | 2000-10-30 12:10:00 | from pwrdpr.xls | System failed | [NAME]
2000-10-27 00:00:00 | 2000-10-30 14:15:00 | from PWRB1027a-includes Alberta.xls | System failed | [NAME]
2000-10-27 00:00:00 | 2000-10-30 12:55:00 | from Orig1027B.xls | Book admin out sick | [NAME]
2000-10-27 00:00:00 | 2000-10-30 16:55:00 | from London_DPR_2000_10_27.xls | System failed | [NAME]
2000-10-27 00:00:00 | 2000-10-30 14:04:00 | from 1000_int.xls | System failed | [NAME]
Spreadsheet: 828065d1683207039-sort-function-or-any-ignoring-header-in-existing-let-function-dummy2
Sheet: Sheet2

Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | Header8 | Header9 | Header10 | Header11
Jasmine |  |  | 2097.6.4 |  | Popy |  | 126364 | Text1 | 44 | 2
Jasmine |  |  | 2098.77 |  | Avenger |  | ABC | Apps | 97
Jasmine |  |  | 2084.2.6 |  | Poly |  | 895634 | Electro |  | 98
Jasmine |  | 2067.8 |  |  | Apple |  |  | Tex9 | 88 | 32
Jasmine |  |  |  |  | Desktop |  | 64638 | District |  | 47
Jasmine |  |  |  |  |  |  | 9631 |  | 56
Jasmine |  |  |  |  | Tesla |  | 126364 | [NAME] | 97 | 97
Lily |  |  |  |  |  |  | ADFG |  |  | 66
Lily |  |  |  |  |  |  | 64638 |  | 34
Rose |  |  |  |  |  |  | 2696 | King |  | 88
Spreadsheet: 688002d1595520052-need-running-sum-based-on-filtered-records-running-sum-filtered-
Sheet: Sheet1

Filter | Office | Employee | Amount | Running Total |  |  | Select Budget: | 300
1 | ABC | [NAME] | 40
1 | ABC | [NAME] | 32
1 | ABC | [NAME] | 52
1 | KLM | Moe | 70
1 | KLM | [NAME] | 50
1 | KLM | Curly | 69
 | RST | [NAME] | 45
 | RST | [NAME] | 35
 | RST | [NAME] | 49
1 | XYZ | [NAME] | 59
1 | XYZ | [NAME] | 32
1 | XYZ | Maurine | 57
Spreadsheet: 842484d1694552520-vlookup-with-sumifs-and-multiple-criteria-dummy-sheet
Sheet: Sheet1

EMP ID | Employee Name | Shift | Previous Balance | Earned Hours | Used hours | Total Remaining Hours
12345 | [NAME] | 1st Shift | 168.25 |  | 20
67890 | [NAME] | 2nd Shift
11123 | [NAME] | 3rd Shift
Spreadsheet: 812423d1673132493-vlookup-and-if-statement-test-max-rate-error
Sheet: Sheet1

 |  | Grade Increment | Min/[NAME]
 |  | 0.11 | 0.6
 |  | 0.1 | 0.4
 |  | 0.09 | 0.3
 | Grade | Min | Mid | [NAME]
 | 2 | 15.96
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | Pay Grade | Pay Rate | New Rate
 | 3 | 19
 | 11 | 50
 | 9 | 40
 | 6 | 23
 | 7 | 33
 | 14 | 50
 | 5 | 27
 | Pay Grade can be 2 though 15
 | My attempt to get started: New rate formula for Pay Grade 2  is =IF(AND(A2=2,D2<=20.75),D2,"Above [NAME], adjust")
 | Is there a way to create a formula that encompasses all pay grades with [NAME] without using 14 If statements?
 | by combining a vlookup with an if(and) statement
Spreadsheet: larry_campbell__21072__expense report SAP 8-2000
Sheet: Travel Form

Employee Expense Report
Travel Expense Summary |  |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  | EMPLOYEE NUMBER
TRAVEL EXPENSE - Enter all transportation and lodging expenses by receipt total (airline tickets, rental car receipts, taxis, hotel, tips, personal mileage, etc.).  Exclude meals and entertainment.
Designate type of transportation used: B = Bus,  C = Cab, P = Plane,  PC = Personal Car,  CC = Company Car, RC = Rental Car, T = Train.
Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date |  |  | Location and Business Purpose |  |  |  |  |  |  | Type | Cost/Miles | Rate | $ [NAME]
01 | 8/14-8/18 | [NAME] to Albuq. To Roswell    DES and Interim Review Mtg |  |  |  |  |  |  |  |  | P | 309 | 1
01 | 8/14-8/18 | DES Interim Review |  |  |  |  |  |  |  |  |  | 410.61 | 1
01 | 8/14-8/18 | DES Interim Review Rental Car |  |  |  |  |  |  |  |  | RC | 180.72 | 1
01 | 8/14-8/18 | DES Interim Review Rental Car Gasoline |  |  |  |  |  |  |  |  | RC | 7.35 | 1
01 | 2000-08-20 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  | 62.1 | 1
01 | 2000-08-22 00:00:00 | EOTT Pipeline Due Diligence |  |  |  |  |  |  |  |  |  | 90.85 | 1
01 | 8/232/00 | Roswell to Farmington NM EOTT Pipeline Due Diligence |  |  |  |  |  |  |  |  | P | 446 | 1
01 | 2000-08-23 00:00:00 | EOTT Pipeline Due Diligence |  |  |  |  |  |  |  |  |  | 107.87 | 1
01 | 2000-08-24 00:00:00 | EOTT Pipeline Due Diligence Rental Car |  |  |  |  |  |  |  |  | RC | 72.78 | 1
01 | 2000-08-24 00:00:00 | EOTT Pipeline Dur Diligence Rental Car Gasoline |  |  |  |  |  |  |  |  | RC | 22.25 | 1
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co Trd Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  |  | Amount
01 | 52004500 | 0060 | 111102
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 599442d1543079317-formula-to-update-second-workbook-based-on-todays-date-from-row-in-1st-workbook-workbook-1
Sheet: Sheet1

2018-01-01 00:00:00 | 2018-01-02 00:00:00 | 2018-01-03 00:00:00 | 2018-01-04 00:00:00 | 2018-01-05 00:00:00 | 2018-01-06 00:00:00 | 2018-01-07 00:00:00 | 2018-01-08 00:00:00 | 2018-01-09 00:00:00 | 2018-01-10 00:00:00 | 2018-01-11 00:00:00 | 2018-01-12 00:00:00 | 2018-01-13 00:00:00 | 2018-01-14 00:00:00 | 2018-01-15 00:00:00 | 2018-01-16 00:00:00 | 2018-01-17 00:00:00 | 2018-01-18 00:00:00 | 2018-01-19 00:00:00 | 2018-01-20 00:00:00 | 2018-01-21 00:00:00 | 2018-01-22 00:00:00 | 2018-01-23 00:00:00 | 2018-01-24 00:00:00 | 2018-01-25 00:00:00 | 2018-01-26 00:00:00 | 2018-01-27 00:00:00 | 2018-01-28 00:00:00 | 2018-01-29 00:00:00 | 2018-01-30 00:00:00 | 2018-01-31 00:00:00 | 2018-02-01 00:00:00 | 2018-02-02 00:00:00 | 2018-02-03 00:00:00 | 2018-02-04 00:00:00 | 2018-02-05 00:00:00 | 2018-02-06 00:00:00 | 2018-02-07 00:00:00 | 2018-02-08 00:00:00 | 2018-02-09 00:00:00 | 2018-02-10 00:00:00 | 2018-02-11 00:00:00 | 2018-02-12 00:00:00 | 2018-02-13 00:00:00 | 2018-02-14 00:00:00 | 2018-02-15 00:00:00 | 2018-02-16 00:00:00 | 2018-02-17 00:00:00 | 2018-02-18 00:00:00 | 2018-02-19 00:00:00
555 | 256 | 539 | 956 | 458 | 255 | 333 | 964 | 152 | 2258 | 2699 | 5564 | 258 | 555 | 6632 | 254 | 459 | 523 | 552 | 158 | 2654 | 222 | 339 | 884 | 158 | 1522
 | Data added daily
Spreadsheet: 09d848e9-79c9-4b52-b77d-0b43fd37b9f4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 36. LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413895X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413896A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413897C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413898F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413899J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413900F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413901J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413902K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413903L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413904R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413905T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413906V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413907W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413908X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413909A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413910K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: e6a31cfb-b3c1-4054-a2cb-6aebea201abd
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75678967603 | Paramore | Brand New Eyes | 2010-08-03 | Compact Disc | Rock | 18.98 | N | To Be Retired
Atlantic-Elektra | 75678998058 | Paramore | [NAME]! | 2010-08-03 | Compact Disc | Rock | 18.98 | N | To Be Retired
Atlantic-Elektra | 645131207623 | Paramore | All We Know Is Falling | 2010-08-03 | Compact Disc | Rock | 13.98 | N | To Be Retired
Spreadsheet: 4445fe5f-61c7-494c-9168-08899020cdd9
Sheet: TIG - Cohort 2 

Grant: |  | Tiered Intervention Grant
CFDA # |  | 84.388
GRANT NUMBER: |  | 7388
FISCAL YEAR: |  | 2011-12
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6905 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2012
Code | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2011 | AUGUST 2011 | SEPTEMBER 2011 | OCTOBER 2011 | NOVEMBER 2011 | DECEMBER 2011 | JANUARY 2012 | FEBRUARY 2012 | MARCH 2012 | APRIL 2012 | MAY 2012 | JUNE 2012 | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2012
0502 | Meadow Community School | 385256 |  |  |  |  |  |  |  |  |  |  |  | 52465 |  | 86513 | 62926 |  |  |  |  | 34796 | 7940
2876 | Fairview Elementary School | 459999 |  |  |  |  |  |  |  | 32327 | 27497 | 62723 | 37193 | 31707 | 39725 | 85393 | 35374 |  |  | 14687 |  | 56618 | 2107
3144 | FM Day Elementary School | 314883 |  |  |  |  |  |  |  | 44177 | 28928 | 34839 | 27524 | 11022 | 47074 | 11361 | 17062 |  |  | 25695 |  | 18065 | 31204
3272 | Fulton Elementary School | 287438 |  |  |  |  |  |  |  |  |  |  | 41057 | 44270 | 27854 | 39691 | 10729 | 17148 | 27034 |  | 43015 |  | 36640
5834 | Mesa Elementary School | 322594 |  |  |  |  |  |  |  | 24512 | 21264 | 53713 | 17625 | 31723 | 24173 | 17560 | 49999 |  |  | 21843 |  | 9504 | 8383
7860 | Sherrelwood Elementary School | 299599 |  |  |  |  |  |  |  | 8769 | 20499 | 36202 | 30653 | 18005 | 21579 | 22294 | 60806 |  |  | 10946 |  | 27661 | 38862
8143 | Spann Elementary School | 346498 |  |  |  |  |  |  |  |  |  |  |  | 61942 | 25607 | 24779 | 55255 |  |  |  | 12424
8909 | Trevista ECE-8 at Horace Mann | 563610 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144947 | 27036 | 86352 | 99148 |  |  | 206127
9462 | Westminster Elementary School | 263200 |  |  |  |  |  |  |  | 5375 | 19572 | 31898 | 27766 | 26551 | 3368 | 49064 | 30608 |  |  | 9054 |  | 32565 | 15238
Spreadsheet: 809050d1670859577-summary-pivot-table-from-more-extensive-data-data-query
Sheet: Expected Outcome

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2023-01-02 00:00:00 | Booked |  |  | Booked
2023-01-03 00:00:00 | None | Booked | None | None | Booked | None
2023-01-04 00:00:00 | Booked |  | Booked | Booked | Booked
2023-01-05 00:00:00 | Maybe | None | Maybe | Maybe | None | Maybe
2023-01-06 00:00:00 | Maybe | Booked | Booked | Booked | Maybe | Booked
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: Feb Abs Data 

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 328186d1403808401-sumproduct-with-different-sized-arrays-sumproductexample
Sheet: Sheet1

Code | Rank
1003 | 1
1004 | 2
1005 | 3
1007 | 4
1012 | 5
1014 | 1
1015 | 2
1016 | 3
1017 | 4
1018 | 5
1019 | 1