tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 484809d1476457548-calculate-intakes-by-month-casse_massagno
Sheet: SunCreams

Date | 5 | 2 | 1 | 0.5 | Total
2016-08-08 00:00:00 | 26 | 5 | 5 | 7
2016-08-15 00:00:00 | 3
2016-08-22 00:00:00 | 1
2016-08-29 00:00:00 | 1
2016-09-05 00:00:00 | 8 | 1 | 4 | 6
2016-09-12 00:00:00 | 5 |  | 2
2016-09-19 00:00:00 | 5 | 1
2016-09-26 00:00:00 | 3 | 4 | 3
2016-10-03 00:00:00 | 9 | 3 | 1
2016-10-10 00:00:00 | 3 |  | 1
Spreadsheet: 822837d1679562091-count-distinct-unique-values-based-on-multiple-criteria-sample-storage-counts
Sheet: Sheet2

Product ID | Category | QoH | Sublocation summary | [NAME] | [NAME] |  | Column1 | Bins | [NAME] | Oversized | Regular |  |  |  | Bins | [NAME] | Oversized | Regular
ABL-0021 | Abler | 60 | RECEIVING: 60 | Pallet Pick | 60 |  | Abler | 2 |  |  |  |  |  | Abler | 2 | 0 | 0 | 0
ABL-0022 | Abler | 173 | RECEIVING: 173 | Pallet Pick | 200 |  | AllCure |  |  | 3 | 9 |  |  | AllCure | 0 | 0 | 3 | 8
AC-112 | AllCure | 5361 | X-18-E-06-A-02: 1271, X-22-A-02-A-01: 157, X-24-B-01-A-01: 1140, X-25-B-10-A-01: 528, X-25-B-10-A-02: 1152, X-25-C-10-A-03: 1104, X-Quarantine: 9 | Pallet Pick |  |  | Alpine | 3 |  |  |  |  |  | Alpine | 3 | 0 | 0 | 0
AC-112 | AllCure | 3532 | Q-10-B-01-A-02: 11, X-17-E-01-A-01: 1476, X-24-B-01-A-02: 936, X-25-D-10-A-01: 988, X-25-E-08-A-01: 24, Z-TRAILER: 97 | Pallet Pick |  |  | Bythe |  |  | 1 |  |  |  | Bythe | 0 | 0 | 1 | 0
ALP-0778 | Alpine | 4 | B-09-A-12-B-05: 4 | B-09-A-12-B-05 | 4 |  | [NAME] |  | 10 |  |  |  |  | [NAME] | 0 | 10 | 0 | 0
ALP-0779 | Alpine | 4 | B-09-A-12-C-01: 4 | B-09-A-12-C-01 | 4 |  | Codger |  |  |  | 2 |  |  | Codger | 0 | 0 | 0 | 2
ALP-0806 | Alpine | 1 | B-07-A-08-A-01: 1 | B-07-A-08-A-01 | 128 |  | Dialate |  |  | 4 |  |  |  | Dialate | 0 | 0 | 4 | 0
BY-002 | Bythe | 78 | X-17-E-08-A-01: 78
BY-003 | Bythe | 28 | X-17-E-08-A-01: 28
BY-004 | Bythe | 207 | X-17-E-08-A-01: 207
BY-005 | Bythe | 75 | X-17-E-08-A-01: 75 |  |  |  | BINS = RECEIVING or start w/ a B-
BY-006 | Bythe | 37 | X-17-E-08-A-01: 37 |  |  |  | [NAME] = End w/ .D
810-0001-00 | [NAME] | 2 | [NAME]: 2 | [NAME] | 3 |  | Oversized Pallet = Start w/ X-*-E
810-0002-04 | [NAME] | 4 | [NAME]: 1, B-01-A-06-D-03.D: 3 | [NAME] |  |  | Regular Pallet = Start w/ X-
810-0024-00 | [NAME] | 40 | B-01-A-01-A-01.D: 6, B-01-A-01-A-02.D: 6, B-01-A-01-A-03.D: 6, B-01-A-01-A-04.D: 6, [NAME]: 6, [NAME]-C-05.D: 6, [NAME]: 4 | B-01-A-01-A-02.D
COD-0021 | Codger | 126 | X-04-D-11-A-01: 87, X-04-D-12-A-01: 39 | B-04-B-01-C-06 | 25
XZ-9000 | Dialate | 1522 | X-17-E-05-A-01: 432, X-17-E-05-A-02: 370, X-17-E-05-A-03: 360, X-17-E-06-A-01: 360
Spreadsheet: 31505d1227352127-automatic-popluation-of-a-table-taking-specific-info-from-other-sheets-example
Sheet: Site 1

Site 1
Date | Zn | Fe | Cu
Limit | 10 | 10 | 5
2008-02-01 00:00:00 | 5 | 5 | 4
2008-02-02 00:00:00 | 6 | 7 | 6
2008-02-03 00:00:00 | 12 | 15 | 2
2008-02-04 00:00:00 | 4 | 12 | 8
2008-02-05 00:00:00 | 20 | 1 | 2
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 1000

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OTV 1000 |  | Start Date | 24/07/2011 |  |  |  | [NAME] |  | 111
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | 1
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 30236755-1152-4c4e-ad84-d76bf0965369
Sheet: 2004

WEST BRANCH MARINA HISTORICAL DATA - 2004
Category |  |  |  |  |  |  |  |  |  |  |  |  | Total | Commission | %
of Revenue | Jan. | Feb. | March | Apr. | May | Jun. | Jul. | Aug. | Sept. | Oct. | Nov. | Dec. | Receipts | Paid | Paid
Rental - Boats & Motors | 0 | 0 | 0 | 664 | 5804.5 | 9681 | 26103.6 | 25671.5 | 14346.5 | 0 | 0 | 0 | 82271.1 | 9049.84 | 0.11
Marine Equipment Sales | 0 | 0 | 0 | 173.8 | 541.12 | 2363.82 | 3763.63 | 1686.55 | 1281.44 | 0 | 0 | 0 | 9810.36 | 686.73 | 0.07
Bait and Tackle | 0 | 0 | 0 | 59.33 | 380.19 | 464.02 | 824.86 | 563.24 | 422.11 | 0 | 0 | 0 | 2713.75 | 298.51 | 0.11
Gasoline and Oil | 0 | 0 | 0 | 221.72 | 2081.64 | 4546.18 | 11237.75 | 9532.83 | 6429.4 | 0 | 0 | 0 | 34049.52 | 1021.48 | 0.03
Food and Beverage | 0 | 0 | 0 | 307.34 | 2196.51 | 3806.65 | 7108.03 | 5742.64 | 3021.17 | 0 | 0 | 0 | 22182.34 | 1774.58 | 0.08
Vending | 0 | 0 | 0 | 28 | 230 | 288 | 300 | 320 | 280 | 0 | 0 | 0 | 1446 | 144.6 | 0.1
Transient Dockage | 0 | 0 | 0 | 0 | 60 | 415 | 855 | 110 | 180 | 0 | 0 | 0 | 1620 | 810 | 0.5
Souvenirs and Sundries | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12
All Other Receipts | 0 | 0 | 0 | 0 | 19.22 | 0 | 100.43 | 128.81 | 59.03 | 0 | 0 | 0 | 307.49 | 24.59 | 0.08
Totals | 0 | 0 | 0 | 1454.19 | 11313.18 | 21564.67 | 50293.3 | 43755.57 | 26019.65 | 0 | 0 | 0 | 154400.56 | 13810.33
Spreadsheet: 867853d1714640018-formula-to-zero-tables-within-kpi-spreadsheet-new-hs-kpi-updated-max-percentage-100
Sheet: H&S Combined

 | Safety | Points avaliable | Month score | Total | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Monthly Target | Annual Target | % | Clancy Target
 | Major injury | -50 |  |  |  |  |  |  |  | 0 | 0
 | Lost time injury | -25 |  |  |  |  |  |  |  | 0 | 0
 | Non-lost time injury | 0 |  |  |  |  |  |  |  | 0 | 0
 | Service Strike (HV) | -20 |  |  |  |  |  |  |  | 0 | 0
 | Service Strike (LV) | -15 |  |  |  |  |  |  |  | Less than 3 | Less than 36 |  | <6
 | Service Strike (Gas) | -10 |  |  |  |  |  |  |  |  |  |  | <33
 | Service Strike (Other) | -5 |  |  |  |  |  |  |  |  |  |  | <33
 | Manager [NAME] | 0.1 |  |  |  |  |  |  |  | 79
 | Safety observations | 0.01 |  |  |  |  |  |  |  | 250
 | H&S advisor visits | 0.2 |  |  |  |  |  |  |  | 60
 | Manager/Supervisor Safety Visits | 0.01 |  |  |  |  |  |  |  | 254
 | [NAME] | 0.01 |  |  |  |  |  |  |  | 1150
 | ABC Tours | 0.01 |  |  |  |  |  |  |  | 20
 | HAVS
 | Total |  |  |  | 01st - 04th | 05th - 11th | 12th - 18th | 19th - 25th | 26th - 30th
 |  |  |  | Clear Numbers
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, February 1 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
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 cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****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: 1384aeea-1d83-430d-8eb0-c26404c1bd7a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | DIVISION OF WATER RESOURCES TAX CERTIFICATION & EXEMPTION APPLICATION |  |  |  |  |  |  |  |  |  |  | PAGE 2
 | Waste Treatment Systems & Equipment:  Waste treatment systems & equipment must be used exclusively for the abatement of water pollution |  |  |  |  |  |  |  |  |  |  | Rev. 09/01/2013
 | For County Use Only |  | For DWR Use Only "A" Approved "D" Disapproved | Description of Waste Treatment Systems or Equipment | Was asset listed in the permit (Yes/No) * | Asset Number, Vehicle Identification Number (VIN) | How is this equipment used for pollution abatement? |  | % of time item is used for pollution abatement | Year of Acquisition | Original Historical Cost** | Is this asset replacing a prior asset?
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | Attach additional pages if necessary
 | * If the asset is listed in the DWQ permit, the description must be identical as listed on the current permit.  If the asset is not specifically listed in the DWQ permit, the applicant must attach detailed information as to why the asset should qualify for Tax Certification.
 | ** When certifying systems or equipment, DENR is not certifying the cost of the equipment or the year of acquisition.
 | Facilities:  To qualify for tax certification, the building or section of building being applied for, must be used exclusively for water pollution prevention.  A sketch of the building, square footage along with details as to how the building is used for water pollution prevention, is required.
 | Land:  To qualify for tax certification, the land must be used exclusively for water pollution prevention.  A schematic diagram of the facility detailing the land being applied for is required.  The amount of land (acreage) is required and how this land is being used to prevent water pollution.  For wastewater treatment and irrigation system list separately the acreage used for actual treatment from the acreage required by the facility's water quality permit for buffers and setbacks.
 | SIGNATURE:
 | I hereby certify that the above equipment, facilities and/or land are used for the purpose stated, and that the information presented in this application is accurate.  Furthermore, I certify that any portable or mobile equipment listed on this application will be used exclusively in the state of North Carolina.
 | Applicant
 | Signature: |  |  |  |  |  | Title: |  |  | Date:
 |  |  |  |  |  | (print name also)
 | NOTICE:  The penalty for false statement, representation or certification |  |  |  |  |  | Of:
 | herein includes imprisonment and / or the assessment of civil penalties. |  |  |  |  |  |  | (Name of Applicant Business Entity) |  |  |  | TC-WQ
Spreadsheet: 863891d1711296648-ifs-function-problem-sample
Sheet: Sheet1

Not working [NAME]
Tax Bracket | Lower | Upper | Amount to Tax | Actual Amount | Before Deduction Tax | After Standard Deduction | Total Tax | Effective Rate
0.1 | 0 | 16550
0.12 |  | 63100
0.22 |  | 100500
0.24 | 100500 | 191950
0.32 |  | 243700 |  |  | 0
0.35 |  | 609350 |  |  | 0
0.37 |  | 1000000 |  |  | 0
 | TOTAL |  |  | 124734.33
Manual
Tax Bracket | Lower | Upper | Amount to Tax | Actual Amount | Before Deduction Tax | After Standard Deduction | Total Tax | Effective Rate
0.1 | 0 | 16550
0.12 |  | 63100
0.22 |  | 100500
0.24 | 100500 | 191950 |  |  |  |  |  |  | <---------- | I manually just put in cell E23 ( E27-C23)  to get the result I need. I want the IFS formula above to be able to evalute it and automatically update it. Thanks!
0.32 |  | 243700 |  |  | 0
0.35 |  | 609350 |  |  | 0
0.37 |  | 1000000 |  |  | 0
 | TOTAL |  |  | 124734.33
Spreadsheet: 664860d1582811289-complex-timesheet-template-sample-timesheet
Sheet: Sheet1

Date | Task | Time In | Break Start | Break End | Time Out | Total Hrs | Task A Hrs | Task A OT Hrs | Task B Hrs | Task B OT Hrs
Sat | Task A |  |  |  |  |  |  |  |  |  |  | *Sat and Sun by default would be OT hrs
 | Task B
Sun | Task A
 | Task B
Mon | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00 | 8 | 8 | 0
 | Task B |  |  |  |  |  |  |  | 0 | 0
Tue | Task A |  |  | 19:00:00 | 20:00:00 | 1 | 0 | 1
 | Task B | 09:00:00 | 12:00:00 | 13:00:00 | 19:00:00 | 9 |  |  | 8 | 1
Wed | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00 | 8 | 8 | 0
 | Task B |  |  | 18:00:00 | 19:00:00 | 1 |  |  | 0 | 1
Thu | Task A | 09:00:00 | 12:00:00 | 13:00:00 | 17:00:00 | 7 | 7 | 0
 | Task B |  |  | 17:00:00 | 18:00:00 | 1 |  |  | 1 | 0
Fri | Task A | 09:00:00 | 12:00:00 | 18:00:00 | 19:00:00 | 4 | 3 | 1
 | Task B |  |  | 13:00:00 | 18:00:00 | 5 |  |  | 5 | 0
Spreadsheet: 801002d1666025190-drag-down-formula-but-skip-certain-cells-sample
Sheet: Sheet1

Fruit | [NAME] to be dragged down in A1 |  | Fruits
 | =D2 |  | [NAME]
 | =D3 |  | Apple
 | =D4 |  | Orange
 | =D5 |  | Grapes
 | =D6 |  | Watermellon
 | =D7 |  | [NAME]
 | =D8 |  | Apple
Apple | =D9 | I don't want the formula to effect this cell! Just stay this value! | Orange
 | =D10 |  | Watermellon
 | =D11 |  | [NAME]
 | =D12 |  | Apple
 | =D13 |  | Orange
Orange | =D14 | I don't want the formula to effect this cell! Just stay this value! | [NAME]
 | =D15 |  | Apple
 | =D16 |  | Orange
 | =D17 |  | Watermellon
 | =[NAME] |  | [NAME]
 | =[NAME] |  | Apple
 | =D20 |  | Apple
Spreadsheet: 880780d1728639189-dynamic-gantt-diagram-based-on-a-dynamic-list-examplegantt
Sheet: Tabelle1

Projektübersicht |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Team | Autoprojekt | Projektleiter | Freigabe | LAS-Release / Zieltermin | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00
Auto DE | Mercedes | Meier |  | 2025-06-01 00:00:00
Auto DE | BMW | Müller |  | 2025-09-01 00:00:00
Auto USA | Tesla | Mustermann |  | 2025-06-01 00:00:00
Auto Anon. | Ford | Meier |  | 2026-09-01 00:00:00
Auto Anon. | Nissan | Müller |  | 2026-09-01 00:00:00
Auto Anon. | Nissan | Mustermann |  | 2025-09-01 00:00:00
Auto DE | BMW | Meier |  | 2025-06-01 00:00:00
Auto DE | Mercedes | Müller |  | 2025-11-01 00:00:00
Auto USA | BMW | Mustermann |  | 2025-09-01 00:00:00
Auto Anon. | Tesla | Meier |  | 2025-09-01 00:00:00
Auto Anon. | Ford | Müller |  | 2025-12-01 00:00:00
Auto Anon. | Nissan | Mustermann |  | 2025-06-01 00:00:00
Auto DE | Nissan | Meier |  | 2025-06-01 00:00:00
Auto DE | BMW | Müller |  | 2025-09-01 00:00:00
Auto USA | Mercedes | Mustermann |  | 2025-12-01 00:00:00
Auto Anon. | BMW | Meier |  | 2025-03-01 00:00:00
Auto Anon. | Tesla | Müller |  | 2025-03-01 00:00:00
Auto Anon. | Ford | Mustermann |  | 2025-06-01 00:00:00
Auto DE | Nissan | Meier |  | 2025-12-01 00:00:00
Auto DE | Nissan | Müller |  | 2025-12-01 00:00:00
Auto USA | BMW | Mustermann |  | 2025-12-01 00:00:00
Auto Anon. | Mercedes | Meier |  | 2025-03-01 00:00:00
Auto Anon. | BMW | Müller |  | 2025-03-01 00:00:00
Auto Anon. | Tesla | Mustermann |  | 2024-12-01 00:00:00
Auto DE | Ford | Meier |  | 2024-12-01 00:00:00
Auto DE | Nissan | Müller |  | 2025-03-01 00:00:00
Auto USA | Nissan | Mustermann |  | 2025-06-01 00:00:00
Auto Anon. | BMW | Meier |  | 2025-12-01 00:00:00
Auto Anon. | Mercedes | Müller |  | 2025-03-01 00:00:00
Auto Anon. | BMW | Mustermann |  | 2025-12-01 00:00:00
Auto DE | Tesla | Meier |  | 2025-12-01 00:00:00
Auto DE | Ford | Müller |  | 2025-06-01 00:00:00
Auto USA | Nissan | Mustermann |  | 2025-12-01 00:00:00
Auto Anon. | Nissan | Meier |  | 2025-12-01 00:00:00
Auto Anon. | BMW | Müller |  | 2025-12-01 00:00:00
Auto Anon. | Mercedes | Mustermann |  | 2026-06-01 00:00:00
Auto DE | BMW | Meier |  | 2026-12-01 00:00:00
Auto DE | Tesla | Müller |  | 2026-03-01 00:00:00
Auto USA | Ford | Mustermann |  | 2026-03-01 00:00:00
Auto DE | Nissan | Meier |  | 2026-06-01 00:00:00
Spreadsheet: 97238d1296480417-second-revised-formula-for-cell-content-nigelog_sample-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTER-SERVICE GREASE SCHEDULE HOURS
 |  |  | LAST SERVICE | last service [NAME] |  | CERT DUE | LAST GREASED | SERVICE DUE |  | CURRENT | SERVICE | 5o hour increments from row E |  |  |  |  | 50  HRS | 100 HRS | 150 HRS | 200 HRS | 250 HRS |  | GREASE ALERT
 | HYSTER |  | 2010-05-06 00:00:00 | 6368 |  | 2011-10-05 00:00:00 | 6420 | 6668 | 0 | 6422 |  | 6418 | 6468 | 6518 | 6568 | 6618 | DONE | DUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02/10/05 COOLANT + RAD
 | HYUNDAI |  | 2010-02-16 00:00:00 | 1843 |  | 2011-10-05 00:00:00 | 2201 | 2143 | DUE | 2201 | DUE | 1893 | 1943 | 1993 | 2043 | 2093 | DONE | DONE | DONE | DONE | DONE |  |  |  |  |  |  | Also Serviced on that day
 | FLT23 |  | 2010-06-15 00:00:00 | 2074 |  | 2011-10-05 00:00:00 | 2011-01-21 00:00:00 | 2374 | 0 | 2268 |  | 2124 | 2174 | 2224 | 2274 | 2324 | DONE | DONE | DONE | DUE
 | MOFFET1 |  | 2010-05-08 00:00:00 | 768 |  | 2011-10-05 00:00:00 | 2010-09-21 00:00:00 | 1068 | DUE | 1109 | DUE | 818 | 868 | 918 | 968 | 1018 | DONE | DONE | DONE | DONE | DONE |  |  |  |  | Serial no. H120038 |  | 21/09/10 FIT NEW CARRIAGE &MAST BEARINGS 925 HRS
 | MOFFET2 |  | 2010-05-06 00:00:00 | 309 |  | 2011-10-05 00:00:00 | 2010-11-20 00:00:00 | 609 | 0 | 480 |  | 359 | 409 | 459 | 509 | 559 | DONE | DONE | DONE | DUE |  |  |  |  |  | Serial no. 1380088
 | MOFFET5 |  | 2010-07-17 00:00:00 | 1244 |  | 2011-10-05 00:00:00 | 2011-01-21 00:00:00 | 1544 | 0 | 1515 |  | 1294 | 1344 | 1394 | 1444 | 1494 | DONE | DONE | DONE | DONE | DONE |  |  |  |  | Serial no. G410025A
 | MOFFET7 |  | 2010-07-17 00:00:00 | 1038 |  | 2011-10-05 00:00:00 | 2011-01-21 00:00:00 | 1338 | 0 | 1218 |  | 1088 | 1138 | 1188 | 1238 | 1288 | DONE | DONE | DONE | DUE |  |  |  |  |  | Serial no. G442115A
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: BUG_VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM)
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 67078 | 66563
2 | 66246 | 66610
3 | 57532 | 59276
4 | 53728 | 53347
5 | 47154 | 46367
6 | 45159 | 45550
7 | 58467 | 55335
8 | 39946 | 40573
9 | 56738 | 58209
10 | 57830 | 59895
11 | 56138 | 52463
12 | 39485 | 43529
13 | 58087 | 71706
14 | 58089 | 74294
15 | 64335 | 69004
16 | 59587 | 59046
17 | 64435 | 64834
18 | 66930 | 73436
19 | 66705 | 73066
20 | 66683 | 67682
21 | 66198 | 70155
22 | 70457 | 69741
23 | 61354 | 60609
24 | 55685 | 59916
25 | 60182 | 58465
26 | 63498 | 65426
27 | 65070 | 65426
28 | 70352 | 65426
29 | 67457 | 64502
30 | 70035 | 65639
31 | 65155 | 65639
2001-04-30 00:00:00 |  |  | 647845.72
2001-05-31 00:00:00
Spreadsheet: 817366d1676175103-index-and-atch-indexmatch
Sheet: Sheet1

 |  |  |  |  |  | Date | Rate |  |  | Rate
 |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-05 00:00:00 | 100 |  | 2023-01-06 00:00:00
 |  |  |  |  | 2023-01-06 00:00:00 | 2023-01-08 00:00:00 | 120
 |  |  |  |  | 2023-01-09 00:00:00 | 2023-01-12 00:00:00 | 100
 |  |  |  |  | 2023-01-13 00:00:00 | 2023-02-08 00:00:00 | 140 |  |  | I
 |  |  |  |  |  |  | **Date range
 |  |  |  |  |  |  |  |  | I want to get the result of the above is 6 Jan, rate should be 120)
Spreadsheet: john_griffith__15603__Restructure
Sheet: Sheet1

Mesa Gas Restructure
EPSJ Settlement
 | Existing Fixed Price
 | Month | Volume | Price | Market | M2M |  | WA Calc
 | 2001-02-01 00:00:00 | 160000 | 3.74 | 8.05
 | 2001-03-01 00:00:00 | 155000 | 3.74 | 7.38
 | 2001-04-01 00:00:00 | 120000 | 3.74 | 5.265
 | 2001-05-01 00:00:00 | 93000 | 3.74 | 4.85
 | 2001-06-01 00:00:00 | 90000 | 3.74 | 4.83
 | 2001-07-01 00:00:00 | 77500 | 3.74 | 4.727
 | Totals |  |  | M2M Equity
 |  |  |  | WA Market Price
 |  |  |  | New price | 5.25
 |  |  |  | Equity Used
 | Short
 | 2001-08-01 00:00:00 | 181000
 | 2001-09-01 00:00:00 | 184000
 | 2001-10-01 00:00:00 | 232000
 | 2001-11-01 00:00:00 | 300000
 | 2001-12-01 00:00:00 | 493000
 | 2002-01-01 00:00:00 | 467000
 | 2002-02-01 00:00:00 | 415000
 | 2002-03-01 00:00:00 | 356000
 | 2002-04-01 00:00:00 | 307000
 | 2002-05-01 00:00:00 | 221000
 | 2002-06-01 00:00:00 | 197000
 | 2002-07-01 00:00:00 | 175000
 | Total
 | [NAME]
Spreadsheet: 130739d1322564013-excel-2007-estimated-vs-actuals-forum
Sheet: Demand Forecast

 | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act | Est. | Est. | Est. | Est. | Est. | Est. | Est. | Est. | Est. | Est. | Est. | Est.
 | Jan | Feb | Mrt | Apr | [NAME] | Jun | Jul | Aug | Sep | Okt | Nov | Dec | jan | feb | mrt | apr | mei | jun | jul | aug | sep | okt | nov | dec
Product X | 420 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
Spreadsheet: 768549d1645022913-numbers-and-their-order-columns-question
Sheet: Sheet1

 |  |  | What is the formula to get the results automatically in D column
 |  |  | Highest to lowest. [NAME] looks at all the number in C column and decides high to low
 |  |  | Number | ORDER
 |  |  | 200 | 6
 |  |  | 4554 | 4
 |  |  | 44 | 7
 |  |  | 66656 | 1
 |  |  | 777 | 5
 |  |  | 54 | 8
 |  |  | 7897 | 3
 |  |  | 33456 | 2