Profile cover photo
Profile photo
Bobby Shen
126 followers -
Architecture ::: Photographer ::: Writer ::: Blogger ::: Leader
Architecture ::: Photographer ::: Writer ::: Blogger ::: Leader

126 followers
About
Bobby's posts

Post has attachment
Bed
Here's a blog post talking about how I did a small project of my own - building a car bed in my Nissan Tiida hatchback for small road trips. Pro-tip: always reverse into the best view. Ever since going camping in my friend's Honda Fit - a relatively small h...

Post has attachment
Backyard
Oakley Creek (also known as Te Auaunga) is one of Auckland’s longest urban streams It's not often I haven't heard of a place in my own backyard, and the Oakley Creek Waterfall is certainly one of them being only 12 minutes drive from home. I went to investi...

Snapshot of value over time on Google Sheets

Hello,

Absolute beginner here, don't know Javascript but want to make this work on my existing Google Sheet.

I'd like to copy a snapshot of a value from a single cell of a spreadsheet across to another tab, where I want it to paste two columns:
- Date
- The copied value

I want this copy paste action to occur by itself once a day. Then on that destination tab, if I could create a line graph showing the value (which happens to be a percentage) as values are added, that would be amazing!

I have gotten this far piecing together scripts and putting in my parameters. However, don't know if it will work and what I need to do to make this script occur in my spreadsheet:

ScriptApp.newTrigger("myFunction")
.timeBased()
.atHour(16)
.everyDays(1) // Frequency is required if you are using atHour() or nearMinute()
.create();

function Copy() {
var sss = SpreadsheetApp.openById('1HWZMtAkIHAJtZ61bNBYfIqjxX3Oz6JasbdraSWAI4ws'); //replace with source ID
var ss = sss.getSheetByName('ChartData'); //replace with source Sheet tab name
var range = ss.getRange('W3'); //assign the range you want to copy
var data = range.getValues();

var tss = SpreadsheetApp.openById('1HWZMtAkIHAJtZ61bNBYfIqjxX3Oz6JasbdraSWAI4ws'); //replace with destination ID
var ts = tss.getSheetByName('Tracker'); //replace with destination Sheet tab name
ts.getRange(ts.getLastRow()+1, 2,1,1).setValues(data);
}

Any help much appreciated!
Bobby

Post has attachment

Post has attachment
Cage
I was struck by inspiration this morning just as I was about to leave the computer for sunnier things (this just after the end of Daylight Savings after all). John Cage and his "Mushroom Book" of 1972 is a collection of drawings and poetry in a folio format...

Post has attachment
Britomart
During my last year of architecture school, I used to always walk down to Britomart. It became a place of familiarity as I explored its 'new' form. In spite of the hipster/fashionista/high end vibe of current times, Britomart used to be a really nasty backe...

Post has attachment
Amazing day at this Britomart event.
PhotoPhotoPhotoPhotoPhoto
Britomart Fashion Session 2014
30 Photos - View album

Post has attachment
The amazing dance/drawing by Heather Hansen

Post has attachment
Intensity
Heather Hansen is a New Orleans-based artist who creates incredible geometries using her body on pieces of paper. Part performance art, the symmetrical forms made with her movements allude to the Virtruvian Man in many iterations. The performance of creatin...

Post has attachment
I'm back on the blog! And with two seductively great architectural projects to talk about. Both are inspired by archery and nothing to do with the popular culture hype that is going around at the moment.

Archery Hall and Boxing Club by FT Architects
Bowstring Truss House by Works Partnership Architecture
Wait while more posts are being loaded