Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Calculate row total, linear and non-linear components

23 ANTWORTEN 23
GELÖST
Antworten
Nachricht 1 von 24
marieHPAJL
1540 Aufrufe, 23 Antworten

Calculate row total, linear and non-linear components

I am a lighting designer new to Revit and I would like to make informative schedules showing the cost of the luminaires.

 

So far so good.

 

The problem is that linear lighting  is priced in running meters. When I add linear lighting in a kitchen for instance, I add one piece on linear lighting  (thus counted as 1 in the schedule), but it might be 3m long and the price will be 3 x cost/m. In the same time I will add some other lighting that is non-linear and is priced pr piece.

 

 

So this is the situation:

 

marieHPAJL_0-1608047580494.png

I would like to do something like the following, but dont know what kind of formula I should use:

 
 

marieHPAJL_0-1608048194499.png

The thing is to get the prices for both linear and non-linear lighting in the same column.

Any tips?

23 ANTWORTEN 23
Nachricht 2 von 24
martijn_pater
als Antwort auf: marieHPAJL

I think you could use a yes/no parameter to define linear/non-linear, or a calculated lenght value. Needs a value otherwise when it doesn't have a lenght your if statement will not work. You could also have the cost calculated within the famil(y)(ies) as shared parameter to schedule directly.

 

In any case you need another parameter there...

Nachricht 3 von 24
barthbradley
als Antwort auf: marieHPAJL

Like this:

 

Lighting Costs 2.jpgLight Costs.jpg

Nachricht 4 von 24
marieHPAJL
als Antwort auf: martijn_pater

Hi, Martjin!

 

Oh, I just love parameters:)  Well, I guess I do. Have to learn some more about them though...

 

Nachricht 5 von 24
marieHPAJL
als Antwort auf: barthbradley

Hi, Barth. Thank you for helping me out again - I will make myself a very simple sample family and try this out...

Nachricht 6 von 24
ToanDN
als Antwort auf: marieHPAJL

Use this formula for Calculated Cost:
if (Length >0, (Length / 1m) * [Cost per meter], Cost)

- Cost, Cost per meter, and Calculated Cost are Number parameter for simplicity.
- Nonlinear fixtures should not have Length value, or = 0.
Nachricht 7 von 24
barthbradley
als Antwort auf: ToanDN

I tried that. Doesn't work if the Family doesn't have the "Light Length" parameter.  

 

Isn't this what you are prescribing?:

 

CostT.jpg

 

 

 

Nachricht 8 von 24
martijn_pater
als Antwort auf: barthbradley

Perhaps try to make a kind of "Light Lenght+0" calculated value to give all of those a value? Then test that for the condition with your IF statement, not sure if that works...

Nachricht 9 von 24
barthbradley
als Antwort auf: martijn_pater

I'm done playing with it.   A Calculated Parameter using a conditional statement to evaluate a Yes/No Project Parameter is the way to go.  

Nachricht 10 von 24
marieHPAJL
als Antwort auf: barthbradley

This worked great!

marieHPAJL_0-1608063926615.png

Thanks very much to the two of you. 

 

I still have one question though - do you think it is possible to "not itemize" and still end up with the right total price?

 

Now this happens:

 

marieHPAJL_1-1608064107158.png

 I

Nachricht 11 von 24
barthbradley
als Antwort auf: marieHPAJL

How are you sorting? Don't sort.  

Nachricht 12 von 24
barthbradley
als Antwort auf: marieHPAJL

How come you don't have checkboxes in all the rows?  Is this a Multi-Category Schedule? Did you not mark some Categories for the Yes/No Project Parameter?  

Nachricht 13 von 24
marieHPAJL
als Antwort auf: barthbradley

That is my fault. I didn't assign the parameter in question to the ones that ended up without a checkbox!

Nachricht 14 von 24
martijn_pater
als Antwort auf: martijn_pater


@martijn_pater wrote:

Perhaps try to make a kind of "Light Lenght+0" calculated value to give all of those a value? Then test that for the condition with your IF statement, not sure if that works...


FYI it doesn't. There doesn't really seem to be any method to do a kind of "has a value" checking other then adding a yes/no parameter for the type (or similar), as mentioned.

You could only split the schedule filtering for "has a value", one with one without but I suppose... except that would probably make it difficult to do totals...

 

related topic: https://forums.autodesk.com/t5/revit-architecture-forum/scheduling-cant-evaluate-a-null-nil-field/td...
(with some links to idea forum posts)

Nachricht 15 von 24
ToanDN
als Antwort auf: marieHPAJL

here is an example without adding a Yes/no.

 

ToanDN_0-1608139843451.png

 

Nachricht 16 von 24
ToanDN
als Antwort auf: marieHPAJL

.. Grouped and subtotaled per Type

 

ToanDN_0-1608141680463.png

 

Nachricht 17 von 24
barthbradley
als Antwort auf: ToanDN

seems to me that the OP should buy us all a round of Solution Credits. 

 

Just saying...

 

:zwinkerndes_Gesicht: 

Nachricht 18 von 24
barthbradley
als Antwort auf: marieHPAJL

I appreciate the "Like" @marieHPAJL, but I was more thinking we all deserved on of these tasty 'lil intoxications: 

 

Solution Credit.jpg

 

...maybe even with a garnish and tiny umbrella in them.  

 

Bottoms Up! 

 

 

Nachricht 19 von 24
martijn_pater
als Antwort auf: barthbradley

Well I think post #9 summarizes it...

Nachricht 20 von 24
barthbradley
als Antwort auf: martijn_pater

I appreciate that @martijn_pater, but I think we all shined on this one. No winners or losers. It was a team effort all the way. Even, @marieHPAJL contributed to the success.  Without Marie, it wouldn't have been possible.  

 

:zwinkerndes_Gesicht:

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report