tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59930d1260456692-multiple-sheet-sum-question-sum-example
Sheet: Summary

 | January | February | March | April | May | June | July | August | September | October | November | December
Employee 1 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 2 | 0 | 0 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 3 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 4 | 0 | 0 | 0 | 61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 5 | 0 | 0 | 0 | 0 | 0 | 54 | 0 | 0 | 0 | 0 | 0 | 0
Employee 6 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66 | 0 | 0
Employee 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 0 | 0 | 0 | 0
Employee 9 | 0 | 84 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 10 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 864165d1711458419-formula-name-errors-billy60-preventive-maintenance-schedule-2
Sheet: Vehicle Overview

 | Vehicle Overview
 |  | VEH003 | [NAME] a vehicle from this dropdown. The rest of this page will automatically update.
 | Today's Date
 | Service Performed | Last Service |  |  | Frequency of Service |  | Next Service Due |  | Comments
 |  | Odometer | Date | Cost | [NAME] | Months | Odometer | Date
Spreadsheet: 693108d1598779802-rank-alternate-highs-and-lows-by-a-condition-alternate-high-lows
Sheet: Sheet3 (2)

Script | S.No | Date | Price | H/L | Result (I have) | Expected Result
Sample 1 | 1 | 2020-08-17 00:00:00 | 1372.3 | Low |  | 1
Sample 1 | 1 | 2020-07-31 00:00:00 | 1454.9 | High |  | 2
Sample 1 | 1 | 2020-07-16 00:00:00 | 1253 | Low |  | 3 | Two consecutive lows are compared, lowlest low is ranked and other low needs to be mentioned  0.
Sample 1 | 1 | 2020-07-08 00:00:00 | 1290.6 | Low |  | 0
Sample 1 | 1 | 2020-06-24 00:00:00 | 1319.7 | High |  | 4
Sample 1 | 1 | 2020-06-12 00:00:00 | 1180 | Low |  | 5
Sample 1 | 1 | 2020-06-08 00:00:00 | 1316.3 | High |  | 6 | Two consecutive highs are compared, Highest high ranked and other high needs to be mentioned  0.
Sample 1 | 1 | 2020-06-01 00:00:00 | 1310 | High |  | 0
Sample 1 | 1 | 2020-05-18 00:00:00 | 1125 | Low |  | 7
Sample 1 | 1 | 2020-05-07 00:00:00 | 1204 | High |  | 8
Sample 1 | 1 | 2020-04-29 00:00:00 | 1107 | Low |  | 9
Sample 1 | 1 | 2020-04-22 00:00:00 | 1244 | High |  | 10
Sample 2 | 2 | 2020-07-16 00:00:00 | 145.2 | Low |  | 1
Sample 2 | 2 | 2020-06-25 00:00:00 | 169.2 | High |  | 2
Sample 2 | 2 | 2020-06-12 00:00:00 | 141 | Low |  | 3
Sample 2 | 2 | 2020-06-11 00:00:00 | 165.45 | High |  | 4
Sample 2 | 2 | 2020-05-18 00:00:00 | 134.35 | Low |  | 5
Sample 2 | 2 | 2020-05-18 00:00:00 | 146.4 | High |  | 6
Sample 2 | 2 | 2020-05-06 00:00:00 | 127.3 | Low |  | 7
Sample 2 | 2 | 2020-04-30 00:00:00 | 147.45 | High |  | 0 | Three consecutive highs are compared, Highest high ranked and other highs needs to be mentioned  0.
Sample 2 | 2 | 2020-04-20 00:00:00 | 155.45 | High |  | 8
Sample 2 | 2 | 2020-03-26 00:00:00 | 152 | High |  | 0
Sample 2 | 2 | 2020-03-24 00:00:00 | 116.4 | Low |  | 9 | Two consecutive lows are compared, lowlest low is ranked and other low need to be mentioned  0.
Sample 2 | 2 | 2020-02-03 00:00:00 | 215.6 | Low |  | 0
Spreadsheet: 2d04fc9e-2d20-47d0-9f20-3fa94993d534
Sheet: Sheet1

Weekly Registration and Comparison Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
June Start Term 201005 -- Fifth Day
 | College Credit Hours
 | Current |  | Compared to |  |  | Compared to
 | Term |  | Same Time Last Year |  |  | June Start 200905 5th Day
June Start | 2010-06-14 00:00:00 |  | 2009-06-15 00:00:00 | % of 2009 |  | 2009-06-15 00:00:00 | % of 2009
Quad Cities Campus | 7931 |  | 7046 | 1.125603179108714 |  | 7046 | 1.125603179108714
East Campus | 1054 |  | 621 | 1.697262479871176 |  | 621 | 1.697262479871176
District | 8985 |  | 7667 | 1.171905569323073 |  | 7667 | 1.171905569323073
 | College Credit Headcount
 | Current |  | Compared to |  |  | Compared to
 | Term |  | Same Time Last Year |  |  | June Start 200905 5th Day
June Start | 2010-06-14 00:00:00 |  | 2009-06-15 00:00:00 | % of 2009 |  | 2009-06-15 00:00:00 | % of 2009
Quad Cities Campus | 1767 |  | 1629 | 1.084714548802947 |  | 1629 | 1.084714548802947
East Campus | 237 |  | 154 | 1.538961038961039 |  | 154 | 1.538961038961039
District | 2004 |  | 1783 | 1.123948401570387 |  | 1783 | 1.123948401570387
Spreadsheet: 835324d1688496466-trouble-sorting-a-filtered-index-schedule-sandbox
Sheet: Resources

Departments |  | Work Centers |  |  |  |  |  |  |  |  |  |  | Vacation Time
Steel |  | Denude |  |  |  |  |  |  |  |  |  |  | 1-5 years |  | 80 | hrs
Rubber |  | Fabrication |  |  |  |  |  |  |  |  |  |  | 6-10 years |  | 120 | hrs
Finishing |  | Finish |  |  |  |  |  |  |  |  |  |  | 11-15 years |  | 160 | hrs
Molding |  | Fitting |  |  |  |  |  |  |  |  |  |  | 16 + years |  | 200 | hrs
Shipping |  | General Welding
Maintenance |  | [NAME]
Nil |  | Lead Hand
[NAME] |  | Maintenance
 |  | Molding
 |  | Nil
 |  | Paint
 |  | Pick & Pack
 |  | [NAME]
 |  | Rubber, D2D
 |  | Rubber, Neo
 |  | Sandblast
 |  | Shipping
 |  | Steel General
 |  | Steel Prep
 |  | TSBC A
Employee Number | Department | Posted Work Center | Last Name | First Name | Full Name | Hrs  /Day | Productive Hrs | Shift | Start Date | End Date | Years of Service | Vacation Hrs | Phone 1 | Phone 2 | Address | City | Province | Postal Code | [NAME]
Spreadsheet: a9c8c37e-cb6d-48e0-a276-9fdf37d6d297
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | 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
 | Area |  | Yield | Supply |  |  |  |  | Disappearance
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed and |  |  | Ending
August 1 |  |  |  | stocks | Production | Imports | Total |  | food | Crush | residual | Exports | Total | stocks
 | 1,000 acres |  | Pounds/acre | Million pounds
2012/131 | 1638 | 1604 | 4216.521197007482 | 1003.331 | 6763.3 | 118.743 | 7885.374 |  | 2734.836 | 655.96265 | 528.4915199182553 | 1195.334830081745 | 5114.625 | 2770.749
2013/142 | 1067 | 1042 | 4005.930902111325 | 2770.749 | 4174.18 | 85 | 7029.929 |  | 2919 | 650 | 443.9290000000001 | 1025 | 5037.929 | 1992
2014/152 | 1376 | 1348.49 | 3970.737639878679 | 1992 | 5354.5 | 65 | 7411.5 |  | 2979 | 643 | 525.5 | 1000 | 5147.5 | 2264
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2014-06-13 08:21:07.050000
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner5

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner5
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete) |  |  | PS to link
 |  |  |  |  |  | PS to complete
 |  |  |  |  |  | tutor to complete
Spreadsheet: 163985d1340591456-count-number-of-repeat-stays-repeat2
Sheet: Sheet1

 |  |  | No. Of Repeat Stay in the Hotel |  |  |  | Desired Outcome:  1. a function to count the no. of members who have stayed in year 2010 and 2011/ year 2010,2011,2012 based on their tier membership 2. Count of Resort with the most no. of repeat stay per year - format: Resort Name and no. of count
Membership No. | Membership | Resort | 2010 | 2011 | 2012
5866 | Gold | BKK | 2 | 2
1292 | Red | BKK | 1 | 3 | 1
5623 | Platinum | MNL |  | 4 | 2
3235 | Gold | PVG | 1 | 2 |  |  | No. of Members with [NAME] in year 2010 & 2011
1231 | Black | BKK | 2 | 3 | 2
3232 | Black | DPS |  | 2 | 2
2235 | Platinum | CGK | 1 | 2 |  |  | Members with [NAME] in year 2010 & 2011 per Tier |  |  |  | Resort with Most no. of repeat stay per year
1289 | Gold | MNL | 2 | 3 | 2 |  | Gold |  |  |  |  | Resort | Count
3265 | Black | MNL |  | 2 | 2 |  | Platinum |  |  |  | 2010
3235 | Gold | BKK | 1 | 2 |  |  | Black |  |  |  | 2011
1231 | Gold | MNL | 2 | 3 | 2 |  | Red |  |  |  | 2012
3265 | Red | PVG |  | 2 | 2
3235 | Platinum | DPS | 1 | 2 |  |  | No. of Members with [NAME] in year 2010, 2011,2012
1231 | Red | MNL | 2 | 3 | 2
 |  |  |  |  |  |  | Members with [NAME] in year 2010,2011,2012 per Tier
 |  |  |  |  |  |  | Gold
 |  |  |  |  |  |  | Platinum
 |  |  |  |  |  |  | Black
 |  |  |  |  |  |  | Red
Spreadsheet: 135154d1325847413-cost-calculation-based-on-more-than-one-variable-sstepro-example-khalid-solution
Sheet: Sheet1

CATEGORY 1 |  |  | CATEGORY 2 |  |  | CATEGORY 3
1' Imagery |  |  | 1' Imagery |  |  | 1' Imagery
Cost Area | Per tile cost |  | Cost Area | Per tile cost |  | Cost Area | Per tile cost
1 | 5 |  | 1 | 7 |  | 1 | 9
2 | 9 |  | 2 | 12 |  | 2 | 14
3 | 15 |  | 3 | 17 |  | 3 | 20
LiDAR |  |  | LiDAR |  |  | LiDAR
Cost Area | Per tile cost |  | Cost Area | Per tile cost |  | Cost Area | Per tile cost
1 | 19 |  | 1 | 22 |  | 1 | 24
2 | 25 |  | 2 | 26 |  | 2 | 28
3 | 27 |  | 3 | 28 |  | 3 | 30
Reference | CATEGORY | Type | Cost Area | Per tile cost |  |  |  |  | CATEGORY | Type | Cost Area | Reference | Per tile cost | Units | Total Amount
CATEGORY 11' Imagery1 | CATEGORY 1 | 1' Imagery | 1 | 5 |  |  |  |  | CATEGORY 2 | 1' Imagery | 1 | CATEGORY 21' Imagery1 | 7 | 15 | 105
CATEGORY 11' Imagery2 | CATEGORY 1 | 1' Imagery | 2 | 9 |  |  |  |  | CATEGORY 3 | LiDAR | 1 | CATEGORY 3LiDAR1 | 24 | 17 | 408
CATEGORY 11' Imagery3 | CATEGORY 1 | 1' Imagery | 3 | 15 |  |  |  |  | CATEGORY 2 | LiDAR | 3 | CATEGORY 2LiDAR3 | 28 | 11 | 308
CATEGORY 1LiDAR1 | CATEGORY 1 | LiDAR | 1 | 19 |  |  |  |  | CATEGORY 2 | LiDAR | 2 | CATEGORY 2LiDAR2 | 26 | 20 | 520
CATEGORY 1LiDAR2 | CATEGORY 1 | LiDAR | 2 | 25 |  |  |  |  | CATEGORY 3 | LiDAR | 2 | CATEGORY 3LiDAR2 | 28 | 20 | 560
CATEGORY 1LiDAR3 | CATEGORY 1 | LiDAR | 3 | 27 |  |  |  |  | CATEGORY 3 | LiDAR | 3 | CATEGORY 3LiDAR3 | 30 | 16 | 480
CATEGORY 21' Imagery1 | CATEGORY 2 | 1' Imagery | 1 | 7 |  |  |  |  | CATEGORY 2 | 1' Imagery | 3 | CATEGORY 21' Imagery3 | 17 | 17 | 289
CATEGORY 21' Imagery2 | CATEGORY 2 | 1' Imagery | 2 | 12 |  |  |  |  | CATEGORY 3 | 1' Imagery | 1 | CATEGORY 31' Imagery1 | 9 | 15 | 135
CATEGORY 21' Imagery3 | CATEGORY 2 | 1' Imagery | 3 | 17 |  |  |  |  | CATEGORY 2 | LiDAR | 1 | CATEGORY 2LiDAR1 | 22 | 12 | 264
CATEGORY 2LiDAR1 | CATEGORY 2 | LiDAR | 1 | 22 |  |  |  |  | CATEGORY 3 | 1' Imagery | 3 | CATEGORY 31' Imagery3 | 20 | 15 | 300
CATEGORY 2LiDAR2 | CATEGORY 2 | LiDAR | 2 | 26 |  |  |  |  | CATEGORY 1 | 1' Imagery | 2 | CATEGORY 11' Imagery2 | 9 | 13 | 117
CATEGORY 2LiDAR3 | CATEGORY 2 | LiDAR | 3 | 28 |  |  |  |  | CATEGORY 1 | LiDAR | 3 | CATEGORY 1LiDAR3 | 27 | 14 | 378
CATEGORY 31' Imagery1 | CATEGORY 3 | 1' Imagery | 1 | 9 |  |  |  |  | CATEGORY 1 | LiDAR | 2 | CATEGORY 1LiDAR2 | 25 | 13 | 325
CATEGORY 31' Imagery2 | CATEGORY 3 | 1' Imagery | 2 | 14 |  |  |  |  | CATEGORY 2 | 1' Imagery | 2 | CATEGORY 21' Imagery2 | 12 | 17 | 204
CATEGORY 31' Imagery3 | CATEGORY 3 | 1' Imagery | 3 | 20 |  |  |  |  | CATEGORY 1 | 1' Imagery | 1 | CATEGORY 11' Imagery1 | 5 | 15 | 75
CATEGORY 3LiDAR1 | CATEGORY 3 | LiDAR | 1 | 24 |  |  |  |  | CATEGORY 3 | 1' Imagery | 2 | CATEGORY 31' Imagery2 | 14 | 12 | 168
CATEGORY 3LiDAR2 | CATEGORY 3 | LiDAR | 2 | 28 |  |  |  |  | CATEGORY 1 | 1' Imagery | 3 | CATEGORY 11' Imagery3 | 15 | 11 | 165
CATEGORY 3LiDAR3 | CATEGORY 3 | LiDAR | 3 | 30 |  |  |  |  | CATEGORY 1 | LiDAR | 1 | CATEGORY 1LiDAR1 | 19 | 15 | 285
Spreadsheet: 888688d1739269915-returning-a-series-of-non-empty-results-based-on-a-reference-le-five-paris-17
Sheet: Table

 | Matchday |  | 3
 | Date
 | Qualification |  | 0.3
 | # |  | Joueurs | Résultats |  |  |  | Différence de Buts |  |  | 5 Derniers matchs |  |  |  |  | Classement
 |  |  |  | J | G | N | D | BP | BC | DIF |  |  |  |  |  | Qual? | Pts | % Vic. | PPM |  | # | Joueurs | Buts | Matchs | [NAME]
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 797143d1663740737-powerquery-date-and-time-extraction-power-query-help
Sheet: Sheet1

Resolved
01.10.2020 08:42:59
01.10.2020 09:14:36
01.10.2020 09:15:00
01.10.2020 10:34:16
01.10.2020 14:35:33
01.10.2020 14:50:20
01.10.2020 15:11:55
01.10.2020 16:01:07
01.10.2020 17:05:12
02.10.2020 08:49:34
02.10.2020 09:04:27
02.10.2020 09:44:36
02.10.2020 09:45:00
02.10.2020 10:44:34
02.10.2020 11:03:16
02.10.2020 11:07:01
02.10.2020 11:36:23
02.10.2020 11:56:35
02.10.2020 12:00:47
02.10.2020 12:14:22
02.10.2020 12:34:58
02.10.2020 12:49:54
02.10.2020 12:56:28
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 147304 | 158363
2 | 162200 | 159898
3 | 156474 | 159849
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
2002-01-31 00:00:00 |  |  | -5048
2002-02-03 00:00:00
CBS Dollars
 |  |  | 324667
Spreadsheet: 111303d1307698755-macro-to-copy-a-range-of-dates-based-on-matching-criteria-student-tracking-trial
Sheet: test data

 |  |  |  |  | Y8 tests |  |  | Y9 tests |  |  |  |  | date of test
forename | Surname | Form group | Y8 Group | Y9 group | test 1 score | test 2 score | test 3 score | test 1 score | test 2 score | test 3 score |  | Group | test1 | test 2 | test 3
fred | bloggs | CB | 8a1 | 9a2 | 78 | 67 | 90 | 78 | 67 | 90 |  | 8a1 | 2009-11-25 00:00:00 | 2010-02-02 00:00:00 | 2009-12-15 00:00:00
alice | cooper | CB | 8a1 | 9a1 | 56 | 78 | 83 | 56 | 78 | 83 |  | 8a2 | 2009-11-23 00:00:00 | 2009-12-15 00:00:00 | 2010-02-03 00:00:00
[NAME] | ten | CB | 8a2 | 9a3 | 78 | 80 | 56 | 78 | 80 | 56 |  | 8a3
 |  |  |  |  |  |  |  |  |  |  |  | 8a4
 |  |  |  |  |  |  |  |  |  |  |  | 8a5
 |  |  |  |  |  |  |  |  |  |  |  |  | test1 | test 2 | test 3
 |  |  |  |  |  |  |  |  |  |  |  | 9a1 | 2010-09-19 00:00:00 | 2010-12-03 00:00:00 | 2011-01-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 9a2 | 2010-09-21 00:00:00 | 2011-01-20 00:00:00 | 2010-12-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 9a3
 |  |  |  |  |  |  |  |  |  |  |  | 9a4
 |  |  |  |  |  |  |  |  |  |  |  | 9a5
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 31118 | 31456
2 | 26432 | 31456
3 | 27387 | 31394
4 | 31954 | 31456
5 | 31066 | 34456
6 | 37507 | 36936
7 | 37808 | 38956
8 | 38181 | 39034
9 | 38435 | 39956
10 | 36511 | 39956
11 | 36351 | 34319
12 | 35353 | 39956
13 | 38142 | 39956
14 | 34878 | 37956
15 | 40870 | 37956
16 | 40485 | 39956
17 | 40144 | 39956
18 | 41271 | 40108
19 | 41202 | 40108
20 | 37059 | 40108
21 | 37880 | 40108
22 | 37247 | 40108
23 | 37136 | 37702
24 | 37826 | 40100
25 | 35219 | 37633
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 100916
2002-02-25 00:00:00
CBS Volume
 |  |  | 62232
Spreadsheet: 12c810e1-855d-4246-aa19-d6943d4d0dec
Sheet: Template w Format Requirements

Field Name | SP_NUMBER | DATE_MEASURED | BEGIN_TIME | END_TIME | ROUTE_SYSTEM_ABBR | ROUTE_NUMBER | DIRECTION | FROM_REF_POST_OFFSET | TO_REF_POST_OFFSET | FROM_LONGITUDE | FROM_LATITUDE | TO_LONGITUDE | TO_LATITUDE | LINE_TYPE_CODE | RETROREFLECTIVITY | STANDARD_DEVIATION | MARKING_TYPE_CODE | GROOVED | RUMBLE_STRIPE | COMMENTS | YEAR_LINE_INSTALLED | CONTRAST
Definition | VARCHAR2(20) | DATE | HH:MM:SS | HH:MM:SS | VARCHAR2(2) | VARCHAR2(4) | VARCHAR2(1) | VARCHAR2(10) | VARCHAR2(10) | NUMBER(10,7) | NUMBER(10,7) | NUMBER(10,7) | NUMBER(10,7) | VARCHAR2(3) | NUMBER(5,1) | NUMBER(3) | VARCHAR2(3) | VARCHAR2(3) | VARCHAR2(3) | VARCHAR2(100) | NUMBER(4) | VARCHAR2(3)
Allowable Values |  |  |  |  | I = Interstate US = US Trunk MN = Minnesota Trunk |  | I = Increasing D = Decreasing |  |  |  |  |  |  | CL = Center Line REL = Right Edge Line LEL = Left Edge Line LL = [NAME] (White) 1LL = Leftmost Lane Line in Multilane 2LL = Second to Left Most Lane Line in Multilane xLL = etc |  |  | E = Epoxy Paint L = Latex Paint T = Tape TH = Thermoplastic PU = Polyurea Paint MMA = [NAME] U = Unknown | Yes/No | Yes/No |  |  | Yes/No
Comments/Description | Diplays the Primary State Project Number | Displays the date when the line was installed. | Displays the time that striping started. | Displays the time that striping ended. | Displays the route system class. | Displays the route number with system type. | Direction of travel on roadway. | Displays the starting reference post number with offset value where retroreflectivity readings were taken. | Displays the ending reference post number with offset value where retroreflectivity readings were taken. | Displays the geographic longitude value of the starting point location. | Displays the geographic longitude value of the starting point location. | Displays the geographic longitude value of the ending point location. | Displays the geographic longitude value of the ending point location. | Marking line type | Displays the average retroreflectivity reading for the segment reported.  Have 10 rows for 1/10th mile segments and then one row to summarize the 1 mile segment. | Displays the standard deviation of retroreflective reading for the segment reported.  Have 10 rows for 1/10th mile segments and then one row to summarize the 1 mile segment. | Marking Material Type | Displays the presence of a pavement groove. | Displays the presence of a pavement rumble stripe. | Displays commentary about the roadway or collection process. | Displays the year the line was installed | Displays the contrast value of the pavement marking.
Example Value | 2771-31 | 2007-06-25 00:00:00 | 13:24:45 | 15:28:30 | MN | 210 | I | 196+00.245 | 196+00.345 | -93.1179478 | 44.9389797 | -93.1349833 | 44.931421 | REL | 1000.4 | 25 | E | Yes | Yes |  | 2012 | No
Mobile Retroreflectometer Measurements Excel File Template
Highlighted column headings are for internal purposes.  All data required.
Spreadsheet: 456560d1460948029-dynamic-range-while-eliminating-blank-spaces-testspread1
Sheet: Sheet1

TYPE | MODEL | PRICE/EACH | QUANTITY | AMOUNT | COLOR
 |  |  |  |  | COFFEE
WALL | W12 |  | 2
BASE SINK | SB30 |  | 2
BASE SINK | sb40 |  | 2
BASE SINK | SB36 |  | 2
BASE SINK | SB33 |  | 2
CROWNS | middle |  | 2
LAZY SUSAN | LAZY1 |  | 2
BASE SINK | SB33 |  | 2
PANTRY | PC18 |  | 2
BASE | W14 |  | -7
Spreadsheet: 867578d1714411524-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-book4-12-aligw
Sheet: Sheet1

 |  | Salesman | Items | Region
 |  | Salesman101 | Item-1 | REG-1
 |  | Salesman101 | Item-2 | REG-3
 |  | Salesman101 | Item-3 | REG-3
 |  | Salesman111 | Item-1 | [NAME]
 |  | Salesman111 | Item-2 | REG-3
 |  | Salesman111 | Item-3 | REG-1
 |  | Salesman111 | Item-4 | REG-3
 |  | Salesman111 | Item-5 | REG-3
 |  | Salesman111 | Item-6 | [NAME]
 |  | Salesman111 | Item-7 | REG-3
 |  | Salesman111 | Item-8 | REG-5
 |  | Salesman111 | Item-9 | [NAME]
 |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] |  |  |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME]
Salesman101 | Item-1 |  |  |  |  |  |  |  |  | Salesman101 | 0.33 |  | 0.67
Salesman101 | Item-2 |  |  | 0.3333333333333333 |  |  |  |  |  | Salesman111 | 0.11 |  | 0.56 |  | 0.11 | 0.22
Salesman101 | Item-3 |  |  | 0.3333333333333333 |  |  |  |  |  | Salesman121 |  | 0.5 |  | 0.5
Salesman111 | Item-4 |  |  | 0.1111111111111111
Salesman111 | Item-1 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-2 |  |  | 0.1111111111111111
Salesman111 | Item-3 | 0.1111111111111111
Salesman111 | Item-4 |  |  | 0.1111111111111111
Salesman111 | Item-5 |  |  | 0.1111111111111111
Salesman111 | Item-6 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-7 |  |  | 0.1111111111111111
Salesman111 | Item-8 |  |  |  |  | 0.1111111111111111
Spreadsheet: d5d4b54b-698b-4966-bfb5-9f13e1d8a63f
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
PBLI | Test | PBLI | Plasma Cell Assessment, Blood | Plasma Cell Assessment, B | Six Color Flow Cytometry | Heparin, EDTA Collection Tube |  |  | 10 | mL | [NAME] must arrive within 72 hours of draw.   Container/Tube: Preferred: Green top (sodium heparin) Acceptable: Lavender top (EDTA) [NAME]: 10 mL Additional Information: Date and time of draw are required. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 4 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | [NAME]+ plasma cells=0.0 | Specimens are processed Monday through Sunday and reported Monday through Friday | 1 day | 2 days |  | Profile |  |  |  |  | Rochester
PBLI | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 72 hours
PBLI | Result | 30388 | Blood Plasma Cell Light Chain | Blood Plasma Cell Light Chain | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PBLI | Result | 26838 | # [NAME] cells per 150,000 events | # [NAME] cells per 150,000 events | Unknown |  |  |  |  | events |  |  |  |  |  |  |  |  |  | In Process
PBLI | Result | 26839 | PC Event Interpretation | PC Event Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69052-9
PBLI | Result | 30391 | Blood Flow Reviewed By | Blood Flow Reviewed By | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PBLI | Billing Component | PBLI |  | Flow Cytometry, each cell |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88184
PBLI | Billing Component | PBLI |  | Flow cytometry, 2 to 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88187
PBLI | Billing Component | PBLI |  | each additional marker |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 88185
Spreadsheet: 221350d1363497608-help-what-formula-to-use-for-range-of-data-to-return-a-specified-value-book2
Sheet: Sheet1

02 | 2000 | 0700
06 | 0700 | 1530 | If the hour is between 0700 & 1530, it would return a value of 6
07 | 1900 | 0300 | If the hour is between 1900 & 0300, it would return a value of 7
04 | 1500 | 2300 | if the hour is between 1500 & 2300, it would return a value of 4
05 | 2300 | 0700 | if the hour is between 2300 & 0700, it would return a value of 5
03 | 0700 | 1500 | if the hour is between 0700 & 1500, it would return a value of 3