tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859078d1707519495-excel-formula-time-calculation-3-eba
Sheet: Planilha1

 |  |  |  | <18h | 18 to 20 | 20 to 24 | >24
12:00:00 | 23:59:00 | 00:30:00 | 11:59:00
17:00:00 | 00:15:00 | 00:30:00 | 07:15:00
00:00:00 | 12:30:00 | 00:30:00 | 07:30:00
20:00:00 | 23:00:00
01:30:00 | 05:30:00
05:20:00 | 17:59:00
Spreadsheet: 72325d1273015258-gps-coordinates-quadrants
Sheet: Sheet1

Address | latitude | longitude |  |  | [NAME] |  | North/South Latitude boundary | 43.7805
1 BENVENUTO UNIT | 43.6818436 | -79.4003071 | -0.09865640000000298 | 0.03619289999998898 | Q4 |  | East/West Longitude boundary | -79.4365
2 FERNDALE AVENUE | 43.1556978 | -79.2123856 | -0.6248022000000049 | 0.2241143999999906 | Q4
25 MAITLAND AVENUE | 43.6639513 | -79.3836226 | -0.1165487000000027 | 0.05287739999999985 | Q4
325 BESSERER AVENUE | 45.4290256 | -75.6831327 | 1.648525599999999 | 3.753367299999994 | Q2
95 BRONSON ST. | 45.4065848 | -75.702918 | 1.626084799999994 | 3.733581999999998 | Q2
191 PARKDALE STREET | 45.4066979 | -75.7326767 | 1.626197899999994 | 3.703823299999996 | Q2
45 SPENCER | 45.4025717 | -75.7302728 | 1.622071699999999 | 3.706227200000001 | Q2
53A FOXFIELD DRIVE | 45.2859593 | -75.7496506 | 1.505459299999998 | 3.6868494 | Q2
79 ST. CLAIR AVENUE EAST | 43.6888799 | -79.3901769 | -0.0916201000000001 | 0.04632309999999507 | Q4
43.6639513 | 43.6639513 | -79.3836226 | -0.1165487000000027 | 0.05287739999999985 | Q4
45.4065848 | 45.4065848 | -75.702918 | 1.626084799999994 | 3.733581999999998 | Q2
45.4025717 | 45.4025717 | -75.7302728 | 1.622071699999999 | 3.706227200000001 | Q2
191 PARKDA | 45.4281797 | -75.6616372 | 1.647679699999998 | 3.774862799999994 | Q2
325 BESSER | 45.4290256 | -75.6831327 | 1.648525599999999 | 3.753367299999994 | Q2
95 BRONSON | 45.4483107 | -75.6278121 | 1.667810699999997 | 3.808687899999995 | Q2
45 SPENCER | 45.4483107 | -75.6278121 | 1.667810699999997 | 3.808687899999995 | Q2
53A FOXFIE | 45.4254441 | -75.6408334 | 1.644944099999996 | 3.79566659999999 | Q2
2020 CLIFF | 43.5761103 | -79.5919225 | -0.2043897000000001 | -0.1554225000000002 | Q1
170 SENTIN | 45.4446217 | -75.6423716 | 1.664121699999995 | 3.794128399999991 | Q3
26 GULLIVE | 43.698932 | -79.4776691 | -0.0815680000000043 | -0.04116910000000473 | Q1
1825 RUSSE | 45.4024608 | -75.6301203 | 1.621960799999997 | 3.806379699999994 | Q3
50 SELKIRK | 45.43189 | -75.6671488 | 1.651389999999999 | 3.769351199999988 | Q3
1455 MORIS | 45.4306602 | -75.6851772 | 1.650160199999995 | 3.751322799999997 | Q3
1555 WALKL | 45.3807986 | -75.6374064 | 1.600298599999995 | 3.799093599999992 | Q3
1570 HERON | 45.3795327 | -75.6529163 | 1.599032699999995 | 3.783583699999994 | Q3
Spreadsheet: 03865a64-42d0-4eae-8642-63c32f8a30fb
Sheet: Sheet1

GOVERNOR | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Summary By Counties | Lucas, r | Shaheen, d | Blevens, l | Bramante* | Rubens* | Bosa* | [NAME]
1998-11-03 00:00:00
Belknap County | 4892 | 9434 | 379 | 13 | 1 |  | 40
Carroll County | 4667 | 8737 | 320 |  | 3 |  | 10
Cheshire County | 5220 | 13793 | 563 | 54 | 15 |  | 20
Coos County | 2966 | 6351 | 207 | 2 | 4 | 21 | 5
Grafton County | 6736 | 14521 | 563 | 18 | 44 |  | 52
Hillsborough County | 31108 | 59436 | 2592 | 44 | 28 |  | 131
Merrimack County | 9503 | 27606 | 1256 | 67 | 57 |  | 152
Rockingham County | 23108 | 43627 | 1831 | 46 | 9 |  | 67
Strafford County | 6640 | 19341 | 657 | 34 | 9 |  | 25
Sullivan County | 3633 | 7923 | 287 | 13 | 21 |  | 38
Totals | 98473 | 210769 | 8655 | 291 | 191 | 21 | 540
*write-ins
Spreadsheet: ff1baccf-f13c-412a-8c25-e22f41e26953
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
South African Star Grading System
GUIDELINES, MINIMUM REQUIREMENTS & DETAILED GRADING ASSESSMENT CRITERIA
for
GUEST ACCOMMODATION
COUNTRY HOUSES, GUEST HOUSES AND BED & BREAKFAST ESTABLISHMENTS
 |  |  | Minimum Requirements 1 to 3 Star Only |  |  |  |  |  |  |  |  |  | Minimum Requirements 4 & 5 Star Only
 |  |  | 1 | Has a formal reception area / appropriate meet and greet service. |  |  |  |  |  |  |  |  | 1 | Provides accommodation 7 days a week.
 |  |  | 2 | Servicing of rooms 7 days a week (includes linen/towel change, removal of rubbish and cleaning). |  |  |  |  |  |  |  |  | 2 | Provides accommodation all year round.
 |  |  | 3 | Breakfast provided/available. |  |  |  |  |  |  |  |  | 3 | Has a formal reception area.
 |  |  | 4 | On site representative must be contactable 24 hours, 7 days a week. |  |  |  |  |  |  |  |  | 4 | Offers a dining facility.
 |  |  | 5 | Plus some of the other requirements listed under 4 &5 Star minimum requirements list. |  |  |  |  |  |  |  |  | 5 | On site representative must be contactable 24 hours, 7 days a week.
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | All meals, (breakfast, lunch and dinner) and beverages must be provided from outlets within the complex.
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Servicing of rooms 7 days a week (includes linen/towel change, removal of rubbish and cleaning).
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | On site parking with security for guests.
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Valet service available.
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Room service must be available.
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Concierge, porterage and luggage handling.
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Central business centre or appropriate service.
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | A range of other miscellaneous services provided e.g. baby/child-minding services, message service, shoe polish, delivery of newspapers etc.
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Full housekeeping and laundry services provided.
Spreadsheet: 59149d1259616895-formulas-for-lookups-swim-tracking
Sheet: Swim History

Reg_Name | Meet | Date | Event | mm/ | ss/ | ms
[NAME], [NAME] | Nationals | 2009-11-01 00:00:00 | 1500 Free
Jones, [NAME] | Nationals | 2009-11-01 00:00:00 | 50m [NAME]
Franklin, Marcy | Nationals | 2009-11-01 00:00:00 | 200 IM
Jones, [NAME] | Nationals | 2009-11-01 00:00:00 | 50m [NAME]
[NAME], [NAME] | Nationals | 2009-11-01 00:00:00 | 1500 Free
[NAME], [NAME] | Nationals | 2009-11-01 00:00:00 | 200 IM
[NAME], [NAME] | World Cup | 2009-12-05 00:00:00 | 1500 Free
Jones, [NAME] | World Cup | 2009-12-05 00:00:00 | 50m [NAME]
Franklin, Marcy | World Cup | 2009-12-05 00:00:00 | 200 IM
Jones, [NAME] | World Cup | 2009-12-05 00:00:00 | 50m [NAME]
[NAME], [NAME] | World Cup | 2009-12-05 00:00:00 | 1500 Free
[NAME], [NAME] | World Cup | 2009-12-05 00:00:00 | 200 IM
Spreadsheet: 848865d1699480816-extract-multiple-lines-from-a-column-with-the-same-reference-excel-forum-example
Sheet: Sheet1

COMPANY NAME | EMAIL ADDRESS |  | COMPANY NAME | EMAIL ADDRESS | EMAIL ADDRESS | EMAIL ADDRESS | EMAIL ADDRESS | EMAIL ADDRESS | EMAIL ADDRESS | EMAIL ADDRESS
Company 1 | [EMAIL] |  | Company 1 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Company 1 | [EMAIL] |  | Company 2 | [EMAIL] | [EMAIL] | [EMAIL]
Company 1 | [EMAIL] |  | Company 3 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Company 1 | [EMAIL] |  | Company 4 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Company 2 | [EMAIL]
Company 2 | [EMAIL]
Company 2 | [EMAIL] |  | COMPANY NAME | 1 | 2 | 3 | 4 | 5 | 6 | 7
Company 3 | [EMAIL] |  | Company 1 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Company 3 | [EMAIL] |  | Company 2 | [EMAIL] | [EMAIL] | [EMAIL]
Company 3 | [EMAIL] |  | Company 3 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Company 3 | [EMAIL] |  | Company 4 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Company 3 | [EMAIL]
Company 3 | [EMAIL]
Company 3 | [EMAIL]
Company 4 | [EMAIL]
Company 4 | [EMAIL]
Company 4 | [EMAIL]
Company 4 | [EMAIL]
Company 4 | [EMAIL]
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 29632 | 30000 | 22925 | 25000
2 | 19946 | 30000 | 25047 | 25000
3 | 24779 | 29992 | 18690 | 24993
4 | 22643 | 30000 | 17753 | 25000
5 | 25628 | 30000 | 17735 | 25000
6 | 26763 | 30000 | 32416 | 25000
7 | 27062 | 30300 | 35161 | 25000
8 | 28834 | 29390 | 36121 | 32222
9 | 29402 | 30000 | 33578 | 25000
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  | 622338.78 |  | -1050867.92
2000-12-09 00:00:00
Spreadsheet: 136701d1326796567-using-several-datasheet-to-generate-a-form-fc-mapping-example
Sheet: ALL

Position /Competency Mapping
Proficiency Level Table  : ALL
 |  |  | Functional Competency
 |  |  | Analytical Thinking ความคิดเชิงวิเคราะห์ | Back up and Recovery System Management | Collaboration การทำงานร่วมกับผู้อื่น | Communication Skills ทักษะการติดต่อสื่อสาร | Database Management | Engineering Knowledge ความรู้ในด้านวิศวกรรม | Helpdesk support and management | IT Project management | IT Service Management | LAN and Server management | Maintenance Management System การบริหารจัดการระบบซ่อมบำรุง | Planning and Following การวางแผนและติดตาม | Software Management | Spare Part Management การบริหารจัดการอะไหล่ | System Analysis and Design | System Development | Technical Expertise ความชำนาญในงานด้านเทคนิค
Competency Level: |  |  | FC007 | FC011 | FC019 | FC020 | [NAME] | FC033 | FC038 | FC045 | [NAME] | FC048 | [NAME] | FC058 | FC076 | FC077 | FC081 | FC082 | FC083
Maintenance
Facility & Equipment Manager |  |  | 4 |  | 4 |  |  | 5 |  |  |  |  | 5 | 4
Maintenance Manager |  |  | 3 |  |  | 4 |  |  |  |  |  |  | 5 | 3 |  |  |  |  | 4
IT
Senior IT Manager |  |  |  |  |  |  |  |  |  | 5 | 5 | 3 |  |  | 5
Application Section Manager |  |  |  |  |  |  | 5 |  |  | 4 | 3 |  |  |  | 5 |  | 5 | 4
Spreadsheet: 80102d1280323925-converting-monthly-data-into-quarterly-cobbled
Sheet: Sheet1

 | Oct-94 | Nov-94 | Dec-94 | [NAME] | Feb-95 | Mar-95 | Apr-95 | May-95 | Jun-95 | Jul-95 | Aug-95 | Sep-95 | Oct-95 | Nov-95 | Dec-95 |  | Q4 1994 | Q1 1995 | Q2 1995 | Q3 1995 | Q4 1995
Serie A | 27000000 | 26900000 | 26900000 | 27100000 | 30700000 | 31000000 | 31400000 | 31800000 | 32500000 | 33100000 | 33600000 | 33500000 | 38000000 | 34700000 | 35200000 |  | 26900000 | 31000000 | 32500000 | 33500000 | 35200000
Serie B | 19874704.98920199 | 19561380.26504721 |  | 19321562.08687609 | 19437955.17688743 | 0 | 18905968.48216777 |  | 21232920.13528947 | 21471641.85637053 | 20953960.57121344 |  |  |  |  |  | 19561380.26504721 | 19437955.17688743 | 21232920.13528947 | 20953960.57121344 | #N/A
Serie C |  | 136735882 |  | 146118302 | 143822980 | 131081601 | 123143968 |  |  | 93020486 | 85945233 | 0 | 74627626 | 69110219 | 0 |  | 136735882 | 131081601 | 123143968 | 85945233 | 69110219
 | Ideally, the data would be as in Row 2: uninterrupted so for every Quarter simply return the latest month of that Quarter (see columns R to V). Note: I do not want to average data for a Quarter, simply the last month of a Quarter.
 | If the cell for a Quarter's last month does not contain any data or a value of '0' (see rows 3 and 4 - Series B and C) the range of Quarters (columns R to V) should either return the preceding month or the month before that.
 | So for example, Cell R3 should normally return the value of [NAME] but since there's no data it now has to return the value in cell [NAME]. Simultaenously, the value in cell [NAME] (i.e. Q2 1995) should normally return the value of
 | cell [NAME] (i.e. June 95) but since there's no data there, it moves one month earlier (May 95) which has no data either and thus it returns Cell H5 (April 95).
 | If a complete Quarter does not contain data or only '0's it should return 0 for that quarter, for example [NAME] from Serie B (Row 3). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | or if you dont want n/a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26900000 | 31000000 | 32500000 | 33500000 | 35200000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19561380.26504721 | 19437955.17688743 | 21232920.13528947 | 20953960.57121344 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 136735882 | 131081601 | 123143968 | 85945233 | 69110219
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | what I did was drag say r18 across then deleted shift cells left those below those marked in green
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26900000 | 27100000 | 30700000 | 31000000 | 31400000 | 31800000 | 32500000 | 33100000 | 33600000 | 33500000 | 38000000 | 34700000 | 35200000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | keeping this
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4 | 7 | 10 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26900000 | 31000000 | 32500000 | 33500000 | 35200000
Spreadsheet: 87665d1287557763-time-calcs-wtih-decimal-results-time-logs_example
Sheet: Jenn's Nov version

November 2010 Time Log
Date | Time In | Time Out | Lunch? | Required Work Hours | Total Hours | O/T Earned | Comments |  | Date | Hours Used | DAILY COMMENTS | Balance |  | 5 | 0.08
 |  |  |  |  |  |  |  |  |  |  |  | 51.17 |  | 10 | 0.17
2010-11-01 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  | 0 |  |  |  | 15 | 0.25
2010-11-02 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 20 | 0.33
2010-11-03 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 25 | 0.42
2010-11-04 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 30 | 0.5
2010-11-05 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 35 | 0.58
2010-11-06 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 40 | 0.67
2010-11-07 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 45 | 0.75
2010-11-08 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 50 | 0.83
2010-11-09 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 55 | 0.92
2010-11-10 00:00:00 |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 60 | 1
2010-11-11 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-12 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-13 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-14 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-15 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-16 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-17 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-18 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-19 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-20 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-21 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-22 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-23 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-24 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-25 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-26 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-27 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-28 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-29 00:00:00 |  |  |  | 1900-01-08 00:00:00
2010-11-30 00:00:00 |  |  |  | 1900-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  | TOTAL Balance Remaining
Spreadsheet: 888139d1738582246-how-complete-cells-depeding-another-vinhas-exemplo-tms
Sheet: Folha1

 |  |  |  |  |  |  |  |  | =IF(INDEX(K:K,MATCH($P$9,J:J,0)):INDEX(L:L,MATCH($P$9,J:[NAME]:K,MATCH($P$9,J:J,0)):INDEX(L:L,MATCH($P$9,J:[NAME]))
 |  |  |  |  |  |  |  |  | A | 2025-01-01 00:00:00 | 100 |  |  |  | A
 |  |  |  |  |  |  |  |  |  | 2025-01-05 00:00:00 | 125
 |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 50
 |  |  |  |  |  |  |  |  | B | 2025-01-03 00:00:00 | 35
 |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-01 00:00:00 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-05 00:00:00 | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 50
 |  |  |  |  |  |  |  |  | C | 2025-01-04 00:00:00 | 50
 |  |  |  |  |  |  |  |  |  | 2025-01-12 00:00:00 | 50
Spreadsheet: 209651d1359149167-worksheet-doesnt-cover-entire-page-ck-nursery-and-finish-inventories
Sheet: Finish summary by age

CIRCLE K FAMILY FARMS, LLC
FINISHING BARNS
Weekly Mortality And Sales Summary
Report Date:
GROWER | FLOCK | START | PRIOR WEEKS | WEEKLY | SALES & | WEEK ENDING
 | INFORMATION | COUNT | TOTAL | DEAD | TRANSFERS | TOTAL
 |  |  |  |  |  | CLOSED
NATHAN DUFLO 3 | 23318 | 1024 | 333 | -23 | -310 |  |  | FOURTH QUARTER
 | 2012-08-27 00:00:00 |  |  |  |  | 01-02-13 |  | CLOSES
NATHAN DUFLO 4 | 23418 | 1032 | 416 | 0 | -222
 | 2012-08-27 00:00:00
[NAME] 2 | 98233 | 1542 | 795 | -5 | -180
 | 2012-09-04 00:00:00
[NAME] 3 | 98333 | 994 | 601 | -1 | -174
 | 2012-09-11 00:00:00
DR. MULL 1 | 55112 | 1400 | 1015 | 0 | 0
 | 2012-09-13 00:00:00
DR. MULL 2 | 55212 | 1000 | 805 | -1 | 0
 | 2012-09-17 00:00:00
WEAVER 1 | 96103 | 1246 | 1221 | -2 | 0
 | 2012-09-27 00:00:00
WEAVER 2 | 96203 | 1243 | 1220 | 0 | 0
 | 2012-10-01 00:00:00
MICHIANA | 28101 | 2090 | 2045 | -1 | 0
 | 2012-10-08 00:00:00
SPARKS | 58111 | 1195 | 1181 | 0 | 0
 | 2012-10-15 00:00:00
SPARKS 2 | 58207 | 1197 | 1189 | 0 | 0
 | 2012-10-23 00:00:00
ALBRIGHT 2 | 99204 | 1200 | 1177 | -1 | 0
 | 2012-10-26 00:00:00
JOSH CLOVER | 26118 | 1021 | 1012 | 0 | 0
 | 2012-10-30 00:00:00
[NAME] | 27118 | 1022 | 1013 | -1 | 0
 | 2012-11-06 00:00:00
SUBURBAN 4 | 94439 | 1020 | 1017 | -1 | 0
 | 2012-11-20 00:00:00
[NAME] 1 | 98132 | 875 | 869 | -4 | 0
 | 2012-11-16 00:00:00
SUBURBAN 3 | 94339 | 1022 | 1015 | -1 | 0
 | 2012-11-26 00:00:00
SUBURBAN 2 | 94240 | 1022 | 1018 | 0 | 0
 | 2012-12-03 00:00:00
LOTHSCHUTZ | 57111 | 950 | 942 | -2 | 0
 | 2012-12-04 00:00:00
SUBURBAN 1 | 94140 | 1021 | 1013 | -1 | 0
 | 2012-12-10 00:00:00
BURKETT | 53116 | 1500 | 1482 | -3 | 0
 | 2012-12-11 00:00:00
ALBRIGHT 1 | 99105 | 1025 | 1021 | -2 | 0
 | 12/201/12
NATHAN DUFLO 1 | 23119 A | 1015 | 1015 | 0 | 0
 | 2012-12-31 00:00:00 |  | NEW
NATHAN DUFLO 2 | 23219 B | 1019 | 1019 | 0 | 0
 | 2013-01-04 00:00:00 |  | NEW
A - | Finish Lot 23119 - Nathan Duflo 1
 | PI 3730 - 12/31/12 - 505 head
 | PI 3729 - -12/31/12 - 510 head
B - | Finish Lot 23219 - Nathan Duflo 2
 | PI 3756 - 01/04/13 - 507 head
 | PI 3755 - 01/04/13 - 512 head
 |  | TOTAL | PRIOR WEEKS | WEEKLY | SALES & | WEEKENDING
 |  | FILL | TOTAL | DEAD | TRANSFERS | TOTAL
Spreadsheet: 804023d1667847470-calculate-final-price-using-tiered-pricing-more-elegantly-tiered-pricing
Sheet: Sheet1

0.65 | per unit cost
4 | multiplier before 200g
 | Rate |  | Qty | Total | Price per gram |  | QTY | Difference |  | Qty | Cost | Total price | [NAME]
 | 0 |  | 100 |  |  |  | 0 |  |  | 1
 | 0.5 |  | 200 |  |  |  | 199 |  |  | 99
 | 0.25 |  | 300 |  |  |  | 299 |  |  | 100
 | 0.18 |  | 400 |  |  |  | 399 |  |  | 101
 | 0.13 |  | 500 |  |  |  | 499 |  |  | 199
 |  |  | 600 |  |  |  | 599 |  |  | 200
 |  |  | 700 |  |  |  |  |  |  | 201
 |  |  | 800 |  |  |  |  |  |  | 299
 |  |  | 900 |  |  |  |  |  |  | 300
 |  |  | 1000 |  |  |  |  |  |  | 301
 |  |  |  |  |  |  |  |  |  | 399
 |  |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  |  | 401
 |  |  |  |  |  |  |  |  |  | 499
 |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  | 501
 |  |  |  |  |  |  |  |  |  | 599
 |  |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  |  | 601
 |  |  |  |  |  |  |  |  |  | 699
 |  |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  |  | 701
 |  |  |  |  |  |  |  |  |  | 799
 |  |  |  |  |  |  |  |  |  | 1000
Spreadsheet: 0af4e482-9b3e-45cc-b09d-46720b033a9d
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
UIOD | Test | UIOD | Iodine, 24 Hour, [NAME] | Iodine, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. If this test is used in conjunction with the (131)I uptake test, then specimen collection should begin immediately after the dose of (131)I is given (ie, the patient should void and discard urine just prior to the (131)I, and all subsequent urine should be collected for the next 24 hours). The last void should be included in the collection.   Urine Preservative Collection Options  Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	No 50% Acetic Acid	Yes Na2CO3	No Toluene	No 6N HNO3	No Boric Acid	No Thymol	No Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 93-1,125 mcg/specimen | Monday, Tuesday, Wednesday, Friday; 5 p.m. | 1 day | 3 days | 1 | 83018 |  |  |  |  | Rochester
UIOD | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 146 days
UIOD | Order Question | TIME5 | Collection Duration |  | Plain Text
UIOD | Order Question | VL23 | [NAME] |  | Plain Text
UIOD | Result | 9549 | Iodine, 24 Hr, U | Iodine, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 2492-7 | Iodine:MRat:24H:[NAME]:Qn:
UIOD | Result | TIME5 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
UIOD | Result | VL23 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
UIOD | Result | 3346 | Iodine Concentration | Iodine Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 26842-5 | Iodine:MCnc:24H:[NAME]:Qn:
Spreadsheet: 132317d1323698865-many-condition-need-to-match-and-return-a-unit-price-urgent-assignment-test-formulae
Sheet: Sheet1

YY/MM/DD | [NAME] | Description | PO. No. | Supplier Inv No. | Qty | Unit Price
2010.12.1 | KAM YUEN PETROCHEMICAL (H.K.)LTD. | PP-BJ550 | PD003052 | JT101117BB | 34000
2010.11.29 | KAM YUEN PETROCHEMICAL (H.K.)LTD. | PP-BJ550 | PD003052 | JT101118BB | 34000
2010.12.4 | P-AUDIO SYSTEM CO., LTD | ASSY XDCR DRIVER | PD002633 | 20100432 | 1440
 | P-AUDIO SYSTEM CO., LTD | DRIVER CONE[LC03 0803(S)-4] | PD002753 |  | 800
2010.12.4 | P-AUDIO SYSTEM CO., LTD | [NAME] LN12 3002-8 | PD002633 | 20100432 | 1287
2010.12.4 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002512 | 20100432 | 336
 | P-AUDIO SYSTEM CO., LTD | [NAME] LN15 3001-4 | PD002872 |  | 48
2010.12.2 | P-AUDIO SYSTEM CO., LTD | [NAME] LN10 2001-12 | PD002512 | 20100427 | 260
2010.12.2 | P-AUDIO SYSTEM CO., LTD | [NAME] LN12 3002-8 | PD002633 | 20100427 | 936
2010.12.2 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002633 | 20100427 | 528
2010.12.2 | P-AUDIO SYSTEM CO., LTD | ADAPTER/THREADED/HORN-DRIVER[305-50127-20] | PD002995 | 20100427 | 1.5
2010.12.24 | P-AUDIO SYSTEM CO., LTD | ADAPTER/HORN-DRIVER[PC-3825] | PD002633 | 20100454 | 1440
 | P-AUDIO SYSTEM CO., LTD | [NAME] | PD002753 | 20100454 | 1296
 | P-AUDIO SYSTEM CO., LTD | DRIVER UNIT | PD002902 | 20100454 | 432
 | P-AUDIO SYSTEM CO., LTD | DRIVER UNIT | PD002902 | 20100454 | 400
2010.12.24 | P-AUDIO SYSTEM CO., LTD | LF-SRM450V2 | PD002753 | 20100454 | 702
 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002902 | 20100454 | 162
2010.12.24 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002633 | 20100454 | 288