I'm entering data from 18th century accounts, which are in pounds, shillings (20 to a pound), pence (12 to a shilling) and farthings (4 to a penny).

I need to add and subtract. I've seen a nice gadget for arithmetic with latitude and longitude ("sexagesimal evaluator" by Raybaudi, in Articles, Tips

Techniques ...) and wonder how it works, how I might adapt it.

All ideas gratefully received.

jdjd

Define a calculation field that returns the entered value in a common unit, say farthings, so cValue =

960 * Pounds + 48 * Shillings + 4 * Pence + Farthings 

Use this field to add or subtract. Use the Div() and Mod() function to extract the individual coin values from the result, e.g.:

Let ( [

£ = Div ( result ; 960 ) ;

r = Mod ( result ; 960 ) ; 



s = Div ( r ; 48 ) ;

r = Mod ( r ; 48 ) ;



d = Div ( r ; 4 ) ;

f = Mod ( r ; 4 )

] ;

...

)

Hopefully, you have individual fields for entering the original sums. If not, explain what notation you are using for the entry.

Many thanks: very useful, works well. What a friendly and helpful Forum.

jdjd