Menu Close

Database w/ many models, but need to run them individually

Syncrosim Forums ST-Sim & State-and-Transition Simulation Models Database w/ many models, but need to run them individually

  • This topic is empty.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #1639
    kblankenshipkblankenship
    Participant

    I created a Path database w/ 21 models (i.e. 21 tabs on the Pathways tab) but I want to tweak and run these models one at a time. What is the easiest way to do this?

    #1797
    leonardo-fridleonardo-frid
    Keymaster

    There are a number of ways in which this could be done.  The simplest would be to copy the scenario that has pathways specified for all 21 models, delete the initial conditions for the 20 you don’t want to run and rename it for the specific stratum that you are running.  To do this you can follow these steps:

     

    1. In the project explorer right click on the scenario that has 21 strata (models) and select Copy

     

    2.  Right Click on the folder that holds that scenario and select Paste

     

    3. Right click on the copy of the scenraio and select Rename.  Rename the scenario to specify the stratum you want to run.

     

    4. Right click on the scenario again and select Open.

     

    5. Navigate to the Initial Conditions tab, right click on the grid and select Export All.

     

    6.  Save the excel file on a location of your choice and it when it appears on your task bar open it.

     

    7.  Filter for all strata except the one you want to run and delete their initial conditions records.  Remove the filter.

     

    8.  Save the excel file and note it’s name and location.

     

    9. Return to the Initial Conditions tab in Path for the scenario that you want to sun a single stratum for and right click on the grid again.  Select Import and navigate to the excel file you just edited.Open it and when prompted select Overwrite.

     

    10. There will be only initial conditions for the selected stratum only.  You can now run this scenario and it will only run your selected model.  You can repeat this for any model you want to run individually.

     

    11.  A more advanced approach for this would be to create a scanario with only pathways and a scenario with only initial conditions for each of the models you want to run individually.  You can then use dependencies to combine each set of initial conditions with your single set of pathways.  

    #1798
    kblankenshipkblankenship
    Participant

    Thanks for your instructions but I’m having trouble at step 9. When I click the overwrite button I get this error message:
    “No data found in the specified file for the property ‘Initial Conditions'”
    When I click OK to that message, I get additional information that states:
    “The value ‘711670’could not be found for the column ‘Stratum’. Record ignored.

    A couple issues I suspect are:
    1) Is there a problem w/ leading 0s in the stratum name? The stratum I want to create a scenario for is named “0711670.” In the xls file that I exported that record shows up as “711670.” I tried adding the leading 0 back in by hand and reimporting but I received the same error message.
    2) Is there a problem w/ blank rows at the top of the initial conditions spreadsheet before the record of interest? After I deleted the unwanted initial condition records and removed the filter, there were 4 or 5 blank rows below the column headers and before the rows that contained info for my stratum (0711670). I tried removing those rows by hand and reimporting but I received the same error message.

    I also tried reimporting w/ a version of the initial conditions file that had both changes implemented – removed extra rows and added leading 0.

    #1799
    leonardo-fridleonardo-frid
    Keymaster

    1.  Yes the problem is with the leading zeros.  To fix this go to the File | Project Definitions | Strata tab and enclose all of your numeric strata names and abbreviations in double quotation marks (").  Then repeat the steps outlined above, beggining with step 5.  I’ll see if we can fix this issue and allow leading zeroes for numeric stratum names in the next version of Path.

     

    2.  You should manualy delete any blank rows in your initial conditions excel file prior to importing.

     

    #1804
    leonardo-fridleonardo-frid
    Keymaster

    The problem with leading zeros in definitions when exporting and importing properties is now fixed.  When exporting to excel we prefix numerical definition names with an appostrophe (‘) so that they are treated as text and the leading zero is not lost.

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.