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
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.
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:)
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?
@@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.
@@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
@@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 ...
@@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
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!
@@CONTRABIM Thanks for the answer, for other people wondering the same as me, this video helped me out: th-cam.com/video/fhE9bGohbIM/w-d-xo.html&ab_channel=MrExcel.com Had to adjust the code a little bit to make it work :-).
@@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
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!
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!
That's exactly the most useful thing on practice and I'm in the same situation...
Is there already a workflow how to get the .txt file back into Archicad as a Pen Set?
Great work John, very helpful. You're really pushing the limit.
Thanks for checking it out and commenting!
Amazing work! This is so useful and a way of visualising the pensets I hadn't thought of. Thanks for sharing!
Great glad you liked it!
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!
Thanks for the comment Neil! Glad it can be of help!
and how do you import it?
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.
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:)
Thanks, but what is excel management for if we can't import back to archicad after adjusting...
THANKYOU FOR SHARING SIR.. LOVE YOUR WORK
AWESOME JOHN!!!
You are the best!
Thanks Bruce, hope it's useful for you!
Nice work. Question, Why you didn't use tables in your excel sheet ??
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?
@@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.
@@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
@@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 ...
@@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
Nice work! Could yo explain the workflow for that Excel button?
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!
@@CONTRABIM Thanks for the answer, for other people wondering the same as me, this video helped me out: th-cam.com/video/fhE9bGohbIM/w-d-xo.html&ab_channel=MrExcel.com Had to adjust the code a little bit to make it work :-).
@@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
thank you
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?
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!