tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: November 1

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 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 | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 |  |  |  | V | V | V | V |  |  |  |  |  |  | V |  |  | s | s |  | p |  | s | s | p | p | p |  |  | p
 |  |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  | v |  | V | V | V
 |  |  |  | P | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s |  |  |  | s | s | s | s | s | S
 |  |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 |  | v | v | v |  |  |  |  |  |  |  |  |  | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | V
 |  |  |  |  |  | v
Spreadsheet: 699794d1602770668-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-ledger-example
Sheet: Checking Account

Due Date | Checking Account Activity | Debit/Credit | Ref #
January
2020-01-01 00:00:00 | Mortgage | -1000 | 1
2020-01-01 00:00:00 | Electric | -200 | 2
2020-01-05 00:00:00 | Gas | -75 | 3
2020-01-15 00:00:00 | Phone | -50 | 4
2020-01-17 00:00:00 | [NAME] | -8 | 8
2020-01-20 00:00:00 | Cable | -100 | 5
2020-01-21 00:00:00 | Dining Out | -50 | 6
February
2020-02-01 00:00:00 | Mortgage | -1000 | 1
2020-02-01 00:00:00 | Electric | -200 | 2
2020-02-05 00:00:00 | Gas | -75 | 3
2020-02-15 00:00:00 | Phone | -50 | 4
2020-02-16 00:00:00 | [NAME] | -8 | 8
2020-02-20 00:00:00 | Cable | -100 | 5
2020-02-27 00:00:00 | Dining Out |  | 6
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: July

Date | Sales
2022-07-01 00:00:00 | 1
2022-07-02 00:00:00 | 1
2022-07-03 00:00:00 | 1
2022-07-04 00:00:00 | 1
2022-07-05 00:00:00 | 1
2022-07-06 00:00:00 | 1
2022-07-07 00:00:00 | 1
2022-07-08 00:00:00 | 1
2022-07-09 00:00:00 | 1
2022-07-10 00:00:00 | 1
2022-07-11 00:00:00 | 1
2022-07-12 00:00:00 | 1
2022-07-13 00:00:00 | 1
2022-07-14 00:00:00 | 1
2022-07-15 00:00:00 | 1
2022-07-16 00:00:00 | 1
2022-07-17 00:00:00 | 1
2022-07-18 00:00:00 | 1
2022-07-19 00:00:00 | 1
2022-07-20 00:00:00 | 1
2022-07-21 00:00:00 | 1
2022-07-22 00:00:00 | 1
2022-07-23 00:00:00 | 1
2022-07-24 00:00:00 | 1
2022-07-25 00:00:00 | 1
2022-07-26 00:00:00 | 1
2022-07-27 00:00:00 | 1
2022-07-28 00:00:00 | 1
2022-07-29 00:00:00 | 1
2022-07-30 00:00:00 | 1
2022-07-31 00:00:00 | 1
Spreadsheet: 161140d1339427267-calculating-expansion-sales-gyro-check
Sheet: Franchise Model

FRANCHISED INCOME STATEMENT
ASSUMPTIONS BELOW |  |  |  |  |  |  | FY1 |  |  |  |  |  |  | Based on 100% Growth
 | January | February | March | April | May | June | July | August | September | October | November | December | FYE 1 | FYE 2 | FYE 3
Number of Stores | 1 | 1 | 2 |  |  |  |  |  |  |  |  |  | 41 | 82 | 164
Revenue
Franchise Fee
Management Services Fee
Marketing Services Fee
Renewal Fee?
Special Services Fee (bookkeeping, taxes, etc.)
Total Revenue
Store Sales
Sales
Sales - Food
Sales  - Other
Total Sales
Cost of Goods Sold
Total Cost of Goods Sold
Gross Profit
Operating Expenses
Labor
Rent Expense | 13595.13 | 10266.35 | 10571.67 | 10489.01 | 6984.27 | 9314.46 | 10488.99 | 10854.92 | 12061.5 | 13707.17 | 14549.76 | 15631.73
Advertising | 5011.25 | 312.7 | 63.14 | 1065.53 | 2632.77 | 314.69 | 1425.28 | 779.35 | 1470.78 | 1675.57 | 701.9499999999999 | 555.38
Credit Card Processing Fees | 8680.64 | 2229.21 | 2468.54 | 3246.91 | 3061.7 | 2906.17 | 3142.81 | 2999.26 | 3503.49 | 3609.45 | 3514.27 | 2880.24
Insurance | 7308.08 | 3977.89 | 0 | 0 | 3283.13 | 0 | 4064 | 0 | 1081 | 0 | 0 | 475.58
Legal & Accounting | 3368 | 400 | 400 | 400 | 400 | 2470 | 400 | 1248.9 | 1170 | 1430 | 800 | 800
Licensing Fees & Permits
Misc. Expense
Repairs & Maintenance | 46888.09 | 1601.11 | 240.09 | 2089.26 | 1411.78 | 3097.53 | 243.13 | 4970.969999999999 | 2904.93 | 4103.76 | 5270.41 | 2695.03
Supplies
Utilities & Telephone
Total Operating Expenses
Operating Income (Loss)
Operating Margin (EBITDA)
Other Income (Expense)
Other Income | 0 | 3981.38 | 3638.28 | 4075 | 4279 | 4425.5 | 4817.37 | 5145.610000000001 | 5484.92 | 6204.5 | 6083.909999999999 | 5862.22
Depreciation | -74645.52 | -5272.46 | -5272.46 | -5272.46 | -5272.46 | -5272.46 | -16791.01 | -16791.01 | -63929.57 | -64330.03 | -64330.03 | -64330.03
Amortization | -59.72 | -29.86 | -29.86 | -29.86 | -29.86 | -29.86 | -101.62 | -101.62 | -115.35 | -115.35 | -115.35 | -115.35
Total Other Income (Expense)
Net Income (Loss)
Less Noncash Charges
Net Cash Margin
Average Margin (less Dec.)
Assumptions
Franchise Growth (monthly) | 0.4
Franchise Fee | 35000
Management Services Fee | 0.07
Marketing Services Fee | 0.02
Special Services Fee (bookkeeping, taxes, etc.) | 0.01
Same Store Sales Growth
First Month's Sales
Second Month Sales
Third Month Sales | 43280
Average Annual Sales | 670000
 |  |  | 900-1500 sq ft
 |  |  | $620-720k annually
Spreadsheet: 492459d1481108402-macro-to-filter-on-unwanted-data-and-delete-fruit
Sheet: Fruit

Fruit | Code
Apples | 1
Bananas | 2
Plums | 3
Grapes | 45
Pears | 56
[NAME]'s | 23
Pineapples | 45
[NAME]'s | 232
[NAME]'s | 2
Apples | 3
Bananas | 45
Plums | 56
Grapes | 23
Pears | 2
[NAME]'s | 3
Pineapples | 45
[NAME]'s | 56
[NAME]'s | 23
Apples | 4242
Bananas | 2
Plums | 3
Grapes | 335
Pears | 4
[NAME]'s | 23
Pineapples | 2424
[NAME]'s | 2432
[NAME]'s | 445
[NAME]'s | 2
[NAME]'s | 3
Apples | 45
Bananas | 56
Plums | 23
Grapes | 6666
Spreadsheet: 818980d1677154909-sorting-unique-array-by-year-and-month-sort_unique
Sheet: Data

 | Created |  |  |  | Merged
 | 2022-01-31 16:44:16 |  |  |  | 2022-01-01 00:00:00
 | 2022-01-31 17:04:23 |  |  |  | 2022-02-01 00:00:00
 | 2022-02-24 17:35:51 |  |  |  | 2022-03-01 00:00:00
 | 2022-03-11 13:36:05 |  |  |  | 2022-04-01 00:00:00
 | 2022-04-05 10:26:59 |  |  |  | 2022-05-01 00:00:00
 | 2022-07-12 06:57:05 |  |  |  | 2022-06-01 00:00:00
 | 2022-08-23 10:03:47 |  |  |  | 2022-07-01 00:00:00
 | 2022-09-02 16:28:16 |  |  |  | 2022-08-01 00:00:00
 | 2022-09-02 17:14:05 |  |  |  | 2022-09-01 00:00:00
 | 2022-09-08 10:00:03 |  |  |  | 2022-10-01 00:00:00
 | 2022-10-04 09:37:55 |  |  |  | 2022-11-01 00:00:00
 | 2022-10-06 10:22:24 |  |  |  | 2022-12-01 00:00:00
 | 2022-10-07 07:56:52 |  |  |  | 2023-01-01 00:00:00
 | 2022-10-14 13:20:29 |  |  |  | 2023-02-01 00:00:00
 | 2022-10-26 11:27:23
 | 2022-10-28 17:49:03
 | 2022-11-07 09:15:02
 | 2022-11-10 10:10:06
 | 2022-11-11 13:34:46
 | 2022-11-24 15:16:08
 | 2023-01-31 15:32:08
 | 2023-02-17 08:30:08
 | 2023-02-21 12:10:33
 | 2022-05-20 14:33:46
 | 2022-06-24 09:29:10
 | 2022-07-22 11:13:51
 | 2022-07-29 10:42:34
 | 2022-08-05 10:36:45
 | 2022-08-11 09:34:26
 | 2022-08-12 11:57:27
 | 2022-09-02 13:41:24
 | 2022-09-12 08:56:41
 | 2022-09-19 10:44:52
 | 2022-09-30 14:32:01
 | 2022-10-04 17:29:28
 | 2022-10-06 08:03:51
 | 2022-11-08 16:31:04
 | 2022-11-10 11:20:10
 | 2022-12-01 10:18:19
 | 2023-01-18 13:57:54
 | 2023-01-18 13:59:32
 | 2023-01-23 13:58:14
 | 2023-01-24 10:21:43
 | 2023-02-01 14:39:37
Spreadsheet: 789045d1658859392-formula-to-find-last-date-in-col-a-where-there-is-a-value-in-col-b-formula-to-find-last-date-in-col-a-where-there-is-a-value-in-col-b
Sheet: Sheet1

Month | Amount
2021-10-01 00:00:00 | 1942.98
 | 2322.19
 | 2651.5
 | 2268.01
 | 1967.53
 | 2018.54
 | 2169.65
 | 1951.16
 | 2307.49
 | 2153.25
Total
Spreadsheet: 778941d1651478578-link-two-different-tables-together-over-1-code-that-exists-in-both-tables-find-codes-aligw
Sheet: Table 1

Company | Person | Code 1 | Code 2
BBC | Smith | 1789925518 | 123456789012
CBB | [NAME] | 1789925519 | 123456789789
[NAME] | [NAME] | 1789925520 | 123456789890
LAS | [NAME] | 1789925521 | 123456789567
Spreadsheet: 147274d1332688715-excel-2007-copy-data-itself-into-another-sheet-once-entered-polymer-workbook-rough
Sheet: PE

Grade : Hostalen GM 9350 C
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lucalen A 2540 D
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lucalen A 2700 H
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lucalen A 2920 M
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lucalen A 2700 M
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lupolen 2420 H
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lupolen 4261 A SW 63200
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lupolen 4261 AG
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lupolen 4261 AG BD
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lupolen 4261 A IM
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Grade : Lupolen 4261 A IMBD
Sr. No. | PO Date | Month | Customer Name | Contact Person | Qty
 |  |  |  | Total | 0
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 17

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD |  | 0 |  | 38895 |  | 38895
 | Dividend |  | 9020 |  | 9739 |  | 18759
 | Equity Swap |  | 257858 |  | 724668 |  | 982526
 | Portfolio |  | 33309 |  | 419316 |  | 452625
 | [NAME] |  | 1984 |  | 1974 |  | 3958
Option | Accumulator/Decumulator |  | 2177 |  | 14111 |  | 16288
 | Vanilla (put/call) |  | 1195275 |  | 2064403 |  | 3259678
 | [NAME]
Forward | Vanilla
Exotic
Structured Products |  |  | 167519 |  | 934615 |  | 1102134
TOTAL |  | N/A**** | 1667143 | N/A | 4207722 | N/A | 5874865
Estimated gross notional amount outstanding, September 30 monthly snapshot, by product, participant type, and cleared status (millions of USD). Data are adjusted for double-counting of inter-broker trades to show a single exposure for each trade.
Data for the equity asset class are currently made available to the Commission on a monthly basis, and the Swaps by Asset Class tables in this proposed version of the CFTC Swaps Report will thus be published with an effective delay of up to one month.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for particpant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 858321d1707051677-pivot-table-formula-not-summarizing-correct-pivot-formula-copy3
Sheet: Ark3

Lønnsart | Fast lønn
Bruker | [NAME] | Summer av Antall timer | Gjennomsnitt av Timelønn | Summer av Felt5
123 Test person | 22923 | 132 | 466.2600000000002 | 1907935.920000001
 | 30004 | 917.5 | 466.2600000000004 | 62457858.30000006
 | 30007 | 77.5 | 466.2600000000002 | 505892.1000000002
 | 31119 | 45 | 466.2600000000002 | 230798.7000000001
 | 8004 | 16 | 466.26 | 14920.32
123 Test person Totalt |  | 1188 | 466.2599999999989 | 112999043.5199997
Totalsum |  | 1188 | 466.2599999999989 | 112999043.5199997
Spreadsheet: 862104d1709872604-help-excel-formula-ideas-needed-formula-help-excel
Sheet: Sheet3

Store ID No. | Store ID Name | # of Customers | # of Employees | Other Store ID No. within 10 min. proximity of Store in Column B
1 | Houston
2 | Los Angeles
3 | Tampa Bay
Spreadsheet: 17522e05-a6bc-4329-82e8-db8d1e3c8086
Sheet: Sheet1

Property Crime | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 193.1969149682706 | 290.6161751878191 | 91.0373478345937
13-14 | 2807.904250555096 | 3996.287112848272 | 1559.858835825216
15 | 3948.015497237654 | 5775.453235057375 | 2022.251370159144
16 | 4114.120371648246 | 6125.54590145932 | 1981.245705341635
17 | 3819.003214275062 | 5774.810104704059 | 1736.832843764797
18 | 3474.627707446399 | 5347.238622379739 | 1505.775144100235
19 | 2675.428264293366 | 4058.062877821277 | 1233.606444135569
20 | 2113.849771829879 | 3128.001155364724 | 1055.250053336277
21 | 1837.333056766229 | 2696.593300379546 | 940.5329825570884
22 | 1672.336523264307 | 2420.127804362347 | 898.6552684011374
23 | 1558.233382972792 | 2228.823220470759 | 867.0435298557622
24 | 1476.054552866749 | 2102.30593351317 | 833.2567278137318
25-29 | 1340.759615262515 | 1921.962444399393 | 755.2551411239484
30-34 | 1105.789223381781 | 1601.340542351447 | 612.9640973391872
35-39 | 829.2730825373887 | 1221.477422460023 | 441.3906868289731
40-44 | 540.4136434019912 | 804.259374331949 | 282.8411053233498
45-49 | 328.0802708784727 | 473.8260387147968 | 187.5847606185098
50-54 | 214.9552611983788 | 303.4666926664222 | 131.2071160714247
55-59 | 141.9435486933705 | 188.8444149628822 | 98.73076166585066
60-64 | 99.39333331009573 | 128.2078542211297 | 73.90448962451053
65 and over | 51.66512845914267 | 76.23308253143527 | 34.91532663122397
Spreadsheet: 0d627491-db24-4b02-8472-6c73520302ea
Sheet: Reasons at FRCC

Survey of all Currently enrolled students Fall 2013 -- Reasons for choosing FRCC
How did you hear about FRCC (Multiple answers) | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Onl |  | Larimer |  | FRCC Onl |  | Westminster |  | Total
Spreadsheet: benjamin_rogers__1073__Reconstructed Consolidated 2000 Peaker 8-15-00
Sheet: Wilton

INCOME STATEMENT - WILTON
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Variable Revenue
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 572 | 583.4 | 595.1 | 607 | 619.1 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5 | 631.5
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - WILTON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA
Plus Property Tax Liability
Less Property Tax Expense | -333.7
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - WILTON
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
State Franchise Tax Rate
State Franchise Tax Liability
STATE TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Exp/(Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 829050d1683886282-aggregate-value-calculation-with-excel-formula-agg-value-sum-updated
Sheet: Sheet1

 |  | Customer | Sale | Product | bid | higest bid | bid ( Sum )
 |  | Abc | 123 | 1 | 10 | False | 0
 |  | Abc | 123 | 2 | 20 | False | 0
 |  | Abc | 123 | 3 | 30 | True | 120
 |  | Abc | 123 | 4 | 40 | True | 0
 |  | Abc | 123 | 5 | 50 | True | 0
 |  | Abc | 789 | 6 | 10 | False | 0
 |  | Abc | 789 | 7 | 20 | False | 0
 |  | Abc | 789 | 8 | 30 | True | 70
 |  | Abc | 789 | 9 | 40 | True | 0
 |  | Xyz | 456 | 10 | 60 | True | 130
 |  | Xyz | 456 | 11 | 70 | True | 0
 |  | Xyz | 456 | 12 | 80 | False | 0
 |  | If Col - customer & sale & higest bid ( TURE only ) , sum the value of col 'bid' ( For TRUE transactiosn ) and update the same col "bid ( sum )  Note :  I looking or a if function formula so that its getting updated as and when the data changes  we need the sum in one of the row in col 'bid (Sum), example hilighted ( Red ) for ref
Spreadsheet: paul_y'barbo__28499__NatGas NYMEX NX3 Settles 2001 MM
Sheet: Price

 |  |  | Cabot LNG Supply Contract
 |  |  | 2002 Estimated Delivered Price of Winter Cargo
 |  |  | $/MMBtu
 |  |  | Commodity Surcharge
 |  |  | Comm. Charge - Fixed Comp.
 |  |  | 6/12 times 0.68 times [NAME]. Jan-Jun '01 NYMEX NX3
 |  |  | 1/12 times 0.68 times Avg. Jly '01 NYMEX NX3
 |  |  | 1/12 times 0.68 times [NAME]. Aug '01 NYMEX NX3
 |  |  | 1/12 times 0.68 times [NAME]. Sep '01 NYMEX NX3
 |  |  | 1/12 times 0.68 times [NAME]. Oct '01 NYMEX NX3
 |  |  | 1/12 times 0.68 times [NAME]. Nov '01 NYMEX NX3
 |  |  | 1/12 times 0.68 times [NAME]. Dec '01 NYMEX NX3
 |  |  | Ex-Ship Price
 |  |  | Demand Charge
 |  |  | [NAME]
 |  | PR-CPI2001 =
 |  | Estimated Final Contract Settlements 3/8/01
 |  | 3.915 | Avg. Jly '01 NYMEX NG NX3
 |  | 4.01 | [NAME]. Aug '01 NYMEX NG NX3
 |  | 4.06 | Avg. Sep '01 NYMEX NG NX3
 |  | 4.13 | [NAME]. Oct '01 NYMEX NG NX3
 |  | 4.31 | Avg. Nov '01 NYMEX NG NX3
 |  | 4.49 | [NAME]. Dec '01 NYMEX NG NX3
Spreadsheet: kate_symes__18628__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
Spreadsheet: 73625d1274272766-using-pythagoras-theorem-to-count-results-book1
Sheet: Sheet1

 |  | Count
 |  | 1
School | School |  | Incident | Incident
Easting | Northing | Distance From School | Easting | Northing
502871 | 107008 | 18748.08795584232 | 518902 | 116729
585461 | 136574 | 24.02082429892863 | 585460 | 136550
487650 | 135334 | 506080.8374716435
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 863474d1710947644-how-to-count-values-in-columns-when-value-is-not-zero-stop-when-0-and-start-again-when-va-question-excelforum
Sheet: Sheet1

DATA:
 | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9
Article 1 QTY | 100 | 50 | 0 | 0 | 0 | 0 | 100 | 0 | 0
Article 2 QTY | 30 | 100 | 100 | 25 | 0 | 0 | 100 | 50
Article 3 QTY | 0 | 25 | 100 | 75 | 0 | 100 | 10 | 0 | 0
FORMULE:
 | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9
Article 1 QTY
Article 2 QTY
Article 3 QTY
Solution 1:
 | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | average run length
Article 1 QTY | 150 | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0
Article 2 QTY | 255 | 0 | 0 | 0 | 0 | 0 | 150 | 0 | 0
Article 3 QTY | 0 | 200 | 0 | 0 | 0 | 0 | 110 | 0 | 0
Solution 2:
 | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | average run length
Article 1 QTY | 0 | 150 | 0 | 0 | 0 | 0 | 100 | 0 | 0
Article 2 QTY | 0 | 0 | 255 | 0 | 0 | 0 | 0 | 150 | 0
Article 3 QTY | 0 | 0 | 0 | 200 | 0 | 110 | 0 | 0 | 0
Spreadsheet: 785750d1656675306-create-a-list-of-words-based-on-conditional-rule-oak-2122-56-termly-cew-analysis-sheet-updated
Sheet: Overview

Oak 21/22 | Overview Out of 103 Words |  |  |  |  |  |  |  |  |  |  | Number of Pupils |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Year 5/6 CEW Analysis Sheet | Cerys | [NAME] | Logan | Mason | Tilly | [NAME] | Ewan | Lilly-R | [NAME] | [NAME] | Jessica | Emma | [NAME] | [NAME] | Lilly | Ashton | Logan H |  |  |  |  |  |  |  |  |  |  |  | Class Average
Autumn 1
Autumn 2
Spring 1
Spring 2
Summer 1
Summer 2
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74036

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 404 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20290 |  | General Ledgers |  |  |  |  |  | Z0074036
 |  | EnSerCo Co.'s 957, 958, 960, 961 (Inception) |  |  |  | 01/01/97 | 12/31/97
 |  | [NAME] |  |  |  | 01/01/95 | 12/31/95
 |  | Co. 506 |  |  |  | 01/01/94 | 12/31/94
 |  | [NAME] |  |  |  | 09/01/95 | 12/31/96
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date