Calculated Value Formulas for Lighting / Wattage Schedule

[Tinman1975]

What Calculated value formulas would I need for the below - 

Wattage per m²

Allowable wattage / Room

Installed wattage m²

[Tinman1975]

I’m aiming for Calculated value formulas that are below -

Wattage per m² (5w) individual Column

Allowable wattage per Room (from Room Area)

Installed wattage m² (from Room and a Area)

Not sure if its better to do off a Room schedule or a Lighting schedule in 2021..

[barthbradley]

Lighting Fixture Schedule that pulls in Room Properties

That's where I would start. 

[Tinman1975]

i need to create a schedule that - 

1. Takes in the Room area, 

2. Multiplies the light fittings placed (wattage per fitting) within a room area.

3. Calculates the maximum wattage allowable for that room. (5w per m²).

4. Yes or No Complies 

Not sure if Room Schedule or Light Fitting schedule works best ???

[Tinman1975]

Just looking for Formulas to try to get this to work...

[barthbradley]

You want to use a Space Schedule. This should give you everything you need. Create one and let me else you need. Be happy to help.  

[Tinman1975]

Adding the Spaces Shedule is not allowing any wattage calculation - 

1- Filter List – Architecture & Electrical

2 - From Rooms

3 - Adding Maybe Actual Lighting Load per area - no wattage fields available  

[Tinman1975]

Wanting a schedule like this -  

[Tinman1975]

@barthbradley 

[barthbradley]

Did you create a Space Schedule @Tinman1975?  If not, create one and include every single Parameter Field that is available.  View the resulting Schedule.  See any columns that are empty of values? Delete those Parameter Fields from the Schedule. Post a screenshot the resulting Schedule.  

[Tinman1975]

@barthbradley yes Mate.. didn't give me the fields i thought would have worked (Lights) 

[Tinman1975]

@barthbradley  the below image is what im aiming for based of a lighting plan layout..

[barthbradley]

---

---

 A Space Schedule???

[Tinman1975]

@barthbradley  what field do you suggest i enter ?

[barthbradley]

Do what I asked in Message 10.  

[Tinman1975]

@barthbradley 

[barthbradley]

Dude! You're killing me here!  I just want to see a screenshot of the actual Space Schedule - excluding any extraneous columns of non-information.  

[Tinman1975]

@barthbradley

 Nothing coming up

 

[Tinman1975]

@barthbradley  this is the lighting Schedule from the same Template

 

[barthbradley]

---

@Tinman1975 wrote:

@barthbradley

 Nothing coming up

 

---

Okay, I guess I should have covered this up front. My bad (I guess).  You first need to create Spaces from those Rooms.  You got Rooms; right?