Jump to content

looking for a Solution


This topic is 7088 days old. Please don't post here. Open a new topic instead.

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

Link to comment
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 [email protected] removing the "NOSPAM" .....

--sd

Link to comment
Share on other sites

This topic is 7088 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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