• 54 views | 1 messages Discussion: LEAP
    Topic: Create/Update branches from Excel ignoring data columnsSubscribe | Previous | Next
  • Damon Lane 2/6/2020

    Hi, I'm following the example at the bottom of this page: https://www.energycommunity.org/Help/Supporting_Screens/Create_Branches_From_Excel.htm

    As shown below, my Excel data sheet has almost exactly the same columns with the same names and units in [square brackets] as that example. My named range includes my entire data table including the column names header. But when I use the create branches function, LEAP correctly reads the resource name and fuel, but it ignores the other columns. Does anyone know why, or what I can do to get LEAP to recognize and import that data?

    I have 55 resources and it would be nice to get the other 8 columns in during import instead of copy+pasting all this data manually, especially since it's likely to be revised.


    Thanks!

    Damon