tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08114427-097b-497a-994a-486d2aa47c2d
Sheet: Generation

Installed Capacity Monthly Settlement Details Report
SD_MTHSTLICAP_<customer id>_<settlement_date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Asset Information |  |  |  |  | Monthly UCAP
Asset ID | Asset Name | Seasonal Claimed Capability | Equivalent Forced Outage Rate | Availability Factor Type | Monthly UCAP per Generation Asset | Ownership Share | Monthly UCAP per Generation Asset per Particiapnt
Number | String | MW | % | String | UCAP MW | % | UCAP MW
Spreadsheet: 828557d1683609458-summing-the-number-portion-of-cells-with-numbers-and-text-book1-test-aligw
Sheet: Sheet1

 | 4 | W | W | 4.
 |  |  | 1 | W | 1 | W | 2.
 |  | 64 | W | 2 | 2 | W | 68.
 |  | 1 | 2 | 4 | 6. | 1 | 1.
 | 1 | 2 | W | W | W | 3.
 |  |  |  |  | 2 | 1 | 3.
SUB
SUB "." | 0 | 0 | 0 | 4 | 6 | 3 | 74 | <[NAME] to calculate this row?
Spreadsheet: 677368d1589316305-problem-with-cummulative-ifs-2020-05-12-oeldere2-polez131059-677336d1589309570-problem-with-cummulative-ifs-urgent-help-2
Sheet: Simulator

 | Client Revenues Calculator
 | 1. SELECT CLIENT TYPE
 | Client location |  | Spain
 | 2. INPUT VOLUMES
 |  | Volume | Revenue
 | FINANCING
 | Car Value | 11000 | =
 |  |  |  |  |  | manualy %
 |  |  |  |  |  | 0.003
 |  |  |  |  |  | 0.002
 |  |  |  |  |  | 0.001
 | 500000
 | I'm basically writing a calculator for my car financing business where depending on the customer location (Spain, Portugal or Italy),
 | and the value of his car, he will pay X, Y or Z interest rate. between 5k-10k will pay 0.2% and above 10k will pay 0.1%. The thing is that those are cumulative, so if you deposit a car valued in 8k, the first 5k pay 0.3% and the rest 3k pays 0.2%.
 | So, first you select the customer location, and input the car value deposited. The assets below 5k will pay 0.3%,
Spreadsheet: jonathan_mckay__16834__Wire Request Form
Sheet: Payables Funding

 | Wire Transfer Request |  |  |  |  | DATE FUNDS TO BE WIRED (MMDDYY)
COMPANY NAME PAYING (PAYOR) |  |  |  |  | COMPANY NO. |  | BANK ACCOUNT
Requestor | NAME |  |  |  |  | PHONE NO.
 | DEPARTMENT
In payment of
 |  |  |  | INVOICE NUMBER |  |  | INVOICE DATE
 | COUNTRY | BANK KEY |  | BANK ACCOUNT NO. |  |  | BANK T(ROUTING ORDER)
 | PAYEE NAME |  |  |  | VENDOR CONTACT NAME |  | VENDOR EMAIL ADDRESS
Wire Funds To
 | PAYEE ADDRESS
 | CITY |  |  |  | STATE |  | COUNTRY
 | BANK NAME
 | BANK ADDRESS |  |  |  | FOR FURTHER CREDIT  (NAME AND ACCOUNT NUMBER)
 | CITY |  |  |  | STATE |  | COUNTRY
 | REFERENCE MESSAGE ON WIRE (20 CHARACTERS)
Accounting Code | Amount |  | Co Code | GL Account | Cost Center | Internal Order/Project Code/WBS Element
 |  |  | Description
 |  |  | Total amount of wire.  Documentation supporting amount MUST be attached to form.
APPROVAL |  |  | DATE | APPROVAL |  |  | DATE
APPROVAL |  |  | DATE | APPROVAL |  |  | DATE
A/P MANAGER APPROVAL |  |  | DATE
Spreadsheet: vkaminski__40916__COD Spread Opt
Sheet: Sheet1

Coal less Synfuel | MTM
-5 | -3168815.077057244
 | 791051.2522910943
 | 4749082.153479723
 | 8701797.493363472
 | 12640502.64231105
 | 16545528.29543505
 | 20376567.03327648
 | 24058833.9868586
 | 27467044.46748944
 | 30416168.38003124
 | 32699449.83001587
 | 34230259.11916812
 | 35132774.23101703
 | 35617490.25172418
 | 35857946.65642875
 | 35968118.84515383
 | 36014627.3234212
 | 36032669.12709378
 | 36039083.27448063
 | 36041167.38985442
 | 36041784.67389195
 | 36041950.92345808
 | 36041991.54455045
 | 36042000.52934533
 | 36042002.32447149
 | 36042002.64773824
 | 36042002.70008717
 | 36042002.70769128
 | 36042002.70867926
 | 36042002.7087937
 | 36042002.70880546
Spreadsheet: 875225d1721810478-resource-pool-to-dropdown-multi-reference-gkma-dropdown-list-question-aligw
Sheet: Hidden Lookup

 |  | blue | red | [NAME]
 |  | Random2 | Random3 | Random4
 | Random5 | Random6 | Random7 | Random8
 | Random9 | Random10 | Random11 | Random12
 | Random13 | Random14 | Random15 | Random16
 | Random17 | Random18 | Random19 | Random20
 | Random21 | Random22 | Random23 | Random24
 | Random25 | Random26 | Random27 | Random28
 | Random29 | Random30 | Random31 | Random32
 | Random33 | Random34 | Random35 | Random36
 | Random37 | Random38 | Random39 | Random40
 | Random41 | Random42 | Random43 | Random44
 | Random45 | Random46 | Random47 | Random48
 | Random49 | Random50
Spreadsheet: 05c472e6-807d-434a-a579-174de8cbc7a4
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC MVC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 239 | 3477 | 3451 | 3 | 3536 | 3576
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 382 | 4574 | 4550 | 51 | 4568 | 4497
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 66 | 64 | 1 | 59 | 49
Term Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8117 | 8065 |  | 8163 | 8122
Academic Year |  |  |  |  |  |  |  |  |  |  |  |  | 11797 |  |  | 11220 |  |  | 11166
% of Total | Credit Headcount % of Total
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3844 | 0.429 | 0.4276 | 0.0545 | 0.4325 | 0.4403
Female |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6124 | 0.5629 | 0.5644 | 0.9273 | 0.5603 | 0.5537
Undeclared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0032 | 0.0081 | 0.008 | 0.0182 | 0.0072 | 0.006
Success Rate | Success Rate
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13 |  |  | AY13-14
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13 | SU13 | [NAME] | SP14
Male | 0.82 | 0.62 | 0.64 | 0.81 | 0.64 | 0.65 | 0.8 | 0.66 | 0.67 | 0.82 | 0.69 | 0.69 | 1 | 0.7 | 0.68 | 0.78 | 0.7 | 0.7 | 1 | 0.7 | 0.68
Female | 0.83 | 0.68 | 0.71 | 0.84 | 0.7 | 0.7 | 0.86 | 0.73 | 0.71 | 0.83 | 0.75 | 0.74 | 1 | 0.76 | 0.73 | 0.82 | 0.74 | 0.74 | 0.94 | 0.74 | 0.72
Undeclared | 0.75 | 0.68 | 0.71 | 0.92 | 0.71 | 0.73 | 0.92 | 0.74 | 0.74 | 1 | 0.74 | 0.71 | 1 | 0.71 | 0.75 | 0.5 | 0.83 | 0.74 | 1 | 0.74 | 0.81
Term Average | 0.83 | 0.65 | 0.68 | 0.83 | 0.68 | 0.68 | 0.84 | 0.7 | 0.69 | 0.83 | 0.72 | 0.72 | 1 | 0.73 | 0.71 | 0.81 | 0.72 | 0.72 | 0.95 |  | 0.7
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 709098d1608152015-compare-an-array-in-one-file-against-contents-of-another-file-checkme
Sheet: Report 1

Test1 | 1946-09-20 00:00:00 | 12345 | METFORMIN HCL 500MG TABS | 70010-0063-10 | 2020-12-20 00:00:00
Test2 | 1931-01-16 00:00:00 | 12346 | PRAVASTATIN SODIUM 40MG TABS | 00093-7202-10 | 2020-12-20 00:00:00
Test3 | 1935-11-16 00:00:00 | 12347 | LISINOPRIL 40MG TABS | 68180-0517-03 | 2020-12-20 00:00:00 | DNC | Name4
Test4 | 1938-07-23 00:00:00 | 12348 | LOSARTAN POTASSIUM 50MG TABS | 65862-0202-99 | 2020-12-20 00:00:00
Test5 | 1940-10-28 00:00:00 | 12349 | LISINOPRIL 20MG TABS | 43547-0354-11 | 2020-12-20 00:00:00
Test6 | 1946-12-17 00:00:00 | 12345 | PRAVASTATIN SODIUM 20MG TABS | 00093-7201-10 | 2020-12-20 00:00:00 | DNC | Name1
Spreadsheet: eric_saibi__9884__102301R
Sheet: Curtis Stanton 01

Owner Name |  | Orlando Utilities Company
Station Name |  | Curtis Stanton Energy Center
Unit Name |  | Curtis Stanton 01
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Coal
Capacity |  | 465 MW
Start Date |  | 2001-10-19 00:00:00
End Date |  | 2001-11-17 00:00:00
Prv. Start Date |  | 2001-10-22 00:00:00
Prv. End Date |  | 2001-11-18 00:00:00
Comments |  | Boiler Work
SIC |  | 4911
Plant ID |  | 1000178
Unit ID |  | 1007517
Outage ID |  | 11030
Spreadsheet: 888351d1738839259-which-formula-would-be-best-to-use-formula-query-6-feb-v2
Sheet: Sheffield - results

Sheffield
Opening hours |  |  |  | Actions per day | ??? | yes, but only half
Monday | 420 | 2400 | 1
Tuesday | 420 | 2400 | 2
Wednesday | 420 | 2400 | 3
Thursday | 420 | 2400 | 4
Friday | 420 | 2400 | 5
Saturday | 420 | 2400 | 6
Sunday | 730 | 2400 | 7
 |  | Total
Screen accessed out of hours |  | NOT WORKING YET
Item accessed | Qty
arrivals & departures
Arrivals & departures button
Back button
flipped
home
Home button
journey planner
Journey planner button
Keyboard
languages
latest travel updates
Latest travel updates button
Menu button
onward travel
Onward travel button
page
Passenger assistance
Passenger assistance banner
Passenger assistance button
station information
Station information button
Unflipped
Total actions
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -27894
3531 | -274395 | -169301
60667 |  | -56295
60749 |  | -603224
61206
61334
62960
INDEX
2001-05-31 00:00:00 |  |  | 1177095.58
2001-06-19 00:00:00
Spreadsheet: ae4f65f6-4c3c-4e99-abad-a5ddf7ecd565
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das Tragen einer Burka und anderen [NAME] wird im öffentlichen [NAME] verboten.
 | Stadt/Land
Antwort
[NAME]
Neutral / Weiss nicht
[NAME]
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 0573e495-84c1-4d0e-b025-2cd05b9abca2
Sheet: Comments

Date | Comments
Spreadsheet: 876208d1722887666-how-to-hlookup-to-compare-and-insert-text-from-data-in-horz-row-to-vertical-row-horz_vvert_lookup
Sheet: HORZ

 | Cop | DPA | EI | NewFarm | Grand | [NAME] | Nesc | NP | RP | Smith | WB | WI | [NAME] | Bell | Mass Pk | GCP | GN | IP | N Bell | N Mass | NHP | SI | N Bruns
EC Nbr /Name | 15863 | 5144 | 15280 | 19108 | 7504 | 16476 | 3164 | 14822 | 15348 | 15238 | 14874 | 12168 | 15998 | 11116 | 11428 | 15110 | 15444 | 14252 | 16038 | 14664 | 14070 | 16791 | 17338
EC01 SATCO(Vendor commitment) | X |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
EC02 Rejuvenate (Vendor Commitment) | X |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
EC03 3M Air Filter(Vendor Commitment | X |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
EC04 Halloween | X |  | X | X |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
EC16 EZ Seed | X |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
EC14 First Alert | X |  | X | X |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
Spreadsheet: 4dac288b-2867-48a1-a38e-8bea4d3c6472
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Disease 1 | Disease 2 | # of Shared Genes | Disease 1 Genes | Disease 2 Genes | Hypergeometic Pvalue
 |  | ADENOCARCINOMA_OF_LUNG | MALIGNANT_MELANOMA | 9 | 220 | 20 | 0.00207459055606998
 |  | ADENOCARCINOMA_OF_LUNG | SQUAMOUS_CELL_CARCINOMA_OF_LUNG | 220 | 220 | 220 | 0
 |  | ADENOCARCINOMA_OF_LUNG | UROTHELIAL_CARCINOMA | 4 | 220 | 5 | 0.000284392110884938
 |  | BIPOLAR_DISORDER | SCHIZOPHRENIA | 98 | 145 | 345 | 1.60380569082433e-23
 |  | [NAME] | MALARIA | 23 | 120 | 63 | 2.86650909273012e-09
 |  | CYSTIC_FIBROSIS | IDIOPATHIC_PULMONARY_FIBROSIS | 3 | 37 | 7 | 3.32235282619041e-05
 |  | CYSTIC_FIBROSIS | MALIGNANT_PLEURAL_MESOTHELIOMA | 2 | 37 | 7 | 0.00106743842123473
 |  | DIABETIC_NEPHROPATHY | ENDOMETRIOSIS | 10 | 56 | 56 | 4.83506788399083e-05
 |  | DIABETIC_NEPHROPATHY | MALIGNANT_NEOPLASM_OF_PROSTATE | 18 | 56 | 173 | 0.000345873193701523
 |  | DIABETIC_NEPHROPATHY | MIXED_HYPERLIPIDEMIA | 2 | 56 | 4 | 0.000460341236826895
 |  | ENDOMETRIOSIS | MALIGNANT_NEOPLASM_OF_PROSTATE | 28 | 56 | 173 | 6.69893263734309e-11
 |  | ENDOMETRIOSIS | MALIGNANT_TUMOR_OF_COLON | 6 | 56 | 31 | 0.000557160027147861
 |  | ENDOMETRIOSIS | UTERINE_LEIOMYOMA | 5 | 56 | 10 | 2.1773521836961e-06
 |  | IDIOPATHIC_PULMONARY_FIBROSIS | IDIOPATHIC_THROMBOCYTOPENIC_PURPURA | 1 | 7 | 1 | 0
 |  | IDIOPATHIC_PULMONARY_FIBROSIS | OBESITY | 4 | 7 | 198 | 0.0025695602590083
 |  | MALIGNANT_MELANOMA | SQUAMOUS_CELL_CARCINOMA_OF_LUNG | 9 | 20 | 220 | 0.00207459055606999
 |  | MALIGNANT_PLEURAL_MESOTHELIOMA | SQUAMOUS_CELL_CARCINOMA_OF_LUNG | 6 | 7 | 220 | 1.05723084781361e-05
 |  | MALIGNANT_PLEURAL_MESOTHELIOMA | UROTHELIAL_CARCINOMA | 1 | 7 | 5 | 0.000333315725355201
 |  | SQUAMOUS_CELL_CARCINOMA_OF_LUNG | UROTHELIAL_CARCINOMA | 4 | 220 | 5 | 0.000284392110884938
Spreadsheet: 0e2be842-0a96-4e83-8a63-62fb0e1fc1e2
Sheet: Table 5.4

Monthly Statistical Bulletin
5.4 Home loan affordability
Quarter | 2009-10 | 2010-11 | 2011-12 | 2012-13 | 2013-14
Average size of new home loan (a) – $
September | 292795 | 326733 | 323572 | 320496 | 321427
December | 308764 | 329159 | 317039 | 325792 | 337116
March | 316134 | 323183 | 311421 | 321700 | 337276
June | 325553 | 328979 | 321127 | 321383 | 341748
Annual average | 309110.9720611516 | 327143.2771327381 | 318374.036728256 | 322368.654743657 | 334410.0742182164
Average monthly repayment on new home loans – $
September | 1746.653815210925 | 2205.178528061062 | 2258.474188097593 | 2176 | 1993
December | 1960.555475668386 | 2271.914192157253 | 2226.791504535607 | 2131 | 2092
March | 2019.69439471878 | 2239.838466872784 | 2196 | 2106 | 2092
June | 2174.679556442804 | 2290.488099812118 | 2155 | 2050 | 2119
Annual average | 1975.395810510224 | 2251.854821725804 | 2209.0664231583 | 2115.75 | 2586.5
Loan repayments as a proportion of family income – per cent
September | 29.5 | 35.5 | 34.4 | 33.3 | 29.8
December | 32.4 | 36 | 33.5 | 32.5 | 30.8
March | 33 | 35 | 32.7 | 29.9 | 30.6
June | 35.2 | 35.4 | 31.9 | 31 | 30.9
Annual average | 32.6 | 35.5 | 33.1 | 31.6 | 30.6
(a) Excludes alterations and additions and refinancing.
Sources: Real Estate Institute of Australia and Adelaide Bank | http://www.reiaustralia.com.au/ | http://www.reiaustralia.com.au/ | http://www.reiaustralia.com.au/
ABS, Housing Finance, Cat. no. 5609.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 9 September 2014 for lending
 |  |  |  |  |  |  |  | Early December 2014 for affordability
Spreadsheet: 865856d1712837544-calculate-the-sum-based-on-the-status-of-a-certain-cell-test-sheet-3
Sheet: Cost Report

 |  |  |  |  |  |  |  |  |  | Per Ton/Load: | [NAME]: |  |  | Budget Earned
Job #: |  |  |  | [NAME]: |  |  |  |  |  |  |  | Minimum | Yes | Asphalt Budget Earned:
Project: |  |  |  | SH Haul Rate: |  |  |  |  |  |  |  |  |  | SH Budget Earned:
Date: |  |  |  | BH Haul Rate: |  |  |  |  |  |  |  |  |  | BH Budget Earned:
 |  |  |  | [NAME]: |  |  |  |  |  |  | 0 |  |  | Local Budget Earned:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Budget:
 | Broker | Unit # | Rate | Start | Finish | Total Hours |  | AM Additional | Minimum | [NAME] | Tonnage | # SH RAP Loads (NOVA) | # BH RAP Loads (NOVA) | Total (Per Ton) | Total (Hourly)
1 | Parham | 123456 | 73 | 08:00:00 | 16:00:00 |  |  | 73 |  | 4 | 80
2 | NOVA | 456789 | 95 | 07:30:00 | 17:00:00 |  |  |  |  | 5 | 100
3 | SOVA | 789123 | 100.21 | 09:00:00 | 14:30:00 |  |  |  |  | 3 | 60
Milling
 | Broker | Total Hours | Rate |  |  |  |  |  |  |  |  |  |  |  | Total (Hourly)
 | Myers
 | SOVA
 | NOVA
 |  |  |  | Totals Paving Hours: |  |  |  |  |  |  |  |  |  | Total Paving:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Milling:
Spreadsheet: 791996d1660686720-offset-formula-to-calculate-rolling-average-returns
Sheet: returns

 |  |  | Output
Returns | TSLA | MSFT |  | TSLA | MSFT
2022-01-01 00:00:00 | -0.007322175732217606 | 0.004288350884811498 |  |  |  |  |  |  | 3
2022-01-02 00:00:00 | 0.009132420091324311 | 0.01302632290146466
2022-01-03 00:00:00 | -0.01079011486251302 | -0.008323551381922867
2022-01-04 00:00:00 | -0.02533427163969049 | -0.001990745722586951
2022-01-05 00:00:00 | 0.02021660649819501 | -0.004366812227074246
2022-01-06 00:00:00 | 0.003538570417551234 | -0.001841022308858631
2022-01-07 00:00:00 | 0.0165726375176305 | -0.001410437235543016
2022-01-08 00:00:00 | -0.004162330905306932 | 0.007877009995653994
2022-01-09 00:00:00 | 0.016370602577499 | 0.01735568371691909
2022-01-10 00:00:00 | 0.009252912954078152 | 0.01324503311258285
2022-01-11 00:00:00 | -0.01188455008488953 | -0.02290196078431372
2022-01-12 00:00:00 | 0.05773195876288661 | -0.02627495050034778
2022-01-13 00:00:00 | -0.02469135802469136 | -0.02495053857990781
Spreadsheet: 99849d1298398485-pivot-table-average-question-test
Sheet: Sales By List

 | Average Sale by List
 | Row Labels | Sum of Sales
 | esp2 | 69 | want this to say 34.5
 | Nov10 | 33
 | ESP1 | 32
 | sep10 | 21
 | oct10 | 19
 | [NAME] | 15
 | oct08 | 15
 | mar10hld | 14
 | [NAME] | 12
 | apr09 | 12
 | [NAME] | 11
 | [NAME] | 11
 | aug10 | 9
 | feb09 | 9
 | mar09 | 9
 | apr10 | 8
 | may10hld | 7
 | nov09 | 7
 | feb10 | 6
 | jun09 | 6
 | sep09 | 6
 | may10 | 6
 | [NAME] | 6
 | [NAME] | 5
 | apr09hld | 5
 | apr10hld | 5
 | dec09 | 5
 | jul09 | 4
 | [NAME] | 4
 | oct09hld | 4
 | jan10 | 3
 | nov09hld | 2
 | oct09 | 2
 | mar10 | 2
 | SF | 1
 | Grand Total | 385
Spreadsheet: 49248d1248496475-pivot-table-duplicate-columns-filtered-differently-delta-example
Sheet: Sheet1

make | year | value | 2008 | 2009 | delta |  |  | Data
make1 | 2008 | 101 | 101 | 0 | -101 |  | make | Sum of 2008 | Sum of 2009 | Sum of delta | calc item delta%
make2 | 2008 | 102 | 102 | 0 | -102 |  | make1 | 101 | 110 | 9 | 0.0891089108910891
make3 | 2008 | 103 | 103 | 0 | -103 |  | make2 | 102 | 111 | 9 | 0.08823529411764706
make4 | 2008 | 104 | 104 | 0 | -104 |  | make3 | 103 | 112 | 9 | 0.08737864077669903
make5 | 2008 | 105 | 105 | 0 | -105 |  | make4 | 104 | 113 | 9 | 0.08653846153846154
make6 | 2008 | 106 | 106 | 0 | -106 |  | make5 | 105 | 114 | 9 | 0.08571428571428572
make7 | 2008 | 107 | 107 | 0 | -107 |  | make6 | 106 | 115 | 9 | 0.08490566037735849
make8 | 2008 | 108 | 108 | 0 | -108 |  | make7 | 107 | 116 | 9 | 0.08411214953271028
make9 | 2008 | 109 | 109 | 0 | -109 |  | make8 | 108 | 117 | 9 | 0.08333333333333333
make1 | 2009 | 110 | 0 | 110 | 110 |  | make9 | 109 | 118 | 9 | 0.08256880733944955
make2 | 2009 | 111 | 0 | 111 | 111 |  | Grand Total | 945 | 1026 | 81 | 0.08571428571428572
make3 | 2009 | 112 | 0 | 112 | 112
make4 | 2009 | 113 | 0 | 113 | 113
make5 | 2009 | 114 | 0 | 114 | 114
make6 | 2009 | 115 | 0 | 115 | 115
make7 | 2009 | 116 | 0 | 116 | 116
make8 | 2009 | 117 | 0 | 117 | 117
make9 | 2009 | 118 | 0 | 118 | 118
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 44045 | 39043
2 | 48392 | 43656
3 | 60040 | 58397
4 | 52770 | 47992
5 | 46964 | 48492
6 | 54280 | 54491
7 | 50994 | 46207 | -1
8 | 50704 | 46207
9 | 49822 | 46207
10 | 51841 | 47207
11 | 44580 | 46492
12 | 61177 | 56491
13 | 48700 | 43898
14 | 34688 | 29491
15 | 33733 | 28660
16 | 34395 | 29491
17 | 37131 | 37990
18 | 39400 | 39492
19 | 38526 | 39492
20 | 39189 | 39083
21 | 28814 | 28606
22 | 30300 | 28882
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00
2001-07-22 00:00:00
Spreadsheet: 887840d1738168568-summing-lookups-on-multiple-sheets-book1
Sheet: Sheet1

ABC-one
ABC-two
ABC-three
ABC-four
ABC-five
ABC-six
ABC-seven
ABC-eight
ABC-nine
ABC-ten
Spreadsheet: 222615d1363890837-copying-down-into-blank-cells-tried-special-goto-and-blanks-not-working-trialfile
Sheet: Raw Data

0312 | [PHONE] | FF | GOOD | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
 |  |  |  | 270 | 365 | 32.7
1460 | [PHONE] |  | GOOD | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
 |  |  |  | 270 | 365 | 32.59
0312 | [PHONE] | GG | DAMG | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  | GOOD | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
1460 | [PHONE] |  | DAMG | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  | GOOD | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
 |  |  |  | 270 | 365 | 34.65
0312 | [PHONE] | EE | GOOD | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
1460 | [PHONE] | OO | GOOD | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  |  | 270 | 365 | 38.63
 |  |  | [NAME] | 270 | 365 | 38.63
0312 | [PHONE] | NN | GOOD | 270 | 365 | 30.16
 |  |  |  | 270 | 365 | 30.16
 |  |  |  | 270 | 365 | 30.16
Spreadsheet: 78710d1279039829-excel-2007-count-my-charges-based-on-time-charges
Sheet: Test

 |  |  |  |  |  | Transaction Fee |  |  | 0.1
 |  |  |  |  |  | 1st | 00:30:00 |  | 3
 |  |  |  |  |  | 2nd | 00:30:00 |  | 3
 |  |  |  |  |  | Subsequent | 01:00:00 |  | 3
SEPTEMBER 2009 |  |  |  |  |  | Per Entry | 17:00:00 | 09:00:00 | 3
 |  |  |  |  |  |  |  | Manual | [NAME]??
NO. |  | SYSTEM TICKET NO. | MANUAL TICKET NO. | DATE | TIME IN | TIME OUT | DURATION | Value
1 | 1 | 159971 | K 9515668 | 2009-01-09 00:00:00 | 06:32:00 | 08:04:00 | 01:32:00 | 3.1
2 | 2 | 159775 | K 9515672 |  | 07:34:00 | 12:42:00 | 05:08:00 | 18.1
3 | 3 | 159776 | K 9515673 |  | 07:58:00 | 11:03:00 | 03:05:00 | 15.1
4 | 4 | 159784 | K 9515681 |  | 08:49:00 | 10:00:00 | 01:11:00 | 9.1
5 | 5 | 159785 | K 9515682 |  | 09:00:00 | 10:23:00 | 01:23:00 | 9.1
6 | 6 | 159786 | K 9515683 |  | 09:01:00 | 10:36:00 | 01:35:00 | 9.1
7 | 7 | 159791 | K 9515688 |  | 09:18:00 | 11:00:00 | 01:42:00 | 9.1
8 | 8 | 159793 | K 9515690 |  | 09:20:00 | 11:04:00 | 01:44:00 | 9.1
9 | 9 | 159799 | K 9515696 |  | 09:31:00 | 11:29:00 | 01:58:00 | 9.1
10 | 10 | 159797 | K 9515694 |  | 09:25:00 | 10:26:00 | 01:01:00 | 6.1