tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867853d1714640018-formula-to-zero-tables-within-kpi-spreadsheet-new-hs-kpi-updated-max-percentage-100
Sheet: H&S RM West

 |  |  |  |  | Friday to Thursday
 | Safety | Points avaliable | Month score | Total | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Monthly Target | Annual Target | % | Clancy Target | % Against Target
 | Major injury | -50 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lost time injury | -25 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Monthly score | Monthly incentive
 | Non-lost time injury | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Above 25 | 3000
 | Service Strike (HV) | -20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 25 to 0 | 3000
 | Service Strike (LV) | -15 |  |  | 0 | 0 | 0 | 0 | 0 | Less than 3 | Less than 36 |  | <6 |  |  | 0 to minus 25 | 0
 | Service Strike (Gas) | -10 |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | <33 |  |  | Minus 25 to Minus 35 | 0
 | Service Strike (Other) | -5 |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | <33 |  |  | Below minus 35 | 0
 | Manager [NAME] | 0.1 |  |  | 18 | 0 | 0 | 0 | 0 | 18
 | Safety observations | 0.01 |  |  | 100 | 0 | 0 | 0 | 0 | 122
 | H&S advisor visits | 0.2 |  |  | 12 | 0 | 0 | 0 | 0 | 12
 | Manager/Supervisor Safety Visits | 0.01 |  |  | 50 | 0 | 0 | 0 | 0 | 116
 | [NAME] | 0.01 |  |  | 400 | 0 | 0 | 0 | 0 | 317
 | ABC Tours | 0.01 |  |  | 0 | 0 | 0 | 0 | 0 | 2
 | HAVS |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | Total
Spreadsheet: 68181d1268741092-summerize-formula-with-3-ifs-and-3-part-sums-excel-forum-template-100316
Sheet: Total FPC Assy Price (USD)

 | INSTRUCTIONS
 | [NAME]
 |  | Budget rate 2010
 | Exchange Rate, 1JPY= | 0.01108 |  | USD
 | Exchange Rate, 1 RMB= | 0.14647 |  | USD
 | CPL Comp Mark-up % | 0.01
 | Non-CPL Comp Mark-up % | 0.02
 |  |  |  |  |  | Only USD in CPL Sheet |  | Both [NAME], USD, CNY in NoneCPL sheet
 | Project Name | Robyn | Part Number | * Price | Quantity | * FPC-BOM (CPL) | * Component [NAME] (CPL) | * FPC-BOM (Non-CPL) | * Component [NAME] (Non-CPL) | Quarter
 | FPC Name | SIM FPC | 1229-1390 |  |  |  |  |  |  | Q1
 | FPC Part Number | 1229-1390 | 1229-1390 |  |  |  |  |  |  | Q2
 |  |  | 1229-1390 |  |  |  |  |  |  | Q3
 |  |  | 1229-1390 |  |  |  |  |  |  | Q4
Spreadsheet: 0eb63211-50f2-489d-a313-87a753b7f6e6
Sheet: Sheet1

Table 9--U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Feb. | Mar. | Apr. | Apr.
Region/country | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
North America | 126902.299 | 123245.058 | 101248.096 | 140062.292
Bahamas | 79.928 | 139.014 | 281.214 | 108.186
Canada | 9462.866 | 10062.489 | 8996.319 | 8823.263
Costa Rica | 477.886 | 296.291 | 199.209 | 298.794
Dominican Republic | 21284.406 | 19724.505 | 17927.3 | 31008.172
El Salvador | 11749.058 | 11561.98 | 9246.243 | 12882.011
Guatemala | 3522.304 | 2835.287 | 2850 | 3482.32
Haiti | 654.319 | 467.157 | 629.717 | 725.583
Honduras | 50715.732 | 50842.394 | 37073.223 | 54579.99
Jamaica | 122.997 | 119.616 | 91.947 | 106.789
Mexico | 26253.346 | 24381.064 | 21961.391 | 25808.05
Nicaragua | 1978.7 | 2079.125 | 1364.042 | 1556.036
Panama | 364.631 | 332.376 | 335.137 | 322
South America | 2465.382 | 2298.667 | 2417.648 | 2948.994
Brazil | 357.827 | 505.814 | 379.817 | 1073.144
Chile | 245.75 | 170.938 | 451.813 | 233.974
Colombia | 552.333 | 505.679 | 532.394 | 488.135
Peru | 312.878 | 344.709 | 325.808 | 279.983
Venezuela | 680.741 | 398.755 | 526.986 | 649.959
Europe | 2987.911 | 3591.554 | 2756.668 | 4362.863
Belgium | 381.407 | 404.594 | 240.639 | 417.926
France | 128.483 | 135.191 | 122.224 | 116.398
Germany | 538.017 | 527.654 | 444.172 | 599.051
Italy | 137.053 | 236.61 | 116.963 | 235.787
Netherlands | 318.574 | 487.222 | 339.737 | 476.992
Russia | 55.697 | 116.38 | 54.471 | 77.444
Turkey | 40.965 | 23 | 38.075 | 255.887
United Kingdom | 905.171 | 1001.688 | 973.847 | 1614.823
Asia | 8868.766 | 7547.642 | 7910.147 | 8555.38
Bangladesh | 28.289 | 4 | 7 | 255
China | 4486.607 | 3210.334 | 4075.864 | 4391.354
Hong Kong | 620.432 | 908.01 | 573.708 | 362.053
India | 440.35 | 335.896 | 148.595 | 456.083
Israel | 141.598 | 239.226 | 261.95 | 222.524
Japan | 1100.877 | 881.107 | 854.931 | 923.801
Pakistan | 142.581 | 77.759 | 28.32 | 44.624
Saudi Arabia | 135.954 | 124.083 | 124.62 | 145.895
Singapore | 169.248 | 140.174 | 233.022 | 324.848
South Korea | 428.372 | 546.514 | 626.873 | 454.154
Taiwan | 130.948 | 128.551 | 119.811 | 108.164
United Arab Emirates | 425.693 | 396.447 | 284.401 | 287.628
Oceania | 649.879 | 671.481 | 586.049 | 740.276
Australia | 489.734 | 516.052 | 467.765 | 582.336
Africa | 221.843 | 276.1 | 253.156 | 1139.455
South Africa | 89.51 | 67.576 | 59.382 | 56.956
World 2/ | 142096.08 | 137630.502 | 115171.764 | 157810.021
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update: 07/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 50495d1249938996-conditional-concatenation-conditional-20concatenate-1-
Sheet: Sheet1

 | INPUT DATA
 | Person | Date | Activity | Transferred by | Received by
 | Able | 1987-01-01 00:00:00 | Transfer from | Able Co
 |  |  | Transfer to |  | Bain Co
 | Vusal | 2009-08-11 00:00:00 | Transfer from | Baku
 |  |  | Transfer to |  | Moscow
 | Vuqar M | 2003-05-05 00:00:00 | Transfer from | Abu Dhabi
 |  |  | Transfer to |  | Mascat
 | Vuqar M | 2008-05-05 00:00:00 | Transfer from | Abu Dhabi
 |  |  | Transfer to |  | Dubai
 | Able | 1992-01-03 00:00:00 | Transfer from | Able Co
 |  |  | Transfer to |  | [NAME]
 | [NAME] | 1987-01-03 00:00:00 | Transfer from | [NAME]
 |  |  | Transfer to |  | Smith Co
 | [NAME] | 1987-10-03 00:00:00 | Transfer from | [NAME]
 |  |  | Transfer to |  | [NAME]
 | Vusal | 2009-01-11 00:00:00 | Transfer from | Moscow
 |  |  | Transfer to |  | Baku
DESIRED OUTPUT
From | Transfer Date | To
Able | 01 Jan 1987 03 Jan 1992 | Bain Co [NAME]
[NAME] | 03 Jan 1987 03 Oct 1987 | Smith Co Walt Co
Vuqar M | 05 May 2003 05 May 2008 | Mascat Dubai
Vusal | 11 Aug 2009 11 Jan 2009 | Moscow Baku
 | Moscow Baku
Spreadsheet: 876767d1723496537-help-schedule-problem-pulling-task-and-revert-back-to-am-or-pm-weekly_employee_schedule_template
Sheet: Monday

DAILY SCHEDULE
NAMES
CUSTOMER SERVICE |  |  | START | END | REGISTER / POSITION
 |  |  |  |  | FLOORS
 |  |  |  |  | CIGS
 |  |  |  |  | VMC
 |  |  |  |  | CASHIER
 |  |  |  |  | CASHIER
CASHIERS |  |  | START
Spreadsheet: b4b02da2-dfa4-4830-9410-a8ac7836d909
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
1992-02-18 00:00:00
 | Names on Checklist
Sullivan County | Republican | Democratic | Libertarian | Undeclared | Totals
Acworth | 166 | 162 | 2 | 134 | 464
Charlestown | 911 | 973 | 1 | 635 | 2520
Claremont Ward 1 | 616 | 833 | 0 | 462 | 1911
Claremont Ward 2 | 893 | 747 | 0 | 518 | 2158
Claremont Ward 3 | 517 | 914 | 0 | 617 | 2048
Cornish | 399 | 367 | 1 | 151 | 918
Croydon | 131 | 64 | 0 | 120 | 315
Goshen | 142 | 145 | 0 | 56 | 343
Grantham | 567 | 259 | 4 | 183 | 1013
Langdon | 156 | 100 | 0 | 83 | 339
Lempster | 233 | 96 | 0 | 192 | 521
Newport | 1199 | 1116 | 0 | 319 | 2634
Plainfield | 378 | 413 | 4 | 329 | 1124
Springfield | 253 | 122 | 0 | 147 | 522
Sunapee | 781 | 451 | 4 | 252 | 1488
Unity | 155 | 149 | 0 | 248 | 552
Washington | 268 | 115 | 2 | 137 | 522
Totals | 7765 | 7026 | 18 | 4583 | 19392
 | [NAME]
 | Republican |  |  | Democratic |  |  | Libertarian
 | Regular | Absentee | Total | Regular | Absentee | Total | Regular | Absentee | Total
Acworth | 131 | 4 | 135 | 143 | 9 | 152 | 2 | 0 | 2
Charlestown | 580 | 19 | 599 | 680 | 21 | 701 | 1 | 0 | 1
Claremont Ward 1 | 445 | 14 | 459 | 714 | 24 | 738 | 0 | 0 | 0
Claremont Ward 2 | 596 | 63 | 659 | 641 | 33 | 674 | 0 | 0 | 0
Claremont Ward 3 | 418 | 13 | 431 | 798 | 20 | 818 | 2 | 0 | 2
Cornish | 247 | 16 | 263 | 244 | 13 | 257 | 1 | 0 | 1
Croydon | 114 | 4 | 118 | 68 | 3 | 71 | 0 | 0 | 0
Goshen | 107 | 11 | 118 | 105 | 5 | 110 | 0 | 0 | 0
Grantham | 430 | 42 | 472 | 195 | 5 | 200 | 4 | 0 | 4
Langdon | 95 | 5 | 100 | 75 | 4 | 79 | 0 | 0 | 0
Lempster | 193 | 19 | 212 | 112 | 5 | 117 | 0 | 0 | 0
Newport | 781 | 41 | 822 | 765 | 47 | 812 | 9 | 0 | 9
Plainfield | 289 | 9 | 298 | 400 | 13 | 413 | 8 | 0 | 8
Springfield | 153 | 27 | 180 | 111 | 7 | 118 | 4 | 0 | 4
Sunapee | 580 | 42 | 622 | 350 | 25 | 375 | 4 | 0 | 4
Unity | 128 | 7 | 135 | 164 | 8 | 172 | 3 | 0 | 3
Washington | 171 | 15 | 186 | 89 | 8 | 97 | 5 | 0 | 5
Totals | 5458 | 351 | 5809 | 5654 | 250 | 5904 | 43 | 0 | 43
Spreadsheet: 54020d1253984232-transfer-data-for-specific-dates-master-1-
Sheet: stats

2009-11-25 00:00:00
day | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  |  | PNC Weekly Target | 2100
 | PNC | LPF | ID's | PNC | LPF | ID's | PNC | LPF | ID's | PNC | LPF | ID's | PNC | LPF | ID's |  | Conflict Weekly Target | 500
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID Weekly Target | 500
[NAME]
ian o |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PNC Completed | #N/A
ian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | #N/A
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID's Completed | #N/A
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PNC Revised Target | #N/A
cheryl |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conflict Revised Target | #N/A
total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Id's Revised Target | #N/A
Spreadsheet: fc0604b2-fce9-4118-933f-7ac5a2ce895b
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
FLASC | Test | FLASC | [NAME] and CSF Analysis | Lyme Ab Analysis Serum and CSF | Antibody Capture Enzyme Immunoassay | Plastic screw-cap vial: PlScr |  |  |  |  | [NAME] and CSF   Serum Draw blood in a red-top tube(s). Spin down and submit 2 mL refrigerate serum.   CSF Collect 1 mL CSF in a sterile plastic vial and submit refrigerate. | Serum: 0.2 mL; CSF: 0.5 mL | Specimens other than	Serum and CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.   Test Performed by: 	IMUGEN Reference Diagnostic Division 		           315 Norwood Park South 		           Norwood, MA 02062 | Monday through Friday | 1 - 2 days | 3 - 8 days |  | Profile |  |  |  |  | IMUGEN Reference Diatnostics Division
FLASC | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 5 days
FLASC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 5 days
FLASC | Billing Component | FLASC |  | IMMUNOASSAY INFECTIOUS AGENT |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 86317
FLASC | Billing Component | FLASC |  | IMMUNOASSAY INFECTIOUS AGENT |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 86317
FLASC | Component | FLAS | Lyme Antibody Analysis, Serum | Lyme Antibody Analysis, Serum | Not orderable by itself. See FLASC |  |  |  |  |  | Not orderable by itself. See FLASC |  |  | See FLASC |  |  |  | 5 | 86317 |  |  | Yes | No
FLAS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 5 days
FLAS | Result | Z2602 | Lyme Antibody Analysis, Serum | Lyme Antibody Analysis, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FLASC | Component | FLAC | Lyme Antibody Analysis, CSF | Lyme Antibody Analysis, CSF |  |  |  |  |  |  | Not orderable by itself. See FLASC |  |  | See FLASC |  |  |  | 3 | 86317 |  |  | Yes | No
FLAC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 5 days
FLAC | Result | Z2603 | Lyme Antibody Analysis, CSF | Lyme Antibody Analysis, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: dd5ec9cc-6b1f-4625-b69b-5d9b4f010c00
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2013/14 |  |  | 2012/13 |  |  | 2011/12
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 12.08 | 12.43 |  | 11.91 | 12.13 |  | 14.08 | 14.4
September | 11.87 | 12.22 |  | 12.57 | 12.81 |  | 15.09 | 15.44
October | 11.95 | 12.3 |  | 12.72 | 12.97 |  | 15.63 | 15.99
November | 11.78 | 12.13 |  | 12.92 | 13.17 |  | 14.93 | 15.28
December | 11.93 | 12.29 |  | 12.62 | 12.86 |  | 13.9 | 14.21
January | 11.74 | 12.09 |  | 12.35 | 12.59 |  | 12.61 | 12.88
February | 11.77 | 12.03 |  | 11.77 | 12.43 |  | 11.81 | 12.2
March 2/ | 11.74 | 12 |  | 12.16 | 12.84 |  | 11.52 | 11.92
April |  |  |  | 12.18 | 12.86 |  | 11.15 | 11.54
May |  |  |  | 12.08 | 12.75 |  | 11.42 | 11.82
June |  |  |  | 12.17 | 12.85 |  | 11.93 | 12.35
July |  |  |  | 12.18 | 12.86 |  | 11.97 | 12.4
Market-year
average 1/ | 11.8575 | 12.18625 |  | 12.3025 | 12.76 |  | 13.00333333333334 | 13.36916666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated March 10, 2014.
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -13559 | -14000
2 | -13675 | -14000
3 | -13732 | -14000
4 | -13318 | -14000
5 | -14017 | -14000
6 | -13620 | -14000
7 | -13282 | -14000
8 | -13676 | -14000
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -15514.53
2002-01-08 00:00:00
CBS Volume
 |  |  | 5596
Spreadsheet: 763838d1642425124-need-alternative-non-volatile-formula-insted-of-given-one-non-volatile-help
Sheet: SeatPlan

 | Room No |  | 1
 | 5 |  | 4 |  | 7 |  | 2 |  | 6 |  | 5 |  | 8 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name of Source Sheet | source |  |  |  |  |  |  | =IFERROR(INDEX($R$6:$R$15,MATCH(0,INDEX(COUNTIF($U$5:U5,$R$6:$R$15),0,0),0))," ")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Cell | A2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference
Spreadsheet: eric_saibi__9869__101901R
Sheet: Rocky Mountain 03

Owner Name |  | Oglethorpe Power Company
Station Name |  | Rocky Mountain Pumped Storage
Unit Name |  | Hydro 03
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Hydro
Capacity |  | 282 MW
Start Date |  | 2001-11-03 00:00:00
End Date |  | 2001-11-23 00:00:00
Prv. Start Date |  | 2001-10-19 00:00:00
Prv. End Date |  | 2001-11-08 00:00:00
Comments |  | Maintenance
SIC |  | 4911
Plant ID |  | 1011981
Unit ID |  | 1012957
Outage ID |  | 18210
Spreadsheet: 804118d1667904051-get-value-of-1st-column-based-on-multiple-criteria-from-all-other-columns-in-excel-08112022-sample-for-excel-forum
Sheet: Sheet1

Data Table
 |  |  |  |  |  |  |  |  | I want this RESULT
Interest | SCheme1 | SCheme2 | SCheme3 | SCheme4 | SCheme5 | SCheme6 |  | Scheme Name | Interest
0.13 | [NAME] | NEW 20-05-17 SALARY DEDUCTION |  |  |  |  |  | JUNE 2021 GENERAL BORROWER | 0.11
0.145 | CLEAN   SCHEME | CLEAN  ABN SCHEME | NEW 20-05-17 CLEAN   SCHEME | NEW PERSONAL  SCHEME | DEC 2021 PERSONAL  SCHEME |  |  | GHARKUL YOJANA  ABN SCHEME | 0.0925
0.11 | DEC 2021 VEHICLE COMERCIAL USE | NEW 20-05-17 VEHICLE | DEC 2021 VEHICLE PERSONAL USE | VEHICLE | JUNE 2021 GENERAL BORROWER |  |  | CLEAN   SCHEME | 0.145
0.12 | DEC 2021 COMERCIAL USE
0.0925 | GHARKUL YOJANA  SCHEME | DEC 2021 HOUSING | GHARKUL YOJANA  ABN SCHEME
0.1 | [NAME]. | NEW 20-05-17 CUSTOMER HSG.
0.1 | SCHEME | NEW 20-05-17   SCHEME | ABN SCHEME | DEC 2021  AGAINST PROP
0.11 | AGAINST PROPERTY | NEW 20-05-17 MORTGAG  PRO | DEC 2021  AGN PRO | AGAINST PROPERTY  ABN SCHEME | JUNE 2021  AGAINEST PRO
0.115 | COMMERCIAL    SCHEME | NEW 20-05-17 COMMERCIAL    SCHEME | NEW RETAIL COMMERCIAL
0.115 | BUSINESS | NEW 20-05-17 BUSINESS | JUNE 2021 BUSINESS | BUSINESS  ABN SCHEME | NEW RETAIL BUSINESS | DEC 2021 BUSINESS
0.115 | JUNE 2021 MACHINERY | MACHINERY | NEW 20-05-17 MACHINERY
0.115 | NEW 20-05-17 BUSINESS  AGAINS RENT REC SCHEME | BUSINESS  AGAINS RENT RECEIVABL SCHEME | JUNE 2021 BUS  AGAINST RENT
0.105 | NEW 20-05-17 BUSINESS  AGAINST RENTREC SCHEME | BUSINESS  AGAINST RENTRECEIVA SCHEME
0.115 | CASH CREDIT SCHEME | DEC 2021 CASH CREDIT
0.115 | OVERDRAFT AGAINST   SCHEME
0.12 | OVER DRAFT  SCHEME | DECEMBER 2021 OVERDRAFT | JUNE 2021 OVERDRAFT SCHEME
0.095 | EMI REPAYMENT | JUNE 2022  BULLET REPAYME | JUNE 2022  EMI  REPYMENT | NEW 20-05-17  EMI SCHEME | NON EMI SCHEME
0.09 | NEW 20-05-17   NON EMI SCHEME | BULLET REPAYMENT
0.09 | NS SCHEME | NEW 20-05-17 NS SCHEME
0.095 | LI SCHEME | NEW 20-05-17 LI SCHEME
0.12 | NEW 20-05-17 EDUCATION   SCHEME | EDUCATION   SCHEME
Spreadsheet: 118548d1313754752-advanced-filter-exf_advancedfilter
Sheet: Sheet1

 |  |  |  |  | Criteria 1 |  | [NAME]
 |  |  |  |  | Order |  | Order
 |  |  |  |  |  |  | >0
 | Name | Number | Order |  | Name |  | Name
 | Name1 | 10001 | 4 |  |  |  | Name1
 | [NAME] | 10002 |  |  |  |  | Name8
 | Name3 | 10003 |  |  |  |  | Name9
 | Name4 | 10004 |  |  |  |  | Name10
 | Name5 | 10005 |  |  |  |  | Name11
 | Name6 | 10006 |  |  |  |  | Name13
 | Name7 | 10007 |  |  |  |  | Name14
 | Name8 | 10008 | 5 |  |  |  | Name15
 | Name9 | 10009 | 5 |  |  |  | [NAME]
 | Name10 | 10010 | 5
 | Name11 | 10011 | 5
 | Name12 | 10012
 | Name13 | 10013 | 9
 | Name14 | 10014 | 3
 | Name15 | 10015 | 10
 | [NAME] | 10016 | 1
Spreadsheet: 77479d1277933595-copying-cell-background-with-formula-columncolorshift
Sheet: Sheet1

COLUMN TO BE UPDATED | COLUMN TO BE UPDATED | % of Total (ORIGINAL COLUMN) |  | USER INPUT (PLEASE ENTER GROUP SIZES BY PERCENT):
 |  | 14 |  | GROUP 1 | 15 | THIS IS THE TOP 10% OF SALES
 |  | 12.5 |  | GROUP 2 | 30 | THIS IS THE NEXT 20% OF SALES
 |  | 10 |  | GROUP 3 | 30 | THIS IS THE NEXT 30% OF SALES
 |  | 7.71 |  | GROUP 4 | 15 | THIS IS THE NEXT 15% OF SALES
 |  | 6 |  | GROUP 5 | 25 | THIS IS THE BOTTOM 25% OF SALES
 |  | 6
 |  | 5
 |  | 5
 |  | 3
 |  | 3
 |  | 2
 |  | 1.29142857142858
 |  | 1.26571428571429
 |  | 1.24000000000001
 |  | 1.21428571428572
 |  | 1.18857142857143
 |  | 1.16285714285714
 |  | 1.13714285714286
 |  | 1.11142857142857
 |  | 1.08571428571429
 |  | 1.06
 |  | 1.03428571428571
 |  | 1.00857142857143
 |  | 0.982857142857144
 |  | 0.931428571428573
 |  | 0.751428571428572
 |  | 0.725714285714286
 |  | 0.7
 |  | 0.674285714285715
 |  | 0.648571428571429
 |  | 0.622857142857143
 |  | 0.597142857142857
 |  | 0.571428571428572
 |  | 0.545714285714286
 |  | 0.52
 |  | 0.494285714285715
 |  | 0.468571428571429
 |  | 0.46
 |  | 0.442857142857143
 |  | 0.417142857142857
 |  | 0.4
 |  | 0.391428571428572
 |  | 0.34
 |  | 0.3
Spreadsheet: 147376d1332774657-normalization-of-data-temp
Sheet: Sheet1

Initial Data |  |  |  |  |  |  |  | Result
Store | date | Product 1 | Priduct 2 | Product 3 |  |  |  | Store | date | Product 1 | Priduct 2 | Product 3
a | 2001-01-01 00:00:00 | 0 | 0 | 0 |  |  |  | a | Month 1 | 1 | 2 | 3
a | 2001-02-01 00:00:00 | 0 | 0 | 0 |  |  |  | a | Month 2 | 5 | 0 | 4
a | 2001-03-01 00:00:00 | 1 | 2 | 3 |  |  |  | a | Month 3 | 7 | 8 | 9
a | 2001-04-01 00:00:00 | 5 | 0 | 4 |  |  |  | a | Month 4 | 0 | 0 | 0
a | 2001-05-01 00:00:00 | 7 | 8 | 9 |  |  |  | a | Month 5 | 0 | 0 | 0
a | 2001-06-01 00:00:00 | 0 | 0 | 0 |  |  |  | a | Month 6 | 7 | 8 | 9
a | 2001-07-01 00:00:00 | 0 | 0 | 0 |  |  |  | a | Month 7 | 7 | 0 | 9
a | 2001-08-01 00:00:00 | 7 | 8 | 9 |  |  |  | a | Month 8 | 7 | 8 | 8
a | 2001-09-01 00:00:00 | 7 | 0 | 9
a | 2001-10-01 00:00:00 | 7 | 8 | 8
a | 2001-11-01 00:00:00 | 0 | 0 | 0
a | 2001-12-01 00:00:00 | 0 | 0 | 0
Spreadsheet: 813736d1673964294-match-and-extract-data-from-two-possible-sources-and-enter-in-to-cell-match-data-from-different-sources
Sheet: External Users

Employee Number | Full Name | First Name | Surname | Job Title | Work Email Address
EXUK7686 |  | User | 5 | [NAME] | [EMAIL]
EXUK7658 |  | User | 8 | [NAME] | [EMAIL]
EXIE701F |  | User | 10 | Services Administrator | [EMAIL]
EXUK7658 |  | User | 14 | Security Guard | [EMAIL]
EXUK7686 |  | User | 15 | Services Administrator | [EMAIL]
EXUK7527 |  | User | 16 | Operations Administrator | [EMAIL]
EXUK767C |  | User | 17 | [NAME] | [EMAIL]
EXUK74CA |  | User | 18 | [NAME] | [EMAIL]
EXUK7690 |  | User | 19 | [NAME] | [EMAIL]
EXUK765E |  | User | 20 | [NAME] | [EMAIL]
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: NewCo_Summary Output

 | Unhide Sub Debt, 1999 Columns
 | NewCo SUMMARY OUTPUT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOL Carryforward - Yes
 | VALUATION SUMMARY |  |  |  |  |  |  |  |  |  |  |  |  |  | NOL Carryforward - No
 |  |  |  |  |  |  |  | PV of Interest | Power Contract |  |  |  |  |  | 1
 | ('000 $) | Equity Ownership | Equity | Bond Proceeds | Enterprise Value | [NAME] | Unlevered IRR | Tax Shield | Liability
 | ENA GenCo |  |  |  |  |  | 0.1136320769786835
 | FPLE GenCo |  |  |  |  |  | 8.5% ~ 11.0% |  | 0
 | NewCo
 | * ENA GenCo and FPLE GenCo valuations do not include the allocation of corporate G&A.
 | Debt FINANCING ASSUMPTIONS:
 | ENA GenCo |  |  |  |  |  |  | FPLE GenCo
 |  | Tranche 1 | Tranche 2 | Tranche 3 | Total |  |  |  |  | Merchant | Contract | Total | Notes Receivable
 | Debt Closing Date |  |  |  |  |  |  | Debt Closing Date |  | 2001-01-01 00:00:00
 | Amount ('000 $) |  |  |  |  |  |  | Amount ('000 $)
 | Term (yrs) |  |  |  |  |  |  | Term (yrs) |  | 20 | 20
 | Final Maturity |  |  |  |  |  |  | Final Maturity |  | 2020-12-31 00:00:00 | 2020-12-31 00:00:00
 | Average Life |  |  |  |  |  |  | Average Life
 | Treasury Rate (%) |  |  |  |  |  |  | Treasury Rate (%) |  |  |  |  |  |  | Weighted Average
 | Spread (%) |  |  |  |  |  |  | Spread (%) |  |  |  |  |  |  | Cost of Debt
 | All-in Coupon Rate (%) |  |  |  |  |  |  | All-in Coupon Rate (%)
 | SUMMARY OUTPUT:
 | ENA: DSCR |  |  | Min | [NAME]. |  |  | FPLE: DSCR |  |  | Min | [NAME].
 | Fixed Price Period |  |  |  |  |  |  | Merchant Projects
 | Merchant Price Period |  |  |  |  |  |  | Contracted Projects
 | ENA: Salvage Value (2 x EBITDA) at the end of 20 years ($/kW) |  |  |  |  |  |  | FPLE: Salvage Value (2.5~5 x EBITDA) at the end of 13~20 years ($/kW)
 |  | 2001 | 2002 | 2003 | 2004 | 2005
 | ENA: GenCo EBITDA (000 $)
 | ENA: GenCo Net Income (000 $)
 | ENA: [NAME] (000 $)
 | ENA: GenCo After-Tax Cashflow (000 $)
 | FPLE: GenCo EBITDA (000 $)
 | FPLE: GenCo Net Income (000 $)
 | FPLE: [NAME] (000 $)
 | FPLE: GenCo After-Tax Cashflow (000 $)
 | NewCo: Existing Assets |  |  |  |  |  | NewCo with Development Pipeline |  | 2001 | 2002 | 2003 | 2004 | 2005
 | NewCo: EBITDA (000 $) |  |  |  |  |  | NewCo: EBITDA (000 $)
 | NewCo: Net Income (000 $) |  |  |  |  |  | NewCo: Net Income (000 $)
 | NewCo: Pre-Tax Cashflow (000 $) |  |  |  |  |  | NewCo: Net Income (CAGR)
 | NewCo: After-Tax Cashflow (000 $) |  |  |  |  |  | NewCo: After-Tax Cashflow (000 $)
 | NewCo: Total ISO MW
 | Corporate [NAME]
 | Cost Category |  |  | Notes
 | Development |  | 12000 | Expensed portion.
 | HR & Legal |  | 2000
 | Asset Management |  | 7000
 | Finance, Accounting, Tax |  | 5000
 | MIS |  | 2000
 | Executive |  | 1000
 | Corporate / Admin |  | 9000 | Rent, incentive compensation, depreciation, taxes/fees, phone, supplies, etc.
 | Total G&A
 | After-tax
 | Excludes trading and marketing.
 | Excludes cost of shared services; parts pooling and fleet team support.  Costs are included in the project models.
 | Operations and construction management are allocated to the projects.