tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__938__historical outages
Sheet: PJM

PJM Outage Data
1997-01-01 00:00:00 | 1997-02-01 00:00:00 | 1997-03-01 00:00:00 | 1997-04-01 00:00:00 | 1997-05-01 00:00:00 | 1997-06-01 00:00:00 | 1997-07-01 00:00:00 | 1997-08-01 00:00:00 | 1997-09-01 00:00:00 | 1997-10-01 00:00:00 | 1997-11-01 00:00:00 | 1997-12-01 00:00:00
1363 | 1474.714285714286 | 3507.266666666667 | 6134.4 | 3278.0625 | 1574.2 | 1333.666666666667 | 1376.25 | 5066.466666666666 | 6759.733333333334 | 5245.266666666666 | 1959.8125
1998-01-01 00:00:00 | 1998-02-01 00:00:00 | 1998-03-01 00:00:00 | 1998-04-01 00:00:00 | 1998-05-01 00:00:00 | 1998-06-01 00:00:00 | 1998-07-01 00:00:00 | 1998-08-01 00:00:00 | 1998-09-01 00:00:00 | 1998-10-01 00:00:00 | 1998-11-01 00:00:00 | 1998-12-01 00:00:00
1423 | 2337.857142857143 | 3006 | 5723.6 | 4430.3125 | 1510.4 | 934.6666666666666 | 799.125 | 2033.133333333333 | 7102.333333333333 | 5253.733333333334 | 2737.5
1999-01-01 00:00:00 | 1999-02-01 00:00:00 | 1999-03-01 00:00:00 | 1999-04-01 00:00:00 | 1999-05-01 00:00:00 | 1999-06-01 00:00:00 | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00
902.75 | 2499.5 | 6558.933333333333 | 9139.333333333334 | 9066.5625 | 2457.6 | 1251.8 | 649.875 | 3447.666666666667 | 6647.733333333334 | 2979.866666666667 | 1436.625
2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
2173.9375 | 1916.5 | 6590.2 | 9776.933333333332 | 5973.3125 | 2247.666666666667 | 745.2666666666667 | 1603.6875 | 2929.266666666667 | 6732.266666666666 | 4885.666666666667 | 1460.3125
2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
481.375 | 1888.071428571429 | 7339.6 | 11583.86666666667 | 6530.8125 | 577 | 406 | 868.3125 | 1381.8 | 4913.133333333333 | 3119.333333333333 | 310.4375
2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00
58.5 | 1577.571428571429 | 6314 | 7033.266666666666 | 1015.6875 | 235 | 36 | 3.75 | 2292.666666666667 | 3007.6 | 332.5333333333334 | 10.9375
**source IIR
* 2002 data is incomplete as it is too far to have accurate forecasts of fossil outages
* 1997 and 1998 data is not as reliable as 1999 and beyond, in regards to historical outages.
* historical outages include "planned" and unplanned".  Forecasts include only "planned".
Spreadsheet: 01d8bb0f-4c19-41fd-ad03-ec9799e1d47b
Sheet: Sheet1

 | RSF |  | Number
2012 |  |  |  |  |  | 2012
2011 |  |  |  |  |  | 2011
2010 |  |  |  |  |  | 2010
2009 |  |  |  |  |  | 2009
2008 |  |  |  |  |  | 2008
2007 |  |  |  |  |  | 2007
2006 |  |  |  |  |  | 2006
2005 |  |  |  |  |  | 2005
2004 |  |  |  |  |  | 2004
2003 |  |  |  |  |  | 2003
2002 |  |  |  |  |  | 2002
2001 |  |  |  |  |  | 2001
average
Spreadsheet: 807257d1669821372-find-last-value-when-needed-book25
Sheet: Sheet1

P/L | CAPITAL |  |  | I need to find a formula in Column B which remembers the LAST Capital in order to add the P/L
 | 2000 |  |  | When the P/L is empty the capital must remain empty!
-79.87 |  |  | It is adding the last known capital, in this case 2000 with the P/L next to it. In this case (2000+(-79.87)
 |  |  | From the moment that the P/L cell is empty, the capital must remain empty
-4.25 |  |  | It is adding the last known capital, in this case 1920.13 with the P/L next to it. In this case (1920.13+(-4.25)
3.36 |  |  | It is adding the last known capital, in this case 1915.88 with the P/L next to it. In this case (1915.88+(3.36)
 |  |  | From the moment that the P/L cell is empty, the capital must remain empty
15.2 |  |  | It is adding the last known capital, in this case 1919.24 with the P/L next to it. In this case (1919.24+(15.2)
 |  |  | From the moment that the P/L cell is empty, the capital must remain empty
 |  |  | From the moment that the P/L cell is empty, the capital must remain empty
 |  |  | From the moment that the P/L cell is empty, the capital must remain empty
Spreadsheet: 29db2ec6-ee1b-4827-b814-b017dbfd3f80
Sheet: Table 6.1

Monthly Statistical Bulletin
6.1 International trade in goods and services
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Exports of goods and services (a) – $ million
July | 19310 | 25069 | 26119 | 25395 | 26406
August | 18835 | 24153 | 27873 | 24486 | 27604
September | 19881 | 24048 | 27070 | 24071 | 27200
October | 19456 | 24428 | 27155 | 24497 | 27309
November | 19129 | 24401 | 27143 | 24668 | 27391
December | 19848 | 24351 | 27025 | 24694 | 28386
January | 20653 | 23804 | 24658 | 24657 | 29369
February | 20754 | 23434 | 24363 | 25206 | 29443
March | 20925 | 25588 | 24702 | 25631 | 28603
April | 23294 | 25613 | 25833 | 25549 | 27981
May | 24502 | 26241 | 26354 | 26526 | 26681
June | 25878 | 25868 | 26195 | 26366
Annual | 252154 | 297321 | 315638 | 301727
Imports of goods and services (a) – $ million
July | 20933 | 23701 | 25480 | 27312 | 27938
August | 20474 | 22985 | 25812 | 26602 | 28318
September | 21918 | 22799 | 26062 | 26518 | 27876
October | 21461 | 23076 | 26342 | 26932 | 27759
November | 21148 | 22964 | 26591 | 27888 | 27556
December | 21946 | 23201 | 26324 | 26447 | 28225
January | 21822 | 22987 | 27298 | 26567 | 28590
February | 22207 | 23982 | 25694 | 26553 | 27847
March | 22857 | 24116 | 27072 | 26371 | 27864
April | 22972 | 24204 | 27066 | 26765 | 28761
May | 23453 | 24626 | 27528 | 27392 | 28592
June | 23826 | 24813 | 27252 | 26912
Annual | 264754 | 283348 | 318710 | 321758
(a) Balance of payments definition. Monthly figures are seasonally adjusted.
Source: ABS, International trade in goods and services, Cat. no. 5368.0 |  |  |  |  |  |  |  | Update
http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5368.0&viewtitle=International%20Trade%20in%20Goods%20and%20Services,%20Australia~Jan%202008~Latest~6/03/2008&&tabname=Past%20Future%20Issues&prodno=5368.0&issue=Jan%202008&num=&view=& |  |  |  | 2014-08-05 00:00:00
Spreadsheet: 74152d1274734239-if-a-the-sum-of-b-c-d-e-yes-if-not-no-mock-sheet-excel-1
Sheet: Sheet1

ORDER | DEPARTMENTS |  |  |  | CHECK
VALUE
200 |  |  | 200 |  | y
900 |  |  |  | 900 | y
300 |  | 200 | 100 |  | y
1000 | 500 |  |  | 500 | y
300 |  | 100 | 100 |  | n
{IF A is equal to the SUM  OF  B,C,D,E then say Yes. If not then No.}
Spreadsheet: 845486d1696990758-capacity-planning-spreadsheet-capacity-planning-spreadsheet
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Partners added | 5 | 7 | 0 | 4 | 5 | 9
PMs needed
Spreadsheet: 118683d1313885927-sumif-and-match-to-add-up-quantities-sample-sumif-and-match
Sheet: Sheet1

Material | Delivery quantity
2008537 | 10
2008622 | 8
2008639 | 4
2008641 | 2
2008838 | 28
2008844 | 36
2008879 | 4
2008974 | 98
2009038 | 2
2009041 | 2
2009177 | 2
2009181 | 2
2009319 | 2
2010755 | 4
2010880 | 1
2010892 | 8
2010896 | 8
2011174 | 1
2012232 | 5
2012991 | 1
2012991 | 1
2013529 | 2
2013531 | 4
2013539 | 4
2014600 | 48
2014807 | 0
2014807 | 3
2014810 | 2
2014828 | 1
2014875 | 1
2014912 | 1
2015301 | 1
2015302 | 1
2015302 | 2
2015305 | 1
2015305 | 4
2015342 | 2
2015349 | 1
2015372 | 1
2015372 | 4
2015834 | 8
2015834 | 8
2015834 | 8
2015834 | 6
2015991 | 98
2015991 | 65
2015991 | 33
2016010 | 486
2016478 | 100
2016478 | 35
2016478 | 48
2016478 | 24
2016478 | 8
2016478 | 8
2016478 | 8
2016478 | 30
2016478 | 24
2016478 | 40
2016478 | 25
2016478 | 2
2016478 | 24
2016478 | 20
2016478 | 25
2016478 | 8
2016478 | 28
2016478 | 300
2016478 | 28
2016479 | 30
2016479 | 24
2016479 | 24
2016479 | 55
2016479 | 55
2016479 | 45
2016490 | 5
2016490 | 4
2016490 | 24
2016490 | 12
2016490 | 4
2016490 | 4
2016490 | 4
2016490 | 4
2016490 | 24
2016490 | 9
2016490 | 10
2016490 | 6
2016490 | 2
2016490 | 2
Spreadsheet: 465567d1465762110-i-need-help-in-time-sheet-please-timesheet
Sheet: Sheet4

 |  | Start Time |  | End Time |  | Regular Hours
 |  | 08:00:00 |  | 16:00:00 |  | 8
 |  | the employee can get no more  than 9 hrs late a month
 | 2016-05-01 00:00:00
 | Name / Date |  |  |  |  |  |  | Total Late | HRS More than 9
 |  |  | 1 | 2 | 3 | 4 | 5
 | [NAME] | In | 10:00:00 | 08:00:00 | 11:00:00 | 08:00:00 | 10:00:00
 |  | Out | 16:00:00 | 16:00:00 | 16:00:00 | 15:00:00 | 13:00:00
 |  | Late
Spreadsheet: 877527d1724336734-summarize-static-data-simulation-johan58-
Sheet: Sheet1

DATA |  |  |  | TOP 3 PIVOT |  |  | EXPECTED RESULT TOP 3 PIVOT
Name | Value |  |  | Row Labels | Sum of Value |  | Row Labels | Sum of Value
a | 4 |  |  | f | 10 |  | f | 10
b | 1 |  |  | g | 7 |  | g | 7
c | 3 |  |  | j | 4 |  | j | 4
d | 4 |  |  | h | 4
e | 1 |  |  | a | 4
f | 10 |  |  | d | 4
g | 7 |  |  | Grand Total | 33
h | 4
i | 2
j | 4
Spreadsheet: kimberly_watson__20634__tw_priority_rate
Sheet: Eff Jan 1, 2000 - Oct 31, 2000

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
11/1999-10/2000
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | Total | GRI Demand | Total |  | Commodity | ACA | GRI
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharges | Surcharge | Rate |  | Rate | Surcharge | Surcharge
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3168 |  | 0.0051 | 0.0007 |  | 0.0066 |  |  | 0.0233 | 0.0022 | 0.0072
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
26677 | El Paso Energy Marketing Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - |  | - |  |  | 0.0011 | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0369 | 0.0052 | 0.0007 |  | 0.0066 |  |  | 0.0159 | 0.0022 | 0.0072
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0369 | 0.0052 | 0.0007 |  | 0.004 |  |  | 0.0159 | 0.0022 | 0.0072
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.005 | 0.0007 |  | 0.0066 |  |  | 0.0159 | 0.0022 | 0.0072
26678 | El Paso Energy Marketing Company | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.0051 | 0.0007 |  | 0.0066 |  |  | 0.0159 | 0.0022 | 0.0072
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.0051 | 0.0007 |  | 0.0066 |  |  | 0.0159 | 0.0022 | 0.0072
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.0053 | 0.0007 |  | - |  |  | 0.0159 | 0.0022 | -
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1647 | 0.0369 | 0.0023 | 0.0003 |  | 0.004 |  |  | 0.0159 | 0.0022 | 0.0072
NOTE --- | Per CBS Rate System, the termination date for the rates listed above are as follows:
 | Reservation | Recalculation eff every Nov 1st
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 2 | 2006-10-31 00:00:00
 | GRI Demand | Recalculation eff every Jan 1st **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: 788062d1658245029-mechanical-sizing-spreadsheet-sizing-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Reference Data
 | [NAME] |  | Length |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] | Length Min | [NAME] |  | Size
 | 1.5 |  | 48 |  |  |  |  |  | 1.5 | 0 | 50 |  | 0.625
 |  |  |  |  |  |  |  |  | 1.5 | 51 | 125 |  | 0.75
 |  |  |  |  |  |  |  |  | 2 | 0 | 50 |  | 0.625
 |  |  |  |  |  |  |  |  | 2 | 51 | 80 |  | 0.75
 |  |  |  |  |  |  |  |  | 2 | 81 | 150 |  | 0.875
 |  |  |  |  |  |  |  |  | 2.5 | 0 | 80 |  | 0.75
 |  |  |  |  |  |  |  |  | 2.5 | 81 | 125 |  | 0.875
 |  |  |  |  |  |  |  |  | 3 | 0 | 80 |  | 0.75
 |  |  |  |  |  |  |  |  | 3 | 81 | 100 |  | 0.875
 |  |  |  |  |  |  |  |  | 3.5 | 0 | 50 |  | 0.75
 |  |  |  |  |  |  |  |  | 3.5 | 51 | 80 |  | 0.875
 |  |  |  |  |  |  |  |  | 3.5 | 81 | 250 |  | 1.125
 |  |  |  |  |  |  |  |  | 4 | 0 | 50 |  | 0.75
 |  |  |  |  |  |  |  |  | 4 | 51 | 80 |  | 0.875
 |  |  |  |  |  |  |  |  | 4 | 81 | 200 |  | 1.125
 |  |  |  |  |  |  |  |  | 5 | 0 | 50 |  | 0.875
 |  |  |  |  |  |  |  |  | 5 | 51 | 100 |  | 1.125
 | Sample
 | If "[NAME]" = 1.5, and "Length" is in range 0 - 50, then size is 5/8
 | If "[NAME]" = 1.5, and "Length" is in range 51 - 125, then size is 3/4
 | Note: Must work for all listed [NAME] and [NAME]
Spreadsheet: da2c9947-2e1f-42df-a4ed-6a9533257f04
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
PCT | Test | PCT | Procalcitonin, Serum | Procalcitonin, S | Homogeneous Time-Resolved Fluorescence | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube: Red top [NAME]: 0.50 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.25 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild reject; Gross reject Other	Serum gel tube | Children >72 hours-adults: < or =0.15 ng/mL | Monday through Saturday; 2:30 p.m. | Same day/1 day | 3 days | 1 | 84145 |  |  |  |  | Rochester
PCT | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
PCT | Result | PCT | Procalcitonin, S | Procalcitonin, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 33959-8
Spreadsheet: 835782d1688811119-textsplit-unknown-dimension-textsplit-unknow-dimension
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT (SPILLING ARRAY)
a,b |  | c,d | a,c,b |  |  |  | c,d | a,c,b |  |  | a |  | c | a
 |  |  |  |  |  |  |  |  |  |  | b |  | d | c
 |  |  |  |  |  |  |  |  |  |  |  |  |  | b
 |  |  |  |  |  |  |  |  |  |  | Column1 | Column2 | Column2.1 | Column3
 |  |  |  |  |  |  |  |  |  |  | a |  | c | a
 |  |  |  |  |  |  |  |  |  |  | b |  | d | c
 |  |  |  |  |  |  |  |  |  |  |  |  |  | b
Spreadsheet: 878074d1725025609-pull-names-from-several-sheets-into-total-sheet-only-if-criteria-is-met-drewber-providernames-updated-365-aligw
Sheet: TOTAL

 |  |  | AliGW | Count
 |  |  |  | 3
 |  |  | BAMBAM, F | 2
 |  |  | CLOONEY, G | 2
 |  |  | DE VITO, D | 1
 |  |  | FRED, B | 2
 |  |  | HANKS, T | 1
 |  |  | KYLE, S | 1
 |  |  | STARK, T | 2
 |  |  | WAYNE, B | 1
Spreadsheet: 166002d1341425126-lookup-value-across-columns-and-return-value-2-columns-further-excel-test-clean-up
Sheet: Clean-up

 | Visit
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Participant
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
Spreadsheet: 130218d1322132096-data-sorting-rearranging-excel-help
Sheet: Sheet1

 | Original Data Format
 | POINTS | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | X | 5.62829 | 5.62746 | 5.62746 | 5.62751 | 5.62756 | 5.62767 | 5.62786
 | Y | -0.17363 | -0.17576 | -0.17574 | -0.17538 | -0.17509 | -0.17484 | -0.17458
 | Preferred Data Format
 |  | 2 |  | 3 |  | 4 |  | 5
 |  | 5.62829 | -0.17363 | 5.62746 | -0.17576 | 5.62746 | -0.17574 | 5.62751 | -0.17538
Spreadsheet: 43862d1242499811-select-last-of-series-greater-than-0-series-select
Sheet: Sheet1

1999-02-18 00:00:00 | 2260.55
1999-02-19 00:00:00 | 0
1999-02-22 00:00:00 | 0
1999-02-23 00:00:00 | 0
1999-02-24 00:00:00 | 0
1999-02-25 00:00:00 | 0
1999-02-26 00:00:00 | 0
1999-03-01 00:00:00 | 0
1999-03-02 00:00:00 | 0
1999-03-03 00:00:00 | 0
1999-03-04 00:00:00 | 0
1999-03-05 00:00:00 | 2337.11
1999-03-08 00:00:00 | 0
1999-03-09 00:00:00 | 0
1999-03-10 00:00:00 | 0
1999-03-11 00:00:00 | 0
1999-03-12 00:00:00 | 0
1999-03-15 00:00:00 | 0
1999-03-16 00:00:00 | 0
1999-03-17 00:00:00 | 0
1999-03-18 00:00:00 | 0
1999-03-19 00:00:00 | 0
1999-03-22 00:00:00 | 0
1999-03-23 00:00:00 | 0
1999-03-24 00:00:00 | 0
1999-03-25 00:00:00 | 2434.8
1999-03-26 00:00:00 | 0
1999-03-29 00:00:00 | 0
1999-03-30 00:00:00 | 0
1999-03-31 00:00:00 | 0
1999-04-01 00:00:00 | 0
1999-04-05 00:00:00 | 0
1999-04-06 00:00:00 | 0
1999-04-07 00:00:00 | 0
1999-04-08 00:00:00 | 0
1999-04-09 00:00:00 | 0
1999-04-12 00:00:00 | 0
1999-04-13 00:00:00 | 0
1999-04-14 00:00:00 | 0
1999-04-15 00:00:00 | 0
1999-04-16 00:00:00 | 0
1999-04-19 00:00:00 | 0
1999-04-20 00:00:00 | 2409.64
Spreadsheet: 128273d1320881782-if-statements-help-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL
 |  |  |  |  |  |  | Sunday | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  | Monday | 0.01 | 0.02 | 0.01 | 0.02 | 0.01 | 0.02 | 0.01 | 0.02 | 0.01 | 0.02 | 0.01 | 0.84
 |  |  |  |  |  |  | Tuesday | 0.02 | 0.03 | 0.02 | 0.03 | 0.02 | 0.03 | 0.02 | 0.03 | 0.02 | 0.03 | 0.02 | 0.73
 | Month of Year |  |  | November |  |  | Wednesday | 0.03 | 0.04 | 0.03 | 0.04 | 0.03 | 0.04 | 0.03 | 0.04 | 0.03 | 0.04 | 0.03 | 0.62
 | Day of the Week |  |  | Wednesday |  |  | Thursday | 0.05 | 0.06 | 0.05 | 0.06 | 0.05 | 0.06 | 0.05 | 0.06 | 0.05 | 0.06 | 0.05 | 0.06
 |  |  |  |  |  |  | Friday | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08247422680412371 | 0.09 | 0 | 0.01 | 0.54
 | Previous supply |  |  | 1500 |  |  | Saturday | 0.09 | 0.08 | 0.07 | 0.06 | 0.05 | 0.04 | 0.03 | 0.02 | 0.09 | 0 | 0.01 | 0.54
 | [NAME] |  |  | 0
 | HR |  |  | HR |  |  | HR
 | Total |  |  | Total |  |  | Total
 |  | Supply
 | 08:00:00
 | TOTAL
Spreadsheet: 684111d1593150037-spread-data-by-numbers-example
Sheet: Sheet1

MyData | Amount |  | count data | count amount | out |  |  |  | the needed out
A | 1 |  | 3 | 12 |  |  |  |  | A | 1
B | 2 |  |  |  |  |  |  |  | A | 2
C | 3 |  |  |  |  |  |  |  | A | 3
 | 4 |  |  |  |  |  |  |  | A | 4
 | 5 |  |  |  |  |  |  |  | B | 5
 | 6 |  |  |  |  |  |  |  | B | 6
 | 7 |  |  |  |  |  |  |  | B | 7
 | 8 |  |  |  |  |  |  |  | B | 8
 | 9 |  |  |  |  |  |  |  | C | 9
 | 10 |  |  |  |  |  |  |  | C | 10
 | 11 |  |  |  |  |  |  |  | C | 11
 | 12 |  |  |  |  |  |  |  | C | 12
Spreadsheet: 784967d1656051242-add-holidays-to-calendar-daf-pq-calendar-with-events-0-holidays-aligw
Sheet: Calendar

 |  |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | Month | 1
 | Year | 2022
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2 |  |  |  | New event
 |  |  | 3 |  |  |  | Birthday for Kayla
 |  |  | 4 |  |  |  | Dentist appointment at 2 pm
 |  |  | 5
 |  |  | 1
 |  |  | 2 |  |  |  | Extra day off for salon
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
Spreadsheet: 778847d1651390283-forumla-help-request-for-index-of-multipal-sheet-summary-with-indirect-aligw
Sheet: Summary

Patient summary
Sr.No | [NAME] | Patient Name | [NAME]
1
Spreadsheet: 110670d1307289999-excel-2007-formulas-in-pivot-table-ptdiff-actual-vs-budget
Sheet: Sheet1

Country | Month | Year | Tipe | Cost | Place | Amount |  | Sum of Amount | Column Labels |  |  |  |  |  |  |  | RESULT!!!
a | Jan | 2011 | bud | [NAME] | Logistika | 20 |  |  | Jan |  | Feb |  | Mar |  | Apr |  | Jan | Feb | Mar | Apr
a | Feb | 2011 | bud | [NAME] | Logistika | 5 |  | Row Labels | bud | act | bud | act | bud | act | act |  | diff. | diff. | diff. | diff.
a | Mar | 2011 | bud | [NAME] | Logistika | 24 |  | a | 20 | 15 | 5 | 20 | 24 | 20 | 56
a | Apr | 2011 | act | Vanredni | Logistika | 56 |  | [NAME] | 20 |  |  |  | 24
a | Mar | 2011 | act | [NAME] rashodi | Centrala | 20 |  | [NAME] |  |  | 5
a | Jan | 2011 | act | [NAME] rashodi | Centrala | 15 |  | [NAME] rashodi |  | 15 |  | 20 |  | 20
a | Feb | 2011 | act | [NAME] rashodi | Centrala | 20 |  | Vanredni |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | Grand Total | 20 | 15 | 5 | 20 | 24 | 20 | 56
 |  |  |  |  |  |  |  | I think the below is what you want.  You need to drag the amount to the Sum box twice
 |  |  |  |  |  |  |  | Then you need to Show Values As Difference and play with it.
 |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  | act |  | bud
 |  |  |  |  |  |  |  | Row Labels | Sum of Amount | Differences | Sum of Amount | Differences
 |  |  |  |  |  |  |  | a
 |  |  |  |  |  |  |  | Jan | 15 |  | 20 | 5
 |  |  |  |  |  |  |  | Feb | 20 |  | 5 | -15
 |  |  |  |  |  |  |  | Mar | 20 |  | 24 | 4
 |  |  |  |  |  |  |  | Apr | 56 |  |  | -56
 |  |  |  |  |  |  |  | Grand Total | 111 |  | 49 | -62
Spreadsheet: 25184d1216311939-totals-and-pivot-table-test
Sheet: Sheet1

 | col 1 | col 2 | col 3
a | y | na | y
b | y | n | y
c | n | n | y
d | na | y | y
e | na | y | n
f | y | y | n
y =
n=
na=