tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863322d1710855788-look-up-test-2-
Sheet: Sheet2

 |  |  |  |  |  | * | H-HANDBALL
 |  |  |  |  |  |  | F-FORKLIFT
 | [NAME]: | JOE | VEHICLE: | B5CBJ |  | DATE: | 20.03.24
 | WHAT |  | WHERE |  | WHO |  | HOW
 | CUSTOMER | ORDER NO | ADDRESS & WHAT3WORDS |  | CONTACT NUMBER |  | CHECK DETAILS
 |  |  |  |  |  | ADDRESS | ACCESS | OFFLOAD*
 | OSWESTRY GLASS |  |  |  | [PHONE]
 | WYNNSTAY
 | NOTES
Spreadsheet: errol_mclaughlin_jr__10039__NETCO Test Issues_0122
Sheet: Sheet1

 | NETCO Integration testing on Friday 01/22
 |  | Outstanding issues
 |  | Area | Problem | Assigned | Status
 |  | Resolved Issues
 |  | Area | Problem | Assigned | Status
 |  | EnPower/ Canada | [NAME]; Deal Entry; no access to deal leg seqment…  Bug in deal entry? | [NAME] | Resolved
 |  | Global Data setup | Wade Price/ Unify Settlements - Missing Partner Bank Type for External Address Id 49863.  This is needed to finalize the supply statement in Unify | Sundar | Resolved
 |  | Global Data setup/ Replication | Unify Power  - missing addresses |  | Resolved
 |  | Infrastructure | Gas/ Canada/ Trading Cluster/ Tagg/ PortCalc.  No Xterm login under Tagg Menu.  This is needed for RunM unix connection. | [NAME] | IT Closed; Awaiting re-test from user.
 |  | Infrastructure | Gas/ Canada/ Trading Cluster/ Tagg/ PortCalc.  No Xterm login under CPR Menu.   This is needed for RunM unix connection. | [NAME] | IT Closed; Awaiting re-test from user.
 |  | Power Confirms/ Global Data setup | Power/ No address confirms for ENA Corp. | Sundar | IT Closed; Awaiting re-test from user.
 |  | Tagg | Tagg Settlements report not working | [NAME]; [NAME] | Resolved
 |  | Tagg-Metacalc | Tagg-Metacalc-- Error Message: ORA-12154: TNS:could not resolve service name | Lim, [NAME] | IT Closed; Awaiting re-test from user.
 |  | Unify (all) | Unable to xmit to SAP.  Unify was executing older exe code (dated 1/10/02), when should have been executing revised (dated 01/18/02), that included the SAP changes.  Infrastructure resolved migration script and repushed NetCo O:\ to W:\ for Unify EXE code. | [NAME] | Resolved
 |  | Unify Financial Settlements | Region Codes missing.  [NAME] and Financial.  [NAME] will add. | DA group; [NAME] | Resolved
 |  | Unify Financial Settlements/ Infrastructure | Need neptune directories added.  Unify weblogic; missing to SQL Server drivers. | [NAME] Infrastructure | Resolved
 |  | Unify Gas | [NAME] screen (stored procedure) permissions issue - scheduled quantity screen | [NAME] | Resolved
 |  | Unify Gas | [NAME]; unable to see Tennessee Gas Pipeline (or any) under Service Verifications list screen. | [NAME] | Resolved
 |  | Unify Gas/ DBAs | Transport contract (20000057) not replicating to Unify | [NAME] | Resolved
 |  | Unify Power | 1st error - Deal load Error: (%ls conflicted with %ls constraint) | [NAME] | Resolved
 |  | Unify Power | 2nd error - DB error on EnPower deal load  (%ls conflicted with %ls constraint) | [NAME] | Resolved
Spreadsheet: stacey_white__39013__East Sched C Summary 1016
Sheet: 10_31_2001

 |  |  |  |  |  |  |  |  |  |  |  |  |  | CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Schedule C Summary
 |  |  |  |  |  |  |  |  |  |  |  |  |  | As of October 16, 2001
 |  |  |  |  |  |  |  |  |  | Prior Month
 | Portfolio | Book(s) | Date | Desk/Region | Counterparty | Description |  | Amount |  | 2001-09-30 00:00:00 |  | Change |  | Removal Date
 | Power | East | 1998-02-01 00:00:00 | EPMI Southeast - Serc | Florida P & L | FP&L and JEA transactions were entered into as backing deals, but do not completely hedge each other.  This difference in value created a gain which was reserved. |  | 0 |  | -226032 |  | 226032 |  | 2001-10-16 00:00:00
 | Power | East | 2000-09-01 00:00:00 | [NAME] |  | LCRA moved to Enpower |  | -2968598 |  | -2968598
 | Power | East | 2000-06-01 00:00:00 | EPMI Southeast - Into TVA | - | Hedge Amortization |  | -89896978 |  | -89896978
 | Power | East | 2001-05-11 00:00:00 | [NAME] | BP Energy - Green Mountain | Energy, ancillary and QSE reserve |  | -2090503 |  | -2090503
 | Power | East | 2000-11-01 00:00:00 | NE-Trans | New York ISO | TCC Auction Payment |  |  |  | 610941 |  | -11594 |  | 2001-10-01 00:00:00
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: 4th 2003032

4th Floor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Diet Dr. Pepper | 0.56
Sprite | 0.56
Dr Pepper | 0.56
Bottled Tea | 0.86
Hydrolyte Honey Water | 0.32
Hydrolyte Honey tea | 0.37
Hydrolyte Nectar Water | 0.32
Hydrolyte Nectar Tea | 0.35
Cereal-Cheerios | 0.39
Cereal-Corn Flakes | 0.39
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
Soup, [NAME] | 0.72
Broth, [NAME] | 0.1
Pudding-Vanilla | 0.28
Diet Vanilla Pudding | 0.35
Chocolate Pudding | 0.28
[NAME] | 0.28
[NAME] | 1.13
Applesauce | 0.32
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Juice Prune | 0.66
[NAME] | 0.16
Ice Cream-Vanilla | 0.41
Ice Cream- Diet-Vanilla | 0.43
Orange Sherbert | 0.5
Popcicles | 0.2
Milk- Skim | 0.25
2% Milk | 0.25
[NAME] | 1.47
Coffee Decaf  cs. | 37.84
Coffee, [NAME]. cs. | 95.11
Coffee, [NAME]. cs. | 95.11
Creamer, non dairy box | 0.03
Tea Bags | 0.03
[NAME] | 0.13
[NAME] | 0.11
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
Salt/Pepper | 0.02
Ensure | 0.13
Glucerna | 0.4
Jevity | 0.35
Nepro | 1.03
[NAME] | 15.6
Vital | 3.05
Osmolite | 0.25
Perative | 1.39
2Cal HN | 0.4
[NAME] | 1.5
Promote | 0.23
Pulmocare | 0.44
Pivot | 2.18
Juven | 2.1
[NAME] | 1.75
Sugar | 0.02
Sweetner-Equal | 0.03
Sweetner-Sweet N Low | 0.03
Sweetner-Splenda | 0.03
[NAME] | 2.5
[NAME] | 11
Plastic Ware (fork,spoon knife) | 0.03
[NAME]-pkts. | 2.4
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
Salt/Pepper | 0.02
Sweetner-Splenda | 0.03
[NAME] | 0.16
Monthly coffee
Monthly Total
 |  |  |  |  |  |  | 2Cal HN | 0.4
Spreadsheet: 833842d1687275916-conditional-formatting-of-multiple-conditions-based-on-a-date-in-another-cell-master-project-template-for-help-2-solution-etaf-2-
Sheet: Shannon

 | Project Manager | Shannon
 | Projects Assigned
 | Test Project
Feasibility | feasibility notes
Schematic Design | schematic design notes
Preliminary |  | preliminary notes
NCC Preliminary
Preliminary Engineering
Final
NCC Final
Changes After Final
Permit
Under Construction
UC Revisions
Marketing
On Hold
Consulting
[NAME]
Complete
Reuse/Plan Order
Spreadsheet: 04e49500-f127-4d72-85f7-374ea741918a
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 21. Value of Dwelling Units Approved in New Residential Buildings, Original, Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  New ;  Total houses ; |  |  | Original | A418405W | 1970-07-01 00:00:00 | 2010-08-01 00:00:00 | 482 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415787K | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422928K | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416423R | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423531F | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424176T | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424728C | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417065V | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total other residential building ; |  |  | Original | A419140V | 1970-07-01 00:00:00 | 2010-08-01 00:00:00 | 482 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total residential building ; |  |  | Original | A419826L | 1956-01-01 00:00:00 | 2010-08-01 00:00:00 | 656 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 851252d1701464003-all-data-in-column-1-questions-about-moving-some-to-other-columns-my-library-audiblecom-2-11-28-2023-test
Sheet: Sheet1

My Library | Audible.com
TITLE | AUTHOR | NARRATOR | SERIES | SYNOPSIS
The Woman Who Walked In Sunshine
By: [NAME]
Narrated by: [NAME]
Series: The No. 1 Ladies Detective Agency , Book 16
Business is slow at the No. 1 Ladies' Detective Agency, so slow in fact that for the first time in her estimable career Precious Ramotswe has reluctantly agreed to take a holiday....
The Handsome Man's Deluxe Café
Series: The No. 1 Ladies Detective Agency , Book 15
Mma [NAME] has her hands full both at home and in the office. To add to her current challenges, her devoted partner, [NAME], has decided to branch out on her own....
The Minor Adjustment [NAME]: No. 1 Ladies' Detective Agency, Book 14 Precious Ramotswe has taken on two puzzling cases. First, she is approached by the lawyer [NAME], who is the executor of a deceased farmer’s estate....
The Limpopo Academy of Private Detection: No. 1 Ladies' Detective Agency, Number 13
Precious Ramotswe’s attention is focused on a pesky disciplinary problem at her adopted daughter’s school....
The Saturday Big Tent Wedding Party: The No. 1 Ladies Detective Agency, Book 12 This 12th entry from [NAME] New York Times best-selling series showcases the humanity and matchless wit that define Precious Ramotswe....
The Double Comfort Safari Club: The No. 1 Ladies' Detective Agency
Series: The No. 1 Ladies Detective Agency , Book 11
[NAME] internationally best-selling and award-winning series starring Botswana’s leading lady detective continues with this 11th charming tale....
The Good Husband of [NAME]: The No. 1 Ladies' Detective Agency
Series: The No. 1 Ladies Detective Agency , Book 8
Mr. [NAME] asks to be put in charge of a case involving an errant husband.
But Mma [NAME] doubts a man can investigate such matters as successfully as the number-one lady detective can....
In the Company of Cheerful Ladies: The No. 1 Ladies' Detective Agency
8
Spreadsheet: 1c98aeae-6e9f-4389-9d8c-ae7cdf65179f
Sheet: Single Voucher

Note:  Please ensure you attach Tax Invoices or Receipts (and Entertainment Form where necessary).
 |  |  |  |  |  |  |  |  |  |  |  | Version 2.1              Mar 2012
PETTY CASH VOUCHER
 |  | DEPARTMENT:
 |  | Name of Purchaser: |  |  |  |  |  | Date of Reimbursement:
Rec # | Particulars of Claim |  |  |  | GST Excl Amount | GST Amount | Gross Amount | Account | Fd | Dept | Prg | Proj
1 |  |  |  |  |  |  |  |  | 2
2 |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  | 2
4 |  |  |  |  |  |  |  |  | 2
Total of Claim
 | Receipt for Cash Advance** |  |  | Cash Reimbursement for Expenditure
Received from University of Southern Queensland |  |  |  | I certify that the above claim is properly due and payable and I approve the relevant expenditure in accordance with Section 3.5 of the
$................................... |  | …../…../…..
 |  | Date |  |  | USQ Petty Cash Policy |  |  |  | USQ Petty Cash Policy
………………………………..……………………….
Signature, purchaser **
By signing for this advance I have read and agree to the procedures outlined in Sections 3.5 and 3.6 of the
**USQ Petty Cash Policy
…...………..…………..……………………………… |  |  |  | ……………………………………………………………. |  |  |  | …………………………………………………
Signature of [NAME] |  |  |  | Signature of Petty Cash Custodian |  |  |  | Signature of Purchaser
Spreadsheet: 79d71083-6d26-4baa-9c08-2ec1890de6c7
Sheet: Sheet1

Unnamed: 0 | Konzern-Gewinn- und [NAME]. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | in Mio. € | Anmerkung | 2008 | 2007* | 2006*
 | Umsatzerlöse | 1 | 61 666 | 62 516 | 61 347
 | [NAME] | 2 | (34 592) | (35 337) | (34 755)
 | Bruttoergebnis vom Umsatz |  | 27 074 | 27 179 | 26 592
 | Vertriebskosten | 3 | (15 952) | (16 644) | (16 410)
 | Allgemeine Verwaltungskosten | 4 | (4 821) | (5 133) | (5 264)
 | Sonstige betriebliche [NAME] | 5 | 1 971 | 1 645 | 1 257
 | Sonstige betriebliche [NAME] | 6 | (1 232) | (1 761) | (888)
 | Betriebsergebnis |  | 7 040 | 5 286 | 5 287
 | Zinsergebnis | 7 | (2 487) | (2 514) | (2 540)
 | Zinserträge |  | 408 | 261 | 297
 | Zinsaufwendungen |  | (2 895) | (2 775) | (2 837)
 | Ergebnis aus at equity bilanzierten Unternehmen | 8 | (388) | 55 | 32
 | [NAME] | 9 | (713) | (374) | (167)
 | Finanzergebnis |  | (3 588) | (2 833) | (2 675)
 | Ergebnis vor Ertragsteuern |  | 3 452 | 2 453 | 2 612
 | Ertragsteuern | 10 | (1 428) | (1 373) | 970
 | [NAME] |  | 2 024 | 1 080 | 3 582
 | [NAME] [NAME] | 11 | 541 | 509 | 409
 | Konzernüberschuss
 | (Gesellschaftern des Mutterunternehmens zuzurechnendes Ergebnis) |  | 1 483 | 571 | 3 173
 | [NAME] | 12
 | Unverwässert |  | 0.34 | 0,13 | 0,74
 | Verwässert |  | 0.34 | 0,13 | 0,74
 | * Vorjahreswerte angepasst. Bilanzierungsänderung im [NAME] mit IFRIC 12. Erläuterungen unter „Grundlagen und Methoden/Änderung der Bilanzierungs- und Bewertungsmethoden“.
Spreadsheet: 710059d1608696372-lookup-issues-lookupissues
Sheet: XLookup

 |  |  |  |  | ID | ID Working | FLAG | Region | ID |  | My Comments
 |  |  |  |  | 2361 | 2269 |  | 701 | 2269
ID | Flag | Product ID | ID2 |  |  |  | XLOOKUP(F2 & "",Test[[#All],[ID]:[ID2]],Test[[#All],[Flag]]) |  |  |  | Does not work
2024 | Yes | 202 | 2024 |  |  |  | XLOOKUP($F$2&" ",Test[ID],Test[[Flag]:[ID2]]) |  |  |  | Does not work
2024 | Yes |  | 2024 |  |  |  | XLOOKUP($G$2,Test[ID],Test[[Flag]:[ID2]]) |  |  |  | Working
2024 | Yes | 406 | 2024 |  |  |  | VLOOKUP(F2,Test[[ID]:[ID2]],3)
2269 | Show? | 701 | 2269 |  |  |  | VLOOKUP(F2&" ",Test[[ID]:[ID2]],2) |  |  |  | Wrong and Does not change
2361 | Adam | 703 | 2361 |  |  |  | VLOOKUP($G$2,Test,2) |  |  |  | Working
2361 | Yes | 202 | 2361
2361 | Yes | 280 | 2361
2361 | Yes |  | 2361
2361 | Yes |  | 2361
2361 | Yes | 202 | 2361
2361 | Yes |  | 2361
2361 | Yes | 280 | 2361
Spreadsheet: 750824d1633661604-count-continuous-instances-and-get-max-value-from-corresponding-column-sample-58-
Sheet: Sheet1

Quantity | Category |  | Variable | Values
625 | 1 |  | Low-Count
616 | 1 |  | Low-maxQtyForLow
578 | 1 |  | Low-continuous count
571 | 1 |  | Low-maxQtyForContinuousCount
571 | 1
6030 | 2 |  | Medium-Count
2430 | 2 |  | Medium-maxQtyForMedium
1030 | 1 |  | Medium-continuous count
920 | 1 |  | Medium-maxQtyForContinuousCount
2920 | 2
2750 | 2
2690 | 2
2540 | 2
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-14-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 766368d1643874797-risk-assessment-with-multiple-likelihood-and-consequence-inputs-risk-assessment-template
Sheet: Risk Register

 |  |  |  |  |  |  |  |  | RISK ASSESSSMENT
Category | Item | Risk Title | Causes Triggers Indicators | Impacts Consequences | Existing Controls |  | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Likelihood | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Consequence | Rating
Ref. |  | Risk Description |  |  |  |  | Likelihood |  |  |  |  |  |  |  | Consequence
A | Due Diligence
A | 1 | RISK TITLE |  |  |  |  | Almost Certain | Likely | Remote | Possible | [NAME] |  |  |  |  |  | Catastrophic |  | Minor | Moderate
Spreadsheet: 730471d1619708718-highlight-date-range-on-calendar-ef1523_test-2-copy
Sheet: Hire

 |  |  |  |  |  |  |  |  | HIRE RECORD
Hire_start |  |  |  |  | Hire_end
Hire Start Date | M/C No. | Customer | Site | Machine Hours | Hire End Date | Machine Hours | Hire Period Weeks | Total Hire Hours | Comments
2020-02-17 00:00:00 | 39 | S-LL | LL |  | 2020-02-19 00:00:00
2020-05-08 00:00:00 | 39 | S-LL | LL |  | 2020-05-28 00:00:00
2020-05-01 00:00:00 | 39 | L - Lanark | Lanark
2020-06-10 00:00:00 | 39 | L - Lanark | Lanark |  | 2020-06-17 00:00:00
2020-07-06 00:00:00 | 39 | L - Lanark | Lanark |  | 2020-07-10 00:00:00
2020-07-13 00:00:00 | 39 | S - Bredbury | [NAME] |  | 2020-08-07 00:00:00
2020-09-21 00:00:00 | 39 | HH | Bury |  | 2020-09-23 00:00:00
2020-09-30 00:00:00 | 39 | CS | WS |  | 2020-11-17 00:00:00
2020-10-22 00:00:00 | 33 | LE | London |  | 2020-11-17 00:00:00
2020-11-17 00:00:00 | 33 | CS | WS
2020-11-24 00:00:00 | 39 | RL | Preston |  | 2020-11-24 00:00:00
2020-11-24 00:00:00 | 39 | RL | Preston |  | 2020-12-04 00:00:00
2020-11-25 00:00:00 | 33 | DS | [NAME] |  | 2020-11-25 00:00:00
2020-11-25 00:00:00 | 33 | DS | [NAME]
2020-12-08 00:00:00 | 39 | DS | [NAME] |  | 2021-01-28 00:00:00
2021-03-22 00:00:00 | 38 | Met | Country |  | 2021-03-24 00:00:00
2021-03-25 00:00:00 | 38 | Met | London
2021-03-25 00:00:00 | 39 | Trans | Hull
Spreadsheet: 356735d1415198154-matching-comparing-data-from-2-tables-example-for-excel-thread-v1
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Table 3A (Desired Results) |  |  |  | Table 3B (Secondary Desired Results if Table 3A isn't possible)
Name | Value |  |  |  | Name | State |  |  |  | Name | State | Value |  | Name | State | Value
[NAME] | 1000 |  |  |  | Benard | Texas |  |  |  | [NAME] |  |  |  | [NAME] | Alabama | 1000
Benard | 2000 |  |  |  | [NAME] | Tennessee |  |  |  | Benard |  |  |  | Benard | Texas | 2000
[NAME] | 3000 |  |  |  | Emily | South Carolina |  |  |  | [NAME] |  |  |  | [NAME] | Kentucky | 3000
[NAME] | 4000 |  |  |  | [NAME] | Kentucky |  |  |  | [NAME] |  |  |  | Emily | South Carolina | 5000
Emily | 5000 |  |  |  | [NAME] | Alabama |  |  |  | Emily |  |  |  | [NAME] | Tennessee | 6000
[NAME] | 6000 |  |  |  |  |  |  |  |  | [NAME]
Gayle | 7000 |  |  |  |  |  |  |  |  | Gayle
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -14096 | -14000
2 | -29052 | -29000
3 | -28909 | -28963
4 | -29235 | -29000
5 | -13842 | -14000
6 | -13715 | -14000
7 | -14374 | -14000
8 | -14059 | -14000
9 | -14018 | -14000
10 | -13988 | -14000
11 | -14090 | -14000
12 | -14023 | -14000
13 | -14061 | -14000
14 | -13994 | -14000
15 | -13261 | -14000
16 | -28987 | -28999
17 | -28996 | -28999
18 | -28948 | -28999
19 | -27796 | -27859
20 | -13888 | -14000
21 | -14432 | -14000
22 | -15470 | -14000
23 | -14866 | -14000
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -27179.17
2002-02-23 00:00:00
CBS Volume
 |  |  | -12
Spreadsheet: larry_campbell__21448__Cash Out Prices for November 2000
Sheet: Elizabethtown

Rates Stated per Therm |  | Elizabethtown Gas Company
 |  | Accounts |  | Cashout - Without Standby
 |  | with Standby |  | Tier 1 | [NAME] | Tier 3
Underdeliveries |  | 0.5661 |  | 0.5732 | 0.5945 | 0.7377
Overdeliveries |  | Per Tier Rate |  | 0.4789 | 0.431 | 0.3592
Gas Flow Month: November 2000
November 2000 - BTU Factor - |  | 1.032
December 2000 - BTU Factor - |  | 1.033
Spreadsheet: 831110d1685431030-match-and-sum-match-and-sum3
Sheet: Sheet1

Case1
 |  |  |  | Expected result
Magh | Ma-45/49/54 | [NAME]
Case2
 |  |  |  |  |  |  | Expected result
Magh | Ma-45/49/54 | [NAME]
Case3 |  |  |  |  |  |  | Expected result
 | Ma-45/49/54 | [NAME] |  |  |  |  | 4626/2023.5.26,846/2023.5.24,342/2023.5.27
Spreadsheet: 5215731f-5f17-4235-88b7-87c220bca067
Sheet: Sheet1

Agency | Name | Phone Number | E-mail address | Name.1 | Phone Number.1 | E-mail address.1 | Name.2 | Phone Number.2 | E-mail address.2
Aging | [NAME] | 783-5166 | [EMAIL] | [NAME] | 783-8613 | [EMAIL]
Agriculture | [NAME] Smyser | 787-1065 | [EMAIL] | [NAME] | 787-1065 | [EMAIL] | Ericka Warner | 787-1065 | [EMAIL]
Banking & Securities | [NAME] | 783-3611 | [EMAIL]
Civil Service Commission | [NAME] | 783-2691 | [EMAIL]
Community and Economic Development | [NAME] | 783-0331 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Conservation and Natural Resources | [NAME] | 346-3962 | [EMAIL] | [NAME] | 705-3741 | [EMAIL]
Corrections | [NAME] | 728-5355 | [EMAIL] | [NAME] | 728-5351 | [EMAIL]
Drug & Alcohol Programs | [NAME] | 783-5446 | [EMAIL]
Education | [NAME] | 783-9343 | [EMAIL]
Environmental Protection | Renata E. Moseley | 787-8476 | [EMAIL]
Executive Offices | [NAME] | 783-5446 | [EMAIL]
Fish And Boat Commission | [NAME] | 705-7825 | [EMAIL]
Game Commission | [NAME] | 787-7836 | [EMAIL]
General Services | [NAME] | 783-0828 | [EMAIL]
Governor's Office | [NAME] | 787-5330 | [EMAIL]
Health | [NAME] | 547-3197 | [EMAIL]
Historical & Museum Commission | [NAME] | 783-5446 | [EMAIL]
Insurance | [NAME] | 787-8027 | [EMAIL]
Labor & Industry | [NAME] | 787-2453 | [EMAIL]
Lieutenant Governor's Office | [NAME] | 783-5446 | [EMAIL]
Liquor Control Board | [NAME] | 783-9853 | [EMAIL]
Military and Veterans Affairs | [NAME] | 861-8850 | [EMAIL] | [NAME] | 861-6372 | [EMAIL]
Milk Marketing Board | [NAME] | 783-5446 | [EMAIL]
Municipal Retirement Board | [NAME] | 787-2065 | [EMAIL]
PA Emergency Management Agency | [NAME] | 651-2018 | [EMAIL]
PA Human Relations Commission | [NAME] | 783-5446 | [EMAIL]
Pennvest | [NAME] | 783-5446 | [EMAIL]
Probation And Parole Board | [NAME] | 787-5699 x 216 | [EMAIL]
Psers | [NAME] | 720-4738 | [EMAIL] | [NAME] | 720-4739 | [EMAIL]
Public Utility Commission | [NAME] | 787-8714 | [EMAIL]
Public Welfare | [NAME] | 525-5477 | [EMAIL] | [NAME] | 783-9310 | [EMAIL]
Revenue | [NAME] | 787-2709 | [EMAIL] | [NAME] | 787-2709 | [EMAIL]
State | [NAME] | 783-9274 | [EMAIL] | [NAME] | 787-6604 | [EMAIL]
State Emp Retirement Board | [NAME] | 237-0242 | [EMAIL] | [NAME] | 237-0265 | [EMAIL]
State Police | [NAME] | 787-6941 | [EMAIL] | [NAME] | 783-5547 | [EMAIL]
State Tax Equalization Board | [NAME] | 787-5950 | [EMAIL]
Transportation | [NAME] | 783-0331 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Turnpike | [NAME] | 831-7178 | [EMAIL]
Revised 12/17/13