SOME SPREADSHEET MANIPULATION ISSUES need to cause the novation values to re-calculate need to get the products added some ideas to fix this and other issues: add some macros to the spreadsheet the will on startup do the things that I need done. - worksheet open - calculateAll seems to work. possibly need to write totals for approval and routing decisions to the workflow tab when the spreadsheet is saved. user process is to initiate the request, which will create a new spreadsheet create a new process instances with the spreadsheet attached. from the portlet the user can download the spreadsheet, make edits and upload. When uploading they can choose to start the process or not. if they start the process, the routing is determined and workflow is initiated. When the user creates a new request they can download the current spreadsheet at anytime. When it is in the not ready state, they can choose to update (prompt, with instructions and link to download) - the update is an upload which will work similarly to what was done for acosta business plan upload (verify that it is the file that was downloaded using the processtracking value from the workflow tab). After upload, the start action will be attempted... processes / processinstances / processinstancerouting documents processId contentId wrk_repository - containerId = processInstanceId, containerType = WPI use the repository model to keep and version the files for the document workflow Process instances have the status of the ERF. When we start a process instance for ERF we: create a record, initialize the file and then add it to the repository (as version 1) (repository record will be linked to process instance id as the container id WPI) and named ERF... determine the routing - store the records in tbl_WRK_ProcessInstanceRouting route it to the first level approver as a workflow request eventListeners will fire after workflow event is completed - the listener will dispatch to the process instance handler the process handler (tbl_WRK_ProcessDefinitions) will determine the next steps based on the state of the approval and the workflow tab in the ERF spreadsheet will list the approvers and their comments tbl_WRK_ProcessInstanceRouting ownerId, ownerType, processInstanceId,userId,role,status,statusComment,statusDate,sequence,oncancel (OWNER,PREVIOUS),onapprove(NEXT) Initialize the spreadsheet