Jump to content

Space Planning Schedule


Recommended Posts

I've used the create report command to make a worksheet from spaces and am left with sub-rows listing each space. I have 3 spaces per building and would like to summarise the areas of each unit and add formulas to calculate carparking etc.

There seems to be no way to insert rows within the subrows, or select single cells in adjacent columns.

Am I faced with having to manually create the worksheet and retrieve the records in order to have the worksheet in a presentable format?

Any advice on creating schedules from space planning is appreciated.

Thanks

Grant

Link to comment

Robert

Yes I realise I can control the database definition after it has been created. The spaces are on a single layer and defined by space name and occupant name and area.

However I need to do further calculations on every space, so it becomes time consuming for a large project to define each one in the worksheet. Its easier to export the worksheet to excel, but of course i lose the live update capability then if a space is altered.

As a work around I tried to reference individual cells to elsewhere in the worksheet but it doesn't accept a subrow reference - b2.1 for example just shows in the cell as typed rather than the content of cell b2.1.

Is there a way to reference sub cells?

Is there a programming reason stopping the initial worksheet creation placing the data into normal rows rather than creating subrows?

Thanks

Grant

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...