tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 07e47710-9dfd-42f2-9431-8d812749355e
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
FMERC | Test | FMERC | [NAME] (6-MP, [NAME]) | [NAME] (6-MP, [NAME]) | High Performance Liquid Chromatography with Ultraviolet Detection (HPLC-UV) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.  Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Units:          ng/mL  [NAME] may be administered as an antineoplastic or may be present as a metabolite of the immunosuppressant drug azathioprine. Therapeutic and toxic ranges have not been established. Usual therapeutic doses of either mercaptopurine or azathioprine produce 6-mercaptopurine serum concentrations of less than 1000 ng/mL.   Test Performed By: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FMERC | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FMERC | Result | Z1190 | 6-Mercaptopurine | 6-Mercaptopurine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 181273d1347980183-if-column-a-contains-x-and-column-b-contains-date-add-column-c-expenses-modified-by-tigeravatar-
Sheet: Sheet1

Date | Employee | Total Cost |  |  |  | DW | FB | CM | JS | BD | HH | BG | KD | GC | KE | MC | CG | SM
2012-06-01 00:00:00 | KD | 187.8 |  |  | June
2012-07-24 00:00:00 | JS | 0 |  |  | July
2012-07-28 00:00:00 | JS | 0 |  |  | August
2012-07-31 00:00:00 | GC | 60 |  |  | September
2012-08-03 00:00:00 | JS | 0 |  |  | October
2012-08-05 00:00:00 | KD | 79.1 |  |  | November
2012-08-11 00:00:00 | BG | 50.4 |  |  | December
2012-08-11 00:00:00 | GC | 60 |  |  | January
2012-08-11 00:00:00 | KD | 79.1 |  |  | February
2012-08-14 00:00:00 | BG | 109.8 |  |  | March
2012-08-14 00:00:00 | JS | 0 |  |  | April
2012-08-17 00:00:00 | KD | 83.3 |  |  | May
2012-08-18 00:00:00 | BG | 82.8 |  |  | Total
2012-08-18 00:00:00 | GC | 60
2012-08-18 00:00:00 | KD | 95.19999999999999
2012-08-21 00:00:00 | BG | 60.4
2012-08-21 00:00:00 | KD | 99.39999999999999
2012-08-22 00:00:00 | GC | 60
2012-08-25 00:00:00 | GC | 60
2012-08-25 00:00:00 | JS | 0
2012-08-25 00:00:00 | KD | 104.3
2012-08-28 00:00:00 | BG | 66.8
2012-08-28 00:00:00 | JS | 0
2012-08-30 00:00:00 | GC | 60
2012-09-01 00:00:00 | BG | 114.5
2012-09-01 00:00:00 | HH | 0
2012-09-01 00:00:00 | KD | 121.1
2012-09-01 00:00:00 | KE | 0
2012-09-02 00:00:00 | KD | 86.8
2012-09-04 00:00:00 | BD | 0
2012-09-04 00:00:00 | BG | 44.7
2012-09-04 00:00:00 | DW | 0
2012-09-04 00:00:00 | HH | 0
2012-09-04 00:00:00 | KD | 93.8
2012-09-04 00:00:00 | MC | 0
2012-09-05 00:00:00 | KD | 60.2
2012-09-08 00:00:00 | BD | 0
2012-09-08 00:00:00 | BG | 74.4
2012-09-08 00:00:00 | BS | 0
2012-09-08 00:00:00 | CG | 0
2012-09-08 00:00:00 | HH | 0
2012-09-08 00:00:00 | KE | 0
2012-09-08 00:00:00 | MC | 0
2012-09-10 00:00:00 | BD | 0
2012-09-11 00:00:00 | BD | 0
2012-09-12 00:00:00 | BG | 68.8
Spreadsheet: 134776d1325627161-excel-2007-reconciliation-query-excel-2007-example
Sheet: Sheet1

 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Order # | Extended Prices | Order Date |  | Order Number | Bookings Volume | Order Date |  | Order Number | Bookings | Order Date
WW0329 | 14802.12 | 2011-04-04 15:47:28 |  | WW0329 | 14802.12 | 2011-04-04 00:00:00 |  | WW0316 | 1500 | 2Qtr 2011
WW0330 | 1599.12 | 2011-04-06 15:18:37 |  | WW0330 | 12406.14 | 2011-04-06 00:00:00 |  | WW0325 | 649 | 2Qtr 2011
WW0330 | 10807.02 | 2011-04-06 15:18:37 |  | WW0331 | 175 | 2011-04-08 00:00:00 |  | WW0329 | 14802 | 2Qtr 2011
WW0331 | 175 | 2011-04-08 17:21:23 |  | WW0332 | 2180 | 2011-04-14 00:00:00 |  | WW0330 | 12406 | 2Qtr 2011
WW0332 | 1090 | 2011-04-14 11:04:46 |  | WW0333 | 31339 | 2011-04-14 00:00:00 |  | WW0331 | 175 | 2Qtr 2011
WW0332 | 1090 | 2011-04-14 11:04:46 |  | WW0334 | 109000 | 2011-04-14 00:00:00 |  | WW0332 | 2180 | 2Qtr 2011
WW0333 | 13584 | 2011-04-14 11:32:55 |  | WW0334 | 21900 | 2011-04-14 00:00:00 |  | WW0333 | 31339 | 2Qtr 2011
WW0333 | 15720 | 2011-04-14 11:32:55 |  | WW0335 | 2010 | 2011-04-15 00:00:00 |  | WW0334 | 36000 | 2Qtr 2011
WW0333 | 2035 | 2011-04-14 11:32:55 |  | WW0337 | 10856 | 2011-04-19 00:00:00 |  | WW0334 | 4000 | 2Qtr 2011
WW0334 | 33000 | 2011-04-14 14:20:43 |  | WW0338 | 11424 | 2011-04-19 00:00:00 |  | WW0335 | 1000 | 2Qtr 2011
WW0334 | 28400 | 2011-04-14 14:20:43 |  | WW0339 | 6834.96 | 2011-04-20 00:00:00 |  | WW0337 | 10856 | 2Qtr 2011
WW0334 | 32700 | 2011-04-14 14:20:43 |  | WW0340 | 10807.02 | 2011-04-26 00:00:00 |  | WW0338 | 4000 | 2Qtr 2011
WW0334 | 14900 | 2011-04-14 14:20:43 |  | WW0341 | 116400 | 2011-04-26 00:00:00 |  | WW0339 | 2100 | 2Qtr 2011
WW0334 | 21900 | 2011-04-14 14:20:43 |  | WW0342 | 4904 | 2011-04-27 00:00:00 |  | WW0340 | 4000 | 2Qtr 2011
WW0335 | 2010 | 2011-04-15 11:54:50 |  | WW0344 | 167098.96 | 2011-04-28 00:00:00 |  | WW0341 | 36000 | 2Qtr 2011
WW0337 | 10856 | 2011-04-19 16:24:02 |  | WW0345 | 38408.7 | 2011-05-03 00:00:00 |  | WW0342 | 1400 | 2Qtr 2011
Spreadsheet: 708328d1607723797-waybill-puzzle-max-weight-total-lbs-to-max-150-carry-over-remainder-and-repeat-waybill-puzzle_solver
Sheet: Solv_setup1

Item | Qty | Lbs | Total lbs | [NAME] lbs |  | What I want it to have my formulate produce as the end result
 |  |  |  | 150 |  | Waybill 1 | Waybill 2 | Waybill 3
Clear ziplock baggies | 1 | 40 |  |  |  | 0 | 0 | 1 |  | = | 1
baggies tie close | 2 | 40 |  |  |  | 0 | 0 | 1
cans | 2 | 17 |  |  |  | 0 | 1 | 0
Sterile water | 8 | 15 |  |  |  | 1 | 0 | 0
Swabs | 2 | 6 |  |  |  | 0 | 1 | 0
Spoons | 8 | 6 |  |  |  | 0 | 1 | 0
Straps | 3 | 3 |  |  |  | 1 | 0 | 0
dowels | 1 | 2 |  |  |  | 0 | 0 | 1
blister pacsk | 1 | 1 |  |  |  | 0 | 1 | 0
screens | 2 | 1 |  |  |  | 0 | 1 | 0
Straws | 1 | 0.5 |  |  |  | 1 | 0 | 0
 |  |  |  |  | Total lbs
 |  |  |  |  |  | =< | =< | =<
 |  |  |  |  |  | 150 | 150 | 150
Spreadsheet: 234511d1368115393-golf-analysis-spreadsheet-help-squire82-2020130507-20v2-1-
Sheet: May Medal

Weather | S, W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Approach
Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total |  |  | 1 | Hk | -
Par | 3 | 4 | 3 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 3 | 4 |  |  |  | 2 | Pu | St
Score | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 6 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 3 | Pu | -
FH |  | 1 |  | 0 | 1 | 0 |  | 1 | 1 | 0 |  |  |  | 1 | 1 | 0 |  | 1 |  |  |  | 4 | Hk | St
GIR | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  |  | 5 | Hk | St
Putts | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 |  |  |  | 6 | St | Sh
Chip | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |  |  |  | 7 | St | -
Pitch | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  | 8 | Hk | Hk
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 9 | St | St
U&D |  |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Hk | LU
Penalty | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 11 | St | -
[NAME] | D | D | 4 | D | 4 | D | P | D | D | D | 5 | 6 | 5w | 5w | 3w | D | 9 | 3w |  |  |  | 12 | St | -
Approach |  | S |  | 5w | L | 5w |  | 5 | 8 | 7 |  |  |  | P | L | S |  | L |  |  |  | 13 | Hk | -
0 - 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 2 | 1 |  |  |  | 14 | St | Sh
6 -10 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  | 15 | St | St
11 - 20 |  | 1 |  |  |  |  | 1 |  | 1 |  | 1 | 1 |  |  | 1 |  |  | 1 |  |  |  | 16 | St | St
21+ |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 17 | St | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | St | St
Missed Green Analysis |  |  |  |  |  |  | GIR Analysis |  |  |  |  |  |  | Club Analysis
Shot |  | No. | Tot Putts |  | U&D |  | Below Par |  |  |  |  |  |  | Club |  | Tot. Shots |  | Tee Shots |  | Fairway | Green | Approach | Green
Chip |  |  |  |  |  |  | At Par |  |  |  |  |  |  | D
Pitch |  |  |  |  |  |  | Above Par |  |  |  |  |  |  | 3w
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 5w
 |  |  |  |  |  |  | Par Performance |  |  |  |  |  |  | 4
Putting Analysis |  |  |  |  |  |  | Par 3 |  |  |  |  |  |  | 5
Putts |  |  |  |  |  |  | Par 3 avg |  |  |  |  |  |  | 6
Putts per hole |  |  |  |  |  |  | Par 4 |  |  |  |  |  |  | 7
% of shots |  |  |  |  |  |  | Par 4 avg |  |  |  |  |  |  | 8
GIR avg |  |  |  |  |  |  | Birdies |  |  |  |  |  |  | 9
Missed GIR avg |  |  |  |  |  |  | Pars |  |  |  |  |  |  | P
[NAME] par 3 |  |  |  |  |  |  | Bogeys |  |  |  |  |  |  | S
[NAME] par 4 |  |  |  |  |  |  | Double Bogeys |  |  |  |  |  |  | L
[NAME] 6 - 10 ft |  |  |  |  |  |  | Front 9 - Par 3 |  |  |  |  |  |  | X
[NAME] 11 - 20 ft |  |  |  |  |  |  | Front 9 - Par 4
[NAME] 21+ ft |  |  |  |  |  |  | Back 9 - Par 3
 |  |  |  |  |  |  | Back 9 - Par 4
Spreadsheet: 876436d1723119488-count-the-occurance-from-a-cell-if-it-meets-2-criteria-book1
Sheet: Sheet1

 |  | Desired results |  |  | Concrete / Stone Surround | Pipe Diameter / Size |  | Length
 |  | 150 |  |  | Stone | 1200 |  | 49.5
 |  | 225 | 9.1 |  | Stone | 1200 |  | 39.7
 |  | 300 |  |  | Stone | 1200 |  | 33.5
 |  | 375 |  |  | Stone | 1200 |  | 51.75
 |  | 450 | 55.8 |  | Stone | 900 |  | 15.7
 |  | 525 |  |  | Concrete | 450 |  | 48
 |  | 600 |  |  | Stone | 1200 |  | 10
 |  | 675 |  |  | Concrete | 900 |  | 10.5
 |  | 750 |  |  | Stone | 1200 |  | 28.8
 |  | 800 |  |  | Stone | 1200 |  | 34
 |  | 825 |  |  | Stone | 1200 |  | 25.75
 |  | 900 | 10.5 |  | Stone | 1200 |  | 24
 |  | 1050 |  |  | Stone | 1200 |  | 23
 |  | 1200 | 14.2 |  | Stone | 1200 |  | 39.3
 |  | 1350 |  |  | Stone | 1200 |  | 13.5
 |  | 1400 |  |  | Stone | 1200 |  | 20.8
 |  | 1500 |  |  | Stone | 1200 |  | 6.5
 |  | 1600 |  |  | Concrete | 1200 |  | 14.2
 |  | 1650 |  |  | Stone | 1200 |  | 16
 |  | 1800 |  |  | Stone | 1200 |  | 18.5
 |  | 1950 |  |  | Stone | 1200 |  | 18
 |  | 2000 |  |  | Stone | 1200 |  | 43.5
 |  | 2100 |  |  | Concrete | 450 |  | 7.8
 |  | 2200 |  |  | Concrete | 225 |  | 3.6
 |  | 2250 |  |  | Concrete | 225 |  | 5.5
 |  | 2400 |  |  | Stone | 1200 |  | 26.6
Spreadsheet: 258793d1376854846-adult-baseball-league-schedule-2013fall-schedule-1-
Sheet: MUDCATS

Game # | week # | Visitors | Home | Field
2 | 1 | SENATORS | MUDCATS | CCC
6 | 2 | MUDCATS | BYE
10 | 2 | MUDCATS | REDWINGS | [NAME]
14 | 3 | REDWINGS | MUDCATS | CCC
16 | 3 | MUDCATS | SENATORS | [NAME]
21 | 4 | MUDCATS | SEADOGS | GHS
24 | 5 | BAYSOX | MUDCATS | CCC
35 | 6 | TBD | MUDCATS | [NAME]
31 | 6 | MUDCATS | KEYS | CCC
38 | 7 | TIGERS | MUDCATS | CCC
Spreadsheet: 78092d1278521989-extracting-values-greater-than-0-extracting-values
Sheet: All States

All States | State | Sales %
 | AL | 0.36
 | AK | 0.16
 | AZ | 0.2
 | AR | 0.28
 | CA | 0
 | CO | 0
 | CT | 0
 | DE | 0
 | FL | 0
 | GA | 0
 | HI | 0
 | ID | 0
 | IL | 0
 | IN | 0
 | IA | 0
 | KS | 0
 | KY | 0
 | LA | 0
 | ME | 0
 | MD | 0
 | MA | 0
 | MI | 0
 | MN | 0
 | MS | 0
 | MO | 0
 | MT | 0
 | NE | 0
 | NV | 0
 | NH | 0
 | NJ | 0
 | NM | 0
 | NY | 0
 | NC | 0
 | ND | 0
 | OH | 0
 | OK | 0
 | OR | 0
 | PA | 0
 | RI | 0
 | SC | 0
 | SD | 0
 | TN | 0
 | TX | 0
 | UT | 0
 | VT | 0
 | VA | 0
 | WA | 0
 | WV | 0
 | WI | 0
 | WY | 0
Spreadsheet: 81651d1281768341-how-to-enter-a-vlookup-function-with-vba-fgin-auto-test
Sheet: DATA

Dispatch List | Invoice List | Products
1 | a | z
2 | b | ab
3 | c | cd
4 | c | ef
5 | c | gh
6 | c | ij
7 | c | kl
8 | c | mn
9 | c
10 | d
11 | e
12 | f
13 | g
14 | h
15 | i
16 | j
17 | j
18 | j
19 | j
20 | j
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: ARUBA-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 15465468 | 41679437
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 21293649 | 55351498
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 36759117 | 97030935
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -8950787 | -23395546 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -28092979 | -73058872
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 290458 | 748647
 | Total Purchases: |  | -36753308 | -95705771
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -5809 | -15213.28946497151
 |  |  | 0 | 0
23 | Fuel: |  | -290458 | -748647
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -144172
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -144172
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 8290600.942900002
31 |  | Prior Month Book Balance | 0 | -12262546
 |  | Total MTM Income | 0 | -3971945.057099998
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 3159746.0571
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 46882
 |  | TOTAL INTRA-MTH
Spreadsheet: tracy_geaccone__40550__capcharge
Sheet: Capital Charge Template

BUSINESS UNIT NAME
2001 - 2003 OPERATING PLAN
CAPITAL CHARGE CALCULATION
(Millions of Dollars)
 |  |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL
Theoretical Debt at 12/31/00:
 | Equity (A) |  | 0
 | Third Party Debt (B) |  | 0
 | Net Intercompany balance (C) |  | 0
 |  | Total Capital
 | Theoretical [NAME] |  | 0
Theoretical Debt Balance - Beginning of Month
(Increase)/Decrease In Cash Required (D) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Theoretical Debt %
Theoretical Debt Portion of Monthly Cash Flow
Total Theoretical Debt Balance
Interest Rate (7.5% annual) |  |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625
Total Capital Charge
Adjustments
 | Third Party Interest Income/(Expense) (E) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Intercompany Interest Income/(Expense) (F) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Capital Charge booked by Corporate
 | (A) | Hyperion line TOT_SHARE-EQU less line 0948 (CTA)
 | (B) | Hyperion line TOT_OTH_LT_DEBT and TOT_NP_OTHER
 | (C) | Hyperion lines: 0051, 0052, 0037, 0038, 0218, 0486, 0516, 0517, 0660
 |  | 0661, 0878, 0901, 0915, 0936, 0941
 | (D) | Cash is defined as the change in all intercompany accounts (see C)
 | (E) | Hyperion lines 1615, 1679, 1750, 1719, 1710, 1722, 1730, 1735, 1755, 1725
 | (F) | Hyperion lines 1605, 1681, 1713, 1751, 1736, 1738
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 162000 | 164214
2 | 165112 | 164214
3 | 166252 | 167214
4 | 159596 | 159052
5 | 151508 | 151275
6 | 111224 | 110803
7 | 147182 | 147214
8 | 148253 | 147214
9 | 142380 | 142638
10 | 146106 | 146975
11 | 157270 | 157014
12 | 157058 | 157014
13 | 157082 | 157014
14 | 146041 | 145920
15 | 151778 | 149946
16 | 144193 | 142114
17 | 120202 | 117223
18 | 111013 | 109963
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 0
2001-07-18 00:00:00
Spreadsheet: 817590d1676340770-calculating-payment-due-dates-automatically-subscription-tracker
Sheet: Interface

 | Service details |  |  | Billing period |  |  |  |  |  | Context
 | Subscription | Date commenced | Payment Next Due | QTY | Unit |  |  |  |  | 1 | The date as of me creating this is 14 Feb 23.
 | Spotify | 2019-12-18 00:00:00 | 2023-12-18 00:00:00 | 3 | y |  |  |  |  | 2 | The cells that are highlighted orange are user input. (Column B, C, E, F)
 | ExpressVPN | 2022-04-19 00:00:00 | 2023-02-19 00:00:00 | 3 | m |  |  |  |  | 3 | The cells that are white with orange text are automatic calculations. (Column D)
 | Hulu | 2021-07-21 00:00:00 | 2023-02-21 00:00:00 | 1 | m |  |  |  |  | 4 | Column D (Payment Next Due) needs to update every time the previous due date has passed.
 | [NAME] | 2021-08-07 00:00:00 | 2023-02-18 00:00:00 | 1 | w |  |  |  |  | 5 | Cell [NAME] is left blank to provide space for solution.
 | Amazon Prime | 2021-06-04 00:00:00 | 2023-02-15 00:00:00 | 1 | d |  |  |  |  | 6 | Problem: How do I create the auto-calculations for column D? Thank you for your time.
 | MasterClass | 2022-05-15 00:00:00 | 2023-04-15 00:00:00 | 1 | q
 | Tidal | 2020-06-06 00:00:00 | 2023-04-06 00:00:00 | 2 | q
 | Apple Music | 2021-11-09 00:00:00 | 2023-11-09 00:00:00 | 1 | y
 | HubSpot | 2022-08-16 00:00:00 | 2023-02-16 00:00:00 | 1 | m
 | Zenefits | 2020-07-22 00:00:00 | 2023-02-22 00:00:00 | 1 | m
 | Disney+ | 2023-01-06 00:00:00 | 2023-02-17 00:00:00 | 1 | w
 | Audible | 2022-04-26 00:00:00 | 2023-02-15 00:00:00 | 1 | d
 | GrandBox | 2021-11-11 00:00:00 | 2023-04-11 00:00:00 | 1 | q
 | Kindle Direct | 2021-02-11 00:00:00 | 2023-04-11 00:00:00 | 1 | q
 | Netflix | 2022-01-09 00:00:00 | 2023-01-09 00:00:00 | 1 | y
 | [NAME] | 2022-05-26 00:00:00 |  | 1 | m
Spreadsheet: 776138d1649522235-using-eomonth-fuel-calculations-temp-2-bsb-
Sheet:  B Co-op EDF July 17-18

DATE | R | DAY | NIGHT | Gas | Elec High | Elec Low | Gas | Total | % Night | Coop |  |  | Estimated 2017-18 |  | Total | Actual 2016-17 |  | Total
 |  |  |  |  | Yr-Projected > |  |  |  |  |  | T |  | Elec | Gas |  | Elec | Gas
2017-07-26 00:00:00 | A | 29787 | 24530 | 2830 |  |  |  | Averages |  |  | E7 |  |  |  |  | 3999 | 518
 | A | 29829 | 24558 | 2832 |  |  |  |  |  | E7 Day Rate |  |  |  |  |  | 573 | 579
 | E | 29869 | 24579 | 2835 |  |  |  |  |  | 0.134
 | A | 29903 | 24605 | 2837 |  |  |  |  |  | E7 Night Rate
 | E |  |  | 2841 |  |  |  |  |  | 0.094
 | A | 29979 | 24649 | 2843 |  |  |  |  |  | E7 SC
 | A | 30011 | 24668 | 2845 |  |  |  |  |  | 0.205
 | A | 30054 | 24689 | 2848 |  |  |  |  |  | Totaliser Rate
 | E | 30090 | 24708 | 2850 |  |  |  |  |  | 0.127
 | A | 30123 | 24729 | 2853 |  |  |  |  |  | Totaliser SC
 | A | 30163 | 24748 | 2859 |  |  |  |  |  | 0.205
 | A | 30211 | 24773 | 2866 |  |  |  |  |  | Gas Rate
 | E | 30261 | 24796 | 2872 |  |  |  |  |  | 0.0264
 | A | 30310 | 24824 | 2878 |  |  |  |  |  | Gas SC
 | L | 30361 | 24848 | 2887 |  |  |  |  |  | 0.151
 | A | 30398 | 24869 | 2899
 | A | 30439 | 24896 | 2915
 | A | 30481 | 24922 | 2929
 | E | 30528 | 24947 | 2948
 | A | 30578 | 24971 | 2967
 | E | 30618 | 25000 | 2989
 | A | 30658 | 25029 | 3011
 | A | 30713 | 25057 | 3027
 | E | 30770 | 25089 | 3047
 | A | 30828 | 25121 | 3067
 | A | 30879 | 25147 | 3086
 | E | 30929 | 25175 | 3105
 | A | 30987 | 25204 | 3124
 | A | 31033 | 25229 | 3146
 | L | 31094 | 25256 | 3169
 | A | 31140 | 25284 | 3186
 | A | 31187 | 25309 | 3211
 | A | 31237 | 25334 | 3236
 | E | 31297 | 25357 | 3256
 | A | 31354 | 25381 | 3276
 | E | 31405 | 25408 | 3292
 | A | 31454 | 25434 | 3307
 | E | 31506 | 25459 | 3317
 | E | 31558 | 25484 | 3326
 | E | 31610 | 25509 | 3336
 | A | 31663 | 25536 | 3346
Spreadsheet: mark_taylor__24964__methanol plant allowances DERCs ERCs
Sheet: NOxAllowances

NOx Emission Allowances for Methanol Plant |  |  |  | Final Regulations 9/26/01
 | Allowances (tons/yr of NOx)
Emission Unit | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
Reformer | 101.4 | 101.4 |  |  |  |  | 13.5
Engine 101A | 586.7 | 586.7 |  |  |  |  | 20.7
Engine 101B | 982.2 | 982.2 |  |  |  |  | 21.7
Engine 101C | 860.6 | 860.6 |  |  |  |  | 20.3 |  |  |  |  |  | 0.598 | 0.75 | 0.945 | 1
Total |  |  |  |  |  |  |  |  |  |  |  | 101.39 | 101.39 | 101.39 | 101.39 | 101.39
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.598 | 0.75 | 0.945 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 101.39 | 101.39 | 101.39 | 101.39 | 101.39
 |  |  |  |  |  |  |  |  |  |  |  | 2714600 | 2714600 | 2714600 | 2714600 | 2714600
 |  |  |  |  |  |  |  |  |  |  |  | 907184.74 | 907184.74 | 907184.74 | 907184.74 | 907184.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.598 | 0.75 | 0.945 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 39348833.33 | 39348833.33 | 39348833.33 | 39348833.33 | 39348833.33
 |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 907184.74 | 907184.74 | 907184.74 | 907184.74 | 907184.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.598 | 0.75 | 0.945 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 36810000 | 36810000 | 36810000 | 36810000 | 36810000
 |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 907184.74 | 907184.74 | 907184.74 | 907184.74 | 907184.74
Spreadsheet: tracy_geaccone__40587__CostReportingPilot1
Sheet: Operating Details

 |  |  |  |  | Month | Jul |  | Year | 2000
 |  |  |  |  |  | Aug |  |  | 2001
 |  |  |  |  |  | Sep |  |  | 2002
 |  |  |  |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Plan | Plan | Plan | Plan | Plan
 |  | Operating Cost Data |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | Total
 |  | People
 |  |  | Salaries and Wages
 |  |  |  | 52000500 | Salaries and Wages
 |  |  |  | 52505000 | Directors Fees
 |  |  |  | 82100002 | Const Mgmt
 |  |  |  | 82100009 | [NAME] Assistant
 |  |  | Benefits
 |  |  | Payroll Taxes
 |  | Employee Expense
 |  | Office
 |  | Outside  Services
 |  | Technology
 |  | Depreciation
 |  | Other
 |  |  | Gross
 |  | Capitalized / Deferred
 |  |  | Net
 |  | Allocations Out
 |  |  | Total After Allocations