...

1. Open the job,
2. Go to Usage,
3. Scroll down to Annual Usage Section
4. Select CSV Upload on the Edit Usage by dropdown menu, as shown above
5. A quick guide will then show, it would look like this:the below.  It is very important to ensure your CSV follows the instructions and has the correct format as displayed.
    
6. Select Upload Usage CSV
7. You'll then be prompted to upload a file. Once a file is selected, you'll see a spinning wheel on the Upload Usage CSV Button.
8. Note that you can redownload the uploaded file anytime by clicking on the file name as highlighted below: 

What happens if data is missing on the CSV file?

If any column is missing on the CSV file you're trying to upload, it will fail. You'll then see an error message like this:

Image Removed

Where else can I access the CSV document on Sighten?

Once uploaded, you can also see the CSV document on Site Documents, this is the Document icon on the right side of every job, as seen below:

...

How does Sighten handle different use cases of data?

• If any the required columns are missing on the CSV file you

...

• 're trying to upload, it will fail.
• If any rows are missing on the CSV, Sighten will automatically extrapolate this missing data to ensure a successful upload.  If too much data is missing and we are unable to extrapolate accurately, the upload will fail.
• If the CSV contains more than a year's worth of data, then the most recent year of data is used to calculate usage and bill information.

CSV File Example

Here's an example of a CSV file for PGE (interval data & monthly data)

...