Google sheets db query assistance.

Posted by - Muh Imran at Nov 26, 2021
Dodoma, Tanzania

Toogit Instant Connect Enabled
BudgetTypeStatusValid Through
$15.37HOURLYOpenDec 26, 2021

Job Description

This should be a quick 1-2 hour job for anyone experienced with Google sheets query.

I have a sheet full of survey results, sometimes people will perform the survey twice, and I want to make a query that compares the variance of 1st survey vs 2nd survey for the same person. The survey will have 8-10 questions, each question is answered with a 1-5 scale.

I have made a named range of the whole sheet called SurveyResults.

I would like to make a report that outputs the variance (VAR query) of each question if a person answered it twice, and maybe answered differently the 2nd time. Sample:
Columns: A,B,C,D,E,F

Sample data, answer for question 1 found in Column B and name in column E
3 jane
5 joe
2 joe
5 jane

In this case Jane answer question1 (Q1), 2 times, so I see variance of of +2 from 3 vs 5.

Joe answered Q1 twice, and there is a variance of -3.

Here is the sheet:
https://docs.google.com/spreadsheets/d/1n9344zyCBL1QD9vZLCUYKRn46RXejLXqw9gdRyhSUGc

I have gotten this far:

=QUERY(SurveyResults,'SELECT B, ..... something WHERE E is the same, VAR..., -1).

There are a couple other queries I want to make, but that is the starting point.

For instance, Column F may have the company name of a person, and I want to calculate the average variance for each question from everyone in the same company. There may be additional needs in the future for this.

Skills & Expertise Required

Database Programming Google Docs Google Spreadsheets Google Spreadsheets API 

Offer to work on this project closes in 16 days!

Try more jobs by Muh Imran

Excel expert Needed for Advanced NPV ROI IRR for Solar Project calculations - Hourly
DevOps/AWS/Jenkins/Terraform Support - Hourly
Redshift and Python Development for Reporting Project - Hourly

Similar Projects

Tech in Norwich, United Kingdom

Tech should have:
- Experience with DELL Tape Libraries (LT06).
- The technician can understand and speak English.
Hourly, $15.37

Shopify/Aliexpress dropship product...

Need you to find 20 different product catagories/niches using the method below:

1. Research Best selling product catagories (Google AliExpress Best sellers) on AliExpress.
Further refine...read more
Fixed, $38.42

ATF activation for incident Mgt pro...

Looking for an experienced ServiceNow developer to guide with automating test frame for incident management process.

Hourly, $21.51

Muh Imran hiring Database Programming, Google Docs, Google Spreadsheets, Google Spreadsheets API experts from & nearby:

  • Afghanistan
  • Albania
  • Algeria
  • American Samoa
  • Andorra
  • Angola
  • Anguilla
  • Antarctica
  • Antiguaand Barbuda
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan
  • Bahamas
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosniaand Herzegovina
  • Botswana
  • Bouvet Island
  • Brazil
  • British Indian Ocean Territory
  • Brunei
  • Bulgaria
  • Burkina Faso
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde
  • Cayman Islands
  • Central African Republic
  • Chad
  • Chile
  • China
  • Christmas Island
  • Cocos Islands
  • Colombia
  • Comoros
  • Republic of the Congo
  • Democratic Republicof the Congo
  • Cook Islands
  • Costa Rica
  • Ivory Coast
  • Croatia
  • Cuba
  • Cyprus
  • Czech Republic
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • EastTimor
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • External Territories of Australia
  • Falkland Islands
  • Faroe Islands
  • Fiji
  • Finland
  • France
  • French Guiana
  • French Polynesia
  • French Southern Territories
  • Gabon
  • Gambia
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guadeloupe
  • Guam
  • Guatemala
  • Guernseyand Alderney
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Heard Islandand McDonald Islands
  • Honduras
  • HongKong
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iran
  • Iraq
  • Ireland
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jersey
  • Jordan
  • Kazakhstan
  • Kenya
  • Kiribati
  • North Korea
  • South Korea
  • Kuwait
  • Kyrgyzstan
  • Laos
  • Latvia
  • Lebanon
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macao
  • Macedonia
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Mali
  • Malta
  • Man(Isleof)
  • Marshall Islands
  • Martinique
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia
  • Moldova
  • Monaco
  • Mongolia
  • Montserrat
  • Morocco
  • Mozambique
  • Myanmar
  • Namibia
  • Nauru
  • Nepal
  • Netherlands Antilles
  • Netherlands
  • New Caledonia
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norfolk Island
  • Northern Mariana Islands
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Palestinian Territory
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Pitcairn
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Reunion
  • Romania
  • Russia
  • Rwanda
  • Saint Helena
  • Saint Kittsand Nevis
  • Saint Lucia
  • Saint Pierreand Miquelon
  • Saint Vincentandthe Grenadines
  • Samoa
  • San Marino
  • Sao Tomeand Principe
  • Saudi Arabia
  • Senegal
  • Serbia
  • Seychelles
  • SierraLeone
  • Singapore
  • Slovakia
  • Slovenia
  • Smaller Territories of the UK
  • Solomon Islands
  • Somalia
  • South Africa
  • South Georgia and the South Sandwich Islands
  • South Sudan
  • Spain
  • Sri Lanka
  • Sudan
  • Suriname
  • Svalbardand Jan Mayen
  • Swaziland
  • Sweden
  • Switzerland
  • Syria
  • Taiwan
  • Tajikistan
  • Tanzania
  • Thailand
  • Togo
  • Tokelau
  • Tonga
  • Trinidadand Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turksand Caicos Islands
  • Tuvalu
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • United States Minor Outlying Islands
  • Uruguay
  • Uzbekistan
  • Vanuatu
  • Vatican
  • Venezuela
  • Vietnam
  • British Virgin Islands
  • U.S.Virgin Islands
  • Wallis and Futuna
  • Western Sahara
  • Yemen
  • Yugoslavia
  • Zambia
  • Zimbabwe
  • Aland Islands
  • Saint Barthélemy
  • Bonaire, Saint Eustatiusand Saba
  • Curaçao
  • Guernsey
  • Isleof Man
  • Jersey
  • Montenegro
  • Saint Martin
  • Sint Maarten
  • East Timor
  • Kosovo