I need an excel expert
Budget: $30 – $250 USD
I am looking for an excel expert to set up a weekly and monthly revenue operation for my veterinary clinic. Basically I would like to have a goal in place for our Monthly revenue but maintained weekly. My excel sheet would include our weekly revenue, weekly revenue per hospital day (RPHD), weekly pet count, weekly Pet Per Hospital Day (PPHD). We would have our goal and then our actual. Ideally the cells would be green if we surpass our goal weekly and red when are under our goal. This excel sheet would also include our Month to date revenue (MTD), our MTD RPHD, MTD Pet Count, MTD PPHD. This portion would also have goal and actual. The last portion of the excel sheet would include Revenue projection, RPHD Projection, Pet Count Projection and PPHD Projection. With a goal and actual line item.