tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13af8b7f-21db-400d-9b4c-83a81b4244ec
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
E1 | Test | E1 | Estrone, Serum | Estrone, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Serum Gel Tube: SGT |  |  | 1.2 | mL | Container/Tube: Preferred: Red top  Acceptable: Serum gel  [NAME]: 1.2 mL Collection Instructions: Serum must be separated from gel within 24 hours of draw. Additional Information: See Steroid Pathways in Special Instructions. | 0.8 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | CHILDREN* 1-14 days: Estrone levels in newborns are very elevated at birth but will fall to prepubertal levels within a few days. [NAME] Stages#	Mean Age	Reference Range Stage I (>14 days and prepubertal)	7.1 years	Undetectable-16 pg/mL Stage II	11.5 years	Undetectable-22 pg/mL Stage III	13.6 years	10-25 pg/mL Stage IV	15.1 years	10-46 pg/mL Stage V	18 years	10-60 pg/mL #[NAME] onset (transition from Tanner stage I to Tanner stage II) occurs for boys at a median age of 11.5 (+/- 2) years. For boys there is no proven relationship between puberty onset and body weight or ethnic origin. Progression through Tanner stages is variable. Tanner stage V (adult) should be reached by age 18.   Females Tanner Stages#	Mean Age	Reference Range Stage I (>14 days and prepubertal)	7.1 years	Undetectable-29 pg/mL Stage II	10.5 years	10-33 pg/mL Stage III	11.6 years	15-43 pg/mL Stage IV	12.3 years	16-77 pg/mL Stage V	14.5 years	17-200 pg/mL #[NAME] onset (transition from Tanner stage I to Tanner stage II) occurs for girls at a median age of 10.5 (+/- 2) years. There is evidence that it may occur up to 1 year earlier in obese girls and in African American girls. Progression through Tanner stages is variable. Tanner stage V (adult) should be reached by age 18.  *The reference ranges for children are based on the published literature(1,2), cross-correlation of our assay with assays used to generate the literature data and on our data for young adults.   ADULTS Males: 10-60 pg/mL Females Premenopausal: 17-200 pg/mL Postmenopausal: 7-40 pg/mL Conversion factor E1: pg/mL x 3.704=pmol/L (molecular weight=270) | Monday through Saturday; 1 p.m. | 2 days | 4 days | 1 | 82679 |  |  |  |  | Rochester
E1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
E1 | Result | 81418 | Estrone, S | Estrone, S | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 2258-2 | Estrone:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 832677d1686541361-how-to-have-cell-put-border-around-cell-that-meets-certain-criteria-short-term-real-trades-4-oct-2013-study-36
Sheet: Sheet1

 |  |  |  |  | 1234..123cl..234X2t..246 |  |  |  |  |  |  |  | a t6=3,t12=6,..b t13=3,
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | start 5/17/23
 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 2 | 2 | 2 | 4 | 2 | 5 | 2 | 8
all | 1 | 0 | 0 | 1 | 1 | 0 | 2 | 3 | 3 | 3 | 5 | 4 | 7 | 4 | 10
[NAME]) | 1 | 0 | 0 | 1 | 1 | 0 | 2 | 3 | 3 | 4 | 7 | 5 | 9 | 6 | 12
all(s/fexp) | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 3 | 4 | 7 | 9 | 6 | 10 | 8 | 15
all(s/fexp) | 1 | 0 | 0 | 1 | 3 | 0 | 3 | 3 | 7 | 7 | 12 | 8 | 11 | 13 | 21
all(s/fexp) | 1 | 0 | 0 | 1 | 4 | 1 | 3 | 3 | 8 | 8 | 17 | 11 | 16 | 17 | 24
 | 1 | 0 | 0 | 1 | 4 | 1 | 3 | 3 | 8 | 8 | 17 | 11 | 16 | 17 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | a t6=3,t12=6,..b t6=3,
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 2 | 1 | 3 | 7 | 6 | 7
all | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 2 | 2 | 2 | 4 | 7 | 7 | 9
[NAME]) | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 2 | 2 | 2 | 4 | 9 | 9 | 12
all(s/fexp) | 1 | 0 | 0 | 1 | 2 | 0 | 3 | 1 | 3 | 4 | 7 | 6 | 12 | 13 | 19
all(s/fexp) | 1 | 0 | 0 | 1 | 2 | 1 | 3 | 2 | 3 | 6 | 9 | 6 | 15 | 16 | 20
all(s/fexp) | 1 | 0 | 0 | 1 | 3 | 1 | 3 | 3 | 5 | 9 | 12 | 8 | 20 | 19 | 22
 | 1 | 0 | 0 | 1 | 4 | 1 | 4 | 4 | 5 | 9 | 14 | 8 | 20 | 20 | 23
Spreadsheet: 685720d1594152650-looking-for-formulas-to-get-me-individual-cells-in-a-range-that-are-true-for-formula-is-formula
Sheet: Sheet2

Sheds | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Tractors | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Grass | 5568 | 5569 | 5570 | 5571 | 5572 | 5573 | 5574 | 5575 | 5576 | 5577 | 5578 | 5579
Roots | 58698 | 58699 | 58700 | 58701 | 58702 | 58703 | 58704 | 58705 | 58706 | 58707 | 58708 | 58709
Paint | 2569 | 2570 | 2571 | 2572 | 2573 | 2574 | 2575 | 2576 | 2577 | 2578 | 2579 | 2580
Led | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Spreadsheet: 864395d1711575361-if-xlookup-formulas-creation-assistance-excel-asssitance
Sheet: MCC & F&P Register (Sinead Cowa

Area (Sub-Business) | Location | Impact | Status | Open text | Qualification | If 'Other', Please [NAME] Obtained | For ‘Qualified’ individuals, | Member | Has the individual completed the Fitness & Probity Declaration for the last calendar year? | Please detail any issues
A | EU | 1 |  |  |  |  |  |  | Yes | detailed information
B | US | 2 | X |  | AC |  | Yes | Yes | No | detailed information
C | EU | 3
D | US | 2 | Y |  |  |  |  |  | No | detailed information
A | EU | 3
C | US | 2 | Z |  |  |  |  | No | Yes | detailed information
 |  | 2 | X |  | Other | detailed information | No | Yes | No | detailed information
Spreadsheet: tracy_geaccone__40395__NNG3rdCEEM
Sheet: OtherRev

PRINT: PAGE1
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
OTHER REVENUE ($000's)
DDVC's | CF Link
Receipt Point Penalty | CF Link
KN Helium Sale | CF Link
Hedge Activity - Intercompany | CF Link
- Third Party | CF Link
Hubbard Annual Fee | CF Link
Tenaska Consulting Fees   "Commercial Function" | CF Link
Miscellaneous | CF Link
Misc. Item 2 | CF Link
Misc. Item 3 | CF Link
New Structured Products (Unidentified Stretch) | NonCash
New Non-recurring Structured Products (Unidentified) | NonCash
Strangers Gas (Administrative fee) | NonCash
Offshore Liquids Transport | NonCash
Lucent Reimbursement (1/99-12/03) '00 Short $751K | NonCash
Other (Mics. Item 1) | NonCash
Reserve Issues - (DDVC) | Link D.T.
- Misc. Item 1 | Link D.T.
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 | Linked
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: 57ae235b-9eff-40d7-9504-9ba402cbb172
Sheet: Sheet1

SEZNAM PEDAGOGŮ A PRACOVNÍKŮ CENTRA JAZYKOVÉ PŘÍPRAVY AMU | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
telefon do sekretariátu: 234 244 571
 | Tajemník katedry | e-mail | telefon
 | [NAME] | [EMAIL] | 605435212
[NAME] | Vedoucí CJP AMU
Aj | PhDr. Párová Štěpánka | [EMAIL] | 721331208
 | Interní pedagogové
Aj | Ing. [NAME], B.A. | [EMAIL] | 732185898
Nj | Mgr. Honzíková Ivanka | [EMAIL] | 777229550
Aj | PhDr. [NAME] | [EMAIL] | 603564054
Aj | PhDr. [NAME] | [EMAIL] | 271725856
Aj | Mgr. [NAME] | [EMAIL] | 731556728
Fr | PhDr. Paulisová Janka | [EMAIL] | 604474744
[NAME] | PhDr. [NAME], PhD. | [EMAIL] | 608524254
 | Externí pedagogové
Šp | Lorena Aguado Sánchez | [EMAIL]
Šp | [NAME] Antequera | [EMAIL] | 774978726
It | [NAME] | [EMAIL]
It | [NAME] | [EMAIL] | 606468844
Fr | Moise Lemonnier | [EMAIL] | 773577263
Nj | Tomislav Potocký | [EMAIL]
Čj | [NAME] | [EMAIL] | 777558713
Aj | [NAME] | [EMAIL]
Nj | [NAME] | [EMAIL] | 776777913
It | [NAME] | [EMAIL] | 777676948
Fr | [NAME] Vaddé | [EMAIL]
Aj | [NAME] | [EMAIL]
Spreadsheet: 48051d1247231623-lookup-function-book1
Sheet: Port to Desk Mappings

Definity Ports | Network Point | Patch Panel Link
01B0801 | X10F-099 | Link X10F-24
01B0802 | X10F-081 | Link X10F-09
01B0803 | [NAME] | Link X10F-13
01B0805 | X10F-168 | [NAME]
01B0809 | X10F-656 | Link X10F-08
01B0810 | X10F-008 | Link X10F-19
01B0811 | X10F-146 | Link X10F-22
01B0813 | X10F-136 | Link X10F-15
01B0815 | X10F-082 | Link X10F-12
01B0902 | X10F-135 | Link X1OF-05
01B0904 | X10F-022 | Link X10F-17
01B0905 | X10F-071 | [NAME]
01B0906 | X10F-024 | Link X10F-23
Spreadsheet: 782395d1654014751-lookup-value-in-one-column-if-not-there-lookup-in-another-column-to-return-value-in-a-3rd-test-file
Sheet: Sheet1

MFG-Part-Number | Type
[NAME]
PRO+G50S-36P RH61
PROE38-S2 RH95-B
PROE40-M2 RH95
[NAME] RH95
PROE47-S2 RH95
PROG40-32P RH62 |  | EXPECTED:
660479 |  | Tank 6yr
650265 |  | Tank 6yr
Spreadsheet: 45842d1244636409-monthly-sum-copy-of-markup
Sheet: Summary

MONTH WISE MARK-UP EXPENSES
S.NO. | BANK NAME & ACCOUNT NO. | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | TOTAL
1 | Bank1 | 80345.42352526027 | 41020.45100827397 | 122887.5549196438 | 127260.7301672876 | 129244.7383526712 | 88898.79079772055 | 46688.23135367616 | 47384.92364196164 | 94648.91503731614 | 46640.31032872439 | 143553.3533045835 | 0 | 968573.4224371193
2 | Bank2
3 | Bank3
Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: EWC

 |  |  |  | 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
 | Enron Wind Corp Return
 | TOTAL INCOME TAX
 | Taxable Income (Loss)
 | [NAME] (Re-Used)
 | Total Taxable Income
 | Effective Tax Rate
 | Total Income Tax Benefit (PMT)
 | PTC
 | Total PTC
 | [NAME] Income
 | Share of PTC
 | ANNUAL RETURN
 | INITIAL EQUITY
 | ADDITIONAL EQUITY
 | CASH DISTRIBUTION
 | TOTAL INCOME TAX BENEFIT (PMT)
 | TAX CREDIT- PTC
 | TOTAL PRE-TAX CASH FLOW
 | CUMULATIVE P-T CASH FLOW
 | TOTAL AFTER-TAX CASH FLOW
 | CUMULATIVE A-T CASH FLOW
 | ANNUAL RESULTS |  | AFTER TAX
 |  |  | IRR | NPV
 |  | 10 YEAR
 |  | 20 YEAR
 |  | 30 YEAR
 |  |  | PRE TAX
 |  | 10 YEAR
 |  | 20 YEAR
 |  | 30 YEAR
 | QUARTERLY CASHFLOW DATES |  | AFTER TAX
 | PRE TAX
 | QUARTERLY CASHFLOW VALUES |  | AFTER TAX
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | PRE TAX |  | 0
 | ANNUAL TOTAL
 | QUARTERLY RESULTS |  | AFTER TAX
 |  |  | IRR | NPV | [NAME]
 |  | 10 YEAR
 |  | 20 YEAR
 |  | 30 YEAR
 |  |  | PRE TAX
 |  | 10 YEAR
 |  | 20 YEAR
 |  | 30 YEAR
 | ANNUAL PAYMENT PARAMETERS
 | ADDITIONAL EQUITY | 0 | 1
 | CASH DISTRIBUTION | 0 | 1
 | TOTAL INCOME TAX BENEFIT (PMT) | 0.25 | 0
 | TAX CREDIT- PTC | 0.25 | 0
Spreadsheet: 596004d1540906254-if-and-using-vlookup-from-another-tab-using-table-but-if-over-roundup-to-next-cell-med-gas-branch-pipe-sizing-test-autosaved-
Sheet: Medical Nitrogen 

MEDICAL NITROGEN LINE SIZING (300 LPM PER OUTLET) |  |  |  |  |  |  |  |  | NITROGEN PRESSURE DROP
START | END | RUN (FEET) | FLOW (LPM) | PIPE SIZE | LOSS PER 100' | LOSS | RUNNING SUB TOTAL
 |  |  |  |  |  |  |  |  | FLOW |  | NOMINAL PIPE SIZE
A | B |  |  |  |  |  |  |  | LPM | SCFM | 1/2" | 3/4" | 1" | 1-1/4" | 1-1/2" | 2" | 2-1/2" | 3" | 4"
B | C
C | D
D | E
E | F |  |  |  |  |  |  |  | System Totals
F | G |  |  |  |  |  |  |  | [NAME] | LPM Per Section |  | Pressure [NAME] (PSIG/100 FT) |  |  |  | Equivalent (LF) |  | Pressure Drop
G | H |  |  |  |  |  |  |  | 4"
H | J |  |  |  |  |  |  |  | 3"
J | K |  |  |  |  |  |  |  | 2 1/2"
K | L |  |  |  |  |  |  |  | 2"
L | M |  |  |  |  |  |  |  | 1 1/2"
M | N |  |  |  |  |  |  |  | 1 1/4"
 |  |  |  |  |  |  |  |  | 1"
 |  |  |  |  |  |  |  |  | 3/4"
 |  |  |  |  |  |  |  |  | 1/2"
 |  |  |  |  |  |  |  |  | Total Maximum System Loss Per 100' = |  |  |  |  |  | System Total Pressure Drop
 |  |  |  |  |  |  |  |  | Place your flow rate for the overall zone of pipe you are sizing up top, then place the flow rate for the section you are sizing and the length of that section in the middle. |  |  |  |  |  | LENGTH OF LONGEST RUN |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADD FOR FITTING  LOSS |  |  |  | LF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EQUIVALENT LENGTH |  |  |  | LF
Spreadsheet: 265708a7-816b-4b87-ad08-6644238ff231
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8991 | 8137 | [NAME] | Bradley-Cox | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:37:18
8991 | 67316 | [NAME] | Young | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:50:17
8991 | 67304 | Sue | Hutchinson | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:55:27
8991 | 67315 | Pater | Pollack | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 03:05:40
8991 | 67301 | Luise | Easton | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 03:12:23
8991 | 67312 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 03:13:25
8991 | 67259 | Monique | Balembois | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 03:27:36
8991 | 67260 | Monique | [NAME] | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 8 | 03:31:23
Spreadsheet: 6ca59450-4b5c-4f86-af2d-b703315e44b3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5023 | 15261 | Viv | [NAME] | RSA | 0 | 00:21:59 | 00:00:00 | 01:14:45 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 5925a415-9065-446d-89d2-dad38df3804b
Sheet: EPR EBITDA FCF

 | Periods Ended June 30,
 | Quarters |  |  |  | Nine Months
 | 2012 |  | 2011 |  | 2012 |  | 2011
Adjusted EBITDA
GAAP Income from continuing operations | 46.89999999999988 |  | 91.80000000000001 |  | 159.6 |  | 232.3000000000001
Other (income) expense, net | 21.4 |  | 19.1 |  | 63.39999999999999 |  | 60.1
Income tax provision | 27.2 |  | 29.9 |  | 90.5 |  | 96.7
Depreciation and amortization | 64.1 |  | 55.3 |  | 179.3 |  | 161.4
Other charges:
Share-based compensation | 8.8 |  | 9.2 |  | 25.4 |  | 31.5
Contingent acquisition related costs | 26 |  | 0 |  | 37.8 |  | 0
Adjusted EBITDA | 194.3999999999999 |  | 205.3 |  | 556 |  | 582.0000000000001
 |  |  |  |  |  | Nine Months Ended
 |  |  |  |  |  | June 30,
 |  |  |  |  | 2012 |  | 2011
Free Cash Flow
GAAP net operating cash flows |  |  |  |  | 327 |  | 448.7000000000002
Investment in property, plant and equipment |  |  |  |  | -35.3 |  | -10.8
Investment in gaming operations equipment |  |  |  |  | -133.2 |  | -143.2
Investment in intellectual property |  |  |  |  | -2.3 |  | -1.1
Free Cash Flow (before dividends) |  |  |  |  | 156.2 |  | 293.6000000000001
Dividends paid |  |  |  |  | -53.5 |  | -53.8
Free Cash Flow (after dividends) |  |  |  |  | 102.7 |  | 239.8000000000001
Spreadsheet: 39196d1237391738-help-needed-with-counting-the-number-of-instances-between-blanks-cells-676316_starbucks_junkie
Sheet: PTSOURCE

Date | Product | Stock | Stock_Flg | Movement
2009-02-26 00:00:00 | Product A | 10 | 0 | 0 |  | Stock Flag -> 0 = instock per OP
2009-02-26 00:00:00 | Product B | 0 | 1 | 0
2009-02-27 00:00:00 | Product A | 0 | 1 | 1 |  | Movement is based on original position on day 1 (ie in/out stock)
2009-02-27 00:00:00 | Product B | 0 | 1 | 0
2009-02-28 00:00:00 | Product A | 20 | 0 | 0
2009-02-28 00:00:00 | Product B | 1 | 0 | 1
2009-03-01 00:00:00 | Product A | 0 | 1 | 1
2009-03-01 00:00:00 | Product B | 1 | 0 | 0
2009-03-02 00:00:00 | Product A | 0 | 1 | 0
2009-03-02 00:00:00 | Product B | 0 | 1 | 0
2009-03-03 00:00:00 | Product A | 0 | 1 | 0
2009-03-03 00:00:00 | Product B | 1 | 0 | 1
2009-03-04 00:00:00 | Product A | 30 | 0 | 0
2009-03-04 00:00:00 | Product B | 0 | 1 | 0
2009-03-05 00:00:00 | Product A | 0 | 1 | 1
2009-03-05 00:00:00 | Product B | 1 | 0 | 1
2009-03-06 00:00:00 | Product A | 0 | 1 | 0
2009-03-06 00:00:00 | Product B | 0 | 1 | 0
2009-03-07 00:00:00 | Product A | 10 | 0 | 0
2009-03-07 00:00:00 | Product B | 1 | 0 | 1
Spreadsheet: 157915d1337924955-pulling-data-based-on-name-to-new-reformatted-sheet-sample-sheet
Sheet: Data By Store

Store Name | Sales Team Breakdown |  | Open Opportunities | Opportunity | Targeting | Interview | Application | Closed Deal - Closed | Closed - Lost | Cancelled | Opportunity Conversion Rate
Store 1
 | [NAME] 2 | Role 1
 | [NAME] | Role 3
 | [NAME] | Role 4
Store 2
 | [NAME] | Role 1
 | [NAME] 12 | Role 1
 | ED SMITH 1 | Role 6
 |  | 3
Spreadsheet: 0299af89-1f71-4e27-89ab-0ff433bf2fdf
Sheet: Sheet1

1932 - 20th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Kleinhüningen, Basel, Switzerland |  |  |  |  | 1932-09-25 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | Settle | Lt. T.G.W. | [NAME] | Lt. E.Winfield | US Army | Daugieliszki/Vilna/Poland | 1550 | 1900-01-01 17:20:00
2 | USA | Orman | [NAME] | Blair | [NAME] | Goodyear VIII | [NAME] | 1356 | 1900-01-01 04:45:00
3 | FRA | Ravaine | Georges | Grain | René de | Petit Mousse | Tokary | 1238 | 19:58:00
4 | POL | [NAME] | Wladyslaw | Janusz | Antoni | Polonie | Siemien | 1181 | 1900-01-01 00:00:00
5 | SPA | Nunez | [NAME] | Carrasco | Franc. | 14 de Avril | Sadowne | 1162 | 1900-01-01 00:53:00
6 | POL | [NAME] | [NAME] | Burzynski | Zbigniew | Gdynia | Bielany | 1089 | 17:05:00
7 | FRA | Marquant | Marius | Brucker | M. de | L'Avanture | Potworow | 1045 | 1900-01-01 00:25:00
8 | SUI | Baerle | Dr. [NAME] | Dietschi | Dr. E. | Basel | Zondlowice/Poland | 1017 | 21:41:00
9 | GER | Eimermacher | Ferdinand | [NAME] | Dr. Hugo | [NAME] | Zelechlinek | 1006 | 18:40:00
10 | BEL | Demuyter | Ernest | [NAME] | [NAME] | Belgica | [NAME] | 965 | 21:06:00
11 | SUI | Huber | [NAME]. E. | Lochinger | Fst.Ltd. J. | Victor de Beauclair | Mycielin | 906 | 14:52:00
12 | GER | Bertram | Otto | Dahl | [NAME] | Barmen | Keltsch | 865 | [NAME]
13 | SUI | Gerber | [NAME] | Tilgenkamp | Dr. E. | Zürich II | Deutsch-Rasselwitz/Germany | 803 | 17:01:00
14 | FRA | [NAME] | [NAME] | [NAME] | G. | Lafayette | Falkenberg/Germany | 801 | 18:55:00
15 | GER | Leimkugel | Erich | Schütze | [NAME] | Deutschland | Freiwaldau/Germany | 762 | [NAME]
16 | AUT | Effhofen | Dr. [NAME] | [NAME] | F. | [NAME] | Greifendorf/Germany | 698 | 12:38:00
Spreadsheet: 593644d1539261320-dynamicaly-linked-cells-based-on-the-month-test-labor-tracker
Sheet: Chart

 | Meal Count
 | 15,000 – 14,001 | 5.63
 | 14,000 – 13,001 | 5.62
 | 13,000 – 12,001 | 5.62
 | 12,000 – 11,001 | 5.6
 | 11,000 – 10,001 | 5.52
 | 10,000 –  9,001 | 5.47
 | 9,000 –  8,001 | 5.42
 | 8,000  -  7,001 | 5.35
 | 7,000  -  6,001 | 5.18
 | 6,000  -  5,001 | 4.93
 | 5,000  -  0 | 4.42
Spreadsheet: 146667d1332293499-populate-new-file-with-multiple-excel-files-sample20database-1-
Sheet: Address

Name | Street | City | State | Zip | Phone | Cell
[NAME] | 123 Street | Springfield | IL | 12345 | [PHONE] | [PHONE]
[NAME] | 123 Street | Springfield | IL | 12345 | [PHONE] | [PHONE]
[NAME] | 123 Street | Springfield | IL | 12345 | [PHONE] | [PHONE]
[NAME] | 123 Street | Springfield | IL | 12345 | [PHONE] | [PHONE]
[NAME] | 123 Street | Springfield | IL | 12345 | [PHONE] | [PHONE]
Spreadsheet: 698199d1601852173-how-to-take-monthly-average-based-on-dates-electric
Sheet: Sheet1

Utility | Date | Average
BGE | 2016-01-01 00:00:00 | 27.28038333333333
BGE | 2016-05-30 00:00:00 | 22.61321666666667
BGE | 2016-07-04 00:00:00 | 21.49092083333333
BGE | 2016-09-05 00:00:00 | 36.01042083333333
BGE | 2016-11-24 00:00:00 | 22.93530416666666
BGE | 2016-12-26 00:00:00 | 25.6174
PECO | 2016-01-01 00:00:00 | 12.63515
PECO | 2016-05-30 00:00:00 | 22.00831666666667
PECO | 2016-07-04 00:00:00 | 7.975829166666667
PECO | 2016-09-05 00:00:00 | 12.990625
PECO | 2016-11-24 00:00:00 | 20.1459875
PECO | 2016-12-26 00:00:00 | 25.88587916666667
Spreadsheet: jeffrey_a_shankman__13821__Northeast HEating oil Reserve
Sheet: DIFFS

 | Northeast Heating Oil Reserve (NHOR)
 | Week | Residential Heating Oil Price |  |  | Average WTI |  | Heating | 5-year | Current | Differential
 |  |  |  |  | Crude Oil Spot |  | Oil/ | Average | vs. | Required
 |  |  |  |  | Price (Previous Week) |  | Crude | Differential | Average | for
 |  |  |  |  |  |  | Oil |  | Differential | Release
 |  |  |  |  |  |  | Differential
 |  | PADD 1x | PADD 1y | [NAME]. | dollars | cents
 |  |  |  | PADD | per | per
 |  |  |  | 1x/1y | barrel | gallon
 | 2000-10-02 00:00:00 | 144.8 | 150.1 | 147.5 | 31.13 | 74.1 | 73.3 | 50.3 | 0.458 | 80.5
 | 2000-10-09 00:00:00 | 145.6 | 150.4 | 148 | 31.27 | 74.4 | 73.6 | 50.3 | 0.462 | 80.5
 | 2000-10-16 00:00:00 | 153 | 157.2 | 155.1 | 33.9 | 80.7 | 74.4 | 50.3 | 0.478 | 80.5
 | 2000-10-23 00:00:00 | 150.2 | 155.1 | 152.6 | 33.48 | 79.7 | 72.9 | 50.3 | 0.45 | 80.5
 | 2000-10-30 00:00:00 | 150.4 | 154.9 | 152.6 | 33.92 | 80.8 | 71.9 | 50.3 | 0.429 | 80.5
 | 2000-11-06 00:00:00 | 149.2 | 154.4; | 151.8 | 32.78 | 78 | 73.8 | 52.2 | 0.413 | 83.5
 | 2000-11-13 00:00:00 | 150.8 | 155.1 | 153 | 33.46 | 79.7 | 73.3 | 52.2 | 0.404 | 83.5
 | 2000-11-20 00:00:00 | 155 | 159.6 |  | 35 |  |  | 52.2 |  | 83.5
 | 2000-11-27 00:00:00 | 157.4 | 161.5 |  | 35.86 |  |  | 52.2 |  | 83.5
 | 2000-12-04 00:00:00 | 156.4 | 161.8 |  | 34.1 |  |  | 54.9 |  | 87.9
 | 2000-12-11 00:00:00 | 156.5 | 162.2 |  | 29.69 |  |  | 54.9 |  | 87.9
 | 2000-12-18 00:00:00 | 154.6 | 160.6 |  | 29.05 |  |  | 54.9 |  | 87.9
 | 2000-12-25 00:00:00 |  |  |  |  |  |  | 54.9 |  | 87.9
 | 2001-01-01 00:00:00 |  |  |  |  |  |  | 63 |  | 100.9
 | 2001-01-08 00:00:00 |  |  |  |  |  |  | 63 |  | 100.9
 | 2001-01-15 00:00:00 |  |  |  |  |  |  | 63 |  | 100.9
 | 2001-01-22 00:00:00 |  |  |  |  |  |  | 63 |  | 100.9
 | 2001-01-29 00:00:00 |  |  |  |  |  |  | 63 |  | 100.9
 | 2001-02-05 00:00:00 |  |  |  |  |  |  | 66.9 |  | 107
 | 2001-02-12 00:00:00 |  |  |  |  |  |  | 66.9 |  | 107
 | 2001-02-19 00:00:00 |  |  |  |  |  |  | 66.9 |  | 107
 | 2001-02-26 00:00:00 |  |  |  |  |  |  | 66.9 |  | 107
 | 2001-03-05 00:00:00 |  |  |  |  |  |  | 59.9 |  | 95.8
 | 2001-03-12 00:00:00 |  |  |  |  |  |  | 59.9 |  | 95.8
 | 2001-03-19 00:00:00 |  |  |  |  |  |  | 59.9 |  | 95.8
 | Analysis
Spreadsheet: 791766d1660578561-generate-unique-sequence-numbers-data-set-example
Sheet: Sheet1

Example
Data Set |  |  | Column to [NAME]
[NAME] | Vendor | Vendor # | Sequence #
1 | Group A | 111 | 111-1
2 | Group A | 111 | 111-2
3 | Group B | 222 | 222-1
4 | Group C | 333 | 333-1
5 | Group D | 444 | 444-1
6 | Group C | 333 | 333-2
7 | Group D | 444 | 444-2
8 | Group D | 444 | 444-3
9 | Group A | 111 | 111-3
10 | Group A | 111 | 111-4
11 | Group A | 111 | 111-5
12 | Group A | 111 | 111-6
13 | Group B | 222 | 222-2
14 | Group B | 222 | 222-3
15 | Group C | 333 | 333-3
16 | Group C | 333 | 333-4
17 | Group C | 333 | 333-5
18 | Group D | 444 | 444-4
19 | Group D | 444 | 444-5
20 | Group A | 111 | 111-7
Spreadsheet: 68399d1268931658-combo-line-and-scatter-chart-722256b
Sheet: Sheet1

# of Tickets | Tier 1 Capacity |  |  | Tier1
153 | 248 |  | 1
155 | 270
132 | 293
113 | 315
93 | 338
156 | 360
124 | 383
154 | 405
127
183
167
185
115
160
185
188
189
271
301
138
140
494