tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0113d0f0-ae96-43a1-a864-164e8a8c71ae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Guard Dog Budget
 | One dog per band or group of sheep. With uninterrupted service.
 |  |  |  |  |  |  | Guard Dog Budget
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Annual Costs
1 | Initial purchase and shipping. |  |  |  | Price | 350 | Delivery | 50 | 400 | 133.3333333333333
 | Most experts agree that this dog will have a 3 year life
 | but a replacement must be introduced at the beginning
 | of year three.
2 | Replacement Dog,  beginning year three |  |  |  | Price | 350 | Delivery | 50 | 400 | 44.44444444444445
 | Early work in
3 | Feedcosts
 | High quality dog food assuming all feed is purchased for dog. Approximately $0.60 per day |  |  |  |  |  |  |  |  | 219
 | Replacement Pup starting Year 3 |  |  |  |  |  |  |  |  | 73
4 | Vet care including vaccinations, check ups, deworming |  |  |  |  |  | 150 |  |  | 150
 | Spaying and neutering |  |  |  |  |  |  | 125 |  | 41.66666666666666
 | Injury
5 | Extra fencing to keep dog home was left blank by manager must consider this possibility |  |  |  |  |  |  |  |  | 0
 | If shepherd doesn't have a fence good enough to keep the guard dog home an estimate must
 | be included here |  |  | the program will estimate a 15 year life for this improvement
6 | Sheep damage due to bad dog. Studies in western US and Canada indicated that |  |  |  |  |  |  |  |  | 3.333333333333333
 | 10% of the dogs listed in the study had killed at least one ewe or lamb in its life.
 | That means that each dog should be budgeted at the price of 10% of one lamb per three years
 | Placing a value of |  | 100 | per lamb of ewe over three years the estimate is
7 | Neighbor problems should be accounted for also. |  |  |  |  |  |  |  |  | 0
8 | Labor must be accounted for in this budget. Many shepherds report spending
 | from 10 to 50 hours of special attention per month .
 | Some shepherds blend this care into their regular schedule while others make special efforts.
 | Early work suggests that at least some hours per day should be reflected in this budget.
 | Consider | 5 | hours/month | 8 | hour the annual figure of |  |  |  |  | 480
9 | Housing, a kennel for restricted seasons consider a 10 year life |  |  |  |  |  |  | 250 |  | 25
 |  |  |  |  |  |  |  |  |  | 1036.444444444444
 | This leaves the question of how many lamb and ewe kills are necessary for you to justify
 | buying and maintaining a dog.
Spreadsheet: 142285d1329764267-vlookup-issue-using-pivot-table-data-example
Sheet: Sheet3

Month | Data Type | Total |  |  |  |  |  |  | month | Data Type | Count
201101 | A | 1200 |  |  |  |  |  |  | 201101 | A | 1000
201102 | A | 1400 |  |  |  |  |  |  | 201102 | A | 1500
201103 | A | 1542 |  |  |  |  |  |  | 201103 | A | 1200
201104 | A | 1242 |  |  |  |  |  |  | 201104 | A | 900
201105 | A | 1243 |  |  |  |  |  |  | 201105 | A | 1300
201101 | B | 12300 |  |  |  |  |  |  | 201101 | B | 2000
201102 | B | 12452 |  |  |  |  |  |  | 201102 | B | 2500
201103 | B | 21532 |  |  |  |  |  |  | 201103 | B | 3000
201104 | B | 12536 |  |  |  |  |  |  | 201104 | B | 4000
201105 | B | 15284 |  |  |  |  |  |  | 201105 | B | 3500
201101 | C | 124000 |  |  |  |  |  |  | 201101 | C | 10000
201102 | C | 148521 |  |  |  |  |  |  | 201102 | C | 12000
201103 | C | 124582 |  |  |  |  |  |  | 201103 | C | 20000
201104 | C | 152482 |  |  |  |  |  |  | 201104 | C | 25000
201105 | C | 125932 |  |  |  |  |  |  | 201105 | C | 30000
Spreadsheet: 136974d1326900648-getting-a-date-out-of-a-text-string-book1
Sheet: Sheet1

9134E | 96620808100501 | 91 | 34 | E | 966208 | 1 |  | 2008-10-05 00:00:00
9234K09702809300501 | 9702809300501 | 34 | K | 970280 |  | 1 |  | 2011-06-05 00:00:00
7709P | 5920312310401 | 77 | 9 | P | 59203 | 1 |  | 2014-07-04 00:00:00
7709N | 91555402020501 | 77 | 9 | N | 915554 | 1 |  | 2002-02-05 00:00:00
6631P | 50320206120501 | 66 | 31 | P | 503202 | 1 |  | 2006-12-05 00:00:00
5138BA | 17781603180551 | 38 | BA | 177816 |  | 51 |  | 2004-06-05 00:00:00
5106D | 96560506230501 | 51 | 6 | D | 965605 | 1 |  | 2007-11-05 00:00:00
6316C | 15269207140401 | 63 | 16 | C | 152692 | 1 |  | 2008-02-04 00:00:00
Spreadsheet: 989354dc-c204-4643-839c-52baf9e8a393
Sheet: C.R. Irrigation Chart

Zone | Hydrozone        Low (5"-10")      Med. (10"-15")  High (>15") | Plant Type                 (Turf, Native, Shrubs, Perennials, Trees, Annuals, etc.) | Head Type           (Rotors, Sprays, Bubblers, Drip, SDI, etc.) | Nozzle    (Nozzle/          Emmitter size) | App. Rate (inches/hour) |  | [NAME](Per Zone) | Inches/Month   (Peak not to exceed 6"/month or 1.5"/week) | Run Time   (Minutes/ Month) | Run Time (Minutes/Day) | Water Usage (Gallons per month)
Ex: 1 | High | Blue Grass | RB 1806 SAM PRS | 15' | 1.83 |  | 15 | 6
Ex: 2 | low | Buffalo Grass | [NAME] | 3 | 0.4 |  | 15 | 1
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
32
33
34
35
36
Total
 |  |  |  |  |  |  |  |  | Min/Month | Min/cycle | Gallons/Month
NOTE:  For questions about the various columns, please hover over the column heading.
Spreadsheet: 274205d1383050387-reorganising-data-in-a-spreadsheet-widgets-file
Sheet: Widgets Info

 | NOW
 | Product Code | Description | [NAME] | Product Category description | [NAME] | Compatible Items
 | CN2130 | Acme TN2130 Product Item | Acme | Paper | TN-2130 | Acme DCP 7040,Acme HL 2140,Acme HL 2142,Acme HL 2150N,Acme HL 2170W,Acme MFC 7340,Acme MFC 7440,Acme MFC 7840W
 | CN2150 | Acme TN2150 Product Item | Acme | Paper | TN-2150 | Acme DCP 7040,Acme HL 2140,Acme HL 2142,Acme HL 2150N,Acme HL 2170W,Acme MFC 7340,Acme MFC 7440,Acme MFC 7840W
 | CN21503PK | Acme TN2150 Product 3 Pack | Acme | Paper | TN-21503PK | Acme DCP 7040,Acme HL 2140,Acme HL 2142,Acme HL 2150N,Acme HL 2170W,Acme MFC 7340,Acme MFC 7440,Acme MFC 7840W
 | CN215010PK | Acme TN2150 Product 10 Pack | Acme | Paper | TN-215010PK | Acme DCP 7040,Acme HL 2140,Acme HL 2142,Acme HL 2150N,Acme HL 2170W,Acme MFC 7340,Acme MFC 7440,Acme MFC 7840W
 | FUTURE
 | [NAME] | Product Category description | Compatible Items | Product Code
 | Acme | Paper | ACME DCP 7040 | CN2130, CN2150, CN21503PK, CN215010PK
Spreadsheet: 842105d1694173209-catan-scoring-rule-formula-catan-scoreboard-3-player-sample-data-
Sheet: Sheet1

Players | Score | Settlements | Cities | Consecutive Roads (#) | Longest Road | [NAME] (#) | Biggest Army | [NAME] (Keep secret until you are read to declare on your turn only)
Player 1 |  | 2 | 0 | 1 |  | 0
Player 2 |  | 2 | 0 | 1 |  | 0
Player 3 |  | 2 | 0 | 1 |  | 0
Player 4 |  | 0 | 0 | 0 |  | 0
Player 5 |  | 0 | 0 | 0 |  | 0
Player 6 |  | 0 | 0 | 0 |  | 0
Target Score | 10
Spreadsheet: 847285d1698299213-to-get-a-total-score-whereby-1-or-2-conditions-may-affect-the-result-support-excel
Sheet: Dashboard

 | Risk Factor | Max.% | Risk Sub-Factor | Sub-Max.% | Sheet |  | Info From | [NAME] | Weight |  | Sub-Score | Score
 | A |  | A1 | 0.03 | Geography |  |  | Andorra
 |  |  | A2 | 0.04 | Geography |  |  | Andorra
 |  |  | A3 | 0.06 | Geography |  |  | Andorra
 |  |  | A4 | 0.03 | Geography |  |  | Andorra
 |  |  | A5 | 0.05 | Geography |  |  | Andorra
 |  |  | A6 | 0.02 | Geography |  |  | Andorra
 |  |  | A7 | 0.03 | Geography |  |  | Andorra
 |  |  | A8 | 0.11 | Geography |  |  | Andorra
 |  |  | A9 |  | Geography |  |  | Andorra
 |  |  | A10 |  | Geography |  |  | Andorra
 |  |  | A11 | 0.11 | Geography |  |  | Andorra
 |  |  | A12 |  | Geography |  |  | Andorra
 |  |  | A13 |  | Geography |  |  | Andorra
 | B |  | B1 | 0.05 | Industry |  |  | Waste collection, treatment and disposal activities; materials recovery
 |  |  | B2 | 0.02 | Other |  |  | X
 |  |  | B3 | 0.03 | Other |  |  | X
 |  |  | B4 | 0.02 | Other |  |  | X
 |  |  | B5 | 0.03 | Other |  |  | X
 |  |  | B6 | 0.04 | Other |  |  | No adverse Media
 |  |  | B7 | 0.05 | Other |  |  | X
 | C |  | C1 | 0.07 | Other |  |  | X
 |  |  | C2 | 0 | Geography |  |  | X
 | D |  | D1 | 0.05 | Other |  |  | X
 |  |  | D2 | 0.04 | Other |  |  | X
 |  |  | D3 | 0.03 | Other |  |  | X
 |  |  | D4 | 0.03 | Other |  |  | X
 |  |  | D5 | 0.03 | Other |  |  | X
 |  |  | D6 | 0.03 | Other |  |  | X
 |  |  |  |  |  |  |  | Total Score
 |  |  |  |  |  |  | Score: |  |  |  | Prohibited | 80.01-100.00 | 80.01 | 100
 |  |  |  |  |  |  |  |  |  |  | High Risk | 60.01 - 80.00 | 60.01 | 80
 |  |  |  |  |  |  |  |  |  |  | Medium Risk | 40.01 - 60.00 | 40.01 | 60
 |  |  |  |  |  |  |  |  |  |  | Low Risk | 23.00 - 40.00 | 23 | 40
Spreadsheet: 225103d1364896744-help-with-timetable-lesson-planner
Sheet: SUMMER 1

 |  |  | WK | 1 | 2 | 3 | 4 | 5 | 6 | Extra
 | Monday | 2013-04-15 00:00:00 | 1 | PD DAY |  |  |  |  |  | MODERATION
 | Tuesday | 2013-04-16 00:00:00 | 1 |  |  | 13 - MOCK PROSE ESSAY |  |  |  | MODERATION
 | Wednesday | 2013-04-17 00:00:00 | 1 |  |  |  |  |  |  | MODERATION
 | Thursday | 2013-04-18 00:00:00 | 1 |  |  |  | 9B | 13- MOCK UNSEEN
 | Friday | 2013-04-19 00:00:00 | 1 |  |  | 9B | 9L
 |  | 2013-04-20 00:00:00
 |  | 2013-04-21 00:00:00 | WK | 1 | 2 | 3 | 4 |  | 5 | Extra
 | Monday | 2013-04-22 00:00:00 | 2 | 9B |  |  |  | S+
 | Tuesday | 2013-04-23 00:00:00 | 2
 | Wednesday | 2013-04-24 00:00:00 | 2
 | Thursday | 2013-04-25 00:00:00 | 2 |  |  |  | 9B
 | Friday | 2013-04-26 00:00:00 | 2 |  |  | 9B | 9L
 |  | 2013-04-27 00:00:00
 |  | 2013-04-28 00:00:00 | WK | 1 | 2 | 3 | 4 | 5 | 6 | Extra
 | Monday | 2013-04-29 00:00:00 | 3 | 9B |  |  |  | S+ |  | YEAR 10 EXAMS
 | Tuesday | 2013-04-30 00:00:00 | 3 |  |  |  |  |  |  | YEAR 10 EXAMS
 | Wednesday | 2013-05-01 00:00:00 | 3
 | Thursday | 2013-05-02 00:00:00 | 3 |  |  |  | 9B |  |  | YEAR 10 EXAMS
 | Friday | 2013-05-03 00:00:00 | 3 |  |  | 9B | 9L
 |  | 2013-05-04 00:00:00
 |  | 2013-05-05 00:00:00 | WK | 1 | 2 | 3 | 4 | 5 | 6 | Extra
 | Monday | 2013-05-06 00:00:00 | 4 |  |  |  |  |  |  | BANK HOLIDAY
 | Tuesday | 2013-05-07 00:00:00 | 4 |  |  |  |  |  |  | Y10 LIT EXAM
 | Wednesday | 2013-05-08 00:00:00 | 4
 | Thursday | 2013-05-09 00:00:00 | 4 |  |  |  | 9B
 | Friday | 2013-05-10 00:00:00 | 4 |  |  | 9B | 9L
 |  | 2013-05-11 00:00:00
 |  | 2013-05-12 00:00:00 | WK | 1 | 2 | 3 | 4 | 5 | 6 | Extra
 | Monday | 2013-05-13 00:00:00 | 5 | 9B |  |  |  | S+
 | Tuesday | 2013-05-14 00:00:00 | 5
 | Wednesday | 2013-05-15 00:00:00 | 5
 | Thursday | 2013-05-16 00:00:00 | 5 |  |  |  | 9B
 | Friday | 2013-05-17 00:00:00 | 5 |  |  | 9B | 9L
 |  | 2013-05-18 00:00:00
 |  | 2013-05-19 00:00:00 | WK | 1 | 2 | 3 | 4 | 5 | 6 | Extra
 | Monday | 2013-05-20 00:00:00 | 6 | 9B |  |  |  | S+BIOLOGY EXAM |  | GCSE LIT EXAM -NOVELS
 | Tuesday | 2013-05-21 00:00:00 | 6
 | Wednesday | 2013-05-22 00:00:00 | 6
 | Thursday | 2013-05-23 00:00:00 | 6 |  |  |  | 9B | 13 | 12 | GCSE LIT EXAM -POETRY
 | Friday | 2013-05-24 00:00:00 | 6 | YEAR 11 LEAVERS' DAY |  | 9B | 9L |  |  |  | `
Spreadsheet: 66aba3d1-fa05-4054-a407-dd4501e429ef
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
EGPL | Test | EGPL | English Plantain, IgE | English Plantain, 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
EGPL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EGPL | Result | EGPL | English Plantain, IgE | English Plantain, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6110-1 | Plantago lanceolata Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: c039fad8-426f-4d71-bd13-0e50323964aa
Sheet: GL Summary

Row Labels | Sum of Device Total Click Charge
Academic Advising | 28.4042
Administrative | 671.3506000000001
Admissions Office | 806.3006
AOF - Academic Advising | 196.0941
Auxiliary Administration | 37.0896
AUX-Laundry & Pressing | 27.04
AUX-Military Store | 175.3291
AUX-Student Health | 213.66
AUX-Tailor Shop | 22.4534
Business Executive | 32.6058
Cameron Physics & Astronomy | 265.7277999999999
Career Services and Placement | 44.8282
Carroll Biology Fund | 163.0569
Center for Leadership & Ethics | 233.7381
Chemistry | 336.8517000000001
Civil Engineering | 292.7186
Communications & Marketing | 17.9889
Comptroller's Office | 197.0834
[NAME] of the Faculty | 77.46600000000001
Duplicating | 2079.421
Economics | 728.2108
Electrical Engineering | 78.43469999999999
English | 1038.5935
Football | 1070.7353
History | 89.4265
Honor Court | 49.5466
Institute Planning | 639.9322999999999
Institute Writing Program | 45.9462
Institutional Analysis | 3.1878
International Programs | 16.4432
International Studies Depart | 331.6748
IST | 170.5699
Learning Programs | 109.0968
Libraries | 576.0751
Mathematics | 432.1242
Mechanical Engineering | 244.024
MERC Operating | 18.567
Modern Languages | 44.1208
Museum | 56.661
Office of Construction | 215.6349
Personnel Administration | 160.9126
Philosophy & Psychology | 298.3324
Physical Education | 170.7484
Physical Plant Administration | 236.4004
Post Mail | 31.7124
Printer Services | 2679.6804
Protocol Office | 20.0976
Purchasing Office | 45.4572
Registration & Records | 92.30600000000001
ROTC-Air Force | 0.0524
ROTC-Army | 373.3218999999999
ROTC-Navy | 11.3446
Soccer | 1.5458
Soccer - Women | 3.7204
Sports Information | 21.1968
Student Union | 14.1494
Superintendents Office | 251.758
Track & Cross Country | 8.567400000000001
Treasurers Office | 74.6438
UMA-Band | 10.4328
UMA-Commandant's Office | 332.4904999999999
UMA-Counselors Office | 15.6906
Undergraduate Research | 18.0191
(blank)
Biology | 7.7552
Drug & Alcohol Abuse | 39.4027
Financial Aid Administration | 154.6848
Post Security | 153.9849
Stone [NAME] House | 18.7264
Grand Total | 17125.3483
Spreadsheet: 682262d1591982948-sum-based-on-order-number-2020-06-12-oeldere-stax67-pt-682211d1591966063-sum-based-on-order-number-in
Sheet: Pivot table

Som van Expr1 |  | month
Invoice Number | WON |  | 6 | 5 | Eindtotaal
4420 | 203363 |  |  | 100000 | 100000
4421 | 203398 |  |  | 1710 | 1710
4422 | 203392 |  |  | 2592.900146484375 | 2592.900146484375
4423 | 203371 |  |  | 1845 | 1845
4424 | 203323 |  | 55898.64013671875 |  | 55898.64013671875
4425 | 203361 |  |  | 5850 | 5850
4426 | 203358 |  |  | 7320 | 7320
4427 | 203240 | 6132 |  |  | 6132
Eindtotaal |  | 6132 | 55898.64013671875 | 119317.9001464844 | 181348.5402832031
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: Birthdays

Name of Person |  | Birthday | Birthday this Year | Current Age | Turning this Year |  | Days Until Birthday | Now? |  |  |  |  | Today is:
[NAME] | 1989-07-12 00:00:00 |  |  |  |  |  |  |  |  | Settings
[NAME] | 1962-06-06 00:00:00 |  |  |  |  |  |  |  |  | Calendar: Display Age | Yes
[NAME] | 1971-10-01 00:00:00 |  |  |  |  |  |  |  |  | Calendar: Highlight Today | Yes
[NAME] | 1977-11-25 00:00:00 |  |  |  |  |  |  |  |  | Calendar: "No Birthdays Today" message | Yes
[NAME] | 1997-11-28 00:00:00
Smith Joe | 1984-02-15 00:00:00 |  |  |  |  |  |  |  |  | Calendar: Title Format | Month Year
[NAME] | 1989-01-22 00:00:00
[NAME] | 1998-08-11 00:00:00
[NAME] | 1996-12-11 00:00:00 |  |  |  |  |  |  |  |  | Calendar: Unknown Age | (??)
[NAME] | 2000-03-15 00:00:00
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Highspire

 |  |  |  |  |  |  | 2013 Highspire F.E.
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 1st & 3rd Fridays (if a 5th Friday occurs, add).  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 851069d1701328215-getting-price-using-3-reference-points-test
Sheet: Delivery

Job No. | Order Refarence | Collection Address | Collection Date | Collection Contact Name | Delivery Address | Delivery Date | Delivery Time | Service | Quantity | Delivery Zone | Pallet Type | Delivery Cost | Supplementary Charges | Total Delivery Charge | Difference | Total Delivey Cost Excluding Extras |  | Total Difference |  | Total Pallets |  | 60 | Micro Pallet
 |  |  |  |  |  |  |  | A - 24 Hour | 1 | Zone A | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | B - 48 Hour | 1 | Zone C | Full Pallet 1 |  |  |  |  |  |  |  |  |  |  |  | Half Pallet
 |  |  |  |  |  |  |  | A - 24 Hour | 1 | Zone D | Full Pallet 3 |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 10
Spreadsheet: 53be7db9-9497-4a52-a2cb-bf9c3533967e
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
MTBCV | Test | MTBCV | Susc, [NAME], 1 drug | [NAME], [NAME], 1 drug |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87190 |  |  |  |  | Rochester
MTBCV | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 020b289c-fc9c-4650-8d04-913461b4576c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | [NAME]
 |  |  | 9:10AM F4 (2
 |  | T's Train
Sneaky Petes
 |  |  |  |  | 11:30 AM F3 (6
 | 9:10AM F3 (1
[NAME] |  |  | 10:20 AM F3 (3
 |  | Rivals
 |  |  |  |  |  |  | Sunday
 |  |  |  |  |  |  | 9:10AM F4 (10
 |  | L-6
 |  |  | 12:40 PM F3 (8 |  |  |  |  |  | Sunday
 |  | [NAME] |  |  |  |  |  |  | 10:20 AM F4 (11
 |  |  |  |  | Sunday
L-1 |  |  |  |  | 8:00AM F4 (9
 | 10:20AM F2 (4*
L-2
 |  |  | 12:40PM F4 (7
[NAME]
 | 11:30AM F4 (5*
L-4
 |  | Note: An * next to a game number in the losers bracket denotes the loser of that game is still in the tournament. The team that loses
 |  | game #4 could possibly lose their first 3 games and still remain in the tournament. This is done to ensure that the loser of game #3 will play
 |  | a minimum of 3 games.
Spreadsheet: 40715d1239116301-how-to-search-for-duplicates-in-a-string-across-a-range-of-cells-test
Sheet: Sheet1

Example 1
1 | 1x | 2 |  |  | x | exists |  | The user inputs cells in column F. In this example it returned true to G3 because all values in F exist in column B
x | 1x | 2 |  |  | 1
x | 1x2 | 2 |  |  | 2
2 | x2 | 1 |  |  | 2
x | 1x | 2 |  |  | 1
x | 1x | 2 |  |  | x
1 | 1x | 2 |  |  | x
1 | 1x | 2 |  |  | 1
2 | x2 | 1 |  |  | 2
x | 1x2 | 2 |  |  | x
Example 2
1 | 1x | 2 |  |  | x | exists |  | It would be ideal if the F cells were validated as they are input!
x | 1x | 2 |  |  | 1 | exists |  | In this example the user has entered down to F21 and the spreadsheet is validating this group against the other columns.
x | 1x2 | 2 |  |  | 2 | exists |  | The first 5 values exist in column B but F21 does not.
2 | x2 | 1 |  |  | 2 | exists
x | 1x | 2 |  |  | 1 | exists
x | 1x | 2 |  |  | 2 | not existing
1 | 1x | 2
1 | 1x | 2
2 | x2 | 1
x | 1x2 | 2
Spreadsheet: 829206d1684032437-a-function-for-automatically-distributing-the-total-load-based-on-the-individual-load-transportation-optimization
Sheet: Sheet1

 |  |  |  | Trucks needed for destination (example
Amounts for delivery per destination [tons/day] |  |  |  | Alpha |  | Beta |  |  |  |  |  | Trucks [NAME]. capacity (assigned per destination) [tons]
Day | Alpha | Beta |  | Alpha 1 | Alpha 2 | Beta 1 | Beta 2 | Beta 3 | Beta 4 |  |  | Alpha 1 | 20
1 | 40 | 16 |  | 20 | 20 | 16 | 0 | 0 | 0 |  |  | Alpha 2 | 20
2 | 40 | 16 |  | 20 | 20 | 16 | 0 | 0 | 0 |  |  | Beta 1 | 30
3 | 30 | 54 |  | 20 | 10 | 30 | 24 | 0 | 0 |  |  | Beta 2 | 30
4 | 35 | 105 |  | 20 | 15 | 30 | 30 | 35 | 10 |  |  | Beta 3 | 35
5 | 30 | 60 |  | 20 | 10 | 30 | 30 | 0 | 0 |  |  | Beta 4 | 35
6 | 30 | 50 |  | 20 | 10 | 30 | 20 | 0 | 0
7 | 25 | 110 |  | 20 | 5 | 30 | 30 | 35 | 15
8 | 40 | 120 |  |  |  |  |  |  |  |  | Rule 1: The 2nd truck will be available only after the 1st truck is fully loaded.
9 | 40 | 100 |  |  |  |  |  |  |  |  | Rule 2: After the 1st truck is shipped at full capacity, the 2nd truck will carry the remaining load.
10 | 40 | 95 |  |  |  |  |  |  |  |  | Rule 3: When the load can be delivered by less than the available trucks, the rest should be marked with 0.