Need help with pre-decimal exchangerates and pre-Euro? I gave it a try

I have used today on making a helpfull (I hope) Google-sheet, with all the current Pre-Euro Exchangerates, First in Danish, because why not and a little further down in English. 

It is with a handy “set in” column, so you just can set in the amount of value you have in hand and it will exchange it to Euros to the left and other currencies to the right. This is especialy helpfull for those currencies still exchangeable, marked with green and orange, the orange having a set last day of exchange.

Those not exchangeable anymore, are marked with red and have the date too.

A little further down you can exchange pre-decimal currencies to their later/first decimal counterpart, in no particular order. I joust found this funny. I have a love hate relationship with the £sd system(s) and math, so hope most of it is correct.

I hope other people can find this helpfull and feel free to use it/download it/copy it, for your own use and tweek it for your own purposes. It was fun for me and probably later helpfull, even though it gave me headache 😂

https://docs.google.com/spreadsheets/d/1nSMqlyICyI1g8tbQ5ej96Y_iku44UsOw-6bQe0sgehk/edit?usp=sharing

Sources are primarely Numista and Wikipedia

HERE is a download link to a sheet that contains a quite good LSD calculator. You can play around with it an implement and adjust what ever functions you could use for your sheet (you have to unhide the AB column to see some functions).

Jamtrup

I have used today on making a helpfull (I hope) Google-sheet, with all the current Pre-Euro Exchangerates, First in Danish, because why not and a little further down in English. 

It is with a handy “set in” column, so you just can set in the amount of value you have in hand and it will exchange it to Euros to the left and other currencies to the right. This is especialy helpfull for those currencies still exchangeable, marked with green and orange, the orange having a set last day of exchange.

Those not exchangeable anymore, are marked with red and have the date too.

 

A little further down you can exchange pre-decimal currencies to their later/first decimal counterpart, in no particular order. I joust found this funny. I have a love hate relationship with the £sd system(s) and math, so hope most of it is correct.

 

I hope other people can find this helpfull and feel free to use it/download it/copy it, for your own use and tweek it for your own purposes. It was fun for me and probably later helpfull, even though it gave me headache 😂

 

https://docs.google.com/spreadsheets/d/1nSMqlyICyI1g8tbQ5ej96Y_iku44UsOw-6bQe0sgehk/edit?usp=sharing

 

Sources are primarely Numista and Wikipedia

Eksisterer ikke

Ubegrænset

It's a nice job you did!