Proposals per Week (Excel 2007)

Topic

New Reply

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?

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Hans A quick follow up to this. It is working perfectly, but what is the “/7” at the end?

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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%5B/url%5D

Reply | Quote