Discover our Clipsal Smart Home packages as seen on The Block 2018

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Video: How is logged data exported from ION Setup to Microsoft Excel?

    Product Line
    ION Setup

    Environment
    Data Logs

    Cause
    ION Setup was designed as a viewing program without any facility for data storage or export.

    Resolution
    If historic data that was downloaded from a meter in ION Setup needs to be exported to another format the following procedure will need to be follow:

    Connect to the meter and enter data viewing mode (see ION Setup User's Guide for details).

    1. Open the data recorder of your preference. And highlight the section you'd like to copy.
    2. Select the Edit menu and choose copy.
    3. Open Microsoft Excel and open a 'New' document.
    4. Select the Edit menu and choose paste. You will need to create the column headings yourself as they won't be copied over.
    5. Highlight the Timestamp column and right click on one of the highlighted cells and select Format Cells
    6. When the Format Cells popup appears, change the Category to date, and select an appropriate date type.
    7. If the date shows up with an @ symbol between the Time & Date section, then you will have to find/replace the @ with a (space).
    8. Click on the A column heading to select the A column again.
    9. Select Edit and choose replace.
    10. In the find field place your @ symbol, then in the replace field you can type the space, then click Replace all.

    To Graph Data:
    1. To Graph your data, you can select the Timestamp column & the desired columns by holding down the CTRL button and clicking on the Column letter.
    2. Click on the graph button, and follow the wizard to create the line/x-y scatter graph you need.



    If you want to export the data as a .CSV file, follow FA221402

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance