tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4c100e0c-ea04-49e0-a6e6-4ac6e89b0b4e
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
DLAC | Test | DLAC | D-Lactate, Plasma | D-Lactate, P | Enzymatic | Gray-Top Tube (Potassium Oxalate/Sodium Fluoride): GryPOSF |  |  | 1 | mL | Collection Container/Tube: Grey top (potassium oxalate/sodium fluoride) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and immediately freeze specimen. Additional Information: For L-lactate (lactic acid), order [NAME], Plasma. | 0.55 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 0.0-0.25 mmol/L | Monday, Thursday | 4 days | 8 days | 1 | 83605 |  |  |  |  | Rochester
DLAC | [NAME] | NAFL-KOX | [NAME] |  |  |  | Frozen | 365 days
DLAC | Result | 8878 | D-Lactate, P | D-Lactate, P | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 14045-9 | D-lactate:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 587011d1534791480-conditional-formatting-example-file
Sheet: Sheet1

item # | description | month | total
123 | aaaa | January | 2
123 | aaaa | February | 5
123 | aaaa | March | 8
123 | aaaa | April | 9
123 | aaaa | May | 10
123 | aaaa | June | 12
123 | aaaa | July | 12
total
456 | bbb | January | 2
456 | bbb | February | 6
456 | bbb | March | 8
456 | bbb | April | 4
456 | bbb | May | 4
456 | bbb | June | 4
456 | bbb | July | 9
total
789 | eee | January | 5
789 | eee | February | 5
789 | eee | March
789 | eee | April
789 | eee | May
789 | eee | June
789 | eee | July
total
111 | [NAME] | January | 25
112 | [NAME] | February
113 | [NAME] | March
114 | [NAME] | April
115 | [NAME] | May
116 | [NAME] | June
117 | [NAME] | July
total
Spreadsheet: 267145d1379968565-function-to-find-if-a-string-contains-any-item-from-a-list-lutext
Sheet: Sheet3

ZYXDEF 123 | 1 |  |  | ABC
abc123123 | 1 |  |  | DEF
[NAME] | 0 |  |  | GHI
1234 ghi | 1 |  |  | 345
234 ghk | 0
[NAME] 456 | 1
[NAME] 345 | 1
eeee 123 | 0
345 tttt | 1
Spreadsheet: 77327d1277821174-push-data-range-based-on-the-input-value-excel-issue
Sheet: Sheet1

Input cell | [NAME] |  |  |  |  |  |  | If [NAME] has [NAME] |  |  |  | If [NAME] has [NAME]
Source Data |  |  |  | Destination Data |  |  |  | Destination Data |  |  |  | Destination Data
 | Region | Count |  |  | Region | Count |  |  | Region | Count |  |  | Region | Count
Mar-2010 | A | 23 |  | Mar-2010 | A | 23 |  | Mar-2010 | A | 23 |  | Mar-2010 | A | 23
Mar-2010 | B | 46 |  | Mar-2010 | B | 46 |  | Mar-2010 | B | 46 |  | Mar-2010 | B | 46
Apr-2010 | A | 34 |  | Apr-2010 | A | 34 |  | Apr-2010 | A | 34 |  | Apr-2010 | A | 34
Apr-2010 | B | 67 |  | Apr-2010 | B | 67 |  | Apr-2010 | B | 67 |  | Apr-2010 | B | 67
[NAME] | A | 765 |  | [NAME] | A | 765 |  | [NAME] | A | 765 |  | [NAME] | A | 765
[NAME] | B | 76 |  | [NAME] | B | 76 |  | [NAME] | B | 76 |  | [NAME] | B | 76
[NAME] | A | 69 |  | [NAME] | A | 69 |  |  |  |  |  | [NAME] | A | 69
[NAME] | B | 67 |  | [NAME] | B | 67 |  |  |  |  |  | [NAME] | B | 67
[NAME] | A | 97
[NAME] | B | 18
Spreadsheet: 266006d1379462370-drop-down-menu-when-selected-auto-populates-another-cell-with-linked-data-order-form-test
Sheet: Sheet3

N/A | N/A | 0
aabb | Brown knee high | 5
bbss | black knee | 10
seta | yellow knee | 10
bedd | green knee | 10
[NAME] | lace | 1
tsit | double toe | 5
Spreadsheet: 831168d1685459911-formula-to-lookup-from-dynamic-file-name-based-on-cell-value-output-file
Sheet: File & Sheet Lookup

w/c Date |  | Start |  | End |  | Sheetname | Cell | Filename & Sheet & Cell lookup
2023-05-28 00:00:00 | [Back Office 4 Week IDP - | 2805 | - | 2406 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-06-04 00:00:00 | [Back Office 4 Week IDP - | 0406 | - | 0107 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-06-11 00:00:00 | [Back Office 4 Week IDP - | 1106 | - | 0807 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-06-18 00:00:00 | [Back Office 4 Week IDP - | 1806 | - | 1507 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-06-25 00:00:00 | [Back Office 4 Week IDP - | 2506 | - | 2207 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-07-02 00:00:00 | [Back Office 4 Week IDP - | 0207 | - | 2907 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-07-09 00:00:00 | [Back Office 4 Week IDP - | 0907 | - | 0508 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-07-16 00:00:00 | [Back Office 4 Week IDP - | 1607 | - | 1208 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-07-23 00:00:00 | [Back Office 4 Week IDP - | 2307 | - | 1908 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-07-30 00:00:00 | [Back Office 4 Week IDP - | 3007 | - | 2608 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-08-06 00:00:00 | [Back Office 4 Week IDP - | 0608 | - | 0209 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-08-13 00:00:00 | [Back Office 4 Week IDP - | 1308 | - | 0909 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-08-20 00:00:00 | [Back Office 4 Week IDP - | 2008 | - | 1609 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-08-27 00:00:00 | [Back Office 4 Week IDP - | 2708 | - | 2309 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-09-03 00:00:00 | [Back Office 4 Week IDP - | 0309 | - | 3009 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-09-10 00:00:00 | [Back Office 4 Week IDP - | 1009 | - | 0710 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-09-17 00:00:00 | [Back Office 4 Week IDP - | 1709 | - | 1410 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-09-24 00:00:00 | [Back Office 4 Week IDP - | 2409 | - | 2110 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-10-01 00:00:00 | [Back Office 4 Week IDP - | 0110 | - | 2810 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-10-08 00:00:00 | [Back Office 4 Week IDP - | 0810 | - | 0411 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-10-15 00:00:00 | [Back Office 4 Week IDP - | 1510 | - | 1111 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-10-22 00:00:00 | [Back Office 4 Week IDP - | 2210 | - | 1811 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-10-29 00:00:00 | [Back Office 4 Week IDP - | 2910 | - | 2511 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-11-05 00:00:00 | [Back Office 4 Week IDP - | 0511 | - | 0212 | .xlsm] | Summary & Shrinkage | !$AW$63
2023-11-12 00:00:00 | [Back Office 4 Week IDP - | 1211 | - | 0912 | .xlsm] | Summary & Shrinkage | !$AW$63
Spreadsheet: 79cc519d-477e-4d75-985c-6bf95817d379
Sheet: APRIL

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-04-01 00:00:00 | TO | 2015-04-30 00:00:00 |  | MO. NO.: |  | 4
Holiday Pay |  |  |  | HP
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 165 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  | 7.5 |  | 7.5 | HP | 7.5
 |  |  |  |  |  |  | 1 |  | 2 | Good Friday | 3 |  | 4
 |  | HP | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 12 |  | 13 |  | 14 |  | 15 |  | 16 | Time sheets due | 17 |  | 18
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 19 |  | 20 |  | 21 |  | 22 | Mission day | 23 |  | 24 |  | 25
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 26 |  | 27 |  | 28 |  | 29 | Pay day | 30
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 207394d1358445526-determining-if-a-certain-number-of-blanks-occur-in-succession-at-any-point-in-a-row-example
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Answer: |  |  | Correct Answer (looking for this):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column | Address |  | Column | Address
Numbers( through column DN) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Max Period of Blanks | End of Max Period of Blanks | Location of Max Period of Blanks | Want the last Period of Blanks, which is below | End of Max Period of Blanks | Location of Max Period of Blanks
4 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 2 | 3 | 4 | 2 | 3 | 4 | 5 | 4 | 5 | 6 | 7 | 8 | 7 | 6 |  | 5 | 6 | 7 | 8 | 9 | 8 | 6 | 7 | 5 | 4 | 8.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.2
Spreadsheet: 125103d1318878430-summarizing-for-pivot-table-testdatals_v2
Sheet: Sheet3

Average of Hours | Column Labels
Row Labels | Development | Leadership | Service | Grand Total
Arizona School of Health Sciences |  | 4 |  | 4
Kirksville College of Osteopathic Medicine | 1 |  | 11 | 7
School of Osteopathic Medicine in Arizona |  | 3 |  | 3
Grand Total | 1 | 3.333333333333333 | 11 | 5.625
Spreadsheet: 141b41e6-379a-4e16-a222-00cc019bb8d6
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 13. LENDING FINANCE SEASONAL FACTORS, BY PURPOSE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial finance for fixed loan facilities ; |  |  | Original | A2433160J | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Commercial finance for revolving credit facilities ; |  |  | Original | A2433161K | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Total lease finance commitments ; |  |  | Original | A2433163R | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Personal finance for fixed loan facilities ; |  |  | Original | A2433157V | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Personal finance for revolving credit facilities ; |  |  | Original | A2433158W | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Investment housing, Construction of dwellings for rent and resale ; |  |  | Original | A2434908R | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by individuals ; |  |  | Original | A2434909T | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by others ; |  |  | Original | A2434910A | 1985-01-01 00:00:00 | 2010-06-01 00:00:00 | 306 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 809192d1670952060-top-ten-percentile-amjad-sample-period_end_p11_2022-test
Sheet: Expected Answer

Lane_State | SERVICE_CD | CORP_WK_NUM | CORP_PD_NUM | TOTAL_TOTAL
CA--->ON | NOF_CAD | 41 | 11 | 20257.7
CA--->ON | NOF_USD | 41 | 11 | 16770.2
CA--->ON | NOF_USD | 41 | 11 | 16770.2
CA--->ON | NOF_USD | 41 | 11 | 16070.2
CA--->ON | NOF_USD | 41 | 11 | 15320.2
CA--->ON | NOF_CAD | 41 | 11 | 14981.05
CA--->ON | NOF_CAD | 41 | 11 | 10248.48
CA--->ON | NOF_CAD | 41 | 11 | 10003.85
CA--->ON | NOF_CAD | 41 | 11 | 10003.85
CA--->ON | NOF_USD | 42 | 11 | 17073.06
CA--->ON | NOF_USD | 42 | 11 | 16073.06
CA--->ON | NOF_USD | 42 | 11 | 15673.06
CA--->ON | NOF_USD | 42 | 11 | 15623.06
CA--->ON | NOF_CAD | 42 | 11 | 10315.03
CA--->ON | NOF_CAD | 42 | 11 | 10190.03
CA--->ON | NOF_CAD | 42 | 11 | 10190.03
CA--->ON | NOF_CAD | 42 | 11 | 10190.03
CA--->ON | NOF_USD | 43 | 11 | 17115.88
CA--->ON | NOF_USD | 43 | 11 | 17115.88
CA--->ON | NOF_USD | 43 | 11 | 17115.88
CA--->ON | NOF_CAD | 43 | 11 | 10535.93
CA--->ON | NOF_CAD | 43 | 11 | 10535.93
CA--->ON | NOF_CAD | 43 | 11 | 10535.93
CA--->ON | NOF_CAD | 43 | 11 | 10535.93
CA--->ON | NOF_CAD | 43 | 11 | 10535.93
CA--->ON | NOF_CAD | 43 | 11 | 10485.93
CA--->ON | NOF_CAD | 43 | 11 | 10485.93
CA--->ON | LTLW | 44 | 11 | 1095.21
Spreadsheet: mary_fischer__25641__111
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111 |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME  Pierce Mechanical
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | completed
E-2 * | 195 | Other Current Assets | completed
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | completed
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | completed
E-11* | 655 | Other Current Liabilities | completed
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | completed
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | completed
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | completed
E-31 |  | [NAME] | completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 752464d1634768099-extract-specific-number-of-characters-if-word-in-cell-begins-with-specific-text-tapyr-answer
Sheet: Sheet1

Data | Result | Answer
[PHONE] | [PHONE]
School [PHONE], Best | 2101225909
[PHONE] | [PHONE]
[PHONE] | [PHONE]
[PHONE] | [PHONE]
Rock School [PHONE]
[PHONE] room | [PHONE]
tower [PHONE] | 2101213684
Spreadsheet: 799086d1664905624-my-index-match-does-not-seem-to-be-working-correctly-slave
Sheet: Mbrs

ID | GWMbrs | Hero Pwr
3
29
28
26
22
4
18
27
17
21
20
12
1
23
30
19
14
15
24
13
16
11
7
6
5
2
9
10
8
25
Spreadsheet: 117996d1313333389-summing-cell-content-in-every-6th-column-sum6th
Sheet: Sheet1

Sum every 6th column - 2 ways
168 | 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 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
168 | 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 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45
Helper | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Spreadsheet: 853269d1703156268-conditional-format-highest-value-in-previous-28-cells-cf-offset-strange-p-and-r-aligw
Sheet: TRENDING ANALYSIS (WEEK)

 |  |  |  |  | Normal Pay |  |  |  |  |  |  |  |  |  | Standard Overtime |  |  |  |  |  |  |  |  |  | Double Pay
 |  | 1 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 |  | 1 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 |  | 1 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
 |  | Date | Wash Tech Month Ending | [NAME] |  | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved |  | Date | Wash Tech Month Ending | [NAME] |  | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved |  | Date | Wash Tech Month Ending | [NAME] |  | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved
 | Week 1
 | Week 2
 | Week 3
 | Week 4 | 2023-10-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2023-10-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2023-12-04 00:00:00
Spreadsheet: 762493d1641577292-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Denver_P9

Denver DC
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME]/COS | [NAME] | 80072054 | RSA |  | Y | 2
 | [NAME] | 71107148 | FTM-toRSA | L | DOT only |  |  | Lives in Thornton
 | [NAME] | 80071632 | FTM | L
Did not show up | [NAME] | 80070865 | FTM | L
 | Kinnzey Lopez | 80070869 | FTM |  | ? |  |  | Unknown, do not have address
Did not show up | [NAME] | 80070873 | CSS | L | Y | 2 | Charged for one night
Late | [NAME]Late 1 | 80071845 | RSA | L | Y | 2 |  | Late one hour on day one and 45min on day 2
Did not show up | [NAME] |  | RSA |  | N | N
 | [NAME] |  | RSA
Ft. Collins | [NAME] | unknown | RSR |  | Y | M, T, W
 | [NAME] | unknown | RSS |  | Y | M, T, W | 2 | 2
 | [NAME] | unknown | RSS |  | Y | M, T, W
 | [NAME] |  |  |  |  |  | 3 | 3
 | [NAME] |  |  |  |  | 2
New Mexico | [NAME] | 80070497 | RSA | L | T,W | Alb/Kathleen
 | [NAME] | 80072437 | RSA | L | T,W | Alb/Kathleen
 | [NAME] | Pending | RSA | XXL
 | Names Coming | Pending | RSA
El Paso |  |  |  |  |  |  |  | Have the receipt and expensed
Spreadsheet: 835447d1688584595-rentrun-value-only-to-first-instance-of-lookup-value-return-value-only-to-first-instance-of-lookup-value
Sheet: Sheet1

 |  | What I don’t want
 |  | Account | Transactions | Total Sales |  |  |  | Account | Total Sales
 |  | 1 | 0.9229700367841491 |  |  |  |  | 1 | 458
 |  | 1 | 0.6377953809610273 |  |  |  |  | 2 | 857
 |  | 1 | 0.5183634201107947 |  |  |  |  | 3 | 174
 |  | 2 | 0.2564388215806985 |  |  |  |  | 4 | 1006
 |  | 2 | 0.04328923408005236 |  |  |  |  | 5 | 658
 |  | 2 | 0.7215263739639177
 |  | 3 | 0.7291767139933514
 |  | 3 | 0.09552753616621423
 |  | 4 | 0.7527769391371932
 |  | 4 | 0.7108251240873098
 |  | 5 | 0.9774339185540624
 |  | What I do want
 |  | Account | Transactions | Total Sales
 |  | 1 | 0.9229700367841491
 |  | 1 | 0.6377953809610273
 |  | 1 | 0.5183634201107947
 |  | 2 | 0.2564388215806985
 |  | 2 | 0.04328923408005236
 |  | 2 | 0.7215263739639177
 |  | 3 | 0.7291767139933514
 |  | 3 | 0.09552753616621423
 |  | 4 | 0.7527769391371932
 |  | 4 | 0.7108251240873098
 |  | 5 | 0.9774339185540624
Spreadsheet: 128239d1320869691-excel-2007-forward-looking-months-of-supply-formula-months-of-supply
Sheet: Sheet1

 | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
Beginning Inv
Receipts |  | 2000 | 1500 |  | 5000 |  | 6000 | 10000 | 4000 | 10000 | 8000 | 10000 | 10000 | 5000 | 4000
Sales |  | 4000 | 4000 | 4000 | 500 | 5000 | 6000 | 6000 | 7000 | 8000 | 8000 | 6000 | 5000 | 4000 | 4000
Ending Inv | 10000
Months of Supply
Spreadsheet: 708616d1607951159-finding-highest-value-across-sheets-book1
Sheet: Wk1

 | 2020-11-01 00:00:00 |  |  |  |  |  |  |  |  | 869
 | 2020-11-02 00:00:00 |  |  |  |  |  |  |  |  | 393
 | 2020-11-03 00:00:00 |  |  |  |  |  |  |  |  | 576
 | 2020-11-04 00:00:00 |  |  |  |  |  |  |  |  | 883
 | 2020-11-05 00:00:00 |  |  |  |  |  |  |  |  | 814
 | 2020-11-06 00:00:00 |  |  |  |  |  |  |  |  | 173
 | 2020-11-07 00:00:00 |  |  |  |  |  |  |  |  | 249
 | 2020-11-08 00:00:00 |  |  |  |  |  |  |  |  | 602
 | 2020-11-09 00:00:00 |  |  |  |  |  |  |  |  | 739
 | 2020-11-10 00:00:00 |  |  |  |  |  |  |  |  | 634
 | 2020-11-11 00:00:00 |  |  |  |  |  |  |  |  | 615
 | 2020-11-12 00:00:00 |  |  |  |  |  |  |  |  | 450
 | 2020-11-13 00:00:00 |  |  |  |  |  |  |  |  | 5
 | 2020-11-14 00:00:00 |  |  |  |  |  |  |  |  | 714
 | 2020-11-15 00:00:00 |  |  |  |  |  |  |  |  | 689
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 623
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 606
 | 2020-11-18 00:00:00 |  |  |  |  |  |  |  |  | 316
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 208
 | 2020-11-20 00:00:00 |  |  |  |  |  |  |  |  | 125
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 126
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 714
 | 2020-11-23 00:00:00 |  |  |  |  |  |  |  |  | 13
 | 2020-11-24 00:00:00 |  |  |  |  |  |  |  |  | 306
 | 2020-11-25 00:00:00 |  |  |  |  |  |  |  |  | 999
 | 2020-11-26 00:00:00 |  |  |  |  |  |  |  |  | 440
 | 2020-11-27 00:00:00 |  |  |  |  |  |  |  |  | 624
 | 2020-11-28 00:00:00 |  |  |  |  |  |  |  |  | 912
 | 2020-11-29 00:00:00 |  |  |  |  |  |  |  |  | 667
 | 2020-11-30 00:00:00 |  |  |  |  |  |  |  |  | 459
Spreadsheet: tracy_geaccone__40297__02CapPlan_8_27_01
Sheet: NNG - Summary

NORTHERN NATURAL GAS
2002 - 2003 OPERATING & STRATEGIC PLAN
CAPITAL SUMMARY - COMMERCIAL GROUP
 |  |  |  |  |  |  |  |  |  | 2001
 |  |  |  |  |  |  |  |  |  | 2nd CE |  | 2002 |  | 2003
 |  |  |  |  |  |  |  |  |  | ($[NAME]) |  | ($[NAME]) |  | ($[NAME])
 | Total Capital - Plant |  |  |  |  |  |  |  |  | 22.2 |  | 35.09 |  | 20.37
 |  | Discretionary |  |  |  |  |  |  |  | 9.6 |  | 20.8 |  | 20
 |  | Non-Discretionary |  |  |  |  |  |  |  | 12.6 |  | 14.3 |  | 0.35
 | Discretionary
 |  | Discretionary Pool made up of 18 Projects (total project estimates = $28.1 MM, Probability Adjusted = $15.0 MM)
 |  | Revenue from Capital Pool $1.1 MM in 2002.  In-service November1,2002
 |  | Other Non Pool Items = $5.9 MM  ([NAME] $4.7MM).  Revenue in 2002 = $.3 MM.
 | Non-Discretionary
 |  | Non-Discretionary made up of 11 Projects
 |  | Metropolitan Utilities District ($6.3 MM) - Commitment on long term contract extension
 |  | Exxon / Mobil ($3.5 MM) - Commitment on 10 year Operating Agreement  ($6.8 MM left on commitment which ends in 2005)
 |  | Belleville Compression & NNG/WG TBS ($2.5 MM) - East Leg Sale, Contract extension with Wisconsin Gas
 | Capital Other Than Plant
 |  | Base Gas Buyback ($25.0 MM in 2002, 0 in 2003)  See additional SBA Expense for the carrying cost on remaining amount
 |  | [NAME] 25% Ownership in Expansion ($4.5 MM)
 |  | Regulatory Commission Expense - ($.5 MM in 2002, $1.3 MM in 2003) - Increase for 2003 Rate Case