OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[Solved]Project Management

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ram8516
General User
General User


Joined: 25 Apr 2010
Posts: 42

PostPosted: Mon Jan 30, 2012 8:41 am    Post subject: [Solved]Project Management Reply with quote

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
Ram


Last edited by ram8516 on Wed Sep 05, 2012 1:11 am; edited 1 time in total
Back to top
View user's profile Send private message
ram8516
General User
General User


Joined: 25 Apr 2010
Posts: 42

PostPosted: Mon Jan 30, 2012 10:22 am    Post subject: Reply with quote

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???
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group