# \[iEMS/ECOWatch\]How to insert data and re-calculate energy usage

**URL:** <https://forum.wise-paas.advantech.com/t/iems-ecowatch-how-to-insert-data-and-re-calculate-energy-usage/1625>\
**Category:** ECOWatch/HVAC\
**Tags:** InsightAPM, ECOWatch\
**Created:** [September 23, 2025, 7:20am UTC](https://forum.wise-paas.advantech.com/t/iems-ecowatch-how-to-insert-data-and-re-calculate-energy-usage/1625 "2025-09-23T07:20:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Simon\_Chiu](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@Simon\_Chiu](https://forum.wise-paas.advantech.com/u/Simon_Chiu)\
**Post date:** [September 23, 2025, 7:20am UTC](https://forum.wise-paas.advantech.com/t/iems-ecowatch-how-to-insert-data-and-re-calculate-energy-usage/1625/1 "2025-09-23T07:20:00Z")

</div>

1. Before deleting data, please make sure your account is Super Admin.

2. Please go to InsightAPM and find the tag which bind to energy usage. Click data repair

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/9789f2c86b15fdc53890519a2ef417957998530d.png)

3. Search data in 19/Aug/2025 and make sure this tag doesn’t have any value.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/b948ceea78a9275904e747962f98b68162cd1dc9.png)

4. Click “down” arrow to download excel template

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/347e3266735b885215a457bfa8b77d3c259355f5.png)

5. You need Gateway ID / Device ID / Tag name / Value / Timestamp

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/a24f5c145ee5c035aff7ae9725e8a8702d1d6caf.png)

Gateway ID

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/944ff233146e9fc98df2cfc774f95ec7617ef296.png)

Device ID / Tag name / Value / Timestamp

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/ec917287f3bf16c68f33709e562996a0fd663621.png)

Timestamp format should be one of these kind:

“2025-08-19T19:00:00Z”

“2025-08-19T20:00:00.000Z”

“2025-08-19T05:00:00+08:00”

“2025-08-19T06:00:00.000+08:00”

After modifing excel, save excel.

6. Upload excel by clicking “Upload” button

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/4c814fdf94f17bfc3bf9e149a22404c49e90ecf7.png)

Click upload

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/eaa974b86d3b87f2be9151d5a557f77e9819b9c5.png)

Result:

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/384875257ea75deea5886603acdf60bfbbdb86ba.png)

7. Go to System Monitoring à Usage Analysis

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/4c0082726d7603c0d21d5247fe95780867f08d6c.png)

8. Query Meter Asset à Back Calculation

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/0f981a59cc461317276f55f9de845b7ab34ad3a7.png)

Select the same time range then save

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/4a499ff813608832fcca4823ab96d37937e6e7cf.png)

Press Query until finish

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/1a8afc583e160d2bbc29d7356f52a6953dcf960b.png)

ECOWatch result:

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/30f3f372ac11fd0a4b48067567ea942c9641d8e2.png)