tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0059affc-218f-439f-a257-d7afda958c89
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Pearson's correlation coefficients (replicates are in bold)
 | Mx1 | Mx2 | [NAME] | ORS2 | DF1 | DF2 | DP1 | DP2 | Mc1 | Mc2
Mx1 | 1 | 0.949889075706556 | 0.868761233983543 | 0.834193312444093 | 0.561200216718897 | 0.606743084672246 | 0.550681009868514 | 0.534102403053356 | 0.652255022238307 | 0.626591177555286
Mx2 | 0.949889075706556 | 1 | 0.87959652896589 | 0.872390603827125 | 0.56063205468231 | 0.614736904046959 | 0.563387446815177 | 0.545730615451155 | 0.649377798078086 | 0.634776936122663
[NAME] | 0.868761233983543 | 0.87959652896589 | 1 | 0.959362353434396 | 0.655574527478067 | 0.689844717929489 | 0.612625088598616 | 0.610432872235622 | 0.620530883657008 | 0.594286669719428
ORS2 | 0.834193312444093 | 0.872390603827125 | 0.959362353434396 | 1 | 0.679377936772218 | 0.724810187437634 | 0.643705119435997 | 0.63770458810997 | 0.618162338266239 | 0.601929481887028
DF1 | 0.561200216718897 | 0.56063205468231 | 0.655574527478067 | 0.679377936772218 | 1 | 0.954763419634342 | 0.866509074948744 | 0.866172376403304 | 0.680617858808596 | 0.659317775613064
DF2 | 0.606743084672246 | 0.614736904046959 | 0.689844717929489 | 0.724810187437634 | 0.954763419634342 | 1 | 0.848280766705205 | 0.867386740046734 | 0.652200059266847 | 0.633081898339727
DP1 | 0.550681009868514 | 0.563387446815177 | 0.612625088598616 | 0.643705119435997 | 0.866509074948744 | 0.848280766705205 | 1 | 0.964890793976658 | 0.753849554720418 | 0.739776541369259
DP2 | 0.534102403053356 | 0.545730615451155 | 0.610432872235622 | 0.63770458810997 | 0.866172376403304 | 0.867386740046734 | 0.964890793976658 | 1 | 0.709603550890237 | 0.69336910076133
Mc1 | 0.652255022238307 | 0.649377798078086 | 0.620530883657008 | 0.618162338266239 | 0.680617858808596 | 0.652200059266847 | 0.753849554720418 | 0.709603550890237 | 1 | 0.96707545498333
Mc2 | 0.626591177555286 | 0.634776936122663 | 0.594286669719428 | 0.601929481887028 | 0.659317775613064 | 0.633081898339727 | 0.739776541369259 | 0.69336910076133 | 0.96707545498333 | 1
Spreadsheet: 01447e1e-d967-449e-a705-166f238f4c09
Sheet: Sheet1

Title | Name | Date | Amount | Description
Municipal Judge | [NAME] | 2013-11-15 00:00:00 | 28.31 | Mileage Reimbursement to attend NMML Automation Committee Meeting and [NAME] on 11/8/13
Municipal Judge | [NAME] | 2013-10-07 00:00:00 | 230.58 | Alamo Rent-A-Car Reno, NV
City Manager | [NAME] | 2013-11-20 00:00:00 | 100 | Registration fee for the NM City Managers Association Winter Conference
Spreadsheet: 98428d1297331605-index-match-sumproduct-book1
Sheet: Sheet2

DL00305LCLMN |  |  |  |  |  | NNI
DL003060LCLMNS |  |  |  |  |  | NNI
[NAME] |  |  |  |  |  | CDI
DL0030A14 |  |  |  |  |  | CDI
DL0030A15 |  |  |  |  |  | CDI
DL0030A15PI1 |  |  |  |  |  | CDI
[NAME] |  |  |  |  |  | CDI
DL0030A15VB1 |  |  |  |  |  | CDI
DL0030A15VVPPWK |  |  |  |  |  | NNI
DL0030A16 |  |  |  |  |  | NII
DL0030A16VVPPWK |  |  |  |  |  | NII
DL0030A17 |  |  |  |  |  | CDI
DL0030A17AG1 |  |  |  |  |  | CDI
DL0030A17GBOX1 |  |  |  |  |  | NDI
DL0030A17M1 |  |  |  |  |  | NDI
DL0030A17PI1 |  |  |  |  |  | CDI
DL0030A17PSV1 |  |  |  |  |  | CDI
DL0030A17TI1 |  |  |  |  |  | CDI
DL0030A17VB1 |  |  |  |  |  | CDI
[NAME] |  |  |  |  |  | CDI
DL0030A18AG1 |  |  |  |  |  | CDI
DL0030A18GBOX1 |  |  |  |  |  | NDI
DL0030A18M1 |  |  |  |  |  | NDI
DL0030A4AG1 |  |  |  |  |  | CDI
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr. Nedhal Ayoub

Contract Terms (*)
 |  | Description | Commission
 |  | Refferal | 0.1
 |  | Consultation (After deducting OHE 5%) | 0.5
 |  | Procedure in the Clinic (After deducting material consumables such as Botox & Filler and OHE 5%) | 0.5
 |  | OR in the Clinic (From gross after deducting OHE 5%) | 0.42
Doctor Calculation
 |  | LAB Refferal Revenue | 0
 |  | Amount to be paid
 |  | Doctor Consultation Revenue | 0
 |  | OHE (5%)
 |  | Net Consultation Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue | 0
 |  | Consumables
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | OR in the Clinic Doctor Revenue | 0
 |  | OHE (5%)
 |  | Net OR in the Clinic Doctor Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  | Sr. Finance Manager |  | .......................
 |  |  |  |  |  | Operations Report on April - 2019
 |  |  |  |  |  | # | Day/Date | Time | Patient Name and file number |  | [NAME] | Price | Surgeon | Anesthesia
 |  |  |  |  |  | 20 | 2019-04-17 00:00:00 | At 3:15 pm he tooks          3 hrs & 54 mins | [NAME] |  | Vaser Liposuction abdomen and flanks | 15000 | Dr Nedhal Ayoub | GA | 3000+2000+2000+2000
 |  |  |  |  |  | 28 | 2019-04-27 00:00:00 | At 3:30 pm he tooks          1 hr & 48 mins | [NAME] 10050540 |  | Vaser lipo falanks and fat injection | 4500 | Dr Nedhal Ayoub | GA | 3000+2000
Spreadsheet: 142799d1330013176-excel-2010-matching-one-cell-to-a-list-of-cells-on-another-sheet-sites-and-dialplan-online-help
Sheet: CHS Sites

[NAME]
Name | Address | Location | Numbers
[NAME] |  | Barrie
[NAME] |  | Belleville
CHS Brantford Viavideo |  | Brantford
[NAME] |  | Brockville
[NAME] |  | Chatham
[NAME] |  | [NAME]
[NAME] OIS VRI 1 |  | [NAME]
[NAME] OIS VRI 2 |  | [NAME]
[NAME] |  | [NAME]
[NAME] lake Vcon |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] room |  | Kingston
[NAME] |  | Kingston
[NAME] reed room |  | London
[NAME] meeting room A |  | London
[NAME] |  | Newmarket
[NAME] Via Video |  | [NAME]
CHS North Bay Vcon |  | North
CHS Ottawa Board room |  | Ottawa
CHS Ottawa viewstation |  | Ottawa
[NAME] |  | Peel
CHS Peterborough Counseling roo |  | Peterborough
CHS Peterborough Viewstation |  | Peterborough
CHS Sault St. Marie |  | Sault
[NAME] Brdroom A |  | Sudbury
[NAME] [NAME] |  | Sudbury
[NAME] RD-Vcon |  | Sudbury
CHS Thudbay Howard king |  | Thudbay
CHS Thudbay smallroom |  | Thudbay
[NAME] room |  | Timmins
CHS Toronto 3rd Floor Boardroom |  | Toronto
[NAME] [NAME] |  | Toronto
CHS Toronto Connect |  | Toronto
CHS Toronto COO |  | Toronto
[NAME] [NAME] |  | Toronto
[NAME] HR |  | Toronto
CHS Toronto Peikoff Room |  | Toronto
CHS Toronto President & CEO |  | Toronto
[NAME] [NAME] |  | Toronto
[NAME] |  | [NAME]
[NAME] |  | Windsor
CHSVCON - testing |  | Toronto
Spreadsheet: 696493d1600855593-total-and-percentage-of-another-value-new-microsoft-excel-worksheet
Sheet: Sheet1

Year | Total Cases | In Warranty Cases | Out Warranty Cases | Unknown Warranty Cases | % In Warranty  Cases | % Out Warranty Cases | % Unknown Warranty Cases |  | Revised In Warranty Cases | Revised Out Warranty Cases | Revised In Warranty Cases % | [NAME] Warranty Cases %
2013 | 26 | 12 | 4 | 10
2014 | 51 | 20 | 11 | 20
2015 | 123 | 64 | 19 | 40
2016 | 275 | 146 | 49 | 80
2017 | 397 | 190 | 99 | 108
2018 | 739 | 299 | 227 | 213
2019 | 949 | 409 | 368 | 172
2020 | 486 | 204 | 199 | 83
Spreadsheet: 25105d1216222542-bonus-calculations-using-nested-ifs-copy-of-commission-bands
Sheet: Bonus Calculation

Category | Source_Code | Title | Volume | Revenue | Yield | Base Yield | Rate | Commission | Variance to Target
Classified Entertainment | DELL1 | A | 500 | 850
Classified Motors | DELL1 | B | 250 | 350
Classified Motors | DELL1 | C | 3500 | 4000
Classified Motors | DELL1 | D | 2000 | 2350
Classified Motors | DELL1 | E | 200 | 250
Classified Motors | DELL1 | F | 400 | 500
Classified Motors | DELL1 | G | 4000 | 6000
ROP Feature | DELL1 | H | 500 | 750
ROP Feature | DELL1 | I | 55 | 100
ROP Motors | DELL1 | J | 70 | 200
ROP Retail & Services | DELL1 | K | 70 | 100
ROP Retail & Services | DELL1 | L | 300 | 500
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9903

March 1999 Transport Expense Flash
 |  |  | Commodity Expenses |  |  |  | Comments
Texas Co. 78 |  |  |  |  |  |  | Long term deal commodity expense
Texas Co. 78 |  |  | 1240 |  |  |  | payable to Pan Grande Pipeline 96019628
Texas Co. 16 |  |  | 14962.28 |  |  |  | payable to Black Marlin - 96006607/8
Texas Co. 16 |  |  | 2875 |  |  |  | payable to Centana- 96018371
Texas Co. 16 |  |  | 106475 |  |  |  | payable to Oasis Pipeline- 96015445
Texas Co. 16 |  |  | 79931 |  |  |  | payable to PG&E/Valero 96006479/96006482/96009903/96011842/96016347
Texas Co. 16 |  |  | 15624 |  |  |  | payable to Channel Industries-96017837
Texas Co. 16 |  |  |  |  | 98300 |  | Centana Storage Demand Charge
 |  |  |  |  |  |  | ***booked as an annuity and is located in financial price
Texas Co. 16 |  |  |  |  | 10000 |  | Entex Management Fee to Storage
Totals
Spreadsheet: 679903d1590677798-sumif-trouble-with-unique-values-and-summing-the-max-values-maxifs-1-
Sheet: Sheet2

Week | Name | Orders
1 | [NAME] | 5000
1 | [NAME] | 200
1 | [NAME] | 1000
1 | [NAME] | 7000
2 | [NAME] | 9000
2 | [NAME] | 200
2 | [NAME] | 8000
2 | [NAME] | 15000
Spreadsheet: 141353d1329230073-trying-to-display-information-from-multiple-sheets-onto-1-summary-sheet-ef41_copy-of-production-scheduler-2-
Sheet: Summary

Status | Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min People | Budget Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools |  | yymm | seq
[NAME] | 2011-02-02 00:00:00 | A***** | O**** | ***** | ***** | **** | *** | **** | **** | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | **** | ****
 | 2012-02-08 00:00:00 | A16573 |  | COMBUSTION SOLUTIONS | [NAME] | 1 OFF SINGLE SYSTEM | 1 | 20 | ELECTRICAL | 2012-03-12 00:00:00 | 2012-03-16 00:00:00
 | 2012-02-08 00:00:00 | N16500 | EASINGTON | COSTAIN | DAVE SMITH | 10" TWIN STREAM METERING SKID | 2 | 320 | MECHANICAL | 2012-06-04 00:00:00 | 2012-06-22 00:00:00
 | 2012-02-08 00:00:00 | N14700/2816 | RYEHOUSE | NAT GRID | [NAME] | INSTALL HAND RAIL / BARRIERS | 1 | 8 | MECHANICAL | 2012-02-17 00:00:00 | 2012-02-17 00:00:00 |  | 36V HAMMER DRILL, 1 1/2" TUBE CUTTER
 | 2012-01-30 00:00:00 | N16000 | SAPPERTON | NAT GRID | S.OWEN | GTA | 1 | 80 | ELECTRICAL | 2012-02-13 00:00:00 | 2012-02-24 00:00:00
Spreadsheet: 46960d1245870563-worksheet_change-macro-sample-1-1
Sheet: Order Form

INTERNATIONAL ORDER FORM
[NAME] To: |  | Ship To:
 |  |  |  |  |  |  |  | Customer #:
 |  |  |  |  |  |  |  | Terms: | Open-60 days
 |  |  |  |  |  |  |  | Taken By: | CL
Order Date: |  |  | P.O. #:
Product      No. | Description | Quantity | Cost/Bottle | Total | Serial No. | Exp. Date | #N/A | #N/A | #N/A | #N/A
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Special Instructions:  2009 Prices for products ordered |  |  | Subtotal | 0
 |  |  | Freight
 |  |  | Total
 | Delivery Date:
 | SAP Due Date: | 1900-04-29 00:00:00
 | Date Wanted:
Labeling Information
Product No. | Description | Full Shippers/ Cases | Btls/Shipper | Partial Shippers/ Cases | Btls/Partial Shippers/ Cases | Total Btls
Gaylord | Product | GLB11A's
Cooler
Spreadsheet: 53354d1253224059-excel-2007-bar-chart-x-axis-labels-show-up-vertical-profit-and-loss-account-example-091609b
Sheet: Data

 | ENTER | CALC | CALC | ENTER | ENTER | ENTER | CALC | ENTER | ENTER | ENTER | ENTER | ENTER | CALC | CALC | ENTER | ENTER | ENTER | ENTER | ENTER | ENTER | CALC | CALC | ENTER
 | Year | Flag | Data Year | Type | Gross Sales | Discounts & Refunds | Net Sales | Beginning Inventory | Purchases | Direct Labor | Manufacturing Overhead | Less: Ending Inventory | Cost of Goods Sold | Gross Profit | Office Expenses | Selling Expenses | Rents | Insurance | Interest Expense | Other General Expenses | Total Selling, General & Administrative Expenses | Net Profit | Comments
 | 2005 |  |  | Budget | 546355 | -33862 |  | 352750 | 229200 | 148100 | 74810 | -250078 |  |  | 50224 | 60678 | 62590 | 16043 | 18078 | 25347
 | 2005 |  |  | Actual | 799574 | -43449 |  | 385563 | 223589 | 182695 | 76268 | -297060 |  |  | 57040 | 50500 | 55838 | 23961 | 20985 | 31236
 | 2006 |  |  | Budget | 732014 | -42346 |  | 285866 | 165361 | 191689 | 62258 | -255603 |  |  | 49549 | 80800 | 51848 | 21388 | 7525 | 26284
 | 2006 |  |  | Actual | 826844 | -27815 |  | 251669 | 271058 | 189874 | 60765 | -305554 |  |  | 52834 | 65208 | 76735 | 20420 | 18132 | 25375
 | 2007 |  |  | Budget | 959702 | -25525 |  | 396050 | 205377 | 136019 | 56607 | -344636 |  |  | 57387 | 48409 | 67924 | 20477 | 19656 | 37860
 | 2007 |  |  | Actual | 917778 | -27259 |  | 351309 | 223981 | 117806 | 66247 | -321212 |  |  | 49128 | 57997 | 77029 | 17696 | 16433 | 25647
 | 2008 |  |  | Budget | 934533 | -34380 |  | 290312 | 205771 | 154023 | 80809 | -387479 |  |  | 51752 | 79592 | 59429 | 17825 | 19305 | 25263
 | 2008 |  |  | Actual | 656455 | -27303 |  | 293990 | 166208 | 115632 | 64045 | -369568 |  |  | 57944 | 69980 | 56789 | 15124 | 8329 | 27720
 | 2009 |  |  | Budget | 939907 | -38710 |  | 319809 | 204528 | 131772 | 73328 | -374200 |  |  | 55444 | 57267 | 75539 | 17883 | 14126 | 39767
 | 2009 |  |  | Projected | 870236 | -45863 |  | 385284 | 194386 | 169602 | 69313 | -384248 |  |  | 57072 | 96086 | 56150 | 20990 | 11484 | 28074
 | 2010 |  |  | Budget | 905335 | -44878 |  | 306702 | 197653 | 174267 | 54943 | -337326 |  |  | 47575 | 62494 | 82521 | 24009 | 9469 | 31960
 | 2010 |  |  | Projected
 | 2011
 | 2011
 | 2012
 | 2012
 | 2013
 | 2013
 | 2014
 | 2014
Spreadsheet: 47762d1246949311-reorganize-data-result
Sheet: Sheet1

Poll Time | AA | BBB | CCCCC
2009-06-11 00:00:00 | 45 | 45 | 0
2009-06-12 00:00:00 | 4643 | 4643 | 0
2009-06-13 00:00:00 | 456 | 456 | 0
2009-06-14 00:00:00 | 436 | 436 | 0
2009-06-15 00:00:00 | 436 | 436 | 0
2009-06-16 00:00:00 | 3684 | 3684 | 0
2009-06-17 00:00:00 | 4 | 4 | 0
2009-06-18 00:00:00 | 48364 | 0 | 0
2009-06-19 00:00:00 | 4 | 0 | 0
2009-06-20 00:00:00 | 5 | 0 | 0
2009-06-21 00:00:00 | 48 | 0 | 0
2009-06-22 00:00:00 | 836 | 0 | 0
2009-06-23 00:00:00 | 684 | 0 | 0
2009-06-24 00:00:00 | 6 | 0 | 0
2009-06-25 00:00:00 | 436 | 0 | 0
2009-06-26 00:00:00 | 846 | 0 | 0
2009-06-27 00:00:00 | 6 | 0 | 0
2009-06-28 00:00:00 | 4836 | 0 | 0
2009-06-29 00:00:00 | 38 | 0 | 0
2009-06-30 00:00:00 | 4634 | 0 | 0
Spreadsheet: 17a20abd-ee84-4fcc-89a8-d64299ee9354
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
 | 5671.0 Lending Finance, Australia
 | TABLE 49. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (ACT), Original (Number, $000)
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
1. . . [NAME] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413727L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413728R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413729T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413730A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413731C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413732F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413733J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413734K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413735L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413736R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 46750d1245691164-alternative-to-pivot-table-example
Sheet: Sheet1

Year | Code | Place | Person | Product
2004 | 5569 | North | [NAME] | Food
2004 | 2254 | South | [NAME] | Beverage
2004 | 4497 | North | [NAME] | Dish |  | Year | (All)
2004 | 5579 | North | [NAME] | Food
2005 | 2254 | South | [NAME] | Beverage |  | Count of Product | Person
2005 | 5569 | South | [NAME] | Food |  | Place | [NAME] | Fred | [NAME] | [NAME] | Mark | [NAME] | Grand Total
2005 | 5579 | South | [NAME] | Food |  | North | 2 | 1 | 4 | 2 | 3 | 1 | 13
2006 | 4487 | North | [NAME] | Dish |  | South | 3 |  | 1 | 2 | 1 | 4 | 11
2006 | 2264 | North | [NAME] | Beverage |  | Grand Total | 5 | 1 | 5 | 4 | 4 | 5 | 24
2006 | 5579 | South | [NAME] | Food
2006 | 4487 | South | [NAME] | Dish
2006 | 2264 | North | Mark | Beverage
2007 | 5569 | South | [NAME] | Food
2007 | 4487 | North | [NAME] | Dish
2007 | 2254 | South | Mark | Beverage
2008 | 4487 | North | [NAME] | Dish
2008 | 4487 | South | [NAME] | Dish
2008 | 2264 | North | Mark | Beverage
2009 | 2254 | North | [NAME] | Beverage
2009 | 2264 | North | [NAME] | Beverage
2009 | 5569 | South | [NAME] | Food
2009 | 2254 | South | [NAME] | Beverage
2009 | 5569 | North | Mark | Food
2009 | 4497 | North | Fred | Dish
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: TX-HPL-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
 |  | Fuel Allocation:
 |  | Storage Book |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book
 |  | Texas Desk
 |  | Total
 |  | 3rd Party Commidity exp. to transport book
 |  | 3rd Party Demand exp. to transport book
 |  | Total
Spreadsheet: 133123d1324200800-finding-sum-and-rank-fruit-stuff-rank
Sheet: RANKER SHEET

WEEK 1 | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK |  |  |  |  | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK
1 |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  | WEEK 1 RANKS |  |  |  |  |  |  |  |  |  |  | RUNNING RANK….INCLUDES ALL PAST AND CURRENT DATA
WEEK 2 | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 |  | IF(Sheet1!L92=" ","0",(RANK(Sheet1!L92,Sheet1!L87:L105)))
DEC 4 - DEC 10 | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
DEC 18 - DEC 24  RANKS | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
JAN 1 - JAN 7       2012! | APPPLES % | $ per Trans | Oranges % | BANANA % | GRAPES % | POTATO % | POINTS | TOTAL RANK
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 740243d1626253158-formula-to-look-up-how-many-records-there-are-for-a-serial-number-on-a-certain-date-find-date
Sheet: Sheet1

No | S.NO | Worker name | 15-Jun | 16-Jun | 17-Jun | 18-Jun | 19-Jun | 20-Jun | 21-Jun | 22-Jun | 23-Jun | 24-Jun | 25-Jun | 26-Jun | 27-Jun | 28-Jun | 29-Jun | 30-Jun | 1-Jul | 2-Jul | 3-Jul | 4-Jul | 5-Jul | 6-Jul | 7-Jul | 8-Jul | 9-Jul | 10-Jul | 11-Jul | 12-Jul | 13-Jul | 14-Jul | 15-Jul
1 | S_001754
2 | S_000898
3 | S_001641
4 | S_001673
5 | S_001702
6 | S_001762
7 | S_001900
8 | S_001979
9 | S_002013
10 | S_002014
11 | S_002039
12 | S_000716
13 | S_001023
14 | S_002015
15 | L_052689
16 | S_001905
17 | S_001532
18 | S_001401
19 | S_002050
20 | S_001978
21 | S_002012
22 | S_001483
23 | S_002011
24 | S_000275