tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 218226d1362405588-does-this-action-require-conditional-formatting-sample
Sheet: Sheet1

Complete | Month(of) | How many Visits/yr | Project Hours | Job Number | Location Name | Sort
X | Feb | 12 | 600 | [PHONE] | BLUE SMOKE
X | Mar | 12 | 600 | [PHONE] | BLUE SMOKE
X | Apr | 12 | 600 | [PHONE] | BLUE SMOKE
X | May | 12 | 600 | [PHONE] | BLUE SMOKE
X | Mar | 2 | 1200 | [PHONE] | LORAL CORPORATION
X | Feb | 2 | 1200 | [PHONE] | LORAL CORPORATION
X | Feb | 12 | 1600 | [PHONE] | WNYC RADIO
X | Mar | 12 | 1600 | [PHONE] | WNYC RADIO
X | Apr | 12 | 1600 | [PHONE] | WNYC RADIO
 | May | 12 | 1600 | [PHONE] | WNYC RADIO
X | Feb | 12 | 500 | [PHONE] | GRAMERCY TAVERN RESTAURANT
 | Mar | 12 | 500 | [PHONE] | GRAMERCY TAVERN RESTAURANT
 | Apr | 12 | 500 | [PHONE] | GRAMERCY TAVERN RESTAURANT
 | May | 12 | 500 | [PHONE] | GRAMERCY TAVERN RESTAURANT
Spreadsheet: 31209d1227016929-further-query-about-complex-cumulative-interest-pre-97-botten-arrears-calc3
Sheet: Sheet1

Name
Number
Non increasing pension paid |  |  |  | 1348.62
Non increasing pension should have been |  |  |  | 747.76
Difference which is now subject to annual increases |  |  |  | 600.8599999999999
 | Relevant Date | Was Paid | Increase Factor | Increase (Arrears)
 | 2008-03-23 00:00:00 | 600.8599999999999 | 0.03 | 34.61170934326908 | 1188.335354118905 | 587.4753541189052
 | 2007-03-25 00:00:00 | 600.8599999999999 | 0.03 | 33.60360130414474 | 1153.723644775636 | 552.8636447756362
 | 2006-03-26 00:00:00 | 600.8599999999999 | 0.027 | 29.44814135708886 | 1120.120043471491 | 519.2600434714914
 | 2005-03-27 00:00:00 | 600.8599999999999 | 0.031 | 32.79420850198494 | 1090.671902114402 | 489.8119021144025
 | 2004-03-28 00:00:00 | 600.8599999999999 | 0.028 | 28.81378932018258 | 1057.877693612417 | 457.0176936124176
 | 2003-03-31 00:00:00 | 600.8599999999999 | 0.017 | 17.20165818384267 | 1029.063904292235 | 428.2039042922349
 | 2002-03-31 00:00:00 | 600.8599999999999 | 0.017 | 16.91411817486988 | 1011.862246108392 | 411.0022461083922
 | 2001-04-01 00:00:00 | 600.8599999999999 | 0.036 | 34.57348707104904 | 994.9481279335223 | 394.0881279335224
 | 2000-03-05 00:00:00 | 600.8599999999999 | 0.011 | 10.44918006873116 | 960.3746408624733 | 359.5146408624734
 | 1999-03-07 00:00:00 | 600.8599999999999 | 0.032 | 29.45505304786797 | 949.9254607937421 | 349.0654607937422
 | 1998-03-08 00:00:00 | 600.8599999999999 | 0.036 | 31.98545818421956 | 920.4704077458741 | 319.6104077458742
 | 1997-03-09 00:00:00 | 600.8599999999999 | 0.025 | 21.67036462345499 | 888.4849495616546 | 287.6249495616547
 | 1996-03-10 00:00:00 | 600.8599999999999 | 0.035 | 29.31257050515651 | 866.8145849381996 | 265.9545849381997
 | 1995-03-12 00:00:00 | 600.8599999999999 | 0.022 | 18.02841909738449 | 837.5020144330431 | 236.6420144330432
 | 1994-03-13 00:00:00 | 600.8599999999999 | 0.02 | 16.06810971246389 | 819.4735953356586 | 218.6135953356587
 | 1993-03-14 00:00:00 | 600.8599999999999 | 0.035 | 27.168301446195 | 803.4054856231947 | 202.5454856231948
 | 1992-03-16 00:00:00 | 600.8599999999999 | 0.04 | 29.85527631449999 | 776.2371841769998 | 175.3771841769999
 | 1991-03-17 00:00:00 | 600.8599999999999 | 0.085 | 58.47231536249999 | 746.3819078624998 | 145.5219078624999
 | 1990-03-18 00:00:00 | 600.8599999999999 | 0.075 | 47.99369249999999 | 687.9095924999998 | 87.0495924999999
 | 1989-03-19 00:00:00 | 600.8599999999999 | 0.065 | 39.05589999999999 | 639.9158999999999 | 39.05589999999995
Date pension began | 1989-03-11 00:00:00 | 600.8599999999999 | 1 | 0
 |  | 12017.2 |  | 587.4753541189053 | 18543.49864026034 | 6526.298640260341 | 6526.298640260338
Spreadsheet: 852858d1702843095-average-daily-balance-formula-average-daily-balance-2
Sheet: Sheet1

 |  | Beginning Date |  | 2023-03-01 00:00:00
 |  | Ending Date |  | 2023-09-30 00:00:00
 |  | Average Daily Balance
 |  | Date | Deposit/ (Withdrawl) | Balance
 |  | 2023-02-03 00:00:00 | 10000
 |  | 2023-05-25 00:00:00 | 12000 |  |  |  | Total Daily Balance from 3/1/ to 5/25
 |  | 2023-07-23 00:00:00 | -1250 |  |  |  | Total Daily Balance from  5/25 to 7/23
 |  | 2023-10-17 00:00:00 | -2850 |  |  |  | Total Daily Balance from  7/23 to 9/30
 |  | 2023-12-15 00:00:00 | 15000
 |  |  |  |  |  |  | Total Daily Balance
 |  |  |  |  |  |  | Days between 3/1/23 and 10/31/23
 |  |  |  |  |  |  | Total Daily Balance Divided by day in range (244) |  | Average Daily Balance
Spreadsheet: darrell_schoolcraft__7837__ONEOKRECAP2001
Sheet: MANUAL

 |  | BUSHTON PROD. |  |  |  |  | HEMPHILL/CANADIAN |  |  |  |  | BUSHTON PVR |  |  |  |  | MULLINVILLE |  |  |  |  | ELLIS CO #1/#2
 |  | 103138 |  |  |  |  | 104307 |  |  |  |  | 103135 |  |  |  |  | 103133 |  |  |  |  | 107444
 |  | NAME | POI |  |  |  | NAME | POI |  |  |  | NAME | POI |  |  |  | NAME | POI |  |  |  | NAME | POI
 | 1 | HOCKETT | 3451 |  |  | 6 | HEMP 3 | 65 |  |  | 9 | PVR | 63024 |  |  | 10 | EDWARD 1 | 39 |  |  | 37 | ELLIS 2 ONEOK | 78109
 |  | MEADE CO | 8081 |  |  |  | ONEOK HEMP 3 | 62867 |  |  |  |  |  |  |  |  | EDWARD 2 | 40 |  |  |  | CRESC ELLIS | 71410
 |  | PLEASANT VALLEY | 25781 |  |  |  | [NAME] | 61491 |  |  |  |  |  |  |  |  | EDWARD 3 | 41
 |  | HAGAR | 59932 |  |  |  |  |  |  |  |  |  |  |  |  |  | PAWNEE 1 | 103
 |  | RALSTIN | 61998 |  |  |  |  |  |  |  |  |  |  |  |  |  | PAWNEE 2 | 104 |  |  |  | WWD CO #1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BURDETT | 17378 |  |  |  | 107445
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME | POI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | WWD  1 ONEOK | 78108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLARK CO #1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 107446
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME | POI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | CLK ONEOK | 78107
 |  | HOLCOMB |  |  |  |  | SUBLETTE
 |  | 103134 |  |  |  |  | 103132
 |  | NAME | POI |  |  |  | NAME | POI
 | 31 | FIN 1 | 51 |  |  | 16 | HASKELL | 62
 |  | FIN 2 | 52 |  |  |  | LIBERAL | 83
 |  | FIN 3 | 53 |  |  |  | STC 1 | 126 |  |  |  | HUGOTON |  |  |  |  |  |  |  |  |  | ONEOK
 |  | FIN 4 | 54 |  |  |  | STC 2 | 127 |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  | TOTAL
 |  | TATE | 135 |  |  |  | STC 3 | 128 |  |  |  | DEVIATION |  |  |  |  |  |  |  |  |  | DEVIATION
 |  | HOLCOMB SO | 1660 |  |  |  | STC 4 | 129
 |  |  |  |  |  |  | STC 6 | 131
 |  |  |  |  |  |  | TEX 1 | 137
 |  |  |  |  |  |  | TEX 2 | 138
 |  |  |  |  |  |  | MTC1 | 1713
 |  |  |  |  |  |  | SEWARD | 1752
 |  |  |  |  |  |  | SUBLETTE | 1998
 |  |  |  |  |  |  | HUGOTON N&S | 23269
 |  |  |  |  |  |  | MTC 6 | 61510
 |  |  |  |  |  |  | ELSC MCCOY | 63035
Spreadsheet: 698196d1601848107-formula-to-sum-variable-ranges-based-on-headers-desens
Sheet: product

Status | C | C | C | C | C | C |  | C | C | F | F | F | F
 | 06.2015 | 07.2015 | 08.2015 | 09.2015 | 10.2015 | 11.2015 |  | 12.2015 | 01.2016 | 02.2016 | 03.2016 | 04.2016 | 05.2016
 | S15 |  |  |  |  |  |  | W15 |  |  |  |  |  |  | Total
# Days | 30 | 31 | 31 | 30 | 31 | 30 |  | 31 | 31 | 29 | 31 | 30 | 31
Month | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 |  | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00
BOP STOCK Total | 0 | 0 | 0 | 0 | 0 | 0 |  | 12 | 12 | 12 | 12 | 12 | 12
BOP store | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 708 | 577 | 450 | 788
Plan | 1 | 2 | 3 | 4 | 5 | 6 |  | 1 | 2 | 3 | 4 | 5 | 6
Order | 7 | 8 | 9 | 10 | 11 | 12 |  | 7 | 8 | 9 | 10 | 11 | 12
VSS | 13 | 14 | 15 | 16 | 17 | 18 |  | 13 | 14 | 15 | 16 | 17 | 18
Act Indent | 19 | 20 | 21 | 22 | 23 | 24 |  | 19 | 20 | 21 | 22 | 23 | 24
Act VSS | 25 | 26 | 27 | 28 | 29 | 30 |  | 25 | 26 | 27 | 28 | 29 | 30
BOP + PIS Units | 0 | 0 | 0 | 0 | 0 | 0 |  | 1539 | 0 | 1446 | 1315 | 1188 | 1101
Spreadsheet: mary_fischer__25613__32H
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 2000 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | 2656838 |  |  |  |  |  |  |  |  |  | -2657838
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -16267536
RE - Beg Bal |  | 0920 |  | 5577178 |  |  |  |  |  |  |  |  |  | 2657838
RE - Net Income |  | 0930 |  | -1104062 |  | 1104062 |  | 991013
RE - Net Income (Fair Value Adjustment) |  | 0931 |  | 321995 |  | -321995 |  | 113489
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  | -1 |  |  |  | 3
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 46488d1245334712-aging-of-values-classement-donn-es-jour-semaine2
Sheet: Hoja1

 |  | [NAME] | midi | soir |  | lundi (matin) |  | mardi (midi + soir) |  | samedi (matin +  midi + soir)
 | lundi |  | 1.36 | 0.67 |  | 0.95 |  | 0.48 |  | 0.8
 | mardi | 0.67 | 0.48 | 0.49 |  | 0.51 |  | 0.49 |  | 3.65
 | mercredi | 3 | 3.19 | 1.44 |  | 0.98 |  | 2.57 |  | 1.23
 | jeudi | 1 | 1.43 | 0.84 |  |  |  | 2.23 |  | 1
 | vendredi | 0.02 | 2.68 | Hi |  |  |  | 2.35 |  | 3.05
 | samedi | 0.8 | 3.65 | 1.23 |  |  |  | 2.76 |  | 2
 | dimanche | 0.85 | 1 | 1 |  |  |  | 3.31 |  | 2.91
 | lundi | 0.95 | 2.07 |  |  |  |  | 0.99 |  | 1
 | mardi | 1 | 2.57 | 2.23 |  |  |  |  |  | 4.95
 | mercredi | 0.7 | 2.21 | 3 |  |  |  |  |  | hi
 | jeudi | 2 | 3.8 | 3.52
 | vendredi | 0.25 | 2.9 | 1
 | samedi | 1 |  | 3.05
 | dimanche | 0.6 | 0.49
 | lundi | 0.51 | 2.17 | 2.96 |  | In sum, I'd like to pick on any given day of the week, or after the time
 | mardi | 1.23 | 2.35 | 2.76 |  | of day desired, all values listed chronologically (not in ascending order)
 | mercredi | 0.56 | 1.39 | 3.53 |  | and omit the whites if there is a.
 | jeudi | 2 | 0.36 | 0.88
 | vendredi |  | 4.2 | 5
 | samedi | 2 | 2.91
 | dimanche | Hi | 0.74 | 1
 | lundi | 0.98 | 3.01 | 2.57
 | mardi |  | 3.31 | 0.99
 | mercredi | 0.85 | 1.03 | 1.59
 | jeudi | 0.4 | 1.11 | 1.25
 | vendredi | hi | 1.39 | 3
 | samedi | 1 | 4.95 | hi
 | dimanche | 3 | 1 | 0.51
Spreadsheet: 872430d1718809813-ignore-text-in-my-working-hours-formula-add-times-inc-text-etaf
Sheet: Sheet1

 | Mon
Employee Name | 2024-08-05 00:00:00
Emp 1
Emp 2 | Holiday
Emp 3
Emp 4 | 08:45:00 | 16:45:00
Emp 5 | 09:30:00 | 14:00:00
Emp 6 | Holiday
Emp 7
Emp 8 | 08:45:00 | 16:45:00
Emp 9
Emp 10
Emp 11
Emp 12 | 08:45:00 | 14:45:00
Emp 13
Emp 14
Emp 15
Emp 16 | 10:00:00 | 14:00:00
Emp 17 | 08:45:00 | 16:45:00
Emp 18
Emp 19
Emp 20
Emp 21 | 08:45:00 | 16:45:00
Emp 22 | 08:45:00 | 16:45:00
Emp 23 | 08:45:00 | 16:45:00
Emp 24 | 08:45:00 | 16:45:00
Emp 25
Emp 26 | 08:45:00 | 16:45:00
Emp 27 | 08:45:00 | 16:45:00
Emp 28 | 08:45:00 | 16:45:00
Emp 29
Emp 30
Spreadsheet: 875222d1721806840-schools-angling-league-scoresheet-schools-league-1-2024-punte
Sheet: Hoerskole JD Span Merietelys

Span | [NAME] | [NAME]
MACKIES DAMES - HS PIETERSBURG
REEL RASCALS DAMES - HS PIETERSBU
PIETIE CRUSHERS DAMES - HS PIETER
SCREAMINGREELS DAMES - HS PIETE
HPP DAMES 2
RESILIANT MIGNIONS DAMES - HS PIE
Spreadsheet: 884438d1733579502-adding-additional-sort-in-filter-sortby-sample
Sheet: Sheet1

City | Sales | Classification | Grade
Paris | 1.2 | VB | B
NY | 5 | VS | A+
Berlin | 4.5 | VS | A
Seattle | 0.3 | VB | A
Milan | 1 | VB | B
Madrid | 2 | VB | C
London | 1.5 | VS | A+
Hong Kong | 0.5 | VS | C
LA | 3 | VB | A-
Toronto | 0.7 | VB | B-
NY | 7 | VS | A+
Spreadsheet: 129132d1321463658-vlookup-over-multiple-sheets-2011-barter-and-trade-test
Sheet: September

Customer | Net | [NAME] | Size | Rep
[NAME]'s Bakery | 1 | 1 | 1/3 Page Square | [NAME]
Red Mountain Theatre Company | 2 | 2 | 2/3 Page | [NAME]
California Pizza Kitchen | 3 | 3 | 1/2 Page | [NAME]
Crystal Springs Water Co. | 4 | 4 | 1/6 Page | [NAME]
[NAME] Center | 5 | 5 | 1/3 Page Square | [NAME]
Birmingham Botanical Gardens | 6 | 6 | 1/3 Page Square | [NAME]
Alabama Public Television | 7 | 7 | 1/3 Page Square | [NAME]
Books A Million | 8 | 8 | 1/3 Page Vertical | [NAME]
[NAME]'s Flower Market | 9 | 9 | 1/3 Page Square | [NAME]
JAMM Entertainment Services | 10 | 10 | 1/3 Page Square | [NAME]
WELD for Birmingham | 11 | 11 | 1/3 Page Square | [NAME]
Al.com | 12 | 12 | 2/3 Page | [NAME]
[NAME] | 13 | 13 | 1/2 Page | [NAME]
Hothouse Design Studio | 14 | 14 | 1/3 Page Square | [NAME]
The Happy Catering Company | 15 | 15 | 1/3 Page Vertical | [NAME]
Railroad Park Film Series | 16 | 16 | 1/3 Page Square | [NAME]
A.G. Lighting | 17 | 17 | 1/2 Page | [NAME]
Birmingham Mountain Radio | 18 | 18 | [NAME] | [NAME]
Cox Radio | 19 | 19 | [NAME] | [NAME]
Cultural Alliance of Greater Birmingham - Birmingham 365 | 20 | 20 | [NAME] | [NAME]
The Birmingham News | 21 | 21 | [NAME] | [NAME]
Feld Entertainment | 22 | 22 | [NAME] | [NAME]
Spreadsheet: 147966d1333049424-excel-2007-convert-data-to-part-book1
Sheet: Sheet2

 | I want to convert |  |  | my formula for
Source Reference | source to part # |  |  | conversion to part # | NOTE
-------------------- | -------------------- |  |  | -------------------- | --------------------
02-89YY-119-120486 | 02-89YY-119 |  |  |  | part #  <> 13 characters
M001-TG0-120437 | M001-TG0 |  |  |  | part #  <> 13 characters
88-0001-RM135563 | 88-0001 |  |  |  | part #  <> 13 characters
488-10011-120439 | 488-10011 |  |  |  | part #  <> 13 characters
99200100-120312 | 99200100 |  |  |  | part #  <> 13 characters
D01-1102-RM135490 | D01-1102 |  |  |  | part #  <> 13 characters
TXSRS432-120375 | TXSRS432 |  |  |  | part #  <> 13 characters
TXSMS3C88-120411 | TXSMS3C88 |  |  |  | part #  <> 13 characters
6-3010-00-999 | 6-3010-00-999 |  |  |  | part #  = 13 characters
6-3010-00-999 31 | 6-3010-00-999 |  |  |  | part #  = 13 characters
Spreadsheet: 852663d1702622878-count-only-new-occurrences-within-specific-dates-new-occurences
Sheet: Sheet1

 |  |  |  | Date | Name | Met | New?
 | Date criteria From | Date criteria To |  | 2023-01-11 00:00:00 | [NAME]
 | 2023-07-01 00:00:00 | 2023-08-31 00:00:00 |  | 2023-01-11 00:00:00 | [NAME]
 |  |  |  | 2023-02-23 00:00:00 | [NAME]
 |  |  |  | 2023-04-01 00:00:00 | [NAME]
 |  |  |  | 2023-05-26 00:00:00 | [NAME]
 |  |  |  | 2023-07-01 00:00:00 | [NAME] |  | New
 |  |  |  | 2023-07-12 00:00:00 | [NAME] |  | New
 |  |  |  | 2023-08-01 00:00:00 | [NAME]
 |  |  |  | 2023-08-18 00:00:00 | [NAME] |  | New
 |  |  |  | 2023-09-23 00:00:00 | [NAME]
Spreadsheet: 091c630b-3012-4968-9731-b70fffce9af5
Sheet: Sheet1 - Table 1 - Table 1

2013 USAT Southeast Region SERCS Schedule
Last updated on 03/08/13
2013 EVENT | DATE | TYPE | STATE
Double Oak Duathlon | 2012-04-06 00:00:00 | Long Course Du | AL
PT Solutions Duathlon | 2012-04-14 00:00:00 | Short Course Du | GA
Los Locos Duathlon | 2012-04-14 00:00:00 | Short Course Du | TN
Beach Blast Sprint Triathlon | 2012-04-27 00:00:00 | Sprint Tri | FL
Spring Fling Triathlon | 2012-04-28 00:00:00 | Sprint Tri | GA
West Point Lake Triathlon | 2012-04-28 00:00:00 | Intermediate Tri | GA
[NAME] | 2012-05-05 00:00:00 | Half Tri | TN
Gulf Coast Triathlon | 2012-05-11 00:00:00 | Half Tri | FL
Clemson Triathlon | 2012-05-11 00:00:00 | Sprint Tri | SC
Peachtree International | 2012-05-18 00:00:00 | Intermediate Tri | GA
Memphis in May Triathlon | 2012-05-19 00:00:00 | Intermediate Tri | MS
Coliseum Health System's Rock 'N Roll Man | 2012-06-01 00:00:00 | Half Tri | GA
Dragonfly Triathlon | 2012-06-08 00:00:00 | Sprint Tri | MS
Tri the Parks - Blalock Lakes | 2013-06-22 00:00:00 | Aquathlon | GA
Chattanooga Waterfront Triathlon | 2012-07-15 00:00:00 | Intermediate Tri | TN
Tri the Parks - Mistletoe State Park | 2012-07-20 00:00:00 | Sprint Tri | GA
Music City Triathlon | 2012-07-28 00:00:00 | Intermediate Tri | TN
Heart O' Dixie Triathlon | 2012-07-27 00:00:00 | Sprint Tri | MS
Mountain Lakes Triathlon | 2012-08-10 00:00:00 | Sprint Tri | AL
Tri the Parks - [NAME] | 2013-08-10 00:00:00 | Aquabike | GA
[NAME] | 2012-08-11 00:00:00 | Sprint Tri | SC
Tri Peachtree City Triathlon | 2012-08-17 00:00:00 | Sprint Tri | GA
Tri Fall Creek Falls Triathlon | 2012-08-18 00:00:00 | Intermediate Tri | TN
[NAME] | 2012-08-25 00:00:00 | Intermediate Tri | AL
Tri the [NAME] - [NAME] State Park | 2012-09-07 00:00:00 | Short Course Du | GA
[NAME] | 2012-09-07 00:00:00 | Intermediate Tri | GA
[NAME] | 2012-10-13 00:00:00 | Half Tri | SC
Spreadsheet: bc33c97c-7975-4c9f-81f6-fa532f2bc25b
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
APO2S | Test | APO2S | Apolipoprotein A-II (APOA2) Gene, Full Gene Analysis | [NAME], Full Gene Analysis | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Wednesday; 10 a.m. | 14 days | 20 days | 1 | 81479 |  |  |  |  | Rochester
APO2S | [NAME] | VARIES | Varies |  |  |  | Ambient
APO2S | Result | 33404 | [NAME] | [NAME] | Alphanumeric
APO2S | Result | 33405 | [NAME] | [NAME] | Alphanumeric
APO2S | Result | 33406 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
APO2S | Result | 33407 | Order Date | Order Date | Alphanumeric
APO2S | Result | 33408 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
APO2S | Result | 33409 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
APO2S | Result | 33410 | Result | Result | Alphanumeric
APO2S | Result | 33411 | Interpretation | Interpretation | Alphanumeric
APO2S | Result | 33412 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
APO2S | Result | 33413 | Reviewed By | Reviewed By | Alphanumeric
APO2S | Result | 33414 | Release Date | Release Date | Alphanumeric
Spreadsheet: 34827ed7-eb9f-44ff-8102-7d6500948729
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
AFP | Test | AFP | Alpha-Fetoprotein (AFP) [NAME], Serum | Alpha-Fetoprotein, [NAME], S | Immunoenzymatic Assay | Serum Gel Tube: SGT OR |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | <6.0 ng/mL Reference values are for nonpregnant subjects only; fetal production of AFP elevates values in pregnant women. Range for newborns is not available, but concentrations over 100,000 ng/mL have been reported in normal newborns, and the values rapidly decline in the first 6 months of life. (See literature reference: Ped Res 1981;15:50-52.) For further interpretive information, see Alpha-Fetoprotein (AFP) in Special Instructions. Serum markers are not specific for malignancy, and values may vary by method. | Monday through Friday; 5 a.m.-12 a.m. Saturday; 6 a.m.-6 p.m. | 1 day | 3 days | 1 | 82105 |  |  |  |  | Rochester
AFP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
AFP | Result | AFP | Alpha-Fetoprotein, [NAME], S | Alpha-Fetoprotein, [NAME], S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53962-7
Spreadsheet: 741387d1627017801-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-copy-of-extract-values-into-desired-columns-ans1_1
Sheet: OUTPUT expected

 |  |  |  | Section I |  |  | Section II |  |  | Section III
S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2
15 | Desk, Vest - 15 | Desk, Vest | 1234567
15 | Desk, Vest - 15 | Desk, Vest | 1234567
15 | Desk, Vest - 15 | Desk, Vest | 1234567
15 | Desk, Vest - 15 | Desk, Vest | 1234567
15 | Desk, Vest - 15 | Desk, Vest | 1234567
15 | Desk, Vest - 15 | Desk, Vest | 1234567
15 | Desk, Vest - 15 | Desk, Vest | 1234567
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 |  |  |  |  |  |  | YTN | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 |  |  |  |  |  |  | PNT | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 |  |  |  |  |  |  | PNT | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 |  |  |  |  |  |  | PNT | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 |  |  |  |  |  |  | PNT | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 |  |  |  |  |  |  | PNT | 1 | 1
Spreadsheet: 787823d1658074077-if-vlookup-and-mod-subtotal-backwards-math-calculation-example
Sheet: Sheet1

 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1