How to Manage

Рет қаралды 17,546

3 жыл бұрын

Pen Rig Download: www.contrabim.com/blog/pen-se...
In this video we'll introduce a few free tools you can download from our blog, that we've been using for setting up a management process of Archicad Pens!
About CONTRABIM:
Our mission is to help Architects, Engineers and Builders navigate the complexities of designing and building with 3D Virtual Models in Archicad BIM Software, through thoughtfully produced templates and training programs to help them implement a strategic workflow, enabling them to deliver projects faster, win more work, reduce waste and increase profits.
CONTRABIM Network:
To serve our community, we've launched the CONTRABIM Network which includes access to all of our Archicad Templates, Training Programs and Tools to help fast track users learning and adoption of BIM. Join the community today to get instant access to training and downloads.
Website: www.contrabim.com/
Join: www.contrabim.com/offers/qhVA...
Blog: www.contrabim.com/blog
Linkedin: / contrabim
Facebook: / contrabim
Instagram: / contrabim
If you're interested in building the macro yourself. You can adjust this code also!
Sub UpdateColors()
'
' UpdateColors Macro
' Updates based on RGB Values of Selected Cells
For Each Cell In Selection
R = Cell.Offset(0, 2).Value
g = Cell.Offset(0, 3).Value
B = Cell.Offset(0, 4).Value
Cell.Resize.Interior.Color = RGB(R, g, B)
Next Cell
End Sub

Пікірлер: 28

@CONTRABIM 3 жыл бұрын

I've updated the download package to include additional modules for v22 and v23! You can download these from the blog. www.contrabim.com/blog/pen-set-tools

@neiliusflavius 3 жыл бұрын

This is exactly what I'd been thinking about doing but you actually knew how to do it and did it. This will be really useful. Thanks!

@CONTRABIM 3 жыл бұрын

Thanks for the comment Neil! Glad it can be of help!

@archi-k4117 3 жыл бұрын

Great work John, very helpful. You're really pushing the limit.

@CONTRABIM 3 жыл бұрын

Thanks for checking it out and commenting!

@nielsonhuang6251 3 жыл бұрын

Thank you for sharing, sir John. Really appreciate your hard work. I used your pen set as reference, and I found your pen settings (especially line weight) are really useful on creating a clear section/elevation, I can get a better result by just tweaking the pen weight.

@CONTRABIM 3 жыл бұрын

Hi Nielson. Glad you found the video helpful. I'm not sure which specific pen set you're referring to here, but glad it helped out and set you on your way in determining your own pen settings! I'll review my new custom pen set at some point here soon, with more tips and tricks on how they can be used:)

@AikenBruce 3 жыл бұрын

AWESOME JOHN!!! You are the best!

@CONTRABIM 3 жыл бұрын

Thanks Bruce, hope it's useful for you!

@enzoguida6135 Жыл бұрын

Amazing work! This is so useful and a way of visualising the pensets I hadn't thought of. Thanks for sharing!

@CONTRABIM Жыл бұрын

Great glad you liked it!

@Gustavostarke 10 ай бұрын

This is great. But after creating my custom pen set, how do I actually transfer/import it to archicad? Thanks in advance!

@odkhuu5723 3 жыл бұрын

thank you

@someJernej 6 ай бұрын

Is there already a workflow how to get the .txt file back into Archicad as a Pen Set?

@JoelMendez-wr4kv 5 ай бұрын

and how do you import it?

@kijkrond1084 3 жыл бұрын

Nice work! Could yo explain the workflow for that Excel button?

@CONTRABIM 3 жыл бұрын

Thanks! The button runs a macro that colorizes cells based on values to the right, offset by 2,3&4 columns to hit the R,G,B number (0-255). The cell is then reformatted to the color equaling the RGB. This only really works in the cells left of the index number. If you select other cells that are not to the left of the index, this macro will return 0,0,0, for RGBs, and thus making the cell black! You can check out the simple code in the VB module and adjust if you'd like, thanks for the question!

@kijkrond1084 3 жыл бұрын

@@CONTRABIM Thanks for the answer, for other people wondering the same as me, this video helped me out: kzfaq.info/get/bejne/nM51bMV41M7GeYE.html&ab_channel=MrExcel.com Had to adjust the code a little bit to make it work :-).

@CONTRABIM 3 жыл бұрын

@@kijkrond1084 Yep that is a good reference video! Here's the actual code I ended up using on the last version: Sub UpdateColors() ' ' UpdateColors Macro ' Updates based on RGB Values of Selected Cells For Each Cell In Selection R = Cell.Offset(0, 2).Value g = Cell.Offset(0, 3).Value B = Cell.Offset(0, 4).Value Cell.Resize.Interior.Color = RGB(R, g, B) Next Cell End Sub

@naderbelal8439 3 жыл бұрын

Nice work. Question, Why you didn't use tables in your excel sheet ??

@CONTRABIM 3 жыл бұрын

Hi Nader, thanks for the comment! You certainly could add a table into the excel sheet. But for filtering purposes, it's important to make sure to have a value in the colored cells. Otherwise the table won't pick it up and filter and sort with the others... I'm curious, what would you do with a table in this case besides sort and filter?

@naderbelal8439 3 жыл бұрын

@@CONTRABIM On contrar my friend, sorting and filtering per row in a table is possible, besides, you can add more columns so that their concatenation would create a meaningful description ... But I confess that I have no idea if your macro would work with in a table.

@CONTRABIM 3 жыл бұрын

@@naderbelal8439 Oh yes certainly a table will be able to filter, my point was to filter the colors along with it those colorized cells require a value first, otherwise the table doesn't recognize it and they won't move with any sorting... The macro does function within a table, no problems! Good point on adding more columns for extra clarity on notes and uses...I've been doing that off to the side

@naderbelal8439 3 жыл бұрын

@@CONTRABIM Is their a function in Excel for converting RBG values to "#FFFFF" values ??? If so, then you could also filter those coloured cells by their Hex values ...

@naderbelal8439 3 жыл бұрын

@@CONTRABIM Or you can filter the coloured cells if they had the concatenation of RGB values seperated with a space ... thus anyone can filter them easily

@marisbesakirskij4728 3 жыл бұрын

John, where can i donate you some money? You give that for free. I cannot afford your big kits, but i really want to support your work. Maybe paypal?

@CONTRABIM 3 жыл бұрын

Hi Maris, I super appreciate the comment and support! I enjoy providing free content to hopefully help others, but I'll look into how to setup a donation option, shouldn't be too had... thanks so much for the question!