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

 |  |  |  |  | Volume
CNG |  | 145898 | App prod |  | 228071
CGAS |  | 142046 | Storage |  | 555106 |  | Ignore this deal
CGAS
 | Deal | 143768 | FT-East |  | 3625
 |  | 143769 | FT-East |  | 754
 |  | 145482 | FT-East |  | 7616
 |  | 143336 | Baseload Index |  | 3119210
 |  | 148416 | Baseload Index |  | 3997815
 |  | 149708 | Baseload Fixed |  | 2250
 |  | 149725 | Baseload Fixed |  | 51490
 |  | 149770 | Baseload Fixed |  | 25020
 |  | 150348 | Spot |  | 14163
 |  | 148278 | Spot |  | 10000
 |  | 149209 | Spot |  | 7500
 |  | 149499 | Spot |  | 28400
 |  | 151821 | Spot |  | 6000
 |  | 153799 | Spot |  | 21800
 |  | 154200 | Spot |  | 515
 |  | 157042 | Spot |  | 1534
 |  |  |  | Total Flowing at max IT
 |  |  |  | Deal 143336 Cove Point Gas | 141915
 |  |  |  | Deal 143336 at [NAME] IT
 |  |  |  | Deal 143336 at IF + Variable
 |  |  |  | Total Deal 143336
 | [NAME]
 | Date | Volume | GD-Non NY | Deduct | Price | Total Cost
 | 17 | 7401 | 3.1 | -0.05
 |  | 13401 | 3.1 | -0.05
 |  |  | 5 | -0.05
 |  | 14920 | 6.895 | -0.05
 |  | 15169 | 12.305 | -0.05
 |  | 7401 | 7.405 | -0.05
 |  | 7401 | 7.405 | -0.05
 |  | 7507 | 7.405 | -0.05
 |  | 7401 | 5.735 | -0.05
 |  | 8579 | 7.085 | -0.05
 |  | 8569 | 9.38 | -0.05
 |  | 8501 | 8.88 | -0.05
 |  | 7629 | 8.345 | -0.05
 |  | 7629 | 8.345 | -0.05
 |  | 7629 | 8.345 | -0.05
 |  |  |  |  | Average Price
 |  | Total FT | CES Tport | IT Rate | IF + Vari
 | 1 | 193666 | 232087
 | 2 | 173249 | 232087
 |  | 187100 | 232087
 |  | 248812 | 232087
 |  | 259731 | 232087
 |  | 242336 | 232087
 |  | 269712 | 232087
 |  | 218304 | 232087
 |  | 207891 | 232087
 |  | 199470 | 232087
 |  | 213671 | 232087
 |  | 217560 | 232087
 |  | 254854 | 232087
 |  | 256058 | 232087
 |  | 199966 | 232087
 |  | 232399 | 232087
 |  | 237880 | 232087
 |  | 216484 | 232087
 |  | 206520 | 232087
 |  | 243611 | 232087
 |  | 311232 | 232087
 |  | 267421 | 232087
 |  | 258322 | 232087
 |  | 288629 | 232087
 |  | 279288 | 232087
 |  | 297840 | 232087
 |  | 298811 | 232087
 |  | 279235 | 232087
 |  | 234984 | 232087
 |  | 234928 | 232087
 |  | 232924 | 232087
Spreadsheet: 286528d1388340509-excel-multiple-search-criteria-and-display-results-vehicle-spec-search_alkey
Sheet: Search

[NAME] | [NAME] | Year
Hyundai
[NAME] | [NAME] | Year | Live | Live Wire Location | Ignition | Ignition Wire Location | 12v Immobilisation (CAT5) | Special Notes
Hyundai | i30 CRDi | 2009 | [NAME] (+) | Loom to ignition barrel. | [NAME] (+) | Loom to ignition barrel. | Starter Motor Cut - Thick White (+) | Earth (-) - Chassis.
Hyundai | Veloster | 2012 | Green (40A) | Ignition switch, White 6 pin plug, pin 1 - On vehicles with Smart Key, use white, red or black (50A each) at the dash fuse box, white 4 pin plug (L), pin 1, 2, or 4. | Black | Ignition switch, White 6 pin plug, pin 4 - On vehicles with Smart Key, it is pink (+) at the dash fuse box, white 16 pin plug (F), pin 7. | White
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 140112 - G&A Assumption

 |  |  |  | Enron Net Works
 |  |  |  | 2002 Plan
SAP PROFIT CENTER: |  |  | 11105
PROFIT CENTER OWNER: |  |  | [NAME]
SAP COST CENTER/PROJECT: |  |  | 140112
 |  |  |  |  | AVERAGE
 |  |  |  |  | MONTHLY |  | TOTAL
 |  |  |  |  | AMOUNT |  | 2002 |  | ASSUMPTIONS
52001500 | Club Dues |  |  |  | 0
52002000 | Tuition Reimbursement |  |  |  | 0
52002500 | Other Employee Expenses |  |  |  | 0
52003000 | Overtime/Working Meals |  |  |  | 0
52003500 | Client Meals & entertainment |  |  |  | 0
52004000 | Employee Memberships & Dues |  |  |  | 0
52004500 | Travel & Lodging |  |  |  | 0
 | Subtotal Employee Expenses
52503500 | Communication Expenses |  |  |  | 0
 | Subtotal Communication Expense
52502000 | EIS Controllable |  |  |  | 0
 | Infrastructure
52507400 | Outside Services - IT |  |  |  | 0
 | Subtotal Outside Services - IT
52507000 | Outside Services - Legal |  |  |  | 0
52507100 | Outside Services - Audit |  |  |  | 0
52507200 | Outside Services - Contract for OH Allocation |  |  |  | 0
52507300 | Outside Services - Tax |  |  |  | 0
52507500 | Outside Services - Other |  |  |  | 0
52507600 | Outside Services - Engineering |  |  |  | 0
52507700 | Outside Services - Accounting |  |  |  | 0
52508000 | Outside Services - Professional |  |  |  | 0
 | Subtotal Outside Services
52508100 | Postage & Freight Expense |  |  |  | 0
52508500 | Subscriptions & Periodicals |  |  |  | 0
53500000 | Materials and Supplies - Stock |  |  |  | 0
53500500 | Materials and Supplies - Non Stock |  |  |  | 0
53600000 | Office Supplies |  |  |  | 0
 | Subtotal Office Supplies
52500500 | Advertising Expenses |  |  |  | 0
52504100 | Charitable Contributions |  |  |  | 0
53800000 | Equipment Rental - Personal |  |  |  | 0
53801000 | Rent - Office, Warehouse, & Tower - Real |  |  |  | 0
 | Subtotal Rent (3rd Party)
52504500 | Technology - Computer Exp |  |  |  | 0
54000000 | Transportation |  |  |  | 0
52502500 | EPSC Allocation |  |  |  | 0 |  |  |  | $700 a month an employee
 | A&A Allocation |  |  |  | 0
52505500 | Fees & Permits |  |  |  | 0
54005000 | General Business & Admin Expenses |  |  |  | 0
52504200 | Political Contributions |  |  |  | 0
52506500 | Insurance |  |  |  | 0
52506000 | Fines & Penalties |  |  |  | 0
52503000 | Allocations - Other |  |  |  | 0
52504000 | Company Membership & Dues |  |  |  | 0
 | Subtotal Other
57200000 | Depreciation |  |  |  | 0
57000000 | Amortization |  |  |  | 0
 | Subtotal Noncash Expenses
59099900 | Taxes Other than Income |  |  |  | 0
 | TOTAL DIRECT EXPENSES
Allocated Expenses:
 | ENA E-Source |  |  |  | 0
 | ENA HR |  |  |  | 0
 | ENA Internal Support |  |  |  | 0
 | ENA Legal |  |  |  | 0
 | ENA PR |  |  |  | 0
 | ENA Tax |  |  |  | 0
 | ENA Transaction Support |  |  |  | 0
 | Energy Ops |  |  |  | 0
 | ENW Accounting |  |  |  | 0
 | ENW Corporate |  |  |  | 0
 | ENW Graphics Productions |  |  |  | 0
 | ENW HR |  |  |  | 0
 | GTT Allocation |  |  |  | 0
 | IT e-Commerce |  |  |  | 0
 | IT Infrastructure - Passthrough |  |  |  | 0
 | Other Allocations |  |  |  | 0
 | TOTAL ALLOCATED EXPENSES
Spreadsheet: 816829d1675854530-vlookup-or-something-else-help-example
Sheet: Sheet1

Tax Calculation - Reduction Method
 | Taxable Income |  |  | 45000 |  | ( | Taxable Income | X | Rate | ) | - | reduction amount
0 | 0 | 18200 | 0 |  |  | ( |  | * |  | ) | -
0.19 | 18201 | 45000 | 3458
0.325 | 45001 | 120000 | 9533
0.37 | 120001 | 180000 | 14933
0.45 | 180000 | 1000000000 | 29333
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hello I'm trying to do a VLOOKUP on a number, say "50000"(in cell E2) in the table and bring back the % value.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Example: "$50,000" falls in between "$45,000" and "$120,000" and would display 32.50% in cell J3. "$190,000" falls in between "180,000" and "1,000,000,000" and would display 45.00% in cell J3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | In Cell M3, it would do the same by bring back the value from Collumn D "$50,000" falls in between "$45,000" and "$120,000" and would display "$9,533" in cell M3. "$190,000" falls in between "180,000" and "1,000,000,000" and would display "$29,333" in cell M3
Spreadsheet: 584189d1533021996-excel-icon-set-based-on-previous-cell-book1
Sheet: Sheet1

Month | April |  | May
Budget :
Rent | 6000 |  | 7000
Family | 10000 |  | 10000
Transport | 500 |  | 100
Grocery | 500 |  | 500
Laundry | 100 |  | 100
Food | 2500 |  | 300
Spreadsheet: 77425d1277905968-duplicates-based-on-multiple-columns-dummy-file
Sheet: Sheet1

Customer Name | Product Line | Address | Province | Postal
Apple | Appliance | 123 Apple Rd | ON | L1L 1L1
Orange | Furniture | 123 Orange Rd | BC | [NAME]
[NAME] | Appliance | 123 Banana Rd | MB | H1H 1H1
[NAME] | Furniture | 123 Banana Rd | MB | H1H 1H1
Orange | Furniture | 123 Orange Rd | BC | [NAME]
Orange | Mattress Pads | 123 Orange Rd | Bc | [NAME]
Avacado | Furniture | 123 Avacado Rd | SK | S1S 1S1
Spinach | Mattress Pads | 123 Spinach Ave | PEI | M1M 1M1
Tomato | Appliance | 123 Tomato Lane | NF | F1F 1F1
Spreadsheet: 267567d1380113313-multiply-with-a-value-according-to-the-text-in-the-next-coloumn-sample_oozden
Sheet: Sample 1

Text |  | Material | Multiply | Quantity
Elbow |  | Elbow | 1.5
Elbow |  | Tee | 2
Tee |  | Flange | 1
Flange
Tee
Elbow
Flange
Spreadsheet: 128215d1320857655-month-vs-month-vs-month-2009-10-11-upload
Sheet: Sales by Customer by Month 2010

CUSTOMER | JAN | FEB | MAR | APRIL | MAY | [NAME] | JULY | AUGUST | SEPT | OCT | NOV | DEC |  | TOTAL
A | 16928.18 | 12043 | 15379.66 | 10746.46 | 12887.5 | 13640.56 | 14305.51 | 16198.91 | 6461.98 | 7447 | 56767 | 747467
B | 5243.6 | 7517 | 12493.6 | 234234 | 32323 | 15780 | 332 | 223 | 17691.36 | 5674574 | 67546754 | 7474747
C | 10351.18 | 32 | 11376.38 | 234 | 19317.9 | 333 | 3 | 34443R | 3223 | 7 | 54567 | 45757457
D | 6582 | 5777 | 234 | 23 | 5198.5 | 10079 | 9793.65 | 3 | 33 | 5745754 | 56757457 | 75756767
E | 9837.4 | 7904 | 2523.9 | 8554.8 | 4633.6 | 10473 | 6289.2 | 3333244 | 4254.34 | 5423526 | 7547532 | 67575
Spreadsheet: 226211d1365305489-filter-help-vanpool
Sheet: Category PivotTable

 |  | Semi-Monthly Home Budget |  |  |  |  |  |  |  |  |  |  | CATEGORY PIVOT
 | This PivotTable is the data source for the Category Totals PivotChart on the Budget Report.
 |  | Row Labels | Sum of AMOUNT
 |  | Children | 150
 |  | Entertainment | 112
 |  | Food | 425
 |  | Household | 7880
 |  | Investment Accounts | 500
 |  | Personal | 100
 |  | Pets | 150
 |  | Transportation | 925
 |  | Grand Total | 10242
Spreadsheet: lisa_gang__22374__Hanson Scheduling Model_4_4
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-04-04 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 26.556 | 27.708 | 31.188 | 31.632 | 30.6 | 30.24 | 30.72 | 32.208 | 31.596 | 31.8 | 31.56 | 30.924 | 31.056 | 29.808 | 28.644 | 27.972 | 27.42 | 27.156 | 28.704 | 28.644 | 29.184 | 31.152 | 30.708 | 30.42 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 32.36023590669259 | 32.36023590669259 | 32.56023590669258 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 32.14023590669259 | 30.61523590669259 | 30.61523590669259 | 31.36523590669259 | 30.48523590669259 | 30.90523590669259 | 30.90523590669259 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 141559d1329330149-combine-two-worksheet-with-common-column-values-dummy-books-for-excel-help
Sheet: Sheet3

state1no | state1ab | state2no | [NAME] | year | conttype | fragment | democ | autoc | polity | polity2 | durable
290 | POL | 255 | GMY | 1918 | 1 |  | -88 | -88 | -88 | 4 | 0
290 | POL | 255 | GMY | 1919 | 1 |  | 6 | 0 | 6 | 6 | 0
290 | POL | 255 | GMY | 1920 | 1 |  | 6 | 0 | 6 | 6 | 1
290 | POL | 255 | GMY | 1921 | 1 |  | 6 | 0 | 6 | 6 | 2
290 | POL | 255 | GMY | 1922 | 1 |  | 6 | 0 | 6 | 6 | 3
290 | POL | 255 | GMY | 1923 | 1 |  | 6 | 0 | 6 | 6 | 4
290 | POL | 255 | GMY | 1924 | 1 |  | 6 | 0 | 6 | 6 | 5
290 | POL | 255 | GMY | 1925 | 1 |  | 6 | 0 | 6 | 6 | 6
290 | POL | 255 | GMY | 1926 | 1 |  | 6 | 0 | 6 | 6 | 7
290 | POL | 255 | GMY | 1927 | 1 |  | 6 | 0 | 6 | 6 | 8
290 | POL | 255 | GMY | 1928 | 1 |  | 6 | 0 | 6 | 6 | 9
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: May

 |  |  | 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 | Fri | Sat | Sun
Name | Entitlement | Total Holiday's Used | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | Full days Booked | 1/2 Days Booked | Holiday's Used | Lateness | Sickness Absence (Current Months Total) | Sickness Absence (Days - Rolling 12 Months) | Sickness Absence Periods (Current Months Total) | Sickness Absence (Periods - Rolling 12 Months) | Bradford Index Score (Rolling 12 Months)
A.N.Other | 25 | 21.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0 | 0 | 21 | 0 | 3 | 189
 |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  | H | H |  |  |  |  |  |  | H |  |  |  | H |  |  |  |  |  | 5 | 0
S 1 | L
S 2 | H
S 3 | 0.5
S 4 | AA
S 5 | UA
S 6 | TR
Spreadsheet: 90190d1289945486-a-word-to-a-number-example
Sheet: Sheet1

 | HAMMER
 | QUANTITY OWNED | 6
 | AVALIBILITY | 3
NO. | Status | Where | Taken By | Date Taken Out | Date due Back | Notes
1 | Available | [NAME] | [NAME] | 2010-08-16 00:00:00 | 2010-11-13 00:00:00 | -
2 | On Site | Derryconnor | [NAME]
3 | [NAME] | The Old School | [NAME]
4 | Available | Gortahork | [NAME]
5 | Available
6 | Available
 |  |  | Names | Places | Availability
 |  |  | [NAME] | Gortahork | Available
 |  |  | [NAME] | Derryconnor | On Site
 |  |  | [NAME] | - - - - - - - - - - - - - - - - - - - - - - - - - - | [NAME]
 |  |  | [NAME] | [NAME] | Being Fixed
 |  |  | Grace | The Old School
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Cian
 |  |  | - - - - - - - - - - - - - - - - - - - - - - - - - -
Spreadsheet: 879273d1726740252-paint-surface-steel-profiles-verfoppervlakte-staalprofielen-test-1-zeddy2
Sheet: Paint surface

 |  |  |  |  | Project :
 |  |  |  |  | Description:
 |  |  |  |  | Made by : |  |  |  |  |  | on
NR Profile | HEA | HEB | HEM | IPE | [NAME]. 2 | [NAME]. 2 | Binnenflens [NAME]. 4 | [NAME]. 4 | Length mm | # Profiles | Surface/m | Total surface
 |  |  |  |  |  |  |  |  |  |  |  |  | chk | row | b | hi | tw | tf
K1 | HE 100 A |  |  |  | 2 | 2 | 4 | 4 | 1000 | 2
K2 |  | HE 200 B |  |  | 1 | 1 | 2 | 2 | 1000 | 1
K3
 |  |  |  |  |  |  |  |  |  |  | Total netto surface =
Spreadsheet: 875115d1721677392-9-box-help-speedking57-9-box-talent-assessment-corporate
Sheet: Keys

Performance Ratings |  |  | Potential Ratings |  |  | Current Location |  | Time In Role |  | Readiness
Rating | Value |  | Rating | Value |  | Home Office - STL |  | < 1 year |  | Now
Below | 1 |  | Never | 1 |  | Remote Corp Role |  | 1-3 years |  | Less than 12 months
Meets | 2 |  | Rarely | 2 |  | Distribution Center |  | 3-5 years |  | More than 12 months
Exceeds | 3 |  | Sometimes | 3 |  | Corp Retail Ops |  | 5-10 years
 |  |  | Often | 4 |  | Retail Partner Ops |  | > 10 years
Text | Value |  | Always | 5
 |  |  |  |  |  | Geographic Mobility |  | Risk of Leaving |  | Impact of Loss
 |  |  |  |  |  | Home Office - STL |  | High |  | High
 |  |  |  |  |  | Remote Corp Role |  | Medium |  | Medium
 |  |  |  |  |  | Distribution Center |  | Low |  | Low
 |  |  |  |  |  | Corp Retail Ops
 |  |  |  |  |  | Retail Partner Ops
Spreadsheet: 848524d1699259919-excel-formula-for-a-few-parameters-payment-delay-2-
Sheet: sum

Customer ID | Invoice 01 | Invoice 02 | Invoice 03 | Invoice 04 | Invoice 05 | Invoice 06 | Invoice 07 | Invoice 08 | Invoice 09 | Invoice 10 | Invoice 11 | Invoice 12 | Invoice 13 | Invoice 14 | Invoice 15 | Invoice 16
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
1646
1647
1648
1649
1650
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
1661
1662
1663
1664
1665
1666
1667
1668
1669
1670
1671
1672
1673
1674
1675
1676
1677
1678
1679
1680
1681
1682
1683
1684
1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
Spreadsheet: joe_parks__14512__TEXAS_P&L_JUN01
Sheet: JUN_PHY

 |  | KATY |  |  |  |  | WAHA |  |  |  | hsc
 |  |  |  |  | Pos | P&L
Spreadsheet: jane_tholt__13115__July2001pricinggriffithprelim2_jc
Sheet: Summary

Citizens Utilities - Griffith Plant Deliveries |  |  |  |  | Delivery Month:
 |  |  |  |  |  |  |  |  |  |  |  | E N R O N    C O S T
 | Scheduled Delivery Quantity | Sales   Quantity | Thoreau Quantity | Transport Quantity | Sales   Spread | Sales Margin | Demand Spread | Demand Margin | Transport Spread | Trasnport Margin | Total     Margin | Enron  Margin Sharing | Brokering Fee | Total Margin & Brokering | Demand Cost | Supply   Cost | Variable Commodity Cost | Total Supply & Delevery cost | Total Cost
Date | MMBtu | MMBtu | MMBtu | MMBtu | $/MMBtu | $ | $/MMBtu | $ | $/MMBtu | $ |  | $ | $'s | $'s | $'s |  | $'s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ]
Total
Spreadsheet: 60544d1261064840-vllokup-across-multiple-tabs-sample
Sheet: Digital Pricing

Product # | Roll | Position | [NAME] (across) | Length (around) | Die | Stock | Liner | Adhesive | Colors | 1000 | 2500 | 5000 | 7500 | 10000 | 15000 | 20000 | 30000 | 40000 | 50000
10376907 | 8" | Left Off | 0.625 | 2.85 | 0914D-L-40 | 3 [NAME] Matte White BOPP | 50# Paper | S4600 | 2 + V | 403 | 167.8 | 89.5 | 63.3 | 50.3 | 37.6 | 31.6 | 25.5 | 22.6 | 20.9
10376907 | 8" | Left Off | 0.625 | 3 | 0859D-L-40 | 3 [NAME] Matte White BOPP | 50# Paper | S4600 | 2 + V | 392.5 | 163.4 | 87.1 | 61.6 | 48.9 | 36.7 | 30.9 | 25 | 22.1 | 20.5
30-2775 | 8" | Left Off | 0.8 | 3.35 | 0873D-L-32 | 3 [NAME] Matte White BOPP | 50# Paper | S4600 | 2 + V | 391.5 | 163.6 | 87.6 | 62.3 | 49.6 | 37.8 | 32 | 26.2 | 23.4 | 21.8
832210 | 8" | Left Off | 0.866 | 2.756 | 0932D-L-40 | 3 [NAME] Matte White BOPP | 50# Paper | S4600 | 1 + V | 387.5 | 159.9 | 84 | 58.7 | 46.1 | 34 | 28.3 | 22.6 | 19.8 | 18.3
835241 | 8" | Left Off | 0.875 | 1.3125 | 0858D-L-66 | FPG-80 [NAME] | 50# Paper | B-82 | 2 + V | 396.9 | 163.3 | 85.4 | 59.4 | 46.5 | 33.5 | 27 | 20.7 | 17.8 | 16.1
3946VL | 8" | Left Off | 0.875 | 1.8125 | 0860D-L-48 | [NAME] | 50# Paper | B-82 | 3 + V | 439 | 180.5 | 94.4 | 65.6 | 51.3 | 36.9 | 29.8 | 23 | 19.7 | 17.7
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 7

Ambev Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 1Q10 | Scope |  |  | 1Q11 | Reported | Organic
Volume ('000 hl) | 27832.64003002148 | 0 | 0 | -313.1556124817762 | 27519.48441753971 | -0.01125138011140847 | -0.01125138011140851
Net revenue | 4175.788 | 0 | 0 | 419.933 | 4595.721 | 0.1005637738314302 | 0.1005637738314301
Net revenue/hl | 150.0320485406995 | 0 | 0 | 16.96675602523518 | 166.9988045659347 | 0.1130875448963331 | 0.1130875448963331
[NAME] | -1257.33 | -15.984 | 0 | -105.373 | -1378.687 | 0.09651960901274914 | 0.08380695600995759
[NAME]/hl | -45.17465819425644 | -0.5742897541432939 | 0 | -4.349628721201142 | -50.09857666960088 | 0.108997359850981 | 0.09628470684818947
Gross profit | 2918.458 | -15.984 | 0 | 314.56 | 3217.034 | 0.1023060808139094 | 0.1077829456514365
Gross margin | 0.698899944154253 | 0 | 0 | 0 | 0.7000063754958145 | 10 | 50
SG&A excl. deprec.&amort. | -1026.623 | 0 | 0 | -117.1880000000001 | -1143.811 | 0.1141490108832552 | 0.1141490108832552
SG&A deprec.&amort. | -105.636 | -6.66 | 0 | 17.30299999999999 | -94.99300000000001 | -0.1007516376992691 | -0.1637983263281456
SG&A total | -1132.259 | -6.66 | 0 | -99.88500000000008 | -1238.804 | 0.09409949490355118 | 0.08821744848131044
Other operating income | 102.498 | 0 | 0 | 34.37400000000001 | 136.872 | 0.3353626412222679 | 0.3353626412222678
Normalized EBIT | 1888.697 | -22.644 | 0 | 249.0489999999999 | 2115.101999999999 | 0.1198736483406284 | 0.1318628663041239
Normalized EBIT margin | 0.4522971472689705 | 0 | 0 | 0 | 0.4602328992556336 | 80 | 130
Normalized EBITDA | 2098.178 | 0 | 0 | 238.326 | 2336.504 | 0.1135871217789912 | 0.1135871217789911
Normalized EBITDA margin | 0.5024627687037753 | 0 | 0 | 0 | 0.5084085826794098 | 60 | 60