Inserting additional Lines into a Google Sheet

You might want to take a look at my latest video on YouTube, to show how to add or insert rows into a google spreadsheet, its simple but you need to understand where the rows will be added to make it effective.

Forgive the slight pause in the middle, for some reason my Mac  did not want to play ball

Walter Segal -The Tartan Grid

One of the more interesting things about Walter Segals detailing, is the use of a Tartan Grid, thats alined to the size of materials as well as the structural needs of the building.

If you take time to have a look through the Excellent AJ article on Walter Segal, you might want to take time and review his explanation of this grid. It’s not the usual grid you might expect to find on a house or for that mater any other Architectural project I have ever worked on in 45 years, and consist of a smaller tartan grid fitting within a master grid.

Walter segal houses were, or are, made with as little waste as possible, materials used are fitted whole, not cut, hence the tartan grid, which is used to control the main materials and they are intended to fit between the main structure grid.

Lets start with the smaller tartan grid, which is made up of a 600mm wide larger spacing with a 50mm wide space between. The 6000mm wide space being the width of a plaster board. The 50mm space is for the secondary structural stud, which always shows through in Walters designs, a point you might like to re consider in a modern house.

The larger grid would be made up of module of the smaller unit, limited by the span of the floor joist, I like the idea of a three or four material tartan modules to the main structural grid of the main support frame, if I keep both grids with a 50mm small gap, this will allow easy planning of the interior fitting in with the smaller internal walls.

The point of this review of Walters grid is to make you think about how you might approach the same problem given modern materials and structural requirements. I still like the idea of this grid, but would look at a 1200mm wide plasterboard, and a 75mm wide stud to both the secondary and main structure, looking at a 150 x75, with a 200 or 225×75 main structure. This defiantly needs some play time looking at the various permutations and layout possibilities, and how easy each would be to install, given that most of his house types are self build. 

I original posted most of this blog in Jan 2012, 

Walter Segal update

I have just added an old 1966 television program from Youtube to the first post in this set of articles on Walter Segal, this time however, I thought I would separate Walters work with this video looking at his designs from a different perspective.

This link will take you to the Google Map, there is a lot of tree cover, but the site is there to be seen.

Walter Segal Foundations

Building the Walter Segal Way, takes you into a minimal foundation design. Its simplicity itself, yet works as well as a strip foundation, and the steeper sites lap up the method.

So whats involved, simply a paving flag sitting on the earth, with perhaps a small circular concrete pile below, the paving flag following the contour of the natural land.

The load from the timber structure loading direct onto the paving flag at its centre.

The AJ Article has this in depth, which I will send or give a link out for, if for research,  and the films particularly the Grand Design film explains this in a little more detail.

The impact on the land from the house is minimal.

The video below bottom helps to understand it all, its not great and uses concrete posts rather than paving flags, but you get the basic principal, but I downloaded a sketchup file of a very good 3D Sketchup model part finished, and made the video immediately below.and the jpg to the left, I think it shows the construction better.

Walter Segal - Grand Designs

Grand Designs produced this program in 2014, its an up to date view of construction the Walter Segal Way, the construction, but more the people involved, and the problems.
But excellent all the sane.

Walter Segal

If you have followed my blog for the past few years, it will come as no surprise to learn of my fascination with the Architect Walter Segal.

I first came into contact with him and his method of timber frame building as a Tech guy in Dow Construction Products, we got involved with making a new updated version with Styrofoam as the loose core insulation not quilt, at the centre of Alternative Technology mid wales.

The Architect Jon Broom was the designers at the time, he worked with Walter, and although runs his own practice in London, he still has strong ties to the method Walter devised.

The AJ at about the same time printed a booklet attached to the AJ, it looked at the way he viewd materials, the method of layout, and his tartan grid that aided layout design by looking at the material sizes. I still have a copy and if you want a pdf for research, please let me know I send a link to down load it.

Recently I recieved an email from the the AA about an affordable Housinr exhibition featering Walter Segal and his self build houses in the London Borough of Lewisham, some 200 units, I was lucky enough to visit several of them with Jon and just loved the simplisity and easy style living.

You can read about the exhibition at this link to the AA site, I plan to take time to visit myself  Walter’s Way – The Self-Build Revolution until 13 February, Architectural Association School of Architecture, 36 Bedford Square, London

I had a lot of separate article on the old site, I will dig these out of my archive and repost over the coming weeks.

Vectorworks Building Takeoff sheets

I am so pleased to report, that Jon Pickup of Archoncad, is running a webinar on Wed, Feb 10, 2016 7:30 AM - 8:30 AM GMT, looking at the use of Vectorworks to produce sheets or spreadsheets for export. There are actually several time slots to suite attendees from all over the world. Take a peak at his new site for further info.

I know they are not easy to do, but following Jon's advice, I am sure it will prove very simple.

The official name for spreadsheets are Cobie files, but apart from the formatting they are essentially spreadsheets.

The problem is not their  creation, but getting the right information onto the sheet, and getting it onto the sheet is so often down to the way we name and link the information to the sheet, naming correctly is so important.

So many people are ready to ignore spreadsheet exports, because they argue the IFC file has it all, but contractors and site managers are not going to let them go, and if we want to see purchase orders and other site information correctly then the use of well made spreadsheets is still very important.

I use Google spreadsheet, so it will be interesting to see how they import

Related articles

• Google Spreadsheets Now Shows Functions In Your Preferred Language
• Google Sheets 101: The Beginner's Guide to Online Spreadsheets
• Architectural Technologist - Exporting a Vectorworks Symbol Database via a worksheet into a Google Docs spreadsheet or Filemaker database