<\/i> Speed up the tedious stuff and enjoy designing and documentation more<\/li>\n \t

<\/i> Works in all versions of Revit<\/li>\n

<\/i> Information to PROVE your increased speed<\/li>\n<\/ul>\n<\/div>\n\t\n\t PowerKey4Revit Free 30 day Trial<\/span><\/a>\n
<\/div> \n\t\n
<\/span>PowerKey4Revit VIDEO <\/div>
<\/iframe><\/div><\/div><\/div>\n\t\t<\/div><\/div><\/body> <\/html>\n\n\n\nI had previously used Conditional formatting in Excel for condition over time so that you could filter building components by year based on their condition, this would allow you to forecast what work was coming up in the following years. See <a rel=\"noreferrer noopener\" aria-label=\"this example (opens in a new tab)\" href=\"https:\/\/pir2.tk\/web\/data\/ExcelHeatmap\/ExcelIframe.html\" target=\"_blank\">this example<\/a><\/strong> and<a rel=\"noreferrer noopener\" aria-label=\" this article (opens in a new tab)\" href=\"https:\/\/pir2.tk\/index.php\/heatmaps\/\" target=\"_blank\"> <\/a><a rel=\"noreferrer noopener\" aria-label=\" this article (opens in a new tab)\" href=\"https:\/\/pir2.tk\/index.php\/heatmaps\/\" target=\"_blank\">this article<\/a><\/strong>.<\/p>\n\n\n\nWhat I was looking for was a way to reference selected materials and describe them adequately for a schedule and be able to do a simple colour comparison to see that all the elements were in the correct colour range I’d selected. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Process<\/h2>\n\n\n\nFor copy of Excel Workbook click on <a href=\"https:\/\/pir2.tk\/web\/data\/ColourScheme\/ColourSchemeVL.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"LINK (opens in a new tab)\">LINK<\/a><\/strong><\/p>\n\n\n\nI initially just did an extract from a 3D PDF of my house and dropped the data into my excel sheet to get data on room finishes. Its pretty simple, it just has rooms, areas, base material and finish.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"225\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_26_45-28-ColourScheme.xlsx-Excel-1024x225.jpg\" alt=\"\" class=\"wp-image-5309 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_26_45-28-ColourScheme.xlsx-Excel-1024x225.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_26_45-28-ColourScheme.xlsx-Excel-300x66.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_26_45-28-ColourScheme.xlsx-Excel-768x168.jpg 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/225;\" \/><figcaption>room data from 3D PDF<\/figcaption><\/figure>\n\n\n\nI then cleaned this up, because I only really wanted finishes, so the table was reduced to:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"993\" height=\"546\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_29_28-28-ColourScheme.xlsx-Excel.jpg\" alt=\"\" class=\"wp-image-5310 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_29_28-28-ColourScheme.xlsx-Excel.jpg 993w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_29_28-28-ColourScheme.xlsx-Excel-300x165.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_29_28-28-ColourScheme.xlsx-Excel-768x422.jpg 768w\" data-sizes=\"(max-width: 993px) 100vw, 993px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 993px; --smush-placeholder-aspect-ratio: 993\/546;\" \/><figcaption>Room Name\/Number, Floor, Ceiling\/Wall Finish Columns <\/figcaption><\/figure>\n\n\n\nI also wanted 4 faces of walls for rooms, as well as skirting & scotias, so I added these columns in. I also changed some of the references, so instead of Vinyl, there would be different types, as well as paint finishes, carpets etc<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"274\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_35_37-28-ColourScheme.xlsx-Excel-1024x274.jpg\" alt=\"\" class=\"wp-image-5311 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_35_37-28-ColourScheme.xlsx-Excel-1024x274.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_35_37-28-ColourScheme.xlsx-Excel-300x80.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_35_37-28-ColourScheme.xlsx-Excel-768x205.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_35_37-28-ColourScheme.xlsx-Excel.jpg 1755w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/274;\" \/><figcaption>So now I have the basic elements in my rooms (no windows or doors or frames at this time)<\/figcaption><\/figure>\n\n\n\nSo, now I want a list of finishes for these elements, so I make another sheet as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"460\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_41_01-28-ColourScheme.xlsx-Saved-1024x460.jpg\" alt=\"\" class=\"wp-image-5312 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_41_01-28-ColourScheme.xlsx-Saved-1024x460.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_41_01-28-ColourScheme.xlsx-Saved-300x135.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_41_01-28-ColourScheme.xlsx-Saved-768x345.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_41_01-28-ColourScheme.xlsx-Saved.jpg 1756w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/460;\" \/><figcaption>A list of all the elements Floor, Wall, Ceiling, Skirting, Scotia with Manufacturer, model & colour. <\/figcaption><\/figure>\n\n\n\nSo there is a separate Sheet with tables for each Element, with possible materials\/models\/colours relating to that element. You could put this at the bottom of your initial worksheet, but I’ve just put it on another sheet to keep it tidy. If you need to compare later, you can always split the screen and show both sheets.<\/p>\n\n\n\nIn the first sheet we will add 3 blank columns (for manufacturer\/model\/Colour) between each of the current finishes columns<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"217\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_47_33-28-ColourScheme.xlsx-Excel-1024x217.jpg\" alt=\"\" class=\"wp-image-5313 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_47_33-28-ColourScheme.xlsx-Excel-1024x217.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_47_33-28-ColourScheme.xlsx-Excel-300x64.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-15_47_33-28-ColourScheme.xlsx-Excel-768x163.jpg 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/217;\" \/><figcaption>add 3 blank columns for manufacturer\/model\/colour between all the finishes columns<\/figcaption><\/figure>\n\n\n\n\n\n\n\n<h3 class=\"wp-block-heading\">Using Vlookup() in Excel<\/h3>\n\n\n\nSo, in floors , the first active room cell is C2, this holds the material for floor finish. So in Cell D2 we want to be able to lookup the manufacturer for this type of vinyl. We will use the Vlookup() excel function to look to cell C2 on this sheet, compare it to the Floor Finishes table on the next sheet over, when it gets a correct comparison on that table, it will fill in the result of the next column along, which is the manufacturers column. <\/p>\n\n\n\nThe video below demonstrates how you use Vlookup:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to Do a VLOOKUP in Excel - Video Tutorial\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/-WAEzokHSJM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\nso the function in cell D2 looks like this:<\/p>\n\n\n\n=VLOOKUP($C2,Finishes!$A$2:$D$10,2,FALSE)<\/strong><\/p>\n\n\n\nThe $ sign in front of each cell code, of say cell =C2, means that if you have =$C$2 this means this is an a ABSOLUTE CELL REFERENCE , so if you copy that formula by dragging the formula down or across the spreadsheet, that part of the formula will always reference only that cell =$C$2.<\/p>\n\n\n\nIf you just had just =C2 and you dragged that down to the next row (or copied\/pasted) then it would read =C3 instead, so it would be a RELATIVE CELL REFERENCE, not an ABSOLUTE CELL REFERENCE. <\/p>\n\n\n\nSo, now we can use the formula above that says:<\/p>\n\n\n\n\n=VLOOKUP($C2,Finishes!$A$2:$D$10,2,FALSE)<\/strong><\/p>\n\n\n\nLook in Cell C2 and then look up that reference in the table on the finishes sheet and find the corresponding match. When you find it, in column 1 of that table, return to me the value in the 2nd column over on that row (this is Manufacturer). The last FALSE means it must be an absolute match, or don’t return anything (#N\/A). <\/p>\n\n\n\nThe #N\/A would occur if you created in the finishes schedule a type Vinylx (you miss-typed it), there would not be an equivalent in the floor table so you get a Not applicable N\/A. So go check your spelling. <\/p>\n\n\n\n For the next column along, to get make, all we have to do is change the 2 for a 3, as below<\/p>\n\n\n\n =VLOOKUP($C2,Finishes!$A$2:$D$10,3<\/font>,FALSE)<\/strong> <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"291\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_20-28-ColourScheme.xlsx-Excel-1024x291.jpg\" alt=\"\" class=\"wp-image-5315 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_20-28-ColourScheme.xlsx-Excel-1024x291.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_20-28-ColourScheme.xlsx-Excel-300x85.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_20-28-ColourScheme.xlsx-Excel-768x218.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_20-28-ColourScheme.xlsx-Excel.jpg 1782w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/291;\" \/><figcaption>The cells are populated with the vlookup<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"250\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_09-28-ColourScheme.xlsx-Excel-1024x250.jpg\" alt=\"\" class=\"wp-image-5316 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_09-28-ColourScheme.xlsx-Excel-1024x250.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_09-28-ColourScheme.xlsx-Excel-300x73.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_11_09-28-ColourScheme.xlsx-Excel-768x187.jpg 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/250;\" \/><figcaption>Because we are using absolute cells we can copy the Vlookup() formula across and just change column from 2 to 3 and 4<\/figcaption><\/figure>\n\n\n\nSo this has now populated our floor finishes room list with specific materials and finishes. If we change the name of the column from Vinyl1 to Vinyl2 then all the data will change in the next 3 columns, so we are specifying the correct product\/material\/finish<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Show it in colour- Conditional formatting<\/h3>\n\n\n\nSo we can copy the formula across and populate all the other columns, then we can hide the manufacturer\/model\/colour columns as we know they are populating correctly. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"394\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_25_27-28-ColourScheme.xlsx-Saved-1024x394.jpg\" alt=\"\" class=\"wp-image-5317 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_25_27-28-ColourScheme.xlsx-Saved-1024x394.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_25_27-28-ColourScheme.xlsx-Saved-300x115.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_25_27-28-ColourScheme.xlsx-Saved-768x295.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_25_27-28-ColourScheme.xlsx-Saved.jpg 1896w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/394;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"400\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_14-28-ColourScheme.xlsx-Excel-1024x400.jpg\" alt=\"\" class=\"wp-image-5318 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_14-28-ColourScheme.xlsx-Excel-1024x400.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_14-28-ColourScheme.xlsx-Excel-300x117.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_14-28-ColourScheme.xlsx-Excel-768x300.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_14-28-ColourScheme.xlsx-Excel.jpg 1501w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/400;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"870\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_50-28-ColourScheme.xlsx-Excel-1024x870.jpg\" alt=\"\" class=\"wp-image-5319 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_50-28-ColourScheme.xlsx-Excel-1024x870.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_50-28-ColourScheme.xlsx-Excel-300x255.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_50-28-ColourScheme.xlsx-Excel-768x653.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_26_50-28-ColourScheme.xlsx-Excel.jpg 1537w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/870;\" \/><\/figure>\n\n\n\nThe process above can be repeated, or else, as we have one setup now, we can go int the MANAGE RULES<\/strong> of the Conditional Formatting tab<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"489\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_28_04-28-ColourScheme.xlsx-Excel-1024x489.jpg\" alt=\"\" class=\"wp-image-5320 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_28_04-28-ColourScheme.xlsx-Excel-1024x489.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_28_04-28-ColourScheme.xlsx-Excel-300x143.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_28_04-28-ColourScheme.xlsx-Excel-768x367.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_28_04-28-ColourScheme.xlsx-Excel.jpg 1592w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/489;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"389\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_03-28-ColourScheme.xlsx-Excel-1024x389.jpg\" alt=\"\" class=\"wp-image-5321 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_03-28-ColourScheme.xlsx-Excel-1024x389.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_03-28-ColourScheme.xlsx-Excel-300x114.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_03-28-ColourScheme.xlsx-Excel-768x292.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_03-28-ColourScheme.xlsx-Excel.jpg 1653w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/389;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"478\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_22-28-ColourScheme.xlsx-Excel-1024x478.jpg\" alt=\"\" class=\"wp-image-5322 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_22-28-ColourScheme.xlsx-Excel-1024x478.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_22-28-ColourScheme.xlsx-Excel-300x140.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_22-28-ColourScheme.xlsx-Excel-768x358.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_22-28-ColourScheme.xlsx-Excel.jpg 1479w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/478;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"364\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_47-28-ColourScheme.xlsx-Excel-1024x364.jpg\" alt=\"\" class=\"wp-image-5323 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_47-28-ColourScheme.xlsx-Excel-1024x364.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_47-28-ColourScheme.xlsx-Excel-300x107.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_47-28-ColourScheme.xlsx-Excel-768x273.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_33_47-28-ColourScheme.xlsx-Excel.jpg 1643w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/364;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"363\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_34_26-28-ColourScheme.xlsx-Excel-1024x363.jpg\" alt=\"\" class=\"wp-image-5324 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_34_26-28-ColourScheme.xlsx-Excel-1024x363.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_34_26-28-ColourScheme.xlsx-Excel-300x106.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_34_26-28-ColourScheme.xlsx-Excel-768x272.jpg 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/363;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"413\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_35_56-28-ColourScheme.xlsx-Excel-1024x413.jpg\" alt=\"\" class=\"wp-image-5325 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_35_56-28-ColourScheme.xlsx-Excel-1024x413.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_35_56-28-ColourScheme.xlsx-Excel-300x121.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_35_56-28-ColourScheme.xlsx-Excel-768x310.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_35_56-28-ColourScheme.xlsx-Excel.jpg 1398w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/413;\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">The result<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"351\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_45_31-28-ColourScheme.xlsx-Excel-1024x351.jpg\" alt=\"\" class=\"wp-image-5326 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_45_31-28-ColourScheme.xlsx-Excel-1024x351.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_45_31-28-ColourScheme.xlsx-Excel-300x103.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_45_31-28-ColourScheme.xlsx-Excel-768x263.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_45_31-28-ColourScheme.xlsx-Excel.jpg 1590w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/351;\" \/><\/figure>\n\n\n\nUsing the setup above, I have highlighted the Corridor. The colours do not seem to be too good with blues, greens and peach colours. <\/p>\n\n\n\nSo we can start to adjust them by selecting other finishes from the list so that they look more harmonious. <\/p>\n\n\n\nTo help with the referencing we can have the sheet with the tables to show what we are using. We can always adjust the Manufacturer\/Model\/Colour to suit our needs. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"769\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel-1024x769.jpg\" alt=\"\" class=\"wp-image-5327 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel-1024x769.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel-300x225.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel-768x577.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel.jpg 1979w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/769;\" \/><\/figure>\n\n\n\nA further thing I’d add to all the finishes is a comments column, so if you wanted something special, like a feature pattern or something that was specific to that item, then you could reference it in the “Comments” field. <\/p>\n\n\n\nThis is only a method of getting data into Excel to manipulate the colour scheme, or test a number of Schemes. You could create 2 more sheets, your colour scheme sheet and your tables sheet and then create a 2nd colour scheme. You could use FIND\/REPLACE to change the vlookup reference sheet from Finishes to say Finishes2. This keeps all your original setup, you just need to change the colours in your conditional formatting. <\/p>\n\n\n\n =VLOOKUP($C2,Finishes!$A$2:$D$10,2,FALSE) to<\/strong> =VLOOKUP($C2,Finishes2!$A$2:$D$10,2,FALSE)<\/strong> <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Getting data back into Revit<\/h2>\n\n\n\nSeveral ways to transfer data to\/from Revit. You would need to have a Revit Schedule for say floor, walls, etc , they could be separate category schedules, then you need to map the Excel finishes floor to a separate sheet that has the same column headers as the revit schedule, then Export the Revit schedule using BIMOne Export\/Import Excel and copy Values from linked sheet. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">End thoughts<\/h2>\n\n\n\nI am pleased with the result. After trying it in AirTable , then in LibreOffice, in which I had problems with their styles, not as intuitive as I’d thought, just switching from Excel, which I’m used to. <\/p>\n\n\n\nOnce I’d got the principles of what I was trying to do the process was pretty straight forward. It took a little while to setup, specifically the colour filters but once they were up and running it was easy to adjust.<\/p>\n\n\n\n It would have been nice to colour all the fields (inc Manufacturer\/Model\/Colour) but in some ways compressing it makes it easier to view. <\/p>\n\n\n\nI will think about the process as I think you could use macros to speed up some of the steps, maybe even templating part of the process would be good too. Potentially, you could have a colour palette dashboard to do some tweeking. This is transferable to LibreOffice & Google Sheets, I’ll have to try doing both those processes. <\/p>\n","protected":false},"excerpt":{"rendered":"The last post I tried to use AirTable to create a Colour Schedule from a Revit export. Thinking I could use the Database to cross reference items in the room such as doors\/windows etc to be able to pull those in to make the colour scheme planning more comprehensive. It didn’t work. Along the way […]<\/p>\n","protected":false},"author":1,"featured_media":5327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,40,3,264,32,42,12],"tags":[],"class_list":["post-5308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bim","category-data-analysis","category-data-extraction","category-design","category-power-bi","category-productivity","category-visualisation"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/03\/2019-03-14-16_48_06-28-ColourScheme.xlsx-2-Excel.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5308"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/5327"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}