Speed of Executing a NeoOffice Basic Sub on Different Pages

[pluby]

[billycar]

In my original spreadsheet, I moved Page 1 to the last page, and it maintained it's sluggish response, after closing and opening NeoOffice, to refresh memory , etc ...

Page 2 and 3, now in position 1 and 2, maintained their "instant" response.

I would upload the original spreadsheet, but I'm considering publishing it as an aid to practicing jazz, and haven't completed it yet. Want to keep it private until then ...

[billycar]

About the 450MHz speed ... I agree it is slow ... but my Quicksliver Dual 1GHz G4 appears to be doing the same thing ... relatively speaking ...

Want to clear up why it is instant on some pages, and 6x slower on the other.

[narf]

Thank you for providing a sample document. On my 1.8 Ghz G5 there is no noticeable difference in calculation speed on the first page versus the second and third page. All update immediately.

I think the difference is due to the G4. I found that when I replaced my G4 with a G5 that things such as patch loading was a lot faster.

--fran

[billycar]

I had to remove the file previously linked here ... I solved the problem later in this thread ...

Thanks for all your attention to this issue ...

Note: Another issue solved herein was how to pass an ods file to another Forum reader. It can be solved by creating a zip file of the ods file. Then, at least on a Mac, when you use Stuffit Expander, choose Preference > File Mapping > MIME, and it will create a file and a folder. If you then open the ods file in NeoOffice, it will take it from there.

[billycar]

I believe I figured out part of the issue.

When defining a range for the number of cells to be summed in a column, I used an arbitrary large number for the last cell, being told that NeoOffice would select the last existing cell to sum to. This would allow me to add rows and not have to fix all the formulae for summing the daily totals as my spreadsheet grows, sometimes daily. (NeoOffice does adjust the formula if I delete / add rows up to and between the min and max specified ranges).

After going back and changing the last cell to be summed to, to be the actual cell number in my spreadsheet for that page, all pages exhibit "instant" retrieval and insertion of current time. (This might also appear to be happening on your Quad Core Intel Monster machines, without changing the range ...).

The formula was (page 1):
=60*HOUR(SUM(J4:J202)) + MINUTE(SUM(J4:J202))

and now is (page 1):
=60*HOUR(SUM(J4:J55)) + MINUTE(SUM(J4:J55))

This varied slightly from page to page, but the magnitude of the ranges was similar. Other maximums now(then) are Page 2: 45(195) and Page 3: 75(210).


The overall speedup occurred in the Master copy, after using the Time retrieve function the first time on that page ...

In the copy being used already for this week's recording of times, the same behavior continued, even though I changed the ranges (???).

So ... partially solved.

To optimize things, any hints on how to create a Function or Sub that would allow me to calculate the total Days Minutes would be appreciated:

From

DAILYMIN = 60*HOUR(SUM(J4:J55)) + MINUTE(SUM(J4:J55))

To using a 2 step process:

RANGESUM = SUM(Arg1,Arg2)
DAILYMIN = 60*HOUR(RANGESUM) + MINUTE(RANGESUM)

So that I could use the user created function

=DAILYMIN(J4,J55)

to fill the corresponding cell.

(I'm questioning my method of computing the Daily Total Minutes as I type: the cells being summed are the task time differences (Q4 = IF(I4>H4; I4-H4;"")) formatted in HH:MM of 2 times ... Start (H4) and Stop (I4) Times, both in HH:MM:SS AM/PM Text format. This doesn't seem to be working if H4 & I4 span midnight).

I'm including all of this in the discussion here, since I'm converting between time formats as times are retrieved and calculations are performed ... all time consuming I am assuming.

Comments welcomed.

[billycar]