tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 512157d1491946756-regular-ot-and-doubletime-copy-of-sample-timesheet
Sheet: Portrait

Month: | 2017-03-01 00:00:00
Name: |  |  |  |  | OT starts after | 40 | hours |  |  | Weekly | Reg Hours | Over Hours | Double OT Hrs | Total Hrs worked | TOTAL  PAY
 | Rate | $ |  |  | Double OT starts after | 50 | Hours
[NAME] | 1 | 20
Overtime rate | 1.5
Double OT Rate | 2
 |  |  |  |  |  |  |  |  |  | TOTAL
Week of  03/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 08:00:00 | 10:15:00 | 11:15:00 | 07:30:00 | 08:15:00 | 11:15:00
[NAME] | 09:15:00 |  |  |  |  | 14:00:00
Lunch Ends | 09:30:00 |  |  |  |  | 15:00:00 |  |  |  | 23 Bus. Days x 5 hours per day = 115 hours
Log Out | 18:00:00 | 20:15:00 | 23:15:00 | 23:00:00 | 23:15:00 | 21:15:00
Hours Worked |  |  |  |  |  |  |  |  |  | RED = HOLIDAY
[NAME] |  |  |  |  |  |  |  |  |  | BLUE = SICK Balance 24
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/06/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/13/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/20/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  03/27/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In
[NAME]
Lunch Ends
Log Out
Hours Worked
[NAME]
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Spreadsheet: 681406d1591554521-sorting-data-in-1-column-to-rows-column-to-row
Sheet: Blad1

NOW
1000 | [NAME]
1000 | 50
1000 | 12
1000 | 1100
1000 | 1200
1000 | 1300
1000 | 1400
1000 | 1500
1000 | 1600
5000 | rood
5000 | 57
5000 | 8
5000 | 5100
5000 | 5200
5000 | 5300
5000 | 5400
5000 | 5500
5000 | 5600
9000 | [NAME]
9000 | 64
9000 | 4
9000 | 9100
9000 | 9200
9000 | 9300
9000 | 9400
9000 | 9500
9000 | 9600
13000 | rood
13000 | 71
13000 | 0
13000 | 13100
13000 | 13200
13000 | 13300
13000 | 13400
13000 | 13500
13000 | 13600
17000 | [NAME]
17000 | 78
17000 | -4
17000 | 17100
17000 | 17200
17000 | 17300
17000 | 17400
17000 | 17500
17000 | 17600
Wish
Item | color | gewicht | doos | synoniem 1 | synoniem 2 | synoniem 3 | synoniem 4 | synoniem 5 | synoniem 6
1000 | [NAME] | 50 | 12 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600
5000 | rood | 57 | 8 | 5100 | 5200 | 5300 | 5400 | 5500 | 5600
9000 | [NAME] | 64 | 4 | 9100 | 9200 | 9300 | 9400 | 9500 | 9600
13000 | rood | 71 | 0 | 13100 | 13200 | 13300 | 13400 | 13500 | 13600
17000 | [NAME] | 78 | -4 | 17100 | 17200 | 17300 | 17400 | 17500 | 17600
Spreadsheet: 65156d1265883893-mixing-date-in-one-column-concatif_temp_avk-1-
Sheet: Sheet1

 |  |  | code | abc | bcd | cde | visit date in may | visit date in june | visit date in july | visit date in aug | visit date in sept | visit date in oct | visit date in nov
 | 604117 | NW | INX1024399
 | 604118 | NW | INX1024398 |  |  |  |  |  |  |  |  |  | 13.11.08
 | 604119 | NW | INX1024397 |  |  |  |  |  |  |  |  |  | 15.11.08
 | 604117 | NW | INX1024399 |  |  |  |  |  |  |  |  |  | 20.11.08
 | 604118 | NW | INX1024398 |  |  |  |  |  |  |  |  |  | 21.11.08
 | 604119 | NW | INX1024397 |  |  |  |  |  |  |  |  |  | 22.11.08
 | 604117 | NW | INX1024399 |  |  |  |  |  |  |  |  |  | 20.11.09
 | 604118 | NW | INX1024398 |  |  |  |  |  |  |  |  |  | 21.11.09
 | 604119 | NW | INX1024397 |  |  |  |  |  |  |  |  |  | 22.11.09
 |  |  | INX1024397 |  |  |  |  |  |  |  |  |  | 01.01.10
 |  |  | INX1024397 |  |  |  |  |  |  |  |  |  | 01.02.10
Spreadsheet: 105053d1302535152-excel-error-with-charts-book2
Sheet: Debt

 |  |  | Opening Balance | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | Total
 | 947609.892145397 | Opening Balance
 | 1913.763219168282 | 2010-03-01 00:00:00
 | 86313.55257546417 | 2010-04-01 00:00:00
 | 69352.19475971757 | 2010-05-01 00:00:00
 | 15067.79351627657 | 2010-06-01 00:00:00
 | 13024.51972346482 | 2010-07-01 00:00:00
 | 68866.83739018341 | 2010-08-01 00:00:00
 | 13236.27800640305 | 2010-09-01 00:00:00
 | 29876.64221231224 | 2010-10-01 00:00:00
 | 75568.18888177583 | 2010-11-01 00:00:00
 | 84514.52886287087 | 2010-12-01 00:00:00
 | 210067.9336246122 | 2011-01-01 00:00:00
 | 410234.9568659292 | 2011-02-01 00:00:00
 |  | Total
 |  | Collection Ratio |  | 0.9533596052997858 | 0.9550615307883993 | 0.9555346973413738 | 0.9555346973413738 | 0.9586184499554227 | 0.9617972285058791 | 0.9672386481122983 | 0.9681415955434145 | 0.9696409929657496 | 0.9732382488744066 | 0.9734239264511517 | 0.9744882878891286
Spreadsheet: 464966d1465390718-overlay-worksheets-with-formatting-programme-engineering
Sheet: Resource

Approx No.s | SITE | JUNE 2016 |  |  |  |  |  | JUNE 2016
 |  | 6 | 7 | 8 | 9 | 10 |  | 13 | 14 | 15 | 16 | 17
 | BITS & PIECES |  |  | LISP | LISP | PROG |  | PROG
 |  |  |  |  |  |  |  | BACKUP
 | Poole NMA
 | DESIGN | L |  | v
 | PRODUCTION |  | L | L | V | V |  | V | V | L |  | SUB
 | ENGINEERING
800-OUTLINE | Newquay - (800-OUTLINE)
 | DESIGN |  | L | L | V | V
 | PRODUCTION |  | HT |  | DAN | DAN |  |  | L | L
 | ENGINEERING
250-OUTLINE | Matford Park (250-OUTLINE)
 | DESIGN
 | PRODUCTION
 | ENGINEERING |  |  |  |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  |  |  |  | L
238 | [NAME] (238)
 | DESIGN
 | PRODUCTION
 | ENGINEERING
460 | [NAME], [NAME] (460)
 | DESIGN
 | PRODUCTION
 | ENGINEERING
DAZ | SERGEY | DAVEY
 | PABS |  |  |  |  |  |  |  |  |  | DAVEY
[NAME] | DAN |  |  |  |  |  |  |  |  |  | JONNY L
JON | DAVEY |  |  |  |  |  |  |  | [NAME] |  |  | DAGMARA (PM)
WATTO | JONNY THE BEAR |  |  |  |  |  |  |  |  | SERGEY (PM) | SERGEY (PM)
ZSOLT | [NAME]
J.R | DAGMARA
ADRIAN G | ADRIAN
Spreadsheet: 728462d1618478097-formula-for-match-data
Sheet: Data

Month | Depot | Region | WK1 | WK2 | WK3 | WK4 | WK5 | Average Total |  | Month | Depot | Region | WK1 | WK2 | WK3 | WK4 | WK5 | Total |  | Month | Depot No | Depot Name | Region | Bottom 10 Total | Above Bottom Total
Jan | 001 - Depot 01 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D001 | Depot 01
Jan | 002 - Depot 02 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D002 | Depot 02
Jan | 003 - Depot 03 | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D003 | Depot 03
Jan | 004 - Depot 04 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D004 | Depot 04
Jan | 005 - Depot 05 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D005 | Depot 05
Jan | 006 - Depot 06 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D006 | Depot 06
Jan | 007 - Depot 07 | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D007 | Depot 07
Jan | 008 - Depot 08 | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D008 | Depot 08
Jan | 009 - Depot 09 | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D009 | Depot 09
Jan | 010 - Depot 10 | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D010 | Depot 10
Spreadsheet: 145936d1331821797-excel-2008-use-an-master-sheet-to-get-tables-from-other-sheets-using-a-single-value-master-data
Sheet: Q3

 |  |  |  |  |  | 10 | 12 | 14 | 51
 |  |  |  |  |  | 11 | 13 | 15 | 51
 |  |  |  |  |  | 12 | 13 | 16 | 14
 |  |  |  |  |  | 13 | 14 | 17 | 14
 |  |  |  |  |  | 14 | 15 | 17 | 12
Spreadsheet: 150183d1334325451-excel-2007-copying-formula-to-another-position-with-certain-conditions-book2
Sheet: Sheet1

 | Table 1 |  |  |  |  | Table 2
 | Column A | Column B | Column C |  |  | Column A | Column B | Column C
 | a1 | b1 | c1 |  |  | a1 | e1 | f1
 | a2 | b2 |  |  |  | a2 | e2
 | a3 | b3 | c3 |  |  | a3 | e3 | f3
 | a4 | b4 | c4 |  |  | a9 | e4 | f4
 | a5 | [NAME] |  |  |  | a5 | e5
Spreadsheet: 745069d1629723901-sum-if-value-match-formula-2
Sheet: 23-08-2021

Daily PMC Transfer Target Sheet
Serial No | Style No | Season | Order QTY | RCV QTY | Remarks | Work -Area
1 | FZ-658 | EF-22 | 277 | 278 | Wait For Finishing | Inhouse
2 | FZ-654 | SP-22 | 400 | 328 | Wait For Finishing | Inhouse
3 | FZ-657 | EF-22 | 287 | 271 | Wait For Finishing | Inhouse
4 | JR-044 | SP-22 | 200 | 207 | Wait For Finishing | Inhouse
5 | FZ-668 | EF-22 | 370 | 356 | Wait For Finishing | Inhouse
6 | SA-355 | EF-22 | 154 | 153 | Wait For Finishing | Subcon
7 | SA-317 | EF-22 | 698 | 656 | Wait For Finishing | Subcon
8 | RB-1121 | EF-22 | 307 | 267 | Wait For Finishing | Subcon
9 | SS-1235 | [NAME] | 422 | 438 | Rework | Subcon
10 | SA-295 | WIN-21/22 | 300 | 286 | Recheck - Merchandiser | Inhouse
11 | SI-305 | WIN-21/22 | 300 | 314 | Wait For Size Grading | Inhouse
12 | RB-1203 | EA-21 | 400 | 459 | [NAME] | Subcon
13 | RB-1202 | EF-22 | 300 | 301 | [NAME] | Subcon
14 | EV-415 | WIN-21/22 | 202 | 202 | [NAME] | Subcon
15 | RB-1132 | EF-22 | 308 | 291 | [NAME] | Semi
16 | SO-010 | EF-22 | 1463 | 1484 | [NAME] | Subcon
17 | SO-016 | EF-22 | 480 | 522 | [NAME] | Subcon
18 | SS-1220 | EF-22 | 240 | 237 | [NAME] | Inhouse
19 | RB-1099 | EF-22 | 337 | 316 | [NAME] | Subcon
20 | ST-031 | EF-22 | 333 | 358 | Decession pending. Button N/A | Subcon
21 | FZ-620 | EF-22 | 316 | 314 | Dopatta N/A | Inhouse
 | MRP OK |  | Result Will be 3812 Here
Spreadsheet: 763223d1642064054-if-with-two-string-conditions-in-a-table-exemple-si
Sheet: Feuil1

[NAME] fichier | Date |  |  |  | CLIENT | Référence | [NAME]
CLIENT001 112021 EUROS - Copie | 2022-01-12T12:07:35.8837290Z |  |  |  | CLIENT001 | 122021 |  |  | For this customer, [NAME] should = 0
CLIENT001 112021 EUROS - Copie (4) | 2022-01-12T12:07:35.9305344Z |  |  |  | CLIENT002 | 122021 |  |  | For this customer, [NAME] should = 0
CLIENT005-102021 | 2022-01-12T13:24:15.6835489Z |  |  |  | CLIENT003 | 122021 |  |  | For this customer, [NAME] should = 0
CLIENT002 082021 | 2022-01-12T13:24:15.6991763Z |  |  |  | CLIENT004 | 122021
CLIENT005 122021 | 2022-01-12T13:24:15.6991763Z |  |  |  | CLIENT005 | 122021
CLIENT002-112021 | 2022-01-12T13:24:15.7148037Z |  |  |  | CLIENT006 | 122021
CLIENT003 092021 | 2022-01-12T13:24:15.7148037Z |  |  |  | CLIENT007 | 122021
CLIENT009 122021 EUROS | 2022-01-12T15:25:09.5277016Z |  |  |  | CLIENT008 | 122021
CLIENT009 122022 EUROS | 2022-01-12T15:30:07.2672113Z |  |  |  | CLIENT009 | 122021
Spreadsheet: 57301d1257417442-interpolation-on-a-connected-scatter-plot-705999
Sheet: Sheet1

 |  | Y
 | 40321.12500000001 | 0 |  |  |  | Nearest | Lower Index | Upper Index | Lower Value | Upper Value | Gap | Factor
 | 44425.87499999999 | 3.75 |  | Y | 20 | 12.5 | 3 | 4 | 12.5 | 25 | 12.5 | 0.6
 | 47173.15416666667 | 12.5 |  | X | 48503.41166666667 |  |  |  | 47173.15416666667 | 49390.25 | 2217.095833333333
 | 49390.25 | 25
 | 51172.33333333334 | 37.5
 | 53463.58333333334 | 50
 | 55551.16666666668 | 62.5
 | 57155.04166666666 | 75
Spreadsheet: f085fb2d-8d1a-4b49-aaf3-430beb027e40
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
9864 | Test | 9864 | Ziehl-Nielsen Stain for Acid- Fast Bacteria | [NAME] ST for Acid Fast Bact | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88312 |  |  |  |  | Rochester
9864 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9864 | Result | 9864 | [NAME] for Acid Fast Bact | [NAME] for Acid Fast Bact |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 656-9
Spreadsheet: 174567d1345116334-combining-2-workbooks-workbook-1
Sheet: July

 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00 | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 | 2012-07-04 00:00:00 | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 | 2012-07-07 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 14 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 1 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-07-08 00:00:00 | 2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00 | 2012-07-14 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 15 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 2 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-07-15 00:00:00 | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 16 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 3 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-07-22 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00 | 2012-07-28 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 17 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 4 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
Spreadsheet: 51907d1251485437-sum-based-on-date-cell-not-being-empty-example
Sheet: Sheet1

Exterior | Buy Date | Supplier | Price | Shipping | Total Cost
Wind deflectors, passenger side
Spoon - Carbon Racing Mirror |  | Nengun | 215.27 | 25
Spoon - Carbon Roof Spoiler |  | Nengun | 242.17
Works Bell [NAME] and Lock Set |  | Nengun | 223.7
Spoon sports wiper blade |  | Nengun | 59.12
 |  |  |  |  |  | Total
 |  |  |  |  |  |  | Spent
The "spent" field should only include the 2nd Item "Spoon - Carbon Racing Mirror" as it's the only item with a purchase date
Spreadsheet: darrell_schoolcraft__7809__imbalsumm0108
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -68011 | -37500 | -90 | -29410
2 | -49057 | -20000 |  | -27910
3 | -48415 | -11000 |  | -36910
4 | -29951 |  |  | -29410
5 | -29999 |  |  | -29410
6 | -29297 |  |  | -28307
7 | -64051 | -11000 |  | -51049
8 | -35246 |  |  | -34257
9 | -61903 | -10000 |  | -49974
10 | -63569 | -17500 |  | -44910
11 | -57587 | -27000 |  | -28288
12 | -57418 | -27000 |  | -28592
13 | -57225 | -27000 |  | -28771
14 | -88695 | -12000 |  | -75910
15 | -79069 | -11998 | -23700 | -90257
16 | -46861 | -5000 | -44315 | -84512
17 | -62441 |  |  | -60910
18 | -81752 | -48000 | -65196 | -97157
19 | -76011 | -48000 | -60094 | -88748
20 | -84945 | -48000 | -68581 | -102023
21 | -34415 | -30000 | -43468 | -49989
22 | -75971 | -37000 |  | -36910
23 | -55320 | -21996 |  | -31910
24 | -83890 | -16199 |  | -65075
25 | -52746 | -12063 |  | -39275
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 36339
 | 2001-08-25 00:00:00
CBS Dollars
 |  |  | -29968.41
Spreadsheet: 156706d1337410444-lookup-or-sumproduct-or-if-condition-with-sumproduct-and-vlookup-sample-bonus_solution
Sheet: Bonus Calculation

2012-06 (Jun)
1000 |  |  |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Name | Date | Day | Unexcused Absence | Unexcused Absence (NO CONTACT) | Unexcused Absence following PTO | Unexcused Absence following PTO (NO CONTACT) | Bonus Lost |  |  | Unexcused Absence | 2 | 1 | 1 | 1 | 2 | 1
[NAME] | 2012-06-04 00:00:00 |  | Y |  |  |  |  |  |  | Unexcused Absence (NO CONTACT) | 4 | 2 | 2 | 2 | 4 | 2
Blaise Moriarty | 2012-06-05 00:00:00 |  | Y |  |  |  |  |  |  | Unexcused Absence following PTO | 4 | 2 | 2 | 2 | 4 | 2
[NAME] | 2012-06-06 00:00:00 |  |  | Y |  |  |  |  |  | Unexcused Absence following PTO (NO CONTACT) | 4 | 2 | 2 | 2 | 4 | 2
Cassie French | 2012-06-08 00:00:00 |  |  | Y
[NAME] | 2012-06-07 00:00:00 |  |  |  |  | Y
Cassie French | 2012-06-08 00:00:00 |  |  |  | Y
[NAME] | 2012-06-11 00:00:00 |  |  |  |  | Y
[NAME] | 2012-06-12 00:00:00
[NAME] | 2012-06-13 00:00:00
Biz Days | 21
Spreadsheet: 0f85811a-8dc4-4c9a-8197-5d9c04b4861d
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Milestone F. | [NAME] | [NAME]
Milestone Description | Performance of Professional Land Survey | Performance of Geophysical Survey and Engineering Evaluation of Underground Utilities | Soil Boring Installation and Sampling | Monitoring Well Installation, Development, Abandonment, and Refurbishment | Soil Gas Sampling | Single Well Aquifer Testing | [NAME] | Preparation of Site Characterization Report
Sub-Milestones | NA | NA | NA | NA | NA | NA | NA | NA | Cost Subtotals
Anticipated # of Milestone Payments | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Direct Costs
Labor (total)
Other Direct Costs1 (ODCs)
ODC ≥ $5,000 (Specify)2
ODC ≥ $5,000 (Specify)2
ODC ≥ $5,000 (Specify)2
Subcontracted Costs3 | 6
Analytical - Water
Analytical - Soil
Analytical - Vapor
Other Analytical
Professional Surveyor
Geoprobe / Driller
Geophysical Surveyor
Other (specify)
Other (specify)
Other (specify)
Other (specify)
Other (specify)
Other (specify)
Other (specify)
Cost Per Sub-Milestone:
Total Milestone Cost:
Schedule of Unit Rates |  |  |  |  |  |  |  |  | Additional / Reduced Cost per Unit
[NAME] inclusive fixed unit-rate for the advancement of an additional 6 soil borings and the collection of 12 soil samples
[NAME] inclusive fixed unit-rate for a reduction in the number monitoring wells sampled ($[NAME])
Notes
- Bidders can only enter information into the blue cells of the Bid Form.  Bidders shall not insert or delete columns or rows.
- Bidders shall enter costs for each Direct Cost/Subcontracted Cost based on the proposed payment for achieving each milestone.  The "Total Milestone Cost" is the "Cost per Sub-Milestone" multiplied by the "Anticipated # of Milestone Payments"
- In accordance with the Request for Bid, bidders must include a rate schedule that will be used for any out-of-scope work.  Failure to submit unit rate schedule(s) (separate from this attachment) may cause the submitted bid to be deemed incomplete and/or non-responsive.
1 - Sum of individual direct costs other than Labor.  Each individual direct cost included in the sum must be <$5,000.  For example, vehicle charges, rental and/or disposable equipment, reproduction costs, and per diem.
2 - Direct costs that are ≥ $5,000 should be listed individually.
3 - Details related to subcontracted costs are required by the Solicitor.  Copies of subcontractor quotations shall be provided separately in the bid to assist in the bid evaluation.
Spreadsheet: 110bba1a-489b-4fe7-a06b-e4f0aa071eb1
Sheet: Occupancy Classifications

NO NEW CONSTRUCTION PERMIT NEEDED.
A Occupancy Tenant Improvements
B Occupancy Tenant Improvements
E Occupancy Tenant Improvements
F Occupancy Tenant Improvements
H Occupancy Tenant Improvements
I Occupancy Tenant Improvements
M Occupancy Tenant Improvements
R Occupancy Tenant Improvements
S Occupancy Tenant Improvements
U Occupancy Tenant Improvements
New Construction...A-1 Assembly—Fixed Seating
New Construction...A-2 Assembly—Food & Drink
New Construction...A-3 Assembly—Worship, Amusement
New Construction...A-4 Assembly—Indoor Sport Viewing
New Construction...A-5 Assembly—Outdoor Activities
New Construction...Business
New Construction...Educational—School 6+ persons, up to the 12th Grade
New Construction...Educational—Day Care 5+ children, older than 2 1/2 yrs
New Construction...Factory Industrial—Moderate Hazard
New Construction...Factory Industrial—Low Hazard
New Construction...High Hazard Group [NAME] a detonation hazard
New Construction...High Hazard Group H-2 Pose a deflagration hazard
New Construction...High Hazard Group H-3 Readily support combustion
New Construction...High Hazard Group H-4 Pose health hazards
New Construction...High Hazard Group H-5 Semiconductor Fabrication, R&D
New Construction...Institutional—17+ persons, ambulatory
New Construction...Institutional—6+ persons, non-ambulatory
New Construction...Institutional—6+ persons, restrained
New Construction...Institutional—6+ persons, day care
New Construction...Mercantile
New Construction...Residential—Transient Boarding Houses, Hotels, Motels
New Construction...Residential—Permanent
New Construction...Residential—Assisted Living (6-16 persons)
New Construction...Storage
New Construction…U Accessory buildings
New Construction…NFPA 13 Sprinkler System
New Construction…NFPA 13R Sprinkler System
New Construction…NFPA 13D Sprinkler System
New Construction…Other Suppression System
New Construction…Fire Alarm System
New Construction…Access Control
Spreadsheet: 872339d1718723322-xlookup-trouble-excelexample
Sheet: Sheet1

 | Best | Name | Price |  | User | Best | Name | Price
 | 12 | [NAME] | 1.6 |  | A
 | 14 | Smith | 1.5
 | 12 | Jones | 1.8
 | 15 | [NAME] | 1.9
 | 15 | [NAME] | 1.7