LPC flag in Access database?
We have an application that generates weights for each income bracket based on what FS personnel are paid at the forest or regional level and writes them to our IMPLAN models. I want the LPC to equal the model SAM value so before running the scenario I have to reset all LPCs for each income bracket. It's a pain because I run a lot of models and each income bracket reset takes a chunk of time to do. Is there a flag somewhere in the IMPLAN Access database that could act as a flag to tell IMPLAN to set the LPC = model SAM when it's imported? That would save a ton of time. Thanks!
-
First off, I am a little confused as to how you are implementing the impact vector. When an impact vector is imported, it should set the LPP (Local Direct Purchase in the premade templates) = Trade Flow ...if the LPP in the imported data is a value less then 1.0 (<100%). If it doesn't work that way let me know. -
k, Susan. I renamed your database to .impdb and tried to import the household activities and kept getting an error about null fields. I was able to fix it, and when I import the household sectors from that model into a new model the LPP's are reset to the current model. However, the events were not sorted so it appeared to have LPP's all over the board if you did not note the sector numbers. If you sort (click on the "sector" header field) that problem clears up. -
Can you try this - 1) In your System folder rename IMPLANModelTemplate something like "Original IMPLANModelTemplate". Then rename the file I sent you IMPLANModelTemplate and put it in the System folder. 2) Build a model. That stuffs all my activities and scenarios in the new model. I somehow want the LPCs to be set to the model RPCs as the model is built. Maybe that's not possible. -
Ok, thanks for checking!!! Another question - sometimes when I do Event Options/Change All it runs really fast. Other times it's really slow - this is for the same Activity in different models. Is there any way to make it run fast? Can I do something in Access rather than in IMPLAN? That might be faster. -
This was something that Scott looked at a while ago and couldn't come up with a solution. When I try to update all events in an activity that holds a lot of events it always runs slow - I'd like to know how you get it to run fast sometimes. Anyway, one thing to try, is to import the 9 activities to the current model from a holding model (you can shift-click to highlight and import all 9 at once)- this automatically updates the LPPs. It may be faster.
Please sign in to leave a comment.
Comments
10 comments