=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 […]
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 […]
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 […]
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
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 […]
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
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
Welcome to the Dark Net, a Wilderness Where Invisible World Wars Are F | Vanity Fair , Look, we’re in the Internet business. We know we’re going to get hacked. We have to assume, always, that our network is already owned. It is important to go slowly and stay calm. We will soon know how […]
I wasn’t pleased enough to do a weekly post last week. I’m concentrating a bit more now and trying to get past my urge to rush to work that will be there if I take an extra ten or fifteen minutes. […]