{"id":4473,"date":"2018-11-13T18:18:31","date_gmt":"2018-11-13T18:18:31","guid":{"rendered":"https:\/\/max-drake.cc\/?p=4473"},"modified":"2022-03-29T19:38:30","modified_gmt":"2022-03-29T19:38:30","slug":"revit-crowd-seating-visual-numbering-colouring-random-and-ordered","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=4473","title":{"rendered":"Revit- Crowd seating, visual numbering, colouring ordered and random"},"content":{"rendered":"\n<p>Capturing auditoria, theatres etc for AM\/FM and for ongoing use of the model for seating planning can be useful. With numbered seating you can allocate different prices for different seating, you can also change pricing for different event configurations for multi-purpose arrangements.<br>I have done seating on a number of buildings in Wellington when working for WCC (Wellington City Council) for their buildings. I was hoping that the models could be used as part of the marketing of the centres for different event configurations. Alas, to date that has not occurred.<\/p>\n\n\n\n<!DOCTYPE html><html> <head><meta http-equiv=\"content-type\" content=\"text\/html; charset=\"> \n    <\/head> <body> <div class=\"su-box su-box-style-glass\" id=\"\" style=\"border-color:#0f5897;border-radius:5px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#428bca;color:#FFFFFF;border-top-left-radius:3px;border-top-right-radius:3px\">PowerKey4Revit                               Free 30 day Trial<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:3px;border-bottom-right-radius:3px\">\n\t<div class=\"su-list\" style=\"margin-left:0px\">\n<ul>\n<li><i class=\"sui sui-star\" style=\"color:#428bca\"><\/i> Speed up the tedious stuff and enjoy designing and documentation more<\/li>\n \t<li><i class=\"sui sui-star\" style=\"color:#428bca\"><\/i> Works in all versions of Revit<\/li>\n<li><i class=\"sui sui-star\" style=\"color:#428bca\"><\/i> Information to PROVE your increased speed<\/li>\n<\/ul>\n<\/div>\n\t\n\t<a href=\"https:\/\/datacapture.tk?utm_source=websiteArticle&#038;utm_medium=web&#038;utm_campaign=PushTrafficToSite20220330&#038;utm_id=PowerKey4Revit\" class=\"su-button su-button-style-glass\" style=\"color:#FFFFFF;background-color:#428bca;border-color:#3570a2;border-radius:6px\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color:#FFFFFF;padding:0px 18px;font-size:14px;line-height:28px;border-color:#7baeda;border-radius:6px;text-shadow:none\"> PowerKey4Revit Free 30 day Trial<\/span><\/a>\n<div class=\"su-spacer\" style=\"height:20px\"><\/div> \n\t\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-circle my-custom-spoiler su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>PowerKey4Revit VIDEO <\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><div class=\"su-youtube su-u-responsive-media-yes\"><iframe width=\"600\" height=\"400\" data-src=\"https:\/\/www.youtube.com\/embed\/1eFJAzWhOLU?\" frameborder=\"0\" allowfullscreen allow=\"autoplay; encrypted-media; picture-in-picture\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/div><\/div><\/div>\n\t\t<\/div><\/div><\/body> <\/html>\n\n\n\n<p>I have since been working with a small architectural firm and have been trying to set up some scheduling for the seating. In this instance there were different coloured seating which had a randomness about it, that was later tuned to the designers preference.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"704\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im30-1024x704.jpg\" alt=\"\" class=\"wp-image-4474 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im30-1024x704.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im30-300x206.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im30-768x528.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\/704;\" \/><\/figure><\/div>\n\n\n\n<p>To start with, a seat family is required. I did use another family for earlier work but found the<br><a href=\"https:\/\/www.husseyseating.com\/revit\" target=\"_blank\" rel=\"noopener\">Hussey Families<\/a> very well modelled and adaptable.&nbsp; The seat below is the Hussey Fusion. There are even some neat ones with cup holders. The one below can be displayed with seat up or down too.<\/p>\n\n\n\n<p>The seat family can show floor or wall fixings, also showing Left\/Right side brackets with tick boxes in the properties dialogue for the family.<\/p>\n\n\n\n<p>A very nice family from Hussey, thank you.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Seat numbering<\/h3>\n\n\n\n<p>We can just add a project or shared parameter to the Seat category, in this case it is under <strong>Speciality Equipment<\/strong> Category. Then we can schedule them.&nbsp; But if we want to tag them then it needs to be a Shared Parameter as project parameters can&#8217;t be tagged. So I created a <strong>Shared Parameter<\/strong> called &#8220;<strong>Seat Number<\/strong>&#8221;&nbsp; so now the seats can be tagged in 2D as in the 2 images below. This is fine if you want to just display seat numbers in 2D plans. But what do you do if you want the seat numbers in 3D views?<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"489\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im32-1024x489.jpg\" alt=\"\" class=\"wp-image-4477 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im32-1024x489.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im32-300x143.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im32-768x366.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\/489;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"453\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im33-1024x453.jpg\" alt=\"\" class=\"wp-image-4476 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im33-1024x453.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im33-300x133.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im33-768x340.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\/453;\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Seat numbers in 3D<\/h3>\n\n\n\n<p>what we do in 3D is add some 3D text into the seat family. This allows us to display the 3D text in 3d views.&nbsp; I float the 3D text over the seat, although you could have it vertically in front of the backrest too, then it would be clearer in elevations. You could also have a visibility tick box to either display it or hide it (I haven&#8217;t tried that yet).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"707\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im31-1024x707.jpg\" alt=\"\" class=\"wp-image-4475 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im31-1024x707.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im31-300x207.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im31-768x531.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\/707;\" \/><\/figure>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"643\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im36-1024x643.jpg\" alt=\"\" class=\"wp-image-4480 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im36-1024x643.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im36-300x189.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im36-768x483.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im36-200x125.jpg 200w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/643;\" \/><\/figure><\/div>\n\n\n\n<p>I use the 3D text from the Room Name cube from the Case App Add-in. These already have parameters attached to them, so its just a matter of selecting annother parameter and putting the 3D text onto the <strong>Speciality Equipment<\/strong> Category. Then it all works. I have found that the install from BimOne for the Case Apps does not work, but <a href=\"https:\/\/github.com\/rudderdon\/case-apps\" target=\"_blank\" rel=\"noopener\">Don Rudders Github link<\/a> works, unfortunately only for 2015,16 and 17 versions so far (so set up 3d text in older version of revit and send your family to a later version).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Actually numbering all the seats<\/h3>\n\n\n\n<p>Going and writing all the seat numbers can drive you cracked.<\/p>\n\n\n\n<p>I have a couple of techniques. First, I select a complete row and give the selection <strong>Seat Number<\/strong> parameter it its letter A,B,C&#8230;. so you can see all the row with the same letter on.<\/p>\n\n\n\n<p>Then I use a Renumbering Add-In. These are pretty good as they will do sequential, also adding prefixes and suffixes and Zero Padding ( which is good for numbers 1 to 9 (or rather 01, to 09) as this helps with sorting in the schedules.<\/p>\n\n\n\n<p>The current free numbering add in is <a href=\"https:\/\/apps.autodesk.com\/RVT\/en\/Detail\/Index?id=6951474899027933388&amp;appLang=en&amp;os=Win64\" target=\"_blank\" rel=\"noopener\">ElementRenumbering<\/a> by Juan Osborne (thank you for this tool Juan).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"876\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im34-1024x876.jpg\" alt=\"\" class=\"wp-image-4478 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im34-1024x876.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im34-300x257.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im34-768x657.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im34.jpg 1959w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/876;\" \/><\/figure><\/div>\n\n\n\n<p>I have used others, some paid , others free. The first one I used was <a href=\"http:\/\/wiip.biz\/content\/wiip-numbering-revit\" target=\"_blank\" rel=\"noopener\">WIIP numbering<\/a> which I used in the 2015 version and that was a good tool. I also used the <a href=\"https:\/\/apps.autodesk.com\/RVT\/en\/Detail\/Index?id=7836060611782526587&amp;appLang=en&amp;os=Win64\" target=\"_blank\" rel=\"noopener\">Redbike AutoRenumber<\/a> when it was free, now you have to pay for it.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"848\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im35-1024x848.jpg\" alt=\"\" class=\"wp-image-4479 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im35-1024x848.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im35-300x249.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im35-768x636.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im35.jpg 1925w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/848;\" \/><\/figure>\n\n\n\n<p>The re-numbering add-in is a useful tool at times. Sometimes you can send the schedule out to Excel and manage the numbering there, sometimes the renumbering tool inside revit works best. With the seating its great, especially if the seats are tagged (2d or 3d) so you can see that you are picking the seats in the correct order. Once you have them all numbered then they are great for scheduling and exporting to Excel for sorting and adding things to.<\/p>\n\n\n\n<p><strong>Back to the 3D seat numbers. Issues with model size and speed.&nbsp;<\/strong><\/p>\n\n\n\n<p>On the theatre\/event centre&nbsp; models I did with WCC I had all the seats in the models with 3D text. The models were big. In the architectural practice I was working in they linked the seating into the main model. This is a great idea as the seating, once arranged, is only used when you are printing out your document set, so can be unloaded while you are working on the rest of the model, thereby speeding up your work.<\/p>\n\n\n\n<p>This is particularly true with the 3D numbers being in the Seat family.&nbsp; On the project I was working on it had about 1000 seats. When the seats were in a model on their own, the size of the Revit file was about 6Mb even with the shared Seat Number parameter for each seat filled in.<\/p>\n\n\n\n<p>When I put the 3d text into the family and have each seat separately numbered the file size goes from about 6Mb to about 45Mb, so quite scary. So in this particular project I have 2 seating models, one with 3D numbers in and one without, and link whichever one I want to display.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Colours\/Options for seating<\/h3>\n\n\n\n<p>You can colour seating for different events depending on orientation\/location of seats with regard to proximity and visual sightlines. The first image below would be set up for a stage\/concert\/catwalk. The ones nearest the event (Yellow) are the best seats, the ok ones are blue and the cheaper ones are Red.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"898\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im38-1024x898.jpg\" alt=\"\" class=\"wp-image-4481 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im38-1024x898.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im38-300x263.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im38-768x674.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im38.jpg 1832w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/898;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"910\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im37-1024x910.jpg\" alt=\"\" class=\"wp-image-4482 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im37-1024x910.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im37-300x267.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im37-768x683.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im37.jpg 1738w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/910;\" \/><\/figure><\/div>\n\n\n\n<p>For a basketball event the orientation would be different and so the seats would have a different value. ( I actually think the centre court would be rotated 90 degrees otherwise the yellow seats get a view of the back screen of the hoop), so Yellow high value seats, blue average value and red low value. <\/p>\n\n\n\n<p>Another way to use colour is actual colour of seats, so that a design pattern for the seating can be developed. In the one below I used a random number generator in Excel for numbers between 1 and 3 and used that formula on the seating.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"599\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im39-1024x599.jpg\" alt=\"\" class=\"wp-image-4483 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im39-1024x599.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im39-300x175.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im39-768x449.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\/599;\" \/><\/figure><\/div>\n\n\n\n<p>In the top case I used 2 project or shared parameters one say BBCol (Basketball Colour) the other CC (Concert Colour) which i can assign numbers to.In the 2nd example, I just used a single parameter called seat colour. You could extend these parameters, then assign the colour to the back of the seat and the base of the seat if you required more complexity.<\/p>\n\n\n\n<p>So how do we actually show the colours? Using FILTERS<\/p>\n\n\n\n<p>We set up a filter for each number that is likely to occur, in this case, 1,2 &amp; 3 and then if it filters to a number then choose a colour to display.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"557\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im40-1024x557.jpg\" alt=\"\" class=\"wp-image-4484 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im40-1024x557.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im40-300x163.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im40-768x418.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\/557;\" \/><\/figure><\/div>\n\n\n\n<p>As well as geometrically displaying the seating by colour, you can also do it graphically using schedules and using conditional formatting to display different colours for the seating <img decoding=\"async\" class=\"wp-image-4485 alignnone lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im41.jpg\" alt=\"\" width=\"922\" height=\"1523\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im41.jpg 505w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im41-182x300.jpg 182w\" data-sizes=\"(max-width: 922px) 100vw, 922px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 922px; --smush-placeholder-aspect-ratio: 922\/1523;\" \/><\/p>\n\n\n\n<p>So that you can itemise each seat by number and colour and with type and count as well. Below is schedule on a sheet for 1010 seats.<\/p>\n\n\n\n<p>You can also do a more simple table by not itemising each separate seat and only doing it by type. In this case, floor fixed or wall fixed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"714\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im42-714x1024.jpg\" alt=\"\" class=\"wp-image-4486 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im42-714x1024.jpg 714w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im42-209x300.jpg 209w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im42-768x1101.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im42.jpg 1039w\" data-sizes=\"(max-width: 714px) 100vw, 714px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 714px; --smush-placeholder-aspect-ratio: 714\/1024;\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Randomising colours<\/h3>\n\n\n\n<p>To be able to randomise the numbers of the seats between 1 &amp; 3 or 1 and 10 (if you want 10 colours) you need to export the schedule to Excel, there you can use some formulae.<\/p>\n\n\n\n<p>I use BIMOne&nbsp; Export\/Import to excel as its free and easy. I sometimes use the Case Apps for exporting categories to Excel (the export schedules to Exceller8 doesn&#8217;t work in my Case Apps) and synchronise (see the 3rd image down). There is also another free one out<\/p>\n\n\n\n<p><a href=\"http:\/\/revitaddons.blogspot.com\/2018\/11\/sheetlink-synchronize-model-data-with.html\" target=\"_blank\" rel=\"noopener\">Free SheetLink \u2013 Synchronize Model Data with Spreadsheets<\/a>&nbsp; but I think that dumps out Categories rather than schedules, so you have to hide a lot of columns to be able to view the data that you want to look at.<\/p>\n\n\n\n<p>The first time I was using BIM One for this the Seat Colour column data would not come out, and I&#8217;ve just realised that its because I had it hidden, oops!). Anyway, export to Excel<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"776\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im43-1024x776.jpg\" alt=\"\" class=\"wp-image-4489 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im43-1024x776.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im43-300x227.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im43-768x582.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im43.jpg 1514w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/776;\" \/><\/figure><\/div>\n\n\n\n<p>So we have the export to Excel<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"671\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im44-671x1024.jpg\" alt=\"\" class=\"wp-image-4488 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im44-671x1024.jpg 671w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im44-196x300.jpg 196w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im44-768x1173.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im44.jpg 772w\" data-sizes=\"(max-width: 671px) 100vw, 671px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 671px; --smush-placeholder-aspect-ratio: 671\/1024;\" \/><\/figure><\/div>\n\n\n\n<p>This is another method of exporting\/importing data free form to Revit\/Excel using the Case free apps.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"712\" height=\"546\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im45.jpg\" alt=\"\" class=\"wp-image-4487 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im45.jpg 712w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im45-300x230.jpg 300w\" data-sizes=\"(max-width: 712px) 100vw, 712px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 712px; --smush-placeholder-aspect-ratio: 712\/546;\" \/><\/figure><\/div>\n\n\n\n<p>So after unprotecting the sheet<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"482\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im46-1024x482.jpg\" alt=\"\" class=\"wp-image-4491 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im46-1024x482.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im46-300x141.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im46-768x362.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im46.jpg 1285w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/482;\" \/><\/figure><\/div>\n\n\n\n<p>Type in the formula in an empty column on the first line of seats<\/p>\n\n\n\n<p>=RANDBETWEEN(1,3)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"425\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im47-1024x425.jpg\" alt=\"\" class=\"wp-image-4490 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im47-1024x425.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im47-300x124.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im47-768x319.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im47.jpg 1232w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/425;\" \/><\/figure><\/div>\n\n\n\n<p>Then copy this down to all the cells, remember that there is the formula in the actual cell, so you need to copy VALUES ONLY otherwise you just copy a formula into the Seat Colour column and that doesn&#8217;t work when being imported back into revit Schedule.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"669\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im48-669x1024.jpg\" alt=\"\" class=\"wp-image-4495 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im48-669x1024.jpg 669w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im48-196x300.jpg 196w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im48.jpg 736w\" data-sizes=\"(max-width: 669px) 100vw, 669px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 669px; --smush-placeholder-aspect-ratio: 669\/1024;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"827\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im49-1024x827.jpg\" alt=\"\" class=\"wp-image-4494 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im49-1024x827.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im49-300x242.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im49-768x620.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im49.jpg 1044w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/827;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"794\" height=\"918\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im50.jpg\" alt=\"\" class=\"wp-image-4493 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im50.jpg 794w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im50-259x300.jpg 259w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im50-768x888.jpg 768w\" data-sizes=\"(max-width: 794px) 100vw, 794px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 794px; --smush-placeholder-aspect-ratio: 794\/918;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"703\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im51-703x1024.jpg\" alt=\"\" class=\"wp-image-4492 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im51-703x1024.jpg 703w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im51-206x300.jpg 206w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im51.jpg 734w\" data-sizes=\"(max-width: 703px) 100vw, 703px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 703px; --smush-placeholder-aspect-ratio: 703\/1024;\" \/><\/figure><\/div>\n\n\n\n<p>&nbsp; Then use BIMOne to import the excel file back into Revit. Actually, this gives an error.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"773\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im53-1024x773.jpg\" alt=\"\" class=\"wp-image-4496 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im53-1024x773.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im53-300x227.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im53-768x580.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im53.jpg 1565w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/773;\" \/><\/figure>\n\n\n\n<p>That is why I used Case App for Categories. I forgot about BIM One not working.<\/p>\n\n\n\n<p>The Case Sync is slower, but more thorough. I highlighted a number for seat R01 as Seat Colour 3 (which it was not originally)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"466\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im54-1024x466.jpg\" alt=\"\" class=\"wp-image-4498 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im54-1024x466.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im54-300x137.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im54-768x350.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\/466;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"937\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im55-937x1024.jpg\" alt=\"\" class=\"wp-image-4499 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im55-937x1024.jpg 937w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im55-274x300.jpg 274w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im55-768x840.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im55.jpg 1263w\" data-sizes=\"(max-width: 937px) 100vw, 937px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 937px; --smush-placeholder-aspect-ratio: 937\/1024;\" \/><\/figure><\/div>\n\n\n\n<p>and it comes back into the scheduler as 3 for seat R01.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"834\" height=\"822\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im56.jpg\" alt=\"\" class=\"wp-image-4497 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im56.jpg 834w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im56-300x296.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im56-768x757.jpg 768w\" data-sizes=\"(max-width: 834px) 100vw, 834px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 834px; --smush-placeholder-aspect-ratio: 834\/822;\" \/><\/figure><\/div>\n\n\n\n<p>This populates the <strong>Seat Colour<\/strong> column and then you can adjust it by eye.\/ If you do not like it then re-run the radomiser again and you&#8217;ll get different numbers as a base start point<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Another model colouring method using Color Splasher<\/h3>\n\n\n\n<p>A quick way to check out colour schemes is to use Color Splasher add-in by BIMOne. After opening the add-in select the category that you want to colour, in this case Speciality Equiptment, then choose the parameter that you want to colour. In this case we want Seat Colour.&nbsp; As soon as you have this parameter selected it shows all the instances of that parameter with a different colour against each instance, in this case 1,2 &amp; 3. If you click on the instance, you can select an individual colour to change it, then when you are happy with the colours, you hit the apply color set button and the category will be coloured.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"568\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im04-1024x568.jpg\" alt=\"\" class=\"wp-image-4506 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im04-1024x568.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im04-300x166.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im04-768x426.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\/568;\" \/><\/figure><\/div>\n\n\n\n<p>To clear the colour scheme just hit the Clear Set button in the bottom right hand corner.<\/p>\n\n\n\n<p>You can also make a unique colour scheme and save it, also you can load that scheme for re-use.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"618\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im05-1024x618.jpg\" alt=\"\" class=\"wp-image-4505 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im05-1024x618.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im05-300x181.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im05-768x464.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\/618;\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"422\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im06-1024x422.jpg\" alt=\"\" class=\"wp-image-4508 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im06-1024x422.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im06-300x124.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im06-768x317.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im06.jpg 1256w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/422;\" \/><\/figure><\/div>\n\n\n\n<p>The colour scheme file is pretty simple, using hex codes (plus &#8220;FF&#8221; at the front of the code) for colours, so you could write your own codes in if you knew the instance values that you had to work with. This could be quite useful if you were fine tuning colours.<\/p>\n\n\n\n<p>The Hex colour code page where you can put in your Hex number to see the colour and other information about it.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"884\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im07-1024x884.jpg\" alt=\"\" class=\"wp-image-4509 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im07-1024x884.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im07-300x259.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im07-768x663.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im07.jpg 2014w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/884;\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">End thoughts<\/h3>\n\n\n\n<p>I do recollect I had a lot of frustration with the Excel import\/export from BIM One, but their&nbsp; color splasher tool is absolutely brilliant.<\/p>\n\n\n\n<p>The Color Splasher to paint a view using the number perameters, much quicker than using the filters and easy to manipulate on screen without going into the visibility graphics pop-up and selecting filter tab etc.<\/p>\n\n\n\n<p>This process is something that has evolved over time. Each time I have another attempt at it I find ways to make it either easier (using links) or more complicated (using randomiser). The nice thing is that these are all free add-ins that are used.<\/p>\n\n\n\n<p>The one tedious bit is going along the rows numbering each seat consecutively.&nbsp; I suppose I could consider a Dynamo method of doing that, maybe later.<\/p>\n\n\n\n<p>Some of the processes can be extended so that they can be used on things like external cladding panels or floor tiles where a randomness factor may need to be included.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Capturing auditoria, theatres etc for AM\/FM and for ongoing use of the model for seating planning can be useful. With numbered seating you can allocate different prices for different seating, you can also change pricing for different event configurations for multi-purpose arrangements.I have done seating on a number of buildings in Wellington when working for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,40,3,4,32,12],"tags":[],"class_list":["post-4473","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bim","category-data-analysis","category-data-extraction","category-drawings","category-power-bi","category-visualisation"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im30.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/11\/im30.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\/4473","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=4473"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/4473\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/4474"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}