New Macro Spreadsheet

Autoplay, reporting, all those clever things it does. Discuss.

Moderator: kirkm

kirkm
Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

New Macro Spreadsheet

Postby kirkm » Thu Jun 09, 2011 7:12 am

http://www.britburn.co.uk/files/site/spreadsheet.php

It's recommended to change even if you have 999890 test version as this contains further code improvements.

NB: If you have run the renumbering routine, use your existing Backend .mdb file instead of the one in the zip file.

Cheers - Kirk

Glinty
Number One
Posts: 161
Joined: Sat Jun 09, 2007 5:47 pm

Re: New Macro Spreadsheet

Postby Glinty » Fri Jun 10, 2011 10:45 am

Hi Kirk,

I've just downloaded the new macro spreadsheet and there seems to be a problem with it. It wont display any A-Side labels, B-Sides are ok. If you click on a A-Side title the line across the bottom of the screen reports "0x Labels" even though the labels are there. The user config is set up correctly as the B-Side labels display OK. The test version of 999890 works fine.

Cheers
Glinty

kirkm
Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

Re: New Macro Spreadsheet

Postby kirkm » Sat Jun 11, 2011 2:09 am

Hi Glinty,

That's indeed a major bug and I've pulled both v999980's off line temporarily. I've done a fix and in the process of testing. The routine in question is a very important one and was substantially improved to the point it failed :D Ahem :oops:

Stay tuned, won't be long.

Cheers - Kirk

kirkm
Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

Re: New Macro Spreadsheet

Postby kirkm » Mon Jun 13, 2011 10:36 am

kirkm wrote:Stay tuned, won't be long.


Apologies, please upgrade that to 'much longer' :?

Cheers - Kirk

kirkm
Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

Re: New Macro Spreadsheet

Postby kirkm » Tue Jun 14, 2011 9:56 am

Hi All,

Finally ready for testing (well, using - with any luck!)

Standard Macro
http://www.britburn.co.uk/files/spreads ... 99891m.zip

Macro + Whitburn Sheet
http://www.britburn.co.uk/files/spreads ... 9891mw.zip

This contains an improved verify routine for Checksums, as well as a few bug fixes and the 1960s Extras renumbering option.

If you have renumbered, don't do it again (although it *shouldn't* cause any problems). It will not try to renumber if you use your existing Backend mdb file (instead of the one in this v999891 zip).

It does contain Theo's sheet music additions.
There's a few additional 1980 files and some minor 80s modifications just received from Bert. These had to be held over until the next version, due quite soon.

Cheers - Kirk

Glinty
Number One
Posts: 161
Joined: Sat Jun 09, 2007 5:47 pm

Re: New Macro Spreadsheet

Postby Glinty » Wed Jun 15, 2011 6:23 pm

Hi Kirk,

I've been giving the new spreadsheet some hammer over the last two days and I've been unable to break it so far. I think I have tested all the facilities and all are working fine. Well done and thanks for all the hard work.

Cheers
Glinty

kirkm
Platinum Record (Admin)
Platinum Record (Admin)
Posts: 694
Joined: Wed Mar 07, 2007 8:50 am

Re: New Macro Spreadsheet

Postby kirkm » Thu Jun 16, 2011 12:53 am

That's beaut Glinty, thanks for the feedback.

I'll liven up the link on site.

Cheers - Kirk


Return to “The Spreadsheet”

Who is online

Users browsing this forum: No registered users and 1 guest