Okay, I'm looking for a custom designed Excel Spreadsheet to keep track of profits I'm making with some software.
I could do this myself but I'm testing this out, meaning there will be more work potential in the future if the work is of a high standard.
This is what I need.
An sheet that will contain..
A running total of my balance, updated every time I update the sheet.
The ability to enter a balance at any time, have the sheet enter the date automatically, calculate the hours since the last update, profit per hour and hours passed.
Also calculation of projected profit/hour /day etc based on profits so far.
I would also need it to keep track of how much was made on average every day, for example if I enter a balance of £100 today at 12 and £300 in 2 days at 12 then it will show as a £100/day profit for those two days.
I would require it tested so it works with frequent as well as infrequent updates.
I need autogenerated charts and graphs showing misc info such as profit/month, profit/day.
Finally I need to be able to withdraw from the balance and enter the new balance as well as withdrawl into the sheet as normal, and have it take the withdrawls and factor them into calculation.
Please post a bid or any clarification questions.