How to Use Your Service History to Forecast Your Chemical Needs
To learn how to use your service history to forecast future chemical needs with Google Sheets, see the video below. Or, if you prefer, scroll past the video to view our step-by-step text instructions.
Step-by-step instructions . . .
Export your Service History and Import it to Google Sheets
- Navigate to Settings > Exports in Skimmer's web app. Choose the range of dates you want to use and click Export to Excel to save
- Now take that file and open it in Google Sheets File > Import > Upload.
- In Google Sheets go to Data > Add a Slicer.
- Pick a chemical to monitor. In this example, we use Tabs. Set your column to the chemical you want to monitor.
Start by creating a Pivot Table. To do this go to Insert > Pivot Table.
Set your value to your Service History.
Then we set our row to Gallons. Now your table should be listing pools by size.
Here we've used Tabs again. Now your table will show how many Tabs were used based on pool size. You can also enter a formula to average the amount of Tabs used per gallon.
And that's it! Now you have a way to help see the sum values and averages of your chemical usage to help you navigate chemical forecasting. This is just one way to utilize your Service History in Google Sheets to help make predictions for the future or see trends from the past.