How to Identify Red Flag Pools

So what is a Red Flag pool? It's a pool that should be "red-flagged" for being out of an acceptable range, meaning it could become a problem soon. To learn how to identify red flag pools, see the video below. Or, if you prefer, scroll past the video to view our step-by-step text instructions.

Step-by-step instructions . . .


Exporting your Service History.

  • In Skimmer go to Settings> Exports and select the range of dates you'd like to export for, then click Export to Excel.

Upload your spreadsheet

Next, upload your spreadsheet into Google sheets by going to File > Import > Upload and selecting your file.

Add a slicer
  • Once in Google Sheets, you'll add what is called a "slicer". Do this by going to Data > Add a Slicer.
  • In your slicer, you'll set your column as the value you want to analyze. For this example, we are using pH but you can use any chemical to find what is out of its acceptable range.

Filter by condition
  • Update your Condition. We used "is not between" and set the values to 7.2 and 7.6.
  • The remaining customers left represent the pools that fall outside of the pH's acceptable range. With Skimmer's Service History you can also see which team member has been servicing those pools.

Keeping detailed digital notes and daily readings on your pools can help save you time and money in the long run by showing which pools are in danger of having chemicals out of an acceptable range. Having digital notes, readings, and dosages means you'll be able to filter your data easier using spreadsheet editors.