Next Steps for Propmansheet

1. Implement password protection for Top20 report. This is necessary as it is only accessable on British Red Cross intranet but only want authorised property professionals to see information.

2. Write more reports in Crystal Report writer.

3. Write Excel reports for it using MySQL ODBC driver ( http://dev.mysql.com/downloads/connector/odbc/3.51.html ) to link into Promansheet database.

4. Ensure all users have access to Crystal Report Writer.

Simple Tool for Updating Propman Analysis and Keynotes

I have decided to email a few Grosvenor Propman users to tell them about Propmansheet as others could find it useful.

http://code.google.com/p/propmansheet/
http://groups.google.com/group/propmansheet

Hi would you pass this on to your Property Department,

I have written a simple tool that makes it easy, using a web browser, to update Propman keynotes and analysis.

I would like to share it with Grosvenor Propman users.

The tool is free.

You can use or adapt it.

You or your IT department could find it useful.

If you have any thoughts or queries please do not hesitate to contact me.

Ez

A Propman User

Simply How To

Today in the spirit of "service through simplicity" I am writing some notes on the wiki (http://code.google.com/p/propmansheet/w/list) on how to upload keynotes and property analysis code to Propman.

New Propmansheet Download

I have just uploaded a new Propmansheet download zip.

The main change is that it now translates spreadsheet entries into analysis codes.

So You can use more readable spreadsheet entries and then use a simple lookup table to change them into analysis codes.

see Zip of beta 0.2 of BRCS Top Twenty Report using Propmansheet requires ROR and... in root

Propmansheet Works

After initially setting up propmansheet using an excel spreadsheet. I corrected it on the web then produced a upload file for propman.

I worked well.

Now I have a spreadsheet that the building professionals can use and a tool for EASILY updating propman.

Keeping Propmansheet Readable and Simple

I have decided to keep the Proman spreadsheet readable and simple by using simple descriptions for terms in the spreadsheet.

These terms are then used to lookup the analysis code and it is this analysis code that is output to the Propman upload file.

Currently setting up the lookups.

Updating PropmanSheet

I am currently updating the Propman spreadsheet prior to live launch.

This involves updating the web spreadsheet using information from the Excel spreadsheets.

The data has then has to be rationalised, made consistent e.g. "yes" and "Y" spreadsheet entries changed to one or the other.

A pre-formated Excel spreadsheet is then used to make a migration file to move data to Propmansheet. See

Also, Propman needs to be updated with any new analysis codes or keynote types.

Top 20 spreadsheets to be brought up to date

Comparing the latest top 20 spreadsheet with figures in Propman sheet.

Correcting differences.

Ensuring all properties have propman references.

Cleaning up comments.

Plan for First Roll Out of Propmansheet

In discussions with BRCS MIS to ensure it can be supported.

I have been writing down how it works and a User's guide.

The stages of Phase 1 are

- the Top 20 spreadsheets will be brought up to date

- to ensure that the Prop Ref numbers are correct and all new projects have Prop Ref numbers (essential)

- clean up the comments column

- upload the information into PropMan

- produce reports from PropMan and check the information.

- once we are comfortable that the information is loading up into the correct places and we can report out again, this will be Big Bang as we can stop using the excel spreadsheets.

- as a group the BRCS need to agree how frequently to update PropMan with this information

- once we are comfortable with Top 20 reports we will do the same for the 5 year planned maintenance, lease details, others to follow.

More Propmansheet Testing

Demo currently not working as I have updated to latest Active Scaffold version but I haven't had time to update Instant Rails. I'll do it some time today if I have time.

I will be ticking back and setting up new analysis and keynote items to match Top20 Report.

Propman VPN

The next challenge is to log into Propman over the red cross vpn and remotely test uploading and reporting using my office computer.

Need to speak to IT helpdesk first to sort out some vpn issues so that won't be until tomorrow.

New Logo for Application

Propman Testing

Meeting with Andrew today to discuss Propman Sheet.

I will this morning trying to test out Propman by VPNing into Red Cross system.

Added Demo to Wiki Web Site

This Demo is running on my home machine.

So it is very slow.

Demo on my home computer >>

Wiki - First Draft Done

Finished first draft of wiki.

Next need to get web Propman spreadsheet updated and agreed.

Then do some testing on Propman.

Meeting Andrew from IT dept. tomorrow to discuss support and hosting.

A key issue will be security and login and password protection.

Proman Sheet Discussion Group

Visit discussion group

Subscribe to Propmansheet

Email:

Visit this group

Weblog of Developemnt of Propman sheet

Hi,

This is my weblog of the development of a web spreadsheet for Grosvenor Systems Propman property accounting system.

I have posted the source code to google code and created a discussion group.

Currently working on the wike.