30

Weekly Web Harvest for 2016-10-23

Of Course Westworld’s Costumes Are 3D-Printed, Too – Racked With the exception of some places in Italy or maybe England, you honestly can’t find beautiful, intricate fabrics anymore. It’s really sad! So we had to hire 3D printers in Los Angeles to reprint all our vintage fabrics so we could have more — and then beg them to work around our crazy TV schedules. Vine star Logan Paul profile – Business Insider A source close to the stars went so far as to say it’s a combination of living on Vine Street and the re-Vine tool — not necessarily talent — that keeps these stars on top. “You literally have the top 30 Viners creating what is nearly all of the content that is being viewed on Vine,” he said. “And all they do is just help each other get bigger and bigger. It’s not a democracy,” he adds. “Probably for a lot of people who want to do cool things on Vine, it’s discouraging.” Found Objects & Focus on the Details: A Look at Sculpture Artist Nemo Gould’s Upcoming Solo Show | SF Station – San Francisco’s City Guide Each piece is a feat of engineering with many moving parts, lights and little secret components—rewarding tidbits for observant viewers who are also willing to take their time and go in for a careful look. […]

Making Google Scripts & Google Sidebars Talk

flickr photo shared by Internet Archive Book Images with no copyright restriction (Flickr Commons) Sometimes you want a Google Sidebar element to be able to pull variables from a Google Script. The key element is google.script.run.withSuccessHandler. I’m still not entirely sure I have this in my head deeply/correctly but this is functional and might help someone else (even if that someone is just me at a later point in time when I’ve forgotten this). This one sets some default times based on spreadsheet variables stashed elsewhere and then automates some date/time entries using the form sidebar. Sidebar Code Google Script Code The entire sidebar/script setup is below in case anyone cares for some reason. Pick Your Date Start/End Times Start: End: Hide Previous Dates Submit

Interactive Google Sheets Dashboards

It’s pretty easy to put a bunch of data and charts in a spreadsheet and call it a dashboard. It became a more interesting challenge to make those charts change to reflect variables chosen via dropdown cell menus. The key it turns out is using =query. I can do some really powerful things with query and as long at the data bounds (columns/rows) are the same, I can change the content and it’ll replicate in the chart assigned to those columns/rows. For instance, I can have raw data on a sheet called data. I can use query on that data on another sheet with something like =query(data!A1:N,”select B,C,D,E,F,G,H,I,J,K,L,M,N where A=”&”‘”&A2&”‘”) That formula is going to the sheet named data and querying cells A1 through N(whatever the last row is) and selecting columns B through N where the content of cell A matches the text of cell A2 on the local page. As a result we can manipulate the contents of cell A2 and change the data being returned. In this case I did a little data validation drop down to restrict it to the three items for which we have data. Do take note that for numbers I could have just appended the cell reference (&A2 in this case) but because it was a text match I had to staple […]

23

Weekly Web Harvest for 2016-10-16

Infinite Jukebox for Make It Funky by John Lee Hooker fun tool h/t John Freyer WordPress Without Shame Ultimately, as a director, I am obligated to consider all the technologies that can help our client achieve our goals—including the old, boring ones. Enter WordPress. Monday Night Raw To Host Presidential Tables, Ladders, and Chairs Match —ouch. The school also plans to host various social media workshops focused on teaching people how to effectively communicate via social media. These seminars will cover subjects like, do’s and don’ts of Facebook (with an emphasis on posting “like a mom”), what all the five primary social media outlets are and how to tell the difference between them, and why no one likes rampages.

Spreadsheet Karma

=QUERY({C:C,C:C},”select Col1, count(Col2) where Col1 ” group by Col1″,1) This is just so handy for getting all the unique values from a column and spitting them out with the counts of their occurrences.1 I can’t tell you how many times I’ve done this a much harder way. I saw the function above as an answer after I’d responded to a Stack Overflow question about getting unique word counts. Just another little example of how doing things in the open and being involved in communities ends up benefitting you in unexpected ways. flickr photo shared by New York Public Library with no copyright restriction (Flickr Commons) 1 If you data isn’t in column C, just change it to the right letter.

16

Weekly Web Harvest for 2016-10-09

Monday Night Raw To Host Presidential Tables, Ladders, and Chairs Match —ouch. The school also plans to host various social media workshops focused on teaching people how to effectively communicate via social media. These seminars will cover subjects like, do’s and don’ts of Facebook (with an emphasis on posting “like a mom”), what all the five primary social media outlets are and how to tell the difference between them, and why no one likes rampages. Chrome Music Lab Some fun stuff Avoid “Culture Fit” If You Want Innovation – The Creativity Guru “that human-resources staff, when considering recent college hires, ranked cultural fit above a candidate’s referrals, coursework and grades.” (If you’re not white and male, this probably isn’t a surprise. And you’re probably not excited by the idea of playing a spin the wheel game, with three white guys, in a pit full of balls.) _____________________ Your work is meaningless. Your grades don’t matter. Just agree with us on stuff. Also I would not enjoy playing spin the wheel in a ball pit with three white guys. Officials confirm 4-year-old Rebecca Lewis found safe in Memphis; West Hogs in custody Polk County Sheriff Grady Judd of Florida has a message for the suspected kidnapper, who legally changed his name to West Wild Hogs from Matthew Clark Pybus: “Don’t you hurt that […]

09

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 end of a grove and traced it through the root network all the way to the other side. “Most people, when they come to the redwood, they look up at the canopy,” Kuty says. “But down is where the action is.” This collaboration lasts only until summer comes. Then every tree, sprout and branch must fend for itself. Those that can’t photosynthesize enough sugar are cut off from the shared root system and discarded during what’s known as the autumn “needle drop.” Douglas Coupland: ‘I’m actually at my happiest when I’m writing on a plane’ | Books | The Guardian There’s a kind of existential heebie-jeebies that accompanies the abandonment of routine: what if I lose my skills and they never come back? What if I become too fragmented? What if the forces of the future I’m trying to depict crush me like a bug? But then, nothing ventured, nothing gained. Live asynchronously. If your job requires even an ounce of creativity, you’ll do your best […]

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 in there and manually enter formulas or drag down to apply them to additional cells but that sucks and if you’re automatically displaying this data live somewhere it’s an impediment to a solid workflow. Most importantly, it sets a human to do something that a machine ought to be doing- that is the path to Skynet assuming control. We can and must resist! Subjugate the machines whenever possible! The script below is broken into three parts and shows two different ways to set the value for columns based on data entered in a form. Part 1 – This is pretty much default information that lets the script know which spreadsheet and which page it’s working with. The getLastRow() is really handy for applying this to data as it is entered. This example form writes data to columns A – K. In example one, we do the math internally and just spit the result into the cell. That’s handy for lots of stuff and can be […]

02

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 Over the years they added Jumbo, Supercolossal, and Special Supercolossal. I Sarah Patterson, arrested for trying to steal money from a… | Flickr the comments are pretty interesting