tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mark_guzman__24561__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-10-31 00:00:00 |  | 101.13 | 11968 | 88.57 | 2800
 | 2000-10-30 00:00:00 |  | 101.67 | 8400 | 94.35 | 3400 | 95 | 50 | 92.5 | 0
 | 2000-10-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | 94.56 | 9600
 | 2000-10-28 00:00:00 |  | 99.51 | 9200 | 88.43 | 2800 | 81.67 | 75 | 87.5 | 0
 | 2000-10-27 00:00:00 |  | 99.55 | 9920 | 88.43 | 2800 | 90 | 5 | 80 | 48
 | 2000-10-26 00:00:00 |  | 105.3 | 10752 | 87.19 | 3200 | 106 | 0 | 88 | 0
 | 2000-10-25 00:00:00 |  | 105.29 | 11072 | 87.19 | 3200 | 106 | 0 | 88 | 0
 | 2000-10-24 00:00:00 |  | 105.3 | 10752 | 87.19 | 3200 | 100 | 10 | 88 | 0
 | 2000-10-23 00:00:00 |  | 108.99 | 9312 | 99.21 | 3400 | 109 | 0 | 99 | 0
 | 2000-10-22 00:00:00 |  |  |  |  |  |  |  | 102 | 0 |  | 99.25 | 9000
 | 2000-10-21 00:00:00 |  | 107.35 | 9952 | 89 | 2000 | 109 | 0 | 110 | 50
 | 2000-10-20 00:00:00 |  | 107.45 | 10352 | 88.56 | 2104 | 106.15 | 260 | 100 | 25
 | 2000-10-19 00:00:00 |  | 113.72 | 10976 | 89.9 | 2000 | 116.54 | 261 | 77.16 | 299
 | 2000-10-18 00:00:00 |  | 113.7 | 15264 | 89.59 | 2200 | 120 | 28 | 100 | 25
 | 2000-10-17 00:00:00 |  | 112.14 | 5600 | 91.5 | 1200 | 115 | 20 | 102.09 | 43
 | 2000-10-16 00:00:00 |  | 99.01 | 13360 | 91 | 1000 | 150 | 64 | 115 | 36
 | 2000-10-15 00:00:00 |  |  |  |  |  |  |  | 85 | 100 |  | 91 | 3000
 | 2000-10-14 00:00:00 |  | 86.77 | 4400 | 80.22 | 1800 | 86 | 0 | 80.5 | 0
 | 2000-10-13 00:00:00 |  | 86.77 | 4400 | 80.22 | 1800 | 100 | 25 | 80.5 | 0
 | 2000-10-12 00:00:00 |  | 102.41 | 12960 | 84.12 | 3416 | 95 | 206 | 90 | 50
 | 2000-10-11 00:00:00 |  | 108.75 | 12384 | 86.2 | 2000 | 107.5 | 0 | 85 | 0
 | 2000-10-10 00:00:00 |  | 109.33 | 8960 | 82 | 1400 | 100 | 475 | 83 | 0
 | 2000-10-09 00:00:00 |  | 138.06 | 11968 | 109.21 | 2400 | 108.26 | 800 | 79.17 | 120
 | 2000-10-08 00:00:00 |  |  |  |  |  |  |  | 65 | 225 |  | 109.21 | 7200
 | 2000-10-07 00:00:00 |  | 118.07 | 11760 | 86.86 | 2800 | 81.67 | 225 | 63.42 | 585
 | 2000-10-06 00:00:00 |  | 118.07 | 11760 | 86.71 | 3040 | 109.85 | 845 | 78.02 | 430
 | 2000-10-05 00:00:00 |  | 131.84 | 16400 | 93.38 | 2792 | 110.26 | 38 | 75.33 | 330
 | 2000-10-04 00:00:00 |  | 132.05 | 9760 | 86 | 1400 | 101.7 | 280 | 93.28 | 125
 | 2000-10-03 00:00:00 |  | 157.7 | 11120 | 95.5 | 2400 | 128.52 | 687 | 95 | 0
 | 2000-10-02 00:00:00 |  | 137.83 | 15200 | 111.15 | 2600 | 123.66 | 918 | 88.75 | 100
 | 2000-10-01 00:00:00 |  |  |  |  |  |  |  | 88 | 1400 |  | 112.08 | 7200
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 68415d1268942042-calculated-field-item-using-the-same-column-header-pivot-test
Sheet: Data

Type | Group | Resource | Cost Type | Qty | Cost
1 | 1000A | ABC | 1000A | 66 | 608
1 | 1000A | IGH | 1000A | 120 | 647
1 | 1000A | JHK | 1000A | 97 | 1175
4 | 1000A | ABC | 1000A | 71 | 593
4 | 1000A | IGH | 1000A | 88 | 731
4 | 1000A | JHK | 1000A | 110 | 450
1 | 1000A | ABC | 1000A | 87 | 670
1 | 1000A | IGH | 1000A | 70 | 862
1 | 1000A | JHK | 1000A | 43 | 376
4 | 1000A | ABC | 1000A | 64 | 1029
4 | 1000A | IGH | 1000A | 65 | 700
4 | 1000A | JHK | 1000A | 115 | 967
1 | 1000A | ABC | 1000A | 117 | 958
1 | 1000A | IGH | 1000A | 79 | 1082
1 | 1000A | JHK | 1000A | 74 | 836
1 | 1000A | ABC | 1000A | 132 | 407
4 | 1000A | IGH | 1000A | 35 | 1055
4 | 1000A | JHK | 1000A | 115 | 655
4 | 1000A | ABC | 1000A | 113 | 348
1 | 1000A | IGH | 1000A | 135 | 546
1 | 1000A | JHK | 1000A | 81 | 1136
4 | 1020B | ABC | 1020B | 43 | 1012
4 | 1020B | IGH | 1020B | 83 | 800
4 | 1020B | JHK | 1020B | 107 | 711
1 | 1020B | ABC | 1020B | 129 | 898
4 | 1020B | IGH | 1020B | 56 | 1009
1 | 1020B | JHK | 1020B | 66 | 271
4 | 1020B | ABC | 1020B | 45 | 335
4 | 1020B | IGH | 1020B | 127 | 533
4 | 1020B | JHK | 1020B | 43 | 1050
1 | 1020B | ABC | 1020B | 67 | 281
1 | 1020B | IGH | 1020B | 101 | 458
1 | 1020B | JHK | 1020B | 35 | 504
1 | 1020B | ABC | 1020B | 72 | 1029
1 | 1020B | IGH | 1020B | 116 | 260
4 | 1020B | JHK | 1020B | 84 | 1234
4 | 1020B | ABC | 1020B | 121 | 303
4 | 1020B | IGH | 1020B | 131 | 542
4 | 1020B | JHK | 1020B | 73 | 435
4 | 1020B | ABC | 1020B | 36 | 620
4 | 1020B | IGH | 1020B | 134 | 1069
4 | 1020B | JHK | 1020B | 39 | 1128
4 | 1020B | JHK | 1020B | 107 | 610
4 | 1020B | ABC | 1020B | 106 | 567
4 | 1020B | IGH | 1020B | 93 | 1094
4 | 1020B | JHK | 1020B | 129 | 573
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: Index

Report |  | V149
 |  |  |  | [NAME]
DAF
S898 ERE | EX51 UUY | DX03 MJY | DX54 LRE | MX57 CJV |  | Moffetts |  | MAN |  | SCANIA
T198 ABF | DX51 VFB | DX03 MKF | DX54 TYC | DX08 HRJ |  | [NAME] (Moff 1) |  | MX09 CDV |  | CU03 BXL
T199 ABF | MF51 LLR | DX04 [NAME] | DX55 BYT | DU09 EPC |  | DX56 NWV ([NAME]) |  | MX09 CJF |  | DX05 CTY
X112 AHY | BL02 UXS | FN04 FOH | DX55 CMK | DU60 LBF |  |  |  | MV60 WNX |  | MX05 BLJ
X662 GBF | DN02 FGD | [NAME] | DX07 JHA | DU60 KZT |  |  |  | PN60 FCD |  | MX57 MBV
X663 GBF | DU52 HBG | DX04 LRA | DX07 JJK |  |  |  |  | MJ60 RCX |  | MX57 MLJ
 |  |  |  |  |  |  |  | MJ61 TNF |  | MX57 MMV
 |  |  |  |  |  |  |  | PK61 YXR
Volkswagen |  | Trade Plates |  | Volvo |  | Iveco |  | Vauxhall |  | Kia
[NAME] |  | 444RF |  | BD52 ENT |  | DX53 LFK |  | FN06 HKO |  | LG10 YSO
N75 DFA |  |  |  | BD52 EOS |  | FJ05 EFG
S428 ADM |  |  |  | BU53 [NAME] |  | FJ05 EKV
[NAME] |  |  |  | BU53 KRE |  | MX55 TYK
 |  |  |  |  |  | BU06 LYK
Spreadsheet: 17d20662-1a41-4615-8eb9-89e60009a486
Sheet: Table 7.4

Monthly Statistical Bulletin
7.4 Health—bulk billing and private health insurance
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
General practice bulk billing rate – per cent (a)
September | 78.8 | 79.8 | 80.7 | 81.7 | 82.8
December | 79.6 | 79.8 | 80.9 | 82 | 83.1
March | 79.6 | 80.2 | 81.2 | 82.4 | 83.6
June | 80.2 | 80.9 | 82 | 82.8
Annual | 79.55 | 80.17500000000001 | 81.2 | 82.225
Private health insurance hospital coverage rate – per cent
September | 44.5 | 44.8 | 45.6 | 46.75992603040859 | 47.0308960463355
December | 44.5 | 44.9 | 45.7 | 46.73468258583196 | 46.96221450720056
March | 44.6 | 45.1 | 45.7 | 46.72255277675211 | 46.95370037950313
June | 44.7 | 45.3 | 46.62758980988292 | 46.90550536771482
(a) Out of hospital services only | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1 | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1 | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1 | http://www.health.gov.au/internet/main/publishing.nsf/Content/Medicare+Statistics-1
Sources: Department of Health and Ageing, Medicare statistics online | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm | http://www.phiac.gov.au/statistics/trends/index.htm
Private Health Insurance Administration Council, Membership statistics online
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | August 2014 for bulk billing data
 |  |  |  |  |  |  |  | August 2014 for health insurance data
Spreadsheet: bbdd3ea3-495d-466d-b7c0-8561e44a5a33
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35985260 | 2013-05-17 20:27:24 | AXIS | 1 | 6 | 4 | 1324997 | krissosa | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
35987507 | 2013-05-17 23:02:02 | AXIS | 1 | 4 | 3 | 757054 | Bulldoz44 | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
35987792 | 2013-05-17 23:15:25 | ALLIES | 0 | 1 | 4 | 757054 | Bulldoz44 | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
Spreadsheet: 820871d1678315536-replace-maiden-name-with-married-name-s666-pq-replace-maiden-name-with-married-name
Sheet: Result

Name | Married Name | Sales
[NAME] | [NAME] | 2000
[NAME] |  | 1500
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] | [NAME] | 1400
[NAME] |  | 1000
[NAME] | [NAME] | 999
[NAME] |  | 888
Spreadsheet: 584db522-bbf9-4916-ad4a-8a3e0656387d
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
CUS | Test | CUS | Copper, Serum | Copper, S | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 0.8 | mL | Collection Container/Tube: Plain, royal blue-top [NAME] plastic trace element blood collection tube, catalog #368380 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 0.8 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into Mayo metal-free, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium, iodine, and barium are known to interfere with most metals tests. If either gadolinium-, iodine-, or barium-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 0-2 months: 0.40-1.40 mcg/mL    3-6 months: 0.40-1.60 mcg/mL  7-9 months: 0.40-1.70 mcg/mL  10-12 months: 0.80-1.70 mcg/mL 13 months-10 years: 0.80-1.80 mcg/mL  > or =11 years: 0.75-1.45 mcg/mL | Monday through Friday; 8 a.m. - 6 p.m.; Saturday; 8 a.m. - 3 p.m./Continuously | 1 day | 3 days | 1 | 82525 |  |  |  |  | Rochester
CUS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CUS | Result | 8612 | Copper, S | Copper, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 5631-7 | Copper:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 116127d1311615512-vlookup-challenge-master-spread-example
Sheet: LOB Summary

 |  | Revenue | FL Third Party Liability | XREV - Total Revenues | VLOOKUP to match D and E
 |  | Direct Expenses |  | XDEXP - Direct Expenses
 |  | Gross Margin |  | XGM - Gross Margin
 |  | Selling, Admin, & General |  | XSAG - Selling, [NAME] and [NAME]
 |  | Operating Income |  | XOPINC - Operating Income
 |  | Profit Before Tax |  | XPBT - Profit Before Tax and Eq Inc
 |  | Gross Margin %
 |  | Operating Income %
 |  | FTE |  | Full-time Equivalent | 0
Spreadsheet: 0cf347a2-b833-4c87-a5f3-4948893d1ab9
Sheet: Sheet1

Protein | Source (Institution/catalog number) | ChIP | Immunoblot
ACTB | Sigma ([NAME]) | - | X
MED18 | Joan & Ron Conaway (Stowers Institute) | - | X
MED28 | Vijaya Ramesh (Harvard Medical School) | - | X
NES | BD Biosciences (611658) | - | X
OCT4 | Santa Cruz (sc9081) | - | X
POL2 | (8WG16) Covance MMS-126R | X | X
RAB2A | Santa Cruz (sc28567) | - | X
TAF1 | Santa Cruz (sc735) | X | -
 | Aviva Systems Biology (ARP32473_P050) | - | X
TAF2 | [NAME] (Rockefeller University) | X | X
 | [NAME] (H00006873-A01) | - | X
TAF3 | [NAME] (IGBMC, France) | X | X
 | Bethyl (A302-359A) | X | -
 | Aviva Systems Biology (ARP51249_P050) | - | X
TAF4 | Santa Cruz (sc736) | - | X
 | Santa Cruz (sc136093) | - | X
TAF5 | [NAME] (Rockefeller University) | - | X
 | Sigma-Aldrich (HPA006474) | X | X
TAF6 | [NAME] (Rockefeller University) | X | X
TAF7 | Santa Cruz (sc101167) | X | -
 | [NAME] (Rockefeller University) | X | X
[NAME] | [NAME] (Rockefeller University) | X | X
[NAME] | [NAME] (Rockefeller University) | X | X
TAF10 | Abcam (ab51466) | - | X
TAF11 | Santa Cruz (sc130406) | X | X
 | [NAME] (Rockefeller University) | X | X
TAF12 | [NAME] (Rockefeller University) | - | X
TAF13 | Santa Cruz (sc81392) | - | X
TBP | Santa Cruz (sc204) |  | X
 | Santa Cruz (sc273) | X | -
TFIIA | Santa Cruz (sc81398) | - | X
TFIIB | Santa Cruz (sc274) | - | X
TFIIE | Santa Cruz (sc238) | - | X
TFIIF | Santa Cruz (sc136408) | - | X
TFIIH | Santa Cruz (sc271500) | - | X
TUBA | Sigma (T5168) | - | X
Spreadsheet: 37915d1236018611-pulling-back-closest-value-when-condition-is-same-trans
Sheet: Sheet1

Trans | Items | Retail | Rebate | Item w/ rebate
1 | 1234 | 8.97
1 | 1112 | 10.5
1 | 0 | 0 | 8.99 | 1234
2 | 4321 | 7.42
2 | 12 | 7
2 | 45 | 12
2 | 789 | 18.99
2 | 0 | 0 | 7.99 | 4321
3 | 123 | 8.99
3 | 9 | 2.99
3 | 76 | 4.01
3 | 0 | 0 | 3.99 | 76
Spreadsheet: mark_whitt__25244__Huber - Existing & Proposed Deals 111201
Sheet: Volumes

 | IF NGPL MidContinent index (@ Forgan) | IF NGPL MidContinent index (@ [NAME]) | IF NGPL MidContinent Index minus $0.01 | IF CIG Rocky Mtns. index minus $0.03 (Proposed) | Gas Daily PG&E Topock index minus $0.02 (Proposed) | Gas [NAME] San Juan index minus $0.10 (Proposed) | Gas Daily NWPL Wyoming Pool index minus $0.10 (Proposed)
2001-12-01 00:00:00 | 5000 | 5000 |  | 45000 | 20000 | 10000 | 10000
 | 5000 | 5000 |  | 45000 | 20000 | 10000 | 10000
 | 5000 | 5000 |  | 45000 | 20000 | 10000 | 10000
 | 5000 | 5000 |  | 45000 | 20000 | 10000 | 10000
 | 5000 | 5000 |  | 45000 | 20000 | 10000 | 10000
 | 5000 | 5000 |  | 45000 | 20000 | 10000 | 10000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000 |  | 20000
 | 5000 | 5000 | 42000
 | 5000 | 5000 | 42000
 | 5000 | 5000 | 42000
 | 5000 | 5000 | 42000
 |  |  | 42000
 |  |  | 42000
 |  |  | 42000
Spreadsheet: 123680d1317805208-designing-the-best-structure-for-data-sheet-kennybonesexample
Sheet: Summary

 | Work clothes 2011
Navn :
Art.nr | Item | Price | Summer | Winter | Sum summer | Sum winter
2175-3399 |  | 49 | 1 | 2
2175-3400 |  | 39 | 1 | 1
2175-3401 |  | 59 | 1 | 3
2175-3402 |  | 15 | 2 | 1
2175-3403 |  | 25 | 2 | 1
2175-3404 |  | 45 | 1 | 1
Sum
Spreadsheet: 37579d1235621672-excel-macro-group-by-and-sum-sumby2criteria
Sheet: Sheet2

ID | Date | Price |  | This sheet will keep itself updated in realtime.
1456 | 2008-03-01 00:00:00 | 2406.89 |  | no macro is needed.
1457 | 2008-03-01 00:00:00 | 61
1458 | 2008-03-01 00:00:00 | 8788.7
1459 | 2008-03-01 00:00:00 | 15506.1
14510 | 2008-04-01 00:00:00 | 9766.1
14511 | 2008-04-01 00:00:00 | 8032.26
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 702441d1604348707-xirr-result-with-non-reinvested-dividends-xirr-div-wd
Sheet: Sheet1

 |  |  | Unrealized Gain | Ending Balance
2018-12-13 00:00:00 | 250000
2019-01-14 00:00:00 | -5625
2019-04-10 00:00:00 | -5625
2019-07-10 00:00:00 | -5625
2019-10-10 00:00:00 | -5625
2019-12-31 00:00:00 | -250000
 |  |  |  |  | relatively close to zero
 |  | XIRR
Spreadsheet: 0bd79ef2-a562-4539-9dc0-28bd3d46e277
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 36. LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), Original (Number, $000)
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
1 . . . [NAME] ; |  |  | Original | A2413895X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413896A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413897C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413898F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413899J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413900F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413901J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413902K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413903L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413904R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413905T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413906V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413907W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413908X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413909A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413910K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 537747d1505239237-how-to-assign-an-array-name-to-a-number-value-to-use-in-hlookup-oeldere-537742d1505238420-how-to-assign-
Sheet: Returned Value

Need value for starting age 7, attn'd age 3 from table 89MS
Start Age: | 7 | input
Req'd Table | 89MS | input
 |  |  |  |  |  |  |  |  |  |  |  | Attn'd Age | Value
3 |  | result |  |  |  |  |  |  |  |  |  | 3
4 |  | result |  |  |  |  |  |  |  |  |  | 4
5 |  | result |  |  |  |  |  |  |  |  |  | 5
6 |  | result |  |  |  |  |  |  |  |  |  | 6
7 |  | result |  |  |  |  |  |  |  |  |  | 7
8 |  | result |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 166175d1341494073-trying-to-get-a-vlookup-median-that-ignores-zeros-some-vlookup
Sheet: Sheet1

1 | a |  |  | median a1:a10 | 0 |  | vlookup median a1:a10 | d
2 | b |  |  | median if not 0 | 2 |  | vlookup median if not 0 exact match | b
3 | c
0 | d
0 | e
0 | f
0 | g
0 | h
0 | i
0 | j
1 | a |  |  | median a17:a26 | 0 |  | vlookup median a17:a26 | j
2 | b |  |  | median if not 0 | 2.5 |  | vlookup median if not 0 exact match | #N/A |  | because 2.5 isnt in the range
3 | c
4 | d |  |  |  |  |  | however
0 | e |  |  |  |  |  | {=VLOOKUP(MEDIAN(IF(A17:A26<>0,A17:A26)),A17:B26,2,true)}
0 | f |  |  |  |  |  | will not work either as data in column a has to be sorted ascending
0 | g |  |  |  |  |  | for vlookup to find the largest value<= to 2.5
0 | h
0 | i
0 | j
Spreadsheet: 150284d1334383094-multiple-count-and-sum-values-multiple-count-and-sum-question
Sheet: Data

Date | Type | Price
2012-04-01 00:00:00 | apple | 2.5
2012-04-01 00:00:00 | orange | 6.8
2012-04-01 00:00:00 | orange | 3.5
2012-04-02 00:00:00 | apple | 5.7
2012-04-02 00:00:00 | apple | 7.8
2012-04-02 00:00:00 | apple | 7.8
2012-04-03 00:00:00 | orange | 3.5
2012-04-03 00:00:00 | apple | 5.7
2012-04-03 00:00:00 | apple | 7.8
Spreadsheet: chris_germany__2916__1999_2000 Winter Oil Orders
Sheet: FALL 1999 ENDING

Gordonsville Energy LP   (L.S. #2 FUEL OIL ORDERS)
Sept thru Dec 1999 |  |  |  |  | Updated 1/03/2000
DATE | BP AMOCO                       ORDERS | Order number | [NAME]ORDERS | Order number | MARATHON/ [NAME]ORDERS | Order number
1999-09-25 00:00:00 |  |  |  | CIT-001 |  |  | This is reference only, not included in the December tracking below.
1999-12-15 00:00:00 |  |  |  | CIT-002
 |  |  |  |  | 150000 | MAP-001
TOTAL ORDERED
DRIVE TO MAINTAIN 4.5 MILLION GALLON INVENTORY
1999-12-14 00:00:00 | LAST "STRAPPED" vs [NAME] LEVEL                                (as reference only… available monthly) |  | 4,360,000 Strapped            4,365,000 Indicator
1999-12-29 00:00:00 | TANK LEVEL READING @ 10:AM                  as reported by Plant control room |  | 4713000
 | TOTAL ORDERED THRU (during) DECEMBER
 | Possible Over Delivery
FALL '99 TOTAL | DELIVERED IN DEC.'99                                       per Plant off-load meters |  | -322823 | (Deliveries should be shown as negatives to properly calculate the projected level)
 | DELIVERED YESTERDAY, THRU 12:MID                              per Plant Control Room |  | -22500
 | DELIVERED 12:AM - 10:AM                                 as reported by Plant Control Room |  | 0
PROJECTED TANK LEVEL (at completion)
NOTE: