speeding up calculation time

[pmusaev]

Hoping to gather some insight on how to improve my relationship... I have 2 files (1 - Timesheet , 2 - Cost Codes). *Please see attached documents* I am experiencing an extreme slow down when I run my script "Calculate Totals and Go To Summary"... can anyone provide me with a more efficient way to do what I am trying to do? As well, adding codes is a little bit painful. Thanks much in advance!

Cost Codes.zip

[pmusaev]

in addition...

Things I don't want are...

1) 2 Fields per Cost Code (one for ST and another for OT)

2) 2 Fields for Cost Code Totals (one for ST and another for OT)

3) Script that requires "hard" copy of Cost Code entered.

[Oldfogey]

I've never had this confirmed or otherwise BUT I suspect that scripts get bogged down when there is a lot of calculation text. i.e even large field names could slow things down.

Do you like typing? Your calculations seem to be the same for all OTs and ditto for all STs. Why not do the sums first into global fields?

set field OT_sum_a = sum of your a_OT fields

set field OT_sum_b = sum of your b_OT fields

etc.

'Case' adds an extra machine instruction to your calculation. Try this -

set field [total_0309007_OT] = (CostCode_a = "03-09-007") * OT_sum_a +

(CostCode_b = "03-09-007") * OT__sum_b +

etc.

No matter what you do, you are in trouble with that huge acript.

Now I've looked a bit more...

in your Timesheet file, set up fields as totals of each of your 14 columns (instead of the globals mentioned above.)

You might also like to have a look at doing a series of FINDs and a modified script to handle each costcode at a time. I'm guessing that the vast bulk of your work is done in just a few costcodes so the FINDs could well cut down the amount of FMP work necessary.

Going way, way back, I'd have a separate record for each row in yout timesheet table. Or better still, I think, a separate record for each column! In the latter case, you could just use a straight summry report.