I need an excel expert to help tidy up, add certain features to my excel sheet. This excel sheet measures winnings from playing poker. Please open the file i;ve attached named [url removed, login to view]
So far I have created the excel to automatically calculate the networth and per hour winnings - as those are easy. The following things would be asked of you,
Calculate per day winnings, this depends on how many separate rows(dates) there are starting from A2 in the Daily New sheet. Some days there will be no poker play, therefore the amount of rows used should be the determining factor.
Same goes with Per Day Expenses in the Expenses sheet.
Now I will ask you to create a separate sheet which graphs per hour winnings as well as the increase in total networth. The graph should be labeled correctly and make use of different colors, line thicknesses to easily decipher differences.
I will ask you to show this data using all the trendlines that are possible for me to compare which ones are best. I will also ask for your recommendation as to which trendline I should use for each different set of data. I have read on [url removed, login to view] that the best trendline to use is when R is closest to 1.
As an extra bonus to select you for this project, any other cool tricks you suggest I can add to my graph, keeping what the Excel is for in mind, would be of great benefit in choosing you for this project.
Thank you and good luck!