Spreadsheet: 52562d1252418004-sorting-multiple-columns-help
Sheet: qryExportNctcog2030

Layer | EMP10w | EMP20w | HH10w | HH20w | HHPOP10w | HHPOP20w | DifferenceEmp | DifferenceHH | DifferencePOP | PCemp | PChh | Pcpop
Area 01 | 63456 | 85093 | 75343 | 102934 | 214692 | 290809 | 21637 | 27591 | 76117 | 34.0976424609178 | 36.62052214538842 | 35.45404579583776
Area 02 | 44830 | 60913 | 46057 | 59700 | 129133 | 165700 | 16083 | 13643 | 36567 | 35.87552977916574 | 29.62199014264932 | 28.31731625533365
Area 03 | 23953 | 31825 | 18621 | 26976 | 55133 | 78288 | 7872 | 8355 | 23155 | 32.86435937043377 | 44.8686966328339 | 41.99844013567192
Area 04 | 37345 | 45971 | 40861 | 48763 | 118237 | 141571 | 8626 | 7902 | 23334 | 23.09813897442763 | 19.33873375590417 | 19.73493914764414
Area 05 | 5753 | 8861 | 11183 | 21171 | 32330 | 60221 | 3108 | 9988 | 27891 | 54.02398748479055 | 89.31413753017974 | 86.26971852768327
Area 06 | 20610 | 25968 | 23432 | 35860 | 66972 | 102317 | 5358 | 12428 | 35345 | 25.99708879184861 | 53.03857972004097 | 52.77578689601624
Area 07 | 278278 | 311324 | 177467 | 190299 | 501008 | 534798 | 33046 | 12832 | 33790 | 11.8751751845277 | 7.230640062659536 | 6.744403282981509
Area 08 | 36914 | 61530 | 41003 | 54448 | 117810 | 153724 | 24616 | 13445 | 35914 | 66.68472666197107 | 32.7902836377826 | 30.48467871997283
Area 09 | 117683 | 135801 | 75926 | 78427 | 167840 | 172509 | 18118 | 2501 | 4669 | 15.39559664522488 | 3.293996786344599 | 2.781816015252621
Area 10 | 89093 | 112461 | 85852 | 88803 | 231951 | 239837 | 23368 | 2951 | 7886 | 26.22877218187736 | 3.437310720775288 | 3.399856004069826
Area 11 | 11653 | 16040 | 21714 | 32270 | 64432 | 95346 | 4387 | 10556 | 30914 | 37.64695786492749 | 48.61379754996776 | 47.97926496150981
Area 12 | 14368 | 31877 | 26818 | 40249 | 74944 | 112061 | 17509 | 13431 | 37117 | 121.8610801781737 | 50.08203445447088 | 49.52631298035867
Area 13 | 13916 | 24657 | 27556 | 42448 | 78326 | 119086 | 10741 | 14892 | 40760 | 77.18453578614545 | 54.04267673102046 | 52.03891428133698
Area 14 | 3031 | 6433 | 9335 | 16850 | 27494 | 48030 | 3402 | 7515 | 20536 | 112.2401847575058 | 80.50348152115694 | 74.69266021677457
Area 15 | 5450 | 10184 | 3792 | 8962 | 11012 | 25315 | 4734 | 5170 | 14303 | 86.86238532110092 | 136.3396624472574 | 129.8855793679622
Area 16 | 7202 | 17520 | 4261 | 8006 | 11221 | 19988 | 10318 | 3745 | 8767 | 143.2657595112469 | 87.89016662755222 | 78.1302914178772
Area 17 | 13040 | 19645 | 7793 | 13658 | 21470 | 37127 | 6605 | 5865 | 15657 | 50.65184049079755 | 75.25984858206083 | 72.92501164415464
Area 18 | 222262 | 251168 | 99694 | 104676 | 242713 | 253563 | 28906 | 4982 | 10850 | 13.00537203840512 | 4.99729171264068 | 4.470300313539036
Area 19 | 38921 | 44765 | 56925 | 61915 | 166281 | 180104 | 5844 | 4990 | 13823 | 15.01503044628864 | 8.765920070267896 | 8.313036366151275
Area 20 | 71507 | 87788 | 61639 | 80989 | 156482 | 203058 | 16281 | 19350 | 46576 | 22.76840029647447 | 31.3924625642856 | 29.76444575094899
Area 21 | 166655 | 224914 | 139964 | 156453 | 387786 | 432703 | 58259 | 16489 | 44917 | 34.95784704929345 | 11.78088651367494 | 11.58293491771235
Area 22 | 28092 | 57488 | 12148 | 29352 | 34792 | 81517 | 29396 | 17204 | 46725 | 104.6418909298021 | 141.6200197563385 | 134.2981145090826
Area 23 | 39859 | 59271 | 26428 | 51371 | 75268 | 141908 | 19412 | 24943 | 66640 | 48.70167339873053 | 94.38095958831542 | 88.53696125843652
Area 24 | 14628 | 20055 | 16244 | 22395 | 43479 | 58976 | 5427 | 6151 | 15497 | 37.10008203445447 | 37.8662890913568 | 35.64249407760068
Area 25 | 22996 | 33071 | 29550 | 43177 | 74440 | 108189 | 10075 | 13627 | 33749 | 43.81196729866063 | 46.11505922165821 | 45.33718430951102
Area 26 | 87934 | 108549 | 92253 | 128169 | 227034 | 319389 | 20615 | 35916 | 92355 | 23.44371915300111 | 38.93206724984553 | 40.6789291471762
Area 27 | 35124 | 43926 | 16953 | 22693 | 48664 | 64441 | 8802 | 5740 | 15777 | 25.05978817902289 | 33.85831416268507 | 32.42026960381391
Area 28 | 57044 | 82375 | 87491 | 107799 | 257542 | 315252 | 25331 | 20308 | 57710 | 44.4060725054344 | 23.21153032883382 | 22.40799558906897
Area 29 | 293751 | 368064 | 73801 | 78593 | 169600 | 179338 | 74313 | 4792 | 9738 | 25.29795643248874 | 6.49313694936383 | 5.741745283018869
Area 30 | 181369 | 205075 | 81293 | 84135 | 235156 | 242971 | 23706 | 2842 | 7815 | 13.07059089480562 | 3.495995965212257 | 3.323325792240045
Area 31 | 262680 | 281966 | 106245 | 111603 | 333603 | 347443 | 19286 | 5358 | 13840 | 7.342013095781939 | 5.043060849922349 | 4.148643747208508
Area 32 | 204304 | 222237 | 146234 | 157386 | 360175 | 386165 | 17933 | 11152 | 25990 | 8.777605920588927 | 7.626133457335503 | 7.215936697438745
Area 33 | 50454 | 51960 | 34831 | 35649 | 103623 | 105674 | 1506 | 818 | 2051 | 2.984897134023071 | 2.34848267348052 | 1.979290311996371
Area 34 | 68948 | 74349 | 34904 | 36642 | 87916 | 92725 | 5401 | 1738 | 4809 | 7.833439693682196 | 4.979371991748796 | 5.469994085263206
Area 35 | 184825 | 208210 | 40560 | 45318 | 110475 | 120058 | 23385 | 4758 | 9583 | 12.65250913025835 | 11.73076923076923 | 8.674360715093913
Area 36 | 189141 | 194229 | 48941 | 49743 | 139029 | 141129 | 5088 | 802 | 2100 | 2.690056624423049 | 1.638707831879202 | 1.510476231577585
Area 37 | 198974 | 226480 | 25897 | 33057 | 42243 | 54775 | 27506 | 7160 | 12532 | 13.82391669263321 | 27.6479901146851 | 29.66645361361645
Area 38 | 25043 | 25206 | 13920 | 13920 | 33983 | 33958 | 163 | 0 | -25 | 0.6508804855648285 | 0 | -0.07356619486213695
Area 39 | 58836 | 70509 | 19253 | 19259 | 37968 | 37791 | 11673 | 6 | -177 | 19.83989394248419 | 0.03116397444554096 | -0.4661820480404551
Area 40 | 217825 | 247681 | 149002 | 151469 | 347930 | 351095 | 29856 | 2467 | 3165 | 13.70641570067715 | 1.655682474060751 | 0.9096657373609633
Area 41 | 88898 | 97906 | 58042 | 61252 | 183570 | 192693 | 9008 | 3210 | 9123 | 10.13296137145943 | 5.530477929774991 | 4.969766301683282
Area 42 | 24604 | 33859 | 26229 | 43680 | 69970 | 115466 | 9255 | 17451 | 45496 | 37.61583482360592 | 66.53322658126501 | 65.02215235100758
 |  |  |  |  |  |  |  |  |  |  | 3158200 | 5416800 | 71.51542017604964