Weekly Web Harvest for 2016-10-02

The mystery of the ‘ghost trees’ may be solved – SFGate Redwoods can also clone themselves, further complicating scientists’ understanding of them. Vast rings of related plants communicate via their roots, and during the hard months of winter and early spring, they’ll distribute nutrients evenly among themselves. Scientists have spilled dye onto trees at one […]

Read More… from Weekly Web Harvest for 2016-10-02

Setting Cell Values – Google Forms/Sheets Workflow

flickr photo shared by Internet Archive Book Images with no copyright restriction (Flickr Commons) Often, people really like the workflows enabled by Google Forms but they’d like it to go one step farther . . . like adding up two submitted items, or running a particular function/formula against the submitted data. You can certainly go […]

Read More… from Setting Cell Values – Google Forms/Sheets Workflow

Weekly Web Harvest for 2016-09-25

Size Matters – Futility Closet Olives counting 120-135 olives per pound: Standard Olives counting 105-120 olives per pound: Medium Olives counting 90-105 olives per pound: Large Olives counting 75-90 olives per pound: Extra Large Olives counting 65-75 olives per pound: Mammoth Olives counting 55-65 olives per pound: Colossal Olives counting 45-55 olives per pound: Giant […]

Read More… from Weekly Web Harvest for 2016-09-25

Importing CSV into Google Sheets via Google Script

flickr photo shared by OSU Special Collections & Archives : Commons with no copyright restriction (Flickr Commons) As part of a future project, I’m looking for easy, automated ways to push/pull CSV files around. Initially I thought I’d just do the =importdata(‘http://theurl.com/data.csv”) function but I realized that had some drawbacks that made it less ideal […]

Read More… from Importing CSV into Google Sheets via Google Script

Playing with Words – Google Sheets to jQuery Drag/Drop

flickr photo shared by Internet Archive Book Images with no copyright restriction (Flickr Commons) This is a modification of the old refrigerator poetry concept based on a request from some of our World Languages professors but it’ll likely have some broader applicability. It essentially allows for three major things. You can create draggable elements (words, […]

Read More… from Playing with Words – Google Sheets to jQuery Drag/Drop