tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 221280d1363454484-attemepting-to-link-and-automate-multiple-data-points-individual-rep-kpi-report-2013-example
Sheet: Chris

 | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Total
Results | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team
[NAME]
Act Rev
% to Goal
AB Goal
Act AB
% to Goal
[NAME] $ [NAME]
Act App $
% to Goal
Rev p/hr Goal
Act Rev p/hr
% to Goal
[NAME]
Act Conv
% to Goal
Activity | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Total
Dial p/hr Goal | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 10 | 10 |  | 9 | 9 |  | 8 | 8
Act Dial p/hr
% to Goal
Dial Total Goal
Act Total Dials
% to Goal
[NAME] Goal | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00
Act Avg Call Time
% to Goal
Drivers | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Total
OP Days |  | 20 |  |  | 20 |  |  | 23 |  |  | 19 |  |  | 21 |  |  | 22 |  |  | 20 |  |  | 23 |  |  | 20 |  |  | 21 |  |  | 20 |  |  | 17
FTE Count |  | 7.75 |  |  | 8.75 |  |  | 11.25 |  |  | 11.5 |  |  | 12 |  |  | 9.5 |  |  | 8.25 |  |  | 8.25 |  |  | 8.25 |  |  | 9.25 |  |  | 8.25 |  |  | 8.25
Man Hours
Spreadsheet: 123695d1317811582-vlookup-value-in-multiple-sheets-and-display-value-that-is-not-in-adjacent-colum-excel-example
Sheet: B'lana

Name |  | Title |  |  | Section | Department
[NAME] |  | Chief Engineer |  |  | Engineer1 | Engineer Department
Code | Competency | Expect Level | 5 | 4 | 3 | 2 | 1 | Actual Level | Gap (A-E)
 |  |  | Outstanding | Exceed | Meet Expectation | Below | Must Improve
CC 001 | Quality Awareness | 4 |  |  |  |  |  | 3 | -1
 | ·  Improve the quality of products and services based on customer feedback |  |  |  | X
 | ·  Determine quality standards of completed products, work and services. |  |  |  |  | x
 | ·  Execute plans to support local and corporate quality initiatives and strategy |  |  |  | X
CC 002 | Customer Oriented | 3 |  |  |  |  |  | 4 | 0
 | ·  Proactively plan and set guidelines for response to customer expectations. |  |  |  | X
 | ·  Resolve intra-department issues in support of customer satisfaction |  |  |  | X
 | ·  Execute plans in support of customer satisfaction directives and company policy |  |  |  | X
Spreadsheet: 96190d1295608707-conditional-formating-issue-for-forum-conditional-formating
Sheet: Sheet1

LONG DURATION |  | Starts / SR | 2007/08 | 2008/09 | 2009/10 | 2009/10 + / - than 2007/08 | 2009/10 + / - than 2008/09 | SR + / - than White U19
Under 19 | African | Starts | 819 | 666 | 660
 |  | Success Rate | 0.6764346764346765 | 0.7252252252252253 | 0.7575757575757576
 | [NAME] | Starts | 43 | 41 | 41
 |  | Success Rate | 0.6046511627906976 | 0.8292682926829268 | 0.6829268292682927
 | Caribbean | Starts | 641 | 659 | 808
 |  | Success Rate | 0.6365054602184087 | 0.7268588770864947 | 0.698019801980198
 | Chinese | Starts | 119 | 137 | 69
 |  | Success Rate | 0.8571428571428571 | 0.7591240875912408 | 0.7391304347826086
 | Indian | Starts | 30 | 19 | 32
 |  | Success Rate | 0.7333333333333333 | 0.7894736842105263 | 0.6875
 | Not Known | Starts | 142 | 83 | 74
 |  | Success Rate | 0.7394366197183099 | 0.6506024096385542 | 0.5540540540540541
 | Other | Starts | 243 | 196 | 195
 |  | Success Rate | 0.7078189300411523 | 0.6581632653061225 | 0.6358974358974359
 | Other Asian | Starts | 162 | 191 | 145
 |  | Success Rate | 0.5802469135802469 | 0.7958115183246073 | 0.7931034482758621
 | Other Black | Starts | 203 | 193 | 204
 |  | Success Rate | 0.7586206896551724 | 0.6787564766839378 | 0.6813725490196079
 | Other Mixed | Starts | 36 | 36 | 90
 |  | Success Rate | 0.6111111111111112 | 0.5833333333333334 | 0.6888888888888889
 | Other White | Starts | 272 | 294 | 266
 |  | Success Rate | 0.7132352941176471 | 0.8163265306122449 | 0.7443609022556391
 | Pakistani | Starts | 12 | 33 | 35
 |  | Success Rate | 0.5833333333333334 | 0.6666666666666666 | 0.6571428571428571
 | White British | Starts | 1169 | 1231 | 1905
 |  | Success Rate | 0.6903336184773311 | 0.7514216084484159 | 0.7202099737532809
 | White Irish | Starts | 28 | 24 | 39
 |  | Success Rate | 0.75 | 0.75 | 0.6410256410256411
 | White/ Black African | Starts | 84 | 55 | 74
 |  | Success Rate | 0.6547619047619048 | 0.6363636363636364 | 0.6891891891891891
 | White/Asian | Starts | 45 | 45 | 39
 |  | Success Rate | 0.7777777777777778 | 0.7555555555555555 | 0.7692307692307693
 | White/Black Caribbean | Starts | 193 | 212 | 268
 |  | Success Rate | 0.6217616580310881 | 0.7264150943396226 | 0.6977611940298507
Spreadsheet: 62179d1263168408-using-if-function-in-an-amortization-table-dummyworkbook
Sheet: Amortization

 |  | Loan | 200000
 |  | Term | 5
 |  | Rate | 0.08
 |  | Payment
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Beg. Balance
 | Interest
 | Payment
 | Principal
 | End Balance
 | [NAME]
 | Interest
 | Payment
 | Principal
 | End Bal
 | [NAME]
 | Interest
 | Payment
 | Principal
 | End Bal
 | [NAME]
 | Interest
 | Payment
 | Principal
 | End Bal
Spreadsheet: 154570d1336487498-eric-chart-in-excel-temp_forum
Sheet: Multi-colour ERIC

Multi-colour MAC curve chart with labels and reduction target
generated using a multiple set XY scatter chart
Data
Reduction target | (thousand tonnes) |  | 1 | 1
 |  |  | 0 | 1790.865013774107
Project name |  |  | Project 1 |  | Project 2 |  | Project 3 |  | Project 4 |  | Project 5 |  | Project 6 |  | Project 7 |  | Project 8 |  | Project 9 |  | Project 10
Capital cost | (£) |  | 250 |  | 575 |  | 20000 |  | 25000 |  | 10000 |  | 15000 |  | 161387 |  | 22010 |  | 320000 |  | 135000
Annual benefit/cost | (£) |  | 4910 |  | 6762 |  | 22500 |  | 19770 |  | 5000 |  | 4600 |  | 35533 |  | 2890 |  | 35900 |  | 17520
Annual average CO2 savings for project | (tonnes/year) |  | 27 |  | 37 |  | 123.3 |  | 109.9238688 |  | 420.8 |  | 43 |  | 222 |  | 20 |  | 69 |  | 23
Project life | (years) |  | 3 |  | 3 |  | 10 |  | 25 |  | 3 |  | 10 |  | 15 |  | 15 |  | 20 |  | 25
NPV | (£) |  | -11960.44327573254 |  | -16241.09316303533 |  | -118252.7598783554 |  | -154453.0811603944 |  | -2434.259954921125 |  | -13265.00868624155 |  | -108879.8230976551 |  | 28.43022676882174 |  | 14363.06246066751 |  | -24029.74111937836
Cumulative savings for all projects | (thousand tonnes/year) |  | 0.027 |  | 0.064 |  | 0.1873 |  | 0.2972238688 |  | 0.7180238688 |  | 0.7610238688000001 |  | 0.9830238688 |  | 1.0030238688 |  | 1.0720238688 |  | 1.0950238688
IRR | 0 |  | 1628.059103431006 |  | 1176 |  | 112.5 |  | 79.08 |  | 50 |  | 30.66666666666666 |  | 22.01726285264612 |  | 13.13039527487506 |  | 11.21875 |  | 12.97777777777778
Discounted life savings of carbon | (tonnes) |  | 67.14500375657406 |  | 92.01352366641632 |  | 757.6251241333877 |  | 997.7833560561934 |  | 1046.467317806162 |  | 264.2163855453014 |  | 1688.549650400457 |  | 152.1215901261673 |  | 587.4358966633409 |  | 208.7719204192752
MAC (carbon  discounted) | (£/tonne) |  | -178.1285666330984 |  | -176.5076753490651 |  | -156.083472038522 |  | -154.7962092401308 |  | -2.32616911536651 |  | -50.20509480842622 |  | -64.48126833098047 |  | 0.1868914645530732 |  | 24.45043372774846 |  | -115.1004458411821
XY data points |  | 0 | 0 | 0.027 | 0 | 0.064 | 0 | 0.1873 | 0 | 0.2972238688 | 0 | 0.7180238688 | 0 | 0.7610238688000001 | 0 | 0.9830238688 | 0 | 1.0030238688 | 0 | 1.0720238688 | 0
 |  | 0 | 1628.059103431006 | 0.027 | 1176 | 0.064 | 112.5 | 0.1873 | 79.08 | 0.2972238688 | 50 | 0.7180238688 | 30.66666666666666 | 0.7610238688000001 | 22.01726285264612 | 0.9830238688 | 13.13039527487506 | 1.0030238688 | 11.21875 | 1.0720238688 | 12.97777777777778
 |  | 0.027 | 1628.059103431006 | 0.064 | 1176 | 0.1873 | 112.5 | 0.2972238688 | 79.08 | 0.7180238688 | 50 | 0.7610238688000001 | 30.66666666666666 | 0.9830238688 | 22.01726285264612 | 1.0030238688 | 13.13039527487506 | 1.0720238688 | 11.21875 | 1.0950238688 | 12.97777777777778
 |  | 0.027 | 0 | 0.064 | 0 | 0.1873 | 0 | 0.2972238688 | 0 | 0.7180238688 | 0 | 0.7610238688000001 | 0 | 0.9830238688 | 0 | 1.0030238688 | 0 | 1.0720238688 | 0 | 1.0950238688 | 0
Spreadsheet: 264964d1379024099-looping-through-data-and-finding-cells-that-meet-criteria-test
Sheet: Peter Pan

Supplier # | Supplier | SSR | Discrepancy Type | PO # | PO Date | Stuff | P/n | P/n | Total Order Qty | Received | Total Due | Cost | Balance | Now | Here | When | Ack Qty 1 | Country | Mexico | Canada | Taiwan | Part | Cuba
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32656 | 32656 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32657 | 32657 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32658 | 32658 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32659 | 32659 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32660 | 32660 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32661 | 32661 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32662 | 32662 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32663 | 32663 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32664 | 32664 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32665 | 32665 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32666 | 32666 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32667 | 32667 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32668 | 32668 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32669 | 32669 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32670 | 32670 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32671 | 32671 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Past Due Ack | y | ? |  | 32672 | 32672 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Blank Ack Date | y | ? |  | 32673 | 32673 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Blank Ack Date | y | ? |  | 32674 | 32674 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Blank Ack Date | y | ? |  | 32675 | 32675 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
d | Pampers | [NAME] | Blank Ack Date | y | ? |  | 32676 | 32676 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
Spreadsheet: 869512d1716097271-average-skipping-every-other-column-averege-column-skip-help-aligw
Sheet: Sheet1

 |  |  |  |  | Current
 |  |  |  |  | Case Cost Average | Each Cost Average
Item Name | Product Number | Pack | Size | Unit
Generic Item 1 | 123456 | 6 | 32 | oz
Generic Item 2 | 123457 | 4 | 1 | gal | 20.28 | 5.07
Generic Item 3 | 123458 | 12 | 32 | oz | 33.33 | 2.7775
Generic Item 4 | 123459 | 12 | 32 | oz | 34.43 | 2.869166666666667
Generic Item 5 | 123460 | 6 | 32 | oz | 25.65 | 4.274999999999999
Generic Item 6 | 123461 | 6 | 2 | lbs | 74.71 | 12.45166666666667
Generic Item 7 | 123462 | 48 | 1 | ea
Generic Item 8 | 123463 | 12 | 1 | ea | 19.06 | 1.588333333333333
Generic Item 9 | 123464 | 12 | 1 | ea | 19.06 | 1.588333333333333
Generic Item 10 | 123465 | 12 | 1 | ea
Generic Item 11 | 123466 | 24 | 1 | ea | 13.45 | 0.5604166666666667
Generic Item 12 | 123467 | 1 | 1 | cs | 58.90166666666666 | 58.90166666666666
Generic Item 13 | 123468 | 4 | 12 | pk | 57.2 | 14.3
Generic Item 14 - manually calculated | 123469 | 7 | 1 | ea | 18.3 | 2.614285714285714
Generic Item 15 - manually calculated | 123470 | 1 | 1 | cs | 20.43666666666667 | 20.43666666666667
Spreadsheet: john_lavorato__16551__Turbine Position Report 110201
Sheet: Summary by Region

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Controlling Region
($ MMs)
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | STATUS | DASH APPROVAL DATE / STATUS | PROJECT(S) | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION
EEL
 |  |  |  |  | TOTAL EEL
EA
 |  |  |  |  | TOTAL EA
EGM
PGE
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
 |  |  |  |  | per Summary By [NAME] report
 |  |  |  |  | Difference
Spreadsheet: 774121d1648221104-identify-records-with-specific-condition-makaveeti-aligw
Sheet: Sheet2

ID | Never Logged In? | [NAME]
253071690049
566369030103
566369030103
566369030103
560122395105
560122395105
560122395105
560122395105
558415928107 | Never
579036465109
579036465109
766862153562 | Never
Spreadsheet: 2630fbe9-e150-41a0-b42f-f6bf548a1e64
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
MORP | Test | MORP | [NAME], Unconjugated, Serum | [NAME], Unconjugated, S | Gas Chromatography-Mass Spectrometry Using Selected Ion Monitoring (GC-MS SIM) | Plain, Red-Top Tube: Red |  |  | 5 | mL | Container/Tube: Red top [NAME]: 5 mL | 2.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Therapeutic: 70-450 ng/mL Tolerant patients: <1,500 ng/mL Toxicity: >700 ng/mL | Thursday; 8 a.m. | 2 days | 8 days | 1 | 83925 |  |  |  |  | Rochester
MORP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
MORP | Result | 83132 | [NAME], Unconjugated, S | [NAME], Unconjugated, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3827-3 | Morphine:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 4669bb0a-5442-4867-a260-f815f4dc099b
Sheet: Sheet1

 | only antigen coated wells |  |  | antigen+distiled water |  |  | sample mean | sample mean
A |  |  | 0.159 |  |  | 0.177 | 0.408 | 0.747
B |  |  | 0.061 |  |  | 0.078 | 0.493 | 0.509
C |  |  | 0.123 |  |  | 0.14 | 0.659 | 0.848
D |  |  | 0.094 |  |  | 0.105 | 0.608 | 0.447
E |  |  | 0.069 |  |  | 0.066 | 0.796 | 0.469
F |  |  | 0.086 |  |  | 0.099 | 0.533 | 0.534
G |  |  | 0.117 |  |  | 0.124 | 0.61 | 0.608
H |  |  | 0.123 |  |  | 0.131 | 0.7 | 0.446
Spreadsheet: 81357d1281560982-macro-to-auto-fill-rows-based-on-one-cell-value-excel-fruit-example
Sheet: Main Sheet

Title | Number of items | Unit Price | Total Price
Oranges |  | 0.4 | 0
Lemons | 4 | 0.6 | 2.4
Apples |  | 0.2 | 0
Limes | 5 | 0.6 | 3
Bananas |  | 0.7 | 0
Plums |  | 0.9 | 0
Spreadsheet: dac58964-fb6c-47dd-940d-77f93e3bfe92
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] im ländlichen Raum Südliche Oberlausitz - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 29129 | 29211 | 27597 | 25261
20 - 65 | 117523 | 108777 | 97668 | 87594
65 und mehr | 54707 | 54717 | 57154 | 59323
Insgesamt | 201359 | 192705 | 182419 | 172178
%
unter 20 | 14.46620215634762 | 15.15840273993929 | 15.12835833986591 | 14.67144466772758
20 - 65 | 58.36491043360367 | 56.44741963104226 | 53.5404754987145 | 50.87409541288667
65 und mehr | 27.16888741004872 | 28.39417762901845 | 31.33116616141959 | 34.45445991938575
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 24.78578661198233 | 26.85402244959872 | 28.25592824671336 | 28.8387332465694
Altenquotient | 46.5500370140313 | 50.3019939876996 | 58.51865503542614 | 67.72495833047925
Gesamtquotient | 71.33582362601362 | 77.15601643729832 | 86.77458328213949 | 96.56369157704866
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: kate_symes__18202__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 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
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
 | 2001-02-11 00:00:00 |  |  |  |  |  | 159.15 | 18960
 | 2001-02-10 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-09 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-08 00:00:00 |  | 175.42 | 14400 | 142.48 | 5160
 | 2001-02-07 00:00:00 |  | 170.73 | 11184 | 140.82 | 10680
 | 2001-02-06 00:00:00 |  | 167.38 | 11280 | 146.9 | 6640
 | 2001-02-05 00:00:00 |  | 165.77 | 7120 | 151.67 | 6392
 | 2001-02-04 00:00:00 |  |  |  |  |  | 152.31 | 20376
Spreadsheet: daren_farmer__5741__HPLN0224
Sheet: Sheet1

HPLN0224.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 24-26, 2001
 |  |  |  |  |  | **Sat.-Sun. | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2/24-25/2001 | 2001-02-26 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 696623d1600924301-help-for-if-statement-possibly-with-or-and-and-functions-sample-for-excel-help
Sheet: Sheet1

 | FRUIT | CLIENT | GROSS INCOME | NET INCOME | NOTES
 | APPLES | MR. REYES | 20 | 16 | APPLES ARE MULTIPLIED TO 0.8
 | ORANGES | MR. REYES | 30 | 25 | SUM OF ORDER FOR MR. REYES' ORANGES STILL BELOW 50
 | PEARS | MRS. MELCHOR | 200 | 160 | OVERALL ORDERS OF PEARS IS BELOW 500, SO MULTIPLY TO 0.80
 | ORANGES | MR. REYES | 15 | 15 | SUM OF ORDER FOR MR. REYES' ORANGES STILL BELOW 50
 | ORANGES | MR. REYES | 35 | 32 | SUM OF ORDER FOR MR. REYES IS ABOVE 50, SO 10% OF TOTAL IS SUBTRACTED
 | PEARS | MS. TUAZON | 400 | 330 | UP UNTIL THE FIRST 300, RATE IS x0.80, SO IT WOULD BE 240; FOR THE REMAINING 100, RATE IS ALREADY x0.90, SO IT WOULD BE 90
 | PEARS | MRS. MELCHOR | 50 | 45 | RATE IS ALREADY x0.90
 | APPLES | MR. IGNACIO | 45 | 36 | APPLES ARE MULTIPLIED TO 0.8
 | ORANGES | MR. REYES | 10 | 9 | SUM OF ORDER FOR MR. REYES IS ABOVE 50, SO 10% OF TOTAL IS SUBTRACTED
 | ORANGES | MS. MACALALAY | 40 | 35 | SUM OF ORDER FOR MS. MACALALAY'S ORANGES STILL BELOW 50
Spreadsheet: 79997d1280247188-sorting-fillgaps4sort
Sheet: Sheet1

cust | info |  |  | spare column
martin | 1.1 |  |  | martin | <<<<<<<<<<<<<<< |  | just put first name here
 | 1.2 |  |  | martin | <<<<<<<<<<<<<<< |  | then put =IF(A3="",E2,A3) here and drag down
 | 1.3 |  |  | martin
 | 1.4 |  |  | martin | <<<<<<<<<<<<<<<<now sort the lot by this column
 | 1.5 |  |  | martin
 | 1.6 |  |  | martin
 | 1.7 |  |  | martin
 | 1.8 |  |  | martin
 | 1.9 |  |  | martin
alf | 2.1 |  |  | alf
 | 2.2 |  |  | alf
 | 2.3 |  |  | alf
 | 2.4 |  |  | alf
 | 2.5 |  |  | alf
 | 2.6 |  |  | alf
 | 2.7 |  |  | alf
 | 2.8 |  |  | alf
 | 2.9 |  |  | alf
[NAME] | 3.1 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
 | 3.2 |  |  | [NAME]
Spreadsheet: 754177d1635983344-columns-to-rows-based-on-email-address-column-to-row-eba
Sheet: Sheet1

THIS IS WHAT I HAVE
[NAME] | Upload Module 1 Certificate | Upload Module 2 Certificate | Upload Module 3 Certificate | Upload Module 4 Certificate | Upload Module 5 Certificate | Upload Module 6 Certificate | Upload Module 7 Certificate | Upload Module 8 Certificate | Upload Module 9 Certificate | Upload Module 10 Certificate | Upload Module 11 Certificate | Upload Module 12 Certificate
[EMAIL] | info1
[EMAIL] |  | info2
[EMAIL] |  |  | [NAME]
[EMAIL] |  |  |  | [NAME]
[EMAIL] |  |  |  |  | info5
[EMAIL] |  |  |  |  |  | info6
[EMAIL] |  |  |  |  |  |  | Info7
[EMAIL] |  |  |  |  |  |  |  | info8
[EMAIL] |  |  |  |  |  |  |  |  | info9
[EMAIL] |  |  |  |  |  |  |  |  |  | info10
[EMAIL] |  |  |  |  |  |  |  |  |  |  | info11
[EMAIL] |  |  |  |  |  |  |  |  |  |  |  | info12
[EMAIL] | info1
[EMAIL] |  | info2
[EMAIL] |  |  | [NAME]
[EMAIL] |  |  |  | [NAME]
[EMAIL] | info1
[EMAIL] |  | info2
[EMAIL] |  |  | [NAME]
[EMAIL] |  |  |  |  |  |  |  |  | info9
[EMAIL] |  |  |  |  |  |  |  |  |  | info10
[EMAIL] |  |  |  |  |  |  |  |  |  |  | info11
[EMAIL] |  |  |  |  |  |  |  |  |  |  |  | info12
 | ::::THIS Continues for around 500 email addresses:::::
THIS IS WHAT I NEED
[NAME] | Upload Module 1 Certificate | Upload Module 2 Certificate | Upload Module 3 Certificate | Upload Module 4 Certificate | Upload Module 5 Certificate | Upload Module 6 Certificate | Upload Module 7 Certificate | Upload Module 8 Certificate | Upload Module 9 Certificate | Upload Module 10 Certificate | Upload Module 11 Certificate | Upload Module 12 Certificate
[EMAIL] | info1 | info2 | [NAME] | [NAME] | info5 | info6 | [NAME] | info8 | info9 | info10 | info11 | info12
[EMAIL] | info1 | info2 | [NAME] | [NAME]
[EMAIL] | info1 | info2 | [NAME] |  |  |  |  |  | info9 | info10 | info11 | info12