Hi folks,
I was merrily zooming along, getting my data into my file, then one day the data went all wonky, showing me as running out of money almost immediately. When I tried to troubleshoot, I discovered that I'm also getting the "Runtime Error '13': Type value mismatch" error when I try to click on "Analysis." Any ideas on what might have gone wrong? Unfortunately, I didn't have an uncorrupted export to fall back on, so I'm up the proverbial creek right now.
Thanks,
Rebecca
@rnathenson I really couldn't say what happened and you may indeed be up the proverbial creek right now. If you did any copy and pastes of data from some other location into the PRC file, that can corrupt the file and there's no fixing it. Regardless, if you want to email me your file (to mail@pralanaconsulting.com), I might be able to repair it one way or another. Otherwise, you'll just have to start over and then be diligent about maintaining an updated export file if this were to ever happen again.
Stuart
@rnathenson The runtime error may have been just running out of memory or other resources. You may not be corrupted. I'd reboot, only run Excel/Pralana, and try to do the analysis again.
If Pralana shows something odd, running out of money immediately, etc just head to the tabular pages and see what looks out of place, i.e. maybe in the expenses tab you see you put an extra zero in somewhere for an annual expense. Those tabular pages provide a wealth of troubleshooting data.
Sometimes I do expense smoothing to see how much more a client can spend and stay at or above 90% chance of success. If I forget to change it back to specified expenses only, I can give myself a momentary panic when seeing the graph is different than I expect the next time I pull it up 🙂
