joffemd/pscf

Public Sector Credit Framework

pscf's Issues

Will not run on Excel 64 bit

Received the following error message when loading into Excel 2010, 64 bit (running on Windows 7, 64 bit)

"Compile Error
The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements adn then marke them with the PtrSafe attribute"

Port Excel User Interface to Open Office

The user interface provided in sample.xlsm only works in Excel. Users who do not want to license Excel should have the ability to use the framework. Consequently, it would be helpful if the framework were ported to Open Office.

Create a readme file

Spoke with @joffemd. Interesting project! Looking forward to a readme file and wiki.

Enable Simulations to Run in the Cloud

The initial version of PSCF runs on the user's workstation. PSCF users would have access to greater processing power if they were able to perform their simulations on Amazon EC2 and other cloud platforms.

Will not run on Excel 64 bit

Received the following error message when loading into Excel 2010, 64 bit (running on Windows 7, 64 bit)

"Compile Error
The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements adn then marke them with the PtrSafe attribute"

32/64 Bit Excel VBA Issue with ShellExecute

Can someone knowledgeable in Excel VBA help us out?

Sone users get compile errors on the following block of code in pscf.xla

If VBA7 Then

Public Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As LongPtr, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPtr

Else

Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

End If

...

On Error GoTo 0
Print #1, "locked"
Close #1
Dim args As String
args = arg1 & " " & arg2 & " " & arg3 & " " & arg4 & " " & arg5 & " " & arg6 & " " & arg7
Dim inst As Long
inst = ShellExecute(0, "open", spec, args, work_dir, 0)
If inst <= 32 Then
MsgBox work_dir & ", " & spec
End If
On Error GoTo done:

We need to be able to reliably shell out to Windows under both 32 and 64 bit.

Port Excel User Interface to GoogleDocs Spreadsheet

The user interface provided in sample.xlsm only works in Excel. Users who do not want to license Excel should have the ability to use the framework. Consequently, it would be helpful if the framework were ported to the Google Docs spreadsheet as well as other web based spreadsheet tools.

Linux build instructions

I see in the sample spreadsheet that PSCF can run from the command-line under linux with tab-delimited data files. Can you provide build instructions for linux?

Support Multithreaded PSCF Simulations

Currently the simulation runs in a single thread. Although it is quite fast, larger numbers of trials would be feasible if multiple processor cores were utilized.

Enable LookAhead and/or Recursive Processing

PSCF models are processed unidirectionally. Formulas can only reference prior year values or current year values that have already been processed (i.e. are higher up in the list of Series). It would be great if this restriction could somehow be relaxed so that expressions could be influenced by values that would normally be calculated later.

This requirement needs discussion before anyone attempts to implement it.