tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 27575d1220931529-accumulated-interest-accum-daily-interest
Sheet: Sheet1

 |  |  |  |  | Accumulated |  |  | ACTUAL at 6.5% interest
Dates | Rate |  | Borrowing | Pay-in | Debt |  | Date | Description | Debit | Credit | Balance
2008-07-03 00:00:00 | 6.5 |  | 3000 |  | 3000 |  | 2008-07-03 00:00:00 | GC 0679-TRANSFER | 3000 |  | 3000 |  |  |  |  |  | 8.125 | 19.43806944444444
2008-07-18 00:00:00 | 6.5 |  |  | 467 | 2541.013698630137 |  | 2008-07-18 00:00:00 | PAYMENT - THANK YOU |  | 467 | 2533 |  |  |  |  | 2533 | 2.286736111111111
2008-07-23 00:00:00 | 6.5 |  | 1791 |  | 4334.276245074123 |  | 2008-07-23 00:00:00 | CHQ#00001-[PHONE] | 1791 |  | 4324 |  |  |  |  | 4324 | 0
2008-07-23 00:00:00 | 6.5 |  | 1925 |  | 6259.276245074123 |  | 2008-07-23 00:00:00 | CHQ#00002-[PHONE] | 1925 |  | 6249 |  |  |  |  | 6249 | 9.026333333333334
2008-07-31 00:00:00 | 6.5 | INT | 20.28 |  | 6288.473570135598 |  | 2008-07-31 00:00:00 | INTEREST | 20.28 |  | 6269.28 |  |  |  |  | 6269.28 | 1.131953333333333
2008-08-01 00:00:00 | 6.5 |  |  | 467 | 5822.593435291924 |  | 2008-08-01 00:00:00 | PAYMENT - THANK YOU |  | 467 | 5802.28 | 1.033282739726027 |  |  |  | 5802.28 | 11.52397277777778 | 34.70422763888889
2008-08-12 00:00:00 | 6.5 |  | 288.75 |  | 6122.749337500783 |  | 2008-08-12 00:00:00 | CHQ#00003-[PHONE] | 288.75 |  | 6091.03 | 1.08470397260274 |  |  |  | 6091.03 | 9.89792375
2008-08-21 00:00:00 | 6.5 |  | 372.75 |  | 6505.312511096504 |  | 2008-08-21 00:00:00 | CHQ#00006-[PHONE] | 372.75 |  | 6463.78 | 1.151084109589041 |  |  |  | 6463.78 | 0
2008-08-21 00:00:00 | 6.5 |  | 2731.68 |  | 9236.992511096503 |  | 2008-08-21 00:00:00 | CHQ#00005-[PHONE] | 2731.68 |  | 9195.46 | 1.637547671232876 |  |  |  | 9195.46 | 13.28233111111111
2008-08-29 00:00:00 | 6.5 | INT | 39.14 |  | 9289.292062071216 |  | 2008-08-29 00:00:00 | INTEREST | 39.14 |  | 9234.6 | 1.644517808219178
 | 6.5
 | 6.5 | days
 | 6.5 | 15 | 3000 | 8.013698630136986
 | 6.5 | 5 | 2533 | 2.25541095890411 |  |  | ACCRINTM(issue,maturity,rate,par,basis)
 | 6.5 | 8 | 6249 | 8.90268493150685
 | 6.5
 | 6.5 |  |  | 19.17179452054794 | 20.28 if rate is 6.88
 | 6.5
 | 6.5 | 28 |  | 1.108205479452057
 | 6.5
 |  | 28 |  |  | This is a chequebook where every cheque is a debt.
Spreadsheet: 139779d1328462699-sum-if-array-calc-for-between-2-dates-monthly-term-fee-calc
Sheet: Term Fee Summary

 | Sent | Verified | Estimate
Totals | 390563.5125 | 2673357.801809884 | 3292149.273372334
2012-02-29 00:00:00 |  |  |  |  | OK, based on the Early term date in Column F of the All Locations sheet, I need to know the total for each of the Columns to the left.  As you can see I can do it in total using the Sum(if() [NAME], but it is beyond me haow to tell it to do the same thing between 2 dates.  Can someone help me with this?
2012-03-31 00:00:00
2012-04-30 00:00:00
2012-05-31 00:00:00
2012-06-30 00:00:00
2012-07-31 00:00:00
2012-08-31 00:00:00
2012-09-30 00:00:00
2012-10-31 00:00:00
2012-11-30 00:00:00
2012-12-31 00:00:00
2013-01-31 00:00:00
2013-02-28 00:00:00
2013-03-31 00:00:00
2013-04-30 00:00:00
2013-05-31 00:00:00
2013-06-30 00:00:00
2013-07-31 00:00:00
2013-08-31 00:00:00
2013-09-30 00:00:00
2013-10-31 00:00:00
2013-11-30 00:00:00
2013-12-31 00:00:00
2014-01-31 00:00:00
2014-02-28 00:00:00
2014-03-31 00:00:00
2014-04-30 00:00:00
2014-05-31 00:00:00
2014-06-30 00:00:00
2014-07-31 00:00:00
2014-08-31 00:00:00
2014-09-30 00:00:00
2014-10-31 00:00:00
2014-11-30 00:00:00
2014-12-31 00:00:00
2015-01-31 00:00:00
2015-02-28 00:00:00
2015-03-31 00:00:00
2015-04-30 00:00:00
2015-05-31 00:00:00
2015-06-30 00:00:00
2015-07-31 00:00:00
2015-08-31 00:00:00
2015-09-30 00:00:00
2015-10-31 00:00:00
2015-11-30 00:00:00
2015-12-31 00:00:00
2016-01-31 00:00:00
2016-02-29 00:00:00
2016-03-31 00:00:00
2016-04-30 00:00:00
Spreadsheet: 79843d1280079850-calculating-late-fees-and-accruing-interest-test-interest-and-penalties
Sheet: A little automated

Today's Date | 2010-07-25 00:00:00
Monthly Items: Last Current on |  |  | 2008-12-01 00:00:00
Months in Arrears |  | 19
 |  | Monthly Principle | Current Principle Obligation | Accrued Interest Due | Accrued Penalties Due | Total Due
Monthly Reserve |  | 492.6 | 9359.4 |  |  | 9359.4 | (the total of the current principle, interest, and penalties)
Monthly Operations |  | 1554.75 | 29540.25 |  |  | 29540.25
Monthly Tax |  | 2531.323333333333 | 48095.14333333333 |  |  | 48095.14333333333
Spreadsheet: 824399d1680543214-comparing-two-lists-with-multiple-columns-lists
Sheet: Sheet12

List 1 |  |  | List 2 |  |  | List of people that are on list 2 but not
 |  |  |  |  |  | on list one
Covo | [NAME] |  | Eastwood | [NAME]
Eastwood | [NAME] |  | Arsenault | Stéphane
Arcand | [NAME] |  | Kelso | [NAME]
Beaulieu | Michel |  | Legault | [NAME]
Legault | [NAME] |  | Mitchell | [NAME]
Rozon | Gilles |  | Arcand | [NAME]
Cross | [NAME] |  | Beaulieu | Michel
Kelso | [NAME] |  | Rozon | Gilles
Du Preez | [NAME] |  | Cross | [NAME]
Arsenault | Stéphane |  | Du Preez | [NAME]
Legault | [NAME] |  | Covo | [NAME]
 |  |  | Chartrain | [NAME]
 |  |  | Legault | [NAME]
Spreadsheet: 830247d1684825361-sum-up-revenue-of-customers-by-year-from-another-sheet-of-financial-data-test-file-for-power-query-aligw
Sheet: Customer List

Customer Code | 2018 | 2019 | 2020 | 2021 | 2022 | 2023
1009126
1009790
1008803
1010244
1008991
1008836
1008837
1010665
1008839
1008804
1009658
1008840
1008928
1008841
1010386
1010140
1010767
1011602
1009343
1008838
1008845
1008820
1010240
1008821
1009209
1009601
1008967
1008843
1008849
1008822
1008842
1008853
1008844
1008823
1010074
1008846
1008856
1009274
1008847
1008824
1008858
1008859
1008860
1008848
1008861
1009583
1010998
1008810
1008862
1011565
1009665
1011356
1008865
1008850
1008851
1009049
1010781
1008852
1008871
1008872
1008811
1008873
1008868
1008869
1008830
1008870
1010571
1008875
1008854
NA- UK Account
1010143
1011425
1008855
1008825
1008857
1008880
1009239
1010434
1008882
1008883
1008826
1011546
1010817
1009520
1010871
1008815
1009187
1008827
1008828
1008879
1008829
1009864
1009944
1008863
1010939
1008929
1008864
1011590
1010888
1008896
1010181
1008897
1009090
1008898
1008866
1009102
1010038
1010002
1008901
1009567
1008904
1009350
1008816
1010392
1011300
1008867
1009793
1008907
1010746
1008874
1008910
1008817
1008909
1008913
1008876
1009141
1008877
1008812
1009368
1010865
1008878
1011155
1008831
1009814
1010044
1008813
1010203
1008881
1009644
1009735
1008884
1009219
1008885
1009979
1008814
1011249
IC7000
1009879
1009666
1009698
1009730
1009725
1008887
1009396
1009070
1009370
1008889
1010060
1008888
1010498
1009817
1010690
1011049
1009873
1010390
1008890
1009885
1008541
1009945
1008079
1009973
1009884
1008891
1009981
1008892
1008893
1009692
1009804
1010058
1010080
1008894
1008895
1009038
1010115
1010441
1008832
1011467
1008899
1010385
1009551
1008900
1010252
1010272
1010314
1010327
1009335
1010222
1009731
1008902
1010088
1008975
1010742
1008833
1010444
1008905
1010455
1010477
1008903
1008906
1010568
1010450
1009844
1010394
1010684
1010709
1010081
1010737
1010391
1010393
1009199
1010768
1009523
1008908
1008914
1010856
1008911
1008912
1008834
1010940
1010941
1010942
1010943
1010674
1010986
1008835
1011038
1009112
1011050
1011110
1011115
1011126
1008818
1011189
1011242
1008915
1011264
1011262
1008949
1008916
1011313
1011347
1011348
1008917
1011375
1011397
1008969
1011431
1011432
1011442
1011456
1011457
1011458
1011461
1011466
1011463
1009980
1011485
1011509
1011527
1011542
1011539
1011545
1008918
1011547
1011548
1011555
1011557
1008919
1011578
1008920
1011596
1009922
1011615
1011620
1011635
1011670
1011703
1011704
Spreadsheet: 73543d1274199336-excel-2007-matrixed-data-gathering-with-report-example-data-gathering-and-report
Sheet: Blank Data Gathering

Module Name:  Module 1
 |  | Role 1 | Role 2 | Role 3 | Role 4
Tracking
 | Tracking Task 1
 | Tracking Task 2
 | Tracking Task 3
 | Tracking Task 4
 | Tracking Task 5
Querying
 | Querying Task 1
 | Querying Task 2
 | Querying Task 3
 | Querying Task 4
Managing
 | Managin Task 1
 | Managin Task 2
 | Managin Task 3
 | Managin Task 4
Spreadsheet: 437372d1451310979-attempting-to-allocate-portions-of-the-week-randomly-to-colleagues-that-allocation-workbook
Sheet: Sheet1

 | That [NAME]
 |  | Monday | Tuesday | Wednesday | Thursday | Friday |  | Player | Name | Slot | Rand
 | AM | 1 | 3 | 5 | 7 | 9 |  | 1 | A
 | PM | 2 | 4 | 6 | 8 | 10 |  | 2 | B
 |  |  |  |  |  |  |  | 3 | C
 |  | Slot Number | Allocated Slot |  |  |  |  | 4 | D
 |  | 1 | Monday AM |  |  |  |  | 5 | E
 |  | 2 | Tuesday AM |  |  |  |  | 6 | F
 |  | 3 | Wednesday AM |  |  |  |  | 7 | G
 |  | 4 | Thursday AM |  |  |  |  | 8 | H
 |  | 5 | Friday AM |  |  |  |  | 9 | I
 |  | 6 | Monday PM |  |  |  |  | 10 | J
 |  | 7 | Tuesday PM
 |  | 8 | Wednesday PM
 |  | 9 | Thursday PM
 |  | 10 | Friday PM
 | Allocated Table
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | AM
 | PM
Spreadsheet: 735067d1622672096-formula-issue-assessments-students-completed-each-term-new-test-v13-smaller-sample-data
Sheet: Total Score Summary

Record ID | This form is being completed for | Intern Name | ROTATION |  | Mid-term | FORMATIVE |  |  |  |  |  |  |  |  |  |  |  |  |  | REDCap record no | End Term | END TERM |  |  |  |  |  |  |  |  |  |  |  |  |  | REDCap record no | Combined | COMBINED
 |  |  | Term Number | Term Name |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Totals |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Totals |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4
 |  |  |  |  |  | Total not observed | Score | % | Total not observed | Score | % | Total not observed | Score | % | Total not observed | Score | % | Score | % |  |  | Total not observed | Score | % | Total not observed | Score | % | Total not observed | Score | % | Total not observed | Score | % | Score | % |  |  | Total not observed | Score | % | Total not observed | Score | % | Total not observed | Score | % | Total not observed | Score | % | Score | %
Spreadsheet: 44208d1242842804-excel-2007-compatability-issue-testing
Sheet: AUG_SEPT

No. | Date | PURCHASES | AMOUNT |  | ELECTRONICS | GROCERY | BOOKS AND [NAME] | MISCELLEANOUS | PETROL
 |  | TOTAL ->
4 | 2009-08-18 00:00:00 |  | 22.08
5 | 2009-08-19 00:00:00 | AMZ*Amazon Payments AMZN.COM/BILL WA | 75.87
6 | 2009-08-19 00:00:00 | PAYPAL *LANPIN [PHONE] CA | 43.98
7 | 2009-08-20 00:00:00 | NCSU BOOKSTORE RALEIGH NC | 0
8 | 2009-08-20 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 1.28
9 | 2009-08-21 00:00:00 | Amazon.com AMZN.COM/BILL WA | 112.61
10 | 2009-08-21 00:00:00 | [NAME] [PHONE] | 4.95
11 | 2009-08-22 00:00:00 | PAYPAL *BENSONBOOKS [PHONE] CA | 55.45
12 | 2009-08-27 00:00:00 | FOOD LION #1454 RALEIGH NC | 6.75
13 | 2009-08-27 00:00:00 | [NAME] RALEIGH NC | 31.44
14 | 2009-08-27 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 2.19
15 | 2009-08-27 00:00:00 | SUBWAY # 1880 RALEIGH NC | 3.98
16 | 2009-08-28 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 3.01
17 | 2009-08-28 00:00:00 | NCSU ALL CAMPUS MICROS RALEIGH NC | 3.01
18 | 2009-08-29 00:00:00 | NCSU BOOKSTORE RALEIGH NC | 18.09
19 | 2009-08-30 00:00:00 | [NAME] CORN RALEIGH NC | 15.06
20 | 2009-09-01 00:00:00 | LOWES #00426* CARY NC | 21.34
21 | 2009-09-02 00:00:00 | WESTERN LANES BOWLING CEN RALEIGH NC | 70
22 | 2009-09-03 00:00:00 | FOOD LION #1454 RALEIGH NC | 18.35
23 | 2009-09-03 00:00:00 | WEB ASSIGN [PHONE] NC | 12.65
24 | 2009-09-06 00:00:00 | [NAME] CORN RALEIGH NC | 11.83
25 | 2009-09-08 00:00:00 | NCSU WOLFPRINT [PHONE] NC | 5
26 | 2009-09-08 00:00:00 | NCSU BOOKSTORE RALEIGH NC | 0
27 | 2009-09-09 00:00:00 | BURGER KING #4521 Q07 RALEIGH NC | 6.23
28 | 2009-09-10 00:00:00 | NCSU WOLFPRINT [PHONE] NC | 5
29 | 2009-09-10 00:00:00 | K & L MART INC. Q39 RALEIGH NC | 10.08
Spreadsheet: 4d6f7408-ea04-4dd5-88c4-31bf3554bdb7
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120602 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Transit and transportation related |  |  |  | Appropriating funding for multiple transit
 | funding needs |  |  |  | related needs for FY 2012-2013
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  | Public Works Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | Public Works
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  |  |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 | Kansas City Power and Light rate increases have been on an upward |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections -- |  | Cost Projection
 |  |  |  |  | Including Indirect |  | 750000
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation |  | 13-2080-891000 B - $355,000.00
 |  |  |  |  | Account Codes |  | 13-2080-891317 B - $375,000.00
 |  |  |  |  |  |  | 13-[PHONE] B - $ 20,000.00
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME]
Reviewed by:
Reference Numbers
Spreadsheet: 705664d1606244733-conditional-formatting-with-special-conditions-max-and-min-by-quarter-month-and-week-zanto666-
Sheet: Tabelle1

 |  |  |  |  | Year |  |  | Year | Quarter # |  | Year | Month # |  | Year | Week # (1st week start at 1st Jan)
Exchange Date | Close | Week No. | Quarter |  | Min | [NAME] |  | Min | [NAME] |  | Min | [NAME] |  | Min | [NAME]
2000-10-26 00:00:00 | 237.684725493749
2000-10-27 00:00:00 | 237.64374063874
2000-10-30 00:00:00 | 238.412418458566
2000-10-31 00:00:00 | 236.941951072185
2000-11-01 00:00:00 | 238.889855387626
2000-11-02 00:00:00 | 239.731786879304
2000-11-03 00:00:00 | 239.419944906244
2000-11-06 00:00:00 | 240.564086455401
2000-11-07 00:00:00 | 241.283209897426
2000-11-08 00:00:00 | 243.187068090659
2000-11-09 00:00:00 | 245.563744442296
2000-11-10 00:00:00 | 247.361184941768
2000-11-13 00:00:00 | 250.19186158902
2000-11-14 00:00:00 | 251.907989320189
2000-11-15 00:00:00 | 251.5350135318
2000-11-16 00:00:00 | 253.220736230413
2000-11-17 00:00:00 | 252.900844519084
2000-11-20 00:00:00 | 253.855325626064
2000-11-21 00:00:00 | 253.4223177832
2000-11-22 00:00:00 | 255.285327728249
2000-11-23 00:00:00 | 256.032737376178
2000-11-24 00:00:00 | 248.054458256321
2000-11-27 00:00:00 | 247.604614641218
2000-11-28 00:00:00 | 251.204561653599
2000-11-29 00:00:00 | 249.775895812696
2000-11-30 00:00:00 | 250.143518127015
2000-12-01 00:00:00 | 251.506251887648
2000-12-04 00:00:00 | 252.76232013628
2000-12-05 00:00:00 | 252.708710885586
2000-12-06 00:00:00 | 250.770448230035
2000-12-07 00:00:00 | 250.700012081672
2000-12-08 00:00:00 | 250.475781995675
2000-12-11 00:00:00 | 247.191233856451
2000-12-12 00:00:00 | 248.765026398135
2000-12-13 00:00:00 | 248.413676452821
2000-12-14 00:00:00 | 247.810627295573
2000-12-15 00:00:00 | 246.39522520781
2000-12-18 00:00:00 | 247.003286056009
2000-12-19 00:00:00 | 247.551345865752
2000-12-20 00:00:00 | 250.246831543211
2000-12-21 00:00:00 | 250.928619756428
2000-12-22 00:00:00 | 250.041436630948
2000-12-25 00:00:00 | 249.870001208167
2000-12-26 00:00:00 | 250.850680810449
2000-12-27 00:00:00 | 248.670291168297
2000-12-28 00:00:00 | 248.088812650246
2000-12-29 00:00:00 | 250.498586512674
Spreadsheet: a7b6243d-e686-4ad3-9d15-61983da6298c
Sheet: Sheet1

A | B | C | D | E | F
Table 1:
Electricity and Natural Gas Savings and Demand Reduction
Annual Results | Installed Savings [1] | [NAME] in D.09-09-047 | % of Goal | % of 3-Year Portfolio Goal | Balance
2010  Energy Savings (GWh) – Annual [2] | 2236.32473235809 | 1117 | 2.002081228610645 | 0.6744043221827775 | -1119.32473235809
PG&E
SCE | 2236.32473235809 | 1117 | 2.002081228610645 | 0.6744043221827775 | -1119.32473235809
SDG&E
SCG
2011  Energy Savings (GWh) – Annual [2] | 1418.511887582285 | 1106 | 1.282560477018341 | 0.4277780119367565 | -312.5118875822845
PG&E
SCE | 1418.511887582285 | 1106 | 1.282560477018341 | 0.4277780119367565 | -312.5118875822845
SDG&E
SCG
2011  Energy Savings (GWh) – Annual [2] |  | 1093
PG&E
SCE |  | 1093
SDG&E
SCG
TOTAL Energy Savings (GWh) - Annual | 3654.836619940374 | 3316 | 1.102182334119534 | 1.102182334119534 | -338.8366199403745
2010  Energy Savings (GWh) – Lifecycle [3] | 17402.7295074235 | 0 |  |  | 0
PG&E
SCE | 17402.7295074235 | 0
SDG&E
SCG
2011  Energy Savings (GWh) – Lifecycle [3] | 11110.49657245097 | 0
PG&E
SCE | 11110.49657245097
SDG&E
SCG
TOTAL  Energy Savings (GWh) – Lifecycle | 28513.22607987447
2010 Natural Gas Savings (MMth) – Annual | 0 | 0 | 0 | 0 | 0
PG&E
SCE
SDG&E
SCG
2011 Natural Gas Savings (MMth) – Annual | 0 | 0
PG&E
SCE
SDG&E
SCG
TOTAL  Natural Gas Savings (MMth) – Annual | 0 | 0 | 0 | 0 | 0
2010 Natural Gas Savings (MMth) – Lifecycle [3] | 0 | 0 |  |  | 0
PG&E
SCE
SDG&E
SCG
2011 Natural Gas Savings (MMth) – Lifecycle | 0 | 0
PG&E
SCE
SDG&E
SCG
TOTAL  Natural Gas Savings (MMth) – Lifecycle | 0
2010 Peak Demand savings (MW) [2] | 429.740016616666 | 245 | 1.754040884149657 | 0.5911141906694168 | -184.740016616666
PG&E
SCE | 429.740016616666 | 245 | 1.754040884149657 | 0.5911141906694168 | -184.740016616666
SDG&E
SCG
2011 Peak Demand savings (MW) [2] | 260.9200624983746 | 243 | 1.073745113162035 | 0.3588996733127574 | -17.92006249837459
PG&E
SCE | 260.9200624983746 | 243 | 1.073745113162035 | 0.3588996733127574 | -17.92006249837459
SDG&E
SCG
2011 Peak Demand savings (MW) [2] |  | 239
PG&E
SCE |  | 239
SDG&E
SCG
TOTAL  Peak Demand savings (MW) | 690.6600791150406 | 727 | 0.9500138639821741 | 0.9500138639821741 | 36.33992088495938
[1] Results from activity installed in 2011 only.  In D.07-11-030, the CPUC adopted the final 2010-2012 ex ante assumptions retroactively to January 1, 2010.
As a result, the 2011 activity is derived as the difference between the adjusted cumulative 2010-2011 performance and SCE's 2010 EE Annual Report.
[2] Includes savings associated with Low Income Energy Efficiency and Codes and Standards programs.
[3] Does not include lifecycle savings associated with Low Income Energy Efficiency and Codes and Standards programs.
Spreadsheet: 5b1b7f72-16fd-4e8b-bd73-e427ad093197
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0022711 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Macon County Reuse System | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Macon | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | Site 1 |  | Field Name: |  | Site 2 |  | Field Name: |  | Site 3 |  | Field Name: |  | Site 4
 |  |  |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Distributed / Utilized |  |  |  | Volume Distributed / Utilized |  |  |  | Volume Distributed / Utilized |  |  |  | Volume Distributed / Utilized
 |  | ºF | in | ft | ft | gal |  |  |  | gal |  |  |  | gal |  |  |  | gal
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
Monthly Loading (gallons): |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.04.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-04 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 25 | 2 | 5 | 0 | 3 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 3 | 4 | 0 | 1 | 0 | 1 | 2 | 0
 | ABC | 27 | 18 | 24 | 2 | 6 | 0 | 1 | 1 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 2 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 3 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-04 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 5 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 23 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 19 | 0 | 6 | 0 | 2 | 1 | 1 | 1 | 0.5
 | MNO | 12 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 3 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 9 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 144649d1331075719-excel-2007-pivot-table-queries-using-multiple-sources-and-cumulative-running-totals-pivot-table-query-example
Sheet: Pivot

Sum of Doc Value | Column Labels |  |  |  |  | Sum of Doc Value | Column Labels
Row Labels | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 |  | Row Labels | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4
2011-04-28 00:00:00 | -397835.68 | -397835.68 | -397835.68 | -397835.68
2011-05-31 00:00:00 | -264112.1899999999 | -264112.1899999999 | -264112.1899999999 | -264112.1899999999
2011-06-29 00:00:00 | -184501.82 | -184501.82 | -184501.82 | -184501.82
2011-07-29 00:00:00 | -162468.02 | -162468.02 | -162468.02 | -162468.02
2011-08-31 00:00:00 | -350886.85 | -400097.17 | -400097.17 | -400097.17
2011-09-30 00:00:00 | -27045.56 | -117895.69 | -117895.69 | -117895.69
2011-10-31 00:00:00 | -35878.01000000001 | -61889.21000000004 | -61889.21000000004 | -61889.21000000004
2011-11-29 00:00:00 | 0 | -534.06 | -33642.91999999998 | -33642.91999999998
2011-12-22 00:00:00 | 0 | 0 | -21086.77 | -21086.77
2012-01-31 00:00:00 | -1814.87 | -10305.51 | -181288.0900000002 | -181288.0900000002
2012-02-29 00:00:00 | 0 | 0 | -414.01 | -414.01
2012-03-02 00:00:00 | 1.818989403545856e-12 | 1.818989403545856e-12 | -55583.45000000001 | -151927.2
2012-03-05 00:00:00 | 0 | 0 | -907.33 | -907.33
Grand Total | -1424543 | -1599639.35 | -1881722.35 | -1978066.1