ok here is a REAL basic spreadsheet i made.....it should be working ok??

all you will need is the opening figure and the closing figure and it should give you the lobe centre...

is this what you even mean? sorry if you actually mean to do something else, i know your a smart guy so forgive me if we are getting our wires crossed...

LOBE CENTRE.xls