tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130525d1322415580-rotating-duty-roster-solver_assigning_staff
Sheet: Staff_asignment

 |  | Working |  |  | Administrating |  | Controll
Week1 |  | Day | Night | Twilight | Controller | P/L Reporter | [NAME]
 | WK | 0 | 0 | 0 | 0 | 0 | 0
 | YC | 0 | 0 | 0 | 0 | 0 | 0
 | IS | 0 | 0 | 0 | 0 | 0 | 0
 | CG | 0 | 0 | 0 | 0 | 0 | 0
 | SY | 0 | 0 | 0 | 0 | 0 | 0
 | LH | 0 | 0 | 0 | 0 | 0 | 0
Schduled |  | 0 | 0 | 0 | 0 | 0
Total need |  | 1 | 2 | 1 | 1 | 1
Difference |  | -1 | -2 | -1 | -1 | -1
Shortfall Object func. |  | -6
 | Not Available |  | WK | WK, SY | LH | LH, WK, YC
 | You got six persons to assign jobbs to during the week. WK, YC, IS, CG, SY, and LH
 | You need 1 person for day duty and 2 for night duty. You also need
 | 1 controller and 1 P/L reporter
 | Restrictions:
 | WK can't work nights
 | WK and SY can't work twilight
 | LH can't work as a controller
 | LH, WK and YC can't do P/L reporting.
 | Only 1 person doing 1 activity during the week. No dobble duty
 | Exceptions the the Controller can also do the P/L reporting
Spreadsheet: 853359d1703228517-make-formula-dynamic-dropdown-list-showing-blanks-dropdownlist
Sheet: D

Dropdown | Cond | Values
[0 - 10] |  | 7
[10 - 20] |  | 10
[20 - 30] |  | 25
[0 - 10] |  | 7
[40 - 50] |  | 47
[20 - 30] |  | 26
[60 - 70] |  | 65
[50 - 60] |  | 55
[50 - 60] |  | 53
[50 - 60] |  | 56
[50 - 60] |  | 59
[50 - 60] |  | 56
[50 - 60] |  | 50
[50 - 60] |  | 52
[50 - 60] |  | 57
[50 - 60] |  | 54
[50 - 60] |  | 55
[50 - 60] |  | 59
[50 - 60] |  | 56
[50 - 60] |  | 60
Spreadsheet: 876862d1723575543-count-if-formula-to-capture-count-of-ranges-book1-etaf
Sheet: Book

This section is a subjective score of the risk.
Category 1 | Category 2 | Score
2 | 5
3 | 4
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
2 | 3
2 | 4
3 | 3
2 | 5
3 | 4
3 | 5
4 | 4
4 | 5
5 | 5 |  | [NAME] --->
Spreadsheet: 839674d1692152171-formula-to-count-duplicate-value-as-one-test1
Sheet: Sheet1

Unit No. | Element |  | Wanted a formula to calculate the duplicate entry that match the creteria A3+B3 as one entry only
A-01-01 | wall |  | The result that I wanted as below
A-01-01 | wall
A-01-01 | window |  | A-01-01 | Wall | 1
A-01-01 | ceiling |  | A-01-01 | window | 1
A-01-01 | fixtures |  | A-01-01 | ceiling | 1
A-01-01 | wall |  | A-01-01 | fixtures | 1
A-01-01 | fixtures |  | A-01-01 | ceiling | 1
A-01-01 | ceiling
A-01-01 | ceiling
A-01-01 | ceiling
Spreadsheet: 218869d1362596512-help-with-double-lookup-between-two-files-exampledata
Sheet: file 2

File 2
Order number | Product name | User limit
SO-123 | Publication X | 12
SO-123 | Publication Z | 0
SO-123 | Publication Y | 1
SO-111 | Publication X | 1
SO-222 | Publication Z | 2
SO-222 | Publication X | 2
Spreadsheet: 117101d1312451374-excel-2007-too-many-if-statements-enter-account-manager-name-depending-on-adjacent-cell-text-xlquery
Sheet: Sheet1

Client | Account Manager
Client 1 | [NAME]
Client 1 | [NAME]
Client 1 | [NAME]
Client 1 | [NAME]
Client 1 | [NAME]
Client 1 | [NAME]
Client 1 | [NAME]
Client 1 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Client 2 | [NAME]
Spreadsheet: 90b26403-ffdd-42dd-9953-ffc7946e2df9
Sheet: 1.8 Jobseekers

1.8 Jobseekers receiving allowances
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014–15
Newstart Allowance and Youth Allowance (other) recipients (a) – '000
July | 338.799 | 314.636 | 339.267 | 411.513 | 413.883
August | 319.562 | 303.978 | 330.774 | 393.998 | 402.971
September | 310.168 | 299.463 | 330.406 | 384.521
October | 302.88 | 297.779 | 332.902 | 383.962
November | 297.995 | 296.112 | 335.427 | 385.236
December | 318.512 | 317.239 | 349.782 | 406.703
January | 336.31 | 335.704 | 404.566 | 428.16
February | 340.795 | 339.475 | 405.688 | 425.617
March | 324.928 | 332.933 | 385.105 | 417.523
April | 319.681 | 332.39 | 394.889 | 415.459
May | 317.719 | 330.686 | 400.5 | 417.595
June | 315.567 | 332.022 | 406.759 | 417.277
Annual average | -14.80482051645856 | -0.2732039940503461 | 15.22924045060859 | 10.67690353289637
Annual change – per cent
July | -20.75563050683333 | -7.131957296213966 | .. | 21.29473246734874 | 0.5759234823687234
August | -20.02392560039242 | -4.876674948836221 | .. | 19.11395696155078 | 2.277422728034156
September | -20.03114517829841 | -3.451355394495881 | .. | 16.37833453387649
October | -19.43759525690438 | -1.684165346011621 | .. | 15.33784717424345
November | -18.6204014976282 | -0.6318897968086651 | .. | 14.84943072561242
December | -15.70679242686484 | -0.3996709700105567 | .. | 16.27327878507182
January | -13.55320959188971 | -0.1801908953049254 | .. | 5.831928535764235
February | -10.3598023046917 | -0.3873296263149381 | .. | 4.91239573268128
March | -10.96350612980835 | 2.463622710261964 | .. | 8.417963931914674
April | -9.846925250565437 | 3.975525602084579 | .. | 5.209058748154543
May | -8.219589627151743 | 4.081279369505753 | .. | 4.268414481897635
June | -7.410841340864074 | 5.214423561399 | .. | 2.585806337413561
Annual average | -14.80482051645856 | -0.2732039940503461 | 15.22924045060859 | 10.67690353289637
(a) Includes jobseekers receiving Youth Allowance (other).
 |  |  |  |  |  |  |  | Update
Source: Department of Social Services, Labour market and related payments: a monthly profile |  |  |  |  |  |  |  | 2014-10-10 00:00:00
Spreadsheet: 734082d1621969146-index-match-formula-to-conditionally-compile-missing-data-index-match-formula-to-pull-missing-data-example
Sheet: FCST

Concat | Revenue Type | Product | Customer
 | Issue Fee | Product A | Customer D
 | Saleable Item | Product B | Customer F
 | Saleable Item | Product C | Customer A
 | Issue Fee | Product A | Customer B
 | Saleable Item | Product A | Customer Y
 | Saleable Item | Product A | Customer X
 | Issue Fee | Product A | Customer G
 | Issue Fee | Product A | Customer H
 | Issue Fee | Product A | Customer I
 | Saleable Item | Product A | Customer K
 | Issue Fee | Product A | Customer A
Spreadsheet: 134181d1325079548-create-outlook-calander-entry-from-excel-weekly-planner-weekly-planner-to-sync-with-outlook
Sheet: Current Week 

Weekly Customer Prospect Report
SALESMAN : |  | [NAME] |  |  |  |  | Week Starting: |  | 2011-11-21 00:00:00
 |  |  |  |  |  |  |  |  |  | Saturday | Sunday
Location: | Wudnna |  | Wudinna |  | [NAME] |  | Kimba |  | Pt Kenny
08:00:00 | Branch Meeting |  | Cook AMS Quote |  | Annual Leave |  | JP Citizen AMS Quote |  | Follow up New Machine Owners
09:00:00 | [NAME]
10:00:00 | Customer Demonstration - S670 |  | Customer Demonstration - S670
11:00:00 |  |  |  |  |  |  | Arrange Customer Finance Papers
12:00:00
13:00:00
14:00:00 |  |  | Jones 9530, S660 Quotes |  |  |  | Murphy Tractor Delivery
15:00:00
16:00:00
17:00:00
18:00:00
Spreadsheet: 763660d1642302581-using-filter-function-to-ignore-n-a-filter-function-to-ignore-na
Sheet: Sheet1

Refrence | Description: | Stock No: | Status: | [NAME] (Days): | Maturity Date: | Value: | Branch |  |  |  |  |  |  |  |  | Branch |  |  |  |  |  |  |  |  | Br1
KN1XXMTKGMA0 |  | A001 | In Stock |  |  | 14862.42 | #N/A |  |  |  |  |  |  |  |  | Br1 |  |  |  |  |  |  |  |  | Br2
KN1XXMJ2NMC3 |  | A002 | In Stock |  |  | 26736.85 | BR1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Br3
[NAME] |  | A003 | In Stock |  |  | 14921.82 | #N/A
KN1XXMRKAMK7 |  | A004 | In Stock |  |  | 19486.21 | BR1 |  |  |  |  |  |  | Refrence | Value: | Branch
KN1XXMRKAMK6 |  | A005 | In Stock |  |  | 18233.99 | BR2
KN1XXMRKAMK7 |  | A006 | In Stock |  |  | 19486.21 | BR3
KN1XXERK1MK8 |  | A007 | In Stock |  |  | 21019.87 | BR3
Spreadsheet: 266821d1379767542-changing-the-cell-colour-based-on-what-is-input-in-another-cell-book8
Sheet: Sheet1

Amount | Paid | Color
50 | N | 50
75 | N | 75
85 | Y | 85
90 | Y | 90
12 | N | 12
51 | Y | 51
70 | N | 70
Spreadsheet: 219427d1362757114-look-for-earliest-date-in-a-list-of-cells-housedecay
Sheet: Sheet1

house | sw end | fw start | fw end | gw start | gw end | idoc start | GW check | [NAME]
nexus | 2013-03-06 09:00:00 | 2013-03-06 10:00:00 | 2013-03-07 09:00:00 | 2013-03-07 10:00:00 | 2013-03-08 09:00:00 | 2013-03-08 10:00:00
fall window
fall window
fall window
fall window
fall window
green cells only cells that can be edited rest are locked
with a time missing in any of the min search cells (C3, C5, C7, C9…)it chooses 1/1/1900 as oldest date
Spreadsheet: richard_shapiro__32139__rcr-budget-status-report
Sheet: Sheet1

Cost Center Owner | RCR Budget | [NAME] to Date | RCR Available to Date
Steffes | 1801200
Nord | 750000
[NAME] | 1140000
Kaufman | 398000
Ryall | 162350
Migden | 471000
[NAME] | 590000
Montovano | 575000
Dadson | 352000
Charvel | 110000 | 0
Yoho | 265000
Guerrero | 0 | 44000 | -44000
TOTAL
Spreadsheet: 822065d1679072355-count-the-number-of-instances-of-a-value-in-one-column-based-on-a-value-in-another-sample
Sheet: Occurences

Date | ID/Associate # | Associate Name | Occ. Type | Age (Days old) | Points | Notes
2022-12-01 00:00:00 | 111111 |  | Absent - Failure to Report
2022-12-15 00:00:00 | 555555 |  | Early Quit - Worked LESS than 1/2 Scheduled Day
2023-01-15 00:00:00 | 777777 |  | WLBD
2023-01-17 00:00:00 | 777777 |  | WLBD2
2022-11-02 00:00:00 | 999999 |  | Absent - Failure to Report
2022-12-02 00:00:00 | 999999 |  | Absent - Failure to Report
2023-02-02 00:00:00 | 999999 |  | Absent
2023-02-03 00:00:00 | 111119 |  | Absent - Failure to Report
2023-02-04 00:00:00 | 111119 |  | Absent
2022-11-15 00:00:00 | 111115 |  | Absent - Failure to Report
2022-12-15 00:00:00 | 111115 |  | Absent - Failure to Report
2023-01-15 00:00:00 | 111115 |  | Absent
2023-03-01 00:00:00 | 999999 |  | Absent
2023-01-01 00:00:00 | 111111 |  | Tardy
2023-02-01 00:00:00 | 111111 |  | Tardy
Spreadsheet: 329314d1404263322-filtering-out-valid-and-invalid-entries-filtered-scenario-1-
Sheet: DESIRED OUTPUT

[NAME] | CELLULARPHONE | REMARKS
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 7092700/[PHONE] | Valid
SAMPLE COMPANY | 7092700/[PHONE] | Valid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 027123465
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | [PHONE]
SAMPLE COMPANY | [PHONE]
SAMPLE COMPANY | 6715580
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 029212535
SAMPLE COMPANY | 029212535
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 023550412 | Invalid
SAMPLE COMPANY | 023550412 | Invalid
SAMPLE COMPANY | 026540335
SAMPLE COMPANY | 026540335
SAMPLE COMPANY | NONE | Invalid
SAMPLE COMPANY | NONE | Invalid
SAMPLE COMPANY | 822984297
SAMPLE COMPANY | 822984297
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | [PHONE]
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 024707418
SAMPLE COMPANY | 024707418
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | NONE | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 647-41-34
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY | 028131321
SAMPLE COMPANY |  | Invalid
SAMPLE COMPANY |  | Invalid
Spreadsheet: 88780d1288631531-shift-value-up-without-shifting-cells-up-shift_up
Sheet: Sheet1

 |  |  |  |  |  |  |  | Starting List consisting of (6) different ranges
 | 5 |  | 3030 Horizontal Slide Window - Mill Finish
 | 3 |  | 3030 Vertical Slide Window - Mill Finish
 |  |  |  |  | 2 |  | 3x3 Louver w/ [NAME]
 | 6 |  | 9" x 10`-0 Ridge Vent - Galvalume w/ Damper
 |  |  |  |  | 24 |  | Super Span 10-8 UL Skylight Package
 | 1 |  | 3070 (G) Walkdoor (w/ Lever Lockset)
 | 1 |  | 3070 (LV) Walkdoor (w/ Lever Lockset)
 | 1 |  | 3070 (M) Walkdoor (w/ Lever & Deadbolt) |  | 3 |  | 4`-6 x 4`-0 Door Canopy [NAME]
 |  |  |  |  |  |  |  | Shift Data Up to get rid of blank values
 | 5 |  | 3030 Horizontal Slide Window - Mill Finish |  | 2 |  | 3x3 Louver w/ [NAME]
 | 3 |  | 3030 Vertical Slide Window - Mill Finish
 | 6 |  | 9" x 10`-0 Ridge Vent - Galvalume w/ Damper |  | 24 |  | Super Span 10-8 UL Skylight Package
 | 1 |  | 3070 (G) Walkdoor (w/ Lever Lockset) |  | 3 |  | 4`-6 x 4`-0 Door Canopy [NAME]
 | 1 |  | 3070 (LV) Walkdoor (w/ Lever Lockset)
 | 1 |  | 3070 (M) Walkdoor (w/ Lever & Deadbolt)
Spreadsheet: 764094d1642587222-month-to-month-expenditure-tally-if-then-logic-preppy_prince-budget_example_v1
Sheet: JAN

EXPENDITURE
Float | Available | Total Spent
Value | Date | Notes
20 | 2022-01-01 00:00:00
50 | 2022-01-07 00:00:00
200 | 2022-01-11 00:00:00
80 | 2022-01-14 00:00:00
150 | 2022-01-17 00:00:00
Spreadsheet: 675788d1588494134-single-answer-from-variable-drop-down-menus-colours
Sheet: Sheet1

 | a | b | c | d
RED - 1 | 10 | 20 | 30 | 40
RED - 2 | 15 | 30 | 45 | 60
RED - 3 | 12 | 24 | 36 | 54
RED - 1 | a
Spreadsheet: 43536d1242179333-more-advanced-ebay-spreadsheet-ebay-calc
Sheet: Shipping

 |  | CODE | PACKAGE TYPE | SIZE |  | PACKAGE COST | SHIPPING COST |  | TOTAL COST |  | SOURCE
 |  | FRE | Flat Rate Envelope | 12.5 X 9.5 |  | 0 | 4.8 |  |  |  | USPS
 |  | FRS | Flat Rate Small Box | 5.5 X 5.75 X 1.75 |  | 0 | 4.95 |  |  |  | USPS
 |  | FR1 | Flat Rate Box | 12 X 3.5 X 13.75 |  | 0 | 10.35 |  |  |  | USPS
 |  | FR2 | Flat Rate Box | 11 X 8.5 X 5.5 |  | 0 | 10.35 |  |  |  | USPS
 |  | FRL | Flat Rate Large Box | 12 x 12 x 5.5 |  | 0 | 10.95 |  |  |  | USPS
Spreadsheet: 125278d1318952319-cell-value-when-entering-another-character-testerhelpxinformula
Sheet: Sheet1

PART NO. | DEFAULT | SUPPLIERS | WELDER SERIES | LUCKY 7 | BILLET | CRAWFORD PERF. | ROADSTER SHOP | MAKE & MODEL | MODEL A | 1932 FORD | 1967 69 F BODY | CORVETTE | PARTS DEPT. | FRONT SUSPENSION | REAR SUSPENSION | BODY PANELS | APPAREL | SHIRTS | HATS | JACKETS | CODE:
 | 2 | 3 | 7 | 9 | 17 | 18 | 30 | 4 | 11 | 12 | 13 | 48 | 5 | 31 | 32 | 58 | 6 | 43 | 44 | 45
ATM 101 | x | x |  | x |  |  |  | x |  |  |  | x | x |  | x |  |  |  |  |  | 2,3,9,10, 4,48, 5,32
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
Spreadsheet: 157074d1337610453-excel-2007-lookup-to-return-multiple-rows-of-data-test-template
Sheet: Job 2

 | # | Date | Description | Requested | Spent
 | 1 | 2010-02-21 00:00:00 | Expense | 6000
 | 1 | 2010-01-22 00:00:00 | Office |  | 4000
 | 1 | 2011-02-25 00:00:00 | Misc |  | 2000
 | 1 | 2010-11-18 00:00:00 | Misc |  | 324
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 2 | 5/11/12 | Expense | 3096 | 3096
 | 2 | 5/9/10 | Office | 20000
 | 2 | 5/7/12 | Misc | 10000 | 9107.4
 | 2
 | 2
 | 2
 | 2
 | 2
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 3 | 2011-02-04 00:00:00 | Carpet Repair | 50 | 50
 | 3 | 2011-04-06 00:00:00 | Cleaning | 125 | 125
 | 3 |  | Tile | 2064 | 2064
 | 3 |  | Advertising | 10000 | 10197.14
 | 3
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 4
 | 4
 | 4
 | 4
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 5
 | 5
 | 5
 | 5
 | 5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 6
 | 6
 | 6
 | 6
 | 6
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
Spreadsheet: 12ee9089-c7ca-44bc-b5ea-e16b55f959dd
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | School Year 2011-2012 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Fiscal Yr 2013 Payment)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev. 12/2012
Center for Student Support and Education Options
Office of  Quality School Choice and Funding
Report of Additional State Aid for School Age Catastrophic Cost Special Education ADM1
Due in Regional Office by March 15
Section I - Header Information
Resident School District Name
Resident School District County |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resident School District IRN
Student Name2
Disability Condition:
Category 2 |  |  |  |  | LD |  |  |  | CD |  |  |  |  |  |  | OHH (minor)
Category 3 |  |  |  |  | ED |  |  |  | HI
Category 4 |  |  |  |  | VI |  |  |  | OHI(major)
Category 5 |  |  |  |  | MD |  |  |  | OI
Category 6 |  |  |  |  | AU |  |  |  | TBI |  |  |  |  |  |  | DB
Section II - Special Education Costs
Description of Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost
Line   1. |  |  | Salary - Special/Regular Education Teacher(s) - (itemize)
Line   2. |  |  | Admin/Supervisor Expense (itemize on attachment)
Line   3. |  |  | Classroom Utilization/Lease Expense
Line   4. |  |  | Maintenance, Operation Utilities Expense
Line   5. |  |  | Supplies/Material Expense
Line   6. |  |  | Equipment Expense
Line   7. |  |  | Remodeling Expense
Line   8. |  |  | Related Services (itemize on attachment)
 | (A)
 | (B)
 | (C)
 | (D)
Line   9. |  |  | Contracted Services (attach contract)
Line 10. |  |  | Total Educational Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Section III - Signatures
I have read and understand Ohio Revised Code 3317.022, have read and understand the instructions for this form and
certify this submission is in accordance with required statutes.
Superintendent Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  | Treasurer Signature |  |  |  |  |  |  |  |  |  |  |  | Date
ODE USE ONLY
ODE REGION |  |  |  |  |  | 1 |  |  | 02 |  |  | 3 |  |  | 4 |  |  |  | 5
 |  |  |  |  |  | 6 |  |  | 07 |  |  | 8 |  |  | 8 |  |  |  | 10
Supporting documentation
Coordinator approval and date
1This form is filed by the school district responsible for costs of educating the special education student.  Please see the form instructions for
additional details about this form.
2One student only may be entered on this line.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | special education cat cost form.doc
Spreadsheet: 599187d1542892776-help-lookup-function-to-reconcile-receipts-against-bank-transactions-test-reconcille
Sheet: Bank Transactions

Column3 | Column4 | Name | Money In | Money Out | Account Number | Business Expense | Date
130 | 2017-11-10 00:00:00 | [NAME] |  | 130 | 1
130 | 2016-03-05 00:00:00 | Frankies |  | 130 | 3
47 | 2018-09-08 00:00:00 | Guitar |  | 47 | 4
5 | 2016-11-07 00:00:00 | Bike |  | 5 | 3
10 | 30/2/16 | Bus |  | 10 | 1
Spreadsheet: john_lavorato__16564__NFL Bets
Sheet: Summary Sheet

 |  |  | Lavorato Charity Fund - Summary Report
 |  | NFL Bets | [NAME] | Other | NFL Total | Golf Total | Totals
 | Week 1 | No Bet
 | Week 2 |  | 360
 | Week 3 |  | 0
 | Week 4 |  | 0
 | Week 5 |  | 0
 | Week 6
 | Week 7 |  | 0 | 0
 | Week 8 |  | 0 | 0
 | Week 9 |  | 0 | 0
 | Week 10
 | Week 11
 | Week 12
 | Week 13
 | Week 14
 | Week 15
 | Week 16
Spreadsheet: 058f5d2a-9fff-49d3-9a58-baa4f5f5abaa
Sheet: Sheet1

STATE OF WEST VIRGINIA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
OFFICES OF THE INSURANCE COMMISSIONER
HEALTH ENTITIES PRODUCT MIX REPORT
Company Name: |  |  |  |  |  |  |  |  | For Year/Quarter Ending:
 | PEIA |  |  | Medicaid - WV |  |  | Medicare - WV |  |  | Commercial - WV |  |  | Total - WV
Medical Expense |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
Administrative Expense |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
Combined Expense |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
Administrative Payable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
Claims Payable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
IBNR |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
Combined Payable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
Premium Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
÷ Premium Income | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ |  |  | ÷ | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 61805d1262727473-trying-to-avoid-long-if-statement-example-1-1-
Sheet: Option 2

Material Estimating
Project:
 | Duct Size |  |  |  | Footage
Fire Rating | W (in.) | H (in.) | Lgth (ft) | Total (ft2) | Required
Round 2-hr | 12 | 12 | 100 | 314.16 | 927.4844444444443
Vent 1-hr | 10 | 10 | 50 | 166.6666666666667 | 204.1666666666667
Round 2-hr | 36 | 24 | 12 | 113.0976 | 287.2277333333333
Grease 2-hr | 14 | 14 | 75 | 350 | 933.3333333333334
Vent 2-hr | 8 | 10 | 1000 | 3000 | 7666.666666666667
Round 1-hr | 8 | 8 | 47 | 98.4368 | 142.2596
Round 1-hr | 12 | 12 | 8 | 25.1328 | 33.98826666666666
Round 2-hr | 36 | 36 | 8 | 75.3984 | 191.4851555555555
Grease 2-hr | 48 | 36 | 32 | 448 | 1095.111111111111
Vent 2-hr | 16 | 18 | 14 | 79.33333333333333 | 188.2222222222222
Grease 2-hr | 24 | 27 | 60 | 510 | 1283.333333333333
Vent 1-hr | 48 | 42 | 1250 | 18750 | 22118.05555555555
 |  |  |  | Total: | 35071.33408888889
[NAME]
Grease 2-hr:
Vent 1-hr:
Vent 2-hr:
Round 1-hr:
Round 2-hr:
Grease 2-hr:
Vent 1-hr:
Vent 2-hr:
Round 1-hr:
Round 2-hr:
Spreadsheet: 95059d1294762515-need-2-x-ticker-label-moving-text-from-right-to-left-linked-dynamically-to-dropdown-multilookup-sort-1-
Sheet: Chk

 | TOTAL SUMM ASSURED : Rupees Eight Lac Ninety Five Thousand  Only |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MODE
 | TOTAL PREMIUM : Rupees One Lac Eight Thousand  Only
15 | 'S'! | Sachin Pradhan |  | [NAME] | 6 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SGL
 | Sr.No | Date of  Comm | POLICY NO | DO's CODE for SORTING | POLICY NO |  | Interest |  |  |  |  |  |  |  |  |  |  | HLY
5 | 1 | 2004-06-28 00:00:00 | 791787833 | 1900-01-01 00:00:00 | 2005-02-15 00:00:00 | 2004-06-28 00:00:00 |  | 762667566 | 762667566 |  |  |  |  |  |  |  |  | QLY
6 | 2 | 2005-02-15 00:00:00 | 792997163 | 1900-01-01 00:00:00 | 2005-02-15 00:00:00 | 2005-02-15 00:00:00 |  | 762667567 | 762667567 |  |  |  |  |  |  |  |  | ECS
2 | 3 | 2005-02-15 00:00:00 | 792969818 | 1900-01-01 00:00:00 | 2004-06-28 00:00:00 | 2005-02-15 00:00:00 |  | 762383788 | 762383788
9 | 4 | 2005-07-20 00:00:00 | 792969819 | 1900-01-01 00:00:00 | 2006-06-21 00:00:00 | 2005-07-20 00:00:00 |  | 762666858 | 762666858
10 | 5 | 2006-06-21 00:00:00 | 792383786 | 1900-01-01 00:00:00 | 2006-06-21 00:00:00 | 2006-06-21 00:00:00 |  | 762666856 | 762666856
8 | 6 | 2006-06-21 00:00:00 |  | 2005-02-15 00:00:00 | 2005-07-20 00:00:00 | 2006-06-21 00:00:00 |  | 762986286 | 762986286
 |  |  |  | 2005-02-15 00:00:00 |  | #N/A
 |  |  |  | 2005-02-15 00:00:00 |  | #N/A
 |  |  |  | 2005-02-15 00:00:00 |  | #N/A
 |  |  |  | 2004-06-28 00:00:00 |  | #N/A |  |  |  |  |  |  |  |  |  |  | 2 | Arvind Deshmukh
 |  |  |  | 2006-06-21 00:00:00 |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | Sachin Pradhan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]