tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708f5aeb-bd8b-4e6f-929c-300e522cb4e3
Sheet: Sheet1

Unnamed: 0 | M&MIII AM Toll Free Numbers | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Asset Manager (Sales)
 | Contract Area | Contract Area States | Company Name | Toll-Free Number
 | 1A | IL, IN, KY, NC, SC, TN | PEMCO | [PHONE]
 |  | IL, IN, KY, NC, SC, TN | Ofori | [PHONE]
 |  | IL, IN, KY, NC, SC, TN | HomeTelos | [PHONE]
 |  | AL, GA, FL, MS, Puerto Rico | PEMCO | [PHONE]
 | 2A | AL, GA, FL, MS, Puerto Rico | Ofori | [PHONE]
 |  | AL, GA, FL, MS, Puerto Rico | HomeTelos | [PHONE]
 | 1D | CO, NM, TX (North), UT | HomeTelos | [PHONE]
 |  | CO, NM, TX (North), UT | [NAME] | [PHONE]
 |  | CO, NM, TX (North), UT | PEMCO | [PHONE]
 | 2D | AR, KS, LA, MO, OK, TX (South) | PEMCO | [PHONE]
 |  | AR, KS, LA, MO, OK, TX (South) | [NAME] | [PHONE]
 |  | AR, KS, LA, MO, OK, TX (South) | HomeTelos | [PHONE]
 | 4D | SD, NE, IA, WI | [NAME] | [PHONE]
 | 5D | WY, MT, ND, MN | [NAME] | [PHONE]
 | 3S | AZ | BLB | [PHONE]
 | 4S | ID, NV | [NAME] | [PHONE]
 | 5S | CA,HI,GU,American Samoa, Northern Mariana Islands | BLB | [PHONE]
 | 6S | OR, WA, AK | BLB | [PHONE]
 | 1P | MI | BLB | [PHONE]
 |  | MI | Cityside HNH | [PHONE]
 | 2P | DC, DE, MD, PA, OH, VA, WV | [NAME] | [PHONE]
 |  | DC, DE, MD, PA, OH, VA, WV | Ofori | [PHONE]
 |  | DC, DE, MD, PA, OH, VA, WV | HomeTelos | [PHONE]
 | 3P | CT, MA, ME, NH, NJ, NY, RI, VT | Ofori | [PHONE]
 |  | CT, MA, ME, NH, NJ, NY, RI, VT | Cityside HNH | [PHONE]
 |  |  |  | Revised 03-26-14
Spreadsheet: 59749d1260311448-formatting-problem-sample
Sheet: sample

30+50.000 | -0.792 | 0.79' Lt +50
30+75.000 | -0.695 | 0.70' Lt +75
31+00.000 | -0.578 | 0.58' Lt +00
31+25.000 | -0.443 | 0.44' Lt +25
31+50.000 | -0.29 | 0.29' Lt +50
31+75.000 | -0.117 | 0.12' Lt +75
32+00.000 | 0.074 | 0.074' Rt +00
32+25.000 | 0.284 | 0.284' Rt +25
32+50.000 | 0.513 | 0.513' Rt +50
32+75.000 | 0.765 | 0.765' Rt +75
33+00.000 | 1.027 | 1.027' Rt +00
33+25.000 | 1.312 | 1.312' Rt +25
33+50.000 | 1.615 | 1.615' Rt +50
33+75.000 | 1.938 | 1.938' Rt +75
Spreadsheet: kate_symes__18264__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
Spreadsheet: 745727d1630142420-how-do-i-duplicate-column-data-from-one-table-to-another-without-vba-test-worksheet
Sheet: Sheet1

Record ID | Data 1 | Data 2 | Data 3
ID001 | cat | apple | earth
ID002 | dog | banana | mars
ID003 | cow | grapes | venus
ID004 | eagle | apple | earth
ID005 | elephant | pineapple | neptune
Spreadsheet: 675803d1588499973-create-list-from-non-error-rows-sample01
Sheet: No Match

Code1 | Description1 | Code2 | Description2 | Notes
 | Row 04 | #N/A | #N/A | 0
99 | Row 06 | #N/A | #N/A | 0
Sample | Row 07 | #N/A | #N/A | 0
Star Wars | Row 08 | #N/A | #N/A | 0
123 | Row 09 | #N/A | #N/A | 0
321 | Row 10 | #N/A | #N/A | 0
4 | Row 11 | #N/A | #N/A | 0
8 | Row 12 | #N/A | #N/A | 0
28 | Row 15 | #N/A | #N/A | 0
Spreadsheet: 805876d1668973583-looking-for-a-function-that-do-a-sum-look-up-across-multiple-sheets-excel-workbook
Sheet: Mike

 | Date | Deposits
 | 2022-11-06 00:00:00 | 20000
 | 2022-11-07 00:00:00 | 19000
 | 2022-11-08 00:00:00 | 23000
 | 2022-11-09 00:00:00 | 15000
 | 2022-11-10 00:00:00 | 12000
 | 2022-11-11 00:00:00 | 13000
 | 2022-11-04 00:00:00 | 5000
 | 2022-11-12 00:00:00 | 4000
 | 2022-11-03 00:00:00 | 5000
Spreadsheet: 695710d1600354869-excel-function-countifs-with-nested-or-function-and-wildcards-sample-data_countifs-with-nested-or-function-and-wildcards-ans
Sheet: Sheet1

CITIES |  |  | COLLECTIONS | [NAME] | FORMULAS
London | New York | Paris | Bags- Accessories, dresses, casual-wear | I want to know for each row which collections were sold for each city. I do not want to format city names to make them consistent (which would be the right thing to do but it could be a problem on the original spreadsheet). So I need to use COUNTIFS with a nested OR function and a few wildcards.
Sydney | New York |  | Dresses, office-wear | For instance my formula on the right should show the number of times [NAME] (or Sy-City) has sold bags and accassories collections.
New York | Lon |  | Sportswear | WHY IS IT NOT COMPUTING?
Paris | Sy-City |  | Office-wear, bags-accessories | Thanks in advance!
Rome | Sydney |  | Casual-wear, sports-wear, bags-accessories
Berlin | NY |  | Casual-wear
Sy-City |  |  | Office-wear, bags-accessories
NY
Lon | Par
Spreadsheet: 03b227ff-5dce-456b-b650-2ddfaa65d7ae
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FLBAE | Test | FLBAE | Ladybeetle Multicolored Asian (Harmonia axyridis) IgE | Ladybeetle Asian IgE | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L  Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 2 - 3 days | 4 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FLBAE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FLBAE | Result | Z3128 | Ladybeetle Asian IgE | Ladybeetle Asian IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FLBAE | Result | Z3129 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 848926d1699531886-postcode-and-country-validity-with-a-formula-postcode-valid
Sheet: Sheet1

Contact First Name | Contact Last Name | Country | Postcode
? |  | UK | E6 000
e |  | UK | E6 000
[NAME] | B | UK | IG5 7AH
[NAME] | Bloggs | UK | E23 098
Trevor | Smith | UK | IG12PP
[NAME] | Smith | UK | IG1 2PP
eeeeeeeeee |  | UK | SW1A 0AA
67*& |  | UK | SW1A0AA
Ally | Smith | UK | E201 EJ
[NAME] | Smith | UK | E20 1EJ
Spreadsheet: 834069d1687429107-need-formula-to-sum-two-sections-where-one-section-can-change-questionpost1
Sheet: Sheet1

Country-A | Counts
Denmark | 6
Poland | 10
Austria | 3
Finland | 3
Germany | 25
 |  |  |  | Is there a formula that can sum B10 to B23.  Note:  Countries can be manually added to section Country-B2 so formula would need to be updated accordingly.
 |  |  |  | Sum of Counts
Country-B1 | Counts
Denmark | 6
Finland | 3
Belgium | 7
Australia | 8
Canada | 17
Taiwan, Province of China | 6
South Korea | 6
Manually updated Country List
Country-B2 | Counts
Norway | 6
Egypt | 4
India | 8
Mexico | 12
Country-C | Counts
Denmark | 5
Poland | 7
Austria | 2
Finland | 4
Germany | 5
Spreadsheet: 226560d1365442143-excel-solver-problem-ive-never-used-it-acres-oeldere-
Sheet: Blad1

 | bulls/cows | acres | total
750 | 30 | 2
 | 1 | 3
hi All - I have a problem and think I would like to experience using solver to help me solve this:
given 1000 acres of land, and that 75% of its is pasturable - I want to maximize the numbers of cows that can be on it.
There can be a max of 1 cow per 2 acres
And we need 1 bull per 3 acres
The ratio of bulls to cows is 1 bull per 30 cows
how many cows and how many bulls can we have in total for the 750 acres?
Thank you!
Spreadsheet: 732183d1620817882-multiple-nested-ifs-test-4-
Sheet: Sheet1

New / Used | coat | hat | shoe | shirt | jumper | Deposit Return |  |  |  |  |  |  |  | Coat | hat | shoe | shirt | jumper
N | No | Yes | Yes | Yes | Yes |  |  |  |  |  |  |  | New | 10 | 5 | 2 | 4 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Used | 5 | 3 | 1 | 1 | 2
Spreadsheet: 13af0001-8e1d-47d7-bf62-f52a38555232
Sheet: Sheet1

Table 10--Final 2012 U.S. cotton acreage, yield, and production | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
State/Region | Planted | Harvested | Yield | Production
 |  |  | Pounds/ | 1,000
 | 1,000 acres |  | [NAME] | bales
Upland:
Alabama | 380 | 378 | 946 | 745
Florida | 108 | 107 | 897 | 200
Georgia | 1290 | 1280 | 1091 | 2910
N. Carolina | 585 | 580 | 1014 | 1225
S. Carolina | 299 | 298 | 955 | 593
Virginia | 86 | 85 | 1118 | 198
Southeast | 2748 | 2728 | 1033 | 5871
Arkansas | 595 | 585 | 1064 | 1297
Louisiana | 230 | 225 | 1020 | 478
Mississippi | 475 | 470 | 1014 | 993
Missouri | 350 | 330 | 1063 | 731
Tennessee | 380 | 377 | 946 | 743
Delta | 2030 | 1987 | 1025 | 4242
Kansas | 56 | 54 | 622 | 70
Oklahoma | 305 | 140 | 531 | 155
Texas | 6550 | 3850 | 623 | 5000
Southwest | 6911 | 4044 | 620 | 5225
Arizona | 200 | 197 | 1474 | 605
California | 142 | 141 | 1729 | 508
New Mexico | 45 | 38 | 1061 | 84
West | 387 | 376 | 1528 | 1197
Total Upland | 12076 | 9135 | 869 | 16535
Pima:
Arizona | 3 | 3 | 1168 | 7
California | 225 | 224 | 1614 | 753
New Mexico | 2 | 2 | 1043 | 5
Texas | 8 | 8 | 928 | 15
Total Pima | 238 | 237 | 1581 | 780
Total All | 12314 | 9372 | 887 | 17315
Source: USDA, National Agricultural Statistics Service, May 2013 Crop Production.
Last update: 05/14/13.
Spreadsheet: 70113d1270774855-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-27-08 2nd

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-27 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 4 |  | 8.5 |  | 3.7
PR |  | 4 |  |  |  | 2.3
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 4-1 | 42111-02070-00 |  | Problem:  O/L burr, [NAME] sticking, fingers |  |  | Station:3,5,6 |  | Ran: 0 of 640 | 1.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | O/L=fingers too close. Lifter=NG bushings. Fingers=needed adjusting |  |  | 615-145
Pulled Twice…1 on first shift for quality issues. |  |  |  |  | Explain: | The O/L was coming from the  5/6 station, The fingers were too close holding the part tight causing the burr. |  |  |  |  | R.B PJ J.C D.E
Changed process'. Put old back in. |  |  |  |  | We backed the fingers back. 6/6 [NAME] would stick, ground out the bushing but that did not help. Ended up chaing them later on. |  |  |  |  |  | K.S [NAME]
Stamping T/L: Shane Roby |  |  |  |  | Helped stamping with finger adjustments. Stamping Eng. Was having problems with coolant getting on the sensors. Rigged |  |  |  |  |  | C.E
 |  |  |  |  | up something to help keep the coolant off of them. Needs to be made better. Stamping eng will help on this 10-28-08.
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 7d5a9330-7164-4f92-a3a6-47d184c61d34
Sheet: Sheet1

Reimbursement Log | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 |  | Invoice No. | 100
 |  | Date | 2011-04-27 00:00:00
 |  | Consultant(s) | [NAME] [NAME]
 |  | E-Mail | kcole@scroggins consulting.com [EMAIL]
 |  | Phone
Scroggins Consulting, LLC
3224 Midway Ave
Shreveport, LA  71109
[PHONE] |  | Deposit Received | 0
www.scrogginsconsulting.com |  | Reimbursement Total | 940
[EMAIL] |  | Total Amount Due | 940
 |  | Amount Paid
Destination | 3520  General [NAME], Ste 1070,  New Orleans, LA 70114
Travel Dates | 3/11/2011 & 4/11/2011
No. of Travelers | 2 | Tax Rate | 0
Service/Assignment Name | Description | Amount per Traveler | Total Amount
Ground Travel/Compu-Cure | [NAME] of 782 miles @ $0.50 prt mile | 391 | 782
Lodging | N/A-consultants either maintained lodging with family or did not need lodging | 0 | 0
M&IE | 2.2 days of meals and incedental expenses | 79 | 158
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | Subtotal | 940
*All receipts and reimbursments should be submitted with corresponding invoice by the 20th of the month. For verification, fax copies of receipts to [PHONE]. |  | Tax | 0
 |  | Total | 940
Notes:
 | Tax rate is not applicable in this situation
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2223 | -2135 |  | -25
2 | -2302 | -2135 | -4 | -25
3 | -2221 | -2135 |  | -25
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114286.65
2002-01-03 00:00:00
CBS Volume
 |  |  | 48091
Spreadsheet: 21962d1210248258-creating-a-dynamic-summary-page-billing-report-example2
Sheet: detail design

detail design BILLING
 |  |  | Cell No. | Site Name | Status | Operator | Region | Site Type | New / Upgrade | Tech-nology | Structure Type | MSV Date | MSV Date | GADrawing Internal Issue [NAME] | Internal Issue | External Issue | Issue month | Billing Amount | Billing Date | Billing month | Latest Comment GA | GA Drawing External Issue | Operator GA Approval | Operator GA Approval
Spreadsheet: 724598d1616252400-lookup-and-count-functions-to-ignore-blank-cells-that-contain-formulas-lookup-example-1-
Sheet: Sheet1

Lets - General Needs
 |  |  |  |  |  |  |  |  | April | May | June | July | August | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Ave | Total
 | Total Number of Re-Lets (STV) |  |  |  |  |  |  |  | 5 | 10 | 0 | 5 | 10
 | STV Rented Days Lost |  |  |  |  |  |  |  | 150 | 100 | 0 | 5 | 5
 | Average Days to Re-Let (STV) |  |  |  |  |  | 34 | 37.5
 | Total Number of Re-Lets (LTV) |  |  |  |  |  |  |  | 5 | 10 | 0 | 5 | 10
 | LTV Total Rented Days Lost |  |  |  |  |  |  |  | 150 | 100 | 0 | 5 | 5
 | Average Days to Re-Let (LTV) |  |  |  |  |  | 34 | 37.5
Spreadsheet: 77041d1277478090-compile-multiple-columns-into-1-excel-help-example
Sheet: Sheet1

Example 1 | Example 2 | Example 3 |  | Current format in colums
hello | thanks | for the help
hi | appreciated | on this sheet
hey |  | it will save
 |  | me time
Example 1 | hello |  |  | Want it to look like this
Example 1 | hi
Example 1 | hey
Example 2 | thanks
Example 2 | appreciated
Example 3 | for the help
Example 3 | on this sheet
Example 3 | it will save
Example 3 | me time
Spreadsheet: chris_germany__1977__lonestarnom2
Sheet: May 1, 2002

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  | 713/853-4743 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  | 713/646-3037 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-05-01 00:00:00 |  | End Date: | 2002-05-31 00:00:00
 |  |  |  | REVISED
RECEIPT POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
17-1201-11 | [NAME] | 01T957 | 0 | 0.01
17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0.01
17-1240-50 | NNG Sprayberry | 108466 | 0 | 0.01
17-7462-50 | [NAME] | 5268 | 0 | 0.01
17-3000-00 | [NAME] | 2880600203 | 25000 | 0.01 |  | **
17-1201-11 | [NAME] | REM | 0 | 0.01 |  | **
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671
FYI:  Buy/Sell Information
17-1201-11 | [NAME] | #01T957 | 10000 | 0 | 10000 | sold to TXU K501
Spreadsheet: 453886d1459507256-create-more-rows-when-a-criteria-is-met-sample
Sheet: After

Division | Market | Customer # | Year | Month | Data Source | Period YTD | Sales | GP | Fin Cost
D-001 | JP | CTM#2389 | 2015 | 1 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 2 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 3 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 4 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 5 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 6 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 7 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 8 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 9 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 10 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 11 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 12 | Actual | 2015A | 100
D-001 | JP | CTM#2389 | 2015 | 1 | Budget | 2015B | 150
D-001 | JP | CTM#2389 | 2015 | 2 | Budget | 2015B | 150
D-001 | JP | CTM#2389 | 2015 | 3 | Budget | 2015B | 150
D-001 | JP | CTM#2389 | 2015 | 4 | Budget | 2015B | 150 |  |  |  |  |  |  | Column Labels
D-001 | JP | CTM#2389 | 2015 | 5 | Budget | 2015B | 150 |  |  |  | Row Labels | Customer # | Values | 2015A | 2015B | 2015F (3+9)
D-001 | JP | CTM#2389 | 2015 | 6 | Budget | 2015B | 150 |  |  |  | D-001 | CTM#2389 | Sum of Sales | 1200 | 1800 | 1560
D-001 | JP | CTM#2389 | 2015 | 7 | Budget | 2015B | 150 |  |  |  |  |  | Sum of GP | 120 | 180 | 156
D-001 | JP | CTM#2389 | 2015 | 8 | Budget | 2015B | 150 |  |  |  |  |  | Sum of Fin Cost | 2.4 | 3.599999999999999 | 3.12
D-001 | JP | CTM#2389 | 2015 | 9 | Budget | 2015B | 150 |  |  |  | Total Sum of Sales |  |  | 1200 | 1800 | 1560
D-001 | JP | CTM#2389 | 2015 | 10 | Budget | 2015B | 150 |  |  |  | Total Sum of GP |  |  | 120 | 180 | 156
D-001 | JP | CTM#2389 | 2015 | 11 | Budget | 2015B | 150 |  |  |  | Total Sum of Fin Cost |  |  | 2.4 | 3.599999999999999 | 3.12
D-001 | JP | CTM#2389 | 2015 | 12 | Budget | 2015B | 150
D-001 | JP | CTM#2389 | 2015 | 1 | Actual | 2015F (3+9) | 100
D-001 | JP | CTM#2389 | 2015 | 2 | Actual | 2015F (3+9) | 100
D-001 | JP | CTM#2389 | 2015 | 3 | Actual | 2015F (3+9) | 100
D-001 | JP | CTM#2389 | 2015 | 7 | Budget | 2015F (3+9) | 150
D-001 | JP | CTM#2389 | 2015 | 8 | Budget | 2015F (3+9) | 150
D-001 | JP | CTM#2389 | 2015 | 9 | Budget | 2015F (3+9) | 150
D-001 | JP | CTM#2389 | 2015 | 10 | Budget | 2015F (3+9) | 150
D-001 | JP | CTM#2389 | 2015 | 11 | Budget | 2015F (3+9) | 150
D-001 | JP | CTM#2389 | 2015 | 12 | Budget | 2015F (3+9) | 150
D-001 | JP | CTM#2389 | 2015 | 4 | Forecast | 2015F (3+9) | 120
D-001 | JP | CTM#2389 | 2015 | 5 | Forecast | 2015F (3+9) | 120
D-001 | JP | CTM#2389 | 2015 | 6 | Forecast | 2015F (3+9) | 120
Spreadsheet: 296801d1392199649-create-unique-list-from-data-ef574_example2
Sheet: Central Colleagues

Full Name | DIVISION | DEP_AREA | DEPTID | DEPTNAME | LAST_NAME | FIRST_NAME | [NAME] | Full Name |  | Unique_ID
[NAME] | IT | Applications & Development | IT41560A | Store Applications | Bloggs | [NAME] | HILMORE
[NAME] | Loss Prevention | LP Corporate & Finance | LP42721A | Loss Prevention Finance | [NAME] | [NAME] | HILMORE
[NAME] | IT | Applications & Development | IT41560A | Store Applications | Harisson | George | HILMORE
[NAME] | IT | Project Delivery Office | IT41507A | IT Delivery & Project Managers | Jagger | Mick | HILMORE
[NAME] | IT | Applications & Development | IT41560A | Store Applications | [NAME] | [NAME] | HILMORE
[NAME] | IT | Applications & Development | IT41560A | Store Applications | [NAME] | [NAME] | HILMORE
[NAME] | Evolve | Evolve | EVO40215A | Evolve IT | Richards | [NAME] | HILMORE
[NAME] | Evolve | Evolve | EVO40215A | Evolve IT | [NAME] | [NAME] | HILMORE
[NAME] | IT | Project Delivery Office | IT41507A | IT Delivery & Project Managers | Smith | Mark | HILMORE
Ringo Starr | Loss Prevention | LP Corporate & Finance | LP42721A | Loss Prevention Finance | [NAME] | Ringo | HILMORE
[NAME] | Evolve | Evolve | EVO40215A | Evolve IT | Watts | [NAME] | HILMORE
[NAME] | IT | Project Delivery Office | IT41507A | IT Delivery & Project Managers | Wyman | [NAME] | HILMORE