tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Services

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 0
 | Analysts & Associates | 7800
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 6
 | Analyst & Associate Headcount |  |  | 1
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: 189826d1351374190-using-multiple-match-tables-on-1-spreadsheet-lookup-for-different-machines
Sheet: Sheet1

Select Equipment Number from List | Select Number of Colors from List | Select Code From List | Results
Machine #1 | 2 color | 101 | 551.75 |  |  | #N/A
 |  |  |  |  |  | Equipment #1 | Equipment #2
 |  |  | Color | Code |  | Total Price | Total Price
 |  | Results >> | 2 color | 101 |  | 551.75 | 557.25
Machine #1 | 1 color | 100 | 1 color | 100 | 1 color100 | 375 | 380.5
Machine #2 | 2 color | 101 | 1 color | 101 | 1 color101 | 400.25 | 405.75
 | 3 color | 102 | 1 color | 102 | 1 color102 | 425.5 | 431
 | 4 color | 103 | 1 color | 103 | 1 color103 | 450.75 | 456.25
 |  | 104 | 1 color | 104 | 1 color104 | 476 | 481.5
 |  | 105 | 1 color | 105 | 1 color105 | 501.25 | 506.75
 |  | 200 | 2 color | 100 | 2 color100 | 526.5 | 532
 |  | 201 | 2 color | 101 | 2 color101 | 551.75 | 557.25
 |  | 202 | 2 color | 102 | 2 color102 | 577 | 582.5
 |  | 203 | 2 color | 103 | 2 color103 | 602.25 | 607.75
 |  | 204 | 2 color | 104 | 2 color104 | 627.5 | 633
 |  | 205 | 2 color | 105 | 2 color105 | 652.75 | 658.25
These are the drop down list options |  |  | 3 color | 100 | 3 color100 | 678 | 683.5
for A2, B2 and C2 |  |  | 3 color | 101 | 3 color101 | 703.25 | 708.75
 |  |  | 3 color | 102 | 3 color102 | 728.5 | 734
 |  |  | 3 color | 103 | 3 color103 | 753.75 | 759.25
 |  |  | 3 color | 104 | 3 color104 | 779 | 784.5
 |  |  | 3 color | 105 | 3 color105 | 804.25 | 809.75
 |  |  | 4 color | 100 | 4 color100 | 829.5 | 835
 |  |  | 4 color | 101 | 4 color101 | 854.75 | 860.25
 |  |  | 4 color | 102 | 4 color102 | 880 | 885.5
 |  |  | 4 color | 103 | 4 color103 | 905.25 | 910.75
 |  |  | 4 color | 104 | 4 color104 | 930.5 | 936
 |  |  | 4 color | 105 | 4 color105 | 955.75 | 961.25
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: 9911

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-11-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.93 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 2.97
IFGMR (PEPL/TX/OK) |  |  | 2.94
IFGMR (ANR/LA) |  |  | 2.97
IFGMR (HENRY HUB) |  |  | 3.06
NX3 |  |  | 3.03967
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5
TRIGGER* (LA) |  | 2.5
DIFFERENTIAL (TX)
DIFFERENTIAL (LA)
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 |  | 150
2 | 309 | 150
3 | 285 | 150
4 | 252 | 150
5 | 300 | 150
6 | 31 | 150
7 | 4 | 150
8 | 303 | 150
9 | 289 | 150
10 | 146 | 150
11 | 52 | 150
12 | 315 | 150
13 | 201 | 150
14 | 186 | 150
15 | 164 | 150
16 | 142 | 150
17 | 227 | 150
18 | 197 | 150
19 | 226 | 150
20 | 242 | 150
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 174593.14
2002-02-20 00:00:00
CBS Volume
 |  |  | 76390
Spreadsheet: 44834d1243558667-finding-the-earliest-time-employee-schedule
Sheet: Week 5

 |  | Labor Cost Analysis |  |  |  | (Complete the boxes below) |  |  |  |  |  | Hours Available
 |  | For week beginning |  |  |  | 2003-07-07 00:00:00 |  |  |  |  |  |  |  |  |  | Hours | Cost
 |  | Labor Target |  |  |  | 0.16 |  |  |  |  |  | Total Labor Hours + Mger
 |  | Avg hourly wage |  |  |  | 7 |  |  |  |  |  | Scheduled labor hours
 |  | Expected NET Sales |  |  |  | 6000 |  |  |  |  |  | Hours Under (Over)
 |  |  | Weekly Schedule
 |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday |  |  | Monday |  |  | Tuesday
 |  |  | 2009-06-17 00:00:00
 | Rate |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | In | Out |  | TOTAL | Est. Cost
 | 0 | Culinary
 | 11.5 | [NAME]
 | 0
 | 10.75 | [NAME]
 | 10.5 | Tiffany
 | 10 | [NAME]
 | 9 | [NAME]
 | 9 | Bradley
 | 9 | Tara
 | 9 | [NAME]
 | 8 | Ramone
 | 9 | Virginia
 | 8 | Reyna
 | 9 | Sandra
 | 10.5 | Sayon
 | 0 | 15
 |  | © 2003 Leno Ventures LLC. Www.makeschedules.com. Version 2.
Spreadsheet: 220311d1363117255-return-cell-value-based-on-multiple-criteria-sample-data
Sheet: RUN Config

No. of bays |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bays | Frames |  |  | OVERALL HEIGHT | L/UR TYPE | L/UR HEIGHT |  | U/UR HEIGHT
RUN 1 |  | A |  | B |  | C |  | D |  | A |  | C |  | B |  | D |  | B |  | B |  | C |  |  |  |  | A | 5700 | 8 | 5700 | 0 | 0
Bays of Type |  | 1 |  | 2 |  | 2 |  | 1 |  | 3 |  | 2 |  | 1 |  | 2 |  | 2 |  | 1 |  | 1 |  |  |  |  | B | 7500 | 12 | 2100 | 8 | 5400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 9300 | 16 | 2100 | 12 | 7200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 9300 | 16 | 4125 | 8 | 5175
Overall Frame Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 0 | 0 | 0 | 0 | 0
Lower Upright Type
Lower Upright Height
Upper Upright Type
Upper Upright Height
RESULT
REQ'D RESULT | A |  | B |  | C |  | D |  | D |  | C |  | C |  | D |  | D |  | B |  | C |  | C
Spreadsheet: 0c647afb-d3d3-4741-ae2e-845982071270
Sheet: Sheet1

SP-13-0151 LTRK-PNBL OC3
OFFICIAL PRICE SHEET
Table 1: [NAME]
From Location | To Location | Cost per Unit/Month | 12 Month Cost | Installation Cost
AT&T C.O. at 120 W. 8Th, Little Rock, [NAME], (501-372),ATM SW CLLI, [NAME] | AT&T C.O. at 720 Beech St, Pine Bluff, [NAME] (870-534) ATM SW CLLI, PNBLARJEHD1
 |  | Total 12 Month Cost
Table 2: Miscellaneous Recurring Cost
Description: Other Recurring Cost |  | Cost per Unit/Month | 12 Month Cost | Installation Cost
 |  | Total
 |  | Total 12 Month Cost
Table 3: Miscellaneous Non-Recurring Cost
Description: Other Non-Recurring Cost |  | Cost per Unit/Month | 12 Month Cost | Installation Cost
 |  | Total
 |  | Total 12 Month Cost
 |  |  |  |  | Page 2 | SP-13-0151
Mandatory Option
Table: 4 Telecommunication Service Priority (TSP) System
Service Description |  |  | Provider |  | Monthly Rate | Nonrecurring Charge
Priority Installation (Per Circuit, Line or Trunk) |  |  | Prime Service Vendor*
 |  |  | Subcontractor**
Priority Restoration Level Implementation (Per Circuit, Line or Trunk) |  |  | Prime Service Vendor*
 |  |  | Subcontractor**
Priority Restoration Level Change on Existing TSP System Access Service (Per Circuit, Line or Trunk) |  |  | Prime Service Vendor*
 |  |  | Subcontractor**
Administration and Maintenance of Priority Restoration (Per Circuit, Line or Trunk) |  |  | Prime Service Vendor*
 |  |  | Subcontractor**
* Prime Service Vendor denotes status of the Telephone Company when it contracts directly with a TSP System end user, or the end-user's authorized agent, to provide all, or a portion, of a TSP system
**Subcontractor denotes status of the Telephone Company when it contracts with a Prime Service Vendor to provide a portion of a TSP system to a TSP System end-user.
Table 5: Summary Table
Table | Cost
Table 1
Table 2
Table 3
Grand Total
E-Rate SPIN #
Delivery: | days ARO (initial order)
Spreadsheet: sara_shackleton__36365__vivendi
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Vivendi  S.A. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | France | S&P Rating | BBB+
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) |  | Enron Corp
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
 | 10 | 10
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change | X | X | Tied to EnronCorp
-Below = S&P/Moody's | BBB- | BBB-
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | $300 FF | 50 | Tied to Enron Corp
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X3-3263
Spreadsheet: 669078d1585181499-pictures-in-drop-down-selection-test-sample
Sheet: SheetA

**Sample Spreadsheet Scenario Below**
Description | Equipment Code | Price
Equipment A
Equipment C
 |  |  |  |  | End Product without photos (too large).  Don't know how to reproduce with "drop down" functionality
 |  |  |  |  | Description | Equipment Code | Price
 |  |  |  |  | Equipment C
 |  |  |  |  | Equipment A
Spreadsheet: kevin_hyatt__19583__Red Rock Design01
Sheet: Sheet1

RED ROCK EXPANSION PROJECT
OPERATING PARAMETERS (ONE STATION DOWN AT A TIME)
CASE 1. | STATION #1 DOWN
 |  |  | Sta. #1 |  | Sta. #2 | 1 | Sta. #3 |  | Sta. #4
 | Flow (MMcf/d) |  | 935.3 |  | 935.3 |  | 941.6 |  | 942.8
 | Suction (Psig) |  |  |  | 893 |  | 899 |  | 839
 | Discharge (Psig) |  |  |  | 1005 |  | 1005 |  | 1005
 | Ts (F) |  |  |  | 79 |  | 79 |  | 84
 | Td (F) |  |  |  | 109 |  | 99 |  | 113
 | Required HP |  |  |  | 9112 |  | 5451 |  | 8978
 | Fuel (MMcf/d) |  |  |  | 1.82 |  | 1.09 |  | 1.8
CASE 2. | STATION #2 DOWN
 |  |  | Sta. #1 |  | Sta. #2 | 1 | Sta. #3 |  | Sta. #4
 | Flow (MMcf/d) |  | 985 |  |  |  | 993.9 |  | 995.3
 | Suction (Psig) |  | 620 |  |  |  | 877 |  | 827
 | Discharge (Psig) |  | 920 |  |  |  | 1005 |  | 1005
 | Ts (F) |  | 79 |  |  |  | 79 |  | 84
 | Td (F) |  | 141 |  |  |  | 103 |  | 115
 | Required HP |  | 21000 |  |  |  | 6969 |  | 10169
 | Fuel (MMcf/d) |  | 4.2 |  |  |  | 1.39 |  | 2.03
CASE 3. | STATION #3 DOWN
 |  |  | Sta. #1 |  | Sta. #2 | 1 | Sta. #3 |  | Sta. #4
 | Flow (MMcf/d) |  | 1074 |  | 1074 |  |  |  | 1088
 | Suction (Psig) |  | 648 |  | 595 |  |  |  | 804
 | Discharge (Psig) |  | 946 |  | 882 |  |  |  | 1005
 | Ts (F) |  | 79 |  | 81 |  |  |  | 84
 | Td (F) |  | 140 |  | 139 |  |  |  | 119
 | Required HP |  | 22000 |  | 23000 |  |  |  | 12836
 | Fuel (MMcf/d) |  | 4.2 |  | 4.6 |  |  |  | 2.6
CASE 4. | STATION #4 DOWN
 |  |  | Sta. #1 |  | Sta. #2 | 1 | Sta. #3 |  | Sta. #4
 | Flow (MMcf/d) |  | 1060 |  | 1064.5 |  | 1073.6
 | Suction (Psig) |  | 642 |  | 588 |  | 877
 | Discharge (Psig) |  | 941 |  | 872 |  | 1005
 | Ts (F) |  | 79 |  | 81 |  | 79
 | Td (F) |  | 140 |  | 144 |  | 143
 | Required HP |  | 22000 |  | 23000 |  | 24000
 | Fuel (MMcf/d) |  | 4.4 |  | 4.6 |  | 4.8
RED ROCK EXPANSION PROJECT
OPERATING PARAMETERS (LOW FLOWS)
 |  |  | Sta. #1 |  | Sta. #2 |  | Sta. #3 |  | All
 |  |  | Only |  | Only | 1 | Only |  | Off
 | Flow West (MMcf/d) |  | 740.2 |  | 785.8 |  | 704.6 |  | 535
 | Suction (Psig) |  | 548 |  | 638 |  | 832
 | Discharge (Psig) |  | 841 |  | 925 |  | 1005
 | Ts (F) |  | 79 |  | 81 |  | 79
 | Td (F) |  | 149 |  | 137 |  | 111
 | Required HP |  | 17500 |  | 15792 |  | 7008
 | Fuel (MMcf/d) |  | 3.5 |  | 3.16 |  | 1.4
Notes: | 1.  Gas cooling at each station to limit maximum discharge temperature to 110 F.
 | 2.  Flows and suction temperatures based on gas cooling upstream.
 | 3.  Configurations assumed the highest possible station flow.
 | 4.  Horsepower limited to pipeline MAOP where applicable.
 | 5.  All cases assumed Gallup CS discharge pressure of 950 psig.
 | 6.  [NAME] delivery pressure set at 825 psig.
Spreadsheet: 475687d1471419870-the-linearity-conditions-required-by-lp-solver-are-not-satisfied-milp-site-preparation
Sheet: Sheet1

 |  |  |  |  |  | [NAME]
 | [NAME] | 28000 | MW/y |  |  | Decision Variable
 |  |  |  |  | Site Type
 |  |  |  |  | CC | WC | CF | WF
 |  |  | Grid Type | MV | x
 |  |  |  | HV |  | x | x
 |  |  |  | HHV |  |  |  | x
 |  |  | Site Usage | Grid Connection Length | Installed Site Power | Construction Rate | People Required | Machines Required
 |  |  | site/y | km/site | MW/site | km/y | ppl | [NAME]
 |  | CC | 0 | 50 | 30 | 0 | 0 | 0
 |  | WC | 400 | 50 | 70 | 20000 | 40000 | 10000
 |  | CF | 0 | 500 | 50 | 0 | 0 | 0
 |  | WF | 0 | 500 | 100 | 0 | 0 | 0
 |  |  |  |  |  | 20000 | 40000 | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material Extraction |  |  | Material Processing
 | Grid Materials |  | Material Usage (t/km) |  |  | Material Required | Material Available | Constraining |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper | Zinc | Iron | Aluminium | Cement | Steel
 |  |  | MV | HV | HHV | t/y | t/y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t/y |  |  | t/y
 |  | Aluminium | 1 | 8 | 19 | 160000 | 68800000 | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18700000 | 13400000 | 3320000000 | 68800000 | 4100000000 | 1665000000
 |  | Concrete | 0 | 130 | 288 | 2600000 | 4100000000 | NO
 |  | Copper | 2.5 | 0 | 0 | 0 | 18700000 | NO
 |  | Iron | 0 | 6 | 15 | 120000 | 3320000000 | NO
 |  | Steel | 1 | 4 | 62 | 80000 | 1665000000 | NO
 |  | Zinc | 0 | 0.5 | 2 | 10000 | 1340000000 | NO
 | Grid Construction (Labour) | Labour Efficiency (km/y/ppl) |  |  | Labour | Constraining
 |  | MV | HV | HHV | ppl
 |  | 1 | 0.5 | 0.2 | 50000 | NO
 | Grid Construction (Machinery) | Labour Efficiency (km/y/mach) |  |  | Machines | Constraining
 |  | MV | HV | HHV | [NAME]
 |  | 5 | 2 | 2 | 10000 | YES
Spreadsheet: 670141d1585760537-updating-a-formula-for-text-split-textfunctions
Sheet: Sheet1

1) Name must have First,Middle and Last Name
2) Zip code must be the last 5 digit
3) State must have a comma before it
4) Town must have a dash before it
Full Address | First | Middle | Last Name | Address | Town | State | Zip
[NAME] 18794 [NAME], Michigan 48168
[NAME] 620 Slayton-Grand Haven, Michigan 12345
[NAME] St.-Garden City, Michigan 48135
[NAME] North Silver Pines-Bellaire, Michigan 49615
[NAME]  18794 [NAME], Michigan 48167
[NAME] 13600 S. Parce Street-Owossoa, Michigan 48667
[NAME] [NAME], Michigan 48433
Cametrious ? Brewer 5813 [NAME], Mchigan 48505
Martin ? [NAME] 7064 [NAME] Rd.-Clio, Michigan 48420
[NAME] 100th St NE.-Flushing, Michigan 48433
[NAME] ? [NAME] 303 S. Main St. Apt 80 -Clio, Michigan 48420
Roeshon D. Brown IV  12345 [NAME], Michigan 48602
Bankston D. Banks 374 River Woods Dr. -Flushing, MI 48433
Spreadsheet: 71539d1272323758-excel-2007-two-pivot-table-queries-how-to-add-a-cumulative-column-and-a-data-sort-query-cum-column-and-data-sort-query
Sheet: Pivot

 | Values
Row Labels | Sum of £ | Cumulative £
2009/01 | 2158578.541697579 | 2158578.541697579
2009/02 | 1641391.205780103 | 3799969.747477681
2009/03 | 1638072.945314208 | 5438042.692791889
2009/04 | 1408231.876772723 | 6846274.569564613
2009/05 | 1631957.878808254 | 8478232.448372867
2009/06 | 1733522.998083418 | 10211755.44645629
2009/07 | 490107.3805976777 | 10701862.82705396
2009/08 | 1006620.902606637 | 11708483.7296606
2009/09 | 881156.0096132942 | 12589639.73927389
2009/10 | 1589117.261017628 | 14178757.00029152
2009/11 | 507539.2603971203 | 14686296.26068864
2009/12 | 1713368.295163815 | 16399664.55585246
Grand Total | 16399664.55585246
Spreadsheet: 187002d1350315500-jump-to-a-particular-worksheet-based-on-the-current-cells-value-jump_example1
Sheet: Ashley_Falls

[NAME] |  |  |  |  |  |  | [NAME] | #N/A
Month | Electricity Used ([NAME]) | Monthly Charge | Other/ Non-Coincident $ | Power Cost Adjustment | Base Charge | Cost/ KWH
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
 |  |  |  |  |  |  | <===
Total | 0 | 0
AVG |  |  |  |  | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
7500 Brantley Pl |  |  | Account/Meter No. |  | 0
 |  | #N/A
Spreadsheet: 842273d1694415562-vlookup-handling-multiple-matches-excel-forum-11-september
Sheet: Packing List Excel (24)

Order number | Barcode | Quantity | [NAME] (formula to be downwards) | Order name | Barcode | Quantity | Price
41432/41523/ | 96433 | 2 | 15 | 41523 | 96433 | 2 | 15
41523 | 96407 | 1 | 40 | 41523 | 96433 | 1 | 30
41523 | 96433 | 1 | 30 | 41523 | 96407 | 1 | 40
41526 | 96433 | 1 | 5 | 41526 | 96407 | 3 | 20
41526/41655 | 96433 | 1 | 10 | 41526 | 96433 | 1 | 5
 |  |  |  | 41526 | 96433 | 1 | 10
Spreadsheet: 221164d1363385259-assigning-a-category-to-a-specific-time-frame-assigncatagory
Sheet: Sheet1

 |  | <3 Months | 3-6 Months | 7-12 Months | 1-2 years
2013-03-15 00:00:00
2013-01-15 00:00:00
2013-02-14 00:00:00
2012-11-12 00:00:00
2012-10-23 00:00:00
2012-12-12 00:00:00
2012-01-12 00:00:00
2012-02-14 00:00:00
2011-05-05 00:00:00
2012-08-30 00:00:00
Spreadsheet: 42130d1240679443-linear-interpolation-lactate-chart-11set
Sheet: Infomation Sheet

Means |  | Sum | Increase Point
100 | 0.5 | 130 | 0.9 |  |  |  |  |  | 1st Inflection | 150 | 160
130 | 1 | 133 | 1.1 |  |  |  |  |  |  | 2 | 160
160 | 2 | 142 | 1.2
190 | 3 | 153 | 2.4
220 | 4 | 160 | 4.3
250 | 5.5 | 168 | 7.2 |  |  |  |  |  | [NAME] | 150 | 182
280 | 7.5 | 173 | 9.1 |  |  |  |  |  |  | 2 | 182
 |  |  |  |  | 1 | 0
 |  |  |  |  | 1
 |  |  | Manually input Vertical Lines as example. Data was not calculated.
 |  |  |  |  |  |  |  |  |  |  |  |  | Means 1st Inflection 1.2 |  | 160
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 142
 |  |  |  |  |  |  |  |  |  | Would like this chart to |  |  | L2 2.0 |  | 182
 |  |  |  |  |  |  |  |  |  | get the numbers |  |  | [NAME] |  | 150
 |  |  |  |  |  |  |  |  |  | from graph Automatically |  |  | L3 3.0 |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | Sum l3 |  | 156
 |  |  |  |  |  |  |  |  |  |  |  |  | L4 4.0 |  | 216
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 159
 |  |  |  |  |  |  |  |  |  |  |  |  | P OBLA 4.4 |  | 222
 |  |  |  |  |  |  |  |  |  |  |  |  | OBLA |  | 161
Spreadsheet: 14ba283f-3ad4-465e-985e-3f37eddfba32
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Central Piedmont CC
Continuing Education - FALL 2010
Location | Class Location | [NAME] Skills Calculated FTE | Con Ed Occupational Extension Calculated FTE | [NAME]   Other Programs Calculated FTE | Con Ed Total Calculated FTE
Main Campus | CENTRAL PIEDMONT CC MAIN CAMPUS | 329.03 | 52.36 | 22.55 | 403.94
Other | OTHER OFF CAMPUS LOCATIONS | 101.88 | 65.8 | 30.78 | 198.46
Satellite Campus | CATO CAMPUS CENTRAL PIEDMONT CC | 44.89 | 2.87 | 5.64 | 53.4
Satellite Campus | HARPER CAMPUS CENTRAL PIEDMONT CC | 52.17 | 10.89 | 4.05 | 67.1
Satellite Campus | HARRIS CAMPUS CENTRAL PIEDMONT CC | 45.49 | 6.09 | 44.92 | 96.5
Satellite Campus | LEVINE CAMPUS CENTRAL PIEDMONT CC | 18.15 | 39.67 | 31.33 | 89.15
Satellite Campus | NORTH CAMPUS CENTRAL PIEDMONT CC | 3.79 | 24.99 | 14.24 | 43.03
State [NAME] | CHARLOTTE CORR. CTR. | 15.31 |  |  | 15.31
 | Central Piedmont CC Totals: | 610.7099999999998 | 202.67 | 153.51 | 966.8899999999999
Spreadsheet: 108512d1305570904-choosing-values-from-table-stream-eval-test-day92
Sheet: Sheet1

1 | 3 | 4 | 5
2 | 2 | 4 | 5
2 | 3 | 3 | 5
2 | 3 | 4 | 4
Spreadsheet: 114007d1309881565-using-indirect-diet-log-book
Sheet: July 4, 2011

Time | Meal | Ingredients | Weight (LBS) | Notes
08:30:00 | Green Coffee 1000 | 1 Cup Hot water, 1 Sachet | 251.1
09:30:00 | Scrabled Egs | 2 eggs, slice of spanish onion, 1 mushroom bulb no stem, 1 slice of Dempsters Whole wheat toast with light spread of peanut butter, 4 1inch cubes of seedless watermelon, 1/2 handful of blueberrys, glass of water
 | water
13:00:00 | Chicken and Pasta | 2 Chicken breast (seasoned and bbq lightly) [8 ounces cooked] and penne pasta in a tomato garlic sauce with 1/4 red pepper and 2 bubls of mushroom no stalk [8 ounces], 1 glass of ice water |  | ate about 85% of the meal
 | water
19:30:00 | Chicken and Pasta | 2 Chicken breast (seasoned and bbq lightly) [8 ounces cooked] and penne pasta in a tomato garlic sauce with 1/4 red pepper and 2 bubls of mushroom no stalk [8 ounces], 1 glass of ice water |  | Ate all but over a 45mins period
Spreadsheet: 4f22f584-6479-430f-a302-ed788f2fc1c3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260511 | 69864 | [NAME] | Horan | NZL | 159 | 00:18:26 | [NAME] | 00:43:22 | 00:02:25 | 00:27:44 | 1 | 01:35:56
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: February

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 13
Name 14
Name 15 |  |  |  |  |  |  |  |  | Done Totals
Name 16 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 17
Name 18
Name 19
Name 20 |  |  |  |  | w
Name 21
Name 22
Name 23
Name 24