Kajalm Posted October 26, 2004 Share Posted October 26, 2004 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 trial.zip Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 28, 2004 Share Posted October 28, 2004 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 More sharing options...
Kajalm Posted October 31, 2004 Author Share Posted October 31, 2004 Thanx SD I am trying to understand SmartRanges. Its a big leap in learning for me, but shall crack it. Yrs Kajal Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now