Profile cover photo
Profile photo
Matthew Ziegelbaum
Matthew's posts

Post has shared content
Color scale conditional formatting in Sheets
Now it's even easier to visualize which numbers are the highest and lowest in a range--just select the “color scale” option when setting up conditional formatting. Plus, if you change any of the values, the colors will automatically update as you go. More info in the Help Center:

And one more thing: you can now import Excel files with color scale formatting too!
Animated Photo

Post has shared content
Meet the new Google Sheets. It’s faster, supports larger spreadsheets, has a number of new features, and works offline. Learn more and give it a try at:

Post has attachment

Post has shared content
The packet capture shown in these new NSA slides shows internal database replication traffic for the anti-hacking system I worked on for over two years. Specifically, it shows a database recording a user login as part of this system:

Recently +Brandon Downey, a colleague of mine on the Google security team, said (after the usual disclaimers about being personal opinions and not speaking for the firm which I repeat here) - "fuck these guys":

I now join him in issuing a giant Fuck You to the people who made these slides. I am not American, I am a Brit, but it's no different - GCHQ turns out to be even worse than the NSA.

We designed this system to keep criminals out. There's no ambiguity here. The warrant system with skeptical judges, paths for appeal, and rules of evidence was built from centuries of hard won experience. When it works, it represents as good a balance as we've got between the need to restrain the state and the need to keep crime in check. Bypassing that system is illegal for a good reason.

Unfortunately we live in a world where all too often, laws are for the little people. Nobody at GCHQ or the NSA will ever stand before a judge and answer for this industrial-scale subversion of the judicial process. In the absence of working law enforcement,  we therefore do what internet engineers have always done - build more secure software. The traffic shown in the slides below is now all encrypted and the work the NSA/GCHQ staff did on understanding it, ruined.

Thank you Edward Snowden. For me personally, this is the most interesting revelation all summer.

Post has shared content
Always cool seeing what people can do with the tools we provide!
Universal Analytics Form & The Measurement Protocol

In this article I present the Universal Analytics Form, an easy-to-use solution I developed with my colleague +Eduardo Cereto Carvalho to send +Google Analytics requests via the Measurement Protocol.

This solution can significantly upgrade your current tracking capabilities, especially if you use coupons for offline purchasing or other offline interactions. Enjoy!

#googleanalytics   #universal   #measurement    

Post has shared content
Congrats on your launches, +Elynn Lee!
Introducing a few new tools that give you more flexibility and customization when building surveys with Google Forms. Starting today, you’ll be able to display progress bars, set up data validation, embed YouTube videos, and post custom messages when your form is closed. More:

Post has shared content
New in Google Forms

Say goodbye to the days of trying to create a form or survey in a text document -- you can now print your Google Forms with ease. When you print a form, each question is formatted in a way that makes it simple for people to fill in when printed on paper. To try it out, just create a form and press the print button.


Post has shared content
It's not a perfect world, but we try to make it better. I try to make it better. 

This actually made me cry a bit at my desk, I didn't really know this was going on, but I'm really glad it is!

#samesexequality   #lgbtq   #hangouts  

Post has shared content
All of the Apps Script sessions from I/O 2013 are now up on YouTube. Below is the talk +Matthew Ziegelbaum and I gave on using Apps Script's new Forms service, and you can find the other ones on our Apps Script playlist:

Post has shared content
We just launched Forms in Apps Script! If you'll be at #io13  tomorrow, come hear +Eric Koleda and me introduce the new features.

Big thanks to +Joe Tessler for getting this started!
We just launched a whole bunch of new features for Apps Script, right in time for Google I/O 2013!

Some of the new features include:
- Apps Scripts in Google Docs and Google Forms (including custom menus!)
- DriveApp, a new version of the DocsList service
- an experimental, faster HtmlService sandbox
- an experimental, improved authorization flow

Check out the official announcement on our blog for more details!
Wait while more posts are being loaded