tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 346c3b30-51fb-4be2-82d6-37e462978879
Sheet: Conv-Conforming Fixed Rate

 |  | TIB-The Independent BankersBank |  |  |  | .25 cost to Price to Waive Escrows
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-20 09:49:30.780000
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.68 | 102.555 | 102.43 | 102.055
4.5 | 102.647 | 102.522 | 102.397 | 102.022 |  | Note: | Refer To Price [NAME]
4.375 | 101.756 | 101.631 | 101.506 | 101.131 |  |  | For all Price Adjs
4.25 | 101.15 | 101.025 | 100.9 | 100.275
4.125 | 100.303 | 100.178 | 100.053 | 99.428
4 | 99.3 | 99.175 | 99.05 | 98.425
3.875 | 98.258 | 98.133 | 98.008 | 97.383
3.75 | 97.383 | 97.258 | 97.133 | 96.508
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.584 | 102.459 | 102.334 | 101.959
3.625 | 102.19 | 102.065 | 101.94 | 101.565
3.5 | 101.637 | 101.512 | 101.387 | 101.012
3.375 | 100.917 | 100.792 | 100.667 | 100.292
3.25 | 100.18 | 100.055 | 99.93 | 99.305
3.125 | 99.744 | 99.619 | 99.494 | 98.869
3 | 98.994 | 98.869 | 98.744 | 98.119 |  | 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-07-04 09:49:30.780000
30 DAY | 2014-07-19 09:49:30.780000
45 DAY | 2014-08-03 09:49:30.780000
60 DAY | 2014-08-18 09:49:30.780000
90 DAY | 2014-09-17 09:49:30.780000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 2011e01c-aaff-49bc-a1fb-bd39f73cad09
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
OH21 | Test | OH21 | 21-Hydroxylase Antibodies, Serum | 21-Hydroxylase Ab, S | Immunoabsorption Assay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top  Acceptable: Serum gel  Submission Container/Tube: Plastic vial [NAME]: 1 mL | 0.19 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <1 U/mL  Reference values apply to all ages. | Thursday; 2 p.m. | 2 days | 9 days | 1 | 83519 |  |  |  |  | Rochester
OH21 | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
OH21 | Result | 81970 | 21-Hydroxylase Ab, S | 21-Hydroxylase Ab, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 17781-6 | 21-Hydroxylase Ab:ACnc:Pt:Ser:Qn:
Spreadsheet: 3e15523c-5fde-4780-b401-6a8f578411e9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2011-12-01 00:00:00 | 118 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 853270d1703156604-conditional-format-highest-value-in-previous-28-cells-cf-offset-strange-p-and-r
Sheet: TRENDING ANALYSIS (DAY)

 |  |  |  |  | Normal Pay |  |  |  |  |  |  |  |  |  | Standard Overtime |  |  |  |  |  |  |  |  |  | Double Pay
 |  | 1 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | Date | Wash Tech Month Ending | [NAME] |  | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved |  | Date | Wash Tech Month Ending | [NAME] |  | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved |  | Date | Wash Tech Month Ending | [NAME] |  | Expected Booked On | Clean Tech | Clean Man Hours | Items Autoclaved | Expected Autoclaved
 | Day 4
 | Day 3
 | Day 2
 | Day 1 | 2023-11-27 00:00:00 |  |  |  |  |  |  |  |  |  | 2023-12-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2023-12-06 00:00:00
Total
Ratio
Days to count | -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Rates | Normal Pay to | Standard Overtime to | Double Pay to
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Booked on
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Autoclaved
Spreadsheet: 465480d1465686439-excel-solver-lp-help-golf-fantasy
Sheet: Test

 | Name | Cost | [NAME] |  | Name | Salary | AVG PTS
1 |  |  |  |  | Ricky | 12000 | 100
2 |  |  |  |  | [NAME] | 11000 | 90
3 |  |  |  |  | [NAME] | 10000 | 80
4 |  |  |  |  | Jordan | 9000 | 70
5 |  |  |  |  | [NAME] | 8000 | 60
6 |  |  |  |  | [NAME] | 7000 | 72
 | Total |  |  |  | Hayden | 7500 | 84
 |  |  |  |  | [NAME] | 8500 | 34
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: MetaPress

MetaPress
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 price | Price per search
Abstracts in Anthropology
Number of Successful Article Requests | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 653 | N/A
Note: This subscription allows users to search a database, yet MetaPress usage statistics only measure "article requests," not searches.
Thus these numbers mean nothing. They do NOT mean that the resource was not used.
COUNTER-Compliant?: | Yes
Spreadsheet: jeff_dasovich__14046__timbdcf--question2operating
Sheet: Cash Flow, DCF, Ratios

Timberland Co.
Cash Flow and DCF Valuation ($000's)
 | Actual | Actual | Assumptions | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
FISCAL YEAR ENDING | 1991 | 1992
EBIT |  |  | from Income Statement
Less:  Taxes on EBIT
EBI
Add: Depreciation & Amortization | 6304 | 7959 | 0.2
(Inc.) Dec. in Other Assets | 0 | 0 | from [NAME]
Inc. (Dec.) in Def. [NAME] | -3748 | 119 | from [NAME]
(Inc.) Dec. in A/R | -6499 | -6210 | from [NAME]
(Inc.) Dec. in Inventories | 10607 | -13892 | from [NAME]
(Inc.) Dec. in Other C. Assets | 4826 | -6440 | from [NAME]
Inc. (Dec.) in A/P | 5724 | 1841 | from [NAME]
Inc. (Dec.) in Other Accruals | 2326 | 3712 | from [NAME]
CFO (excl. int.)
Less: Capital Expenditures |  |  | To bring net PPE to 11% of sales
FCF (free cash flow)
Terminal Value |  |  | 0
Total Free Cash Flow
PV Factor |  |  | 0.13
PV of cash flow
Total PV of Cash Flows
Less:  debt
Plus:   idle assets (liabilities) | 0
PV of shareholders' equity
[NAME] | 11241
Price per share
Ratio Analysis | 1991 | 1992
Profit Margin |  |  | EBI / Sales
Asset Turnover |  |  | Sales / Avg Assets
Return on Assets (ROA) |  |  | EBI / Avg Assets
I/S Leverage |  |  | Net Income/EBI
B/S Leverage |  |  | Avg Assets / Avg Equity
Return on Average Equity (ROE) |  |  | Net Income/Avg Equity
Spreadsheet: e17dd306-e6bc-4c62-9675-2db0210b5212
Sheet: Sheet1

Supplemental Table 4
Microarray results of transcripts showing greater than 1.5-fold difference in expression between Hb and control
[NAME] |  |  |  | Hb - Downregulated
SYMBOL | fold change | p-value |  | SYMBOL | fold change | p-value
LOC674706 | 1.660330327174664 | 0.036761433 |  | Egr1 | 1.91574711855433 | 5.864097e-06
Nfkbiz | 1.615919979356845 | 0.0010365669 |  | Egr3 | 1.583510739732677 | 0.0011943089
Tatdn2 | 1.608566203998925 | 0.029970722
Tnf | 1.549766125537584 | 0.003954458
Lcn2 | 1.528817485252629 | 0.008721219
Spreadsheet: 15586c2a-0076-487e-bcc9-946cf45b4133
Sheet: Sheet1

ETHNIC GROUP DETAILS OF JOB APPLICANTS FOR 01/04/10 - 31/03/11 - ALL INSTITUTES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
TOTAL NUMBER OF APPLICANTS |  |  |  | 1236
TOTAL NUMBER OF SHORTLISTED |  |  |  | 201
TOTAL POSTS APPOINTED |  |  |  | 61
TOTAL OF UNFILLED POSTS |  |  |  | 3
TOTAL OF UNACCEPTED POSTS |  |  |  | 3
ETHNIC GROUP |  |  | APPLICANTS |  |  | SHORTLISTED |  |  | POSTS OFFERED |  |  | POSTS APPOINTED
 |  |  | M(%) | F(%) | BLANK(%) | M(%) | F(%) | BLANK(%) | M(%) | F(%) | BLANK(%) | M(%) | F(%) | BLANK(%)
Asian or Asian British:
Indian |  |  | 216(17.48) | 124(10.03) | 9(0.73) | 14(6.97) | 4(1.99) | 1(0.5) | 2 | 2 |  | 2(3.28) | 2(3.28)
Pakistani |  |  | 39(3.16) | 16(1.29) | 2(0.16) | 1(0.5) | 1(0.5) |  |  | 1 |  |  | 1(1.64)
[NAME] |  |  | 10(0.81) | 3(0.24) |  | 2(1) |  |  | 2 |  |  | 2(3.28)
Other |  |  | 26(2.1) | 22(1.78) | 2(0.16) | 1(0.5) |  | 1(0.5)
Black & Black British:
Caribbean |  |  | 3(0.24) | 2(0.16)
African |  |  | 14(1.13) | 7(0.57)
Other |  |  | 1(0.08)
Chinese |  |  | 76(6.15) | 44(3.56) | 3(0.24) | 3(1.49) | 4(1.99) |  | 1 | 2 |  | 1(1.64) | 2(3.28)
Mixed:
White & Black Caribbean |  |  | 1(0.08)
White & Black African |  |  | 5(0.4) | 3(0.24)
White & Asian |  |  | 3(0.24)
Other |  |  | 4(0.32) | 7(0.57)
Other Ethnic Group: |  |  | 12(0.97) | 9(0.73) | 3(0.24) | 1(0.5) | 1(0.5) |  | 1 |  |  | 1(1.64)
White:
British |  |  | 130(10.52) | 129(10.44) | 8(0.65) | 42(20.9) | 48(23.88) |  | 12 | 14 |  | 12(19.67) | 13(21.88)
Irish |  |  | 7(0.57) | 8(0.65) |  | 3(1.49) | 1(0.5) |  | 1 |  |  | 1(1.64)
Other |  |  | 117(9.47) | 133(10.76) | 7(0.57) | 27(13.43) | 30(14.92) | 1(0.5) | 9 | 9 |  | 8(13.11) | 9(14.75)
Unknown Ethnic Group |  |  | 6(0.49) | 8(0.64) | 17(1.38) | 2(1) | 6(2.98) | 7(3.48) | 1 | 4 | 3 |  | 4(6.56) | 3(4.91)
TABLE OF NOT ACCEPTED/NOT FILLED POSTS
ETHNIC GROUP |  |  | POSTS NOT FILLED |  |  | POSTS NOT ACCEPTED
 |  |  | M | F | BLANK | M | F | BLANK
White: British |  |  |  | 3 |  |  | 1
White: Other |  |  |  |  |  | 1
Withheld/Unknown |  |  |  |  |  | 1
Spreadsheet: 123469d1317672281-excel-2007-merging-multiple-updated-worksheets-book1-copy
Sheet: customer updated worksheet

Order # | Line # | Order Date | Part # | Qty
1342287 | 1 | 6/15/11 | 41SX399 | 14
1342290 | 1 | 2011-06-15 00:00:00 | 41SX399 | 79
1336146 | 1 | 2011-05-27 00:00:00 | 12505677 | 1
1338850 | 1 | 2011-06-07 00:00:00 | 1804650 | 44
1338850 | 1.1 | 2011-06-07 00:00:00 | 1804650 | 8
1344434 | 1 | 2011-06-21 00:00:00 | 1425260 | 27
1350278 | 1 | 2011-07-08 00:00:00 | 1842280 | 2959
1350934 | 1 | 2011-07-12 00:00:00 | 2239HX | 5100
1352903 | 1 | 2011-07-15 00:00:00 | 69790AX | 4728
1342293 | 1 | 2011-06-15 00:00:00 | 378AX1 | 9801
Spreadsheet: 758619d1638973896-index-match-help-sample-excel
Sheet: Source data

Name | [NAME] | Course Name | Course Number | Started | Finished | Status | Score
Heath Moon | [EMAIL] | Painting | 123 | 2020-12-08 00:00:00 | 2020-12-08 00:00:00 | Complete | 0.5
[NAME] | [EMAIL] | Painting | 123 | 2020-12-09 00:00:00 | 2020-12-09 00:00:00 | Complete | 0.51
[NAME] | [EMAIL] | Painting | 123 | 2020-12-10 00:00:00 | 2020-12-10 00:00:00 | Complete | 0.52
[NAME] | [EMAIL] | Painting | 123 | 2020-12-11 00:00:00 | 2020-12-11 00:00:00 | Complete | 0.53
Heath Moon | [EMAIL] | Running | 321 | 2020-12-12 00:00:00 | 2020-12-12 00:00:00 | Complete | 0.54
[NAME] | [NAME] | Painting | 123 | 2020-12-10 00:00:00 | 2020-12-10 00:00:00 | Complete | 0.52
[NAME] | [EMAIL] | Running | 321 | 2020-12-13 00:00:00 | 2020-12-13 00:00:00 | Complete | 0.55
[NAME] | [EMAIL] | Running | 321 | 2020-12-14 00:00:00 | 2020-12-14 00:00:00 | Complete | 0.56
[NAME] | [EMAIL] | Running | 321 | 2020-12-15 00:00:00 | 2020-12-15 00:00:00 | Complete | 0.57
Heath Moon | [EMAIL] | Weights | 852 | 2020-12-16 00:00:00 | 2020-12-16 00:00:00 | Complete | 0.58
[NAME] | [EMAIL] | Weights | 852 | 2020-12-17 00:00:00 | 2020-12-17 00:00:00 | Complete | 0.59
[NAME] | [EMAIL] | Weights | 852 | 2020-12-18 00:00:00 | 2020-12-18 00:00:00 | Complete | 0.6
[NAME] | [EMAIL] | Weights | 852 | 2020-12-19 00:00:00 | 2020-12-19 00:00:00 | Complete | 0.61
Spreadsheet: 866194d1713171060-conditional-sum-through-many-sheets-new-test
Sheet: TC Debit Note

 | [NAME]
 | Ref no | 5
 | Debit Note Date | 2024-01-01 00:00:00
 | Bank: | Bank 3
 | Commission | 0.0125
 | ON HIRE |  |  |  |  |  |  | OUR REF: |  | /
 | Daily Hire: | 10
 | Dates: |  |  |  |  |  |  |  |  |  |  |  | DEBIT NOTE
 | From
 | Date | Time
 | 2024-01-15 00:00:00 | 15:00:00 |  |  |  |  |  |  | M/V |  |  | ACC |  |  | CP DD
 | To
 | Date | Time
 | 2024-04-20 00:00:00 | 23:00:00 |  |  |  |  |  | Commission on hire of captioned vessel:
 |  |  |  |  |  |  |  | FROM : |  |  |  |  |  | HOURS
 | [NAME] |  |  |  |  |  |  | TO : |  |  |  |  |  | HOURS
 | Daily Hire
[NAME]? | Yes
 | Date | Time | Date | Time | Date | Time |  | TTL DAYS : |  |  |  |  | DAYS
From | 2024-04-01 00:00:00 | 10:00:00 | 2024-04-02 00:00:00 | 04:00:00 | 2024-04-03 00:00:00 | 10:00:00 |  | [NAME]
To | 2024-04-02 00:00:00 | 03:00:00 | 2024-04-02 00:00:00 | 05:00:00 | 2024-04-05 00:00:00 | 15:33:00
TOTAL
 | Additional/Less | Description | Amount
 | Additional | BB | 2
 |  |  |  |  |  |  |  | COMM |  |  |  |  |  |  | DUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E. & O.E.
 |  |  |  |  |  |  |  | Please make payment to:
Spreadsheet: 856878-calculate-a-figure-which-is-the-result-of-several-items-automatically-please-see-file-question-solution-1
Sheet: Solution

 |  | Initial Cost of the unit |  | Learning | Porcentage reduction because of the learning |  | Year | Number of units produced per year | Cost without learning | Cost with learning
 |  | 600 |  | 1st unit | 1 |  | 1st | 2
 |  | 600 |  | 2nd unit | 0.95 |  | 2nd | 2 |  |  | 1050 | It did not work for 2nd year (it should 1050), the 100% and 95% where used
 |  | 600 |  | 3rd unit | 0.9 |  | 3rd | 1 |  |  |  | already in year 1 for the 1st and 2nd unit, therefore
 |  | 600 |  | 4th unit | 0.85 |  | 4th | 3 |  |  |  | in year 2, the next two units should use 90% and 85%, and so on
 |  | 600 |  | 5th unit | 0.85 |  | 5th | 1
 |  |  |  |  |  |  |  |  |  |  |  | Then, If I change the blue, with different values, the green
 |  |  |  |  |  |  |  |  |  |  |  | calculation should follow the same logic.
Spreadsheet: 147193d1332584215-excel-2007-shift-data-up-if-there-is-any-empty-cell-datashifttest
Sheet: Sheet1

 | The data in this sheet it daily change. sometime I delete some data and sometime i add new data but not more than (specific rows )
 | first
 | second
 | third
 | fourth
 | fifth
 | sixth
 | seventh
 | eighth
 | ninth
 | tenth
 | eleventh
 |  |  | I  delete  ( twelfth )  from this cell
 | thirteenth |  | I need the data below this cell (which it start from B15) to shift up to fill the blank cell which I deleted . The last cell (B25) must become empty after data shift up
 | fourteenth
 | fifteenth
 | sixteenth
 | seventeenth
 | eighteenth
 | nineteenth
 | twentieth
 | twenty-first
 | twenty-second
 | twenty-third
 | twenty-fourth
 | twenty-fifth
 | twenty-sixth
 | twenty-seventh
 | twenty-eighth
 | twenty-ninth
 | thirtieth
 | thirty-first
 | thirty-second
 | thirty-third
 | thirty-fourth
 | thirty-fifth
 | thirty-sixth
 | thirty-seventh
 | thirty-eighth
 | thirty-ninth
 | fortieth
 | forty-first
 | forty-second
 | forty-third
 | forty-fourth
 | forty-fifth
 | forty-sixth
 | forty-seventh
 | forty-eighth
 | forty-ninth
 | fiftieth
Spreadsheet: 106014d1303248265-new-worksheet-with-drop-down-selection-book1
Sheet: Sheet1

[NAME]
sal
[NAME] |  | Rep | [NAME] |  | rep | [NAME]
tom |  | sales | 3 |  |  | 4
[NAME] |  | revenue | 15000 |  |  | 18000
 |  | cost | 5000 |  |  | 7000
 |  | Net | 10000 |  |  | 11000
Spreadsheet: 472318d1469540846-sum-based-on-working-days-asset-creations-2016
Sheet: Data

 |  | Note:
 |  | 2nd May Bank Holiday
 |  | 30th May Bank Holiday
 |  | Company Code | Asset | Asset Class | Created by | Created on | Acquisition yr | First acq.per. | First acq. on | Capitalized on |  | Work Day |  | on or Before WD-5 | WD -4 to -3 | WD -1 to -2
 |  |  | 10116622 | 11000 |  | 2016-05-03 00:00:00 |  |  |  |  |  | 1 |  | 19 | 2 | 6
 |  |  | 10116623 | 11000 |  | 2016-05-03 00:00:00 |  |  |  |  |  | 1
 |  |  | 10116624 | 11000 |  | 2016-05-04 00:00:00 |  |  |  |  |  | 2
 |  |  | 10116625 | 11000 |  | 2016-05-05 00:00:00 |  |  |  |  |  | 3
 |  |  | 10116626 | 11000 |  | 2016-05-06 00:00:00 |  |  |  |  |  | 4
 |  |  | 10116627 | 11000 |  | 2016-05-09 00:00:00 |  |  |  |  |  | 5
 |  |  | 10116628 | 11000 |  | 2016-05-09 00:00:00 |  |  |  |  |  | 5
 |  |  | 10116629 | 11000 |  | 2016-05-10 00:00:00 |  |  |  |  |  | 6
 |  |  | 10116630 | 11000 |  | 2016-05-11 00:00:00 |  |  |  |  |  | 7
 |  |  | 10116631 | 11000 |  | 2016-05-12 00:00:00 |  |  |  |  |  | 8
 |  |  | 10116632 | 11000 |  | 2016-05-13 00:00:00 |  |  |  |  |  | 9
 |  |  | 10116633 | 11000 |  | 2016-05-16 00:00:00 |  |  |  |  |  | 10
 |  |  | 10116634 | 11000 |  | 2016-05-17 00:00:00 |  |  |  |  |  | 11
 |  |  | 10116635 | 11000 |  | 2016-05-18 00:00:00 |  |  |  |  |  | 12
 |  |  | 10116636 | 11000 |  | 2016-05-18 00:00:00 |  |  |  |  |  | 12
 |  |  | 10116637 | 11000 |  | 2016-05-19 00:00:00 |  |  |  |  |  | 13
 |  |  | 10116638 | 11000 |  | 2016-05-20 00:00:00 |  |  |  |  |  | 14
 |  |  | 10116639 | 11000 |  | 2016-05-23 00:00:00 |  |  |  |  |  | 15
 |  |  | 10116640 | 11000 |  | 2016-05-24 00:00:00 |  |  |  |  |  | 16
 |  |  | 10116641 | 11000 |  | 2016-05-25 00:00:00 |  |  |  |  |  | 17
 |  |  | 10116642 | 11000 |  | 2016-05-26 00:00:00 |  |  |  |  |  | 18
 |  |  | 10116643 | 11000 |  | 2016-05-27 00:00:00 |  |  |  |  |  | 19
 |  |  | 10116644 | 11000 |  | 2016-05-31 00:00:00 |  |  |  |  |  | 20
 |  |  | 10116645 | 11000 |  | 2016-05-31 00:00:00 |  |  |  |  |  | 20
 |  |  | 10116646 | 11000 |  | 2016-05-31 00:00:00 |  |  |  |  |  | 20
 |  |  | 10116647 | 11000 |  | 2016-05-31 00:00:00 |  |  |  |  |  | 20
 |  |  | 10116648 | 11000 |  | 2016-05-31 00:00:00 |  |  |  |  |  | 20
Spreadsheet: 40165d1238503443-cell-references-in-formulae-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 377101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date of Input | 2009-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mileage | B1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-05 00:00:00 |  | B1
 | Days | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-08 00:00:00 |  |  | 5 Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-10 00:00:00 |  | A1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-11 00:00:00
A | B1 | A1 | B2 | A2 | B12 | A3 | C1 | A4 | B13 | A5 | B21 | A6 | B14 | A7 | C2 |  | 2009-01-12 00:00:00
B1 | A1 | B2 | A2 | B12 | A3 | C1 | A4 | B13 | A5 | B21 | A6 | B14 | A7 | C2 | A |  | 2009-01-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-15 00:00:00 |  | B2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-20 00:00:00 |  | A2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-25 00:00:00 |  | B12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00