working example form and graph: how to collect user input and present it in a graph on static websites, using google forms

[posted: ]  [0 comments]

how to collect user input and present it in a graph on static websites, using google forms here is a working example of a google form and chart embedded statically into a web page.
you may also be interested in a truly static version and/or the underlying data in this spreadsheet on google docs.

[category: computers & technology] [tags: , , ]

how to collect user input and present it in a graph on static websites, using google forms

[posted: ]  [0 comments]

how to collect user input and present it in a graph on static websites, using google forms the problem: for a small web project that is going to run on a server with very restricted functionality (due to safety concerns), we wanted to include a web form where visitors can submit values. these values should then be presented in a graph, showing all submitted values and highlighting the latest addition.

the solution: after some digging, i found a way to do all of that using google forms/spreadsheets, which offers user input, a simple spreadsheet-based database, as well as dynamic image creation.
check out the working example page and the underlying spreadsheet, and continue reading for a step-by-step tutorial on how to create a web form that plugs into an automatically refreshing graph/chart using very basic means, and how to implement it all using just two static web pages, a google form, and a google spreadsheet. [more...]

[category: computers & technology] [tags: , , ]

how to convert Sony RX100 videos for correct aspect ratio in 1 Second Everyday

[posted: ]  [0 comments]

How to convert RX100 MP4 videos for correct aspect ratio in 1 Second Everyday MP4 videos recorded with the Sony RX100 appear distorted when processing them with the 1SecondEveryday app. this aspect ratio problem can be solved by converting the video and correcting the video dimensions with the Handbrake open source video transcoder.
here’s how:


How to unprotect Word files without knowing the password

[posted: ]  [62 comments]

How to remove unknown passwords from protected Microsoft Word files I’m regularly annoyed at password-protected Microsoft Word files that only permit editing of certain aspects of the document such as form fields. By itself, Word’s “Restricted Editing” isn’t necessarily a bad thing. It’s the fact that file creators are usually very conservative and prefer to disallow editing something “just in case”, rather than giving users the option to add text somewhere unexpected.
The result is often that in order to complete a form, one must print it out and amend it with a pen, or convert to PDF and use the “comment” function.

Looking for a way around, I recently found out how to remove the Document Protection from Word files without knowing the actual password*:

* Note that this method only works with Word Docs that are protected from editing, not files that require a password to open. [more...]

time lapse video: surprise christmas decoration

[posted: ]  [0 comments]

here’s a little christmas time lapse video i recorded last year: for my mom’s birthday (shortly before christmas), my aunt hand-crocheted a full set of christmas ornaments. we decorated the tree while mom was gone, and then led her into the room when she returned. mom was blown away!

soundtrack: christmas time by franco castagnotto

[category: time lapse] [tags: , ]

burgruine thaur and romediuskirche from above [aerial view]

[posted: ]  [0 comments]

growing up with a ubiquity of historic buildings and castles nearby, i never really felt that they were that special. that is, until friends from around the world asked about them and were very excited to see them up close.

i recently took a dji phantom for a flight around the nearby castle ruins in thaur, which date back to the late 12th century. as it turns out, the ruins had quite a vivid history comprising nobility, illegitimate children, the church, and lots of plight. the aerial view is especially interesting when compared to the below etching from 1699 on wikipedia.

castle ruins from above - burgruine thaur, austria


[category: photo] [tags: , ]

squirting cucumbers in action [slow motion video]

[posted: ]  [0 comments]

not too long ago, we came across a small patch of squirting cucumbers (ecballium elaterium) in spain, and wanted to see their rather spectacular mode of seed propagation in action:

using hygroballochory, the species can expel its seeds into distances of up to 12 meters.

footage was recorded with a gopro hero 3 black at 120 fps, 720p. clips are in real-time, 4x slow motion, and (last sequence) 8x slow motion (i.e.15 fps), respectively.

[category: general] [tags: , , , ]