tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138515d1327691540-pivot-sort-by-two-columns-book1
Sheet: Result

DEPTID | POSITION | VENDOR_NAME | YTD Expense | AKA "Grand Total"
[PHONE] | 00032688 | Colon,[NAME] | 100.8
 | 00065009 | [NAME],[NAME] | 296.02 |  | The green is how I want it.
 | 00062200 | [NAME],[NAME] | 573.2 |  | Note we're sorted by YTD Expense, within DEPTID
 | 00031512 | Adams,[NAME] | 587.35
 | 00031506 | Wilson,[NAME] | 611.25
 | 00031507 | Forbes,August S. | 909.4
 | 00062790 | Mcmahon,[NAME] | 1085.88
 | 00062818 | Riley,[NAME] | 1586.01
[PHONE] Total |  |  | 5749.91
[PHONE] | 00058845 | Espinoza,[NAME] | 127.3
 | 00063077 | Salas,[NAME] | 186.15
 | 00058851 | Allen,Elijah A. | 670.45
 | 00058849 | Nicholson,[NAME] | 685
 | 00065544 | [NAME],[NAME] | 858.6
 | 00058850 | Beard,[NAME] | 1338.62
 | 00064068 | Vance,[NAME] | 1393.82
[PHONE] Total |  |  | 5259.94
[PHONE] | 00058872 | Mercer,[NAME] | 210.75
 | 00066126 | Price,[NAME] | 257.95
 | 00058876 | Wagner,[NAME] | 998.4
 | 00058879 | [NAME],[NAME] | 1066.95
 | 00064052 | [NAME],[NAME] | 1546.51
[PHONE] Total |  |  | 4080.56
[PHONE] | 00031576 | Lyons,Coleman O. | 394.2
 | 00031580 | Clements,[NAME] | 89.95 |  | This is how I don't want it
 | 00031581 | [NAME],[NAME] | 862.75 |  | Note we're sorted by DeptID, then by Position
 | 00036828 | [NAME],[NAME] | 107.7
 | 00063075 | Mcguire,[NAME] | 805
 | 00065880 | [NAME],[NAME] | 154.95
[PHONE] Total |  |  | 2414.55
Spreadsheet: 770220d1645897596-no-filter-if-field-empty-test-sort-2
Sheet: MAIN

 |  | CONSTRUIRE VOTRE REMORQUE
 |  | ALL | 1
 |  | TYPE | REMORQUE FERMÉE
 |  | DIMENSION
 |  | HAUTEUR
 |  | CAPACITÉ
 |  | COULEUR
 |  | INVENTAIRE DISPONIBLE
 |  | TYPE | DIMENSION | HAUTEUR | CAPACITÉ | COULEUR | ALL | PRIX | CODE PRODUIT | # DE SÉRIE
 |  |  | 6x12 | 6 | 3500 - 1 essieu | BLANC | 1 | 999.99 | EF-612-6-035-1-B | XYZ-12345
 |  | REMORQUE FERMÉE | 8x16 | 7 | 3500 - 1 essieu | NOIR | 1 | 999.99 | EF-816-7-035-1-N | XYZ-12346
 |  | REMORQUE FERMÉE | 7x14 | 8 | 5500 - 2 essieux | ANTHRACITE | 1 | 999.99 | EF-714-8-055-2-C | XYZ-12347
 |  | REMORQUE FERMÉE | 8x22 | 6 | 7000 - 2 essieux | BLANC | 1 | 999.99 | EF-822-6-070-2-B | XYZ-12360
 |  | REMORQUE FERMÉE | 7x20 | 7 | 3500 - 1 essieu | NOIR | 1 | 999.99 | EF-720-7-035-1-N | XYZ-12361
 |  | REMORQUE FERMÉE | 7x20 | 8 | 5500 - 2 essieux | ANTHRACITE | 1 | 999.99 | EF-720-8-055-2-C | XYZ-12362
 |  | REMORQUE FERMÉE | 6x14 | 6 | 7000 - 2 essieux | ROUGE | 1 | 999.99 | EF-614-6-070-2-R | XYZ-12363
 |  | REMORQUE FERMÉE | 7x14 | 7 | 5500 - 2 essieux | ARGENT | 1 | 999.99 | EF-714-7-055-2-A | XYZ-12364
Spreadsheet: louise_kitchen__22735__Pwr west P&L
Sheet: Pwr west P&L

ENRON POWER TRADING & TRANSMISSION
DAILY PROFIT LOSS STATEMENT - WEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rolling Check
DATE: | 1999-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Figures - If not
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | zero, you are
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | not finished!
 |  | Preliminary |  |  |  |  |  |  |  |  |  |  | CHECK
 |  | DESK | 1 DAY | 5 DAY | MTD | QTD | YTD | VAR as of 2/8/01 | VAR as of 1/12/01 | 3rd Quarter | 2nd Quarter | 1st Quarter | Expected Liquidations | Difference in YTD |  | 4th Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter
 |  | W-MGMT [NAME] |  |  |  |  |  | not available | not available
 |  | Northwest  [NAME] |  |  |  |  |  | not available | not available
 |  | [NAME]   [NAME] |  |  |  |  |  | not available | not available
 |  | Southwest  [NAME] |  |  |  |  |  | not available | not available
 |  | W-Trans  M.Swerzbin, [NAME]
 |  | Option
 |  | Spread Option
 |  | Service
 |  | TOTAL  LONG TERM
 |  | California  Jeff Richter |  |  |  |  |  | not available | not available
 |  | Northwest  Sean Crandall, [NAME] |  |  |  |  |  | not available | not available
 |  | Southwest  [NAME], [NAME] |  |  |  |  |  | not available | not available
 |  | Hourly  [NAME]
 |  | Management
 |  | W-BOM  [NAME]
 |  | TOTAL  SHORT TERM
 |  | TOTAL WEST
 |  | ALBERTA ORIGINATION - Derek Davies
 |  | ALBERTA TRADING - John Zufferli
 |  | TOTAL ALBERTA POWER
 |  | TOTAL WEST AND ALBERTA
 |  | -27151
 |  | 780343.4841893384
 |  | -558558.1094205244
 |  | -74357
 |  | 214990
 |  | 360860
 |  | -274755
 |  | -214
 |  | -76
 |  | 851224
 |  | 97
 |  | -127
 |  | 57
 |  | 0
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Expense Detail

 | 2001 Budget Template - $US
 | Government Affairs - [NAME]
 |  |  |  |  | 2000 |  | 2001 |  | 2002
 | Average Headcount ( 2001 = Year End) |  |  |  | 21 |  | 19 |  |  | Comments
 |  |  |  |  |  |  | Aug Ytd Annualised
 | Salaries & Wages |  |  |  | $ |  | $ |  | $
 | Total Annual Salaries |  |  |  |  |  | 2735292
 | Average Cost Per Head |  |  |  |  |  |  |  |  | No expat cost in plan 2002
 | Opening Headcount Dec 2001
 | Starters
 | Leavers | -9
 | December 2002
 | Travel & Entertainment
 | Flights
 | Europe - Internal
 | Business @ | 630 | 225 |  |  |  |  |  |  | 5 travellers in the group having one trip each per week by 45 weeks.
 |  |  |  |  |  |  |  |  |  | (P.Hennemeyer needs to make regular travel to Germany & P.Styles is based in Brussels)
 | Hotel @ | 205 | 450 |  |  |  |  |  |  | 2 nights stay per trip
 | Europe - US
 | Economy @ | 1030 | 5 |  |  |  |  |  |  | Possible trips. All have been budgeted at Economy level
 | Business @ | 4700 | 0
 | First @ | 10285 | 0
 | Hotel @ | 185 | 25 |  |  |  |  |  |  | 5 nights per trip
 | Europe Asia
 | Economy @ | 1675 | 0
 | Business @ | 5800 | 0
 | First @ | 7535 | 0
 | Hotel @ | 270 | 0
 | US internal
 | Economy @ | 1895 | 0
 | First @ | 2245 | 0
 | Hotel @ | 185 | 0
 | Other Business Travel
 | Entertainment & Meals
 | Client Entertainment
 | Total T&E |  |  | 0 |  |  | 386072 |  |  | 2002 lower due to reduced headcount and no [NAME] flights
Spreadsheet: 118521d1313745285-radio-buttons-wrong-value-in-linked-cell-radio-buttons-issue
Sheet: Additional Questions

 |  |  |  |  |  | Year planned to implement alternative delivery models
 |  | Preferred Delivery model if known | Stage of Maturity |  |  | Not applicable | 2011/12 | 2012/13 | 2013/14 | 2014/15
 |  | click on downwards arrow in each cell to display the lists from which choices should be selected |  |  |  | i.e. already delivered
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2 | wrong answer given in cell L12
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 4 | wrong answer given in cell [NAME]
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 3
Spreadsheet: 552673d1513705563-table-functions-book1
Sheet: Sheet1

Time | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
2013-01-01 00:00:00 | 5298 | 4956 | 4814 | 4451 | 4195 | 4076 | 4111 | 4155 | 4210 | 4441 | 4692 | 5002 | 5044 | 4769 | 4312 | 4640 | 5024 | 5474 | 6056 | 6136 | 6113 | 5966 | 5664 | 5442
2013-01-02 00:00:00 | 4966 | 4522 | 4530 | 4308 | 4185 | 4217 | 4528 | 4911 | 5234 | 5503 | 5504 | 5483 | 5490 | 5520 | 5435 | 5766 | 6018 | 6468 | 7100 | 7125 | 6998 | 6695 | 6200 | 5811
2013-01-03 00:00:00 | 5240 | 4770 | 4767 | 4539 | 4389 | 4430 | 4794 | 5290 | 5757 | 6240 | 6265 | 6179 | 6104 | 6080 | 5947 | 6310 | 6605 | 7122 | 7676 | 7685 | 7562 | 6993 | 6445 | 5953
Spreadsheet: john_griffith__15754__10_17_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 58 | 300 | 400 | 41.3 | 55.1 | 1.76 | 2001-10-17 10:29:00
 | [NAME] | 59 | 650 | 750 | 41.4 | 47.8 | 1.65 | 2001-10-17 10:29:00
 | HU F2 | 60 | 825 | 925 | 39.7 | 44.5 | 1.59 | 2001-10-17 10:29:00
 | HU G2 | 61 | 950 | 1075 | 37.2 | 42.1 | 1.52 | 2001-10-17 10:29:00
 | [NAME] | 62 | 1075 | 1200 | 36.9 | 41.2 | 1.52 | 2001-10-17 10:29:00
 | [NAME] | 68 | 1275 | 1400 | 36.3 | 39.9 | 1.63 | 2001-10-17 10:29:00
 | [NAME] | 69 | 1350 | 1500 | 34.8 | 38.7 | 1.59 | 2001-10-17 10:29:00
 | [NAME] | 68 | 1425 | 1575 | 34.6 | 38.2 | 1.56 | 2001-10-17 10:29:00
 | HU N2 |  |  |  | 34.7 | 38.1 | 1.58 | 2001-10-12 14:55:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 13d41970-37e2-4839-abbe-f4413dca06ff
Sheet: Sheet1

2008 FCS Survey List Timeline
Family Financial Management
Please match each topic with the timeline for components of program design
Receive training, Plan, Implement (Present, Mentor), Evaluate
 | 2009/2010 | 2010/2011 | 2011/2012 | 2012/2013 | 2013/2014
2008 FCS Survey Questions
Strengthen Money Management Skills to Build Financial Security
Choose Consumer Goods and Services Wisely by Making Informed Decisions
Take Action Steps to Build Financial Assets and Reduce Debt
Organize and Maintain Household Records
Obtain, Monitor and Use Credit Wisely
Make Informed Decisions About Insurance, Medicare, or Prescription Drug Plans
Make Informed Decisions About Savings, Investments, and Retirement
Make Informed Tax Decisions
Make Informed Decisions About Estate Planning
Become aware of expansion of gambling in Kansas
Not on FCS Survey List but Agents Have Expressed Interest
What to Do When You Lose Your Job/Managing in Economic Crisis
For 3 Academic Credit Hours or 45 Continuting Education Units (CEUs)
Financial Behavior Assessment and Consulting
How to Motivate Clients to Achieve Financial Security
How Multicultural Diversity Impacts Financial Security
Other
a.
b.
c.
d.
e.
Spreadsheet: 143852d1330601519-automatic-entry-into-summary-table-when-matching-various-criteria-blank-sui-form-test-3
Sheet: Summary 

 | Incident / Accident 2011 / 2012 |  | Staff | S U | Other |  | Staff | S U | Other |  | Staff | S U | Other |  | Staff | S U | Other
 | Incident / Accident | April | Staff | SU | Other | May | Staff | SU | Other | June | Staff | SU | Other | July | Staff | SU | Other | August | Staff | SU | Other | September | Staff | SU | Other | October | Staff | SU | Other | November | Staff | SU | Other | December | Staff | SU | Other | January | Staff | SU | Other | February | Staff | SU | Other | March | Staff | SU | Other | Total Notifications and Unusual Occurrence's | Total Incidents / Accidents to Staff | Total Incidents / Accidents to Service User | Total Incidents / Accidents to Other
1 | Death
 | Infectious disease
 | Injury
 | Illness
 | Event that adversely affects the person’s safety & welfare
 | Theft, burglary or accident
 | The termination of accommodation without notice
 | Physical Intervention
 | Temporary Change in Provider's Approval
 | Safeguarding
 | Aggression / Violence
 | Medication Error
 | Seizures
 | Self Injuries Behaviour
 | Manual Handling
 | Slips / Trips / Falls
 | Injury Found cause unknown
 | Unwitnessed Event
 | Security
 | Equipment
 | Other *
 | Hints
 | Allegations
Spreadsheet: 679492d1590450472-how-to-capture-multiple-absences-for-a-specific-employee-and-tabulate-total-time-off-absence-sample
Sheet: Sheet9

PERSON_NUMBER | Leave Type | START_DATE | END_DATE | DURATION in DAYS
1111 | Exception Illness Leave Paid | 2019-07-01 00:00:00 | 2020-05-25 00:00:00 | 329
1111 | Exception Illness Leave Paid | 2019-01-21 00:00:00 | 2019-06-28 00:00:00 | 158
1111 | Exception Illness Leave Paid | 2018-04-23 00:00:00 | 2018-10-17 00:00:00 | 177
2222 | Exception Illness Leave Unpaid | 2018-09-03 00:00:00 | 2020-05-25 00:00:00 | 630
2222 | Exception Illness Leave Unpaid | 2018-04-02 00:00:00 | 2018-08-31 00:00:00 | 151
3333 | General Leave | 2020-04-21 00:00:00 | 2020-07-17 00:00:00 | 87
3333 | General Leave | 2019-09-23 00:00:00 | 2020-01-03 00:00:00 | 102
4444 | General Leave | 2020-04-02 00:00:00 | 2020-05-25 00:00:00 | 53
4444 | General Leave | 2020-01-01 00:00:00 | 2020-01-05 00:00:00 | 4
4444 | General Leave | 2019-01-02 00:00:00 | 2019-12-31 00:00:00 | 363
5555 | Long Term Disability | 2019-05-21 00:00:00 | 2020-05-25 00:00:00 | 370
5555 | Long Term Disability | 2018-05-21 00:00:00 | 2019-05-20 00:00:00 | 364
6666 | Long Term Disability | 2020-01-31 00:00:00 | 2020-05-25 00:00:00 | 115
6666 | Long Term Disability | 2019-07-02 00:00:00 | 2019-12-03 00:00:00 | 154
6666 | Long Term Disability | 2018-03-09 00:00:00 | 2019-02-18 00:00:00 | 346
7777 | Maternity Leave | 2020-02-28 00:00:00 | 2020-05-25 00:00:00 | 87
7777 | Maternity Leave | 2019-03-01 00:00:00 | 2020-02-27 00:00:00 | 363
8888 | STD NonCompliant | 2020-02-13 00:00:00 | 2020-05-25 00:00:00 | 102
8888 | STD NonCompliant | 2020-01-27 00:00:00 | 2020-02-11 00:00:00 | 15
8888 | STD NonCompliant | 2019-08-26 00:00:00 | 2019-09-30 00:00:00 | 35
8888 | STD NonCompliant | 2019-06-20 00:00:00 | 2019-08-11 00:00:00 | 52
Spreadsheet: 759331d1639496508-automatically-copy-data-into-summary-summary-example
Sheet: Sheet1

 |  | [NAME] range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  |  |  |  | Name |  | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  | Data is entered daily into the detail
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 73 | range, left.
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  |  |  |  |  |  | How to automatically add new cell
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go |  |  |  |  |  |  |  |  |  | content from the detail range (left)
 |  |  | [NAME] | into the summary. |  |  |  |  |  |  |  |  |  | into the summary (right)?
 |  | 2021-01-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 74
 |  | etc. |  | etc.
Here is the detail with date, name, score and chit number, to be copied into the summary.
Every time there is new data filled into the detail range, it gets the next chit number, and once that is entered, the chit number, plus
the date, name and score should be automatically added to the summary.
Doing this manually now, but would like to automate... except, that's beyond my formula knowledge. Looking for a working formula.
And to make it a little more complicated...
This is the summary of the B league, with Chits 001-1500.
The A league has Chit numbers 1501 up. Each summary can only contain the data that is applicable to it.
Possibly, there will be a C league in the future.
Spreadsheet: phillip_m_love__30668__200003_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | 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 |  |  |  |  |  |  |  | 0
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: richard_ring__31679__EES-StateStatus_102301
Sheet: Existing Markets

EES Existing Markets
STATE | EES PRIORITY | UTILITY | Cost to Implement | Billing Model | PHYSICAL DELIVERY COMPLETED BY
California | Done | Southern California Edison | Not Available | [NAME] Agent | 1998-04-01 00:00:00 | New enrollments are being accepted. As of today. Check Daily w/ Service Desk.
 | Done | Pacific Gas & Electric | Not Available | [NAME] Agent | 1998-04-01 00:00:00 | New enrollments are being accepted. As of today. Check Daily w/ Service Desk.
 | Done | San Diego Gas & Electric | Not Available | [NAME] Agent | 1998-04-01 00:00:00 | New enrollments are being accepted. As of today. Check Daily w/ Service Desk.
Ohio | Done | First Energy Corp (MSG), [NAME], Cleveland Illuminating, Ohio Edison | 561740 | UDC Consolidated Rate Ready |  | NS needs metering contact for installations - referred to [NAME].
Pennsylvania | Done | PECO Energy | Not Available | UDC Consolidated Rate Ready | 1999-01-01 00:00:00 | Customers w/ expired contracts being dropped. No new enrollments at this time.
New Hampshire | Done | New Hampshire Electric Coop | 50495 | UDC Consolidated Rate Ready |  | Ready to Enroll - No Customers from EES
Maine | Done | Central Maine Power Co | 288570 | UDC Consolidated Rate Ready | 2000-03-01 00:00:00 | New enrollments are being accepted.
 | Done | Bangor Hydro Electric Power |  | UDC Consolidated Rate Ready | 2000-03-01 00:00:00 | Market Manager inquiry - how do we obtain pre-enrollment [NAME]?
Rhode Island | Done | [NAME] | 58040 | UDC Consolidated Rate Ready | 2001-05-01 00:00:00 | 810 Issues - mapping to billing system
New York | Done | Consolidated Edison | 314471 | Dual with [NAME] | 2001-04-01 00:00:00 | 170 Tricon Invoices submitted to customer.  RF researching missing cycles. Enron formed working group to push EDI implementation.  Fite/Government Affairs working directly with utility to execute agency agreement. 1300 mass market customers submitted for October enrollment.
Massachusetts | Done | Western Massachusetts Elec |  | UDC Consolidated Rate Ready | 2001-06-01 00:00:00 | New enrollments are being accepted.
Massachusetts | Done | Massachusetts Electric Co |  | UDC Consolidated Rate Ready | 2001-06-01 00:00:00 | New enrollments are being accepted.
Massachusetts | Done | Cambridge Electric | 2001-06-01 00:00:00 | [NAME] Ready | 2001-07-01 00:00:00 | New enrollments are being accepted.
Massachusetts | Done | BECO | 2001-06-01 00:00:00 | [NAME] Ready | 2001-07-01 00:00:00 | New enrollments are being accepted.
Spreadsheet: 549829d1511954248-query-refresh-error-on-some-pcs-and-not-others-tasks
Sheet: Find Me

[NAME] | Category | Due Date | Owner | Task | Status | Progress Notes
Find Me | SEO | 2017-12-10 00:00:00 | Gillian | Sample Task 1 | Not Started
Find Me | PPC | 2017-12-11 00:00:00 | Stephen | Sample Task 2 | In Progress
Find Me | Social Media | 2017-12-12 00:00:00 | Stephen | Sample Task 3 | Delayed
Find Me | SEO | 2017-12-19 00:00:00 | Gillian | Sample Task 10 | Postponed
Find Me | PPC | 2017-12-20 00:00:00 | Gillian | Sample Task 11 | Not Started
Spreadsheet: 823832d1680162170-before-and-after-tp-location-crossings-tp-location
Sheet: Sheet1

TP LIST |  |  | CROSSINGS |  |  | CROSSINGS BEFORE AND AFTER TP REQUIRED ACCORDING TO CHAINAGE
TP's | Chainage |  | Type of  Crossing | Chainage |  | BEFORE TP | Chainage | AFTER TP | Chainage
TP0 | 0 |  | Pipeline | 263.89 |  | TP7 |  | TP8
TP1 | 4.49 |  | Drain | 265.88 |  | TP7 |  | TP8
TP2 | 7.75 |  | NH | 293.2 |  | TP7 |  | TP8
TP3 | 11.22 |  | Drain | 312.82 |  | TP7 |  | TP8
TP4 | 13.73 |  | BG | 498.36 |  | TP18 |  | TP19
TP5 | 16.05 |  | BT Road | 506.76 |  | TP18 |  | TP19
TP6 | 25.9
TP7 | 258.38
TP8 | 359.9
TP9 | 364.65
TP10 | 369.01
TP11 | 371.98
TP12 | 376.65
TP13 | 389.22
TP14 | 429.69
TP15 | 445.03
TP16 | 456.73
TP17 | 467.54
TP18 | 473.85
TP19 | 516.22
TP20 | 677.55
Spreadsheet: 809842d1671370944-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01
Sheet: Budget vs. Actual 

Budget to Actual YTD
 |  |  |  | Month # | 0
 |  |  |  |  | Cash Beginning of Period
 |  |  | Actuals | Budget | Linear Budget YTD | YTD Actuals
 |  |  | Previous Yr
 |  | Total Revenue:
 |  | Uitgawes:
 |  | [NAME] Ds [NAME]
 |  | [NAME] Ds Pieter**
 |  | Lone (Tuinier)(Eric)
 |  | Lone (Skoonmaker)
 |  | Lone (Week 3)
 |  | Lone (Week 4)
 |  | Lone (Week 5)
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 125258d1318948377-calculating-costs-where-quantities-cover-more-than-one-threshold-threshold
Sheet: Sheet1

 | Pricing Table
Soil Volume (m3) |  | Cost per m3 of Soil dug | [NAME] |  | Example check
From | To |  |  |  | (not needed in the future)
0 | 77820.29999999999 | 2.883562898669931
77820.29999999999 | 854827 | 3.36856416367316
854827 | 942377 | 2.03192505819058
942377 | 1019777 | 3.191864889340609
1019777 | 1160077 | 2.706934891138587
1160077 | 1356827 | 2.816011922107943
Time | Actual  Soil Dug m3 | Cumulative Achieved | Cost of actual m3
Month 1 | 75000 |  | ?
Month 2 | 78000 |  | ?
Month 3 | 700000 |  | ?
Month 4 | 102000 |  | ?
Month 5 | 202000 |  | ?
Month 6 | 105000 |  | ?
 | Your Formula |  |  |  |  | This is necessary to calculate