Want A New Macca's

It will be in the mail first thing in the morning along with your copy of CAB. Keep in mind there is no January issue of CAB.

quote:

---

Originally posted by Bigfella

It will be in the mail first thing in the morning along with your copy of CAB. Keep in mind there is no January issue of CAB.

---

There have been a number of References to the CAB
for those of you who are not familiar with it,
It is the Australian Coin and Banknote Magazine
Beautiful pictures and informative articles.
It is published 11 times a year

Cost is AU$ 67 if you live in Australia, but it is AU$ 130 if you live in Europe or the Americas.

To save money-
i have Bigfella send me one each month AU$7.00 and that way I am more likly to place an order with him each month. Even with postage it cost less than a subscription.

Subscription form is available at my website under references.

Though in the main an Aussie Magazine, it should be pointed out that it deals with coins and banknotes from all parts of the world as well.

A highly authoritative magazine, it is recommended for lovers of darkside issues.

sent to Greg McDonald

Hi Greg

Got your 2006 edition of the Australian Coins and Banknotes book, and I was a bit disappointed, because you didn't bother to correct mistakes from last yeas edition. I suppose you wont be able to get one of the three existing 1993 proof 1-kilo platinum koala coins 20.000 dollars below metal value. (Last year it was less, but still a 5 figure mistakes.)
I think you should have an excel spreadsheet like the one I have where you only have to change the underlying metal value, and you get no less than the minimum metal value for each item. (Very easy to set up.) Setting it up that way you wouldn't have dozens of items valued well below the (10 November) closing price of the underlying metal prices.
Also all the Kookaburra coins you copied over from the 2005 edition without a single item change up or down is even more amazing than winning the lotto 1st division two wees in a row. I haven't got the time to compare all other items yet, but I know prices change frequently. However looks like you are managed to come up with the same book with different cover only.
On the lack of correct mintage figures for each item is also very annoying. Especially since most of these later coins are legal tenders, and accurate records must be kept by the mints. Under the freedom of information act these records should be accessible, therefore updated in the book. Me and other people collect every available coin from cretin type and year, (like collecting all the tree existing 93 proof 1-kilo platinum koala coins) and we need these figures.

Marry Christmas

Peter Toldi

rggoodie I did not receive the emails either? Apparently there is (was) a problem with the mail? I will get with Bigfella to get this ordered. Thanks for your efforts!

quote:

---

Originally posted by projack

[quote][i]

You need an ounce collum to do that.
A simple example on the platinum sheet:
Column A is the description, like Kookaburra poof 1994.
Column B is the pure metal weight in ounce.
Column C is the current book price.
What you have to do is add one entry (maybe on the index sheet) for the current metal price for platinum and link that to the platinum sheet to multiply it with collum B and add an if argument to the result if > than Column C than replace it, or you can just add a new metal value collum like a Column D.

I can help you if needed, but you have to add the pure metal weight columns first, or you can add two columns a coin weight, and a purity collum. Like 0.9167 for 22-carat gold or 0.925 for sterling silver.

Peter

---

If you want o down load a copy and make the changes go ahead you can always email to me or As the lazy overworked person would say-
I'lll get to it eventually.

quote:

---

Originally posted by rggoodie

quote:

---

Originally posted by projack

[quote][i]

You need an ounce collum to do that.
A simple example on the platinum sheet:
Column A is the description, like Kookaburra poof 1994.
Column B is the pure metal weight in ounce.
Column C is the current book price.
What you have to do is add one entry (maybe on the index sheet) for the current metal price for platinum and link that to the platinum sheet to multiply it with collum B and add an if argument to the result if > than Column C than replace it, or you can just add a new metal value collum like a Column D.

I can help you if needed, but you have to add the pure metal weight columns first, or you can add two columns a coin weight, and a purity collum. Like 0.9167 for 22-carat gold or 0.925 for sterling silver.

Peter

---

If you want o down load a copy and make the changes go ahead you can always email to me or As the lazy overworked person would say-
I'lll get to it eventually.

---

Ok I did it, and file attachment is sent to you but only on the kookaburras' sheet.
Far too many mistakes were entered on the original so I had to rewrite most of it.
I also reformatted and rearranged the columns, since some of them weren't very useful.
Red writings are Privy Marked coins brown writings are Coin Fair issues, and bold writings are some other special interest.
The quantity reflects my stock so don't take any notice of it unless you want to buy something I have more than one.
Enter the silver spot price on the top and the metal value column will reflect the coin silver value multiplied with the quantity you have, so if you select the Y column, then the sum on the bottom shows the total metal value of the stock.

Few errors on his latest lets hope the next one is corrected