This Excel spreadsheet will allow you to enter in your MONTHLY EARNINGS into a data table. When you enter in your monthly earnings, another data table below will break your monthly earnings into a DAILY EARNINGS AVERAGE. Two charts will be displayed – an area chart will display your monthly earnings throughout the year and the other will show YEAR-TO-YEAR EARNINGS as a bar chart.
This Excel Spreadsheet will let you enter in your profits as far back as January 2009 and as far into the future as December 2041. The PAGE SIZE of this Excel Spreadsheet is 8.5 × 14 inches. Use legal paper to make print outs of your data! This is what I currently use to illustrate my earnings and it works well. Since it is an Excel Spreadsheet, it is completely editable. Your feedback is greatly appreciated! Enjoy!
IN THE PREVIEW:
What you see in the preview is a mock-version of sales to show what it may look like with your own sales inserted. In the actual product, all of the numbers are set at zero dollars. You must enter in your profits.
NEW FEATURE: Annual and Monthly Profit Forecasting... a.k.a... Predicting your Profits!
I have reserved cells for this feature. However, because every TPT Seller started at a different month/year, this is a feature that you must install into the reserved cells of the spreadsheet. I have provided easy, detailed instructions on how to install this feature to work with the original spreadsheet.
NEW FEATURE: Locations of Sales Pie Chart... a.k.a... Who's buying my stuff!?
With this new feature, you must use data generated by TPT from your "Sales Details" page to create a data table and piechart. This data table will list ALL of the locations of where your resources were purchased... it will then take this data and turn it into a pie chart. With this feature, you can see where the majority of your resources are used... and where they are the least used. Based on the date range that you choose from your "Sales Details" page, you can make a pie chart based on the most recent month or you can make one based on your entire TPT sales career. It's up to you! I have provided easy, detailed instructions on how to install this feature to work with the original spreadsheet.
Copyright © Travis Terry. All rights reserved by author. This product is to be used only by the original downloader/customer. Copying for more than one teacher, classroom, department, school, or school system is prohibited. This product may not be distributed or displayed digitally for public view. Intended for classroom and personal use ONLY.