tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725633d1616774952-if-formula-not-working-there-are-multiple-formulas-and-one-is-not-working-don-kitchen
Sheet: Sheet1

 | Names | Week One | Week Two | Week Three | Week Four | Week Five | Week Six | Week Seven | Week Eight |  | Total |  | Top 6 Scores |  | Top 10 Players score
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank Helper
 | D Frith | 15 | 14 |  |  | 0 | 0 | 0 | 0
 | P Carter | 15 | 12 |  |  | 0 | 0 | 0 | 0
 | T Seymore | 15 | 15 |  |  | 0 | 0 | 0 | 0
 | A Terry | 14 | 15 |  |  | 0 | 0 | 0 | 0
 | J Vince | 14 | 10 |  |  | 0 | 0 | 0 | 0
 | M Frith | 14 | 8 |  |  | 0 | 0 | 0 | 0
 | [NAME] | 12 | 8 |  |  | 0 | 0 | 0 | 0
 | M Micklefield | 12 | 10 |  |  | 0 | 0 | 0 | 0
 | K Ellis | 12 | 16 |  |  | 0 | 0 | 0 | 0
 | K Lester | 12 | 11 |  |  | 0 | 0 | 0 | 0
 | C Medlin | 12 | 0 |  |  | 0 | 0 | 0 | 0
 | K De Veen | 12 | 12 |  |  | 0 | 0 | 0 | 0
 | J Thompson | 12 | 12 |  |  | 0 | 0 | 0 | 0
 | K  Thompson | 12 | 14 |  |  | 0 | 0 | 0 | 0
 | G Godhard | 12 | 7 |  |  | 0 | 0 | 0 | 0
 | L Lester | 12 | 11 |  |  | 0 | 0 | 0 | 0
 | L Harvey | 10 | 0 |  |  | 0 | 0 | 0 | 0
 | S Kinson | 10 | 15 |  |  | 0 | 0 | 0 | 0
 | C Micklefield | 10 | 15 |  |  | 0 | 0 | 0 | 0
 | D Bridges | 10 | 0 |  |  | 0 | 0 | 0 | 0
 | H De Veen | 10 | 15 |  |  | 0 | 0 | 0 | 0
 | L Bray | 10 | 7 |  |  | 0 | 0 | 0 | 0
 | W Seymore | 10 | 11 |  |  | 0 | 0 | 0 | 0
 | M Bray | 10 | 7 |  |  | 0 | 0 | 0 | 0
 | G Atkinson | 10 | 11 |  |  | 0 | 0 | 0 | 0
 | [NAME] | 10 | 8 |  |  | 0 | 0 | 0 | 0
 | D Ebdon | 8 | 15 |  |  | 0 | 0 | 0 | 0
 | J Sunderland | 8 | 11 |  |  | 0 | 0 | 0 | 0
 | A Levelle | 8 | 7 |  |  | 0 | 0 | 0 | 0
 | B Green | 7 | 11 |  |  | 0 | 0 | 0 | 0
 | C Laverty | 7 | 0 |  |  | 0 | 0 | 0 | 0
 | D Colquhoun | 7 | 8 |  |  | 0 | 0 | 0 | 0
 | M Holmes |  | 15 |  |  | 0 | 0 | 0 | 0
 | K Burnam | 0 | 7 |  |  | 0 | 0 | 0 | 0
 | [NAME] | 0 | 8 |  |  | 0 | 0 | 0 | 0
Spreadsheet: 783613d1654960783-using-formula-to-fill-format-cells-conditionally-based-on-cells-conditional-formatting-using-formula-bsb-
Sheet: Sheet1

Metric-2 (sub metric-1, Flexible - as many number as required) | Numerator | Denominator | Current Value (Latest Value) | Current Value (YTD) | Weighted %age score | Suggested Weightage for Rolling up into Metric 1 | Green Range | Amber Range | Red Range
Product Availability | 198833 | 206722 | 0.9618 | n/a | 0.721 | 0.75 | 0.953 | in between | 0.928
Transport On Time Delivery | 136392 | 140102 | 0.9735 | n/a | 0.243 | 0.25 | 0.976 | in between | 0.951
Numerator | 183238 | 198833
Denominator | 189252 | 206722
'Product Availablity' - Actuals | 0.9682 | 0.9618
Numerator | 133989 | 136392
Denominator | 138875 | 140102
Transport On Time Delivery - Actual | 0.9648 | 0.9735
Spreadsheet: phillip_m_love__30484__NUI P_B_I
Sheet: index

Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
NUIENEBRO | YF2941.1 | P | IF-HEHUB | 2001-11-01 00:00:00 | 30000 | 30000 | 1 | -0.01 | 1e-07 | 0 | -300.003
NUIENEBRO | YD1065.1 | P | TRANSCO/Z6NONNY | 2001-11-01 00:00:00 | 150000 | 150000 | 1 | -0.07 | 1e-07 | 0 | -10500.015
NUIENEBRO | YF0985.1 | P | TRANSCO/Z6NONNY | 2001-11-01 00:00:00 | 150000 | 150000 | 1 | -0.07 | 1e-07 | 0 | -10500.015
NUIENEBRO | YF2363.1 | P | TRANSCO/Z6NONNY | 2001-11-01 00:00:00 | 150000 | 150000 | 1 | -0.07 | 1e-07 | 0 | -10500.015
NUIENEBRO | YL6165.1 | P | TRANSCO/Z6NONNY | 2001-12-01 00:00:00 | 310000 | 309945.2497 | 0.99982338612278 | 0.1 | 1e-07 | 0 | 30994.494
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -603163
3531 | -360456 | -124630
60667 | -191052 | -1168781
60749 | 9058 | 145315
61206
61334 | -11462
62960
INDEX
2002-02-28 00:00:00 |  |  | 1515.91
2002-03-11 00:00:00
CBS Volume
 |  |  | 90
Spreadsheet: 889496d1740335292-if-error-index-match-formula-to-give-not-found-instead-of-n-a-error-example-data-set-with-formula
Sheet: Sheet1

[NAME] | Main Specialty | Local project reference | confidential | confidential | confidential | confidential | Registration Number | Specialty | comments re column I formula | [NAME] | Specialty for Report
True | Oncology | 0150 | confidential | confidential | confidential | confidential | Bre2024
True | Renal | 0151 | confidential | confidential | confidential | confidential | Ren023
True | Respiratory | 0152 | confidential | confidential | confidential | confidential | Car - 25
True | Paediatrics | 0153 | confidential | confidential | confidential | confidential | OBS - 22523
True | Stroke | 0154 | confidential | confidential | confidential | confidential | A&E - 6438903
True | Oncology | 0155 | confidential | confidential | confidential | confidential | TBT928093240 | Not found | I want this to show Not Found I can have a split warning in column K rather than N/A so formunla in L works like in here.
False | Respiratory | 0156 | confidential | confidential | confidential | confidential | 23489 |  | I want this to show Not Found  as otherwise it affects columns K and L
True | Dermatology | 0157 | confidential | confidential | confidential | confidential | 234809 |  | I want this to show Not Found  as otherwise it affects columns K and L
True | Dermatology | 0158 | confidential | confidential | confidential | confidential | 8242 |  | I want this to show Not Found  as otherwise it affects columns K and L
True | Rheumatology | 0159 | confidential | confidential | confidential | confidential | Der2433
True | Rheumatology | 0160 | confidential | confidential | confidential | confidential | Der - 25
True | PRC | 0161 | confidential | confidential | confidential | confidential | Res -- 286
False | Critical Care | 0162 | confidential | confidential | confidential | confidential | ICU - 9234
False | Cardiology | 0163 | confidential | confidential | confidential | confidential |  |  | I want this to show Not Found too (when it is blank) as otherwise it affects columns K and L
True | Dermatology | 0164 | confidential | confidential | confidential | confidential |  |  | I want this to show Not Found too (when it is blank) as otherwise it affects columns K and L
Spreadsheet: 44907d1243628984-how-to-make-my-formula-more-efficient-h1913_reorg_entitl_v2
Sheet: AllocationRule

LOB | Percentage
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
BN | 0.7
BI | 0.15
BH | 0.1
BC | 0.05
Spreadsheet: 9f5d407c-35f1-4789-8cee-d5f90c159667
Sheet: SW803

SW | SUV | PS# | Ln | Item | Description | UOM | $ | Cat | Cat Desc
SW803 | SCI | 3489 | 1 |  |  |  | 21.05 |  | Socks
SW803 | SCI | 3489 | 2 |  |  |  | 10.65 |  | Socks
SW803 | SCI | 3489 | 3 |  |  |  | 21.65 |  | Socks
SW803 | SCI | 3489 | 4 |  |  |  | 11.4 |  | Socks
SW803 | SCI | 3489 | 5 |  |  |  | 11.4 |  | Socks
SW803 | SCI | 3489 | 6 |  |  |  | 18 |  | Socks
SW803 | SCI | 3489 | 7 |  |  |  | 8.5 |  | Socks
SW803 | SCI | 3489 | 8 |  |  |  | 18 |  | Socks
SW803 | SCI | 3489 | 9 |  |  |  | 8.5 |  | Socks
SW803 | SCI | 3489 | 10 |  |  |  | 21.65 |  | Socks
SW803 | SCI | 3489 | 11 |  |  |  | 8.5 |  | Socks
SW803 | SCI | 3489 | 12 |  |  |  | 22.85 |  | Socks
SW803 | SCI | 3489 | 13 |  |  |  | 8.5 |  | Socks
Spreadsheet: eric_saibi__9943__110101U
Sheet: Sutter 01

Owner Name |  | Calpine Corporation
Station Name |  | Sutter Power
Unit Name |  | Unit 01
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Steam
Capacity |  | 185 MW
Start Date |  | 2001-10-31 00:00:00
End Date |  | 2001-11-11 00:00:00
Comments |  | Lightning Damage
SIC |  | 4931
Plant ID |  | 1032188
Unit ID |  | 1012170
Outage ID |  | 18777
Spreadsheet: 80419d1280626638-rank-and-show-on-bell-chart-statsonsats
Sheet: Sheet1

 | Student | Math | Science | English | Combined | Math Rank(1st, 2nd etc) | Science Rank | English Rank | Combined Rank | Average of Rank | Average Poistional Rank |  | Math | Science | English | Combined total
 | [NAME] | 92 | 56 | 77 |  |  |  |  |  |  |  | Range
 | Pam | 65 | 87 | 75 |  |  |  |  |  |  |  | Mean
 | [NAME] | 42 | 13 | 55 |  |  |  |  |  |  |  | Median
 | [NAME] | 84 | 55 | 42 |  |  |  |  |  |  |  | StevdP
 | [NAME] | 25 | 45 | 87
 | [NAME] | 66 | 92 | 49
 | [NAME] | 51 | 56 | 65
 | [NAME] | 58 | 74 | 42
 | Kel | 49 | 43 | 74
 | Bel | 74 | 51 | 29
 | Shell | 75 | 65 | 57
 | Math |  | Science |  | English
 | Mean | 61.90909090909091 | Mean | 57.90909090909091 | Mean | 59.27272727272727
 | Standard Error | 5.875147263848014 | Standard Error | 6.596768555277713 | Standard Error | 5.412260339587432
 | Median | 65 | Median | 56 | Median | 57
 | Mode | #N/A | Mode | 56 | Mode | 42
 | Standard Deviation | 19.48565906226702 | Standard Deviation | 21.87900612667104 | Standard Deviation | 17.95043681413301
 | Sample Variance | 379.6909090909088 | Sample Variance | 478.6909090909088 | Sample Variance | 322.2181818181816
 | Kurtosis | -0.1427703150689492 | Kurtosis | 0.8606799300639549 | Kurtosis | -0.9379223258691352
 | Skewness | -0.3228873415208304 | Skewness | -0.3226200845493252 | Skewness | -0.106999200681821
 | Range | 67 | Range | 79 | Range | 58
 | Minimum | 25 | Minimum | 13 | Minimum | 29
 | Maximum | 92 | Maximum | 92 | Maximum | 87
 | Sum | 681 | Sum | 637 | Sum | 652
 | Count | 11 | Count | 11 | Count | 11
 | Largest(1) | 92 | Largest(1) | 92 | Largest(1) | 87
 | Smallest(1) | 25 | Smallest(1) | 13 | Smallest(1) | 29
 | Confidence Level(95.0%) | 13.09064382355182 | Confidence Level(95.0%) | 14.69851625250785 | Confidence Level(95.0%) | 12.05926748795578
Spreadsheet: 753094d1635247557-lookup-ref-from-latest-date-for-an-item-in-a-list-lookup-ref-from-latest-date-for-and-item-in-a-list
Sheet: Sheet1

ref | date | item
1 | 2016-01-01 00:00:00 | a
2 | 2016-12-31 00:00:00 | b
3 | 2017-12-31 00:00:00 | c
4 | 2018-12-31 00:00:00 | a
5 | 2019-12-31 00:00:00 | d
6 | 2020-12-30 00:00:00 | a
7 | 2021-12-30 00:00:00 | e
8 | 2022-12-30 00:00:00 | f
9 | 2023-12-30 00:00:00 | a | [NAME] date for entry "a" in this list and return its ref number
10 | 2024-06-01 00:00:00 | g
11 | 2024-06-03 00:00:00 | h
Spreadsheet: 155627d1336996690-subtotal-of-sumproducts-sumproduct
Sheet: Sheet1

 |  |  | Unfactored | 100 | 0 | 100 | 0 | 0 | 0 | 200
 |  |  | Factored | 100
 | Region | Country | Probaility | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Total
 | a | x | 0.25 | 100 |  |  |  |  |  | 100
 | b | y | 1 |  | 200 |  |  |  |  | 200
 | b | z | 0.75 |  |  |  | 100 |  |  | 100
 | c | z | 0.5 | 500 |  |  |  |  |  | 500
 | d | x | 0.5 |  |  | 200 |  |  |  | 200
 | a | y | 1 |  |  | 100 |  |  |  | 100
 | c | y | 0.25 | 50 |  |  |  |  |  | 50
 | c | y | 1 |  |  | 200 |  |  |  | 200
 | d | z | 1 |  |  |  | 300 |  |  | 300
 | b | x | 1 |  |  |  |  | 500 |  | 500
 |  |  |  |  |  |  |  |  |  | 2250
Spreadsheet: 7864031c-edd0-4d68-aa83-87c04c295f40
Sheet: Operating

OPERATING/PROGRAMMATIC
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Increase appropriations for the Police Grants fund
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax) |  |  |  |  |  |  |  |  |  | 2390
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund
 | Special Revenue |  |  |  | 299730
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | The grant consist of federal funding.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund
 | Special Revenue |  |  |  | 299730
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | This grant will allow funding for overtime and training for 1 year.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | No |  | x | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
 | The grant serves the people of the City of Kansas City by providing overtime for officers who backfill for
 | other officers who will be assigned foot patrol duties for 13 weeks. The University of Missouri-Kansas City
 | will evaluate the impact that foot patrols have on crime in the area under study.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Acrylic Acid

Raw Material |  | Acrylic Acid
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 614.8
2023-10-02 00:00:00 |  |  |  |  | 65
2023-10-03 00:00:00 |  |  |  |  | 65
2023-10-04 00:00:00 |  |  |  |  | 65
Total
Spreadsheet: 695368d1600178008-return-and-aggregate-values-if-it-meets-one-or-more-criteria-tes
Sheet: Sheet1

 | Lang1 | Lang2 | Lang3 | Agregate teachers |  |  |  | Teacher | Lang
[NAME] | English |  | German |  |  |  |  | [NAME] | German
[NAME] |  | Russian |  |  |  |  |  | [NAME] | Russian
Jake |  |  | German |  |  |  |  | [NAME] | English
 |  |  |  |  |  |  |  | [NAME] | German
Spreadsheet: 761120d1640671312-income-by-location-sumproduct-pq_list_months
Sheet: Tabela2

Room | begining_of_month |  |  |  | Liczba z Room | Etykiety kolumn
Room A | 2021-01-01 00:00:00 |  |  |  | Etykiety wierszy | Room A | Room B | Room C | Room D | Suma końcowa
Room A | 2021-02-01 00:00:00 |  |  |  | sty | 1 |  |  |  | 1
Room B | 2021-02-01 00:00:00 |  |  |  | lut | 2 | 1 |  |  | 3
Room A | 2021-02-01 00:00:00 |  |  |  | [NAME] | 1 |  |  |  | 1
Room A | 2021-03-01 00:00:00 |  |  |  | kwi | 1 |  | 1 |  | 2
Room A | 2021-04-01 00:00:00 |  |  |  | cze |  |  |  | 1 | 1
Room C | 2021-04-01 00:00:00 |  |  |  | Suma końcowa | 5 | 1 | 1 | 1 | 8
Room D | 2021-06-01 00:00:00
 |  |  | I doubt if totals are meaningful here, especially totels per room. Totals per month seem legit.
Spreadsheet: 124148d1318187094-formatting-795617-formatting-box-inventory
Sheet: Mixed Alloy

 |  | [NAME]
Box # | Start Date | 50 Day | 70 Day | Box Location | Box Weight Empty | Material Weight | Delivered to Staging | Issues
5 | 2011-08-01 00:00:00 |  |  | Baghouse | 8960 | 1 |  | None
6 | 2011-08-01 00:00:00 |  |  | Baghouse | 9180 | 2 |  | None
7 | 2011-08-01 00:00:00 |  |  | Baghouse | 9080 | 3 |  | None
19 | 2011-08-01 00:00:00 |  |  | Baghouse | 7540 | 4 |  | None
 | Baghouse
 | Transfer Tower
 | Dedust
 | Fans
Spreadsheet: 748739d1632320073-work-out-daily-amount-to-target-31-day-figures
Sheet: 25th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 80329d1280497895-sumproduct-with-variable-range-weeklysales_intomonth_fixed
Sheet: Sheet1

 |  | 6 | 7
 | week | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 |  |  |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 |  |  | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 | Total
 | 0 | 20 | 100 |  | 0 | 2009-01-04 00:00:00 | 0.5714285714285714 |  |  |  | 2009-01-01 00:00:00
 | 1 | 30 | 60 |  | 1 | 2009-01-11 00:00:00 | 1 |  |  |  | 2009-02-01 00:00:00
 | 2 | 30 | 40 |  | 2 | 2009-01-18 00:00:00 | 1 |  |  |  | 2009-03-01 00:00:00
 | 3 | 20 | 25 |  | 3 | 2009-01-25 00:00:00 | 1
 | 4 | 10 | 0 |  | 4 | 2009-02-01 00:00:00 | 0.8571428571428571 | 0.1428571428571428 |  |  | Fixed [NAME]
 | 5 | 5 | 0 |  | 5 | 2009-02-08 00:00:00 |  | 1 |  |  |  | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 | Total
 | 6 | 4 | 0 |  | 6 | 2009-02-15 00:00:00 |  | 1 |  |  | 2009-01-01 00:00:00
 | 7 | 3 | 0 |  | 7 | 2009-02-22 00:00:00 |  | 1 |  |  | 2009-02-01 00:00:00
 | 8 | 2 | 0 |  | 8 | 2009-03-01 00:00:00 |  | 0.8571428571428571 | 0.1428571428571428 |  | 2009-03-01 00:00:00
 | 9 | 10 | 0 |  | 9 | 2009-03-08 00:00:00 |  |  | 1
 | 10 | 5 | 0 |  | 10 | 2009-03-15 00:00:00 |  |  | 1
 | 11 | 5 | 0 |  | 11 | 2009-03-22 00:00:00 |  |  | 1
 | 12 | 20 | 0 |  | 12 | 2009-03-29 00:00:00 |  |  | 1
 | 13 | 20 | 0 |  | 13 | 2009-04-05 00:00:00 |  |  | 0.2857142857142857
Spreadsheet: james_steffes__12808__Geoergetowntemplatefall2001b
Sheet: 2000 Results

2000 Results
Georgetown University
The McDonough School of Business
Full Time |  |  | Summer 2001
Offers Given | 10 |  | Offers Given | 5
Acceptances | 8 |  | Acceptances | 5
$ Spent/Effort | 56538 |  |  | 11398
Summer 2000
Offers Given | 1
Acceptances | 1
Total $ Spent | $67,936
Cost Per Hire
Full Time | 7067
Summer | 2279
Current Pool Representation
Name | Hire Date |  | Group |  | Rating
Ashmore | 1998-08-17 00:00:00 |  | EBS-Content Services
Carroll | 1999-07-19 00:00:00 |  | Wholesale / NA Net Development
Corbacho | 2000-08-07 00:00:00 |  | EBS-DCS Business Development
Gregory | 1999-01-18 00:00:00 |  | EIM- Trading Origi
Griffin | 2000-08-07 00:00:00 |  | EIM- Trading Origi
Ham | 2000-08-07 00:00:00 |  | EES Mass Markets
[NAME] | 2000-08-07 00:00:00 |  | CORP-RAC-Investment Valuations
Polsky | 2000-08-07 00:00:00 |  | West Gas Origination
Samudio | 1999-09-13 00:00:00 |  | EBS Enterprise East
Tellechea | 1999-07-19 00:00:00 |  | EES - Costing
Wood | 2000-08-07 00:00:00 |  | EBS-Digital Content Services
Spreadsheet: 701652d1603876455-q2using-powerquery-imported-data-from-website-to-excel-spreadsheet-not-recognizing-numbers-finvizpquery-problem-3-1-
Sheet: Sheet1

Path |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
CO |  |  | Index | - | P/E | 6.85 | EPS (ttm) | 0.61 | Insider Own | 0.496 | Shs Outstand | 121.57M | Perf Week | 18.80% |  | [NAME] is where I want to type the stock ticker
 |  |  | Market [NAME] | 478.88M | Forward P/E | 7.19 | EPS next Y | 0.58 | Insider Trans | 0 | [NAME] | 34.73M | Perf Month | 23.01% |  | When I type a stock ticker, the data in D1:O13 should change
 |  |  | Income | 74.10M | PEG | 0.23 | EPS next Q | 0.13 | Inst Own | 0.171 | Short Float | 0.81% | Perf Quarter | 24.11%
 |  |  | Sales | 183.90M | P/S | 2.6 | EPS this Y | 61.50% | Inst Trans | 0.0003 | Short Ratio | 2.24 | Perf Half Y | 39.46% |  | Examples of stock tickers
 |  |  | Book/sh | 4.94 | P/B | 0.84 | EPS next Y | 23.40% | ROA | 0.069 | Target Price | - | Perf Year | -17.91% |  | BRK-A, CO,  ARC,  HIL,   AAAU,   SIM
 |  |  | Cash/sh | 7.25 | P/C | 0.57 | EPS next 5Y | 30.00% | ROE | 0.129 | 52W Range | 2.54 - 5.29 | Perf YTD | -16.60%
 |  |  | Dividend | - | P/FCF | 5.83 | EPS past 5Y | 23.30% | ROI | 0.118 | 52W High | -21.17% | Beta | 0.49
 |  |  | Dividend % | - | [NAME] | 9.9 | Sales past 5Y | 14.00% | Gross Margin | 0.848 | 52W Low | 64.17% | ATR | 0.17
 |  |  | Employees | 1260 | Current Ratio | 10 | Sales Q/Q | 2.70% | Oper. Margin | 0.472 | RSI (14) | 75.09 | Volatility | 7.03% 4.22%
 |  |  | Optionable | Yes | Debt/Eq | 0 | EPS Q/Q | 22.50% | Profit Margin | 0.403 | Rel Volume | 3.51 | Prev Close | 3.97
 |  |  | Shortable | Yes | LT Debt/Eq | 0 | Earnings | Aug 24 AMC | Payout | 0 | [NAME] | 125.15K | Price | 4.17
 |  |  | Recom | 2.00 | SMA20 | 0.1666 | SMA50 | 18.80% | SMA200 | 0.1829 | Volume | 424,662 | Change | 5.04%
Spreadsheet: louise_kitchen__22762__Turbine Position Report 110201
Sheet: Summary by Type

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Turbine Type
($ MMs)
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION | STATUS
 |  |  |  |  |  |  |  | Available
 |  |  |  | total per above
 |  |  |  | per Summary By [NAME] report
 |  |  |  | Difference
Spreadsheet: 38c619c9-487f-487f-9cbc-0d0046fa54a7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-22 09:21:53.280000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.842 | 102.717 | 102.592 | 102.217
4.5 | 102.83 | 102.705 | 102.58 | 102.205 |  | Note: | Refer To Price [NAME]
4.375 | 102.23 | 102.105 | 101.98 | 101.605 |  |  | For all Price Adjs
4.25 | 101.638 | 101.513 | 101.388 | 100.763
4.125 | 100.801 | 100.676 | 100.551 | 99.926
4 | 99.8 | 99.675 | 99.55 | 98.925
3.875 | 98.755 | 98.63 | 98.505 | 97.88
3.75 | 97.88 | 97.755 | 97.63 | 97.005
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.746 | 102.621 | 102.496 | 102.121
3.625 | 102.611 | 102.486 | 102.361 | 101.986
3.5 | 102.068 | 101.943 | 101.818 | 101.443
3.375 | 101.348 | 101.223 | 101.098 | 100.473
3.25 | 100.583 | 100.458 | 100.333 | 99.708
3.125 | 100.149 | 100.024 | 99.899 | 99.274 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-05 09:21:53.280000
30 DAY | 2014-06-20 09:21:53.280000
45 DAY | 2014-07-05 09:21:53.280000
60 DAY | 2014-07-20 09:21:53.280000
90 DAY | 2014-08-19 09:21:53.280000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 707086d1607023728-multiple-nested-sum-and-blanks-or-zero-new-microsoft-excel-worksheet
Sheet: Sheet1

Site | Current Power |  | BAU 2021 | NCP 2021 | Power | Total 2021 | BAU 2022 | NCP 2022 | Power | Total 2022 | BAU 2023 | NCP 2023 | Power | Total 2023 | Total Projection
A | 100 |  | 1 |  |  |  | 1 | 1 |  |  | 1 | 1
B | 300 |  | 2 | 1 |  |  | 2 |  |  |  | 1 | 1
C | 500 |  | 2 |  |  |  |  | 1