Recently I was asked by my brother and his fiancée if I would make cocktails at their Indian Mendhi night wedding celebrations up in London in a few months’ time. Now I LOVE cocktails (especially in the summer) and this got me thinking: what’s the best drink to make, if you want to take advantage of economies of scale, especially when serving drinks for a large crowd at an event?
I decided the only way was to create a simple spreadsheet, but this quickly escalated into a dashboard-esque suite of tools for analysing a host of our favourite cocktails, including Piña Coladas, Jamaican Rum Punch, Mojitos and more!
Vaguely inspired by this: The Architecture of Happy Hour: plotted, not stirred, the Google Sheet is reminiscent of a schedule or cost-benefit analysis in architecture. The tool is complete with inputs allowing you to test specific numbers of servings, adjusting prices of ingredients. It even provides a graph of costs vs servings for the first 200 drinks, showing the point at which the cost per serving reaches almost its minimum for each drink.
Because I am such a generous guy, and because I want all the other cocktail-nerds out there to enjoy my tool this summer – I’ve shared the spreadsheet online for anybody to look at, build on, and tweak toward their needs. (With the small caveat that it is not to be used commercially, this is completely free… if you do enjoy using it, and would like to say thank you however, you’re more than welcome to buy me a coffee through PayPal.)
Without further a-do, please view an embedded (non-editable) version below – with a link to view/copy the full customisable Google sheet to your own account below that.
Firstly, make sure that you create a copy for yourself (in your Google account), as above
Simply adjust/change/add to the ingredients in blue using the drop-down menu, as above (the choices available are all linked to the ingredients price list sheet – but more on that later). Adjust the serving sizes of each element in blue if needed (these are in millilitres – but there’s a handy unit conversion rate in the ‘conversions’ sheet if required).
Once you’re happy with the ratios, simply adjust the servings number required and the drink costs, buy numbers, and leftover amounts will all update automatically!
Updating ingredients and their prices
All prices for ingredients are based on a domestic-scale UK (Tesco) grocery shop. You may be able to find cheaper ingredients in your part of the world… In order to update the costs, go to the Ingredient Prices sheet (tab on the bottom) and then adjust the prices and amounts per bottle/pack/jar as necessary. Also add to this list to add more choices in the main dropdowns by adding in another row.
IMPORTANT: Make sure you sort the list after adding any new ingredients like so, otherwise the prices may go awry:
So that’s it, feel free to take a copy of this sheet, and add to it or customise it however you want! If you come up with any more great tasty cocktails, or uses for this sheet let me know in the comments section below.
Over the past couple of weeks, I’ve been revisiting a piece of software that I had tried out a few years ago, but had gotten frustrated by and eventually put down, due to limitations that the program had at the time and my own time constraints.
The piece of software is called Blender, and it’s a completely free package with an amazing community of artists following who use it for everything from product design to feature-length films. I decided to give it another try whilst looking for a cheaper alternative to 3DS Max to work into my workflow in architecture.
Previously I had tried real-time visualisation tools such as TwinMotion, as it works on a Mac, and the connection between the software and Archicad is fairly straight forward with a one-button plugin for exporting the model. Again though, the program is expensive, and isn’t particularly user-friendly — you still have to create or apply photo-real textures after exporting, and without masses of tweaking, the overall look is slightly cartoonish.
ArchiCAD’s built-in renderer (Cinema 4D) is great, but for scenes where you need photo-realism, all the scene-fillers that really bring a rendering to life aren’t feasibly achievable in BIM. It’s just not worth modelling small details, plants and entourage and storing them in the architectural model, as it quickly slows down drawings and creates more to manage when changing the design in the future.
Thankfully ArchiCAD has the ability to export the model as a 3D Studio (.3ds) file and import it into Blender. From here, its easy to really focus in on an area to be presented, and then fill it with all the lovely details you want for rendering. You still have to create materials, but at least with the node editor, you can fine-tune these and play around with the properties.
This is a rendering that I recently completed at work for promotional uses:
Now, I’m only a beginner when it comes to UV mapping, modelling landscapes and artificial lighting but I’m really happy with the result and through my first month of learning the software, there have been a few aspects that stand out for me, solidifying blender as my go-to visualisation/organic modelling software.
1. Non-destructive modifiers
One important similarity between Blender and 3DS Max is that they both use modifiers to take simple models and apply amazing effects that can be reversed and easily tweaked by adjusting the original model. Things like adaptive subdivisions for smoothing without creating millions of points to adjust, and particle systems to scatter hundreds of object instances across a surface help to create organic, realistic environments. The grass in my rendering was created using a particle system, and allows me to tweak the strands and play around with the automated scattering to my heart’s content.
2. Excellent Community of Experts
One of the most important aspects of a piece of software when learning how to use it is how active the userbase is, and how easily you can get answers to your questions in forums. Because blender is freeware, it seems to have one of the largest followings in the world, and whilst the documentation on the Blender Wiki page is very good, you would be hard-pressed to find a question that hasn’t been answered in the very active forums.
CG critiquing sites such as ArtStation — although not solely used by Blender users — has so many people able to give you tips and feedback on projects, and really improve as an artist. (There are also weekly competitions and other fun stuff if you want to take part in events.)
If you’re a visual learner, like me, online tutorials by experts such as BlenderGuru on YouTube are fantastic (he’s a Blender user from New Zealand and his PBR materials store is excellent – check it out at poliigon.com – I bought a few of the textures used in my barn rendering from there). There’s no shortage of step-by-step projects showing the best ways to model, light and render projects.
3. Importing and Exporting Files to Graphisoft ArchiCAD
In the latest few editions of ArchiCAD there has been the function to import and export .3DS files, as well as the material mappings used in the program.
This is very handy, because if you’ve designated — for example — all the glazing to be displayed as a type of glass in archicad, all glass elements get exported as a single Blender object, allowing you to simply select and link the required material. Applying it as a whole. It even brings across a simple UV mapping on some textured exports.
4. Great Add-Ons
The number of official and community addons is staggering, two of my current favourites is the archipack set, which allows you to form walls and windows, as well as shelves and stairs really quickly. As well as the Add Sapling tree generator tool. You can also add more, if they’re not already included in the available list.
As somebody who has never really used 3D modelling for anything other than architecture and interior design, the idea of being able to use Blender to sculpt using a mouse or pressure-sensitive Wacom table was intriguing.
I had a go, and it was surprising just how intuitive the process was! Once you get the hang of pushing, pulling and creating creases and lines, you can create characters and organic shapes really quickly. It’s like having a virtual ball of clay. I have heard that programs like MudBox are more specialised for this kind of thing, but honestly – looking at some of the more advanced sculptors online I think you can pretty much model anything in blender with enough time using this mode.
What do you think about Blender as a tool? Do you use it in an architectural/interior visualisation workflow? Let me know in the comments section below.
We’ve been moving into our new house! The past two weeks have been physically exhausting, but great fun. We are finally unpacked, and enjoying having a garden for change – just in time to enjoy this wonderful weather in the UK. The building itself is a 1930s council house, and its true what they say; ‘they don’t make ’em like that any more.’ Once I’ve finished drawing up the house in Archicad I may have to do a blog post to share what I’ve been doing.
Somewhere within the past two weeks I managed to fit in a fun little project for Kirsty (my wife) who had been taking part in the week-long scavenger hunt GISH, where people taking part carry out fun/crazy/charitable tasks and it just so happened that one of the tasks was to:
Submit Bonafide architectural drawings (that can’t already be found on the Internet) for a homemade from two shipping containers. Must have a kitchen, bathroom, and windows.
Obviously, with my background and experience I leapt at the opportunity and agreed to mock up a really sketchy design for submission. It was great fun, and shipping container architecture was something that I’d wanted to look at for a while!
After a quick sketch around and a bit of modelling in Archicad I managed to come up with this:
The main idea was to stack and stagger the two container units so that it created a sheltered area, for planters and even a swing set. The floor plan is fairly bare, with a small kitchen/dining space on the ground floor but with consideration given to how the staircase winds up into the main bedroom space. The bed on the higher floor is extra large to take up the whole width of the container, with views directed out, through folding doors over the balcony area and beyond.
(Tea and Crumpets was the team name, as some members were from the UK, and others were from the US! Go team Tea and Crumpets!)
This is a quick video showing a tool I created using Rhino to calculate simple fixed axle swept path analysis on site plans for work.
This was quite a complicated program to create, but is able to be reused on multiple sites, for multiple vehicles. Based on the Ackermann steering and parametrised geometric principles.
It works really well in my workflow in architecture, as I can export siteplans as DWGs, import them into Rhino, perform the swept path analysis and bake them back into a DWG to be reimported into the BIM model.
If there’s any interest in it, I may upload a .GH file of the script for others to try out.
One of my latest obsessions has been tinkering with Rhinoceros and Grasshopper – whilst I still have my 90 day trial of the software, i’ve been trying to teach myself as much as possible about the benefits of coding in design/architecture. The blog ‘I Eat Bugs For Breakfast‘ by David Rutten has been invaluable in explaining many of the subtleties of the software.
I had originally heard about Grasshopper and parametric design in an interview with Bjarke Ingels of BIG architects (BIG.dk) where they stated that the connection with coded elements was crucial to their design strategies, allowing them to quickly iterate through options and form amazing computer generated landscapes.
The software also happens to work really well with ARCHICAD – the BIM software that the practice I work at has invested in, so it seems like a good match.
I created a little video that walks through one use-case I’ve found for the software, in helping to advise/evolve a solution to calculating efficient timber spans for floors (not very exotic, I know – but handy nonetheless), for giving a good estimate on structural depths whilst minimising the amount of timber required for the build.
Disclaimer: as architects we never advise on actual structural elements, and cannot guarantee any safety – that’s what structural engineers are brought on board for – but in any case, it’s always nice to get an idea of the structural zone the building will require…
Please see the video below:
See the grasshopper script here:
So all in all, a very fun and interesting project, definitely with some scope for development as well as fine tuning — I’m also quite sure that there has to be an easier way of performing a few of the procedures, but for the time being I am really enjoying the process! If you’ve got any questions or comments on the script, let me know in the comments.
My previous Grasshopper script was a push-pull brick facade generator (very pretty), which I hope to also do a video about as well, so stay tuned for that!
Since there was quite a lot of interest in my last free AutoCAD block offering on the site, I decided to release another! This time in the form of a hand-drawn, fully-shaded tree in plan symbol that can be used anywhere.
I got the idea for drawing a few of these after seeing hand-drawn landscaping plans and wishing I could do something similar using just AutoCAD. Turns out: you can! Using true line weights and carefully selecting true colours, this block can be stretched, scaled and rotated to suit without losing its look due to pentypes or weights.
This week I have been working with the two directors at Rogers and Jones Architects (the practice where I work) to redesign the building which will eventually house our new offices! It’s quite an exciting opportunity to think about the design space, our own work units and how best to retrofit quite a dated building.
Quite a lot about the design has been focused on the change of ceiling levels as you walk through the building, giving the more personal, intimate spaces a cosier feel and the design studio space a light and airy room height.
Looking forward to moving in and starting on some of the works now!
For the dissertation aspect of the RIBA OBE Part II course, I chose to focus on the cultural-context module (rather than technology or economics) and to take a closer look at role of the plaza in everyday urban life. It was a really interesting piece to research, and the first hand surveying of Plymouth’s usage of these open spaces was incredibly illuminating. It took me from the historical inception of even the term ‘plaza’ all the way through to infrastructure and guerrilla urban design techniques of the modern age.
For Rogers and Jones Architects, I recently completed this massive survey – featuring an existing block of accommodation for a housing association in Plymouth. I counted over 300 rooms whilst measuring and drawing this up in BIM software, but it was a useful experience as it gave me practice in manipulating large numbers of rooms on confusing level arrangements (through half-floors, stepped floorplates etc.).
Some recent work I did at Rogers and Jones for a private client in Plymouth. I really loved the light and airy feel of the dining area, thanks to the three tilting velux skylights, as well as the quality of the kitchen finishes and fixtures.
Extension and alterations made to the rear of a dwelling in Plymouth. Replacing an existing lean-to conservatory/utility. Clients wished to maximise their views out into the garden, as well as create a more open and contemporary kitchen/living/dining area. We proposed a large 4m+ wide sliding/folding aluminium door opening out onto the patio and garden. The sloping soffit to the ceiling allows a light and airy space in the dining area, whilst the three pivoting velux rooflights allow a good amount of natural daylight into the room. The bespoke kitchen was designed by specialists.
The utility facilities were relocated to new side extension [not pictured] that also incorporated access to the rear garden and downstairs WC facilities.