Jump to content
Sign in to follow this  
Kajalm

looking for a Solution

Recommended Posts

I am sure my project is too big for my level. Here is my problem.

I am attaching a trial database. Each record has manhrs, and a start date & Finish date. The Manhrs are distributed linearly to simplify. The idea is to ditribute all the manhrs summed in a summary, distributing throughout the year on a weekly basis. So that I can draw a Curve for the Manhrs requirement.

I am not sure which way to go. Thought of creating Global fields for each week of the year and going through a loop to check each record and adding the weekly data from a record, depending on whether the week falls between the start date & Finish date, add weekly manhrs. Thats very complicated...can you Gurus think of an easier method PLEASE?

Thanx a million in advance smile.gif

trial.zip

Share this post


Link to post
Share on other sites

Since you're on ver. 6 should you use Michail Edoshin's SmartRanges to make all the dates in between the two dates, then add a new file containing one record for each day in the year which then are trimmed for holidays and weekends etc here do you use a date to a range. Now in order to grasp the workload do you use the weekly manhr to sum( over the relation - which is one per day and perhaps divide with daily hours as long as it produce an integer. This integer pulled over the relation is ment to produce a graph of the webdings char "g" via this calc. =Substitute(Right((10^relation::pull),relation::pull),"0","g")

Checkout http://www.onegasoft.com - for the SmartRanges

Now what is left is to make searches in the new file to extract a certain date range your wish to investigate ...and let the graph here histogram not curve show.

Think about the approach and if you wish me to make you a template - please let me know by mailing me at JamNOSPAMsessionware@mac.com removing the "NOSPAM" .....

--sd

Share this post


Link to post
Share on other sites

Thanx SD

I am trying to understand SmartRanges. Its a big leap in learning for me, but shall crack it.

Yrs

Kajal

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.