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]

Yes Mate...

[barthbradley]

Can you post a higher resolution screen capture or something? I can't make out sh*t in this one. Your other ones were fine.  

[Tinman1975]

@barthbradley  try this bad boy...

[barthbradley]

Dude, what we've got here is failure to communicate ***.  "SPACE" was the operative word (e.g. SPACE Schedule).  

***“What we’ve got here is...failure to communicate.” - Bing video

[Tinman1975]

HAHA All. Good. Lets shelve it, and have another go next week....

Thanks for you help so far....

@barthbradley 

[Tinman1975]

Any assistance or suggestions on the above scheduling im trying to archive  @ToanDN 

[Tinman1975]

Any assistance or suggestions on the above scheduling im trying to archive @Anonymous 

[Tinman1975]

Any assistance or suggestions on the above scheduling I'm trying to archive  @Anonymous @Anonymous 

[barthbradley]

Seems to me that this it pretty close to what you are looking for...

RVT Attached. 

[Tinman1975]

@barthbradley   Bro, I think i can almost smell it..

Just Need Columns - 

Maximum Wattage per Room (Calculauted in W)

Installed Wattage per Room (Calculauted in W)

Complies (Yes / No) for 5w per m² 

Floor Level

[barthbradley]

---

@Tinman1975 wrote:

@barthbradley   Bro, I think i can almost smell it..

---

Ooh-ooh that smell…

https://www.youtube.com/watch?v=J4j7ggZqbiU

[barthbradley]

Mate! No offense, but as Lynyrd Skynyrd so eloquently put it: "ooh, ooh that smell! Can't you smell that smell?".

What you sent me stinks.  Not even close to what I sent you this morning.  Place some Spaces, Mate and watch the magic happen! 

[Tinman1975 · Accepted solution]

ill need to take on Spaces.. haven't handled that type of scope yet.. but will give it a run. Thanks for your Help.

Ill send some Tim Tams your way

[barthbradley]

WTF! So, you give yourself a Solution Credit? For what???  For being from Australia?  

Okay. I can see your point. After all, those talentless, good-for-nothing  Hemsworths eyesores were able to pull it off, so why can't you? 

Still, I thought you were better than Chris and Liam and Luke and ...whoever that ugly one is,   

[Tinman1975]

Ahhhh. I wouldn't say I have a great knowledge when it comes to using Spaces as well as Schedules.  I work solo for a small builder and do not have many options when things get above my skill level, and or try to upskill. and I'm lucky enough to have you get back to me.. which I'm ever grateful for ?? I thought the credit would have gone in your favor, not 100% over how it works.  As for the Hemsworth's ... I'm happy for then to stay up North... all  of them, even the ugly one.  I'm happy in Bendigo.  

Again mate, thank you for your effort and time... really appreciate it. ill keep working on my Spaces...

[barthbradley]

I think I was a little rough on you last night.  Sorry.

Examine the attached RVT.  Both a Space Schedule and a Lighting Fixture Schedule work well. I let you reverse-engineer what I did.  Also note the the ADJUSTMENT FACTOR and MAXIMUM W/m2 have been added to the Room Category and Space Category via Project Parameters and then pulled into the Schedule from the Available Parameter Fields.   

Things to be aware of: some of your Column Header Name are existing Parameters under another name. For instance DESIGN is the in-built "Space: Actual Lighting Load" and "Actual Lighting Load". I have hidden these field and DESIGN is puling their Values into its Column.   Also note that the Lighting Fixtures Parameter are Hidden as they need to be include in the Total Reporting Fields in order for the Schedule to work. Probably why a Space Schedule would be better, IMO.