tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 67609d1268186477-excel-2007-pay-off-balance-help-loan-repayment_help
Sheet: Sheet1

Loan
Beginning Amount | 13000 |  | Interest |  | Months Left |  |  | Directions: Input the Actual Payment for the month in the Green Box associated with the month.
Interest Rate | 0.05 |  | PayOff Balance |  | Years Left
Min Payment | 200
Month-Year | Beginning Balance | Interest | Principle Paid | Ending Balance | Min Payment | Actual Payment | [NAME]
2010-01-01 00:00:00 |  |  |  |  |  | 3000
2010-02-01 00:00:00 |  |  |  |  |  | 600
2010-03-01 00:00:00 |  |  |  |  |  | 240
2010-04-01 00:00:00 |  |  |  |  |  | 8000
2010-05-01 00:00:00 |  |  |  |  |  | 1330
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-01 00:00:00
2012-08-01 00:00:00
2012-09-01 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-01 00:00:00
2013-01-01 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-01 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-01 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-01 00:00:00
2014-01-01 00:00:00
2014-02-01 00:00:00
2014-03-01 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-01 00:00:00
2014-07-01 00:00:00
2014-08-01 00:00:00
2014-09-01 00:00:00
2014-10-01 00:00:00
2014-11-01 00:00:00
2014-12-01 00:00:00
2015-01-01 00:00:00
2015-02-01 00:00:00
2015-03-01 00:00:00
2015-04-01 00:00:00
2015-05-01 00:00:00
2015-06-01 00:00:00
2015-07-01 00:00:00
2015-08-01 00:00:00
2015-09-01 00:00:00
2015-10-01 00:00:00
2015-11-01 00:00:00
2015-12-01 00:00:00
2016-01-01 00:00:00
2016-02-01 00:00:00
2016-03-01 00:00:00
2016-04-01 00:00:00
Spreadsheet: 270790d1381663652-index-match-with-date-range-criteria-tracking-form-formula
Sheet: Accruals-Pmts

All Accounted For? | GDN | ID1 | ID2 | Active Document | Type |  |  | Transaction Type | Impacted Month | Month Submitted on Accrual | 1 | Name | Total as of Col K end-of-month date | [NAME] | Current (today's) % Complete | % complete at time of accrual | Total Amount to [NAME] | Total [NAME] to [NAME] | Total Exp Amount to [NAME]
 | P512-1 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | Test |  |  |  | 0.6
 | P512-1 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | Test |  |  |  | 0.75
 | P512-1 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | Test |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | EofE |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-05-01 00:00:00 | 2013-05-01 00:00:00 |  | EofC |  |  |  | 0.5 |  | 0
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 |  | EofC |  |  |  | 0.7
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | EofC |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 |  | EofI |  |  |  | 0.4
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-08-01 00:00:00 | 2013-08-01 00:00:00 |  | EofI |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-09-01 00:00:00 | 2013-09-01 00:00:00 |  | EofW |  |  |  | 1
 | P308-128 |  |  |  |  |  |  | Accrual | 2013-09-01 00:00:00 | 2013-09-01 00:00:00 |  | EofD |  |  |  | 1
Spreadsheet: 525458d1498739019-is-it-possible-to-auto-update-a-worksheet-while-saving-data-on-another-worksheet-inv
Sheet: Client_Data

 | Client Name | Client Code | Address 1 | Address 2 | City | Country | [NAME]
 | Air seychelles | 1001 | Bldg 1 | Street 1 | Mahe | Seychelles | 456352
 | Emirates Airline | 1002 | [NAME] | Street 2 | Dubai | UAE | 126354
 | Etihad | 1003 | Bldg 3 | Street 3 | Abudhabi | UAE | 968547
 | Fairmont | 1004 | [NAME] | Street 4 | [NAME] | UAE | 331200
 | Hilton | 1005 | Bldg 5 | Street 5 | [NAME] | UAE | 568741
 | Radission | 1006 | Bldg 6 | Street 6 | RAK | UAE | 983250
Spreadsheet: 779872d1652165903-calculate-the-number-of-days-from-a-date-date
Sheet: Sheet1

Date | The number of days |  | Date | The number of days
2022-06-08 00:00:00 |  |  | 2022-06-08 00:00:00
2018-12-17 00:00:00 |  |  | 2018-12-17 00:00:00
2022-05-09 00:00:00 |  | → | 2022-05-09 00:00:00
2022-05-10 00:00:00 |  |  | 2022-05-10 00:00:00
2022-05-11 00:00:00 |  | → | 2022-05-11 00:00:00
2019-04-17 00:00:00 |  |  | 2019-04-17 00:00:00
2019-05-11 00:00:00 |  |  | 2019-04-18 00:00:00
2019-05-10 00:00:00
2019-05-09 00:00:00
2019-05-08 00:00:00
2022-06-10 00:00:00
2022-06-11 00:00:00
2022-06-12 00:00:00
2022-06-13 00:00:00
2023-07-10 00:00:00
2023-07-11 00:00:00
2023-07-12 00:00:00
2023-07-13 00:00:00
2023-07-14 00:00:00
Note Color Mean:
1- Red Mean Past.
2- Green means future.
3- Orange Mean today.
Spreadsheet: sally_beck__33950__Weekly Operating Report 2-8
Sheet: Weekly Report

Principal Projects / Deals: |  |  |  |  |  |  |  | New Deals |  |  |  |  |  |  |  | Physical Volume of New Deals
Acquisition of Diashowa Newsprint Mill and related assets |  |  |  |  |  |  |  |  | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1 | 2/2 -2/8 | Total |  |  | 1/5 - 1/11 | 1/12 - 1/18 | 1/19 - 1/25 | 1/26 - 2/1 | 2/2 -2/8 | Total
 | - operations to be assumed at closing in first quarter 2001 |  |  |  |  |  |  | EA |  |  |  |  |  |  |  | EA (in millions)
 | - approx. 400,000 tons of newsprint per year |  |  |  |  |  |  | Gas |  |  |  |  |  |  |  | Gas
 |  |  |  |  |  |  |  | Power |  |  |  |  |  |  |  | Power
HPL Monetization: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EGM (in thousands)
 | -  maintain operations and staff effectiveness through |  |  |  |  |  |  | EGM |  |  |  |  |  |  |  | Liquids
 | transfer date |  |  |  |  |  |  | IR/FX |  |  |  |  |  |  |  | Coal
 |  |  |  |  |  |  |  | Liquids |  |  |  |  |  |  |  | Emissions
 |  |  |  |  |  |  |  | Coal |  |  |  |  |  |  |  | EIM Total*
Develop Strategic Plan for commercialization of mid-office, |  |  |  |  |  |  |  | Weather |  |  |  |  |  |  |  | Newsprint
 | ASE February 12 & 13 |  |  |  |  |  |  | Emissions |  |  |  |  |  |  |  | Pulp
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lumber
Management information regarding PG&E |  |  |  |  |  |  |  | EIM |  |  |  |  |  |  |  | Steel
 |  |  |  |  |  |  |  | Newsprint |  |  |  |  |  |  |  | * Breakout of EIM volumes not available at this time
 |  |  |  |  |  |  |  | Pulp |  |  |  |  |  |  |  |  | New Counterparties
 |  |  |  |  |  |  |  | Lumber |  |  |  |  |  |  |  |  |  |  | 1/19 - 1/25 | 1/26 - 2/2 | 2/2 -2/8
 |  |  |  |  |  |  |  | Steel |  |  |  |  |  |  |  | E-Commerce |  |  | 14 | 8 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non E-Commerce |  |  | 22 | 33 | 13
Spreadsheet: b6474891-06ad-436a-b4c2-b1fc6e4b3060
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
API | Test | API | Yeast Ident Panel C | Yeast Ident Panel C |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87106 |  |  |  |  | Rochester
API | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 338 | - | 66
Index/OTHER* | 435169 | 84864 | 271748 | 69105
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: tracy_geaccone__40324__3rd CE supplement
Sheet: QtrsPlan

PORTLAND GENERAL GROUP
THIRD CURRENT ESTIMATE
(In Millions) Round to One decimal place
 |  |  |  |  | 1st Qtr |  | 2nd Qtr |  | [NAME] |  | [NAME] |  | Total
Plan - IBIT |  |  |  |  | 56.5 |  | 56.3 |  | 23.3 |  | 75.2
Gross Margin (favorable prices at time of
current estimate) |  |  |  |  |  |  |  |  | 12.7
Other Variance |  |  |  |  | 3.4 |  | 1.4 |  |  |  | -12.8
1st Current Estimate - IBIT
Improved Gross Margin |  |  |  |  |  |  | 7.3
Gross Margin (decline in market price) |  |  |  |  |  |  |  |  | -38.7
Overview |  |  |  |  |  |  | -0.1 |  |  |  | 6.2
2nd Current Estimate - IBIT
Other Variance
3rd Current Estimate - IBIT
Plan has been adjusted by ($3.4) mm for GATX fee and $10.4 mm for transfer of goodwill
Spreadsheet: mary_fischer__25736__Browns and Giants Amort
Sheet: Browns Sponsorship Payment

EES - Cleveland Browns
Cleveland Browns Amortization Schedule for Sponsorship Payments
[NAME] : Completed June 2004
Date |  | Payment | Amortization Schedule | Balance on BS
1999-06-01 00:00:00 | 1&2
1999-07-01 00:00:00
1999-08-01 00:00:00
1999-09-01 00:00:00
1999-10-01 00:00:00
1999-11-01 00:00:00
1999-12-01 00:00:00
2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00
2000-04-01 00:00:00
2000-05-01 00:00:00
2000-06-01 00:00:00 | 2
2000-07-01 00:00:00
2000-08-01 00:00:00
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00 | 2
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00 | 2
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
2002-11-01 00:00:00
2002-12-01 00:00:00
2003-01-01 00:00:00
2003-02-01 00:00:00
2003-03-01 00:00:00
2003-04-01 00:00:00
2003-05-01 00:00:00
2003-06-01 00:00:00 | 2
2003-07-01 00:00:00
2003-08-01 00:00:00
2003-09-01 00:00:00
2003-10-01 00:00:00
2003-11-01 00:00:00
2003-12-01 00:00:00
2004-01-01 00:00:00
2004-02-01 00:00:00
2004-03-01 00:00:00
2004-04-01 00:00:00
2004-05-01 00:00:00
2004-06-01 00:00:00
 | 1 | 1.2 Million dollar sponsorship pymt over 5 years paid 7/1/1999 plus
 | 2 | 100k sponsorship payment each year for 5 years beginning
 |  | 7/1/99 and ending 7/1/2004
Spreadsheet: phillip_m_love__30646__texas-sharp
Sheet: 60.40 summary

TEXAS DESK
Summary of Restatement of NGP & L  -- For March 2000 NGP&L
March 2000 Production - Adjustment to NGPL
February 2000 Production PMA's
January 2000 Production PMA's
December 1999 Production PMA's
November 1999 Production PMA's
October 1999 Production PMA's
September 1999 Production PMA's
August 1999 Production PMA's
July 1999 Production PMA's
June 1999 Production PMA's |  |  | 0
May 1999 Production PMA's |  |  | 0
April 1999 Production PMA's |  |  | -958508
March 1999 Production PMA's |  |  | 0
February 1999 Production  PMA's |  |  | 0
January 1999 Production PMA's |  |  | 0
Pre-1999 Production PMA's |  |  | 0
Total Recommended to April 2000 NGP&L
Spreadsheet: 66e5f9ca-5319-419e-a2f4-89f086b10990
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
 | 5671.0 Lending Finance, Australia
 | TABLE 11. FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
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
Commercial Finance - Transport equipment ; |  |  | Original | A2413510X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance - Other plant and equipment ; |  |  | Original | A2413511A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413512C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413513F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413514J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 216445d1361779305-vlookup-or-index-problem-excel_question_v1
Sheet: Output

Team 1 |  |  | Team 2
LAC (dynamic field where I enter team name) | Age | G | DEN | Age | G | PER
Display first 5 results as shown under "DEN" |  |  | [NAME] | 23 | 57
 |  |  | [NAME] | 24 | 54
 |  |  | [NAME] | 25 | 56
 |  |  | [NAME] | 23 | 56
 |  |  | [NAME] | 25 | 54
Spreadsheet: 727518d1617927038-averaging-formula-with-datedif-test-file-2-
Sheet: Sheet1

START DATE | END DATE
2018-02-20 00:00:00 | 2018-08-23 00:00:00
2018-02-20 00:00:00 | 2018-08-23 00:00:00
2019-08-18 00:00:00 | 2019-11-06 00:00:00
2019-11-25 00:00:00 | 2020-03-24 00:00:00
2019-12-09 00:00:00 | 2020-05-20 00:00:00
2020-03-17 00:00:00 | 2020-06-02 00:00:00
2020-01-21 00:00:00 | 2020-03-11 00:00:00
2020-02-03 00:00:00 | 2020-07-21 00:00:00
2020-03-02 00:00:00 | 2021-05-05 00:00:00
2020-05-25 00:00:00 | 2021-01-14 00:00:00
2020-06-08 00:00:00 | 2020-10-05 00:00:00
2020-08-04 00:00:00
2020-11-10 00:00:00
2021-02-01 00:00:00
Spreadsheet: 769983d1645763639-lookup-formula-in-a-block-of-cells-lookup-test
Sheet: Sheet1

First Set | Second Set | Third Set | First Match | Second Match | Third Match
 | 16 |  | Myra Colby | [NAME] Beaumont | [NAME]
2 | 20 |  | [NAME] | Honey Trask | Raine [NAME]
 | 23 | 40 | Clay North | Daffodil Abrams | [NAME]
11 |  | 75 | [NAME] | Alayna [NAME] | Jodi Bryant
 | 27 |  | Cat Armstrong | Rose Bain | [NAME]
 | Lookup: | 40
 | Match:
Spreadsheet: cf8d98c0-b0f1-49c0-9634-2ec0bd1eff7e
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 20593 | 20611 | 19785 | 18233
20 - 25 | 6644 | 3826 | 4297 | 4416
25 - 35 | 14393 | 13713 | 10510 | 8259
35 - 55 | 43172 | 39133 | 33822 | 30292
55 - 67 | 23807 | 26723 | 27819 | 27182
67 und mehr | 32089 | 31872 | 34366 | 36343
Insgesamt | 140698 | 135878 | 130599 | 124725
%
unter 20 | 14.63631323828342 | 15.16875432373158 | 15.14942687156869 | 14.61856083383443
20 - 25 | 4.72217089084422 | 2.815761197544857 | 3.290224274305316 | 3.540589296452195
25 - 35 | 10.22971186512957 | 10.09214147985693 | 8.047534820327874 | 6.621767889356585
35 - 55 | 30.68416040028998 | 28.80010008978642 | 25.89759492798567 | 24.28703146923231
55 - 67 | 16.92063853075381 | 19.66690707840857 | 21.30108193784026 | 21.79354580076168
67 und mehr | 22.807005074699 | 23.45633583067163 | 26.31413716797219 | 29.1385047103628
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 31. [NAME] 2008
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: 136791d1326824531-referring-to-a-non-existent-worksheet-flim-laser-power-readings
Sheet: Nov-30-2011

Slope
R-Squared
Dichroic | MBS 458 | [NAME] | MBS 458/543 | MBS 458/514/594 | MBS 488 | MBS 488/543 | [NAME] | MBS 488/543/633 | [NAME] | [NAME] | [NAME] | [NAME] | MBS 488/543/6336 | [NAME] | [NAME] | MBS 488/543/6339 | MBS 445 | MBS 473 |  | 458 | 488 | 514 | 543 | 594 | 633 | 440 | 473
Approx. Full Power | 1.5 | 1.5 | 1.5 | 1.5 | 8.4 | 8.4 | 8.4 | 8.4 | 5.1 | 5.1 | 1.2 | 1.2 | 1.2 | 2 | 2 | 5 | 15 | 4.5
Wavelength (nm) | 458 | 458 | 458 | 458 | 488 | 488 | 488 | 488 | 514 | 514 | 543 | 543 | 543 | 594 | 594 | 633 | 440 | 473
0.2 | 0.021 | 0.021 | 0.021 | 0.02 | 0.166 | 0.166 | 0.166 | 0.169 | 0.087 | 0.087 | 0.026 | 0.026 | 0.026 | 0.022 | 0.022 | 0.077 | 0.325 | 0.059
0.4 | 0.042 | 0.042 | 0.042 | 0.042 | 0.333 | 0.333 | 0.337 | 0.337 | 0.176 | 0.176 | 0.052 | 0.051 | 0.052 | 0.045 | 0.045 | 0.154 | 0.659 | 0.119
0.6 | 0.063 | 0.063 | 0.063 | 0.062 | 0.495 | 0.493 | 0.49 | 0.498 | 0.264 | 0.269 | 0.077 | 0.077 | 0.078 | 0.066 | 0.066 | 0.229 | 0.992 | 0.178
0.8 | 0.084 | 0.084 | 0.084 | 0.083 | 0.642 | 0.647 | 0.644 | 0.653 | 0.363 | 0.362 | 0.103 | 0.102 | 0.104 | 0.088 | 0.087 | 0.306 | 1.322 | 0.24
1 | 0.11 | 0.109 | 0.109 | 0.108 | 0.77 | 0.781 | 0.77 | 0.784 | 0.457 | 0.467 | 0.129 | 0.127 | 0.13 | 0.109 | 0.108 | 0.378 | 1.642 | 0.305
* All intensity measurements have units of mW
Spreadsheet: 779867d1652160098-calculate-the-number-of-days-from-a-date-date-changed-aligw
Sheet: Sheet1

Date | The number of days |  | Date | The number of days
2022-06-08 00:00:00 |  |  | 2022-06-08 00:00:00
2018-12-17 00:00:00 |  |  | 2018-12-17 00:00:00
2022-05-09 00:00:00 |  | → | 2022-05-09 00:00:00 | Yesterday
2022-05-10 00:00:00 |  |  | 2022-05-10 00:00:00
2022-05-11 00:00:00 |  | → | 2022-05-11 00:00:00 | Tomorrow
2019-04-17 00:00:00 |  |  | 2019-04-17 00:00:00
Note Color Mean:
1- Red Mean Past.
2- Green means future.
3- Orange Mean today.
Spreadsheet: 844292d1696006839-find-the-estimated-time-required-to-manufacture-a-product-based-on-non-linear-min-max-data-exponentialdecayratemodel-diminishingreturns-
Sheet: expdecay

 |  |  |  |  |  |  | exp decay
inputs |  |  |  |  |  |  | t/n-C=B*M^n
endpoints
 | t/n |  |  |  |  |  | M | B | C
n | actual | equation |  | t/n-C  (for LOGEST()) |  |  |  | 5.743677203689873 | 0.2599689722219246
1 | 6
10000 | 0.27 |  |  |  |  |  | Use LOGEST() to get "linear" parameters in H5 and I5 based on the fixed end points
 |  |  |  |  |  |  | Use Solver to get "non-linear" parameter in J5 based on the 3rd point
3rd point |  |  |  |  |  |  | Note that M is the shape parameter, B is the y intercept (when n=0), and C is the horizontal asymptote.
5000 | 0.5
 |  |  |  |  |  |  | Enter appropriate values in A6:A7, B6:B7, and A10:B10
 |  |  |  |  |  |  | Spreadsheet will automatically calculate values for M and B that force the equation through the endpoints (A6:B7).
 |  |  |  |  |  |  | Use Solver to find the value of C (J5) that causes [NAME] to be equal to B10 (D10=0)
draw curve |  |  |  |  |  |  | See if you like result
n | t/n | equation |  |  |  |  | Most likely error is that Solver will try a value for C (J10) that is larger than the value in B7. If that happens, enter a value into J10 that is just smaller than [NAME], and rerun Solver.
1
2
5
10
50
100
500
1000
2000
3000
4000
5000
6000
7000
8000
9000
10000
Spreadsheet: 50173d1249561805-creating-a-template-printing-page-or-a-clever-way-of-copying-linked-cells-print-book
Sheet: Postage

Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
 | E.g. [NAME]
 | E.G. Address 1
 | E.G. Address 2
 | E.G. Town
 | E.G. County
 | E.G. POSTCODE
 | E.G. COUNTRY
Qty | Item |  | Cost
1 | E.G. title |  | 10
0 | 0 |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
 | DELETE
 | 0
 | 0
 | 0
 | 0
Qty | Item |  | Cost
0 | Total |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
 | DELETE
 | 0
 | 0
 | 0
 | 0
Qty | Item |  | Cost
0 | Total |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
 | DELETE
 | 0
 | 0
 | 0
 | 0
Qty | Item |  | Cost
0 | Total |  | 0
0 | 0 |  | 0
0 | 0 |  | 0
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
 | DELETE
 | 0
 | 0
 | 0
 | 0
Qty | Item |  | Cost
0 | Total |  | 0
0 | 0 |  | 0
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
 | DELETE
 | 0
 | 0
 | 0
 | 0
Qty | Item |  | Cost
0 | Total |  | 0
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Braffinity,
118 Coton Park, Linton, Swadlincote, DE12 6RF
Qty | Item |  | Cost
Spreadsheet: 840295d1692628870-help-linking-2-workbooks-extracting-column-header-based-on-date-2023-manufacturing-schedule_excelforum-bigsy73-
Sheet: 2020 Total Demand

 |  |  | 10 PACKS (IN DOSES) |  |  |  |  |  |  |  |  |  | SINGLE UNIT DOSE (1 PACK)
 |  |  | US | UK | NORDICS |  |  | HONG KONG | CANADA | JAPAN | EXTRA1 | EXTRA2 | GERMANY | ROMANIA | POLAND | EXTRA1 | EXTRA2 | Total
 | Wk | Week Of | US Sales | UK | SE | FI | NO | HK | CA | JP | EX10.1 | EX10.2 | DE SUD | RM SUD | PO SUD | EXSUD.1 | EXSUD.2
 |  | 2020-08-03 00:00:00
 |  |  | 2900000
 |  |  |  | 1320000
 |  |  |  | 1320000 |  |  |  |  | 148050
 |  |  | 1740000
 |  |  | 1160000 | 1320000 |  | 146000 |  | 52281 |  |  |  |  | 75000 | 76419 | 65000
 |  |  |  | 660000
 |  |  |  | 330000
 |  |  |  | 330000
 |  |  | 450000 |  |  |  |  |  | 16450
 |  |  |  | 330000
 |  |  |  | 144431
 |  |  | TOTAL DEMAND