box asking if any illustrations

Science Gossip – Overview of Citizen Science Project to Classify Drawings

The people at Zooniverse have a long track record of creating citizen science projects. These projects harness the power of ordinary internet users looking to make a difference with their spare time.

Their latest creation, Science Gossip, wants users to tag pages from a Victorian Periodical.  You are presented with a simple choice, “Are there any illustrations on this page? Yes, No, Skip this page”. 

 box asking if any illustrations

You scroll up and down the page, and tell it yes or no.  Simple, right?  Well pretty much.  However, there are some finer points that are helpful to learn.  For example, where is the line between illustration and text?  For example, the very first page I saw when writing this contained formulas.

 picture of a handwritten formula

Is this an illustration?  Well, let’s click no the little question mark icon and find out.  It’s right above and to the right of the image.

question mark icon

I am then taken to a small but helpful help section.  There are four example catgories listed – Drawing/Painting/diagram, Chart/table, Photograph or Map.  I think I can safely conclude that it does not fit into one of these catgories, so I mark no and move on.

I clicked through a few more that did not have any images.  Then, I ran into this winner.

two photographs

Wohoo!  Step aside Darwin, here I come.  I then choose the type of illustration – photograph, and I get to draw a rectangle around each one.  I type the name of the photographer, give the pic a few keywords and voila!  The world is a better place because I did that.  At least I hope it is.

The point of the project is pretty straightforward.  You are helping historians by classifying the millions of pages that are available to them.  Imagine if they wanted to find out more about the dodo bird – where do they start?  If you tagged one while using this program, the historian would have quicker access to the information.  It is the rough equivalent of converting these paper pages to web pages by giving them the favorable characteristics that come with the internet – they become sortable, searchable and faster than paper.  

Read in the Science Gossip blog about Mary Anning, a woman whose discoveries were not all properly attributed to her, some of which are within the Science Gossip project.

Projects such as these give “ordinary” people the chance to contribute in ways that were not possible fifteen years ago.  Instead of using your free time binging on old Lost episodes on Netflix, now can be an amateur historian.  Better yet, you can do both at the same time.

share spreadsheet pop up option

Numbers – Sharing Spreadsheets in Apple’s iCloud Numbers

Apple now offers its spreadsheet program to anyone that has an iCloud account. You can access it from most browsers which effectively opens up the program to Windows users. You do not get the same functionality that you would from iWork for Mac, but you can access the same files and perform the most common tasks.

Apple’s Numbers spreadsheet has a sharing option that allows you to invite others to collaborate with you on a spreadsheet. You can give them the ability to view or edit the spreadsheet and you can decide the level of privacy to afford it.

share spreadsheet pop up option

You can find this option by clicking on the sharing icon shown in the image above (the arrow inside the square). However, tread carefully, as this can leave your file open to viewing by others as will be explained in this article. At the time of the writing of this article, the sharing feature is only for the entire spreadsheet. There are no options to specify sharing and editing permissions on a specific cell, range, or worksheet. If you want to share only a portion of the spreadsheet, you will have to use another spreadsheet option such as Google’s Sheets which has more granular security features.

Video explanation

Once you choose to share the spreadsheet, you are presented with a few different options for how to share it. This is where things get a little fuzzy. If you are new to the concept of sharing documents over the web, it is important that you understand what is happening here.

share warning

Before you share anything, your files are locked down in iCloud and only someone who knows your username and password can access them. Hopefully that’s just you. However, if you choose to share a file, you are opening up this particular file to other users on the web outside of your iCloud account. Others will now be able to access the file even if they do not have an iCloud account.

Letting someone see but not edit

If you want to grant a user permission to see the spreadsheet, but not edit it, you choose this option during the sharing process.

view only

However, there is a catch here. This spreadsheet is secured from others by the long, random URL that you see above for the spreadsheet link. This means that no one else will be able to stumble upon this spreadsheet because it is near impossible to guess the link. You should feel pretty comfortable that your spreadsheet is still private, but you should also understand what is making it private. If anyone found this URL, they would be able to see the spreadsheet. There is no login required for this option and no password has been specified. If you shared this spreadsheet with multiple people, then decided that one of the people should not be able to see it anymore, you cannot remove just that particular user’s access. If you still want it to be shared, you would have to add a password and control who gets the password.

Letting someone edit

If you want to grant a user permission to use the spreadsheet with the same permissions that you have, specify “Allow Editing” during the sharing process shown in the picture above. This will give anyone with the link the ability to edit the spreadsheet.

Password protect

This is Number’s method of allowing a user to share a spreadsheet while still keeping it confidential. While other cloud spreadsheet programs allow you to share spreadsheets with specific people, Numbers gives you the ability only to share your password with specific people. This accomplishes the same thing but gets you there differently.

password

Conclusion

The options described above offer enough flexibility to allow simple collaboratoin in Numbers. As your spreadsheets get more complicated, you may encounter the needs to specify certain ranges or worksheets that you want to protect in different ways. If all you want to do is share spreadsheets with others to allow them to see or edit, then Numbers has the ability to get this done.

sparkline barchart no options

Bar Chart Options for Sparklines in Google Sheets – Example Pictures

Sparklines, as seen in this overview post on sparklines, are quick, simple charts that can be inserted directly a the cell of a spreadsheet created with Google Sheets.  One of their strengths is their simplicity.  However, there are several options that can be used to expand a sparkline’s functionality.  Below, we focus on the options available for use with the bar chart type of sparkline.  

sparkline barchart no options
sparkline barchart with no options

Bar chart sparkline options

max determines the maximum value on the horizontal (x) axis

sparkline barchart max 12
"max",12 Note that this is the value in the first cell so the entire chart is representing just that one value.

sparkline barchart max 21
"max",21 Note that this is the sum of the values in the first two cells so the entire chart is representing just these two values.

sparkline barchart max 61
"max",61 This is the value of all of the cells added together the chart is the same as if you had not specified a max value.

sparkline barchart max 61 with a negative
"max",61 This is the value of all of the cells added together the chart is the same as if you had not specified a max value. Note that barcharts must use absolute values as the chart is rendered the same way whether or not the cells are negative.

 

sparkline barchart max 75
"ma",75 setting of 75. This chart illustrates that you can specify a chart max larger than the chart itself and the chart will scale down.

 

color1 determines the first color color used for bars in the chart

sparkline barchart with a color1 set to red
"color1","red" setting of red. Note that is changes the 1st, 3rd, 5th color, etc

color2 determines the second color color used for bars in the chart

sparkline barchart with color1 set to red and color2 set to yellow
"color1","red" and "color2","yelow" Note that this changes not only the first and second colors, but all of the colors.

empty how to treat empty cells

sparkline barchart with no empty option specified
No empty parameter is set for this sparkline bar chart

sparkline barchart with empty parameter set to zero
zero give the cell a value of zero for the sparkline

sparkline barchart with the empty parameter set to ignore
ignore ignore the cell, rendering the chart as if it does not exist

nan how to treat cells with non-numeric data

  • convert let Sheets try to convert the character(s) in the cell to a number. Good luck on this one.
  • ignore ignore the cell, rendering the chart as if that value does not exist
  • Note in the image that the “ignore” option behaves the same as not designating this option at all.

rtl changes the direction of the chart from left-to-right to right-to-left

  • true The direction of the chart is flipped
  • false The direction of the chart stays the same
  • Note that the “false” option behaves the same as not designating this option at all. 

Video explanation

Related Post

Learn how to use bar charts to show ranking data in Google Sheets.

 Live examples in Sheets

Go to this spreadsheet for examples of sparklines that you can study and use anywhere you would like.

different colors in a Google Sheets sparkline column chart

Column and winloss options for Sparklines in Google Sheets

Sparklines, as seen in this overview post on sparklines, are quick, simple charts that can be inserted directly into the cell of a spreadsheet created with Google Sheets.  One of their strengths is their simplicity.  However, there are several options that can be used to expand their functionality.  Below, we focus on the options available for use with the columns and winloss types of sparkline.

Column and winloss sparkline options

color determines the color of the chart’s columns

lowcolor determines the color for the lowest value in the chart

highcolor determines the color for the highest value in the chart

firstcolor determines the color for the first column in the chart

lastcolor determines the color for the last column in the chart

negcolor sets the color for the columns with negative values

different colors in a Google Sheets sparkline column chart

empty how to treat empty cells

  • zero give the cell a value of zero for the sparkline
  • ignore ignore the cell, rendering the chart as if it does not exist
  • Note in the image that the “ignore” option behaves the same as not designating this option at all.

nan how to treat cells with non-numeric data

  • convert let Sheets try to convert the character(s) in the cell to a number. Good luck on this one.
  • ignore ignore the cell, rendering the chart as if that value does not exist
  • Note in the image that the “ignore” option behaves the same as not designating this option at all.
  • Video explanation

    sparkline column winloss charts with non numeric values

    axis determines if the chart will have an axis

    • true let Sheets try to convert the character(s) in the cell to a number. Good luck on this one.
    • false ignore the cell, rendering the chart as if that value does not exist
    • Note that the “false” option behaves the same as not designating this option at all

    axiscolor determines if the color of the axis, if you use the axis option to create onesparkline winloss chart with an axis

    ymin determines the minimum data value for scaling the height of columns (not applicable for win/loss)

    ymax determines the maximum data value for scaling the height of columns (not applicable for win/loss)

    rtl changes the direction of the chart from left-to-right to right-to-left

    • true The direction of the chart is flipped
    • false The direction of the chart stays the same
    • Note that the “false” option behaves the same as not designating this option at all. 

    Follow image below for the live Google doc with sparklines

    docs share icon

sparklines ymin ymax

Line graph options for Sparklines in Google Sheets with Examples

Sparklines, as seen in the overview post on sparklines, are quick, simple charts that can be inserted into the cell of a spreadsheet created with Google Sheets.  One of their strengths is their simplicity.  However, there are several options that can be used to expand their functionality.  Below, we focus on the options available for use with the line graph type of sparkline.

Line graph options

xmin sets the minimum value along the horizontal axis (not shown)

xmax sets the maximum value along the horizontal axis (not shown)


ymin sets the minimum value along the vertical axis.

ymax sets the maximum value along the vertical axis.

sparklines ymin ymax

color sets the color of the line

empty how to treat empty cells

  • zero give the cell a value of zero for the sparkline
  • ignore ignore the cell, rendering the chart as if it does not exist
  • Note in the image that the “ignore” option behaves the same as not designating this option at all.

Video explanation

sparklines empty options shown with different choices

nan how to treat cells with non-numeric data

  • convert let Sheets try to convert the character(s) in the cell to a number. Good luck on this one.
  • ignore ignore the cell, rendering the chart as if that value does not exist
  • Note in the image that the “ignore” option behaves the same as not designating this option at all.

sparklines nan graphs with different options shown

rtl changes the direction of the chart from left-to-right to right-to-left

  • true The direction of the chart is flipped
  • false The direction of the chart stays the same
  • Note in the image that the “false” option behaves the same as not designating this option at all.

sparklines linegraph with different rtl options specified

linewidth specifies the thickness of the line in the chart

sparklines linechart with different linde widths specified

Follow image below for the live Google doc with sparklines

docs share icon