Tag Archives: Google Docs

Google Doc Spreadsheet cell Bullet points list

A long title for this post, but such an easy trick, I so often have to make Google Doc spreadsheet bullet point lists in my spreadsheet, and this is the way I do it, some might say, I should list each item on a separate row, and for the majority of times thats correct, but just every so often, I want to add a Bullet point list within a single cell.

I use Google docs so often now for almost all my writing work, the sharing is so easy, I can take the web upload code Google Docs gives me and load it into Moodle, the Student interface I use as a lecturer, and the students can see my lectures so easily, and get the updates as and when I make then instantly.

My Moleskin is Half empty

Moleskin half empty, or Half FullIts the weekend, and I am looking forward to University, I have so much to do, with both my practice and in preparing for lectures, I use Google Docs so have shared my lectures with the members of staff who I work with, but, and heres a big but, my Moleskin is looking a little full, I use it so much for general day to day notes, sketches, ideas and concepts, some times I sit and sketch an idea I have seen, rather than use my iPhone, its so much more intuitive to do it, the camera captures only what it sees, but sketching, I think, makes you see beyond. So today is a new Moleskin day, ready for my transfer.

I also have just paid for my Evernotte premier account again, I just could not do without it, storing “Stuff”, including captures of my Moleskin. I see so many executive, busy making notes at courses, and wonder, if they ever use them, it looks good, people are impressed, they are taking notes, but so often its a sham, they do not use them, capture the notes in Evernote, and let it become part of your Personal Archive.

So my next job is going to be a full 3D model, I have said this before, but this time it has to be, there will be pain, I know it, but after seeing the CostX presentation, I now can’t delay it, 3D it is. I an also looking at taking my Masters, Birmingham City University have a Masters in BIM, and its my intension the take it on, in the spring.

It looks like I have been using an old version of Skype, so this morning work was to reload it, I must say, this program has changed my life, I can talk all over the world, for free, show my screen, and send files, all for free, I even have a paid for telephone number, I just do not need the BT number I have, in fact its not listed any were, and I don’t use it, Skype is all I need.

It’s now official Gary Mees will be the next CIAT President, I am pleased for Gary, he has been about the CIAT system for so long, he knows how we work, and has put time into our profession.

blogsy is back

I am back on Blogsy, after a while away, I have gone back to this excellent program for the iPad, you might ask why I went away, simply because I was using my Mac so much more, and as I had to travel a lot, I just used the mac browser. But as I work from my home office, my parents home, so much more these days, and the university, I can' see the point of travelling with the laptop, so the iPad is back. also I have moved almost entirely over to Google docs, and now that the iPad has Doc's, spreadsheet,,slides I can work free of the laptop.

besides, the university is both Mac and PC, so I have no need, except for when I need to draw and here if it's the University, I use their Autocad, but there is so much to do here, I doubt I shall have time.

Ok, I can't add the search engine optimisation, I normally do on the laptop, but that can be added later, t he ability to travel light far out ways the problem.


My Watts Single point levelSo often when I visit site, I take loads and loads of photos, my iPhone is simple to use, there is no space problem and transferring is relatively simple. I also include video in this statement, as I see both Video and Stills as a source for recording a site.

The iPhone, and for that matter almost any modern phone, make this operation, simple easy and almost uncomplicated. I use several ways to upload, I have both Flickr and Google auto uploading, It save time and I have the setting set to use only WiFi, and the uploads set to private, so I can go in later and reset the ones I want to use publicly. As I use a Mac, I also have the use of iPhoto, soon to be upgraded as my main safe file source.

For the stills, thats it, I collect them into sets and share, but for the videos I like to collect the short snaps I take into one video, for this I use WeVideo, as part of Google Docs . its relatively simple, link WeVideo to Google Docs,  just load up the videos, and drag them into the time line, I have subscribed to the service to get extra functions, but the basic free version is enough to get started.

The video below show how and a little why, for me video so often tells a better story than still photography, especially if I can give a commentary on what I am looking at.

Next I save a link into Evernote, so I can search on it, and as always its tagged reasonably well, with project No, and location title, plus anything else I can think of.

As Architectural Technologists, we get called on to do all sorts of things, not taught at college or Uni, so for me updating my skills in simple but useful video storage and clipping is valuable CPD, and good to add onto my CV.

For more tutorials on using WeVideo try this link to youtube. As for todays photo, this is my simple yet so useful Dumpy level, and its going to be the subject of my next video.


Architectural Technologist – Adding and subtracting when using Angles

Classic Arch to town hotel in brickToday I thought I would look at adding and subtracting when using angles, especially when using degrees, minutes and Seconds.

Students so often forget that when dealing with angles you need to add and subtract using time or 60, i.e. 60 min and 60 Seconds.

The small slide set I made in Google Docs is all I need to show this, plus some easily worked examples similar to the video that I have embedded into the slide presentation.

For me when I was putting this together I thought this is excellent CPD and made a note to included it here to remind you all about the way it’s done, adding is the easy side, but its the subtraction that so often get them, particularly if the lower angle is in part, larger part. You just have to remember to transfer from the a degree  1 minute and also to lower the minute, watch the video its self explanatory.

I have also included a small video below that shows how I get the html code of my google Doc presentation and embed it into the code of this blog, so similar to adding it to the Moodle notes section.

The photo I used today I took on my trip to Lullworth Cove and is of a very fine old brick Arch in one of the market towns, shallow and wide it has stood the test of time and works.

Architectural Technologist – CPD workflow for saving, creating notes and recording the hours

I thought you might like to see a video I did recently looking at the way I store information I find during my research, it centres on Evernote of course, and also my way of recording the actual hours in my Google Doc Spreadsheet.

I also use PDFpen to scan in documents into Evernote, if they are paper based. I can also just add time direct into my spreadsheet, copy it and paste direct into Evernote.

I can now quite happily search for items on the web, but because I have the Evernote app in my search program like safari or chrome, it can also see what I have stored in my personal database stored within Evernote.

We that is both Technologists and Architects, in fact most profesionals need to complete and show 35 hours of quality CPD in any one year, this is my way of recording that information, but more importantly, how I can see and use it, in my day to day activity.

If you can't work out how to make up the spreadsheet, let me know and I will make up one specific to you, for a small fee of course !!.



Architectural Technologist – Exporting a Vectorworks Symbol Database via a worksheet into a Google Docs spreadsheet or Filemaker database

Following on from my oyher blogs on creating data with the use of Symbols, at some time, you will get asked to export all that data you have so carefully recorded via the symbol you made and dragged out into the drawing, it could be anything from room sizes, to car park symbols, to in this case a tree record, I have in this example about 845 records attached to a series of symbols, that the gardeners want to see a list of, so I thought I would show you how I did it.

The workflow is relatively simple in that I created a worksheet within Vectorworks to list all the trees in the ATrecord database, then exported it as a commercial delimitated file and re imported it into a Google Docs spreadsheet, and a Filemaker 11 database, just to give examples of how it could be used.

The spread sheet is the simplest, and one most other Technologists would be familiar with, the database is the more complex, but the best way to expand the dataset and maker the most of it.

Talking with Jon pickup this morning, I suddenly realised that if you open the txt file from Filemaker it makes the fields within Filemaker for you, just follow the menus, same thing, but I suppose my method at least shows the way to create and manage the fields.

Of course with the FileMaker route, you can add related fields to the main dataset, and create a very powerful database, with report notes on tree condition, pruning reports, and the like.

I will do one more in this series to show the way Filemaker and to a lesser degree, google spreadsheets are such a powerful addition to any Technologist portfolio.

The CPD here is all about the exports of data that we trap inside our Vectorworks files, it's the bottom end of BIM, and so important to know, not only the Vectorworks side, but the spreadsheet and Filemaker side to.