Spreadsheet: 154056d1336165133-lookup-text-from-table-on-different-worksheet-customer-survey-submissions-5-4-2012
Sheet: Satisfaction Calculations

 | Did our Project Manager confirm all appointments prior to their scheduled time and date? | Was our Project Manager thorough in explaining the natural characteristics of granite? | Was our receptionist/phone operator courteous and helpful? | Did our Project Manager review all of your job details with you? | Did our Project Manager listen to, and answer all of your questions on the phone or in the showroom? | Did our Measure Person call you twice on the day of your Measure? | Did our Measure Person answer all your questions during the measure process? | Did our [NAME] call you twice on the day of the installation? | Did our installer answer all your questions during the installation? | Was our Installer Professional? | Did our Installer clean up before he left? | Please rate the overall quality of your installation? | Are you happy with your experience with Great Lakes? | Would you recommend our services to friends and family?
1 | 2 | 5 | 1 | 2 | 1 | 2 | 0 | 4 | 1 | 3 | 2 | 3 | 3 | 3
2 | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 1 | 3 | 2 | 1 | 2 | 1 | 1
3 | 0 | 4 | 2 | 3 | 2 | 5 | 4 | 7 | 1 | 1 | 2 | 4 | 5 | 8
4 | 4 | 7 | 4 | 9 | 5 | 4 | 4 | 3 | 4 | 3 | 4 | 6 | 6 | 4
5 | 34 | 29 | 40 | 28 | 31 | 37 | 32 | 34 | 24 | 20 | 24 | 26 | 32 | 30
OUTSTANDING | 96 | 92 | 88 | 94 | 99 | 86 | 97 | 87 | 106 | 110 | 107 | 99 | 93 | 93
TOTAL | 139 | 140 | 137 | 140 | 140 | 138 | 140 | 137 | 140 | 140 | 141 | 141 | 141 | 140
% 1 | 0.01438848920863309 | 0.03571428571428571 | 0.0072992700729927 | 0.01428571428571429 | 0.007142857142857143 | 0.01449275362318841 | 0 | 0.0291970802919708 | 0.007142857142857143 | 0.02142857142857143 | 0.01418439716312057 | 0.02127659574468085 | 0.02127659574468085 | 0.02142857142857143
% 2 | 0.01438848920863309 | 0.01428571428571429 | 0.0072992700729927 | 0.02142857142857143 | 0.007142857142857143 | 0.02173913043478261 | 0.01428571428571429 | 0.0072992700729927 | 0.02142857142857143 | 0.01428571428571429 | 0.007092198581560284 | 0.01418439716312057 | 0.007092198581560284 | 0.007142857142857143
% 3 | 0 | 0.02857142857142857 | 0.0145985401459854 | 0.02142857142857143 | 0.01428571428571429 | 0.03623188405797102 | 0.02857142857142857 | 0.05109489051094891 | 0.007142857142857143 | 0.007142857142857143 | 0.01418439716312057 | 0.02836879432624113 | 0.03546099290780142 | 0.05714285714285714
% 4 | 0.02877697841726619 | 0.05 | 0.0291970802919708 | 0.06428571428571428 | 0.03571428571428571 | 0.02898550724637681 | 0.02857142857142857 | 0.0218978102189781 | 0.02857142857142857 | 0.02142857142857143 | 0.02836879432624113 | 0.0425531914893617 | 0.0425531914893617 | 0.02857142857142857
% 5 | 0.2446043165467626 | 0.2071428571428572 | 0.291970802919708 | 0.2 | 0.2214285714285714 | 0.2681159420289855 | 0.2285714285714286 | 0.2481751824817518 | 0.1714285714285714 | 0.1428571428571428 | 0.1702127659574468 | 0.1843971631205674 | 0.2269503546099291 | 0.2142857142857143
% OUSTANDING | 0.6906474820143885 | 0.6571428571428571 | 0.6423357664233577 | 0.6714285714285714 | 0.7071428571428572 | 0.6231884057971014 | 0.6928571428571428 | 0.635036496350365 | 0.7571428571428571 | 0.7857142857142857 | 0.7588652482269503 | 0.7021276595744681 | 0.6595744680851063 | 0.6642857142857143
Average | 0.9640287769784173 | 0.9428571428571428 | 0.9781021897810219 | 0.9571428571428572 | 0.9785714285714285 | 0.9565217391304348 | 0.9785714285714285 | 0.9562043795620438 | 0.9642857142857143 | 0.9571428571428572 | 0.9716312056737588 | 0.9574468085106383 | 0.9645390070921985 | 0.9642857142857143