[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
ram8516
General User

Joined: 25 Apr 2010
Posts: 42

 Posted: Mon Jan 30, 2012 8:41 am    Post subject: [Solved]Project Management Hi I have a spread sheet with the following info cell F5 to AH5 has dates starting from FEB 01 to Feb 29 Cell F7 to AH 7 has number of resources A 16 has project name B16 has Estimated hours for the project C 16 has start date d 16 has total number of days I want a formula from f 16 onwards which should first check for the start date at c 16 and then go to the corresponding cell with reference from F5 to AH5 and from that date onwards it should calculate the working days from total number of days and split the resources from cell f7 to ah7 to match the hours from b16 ( 6 working hours per resource). so for example if i enter project 1 estimated hours as 600 hours and days as 10 and start date as 6th feb. the formula should display 10 resource for 10 working days till 16th excluding sundays. can any help??? Thanks in advance regards RamLast edited by ram8516 on Wed Sep 05, 2012 1:11 am; edited 1 time in total
ram8516
General User

Joined: 25 Apr 2010
Posts: 42

 Posted: Mon Jan 30, 2012 10:22 am    Post subject: i used this formula =IF(\$D\$16="";"";IF(\$C\$16=\$F\$5;IF(IF(COLUMN(D\$16)-3>\$D\$16;"";\$C\$16+(COLUMN(D\$16)-3)-1)=F5;(\$B16/\$D\$16)/\$B\$2;"") ;"")) now i want is to check the start date only i want to incorporate a if condition to the above formula to check the start date in c 16 with the dates if f5 to ah7 any help???
messki678
Newbie

Joined: 26 Apr 2012
Posts: 1

 Posted: Thu Apr 26, 2012 9:13 pm    Post subject: ram is exactly right. he solve the issue correctly._________________Test-king cert-MCTTP http://www.test-king.com/cert-MCITP.htm Exam cert-CCNP http://www.test-king.com/cert-CCNP.htm Training cert-CCDA http://www.test-king.com/cert-CCDA.htm
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum