tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: geir_solberg__11293__~3310416
Sheet: Dispatch

Brief Scenario Description:
Obligations:     HE (MST) | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6 |  |  | 7 |  |  | 8 |  |  | 9 |  |  | 10 |  |  | 11 |  |  | 12 |  |  | 13 |  |  | 14 |  |  | 15 |  |  | 16 |  |  | 17 |  |  | 18 |  |  | 19 |  |  | 20 |  |  | 21 |  |  | 22 |  |  | 23 |  |  | 24 |  |  | Total
Projected Native Load:
Other Control Area Load:
TNP:
IID:
PNM Contingent:
Other WSCC Load:
System Load
Preschedules:
Net PV Preschedule:
Net FC Preschedule:
[NAME] Purchase:
FC Real-Time Firm Purchase:
[NAME]:
Other WSCC Preschedule:
Real-Time PV Sales:
Real-Time FC Sales:
Total Obligations
Remote Resources:
FC Unit 4:
FC Unit 5:
PV Unit 1:
PV Unit 2:
PV Unit 3:
Local Resources:
NM1
NM1 Spin
NM2
NM2 Spin
NM3
NM3 Spin
1GT
GT1 Spin
2GT
[NAME]
[NAME]
[NAME]
GT2ST
GT2ST Spin
NM4
NM4 Spin
RG6
[NAME]
RG7
RG7 Spin
RG8
[NAME]
Copper
Copper Spin
Total Local Generation
Real-Time Purchases:
EDDY TIE Purchase
PV Purchase
FC Purchase
Reserves:
Spinning Reserves:
Non-Spinning Reserves:
Contingent Reserves:
Required Spinning Res:
Required Contingent Res:
Reserves Required (+); Excess (-):
WSCC Reserv. Purch (+); SNMI Sale(-):
Eddy or SNM Reserv. Purch (+):
EPE SNM Imports:
Position
Real-Time PV Sales:
Real-Time FC Sales:
Newman Gas Burn (mmbtu):
Rio Grande Gas Burn (mmbtu):
Copper Gas Burn (mmbtu):
 |  |  |  |  |  |  |  |  |  | HE 1:00 - 7:00 |  |  |  |  |  | Newman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HE 8:00 - 24:00 |  |  |  |  |  | Newman
NOTES: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio Grande |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rio Grande
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 729442d1619094398-iferror-nesting-ali
Sheet: Sheet1

ITEM NAME | G | VENDOR | J |  | ITEM 1 | ITEM 1 QTY | ITEM 2 | ITEM 2 QTY | ITEM 3 | ITEM 3 QTY | ITEM 4 | ITEM 4 QTY | ITEM 5 | ITEM 5 QTY | ITEM 6 | ITEM 6 QTY
 | MY | NAME | ITEM NUMBER
 | COST
CAR | 400 | G | CAR
RADIO | 100 | G | RADIO
CAR + RADIO |  | J |  |  | CAR | 1 | RADIO | 1
Spreadsheet: 870090d1716608962-grabbing-data-from-a-data-table-between-2-dates-excel-2010-tornadoes-between-date-bvj-s
Sheet: Sheet1

Data Table |  |  |  |  |  |  |  |  |  |  |  |  | Start Date | 2021-07-01 00:00:00 | End Date | 2021-08-31 00:00:00 | # of Occurrences
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Results
 | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating |  | Occurrences | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating
 | 2020-07-19 00:00:00 | 23:50:00 | 23:57:00 | 1 | [NAME] (WI) | 3.65 | 200 | 0 | 0 | EF1
 | 2020-08-10 00:00:00 | 11:32:00 | 11:34:00 | 1 | Grant (WI) | 0.55 | 50 | 0 | 0 | EF0
 | 2021-05-15 00:00:00 | 16:49:00 | 16:51:00 | 1 | Howard (IA) | 0.3 | 15 | 0 | 0 | EF0
 | 2021-07-14 00:00:00 | 16:34:00 | 17:02:00 | 1 | [NAME] (IA) | 12.02 | 60 | 0 | 0 | EF1
 | 2021-07-14 00:00:00 | 17:43:00 | 17:53:00 | 2 | [NAME] (IA), [NAME] (IA) | 3.18 | 30 | 0 | 0 | EF0
 | 2021-08-07 00:00:00 | 15:29:00 | 15:56:00 | 1 | Grant (WI) | 9.38 | 1100 | 0 | 0 | EF3
 | 2021-08-11 00:00:00 | 12:45:00 | 12:59:00 | 1 | [NAME] (WI) | 5.91 | 80 | 0 | 0 | EF1
 | 2021-08-11 00:00:00 | 12:55:00 | 13:02:00 | 1 | [NAME] (WI) | 2.77 | 75 | 0 | 0 | EF1
 | 2021-08-27 00:00:00 | 16:50:00 | 16:51:00 | 1 | [NAME] (IA) | 1.29 | 140 | 0 | 0 | EF0
 | 2021-08-27 00:00:00 | 16:51:00 | 16:54:00 | 1 | [NAME] (IA) | 2.19 | 90 | 0 | 0 | EF0
 | 2021-08-27 00:00:00 | 16:57:00 | 17:11:00 | 1 | [NAME] (IA) | 6.38 | 300 | 0 | 0 | EF1
 | 2021-09-20 00:00:00 | 15:47:00 | 15:56:00 | 1 | Olmsted (MN) | 5.66 | 100 | 0 | 0 | EF0
 | 2021-09-20 00:00:00 | 16:56:00 | 17:11:00 | 1 | [NAME] (WI) | 8.49 | 100 | 0 | 1 | EF1
 | 2021-12-15 00:00:00 | 18:53:00 | 18:57:00 | 2 | Butler(IA), [NAME] (IA) | 4.17 | 200 | 0 | 0 | EF1
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 3-12 Night

 | CR1 | Priority | Headcount
1 | Alinity RV | High | 0.25
2 | Alinity RV | High | 0.25
3 | Alinity RV | High | 0.25
4 | Alinity RV | High | 0.25
5 | Alinity RV | High | 0.25
12 | [NAME] | Low | 0.25
13 | Baxter cap | High | 0.25
9 | Architect RV | High | 0.25
15 | [NAME] tray | Med/High | 0.5
16 | Architect RV | High | 0.25
17 | Alinity RV | High | 0.25
50 | Baxter SIV Assy | Medium
31 | Architect RV | High | 0.25
8 | Alinity RV | High | 0.25
10 | Architect RV | High | 0.25
11 | [NAME] | Low | 0.25
18 | Architect RV | High | 0.25
19 | Architect RV | High | 0.25
20 | Beckman 3ml | High | 0.25
21 | Architect RV | High |  | DOWN
22 | Architect RV | High | 0.25
23 | Architect RV | High | 0.25
30 | Architect RV | High | 0.25
7 | Architect SC | Med/High | 0.25
Total
 | CR2 | Priority
71 | PP4 | High | 0.25
72 | 8ul ES | * |  | DOWN
73 | PP1 | High | 0.25
74 | Side Cassette A | High | 0.25
76 | PP3 OQ | * |  | QA Support
77 | Base Cassette | High
78 | Side Cassette B | High | 0.25
79 | [NAME] | High | 0.25
87 | Top Frame A | High | 0.25
52 | Architect RV | High | 0.25
53 | Architect RV | High | 0.25
54 | Siemens KS860 | High | 0.5
59 | Architect RV | High | 0.25
61 | [NAME] trays | High | 0.5
66 | [NAME] | High | 0.5
83 | Over [NAME] | Medium
84 | Ceph MB#1 | Med/High
86 | [NAME] | Med/High | 0.25
62 | NP227 | Low | 0.25
63 | NP Birdcage | Low
64 | Siemens 1ML
67 | [NAME] | High
69
88 | Side Pump | High | 0.25
89 | Top Frame B | High | 0.25
95 | Beckman Unicel E | Low | 0.25
96 | Beckman Unicel F | Low | 0.25
106 | [NAME] shell key assembly | High | 2
107 | Snap Ring | Medium
108 | [NAME] shell | High | 0.25
109 | over cap | Medium | 0.25
Total
 | [NAME] |  | 1.25
 | [NAME] |  | 1
 |  |  |  |  |  | 15.75
Spreadsheet: 779889d1652176654-need-formula-to-get-min-and-max-dates-startenddates
Sheet: Sheet1

 |  | Helper cells>>> |  | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00
 | Proj.No. | Labour Division | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 |  | Proj.No. | Start Date | End Date
 | PRJ01 | Eng |  | 0 | 0 | 0
 | PRJ01 | H&S |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02
 | PRJ01 | Project Management |  | 0.5 | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | PRJ02 | Eng |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | PRJ04
 | PRJ02 | H&S |  |  |  |  |  | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925 |  |  |  |  |  |  |  |  | PRJ05
 | PRJ02 | Project Management |  |  |  |  |  | 1.462264150943396 | 1.415094339622641 | 1.462264150943396 | 1.462264150943396 | 1.320754716981132 | 1.462264150943396 | 1.415094339622641
 | [NAME] | Eng |  |  |  |  |  | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851
 | [NAME] | H&S |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-08-01 00:00:00
 | [NAME] | Project Management |  |  |  |  |  | 2.638297872340426 | 2.553191489361702 | 2.638297872340426 | 2.638297872340426 | 1.531914893617021 |  |  |  |  |  |  |  |  |  |  | PRJ02 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00
 | PRJ04 | Eng |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [NAME] | 2021-10-01 00:00:00 | 2022-02-01 00:00:00
 | PRJ04 | H&S |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | PRJ04 | 2021-10-01 00:00:00 | 2022-08-01 00:00:00
 | PRJ04 | Project Management |  |  |  |  |  | 3.886567164179104 | 3.761194029850746 | 3.886567164179104 | 3.886567164179104 | 3.51044776119403 | 3.886567164179104 | 3.761194029850746 | 3.886567164179104 | 3.761194029850746 | 3.886567164179104 | 3.886567164179104 |  |  |  |  | PRJ05 | 2021-06-01 00:00:00 | 2021-11-01 00:00:00
 | PRJ05 | Eng |  | 0.7086614173228345 | 7.322834645669293 | 7.322834645669293 | 7.086614173228348 | 7.322834645669293 | 0.2362204724409449
 | PRJ05 | H&S |  | 0.09448818897637795 | 0.9763779527559056 | 0.9763779527559056 | 0.9448818897637795 | 0.9763779527559056 | 0.03149606299212598
 | PRJ05 | Project Management |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 806160d1669135574-if-formula-impacted-by-previously-entered-data-data-sample
Sheet: Summary

 |  | 2022-07-22 00:00:00 | 2022-08-22 00:00:00 | 2022-09-22 00:00:00 | 2022-10-22 00:00:00 | 2022-11-22 00:00:00 | Total |  | Option 4 - Progressive
 |  |  |  |  |  |  |  |  | Size | [NAME] Actual Hours | Applicable Rev %
 |  |  |  |  |  |  |  |  | Tier 1 | 500 | 0.25
 |  |  |  |  |  |  |  |  | [NAME] | 1000 | 0.1
 |  |  |  |  |  |  |  |  | Tier 3 |  | 0.05
Spreadsheet: 167091d1341897155-need-help-with-soccer-table-please-soccer-table
Sheet: Fifa12 Spreadsheet

 |  |  | P | W | D | L | GF | GA | (+/-) | Pts
AC Milan
Barcelona
Chelsea
Manchester City
Real Madrid
 | Match Day 1 |  |  |  |  |  | Match Day 2 |  |  |  |  |  | Match Day 3
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Match Day 4 |  |  |  |  |  | Match Day 5 |  |  |  |  |  | Match Day 6
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Match Day 7 |  |  |  |  |  | Match Day 8 |  |  |  |  |  | Match Day 9 |  |  |  |  |  | Match Day 10
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 |  |  | P | W | D | L | GF | GA | (+/-) | Pts
AC Milan
Barcelona
Chelsea
Manchester City
Real Madrid
Spreadsheet: 716281d1612145779-return-column-header-based-on-1st-2nd-3rd-match-and-possible-offset-return-headers-based-on-values
Sheet: Sheet1

 | Help on retieving column headers based on cell values in range
 | list for lookup |  |  |  |  |  |  |  |  |  |  |  | Output
 |  |  |  |  |  |  |  |  |  |  |  |  | lookup value | EXPECTED FORMULA BELOW
 |  |  | Name | Header 1 |  | Name | [NAME] |  | Name | [NAME] |  |  | a | Header 1 | [NAME]
 | a |  | a | 1 |  | b | 2 |  | a | 3 |  |  | b | [NAME]
 | b |  | c | 2 |  | d | 3 |  | c | 7 |  |  | d | [NAME]
 | c |  |  |  |  | c | 5 |  |  |  |  |  | c | Header 1 | [NAME] | [NAME]
 | d
 | e
 | f
 | g
 | h
 | i
 | j
 | k
Spreadsheet: 877166d1723834907-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-jdnethaji-
Sheet: Install

Installed  On | MarkNo. | Qty (Nos) | [NAME]. | GROSS WEIGHT | Assembly Name
2024-06-23 00:00:00 | QLGF-C2001 | 1
2024-06-23 00:00:00 | QLGF-C2002 | 1
2024-06-24 00:00:00 | QLGF-C2002 | 1
2024-06-23 00:00:00 | QLGF-C2003 | 1
2024-06-24 00:00:00 | QLGF-BM2003 | 1
2024-06-24 00:00:00 | QLGF-BM2004 | 1
2024-06-24 00:00:00 | QLGF-HB2005 | 1
2024-06-24 00:00:00 | QLGF-HB2009 | 1
2024-06-25 00:00:00 | QL-1-BM2002 | 1
2024-06-25 00:00:00 | QL-1-BM2003 | 1
2024-06-25 00:00:00 | QL-1-BM2004 | 1
Spreadsheet: 846527d1697705944-conditional-format-to-highlight-cell-values-that-are-too-close-together-repeater-frequency-validation-1-
Sheet: Sheet2

Drop Down Menu Items
Frequency Bands | Repeater Offset | Offset Formula
Choose Band From Dropdown | [NAME]
10 [NAME] (29.5 - 29.7) | - 100 KHz | -.100
VHF Low Band (30 - 50) | NO Standard Offset, Enter Manually
VHF Ham Band (50 - 54) | - 500 KHz or - 1 MHz, Enter Manually
VHF High Band (138 - 174) | NO Standard Offset, Enter Manually
220 LMR (220 - 222) | + 1 MHz
220 HAM (222 - 225) | - 1.6 MHz | -1.6
UHF Fed LMR (380 - 400) | + 10 MHz
UHF Federal (406 - 420) | + 9 MHz | 9
UHF Canada Border (420 - 430) | + 5 MHz
UHF HAM (440 - 450) | + 5 MHz or - 5MHz, Enter Manually
UHF Standard (450 - 470) | + 5 MHz
UHF T-Band (470 - 512) | + 3 MHz
700 MHz (698 - 806) | + 30 MHz
800 MHz (806 - 896) | - 45 MHz | -45
900 MHz (896 - 940) | - 39 MHz | -39
900 HAM (902 - 928) | - 12 MHz or - 25 MHz, Enter Manually
Spreadsheet: 217507d1362084864-how-to-use-tallies-in-spreadsheet-to-create-account-xlf-119-tasman-trading
Sheet: Sheet4

Apr12 | M1 | M2 | M3 | trsf | po | fx | txt | em | time | ? | ph# | msg
4 | 1 |  |  | 1 |  |  |  |  | 1039 | r |  | swt daniel - forsythe barr
 | 1 |  |  | 1 |  |  |  |  | 1143 |  |  | swt daniel - forsythe barr
 | 1 |  |  |  |  |  |  |  | 1642 |  | [NAME] | swt daniel - forsythe barr
10 | 2 |  |  | 2
12 | 1 |  |  | 1 |  |  |  |  | 1100 | r |  | [NAME]
13 | 1
18 | 1 |  |  | 1 |  |  |  |  | 0929 | r |  | [NAME]
Spreadsheet: 158840d1338405299-results-summarizing-across-multiple-sheets-copy-of-guest-comments-card
Sheet: Optimus Summary

Aquarius Lunch | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling | 2
Table service |  | 2
Variety of food and beverage menu |  | 1 | 1
Server's knowledge of menu selection |  |  | 2
Quality and presentation of food | 1 | 1
Portion size of food | 1 |  | 1
Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere | 1 | 1
[NAME] handling |  |  | 2
Aquarius Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling | 1 |  |  | 1
Table service |  | 1 | 1
Variety of food and beverage menu | 1 |  | 1
Server's knowledge of menu selection |  | 2
Quality and presentation of food | 1 | 1
Portion size of food | 1 |  | 1
Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere |  | 1 | 1
[NAME] handling | 2
[NAME] Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling
Table service
Variety of food and beverage menu
Server's knowledge of menu selection
Quality and presentation of food
Portion size of food
Quality and presentation of beverage
Restaurant atmosphere
[NAME] handling
Spreadsheet: 467010d1466534090-match-n-a-oeldere-467001d1466531839-match-n-a-price-list-data
Sheet: Sheet1

 | Item |  | Item | Store 1 | Store 2 | Store 3 | Store 4 | Lowest Price | Store Name |  |  |  |  | 1 | shop 1
 |  |  | 1 | 7125.59 |  |  |  |  |  |  |  |  |  | 2 | store 2
 |  |  |  |  |  | 20 |  |  |  |  |  |  |  | 3 | city 3
 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 4 | state 1
 |  |  |  |  | 4
 |  |  | 2 | 136.19
 |  |  | 3 | 93.56
 |  |  | 4 | 113.96
 |  |  | 5 | 90.72
 |  |  | 6 | 107.2
 |  |  | 7 | 140.48
 |  |  | 8 | 636.29 | 490.5
 |  |  | 9 | 218.4
 |  |  | 10 | 116.95
 |  |  | 11 | 40.28
 |  |  | 12 | 615.28
 |  |  | 13 | 237.11
 |  |  | 14 | 57.92
 |  |  | 15 | 253.17
 |  |  | 16 | 62.31
 |  |  | 17 | 325
 |  |  | 18 | 113.4
 |  |  | 19 | 94.25
 |  |  | 20 | 120.84
 |  |  | 21 | 315.9
 |  |  | 22 | 104.16
 |  |  | 23 | 420.06
 |  |  | 24 | 313.92
 |  |  | 25 | 109
 |  |  | 26 | 422.92
 |  |  | 27 | 104.16
 |  |  | 28 | 420.06
 |  |  | 29 | 822.8
 |  |  | 30 | 4112.85
 |  |  | 31 | 595.1
 |  |  | 32 | 1371.5
 |  |  | 33 | 282.17
 |  |  | 34 | 450
 |  |  | 35 | 5473.67
 |  |  | 36 | 1647.2
 |  |  | 37 | 2719.04
 |  |  | 38 | 83.16
 |  |  | 39 | 715
 |  |  | 40 | 72
 |  |  | 41 | 518.02
 |  |  | 42 | 199.65
 |  |  | 43 | 46.34
 |  |  | 44 | 2593.97
 |  |  | 45 | 202.68
 |  |  | 46 | 5825.11
 |  |  | 47 | 3069.84
 |  |  | 48 | 73.7
 |  |  | 49 | 914.94
 |  |  | 50 | 1265
 |  |  | 51 | 1300
Spreadsheet: 829156d1683982531-find-missing-number-and-name-test-missing-code-name-from-sheet-2
Sheet: master

 | [NAME] (Numbers missing in sheet 2 column A) | [NAME] (Name assigned in sheet 2 column A)
6110
6120
6130
6210
6220
6230
7110
7120
7130
7190
7192
7210
7220
7225
7230
7240
7250
7260
7265
7270
7271
7272
7281
7282
7283
7284
7285
7288
7310
7320
7330
7340
7351
7352
7353
7360
7810
7820
7830
7840
7850
7880
7894
7895
7896
8110
8111
8112
8113
8114
8115
8116
8117
8120
8121
8130
8131
8132
8133
8140
8142
8145
8146
8147
8210
8215
8220
8225
8230
8235
8240
8241
8242
8243
8250
8255
8289
8301
8302
8303
8304
8305
8306
8310
8315
8320
8321
8323
8325
8340
8345
8365
8370
8375
8380
8385
8389
8401
8405
8410
8415
8420
8425
8430
8440
8445
8455
8460
8465
8470
8475
8480
8485
8510
8515
8520
8525
8530
8535
8540
8545
8550
8555
8560
8575
8580
8585
8610
8620
8630
8810
8820
8830
8840
8850
8855
9005
9110
9120
9130
9140
9171
9175
9180
9185
9195
9205
9210
9215
9220
9225
9245
9255
9260
9261
9262
9291
9292
9293
9341
9342
9410
9420
9510
Spreadsheet: 813108d1673552613-find-data-between-dates-example-3
Sheet: Bank

Date | Description | Type | Amount | Balance | Voucher
2022-11-25 00:00:00 |  | ACH credit | 29.99
2022-11-28 00:00:00 |  | ACH credit | 111
2022-11-30 00:00:00 |  | Other | 0.01
2022-11-30 00:00:00 |  | Misc. debit | -802
2022-12-01 00:00:00 |  | ACH credit | 83
2022-12-06 00:00:00 |  | ACH credit | 107
2022-12-07 00:00:00 |  | ACH credit | 250
2022-12-09 00:00:00 |  | ACH credit | 43
2022-12-12 00:00:00 |  | ACH credit | 204.51
2022-12-14 00:00:00 |  | ACH credit | 100
2022-12-15 00:00:00 |  | Fee | -55.22
2022-12-16 00:00:00 |  | ACH credit | 50
2022-12-20 00:00:00 |  | ACH credit | 500
2022-12-21 00:00:00 |  | Misc. debit | -1100
2022-12-22 00:00:00 |  | ACH credit | 200
2022-12-23 00:00:00 |  | ACH credit | 100
2022-12-27 00:00:00 |  | ACH credit | 75
2022-12-28 00:00:00 |  | Misc. debit | -1000
2022-12-29 00:00:00 |  | ACH credit | 170
2022-12-30 00:00:00 |  | Other | 0.01
2023-01-03 00:00:00 |  | ACH credit | 50
2023-01-04 00:00:00 |  | ACH credit | 100
2023-01-10 00:00:00 |  | ACH credit | 105.22
Spreadsheet: 05d51c83-57bf-4aef-8924-85b37dbc8be5
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
PBPR | Test | PBPR | Primidone and [NAME], Serum | Primidone and [NAME], S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL Additional Information: Phenobarbital (metabolite) determination is required for proper interpretation. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | PRIMIDONE Therapeutic concentration Children (<5 years): 7.0-10.0 mcg/mL Adults: 9.0-12.5 mcg/mL Toxic concentration: > or =15.0 mcg/mL  PHENOBARBITAL Therapeutic concentration Infants and children: 15.0-30.0 mcg/mL Adults: 20.0-40.0 mcg/mL Toxic concentration: > or =60.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day |  | Profile |  |  |  |  | Rochester
PBPR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
PBPR | Result | 31153 | Primidone, S | Primidone, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3978-4 | Primidone:MCnc:Pt:Ser/Plas:Qn:
PBPR | Result | 31154 | Phenobarbital, S | Phenobarbital, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3948-7 | Phenobarbital:MCnc:Pt:Ser/Plas:Qn:
PBPR | Billing Component | PBPR |  | Phenobarbital, S |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80184
PBPR | Billing Component | PBPR |  | Primidone |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80188
Spreadsheet: 885141d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-example
Sheet: SM

Training ID | Training Curriculum | Transfer type | Transfer phase activity description | Participant | Column6
Spreadsheet: 824791d1680834837-formula-to-count-alternate-columns-given-specific-value-example1-ragladstone62-
Sheet: Sheet1

Units | Chemical/Sample ID | 1 | Detection code | 2 | Detection code | 3 | Detection code | 4 | Detection code | 5 | Detection code | 6 | Detection code | 7 | Detection code | Percent Detected | Count Detected | Percent U | Count U | Percent J | Count J | Percent R | Count R | Percent J+ | Count J+ | Count per Row
ug/mL | 4-Nitrophenol
ug/mL | Acetaldehyde |  |  |  |  |  |  |  |  |  |  | 260 |  | 10 | U
ug/mL | Aluminum |  |  |  |  |  |  |  |  |  |  | 7700 |  | 200 | U
ug/mL | Arsenic |  |  |  |  |  |  |  |  |  |  | 1.4 |  | 1 | U
ug/mL | Benzo(a)anthracene
ug/mL | [NAME] |  |  |  |  |  |  | 10 | U |  |  | 0.19 | U | 0.19 | U
ug/mL | Benzo(g,h,i)perylene |  |  |  |  |  |  | 6.7
mg/L | Calcium |  |  |  |  |  |  | 380
mg/L | Chloride |  |  |  |  |  |  | 0.19 | U |  |  | 110 |  | 96
ug/mL | [NAME] |  |  |  |  |  |  | 200 |  |  |  | 1 | U | 1 | U
ug/mL | Chloromethane | 0.19 | U
ug/mL | Chromium-Hexavalent |  |  |  |  |  |  | 0.5 | U |  |  | 10 | U | 10 | U
ug/mL | Cobalt |  |  |  |  |  |  |  |  |  |  | 6.7 |  | 0.3 | U
ug/mL | Copper | 96 |  |  |  |  |  |  |  |  |  | 380 |  | 18
ug/mL | Dibenz(a,h)anthracene | 1 | U |  |  |  |  |  |  |  |  | 0.19 | U | 0.19 | U
ug/mL | Formaldehyde |  |  |  |  |  |  |  |  |  |  | 200 |  | 10 | U
ug/mL | Hexachloroethane | 10 | U
ug/mL | Hydrazine | 0.3 | U |  |  |  |  |  |  |  |  | 0.5 | U | 0.5 | U
ug/mL | Iron | 18 |  |  |  |  |  |  |  |  |  | 22000 |  | 160
ug/mL | Manganese | 0.19 | U |  |  |  |  |  |  |  |  | 8700 |  | 59
ug/mL | Nickel | 10 | U |  |  |  |  |  |  |  |  | 25 |  | 10 | U
mg/L | Nitrate |  |  |  |  |  |  |  |  |  |  | 0.3 |  | 0.24 | J+
mg/L | Nitrite |  |  |  |  |  |  |  |  |  |  | 0.05 | U | 0.05 | R
ng/L | N-Nitrosodimethylamine (NDMA) | 0.34 | J | 2.1 | U | 2 | U | 0.77 | J | 0.8 | J | 2.3 | U | 2.1 | U
ng/L | N-Nitroso-di-n-propylamine (NDPA) | 2.2 | U | 2.1 | U | 2 | U | 2 | U | 2.1 | U
ug/mL | Phenanthrene
mg/L | Sodium
Spreadsheet: 66634d1267259177-calculating-time-sumproduct-example
Sheet: Sheet1

company | time | direction | company | time | time2
company d | 20:17:26 | left | company d | 00:01:46 | 00:01:46
company d | 20:18:12 | right | company e | 00:00:57 | 00:00:57
company e | 23:43:29 | left | company f | 00:00:08 | 00:00:08
company e | 23:43:50 | right | company g | 00:00:15 | 00:00:15
company f | 00:40:37 | left | company h | 02:00:00 | 02:00:00
company f | 00:40:45 | right | company i | 02:00:00 | 02:00:00
company g | 00:49:37 | left
company g | 00:49:52 | right
company e | 02:20:41 | left
company e | 02:21:17 | right
company h | 17:00:00 | left
company i | 17:30:00 | left
company h | 19:00:00 | right
company i | 19:30:00 | right
company d | 15:00:00 | left
company d | 15:01:00 | right