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

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

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!

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

@CONTRABIM

3 жыл бұрын

Thanks for checking it out and commenting!

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:)

AWESOME JOHN!!! You are the best!

@CONTRABIM

3 жыл бұрын

Thanks Bruce, hope it's useful for you!

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!

thank you

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

and how do you import it?

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: kzread.info/dash/bejne/mJx5m8SAn8vIebA.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

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

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!