tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Cost and Funding Summary

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Project Cost and Sources of Funding Summary
 |  | Cost (2013 $) | Cost (2015 $)*
 | Project Construction
 | Total Project Maintenance Costs (2015-2045)
 | * Assumes 3% inflation annually, 2013-2015.
 | Project Funding
 |  | Funding (2015 $)
 | Design Costs (Already Expended or Funded) | 2400000
 | City of Rochester Match | 5900000
 | Requested TIGER Grant | 17700000
 | Total Funding
Spreadsheet: 30c4703f-e484-44a7-b184-fa1a67238dfa
Sheet: Sheet1

Budget Summary
Original Proposal Budget |  |  |  |  |  | Actual Project Expenditures
The original approved and awarded budget amounts should be included on this side. |  |  |  |  |  | The current budget expenditures to date should be recorded on this side.
Category | [NAME] | Local Cash Match | Local        In-Kind Match | Total |  | LSTA Money Spent | Local Cash Match | Local          In-Kind Spent | Total
Personnel
Salaries
Fringe Benefits
Contact Services
Operating
Advertising
Telephone/Data
Supplies
Photocopying & Printing
Postage & Shipping
Travel
Food | xxx |  |  |  |  | xxx
Rent | xxx |  |  |  |  | xxx
Project Evaluation
Technology
Computer Equipment
Computer Accessories
Other Equipment
Software
Capital Expenditures
Furniture
Books
Other
Total
Spreadsheet: 811130d1672302054-hide-row-hide-empty-row
Sheet: By_Formula

No. | Name | Matric No. | Math | Sc | Arts | Eng | Geog | History
Spreadsheet: 64d11b07-6b99-4710-be39-9f307e9f82b8
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 8 Passive components 8.9 Magnetic and electronic ceramic products 8.9.12 Ceramic insulation inserts
No. | Company | Country | City | [NAME] | Hall/Booth
1 | CeramTec AG Electronic Applications Division | Germany | [NAME] | 95615 | B1.206
2 | Micro Systems Technologies (MST) | Switzerland | Baar | 6341 | B1.635
Spreadsheet: benjamin_rogers__1054__Consolidated 6 Peaker-062000
Sheet: Assumptions

ASSUMPTIONS
TECHNICAL ASSUMPTIONS: |  | 1999 PROJECTS |  |  |  | 2000 PROJECTS
 |  | Brownsville | Caledonia | New Albany |  | [NAME] | Wheatland | [NAME] |  | Sub Total
Number of Turbines |  | 4 | 6 | 6 |  | 3 | 4 | 8
Summer Capacity (MW)(1) |  | 458 | 466 | 371 |  | 510 | 470 | 608
[NAME] (HHV, Btu/kWh) |  | 11406 | 12300 | 12500 |  | 10800 | 11734 | 11973
Numbers of Starts |  | 75 | 75 | 75 |  | 75 | 75 | 75
PRICING ASSUMPTIONS:
Fixed Price Demand Charge ($/kW-month) |  | 4
Energy Charge ($/MWh)
Start Charge ($/Start/Turbine)
Annual Generation (MWh) |  | 624921.7078730493 | 544139.6717506632 | 410269.84 |  | 532991.6197855896 | 461312.7218562186 | 2002000
OPERATING COSTS ASSUMPTIONS:
Variable O&M ($/MWh) |  | 1.5 | 1 | 1 |  | 1.5 | 3 | 2
Major [NAME] ($/Start/Turbine) |  | 1500 | 1000 | 1000 |  | 3000 | 1500 | 1000
Annual Escalator |  | 0.03
Annual Cost (000$ in Year 2000)
Fixed O&M |  | 1563.63147 | 1721.30196 | 1878.06659 |  | 1242.481714285714 | 1515.790285714286 | 1448.540571428571
Variable O&M
Major [NAME]
Owner's Expense |  | 431.7851666666667 | 410.9306666666667 | 362.6721666666667 |  | 322.2511428571429 | 306.2677142857142 | 400.6471428571429
Property Tax Liability
TAX ASSUMPTIONS:
Federal Income Tax Rate |  | 0.35 | 0.35 | 0.35 |  | 0.35 | 0.35 | 0.35 |  | 0.35
State Income Tax Rate |  | 0.06 | 0.05 | 0.05 |  | 0.06 | 0.045 | 0.0718
Adjusted Gross Income Tax |  | N/A | N/A | N/A |  | N/A | 0.034 | N/A
Gross Receipts Tax Rate |  | N/A | N/A | N/A |  | N/A | 0.012 | N/A
Franchise Tax Rate (Year 1) |  | 0.0025 | 0.0025 | 0.0025 |  | 0.0025 | N/A | 0.0015
Franchise Tax Rate (Year 2-20) |  | 0.0025 | 0.0025 | 0.0025 |  | 0.0025 | N/A | 0.001
(1) Includes additional capacity of 20 MW at Caledonia and 15 MW at New Albany, with installation of evaporative coolers by June 2000.
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: J

 | COURSES IN RED ARE GENERAL EDUCATION COURSES FOR FALL 2012 |  |  | PURPLE J-TERM |  | GREEN BOTH FALL & J-TERM
Japanese | AOK designation | CAR designation | Comment
JAPN 211 & 212 | Foreign Language
JAPN 220 | Arts & Literature-Literature | Non-Western
JAPN 221 |  | Non-Western; Experiential-Travel | cross-listed with HIST 221
JAPN 381 & 382 |  | Non-Western
Journalism
JOUR 450 |  | Experiential-Internship
Spreadsheet: bdb56de9-29f5-4322-ac8a-1fff00548ccf
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 959 | 854 | 744 | 632
15 - 65 | 4630 | 4227 | 3771 | 3331
65 und mehr | 1611 | 1751 | 1931 | 2093
Insgesamt | 7200 | 6832 | 6446 | 6056
%
unter 15 | 13.31944444444444 | 12.5 | 11.54204157617127 | 10.43593130779392
15 - 65 | 64.30555555555556 | 61.87060889929742 | 58.50139621470679 | 55.00330250990753
65 und mehr | 22.375 | 25.62939110070258 | 29.95656220912193 | 34.56076618229854
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 20.71274298056155 | 20.20345398627869 | 19.72951471758154 | 18.97328129690784
Altenquotient | 34.79481641468682 | 41.42417790395079 | 51.20657650490587 | 62.83398378865206
Gesamtquotient | 55.50755939524839 | 61.62763189022947 | 70.9360912224874 | 81.80726508555989
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: 11d7aa38-f8d8-4583-8ca8-5b08842a1334
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
FB12 | Test | FB12 | [NAME] and Folate, Serum | [NAME] and Folate, S | B12/9154: Immunoenzymatic Assay FOL/9198: Competitive Binding Receptor Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Collection Instructions: Fasting (8 hours) Additional Information: Do not order on patients who have recently received methotrexate or other folic acid antagonist. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | VITAMIN B12 180-914 ng/L   FOLATE > or =4.0 mcg/L <4.0 mcg/L suggests folate deficiency | Monday through Friday; 5 a.m.-12 a.m., Saturday 6 a.m.-6 p.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
FB12 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FB12 | Component | B12 | [NAME], Serum | [NAME], S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | 180-914 ng/L | Monday through Friday; 5 a.m.-12 a.m. Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 82607 |  |  | Yes | Yes
B12 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
B12 | Result | B12 | [NAME], S | [NAME], S | Numeric |  |  |  |  | ng/L |  |  |  |  |  |  |  |  |  | 2132-9
FB12 | Component | FOL | Folate, Serum | Folate, S | Competitive Binding Receptor Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL Collection Instructions: Fasting (8 hours) Additional Information: Do not order on patients who have recently received methotrexate or other folic acid antagonists. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =4.0 mcg/L <4.0 mcg/L suggests folate deficiency | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same Day/1 day | 3 days | 1 | 82746 |  |  | Yes | Yes
FOL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FOL | Result | FOL | Folate, S | Folate, S | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 2284-8
Spreadsheet: 7a4181f0-8fab-4be1-b82e-310df9fea19b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43097894 | 2014-09-10 08:58:29 | AXIS | 0 | 4 | 6 | 1628962 | Murphy100 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
43098009 | 2014-09-10 09:14:06 | ALLIES | 1 | 6 | 3 | 1628962 | Murphy100 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
43110278 | 2014-09-11 07:17:32 | AXIS | 0 | 3 | 6 | 1633257 | player1633257 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43110367 | 2014-09-11 07:27:50 | ALLIES | 0 | 2 | 6 | 1633257 | player1633257 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43110498 | 2014-09-11 07:53:13 | ALLIES | 1 | 7 | 6 | 1581268 | Dain Ironfoot | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43110641 | 2014-09-11 08:12:26 | AXIS | 1 | 7 | 4 | 1581268 | Dain Ironfoot | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43110776 | 2014-09-11 08:31:25 | AXIS | 0 | 4 | 6 | 979406 | homez | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43110883 | 2014-09-11 08:39:24 | ALLIES | 1 | 6 | 2 | 979406 | homez | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43110933 | 2014-09-11 09:01:03 | ALLIES | 1 | 6 | 4 | 1617365 | hailKingFrank | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43111067 | 2014-09-11 09:19:33 | AXIS | 1 | 6 | 4 | 1617365 | hailKingFrank | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43120280 | 2014-09-12 01:07:10 | AXIS | 0 | 2 | 6 | 1633257 | player1633257 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43120403 | 2014-09-12 01:39:33 | AXIS | 1 | 4 | 3 | 389407 | player389407 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
43123789 | 2014-09-12 07:50:41 | AXIS | 1 | 6 | 3 | 1281014 | malinowski | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
Spreadsheet: 41225d1239726033-excel-workbook-data-populating-project_issue_log
Sheet: Definitions

Definitions:
# | Unique issue identification number
Issue Title | Brief description of the issue
Priority | Emergency - Impacts critical path
 | High - Significant negative impact on quality of project objectives
 | Medium - Moderate negative impact on quality of project objectives
 | Low - All other
Assigned To | Individual responsible for coordinating resolution
Status | Open - raised but no action taken
 | In Progress - assigned and resolution underway
 | On Hold - resolution activity stopped pending some requirement
 | Resolved - solution agreed to and in place. No further action to be taken
Date Reported | Date the issue was first reported
Due Date | Date the issue needs to be completed by
Date Completed | Date the issue status reached resolved
Type of Issue | System Processing - transaction does not perform as required
 | Data - master or transactional data is incorrect
 | Business Process - branch business process not effective and/or efficient
 | Training - competency development required
 | Authorization - system access development or delivery problem
Comment | Specific notes worth recording
Note: As issues are resolved, do not delete them from the list. Simply mark their status "Resolved" and use spreadsheet filters to remove them from view.  This enables statistical analysis and historical archiving of issues.
Spreadsheet: 08455b01-fc55-428d-84b9-0fd1b3a008b9
Sheet: Enterprise Fund Expenditures

[NAME]
Enterprise Fund Expenditures
Recommended Adjustments
 | Originally Proposed | Adjusted | % of Total Fund Expenditures
Airport | 17610810 | 17456056
Parking | 6824865 | 7897526
[NAME] | 18695222 | 17845287
Wastewater | 12657765 | 13985695
Water Usage | 30457903 | 32356236
Waterfront | 10976843 | 10945369
Total
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | April |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  | -1415100 |  | -4310 | -11938.7
2 |  | Liquidations |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  |  |  | 32264 |  | 1246.75
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  | 361 | 4575.86
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  | 231130.82
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | -244462 | -692316.38 | -17 | -48.14
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  | 188191 | 532956.91 | 8885 | 25162.32 | -44298 | -125451.94
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  | -1409 | -4283.49 | -9229 | -26711.34
15 |  | Cash In |  |  |  |  |  |  |  |  |  |  | 16457 | 47032.3
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  | 531505 | 1483149.85
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  | -821505 | -2326502.16
18 |  | W/D (Purchase from Stg) |  |  |  |  |  |  |  |  |  |  | 290000 | 0.01
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  | 1599735 | 4530449.52 | 4310 | 12205.92 | 44298 | 125451.94
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  | 244462 | 692316.38 | 17 | 48.14
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  | 291415 | 21.65 | 57657 | 67.06 | -4230219 | 364.27
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10080
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  | 125550 |  | 6198288.25 |  |  |  | 168147
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 218021d1362303521-cumulative-conditional-formatting-based-on-sum-cumulative-conditional-formatting
Sheet: Sheet1

Sales Consultant | Sales | % as sales | Cumalative Total | CAN HIDE | Required Outcome (MANUAL)
SC 1 | 33652272.79 |  |  |  | 0.2655920808160009
SC 2 | 12886356.71 |  |  |  | 0.3672944030960925
SC 3 | 10209985.89 |  |  |  | 0.4478741432684386
SC 4 | 7366728.66 |  |  |  | 0.5060141924064472
SC 5 | 7257277.14 |  |  |  | 0.5632904230105138
SC 6 | 7021274.02 |  |  |  | 0.6187040584754344
SC 7 | 6104649.25 |  |  |  | 0.6668834639817731
SC 8 | 5523772.94 |  |  |  | 0.7104784496234463
SC 9 | 5023564.44 |  |  |  | 0.7501256657582609
SC 10 | 4981297.28 |  |  |  | 0.7894392989863686
SC 11 | 4305521.07 |  |  |  | 0.8234195388089293
SC 12 | 3733627.35 |  |  |  | 0.8528862515943046
SC 13 | 3698162.32 |  |  |  | 0.8820730655694962
SC 14 | 2284763.6 |  |  |  | 0.9001049863994312
SC 15 | 2235139.74 |  |  |  | 0.9177452634221925
SC 16 | 2227928.57 |  |  |  | 0.9353286281033308
SC 17 | 2114316.27 |  |  |  | 0.9520153363431171
SC 18 | 2112692.28 |  |  |  | 0.968689227651161
SC 19 | 2001168.59 |  |  |  | 0.9844829463458359
SC 20 | 1966113.3 |  |  |  | 1
Spreadsheet: 730222d1619608270-return-booked-holiday-dates-from-a-holiday-planner-example
Sheet: Sheet1

 |  |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00
NAME1 |  |  | H | H | H |  |  | H | H | H
NAME2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
NAME3 |  |  |  | H |  | H |  |  | H | H
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
NAME1 |  |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00
NAME2 |  |  | 2021-01-16 00:00:00 | 2021-01-17 00:00:00
NAME3 |  |  | 2021-01-02 00:00:00 | 2021-01-04 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00
Spreadsheet: 700807d1603354724-if-functions-with-two-conditions-test-if-or-ifs-3
Sheet: Feuille 3

Français 2019-2020 | [NAME] | Français 2018-2019 | [NAME] | Comparatif
0.8044 |  | 1
0.2 |  | 0.2
0.2 |  | 0.4
0.2 |  | 0.6
0.2 |  | 0.8
0.4 |  | 0.2
0.4 |  | 0.4
0.4 |  | 0.6
0.4 |  | 0.8
0.6 |  | 0.2
0.6 |  | 0.4
0.6 |  | 0.6 | D
0.6 |  | 0.8
0.8 |  | 0.8
0.8
Spreadsheet: 225998d1365196812-how-to-use-the-name-of-a-cell-to-reference-a-sheet-with-the-same-name-price-metrics
Sheet: HTS

Ticker | hts us equity
Company
Start Date | 20061231
End Date | 20141231
Periodicity | A
Currency | USD
Filing Status Mnemonic | MR
Filing | Most Recent
Units | MLN
 |  | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | FY 2012
For the period ending |  | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00
Price to Book Ratio | PX_TO_BOOK_RATIO | #N/A N/A | #N/A N/A | 1.3073 | 1.0863 | 1.2186 | 0.9739 | 0.8773
Price [NAME] (P/E) | PE_RATIO | #N/A N/A | #N/A N/A | 7.0933 | 5.8008 | 7.0395 | 6.6423 | 6.7602
Price to Sales Ratio | PX_TO_SALES_RATIO | #N/A N/A | #N/A N/A | 3.0518 | 3.5747 | 4.2872 | 4.2332 | 4.0514
Price/Cashflow | PX_TO_CASH_FLOW | #N/A N/A | #N/A N/A | 7.8302 | 5.5672 | 6.7753 | 5.6466 | 4.3
Price/EBITDA | PX_TO_EBITDA | #N/A N/A | #N/A N/A | 3.0861 | 3.4874 | 3.8848 | 3.6175 | 3.2585
Total Liabilities | [NAME] | #N/A N/A | #N/A N/A | 4724.039 | 6484.689 | 8861.495 | 16506.531 | 23331.254
Last Price | PX_LAST | #N/A N/A | #N/A N/A | 26.6 | 27.96 | 30.27 | 26.37 | 24.81
Debt/Price |  | #[NAME]! | #[NAME]! | 177.5954511278195 | 231.9273605150215 | 292.7484307895606 | 625.9587030716723 | 940.3971785570335
Assets | BS_TOT_ASSET | #N/A N/A | #N/A N/A | 5460.326 | 7416.402 | 10006.979 | 18586.719 | 26404.118
Assets/Price |  | #[NAME]! | #[NAME]! | 205.2754135338346 | 265.2504291845494 | 330.5906508093822 | 704.8433447098976 | 1064.253043127771
Cur EV/T12EBITDA | CURRENT_EV_TO_T12M_EBITDA | #N/A N/A | #N/A N/A | 27.2137 | 24.579 | 32.4091 | 34.1177 | 35.8382
EV To Trailing 12M Sales | CURRENT_EV_TO_12M_SALES | #N/A N/A | #N/A N/A | 26.9109 | 25.1941 | 35.7667 | 39.9239 | 44.5588
Spreadsheet: 137793d1327368702-nested-if-statement-with-index-and-match-within-vanguard-template
Sheet: Sheet1

 | [NAME]
 | Product | [NAME]
 | Length (mm) | 3400
 | Projection | 3500 |  |  |  | Beams and Brackets
 | Operation | Remote
 | Control | Telis 16 - silver |  |  |  | Beams | Price | Length | Total
 | Sensor | Wind sensor - RTS (inc. 1 channel remote) |  |  |  | 150 x 50 |  | 4
 | Material Category | Category 3
 | Frieght | Cost | 400 |  |  | Brackets | Price | Amount | Total
 | [NAME] | No |  |  |  | Rafter | 120 | 10
 | Beam | No
 | Brackets | No
 | Drafting | Cost | 250
 | Buffer | Cost | 250
 | Kit | Cost
 | Labour | Cost | 810
 | Total
 | GST
 | Total inc GST
Spreadsheet: 726604d1617311967-index-indirect-match-function-issue-indirect-invoice-total
Sheet: 0000497987-64597987000

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
46547 | Example |  |  |  | 64597987000 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 95467.65
Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: Project result overview

 | Project1
 | Financial KPIs in EUR
 | Figures displayed in Clarity
 | Budgeted Cost (total incl. non-cash internal expenses) | 6329.722833906906
 | Budgeted Benefit (total incl. non-cash benefits) | 15766.9242384189
 | Budgeted TPV (total present value) | 5858.876665415071
 | [NAME] (total rate of return) | 225368.314904407
 | Budgeted Payback Period | 0
 | Additional figures not displayed in Clarity
 | Budgeted Cost (capex & opex ONLY) | 6329.722833906906
 | Budgeted Benefit (cash ONLY) | 15766.9242384189
 | Budgeted total expenses (cash & non-cash) | 6129.722833906906
 | Financial KPIs in local currency
 | [NAME] (total rate of return) | 225368.314904407
 | Budgeted TPV (total present value) | 5858.876665415071
 | Budgeted Payback Period | 0
 | Budgeted Cost (total incl. non-cash internal expenses) | 6329.722833906906
 | Budgeted Cost (capex & opex ONLY) | 6329.722833906906
 | Budgeted Benefit (total incl. non-cash benefits) | 15766.9242384189
 | Budgeted Benefit (cash ONLY) | 15766.9242384189
 | Budgeted total expenses (cash & non-cash) | 6129.722833906906
 | Financial Planning in EUR
 | (to be entered manually in Clarity) |  |  |  | 321
 |  | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017
 | One-off Cash Expenses (M_OCEXP) | 2542.897833906907 | 22.275 | 22.275 | 22.275 | 0 | 0 | 0 | 0
 | Operating Cash Expenses - BUSINESS (M_OPEX) | 800 | 800 | 800 | 800 | 0 | 0 | 0 | 0
 | 07 - Non-Cash Internal Expenses (M_NCIEXP) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BUDGETED COST (total) | 3622.897833906907 | 902.275 | 902.275 | 902.275 | 0 | 0 | 0 | 0
 | Cash revenues (M_CREV) | 3797.511193630168 | 3890.51876539933 | 3988.176715756951 | 4090.717563632452 | 0 | 0 | 0 | 0
 | Non Cash Benefits (M_NCBEN) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BUDGETED BENEFIT (total) | 3797.511193630168 | 3890.51876539933 | 3988.176715756951 | 4090.717563632452 | 0 | 0 | 0 | 0
 | NET-BENEFIT (=Sustainable ben. after impl. expenses) | #N/A | #N/A | #N/A | #N/A
 | Benefits BG / RS | 525.347485665743 | 525.347485665743 | 525.347485665743 | 525.347485665743
 | Net Benefit BG / RS | 525.347485665743 | 525.347485665743 | 525.347485665743 | 525.347485665743
 | Total Benefits 321+ incl. BG / RS | 4322.858679295911 | 4415.866251065073 | 4513.524201422693 | 4616.065049298195
 | Total Net Benefits 321+ incl. BG / RS | #N/A | #N/A | #N/A | #N/A
 |  | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
 | One-off Cash Expenses (M_OCEXP) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 06 - Operating Cash Expenses - BUSINESS (M_OPEX) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07 - Non-Cash Internal Expenses (M_NCIEXP) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BUDGETED COST (total) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 08 - Cash revenues (M_CREV) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 09 - Non Cash Benefits (M_NCBEN) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BUDGETED BENEFIT (total) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0