I’m using Coda for most of my business’s analytics (we’re a service company, so most of it is just analyzing time sheets vs. contract rates, expenses, etc). I’m almost completely happy with my setup there, and I’m starting to brainstorm future forecasting. I’ve been mulling something over for a few days now, and can’t come up with a great solution, so I thought I’d throw this puzzle out to you guys in case I’m missing something:
How can I best built a forecasting system for future invoices - it’s not complicated, but there’s no spreadsheet system I’ve found that does a decent job of it: Next month (December), my 17 employees are going to be working on 3 different client projects, as well as taking respective vacations. We have 5 price tiers among my employees (their Junior - Senior titles).
Edit: I need a simple view that allows me to input each artist’s expected work for each day of the upcoming months, including their approved vacations, etc. The output from it just needs to be expected days worked per project per artist tier within a timeframe (December, January, February, etc)
As a worst case, I can add line entries per employee per day for december, but that’s a terrible user experience for me. Can you think of a decent/fast way to fill out my scheduled forecast for December (and every month there after?) Gantt Charts and Calendar views come to mind, but from my experiences, they leave a lot to be desired in terms of interactions / entering data.