tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gerald_nemec__11416__Equity valuation - for condor
Sheet:  FUGG valuation

Fort  Union Gas Gathering and Lost Creek Gas Gathering
Ft. Union Valuation
Fort Union Gas Gathering
For the period beginning | 1999-11-30 00:00:00
Ending | 1999-12-31 00:00:00 | 2000-01-31 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00 | 2003-01-31 00:00:00 | 2003-02-28 00:00:00 | 2003-03-31 00:00:00 | 2003-04-30 00:00:00 | 2003-05-31 00:00:00 | 2003-06-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-31 00:00:00 | 2003-09-30 00:00:00 | 2003-10-31 00:00:00 | 2003-11-30 00:00:00 | 2003-12-31 00:00:00 | 2004-01-31 00:00:00 | 2004-02-29 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-05-31 00:00:00 | 2004-06-30 00:00:00 | 2004-07-31 00:00:00 | 2004-08-31 00:00:00 | 2004-09-30 00:00:00 | 2004-10-31 00:00:00 | 2004-11-30 00:00:00 | 2004-12-31 00:00:00 | 2005-01-31 00:00:00 | 2005-02-28 00:00:00 | 2005-03-31 00:00:00 | 2005-04-30 00:00:00 | 2005-05-31 00:00:00 | 2005-06-30 00:00:00 | 2005-07-31 00:00:00 | 2005-08-31 00:00:00 | 2005-09-30 00:00:00 | 2005-10-31 00:00:00 | 2005-11-30 00:00:00 | 2005-12-31 00:00:00
INCOME STATEMENT
Revenues
Total Volume on Fort Union
Total Volume > 300MMcfd
Incremental Rate
Incremental Revenue / Day
# Days in Month
ECT Demand Revenue
Other Demand Revenue
Incremental Revenue
Total Revenue per Month
Operating Expenses
O&M Escalator
Pre-expansion O&M
Incremental Expansion O&M | 0
Total O&M
General & Administrative
G&A Escalator
Total G&A
Total Expenses per Month
EBITDA
Interest Expense
Depreciation Expense
Net Income
STATEMENT OF CASH FLOWS
Cash at beginning of period | 0
OPERATIONS
Pre Tax Income
Plus Depreciation Expense
Cash Flows from Operations
INVESTMENTS
Purchases of PP&E |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Cash Flows from Investments
FINANCING
Increase (Decrease) in Long Term Debt
Increase in Paid-In Capital
Dividends Paid
Cash Flows from Financing
Cash at end of period
Increase in cash
Spreadsheet: 837087d1689843702-lookup-for-value-within-tolerance-from-two-columns-giwi342-xlookup-with-tolerance
Sheet: Sheet1

Compare this |  |  | To this |  |  | If both within range of X, return this |  |  |  | km
Longitude | Latitude |  | Longitude | Latitude |  | ID |  |  | X | 10
24.625272 | 59.405251 |  | 24.61024014 | 59.42884049 |  | 1
24.898454 | 59.44571 |  | 24.61118004 | 59.43042055 |  | 6
24.898512 | 59.445643 |  | 24.6073425 | 59.43094134 |  | 77
24.898384 | 59.445796 |  | 24.63748214 | 59.42330986 |  | 15
24.746022 | 59.436453 |  | 24.63764335 | 59.42378331 |  | 3
24.746032 | 59.436492 |  | 24.63780914 | 59.42430388 |  | 4
Spreadsheet: 104432d1302038003-fetch-values-from-different-sheets-example-for-help2
Sheet: Other Costs

 | Other Costs
 | NAKI Design
 |  |  | Payment Method
Date | Category | COST | CHECK | CASH | CREDIT | PO NUMBER
2010-10-31 00:00:00 | Internet + Promo | 119.4
2010-11-17 00:00:00 | Advertising
2010-11-18 00:00:00 | Advertising | 22.2
2010-11-30 00:00:00 | Internet + Advertising | 15.7
2010-12-22 00:00:00 | Postage | 32
2010-12-31 00:00:00 | Internet + Advertising
2011-01-07 00:00:00 | Internet + Advertising | 68
2011-01-12 00:00:00 | Internet | 88
2011-01-24 00:00:00 | Postage | 24.5
2011-02-21 00:00:00 | Advertising | 69
2011-02-24 00:00:00 | Postage | 16.8
2011-02-27 00:00:00 | Advertising | 72
2011-03-02 00:00:00 | Postage | 38.2
2011-03-05 00:00:00 | Advertising | 39
2011-03-16 00:00:00 | Advertising | 23
2011-03-07 00:00:00 | Internet + Advertising | 7
2011-03-22 00:00:00 | Advertising | 23
2011-03-23 00:00:00 | Postage | 15
2011-03-28 00:00:00 | Advertising | 23
2011-03-31 00:00:00 | Postage | 33
2011-04-03 00:00:00 | Advertising | 19
Spreadsheet: 142807d1330015899-combining-two-countif-statements-test-supplier
Sheet: Sheet1

Out of Scope      X | JDE # | [NAME] | 2011 spend | # [NAME] | Name of internal person working on this ? | Agreement Y or N | Experation of Agreement | [NAME] name | Supplier Phone # | Supplier Contact Name | CA | COI | W9 | [NAME] | Supplier ID & Chg Request | Address Book                  F-02409 | Date Sent to AP | Date Complete chg from VDI to V | Notes | Contact 1 | Contact 2 | Contact 3 | Contact 4 | Contact 5 | Contact 6 | Contact 7 | Contact 8 | Contact 9 | Contact 10 | Contact 11 | Contact 12 | Contact 13 | Contact 14 | Contact 15 | Contact 16
locating serv | 1 | a |  | 11 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2012-02-23 00:00:00
locating serv | 2 | b |  | 149 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00
data software backup/storeage | 3 | c |  | 11 | [NAME]
consulting service?? | 4 | d |  | 9 | debbie
consulting service?? | 5 | e |  | 11 | [NAME]
 | 6 | f |  | 10 | debbie
 | 7 | g |  | 12 | [NAME]
XX  ?? | 8 | h |  | 11 | [NAME]
prepare shareholder info | 9 | i |  | 11 | debbie
 | 10 | j |  | 40 | [NAME]
Spreadsheet: 349114d1412205460-syn-outlook-calendar-with-excel-2013-for-scheduling-purpose-sample
Sheet: Sheet1

2014 October |  | 2014-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
[NAME] | AM |  |  | Electronic Navigation Limited |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A/L |  |  | A/L |  |  |  |  | AM | [NAME] |  |  |  |  |  | A/L
 | AM |  |  | orbit survey |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  | Other
 | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
 | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
Spreadsheet: 140093d1328622649-daily-food-calculator-feb-food-total-values
Sheet: 2-4-12

 |  | Breakfast | Food Item | Cost | Daily Points
 |  |  | 1 English Muffin | 0.28 | 3
 |  |  | 18 g [NAME] | 0.144 | 1.8
 |  |  | 1 [NAME] | 0.966 | 3
 |  | Lunch | Food Item | Cost | Daily Points
 |  |  | 1 English Muffin | 0.28 | 3
 |  |  | 20 Gram TJ Tureky | 0.42
 |  |  | 20 gram Brie | 0.16 | 2.5
 |  |  | 1 WF White Bread | 0
 |  | Dinner | Food Items | Cost | Daily Points
Spreadsheet: 285517d1387674110-excel-2013-finding-the-common-value-repeated-in-each-column-book1
Sheet: Sheet1

4 | 4 | 3 | 2 | 1 | 3 | 4 | 2 | 1 | 4 | 3 | 2 |  |  | 1
4 | 2 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 4 | 2 | 2 |  |  | 2
2 | 3 | 2 | 1 | 3 | 1 | 4 | 3 | 3 | 2 | 4 | 1 |  |  | 3
2 | 1 | 4 | 4 | 2 | 1 | 1 | 3 | 1 | 1 | 3 | 3 |  |  | 4
1 | 1 | 2 | 1 | 1 | 1 | 2 | 4 | 4 | 1 | 4 | 3 |  |  | 5
3 | 3 | 3 | 4 | 2 | 4 | 1 | 2 | 2 | 4 | 1 | 3 |  |  | 6
3 | 3 | 1 | 1 | 1 | 4 | 2 | 1 | 2 | 4 | 3 | 2 |  |  | 7
4 | 2 | 3 | 1 | 3 | 2 | 1 | 1 | 1 | 4 | 2 | 3 |  |  | 8
2 | 3 | 2 | 3 | 3 | 1 | 4 | 2 | 1 | 3 | 1 | 3 |  |  | 9
Spreadsheet: 94a3abf0-ee38-4146-bbf5-a0c3098f818b
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 |  | O90162 | Unnamed: 9 | 90162 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Ordinance Fiscal Note  COMMITTEE SUBSTITUTE FOR |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Appropriating funds in the amount of $120,130.70 from the unappropriated Fund Balance of the Sewer Special
 | [NAME]; authorizing a $234,619.00 contract with Wilson Plumbing Co. for Project No.
 | 89003400, 810000242 NE 88th & N. Lathrop Sanitary Sewer Extension.
Is this ordinance for the following: |  |  |  | x | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  | FY
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please identify source and amount.
 | Source of Funds:
 | Year Funded:
 | Amount of Non-City Funds: |  |  | $
 | If no, please identify source and amount of city funds.
 | Acct #: |  |  |  | 09-3090-898982-B
 | Name of Fund: |  |  |  | Water and Sewer NC2
 | Year Funded: |  |  |  | 2009
 | Amount of City Funds: |  |  | $ | 64520.25
 | Acct #: |  |  |  | AL-8182-807170-B
 | Name of Fund: |  |  |  | Infill Sewer Projects
 | Year Funded: |  |  |  | 2009
 | Amount of City Funds: |  |  | $ | 129040.5
 | Acct #: |  |  |  | AL-3391-808882-B
 | Name of Fund: |  |  |  | Water and Sewer CD2
 | Year Funded: |  |  |  | 2009
 | Amount of City Funds: |  |  | $ | 34389.55
 | Acct #: |  |  |  | 09-3010-808882-B
 | Name of Fund: |  |  |  | Water and Sewer CD2
 | Year Funded: |  |  |  | 2009
 | Amount of City Funds: |  |  | $ | 120130.7
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 540575
 | Estimated lifespan of project in years |  |  |  | 75
 | Estimated annual operating and maintenance costs |  |  | $
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | FY
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 148439d1333401817-output-a-value-based-on-multiple-drop-down-lists-vt_2000_multiple-drop-down-sample_04apr12_01
Sheet: Price Data

Color | Engine | [NAME] | Region |  | PRICE
Red | 4 Cylinder | 1 Year | North |  | 100
Red | 4 Cylinder | 1 Year | South |  | 200
Red | 4 Cylinder | 1 Year | East |  | 300
Red | 4 Cylinder | 1 Year | West |  | 400
Red | 4 Cylinder | 3 Years | North |  | 500
Red | 4 Cylinder | 3 Years | South |  | 600
Red | 4 Cylinder | 3 Years | East |  | 700
Red | 4 Cylinder | 3 Years | West |  | 800
Red | V6 | 1 Year | North |  | 900
Red | V6 | 1 Year | South |  | 1000
Red | V6 | 1 Year | East |  | 1100
Red | V6 | 1 Year | West |  | 1200
Red | V6 | 3 Years | North |  | 1300
Red | V6 | 3 Years | South |  | 1400
Red | V6 | 3 Years | East |  | 1500
Red | V6 | 3 Years | West |  | 1600
Red | V8 | 1 Year | North |  | 1700
Red | V8 | 1 Year | South |  | 1800
Red | V8 | 1 Year | East |  | 1900
Red | V8 | 1 Year | West |  | 2000
Red | V8 | 3 Years | North |  | 2100
Red | V8 | 3 Years | South |  | 2200
Red | V8 | 3 Years | East |  | 2300
Red | V8 | 3 Years | West |  | 2400
Blue | 4 Cylinder | 1 Year | North |  | 2500
Blue | 4 Cylinder | 1 Year | South |  | 2600
Blue | 4 Cylinder | 1 Year | East |  | 2700
Blue | 4 Cylinder | 1 Year | West |  | 2800
Blue | 4 Cylinder | 3 Years | North |  | 2900
Blue | 4 Cylinder | 3 Years | South |  | 3000
Blue | 4 Cylinder | 3 Years | East |  | 3100
Blue | 4 Cylinder | 3 Years | West |  | 3200
Blue | V6 | 1 Year | North |  | 3300
Blue | V6 | 1 Year | South |  | 3400
Blue | V6 | 1 Year | East |  | 3500
Blue | V6 | 1 Year | West |  | 3600
Blue | V6 | 3 Years | North |  | 3700
Blue | V6 | 3 Years | South |  | 3800
Blue | V6 | 3 Years | East |  | 3900
Blue | V6 | 3 Years | West |  | 4000
Blue | V8 | 1 Year | North |  | 4100
Blue | V8 | 1 Year | South |  | 4200
Blue | V8 | 1 Year | East |  | 4300
Blue | V8 | 1 Year | West |  | 4400
Blue | V8 | 3 Years | North |  | 4500
Blue | V8 | 3 Years | South |  | 4600
Blue | V8 | 3 Years | East |  | 4700
Blue | V8 | 3 Years | West |  | 4800
Green | 4 Cylinder | 1 Year | North |  | 4900
Green | 4 Cylinder | 1 Year | South |  | 5000
Green | 4 Cylinder | 1 Year | East |  | 5100
Green | 4 Cylinder | 1 Year | West |  | 5200
Green | 4 Cylinder | 3 Years | North |  | 5300
Green | 4 Cylinder | 3 Years | South |  | 5400
Green | 4 Cylinder | 3 Years | East |  | 5500
Green | 4 Cylinder | 3 Years | West |  | 5600
Green | V6 | 1 Year | North |  | 5700
Green | V6 | 1 Year | South |  | 5800
Green | V6 | 1 Year | East |  | 5900
Green | V6 | 1 Year | West |  | 6000
Green | V6 | 3 Years | North |  | 6100
Green | V6 | 3 Years | South |  | 6200
Green | V6 | 3 Years | East |  | 6300
Green | V6 | 3 Years | West |  | 6400
Green | V8 | 1 Year | North |  | 6500
Green | V8 | 1 Year | South |  | 6600
Green | V8 | 1 Year | East |  | 6700
Green | V8 | 1 Year | West |  | 6800
Green | V8 | 3 Years | North |  | 6900
Green | V8 | 3 Years | South |  | 7000
Green | V8 | 3 Years | East |  | 7100
Green | V8 | 3 Years | West |  | 7200
Spreadsheet: 216511d1361796438-find-data-betwwen-two-dates-find-data-between-2-dates-rev-1-
Sheet: Sheet2

 |  |  |  |  |  | 2012-01-01 00:00:00 |  | COL A | [NAME] | Start_date | End_date
 |  |  |  |  |  | 2012-04-22 00:00:00
Spreadsheet: 49081d1248353171-sumif-issue-book1
Sheet: Sheet1

 |  |  | Customer | Month | Rev
 |  |  | A | 2009-02-01 00:00:00 | 10
 |  |  | A | 2009-02-01 00:00:00 | 20
 |  |  | A | 2009-02-01 00:00:00 | 30
 |  |  | A | 2009-03-01 00:00:00 | 30
 |  |  | A | 2009-03-01 00:00:00 | 20
 |  |  | A | 2009-03-01 00:00:00 | 10
 |  |  | Customer | Rev. Feb 09 | Rev. Mar -09
 |  |  | A
Spreadsheet: 479592d1473437214-if-function-for-a-time-set-as-overtime-excel-help-ot-rates-by-time
Sheet: Schedules

 | # | Start Time | End Time |  | Rate Type | Rate Amount | Total Hours | # | Start Time | End Time |  | Rate Type | Rate Amount | Total Hours
2016-10-01 00:00:00
Staff A | 8 | 08:00:00 | 17:00:00 |  | ST |  |  | 8 | 18:00:00 | 22:00:00 |  | OT
Staff B
Staff C
Spreadsheet: 719642d1613746536-conditional-formatting-programming-performance-targets-etaf-pvt-
Sheet: Results

 |  |  |  |  |  |  |  | PERFORMANCE TARGETS
 |  | TOTAL |  |  | % OF |  |  | [NAME]
 |  | JOBS | ON TIME |  | SCHED |  |  | 0.5 | 0.7 | 0.9
 | 2021-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | I’m sorry etaf, my explanation is rubbish.
 | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | I was hoping not to have to use any manual inputs.
 | 2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Jobs tab U, V, W were only to show my thought process and were to be deleted, I need those col for other data.
 | 2021-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | I was hoping the formulas in Results I4-K15 could;
 | 2021-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Look at Jobs col I, and reference only those dates that match the month in Results H4-H15
 | 2021-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Then look at the corresponding rows for that month in Jobs col T and count the % that match results I3, J3 and K3 respectfully. (50%, 70%, 90%).
 | 2021-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Then if you change, say, [NAME] to 30% then Results K8 would return 1 because of the 13% in Jobs T5, the only item that month below the 30%
 | 2021-05-01 00:00:00
 | 2021-06-01 00:00:00
 | 2021-07-01 00:00:00
 | 2021-08-01 00:00:00
 | 2022-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Added new data with year 2022 and changed the ontime to show different results
 |  |  |  |  |  |  |  |  |  |  |  | 456 123
Spreadsheet: 03e84fa9-a0ea-47fb-9058-05cc1cae3bf6
Sheet: Sheet1

UNIVERSITY OF HAWAI‘I | Unnamed: 1 | Unnamed: 2
CONTINUING EDUCATION ENROLLMENT
SPRING 2014
TABLE OF CONTENTS
Table 1 |  | Continuing Education Enrollment, By [NAME]
 |  | Spring 2014
Table 2 |  | Continuing Education Enrollment, By [NAME]
 |  | Spring 2004 to Spring 2014
Table 3 |  | Continuing Education Enrollment, UH Mānoa
 |  | Spring 2014
Table 4 |  | Continuing Education Enrollment, UH Hilo
 |  | Spring 2014
Table 5 |  | Continuing Education Enrollment, Community Colleges
 |  | Spring 2014
Spreadsheet: 821794d1678898554-split-by-cells-used-how-to-avoid-circular-reference-formula-circ-error-v2
Sheet: Sheet1

This formula works BUT ONLY if I set my options to Enable iterative calcs at 1 iteration
monthly | week1 | week2 | week3 | week4
48.24
This is a set of examples…the formula in columns B to E needs to match this data exactly
monthly | week1 | week2 | week3 | week4
48.24 | 12.06 | 12.06 | 12.06 | 12.06
72.48 | 24.16 |  | 24.16 | 24.16
96.72 |  | 48.36 |  | 48.36
24 |  |  | 24
Spreadsheet: 152113d1335264610-linking-a-monthly-total-to-the-last-date-of-each-month-payments-in
Sheet: Sheet2

 | Supplies | Windows
 | Payments In | Payments Collected
2012-04-23 00:00:00 | 11700
 |  |  | Supplies | Windows
 |  |  | Monthly Total | Monthly Total
 |  |  | Supplies | Windows
 |  |  | Monthly Total | Monthly Total
 |  |  | WINDOWS | DOORS
 |  |  | Monthly Output | Monthly Output
 |  |  | WINDOWS | DOORS
 |  |  | Monthly Output | Monthly Output
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: RGarvey

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 51fcb3d9-04d8-441a-af69-6172a9a97adb
Sheet: Wages

 | This sheet shows the CAA's analysis of staff cost efficiency based on the IDS report and employment cost benchmarking.
 | [NAME] - wage efficiency
 |  |  |  |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year
 |  |  |  |  | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Staff costs from aBP (cross check)
 | January 2013 FBP Forecast |  |  |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year
 | Man Years |  |  |  | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Security |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Operations |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Facilities |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Commercial |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Rail |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Central Support |  |  |  | " | " | " | " | " | " | " | " | " | " | " |  | " | " | "
 | Total
 | Cost per staff
 | Staff Total Index (2011/12 =1)
 | £m 2011/12
 | Regulatory Staff Costs (Forecasts)
 | Statutory Staff Costs (Forecasts)
 | Diff
 | ABP Wage Efficiency |  |  |  |  |  |  |  |  |  | " | " | " | " | " |  | " | " | "
 |  | Level of inefficiency (IDS)
 | IDS Low [NAME] | 0.1 |  |  |  |  |  |  |  |  | -18.23751339764201 | -17.35719185423365 | -16.25950696677385 | -15.62915326902465 | -15.4552625937835 |  | -82.93862808145767 | na | -16.58772561629153
 | CAA Selection within range | 0.145 |  |  |  |  |  |  |  |  | -28.96439442658092 | -27.68792818863879 | -26.09628510182208 | -25.18227224008574 | -24.93013076098606 |  | -132.8610107181136 | na | -26.57220214362271
 | IDS High Benchmark | 0.21 |  |  |  |  |  |  |  |  | -44.45877813504823 | -42.61010289389067 | -40.30496463022508 | -38.98122186495176 | -38.61605144694533 |  | -204.9711189710611 | na | -40.99422379421221
 | Net Wage Growth
 | Mid point staff costs
 | Impact of net wage growth |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | na
 | Impact of nominal wage freeze
 |  |  |  |  |  | Q5 |  |  |  |  | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year | %dif
 |  |  |  |  |  | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Year: |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Inflation Assumption based on OBR |  |  | Average
 |  |  |  |  | Price Base: |  |  | 1
 | £m 2011/12
 | HAL - staff costs
 | End
Spreadsheet: 93529d1293103053-printing-vlookup-results-into-text-w-o-formula-vlooksample
Sheet: Sheet1

product: | inventory quantity |  | date | current quantity | item sold |  |  | date | current quantity | item sold
a | 5 |  | 2010-12-22 00:00:00 |  | a |  |  | 2010-12-22 00:00:00 | 5 | a
b | 10 |  | 2010-12-23 00:00:00 |  | b |  |  | 2010-12-23 00:00:00 | 10 | b
 |  |  | 2010-12-24 00:00:00 |  | a |  |  | 2010-12-24 00:00:00 | 4 | a
 |  |  | 2010-12-25 00:00:00 |  | b |  |  | 2010-12-25 00:00:00 | 9 | b
 |  |  |  | ^ this is how it is now |  |  |  |  | ^ this is how I want it
Spreadsheet: 051744b0-553e-42c0-a325-873c61c184e6
Sheet: Sheet1

 | Reflective Sales Tool:  Growth with 3M™ Scotchlite™ [NAME]
 |  | Target Audience for Tool:  Distributor Sales Rep to Small Sign Shop
 |  | Sign Shop Value of “Designing-In” & “Up-Selling” to reflective
 |  | films (focus on small business company names, logos, websites, phone
 |  | numbers, and accents on vehicles):
 |  | Helpful tip:  Use shop vehicles to promote reflective too!
 |  | Revenue Example 1 (Sqft foot based opaque vs. reflective):
 |  | 85 | Est. Sqft of Opaque Film per week
 |  | 6 | Est. Value of Opaque Film Job per sqft
 |  |  | Est. Opaque Revenue per week
 |  |  | Est. Annual Revenue from Opaque Jobs (Assume 50 weeks)
 |  | 0.33 | % of weekly opaque sqft "[NAME]" to Reflective
 |  |  | Est. # of sqft up-sold to reflective per week
 |  |  | Est. Value of Reflective Film Job per sqft
 |  |  | Est. Incremental Revenue per sqft
 |  |  | Est. Incremental Annual Reflective Revenue
 |  |  | Annual % Revenue Growth on historical opaque business
 |  | Revenue Example 2 (Annual Shop Revenue opaque vs. reflective):
 |  | 250000 | Sign Shop Vinyl Film Graphics Revenue (Base)
 |  | 0.1 | % of Graphic Revenue from opaque vinyl letters or designs
 |  |  | Opaque Vinyl Letters and Designs Revenue
 |  |  | Opaque vs. Reflective Sales Multiple Effect ($13.50/sqft vs. $6.00/sqft)
 |  |  | New Value of Opaque Vinyl to Reflective
 |  |  | Incremental Reflective Revenue
 |  |  | New Annual Sign Shop Vinyl Film Revenue
 |  |  | Annual % Revenue Growth on total shop vinyl business
 |  | Why 3M Reflective?
 |  | ▪Excellent Cutting & Weeding - Less Rework
 |  | ▪Removability with heat and/or chemical - No damage to customer's substrates
 |  | ▪Desirable initial tack - Ease of installation
 |  | ▪Robust product performance
 |  | ▪Published warranty backed with best in class weathering technology
 |  | Remind end-user customers that reflective graphics offer:
 |  | ▪Cost-effective advertising with 24/7 visibility.
 |  | ▪Improved safety through better vehicle visibility - night & low visibility situations
 |  | ▪Increased brand awareness (with 40 percent more impressions, annually)*
 |  | *American Trucking Association
Spreadsheet: 837910d1690493615-need-help-with-index-match-formula-sample46
Sheet: Sheet1

 |  |  | Today's Date
 |  |  | CAT1
 |  |  | CAT2
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  | CAT1 |  |  |  |  |  | 156 | 154
 |  |  | CAT2 |  |  |  |  |  | 959 | 159
 |  |  | CAT3 |  |  |  |  |  | 257 | 328
 |  |  | CAT4 |  |  |  |  |  | 2588 | 258
 |  |  | CAT5 |  |  |  |  |  | 144 | 258
 |  |  | [NAME] |  |  |  |  |  | 287 | 154