Forum Discussion
Autofill cells in Excel spreadsheet based on data from other cells
CamSDGolf You need to create one or more lookup table(s) in Excel. Difficult to say how, not knowing how exactly the fee structure looks like. For example, does every day/hour of the week/day have different rates or are you just differentiating between weekdays and week-ends? And perhaps for tee times before 8 AM, from 8 AM till 3 PM and after 3 PM. With regard to types, would these be based on a percentage of full greenfee? And for each course, could you say, for instance, North = South +15%.
So, if there is some mathematical logic to how you calculate the rates, it should be fairly easy to calculate the rate based on a few variables and XLOOKUP (or VLOOKUP if you are using an older Excel version).
Otherwise, the lookup table(s) should be listing out every rate for every day/hour during the week, for every type and both courses. Doable, but a lot more work and the lookup functions may become a bit more complex.