Results 1 to 9 of 9
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Proposals per Week (Excel 2007)

    I have a spreadsheet that contains proposals. Each one is spaced every other row starting with row 6 next one is row 8 and on. What I would like to do is take the total number of proposals say there are 26, and come up with an average number of proposals per the number of weeks from week 1 of Sept 2007. This needs to run at least until the end of this year, but preferably through Sept. of 2008, and I will be adding rows to it as the proposals come in.
    Attached is a workbook. The names have been changed and or deleted to protect the innocent!

    PS: When will we be able to send attachments in the Office '07 format instead of the '97 - '03 format?
    Attached Files Attached Files
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Proposals per Week (Excel 2007)

    I think you did send the attachment as an XL2007 format. The issue is not the ability to attach, but the limitations of the responses to those who have XL2007

    I can not (and others can not as well) read the XL2007 format. So, if you can't attach in the earlier format you will limit the responses to only those who have XL2007. I think the primary responders to the XL board do not use XL2007 so you could limit the help dramatically....

    Steve

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Proposals per Week (Excel 2007)

    when I first tried to send it in the new format I received the warning that it was not a recognized format. Regardless, here it is in 97-03 format.
    Attached Files Attached Files
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Proposals per Week (Excel 2007)

    I'd put the averages and other summarizing information at the top of the sheet, that makes it a lot easier to add new data at the bottom.
    You could use the following formulas:
    Number of weeks since 9/1/2007: =INT((TODAY()-DATE(2007,9,1))/7)
    Number of proposals: =COUNT(A:A)
    The average number of proposals per week is the quotient of these.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Proposals per Week (Excel 2007)

    In addition to Hans' suggestions, I would eliminate the blanks between the rows. It makes it difficult to Autofill and use end-down in the workbook. If you need the spacing for clarity, I find that just widening the rows is a better approach...

    Steve

  6. #6
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Proposals per Week (Excel 2007)

    Thanks Hans works like I wanted it to.
    Thanks also Steve. I think that I will leave it as is for now however and when I do a re-write I will definitely make the rows wider.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proposals per Week (Excel 2007)

    I have Office 2003 and I had to scurry around to open the file and I found this at MS:

    http://www.microsoft.com/downloads/details...&displaylang=en

  8. #8
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Proposals per Week (Excel 2007)

    Hans A quick follow up to this. It is working perfectly, but what is the "/7" at the end?
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proposals per Week (Excel 2007)

    The TODAY()-DATE(2007,9,1) gives the number of days since 9/1/2007. (TODAY()-DATE(2007,9,1))/7 divides the number of days by 7 to get the number of weeks which might have a fractional part like 1.2857 so =INT((TODAY()-DATE(2007,9,1))/7) drops the fraction and returns the number of whole weeks.
    Legare Coleman

Posting Permissions

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