tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7251__saledoc02_12TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-11 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/12/2002-02/28/02 |  |  | FAX Number:
Total Quantity |  |  | 3757 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.12
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/12/2002 | 2002-02-28 00:00:00 | 3757 |  | 221 |  | 221
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 221 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: andy_zipper__166__DYNEGY-ICE VOL Apr10
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-10-01 thru Apr-10-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-10-01 | 807118390 |  | Bought | NG Fin BS, LD1 for IF | NNG-Demarc | [NAME] | May-01-01 | Oct-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | -0.0025 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-10-01 | 182709986 |  | Bought | NG Fin BS, LD1 for IF | NNG-Demarc | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 5000 | Daily | 920000 | MMBtus | [NAME], G
Apr-10-01 | 114301752 |  | Sold | NG Fin BS, LD1 for IF | Perm | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 0.12 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-10-01 | 142546810 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | El Paso Merchant Energy L.P. | -0.04 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-10-01 | 20647580616 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | El Paso Merchant Energy L.P. | 5.015 | USD / MMBtu | 10000 | Daily | 3650000 | MMBtus | [NAME], J
Apr-10-01 | 557500354 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.045 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-10-01 | 665394820 |  | Sold | NG Fin BS, LD1 for IF | Perm | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 0.165 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], G
Apr-10-01 | 112311350 |  | Bought | NG [NAME], ID, IF | NNG-Demarc | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | -0.0025 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-10-01 | 173944995 |  | Bought | NG Fin BS, LD1 for IF | NNG-Demarc | [NAME] | May-01-01 | Oct-31-01 |  |  |  | Aquila Risk Management Corp. | 0.005 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-10-01 | 665080940 |  | Sold | NG Fin BS, LD1 for IF | NNG-Demarc | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Risk Management Corp. | -0.01 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-10-01 | 457659614 |  | Sold | NG [NAME], ID, IF | NNG-Demarc | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | -0.0025 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-10-01  Deals
Spreadsheet: 166729d1341760585-consolidate-2-tables-into-one-forum
Sheet: Sheet1

Tabe1 |  | table 2 |  |  | wanted results
Part |  | Part | child |  | Part | child
1 |  | 1 | a |  | 1 | a
2 |  | 1 | d |  | 1 | d
3 |  | 1 | r |  | 1 | r
2 |  | 2 | t |  | 2 | t
3 |  | 2 | y |  | 2 | y
1 |  | 4 | r |  | 3
 |  | 4 | t
 |  | 5 | y
 |  | 6 | y
Spreadsheet: 68239d1268770130-excel-2007-solved-if-function-with-4-conditions-andy9988
Sheet: INPUT

TODAYS DATE
2010-03-16 00:00:00
Nirav | DOB | AGE |  | A
 |  |  | 100000 | 0
X | 2010-03-16 00:00:00 | 0 | 150000 | 0
 |  |  | 200000 | 3183
Z | 1990-11-30 00:00:00 | 19.3041095890411 | 250000 | 0
 |  |  | 300000
A | 2006-01-03 00:00:00 | 4.2 | 350000 | 0
 |  |  | 400000
B | 2002-01-01 00:00:00 | 8.208219178082192 | 450000 | 0
 |  |  | 500000
C | 2010-03-16 00:00:00 | 0 | 600000 | 0
 |  |  | 700000 | 0
D | 2004-01-01 00:00:00 | 6.208219178082191 | 800000 | 0
 |  |  | 900000 | 0
 |  |  | 1000000 | 0
ADULT |  | 1
CHILD |  | 3
[NAME] |  | 19.3041095890411
Spreadsheet: 801780d1666366881-pull-information-from-one-sheet-if-criteria-met-mock-up-1-
Sheet: West Section

ID | Deed | Last Name | First Name | Birth Date | Death Date | Burial Date | Burial Type | Cemetery | Section | Block | Lot | Space | Funeral Home | Notes | Owner
 |  | UNAVAILABLE | UNAVAILABLE |  |  |  |  | W | West | 7 | 1 | 1 |  | TREE | UNAVAILABLE
 |  | UNAVAILABLE | UNAVAILABLE |  |  |  |  | W | West | 7 | 1 | 2 |  | TREE | UNAVAILABLE
 |  | UNAVAILABLE | UNAVAILABLE |  |  |  |  | W | West | 7 | 1 | 3 |  | TREE | UNAVAILABLE
 |  | UNAVAILABLE | UNAVAILABLE |  |  |  |  | W | West | 7 | 1 | 4 |  | TREE | UNAVAILABLE
 |  | [NAME] | [NAME] | 1900-12-25 00:00:00 |  |  |  | W | West | 7 | 2 | 1
 |  | [NAME] | Sara | 1902-04-18 00:00:00 |  |  |  | W | West | 7 | 2 | 2
 |  | Elf | [NAME] | 1964-12-06 00:00:00 |  |  |  | W | West | 7 | 2 | 3
 |  | AVAILABLE | AVAILABLE |  |  |  |  | W | West | 7 | 2 | 4 |  |  | AVAILABLE
 |  | AVAILABLE | AVAILABLE |  |  |  |  | W | West | 7 | 3 | 1 |  |  | AVAILABLE
 |  | AVAILABLE | AVAILABLE |  |  |  |  | W | West | 7 | 3 | 2 |  |  | AVAILABLE
 |  | AVAILABLE | AVAILABLE |  |  |  |  | W | West | 7 | 3 | 3 |  |  | AVAILABLE
 |  | AVAILABLE | AVAILABLE |  |  |  |  | W | West | 7 | 3 | 4 |  |  | AVAILABLE
 |  | Pumpkin | Great | 1966-10-31 00:00:00 |  |  |  | W | West | 8 | 1 | 1
 |  | Cottontail | [NAME] | 1971-04-04 00:00:00 |  |  |  | W | West | 8 | 1 | 2
 |  | Appleseed | [NAME] | 1948-06-27 00:00:00 |  |  |  | W | West | 8 | 1 | 3
 |  | Bunyan | [NAME] | 1958-08-01 00:00:00 |  |  |  | W | West | 8 | 1 | 4
 |  | UNAVAILABLE | UNAVAILABLE |  |  |  |  | W | West | 8 | 2 | 1 |  | BENCH | UNAVAILABLE
 |  | UNAVAILABLE | UNAVAILABLE |  |  |  |  | W | West | 8 | 2 | 2 |  | BENCH | UNAVAILABLE
Spreadsheet: 241ba68d-4c7b-4fab-a0ea-5409bef04012
Sheet: Sheet1

The Master's College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Church name here | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Distance Education Extension Program |  |  |  |  |  |  | Church address here
Student Application Tracking Sheet |  |  |  |  |  |  | Church contact person name here.
Student Name | Phone #: | E-mail Address: | Application Fee Received  (amount) | Date Application Received | Date Testimony Received: | Date Pastoral Reference Received | Date Proctor Form Received  (for-credit students) | Date H.S. Transcripts Received (for-credit students) | Date Sent to TMC DEEP for Admission | Proctor form submitted to TMC (as necessary)
Spreadsheet: 79969d1280227406-auto-fill-date-time-timestamp
Sheet: Sheet1

 | Data | Timestamp | Data backup | Timestamp Backup | Timestamp
 | 24 | 2010-07-21 22:11:21 | 1 – 24 | 1 – 40380.[PHONE] | 2010-07-21 22:11:23
 | 35 | 2010-07-21 22:11:21 | 4 – 35 | 4 – 40380.[PHONE] | 2010-07-21 22:11:51
 | 45 | 2010-07-21 22:11:21 | 3 – 45 | 3 – 40380.[PHONE] | 2010-07-21 22:11:54
Spreadsheet: 771973d1646936063-extract-data-with-conditions-extracting-data-based-on-conditions
Sheet: Sheet1

PRODUCT CODE | PRODUCT NAME |  |  | PRODUCT CODE | BENCHMARK NAME
 | UNITED KINGDOM |  |  | AAA | United Kingdom Sales |  |  | United Kingdom Sales
AAA |  |  |  | BBB | United Kingdom Sales |  | BBB | United Kingdom Sales
BBB |  |  |  | CCC | France Sales |  | CCC | France Sales
 | Benchmark 1: United Kingdom Sales |  |  | DDD | Spain Sales |  | DDD | Spain Sales
 | FRANCE |  |  | EEE | Spain Sales |  | EEE | Spain Sales
CCC |  |  |  | FFF | Germany Sales |  | FFF | Germany Sales
 | Benchmark 1: France Sales
 | SPAIN |  |  |  |  |  |  | United Kingdom Sales
DDD |  |  |  |  |  |  | BBB | United Kingdom Sales
EEE |  |  |  |  |  |  | CCC | France Sales
 | Benchmark 1: Spain Sales |  |  |  |  |  | DDD | Spain Sales
 | GERMANY |  |  |  |  |  | EEE | Spain Sales
FFF |  |  |  |  |  |  | FFF | Germany Sales
 | Benchmark 1: Germany Sales
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 83 | - | 63
Cross-Currency Fixed-Fixed | - | 9 | - | 11
Cross-Currency Fixed-Float | - | 37 | - | 27
TOTAL | - | 129 | - | 101
Spreadsheet: 01297aa9-d690-4f5b-a0d4-8262ddca37fd
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 36. Value of Building Approved - Northern Territory
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 ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A420418X | 1970-07-01 00:00:00 | 2011-03-01 00:00:00 | 489 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420430R | 1973-07-01 00:00:00 | 2011-03-01 00:00:00 | 453 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420442X | 1973-07-01 00:00:00 | 2011-03-01 00:00:00 | 453 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | [NAME] | 1970-07-01 00:00:00 | 2011-03-01 00:00:00 | 489 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422768K | 1973-07-01 00:00:00 | 2011-03-01 00:00:00 | 453 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 136026d1326378200-sales-by-month-ef8_sample-sales-by-month
Sheet: Converted to Pivot Table Data

ABC Customer | 2009-01-31 00:00:00 | 1215
ABC Customer | 2009-02-28 00:00:00 | 3411.5
ABC Customer | 2009-03-31 00:00:00 | 5559.7
ABC Customer | 2009-04-30 00:00:00 | 1744.8
ABC Customer | 2009-05-31 00:00:00 | 592.83
ABC Customer | 2009-06-30 00:00:00 | 1741.1
ABC Customer | 2009-07-31 00:00:00 | 692.2
ABC Customer | 2009-08-31 00:00:00 | 1942.49
ABC Customer | 2009-09-30 00:00:00 | 0
ABC Customer | 2009-10-31 00:00:00 | 0
123 Customer | 2009-01-31 00:00:00 | 0
123 Customer | 2009-02-28 00:00:00 | 0
123 Customer | 2009-03-31 00:00:00 | 0
123 Customer | 2009-04-30 00:00:00 | 0
123 Customer | 2009-05-31 00:00:00 | 0
123 Customer | 2009-06-30 00:00:00 | 0
123 Customer | 2009-07-31 00:00:00 | 1873.1
123 Customer | 2009-08-31 00:00:00 | 2383.36
123 Customer | 2009-09-30 00:00:00 | 2667.93
123 Customer | 2009-10-31 00:00:00 | 1388.17
Spreadsheet: 682358d1592043743-find-multiple-text-vales-multiple-find
Sheet: Multiple find

 | # | Emp. ID. | Name
 |  |  | Abhimanyu-38584 Emp Adv
 |  |  | Avinash Karan-161951 Emp Adv ([NAME])
 |  |  | Deepak Karki-161598 Emp Adv ([NAME])
 |  |  | [NAME]
 |  |  | Prashant Sharma-Emp 1041509
 |  |  | [NAME] Emp Id-143865
 |  |  | Anil Kumar Emp Id-44341
 |  |  | Ubes Ullah EMP ID-117878
 |  |  | Mohit Balayan Emp Id: 68803
 |  |  | N Balakrishnan Emp Id: 89832
 |  |  | [NAME]
 |  |  | A.RAVINDER Emp Id-86729
 |  |  | A SHRAVAN KUMAR Emp Id-171166
 |  |  | S SHASHIDHAR REDDY - Emp Id.47848
 |  |  | VARIKUPPALA VISHNU Emp Id-1007300
 |  |  | B [NAME] Id.76216
 |  |  | BALAJI AJIT SINGH - 75028
 |  |  | [NAME] ID-1003876
 |  |  | BARWADI VINAYA REDDY Emp Id-144172
 |  |  | Bharat Reddy - 58225
 |  |  | Chavva [NAME]
 |  |  | D Ravi Kumar - Emp Id.47773
 |  |  | Ganesh -69027
 |  |  | [NAME] Kumar-47781_x000D_
 |  |  | [NAME] Kumar Emp Id.47784
 |  |  | G V M Ramesh Emp Id-79492
 |  |  | RAJEEV KUMAR BAJAJ EMP ID-42638(KARVY FINTECH)
 |  |  | RAMBABU Emp Id-61778
 |  |  | Satish Gandeti Emp 79362
 |  |  | Shaik Saleem - 47778_x000D_
 |  |  | Shanmukha Sai Emp Id-63501
 |  |  | [NAME] Id 52025
 |  |  | Suresh Nallana - Emp Id.47783
 |  |  | Vishal Jadhav
 |  |  | [NAME] Emp Id-68371
 |  |  | Y GIRI HARSHINI EMP ID-72409
 |  |  | [NAME]
 |  |  | S Ravi Emp Id:61114
 |  |  | S Kumar(Banglore)
 |  |  | J Kannan Emp Id:78908
 |  |  | [NAME])
 |  |  | [NAME] Emp- 8415
 |  |  | Kanhaiya Kumar - NPR
 |  |  | [NAME] (Con) Lucknow Po Emp ID
 |  |  | [NAME] EMP ID-57675
 |  |  | [NAME]
 |  |  | Priyank [NAME] Emp Id.45678
 |  |  | Rajendra Kumar Vermaemp Id.1059880
 |  |  | [NAME] Id.75038
 |  |  | Kishor Varma Emp Id:82639
 |  |  | [NAME]
 |  |  | Anil Kumar [NAME] Id.64332
 |  |  | A Phanindra Kumar Emp Id:29 - Others
 |  |  | Ch. Murali Krishna Emp Id:11568 - Others
 |  |  | [NAME] Emp Id:1002631
 |  |  | K Pandu Emp Id-28400 - Others
 |  |  | [NAME]
 |  |  | [NAME] Id 52025-Others
 |  |  | SUDHAKAR REDDY J EMP ID-89321
 |  |  | T K Rengamoorthy-Emp Id.48138 - Others
 |  |  | V Mahesh Emp Id:753 - Others
 |  |  | PRAKASH KUMAR DUTTA-EMP NO.24815
 |  |  | Samaresh Karan Emp Id-73505
 |  |  | [NAME] Kumar Singh Emp Id-58125
 |  |  | Vinit Kumar Soni Emp Id-18740
 |  |  | [NAME] Id
 |  |  | Dipali M.Khawale Emp Id-70113
 |  |  | [NAME] Id-54922
 |  |  | Chandrakant Pote Emp Id-125629
 |  |  | [NAME] Emp Id.
 |  |  | [NAME] [NAME] Id.55865
 |  |  | Durga [NAME] Id
 |  |  | [NAME] Id: 47390
 |  |  | M NAGA ROHINI (NFHS)
 |  |  | Ramesh Awasthi-2000
 |  |  | Vijay Kumar [NAME] Id:66866 ([NAME])
Spreadsheet: 6a4759bb-e65c-49a9-953d-3b1b995e0ba4
Sheet: Sheet1

Project Name: | Enter Multi-particiant Project Name | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Date Analyzed: | Enter Date |  | Participant Agency or Group Name: |  |  | Enter the Name of the Agency or Group Covered by this [NAME]
Net Value (Net Benefits): | 0 | (in Year 1 dollars)
Annualized Return on Investment:
[NAME]: | Year 1
Payback Period (in Years): | 0
Inflation Rate: | 0.025
Opportunity Cost of Capital: | 0.05
Project Years (Inception to Present): | 1 | 2 | 3 | 4 | 5
Project Year Labels: | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Years Since Project Inception: | 5
Method for Determining Prior Years' Cost of Labor:
Derived by Applying Inflation Rate to Final Year Costs
Notes and Other Assumptions:
Enter notes here.
Options for Prior Year Labor Cost Determination: |  |  | Effective Wage Multiplier: |  | 1.025
Actual Historical Costs
Derived by Applying Inflation Rate to Final Year Costs
Derived by Applying Average Cost of Living Adjustment to Final Year Costs:
File Directory and Name:
C:\Documents and Settings\nlerner\My Documents\Active Projects\GITA ROI Book\Templates\Multiparticipant Templates\[Financial Details-Past5.xls]Project Setup Sheet
Spreadsheet: 881247d1729238702-need-help-creating-cocktail-costs-based-on-amount-and-bottles-used-alcohol-costs
Sheet: Cocktails

Cocktail | Price | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz | Spirit | oz
White Russian | 8.5 | Barton Vodka | 1.5 | Kahlua | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 | Examples
Long Island | 7.5 | Barton Vodka | 1.5 | [NAME] | 1.5 | [NAME] | 1.5 | Barton Gin | 1.5 | Triple Sec, Barton | 1.5 |  | 1.5 |  | 1.5 |  | 1.5 | Examples
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Examples
 |  | [NAME], Dekuyper | 1 | Bailey's | 1.5 | Seagrams 7 | 0.5 | 1800 Rep | 1.5
 |  | test
Spreadsheet: chris_stokley__3914__0201 EES
Sheet: EES

EES ISO Settlement 02/01/2001 - 02/28/2001
 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
EES | 111 | Spinning Reserve due ISO | -163434.5959595797 | 1054146.632542239 | 890712.0365826606 | -11432.96352152056
 | 112 | Non -Spinning Reserve due [NAME] | -13318.4015 | 465540.226134618 | 452221.8246346175 | -14028.00789025996
 | 114 | Replacement Reserves Due ISO | -1098685.694166096 | 1898521.879998584 | 799836.1858324879 | -7449.193153051514
 | 115 | Regulation UP due ISO | -60735.20355977649 | 759645.3886683765 | 698910.1851085998 | -6529.939922866002
 | 116 | Regulation Down Due ISO | -42611.36644967223 | 369781.7989348141 | 327170.4324851412 | -5635.973233933413
 | 203 | Congestion DA | 0 | 0 | 0 | 0
 | 253 | Congestion HA | -10.2 | 1.8 | -8.4 | -0.1800000000000031
 | 254 | Congestion HA Refund | -2.5 | 0 | -2.5 | -0.01
 | 255 | TODEBIT Due FTR/TO | 0 | 313.3538 | 313.3538 | -357.62
 | 402 | Generation Deviation | -11667.91743464234 | 16451.41560049 | 4783.498165847666 | -23.22030839999995
 | 403 | Load Deviation | -6396267.285798337 | 6123581.358530004 | -272685.9272683333 | 6053.749839773005
 | 406 | UFE | -183807.6164261411 | 377662.2885134006 | 193854.6720872591 | -1459.130506985291
 | 487 | Allocation Excess Cost for IE | -332651.22 | 2563455.95 | 2230804.73 | -22111.39
 | 521 | Control Area Services Charge | 0 | 79820.82178600001 | 79820.82178600001 | -196603.0117999999
 | 522 | Inter-Zonal Scheduling Charge | 0 | 45361.88396000001 | 45361.88396000001 | -203416.52
 | 523 | Market Operations Charge | -71708.6503 | 152655.1465667548 | 80946.49626675468 | -85117.2392694206
 | 1010 | Neutrality Adj | -622711.3734149986 | 811422.275285495 | 188710.9018704967 | -377038.7863
 | 1011 | AS Rational Buyer Adj. | -667241.3483000004 | 151247.4874 | -515993.8609000001 | -2805667.7369
 | 1030 | No Pay Market Refund | -145159.2205 | 2913.571599999999 | -142245.6489 | -461602.2672913918
 | 1062 | Distribution of Preempted Non | -33.9073 | 0 | -33.9073 | -823.4016
 | 1064 | Distrib of Preempted RR | -218.8415 | 0 | -218.8415 | -3358.6422
 | 1210 | Existing Contract Neu Adj | -204797.9653 | 240254.7119000001 | 35456.74660000001 | -2944032.2668
 | 1302 | Supplemental Reactive Energy | -0.026 | 511.7551 | 511.7291 | -73724.845
Grand Total |  |  | -10015063.33390924 | 15113289.74632077 | 5098226.412411533 | -7214358.595858055
Spreadsheet: 82033d1282097292-custom-formula-in-pivot-table-sample
Sheet: Pivot Table - Before

 | Values
Row Labels | Sum of Visit | Sum of Time
Australia | 30 | 1230
Brazil | 12 | 3320
China | 36 | 4836
Denmark | 19 | 2837
England | 44 | 5669
France | 8 | 2768
Germany | 11 | 3918
Grand Total | 160 | 24578
Spreadsheet: 89424e8e-9ebf-4ea6-9ccb-630b66abae1e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3780 | 12442 | [NAME] | Peck | GBR | 0 | 00:53:20 | [NAME] | 01:24:31 | 00:01:46 | [NAME] | 1 | 02:56:10
Spreadsheet: 490103d1479678540-vlookup-filter-dropdown-generator-sample_vlookup_dropdown
Sheet: Sheet1

 |  | DATABASE
 |  | Material Code | Material Description | Shop | Supplier | Invoice
 |  | 232 | Oreo | [NAME] | Sweden | 4845142
 |  | 232 | Oreo | London | Sweden | 6545666
 |  | 232 | Oreo | London | Holland | 9215658
 |  | 232 | Oreo | London | Holland | 5465458
 |  | 111 | [NAME] | Liverpool | Sweden | 1234567
 |  | Scenario for code 232
 |  | Type in Code | Description pops in | A dropdown is generated | A dropdown is generated | A dropdown is generated
 |  | Material Code | Material Description | Shop | Supplier | Invoice
 |  | 232 |  | London | Holland | 9215658
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R9

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
 | Deadlines to consider:      Section # to Miranda by January 31     Language to Miranda by March 31
Spreadsheet: 546269d1509975236-cascading-drop-down-data-validation-lists-with-only-unique-items-dependant-lists3
Sheet: CheckList

 | No | Service Tower | LBU | Location
 | 1 | FS AS400 | NL | [NAME]
Spreadsheet: mary_fischer__25631__30R
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  030R
COMPANY NAME   [NAME]
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: Sonya City
EXTENSION: 39690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 855061d1704782264-course-enrollment-averages-calculations-to-active-terms-book1-6-
Sheet: Sheet1

Course | Term | Mode | ToT Enrl |  |  | Average of ToT Enrl |  | Term
HST 3111 | 20231 | Online | 87 |  |  | Course | Mode | 20215 | 20231 | 20238 | 20241 | 20245 | Total Geral
HST 3111 | 20231 | Online | 32 |  |  | HST 2122 | Face to Face | 56 |  | 85 |  |  | 70.5
HST 3111 | 20241 | Online | 11 |  |  | HST 2122 | Online |  |  | 54 | 77 |  | 65.5
HST 3111 | 20245 | Face to Face | 74 |  |  | HST 3111 | Face to Face | 52 |  |  |  | 74 | 63
HST 3111 | 20215 | Face to Face | 52 |  |  | HST 3111 | Online |  | 59.5 |  | 11 |  | 43.33333333333334
HST 2122 | 20215 | Face to Face | 56 |  |  | Total Geral |  | 54 | 59.5 | 69.5 | 44 | 74 | 58.66666666666666
HST 2122 | 20241 | Online | 77
HST 2122 | 20238 | Online | 54
HST 2122 | 20238 | Face to Face | 85
 | 20231 | Online
HST 3111 | 20241 | Online
HST 3111 | 20245 | Face to Face
HST 3111 | 20215 | Face to Face
HST 2122 | 20215 | Face to Face
HST 2122 | 20241 | Online
HST 2122 | 20238 | Online
HST 2122 | 20238 | Face to Face
Spreadsheet: 771386d1646651618-when-i-use-a-formula-to-show-contents-of-2-cells-i-lose-formatting-sample
Sheet: Sheet1

This is how my table looks currently |  |  |  |  | This is how my table SHOULD look
Price | Options | Code |  |  | Price | Options | Code |  | As you can see, my table is losing the formatting from the original price.    So in Cell C3, the displayed code reads "$3.5 - 1"  It Should Read "$3.50 - 1"
3.5 | 1 |  |  |  | 3.5 | 1 | $3.50 - 1
4 | 2 |  |  |  | 4 | 2 | $4 - 1
7.25 |  |  |  |  | 7.25 |  | 7.25
None |  |  |  |  | None |  | None
4.5 | 3 |  |  |  | 4.5 | 3 | $4.50 - 3
3 |  |  |  |  | 3 |  | 3
25 |  |  |  |  | 25 |  | 25
17 | 3 |  |  |  | 17 | 3 | $17 - 3
17.5 |  |  |  |  | 17.5 |  | 17.5
4.25 | 2 |  |  |  | 4.25 | 2 | $4.25 - 2
Rules:
The Prices should all be displayed with a decimal point and TWO numbers only if necessary. So... If there is no change, there is no decimal point or change shown.  So... $5.00 will display as "$5".     $6.00 will display as "$6" THERE SHOULD BE NO DECIMAL POINT.  So it will never display a number like "$6."  If the price has change it will display 2 numbers of the change.  So… $5.50 will display as "$5.50" $6.50 will display as "$6.50"