- UID
- 223260
- 帖子
- 267
- 主题
- 112
- 注册时间
- 2011-7-11
- 最后登录
- 2013-9-22
|
5#
发表于 2011-7-13 15:42
| 只看该作者
What I did was create a spreadsheet that equally weighted all readings then took the total and divided the number of days until the test by the number of readings which yeilded the avg # of days needed per section.
So I took that number and applied it to my start date and then pulled it forward until the test date. Then I have a date started and date completed column which I populate when i start and finish, obviously, this gives me a time dirrefence in another column which then allows me to calculate a 'rolling projected finish per section.'
Finally, I have a formula which tabulates all of the extra (or excess) time per section that I have accumulated which gives me an "excess days" calculation, this shows me how many days I should have for my review, right now I am sitting at 38 days for review which I would like to get up to around 45 or 50 before the test.
I also have a %age complete calculation going which works off the total # of readings which gives me exactly how far I am done with the cirriculm (right now about 64.56%). I also have a countdown on my spread sheet, a preferred %age complete (which basically tells me how far I need to be if I were to not do a review, I think its at around 30%). I have a few other odds and ends but Im not giving away all my @#$%&, its badass though. |
|