Looking for someone that can develop 3-4 Graphs ranging from line, column, bar and other graphs you may suggest. These graphs will be seen & utilized by 8-10 people around the office and need to be easily edited in excel on a daily basis. Once these are complete, I'm going to view them on a TV. All example graphs are attached.
1. Annual Net Management Fees
I would like to start tracking our Annual Net Management Fees on a monthly basis, starting in May 2016 and ending in April 2017. The target is $710,000 (inc. GST) by April 2017. I would like to track what we're actually making month on month with target month on month as displayed in the graph.
2. Number & Percentage of Dominant Properties vs Rent Roll
I would also like to track this from May 2016 and ending in April 2017. At the moment we have 69 dominant properties out of 316 properties. Our target is 100 dominant properties with a 50% dominant properties vs our rent roll (316 at the moment).
3. Total Number of Leads
This will be broken up in two graphs. The first one will be the leads year to date tracking it month on month. Starting on May 2016 and ending on April 2017. The target is 50 leads/month and 600 leads for the year. On the second graph, I would like to track this daily, 1 line being our actual leads day on day and the other line being our target leads of 50.
These graphs are pretty self-explanatory in the diagrams but if you have any questions about this please email me on firstname.lastname@example.org
I need this job done immediately.