1. Open up the Consumption Profile editing screen
There are two ways of uploading your customer's interval metering data:
- from within a project
- into your Library of Consumption Profiles
Of course, you can always save a consumption profile to your library from within a project, and load a consumption profile from your library into a project.
1.1.1. Open your project's 'Consumption' tab
1.1.2. Click 'New' or 'Edit'
'New' is shown if there is no Consumption Profile loaded into the project, while 'Edit' will show if there is a Consumption Profile already loaded. The 'New' and 'Edit' buttons will show in the same place on the page to the left of the 'Load' button.
1.1.3. Click 'Meter Data'
1.1.4. If there is already a meter data file associated with the project, delete it
1.2.1. Click on the Libraries icon in the side menu
1.2.2. From the Consumption Profile tab, click 'New Consumption Profile'
You can also edit an existing Consumption Profile:
1.2.3. Enter a Name and Description for the Consumption Profile
1.2.4. Identify whether the consumption profile is for a residential or commercial customer
1.2.5. Click 'Continue'
1.2.6. Click 'Meter Data'
2. Upload the data
2.1. Drag and drop your interval metering data file into the drop zone (or click the 'upload' link in the window and then select the file you wish to upload from your computer)
2.2. Wait for the file upload process to complete. (This may take some time for large files, or for MS Excel files)
3. Format
PVsell can handle interval metering data both in horizontal and vertical formats. So you can select what format you would like to upload your customer's interval metering data in:
- horizontal format – 48 columns wide, with each row containing a day's data. (365 rows for a full year)
- or vertical format – One data point per row (typically 8760 or 17520 rows for a full year).
3.1.1. Select 'Vertical Format'
3.1.2. Identify the date column and the time column, or if date and time are combined in one column in your data file, then identify that column as the 'DateTime' Column
3.1.3. Identify one column that holds the consumption data – whether the data is in kW or kWh
3.1.4. Click 'Set Columns'. PVsell will then perform some analysis of the file and show you the results of its analysis
3.1.5. Review the metadata to identify that the data has been recognised. If not, you may need to click 'Re-define Columns' and enter the format of the date and time columns in your data file
3.2.1. Select 'Horizontal Format'
3.2.2. Select the Time Increment (typically 30 minutes, equivalent to 48 data points per day)
Time increments of 15 minutes, 30 minutes and 1 hour must have 96, 48 and 24 columns respectively, from the starting cell.
3.2.3. Select the Power Units (typically kWh)
3.2.4. Click 'Date' above the column containing the dates (in the heading)
3.2.5. Click the first datapoint (energy reading)
By clicking the cell, select the first kW/kWh value.
3.2.6. Click 'Set Columns'
3.2.7. Review the metadata. If necessary, you can click 'Re-define Columns' and enter the format of the date and time columns in your data file
0 Comments