tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 128551d1321040713-concatif-across-multiple-sheets-hours-test4upl
Sheet: Architectural Glazing Systems

Unique ID | SSN | Employee  First Name | Employee  Last Name | Jan  Hours | Feb  Hours | Mar  Hours | April  Hours | May  Hours | June  Hours | July  Hours | Aug  Hours | Sept  Hours | Oct  Hours | Nov  Hours | Dec  Hours | Total Hours |  | Jan Pension | Feb Pension | [NAME] | Apr Pension | May Pension | Jun Pension | July Pension | August Pension | Sept Pension | Oct Pension | Nov  Pension | Dec  Pension | YTD  Pension | Architectural Glazing Systems
AckermanRo2269 | 2269 | Rocky | Ackerman | 145.5 | 129 | 40 | 0 | 0 | 0 | 0 |  |  |  |  |  | 314.5 |  | 756.6 | 670.8000000000001 | 208 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1635.4
 |  |  | Total Hours Entered | 145.5 | 129 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 314.5 |  | 756.6 | 670.8000000000001 | 208 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1635.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | Total Hours from Report | 2918.5 | 2473 | 2962 | 2257.5 | 2531 | 2946 | 2140.5 | 2274 | 1809.5 |  |  |  | 22312 |  | 15176.2 | 12859.6 | 15402.4 | 11739 | 13161.2 | 15319.2 | 11558.7 | 12279.6 | 9771.3 |  |  |  | 117267.2
 |  |  | Difference | -2773 | -2344 | -2922 | -2257.5 | -2531 | -2946 | -2140.5 | -2274 | -1809.5 | 0 | 0 | 0 |  |  | -14419.6 | -12188.8 | -15194.4 | -11739 | -13161.2 | -15319.2 | -11558.7 | -12279.6 | -9771.3 | 0 | 0 | 0
 |  |  | Received Date | 2011-02-07 00:00:00 | 2011-03-07 00:00:00 | 2011-04-11 00:00:00 | 2011-05-16 00:00:00 | 2011-06-06 00:00:00 | 2011-07-11 00:00:00 | 2011-08-16 00:00:00 | 2011-09-06 00:00:00 | 2011-10-12 00:00:00
 |  |  | Check Date | 2011-02-03 00:00:00 | 2011-03-03 00:00:00 | 2011-07-04 00:00:00 | 2011-05-12 00:00:00 | 2011-06-02 00:00:00 | 2011-07-07 00:00:00 | 2011-08-04 00:00:00 | 2011-09-01 00:00:00 | 2011-10-06 00:00:00
 |  |  | Check Amount | 33154.16 | 28093.28 | 33648.32 | 25645.2 | 28752.16 | 33466.56 | 25065.26 | 26628.54 | 21189.25
 |  |  | H&W $ | 17977.96 | 15233.68 | 18245.92 | 13906.2 | 15590.96 | 18147.36 | 13506.56 | 14348.94 | 11417.95
 |  |  | Pension $ | 15176.2 | 12859.6 | 15402.4 | 11739 | 13161.2 | 15319.2 | 11558.7 | 12279.6 | 9771.3
 |  |  | H&W Hour | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 | 6.31 | 6.31 | 6.31
 |  |  | Pension Hour | 5.2 | 5.2 | 5.2 | 5.4 | 5.2 | 5.2 | 5.4 | 5.4 | 5.4
 |  |  | Check # | 30310 | 30472 | 30616 | 30784 | 30874 | 31031 | 31137 | 31281 | 31398
Spreadsheet: 847757d1698639700-how-to-display-a-message-in-a-cell-based-on-conditions-in-other-cell-form
Sheet:  Decommissioning Request Form

 |  |  |  |  | PARTIAL TEST
 | Decommissioning Product | Enter Product Details
 | Supply Site or Market Warehouse or LOC | S
 | Market (Lead Market) | Austria
 | Batch (Lot Number) | ASDF
 | SKU Code | 12345678912345
 | SKU Description | [NAME]
 | GTIN | 34098765678980
 | Case GTIN (for US Market Only)
 | Types of Decommissioning | Choose Type of Decommissioning
 | [NAME] with Rework | Partial Batch Decommissioning
 | [NAME] without Rework
 | Partial Batch Decommissioning
 | Choose Decommissioning Level | Enter SGTIN Quantity | Enter Case Quantity | Enter SSCC Quantity
 | SGTIN Level | 1 | 2 | 1
 | Decommissioning Reasons | [NAME] for Decommissioning |  | Description
 | FREE SAMPLE | DESTROYED
 | SAMPLE
 | DESTROYED
 | SUPPLIED
 | EXPORTED
 | OTHERS
 | [NAME]
 | RECALL
 | Decommissioning Comments, if any
 | Role | MUD ID | Name | Description of Role
 | Data Provider | V | r
 | Quality Approver | g | g
 | SUMMARY |  |  | DRF Completion Status
 | Quantity of Serial Number/SGTINs Entered | Quantity of Cases Entered | Quantity of SSCCs Entered | Verification:  Decommissioning Quantity Vs Quantity of SGTIN or SSCC numbers entered
 | Enter Serial numbers / SGTINs to be decommissioned | Enter Case numbers to be decommissioned | Enter SSCC numbers to be decommissioned
 |  | 2 | 1
 | 222 | 2
Spreadsheet: 108417d1305491872-weighted-average-and-excluding-not-applicable-example
Sheet: Call 1

 |  | Call ID: |  |  |  | Caller No.:
 |  | Date of Call: |  |  |  | Call Type:
 |  | Time of Call: |  |  |  | Duration: | 148
 |  | Performance Area | Description |  | Performance Category |  |  |  |  |  |  |  |  |  | Additional Comments |  |  | Performance Review Summary
 |  |  |  |  | Performance | Performance | Performance | Performance | Performance | Performance
 |  |  |  | Individual Weighting | Unacceptable | Below Satisfactory | Satisfactory | Good | Excellent | N/A |  |  |  |  | Comments |  |  | Performance Area | Satisfactory Percentage | Weighting | Call 1 Weighted Score
 |  |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  |  |  |  |  |  | 0.03
 |  | Opening | Welcome using company name | 0.25 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0.6
 |  |  | Follow greeting script | 0.25 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  | Agent introduction including name | 0.25 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0.05
 |  |  | Ask customers name | 0.25 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  |  |  |  |  |  | 0.02
 |  | [NAME] | Attempt to resolve all issues within call | 0.2 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | Total Grade
 |  |  | Ask clarifying questions | 0.15 |  |  |  |  | 1
 |  |  | Knowledge of products/services | 0.15 |  |  |  |  | 1
 |  |  | Understanding & diagnosing problems | 0.15 |  |  |  |  | 1
 |  |  | Providing Information | 0.35 |  |  |  |  | 1
 |  |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Volume & clarity of agent | 0.2 |  |  |  |  | 1
 |  |  | Interrupting customer during call | 0.2 |  |  |  |  | 1
 |  |  | Focus of agent during call | 0.2 |  |  |  |  | 1
 |  |  | Formality of agent during call | 0.1 |  |  |  |  | 1
 |  |  | Enthusiasm of agent | 0.2 |  |  |  |  | 1
 |  |  | Avoiding silence / pauses during call | 0.1 |  |  |  |  | 1
 |  |  |  |  | 0 |  | 0.5 |  | 1
 |  | [NAME] | Requesting permission to put on hold | 0.1 |  |  |  |  | 1
 |  |  | Using mute procedure effectively | 0.8 |  |  |  |  | 1
 |  |  | Thanking customer for being on hold | 0.1 |  |  |  |  | 1
 |  |  |  |  | 0 |  | 0.5 |  | 1
 |  | Systems Skills | Using correct applications effectively | 0.65 |  |  |  |  | 1
 |  |  | Correctly escalating trouble tickets | 0.35 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | Panic Buttons
 |  |  |  |  | 0 |  | 0.5 |  | 1
 |  | Closing | Offering to assist with any other issue | 0.5 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | Agent Abuse |  |  | Insert 1 if agent abused the call
 |  |  | Close by thanking customer for contacting company | 0.5 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | Missed Solution |  |  | Insert 1 if agent mistakenly did not solve issues
Spreadsheet: 96949d1296175682-determine-the-date-of-the-last-sunday-in-a-month-forecasting-dates-template
Sheet: Sheet1

Forecasting Dates Guide
(For determining which dates go into which boxes in Totalview)
Forecast Month Being Produced | BU Generate Forecast From | BU Generate Forecast To | MU Generate Forecast From | MU Generate Forecast To
2011-01-01 00:00:00 | Last Sunday of December 2010 | Second Saturday of February 2011 | Last Sunday of December 2010 | First Saturday of February 2011
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
Spreadsheet: 06cd98dc-374f-4b4f-b0b2-fa44e9ba2d97
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Preceptee Name:
DATE: |  |  |  |  |  |  |  |  |  | GRAND
 |  | SUN | MON | TUES | WED | THURS | FRI | SAT | TOTAL | TOTAL
TOTAL HRS:
DATE: |  |  |  |  |  |  |  |  |  | GRAND
 |  | SUN | MON | TUES | WED | THURS | FRI | SAT | TOTAL | TOTAL
TOTAL HRS:
DATE: |  |  |  |  |  |  |  |  |  | GRAND
 |  | SUN | MON | TUES | WED | THURS | FRI | SAT | TOTAL | TOTAL
TOTAL HRS:
DATE: |  |  |  |  |  |  |  |  |  | GRAND
 |  | SUN | MON | TUES | WED | THURS | FRI | SAT | TOTAL | TOTAL
TOTAL HRS:
Preceptee Signature                                                                                                                                               Date
<Preceptee Name>
Preceptor Signature                                                                                                                                                 Date
<[NAME]>
Spreadsheet: 42201d1240782857-obtaining-cell-based-data-from-a-moving-trendline-predicting-data-question-national-election-data-excelhelpforums
Sheet: Sheet4

 | Ukraine
1994 | 0.734
1995 | 0.72075
1996 | 0.7075
1997 | 0.69425
1998 | 0.681
1999 | 0.68475
2000 | 0.6885
2001 | 0.69225
2002 | 0.696
2003 | 0.6859999999999999
2004 | 0.6759999999999999
2005 | 0.6659999999999999
2006 | 0.656
2007 | 0.627
Spreadsheet: 838112d1690734459-calculating-time-car-park-calculations_1
Sheet: Spaces Data

 |  | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 |  |  | Start Time | End Time
Shift 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 23:59:00
Shift 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 19:00:00
Shift 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 | 07:00:00
Shift 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 18:00:00
Spreadsheet: john_hodge__16404__VNG Pipeline Setup-MAY-011
Sheet: Daily Trading Sheet

 | Transport Summary
 | VNG | Gas Day:
 | Pipeline | Primary | Primary |  | ENA / VNG |  | Remaining |  | Receipt | Current | Current
 |  | Receipt | Delivery | MDTQ | Flowing |  | Delivered |  | Purchase | Fuel | Commodity | aca | gri | great plains
 | Tennessee | Zn 0 | Zn 3 CNG | 2598 | 0 |  |  |  |  | 0.0504
 | Tennessee | Zn 1 | Zn 3 CNG | 2125 | 0 |  |  |  |  | 0.0429
 | CNG | Oakford/Pool | VNG | 22633 | 0 |  |  |  |  | 0.0228
 | CNG | S Webster/Pool | VNG | 4723 | 0 |  |  |  |  | 0.0228
 | TRCO | Zn 1 | Zn 5 Emporia | 3400 | 0 | 0 |  |  |  | 0.0458
 | TRCO | Zn 2 |  | 5000 | 0 |  |  |  |  | 0.0423
 | TRCO | Zn 3 |  | 11600 | 0 |  |  |  |  | 0.0381
 | Columbia Gulf | Rayne | Leach | 51479 | 0 |  |  |  |  | 0.02902
 | TCO | Lebanon | VNG | 5000 | 0 |  |  |  |  | 0.02776
 | TCO | Cobb | VNG | 2631 | 0
 | TCO | Leach / Pool | VNG | 50270 | 0
 | TCO | Emporia | VNG | 38000 | 0
 | Total Transport - All Pipes
 |  | VNG FORECAST :
 |  |  |  | SENDOUT VOLUME (Less Enuser and FS Supply) : | 27493
 |  |  | MaxTCO | Min CNG | Min TCO |  | MaxCNG
 | Position Manager (CNG) | 0
 | Position Manager (TCO) | 0
 | Position Manager (TRCO) | 0
 | Storage Fill (TCO) | 0
 | Storage Fill (CNG) | 0
 | Tier 1 = 10,958 | 0 |  | 0 |  |  | 0
 | [NAME] = 101,852 | 0
 | Tier 3 = 45,095 | 0
 | Daily Trading Setup - VNG Desk.xls
Spreadsheet: 49383d1248731430-formula-wont-calculate-when-only-some-of-the-three-variables-are-input-formula-wont-calculate
Sheet: SernaMonday (2)

 | REIM-BURSED | LEFT OVERS | [NAME] | Received
 | 95 | 5 |  | 100 |  |  |  |  | 0
 | 140 | 10 |  | 150 |  |  |  |  | 0
 | 142 | 8 |  | 150 |  |  |  |  | 40
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 | 95 | 5 |  | 100 |  |  |  |  | 400
 | 90 | 10 |  | 100 |  |  |  |  | 150
 | 96 | 2 | 2 | 100 |  |  |  |  | 100
 | 100 |  |  | 100 |  |  |  |  | 0
Spreadsheet: 695987d1600519281-under-multiple-conditions-of-repeated-data-and-count-the-number-of-data-as-required-course-satisfaction
Sheet: Sheet1

Class | subject | Name | Overall class satisfaction
Phase 1-Class 1 | mathematics |  | 1
Phase 1-Class 1 | mathematics |  | 1
Phase 1-Class 2 | mathematics |  | 0.6
Phase 1-Class 2 | mathematics |  | 0.6
Phase 1-Class 1 | physical |  | 0.5
Phase 1-Class 1 | physical |  | 0.8
Phase 1-Class 2 | physical |  | 0.9
Phase 1-Class 2 | physical |  | 0.9
Phase 2-Class 1 | mathematics |  | 0.8
Phase 2-Class 1 | mathematics |  | 0.8
Phase 2-Class 2 | physical |  | 0.8
Phase 2-Class 2 | physical |  | 0.8
Course satisfaction | 100% how many classes | 99-80% how many classes | How many classes below 80%
mathematics | 1 | 1 | 1
physical | 0 | 2 | 1
Spreadsheet: juan_hernandez__17720__SCHED2001
Sheet: APRIL'01

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | APRIL
NAME | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON
ERCOT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
[NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
KELLER MAYEAUX |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
[NAME] | N |  |  |  |  |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  |  | N | N | N | N
CHRIS WATTS |  | N | N | N | N |  | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D |  |  |  |  |  |  |  | N
[NAME] | D |  |  |  |  | N | N | N |  |  |  |  |  | D | D |  | N | N | N |  |  |  |  | N | N |  |  | D | D
SOUTHEAST
[NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
RUDY ACEVEDO |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
MIGUEL GARCIA |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
DEAN LAURENT |  | N | N |  |  |  | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D |  |  | N | N |  |  |  | N
[NAME] | D |  |  | N | N | N |  |  | N | N | N | N |  |  |  |  |  |  |  |  |  |  | N |  |  | D | D | D | D | D
MAURICIO TREJO | N |  |  |  |  | N | N | N |  |  |  |  |  | D | D |  | N | N |  |  |  | N | N | N |  |  | N | N | N
MIDWEST
[NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
J.D.KINSER |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
[NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D
Vacant |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N |  |  |  | D | D
JUAN PADRON | N |  |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | N |  |  |  |  |  | N | N | N
DUSTIN COLLINS | D |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  | N | N |  |  |  | N
NORTHEAST
Spreadsheet: 215831d1361503520-how-to-assign-true-false-values-to-ids-who-meet-the-following-criteria-please-help-newbi-martin
Sheet: Sheet4

222 | False | 3
222 | False | 3
222 | True | 3
222 | False | 3
33 | False | 2
33 | False | 2
33 | False | 2
555 | True | 1
555 | True | 1
555 | True | 1
Spreadsheet: 92867d1292409349-extract-data-from-a-string-test-1-
Sheet: Sheet1

Branch | Result needed |  |  |  |  | LEN
120 [NAME]
127 Chelmsford
133 Glasgow-Graham Boden St
144 [NAME]
150 Hull [NAME]
157 [NAME]
158 [NAME]
159 [NAME]
168 [NAME]
180 [NAME]
221 Nottingham Leengate
223 [NAME]
234 Caernarfon
243 Ashford GRAHAM
256 York Kettlestring Lane
259 [NAME]
270 [NAME]
271 [NAME]
277 Northampton P&H
279 High [NAME]
286 Devizes Graham
294 Musselburgh [NAME]
297 Fareham P&H
298 [NAME]
309 Barnsley [NAME]
319 Camberley Graham
[NAME]
339 Pontefract P&H
341 Middlesborough P&H-Graham
359 Sutton
360 Colchester (Mason Road)
363 Eastbourne
365 [NAME]
366 Hove
373 Banbury
374 Reading
389 Newcastle Under Lyme
401 Gateshead Graham P&H
402 Burton On Trent
410 [NAME] P&H
416 Maidenhead
419 North Shields Graham
421 Scunthorpe Graham
422 Worthing
446 Canterbury Lightside
447 [NAME]
459 Walton-on-Thames
470 Billericay
473 Askew Road
478 Harlesden
[NAME]
502 Dover Coombe Valley Rd
512 Bromley Curzon
525 Worcester Graham
540 Birkenhead
545 Bradford
558 Leicester Graham
563 Cambridge P&H
567 Maidstone Plumbing & Heatn
569 [NAME]
573 Winchester Graham P & H
605 [NAME]
613 [NAME]
715 Walsall
724 [NAME]
731 Bristol Glenfrome Road
732 Wimborne
735 Penge
745 Stafford
753 [NAME]
798 Bristol
799 Bath
813 Poole (Sharp Road)
817 Christchurch (Reid Street)
819 [NAME]
822 [NAME] (Woodrow Way)
832 Cardiff
846 Mansfield
[NAME]
859 Bedford
871 Falkirk Almond Court
882 [NAME]
894 Harrow
895 [NAME]
896 Bangor
899 Chirk
919 Southampton
925 Erith Slade Green
934 Barking Jewson
936 Stirling
937 [NAME] (Mackintosh Place)
944 [NAME]
968 [NAME]
969 York Grahams P&H
979 Shrewsbury
988 Dewsbury [NAME]
3069 [NAME]
3079 East Kilbride
3133 Chichester NJB
3183 Kings Norton
3185 [NAME]
3189 Coventry Graham
Spreadsheet: 110c8b62-99a9-4b2c-8980-724b29cf76ef
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Democratic
Grafton County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
[NAME] | 40 | 58 | 19
Ashland | 48 | 92 | 13
Bath | 38 | 15 | 2 | 2
[NAME] | 1 | 9 | 1
Bethlehem | 53 | 70 | 11
Bridgewater | 33 | 60 | 3
Bristol | 52 | 105 | 35 |  | 1
Campton | 82 | 112 | 25
Canaan | 124 | 106 | 13
Dorchester | 9 | 5 | 1 | 1
Easton | 22 | 17 | 1
Ellsworth | 3 | 4 | 2
Enfield | 160 | 130 | 23 |  |  |  | 1
Franconia | 57 | 83 | 3 | 2
[NAME] | 48 | 64 | 26 |  |  |  | 4
[NAME] | 21 | 15 | 2
Hanover | 613 | 553 | 33
Haverhill | 68 | 35 | 14 | 6
Hebron | 28 | 25 | 2 |  |  |  | 1
Holderness | 118 | 93 | 14 |  | 1
Landaff | 17 | 5 | 2 |  | 1
Lebanon Ward 1 | 195 | 154 | 21
Lebanon Ward 2 | 179 | 98 | 24 | 1
Lebanon Ward 3 | 180 | 96 | 27
Lincoln | 16 | 52 | 9 | 1 |  |  | 1
Lisbon | 17 | 30 | 6
Littleton | 94 | 158 | 18 | 5
Livermore | 0 | 0 | 0
[NAME] | 12 | 21 | 1
Lyme | 162 | 121 | 7 | 1
Monroe | 13 | 22 | 3
Orange | 12 | 20 | 3
Orford | 72 | 33 | 7
Piermont | 39 | 17 | 12
Plymouth | 174 | 177 | 14 | 3 | 1
Rumney | 62 | 39 | 9
[NAME] | 40 | 42 | 1
[NAME] | 57 | 79 | 17
[NAME] | 29 | 19 | 5 |  | 2
Waterville Valley | 13 | 24 | 5
Wentworth | 20 | 14 | 3 | 1 |  |  | 2
Woodstock | 32 | 38 | 8 |  |  |  | 3
TOTALS | 3053 | 2910 | 445 | 23 | 6 |  | 12
Spreadsheet: 147519d1332837520-count-if-formula-ex
Sheet: March

 | 2012 | March
 |  | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00 | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00 | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00
 | Accounts
 | Rod | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | Y | y | y | W | W | y | y | y | y | y | W | W | y | y |  |  |  | W |  |  | Y | Present
 | [NAME] | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y |  |  |  | W
 | [NAME] | W | W | y | y | y | y | y | W | W | y | h | s | s | s | W | W | s | s | s | s | s | W | W | s | s | s | s | s | W | W | s | s | s | s | s | W |  |  | W | Weekend
 | Zippiy | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y | y | y | y | W | W | y | y |  |  |  | W |  |  | S | Sick Day
 | George | W | W | y | y | y | y | y | W | W | y | y | y | y | h.5 | W | W | H | y | H | H | H | W | W | H | H | H | y | y | W | W | y | y |  |  |  | W |  |  | S.5 | Half day sick
 | [NAME] | W | W | 0 | 0 | 0 |  | y | W | W | y | s | y | y | y | W | W | y | y | Y | y | a | W | W | y | y | y | y | y | W | W | y | y |  |  |  | W |  |  | H | Holiday Full Day
 |  | W | W | 0 | 0 | 0 |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  | H.5 | Holiday Half Day
 |  | W | W | 0 | 0 | 0 |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  | A | Absent Day
 |  | W | W | 0 | 0 | 0 |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  | B | Bank Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √ | Time Recorded
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not worked (part time)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | Lieu day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | Cover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NM | No more off
Spreadsheet: 872301d1718687985-calculating-overtime-to-be-paid-after-deductions-are-made-forum-sheet-ot-build-up-rev-04-aligw
Sheet: Sheet1

DAY | [NAME] |  | [NAME] | CUMULATIVE TIME |  | LATE RUNNING OVERTIME WORKED | CUMULATIVE TIME |  | OVERTIME TO BE PAID |  | AliGW
Monday | 7.3 |  | 0 |  |  | 0
Tuesday | 7.55 |  | 0.75 |  |  | 0.5 |  |  |  |  | 0.25
Wednesday | 7.4 |  | 0.4 |  |  | 0.42 |  |  |  |  | 0.42
Thursday | 7.65 |  | 0 |  |  | 0.2 |  |  |  |  | 0.2
Friday | 8.25 |  | 0.45 |  |  | 0.45 |  |  |  |  | 0.45
TOTAL :
Spreadsheet: 804101d1667894907-formula-to-find-change-from-specific-weekday-excel-help
Sheet: Sheet1

 | Date | Day | Weekday num | Price | Change
 | 2022-10-10 00:00:00 |  |  | 39093.1
 | 2022-10-11 00:00:00 |  |  | 38712.45 |  |  |  | first week
 | 2022-10-12 00:00:00 |  |  | 39118.55
 | 2022-10-13 00:00:00 |  |  | 38624
 | 2022-10-14 00:00:00 |  |  | 39305.6
 | 2022-10-17 00:00:00 |  |  | 39920.45 |  |  |  | second week
 | 2022-10-18 00:00:00 |  |  | 40318.75
 | 2022-10-19 00:00:00 |  |  | 40373.2
 | 2022-10-20 00:00:00 |  |  | 40099.55
 | 2022-10-21 00:00:00 |  |  | 40784.05
 | 2022-10-24 00:00:00 |  |  | 41304.9
 | 2022-10-25 00:00:00 |  |  | 41122.75
 | 2022-10-27 00:00:00 |  |  | 41299.3
 | 2022-10-28 00:00:00 |  |  | 40990.85
 | 2022-10-31 00:00:00 |  |  | 41307.9
 | 2022-11-01 00:00:00 |  |  | 41289.55
 | 2022-11-02 00:00:00 |  |  | 41146.65
 | 2022-11-03 00:00:00 |  |  | 41298.35
 | 2022-11-04 00:00:00 |  |  | 41258.45
 | 2022-11-07 00:00:00 |  |  | 41686.7