tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71435d1272150156-inserting-page-breaks-with-a-formula-demo4ix
Sheet: Sheet1

POLICY DETAILS (GOLD CARD #1)
Policy Num | [NAME] |  | Insured Name | [NAME], [NAME] |  | Insured Phone | [PHONE]
Status | ACTIVE |  | Issue Age | 75 |  | Sex | M
D.O.B. | 1928-01-01 00:00:00 |  | Issue State | TX |  | Resident State | TX
Address 1 | 664-C R 3340
Address 2
City | Dallas |  | State | TX |  | Zip | 75201
Owner Name | [NAME], [NAME] |  | Payor Name | [NAME], [NAME] |  | [NAME] | PAC
Reinstate Agt |  |  | Mode Premium | 453 |  | Mode | PAC
Issue Date | 5/1/2003 |  | Paid-To Date | 9/1/2010 |  | Term Date
Last Act Date | 3/5/2010 |  | Maint Date | 5/6/2003
PLAN(S) DETAILS
Plan | Plan Name |  | Insured Name |  | Face Amt | Sex | Status | Iss Date
5020FL12 | MEDICARE SUPPLEMENT PLAN F |  | [NAME], [NAME] |  | $1,000.00 | M | A | 2003-05-01 00:00:00
 | Agent # | Agent Name | Office # | Split %
 | 111111 | [NAME] | 4040404 | 100%
POLICY DETAILS (GOLD CARD #2)
Policy Num | 777777 |  | Insured Name | Jones, [NAME] |  | Insured Phone | [PHONE]
Status | ACTIVE |  | Issue Age | 74 |  | Sex
D.O.B. | 03/19/1929 |  | Issue State | TX |  | Resident State | TX
Address 1 | 1234 Main St
Address 2
City | Dallas |  | State | TX |  | Zip | 75201
Owner Name | Jones, [NAME] |  | Payor Name | Jones, [NAME] |  | [NAME] | PAC
Reinstate Agt |  |  | Mode Premium | $310.00 |  | Mode | PAC
Issue Date | 5/1/2003 |  | Paid-To Date | 5/1/2010 |  | Term Date
Last Act Date | 4/1/2010 |  | Maint Date | 1/9/2003
PLAN(S) DETAILS
Plan | Plan Name |  | Insured Name |  | Face Amt | Sex | Status | Iss Date
5050FL20 | MEDICARE SUPPLEMENT PLAN F |  | JONES, [NAME] |  | $1,000.00 | M | A | 5/1/2003
 | Agent # | Agent Name | Office # | Split %
 | 111111 | [NAME] | 4040404 | 100%
Spreadsheet: 60217d09-d44f-4159-b9d7-e748b4943638
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
FNAD | Test | FNAD | Nadolol, Serum/Plasma | Nadolol | High Performance Liquid Chromatography/Tandem Mass Spectrometry (LC-MS/MS) | EDTA (lavender-top) tube: EDTA OR |  |  | 2 | mL | Submit only 1 of the following specimens.   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of serum refrigerate in plastic vial. Note:  1.Indicate serum on request form.                2.Label specimen appropriately (serum).   [NAME] blood in a lavender-top (EDTA) tube(s). ([NAME] tube is not acceptable.) Spin down and send 2 mL of EDTA plasma refrigerate in plastic vial Note:  1.Indicate plasma on the request form.                2.Label specimen appropriately (plasma). | 0.7 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reporting limit determined each analysis  Synonym(s):  Corgard   Mean steady-state plasma levels following a daily regimen:      80 mg:   26 - 36 ng/mL     160 mg:  52 - 74 ng/mL     320 mg:  154 - 191 ng/mL     Test Performed By:  NMS Labs                                          3701 Welsh Road                                          PO Box 433A                                          [NAME], PA  19090-0437 | Tuesday and Thursday | 2 days | 4 - 7 days | 1 | 83789 |  |  |  |  | NMS Labs
FNAD | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FNAD | Result | Z1430 | Nadolol | Nadolol | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 12406-5
FNAD | Result | Z1867 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 217469d1362074819-if-statement-reading-incorrectly-208-if-statement-reading-incorrectly
Sheet: Sheet1

11 | 530 |  |  | <<Cell with the formula
12 | 590
13 | 640 | <<< This table can be put somewhere else or hidden.
14 | 690
15 | 740
16 | 790
17 | 830
18 | 870
19 | 910
20 | 950
21 | 990
22 | 1030
23 | 1070
24 | 1100
25 | 1150
26 | 1190
27 | 1220
28 | 1260
29 | 1300
30 | 1340
31 | 1380
32 | 1420
33 | 1460
34 | 1510
35 | 1560
36 | 1600 |  |  |  |  | 15
Spreadsheet: 870793d1717233981-sumifs-substitute-2d_spill-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Women
Country X | Bolly
Country X | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 984 |  | 984
Country X | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9582 |  | 9582
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 654 |  | 654
Country X | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50263 |  | 50263
Country X | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.136 |  | 3.136
Country X | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Country X | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 25
Country X | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3310 |  | 3310
Country X | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3575 |  | 3575
Country X
Country X Total | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68652.136
Country Y | Bolly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  | 120
Country Y | Pumpkin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1940 |  | 1940
Country Y | Chicken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11541 |  | 11541
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  | 57
Country Y | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3100 |  | 3100
Country Y | Mango |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 |  | 82
Country Y | Tumbaktu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Country Y | Rhodoendron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38021 |  | 38021
Country Y | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2083 |  | 2083
Country Y | Pure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1321 |  | 1321
Country Y
Country Y Total | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58265
Spreadsheet: richard_ring__31562__FETZERCAPS2001
Sheet: RECAPMONTHLY

 |  |  | FETZER VINEYARDS GREENPOWER COMSUMPTION
 | Report as of: | 2001-08-31 00:00:00 | TOTAL COMMERICAL CONSUMPTION
 |  |  | PRODUCT  -   100%
 | MONTHLY RECAP |  | Report Revised   ----   April 9, 2001 |  | 2001-09-14 00:00:00
 |  |  | Prepared By [NAME] [PHONE]
 | MONTH |  | # OF CUSTOMERS |  | REPORTABLE CONSUMPTION | TOTAL CONSUMPTION
 | 2001-01-01 00:00:00 |  | 15 |  | 257153 | 418670
 | 2001-02-01 00:00:00 |  | 15 |  | 244306 | 309935
 | 2001-03-01 00:00:00 |  | 0 |  | 0 | 0
 | 2001-04-01 00:00:00 |  | 15 |  | 317153 | 422147
 | 2001-05-01 00:00:00 |  | 16 |  | 258244 | 380014
 | 2001-06-01 00:00:00 |  | 0 |  |  | 0
 | 2001-07-01 00:00:00 |  | 15 |  | 352536 | 642934
 | 2001-08-01 00:00:00 |  | 15 |  | 266485 | 571336
 | 2001-09-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
Spreadsheet: 716861d1612386749-formula-for-difference-between-two-times-to-report-hours-and-mins-between-22-00-and-06-00-test-ss
Sheet: Sheet1

 |  |  |  |  |  | Need the hrs worked between C & D between the hours of 22:00 & 06:00 only
 | In Date | In Time | Out Date | Out Time
 | 2021-01-04 00:00:00 | 20:40:00 | 2021-01-05 00:00:00 | 08:44:00 |  | 8
 | 2021-01-08 00:00:00 | 17:47:00 | 2021-01-09 00:00:00 | 00:01:00 |  | 2.01
 | 2021-01-14 00:00:00 | 19:40:00 | 2021-01-15 00:00:00 | 05:24:00 |  | 7.24
Spreadsheet: 124334d1318339576-due-date-programming-log-test
Sheet: Sheet1

CUSTOMER NAME | PURCHASE ORDER # | DATE RECEIVED FROM CUSTOMER | SALES REP. | DUE DATE | DATE GIVEN TO DRAFTING | DRAFTER | DRAFTING PROCESS | PERTINENT DRAFTING/DELAY NOTES | ESTIMATED DRAFTING COMPLETION DATE | DRAFTER | DRAFTING TIME | ACTUAL DRAFTING COMPLETION DATE | RECEIVED IN DATA ENTRY | COMPLETED W/O TO FLOOR | ORDER ENTRY INITIALS | DATA ENTRY NOTES
 |  | 2011-09-07 00:00:00 |  | 2011-09-28 00:00:00 | 2011-09-02 00:00:00 | SS | PROGRAM |  | 2011-09-04 00:00:00 | SS |  | 2011-09-09 00:00:00 | - | - | - | -
 |  | 2011-09-02 00:00:00 |  | 2011-09-21 00:00:00 | 2011-09-02 00:00:00 | SS | PROGRAM |  | 2011-09-04 00:00:00 | SS |  |  | - | - | - | -
 |  | 2011-09-02 00:00:00 |  | 2011-11-30 00:00:00 | 2011-09-02 00:00:00 |  | PROGRAM |  | 2011-09-04 00:00:00 |  |  |  | - | - | - | -
 |  | 2011-09-07 00:00:00 |  | 2011-11-23 00:00:00 | 2011-10-08 00:00:00 |  | PROGRAM |  | 2011-10-10 00:00:00 |  |  |  | - | - | - | -
 |  |  |  |  | 2011-10-07 00:00:00 |  |  |  | 2011-10-09 00:00:00
 |  |  |  |  | 2011-10-10 00:00:00 |  |  |  | 2011-10-12 00:00:00
 |  |  |  |  | 2011-10-10 00:00:00 |  |  |  | 2011-10-12 00:00:00 |  |  | 2011-10-19 00:00:00
 |  |  |  |  | 2011-10-10 00:00:00 |  |  |  | 2011-10-12 00:00:00
 |  |  |  |  | 2011-10-09 00:00:00 |  |  |  | 2011-10-11 00:00:00
 |  |  |  | 2011-10-05 00:00:00 | 2011-10-16 00:00:00 |  |  |  | 2011-10-18 00:00:00
 |  |  |  |  | 2011-10-18 00:00:00 |  |  |  | 2011-10-20 00:00:00
 |  |  |  |  | 2011-10-19 00:00:00 |  |  |  | 2011-10-21 00:00:00
Spreadsheet: 4bad7195-66b8-48f7-9cf0-12472147fc0b
Sheet: All You May 2012

All You Coupons May 2012 |  | done 7/31
Coupon Name | Value | Expiration date | Page
Aquafresh Kids Toothpaste | 1 | 2012-06-30 00:00:00 | p. 121
BIC® Razors | 2 | 2012-06-09 00:00:00 | p. 46
[NAME] | 1 | 2012-08-31 00:00:00 | p. 53
Comet™ Stainless Steel Spray Cleaner, Cream Cleanser &  Polish or Powder Cleanser | 0.75 | 2012-10-01 00:00:00 | p. 57
DIGIORNO® Pizza [NAME] | $0.75 on 1 | 2012-06-30 00:00:00 | p. 126
[NAME] All Natural Fruit Jars | 0.75 | 2012-06-30 00:00:00 | p. 113
Dulcolax® Laxative Tablets for Women, 25 ct. or larger | 2 | 2012-12-31 00:00:00 | p. 61
Dulcolax® Product (any), 25 ct. or larger | 1.5 | 2012-12-31 00:00:00 | p. 61
e.p.t.® | 2 | 2012-08-31 00:00:00 | p. 53
Extra® Gum | $0.50 on any 2 15-stick packs | 2012-06-30 00:00:00 | p. 39
Fashion Bug | $10 off your purchase of $25 or more | 2012-05-31 00:00:00 | p. 43
Gentle Naturals® | 1 | 2012-08-31 00:00:00 | p. 53
Glade® Spring Collection | 1 | 2012-07-27 00:00:00 | p. 100
HOT POCKETS® brand SNACKERS (10 oz.) | $1.00 on any 2 | 2012-06-30 00:00:00 | p. 126
JACK’S® Pizza (15–30.5 oz.) | $0.75 on any 1 | 2012-06-30 00:00:00 | p. 87
[NAME] | 0.5 | 2012-10-31 00:00:00 | p. 85
Luzianne® Tea | 0.5 | 2012-07-31 00:00:00 | p. 94
[NAME] | $0.75 off any 2 | 2012-08-31 00:00:00 | p. 92
[NAME] Entrée, 20 oz. or more | 1.5 | 2012-06-30 00:00:00 | p. 96
NESTLÉ frozen snack (excludes singles) | $1.00 on any 1 | 2012-06-30 00:00:00 | p. 126
NYC New York Color | $1.50 off any 2 NYC New York Color  products that are priced $1.72 or more | 2012-05-31 00:00:00 | p. 31
NYC Product and All You magazine’s June issue | $1.00 with the purchase of All You  magazine’s June issue and any NYC product | 2012-06-22 00:00:00 | p. 128
Olivari Mediterranean Olive Oil® | 1 | 2012-07-31 00:00:00 | p. 131
[NAME] | 1 | 2012-06-30 00:00:00 | p. 102
Ragú® | 1.5 | 2012-05-27 00:00:00 | p. 1
[NAME] Beauty Tools | $2.00 off any beauty tool purchase of $4.00 or more | 2012-05-31 00:00:00 | p. 35
Sergeant’s® Pronyl OTC™ [NAME] | 5 | 2012-08-06 00:00:00 | p. 104
[NAME] | 2 | 2012-05-31 00:00:00 | p. 24
STOUFFER’S® FARMERS’ HARVEST® Steam Perfect Bags | $1.00 on any 2 | 2012-06-30 00:00:00 | p. 126
STOUFFER’S® Multi-Serve Entrée (28–96 oz.) | 1.5 | 2012-06-30 00:00:00 | p. 71
List compile at FabulesslyFrugal.com
Spreadsheet: 03dbe0c4-a774-485a-b7a8-661fb6dc16e9
Sheet: 2012 math grade 9

[NAME] |  | Total Number | [NAME]
Grade 9 |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 558 | 15 | 24 | 29 | 15 | 11 | 7
2011 |  | 552 | 15 | 25 | 30 | 18 | 8 | 4
2012 | All Students | 519 | 14 | 24 | 29 | 18 | 9 | 5
 | Asian | 20 | 25 | 25 | 40 | 5 | 5
 | Black or African American | 34 | 21 | 24 | 21 | 18 | 15 | 3
 | Hispanic or Latino | 175 | 16 | 21 | 34 | 15 | 10 | 3
 | White | 271 | 12 | 28 | 25 | 19 | 9 | 7
 | Minority | 248 | 17 | 21 | 32 | 17 | 10 | 4
 | English Learners | 70 | 20 | 17 | 31 | 11 | 16 | 4
 | Free/Reduced Lunch | 284 | 13 | 23 | 30 | 19 | 11 | 5
 | Female | 202 | 14 | 29 | 29 | 14 | 8 | 6
 | Male | 316 | 15 | 22 | 29 | 20 | 10 | 4
Spreadsheet: 143974d1330648735-add-table-example
Sheet: Sheet2

 |  |  |  | it | hr | fin | it
 |  |  | apple | 1 | 2 | 3 | 4
 |  |  | pear | 5 | 6 | 7 | 8
 |  |  | apple | 9 | 10 | 11 | 12
 |  |  | orange | 13 | 14 | 15 | 16
 |  | apple | it
 |  | pear | it
 |  | orange | it
Spreadsheet: 72392d1273072615-weekly-vs-month-to-date-book1
Sheet: Sheet1

 | Date | Day | Feet Mined
 | 2010-05-31 00:00:00 | Monday | 75
 | 2010-06-01 00:00:00 | Tuesday | 25
 | 2010-06-02 00:00:00 | Wednesday | 50
 | 2010-06-03 00:00:00 | Thursday | 25
 | 2010-06-04 00:00:00 | Friday | 10
 | 2010-06-05 00:00:00 | Saturday | 10
 | 2010-06-06 00:00:00 | Sunday | 25
 | Weekly Total
 | MTD Total
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 162000 | 164214
2 | 165112 | 164214
3 | 166252 | 167214
4 | 159596 | 159052
5 | 151508 | 151275
6 | 111224 | 110803
7 | 147181 | 147214
8 | 148252 | 147214
9 | 142380 | 142638
10 | 146106 | 146975
11 | 157270 | 157014
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 4822
2001-07-11 00:00:00
Spreadsheet: 673767d1587532347-need-to-highlight-column-showing-current-week-1-4-as-per-month-help-me
Sheet: ANNUAL PLANNER

Job Description (excludes travel) | Location | Frequency | Qty | Hrs | Staff | 2020-04-01 00:00:00 |  |  |  | 2020-05-01 00:00:00 |  |  |  | 2020-06-01 00:00:00 |  |  |  | 2020-07-01 00:00:00 |  |  |  | 2020-08-01 00:00:00 |  |  |  | 2020-09-01 00:00:00 |  |  |  | 2020-10-01 00:00:00 |  |  |  | 2020-11-01 00:00:00 |  |  |  | 2020-12-01 00:00:00 |  |  |  | 2021-01-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-03-01 00:00:00 |  |  |  | 2021-08-01 00:00:00 |  |  |  | 2021-09-01 00:00:00 |  |  |  | 2021-10-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-12-01 00:00:00 |  |  |  | 2022-01-01 00:00:00 |  |  |  | 2022-02-01 00:00:00 |  |  |  | 2022-03-01 00:00:00 |  |  |  | 2022-04-01 00:00:00 |  |  |  | 2022-05-01 00:00:00 |  |  |  | Comments | CONTRACTOR
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
Job 1 | All sites |  |  | 16 | Ext
Job 2 | All sites |  |  | 16 | Ext
Job 3 | All sites |  |  | 24 | Ext
Job 4 | All sites |  |  | 4 | Ext
Job 5 | All sites | Annual |  | 2 | Ext
Job 6 | All sites |  |  | 4 | Ext
Job 7 | All sites |  |  | 4 | Ext
Job 8 | All sites |  |  | 16 | Ext
Job 9 | All sites | Monthly | 5 | 144 | 1
Job 10 | All sites | Annual |  | 32 | 2
Job 11 | All sites | Annual |  | 32 | 2
Job 12 | All sites | Annual |  | 32 | 2
Job 13 | All sites |  | 1 | 80 | 2
Job 14 | All sites |  | 1 | 80 | 2
Job 15 | All sites |  | 1 | 80 | 2
Job 16 | All sites | Bi-annual | 5 | 40 | 1
Job 17 | All sites | 3 year | 5 | 20 | Ext |  |  |  |  |  |  |  |  |  |  |  |  | Due 2023
Job 18 | All sites | Bi-annual | 1 | 16 | 2
Job 19 | All sites | Annual | 5 |  | EXT
Job 20 | All sites | Monthly | 5 | 5 | 1
Job 21 | All sites | Annual | 2 | 16 | 1
Job 22 | All sites | Annual | 1 | 32 | 2
Job 23 | All sites | Annual | 2 | 16 | 1
Job 24 | All sites | Annual | 2 | 4 | 1
Job 25 | All sites | Annual | 2 | 32 | 2
Job 26 | All sites | Monthly | 1 | 2 | 1
Job 27 | All sites | Quarterly | 1 | 2 | 1
Total time required to complete tasks |  |  | Hrs
Total working weeks per year |  |  | [NAME] |  |  | Normal working week = 40 hours minus 30min/day smoko breaks. Therefore normal working week production is 37.5hrs/person
Staff required |  |  |  |  |  | Ave working hours per week/person is 37.5
 |  |  |  |  |  | Each person is allocated 20 days annual and 10 days stat leave per year
 |  |  |  |  |  | Working weeks/person/year is 46
Spreadsheet: 220344d1363124873-index-match-play
Sheet: People&Hours

 |  |  |  |  |  | Room
Room | Date | Total People | Total Hours | Additonal Resource Hours |  | Date | Room Number | Total People | Total Hours
1 | 2013-02-11 00:00:00 | 3 | 24 |  |  | 2013-02-11 00:00:00 | 1 | 3 | 12
2 | 2013-02-11 00:00:00 | 2 |  |  |  | 2013-02-12 00:00:00 | 1 | 2 | 12
3 | 2013-02-11 00:00:00 | 3 |  |  |  | 2013-02-13 00:00:00 | 2 | 3 | 12
1 | 2013-02-12 00:00:00 | 3 | 40 |  |  | 2013-02-14 00:00:00 | 2 | 3 | 25
2 |  | 5 |  |  |  | 2013-02-15 00:00:00 | 3 | 2 | 25
3 |  | 6 |  |  |  | 2013-02-18 00:00:00 | 3 | 2 | 10
1 | 2013-02-13 00:00:00 | 6 | 40 |  |  | 2013-02-19 00:00:00 | 3 | 2 | 12
2 |  | 6 |  |  |  | 2013-02-20 00:00:00 | 4 | 3 | 23
3 |  | 6 |  |  |  | 2013-02-21 00:00:00 | 4 | 3 | 22
1 | 2013-02-14 00:00:00 | 8 | 24 |  |  | 2013-02-22 00:00:00 | 4 | 3 | 23
2 |  | 3 |  |  |  | 2013-02-23 00:00:00 | 5 | 3 | 24
3 |  | 3 |  |  |  | 2013-02-24 00:00:00 | 5 | 3 | 25
1 | 2013-02-15 00:00:00 | 9.5 | 40 |  |  | 2013-02-25 00:00:00 | 5 | 3 | 25
2 |  | 3 |  |  |  | 2013-02-26 00:00:00 | 5 | 3 | 25
3 |  | 3
1 | 2013-02-18 00:00:00 | 11.1 | 40
2 |  | 2
3 |  | 4
1 | 2013-02-19 00:00:00 | 12.7 | 24
2 |  | 3
3 |  | 3
1 | 2013-02-20 00:00:00 | 14.3 | 40
2 |  | 9
3 |  | 8
1 | 2013-02-21 00:00:00 | 15.9 | 40
2
3
1 | 2013-02-22 00:00:00 | 17.5 | 21
2 |  | 2 | 20
3 |  | 3 | 20
1 | 2013-02-23 00:00:00 | 6 | 36
2 |  | 6 | 60
3 |  | 6 | 60
1 | 2013-02-24 00:00:00 | 8 | 60
2 |  | 9 | 30
3 |  | 12 | 99
1 | 2013-02-25 00:00:00 | 12 | 200
2
3
1 | 2013-02-26 00:00:00 | 11 | 36
2
3
Spreadsheet: 792043d1660718878-part-no-creation-i-want-to-create-a-unique-part-no-based-on-spreadsheet-data-example-part-no-formula
Sheet: Sheet1

Category | Type | Part No. | Desired Result
APPLIANCES | REPLACEMENT |  | APP-1-001
APPLIANCES | REPLACEMENT |  | APP-1-002
APPLIANCES | REPLACEMENT |  | APP-1-003
APPLIANCES | REPLACEMENT |  | APP-1-004
APPLIANCES | REPLACEMENT |  | APP-1-005
APPLIANCES | REPLACEMENT |  | APP-1-006
APPLIANCES | INSTALLATION |  | APP-2-001
APPLIANCES | INSTALLATION |  | APP-2-002
APPLIANCES | INSTALLATION |  | APP-2-003
APPLIANCES | INSTALLATION |  | APP-2-004
APPLIANCES | INSTALLATION |  | APP-2-005
APPLIANCES | CLIENT SUPPLIED |  | APP-3-001
APPLIANCES | CLIENT SUPPLIED |  | APP-3-002
APPLIANCES | CLIENT SUPPLIED |  | APP-3-003
APPLIANCES | CLIENT SUPPLIED |  | APP-3-004
LIGHTING | REPLACEMENT |  | LIG-1-001
LIGHTING | REPLACEMENT |  | LIG-1-002
LIGHTING | REPLACEMENT |  | LIG-1-003
LIGHTING | REPLACEMENT |  | LIG-1-004
LIGHTING | INSTALLATION |  | LIG-2-001
LIGHTING | INSTALLATION |  | LIG-2-002
LIGHTING | INSTALLATION |  | LIG-2-003
LIGHTING | INSTALLATION |  | LIG-2-004
LIGHTING | CLIENT SUPPLIED |  | LIG-3-001
LIGHTING | CLIENT SUPPLIED |  | LIG-3-002
LIGHTING | CLIENT SUPPLIED |  | LIG-3-003
Spreadsheet: 770068d1645800532-vlookup-issue-with-only-one-cell-copy-of-payroll
Sheet: Payroll data

Emp No | Employee Name | Site | Distribution | SSP | Absence deduction | Allied Mills Lunch Allowance (250) | Allied Mills Mileage Allowance  251 | Night Out Allowance NT (230) | Allied Mills Personal Expenses (252) | Non pensionable pay (Cash) 240(trigger payments) | Management Bonus NP Cash 248 | Overtime hours | Overtime Cash
 | WAGE TYPE |  |  | SSPP | 3281 | 3217 |  | 3037 | 3218 | 3237 | 3108 | 2002 | 2022
11012007 | Mr [NAME] | [NAME]
11009109 | Mr [NAME] | [NAME]
11013719 | Mr [NAME] | [NAME]
11016002 | Mr [NAME] | [NAME]
11204199
11009070 | Mr [NAME] | [NAME]
11010702 | Mr [NAME] | [NAME]
20000810 | Mr [NAME] | [NAME]
11206870 | Mr [NAME] | [NAME]
11206900
11201313
11202396 | Mr [NAME] | [NAME]
20000740 | Mr [NAME] | [NAME]
11205262
11206914
11206232
11206466
11206947 | Mr [NAME] | [NAME]
11207194 | Mr [NAME] | [NAME]
20000903 | Mr [NAME] | [NAME]
11206899
11009080 | Mr [NAME] | [NAME]
11009140 | Mr [NAME] | JNL
11010625 | Mr [NAME] | [NAME]
11016091
11016099
11016101 | Mr [NAME] | JNL
11201311
11204173 | Mr [NAME] | JNL
11205995
11207152 | Mr [NAME] | JNL
11009160 | Mr [NAME] | JNL
11014064 | Mr [NAME] | JNL
11009083 | Mr [NAME] | [NAME]
11009088 | Mr [NAME] | [NAME]
11009027
20000850 | Mr [NAME] | [NAME]
20000873 | Mr [NAME] | [NAME]
11010889 | Mr [NAME] | [NAME]
11203184 | Mr [NAME] | [NAME]
11203736
11204611 | Mr [NAME] | [NAME]
11204697 | Mr [NAME] | [NAME]
11205147
11205503
11206875 | Mr [NAME] | [NAME]
11206877 | Mr [NAME] | [NAME]
11009109 | Mr [NAME] | [NAME]
11206911
11207069
20000551
11207076
11207199 | Mr Damian Majer | [NAME]
11207329
Spreadsheet: 272504d1382411909-count-of-account-numbers-length-of-stay-sample
Sheet: Sheet1

Account Number | Time In | Time Out | Unit | Length of Stay |  |  | Row Labels | Sum of Length of Stay
X123 | 12:53:00 | 12:54:00 | 4 |  |  |  | X123 | 0:08:00
X123 | 12:54:00 | 13:01:00 | 5 |  |  |  | X456 | 0:04:00
X456 | 01:06:00 | 01:10:00 | 4 |  |  |  | X789 | 1:52:00
X789 | 07:08:00 | 07:09:00 | 3 |  |  |  | Grand Total | 2:04:00
X789 | 07:09:00 | 08:10:00 | 4
X789 | 08:10:00 | 09:00:00 | 5
Spreadsheet: 111806d1308089588-how-to-use-sumif-with-multiple-rows-of-each-instance-example
Sheet: Sheet3

2011-04-01 00:00:00 |  | 2011-04-01 00:00:00
2011-04-02 00:00:00 |  | 2011-04-02 00:00:00
2011-04-03 00:00:00 |  | 2011-04-03 00:00:00
2011-04-04 00:00:00 |  | 2011-04-04 00:00:00
2011-04-05 00:00:00 |  | 2011-04-05 00:00:00
2011-04-06 00:00:00 |  | 2011-04-06 00:00:00
2011-04-07 00:00:00 |  | 2011-04-07 00:00:00
2011-04-08 00:00:00 |  | 2011-04-08 00:00:00
2011-04-09 00:00:00 |  | 2011-04-09 00:00:00
2011-04-10 00:00:00 |  | 2011-04-10 00:00:00
2011-04-11 00:00:00 |  | 2011-04-11 00:00:00
2011-04-12 00:00:00 |  | 2011-04-12 00:00:00
2011-04-13 00:00:00 |  | 2011-04-13 00:00:00
2011-04-14 00:00:00 |  | 2011-04-14 00:00:00
2011-04-15 00:00:00 |  | 2011-04-15 00:00:00
2011-04-16 00:00:00 |  | 2011-04-16 00:00:00
2011-04-17 00:00:00 |  | 2011-04-17 00:00:00
2011-04-18 00:00:00 |  | 2011-04-18 00:00:00
2011-04-19 00:00:00 |  | 2011-04-19 00:00:00
2011-04-20 00:00:00 |  | 2011-04-20 00:00:00
2011-04-21 00:00:00 |  | 2011-04-21 00:00:00
2011-04-22 00:00:00 |  | 2011-04-22 00:00:00
2011-04-23 00:00:00 |  | 2011-04-23 00:00:00
2011-04-24 00:00:00 |  | 2011-04-24 00:00:00
2011-04-25 00:00:00 |  | 2011-04-25 00:00:00
2011-04-26 00:00:00 |  | 2011-04-26 00:00:00
2011-04-27 00:00:00 |  | 2011-04-27 00:00:00
2011-04-28 00:00:00 |  | 2011-04-28 00:00:00
2011-04-29 00:00:00 |  | 2011-04-29 00:00:00
2011-04-30 00:00:00 |  | 2011-04-30 00:00:00
2011-05-01 00:00:00 |  | 2011-05-01 00:00:00
2011-05-02 00:00:00 |  | 2011-05-02 00:00:00
2011-05-03 00:00:00 |  | 2011-05-03 00:00:00
2011-05-04 00:00:00 |  | 2011-05-04 00:00:00
2011-05-05 00:00:00 |  | 2011-05-05 00:00:00
Spreadsheet: 575a5530-824c-4bca-9e9f-fe862fd00513
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3600 | 10330 | Ulrike | Striednig | AUT | 188 | [NAME] | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 1 | [NAME]
3600 | 21907 | Gertrud | Harer | GER | 185 | 00:23:25 | 00:00:00 | 00:38:25 | 00:00:00 | [NAME] | 2 | 01:31:25
3600 | 15679 | Sabine | Houdek | GER | 186 | 00:25:38 | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 3 | 01:35:30
3600 | 21906 | Elke | Schanz-Matern | GER | 187 | 00:24:01 | 00:00:00 | 00:42:56 | 00:00:00 | 00:00:00 |  | 00:00:00