tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 809413d1671074901-converting-table-of-data-into-a-list-s666-pq-converting-table-of-data-into-a-list
Sheet: Sheet1

 |  |  | Dept |  |  |  |  |  |  |  |  | output |  |  |  | final
 |  | Column1 | 100 | 200 | 300 |  | Dept | Expense
 | Expense | 70350 | 157 | 927 | 37 |  | 100-70350 | 157 |  |  | 100 | 70350 | 157
 |  | 70360 | 352 | 65 | 469 |  | 100-70360 | 352 |  |  | 100 | 70360 | 352
 |  | 70390 | 923 | 812 | 225 |  | 100-70390 | 923 |  |  | 100 | 70390 | 923
 |  |  |  |  |  |  | 200-70350 | 927 |  |  | 200 | 70350 | 927
 |  |  |  |  |  |  | 200-70360 | 65 |  |  | 200 | 70360 | 65
 |  |  |  |  |  |  | 200-70390 | 812 |  |  | 200 | 70390 | 812
 |  |  |  |  |  |  | 300-70350 | 37 |  |  | 300 | 70350 | 37
 |  |  |  |  |  |  | 300-70360 | 469 |  |  | 300 | 70360 | 469
 |  |  |  |  |  |  | 300-70390 | 225 |  |  | 300 | 70390 | 225
Spreadsheet: 43430d1242099214-formula-to-copy-cell-data-from-another-worksheet-for-a-particular-condition-sample-data
Sheet: 3_1 to 3_20

 | Class | Item # | Color | Area | Sale Date | Date Range
 | A |  |  |  |  | 3/1-3/20
 | A |  |  |  |  | 3/1-3/20
 | B |  |  |  |  | 3/1-3/20
 | B |  |  |  |  | 3/1-3/20
 | C |  |  |  |  | 3/1-3/20
 | C |  |  |  |  | 3/1-3/20
 | Total | 6 |  |  |  | 3/1-3/20
 | Extra |  |  |  |  | 3/1-3/20
 | A |  |  |  |  | 3/1-3/20
 | A |  |  |  |  | 3/1-3/20
 | B |  |  |  |  | 3/1-3/20
 | B |  |  |  |  | 3/1-3/20
 | C |  |  |  |  | 3/1-3/20
 | C |  |  |  |  | 3/1-3/20
Spreadsheet: b30d4e46-12bd-4609-858d-1e39fa2429fb
Sheet: Income Statement YTD

UNIVERSAL AMERICAN CORP. AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF OPERATIONS
 |  | Twelve months ended December 31, |  |  |  | Change
 |  | 2011 |  | 2010(1) |  | $ | %
Revenues: |  | (In thousands, per share amounts in dollars)
Net premium and policyholder fees earned |  | 2219813 |  | 3445749
Net investment income |  | 47425 |  | 39886
Fee and other income |  | 14637 |  | 9575
Realized gain (loss):
Total other-than-temorary impairment losses on securities |  | -373 |  | -1915
Portion of loss recognized in other comprehensive income |  | 76 |  | 1100
Net other-than-temporary impairment losses on securities recognized in earnings
Realized gain, excluding other-than-temporary impairment losses on securities
Net realized gain on investments |  | 841 |  | 6575
Total revenues |  | 2282716
Benefits, claims and expenses:
Claims and other benefits |  | 1812815 |  | 2860641
Change in deferred acquisition costs |  | 3237 |  | 5648
Amortization of present value of future profits |  | 4411 |  | 7258
Commissions |  | 59888 |  | 121354
Reinsurance commissions and expense allowances |  | 3329 |  | -17897
Interest expense |  | 2267 |  | 0
Restructuring costs |  | 22042 |  | 0
Intangible asset impairment |  | 15622 |  | 0
Other operating costs and expenses |  | 355025 |  | 405568
Total benefits, claims and expenses
Income from continuing operations before income taxes
Provision for income taxes |  | 3820.573913834658 |  | 38182
Income from continuing operations
Discontinued Operations:
Loss from discontinued operations, net of income taxes |  | -32605 |  | 109270
Expenses of transactions, net of income taxes |  | -10670 |  | -2622.154275
Loss from discontinued operations
Net (loss) income
(Loss) earnings per common share:
Basic:
Continuing Operations |  | 0.01 |  | 1.04
Discontinued Operations |  | -0.53 |  | 1.36
Net (loss) income
Diluted:
Continuing Operations |  | 0.01 |  | 1.03
Discontinued Operations |  | -0.54 |  | 1.35
Net (loss) income
Weighted average shares outstanding:
Weighted average common shares outstanding |  | 79667.5388191781 |  | 78748
Less weighted average treasury shares |  | -1038.839002739726 |  | -4871
Basic weighted shares outstanding |  | 78628.69981643837 |  | 73877
Weighted average common equivalent of preferred shares outstanding |  | 1372.738356164384 |  | 4211
Effect of dilutive securities |  | 577.3739688344514 |  | 612
Diluted weighted shares outstanding |  | 80578.8121414372 |  | 78700
Effective tax rate |  | 0.9363689167909472 |  | 0.2620604334280144
(1)  Restated to reflect discontinued operations
Spreadsheet: 855377d1704968312-if-with-averageifs-returning-value-sample-data
Sheet: Sheet1

Month | Project Name | Cash Out Periodic | Forecast Cash Out 3 months rolling | Forecast Cash Out - 3 months rolling YTD
January | Ninja | 4990
February | Ninja | 576
March | Ninja | 0
April | Ninja | 18445
May | Ninja | 20783
June | Ninja | 53402
July | Ninja | 3127
August | Ninja | 8919
September | Ninja | 53512
October | Ninja | 78109
November | Ninja | 70641
December | Ninja | 0
Spreadsheet: 078824a8-08a3-4b3e-92b3-2416623d3509
Sheet: Table V.6

Table V.6 الجدول
Energy Efficiency (kg oil equivalent) per US$1,000 GDP (Constant 2005 PPP)1, a/
كفاءة استعمال الطاقة لكل ألف دولار من الناتج [NAME] (كغم مكافئ نفط)
(مماثل القوة الشرائية ثابت لعام 2005)
 | 2004 | 2005 | 2006 | 2007 | Average annual change
 |  |  |  |  | (per cent) 2004-2007
Bahrain | 3691, a/ | 3691, a/ | 3821, a/ | 3731, a/ | 0.4 | البحرين
Egypt | 1751, a/ | 1831, a/ | 1791, a/ | 1761, a/ | 0.2 | مصر
Iraq | ... | ... | ... | ... | … | العراق
Jordan | 2851, a/ | 2831, a/ | 2691, a/ | 2601, a/ | -3 | الأردن
Kuwait | 2491, a/ | 2491, a/ | 2131, a/ | 2081, a/ | -5.6 | الكويت
Lebanon | 1371, a/ | 1401, a/ | 1191, a/ | 951, a/ | -11 | لبنان
Oman | 2271, a/ | 2511, a/ | 2741, a/ | 2651, a/ | 5.5 | عمان
Palestineb/ | 199 | 185 | 185 | 188 | -5.5 | فلسطين
Qatar | 3121, a/ | 2911, a/ | 2911, a/ | 2911, a/ | -2.2 | قطر
Saudi Arabia | 2801, a/ | 2831, a/ | 2871, a/ | 2881, a/ | 0.9 | السعودية
The Sudan | 2671, a/ | 2491, a/ | 2191, a/ | 1931, a/ | -10.2 | السودان
The Syrian Arab Republic | 2471, a/ | 2311, a/ | 2341, a/ | 2371, a/ | -1.3 | الجمهورية العربية السورية
The United Arab Emirates | 2281, a/ | 2151, a/ | 2071, a/ | 2221, a/ | -0.7 | الإمارات العربية المتحدة
Yemen | 1411, a/ | 1421, a/ | 1441, a/ | 1471, a/ | 1.4 | اليمن
ESCWA Averagec/ | 240 | 236 | 231 | 226 | -1.9 | [NAME]
GCC Averaged/ | 278 | 276 | 276 | 275 | -0.4 | [NAME] التعاون الخليجي
Sources: | a/ | MDG Database 2010.
 | [NAME] | PCBS reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
 | c/ | ESCWA calculation, excluding Iraq.
 | d/ | ESCWA calculation.
Note: | 1 | Energy Intensity is the indicator of target 7A of Goal 7 of the Millennium Development Goals on Ensuring Environmental Sustainability.
Spreadsheet: 714764d1611350715-vlookup-with-duplicates-search-and-avoid-duplicates
Sheet: Contractors

Company | Origin | Type | Size | Prior | Multiple | Score | Year | Count | Timing | Price | Exp | Name | Site | License | Reference
Plumbers | Online | Rapid | Mid | Yes | No | 12 | 2020 | 2 | Fast | high | Avg | [NAME] | TX | A123 | Q1
Electricians | In-Person | Long Term | Small | No | No | 44 | 2019 | 1 | Fast | Low | high | [NAME] | FL | B345 | Q2
Company A | Phone | Emergency | Large | Yes | No | 68 | 2021 | 1 | Slow | Avg | Low | [NAME] One | AL | C432 | Q4
Test Company | Online | Trial | Tiny | Yes | No | 55 | 2020 | 1 | Average | high | Avg | Alfonse | WA | N/A | Q1
Random | In-Person | Rapid | Mid | No | No | 66 | 2020 | 1 | Fast | Low | high | [NAME] | TX | b1v2c3 | Q3
Testing | Phone | Long Term | Mid | No | No | 76 | 2020 | 1 | Fast | Avg | Low | Susy | FL | A124 | Q4
Working | Online | Emergency | Small | No | No | 32 | 2019 | 5 | Slow | high | Avg | [NAME] | AL | B346 | Q1
Plumbers | In-Person | Trial | Large | Yes | Yes | 11 | 2021 | 2 | Average | Low | high | [NAME] | WA | C433 | Q3
Electricians | Phone | Rapid | Tiny | No | No | 67 | 2020 | 1 | Fast | Avg | Low | [NAME] | TX | N/A | Q4
Company A | Online | Long Term | Mid | Yes | Yes | 89 | 2020 | 2 | Fast | high | Avg | Will | FL | b1v2c4 | Q1
Test Company | In-Person | Emergency | Mid | Yes | No | 9 | 2020 | 1 | Slow | Low | high | [NAME] | AL | A125 | Q2
Random | Phone | Trial | Small | No | No | 87 | 2019 | 1 | Average | Avg | Low | Whitney | MO | B347 | Q4
Testing | Online | Rapid | Large | No | No | 65 | 2021 | 1 | Fast | high | Avg | Quesi | TX | C434 | Q3
Plumbers | In-Person | Long Term | Tiny | No | No | 45 | 2020 | 1 | Fast | Low | high | Pablo | FL | N/A | Q2
Electricians | Phone | Emergency | Mid | Yes | Yes | 67 | 2020 | 1 | Slow | Avg | Low | [NAME] | AL | b1v2c5 | Q4
Company A | Online | Trial | Mid | No | No | 89 | 2020 | 5 | Average | high | Avg | Rachel | WA | A126 | Q1
Plumbers | In-Person | Rapid | Small | Yes | No | 23 | 2019 | 2 | Fast | Low | high | Rochelle | TX | B348 | Q2
Electricians | Phone | Long Term | Large | Yes | No | 64 | 2021 | 1 | Fast | Avg | Low | Randall | FL | C435 | Q4
Company A | Online | Emergency | Tiny | No | No | 96 | 2020 | 2 | Slow | high | Avg | [NAME] | AL | N/A | Q1
Test Company | In-Person | Trial | Mid | No | No | 18 | 2020 | 1 | Average | Low | high | Wise | WA | b1v2c6 | Q2
Random | Phone | Rapid | Mid | No | No | 59 | 2020 | 1 | Fast | Avg | Low | Red Five | TX | A127 | Q4
Testing | Online | Long Term | Small | Yes | No | 75 | 2019 | 1 | Fast | high | Avg | [NAME] | FL | B349 | Q1
Working | In-Person | Emergency | Large | No | No | 47 | 2021 | 1 | Slow | Low | high | Edgar | AL | C436 | Q2
Company A | Phone | Trial | Tiny | Yes | No | 33 | 2020 | 1 | Average | Avg | Low | Ellen | WA | N/A | Q4
Spreadsheet: f9c9fb9a-9072-4669-8ad1-c25436479010
Sheet: Sheet1

Unnamed: 0 | HOCKEY OPEN REPRESENTATIVE TEAM NOMINATIONS 2012 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Must be 19 or Under as at 31/12/2012  (i.e. 1993)
 | School : |  |  |  |  |  |  |  |  | DUE: | 26th April 2012
 |  |  |  |  | Please complete this form and send via email. |  |  | [NAME] : | [NAME]
 | Please check that all the information below is correct.
 | Players MUST be aware of the AHIGS Representative Policy and  available for all rep commitments
 | IGSSA TRIALS: 2nd May 2012 at Homebush at 9.30am
 | FIRST NAME | SURNAME | SCHOOL | DOB | SCHOOL YR | POSITION 1 | POSITION 2 | Please indicate whether the student competed at the levels indicated below in the last 12 months
 | Top two nominations |  |  |  |  |  |  | IGSSA 1A | Club A Grade | NSW CIS | State | National | Other - Provide BRIEF details ie State League / Out due to Injury
 | Example | Example | ABC | 2001-01-01 00:00:00 | 11 | Right Wing | Left Wing | 2010 - 2011 | 2011 | 2011 | No | No | Selected in NSW Development Squad 2011
1
2
3
4
5
6
7
8
9
 | Request Consideration of these
1
2
Spreadsheet: 713026d1610533112-make-list-from-match-in-table-menu-items-and-inventory
Sheet: CK Inventory

Caesar Dressing | Cheese Sauce | Chili Sauce | Choron Mayo | [NAME] | [NAME] Dressing | [NAME] | Lemon Sour Cream | [NAME] | Mayonnaise | [NAME] | [NAME] | Chocolate Sauce | Caramel Sauce | Falafel Balls | Sliced Ham | Roast Beef | Vegan Pumpkin Hummus | MX Spice (Mixed) | SW Spice (Shawarma) | Pickled Beetroot | Pickled Cucumber | Whole Pickled Jalapeño | Sun Dried Tomato | Roasted Nuts | Peanuts | Emmentaler Cheese | Mozzarella Cheese | Cheddar Cheese | Yoghurt | [NAME] | Muffin [NAME] | Pancakes | [NAME]
Spreadsheet: 770677d1646223172-add-values-in-range-of-cells-if-values-in-other-cells-match-staff-bonuses-2019-working-v2-help-file
Sheet: Stylist Ranking

Stylist Monthly Stats |  |  | Month:
Name | Salon | New Returns | Repeat Returns | Product Sales | Productivity | Cut Times
[NAME] | 4940
[NAME] | 4940
[NAME] | 4940
[NAME] | 4940
Priscilla Amons | 4940
Helena Adair | 4940
[NAME] | 4940
Ashley Banks | 4940
[NAME] | 4940
[NAME] | 4940
[NAME] | 4943
Christina Diaz | 4943
Destiny [NAME] | 4943
[NAME] | 4943
[NAME] | 4943
[NAME] | 4943
[NAME] Villarreal | 4943
Seheyla Rodriguez | 4968
[NAME] | 4968
[NAME] | 4968
[NAME] | 4968
Kimberly Baiely | 4968
[NAME] | 4968
[NAME] | 4968
[NAME] | 4968
[NAME] | 4968
[NAME] | 4970
[NAME] | 4970
Jade Hearn | 4970
Amanda Scarber | 4970
[NAME] | 4970
[NAME] | 4970
[NAME] | 4970
[NAME] | 4970
[NAME] | 7173
Amanda Scarber | 7173
[NAME] | 7173
[NAME] | 7173
[NAME] | 7173
[NAME] | 7173
[NAME] | 7173
[NAME] | 7173
[NAME] | 7173
[NAME] | 7714
Amber Murrell | 7714
[NAME] | 7714
Iliana Smith | 7714
Frances CruzSanchez | 7714
Mariah Grigoriadis | 4913
Danielle Finch | 4913
[NAME] | 4913
[NAME] | 4913
[NAME] | 4913
[NAME] | 4913
[NAME] | 4913
[NAME] | 4913
Desiree Cavazos | 4913
[NAME] | 4913
[NAME] | 7063
Crystal Carranaza | 7063
[NAME] | 7063
Esmeralda Martinez | 7063
[NAME] | 7063
[NAME] | 7063
Aubre [NAME] | 372
[NAME] | 372
Kimberly Bustamant | 372
[NAME] | 372
[NAME] | 372
Chrissy Ogden | 372
[NAME] | 942
[NAME] | 942
[NAME] | 942
[NAME] | 942
[NAME] | 942
[NAME] | 942
Porsche [NAME] | 942
[NAME] | 5150
Amber Burns | 5150
Brandie Fletcher | 5150
[NAME] | 5150
[NAME] | 5150
[NAME] | 5150
[NAME] | 5150
Sandra Agueros | 2546
[NAME] | 2546
[NAME] | 2546
[NAME] | 2546
Michell Nunnally | 2546
[NAME] | 2546
[NAME] | 2546
Sandra Agueros | 4954
[NAME] | 4954
[NAME] | 4954
[NAME] | 4954
[NAME] | 4954
Cassy moreland | 4954
Trista Towles | 4954
[NAME] | 4954
New Returns:  The percentage of new customers that return within 105 day of you serving them.
Repeat Returns:  The percentage of regulars that return within 105 day of you serving them.
Product Sales:  The amount of products you sold in relation to the total revenue you generated
Productivity:  The amount of revenue generated by you, per hour.
Color Code: | Great! | Good | Fair | Poor | Bad
Spreadsheet: 699767d1602756923-extract-values-and-place-extracted-values-in-desired-columns-salesid_okaynow_3
Sheet: Sheet1

Data Year (Fiscal) | Sales ID | Sales Count | Lat | Long |  | Data Year (Fiscal) |  | LL_1 | LL_2 | LL_3 | [NAME] | LL_5 | LL_6 | LL_7 | LL_8 | LL_9 | LL_10 | LL_11 | LL_12 | [NAME] | LL_14 | LL_15 | LL_16 | [NAME] | LL_18 | LL_19 | LL_20 | [NAME] | LL_22 | LL_23 | LL_24 | LL_25 | LL_26 | [NAME] | LL_28 | LL_29 | LL_30 | LL_31 | LL_32 | LL_33 | LL_34 | [NAME] | [NAME] | LL_37 | LL_38 | LL_39 | [NAME] | LL_41 | LL_42 | [NAME] | LL_44 | LL_45 | LL_46 | LL_47 | LL_48 | LL_49 | LL_50 | [NAME] | [NAME] | LL_53 | LL_54 | LL_55 | LL_56 | LL_57 | LL_58 | LL_59 | LL_60 | [NAME] | LL_62 | LL_63 | LL_64 | LL_65 | LL_66 | LL_67 | LL_68 | LL_69 | LL_70 | LL_71 | LL_72 | LL_73 | LL_74 | LL_75 | LL_76 | [NAME] | LL_78 | LL_79 | LL_80 | LL_81 | LL_82 | LL_83 | LL_84 | LL_85 | LL_86 | LL_87 | LL_88 | LL_89 | LL_90 | LL_91 | LL_92 | LL_93 | LL_94 | LL_95 | LL_96 | LL_97 | LL_98 | LL_99 | LL_100
Data Year (Fiscal) | Sales ID | Sales Count | Lat | Long |  | 2012 | Lat | 29.857273 | 40.776642 | 41.852058 | 34.196398 | 41.227413 | 41.214236
2012 | 1 | 6 | 29.857273 | -95.393037 |  | 2012 | Long | -95.393037 | -73.970187 | -88.086039 | -118.261862 | -73.367061 | -103.011929
2012 | 1 | 6 | 40.776642 | -73.970187 |  | 2011 | Lat | 36.699376 | 45.77173 | 35.246862 | 40.209999 | 39.325414
2012 | 1 | 6 | 41.852058 | -88.086039 |  | 2011 | Long | -93.834334 | -122.485953 | -80.833832 | -75.370201 | -104.925987
2012 | 1 | 6 | 34.196398 | -118.261862 |  | 2010 | Lat | 40.776642 | 33.205132 | 26.193535
2012 | 1 | 6 | 41.227413 | -73.367061 |  | 2010 | Long | -73.970187 | -97.12114 | -80.476683
2012 | 1 | 6 | 41.214236 | -103.011929
2011 | 1 | 5 | 36.699376 | -93.834334
2011 | 1 | 5 | 45.77173 | -122.485953
2011 | 1 | 5 | 35.246862 | -80.833832
2011 | 1 | 5 | 40.209999 | -75.370201
2011 | 1 | 5 | 39.325414 | -104.925987
2010 | 1 | 3 | 40.776642 | -73.970187
2010 | 1 | 3 | 33.205132 | -97.12114
2010 | 1 | 3 | 26.193535 | -80.476683
Spreadsheet: 215037d1361233078-determine-ytd-average-employee-weekly-hours-ytd-ave-weekly-hours
Sheet: Data

 | P | = Waiting to [NAME]. X or Did Not Send to Comp. A
 | Y | = Received Comp. X Timesheet or Sent to Comp. A
 | No. | Team | Still On A Team (Y/N) | Comp. X Employee (First / Last) | Initials | Comp. A Badge / Emp. ID | Comp. X SAP ID | Week | Date | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd |  | YTD Ave. Billable Hours | YTD Comp. X Billable Hours | Total
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 1 | 2013-01-04 00:00:00 | Y | 24 | 0 |  | Y | Y
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 2 |  | Y | 47.5 | 0 |  | Y | Y |  | 280.2 | 4.75 | 284.95 | 40.70714285714286
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 3 |  | Y | 53.5 | 1.5 |  | Y | Y
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 4 |  | Y | 40.5 | 3 |  | Y | Y
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 5 |  | Y | 59.7 | 0.25 |  | Y | Y
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 6 |  |  | 0
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 7
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | 8 |  |  | 55
Spreadsheet: 769062d1645275799-adding-extra-spaces-in-a-cell-separating-data-from-a-single-cell-aligw-xlsx-version
Sheet: Sheet3

 | 73.29 BF2192 Brown-line Bright-eye [NAME] conigera
 | 73.291 BF2199 [NAME] Mythimna pallens
 | 73.292 BF2200 [NAME]'s Wainscot [NAME] favicolor
 | 73.293 BF2198 [NAME] [NAME] impura
 | 73.294 BF2197 Southern Wainscot [NAME] straminea
 | 73.295 BF2195 The Delicate [NAME] vitellina
 | 73.296 BF2203 White-speck [NAME] unipuncta
 | 73.297 BF2194 White-point [NAME] albipuncta
 | 73.298 BF2193 The Clay Mythimna ferrago
 | 73.299 BF2201 Shore Wainscot [NAME] litoralis
 | 73.3 BF2202 L-album Wainscot Mythimna l-album
 | [NAME] Shoulder-striped [NAME] Leucania comma
 | 73.302 BF2204 Obscure Wainscot Leucania obsoleta
 | 73.303 BF2206 [NAME] Leucania putrescens
 | 73.3031 BF2210 The Maori Graphania averilla [NAME]
Spreadsheet: 274879d1383247142-two-way-lookup-with-multiple-if-and-variables-my-mind-is-blown-on-this-one-00-wcr-summary_test_jc-solution-combined
Sheet: WCR Pricing Matrix

WASHROOM CONDITION REPORT
Pricing Matrix
 |  |  |  |  |  |  |  | 2013-11-01 00:00:00
< AREA | ARCHITECTURAL |  |  | MECHANICAL |  |  | ELECTRICAL
 | <33% | >33%, <66% | >66% | <33% | >33%, <66% | >66% | <33% | >33%, <66% | >66%
50 | 110 | 150 | 190 | 16 | 19 | 22 | 12 | 15 | 18
75 | 105 | 145 | 185 | 16 | 19 | 22 | 12 | 15 | 18
100 | 100 | 140 | 180 | 16 | 19 | 22 | 12 | 15 | 18
150 | 95 | 135 | 175 | 15 | 18 | 21 | 11 | 14 | 17
200 | 90 | 130 | 170 | 15 | 18 | 21 | 11 | 14 | 17
250 | 85 | 125 | 165 | 14 | 17 | 20 | 10 | 13 | 16
350 | 80 | 120 | 160 | 14 | 17 | 20 | 10 | 13 | 16
450 | 75 | 115 | 155 | 14 | 17 | 20 | 10 | 13 | 16
Spreadsheet: mary_fischer__25624__31X
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:
EXT:
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 126449d1319700850-using-reference-with-inserting-rows-sample
Sheet: actuals

 | ACTUALS
 |  | 4 | 4
 |  |  | 4
Spreadsheet: 859892d1708103006-if-cell-value-matches-same-value-in-another-cell-return-adjacent-cells-test-excel-7
Sheet: SALES HISTORY & SPA ANALYSIS

SALES HISTORY |  |  |  |  |  | RPS DATA
SIM | SIM Description | [NAME] Months | Sales - 24 Months | Market Cost | Margin | [NAME] | Authorization Name | Contract Start Date | Contract Stop Date | Cost-Side Claim | Market Cost (Includes WTT) | Sell | Loaded Margin
 | ARL 84690 90D-DUPLEX-CONN | 18 | 104.24 | 59.44 | 0.429777436684574 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 330.214 | 622.93 | 0.4699019151429534
[PHONE] | ARL EMT50 1/2-NM-TERMINATOR | 120 | 20.53 | 10.78 | 0.47491475888943 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 8.979 | 17.09 | 0.4746050321825629
[PHONE] | ARL EMT75 3/4IN-NM-TERMINATOR | 65 | 13.45 | 8.48 | 0.369516728624535 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 13.11 | 21.78 | 0.3980716253443527
[PHONE] | LUT MS-OPS2-WH 1P-SENSOR-SWITCH | 3 | 71.85 | 50.83 | 0.292553931802366 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 18.409 | 25.09 | 0.2662813870067757
[PHONE] | RAB 080082 ORA1-LED15-B-4K-BRZ-KN | 2 | 135.1 | 92.15 | 0.317912657290896 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 20.449 | 34.31 | 0.4039930049548237
[PHONE] | RAB HELIX1-LED150-B-4K-T3-BRZ-DIM | 3 | 1055.7 | 814.72 | 0.228265605759212 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 204.949 | 327.61 | 0.3744116479960929
[PHONE] | RAB SMW4N-LED48-B-4K-WHT-DIM-FR | 4 | 276.56 | 189.42 | 0.315085334104715 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 40.949 | 63.3 | 0.3530963665086888
[PHONE] | RAB AWL1S-LED30A15-H-VK-BRZ-DIM-PC | 4 | 450.4 | 340.1 | 0.244893428063943 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 76.824 | 115.98 | 0.3376099327470254
[PHONE] | RAB AWL2S-LED80A50-H-VK-BRZ-DIM-PC | 3 | 531.48 | 368.85 | 0.305994581169564 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 122.949 | 177.16 | 0.3060002257846015
[PHONE] | COO 22CZ2-39-UNV-L835-CD1-U | 12 | 1725.6 | 1217.7 | 0.294332406119611 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 101.475 | 144.68 | 0.2986245507326514
[PHONE] | COO 24CZ2-50-UNV-L835-CD1-U | 2 | 356.66 | 260.35 | 0.270033084730556 | PRICE GUIDANCE | 0 | 00:00:00 | 00:00:00 | 0 | 134.173 | 200.08 | 0.3294032387045182
Spreadsheet: 07e8ab7d-c398-4d62-91b2-a154190d042f
Sheet: AP4-End of Life L2

EOL | End Of Life Costs Profile |  |  |  |  |  |  |  |  |  |  |  | Years |  | 60
REF | BCIS | Description | Qty | Unit | Rate | Year | Cost | f | Factored Cost | Annual Cost Equiv. | Life Cycle Cost | (e) | Escalated Costs | (i) | Acc. Present Value | Check Present Value |  | f | f1 | f2 | 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 | 20 | 20 | 21 | 21 | 22 | 22 | 23 | 23 | 24 | 24 | 25 | 25 | 26 | 26 | 27 | 27 | 28 | 28 | 29 | 29 | 30 | 30 | 31 | 31 | 32 | 32 | 33 | 33 | 34 | 34 | 35 | 35 | 36 | 36 | 37 | 37 | 38 | 38 | 39 | 39 | 40 | 40 | 41 | 41 | 42 | 42 | 43 | 43 | 44 | 44 | 45 | 45 | 46 | 46 | 47 | 47 | 48 | 48 | 49 | 49 | 50 | 50 | 51 | 51 | 52 | 52 | 53 | 53 | 54 | 54 | 55 | 55 | 56 | 56 | 57 | 57 | 58 | 58 | 59 | 59 | 60 | 60
5.0 | End of Life Costs
5.1 | Disposal inspections
5.1 |  | State client requirements, standards required, working restrictions and procurement context
5.2 | Demolitions
5.2 |  | State client requirements, standards required, working restrictions and procurement context
5.3 | Reinstatement costs
5.3 |  | State client requirements, standards required, working restrictions and procurement context
5.4 | Salavge costs
5.4 |  | State client requirements, standards required, working restrictions and procurement context
5.5 | Client definable costs
 |  | Total End of Life Costs
Spreadsheet: 702729d1604504530-return-a-date-in-a-cell-based-on-two-criteria-example1
Sheet: Sheet1

 | Date | Index | Date1
 | 2020-10-30 00:00:00 | M0 | BOM
 | 2020-10-30 00:00:00 | M1 | 2020-11-01 00:00:00
 | 2020-10-30 00:00:00 | M2 | 2020-12-01 00:00:00
 | 2020-10-30 00:00:00 | M3 | 2021-01-01 00:00:00
 | 2020-10-30 00:00:00 | M4 | 2021-02-01 00:00:00
 | 2020-11-01 00:00:00 | M0 | BOM
 | 2020-11-01 00:00:00 | M1 | 2020-12-01 00:00:00
 | 2020-11-01 00:00:00 | M2 | 2021-01-01 00:00:00
 | 2020-11-01 00:00:00 | M3 | 2021-02-01 00:00:00
 | 2020-11-01 00:00:00 | M4 | 2021-03-01 00:00:00