Skip to content

Google based approach

Gabriela edited this page Jan 21, 2016 · 2 revisions

What is working now

Folder we're working on: "The working headlines" https://drive.google.com/drive/folders/0B7DHSH6TgtH-NE4xWjllQWZaMHM

Current approach

  1. Open first form: ("Step 1: Project Registration")[Step 1: Project Registration]

  2. Fill out the form with headlines

  3. Access the toolbar: Tools > script > run functions

https://docs.google.com/spreadsheets/d/1IQzyZ_XRdjKexkUPbsiSEk_1nqa8zoaV3TePTJ7kosI/edit#gid=473645995

The function makeForm() will create another form called ("Step 2: Rate Headlines")[https://drive.google.com/open?id=15wnCMCaDUys333TS5TUd487KsAeNT4a_FtIBzsIf6n0], probably not in the same folder you are (check "Recent" in Google Drive's left sidebar).

  1. Rate the headlines through (the form)[https://drive.google.com/open?id=15wnCMCaDUys333TS5TUd487KsAeNT4a_FtIBzsIf6n0]

Next steps

  1. Make a script to sort by ratings
  • Row number 5 sums the votes for each column
  • Sort it

Some scripts to look at: https://script.google.com/macros/d/MpFsv_vuFo7FDi-yjEMw-EBuQO3AwZqnL/edit?uiv=2&mid=ACjPJvEKOQxB5CBMBueoQwH-wGqSRWQSvA9PsZNBOXVvlaPHj3p-ZRTlny3nU5JbDOzAlz55OttF2KMNpvpwZScMEZn7VP5kV9J3ppMMrKzF1v6ziwOVzsRIPkn7cVqRRXTpuX4SbvJ-H0I

  1. Provide visualization

Here are some ways to viz data in spreadsheets in diagramatic (and even animated) ways! The Excel data-to-diagram capabilities are apparently all supported in Google Spreadsheets and some additional capabilities are also cool!

To Learn and Thrive: YouTube Excel

Create Rolling Dice in Excel - YouTube https://www.youtube.com/watch?v=QAPXtrUMqFk

Real Time API Data pulled into Excel using Microsoft BI tools Power Pivot, Power Query, & Power View - YouTube https://www.youtube.com/watch?v=NX4Jb3Tj3J4

Using Excel 2010 - Full Tutorial on the Various Functions - YouTube https://www.youtube.com/watch?v=hBy7BZs-zx0

Real Time API Data pulled into Excel using Microsoft BI tools Power Pivot, Power Query, & Power View - YouTube https://www.youtube.com/watch?v=NX4Jb3Tj3J4

Tutorial - Create a Website Using Excel - YouTube https://www.youtube.com/watch?v=IhIDYrfnE9c

Publish Excel Workbooks as Interactive Webpages - YouTube https://www.youtube.com/watch?v=7EXZ969x5iY

Use Excel to create an iPhone and Android app -- Excel as a UI/UX WireFrame Prototype tool - YouTube https://www.youtube.com/watch?v=xgEVyp2CtWY

Excel VBA Pull Data From A Website - YouTube https://www.youtube.com/watch?v=7sZRcaaAVbg

How to Embed Excel Worksheet Data into Web Pages - YouTube https://www.youtube.com/watch?v=XOgXwmOEAYg

Add Realtime Currency Data into Excel - YouTube https://www.youtube.com/watch?v=tq6iZ1W9KhM

Slaying Excel Dragons Book # 48: Importing Data Into Excel From Excel, Text File, Access, Web Query - YouTube https://www.youtube.com/watch?v=xCWrr-ORJkw

Using Excel 2010 - Full Tutorial on the Various Functions - YouTube https://www.youtube.com/watch?v=hBy7BZs-zx0