tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865256d1712306021-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy-1-aligw
Sheet: Proposed Analysis - PI

POTENIAL PROPERTY ANALYSIS
 | MINIMUM INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | Proposed Property Address: |  |  |  |  |  | Enter the address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSW
 |  | Proposed Purchase Price: |  |  |  |  |  | 600000 |  |  |  |  |  | State: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  | Proposed Loan Amount: |  |  |  |  |  | 540000 |  |  |  |  |  | Proposed LVR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 |  | Proposed Rental Amount: |  |  |  |  |  | 550 |  | Per Week
 | OPTIONIAL INPUTS
 |  | Capital Growth Rate: |  |  |  |  |  | 0.06 |  |  |  | Consumer Price Index: |  |  |  |  |  | 0.03
 |  |  |  | Property Expenses: |  |  |  |  |  |  |  |  |  | Loan Interest Rate: |  |  |  | 0.065
 |  |  |  |  |  | [NAME]: |  | Interest Only Repayments
 | STATISTICS
 |  | Today |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7 |  | Year 8 |  | Year 9 |  | Year 10
 | Property Value:
 | Equity In Property:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Done for you.
 | Property Growth %: | 0
 | LVR:
 | Loan Balance: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E46 is the figure coming from sheet4 Cell E19  Cell [NAME] is the figure coming from sheet4 Cell E31 And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | Surplus to reinvest:
 | Purchase Power: | 0
 | Rental Income:
 | [NAME] Yield:
 | Net Rental Yield:
 | DEDUCTIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E64 is the figure coming from sheet4 Cell C19  Cell G64 is the figure coming from sheet4 Cell C31 And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | Property Expenses:
 | Loan Interest Payments:
 | Loan P & I Payments:
 | Pre-Tax Cashflow p/a:
 | Pre-Tax cashflow p/w:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E66 is the figure coming from sheet4 Cell [NAME]  Cell G66 is the figure coming from sheet4 Cell [NAME] And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | NON - CASH DEDUCTIONS
 | Depreciation:
 | FINAL ANALYSIS
 | Total Deductions:
 | Net Profit or Loss:
 | Tax Refund:
 | Land Tax:
 | After-Tax Cashflow p/a:
 | After-Tax cashflow p/w:
Spreadsheet: 116311d1311743083-excel-2007-countifs-to-gather-data-from-multiple-sheets-based-on-multiple-criteria-ratings-of-surveys
Sheet: HR Service Delivery Survey

 | RECRUITMENT FEEDBACK SURVEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Acceptable
 | HR POC NAME | Date of Submission | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18 | Q19 | Q20 | [NAME] | Q22 | Remarks- for open ended data |  | 1
 | [NAME] |  | 1 | 5 | 2 | 4 | 5 | 3 | 1 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs Improvement
 | [NAME] |  | 4 | 5 | 2 | 4 | 5 | 3 | 1 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | [NAME] |  | 3 | 5 | 1 | 4 | 5 | 3 | 1 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meets Expectations
 | [NAME] |  | 2 | 5 | 4 | 4 | 5 | 3 | 1 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | [NAME] |  | 1 | 5 | 3 | 4 | 5 | 3 | 1 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exceeds Expectations
 | [NAME] |  | 1 | 5 | 3 | 4 | 5 | 3 | 1 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | [NAME] |  | 1 | 3 | 3 | 4 | 5 | 3 | 1 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Well Above Expectations
 | [NAME] |  | 1 | 4 | 3 | 4 | 5 | 3 | 1 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 827394d1682667434-how-to-make-a-consensus-list-consensus1-aligw
Sheet: Sheet1

Player # |  | Class | Strength | Experience | [NAME] |  |  | Player # | Order |  | AliGW:
1 |  | 2 | 11 | 6 | 10 |  |  | 11 | 1 |  |  | 1 |  |  | 1
2 |  | 6 | 2 | 12 | 11 |  |  | 2 | 2 |  | 2 | 2 |  | 2 | 2
3 |  | 11 | 10 | 4 | 1 |  |  | 6 | 2 |  | 6 | 2 |  | 6 | 2
4 |  |  | 12 |  |  |  |  | 10 | 2 |  | 10 | 2 |  | 10 | 2
5 |  |  |  |  |  |  |  | 12 | 2 |  | 12 | 2 |  | 12 | 2
6
7
8
9
10
11
12
13
Spreadsheet: 23ef793f-84d3-4481-b085-86662f25116d
Sheet: SpecBuild

School District |  |  | District Code |  |  | * Round to Nearest Dollar *
Fund 42:  SPECIAL BUILDING AND TECHNOLOGY FUND
 |  |  | Prior Year Actual - Audited FY11-12 | Current Fiscal Year - Budgeted FY12-13 | Current Fiscal Year - Projected FY12-13 | Original Ensuing Fiscal Year - Budget FY13-14 | Adjustments Ensuing Fiscal Year - Budget FY13-14 | Revised Ensuing Fiscal Year - Budget FY13-14
 |  |  |  |  |  |  | Record Inceases to revenue are positive amounts and Decreases as negatives | Figures (Totals) which will appear on Budget Form to Submit to CDE
Codes: | BEGINNING FUND BALANCE |  | 0 | 0 | 0 | 0 | 0
Source |  | REVENUE AND OTHER SOURCES
1110 | 1. | Current Property Taxes | 0 | 0 | 0 | 0 | 0
1120 | 2. | Specific Ownership Taxes | 0 | 0 | 0 | 0 | 0
1140 | 3. | Delinquent Taxes and Penalties | 0 | 0 | 0 | 0 | 0
1500 | 4. | Earnings on Investments | 0 | 0 | 0 | 0 | 0
52XX | 5. | Transfer From________________Fund(s) (Net to zero across all funds)* | 0 | 0 | 0 | 0 | 0
 | 6. | Other Revenue | 0 | 0 | 0 | 0 | 0
 | 7. | TOTAL REVENUE (Sum of lines 1-6)
TOTAL REVENUE INCLUDING BEGINNING FUND BALANCE (Sum of line 7 and BFB)
Object |  | EXPENDITURES AND OTHER USES
0100-0299 | 8. | Salaries and Benefits for Services Provided By District Personnel | 0 | 0 | 0 | 0 | 0
0300-0599 | 9. | Purchased Services (Work Done By Outside Contractors) | 0 | 0 | 0 | 0 | 0
0600-0699 | 10. | Supplies | 0 | 0 | 0 | 0 | 0
0710-0719 | 11. | Land and Improvements | 0 | 0 | 0 | 0 | 0
0720-0729 | 12. | Buildings | 0 | 0 | 0 | 0 | 0
0730-0739 | 13. | Equipment | 0 | 0 | 0 | 0 | 0
0740-0799 | 14. | Other Property | 0 | 0 | 0 | 0 | 0
0800-0999 | 15. | Other Objects and Uses | 0 | 0 | 0 | 0 | 0
 | 16. | TOTAL EXPENDITURES AND OTHER SOURCES (Sum of lines 8 - 15)
Program |  | APPROPRIATED RESERVES
9100 | 17. | Operating Reserve | 0 | 0 | 0 | 0 | 0
9321 | 18. | TABOR Emergency Reserve | 0 | 0 | 0 | 0 | 0
9322 | 19. | Reserve for Multi-Year Obligations | 0 | 0 | 0 | 0 | 0
932X | 20. | Other Restricted Reserves | 0 | 0 | 0 | 0 | 0
9900 | 21. | Other Reserves | 0 | 0 | 0 | 0 | 0
 | 22. | TOTAL APPROPRIATED RESERVES (Sum of 17 - 21)
TOTAL SPECIAL BUILDING AND TECHNOLOGY FUND EXPENDITURES AND APPROPRIATED RESERVES (Sum of lines 16 & 22)
 |  | ---MUST EQUAL AMOUNT ON APPROPRIATION RESOLUTION PAGE---
 |  | TOTAL NET REVENUE
 |  | DIFFERENCE MUST EQUAL 0
*State Statute prohibits the transfer of funds out of the Special Building and Technology Fund.
Spreadsheet: 684217d1593194693-abc-on-unsorted-data-abc_unsorted
Sheet: Summery

Product | Category | Sales Value ($) | % Sales | Grade
A-1 | A | 69
A-2 | A | 149
A-20 | A | 398
A-126 | A | 209
A-141 | A | 249
A-364 | A | 447
A-365 | A | 298
A-375 | A | 398
A-527 | A | 349
B-696 | B | 369
B-702 | B | 379
B-729 | B | 69
B-744 | B | 398
B-775 | B | 399
B-865 | B | 418
B-869 | B | 439
[NAME] | B | 69
B-873 | B | 448
Spreadsheet: sally_beck__35041__MgmtSum-Q2-0501
Sheet: Summary YTD-Qtr

 |  |  | ACTUAL | PLAN2000 | 2000-03-01 00:00:00 |  | PLAN2000 | PLAN2000 | 2000-06-01 00:00:00 |  | PLAN2000 | PLAN2000 | 2000-09-01 00:00:00 |  | PLAN2000 | PLAN2000 | 2000-12-01 00:00:00
PRETAX_INCOME | ENRON NORTH AMERICA
Q.QTD | 2ND QUARTER 2000 EARNINGS ESTIMATE
ENA | [NAME] through Q2
 |  |  | 1Q |  |  |  | 2Q |  |  |  | 3Q |  |  |  | 4Q |  |  |  | Total
 | Business Team |  | Actual | Plan | [NAME] |  | Estimate | Plan | [NAME] |  | Plan | Plan | [NAME] |  | Plan | Plan | [NAME] |  | Estimate | Plan | [NAME]
[NAME] | Gas Trading
PWR_TRd | Power Trading
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
CANADA | Canada
COAL | Coal
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products
EXEC_TRD | Executive Trading
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
PAPER | Industrial Downstream - Paper
CHEMICALS | Industrial Downstream - Chemicals
MDSTRM_IPP_ORIG | Midstream IPP |  | 0
MEXICO | Mexico
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments
ASST_ORIG | Gas Assets
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing
PROD_FIN | Energy Investments
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group
TREASURY_INT | Other Interest Related Charges
TREASURY_INT | Capital Charge Offset
OF_CHAIR | Overview
 | ENA EBIT
 | Interest (Expense)/Income |  | -1000 | -12000 |  |  |  | -8600 |  |  |  | -18900 |  |  |  | -17500
 | [NAME]
Spreadsheet: 753648d1635605879-30-day-moving-total-starting-with-today-sample_data-a
Sheet: summary (2)

report run on | 2021-10-26 00:00:00
 | # Reports | # Work | %
This Week
Last Week
This Month
30day Moving average
This Quarter
Last Quarter
This Year
Last Year
2 Years Ago
Project Total
Spreadsheet: 821727d1678876580-fraction-number-into-percentage-percentage
Sheet: Sheet1

50/50 | 42/42 | 45/50 | 42/52
42/50 | 42/42 | 33/50 | 44/52
34/50 | 36/42 | 38/50 | 30/52
36/42 | 33/42 | 0 | 0
4/4 | 40/42 | 46/50 | 34/52
Spreadsheet: michelle_lokay__26823__sharris1000wk1
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-10-06 10:28:51.040000
 |  | September, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
 |  | .
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.8361679908999999 | 0.06296799090000005 |  | Higher volumes than in plan.
East Demand Revenues |  | 1.1254 | 1.0849816046 | -0.04041839540000014 |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.1709 | 0.15106711032 | -0.01983288967999999 |  | Lower East IT Rates
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1636521197 | 0.1047521197 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 13.04978011552 | 0.4115801155199961
[NAME] due to Price |  |  |  | 0.9727377102088747 |  | Current index price of $5.15
[NAME] due to net fuel retention. |  |  |  | -0.157155603185528
Hedging Adjustment |  |  |  | -0.1255500000000002
Unaccounted for Variance |  |  |  | -0.021
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.6690321070233465
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 1.080612222543343
 |  |  |  | ========
Resolution of El Paso Fuel Dispute |  |  |  | 3.0074
 |  |  |  | -------------
Adjusted Month-to-Date Variance |  |  |  | 4.088012222543343
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through September) |  | 122.2891 | 17.1504 | 139.4395
Actuals through August with Sept. Wkly. |  | 123.62738011552 | 22.35494115790635 | 145.9823212734263
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 1.338280115519979 | 5.204541157906341 | 6.54282127342632
 |  | ------------- | ------------- | -------------
Resolution of El Paso Fuel Dispute (Booked in Oct.,NOT Sept.) |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 9.54282127342632
 |  |  |  | ========
Spreadsheet: 85976d1285953186-creating-a-formula-that-uses-text-in-another-cell-cash-deposits-and-orders-sample-2-
Sheet: 09-14-10

CASH ORDER
Denomination |  | 2010-09-14 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 3611100 |  | 1740100
20 |  | 5040460 |  | 882560
10 |  | 145690 | 32530 | 0
5 |  | 702990 |  | 256630
1 |  | 190379 |  | 55462
0.25 |  | 17782 | 10262 | 0 |  |  | 5000
0.05 |  | 7698 | 1043 | 0
0.01 |  | 1310 | 366 | 0
Total
Spreadsheet: 178857d1346940854-how-to-transpose-columns-into-rows-table-1-
Sheet: Sheet4

Borrower ID | Loan ID | Recovery 1006-1106 | Payment 3Q 2011 | Payment 4Q 2011 | Payment 1Q 2012 | Payment 2Q 2012
6440 | 6440015 | 0 | 0 | 4570.944666666668 | 5645.580753333328 | 2936.252980000001
6440 | 6440090 | 1910.7579 | 0 | 0 | 0 | 0
6492 | 6492018 | 2348.048183333333 | 0 | 0 | 0 | 0
Borrower ID | Loan ID | Payment | Period
6440 | 6440015 | 0 | 1006-1106 |  |  | Sum of Payment |  | Period
6440 | 6440015 | 0 | 3Q 2011 |  |  | Borrower ID | Loan ID | 1006-1106 | 1Q 2012 | 2Q 2012 | 3Q 2011 | 4Q 2011
6440 | 6440015 | 4570.944666666668 | 4Q 2011 |  |  | 6440 | 6440015 | 0 | 5645.580753333328 | 2936.252980000001 | 0 | 4570.944666666668
6440 | 6440015 | 5645.580753333328 | 1Q 2012 |  |  |  | 6440090 | 1910.7579 | 0 | 0 | 0 | 0
6440 | 6440015 | 2936.252980000001 | 2Q 2012 |  |  | 6492 | 6492018 | 2348.048183333333 | 0 | 0 | 0 | 0
6440 | 6440090 | 1910.7579 | 1006-1106
6440 | 6440090 | 0 | 3Q 2011
6440 | 6440090 | 0 | 4Q 2011
6440 | 6440090 | 0 | 1Q 2012
6440 | 6440090 | 0 | 2Q 2012
6492 | 6492018 | 2348.048183333333 | 1006-1106
6492 | 6492018 | 0 | 3Q 2011
6492 | 6492018 | 0 | 4Q 2011
6492 | 6492018 | 0 | 1Q 2012
6492 | 6492018 | 0 | 2Q 2012
Spreadsheet: ee22c8e4-4830-4530-a003-c7ee4fcda813
Sheet: Sheet1

Providence Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2014-04-23 | 1 | Springfield | 3 | Providence | 2 | Final OT | Dunkin' Donuts Center Providence, RI
2014-04-25 | 2 | Providence | 2 | Springfield | 1 | Final OT | [NAME], MA
2014-04-26 | 3 | Providence | 2 | Springfield | 3 | Final | [NAME], MA
2014-04-29 | 4 | Springfield | 3 | Providence | 6 | Final | Dunkin' Donuts Center Providence, RI
2014-05-03 | 5 | Providence | 6 | Springfield | 3 | Final | [NAME], MA
2014-05-09 | 1 | Providence | 4 | W-B/Scranton | 0 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2014-05-10 | 2 | Providence | 1 | W-B/Scranton | 6 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2014-05-14 | 3 | W-B/Scranton | 5 | Providence | 4 | Final OT | Dunkin' Donuts Center Providence, RI
2014-05-16 | 4 | W-B/Scranton | 2 | Providence | 3 | Final OT | Dunkin' Donuts Center Providence, RI
2014-05-17 | 5 | W-B/Scranton | 3 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2014-05-19 | 6 | Providence | 4 | W-B/Scranton | 1 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2014-05-21 | 7 | Providence | 4 | W-B/Scranton | 5 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
Spreadsheet: 673789d1587541646-look-up-a-list-of-client-purchases-with-dates-client-purchases-with-dates-tora-v1-
Sheet: Sheet1

Client | Item | Date
Client A | Book 2 | 2017-05-05 00:00:00
Client A | Book 5 | 2018-06-01 00:00:00
Client A | Book 6 | 2018-08-08 00:00:00
Client A | Book 9 | 2019-09-25 00:00:00
Client B | Book 1 | 2016-02-01 00:00:00
Client B | Book 3 | 2017-08-22 00:00:00
Client B | Book 7 | 2019-10-09 00:00:00
Client C | Book 4 | 2016-02-22 00:00:00
Client C | Book 11 | 2019-03-02 00:00:00
Client C | Book 12 | 2020-01-05 00:00:00
Client D | Book 2 | 2015-11-10 00:00:00
Client D | Book 6 | 2018-04-08 00:00:00
Client D | Book 9 | 2019-01-27 00:00:00
Client D | Book 10 | 2020-03-12 00:00:00
Client E | Book 11 | 2018-08-12 00:00:00
Client E | Book 12 | 2018-09-22 00:00:00
Spreadsheet: 795036d1662473770-how-to-count-a-cell-based-on-a-year-written-on-another-cell-sample
Sheet: Sheet1

Approval | Carmen | [NAME] | [NAME] | [NAME] |  | Positive answer in 2022 and over+blank
2021-12-28 00:00:00 | N/A | SIM | N/A | N/A
 | SIM | SIM | N/A | N/A |  | Positive answer in 2022 and over+blank (Formula)
2021-08-30 00:00:00 | N/A | N/A | N/A | SIM |  | =COUNTIFS(D3:G14; "[NAME]:C14;">31/12/2021")
2021-08-30 00:00:00 | N/A | N/A | N/A | SIM
2021-08-30 00:00:00 | N/A | N/A | N/A | SIM
2022-06-01 00:00:00 | N/A | SIM | N/A | N/A
2021-09-09 00:00:00 | N/A | N/A | N/A | N/A
2021-09-09 00:00:00 | N/A | N/A | N/A | N/A
2021-09-13 00:00:00 | N/A | N/A | SIM | N/A
2022-06-01 00:00:00 | SIM | N/A | SIM | N/A
2021-12-29 00:00:00 | N/A | N/A | SIM | SIM
2021-09-09 00:00:00 | SIM | N/A | SIM | N/A
Spreadsheet: 37810d1235840276-how-do-i-link-cell-contents-across-worksheets-example-1-
Sheet: PC THREE

 | LAST REVIEWED BY: | BOB
 | 2009-02-28 00:00:00 | PC NUMBER 3 |  | INTERNAL USE ONLY
 | COMPONENT | [NAME] |  | SUPPLIER | SKU | COST
 | PROCESSOR | INTEL PROCESSOR |  | IM | 1234 | 1
 | MOTHERBOARD | ASUS MOTHERBOARD |  | IM | 514 | 2
 | PROCESSOR COOLING | STANDARD PROCESSOR COOLING |  | X | 561651 | 4
 | PC CHASSIS | BLACK PC CHASSIS |  | EN | 51 | 5
 | RAM MEMORY | 2GB RAM MEMORY |  | EN | 51 | 5
 | HARD DRIVE | 160G HARD DRIVE |  | IM | 5185 | 7
 | GRAPHICS | ONBOARD GRAPHICS |  | X | 1851 | 8
 | WIRELESS | INBUILT WIRELESS |  | X | 651 | 9
 | ADDITIONAL PORTS | ADDITIONAL PORTS |  | X | 891 | 10
 | OPERATING SYSTEM | VISTA OPERATING SYSTEM |  | IM | 65 | 11
 | DISPLAY | 19-INCH DISPLAY |  | EN | 89 | 12
 | OPTICAL DRIVE 1 | DVD-RWWRITER |  | IM | 156 | 13
 | OPTICAL DRIVE 2 | DVD-RWWRITER |  |  | 418 | 14
 | 3.5" FLOPPY DRIVE | 3.5" FLOPPY DRIVE |  | X | 18 | 15
 | DIGITAL CARD READER | 20-IN-1 DIGITAL CARD READER |  | EN | 16518 | 16
 | SOUND CARD | ONBOARD SOUND CARD |  | X | 1 | 17
 | POWER SUPPLY | 500W POWER SUPPLY |  | X | 185 | 18
 | ALL PRICING IS GUARANTEED FOR 7 DAYS FROM THE DATE SHOWN |  |  | X | X | 19
 | TOTAL (INC.VAT) | 1000 |  |  | TOTAL COST | 186
 | TOTAL (EXC.VAT) | 869.5652173913044 |  |  | TOTAL COST + VAT | 213.9
 |  |  |  |  | PROFIT | 683.5652173913044
 |  |  |  |  | MARGIN | 78.61 | %
 |  |  |  |  | SYSPRICE | 869.5652173913043
Spreadsheet: phillip_m_love__30536__Amend_Aruba_Supply
Sheet: NorthShore

NorthShore Price and Basis Trigger
Amending Aruba Supply Contract
As of August 2, 2001
 | Northshore's |  | NorthShore | Deal | NorthShore | Deal
Date | Volume | Period | Fixed Price | Ticket | Fixed Basis | Ticket
2001-04-26 00:00:00 | 1250 | 2001-05-01 00:00:00 | 4.999 | V59258.9 - .10
2001-04-26 00:00:00 | 1250 | Jun 01 - Oct 02 | 4.999 | V59258.2 - .6 | 0.125 | V59258.2 - .6
2001-04-26 00:00:00 | 1250 | 2001-05-01 00:00:00 | 4.97 | V59258.11 - .12
2001-04-26 00:00:00 | 1250 | Jun 01 - Oct 02 | 4.97 | V59258.4 - .8 | 0.125 | V59258.4 - .8
2001-04-27 00:00:00 | 1250 | Jun 01 - Oct 02 | 4.93 | V63990.3 - .5 | 0.135 | V63990.3 - .5
2001-04-30 00:00:00 | 1250 | Jun 01 - Oct 02 | 4.83 | V67692.3 - .4 | 0.125 | V67692.3 - .4
2001-05-08 00:00:00 | 1250 | Jun 01 - Oct 02 | 4.48 | V82405.1 - .3 | 0.125 | V82405.1 - .3
2001-05-09 00:00:00 | 2500 | Jun 01 - Oct 02 | 4.42 | V82405.6 - .8
2001-05-11 00:00:00 | 1250 | Jun 01 - Oct 02 |  |  | 0.135 | [NAME] | Killed on 5-16 added to V63990.3 - .5 on 5-16
2001-05-16 00:00:00 | 5000 | Jun 01 - Mar 02 | 4.68 | V82405.15 - .17 | 0.12 | V82405.15 - .17
2001-05-18 00:00:00 | 5000 | Apr 02 - Oct 02 |  |  | 0.12 | V82405.19 - .20
2001-05-29 00:00:00 | 2500 | Nov 01 - Mar 02 | 4.385 | V82405.22 - .24 | 0.12 | V82405.24
2001-06-06 00:00:00 | 1250 | Nov 01 - Mar 02 | 4.325 | V82405.25 - .27 | 0.125 | VK6281.18
2001-06-13 00:00:00 | 2500 | Nov 01 - Mar 02 | 4.7 | V82405.28 - .30 | 0.125 | VK6281.28
2000-06-20 00:00:00 | 2500 | Nov 01 - Mar 02 | 4.33 | V82405.31 - .33 | 0.12 | V82405.31 - .33
2000-06-27 00:00:00 | 1250 | Nov 01 - Mar 02 | 4 | VK6281.2 - .4 | 0.1075 | VK6281.21
2000-06-29 00:00:00 | 2500 | Aug 01 - Oct 01 | 3.19 | VK6281.7
2001-07-12 00:00:00 | 1250 | Aug 01 - Oct 01 | 3.505 | VK6281.9
2001-07-12 00:00:00 | 1250 | Nov 01 - Mar 02 | 4 | VK6281.11
2001-07-20 00:00:00 | 1250 | Nov 01 - Mar 02 | 3.56 | VK6281.25 - .26
2001-07-31 00:00:00 | 5000 | 2001-10-01 00:00:00 | 3.38 | VS8407.2 - .4
2001-07-31 00:00:00 | 1250 | Nov 01 - Mar 02 | 3.83 | VS8407.2 - .4
2001-07-31 00:00:00 | 5000 | 2002-04-01 00:00:00 | 3.635 | VS8407.2 - .4
2001-08-01 00:00:00 | 5000 | 2001-10-01 00:00:00 | 3.3 | VS8407.5 - .7
2001-08-01 00:00:00 | 1250 | Nov 01 - Mar 02 | 3.73 | VS8407.5 - .7
2001-08-01 00:00:00 | 5000 | 2002-04-01 00:00:00 | 3.5 | VS8407.5 - .7
2001-08-22 00:00:00 | 5000 | Apr 02 - Oct 02 | 3.58 | VS8407.20 - .21
2001-08-23 00:00:00 | 10000 | 2001-10-01 00:00:00 |  |  | 0.015 | VY1883.1 - .2
2001-08-23 00:00:00 | 10000 | Nov 01 - Mar 02 |  |  | 0.1175 | VY1883.1 - .2
2001-08-29 00:00:00 | 5000 | Apr 02 - Oct 02 | 3.17 | VY1883.9 - .10
P: Trading/Daily Misc/Amend_Aruba_Supply
Spreadsheet: 682409d1592071295-cell-value-dependent-on-tablename-within-a-cell-shift-pattern-calculator-katemaz-
Sheet: Shift Pattern Calculator

Name
What date would you like to begin the rota? |  |  |  |  |  |  |  |  |  | DD/MM/YYYY |  |  |  |  |  |  |  |  | Actual Name | Table Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit 1 | pattern1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit 2 | Pattern2
Which week number of the below do you plan to start the pattern on?
 |  |  |  |  |  | Unit 1
 |  | Days
Week No. |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
1 | Shift times
 | Meal break
 | Paid Hours
2 | Shift times
 | Paid Hours
3 | Shift times
 | Paid Hours
4 | Shift times
 | Paid Hours
5 | Shift times
 | Paid Hours
6 | Shift times
 | Paid Hours
7 | Shift times
 | Paid Hours
8 | Shift times
 | Paid Hours
9 | Shift times
 | Paid Hours
10 | Shift times
 | Paid Hours
Spreadsheet: 115437d1311056404-budget-calc-help-2011budget
Sheet: July

2011 Budget
Payday |  |  |  |  | Amount
1st |  |  |  |  | 0
15th
Total Monthly
Expenses |  | Product |  |  | Amount |  | Paid? | Remainder
1st |  | Ring |  |  | 100 |  | False
 |  | Easynews |  |  | 15 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Verizon |  |  | 100 |  | False
 |  | Bi-Weekly Remainder
15th |  | Chase |  |  | 54 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Insurance |  |  | 120 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Bi-Weekly Remainder
Total Monthly
Total Remainder
Spreadsheet: 177643d1346372319-creating-file-to-track-productivity-vs-goal-productivity-vs-goal
Sheet: Sheet1

I have 30 clients, with packs ranging from a count of 9 to 400.  I would like to be able to 1) know that I am meeting the goal or if ahead by how much; 2) know if I am behind goal  and by how much; 3) I would need to monitor by volume by due dates.  While we have Mon-Fri work week, I will need to work in Sat and Sun packs.  I would like to create this as a dashboard so that I can view not only numbers but graphically.  Each worker is expected to produce 25 count per hour.  I am using Excel 2003.
Client |  | Prdn Goal | Actual | % of Goal | Working Date | Due Date
 | Mon | 150 | 125 |  | 2012-08-31 00:00:00 | 2012-08-28 00:00:00
 | Tue | 200 | 155
 | Wed | 150 | 165 |  | 2012-08-31 00:00:00 | 2012-09-01 00:00:00
 | Thu
 | Fri
 | Sat
 | Sun
Client |  | Prdn Goal | Actual | % of Goal
 | Mon
 | Tue
 | Wed
 | Thu
 | Fri
 | Sat
 | Sun
Spreadsheet: 34247d1231408722-consolidate-data-from-multiple-worksheets-example_2
Sheet: Complete Site List

Alphanumeric Index | License Holder / Site Operator Name | Site Name | District | OPRA Code | Throughput | [NAME]
 | EQ Waste Management Ltd | [NAME], Potters Crouch | St Albans | A22
 | Reviva Composting Ltd | Woodcock Hill Farm, Elstree | Hertsmere | A22
 | Cumberlow Compost Services Ltd | Cumberlow Green Farm | North Hertfordshire | A23
 | Glaxo Smith Kleine | Stevenage | Stevenage | A18
 | R Beach | [NAME], Bedmond | Three Rivers | A11