tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734489d1622199014-if-column-number-matches-row-number-pull-out-number-excel-attached-testdoc
Sheet: Sheet1

 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  | Units | Units | Units | Units | Units | Units | Units
 |  |  |  |  |  |  | 0.4 | 0.1 | 0 | 0 | 0 | 0 | 0 | 7 | 0
 |  |  |  |  |  |  | 5.9 | 0 | 5.6 | 3.3 | 0 | 0 | 0 | 7 | 0
 |  |  |  |  |  |  | 6.2 | 3.3 | 4.4 | 1.5 | 0 | 10.8 | 0 | 6 | 10.8
 |  |  |  |  |  |  | 2.2 | 0 | 0 | 0.2 | 0.4 | 6.7 | 0 | 6 | 6.7
 |  |  |  |  |  |  | 8.5 | 15.7 | 6.9 | 0 | 3 | 0 | 0 | 6 | 0
 |  |  |  |  |  |  | 0.4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0
 |  |  |  |  |  |  | 35.3 | 21.2 | 36.3 | 1.4 | 9.1 | 0 | 0 | 1 | 35.3
 |  |  |  |  |  |  | 5.2 | 17.1 | 0 | 0 | 0 | 0 | 0 | 1 | 5.2
 |  |  |  |  |  |  | 24.7 | 0.2 | 32.9 | 19.5 | 0 | 0.9 | 0 | 4 | 19.5
Spreadsheet: 676323d1588759236-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: Main Sheet

[NAME] | May |  | [NAME] (Manual Payment) | Planned £ | Actual £ |  | [NAME] (DD Payment) | Planned £ | Actual £
[NAME] | 2020 |  |  | 125 |  |  | Home Insurance | 0
Yearly | 25000 |  |  |  |  |  |  | 25
Monthly |  |  | Water | 30 |  |  | TV, Talk & Broadband | 50
Tax | 100 |  |  |  |  |  | TV Licence | 12
National Insurance | 110 |  | Diesel | 50 |  |  | [NAME] | 11
Pension | 110 |  | Electric | 60 |  |  | Mobile Phone Joint Bill | 30
Rebates | 0 |  | Gas | 30 |  |  |  | 15
[NAME] |  |  | Savings | 100 |  |  | Netflix | 11.99
 |  |  | Trust Fund | 50 |  |  |  | 62
Bills Total |  |  | Loan Repay | 50 |  |  |  | 30
Leftover After Bills |  |  | Store Card | 0
 |  |  | Credit Card | 0
 |  |  | [NAME] | 20
 |  |  | Total |  |  |  | Total
 |  |  | Left To Pay |  |  |  | Left To Pay
Spreadsheet: 59177d1259660399-autofill-data-using-keywords-or-button-clicks-deviation-schedule-new-template-
Sheet: Overcurrent

OC1 | Cable strand has been utilised in BS3036 Fuse holder. | 1
OC2 | Fuse carrier is missing giving access to live parts. | 1
[NAME] | Fuse wire has been fitted to BS88/BS1361 fuse holder. | 1
OC4 | 13A BS1362 fuse in spur unit requires derating to 3A. | 2
OC5 | 1.5mm PVC/PVC radial circuit is protected by a (Rating in Amps) A Type (Fuse/MCB Type) Fuse/MCB.  Derating to (Rating in Amps) A is advised (15A [NAME]). | 1
OC6 | 2.5mm PVC/PVC radial circuit is protected by a (Rating in Amps) A Type (Fuse/MCB Type) Fuse/MCB.  Derating to (Rating in Amps) A is advised (20A [NAME]). | 1
OC7 | Push button MCB’s do not offer adequate short circuit protection. | 2
Spreadsheet: kim_ward__20828__SantaClara-Power-Plants
Sheet: POWER PLANTS

CALIFORNIA ENERGY COMMISSION
OPERATIONAL POWER PLANTS (100kW (0.1 MW) and ABOVE)
PLANTNAME (ALIAS) | FUEL SOURCE(COGEN) | TECHNOLOGY | ONLINE (MW) | GROSS (MW) | DATE ONLINE | SERVICE AREA | COUNTY | OPERATOR | OWNER
NCPA 1 #1-#2 | GEOTHERMAL - DRY STEAM |  | 86.2 | 110 | 1982-02-01 00:00:00 | PG&E | LAKE | NCPA | NCPA (45.35%), CSC(54.65%)
NCPA 2 #1-#2 | GEOTHERMAL - DRY STEAM |  | 87.6 | 110 | 1985-10-01 00:00:00 | PG&E | LAKE | NCPA | NCPA (65.87%), CSC (34.13%)
BLACK BUTTE | HYDRO |  | 6.2 | 6.2 | 1988-10-01 00:00:00 | PG&E | TEHAMA |  | CSC
CALAVERAS #1-#6 | HYDRO |  | 249.1 | 249.1 | 1990-01-01 00:00:00 | CCWD | CALAVERAS |  | NCPA(62.98%), CSC(37.02%)
GRIZZLY | HYDRO |  | 23.5 | 22 | 1993-11-01 00:00:00 | PG&E | PLUMAS |  | CSC
HIGHLINE CANAL | HYDRO |  | 0.5 | 0.53 | 1989-03-01 00:00:00 | PG&E | GLENN |  | CSC
STONY GORGE #1-#2 | HYDRO |  | 5 | 5 | 1986-03-01 00:00:00 | PG&E | GLENN |  | CSC
ALAMEDA #1-#2 | OIL/GAS - NATURAL GAS | COMBUSTION TURBINE | 49.9 | 50.4 | 1986-05-01 00:00:00 | PG&E | ALAMEDA | NCPA | NCPA 75%, CSC 25%
CITY OF SANTA CLARA #1-#2 | OIL/GAS - NATURAL GAS (COGEN) | COMBUSTION TURBINE WITH WASTE HEAT | 5.8 | 5.8 | 1982-06-01 00:00:00 | CSC | SANTA CLARA |  | CSC
GIANERA #1-#2 | OIL/GAS - NATURAL GAS | COMBUSTION TURBINE | 50 | 50 | 1986-01-01 00:00:00 | CSC | SANTA CLARA |  | CSC
LODI | OIL/GAS - NATURAL GAS | COMBUSTION TURBINE | 25 | 25 | 1986-02-01 00:00:00 | LODI | SAN JOAQUIN | NCPA | NCPA (75%), CSC (25%)
ROSEVILLE #1-#2 | OIL/GAS - NATURAL GAS | COMBUSTION TURBINE | 49.9 | 50.4 | 1986-04-01 00:00:00 | PG&E | PLACER | NCPA | NCPA (75%), CSC (25%)
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 807715 | 834377
78311 |  | 284983 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
78308 | 24783 |  |  |  |  |  |  |  |  |  | lunch | 7.6
500238 | 789963 | 927830
500239 | 921644 | 830825
500293 |  | 506900
500302 |  | 8059
500303 |  | 23513
500305 | 1228243 | 1315910
500307 |  | 50813
500313 |  | 2412
500314
500655 | 183126
500657 | 99167 | 54240
INDEX
2002-01-31 00:00:00
2002-02-25 00:00:00
CBS Volume
Spreadsheet: 885759d1735593586-get-a-new-list-from-one-column-to-a-new-column-treasurer-report-redacted
Sheet: CD Register

Date | Description | Debit | Credit
2024-09-16 00:00:00 | Starting Balance |  |  | 0
2024-09-16 00:00:00 | Deposit | 3014.45
2024-09-30 00:00:00 | Dividend | 5.41
2024-10-31 00:00:00 | Dividend | 11.9
2024-11-30 00:00:00 | Dividend | 10.57
Spreadsheet: 765243d1643221370-how-to-populate-all-data-in-other-column-when-choosing-a-certain-parameters-in-a-column-indexing-multiple-rows-of-data-lotsch-
Sheet: draft

Sales Rep ID | ID | Name | Plan ID | Plan Name | Element Name | Element Components | Element Weighting | Quota Currency | 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 | 2022-12-01 00:00:00 | FY | Element Source | Region | Business Area | Country
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
 |  |  | LXK02430
Spreadsheet: 273484d1382724544-array-formulas-book1
Sheet: FAC 1X

Rssm# | Part Number | Description | EC | DWG | Quantity | Price per Piece | Total Cost | AMR | Total Box | Total Amount |  | This is the really tricky part. I need each of these sheets to load the corresponding data from the October 2013 RSSM tab based on the facility code listed on that tab: Where the facility code on October [NAME] will match to its corresponding [NAME]. I would not object to putting the facility name hidden in the sheet itself if needed. This is currently a copy and paste operation that can take a great deal of time since in reality there are about 40 facility tabs and the parts list is generally over 200 part numbers. Macros are no good as far as what I know about them, because data and positions on the source sheet (October RSSM) change all the time. These facility tabs need to be a snapshot of current data. (Price per piece on this sheet is equivalent to STD $ on the RSSM sheeet) This may even require setting up a database (which I have very little experiance with and would like to avoid if possible. If that is the only way that is fine though)
 | 5678910 | varries | code | X | 2 | 1 |  | 10
 | 0X0000 |  | 0 | X | 5 | 1 |  | 10
 |  |  |  |  |  |  |  |  |  | Total Boxes
Spreadsheet: 17a225fa-55cc-420d-88e6-3db5d900d11d
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 5/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | Oct | Nov | Dec | Jan | Feb | Mar
 |  | 2012 | 2012 | 2012 | 2013 | 2013 | 2013
Exports | All wheat grain | 51750.87508381141 | 46512.0493887 | 62762.8693062 | 76874.32116889142 | 91025.42929445072 | 101784.6774569142
 | All wheat flour 1/ | 1236.396968887244 | 1020.540156181214 | 1023.336426672353 | 1076.848165719499 | 1111.884357404189 | 927.6449420258741
 | All wheat products 2/ | 644.7809153039525 | 641.8423426731335 | 486.8246706917599 | 489.0562170494644 | 596.5609254940301 | 851.2603597636167
 | Total all wheat | 53632.05296800261 | 48174.43188755435 | 64273.03040356412 | 78440.22555166038 | 92733.87457734894 | 103563.5827587037
Imports | All wheat grain | 9056.6771613213 | 8179.758924936904 | 9217.9667924295 | 9522.955191989402 | 9121.387520214905 | 6464.327187870301
 | All wheat flour 1/ | 881.3723790348241 | 830.5642066315149 | 819.7333560972884 | 818.6792741988849 | 847.43763241944 | 848.3643600054846
 | All wheat products 2/ | 1614.102198101327 | 1633.713467199341 | 1573.951869286533 | 1405.744347372018 | 1279.253090188831 | 1562.69362688873
 | Total all wheat | 11552.15173845745 | 10644.03659876776 | 11611.65201781333 | 11747.3788135603 | 11248.07824282317 | 8875.385174764517
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 5/14/2013
Spreadsheet: 0b9efa3b-c34b-4d00-9d1f-926ea7c4f7a8
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
HIV2M | Test | HIV2M | HIV-2 Antibody Screen, Serum | HIV-2 Ab Screen, S | Enzyme Immunoassay (EIA) |  |  |  | 1.2 |  | Collection Container/Tube: Serum gel	 Submission Container/Tube: Plastic vial [NAME]: 1.2 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative See HIV Serologic Interpretive Guide in Special Instructions for further interpretive information. | Monday through Friday; Varies | 1 day.  Approximately 1 week for the reflex confirmation result. | 3 days | 1 | G0432 |  |  |  |  | Rochester
HIV2M | [NAME] | SST | Serum SST |  |  |  | Frozen
HIV2M | Result | 60356 | HIV-2 Ab Screen, S | HIV-2 Ab Screen, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30361-0
HIV2M | [NAME] | HIV2L | HIV-2 Antibody Confirmation, Serum | HIV-2 Ab Confirmation, S | Line Immunoassay (LIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube: Serum gel	 Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative  This confirmatory assay should be ordered only on specimens that are reactive by an anti-HIV-2 screening immunoassay. | Monday; 3 p.m. | 5 Days | 9 Days | 1 | 86689 |  |  | No | Yes
HIV2L | [NAME] | SST | Serum SST |  |  |  | Frozen
HIV2L | Result | 61785 | HIV-2 Ab Confirmation, S | HIV-2 Ab Confirmation, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 858991d1707473383-info-in-a-filtered-column-spill-into-another-column-and-not-get-compressed-by-filter-excel-tests-3-
Sheet: Sheet2

 | SHIFT | STA | END | SCH | WRK | PAID | HRs
EMPLOYEE 1 | 600-1100 | 600 | 1100 | 0.2083333333333333 | 0.1979166666666667 | 0.2083333333333333 | 5
EMPLOYEE 2 | 600-1430 | 600 | 1430 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 4 | 600-1430 | 600 | 1430 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 5 | 530-1400 | 530 | 1400 | 0.3541666666666667 | 0.3125000000000001 | 0.3333333333333334 | 8
EMPLOYEE 7 | 730-1600 | 730 | 1600 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 8 | 600-1330 | 600 | 1330 | 0.3125 | 0.2708333333333333 | 0.2916666666666667 | 7
EMPLOYEE 9 | 600-1330 | 600 | 1330 | 0.3125 | 0.2708333333333333 | 0.2916666666666667 | 7
EMPLOYEE 10 | 400-800 | 400 | 800 | 0.1666666666666667 |  | 0.1666666666666667 | 4
EMPLOYEE 12 | 545-1415 | 545 | 1415 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 13 | 500-1330 | 500 | 1330 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 14 | 430-1300 | 430 | 1300 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 15 | 430-1300 | 430 | 1300 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 16 | 500-1330 | 500 | 1330 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 17 | 700-1530 | 700 | 1530 | 0.3541666666666667 | 0.3125 | 0.3333333333333334 | 8
EMPLOYEE 18 | 700-1530 | 700 | 1530 | 0.3541666666666667 | 0.3125 | 0.3333333333333334 | 8
EMPLOYEE 19 | 500-1330 | 500 | 1330 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 20 | 430-1300 | 430 | 1300 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 21 | 430-1300 | 430 | 1300 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 22 | 500-1330 | 500 | 1330 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 23 | 545-1415 | 545 | 1415 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
EMPLOYEE 25 | 400-800 | 400 | 800 | 0.1666666666666667 |  | 0.1666666666666667 | 4
EMPLOYEE 26 | 600-1330 | 600 | 1330 | 0.3125 | 0.2708333333333333 | 0.2916666666666667 | 7
EMPLOYEE 27 | 600-1330 | 600 | 1330 | 0.3125 | 0.2708333333333333 | 0.2916666666666667 | 7
EMPLOYEE 28 | 600-1330 | 600 | 1330 | 0.3125 | 0.2708333333333333 | 0.2916666666666667 | 7
EMPLOYEE 29 | 730-1600 | 730 | 1600 | 0.3541666666666666 | 0.3124999999999999 | 0.3333333333333333 | 8
Spreadsheet: 63905d1264764227-vlookup-with-mutliple-criteria-pending-contract
Sheet: Sheet1

Custmer code | plant code | Product code | Peding qty
1 | 2a | 13 | 10
2 | 3a | 36 | 7
3 | 5a | 44 | 13
4 | 1a | 14 | 5
5 | 3a | 14 | 4
6 | 5a | 13 | 44
7 | 1a | 36 | 78
8 | 2a | 44 | 54
9 | 3a | 14 | 68
10 | 5a | 14 | 65
11 | 1a | 25 | 45
Spreadsheet: tracy_geaccone__40281__EMNNG01CE
Sheet: OtherRev

PRINT: PAGE1
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
OTHER REVENUE ($000's)
DDVC's | CF Link | 230 | 154 | -22 | 18 | 48 | 20 | 51 | 0 | 0 | 0 | 100 | 250
Receipt Point Penalty | CF Link |  |  |  |  |  | 8
KN Helium Sale | CF Link | 0 | 0 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hedge Activity - Intercompany | CF Link | 75 | 296 |  | 0 | 188
- Third Party | CF Link | -65 | -6 |  | 1
Hubbard Annual Fee | CF Link |  | 160 |  |  | 26 | -186
Tenaska Consulting Fees   "Commercial Function" | CF Link | 0 | 0 | 331 | 331 | 331 | 331 | 331 | 331 | 331 | 331 | 331 | 331
Other | CF Link | 0 | 0 | 0 | 1 | 65 |  | 0 | 0 | 0 | 0 | 0 | 0
New Structured Products (Unidentified Stretch) | NonCash | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New Non-recurring Structured Products (Unidentified) | NonCash |  |  | 0 | 0 | 0 | 0 | 0 |  | 83 |  |  | 86
Strangers Gas (Administrative fee) | NonCash | 0 | 0 | 0 | 0 | 0 | 264 | 0 | 0 | 0 | 0 | 0 | 0
Offshore Liquids Transport | NonCash | 1 | 0 | 3 | 6 | 0 | 3 | 0 | 4 | 4 | 4 | 4 | 4
Lucent Reimbursement (1/99-12/03) '00 Short $751K | NonCash | 0 | 513 | 256 | 256 | 256 | 256 | 256 | 256 | 256 | 256 | 256 | 256
Other | NonCash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reserve Issues - (DDVC) | Link D.T. |  | -216 | 0 |  | -8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal
TOTAL OTHER REVENUE (NET)
PRINT: PAGE4
SBA DEMAND
TF Transport - North (Peak Day Units) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Central (Peak Day Units) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- South (Peak Day Units) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total TF Demand Volume
Avg. Revenue Rate ([NAME].)
Total SBA Demand & Commodity Revenue | Link Trans
Total SBA Demand & Commodity Expense |  | 1743 | 1652 | 791 | 1066 |  | 407 |  | 0 | 281 | 281 | 281 | 1012
Over / (Under) Recovery- Demand
Over / (Under) Recovery- Commodity | Linked
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Actual / Estimate Adjustments (Input) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OVER / (UNDER) RECOVERY
SBA   ADJUSTMENT
SBA - BALANCE SHEET | 12/31/00
Beginning Balance - (Over) / Under Recovery
Other Revenue / Expense Items (INPUT) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Current Month-Tracker
Other Adjustments (INPUT) |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Prior Month Carrying Charges
Ending Balance - (Over) / Under Recovery | 379
Interest Rate |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Monthly
Current Month Carrying Charges
Cumulative Carrying Charges
Spreadsheet: 889935d1740978558-use-min-and-max-with-filter-filter1a
Sheet: Sheet1

Player# | Cat B | Cat C | Cat D | # Points |  |  |  | # Points
1 | 20 | 12.5 | 103.4
2 | 3.5 | 21.5 | 109.6
3 | X
4 | 20 | 4.5 | 104.4
5 | X
6 | X
7 | 6 | 25.5 | 106.9
8 | 6 | 30.5 | 103.5
9 | 12 | 22 | 107.1
10 | 8 | 12 | 106.3
11 | 30 | 2.5 | 103.3
12 | 10 | 15 | 0
13
14
15
Player # |  | Cat C |  | Cat C |  | Cat C |  | Cat D
 |  |  |  |  |  | 6.975308641975309
2 |  | 16.97530864197531 |  | 16.97530864197531 |  | 16.97530864197531 |  | 17.54687500000001
4 |  | -1.913580246913578 |  | 2.777777777777778 |  | 2.777777777777778 |  | 11.04687500000002
7 |  | 21.41975308641975 |  | 21.41975308641975 |  | 21.41975308641975 |  | 14.17187500000002
8 |  | 26.97530864197531 |  | 26.97530864197531 |  | 26.97530864197531 |  | 9.921875000000018
9 |  | 17.53086419753086 |  | 17.53086419753086 |  | 17.53086419753086 |  | 14.42187500000001
10 |  | 6.419753086419753 |  | 6.419753086419753 |  | 6.419753086419753 |  | 13.42187500000001
11 |  | -4.135802469135802 |  | 2.777777777777778 |  | 2.777777777777778 |  | 9.671875000000014
12 |  | 9.753086419753087 |  | 9.753086419753087 |  | 9.753086419753087
Spreadsheet: 885005d1734416551-match-and-index-function-example-for-excel
Sheet: Data

Emp ID | SY | SS | SR | NR | SO | EMG | NCH | SW | RE | NH | [NAME]
1 | 0.8 | 0.2
2 | 0.6 |  |  | 0.4
3 | 0.5 |  |  |  |  | 0.5
4 | 0.6 |  | 0.4
5 | 0.5 |  | 0.5
6 | 0.6 |  |  |  | 0.4
7 | 0.6 |  |  |  |  | 0.4
8 | 0.6 |  |  |  |  |  |  |  |  | 0.4
9 | 0.5 |  |  |  |  |  |  |  |  | 0.5
10 | 0.7 |  |  |  |  |  | 0.3
 |  |  |  |  |  |  |  |  |  |  | [NAME] derived
Spreadsheet: e57e1407-12bc-42b5-9e67-8a8bb43c98fe
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
CORAB | Test | CORAB | Hepatitis B Core Total Antibodies, with [NAME] to Hepatitis B Core Antibody, IgM, Serum | HBc [NAME], w/Reflex, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and remove serum from clot within 24 hours. Additional Information: Date of draw is required. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative	 Interpretation depends on clinical setting.  See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86704 |  |  |  |  | Rochester
CORAB | [NAME] | SST | Serum SST |  |  |  | Frozen
CORAB | Result | CORAB | HBc [NAME], w/Reflex, S | HBc [NAME], w/Reflex, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16933-4 | Hepatitis B virus core Ab:ACnc:Pt:Ser:Ord:
CORAB | [NAME] | HBIM | Hepatitis B Core Antibody, IgM, Serum | HBc IgM Ab, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and remove serum from clot.  Additional Information: Date of draw is required. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative  See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86705 |  |  | No | Yes
HBIM | [NAME] | SST | Serum SST |  |  |  | Frozen
HBIM | Result | HBIM | HBc IgM Ab, S | HBc IgM Ab, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31204-1 | Hepatitis B virus core [NAME].IgM:ACnc:Pt:Ser:Ord:
Spreadsheet: 806796d1669597684-index-match-with-a-criteria-to-select-the-cells-which-have-the-selected-date-ex-10-31-22-date-filter-in-pivot
Sheet: Dashboard

 | [NAME]
 | 2022-10-31 00:00:00
 |  |  |  | As of Date | 2022-09-30 00:00:00 | << Change this filter cell???
 |  | Values |  | Row Labels | Sum of #
 |  | # |  | A | 10
 | Data as of 9/30/22 | Current |  | B | 15
 | A |  |  | C | 31
 |  |  |  | D | 21
 | B |  |  | Grand Total | 77
 | C
 | D
Spreadsheet: 878455d1725535288-auto-number-generate-with-conditions-srno-help
Sheet: tbl_Data

Item Type | Attribute | Value | Time | Rank
111 | Receipt _ Dt | 2024-01-01 00:00:00
111 | Receipt _ Dt | 2024-01-05 00:00:00
333 | Receipt _ Dt | 2024-01-05 00:00:00
111 | Receipt _ Dt | 2024-01-05 00:00:00
111 | Return  _ Dt | 2024-01-09 00:00:00
111 | Receipt _ Dt | 2024-01-09 00:00:00
111 | Return  _ Dt | 2024-01-10 00:00:00
111 | Receipt _ Dt | 2024-01-10 00:00:00
333 | Return  _ Dt | 2024-01-11 00:00:00
111 | Return  _ Dt | 2024-01-12 00:00:00
111 | Return  _ Dt | 2024-01-13 00:00:00
111 | Receipt _ Dt | 2024-01-13 00:00:00
111 | Receipt _ Dt | 2024-01-20 00:00:00
111 | Return  _ Dt | 2024-01-22 00:00:00
111 | Receipt _ Dt | 2024-01-25 00:00:00
111 | Receipt _ Dt | 2024-01-26 00:00:00
111 | Return  _ Dt | 2024-01-26 00:00:00
111 | Receipt _ Dt | 2024-01-26 00:00:00
111 | Receipt _ Dt | 2024-01-27 00:00:00
222 | Receipt _ Dt | 2024-01-27 00:00:00
111 | Receipt _ Dt | 2024-01-28 00:00:00
222 | Receipt _ Dt | 2024-01-28 00:00:00
111 | Return  _ Dt | 2024-01-31 00:00:00
111 | Return  _ Dt | 2024-01-31 00:00:00
222 | Return  _ Dt | 2024-02-15 00:00:00
111 | Receipt _ Dt | 2024-02-15 00:00:00
222 | Receipt _ Dt | 2024-03-31 00:00:00
111 | Receipt _ Dt | 2024-07-29 00:00:00
333 | Receipt _ Dt | 2024-07-31 00:00:00
111 | Return  _ Dt | 2024-08-01 00:00:00
333 | Receipt _ Dt | 2024-08-10 00:00:00
222 | Return  _ Dt | 2024-08-11 00:00:00
333 | Return  _ Dt | 2024-08-16 00:00:00
333 | Receipt _ Dt | 2024-08-25 00:00:00
111 | Return  _ Dt | 2024-08-29 00:00:00
Spreadsheet: 1b25b2ed-7cff-4243-8917-6139f1a16798
Sheet: One-time, PV-FV 

Discount Factor Table for One-time Fund
Present Value (PV) --> Future Value (FV) |  |  |  |  |  |  |  |  | Column: discount rate (r%), Row: Year (n)
 |  |  |  |  |  |  |  |  | [NAME]: (1+r%)^n
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
0
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
Spreadsheet: 774377d1648446752-enter-a-number-to-find-the-closest-minimum-difference-3028
Sheet: Sheet1

6 | 15 | 23 | 24 | 25 | 33 | Source Area
4 | 7 | 8 | 29 | 30 | 31 | <<<< KEY IN AREA
 | 6 | 6 | 25 | 33 | 33 | Result
 | 6 | 6 | 25 | 33 | 33
 |  |  |  |  | Subtract two numbers to find the closest number, if the two numbers are subtracted, take the minimum value
 |  |  |  |  | For example
 |  |  |  |  | Cell D2 key in 29
 |  |  |  |  | Because  29-25 = 4 , 33-29 = 4
 |  |  |  |  | Because the same difference is 4, the minimum value Cell D4 result is 25