You are reading a single comment by @christianSpaceman and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@christianSpaceman
Nice, looks about right.
I was thinking about this this morning, I think it could be formula'able, but potentially v complex. You'd also have to make an assumption of the upper limit of how many people could be off in one time
Vba is the right way i think. It will recalculate all the time, so might slow down if it or your spreadsheet gets big, or you start tracking many years of holidays, but can't imagine it'll be terribly noticeable in this case.