ENQUIRY+-+TOURISM

   181016 This is a little explainer I made to help build (and turn around) the 100% stacked column chart
 * 2016/2017 Geography Project **
 * UPDATES ** 

 media type="youtube" key="vN14UheXsUg" width="560" height="315"  Updated Data. The data is now complete.    Numbers version   <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">
 * <span style="background-color: #ffffff; color: #666666; font-family: arial,sans-serif;">Project Guide **

160916 Here are the photos from the trip. If you have any more please email them to me and I will add them. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> [|https://www.icloud.com/sharedalbum/#B0ZGIcgc2GHVos1] <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">160916 Here are last year's photos. They might be useful for location images or for equipment. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> [|https://www.icloud.com/sharedalbum/#B0Z55Z2WMJ6CpN] <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"><span style="background-color: #ffffff; color: #666666; font-family: arial,sans-serif; font-size: small;">160916 We are now not going to use BatchGeo. There is a free version called Easy Map Maker. It works in almost exactly the same way. You can access it here.

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> http://www.easymapmaker.com <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Blank Versions <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Last Year's Project Material Below <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">**2015/2016 Geography Project** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">** Geography Projects Due on Monday 9 November. **

1) If you are having any difficulty email me. I should be online most of the weekend.

2) Do not get any help with your projects. No parental assistance. No tutor assistance. This causes a big difficulty and is easy to detect. If detected I am obliged to advise your Public School and mark your project down heavily.

3) If your project is not adequate when I mark it, I will have you work on areas that need attention before it is submitted. So long as you are prepared to follow advice at this point you should not be left with a poor project.

Dr Lee

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">**Geography Project Checklist for after first draft submission.** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">
 * Key Documents** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">


 * Project Guide** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">[[file:SH15 Geography Project Guide 080915.pdf]]


 * Tourism Data v1.06 150915** (This document will be regularly updated and improved. Make sure you have the latest version) <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">This version has corrected data and is ready to map. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Updated Friday 18 September. I have removed the sections. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">[[file:SH15 Tourism Questionnaire v1.06 150915.xlsx]]

(Use these for your project but do not republish them to social media). [|https://www.icloud.com/sharedalbum/#B0455Z2WMJ6CpN] <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Last year's photographs are here. You can use them if necessary for general images of landscapes and of people using equipment. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> [|https://www.icloud.com/sharedalbum/#B0Z55Z2WMJ6CpN] <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> Questionnaire <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">
 * Photographs from Expedition**

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">
 * Table of Contents Page (PAGES VERSION)**

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">**Video explaining how to use batchgeo. I bought an account too!** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">media type="youtube" key="YfzFXVxzKvg" width="560" height="315" <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">
 * Table of Contents Page (WORD VERSION)**
 * Here is a compound bar chart with made up numbers.**

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">


 * ARCHIVE BELOW**
 * ARCHIVE BELOW**

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> PLEASE NOTE SCROLL DOWN TO GET THE NEWEST ADDITIONS
 * 2014/2015 Geography Project ** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">


 * Guide **

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> High quality maps can be found here on Digimap. We pay for this service.

Go here: http://digimapforschools.edina.ac.uk/cosmo/home

The user name is: SW1X0EA

The password will be told to you by Dr Lee.

This is version 120914 Excel Version <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">This is version 120914 Numbers Version <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">This is the web application you might want to use to build postcode maps. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; font-family: arial,sans-serif; font-size: small;">http://batchgeo.com <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> Photographs from the expedition can be found here. Please make copies as access to these will be shortly taken down.

https://www.icloud.com/photostream/#A4GqkRUiGrXnTs <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Interview Tool (Questionnaire) <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Here is a picture of this file: <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Here is a guide for when you are doing your data analysis. <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> The age ranges for the age tool were as follow <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">A 1-17 <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">B 18-24 <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">C 25-34 <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">D 35-44 <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">E 45-54 <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">F 55-64 <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">G 65+ <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Project Feedback <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">--- <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Archive 2013/2014
 * Geography Projects are due in on Friday 15 November.**

<span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">- <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">There is a good application for building postcode maps online here. http://batchgeo.com <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> **<span style="color: #666666; font-family: arial,sans-serif;">You paste a list of postcodes into the box at the top and it will make you a map with the places on it. You need to make sure the postcodes are in the right format. ** **FOLLOW THESE INSTRUCTIONS CAREFULLY** **<span style="color: #666666; font-family: arial,sans-serif;">I have improved some of the postcodes on the list and am republishing a version, which will work smoothly with this application. ** <span style="color: #666666; font-family: arial,sans-serif;">1. Open this file and copy the postcodes <span style="color: #666666; font-family: arial,sans-serif;">2. Go to http://batchgeo.com <span style="color: #666666; font-family: arial,sans-serif;">3. Choose __Validate__ and change the settings to these:
 * Geography Enquiries will be given a due date shortly, once it is ascertained what progress boys have made/are making. Enquiries need to be entirely a boy's own work. Work produced that is not a boy's own work is obvious and is marked accordingly. Enquiries are marked by me and Heads of Geography at a candidate's public school, to whom they are sent. (Boys will get projects back next year in their geography lessons). Enquiries are worth 20% of the Geography CE grade. They are not formally assessed for Scholarship candidates, although public schools do like to see them.**
 * Dr Lee 8 October 2013**



<span style="color: #666666; font-family: arial,sans-serif;">4. Paste the postcodes into the box at the top of the page, where it says paste in data.

<span style="color: #666666; font-family: arial,sans-serif;">5. Select Make Map

<span style="color: #666666; font-family: arial,sans-serif;">6. Wait for map to complete

<span style="color: #666666; font-family: arial,sans-serif;">7. Save map to private and include your email address and the map link will be mailed to you.

**<span style="color: #666666; font-family: arial,sans-serif;">It takes a little while to build but you can watch its progress. ** Copy and put into your project. **<span style="color: #666666; font-family: arial,sans-serif;">--- ** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">**Tourism Questionnaire** <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;"> <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">Project Guide Summary <span style="background-color: #ffffff; color: #666666; display: block; font-family: arial,sans-serif; font-size: small;">

<span style="background-color: #ffffff; color: #666666; font-family: arial,sans-serif; font-size: small;">To access the photos please send me an email at al@sussexhousechool.co.uk and I will generate you a pass to see the photographs. Please specify who you are when you are making a request. Each pass is different and will only work on one device. Dr Lee

<span style="background-color: #ffffff; color: #666666; font-family: arial,sans-serif; font-size: small; line-height: 0px; overflow: hidden;">

Find below a copy of the dataset that we collated. I have cleaned it up with postcodes etc.

NB The data set has been found to have some counting errors in it. These errors were part of the spreadsheet that was provided, and they have now been fixed. You will need to update the numbers in your graphs, if you have used the totals at the bottom of the spreadsheet. Your numbers should be accurate, if you have tallied your own 1s (ones).

Numbers version

Excel version