Embedded Files
July 11, 2022
Parking Schedule - with Retail Carpark and Regular Carpark
Parking Schedule - with Retail Carpark and Regular Carpark
Question: Hi Tien, until today the parking schedule was very simple cause the client didn't want to complicate it and we were creating a parking schedule using: Level, Carpark number.
Now the client wants to bifurcate the car parking into two types: Normal Carpark and Retail Carpark.
The car parking family is just one family. The team tried to create a new family but it didn't work. We need to assist the team in the car parking schedule where the schedule is able to show 3 sections
Level
Regular Carpark
Retail Carpark
Answer: This schedule needs some tricks.
We need to create
1 new parameter for the Parking Category
3 new formula parameters for the Parking Schedule. Please follow these steps
Step 1 : Create a new project parameter
Create 1 new Project Parameter for Parking as the image below
Currently, almost the parking families are STANDARD, I will randomly create 8 RETAILS in LOWER GROUND LEVEL for testing
Step 2 : Create 3 new formula parameters
The preparation is done, now we will move to how to create the schedule
Go to the current PARKING SCHEDULE
Create 1 new CALCULATED VALUE name: Count New and set it equal to Count (because we cannot use the Count parameter in the Formula, you can see it clearly after reading all the steps)
Create Calculated value
Go to Schedule Properties -> Formatting, change it to Calculate Totals
Now, we will have 1 new parameter have the same value with Count
Add the project parameter we have just created in step 1 into the schedule, and the filter to AB-UPPER GROUND to show LOWER GROUND LEVEL
This is the current result
IMPORTANT! Create 1 new CALCULATED VALUE name REGULAR CARPARK and add the formula as the image below
IMPORTANT! Create 1 new CALCULATED VALUE name RETAIL CARPARK and add the formula as the image below
This is the current result
Step 2 : Almost there
Go to Schedule Properties -> Formatting, change it to Calculate Totals
This is the current result, as you can see we have wrong value here, total is 205, but we just have 199, so why?
Basement 1 also has BICYCLE PARKING
So that means the old schedule was wrong, we need to add 1 more filter condition as the image below to make sure we just schedule the car parking
Finally, we got what we need
Hide some unused columns (Count, Count New, Regular Carpark) and we got it!
In this way, it will also work if we have Retail Carparks in the basement. I just made a test as the image below, changing 3 carparks in basement 4 from Regular to Retail: Regular will change from 234 to 234 – 3 = 231, and Retail will change from 0 to 0 + 3 = 3 automatically
Extra Note: This solution can also use for Unit Room Schedule with Room area and Balcony area separately
Hope this helps!
Please contact me if you need any further information
@Tien - July 12th, 2022
Page updated
Google Sites
Report abuse