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.