Tutorial for "Spaces"

[Ethan R.]

I need to define space use over time.

ie. month 1 -> usage scenario A

month 3 -> usage Scenario B

 

is spaces the right tool for this?

Can someone help me with a good tutorial?

 

Thank you

Ethan

[Pat Stanford]

I think you need to better define what you are trying to do so we can provide a solution.

 

Do you want to:

A:   Change the graphics attributes of the objects based on the scenario?

or

B:  Generate a list of spaces being used in each scenario?

 

In either case, how do you want to define space usage in the different scenarios?  Probably the best way would be to create a custom record format with a field for each scenario (or month) and fill that in for each space. You can then use that data to either generate lists or to use Data Visualization to change the display attributes of the spaces.

[Ethan R.]

Thanks Pat

 

I have a unit with about 9 "Spaces" or "Areas"

 

I think what you say is correct

 

Quote

 Probably the best way would be to create a custom record format with a field for each scenario (or month) and fill that in for each space. You can then use that data to either generate lists or to use Data Visualization to change the display attributes of the spaces.

 

Over the course of time, the spaces will change use

example:

• Space 1
  • Month 1: Build-Out
  • Month 2: Retail Use 1
  • Month 2: Retail Use 2
  • Month 7: Buildout
  • Month 8: Exhibition
  • Month 14: Tear-Down
  • Month 15: Vacant
• Space 2
  • Month 1: Build-Out
  • Month 2: Multi-Purpose Event Space
  • Month 6: Buildout
  • Month 8:  Exhbitoin
• etc ..

This could also be reorganized by time

 

1. Month 1
   1. Space 1: Build-Out
   2. Space 2: Build Out
2. Month 2
   1. Space 1: Retail 1
   2. Space 2: Multi-Purpose Event Space

 

As a final product

I would like a series of color coded plans showing Usage per Time Period

It would great to be able to generate a report from the same data

 

[Silvano]

Click in:

your space label;

Settings (OIP button);

Occupation (choose the space/use name);

Label;

a Field name;

Format: choose a name in the pop-up;

Add data: choose the information;

Advanced parameters: choose the properties to control in the OIP:

- space name;

- month;

…

OK.

Use the OIP buttons to change the data in the label space.

[Pat Stanford]

As @Silvano stated, you can either use the Additional Data fields available in the space object to store your scenario data or you can attach a custom record. Once you do that they should both work effectively the same.  If you use a custom record, you will have to switch to the Data Pane of the OIP to enter the data. If you use the Additional Data, then you can use the Space Advanced Settings to control which items show on the Data pane of the OIP, but you will probably have to scroll down to see those fields. The best option is probably your personal preference. In either case, you can use a 2-way worksheet to enter or edit the data.

 

You are going to want a field for each month (or whatever period you are using), so a custom record is likely to be better able handle a larger number of periods (like the 15 shown in your example).

 

You can use the Data Visualization commands to set the attributes of objects based on the Stage and Use. You can use Worksheets to show the usage of each space by month or the monthly usage of each space.

 

The biggest trick is going to be making sure you use exactly the same words for each space.  In the database/worksheet Buildout is not the same as Build out.

 

You are probably going to want to have multiple worksheets. One for data entry/editing. One for displaying the usage of each space by Month (criteria is custom record attached,  Column formulas of =CustomRecord.FieldForMonth. Plus probably some kind of identifier column. One for each period. This one will likely be the most complicated and you will have to consider if you want to use a separate database row for each period, or get trick with the criteria and column formulas. If you only have 15-20 periods, I would recommend multiple database rows. You set one up and then copy and edit the criteria for the others. You can then transfer the entire worksheet to a different file and not have to set it up again.

 

Everything you want is doable.

 

Ask again about the parts that don't make sense.

 

[Ethan R.]

@Pat Stanford Thank you

 

Reading this; I'm thinking that it is probably faster to simply bash this out on 15 Sheet Layers!  🤣

 

I'll give it a go and see how we do!

For reporting - maybe copy past into excel?

Edited July 30, 2020 by Ethan R.
spelling

[Pat Stanford]

Definitely not. If you keep it in the VW Worksheet you have the data directly available from the objects. As soon as you take it to Excel you lose the links and just end up with the text or numbers. If you change the drawing, then what you have in Excel is out of date.

 

For 1 drawing it might be faster to do it manually. If this is something you do regularly, then you will save a great deal of time down the road by figuring out how to automate it. Once you get one done the others are pretty much copy/paste and change some values.

 

 

https://imgs.xkcd.com/comics/is_it_worth_the_time.png

 

 

[Ethan R.]

I haven't been able to work it with spaces, but have it going with Data Viz