I use a spreadsheet for bookkeeping and indeed other things. This article is about understanding how this solution works, it is not about the syntax which is in the Excel help screens. My file has what I call “ledgers” each comprised of three columns: the amount of the transaction, the…

(Before we start there is also this non “volatile” solution =SUM(A$1:A10) used in column B as running total.) The problem: cumulating column totals fail when rows are copy inserted or the data is sorted using data sort. This SOLUTION was HUGE; for me. I just learned/discovered this. Using Excel OFFSET…

Note, this piece is designed to be “evidence based”. This means it is necessarily longer because for each assertion or opinion I provide the authority, which means statute or court and in some cases where court over-rides or “clarifies” statute. This is not easy reading, but offers real insight into…

(The short takeaway: manage your banking etc with this in mind, merely being aware is all you need to defend yourself against unexpected undesirable outcomes. Destiny is all, take charge of yours.) We have always thought our home is our castle. At least we used to until we generally became…

16/3 16:00 By “time defined” I mean set start and end dates. Seems to me that if these are set, then both parties have agreed to give and receive work (to provide and carry out or whatever are your preferred words) until the end date is reached, regardless of agreed…

16/3 16:00 Historically This is the original 1 9 9 4 enactment requiring agencies to operate paye on workers, 25 years ago is a long time and is long forgotten: https://www.legislation.gov.uk/ukpga/1994/9/section/125/enacted I think that’s the one. 1994 sounds about right. …