Excel Spreadsheet template
Budget: £750 – £1,500 GBP
Hello,
I'm looking for someone to make me an interactive spreadsheet template that I can use year over year to track everything with my new indie business. I go to a lot of events and I want to track a lot of metrics. I want me dashboard to be very visual and interactive. This template should have multiple sheets. Things I need to track
- Events
At these events I want to know what product sold, demographic of who brought the product, name of the event, cost of the event, I want it to calculate what product was the most popular for that event so whatever sold the most, and see if I came out positive for that event.
- Dashboard
I want the dashboard to be very visual and calculate everything within all the sheets.
- Online Sales
I want to be able to track monthly and yearly sales of each product. So if I sell on Shopify, I want to be able to just input I sold this much stuff this month or this product on this month.
- Projects
I want to track what I am spending on projects, if I hire freelancers to get stuff done I want to be able to track how much I paid for each project, and how much I paid each individual.
- A simple expanse and revenue page
here I want to add up all the expenses and revenue manually so that when it transfer to the dashboard I know it's pulling directly from this page.
Attached are some examples of what I mean by visual/interactive. Since I am a very visual person.
I'm looking for someone to make me an interactive spreadsheet template that I can use year over year to track everything with my new indie business. I go to a lot of events and I want to track a lot of metrics. I want me dashboard to be very visual and interactive. This template should have multiple sheets. Things I need to track
- Events
At these events I want to know what product sold, demographic of who brought the product, name of the event, cost of the event, I want it to calculate what product was the most popular for that event so whatever sold the most, and see if I came out positive for that event.
- Dashboard
I want the dashboard to be very visual and calculate everything within all the sheets.
- Online Sales
I want to be able to track monthly and yearly sales of each product. So if I sell on Shopify, I want to be able to just input I sold this much stuff this month or this product on this month.
- Projects
I want to track what I am spending on projects, if I hire freelancers to get stuff done I want to be able to track how much I paid for each project, and how much I paid each individual.
- A simple expanse and revenue page
here I want to add up all the expenses and revenue manually so that when it transfer to the dashboard I know it's pulling directly from this page.
Attached are some examples of what I mean by visual/interactive. Since I am a very visual person.