Learning the spreadsheet, forecasting
Hey girls,
[I tried looking up on search, I get tips that I should learn this, but I couldn't find any actual spreadsheet setup. If there is an existing thread, please let me know]
I want to learn how to work those spreadsheet, calculate my earnings per day/month, find the best schedules for camming, and forecasting my cashflow.
I know some excel formulas here and there, but I would really want to know what kind of information are you feeding into the sheet? Does anybody have a template to work with?
Re: Learning the spreadsheet, forecasting
Re: Learning the spreadsheet, forecasting
Wow this spreadsheet is amazing:
Thank you! ^_^
Re: Learning the spreadsheet, forecasting
How about documenting the best hours to work in each day? Do you personally calculate the earnings by hour to get an average?
Re: Learning the spreadsheet, forecasting
I am not an expert on making the excel spreadsheets, let alone with the best hours. It requires A LOT more of cells to be made! Maybe you can ask Tsani on here and see if she can make one for you. I wish Streamate has this feature! Well, all the sites!
If hours isn't absolute must, you can look at what days are your best. Or you could add the notes on the free areas of excel on what hours you worked on that day, then you can compare.
Re: Learning the spreadsheet, forecasting
Quote:
Originally Posted by
CurvyWinona
I am not an expert on making the excel spreadsheets, let alone with the best hours. It requires A LOT more of cells to be made! Maybe you can ask Tsani on here and see if she can make one for you. I wish Streamate has this feature! Well, all the sites!
If hours isn't absolute must, you can look at what days are your best. Or you could add the notes on the free areas of excel on what hours you worked on that day, then you can compare.
hehehe ;D well, I'm new to all this, and have absolutely zero business sense and no idea how to go about this. I'm just curious what other camgirls do to track their earnings and adapt their camming habits or content to those statistics (i suppose not everyone is a data nerd)...
Re: Learning the spreadsheet, forecasting
I checked tsani's site and saw this
"You can comment on this post or email [email protected] if you have any questions or requests for additions for future spreadsheets."
You can contact her and see if she can make something to fit your needs. I have seen few other models being really happy with her services on excel, graphics, and many other projects.
Re: Learning the spreadsheet, forecasting
Thank you so much for this! I keep thinking I've read all your bookmarks Winona; I know nothing.
Re: Learning the spreadsheet, forecasting
I've been pretty busy lately with my vanilla business during my camming hiatus and the holiday season coming up and various health issues, but if I get some extra time I'll look into making something that can track trends like that with graphs n stuff. :D
Re: Learning the spreadsheet, forecasting
Quote:
Originally Posted by
ylenafoxxy
How about documenting the best hours to work in each day? Do you personally calculate the earnings by hour to get an average?
I wouldn't say I am an expert either but after downloading the spreadsheet that I found in this thread and making a few changes to my save version I added another page for calculating the best time for each day of the week and time of year. It also includes the type of show I did.
Month Day Hours Total Wage Shift Site Show Type
Nov Sun 4 $40.00 $10.00 Graveyard CB Goal
Nov Mon 1.5 $8.00 $5.33 Mid Day CB Token Keno
The only formulas I used was to calculate my hourly wage (simple division) and I added some formatting to lock rows so things don't get messed up when I sort.
Not sure if that helps but for me the sort feature is the easiest way to spot patterns on excel.
Re: Learning the spreadsheet, forecasting
I paid someone to make one for me. It calculates my hourly and I'm able to put in how much I make on all of my different sites. It's pretty awesome.
Re: Learning the spreadsheet, forecasting
LingerieMilf, I like your additions! I will try and add some other things too. :D I want to add how many vids sold on each day on SM and for how much. I also want to add how many PVT/Exclusive/Skype on each day too.