tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 453922d1459518982-attendance-point-tracker-attendance-tracker
Sheet: Bids

Team Details | Team | Headcount | W/D Shift | W/E Shift | Days Worked | Days Off | Team Leader | Shift Manager | Q2 Rank
Team 01 -MTWRF-  (21)  04:30 - 14:00 | BMG01 | (19) | 04:30 - 14:00 | n/a | -MTWRF- | SY | [NAME] | Aragon | 2
Team 02 -MTWRF-  (21)  06:00 - 15:00 | BMG02 | (20) | 06:00 - 15:00 | n/a | -MTWRF- | SY | [NAME] | Aragon | 1
Team 03 -MTW-FY  (21)  07:00 - 16:00 | BMG03 | (20) | 07:00 - 16:00 | (Y) 07:00 - 16:00 | -MTW-FY | SR | [NAME] | Aragon | 4
Team 04 SMTWR--  (21)  07:00 - 16:00 | BMG04 | (20) | 07:00 - 16:00 | (S) 10:00 - 19:00 | SMTWR-- | FY | [NAME] | Aragon | 3
Team 05 SM--RFY  (19)  07:00 - 16:00 | BMG05 | (19) | 07:00 - 16:00 | 10:00 - 19:00 | SMT--FY | WR | [NAME] | Aragon | 7
Team 06 -MTWR-Y  (21)  09:00 - 18:00 | BMG06 | (21) | 09:00 - 18:00 | (Y) 09:00 - 18:00 | -MTWR-Y | SF | Cecil [NAME] | Aragon | 5
Team 07 SMTW--Y  (19)  08:00 - 19:00 | BMG07 | (18) | 08:00 - 19:00 | 11:00 - 16:00 | SMTW--Y | RF | [NAME] | [NAME] | 10
Team 08 SMTWR--  (21)  10:00 - 19:00 | BMG08 | (21) | 10:00 - 19:00 | (S) 10:00 - 19:00 | SMTWR-- | FY | [NAME] | [NAME] | 6
Team 09 SMT--FY  (19)  10:00 - 19:00 | BMG09 | (16) | 10:00 - 19:00 | 10:00 - 19:00 | SMT--FY | WR | [NAME] | [NAME] | 8
Team 10 SM--RFY  (19)  10:00 - 19:00 | BMG10 | (18) | 10:00 - 19:00 | 10:00 - 19:00 | SM--RFY | TW | [NAME] | [NAME] | 12
Team 11 SMTW--Y  (18)  10:00 - 19:00 | BMG11 | (17) | 10:00 - 19:00 | 10:00 - 19:00 | SMTW--Y | RF | [NAME] | [NAME] | n/a
Team 12 -MTWRF-  (20)  12:00 - 21:00 | [NAME] | (19) | 12:00 - 21:00 | n/a | -MTWRF- | SY | [NAME] | [NAME] | 9
Team 13 SMT--FY  (19)  11:00 - 20:00 | BMG13 | (19) | 11:00 - 20:00 | 10:00 - 19:00 | SMT--FY | WR | Meredith Bridschge | [NAME] | 11
Team 14 -MT-RFY  (18)  12:00 - 21:00 | BMG14 | (15) | 12:00 - 21:00 | (Y) 08:30 - 17:30 | -MT-RFY | SW | [NAME] | Aragon | n/a
Mentor 01 -MTWRF- (20) 09:00 - 13:00 | Men01 | (20) | 09:00 - 18:00 | n/a | -MTWRF- | SY | [NAME] | [NAME] | n/a
Mentor 02 -MTWRF-  (20) 13:00 - 22:00 | Men02 | (20) | 13:00 - 22:00 | n/a | -MTWRF- | SY | Meagan Niemeyer | [NAME] | n/a
Esc 01 -MTWRF-  (20) 07:00 - 16:00 | Esc01 | (20) | 07:00 - 16:00 | n/a | -MTWRF- | SY | [NAME] | Aragon | n/a
Esc 02 -MTWR-Y  (20) 11:00 - 20:00 | Esc02 | (20) | 10:00 - 19:00 | (S) 10:00 - 19:00 | -MTWR-Y | SF | [NAME] | Aragon | n/a
Spreadsheet: 219404d1362750487-copying-a-formula-but-changing-a-row-reference-sample080313
Sheet: Overview

Sales table 1 - overview of key metrics
 | Metric 27 |  | Metric 5 |  | Metric 12
 | Target | Actual | Target | Actual | Target | Actual
January | 27 | 28 | 5 | 6 | 12 | 13
February | 55 |  | 33 |  | 40
March
April
May
June
July
August
September
October
November
December
 | Metric 27 |  | Metric 5 |  | Metric 12
 | Target | Actual | Target | Actual | Target | Actual
January | 27 | 28 | 5 | 6 | 12 | 13
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 734345d1622119066-automatic-summing-of-data-book1
Sheet: Sheet1

 | OrderNo | Shipment Number | Approval date | [NAME] | Item Number | orderline | Qty | Column1 | ABC | Current costs | new costs | difference
 | 6614352 | 15488861 | 20210415 | NL | [NAME] | 1 | 1 |  | B | 7.682597509330657 | 7.682597509330657 | 0
 | 6614352 | 15488861 | 20210415 | NL | BLC2217888885 | 1 | 1 |  | B | 7.682597509330657 | 7.682597509330657 | 0
 | 6614352 | 15488861 | 20210415 | NL | [NAME] | 1 | 1 |  | B | 7.682597509330657 | 7.682597509330657 | 0
 | 6614352 | 15488861 | 20210415 | NL | [NAME] | 1 | 1 |  | B | 7.682597509330657 | 7.682597509330657 | 0
 | 6614352 | 16292148 | 20210415 | FR | BLC2197886746 | 1 | 1 |  | A | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614352 | 16292148 | 20210415 | FR | BLC2207888158 | 1 | 1 |  | A | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614352 | 16292148 | 20210415 | FR | BLC2207888159 | 1 | 1 |  | A | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614352 | 16292148 | 20210415 | FR | BLC2217888884 | 1 | 1 |  | A | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614352 | 16292148 | 20210415 | FR | BLC2217888896 | 1 | 1 |  | A | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614352 | 16292148 | 20210415 | FR | BLC2217889319 | 1 | 1 |  | B | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614352 | 16292148 | 20210415 | FR | BLC2217889356 | 1 | 1 |  | A | 11.50837047355625 | 9.991677694522025 | -1.51669277903423
 | 6614374 | 16763279 | 20210405 | NL | ESHET300MGG01S43000 | 1 | 1 |  | C | 7.682597509330657 | 7.682597509330657 | 0
 | 6614374 | 16763279 | 20210405 | NL | ESHET300MGG01S44000 | 1 | 1 |  | C | 7.682597509330657 | 7.682597509330657 | 0
Spreadsheet: 794018d1661853592-index-and-match-with-multiple-with-rows-sample-workbook
Sheet: Service Report Page 1 of 2

SERVICE REPORT | Gas Analysis Services Ltd. Unit 1C, N11 South Point Business Park, [NAME], Rathnew Co. [NAME], Ireland.                                                       [NAME]: +353-(0)1-2761984, [NAME]: [EMAIL]. www.gasanalysis.eu
Report Title:
RAMS Complete (Yes/No/ N/A) |  | RGC No. | 6110
Customer Name |  | GAS Identification Tag
Site Address |  | Contract Frequency
User Contact Details |  | Date of Calibration
Test Location |  | Previous Calibration Date
Instrument Make and Model |  | Next Calibration date
Method Used |  | Serial Numbers
Reported Faults |  | Cust Tag Number
Plant Condition |  | Service Report Number
Instrument Diagnostics |  | Parameter Before | Parameter After
Sample System Components | Part No. | Status
N/A | N/A | N/A
N/A | N/A | N/A
N/A | N/A | N/A
N/A | N/A | N/A
N/A | N/A | N/A
All cells to be populated. Where information is not available, not documented or not complete please input as N/A.(Not Applicable)
Service Report
Part Replaced
Part No. |  | Description
Part No. |  | Description
Part No. |  | Description
Further Action Required | N/A
Service Report Template LF-037  Issue No. 2
Spreadsheet: 853707d1703668920-excel-cross-tabulated-dynamic-arrays-in-one-cell-excel-cross-tabulated-dynamic-arrays-in-one-cell
Sheet: TabDin

Data | Ano | Mês | Mês/Ano | [NAME] | [NAME] | [NAME] sem | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-04 00:00:00 |  |  |  |  |  |  | 2 |  | 2 | 6 | 1 | 2 |  |  |  |  |  | Just one formula in cell S9
2023-12-05 00:00:00 |  |  |  |  |  |  | 4 |  | 4 | 3 | 2 | 3
2023-12-06 00:00:00 |  |  |  |  |  |  | 5 |  | 1 | 1 | 3 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AliGW Formula
2023-12-07 00:00:00 |  |  |  |  |  |  | 7 |  | 1 | 4 | 1 |  |  |  |  |  | 49 | [NAME] | [NAME] | Maria | João | Paulo | [NAME]
2023-12-09 00:00:00 |  |  |  |  |  |  | 1 |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 2 | 6 | 1 | 2
2023-12-10 00:00:00 |  |  |  |  |  |  |  | 1 |  | 5 | 2 | 2 |  |  |  |  | Seg | 2 | 0 | 2 | 6 | 1 | 2 |  |  |  |  | Ter | 4 | 0 | 4 | 3 | 2 | 3
2023-12-11 00:00:00 |  |  |  |  |  |  | 4 | 3 |  | 3 | 4 | 4 |  |  |  |  | Ter | 4 | 0 | 4 | 3 | 2 | 3 |  |  |  |  | Qua | 5 | 0 | 1 | 1 | 3 | 6
2023-12-12 00:00:00 |  |  |  |  |  |  | 4 | 5 | 3 | 6 | 5 | 1 |  |  |  |  | Qua | 5 | 0 | 1 | 1 | 3 | 6 |  |  |  |  | Qui | 7 | 0 | 1 | 4 | 1 | 0
2023-12-13 00:00:00 |  |  |  |  |  |  | 4 | 4 | 2 | 8 | 6 | 9 |  |  |  |  | Qui | 7 | 0 | 1 | 4 | 1 | 0 |  |  |  |  | Sáb | 1 | 0 | 0 | 0 | 3 | 0
2023-12-14 00:00:00 |  |  |  |  |  |  | 7 | 13 | 1 | 1 | 7 |  |  |  |  |  | Sex | 0 | 0 | 0 | 0 | 0 | 0
2023-12-15 00:00:00 |  |  |  |  |  |  | 2 | 3 |  | 3 | 1 | 7 |  |  |  |  | Sáb | 1 | 0 | 0 | 0 | 3 | 0
2023-12-16 00:00:00 |  |  |  |  |  |  | 2 | 1 | 1 |  | 8
2023-12-18 00:00:00 |  |  |  |  |  |  | 4 | 1 | 3 |  | 2 | 3 |  |  |  |  | Gregb11 Formula
2023-12-19 00:00:00 |  |  |  |  |  |  | 9 | 3 |  | 6 | 4 | 5
2023-12-20 00:00:00 |  |  |  |  |  |  | 4 | 2 | 1 |  | 6 | 2 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
2023-12-21 00:00:00 |  |  |  |  |  |  | 7 | 14 | 1 | 8 |  |  |  |  |  |  |  | 2 | 0 | 2 | 6 | 1 | 2
2023-12-26 00:00:00 |  |  |  |  |  |  |  | 1 |  | 9 |  |  |  |  |  |  |  | 4 | 0 | 4 | 3 | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0 | 1 | 1 | 3 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 1 | 4 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seg | 2 | 0 | 2 | 6 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ter | 4 | 0 | 4 | 3 | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qua | 5 | 0 | 1 | 1 | 3 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qui | 7 | 0 | 1 | 4 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sex | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sáb | 1 | 0 | 0 | 0 | 3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | windknife [NAME]
Spreadsheet: 702959d1604639703-most-frequent-address-example1930
Sheet: Sheet1 (2)

Excel Forum Example
Invoice No. | Address | Route | Codes | Freight Miles | [NAME] | [NAME] | [NAME] | Weight (lbs)
398020105714 | 3501 Roosevelt Blvd., Middletown, OH |  |  |  |  |  |  | 125
397358235299 | 1995 [NAME], Orange, CA |  |  |  |  |  |  | 150
397390358354 | 135 [NAME]. NW., Albuquerque, NM |  |  |  |  |  |  | 115
397358677973 | 13701 S. Alma Ave., Gardena, CA |  |  |  |  |  |  | 115
397357982242 | 13701 S. Alma Ave., Gardena, CA |  |  |  |  |  |  | 115
396883429790 | 3001 Bloomfield Hwy., Farmington, NW |  |  | 1645 |  |  |  | 220
396883550994 | 3215 Hwy 64, Waterflow, NM |  |  | 1653 |  |  |  | 220
396883671057 | 3001 Bloomfield Hwy., Farmington, NW |  |  | 1645 |  |  |  | 220
395740536532 | 5006 Timberlea Blvd., [NAME], ON |  |  |  |  |  |  | 765
395256316026 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 585
395052368905 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 180
394212196515 | 5-823 Corydon Ave., [NAME], MB |  |  | 1132 |  |  |  | 370
394629516721 | 821 Tyson Rd., [NAME], AL |  |  | 930 |  |  |  | 125
394849267033 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 1000
394629516721 | 821 Tyson Rd., [NAME], AL |  |  | 930 |  |  |  | 125
394212196515 | 5-823 Corydon Ave., [NAME], MB |  |  | 1132 |  |  |  | 370
7218880255 | 10828 [NAME], Dallas, TX |  |  | 1214 |  |  |  | 1225
392732394061 | 6970 Van Buren Blvd., [NAME], CA |  |  | 2340 |  |  |  | 100
393291958977 | 7746 S. Union Park Ave., Midvale, UT |  |  | 1752 |  |  |  | 100
394097276185 | 351 Steelcase Road West, [NAME], ON |  |  | 272 |  |  |  | 285
390467063620 | 1442 Cliveden Ave., Delta, BC |  |  | 2453 |  |  |  | 613
390917362253 | Missing |  |  | 0 |  |  |  | 0
7218880093 | 1700 Northridge NW., Walker, MI |  |  | 172 |  |  |  | 200
7218880196 | 1020-A Derita Rd., Concord, NC |  |  | 678 |  |  |  | 543
779073626737 | 1735 West Front St., Plainfield, NJ |  |  | 647 |  |  |  | 1010
390192722655 | 4000 Eastdale Circle, Montgomery, AL |  |  | 866 |  |  |  | 125
779653759736 | 12610 Interuban Ave S., Seattle, WA |  |  | 2330 |  |  |  | 500
779756829896 | 1020-A Derita Rd., Concord, NC |  |  | 678 |  |  |  | 543
39020058890 | 11720 Montana Ave., El Paso, TX |  |  | 1744 |  |  |  | 135
390468918559 | 75 Aventura Court, Mississauga, ON |  |  | 248 |  |  |  | 735
390560773618 | 4700 Broadmoor Ave. SE., Kentwood, MI |  |  | 124 |  |  |  | 115
779576698132 | 1045 Middlegate Rd., [NAME], ON |  |  | 255 |  |  |  | 880
779552101996 | 10701 Gateway Blvd. S., El Paso, TX |  |  | 1714 |  |  |  | 105
779663003194 | 3131 [NAME]., Columbus, GA |  |  | 833 |  |  |  | 975
390669947752 | 222 West Merchandise Mart, Chicago, IL |  |  | 300 |  |  |  | 420
Totals
Spreadsheet: 91659d1291317998-linking-multiple-tabs-to-one-main-data-sheet-excel-help
Sheet: Main Spreadsheet

 | Project Name | Director | Project code | Budget | Budget spent YTD | Time RAG | Cost RAG | Benefit RAG
Project 1 | April | [NAME] | LLPP4356 | £4.5M | £2.0M | Green | Yellow | Red
Project 2
Project 3
Project 4
Project 5
Spreadsheet: 843268d1695159017-date-ranges-and-conditional-formating-on-call-schedule-example
Sheet: Formulas

2023-01-03 00:00:00
Spreadsheet: 850072d1700472309-calculating-the-number-of-people-who-have-purchased-more-than-once-over-rolling-periods-repeat-purchase-example
Sheet: Sheet1

Person's name | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
[NAME] | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 1
[NAME] | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Jake | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sue | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Number of people who made more than 1 purchase in the 3 month period - expected values
 | Jan - March | … | … | … | … | [NAME] | … | … | …. | … | Oct - Dec
 | 4 |  |  |  |  | 2 |  |  |  |  | 2
Spreadsheet: 479520d1473399425-day-and-countif-function-wordondate
Sheet: Sheet3

2016-09-01 00:00:00 | AA
2016-09-01 00:00:00 | AA
2016-09-01 00:00:00 | AA
2016-09-01 00:00:00 | AA
2016-09-01 00:00:00 | BB
 | CC |  | Ctrl+Shift+Enter
 | CC
 | DD
 | DD
 | EE
 | EE
Spreadsheet: 45070d1243863560-using-boolean-to-compile-knowledge-flags
Sheet: Europe

Country | Sent | Received | Location | Contact | Notes
Albania
Austia
Bangladesh
Belgium
France
Germany
Great Britain
Hungary
Israel
Italy
Kazakistan
Lebanon
Malta
[NAME]
Netherlands
Norway
Romania
Russia
Spain
Turkey
Ukraine
Uzbekistan
Spreadsheet: 733499d1621601735-using-a-sum-array-to-grade-homework-with-multiple-correct-answers-best-practice-for-grading-multiple-correct-answers-with-sum
Sheet: Assignment B Responses

 | points possible | 2
 |  |  |  | computer | zebra | correct answer #1
 |  |  |  | OR | OR | ALSO
 |  |  | answer key> | radio | bird | correct answer #2
Class | Seat | Score | % | 1 | 2
101 | 1 |  |  | radio | cat
101 | 2 |  |  | radio | cat
101 | 5 |  |  | radio | cat
101 | 3 |  |  | radio | cat
101 | 4 |  |  | radio | cat
101 | 6 |  |  | radio | cat
101 | 10 |  |  | radio | bird
101 | 9 |  |  | radio | bird
101 | 8 |  |  | radio | bird
101 | 7 |  |  | computer | zebra | < this poor guy is getting misgraded at the moment because I'm not sure how to accept two different answers easily with SUM. I've kind of been getting by with SUBSTITUTE, just changing alternative answers to one of the correct answers and grading based on that answer, but with many different possible answers, it can start getting kind of messy. Looking for a neat way to do it
101 | 1 |  |  | radio | bird
Spreadsheet: 00daba9a-7901-4cd7-b754-5376ab2f1c4e
Sheet: Sheet1

COGNIZANT TECHNOLOGY SOLUTIONS CORP | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
02/07/2013
Cognizant Technology Solutions Corporation
Delaware |  | 0-24429 |  | 13-3728359
(State or Other Jurisdiction |  | (Commission |  | (IRS Employer
of Incorporation) |  | File Number) |  | Identification No.)
Glenpointe Centre West |  |  |  | 7666
500 [NAME].
Teaneck, New Jersey
(Address of Principal Executive Offices) |  |  |  | (Zip Code)
Spreadsheet: 267662d1380132772-counting-total-number-of-days-in-specified-period-for-dataset-nick_f-22sep13
Sheet: Sheet3

Period start | Device_days | Infect_No |  | Infection rate/1000days
2002-08-01 00:00:00
 | To count the number of "device days" - that is in Sheet1, how many days were devices in for each period (col A above)
Spreadsheet: 215072d1361257306-if-statement-to-evaluate-the-next-record-nessabell3
Sheet: Details

 |  |  |  | Heading E | Heading F | Heading G
 |  |  |  | P | 59 | 40
 |  |  |  | H | 25 | 16
 |  |  |  | H | 16 | 44
 |  |  |  | I | 52 | 99
 |  |  |  | H | 47 | 49
 |  |  |  | H | 94 | 78
 |  |  |  | I | 80 | 62
 |  |  |  | H | 82 | 64
 |  |  |  | H | 16 | 78
Spreadsheet: 873814d1720379517-vlookup-does-not-find-the-data-although-it-is-there-in-the-table-tbfs-file-creation_v2
Sheet: DHL File Suggestion

Customer Name | Order ID | PO Number | Ship Date | Customer | Address 1 | Address 2 | Address 3 | Town | County | Postcode | QTY | Unit Type | Temp Req | Weight | Instructions | [NAME] Number | [NAME] Number (Optional) | Exporter GB EORI Number | Importer Of Record GB EORI Number
Spreadsheet: kate_symes__18704__New Notification Report 0101
Sheet: Mar 01 Changes

ALL PROPOSED CHANGES SINCE: |  | 2001-02-21 00:00:00
Old Record Information |  |  | New Record Information
Change Type | Old Name | CP ID | New Name
Spreadsheet: 24574d1215075946-help-how-to-getpivotdata-with-empty-string-single-quote-example_getpivotdata_with_emptystring
Sheet: Blad1

Source Data
Team | Prod | Quantity
Team1 | Prod1 | 1
Team2 | Prod1 | 2
Team3 | Prod1 | 3
Team1 | Prod2 | 1
Team3 | Prod2 | 1
Team2 | Prod2 | 2
 | Prod2 | 3
Team1 | Prod1 | 4
Team2 | Prod2 | 1
1st PivotTable
Som van Quantity | Prod
Team | Prod1 | Prod2 | Eindtotaal
 |  | 3 | 3
Team1 | 5 | 1 | 6
Team2 | 2 | 3 | 5
Team3 | 3 | 1 | 4
Eindtotaal | 10 | 8 | 18
GetPivotData
Team | Prod | Q
 | Prod1 | #N/A | team is empty string
Team1 | Prod1 | 5
Team2 | Prod1 | 2
Team3 | Prod1 | 3
 | Prod1 | #N/A | team is ' (quote)
 | Prod2 | #N/A | team is empty string
Team1 | Prod2 | 1
Team2 | Prod2 | 3
Team3 | Prod2 | 1
 | Prod2 | #N/A | team is ' (quote)
Spreadsheet: d60753d1-fa1d-4811-837c-7445982e9e4c
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
FESE | Test | FESE | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
FESE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FESE | Result | FESE | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10929-8 | Foeniculum vulgare seed [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 524803d1498326525-need-execel-to-do-math-and-spit-out-data-second-attempt
Sheet: Formula

Ref# | Date | Zip | CRRT | Total # of Pieces Per Bundle | Bundle# | Total Bundles
1 | 2017-07-03 00:00:00
2 | 2017-07-03 00:00:00
3 | 2017-07-03 00:00:00
4 | 2017-07-03 00:00:00
5 | 2017-07-03 00:00:00
6 | 2017-07-03 00:00:00
7 | 2017-07-03 00:00:00
8 | 2017-07-03 00:00:00
9 | 2017-07-03 00:00:00
10 | 2017-07-03 00:00:00
11 | 2017-07-03 00:00:00
12 | 2017-07-03 00:00:00
13 | 2017-07-03 00:00:00
14 | 2017-07-03 00:00:00
15 | 2017-07-03 00:00:00
16 | 2017-07-03 00:00:00
17 | 2017-07-03 00:00:00
18 | 2017-07-03 00:00:00
19 | 2017-07-03 00:00:00
20 | 2017-07-03 00:00:00
21 | 2017-07-03 00:00:00
22 | 2017-07-03 00:00:00
23 | 2017-07-03 00:00:00
24 | 2017-07-03 00:00:00
25 | 2017-07-03 00:00:00
26 | 2017-07-03 00:00:00
27 | 2017-07-03 00:00:00
28 | 2017-07-03 00:00:00
29 | 2017-07-03 00:00:00
30 | 2017-07-03 00:00:00
31 | 2017-07-03 00:00:00
32 | 2017-07-03 00:00:00
33 | 2017-07-03 00:00:00
34 | 2017-07-03 00:00:00
35 | 2017-07-03 00:00:00
36 | 2017-07-03 00:00:00
37 | 2017-07-03 00:00:00
38 | 2017-07-03 00:00:00
39 | 2017-07-03 00:00:00
40 | 2017-07-03 00:00:00
41 | 2017-07-03 00:00:00
42 | 2017-07-03 00:00:00
43 | 2017-07-03 00:00:00
44 | 2017-07-03 00:00:00
45 | 2017-07-03 00:00:00
46 | 2017-07-03 00:00:00
47 | 2017-07-03 00:00:00
48 | 2017-07-03 00:00:00
49 | 2017-07-03 00:00:00
50 | 2017-07-03 00:00:00
51 | 2017-07-03 00:00:00
52 | 2017-07-03 00:00:00
53 | 2017-07-03 00:00:00
Spreadsheet: 46906102-07ee-49a4-a3d9-2089c4ca42b8
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0002520 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Bath Wastewater Reclamation Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Beaufort | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | IR-1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 19.61 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.35 |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | See Permit |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 112750d1308766209-issues-with-pasting-cells-testformatting
Sheet: NormalFormat

Name
 | *04-1231* |  |  |  | *04-1232* |  |  |  | *04-1233*
 | Zone 1 |  |  |  | Zone 2 |  |  |  | Zone 3
 | *04-1234* |  |  |  | *04-1235* |  |  |  | *04-1236*
 | Zone 4 |  |  |  | Zone 5 |  |  |  | Zone 6
 | *04-1237* |  |  |  | *04-1238* |  |  |  | *04-1239*
 | Zone 7 |  |  |  | Zone 8 |  |  |  | Zone 9
 | *04-12310* |  |  |  | *04-12311* |  |  |  | *04-12312*
 | Zone 10 |  |  |  | Zone 11 |  |  |  | Zone 12
 | *04-12313* |  |  |  | *04-12314* |  |  |  | *04-12315*
 | Zone 13 |  |  |  | Zone 14 |  |  |  | Zone 15