Once the readings from your meters are entered you have all necessary Costs calculated.
In Moderan you don't have to enter every reading number manually - instead, you can upload the meters' readings in bulk!
- Step 1. Get familiar with the process
- Step 2. Date and template
- Step 3. Fill in the template
- Step 4. Importing readings to a database
- Step 5. Adding readings from your database
Step 1. Get familiar with the process
Uploading readings in Moderan is easy:
- Get the data from your meters
- Paste your data into template
- Upload it to make a record into the database
- Sync the database of your readings with your account
- That's it! Now these readings are in your Moderan calculations.
Step 2. Date period and template
You can import readings any time you get information from your meters: on a random date, mid-month or normally the end of the month. Readings data will be stored in Readings database, and recorded in your Moderan account once you sync it.
TIP: If you enter a new reading for the same building, meter ID and date , it will re-write the previous reading figure for that date.
In order to start, please go to Costs tab. Select the property from the list on the left, and the period you need:
After selecting the period, go to the Readings tab:
If you had previous readings, they will populate there.
Now, click on View Readings Database - you need to download the Import template we've prepared to make the upload smooth:
Step 3. Fill in the template
Our template has only 4 columns to be filled:
Property/Building set name - copy and paste the name of the property. This field is case-sensitive, so the easiest way to fill it is to copy it from your Moderan account.
Meter ID - fill in the ID you entered previously, should be defined for the period chosen or later.
Current reading - copy the numbers you got for the meters at the due date. Moderan supports up to 5 digits after comma, so be secure of our accuracy!
Date - fill in the date in DD.MM.YY format (ex. 01.01.2000)
You may also add readings outside the selected period, and it will be added to the database - be sure to reselect the period to see those.
Step 4. Importing readings to a database
Next, upload the filled template into Moderan on the same page Costs > Readings > View Readings Database. You can select file or simply drag and drop it in the area:
In case you miss reading, meter ID, date or property name you will see the error when importing. These columns are required to be filled.
Once the import is completed the new readings will appear:
- Newly entered Readings are marked white.
- Readings entered to the database previously are marked grey. If you close the window and click Readings Database again, all readings will be grey.
- If a meter is not registered for this period or in general such cell will be marked pink. (check Enabling my meters in Moderan)
Step 5. Adding readings from your database
When you imported the template, the data was added to your readings database. It is a storage for all figures of readings you've ever entered.
Now we need to sync the data so that the newly entered readings are added to the period we're in. When syncing, Moderan takes the most recent numbers to the period's end.
Example: you entered two readings for meter "EF", previously for 20.08 - and just now for 31.08. After you sync the readings, Moderan will pick up the figure entered for 31.08 for calculations.
To sync the data, click Add Readings from Database:
Once it's done, you will see the imported readings under Current Readings. Now these are the readings used for the chosen period's calculations.
If you hover over the little "i" next to the number, you will see the date of the most recent reading entered:
If there was no reading for the current period, previously entered one will be showed - and such outdated cell will be marked yellow. It is important to go over all yellow cells to ensure information is entered for the period.
In our August period example, we're missing a reading for a certain water meter WC-TR, and we see the last data entered for it was in July:
If you change some reading manually after there will be no little "i" with the date for this figure