Results 1 to 7 of 7

Prediction formula

Threaded View

karnold Prediction formula 06-19-2012, 09:39 AM
amotto11 Re: Prediction formula 06-19-2012, 09:57 AM
karnold Re: Prediction formula 06-19-2012, 10:21 AM
ChemistB Re: Prediction formula 06-19-2012, 10:17 AM
karnold Re: Prediction formula 06-19-2012, 10:29 AM
amotto11 Re: Prediction formula 06-19-2012, 10:29 AM
karnold Re: Prediction formula 06-19-2012, 10:39 AM
  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    on earth
    MS-Off Ver
    Excel 2003
    Posts
    9

    Prediction formula

    This is likely an easy one but I cannot seem to figure something that works. What I am trying to do is predict how many complaints my company will have during the fiscal year (from April 1 to March 30). Currently the calculation is being done manually base on the current complaints we have received this fiscal year.

    Here is the formula:
    - Number of current complaints / total of current fiscal days * 365=
    - 31 complaint so far / 80 days into fiscal year * 365 = 141 complaint for 2012/2013

    Thank you,
    Karnold
    Last edited by karnold; 06-19-2012 at 09:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1