Tag Archives: Spreadsheet

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.

Architectural Technologist – More on google Docs

Following on from my articles on google docs, I found this nice little video for accessing and using google docs away from you main laptop or desk top machine, and on your iPad.

Unfortunatly Google presentations are available to view but not to generate them, bit of a bummer for me, but the doc and spreadsheet, options are, and they are great.

I use google docs on a lot so having access via my iPad is a huge bonus, I am writing a couple of books at present, and they are all on google docs. For straight text there is no better, adding pictures and formatting I find fiddlley, but then I use Apple Pages for that, ,,,,,, google can't have it all !!!.

You might want to add this to your general CPD file on office and development,


Architectural Technologist – Google Spreadsheets

Google Spreadsheets are just a way of life for the technologist, I use both numbers the mac product, and google sheets! the later being the predominant offering.

I find the google spreadsheet an ideal product, just because it’s so much like excel! and so easy to share. The video below is the latest updates that have been applied to the product.

Google sheets and the doc program are the best and cheapest way for me to write,  and the ease of sharing is so good.

I openly recommend students to use the Google Doc site, it saves on all that Microsoft office software, gives them stacks of storage space, one of the best email programs and access to so many other apps, the translate app is the one I use a lot, for me any overseas student who is struggling with English, should be using it to write in their mother tongue, and translating to english to submit to their tutor.


Architectural Technologist – Maths

Lat Long - Easting Northing comparisonI so often get asked, what maths do I need as a Technologist, there is no simple answer, because it depends on the type and style of work your doing, but here is my take on the min.

Basic arithmetic, the every day use of numbers, addition, subtraction, multiplication, division, with and without a calculator, and if you use one, make sure you know how to use it.

Next trig, or Trigonometry, this is so often over looked now, simply because CAD packages are so good at working out lengths and angles for you, but in my book, you should be able to apply SOH-CAH-TOA without the aid of a CAD program. Unfortunately this means simple Algebra as well.

Logs are an option, but I can’t remember using them in recent years, but I’m told it should not be neglected.

Last but not least, is the ability to use a good spreadsheet, I know its not straight maths, but this is the medium we all use to collect and manipulate numbers, and you should be able to list numbers and use the built in formulas, its almost every day use  now so it is part of my Maths update list.

So the CPD here is, take a little time to practice Trig and a little Algebra, I had not forgotten it, but it took some time to get back into it, and as always, some times computers are just not there, and we might have to do it the long way.

Todays photo is of a comparison of lat, long lines super imposed onto a Eastings and northing lines and clearly shows why we do not use lat and long co-ordinates in the building industry.

I can’t remember where I found this photo, but apologies to you if it’s yours, but its such a good example I thought all should see it.


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 – Google Docs

My use of Google Docs is known, I write there, and use the spreadsheet to keep my CPD records, so when I saw this excellent little video on YouTube I thought neat, perhaps I should spend a little time and catch up on some of the commands.

First though take a look at this web site and see the code in action, then scroll down and watch the video, it shows such a great way to import data from tables in web sites and there are many.

It's has made me sit and think, what else can I use it for, so in the future I will let you know.


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.