tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155269d1336747707-how-to-fill-in-cells-with-reference-column-an-row-sample-excelforum
Sheet: Sheet1

name | leeftijd | studie | Hoeveel | Auto | Sporten | Reporten | Werk
[NAME] | 20 | ja | 55 | ja | hockey | 8 | ja
pieter | 21 | nee | 546 | nee | voetbal | 6 | nee |  |  | Use the the upper row and the most left column to fill in the data in sheet 2
jan | 34 | ja | 452 | ja | ijshockey | 56 | ja
[NAME] | 32 | nee | 41 | nee | voetbal | 3 | ja
gerard | 23 | nee | 6 | nee | basketball | 8 | ja
reinier | 45 | ja | 1 | ja | autorijden | 43 | ja
johannes | 53 | nee | 364 | nee | tennis | 4 | ja
joop | 22 | ja | 1 | ja | paardrijden | 6 | nee
antoon | 24 | ja | 6 | ja | bowlen | 4 | nee
didier | 56 | nee | 4 | ja | voetbal | 96 | nee
Spreadsheet: 587902d1535381513-non-volatile-alternative-to-sumifs-indirect-formulas-dummy-workbook
Sheet: DataSheet4

 | 2014-06-30 00:00:00 | 100
 | 2014-07-07 00:00:00
 | 2014-07-14 00:00:00
 | 2014-07-21 00:00:00
 | 2014-07-28 00:00:00
 | 2014-08-04 00:00:00
 | 2014-08-11 00:00:00
 | 2014-08-18 00:00:00
 | 2014-08-25 00:00:00
 | 2014-09-01 00:00:00
 | 2014-09-08 00:00:00
 | 2014-09-15 00:00:00
 | 2014-09-22 00:00:00
 | 2014-09-29 00:00:00
 | 2014-10-06 00:00:00
 | 2014-10-13 00:00:00
 | 2014-10-20 00:00:00
 | 2014-10-27 00:00:00
 | 2014-11-03 00:00:00
 | 2014-11-10 00:00:00
 | 2014-11-17 00:00:00
 | 2014-11-24 00:00:00
 | 2014-12-01 00:00:00
 | 2014-12-08 00:00:00
 | 2014-12-15 00:00:00
 | 2014-12-22 00:00:00
 | 2014-12-29 00:00:00
 | 2015-01-05 00:00:00
 | 2015-01-12 00:00:00
 | 2015-01-19 00:00:00
 | 2015-01-26 00:00:00
 | 2015-02-02 00:00:00
 | 2015-02-09 00:00:00
 | 2015-02-16 00:00:00
 | 2015-02-23 00:00:00
 | 2015-03-02 00:00:00
 | 2015-03-09 00:00:00
 | 2015-03-16 00:00:00
 | 2015-03-23 00:00:00
 | 2015-03-30 00:00:00
 | 2015-04-06 00:00:00
 | 2015-04-13 00:00:00
 | 2015-04-20 00:00:00
 | 2015-04-27 00:00:00
 | 2015-05-04 00:00:00
 | 2015-05-11 00:00:00
 | 2015-05-18 00:00:00
 | 2015-05-25 00:00:00
 | 2015-06-01 00:00:00
 | 2015-06-08 00:00:00
 | 2015-06-15 00:00:00
 | 2015-06-22 00:00:00
 | 2015-06-29 00:00:00
 | 2015-07-06 00:00:00
 | 2015-07-13 00:00:00
 | 2015-07-20 00:00:00
 | 2015-07-27 00:00:00
Spreadsheet: 774255d1648334752-create-a-reference-formula-impact_statement
Sheet: Package Estimate

 | Package Estimate
 |  | Employee Name | [NAME] (5) |  | Date |  | 21/03/2022 |  | Payroll Number
 |  | Employer | Department of Immigration and Border Protection |  | Reference |  | 100218 |  | Pay Cycle | Fortnightly
 |  | Location, State |  |  | Consultant
 |  | Contact Phone | 0 |  | Contact Phone
 |  | [NAME] | [EMAIL] |  | [NAME]
 |  | [NAME]
 |  | Item | Description | Effective Date | Type | Pre-Tax |  | Post-Tax
 |  |  | Childcare | 22/03/2022 |  |  |  |  |  |  |  |  |  |  |  | 0.00 | 384.61
 |  |  | Home Office Expenses | 22/03/2022 |  |  |  |  |  |  |  |  |  |  |  | 0.00 | 23.07
 |  |  | Portable Electronic Devices | 22/03/2022 |  |  |  |  |  |  |  |  |  |  |  | 0.00 | 96.15
 |  |  | Superannuation | 22/03/2022 |  |  |  |  |  |  |  |  |  |  |  | 0.00 | 230.76
 |  |  | Novated Lease - Salary Packaged | 22/03/2022 |  |  |  |  |  |  |  |  |  |  |  | 0.00 | 461.53
 |  |  | Administration Fee | 22/03/2022 |  |  |  |  |  |  |  |  |  |  |  | 0.00 | 24.46
 |  |  |  | No Packaging |  |  |  |  | Proposed Package
 |  | Salary
 |  | Super (SGC)
 |  | Employer Super
 |  | TEC
 |  | Employee Super
 |  | Benefits: Pre-Tax
 |  | GST/ITC (nett addition)
 |  | Taxable Income
 |  | Income Tax & Medicare
 |  | Post-Tax (EC)
 |  | FBT Payable
 |  | HELP Debt
 |  | Net Income
 |  | Add Back Benefits
 |  | Total Net Income
 |  | Payment Confirmation
 |  | Item | Description | Total | Pmts | Type | Account Name |  | BSB | Account No
 |  |  |  |  | 1 | recurring |  |  | 063-594 | 111111
 |  |  |  |  | 1 | recurring |  |  | 063-594 | 111111
 |  |  |  |  | 1 | recurring |  |  | 063-594 | 111111
 |  |  |  |  | 1 | recurring |  |  | 063-594 | 111111
 |  |  |  |  | 1 | periodic
 |  |  |  |  | 1 | recurring
 |  | Employee Authority to Proceed
 |  | Employee Name |  | Signature |  |  |  |  | Date
Spreadsheet: 31760d1227710325-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: December

DECEMBER | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 011bde9b-ea3a-4bd0-9e94-2d590e0d1a03
Sheet: July

Year End: | July
Year:
Monthly CACFP Reimbursement:
Monthly Food Program Expenses:
Amount Needed from Other Funding Source:
Date | Check Number | Name (Payee on Check) | Total Amount of Check | Administrative Salaries and Benefits | Travel Expenses (include monitoring staff) | Printing, Office Supplies, Communications | Staff Training | Food Service Salaries and Benefits | Food (include delivery charges) | Purchased Vended Meals | Food Service Equipment | Allowable Nonfood Supplies | Occupancy/ Utilities | [NAME]. | Specify Misc.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Monthly CACFP Expenses:
End of worksheet
Spreadsheet: 860240d1708421245-if-formula-to-read-if-dropdown-matches-table-brings-it-into-another-table-at-top-sample-243-aligw
Sheet: Sheet1

Field One |  | Lookup & Return Table |  | Table I want formula to rad
NSW |  | Jurisdiction |  | Read formula
 |  | ACT |  |  |  |  |  |  | Where ever the text is in Column C, I need it to star here in column E
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | ACT |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
Spreadsheet: 61108d1261768367-numerous-if-conditions-gpa-conversion-gpa-calculator-2
Sheet: Sheet2

Table of Grade values
50 | F
60 | D-
63 | D
67 | [NAME]
70 | C-
73 | C
77 | C+
80 | B-
83 | B
87 | [NAME]
90 | A-
93 | A
Spreadsheet: 470224d1468403128-date-format-change-date-format-aligw
Sheet: Sheet1

VersionDate
Feb  3 2016  5:44PM
Jun  3 2014  5:51PM
Apr  9 2015  9:23PM
Mar 17 2016 12:35PM
Jun  9 2016 12:13PM
Jun 16 2016  7:14PM
Apr  9 2015  9:23PM
Apr  9 2015  9:23PM
Apr  9 2015  9:23PM
Mar 17 2016 12:35PM
Mar 17 2016 12:35PM
Mar 17 2016 12:35PM
Jan 25 2016  [NAME]
Feb 13 2014  3:22PM
Feb 11 2014  2:42PM
Sep 29 2014  7:01PM
Sep 24 2015  6:06PM
Nov 26 2014  9:55PM
Sep 24 2014 11:49AM
2016-02-03 00:00:00
Spreadsheet: 768944d1645209643-counting-cells-based-on-part_work_order-and-route_step_num-excel-question
Sheet: Sheet1

Part_Work_Order | Route_Step_Num | Cell |  |  |  | Cell: | Count:
1RRR | 3 | Saw1 |  |  | 0 | Saw1 |  | Correct vaules from rows 2 to 14. |  |  |  |  |  | Cell: | Count:
1RRR | 5 | Inspection |  |  | 1 | Inspection |  |  |  |  |  |  |  | Saw1
1RRR | 1 | Saw1 |  |  | 1 | Saw2 |  |  |  |  |  |  |  | Inspection
[NAME] | 2 | Saw1 |  |  |  | Ground |  |  |  |  |  |  |  | Saw2
[NAME] | 4 | Inspection |  |  |  | Ship |  |  |  |  |  |  |  | Ground
[NAME] | 5 | Saw1 |  |  |  |  |  |  |  |  |  |  |  | Ship
[NAME] | 6 | Saw1 |  |  |  | Only counts as 1 because in sequence.
[NAME] | 8 | Saw1
[NAME] | 11 | Saw2
[NAME] | 12 | Saw2
[NAME] | 13 | Ground
[NAME] | 15 | Ground
[NAME] | 16 | Ship
3FFF | 2 | Ship
3FFF | 3 | Saw1
3FFF | 1 | Ship
3FFF | 5 | Saw1
3FFF | 8 | Inspection
3FFF | 9 | Ship
4GGG | 3 | Saw1
4GGG | 4 | Saw1
4GGG | 5 | Saw1
4GGG | 6 | Saw1
4GGG | 8 | Inspection
4GGG | 10 | Inspection
4GGG | 11 | Inspection
4GGG | 12 | Inspection
4GGG | 13 | Saw1
4GGG | 14 | Saw1
4GGG | 15 | Saw1
4GGG | 16 | Saw2
4GGG | 17 | Saw2
4GGG | 18 | Saw2
4GGG | 19 | Saw2
4GGG | 21 | Ground
4GGG | 22 | Ground
4GGG | 23 | Ship
Spreadsheet: larry_campbell__20978__PCB Graphs
Sheet: 0.55B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 1999-11-03 00:00:00 |  |  | 14 |  | Sherwood
0.55 B side |  |  | 1999-11-18 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 1999-11-24 00:00:00 |  |  | 44 |  | Sherwood
 |  |  | 1999-12-01 00:00:00 |  |  | 47 |  | Sherwood
 |  |  | 1999-12-08 00:00:00 |  |  | 30 |  | Sherwood
 |  |  | 1999-12-14 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 1999-12-29 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-01-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-01-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-02-09 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-03-01 00:00:00 |  |  | 23 |  | Sherwood
 |  |  | 2000-03-22 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-04-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 13 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 5 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 801624d1666275827-formula-not-calculating-mrp-test
Sheet: PASTE IN

 |  |  | WEEK 1 |  |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  |  | WEEK 4
 | KLN | [NAME] | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 | D01665 | [NAME] |  | 7031 | 6441 | 8879
 | D01700 | [NAME] |  | 45680 | 25560 | 31428
 | D00101 | Kro 3.25-Gal |  | 23118 | 23665 | 23930
 | D02315 | [NAME] |  | 5698 | 3920 | 5990
 | D01661 | Kro 1%-HG |  | 1894 | 2590 | 3074
 | D01600 | Kro 2%-HG |  | 14984 | 19446 | 12090
 | D00601 | Kro 3.25-HG |  | 4038 | 4802 | 8199
 | D02305 | [NAME] |  | 5055 | 1079 | 3041
 | D07851 | [NAME] |  | 1035 | 995 | 996
 | D07849 | [NAME] 2%-Gal |  | 3004 | 4016 | 5037
 | D07852 | [NAME] 3.25%-Gal |  | 2001 | 2511 | 3007
 | D07850 | [NAME] |  | 796 |  | 1009
 | D07835 | [NAME] 1% HG |  |  | 545 | 1007
 | D07853 | [NAME] 2% HG |  | 431 |  | 1993
 | D07836 | Roundy 3.25%  HG |  |  |  | 1203
 | D07834 | [NAME] |  |  |  | 869
 | D03266 | Kro 3.25 Choc-HG |  | 4341 | 3024
 | D56032 | Kro LF Choc-Gal |  | 6400 | 4090 | 5986
 | D56033 | Kro LF Choc-HG |  | 5711 | 3621 | 6709
 | D07848 | [NAME] Gal |  |  |  | 516
 | D07847 | [NAME] |  | 443 | 404 | 435
 | D02701 | Kro LF B'milk-HG
 | D02712 | [NAME] |  |  |  | 3936
 | D08820 | Kr Orange Juice-Gal |  |  | 2955 | 1957
 | D08822 | Kr Orange Juice-HG |  | 10384 | 8158 | 3111
 | D08815 | [NAME]
 | D08902 | [NAME] |  | 6099 | 5475 | 4141
 | D08819 | [NAME]
 | D08621 | [NAME] |  |  | 1976
 | D08626 | [NAME] |  |  | 6072
 | D09131 | Kro SIP Fruit Punch - Gal
 | D09132 | Kro SIP Orange - Gal
 | D07823 | Tamp Citrus-Gal |  |  | 1841
 | D07803 | [NAME]
 | D07816 | Tamp Mango-Gal
 | D07828 | Tamp Tropical-Gal
 | D09225 | Kro Caffeinated Sweetened Iced Tea |  |  | 1954
 | D08965 | Kro Diet Decaf Tea-Gal |  |  |  | 1944
 | D08395 | Kro Lemonade/Tea-Gal |  |  | 1996
 | D08960 | Kro Sweet Tea-Gal |  |  | 1897 | 2959
 | D08957 | Kro Unsweet Tea-Gal
 | D09330 | KRO HG CAFFINATED SWEET TEA
 | D03040 | KRO HG DECAF SWEET TEA
 | D02124 | [NAME] |  | 4970 | 9119 | 12095
 | D02123 | [NAME] |  | 11218 |  | 5293
 | D02125 | Kro Spring-Gal |  |  | 22905 | 23992
 | [NAME] | Kro 2% EN-HG
 | D07602 | Kro 6% EN-HG
 | D07701 | Kro 7% Pumpkin EG-NG
 | D07734 | Kro French Vanilla EG-NG
Spreadsheet: john_griffith__16074__1_16_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 240 | 27 | 27.5 | 77.9 | 79.3 | 11.86 | 2002-01-16 14:53:00
 | NG H2 | 235 | 39.5 | 41 | 64 | 66.4 | 9.63 | 2002-01-16 14:53:00
 | NG J2 | 240 | 42 | 44 | 51.3 | 53.7 | 7.92 | 2002-01-16 14:53:00
 | NG K2 | 245 | 49 | 50 | 48.8 | 49.8 | 7.59 | 2002-01-16 14:53:00
 | NG M2 | 250 | 53 | 56 | 45 | 47.5 | 7.27 | 2002-01-16 14:53:00
 | NG N2 | 255 | 59 | 62 | 44.7 | 47 | 7.35 | 2002-01-16 14:53:00
 | NG Q2 | 260 | 66 | 70 | 45.2 | 47.9 | 7.61 | 2002-01-16 14:53:00
 | NG U2 | 260 | 71 | 75 | 45.2 | 47.7 | 7.59 | 2002-01-16 14:53:00
 | NG V2 | 260 | 77 | 80 | 46.2 | 48.1 | 7.71 | 2002-01-16 14:53:00
 | NG X2 | 280 | 88 | 91 | 46.4 | 48.1 | 8.32 | 2002-01-16 14:53:00
 | [NAME] | 300 | 100 | 103 | 47.2 | 48.7 | 9.04 | 2002-01-16 14:53:00
 | NG F3 | 310 | 109 | 114 | 47.9 | 50.1 | 9.55 | 2002-01-16 14:53:00
 | NG H3 |  |  |  |  |  |  | 2002-01-14 14:57:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 778979d1651496225-formula-to-extract-days-for-the-month-starting-with-1-for-a-calendar-formula-to-extract-dates-from-1st-to-last-day-for-the-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  | 2022-05-31 00:00:00
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00
 |  | 2022-06-06 00:00:00 | 2022-06-07 00:00:00 | 2022-06-08 00:00:00 | 2022-06-09 00:00:00 | 2022-06-10 00:00:00 | 2022-06-11 00:00:00 | 2022-06-12 00:00:00
 |  | 2022-06-13 00:00:00 | 2022-06-14 00:00:00 | 2022-06-15 00:00:00 | 2022-06-16 00:00:00 | 2022-06-17 00:00:00 | 2022-06-18 00:00:00 | 2022-06-19 00:00:00
 |  | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2022-06-22 00:00:00 | 2022-06-23 00:00:00 | 2022-06-24 00:00:00 | 2022-06-25 00:00:00 | 2022-06-26 00:00:00
 |  | 2022-06-27 00:00:00 | 2022-06-28 00:00:00 | 2022-06-29 00:00:00 | 2022-06-30 00:00:00 | 2022-07-01 00:00:00 | 2022-07-02 00:00:00 | 2022-07-03 00:00:00
 |  | 2022-05-31 00:00:00
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  |  |  |  |  |  | 2022-05-01 00:00:00
 |  | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00
 |  | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00
 |  | 2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00
 |  | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00
 |  | 2022-05-30 00:00:00 | 2022-05-31 00:00:00
Spreadsheet: 115758d1311267783-how-would-i-sum-this-book1
Sheet: Sheet1

Spend | Program 1 | Program 2
473670 | JIT | Ex Works
650106 | VMI without Consignment | VMI without Consignment
216522 | VMI without Consignment | Ex Works
158103 | VMI without Consignment
790492 | VMI without Consignment
207685 | VMI without Consignment
737399 | Delivered Product | Ex Works
9813 | VMI without Consignment | Ex Works
62965 | JIT | Ex Works
481970 | VMI without Consignment | Ex Works
304185 | VMI without Consignment | Delivered Product
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: JS

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 707310d1607172937-drop-down-list-selection-based-on-column-title-selection-template
Sheet: Data

Passive Fire
Inspected |  | YES | NO
Compliance |  | COMPLIANT | NOT COMPLIANT
Non Compliance |  | No Treatment | Not A Tested System | Not Meet Test Certificate | No Thermal Rating (FRL)
Service |  | Hydraulic | Fire | Electrical | Mechanical
Type of Service |  | PVC Pipe < 50mm | Hydrant | Electrical Tray | Refrigeration Pipes
 |  | PVC Pipe > 50mm | Hydrant > 100 | Electrical Tray & Cables | [NAME] of Ref pipes
 |  | PVC Pipe > 100mm | Sprinkler | 3Phase Cable | Chilled Water Pipe <100mm
 |  | HDPE Pipe < 50mm | Sprinkler > 50 | 3Phase Cable < 20 | Chilled Water Pipe >100mm
 |  | HDPE Pipe > 50mm | Sprinkler >100 | 3Phase Cable > 20 | Heating Water Pipes <100mm
 |  | HDPE Pipe > 100mm | Exhaust Pipe | 3Phase Cable > 50 | Heating Water Pipes >100mm
 |  | Copper Pipe < 50mm | Electrical Tray | 3Phase Cable > 100 | Copper Pipes <100mm
 |  | Copper Pipe > 50mm | Electrical Tray & Cables | TPS | Copper Pipes >100mm
 |  | Copper Pipe > 100mm | Fire Cable | TPS Cables < 20 | Steel Pipes <100mm
 |  | Steel Pipe < 50mm | Fire Cable < 20 | TPS Cables > 20 | Steel Pipes >100mm
 |  | Steel Pipe > 50mm | Fire Cable > 20 | TPS Cables > 50 | PVC Pipes <100mm
 |  | Steel Pipe > 100mm | Fire Cable > 50 | TPS Cables > 100 | PVC Pipes >100mm
 |  |  | Fire Cable > 100 | Cat | Condensate
 |  |  |  | Cat Cables < 20 | 2x Ref, 1x Power & Comms
 |  |  |  | Cat Cables > 20 | 2x Ref, 2x Power & 2x Comms
 |  |  |  | Cat Cables > 50 | 3x Ref, 1x Power & Comms
 |  |  |  | Cat Cables > 100 | 3x Ref, 2x Power & 2x Comms
 |  |  |  | [NAME] | 1x 3Phase Cable
 |  |  |  | [NAME] < 20 | Multiple 3Phase Cable
 |  |  |  | [NAME] 20 | 1x TPS
 |  |  |  | [NAME] 50 | Multiple  TPS
 |  |  |  | Mixed Cables > 100 | 1x Comms
 |  |  |  |  | Multiple  Comms
 |  |  |  |  | Cluster of Cables
 |  |  |  |  | Electrical Tray
 |  |  |  |  | Electrical Tray & Cables
 |  |  |  |  | Duct
 |  |  |  |  | Flexible Duct
Level |  | Basement | Ground | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10 | L11 | L12 | [NAME] | [NAME] | L15 | L16 | L17 | L18 | L19 | L20 | Roof
Area |  | Floor | [NAME] | Comms Room | Pump Room | Lift | Plantroom | Garbage Room | Store Room | Foyer
Wall/ Slab |  | Wall | Slab
Structure Type |  | Concete | Masonry | Block | Hebel | Speedpanel | AFS | Shaftwall | Sheeted | 1x Layer Sheet | 2x Layer Sheet | 3x Layer Sheet
Sticker |  | Compliant | Not Compliant | Missing
Manufacturer |  | Promat | Trafalgar | TBA | BOSS Fire
Product |  | Mastic
 |  | Collar
Application
Spreadsheet: 453949d1459531289-data-validation-listing-based-on-certain-condition-data-validation-listing-based-on-certain-condition
Sheet: Weeks

 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2016-04-02 00:00:00 | 2016-04-08 00:00:00
2016-04-09 00:00:00 | 2016-04-15 00:00:00
2016-04-16 00:00:00 | 2016-04-22 00:00:00
2016-04-23 00:00:00 | 2016-04-29 00:00:00
2016-04-30 00:00:00 | 2016-05-06 00:00:00
2016-05-07 00:00:00 | 2016-05-13 00:00:00
2016-05-14 00:00:00 | 2016-05-20 00:00:00
2016-05-21 00:00:00 | 2016-05-27 00:00:00
2016-05-28 00:00:00 | 2016-06-03 00:00:00
2016-06-04 00:00:00 | 2016-06-10 00:00:00
2016-06-11 00:00:00 | 2016-06-17 00:00:00
2016-06-18 00:00:00 | 2016-06-24 00:00:00
2016-06-25 00:00:00 | 2016-07-01 00:00:00
2016-07-02 00:00:00 | 2016-07-08 00:00:00
2016-07-09 00:00:00 | 2016-07-15 00:00:00
2016-07-16 00:00:00 | 2016-07-22 00:00:00
2016-07-23 00:00:00 | 2016-07-29 00:00:00
2016-07-30 00:00:00 | 2016-08-05 00:00:00
2016-08-06 00:00:00 | 2016-08-12 00:00:00
2016-08-13 00:00:00 | 2016-08-19 00:00:00
2016-08-20 00:00:00 | 2016-08-26 00:00:00
2016-08-27 00:00:00 | 2016-09-02 00:00:00
2016-09-03 00:00:00 | 2016-09-09 00:00:00
2016-09-10 00:00:00 | 2016-09-16 00:00:00
2016-09-17 00:00:00 | 2016-09-23 00:00:00
2016-09-24 00:00:00 | 2016-09-30 00:00:00
Spreadsheet: e3bcfdfe-1c25-491f-9478-edb843e65583
Sheet: Sheet1

Supplementary Table 3.  Primers used for CNV validation. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Chromosome | CNV Start site (Build 34) | Change | Forward | Reverse | Probe
19 | 25.2 Mb | control | 5'-CAGGCCAATCTGATAGGAGTTTTT | 5'-TACTGACTGACACGGGCTAGGA | 5' FAM-CTCTATCAAAGTTCCTTCTTCCAAAATG-TAMRA
3 | 23.6 Mb | loss | 5'-AAATTATGGCAACCTTTGAGACTGT | 5' CCCCAGCTTCATAGGCAGATC | 5' FAM-CCTGCAGGGCAACGTGTCAGCTATG-TAMRA
6 | 41.2 Mb | loss | 5'-CAGTATCCTGAGAGGAAGCATGTC | 5'-AGATAGCAGGGTGGTGTTCCA | 5'-FAM AACACTGCCTTCCCTGACCCCGC-TAMRA
17 | 28.4 Mb | gain | 5'-CCAGTGCTTGAGGCAAATCA | 5'-TGGGAACATGCGCTTTAACC | 5' FAM-TCACCCGCTATGAAGCAGCCTCTTG-TAMRA
18 | 57.8 Mb | gain | 5'-TGCAGAGCCAGCAGTGTAGTG | 5'-CCACCGTGCTTTCCCTATCA | non-qPCR
6 | 41.2 Mb | loss | 5'-GAAGAGGACTTTCCCACACCC | 5'-AGGAGCTTAGGAGCAGTCTTGC | non-qPCR
19 | 25.1 Mb | loss | 5' GCCCTGTTGGTGTATTCAAGGA 3' | 5' CGACAGCTTCATGGTCATTTTTC 3' | 5' FAM CCGTGCACTTTCTACAGCATCC 3' TAMRA
11 | 73.8 Mb | loss | 5' TCGTTTTTCAGGCCTCTAATGC 3' | 5' TCACATTTGTAGTCATTCATAGCCATAG 3' | 5' FAM CTGAAGCCAGGAGCTTCCATGGTGA 3' TAMRA
1 | 109.7 Mb | loss | 5' CAGAATATGTAAATGTTAGTCCCCAAAG 3' | 5' GCTTCAACCACCTGGAAGAGAT 3' | non-qPCR
4 | 59.9 Mb | loss | 5' TGGGTATCTGTCCTCAAAATCTCTCT 3' | 5' AAGCCCAAGCATTCCACATAA 3' | 5' FAM CTTCAGCCCTTGATCCTCTGAGGATGCTT 3' TAMRA
6 | 130.6 Mb | loss/gain | 5' GGCATAGGTACTATCCAAGTACAAGGT 3' | 5' CCTCCCCATCCTCAGTTATCTCT 3' | 5' FAM CAAGCTGAGGCATGCAGCCTACCAA 3' TAMRA
Spreadsheet: 856311d1705593181-monthly-totals-with-multiple-date-ranges-book2
Sheet: Sheet1

Month | Days Requested
2024-01-23 00:00:00 |  | 5 | 5 | 1
2024-02-23 00:00:00
2024-03-23 00:00:00
2024-04-23 00:00:00
2024-05-23 00:00:00 |  |  | 3
2024-06-23 00:00:00 |  | 2
2024-07-23 00:00:00 |  | 11 | 8 | 1
2024-08-23 00:00:00 |  | 18 | 4
2024-09-23 00:00:00
2024-10-23 00:00:00
2024-11-23 00:00:00
2024-12-23 00:00:00
2024-01-24 00:00:00 |  | 30 | 3
2024-02-24 00:00:00 |  | 26
Requests
Dept | Emp ID | Name | From Date | To Date | Days Requested | Approval
 |  |  | 2023-01-09 00:00:00 | 2023-01-13 00:00:00 |  | Approved
 |  |  | 2023-01-09 00:00:00 | 2023-01-13 00:00:00 |  | Approved
 |  |  | 2023-01-16 00:00:00 | 2023-01-16 00:00:00 |  | Approved
 |  |  | 2023-05-29 00:00:00 | 2023-05-31 00:00:00 |  | Approved
 |  |  | 2023-06-01 00:00:00 | 2023-06-02 00:00:00 |  | Approved
 |  |  | 2023-07-03 00:00:00 | 2023-07-20 00:00:00 |  | Denied
 |  |  | 2023-07-07 00:00:00 | 2023-07-17 00:00:00 |  | Approved
 |  |  | 2023-07-24 00:00:00 | 2023-07-31 00:00:00 |  | Approved
 |  |  | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 |  | Approved
 |  |  | 2023-08-01 00:00:00 | 2023-08-18 00:00:00 |  | Approved
 |  |  | 2023-08-01 00:00:00 | 2023-08-04 00:00:00 |  | Approved
 |  |  | 2023-08-21 00:00:00 | 2023-08-31 00:00:00 |  | Denied
 |  |  | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 |  | Denied
 |  |  | 2024-01-02 00:00:00 | 2024-02-26 00:00:00 |  | Approved
 |  |  | 2024-01-03 00:00:00 | 2024-01-05 00:00:00 |  | Approved
Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Invoice 04

 |  | 511 East Steel Loop, Suite 201
 |  | Palmer, AK  99645
 |  | Phone:  [PHONE]
 |  | Fax:      [PHONE]
TO: |  |  |  |  | INVOICE DATE: |  | 0/00/2024
 |  |  |  |  | INVOICE NO:
 |  |  |  | Submitted
 |  |  |  | Via Email
JOB NO:
DOL NUMBER:
JOB NAME:
[NAME] |  | CONTRACT AMOUNT ( $ ) | PREVIOUS BILLED (%) | PREVIOUS BILLED ( $ ) | CURRENT BILLING (%) | CURRENT BILLING ( $ ) | [NAME] (%) | JTD  BILLING ( $ )
Labor
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
LABOR TOTALS: |  |  | 0 |  | 0
CHANGE REQUESTS:
CHANGE REQUEST TOTALS:
TOTALS ALL TO DATE:
Please Remit Payment to: |  |  |  | TOTAL CURRENT BILLING
Iron Inc
511 East Steel Loop |  |  |  | TOTAL PREVIOUS BILLING
Palmer, AK 99645
 |  |  |  | TOTAL AMOUNT DUE THIS INVOICE