tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768449d1644973100-qty-from-multiple-orders-to-fill-multiple-requests-over-different-dates-index-aggregate-inside-index-agregate-neilosj-
Sheet: Sheet1

 |  |  |  | Just so I can keep track |  |  |  | qty from multiple orders to fill multiple requests over different dates (excelforum.com)
Outstanding orders |  |  |  | Remaining after |  |  |  | Customers requests for quantities and delivery date |  |  |  |  |  |  | This is how I need to present the information (minus the shading)
Order num. | Item | Qty |  | 2022-02-18 00:00:00 | 2022-02-24 00:00:00 | 2022-03-04 00:00:00 |  | Item | 18-Feb | 24-Feb | [NAME] |  |  |  | Order number | Item | Quantity | Delivery Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 503 | 755A | 5 | 2022-02-18 00:00:00
503 | 755A | 5 |  | 0 | 0 | 0 |  | 755A | 10 | 10 | 10 |  |  |  | 500 | 755A | 5 | 2022-02-18 00:00:00
500 | 755A | 7 |  | 2 | 0 | 0 |  | 1190 | 5 | 2 | 30 |  |  |  | 503 | 1190 | 2 | 2022-02-18 00:00:00
400 | 755A | 20 |  | 20 | 12 | 2 |  |  |  |  |  |  |  |  | 500 | 1190 | 3 | 2022-02-18 00:00:00
503 | 1190 | 2 |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 500 | 755A | 2 | 2022-02-24 00:00:00
500 | 1190 | 10 |  | 7 | 5 | 0 |  |  |  |  |  |  |  |  | 400 | 755A | 8 | 2022-02-24 00:00:00
400 | 1190 | 50 |  | 50 | 50 | 25 |  |  |  |  |  |  |  |  | 500 | 1190 | 2 | 2022-02-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 | 755A | 10 | 2022-03-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 | 1190 | 30 | 2022-03-04 00:00:00
 |  |  | Item | 2022-02-18 00:00:00 | 2022-02-24 00:00:00 | 2022-03-04 00:00:00 |  |  |  |  |  |  |  |  | Order number | Item | Quantity | Delivery Date
 |  |  |  |  |  |  |  | Item | Attribute | Value | Rows | Total Rows
 |  |  | 755A | 10 | 10 | 10 |  | 755A | 18-Feb | 10
Order num. | Item | Qty | 1190 | 5 | 2 | 30 |  | 1190 | 18-Feb | 5
 |  |  |  |  |  |  |  | 755A | 24-Feb | 10
503 | 755A | 5 |  |  |  |  |  | 1190 | 24-Feb | 2
500 | 755A | 7 |  |  |  |  |  | 755A | [NAME] | 10
400 | 755A | 20 |  |  |  |  |  | 1190 | [NAME] | 30
503 | 1190 | 2
500 | 1190 | 10
400 | 1190 | 50
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 32539 | 31400
2 | 32516 | 31400
3 | 39547 | 36521
4 | 37821 | 33628
5 | 35429 | 38484
6 | 39521 | 38484
7 | 40825 | 38500
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -39050
2001-08-07 00:00:00
CBS Volume
 |  |  | -2111
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: TETCO STX

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       TETCO STX               Jun01           USD/MM | 05/29/2001 03:28 pm | 5000 | 3.645
US Gas Phy       TETCO STX               Jun01           USD/MM | 05/30/2001 12:17 pm | 5000 | 3.53
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 0264969a-a5ab-4584-adb1-9d0d2c229817
Sheet: Certificates

Certificates
C& I meeting Date | New Certificates | Certificate Modification | Modification Details | Delete from Catalog | Delete Curriculum Inventory | Effective Date | Approved by AA | Date BOT approved | CO's Approval Date
2013-02-27 00:00:00 |  | Digital Animation Certificate | Delate from Catalog
2013-02-27 00:00:00 | NA |  |  | Digital Animation Certificate |  | Fall 2013
2013-03-13 00:00:00 | NA | Title Change | Animation Certificate (New Title) |  |  | Fall 2013 |  |  | Unable to process. Need additional records.
2013-03-13 00:00:00 | NA | Course changes | Required Courses: Add Art 121, 230 Required Courses: Delete Art 205, 206, 209 , 146, TA 130, Dance 140 |  |  | Fall 2013 |  |  | Unable to process. Need additional records.
2013-03-13 00:00:00 | HomeLand Security Skill Award | NA
2013-05-08 00:00:00 | NA | Fire Technology certificate | Reflect the title and number changes for FIRE 104 and 115 |  |  |  |  |  | Unable to process. Need additional records.
2013-06-12 00:00:00 |  | Specialist in Alchohol and Drug Studies | Delete AD ST 150 and 151
Spreadsheet: 725778d1616854990-index-aggregate-multiple-criteria-and-columns-to-search-problem1
Sheet: Sheet1

Product | Component | Quantity |  | Product | Component | Country | Qty In | Qty Out | Value | Item | Box |  |  | Label |  |  | Bag
Beverage | [Item] Tea |  |  | Beverage | [Item] Tea | - | 50 | - | - | Beverage | Box A | 1 | 11 | [NAME] | 2 | 11 | Bag S | 8 | 11
Beverage | [Item] Juice |  |  | Beverage | [Item] Juice | - | 50 | - | - | Flower | [NAME] | 2 | 12 | [NAME] | 1 | 12 | Bag M | 5 | 12
Beverage | Box A |  |  | Flower | [Item] Tulip | - | 100 | - | - | Furniture | Box C | 3 | 24 | [NAME] | 10 | 24 | Bag L | 6 | 24
Beverage | [NAME] |  |  | Furniture | [Item] Table | - | 75 | - | - | Food | Box D | 4 | 36 | [NAME] | 8 | 36 | Bag XL | 11 | 36
Beverage | Bag S |  |  | Furniture | [Item] Chair | - | 150 | - | - | Pets | Box A | 5 | 12 | [NAME] | 4 | 12 | Bag M | 3 | 12
Food | [Item] Bacon |  |  | Furniture | [Item] Couch | - | 76 | - | -
Food | [Item] Egg |  |  | Food | [Item] Bacon | - | 188 | - | -
Food | Box D |  |  | Food | [Item] Egg | - | 125 | - | -
Food | [NAME] |  |  | Pets | [Item] Cat | - | 304 | - | -
Food | Bag XL
Flower | [Item] Tulip
Flower | [NAME]
Flower | [NAME]
Flower | Bag M
Furniture | [Item] Table
Furniture | [Item] Chair
Furniture | [Item] Couch
Funiture | Box C
Funiture | [NAME]
Funiture | Bag L
Spreadsheet: 274550d1383147700-vlookup-sum-product-test-lookup-two
Sheet: Sheet1

Green | Blue | Red | [NAME] | Blue Rev | Red Rev
5 | 10 | 6 | 7 | 5 | 9
4 | 5 | 8 | 8 | 7 | 9
Lookup | Cost
Green
Blue
Red
Spreadsheet: 853270d1703156604-conditional-format-highest-value-in-previous-28-cells-cf-offset-strange-p-and-r
Sheet: MONTHLY CHARTS

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
 |  | Date | TRAYS IN | SUPPS IN | TOTAL IN | INSTRUMENT TOTAL IN | TRAYS OUT | SUPPS OUT | TOTAL OUT | TRAY CONTENTS TOTAL OUT | TOTAL ITEMS OUT | SHORTFALL | SHORFALL PERCENTAGE | FAST TRACK | FAST TRACK PERCENTAGE | % PRIORITIES <24HRS | DIRTY | DIRTY % | BYPASSED | BYPASSED % | RUSTY | RUSTY % | TOTAL | TOTAL % | TURNAROUND TIME | [NAME] | [NAME] | Booked On | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved
 |  | 2023-12-01 00:00:00
Spreadsheet: 706664d1606825764-equation-for-averaging-cells-that-include-signs-excel-help
Sheet: Sheet1

With the new formula placed in to cell J64, a percent recovery is not showing up.  For this particular example the numbers I'd like to have calculated are 5 and 2 since we can't have a number below 2.  The result in L64 and J64 should be 85.7.   In this example, the calculation in [NAME] is currently using 5 and 1. Could you recognize the 1's to be 2's in L60-L62 but still show up as <2 in J60-62?
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 57 | 200 |  | 8.95 | 4.7 |  | 1.4
 | 58 | 180 |  | 8.88 | 4.5 |  | 1.4
 | 59 | 150 |  | 8.81 | 4.5 |  | 1.4
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Average:
Sample ID | Bottle # | ml's Sample Used | Volume of B.O.D. Seed Used (mL) | Initial D.O. | Final D.O. | Depletion | Seed Correction Factor | Net Depletion | Result (mg/L)
 | 60 | 200 |  | 8.93 | 6.56 |  | 1.4
 | 61 | 180 |  | 8.88 | 6.64 |  | 1.4
 | 62 | 150 |  | 8.76 | 6.75 |  | 1.4
 |  |  |  |  | Final D.O. must be >1mg/L | Depletion must be >2mg/L | Effluent Duplicate Average:
 |  |  |  |  |  |  | Duplicate % Recovery (<20%):
 |  |  |  |  |  |  | Effluent & Duplicate Average:
Spreadsheet: 795836d1662978043-googlesheets-count-number-of-days-between-days-listed-in-text-days_leadtime
Sheet: Sheet1

 |  |  |  | Desired Output
Collection Day | Train Departure Day | Train Arrival Day | Delivery Day | Lead Days (incl weekends) | Lead Days (exc weekends)
Tuesday | Wednesday | Saturday | Monday | 7 | 5
Wednesday | Sunday | Wednesday | Thursday | 9 | 7
Monday | Monday | Thursday | Friday | 5 | 5
Lead Days = number of days between collection day and delivery day
collection day = Day 1
Spreadsheet: 142038d1329594641-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: PGA

 |  | WEEK 18 PGA Championship
 |  | Total Earnings |  |  |  | Rankings Through Week 18 | Total
 | [NAME] | 0 |  | 2 | 1 | [NAME] | 5000
 | [NAME] | 5000 |  | 1 | 2 | [NAME] | 0
 | [NAME] | 0 |  | 3 | 3 | [NAME] | 0
 |  | 0 |  | 4 | 4 | 0 | 0
 |  | 0 |  | 5 | 5 | 0 | 0
 |  | 0 |  | 6 | 6 | 0 | 0
 |  | 0 |  | 7 | 7 | 0 | 0
 |  | 0 |  | 8 | 8 | 0 | 0
 |  | 0 |  | 9 | 9 | 0 | 0
 |  | 0 |  | 10 | 10 | 0 | 0
 |  | 0 |  | 11 | 11 | 0 | 0
 |  | 0 |  | 12 | 12 | 0 | 0
 |  | 0 |  | 13 | 13 | 0 | 0
 |  | PGA Championship |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: 00a00d12-c552-4ecd-a5e1-44ecb5eada89
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TABLE 1:  Participation in Employee Ownership and Stock Options, 2002-2010 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Based on analysis of 2002, 2006, and 2010 cross-sectional General Social Surveys
 |  |  |  | All private sector |  |  | For-profit | Companies
 |  |  |  |  |  |  | companies | with stock
 |  |  |  | 2002 | 2006 | 2010 | 2010 | 2010
 |  |  |  | (1) | (2) | (3) | (4) | (5)
Percent of employees covered
 | Own company stock |  |  | 0.2117552 | 0.1754355 | 0.174 | 0.206 | 0.36
 | Stock options |  |  | 0.1312804 | 0.09285 | 0.087 | 0.112 | 0.238
Number of employees covered (millions)
 | Total employees in economy^ |  |  | 108.8 | 114.262 | 107.3 | 93.5656 | 40.9886
 | Own company stock |  |  | 23.03896576 | 20.045611101 | 18.6702 | 18.6702 | 18.6702
 | Stock options |  |  | 14.28330752 | 10.6092267 | 9.335099999999999 | 9.335099999999999 | 9.335099999999999
Sample size |  |  |  | 1242 | 1173 | 795 | 690 | 394
^ The figure for total private sector employees comes from Bureau of Labor Statistics establishment data
for July 2002 and 2006. The BLS does not provide employee counts for not-for-profit organizations and companies
with stock, so columns 3-5 are estimates based on the distribution of respondents in the General
Social Survey sample.
Source:  Analysis and question design by [NAME], [NAME], and [NAME], National Bureau of
Economic Research Shared Capitalism Project.  The items were included in the 2010 General Social Survey which
was administered by the National Opinion Research Center at the University of Chicago.  The GSS is mainly
supported by the National Science Foundation.  The shared capitalism segment of the GSS for 2010 was
supported by the Employee Ownership Foundation, the ESOP Association, the Beyster Institute at the University
of California at San Diego,  the Profit Sharing Council of America, and the National Center for Employee Ownership.
Spreadsheet: e0b3ffc3-da3a-46c0-bb98-d234319693dc
Sheet: Sheet1

Release: Money Velocity | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=193
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-30 12:02 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Money Velocity | 2010-07-30 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2010-07-30 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-07-30 00:00:00
2010-08-27 00:00:00
2010-09-30 00:00:00
2010-10-15 00:00:00
2010-10-29 00:00:00
2010-11-23 00:00:00
2010-12-22 00:00:00
2011-01-14 00:00:00
2011-01-28 00:00:00
2011-02-11 00:00:00
2011-03-11 00:00:00
2011-03-25 00:00:00
2011-04-15 00:00:00
2011-04-28 00:00:00
2011-05-13 00:00:00
2011-05-26 00:00:00
2011-06-24 00:00:00
2011-07-15 00:00:00
2011-07-29 00:00:00
2011-08-26 00:00:00
2011-09-16 00:00:00
2011-09-29 00:00:00
2011-10-14 00:00:00
2011-10-27 00:00:00
2011-11-14 00:00:00
2011-11-22 00:00:00
2012-01-13 00:00:00
2012-01-27 00:00:00
2012-02-29 00:00:00
2012-03-29 00:00:00
2012-04-13 00:00:00
2012-04-26 00:00:00
2012-04-27 00:00:00
2012-05-31 00:00:00
2012-06-28 00:00:00
2012-07-13 00:00:00
2012-07-27 00:00:00
2012-08-29 00:00:00
2012-09-27 00:00:00
2012-10-12 00:00:00
2012-10-26 00:00:00
2012-11-16 00:00:00
2012-11-29 00:00:00
2012-12-14 00:00:00
2012-12-20 00:00:00
2013-01-30 00:00:00
2013-02-28 00:00:00
2013-03-28 00:00:00
2013-04-26 00:00:00
2013-05-17 00:00:00
2013-05-30 00:00:00
2013-06-26 00:00:00
2013-07-31 00:00:00
2013-08-29 00:00:00
2013-09-26 00:00:00
2013-10-11 00:00:00
2013-11-07 00:00:00
2013-12-05 00:00:00
2013-12-20 00:00:00
2014-01-30 00:00:00
2014-02-28 00:00:00
2014-03-27 00:00:00
2014-04-30 00:00:00
2014-05-29 00:00:00
2014-06-25 00:00:00
2014-07-30 00:00:00
Spreadsheet: 474143d1470661026-data-categorized-by-month-in-pivot-table-tick-multiple-boxes-responses-in-one-cell-copy-of-summerproject_excel_help
Sheet: Sheet1

# | While completing your activities, were they… | The activities were ____ to do. | Which three activities did you like the most? | Which three activities did you like the least? | What is your age group? | Comments
1 | Very enjoyable | Too difficult | A, B, D | E, F, G | 18 to 24 |  |  | 18 to 24
2 | Enjoyable | Difficult | C, E, F | A, B, D | 25 to 36 |  |  | 25 to 36
3 | Alright | Somewhat easy | G, C, A |  | 37 to 45 | Great fun! |  | 37 to 45
4 | Not so enjoyable | Easy | D, E, G | E, A, F | 45 to 64 |  |  | 45 to 64
5 | Not enjoyable | Too easy | C, A, D |  | 65+ | You could have done this better. |  | 65+
6 | Abstained | Abstained | D, A, C | A, B, E | 18 to 24 |  |  | All
 |  | All
 |  | Activity | Most Popular | Least Popular
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | I
Spreadsheet: 791435d1660332948-rag-rating-for-dates-in-different-cells-outreach-case-management-template2-eba
Sheet: Sheet1

Caseload Management |  |  |  |  |  |  | 20
Severity | Reference # | Contact Name | [NAME] | Date of last ROO contact | Service Promise met? | Exploration of Need Completed? | Safeguarding/Risk | Case review date | Next contact date/time | Contact number | Case Officer/Area | Other agencies/referrals | Notes
 |  |  |  | 09/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 03/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 04/08/2022
 |  |  |  | 04/08/2022
 |  |  |  | 08/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 05/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 09/08/2022
Spreadsheet: 176419d1345843447-running-bulk-invoice-factuur_running-print
Sheet: Factuur

Factuur nummer | Klantnummer | Datum | Omschrijving | BTW | Bedrag | Stuk nummer | Datum nummer | [NAME] | Verval datum | Factuur bedrag | BTW bedrag | Totaal bedrag
 | 4 | 2012-08-20 00:00:00 | Administratiekosten augustus | 0.19 | 100 | 1
 | 4 | 2012-08-20 00:00:00 | Test | [NAME] | 1000 | 1
 | 4 | 2012-08-20 00:00:00 | Adding | 0.06 | 100 | 1
 | 10000 | 2012-08-21 00:00:00 | Administratiekosten augustus | 0.19 | 1200 | 2
Spreadsheet: tracy_geaccone__40314__02_In-service dates
Sheet: In-Service Dates

 | NNG COMMERCIAL GROUP
 | 2002 PLAN
 | CAPITAL EXPENDITURES
 |  | Disc. or | Contract |  |  |  | Total
 |  | Non- | Term |  | In-Service |  | Project
 | Project Description | Disc. | in Years |  | Date |  | Cost
 | Discretionary Pool | D | 5 |  | 2002-11-01 00:00:00 |  | 12000000
 | [NAME] | D | 6 |  | 2002-12-31 00:00:00 |  | 4700000
 | Tall Corn Ethanol Plant | D | 6 |  | 2002-11-01 00:00:00 |  | 360000
 | Little Sioux Ethanol Plant | D | 6 |  | 2002-11-01 00:00:00 |  | 360000
 | Automate Storage Book | D | 5 |  | 2002-06-01 00:00:00 |  | 90000
 | Computer Blanket | D | 5 |  | 2002-06-30 00:00:00 |  | 120000
 | AVA Upgrade | D | 5 |  | 2002-06-01 00:00:00 |  | 20000
 | [NAME] | D | 5 |  | 2002-06-01 00:00:00 |  | 20000
 | Belleville Compression | D | 5 |  | 2002-11-01 00:00:00 |  | 2200000
 | NNG / WG TBS | D | 5 |  | 2002-11-01 00:00:00 |  | 300000
 | Exxon / Mobil | N | 10 |  | 2002-12-31 00:00:00 |  | 3500000
 | Wisconsin Gas Capital Pool | N-Rate C | 3 |  | 2002-11-01 00:00:00 |  | 300000
 | Utilicorp Priority Markets | N-Rate C | 5 |  | 2002-11-01 00:00:00 |  | 710000
 | MUD - Relocation of Omaha #1 | N | 15 |  | 2002-11-01 00:00:00 |  | 0
 | MUD - 84th Street TBS Mods | N | 15 |  | 2002-11-01 00:00:00 |  | 0
 | LaCrosse Branchline Expansion | D | 10 |  | 2002-11-01 00:00:00 |  | 110000
 | MUD - CIAC | N-Rate C | 15 |  | 2002-12-31 00:00:00 |  | 200000
 | Studies | D | 5 |  | 2002-11-01 00:00:00 |  | 300000
 | Tivoli Land Purchase | D | 4 |  | 2002-12-31 00:00:00 |  | 40000
 | Tariff Software | N | 5 |  | 2002-12-31 00:00:00 |  | 20000
 | Rate Case Software | N | 5 |  | 2002-12-31 00:00:00 |  | 110000
 | Form 567 Solftware | N | 5 |  | 2002-03-31 00:00:00 |  | 70000
 | Total 2002 Projects
Spreadsheet: benjamin_rogers__1203__Retail Shorts version Debt-Equity 60-40 version2
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Spread Option Capacity Revenue
EES Energy Revenue
ICAP |  |  | 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
Total Revenue
Expense
Expense of Serving EES Load
Fixed Operating Expenses
Insurance
SG&A
Start Charge
Property Tax |  | 400
Franchise Tax
[NAME] |  | 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
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 36134d1233904231-dummy-variables-variable
Sheet: Sheet1

Firm Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 810358d1671715781-take-and-last-dates-by-group-date-by-rev-etaf
Sheet: Main

PartNum | Rev1 | Rev2 | Rev3 | Rev4 | Rev5
100-101-039 |  | PJ02SB
100-101-041 |  | ZF0JA
100-101-058 |  | EU06SE | EU02SE
Spreadsheet: 152167d1335276586-basic-conditional-formatting-ga-exp-savings-week-of-4-8-11
Sheet: MASTER (SUM) EXP

 | [NAME] | PARTS                   (Marked up 12%) | LABOR  LOGGED | BALANCE IN  SAVINGS | TRANSFER FROM SAVINGS | BALANCE  AFTER TRANSFER
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 | Totals
Spreadsheet: 0eb13a2b-0633-4f6e-aabf-d49e01b3158f
Sheet: Sheet1

Assumptions | Unnamed: 1 | Unnamed: 2
Unit Energy Consumption (kWh/year) | Standard | ENERGY STAR
 | 65.7 | 14.235
kWh saved (Incandescent vs. ENERGY STAR CFL) | 51.465 | kWh/year
Years CFL is Active | 7.31 | years
Lifetime kWh saved | 376.20915 | kWh/year
Hourly household lighting use | 1.780821917808219 | kWh
Tree carbon sequestration | 10347 | lbs CO2/acre/year
Car emissions | 11244 | lbs CO2/car/year
CO2 emissions rate | 1.535 | lbs CO2/kWh
CO2 eliminated per bulb changed to ENERGY STAR | 577.48104525
Average number of US households | 116217422