《salary-survey-entry-09-lmorris.xlsx》由会员分享，可在线阅读，更多相关《salary-survey-entry-09-lmorris.xlsx（50页珍藏版）》请在三一文库上搜索。
1、The contest1.Step1:DownloadExcelSalarySurveyrawdata.2.Step2:AnalyzeitandpresentyouranalysisusingExcelcharts(refertorulesbelow)3.Step3:Submit your output by end of 6th of July (Friday)4.Step4:Ifyouroutputismind-blowinglyawesome,youcouldwinXBOX360+KinectBundleGoals for analysis:Whileyouarefreetoanalyz
2、ethedatainanyway,youroutputmustmeetthesegoalsHelpusunderstandhowmuchExcelprofessionalsmakeallovertheworldHelpusunderstandrelationshipbetweensalaryandrole,experience,country&hoursofExcelwork.How to send your entriesOnceyouarereadytosendyourentry,1.Checktherules(below)andmakesureyouhavefollowedallofth
3、em.2. Email your workbooks to chandoo.d withsubject“Salary Survey Contest“3.Pleaseincludeyourname&bestemailaddress(es)sothatwecanreachyouifthereisanyclarificationneeded.4. Please send in your entries before end of 6th July (Friday).The RulesYoucanmakeadashboardor1pagereportYoucanmakeseveralindividua
4、lcharts(ortables)tooaslongastheyallfitintoonewindow.YoucanmakeinteractiveorstaticchartsYoucanalsouseVBAtoaddinteractiontothecharts.Eventhoughyoucanuseadd-instomakeyourreport,usershouldbeabletoviewyouroutputwithoutinstallinganyadd-insYoucanuseExcel2010,2007or2003.Pleasenotethatthiscontestrequiresuseo
5、fExcel.Youcansubmitmorethanoneentry.Yourfilesmustbeunlocked&anymacrosyouusemusthaveenoughcommentssothatotherscanlearn.Youcanadddatatothisdataset(forexample,PPPadjustedsalaries,establishedsalarybenchmarksfrompublicsourceslikegovt.databasesorwebsites)The PrizesThewinnerofthiscontestwillreceive1XBOX360
6、(4GB)+KinectSportsbundle(valued$299).Wehave2consolationprizestoo.Forthe2ndbestentry,yougetaAmazonKindleFireandfor3rdbestentry,yougetaKindleTouch($99option).Sothereyougo.3gorgeousgadgetsupforgrabs.Primary RegionSecondary ComparisonRoleAvg. SalaryRoleAvg. SalaryAccountant55,503Accountant15,398.00Analy
7、st40,657Analyst14,690.00Consultant82,000Consultant21,925.00Controller11,628Controller25,674.00CXO or TopMgmt.69,815CXO or TopMgmt.33,891.00Engineer16,688Engineer21,813.00Manager46,758Manager19,034.00Misc.-Misc.17,551.00Reporting19,985Reporting11,321.00Specialist38,666Specialist28,215.00Comparison Av
8、g Salary in US$Primary Avg Salary in US$1 to 5 Years6 to 10 Years11 to 15 Years16 to 20 Years21+ YearsNo Response - 2 4 6 8 10 12 Salaries(x10,000)&HoursPrimary Avg Hours Per DayComparison Avg Hours per Day30%30%8%11%5%16%Average Salary and Hours by ExperiencePrimary % Responding71769230596373222Ave
9、rage Salary by Regional ResponsesAsiaNorth AmericaEuropeAustraliaAfricaSouth AmericaUnknownLatin America - 1 2 3 4 5 6 7 8 9 10 Salaries(x 10,000)&Respondents(x 100)RespondentsAvg Salary in USD% of ResponsesSouth AfricaOthers 5%60%40%20%0%Primary Region Country DetailSouth AfricaOthers 5%Average Sal
10、ary - 10 20 30 40 50 60 Salary (Thousands) - 1 2 3 4 5 6 7 Average HoursAvg SalaryAvg HoursRoles and Average Hours by Country in Primary Region - 1 2 3 4 5 6 - 20 40 60 80 100 120 140 (Thousands)ResponsesSalaryAccountantAnalystConsultantControllerCXO or Top Mgmt.EngineerManagerMisc.ReportingSpeciali
11、stResponses 2 5 1 1 2 - 5 - 2 1 Median Avg Salary 36,958 32,187 82,000 9,510 69,815 - 39,000 - 28,500 38,666 Max Salary 44,654 109,730 82,000 9,510 125,000 - 131,676 - 45,000 38,666 Minimum Salary 29,261 9,600 82,000 9,510 14,631 - 12,192 - 12,000 38,666 Mean Avg Salary 36,958 44,071 82,000 9,510 69
12、,815 - 64,096 - 28,500 38,666 Select aPrimary Region Country forAnalysis by Role and Avg Hours(for the nerds)AsiaAfricaSouth Africa5.256.255506.306.58Avg HoursPrimary Region Country DetailRoles and Average Hours by Country in Primary Region - 1 2 3 4 5 6 - 20 40 60 80 100 120 140 (Thousands)Response
13、sSalaryAccountantAnalystConsultantControllerCXO or Top Mgmt.EngineerManagerMisc.ReportingSpecialistResponses 2 5 1 1 2 - 5 - 2 1 Median Avg Salary 36,958 32,187 82,000 9,510 69,815 - 39,000 - 28,500 38,666 Max Salary 44,654 109,730 82,000 9,510 125,000 - 131,676 - 45,000 38,666 Minimum Salary 29,261
14、 9,600 82,000 9,510 14,631 - 12,192 - 12,000 38,666 Mean Avg Salary 36,958 44,071 82,000 9,510 69,815 - 64,096 - 28,500 38,666 Mapping SheetSource:Xrateson6/21/2012Currency MappingCurrencyin USDValue of 1 American DollarUSD1 Argentine Peso EUR1.270399 Australian Dollar PKR0.010614 Botswana Pula INR0
15、.017808 Brazilian Real GBP1.576178 British Pound AUD1.01991 Brunei dollar CAD0.983362 Bulgarian Lev PHP0.023705 Canadian Dollar AED0.272219 Chilean Peso MXN0.073047 Chinese Yuan SEK0.143655 Colombian Peso BDT0.012221 Croatian Kuna COSTARICAN0.002008 Danish Krone ZAR0.121922 Euro NZD0.797588 Hong Kon
16、g Dollar CNY0.15721 Hungarian Forint EGYPT0.165262 Iceland Krona NAIRA0.006163 Indian Rupee AED0.272219 Indonesian Rupiah BRL0.494281 Israeli New Shekel RON0.284613 Japanese Yen USD1 Kazakhstani Tenge MYR0.316801 Kuwaiti Dinar LKR0.007524 Latvian Lat SGD0.788824 Libyan Dinar GBP1.576178 Lithuanian L
17、itas DOP0.025674 Malaysian Ringgit PLN0.300315 Mauritius Rupee KENYA0.011976 Mexican Peso DKK0.170904 Nepalese Rupee IDR0.000106 New Zealand Dollar MONGOLIAN0.000756 Norwegian Kroner JPY0.012674 Omani Rial SAR0.266667 Pakistan Rupee MAD0.114548 Philippine Peso MUR0.032556 Qatari Rial NOK0.169251 Rom
18、anian Leu CHF1.057873 Russian Ruble ETB0.056561 Saudi Riyal Singapore Dollar South African Rand South Korean Won Sri Lanka Rupee Swedish Krona Swiss Franc Taiwan Dollar Thai Baht Trinidad/Tobago Dollar Turkish Lira Venezuelan Bolivar UAE DirhamBangladesh TakhaCostarican CRCEgyptian PoundNigerian Nai
19、raDominican PesoPolish ZlotyKenyan ShillingMongolian TughrikMoroccan DirhamEthiopian BCountry MappingActual4.49273 ARSUSA0.980479 AUDIndia7.65697 BWPUK2.02314 BRLAustralia0.634446 GBPCanada1.2687 BNDPakistan1.53952 BGNSouth Africa1.01692 CADGermany497.268 CLPUAE6.36091 CNYBrazil1769.79 COPNetherland
20、s5.93671 HRKSingapore5.85123 DKKPhilippines0.787154 EURPortugal7.75889 HKDSpain225.874 HUFNew Zealand124.697 ISKRussia56.1548 INRSaudi Arabia9443.81 IDRMexico3.86721 ILSIndonesia78.9043 JPYNorway148.88 KZTmalaysia0.2794 KWDThe Netherlands0.548489 LVLRomania1.9324 LYDPoland2.71788 LTLitaly3.15656 MYR
21、Hungary30.7159 MURDenmark13.6899 MXNIreland89.65 NPRIsrael1.25378 NZDFrance5.90838 NOKColombia0.3845 OMRSwitzerland94.2144 PKRSri Lanka42.1851 PHPBelgium3.64 QARDubai3.51354 RONUkraine32.5458 RUBKuwait3.75 SARiran1.26771 SGDQatar8.20198 ZARNigeria1151.09 KRWFinland132.907 LKREurope6.96111 SEKJapan0.
22、945293 CHFBrasil29.8594 TWDnz31.5003 THBGreece6.39122 TTDksa1.79447 TRYPanama4.29402 VEFTurkey3.67351 AEDSweden81.8274 BDTchina498.05 CostaricanBangladesh6.051 EgyptCroatia162.25 NAIRAUnited Arab Emirates38.95 DOPMxico3.32984 PLNZambia83.5 KenyaTunisia1322 MongolianSaudi Arabai8.73 MADEthiopia17.68
23、ETBCEESouthAfricaCentral AmericaUruguayKenyaRepublica DominicanaKingdom of Saudi ArabiaSlovakiaAustriaGuyanaAzerbaijanBulgariaKuwait PeruVietnamArmeniaZimbabweRSALibyaself-employedLithuaniaSomaliaColombia - South AmericaBRAmainland Europe (Euro zone)ThailandContinental EuropeAsiaMauritiusCambodiaCos
24、ta RicaViet NamMongoliaEstoniaMontenegroEUMoroccoRepublic of Georgiamozambiqueeurope/CroatiaMyanmarBermudaMyanmar BurmaFRMYSBhutanBalticSloveniaNew ZealandBoliviaCzech RepublicGhanabangkoksrilankaNLHong KongnldArubaDKIcelandDominican RepublicUgandaOmanInonesiaArgentinaUnited Arab EmriatePakistan, An
25、golaCanadEgyptarabian GulfParaguayLatin AmericaAlbaniaLesothoHours MappingMappingContinent/RegionExcel ?!? What Excel?0USANorth America1 or 2 hours a day 1.5IndiaAsia2 to 3 hours per day2.5UKEurope4 to 6 hours a day5AustraliaAustraliaAll the 8 hours baby, all the 8!8CanadaNorth AmericaPakistanAsiaYe
26、ars of Experience MappingSouth AfricaAfrica1 1 to 5 YearsGermanyEurope2 6 to 10 YearsUAEAsia3 11 to 15 YearsBrazilSouth America4 16 to 20 YearsNetherlandsEurope5 21+ YearsSingaporeAsia6 No ResponsePhilippinesAsiaJob TypesPortugalEuropeSpainEuropeAccountantNew ZealandAustraliaAnalystRussiaAsiaConsult
27、antSaudi ArabiaAsiaControllerMexicoNorth AmericaCXO or Top Mgmt.IndonesiaAsiaEngineerNorwayEuropeManagermalaysiaAsiaMisc.NetherlandsEuropeReportingRomaniaEuropeSpecialistPolandEuropeitalyEuropeHungaryEuropeDenmarkEuropeIrelandEuropeIsraelAsiaFranceEuropeColombiaSouth AmericaSwitzerlandEuropeSri Lank
28、aAsiaBelgiumEuropeDubaiAsiaUkraineEuropeKuwaitAsiairanAsiaQatarAsiaNigeriaAfricaFinlandEuropeEuropeEuropeJapanAsiaBrazilSouth AmericaNew ZealandAustraliaGreeceEuropeUSANorth AmericaPanamaNorth AmericaTurkeyEuropeSwedenEuropechinaAsiaBangladeshAsiaCroatiaEuropeUAEAsiaMexicoNorth AmericaZambiaAfricaTu
29、nisiaAfricaSaudi ArabiaAsiaEthiopiaAfricaCEEEuropeSouth AfricaAfricaCentral AmericaLatin AmericaUruguaySouth AmericaKenyaAfricaRepublica DominicanaNorth AmericaSaudi ArabiaAsiaSlovakiaEuropeAustriaEuropeGuyanaSouth AmericaAzerbaijanAsiaBulgariaEuropeKuwait AsiaPeruSouth AmericaVietnamAsiaArmeniaEuro
30、peZimbabweAfricaSouth AfricaAfricaLibyaAfricaself-employedUnknownLithuaniaEuropeSomaliaAfricaColombiaSouth AmericaBrazilSouth AmericaEuropeEuropeThailandAsiaCEEEuropeAsiaAsiaMauritiusAfricaCambodiaSouth AmericaCosta RicaNorth AmericaViet NamAsiaMongoliaAsiaEstoniaEuropeMontenegroEuropeEuropeEuropeMo
31、roccoAfricaRepublic of GeorgiaAsiamozambiqueAfricaCroatiaEuropeMyanmarAsiaBermudaNorth AmericaMyanmarAsiaFranceAsiaMYSUnknownBhutanAsiaBalticEuropeSloveniaEuropeNew ZealandAustraliaBoliviaSouth AmericaCzech RepublicEuropeGhanaAfricaThailandAsiaSri LankaAsiaNetherlandsEuropeHong KongAsiaNew ZealandAu
32、straliaArubaNorth AmericaDenmarkEuropeIcelandEuropeDominican RepublicNorth AmericaUgandaAfricaOmanAsiaIndonesiaAsiaArgentinaSouth AmericaUAEAsiaPakistanAsiaCanadaNorth AmericaEgyptAfricaarabian GulfAsiaParaguaySouth AmericaLatin AmericaLatin AmericaAlbaniaEuropeLesothoAfricaYears of Experience Mappi
33、ng1 to 5 Years6 to 10 Years11 to 15 Years16 to 20 YearsNo ResponseExcel Salary Survey DataNote: Experience data is not available for first few hundred rows.Unique IDTimestampYour Salaryclean Salary (in local currency)Currency Salary in USDID002525 五月 2012, 4:43 AM40000 us40000 USD40000ID003725 五月 20
34、12, 5:07 AM150000150000 USD150000ID006525 五月 2012, 7:20 AM8500085000 USD85000ID007225 五月 2012, 10:52 PM 7500075000 USD75000ID008025 五月 2012, 11:31 PM 5000050000 USD50000ID008426 五月 2012, 12:05 AM 120000120000 USD120000ID009226 五月 2012, 12:39 AM 3600036000 USD36000ID009626 五月 2012, 12:40 AM 240002400
35、0 USD24000ID009726 五月 2012, 12:40 AM 91,000 USD91000 USD91000ID009926 五月 2012, 12:40 AM 5700057000 USD57000ID010426 五月 2012, 12:40 AM 5200052000 USD52000ID011326 五月 2012, 12:41 AM $58,000 USD58000 USD58000ID012626 五月 2012, 12:42 AM 128000128000 USD128000ID012726 五月 2012, 12:42 AM US $44,00044000 USD
36、44000ID014726 五月 2012, 12:44 AM 8800088000 USD88000ID015126 五月 2012, 12:44 AM 3500035000 USD35000ID016326 五月 2012, 12:46 AM 5500055000 USD55000ID018326 五月 2012, 12:50 AM 7000070000 USD70000ID018926 五月 2012, 12:50 AM 8000080000 USD80000ID020026 五月 2012, 12:53 AM 9000090000 USD90000ID020326 五月 2012, 1
37、2:53 AM 5100051000 USD51000ID020426 五月 2012, 12:53 AM 100000100000 USD100000ID021026 五月 2012, 12:54 AM 5000050000 USD50000ID021126 五月 2012, 12:54 AM 400000400000 USD400000ID021426 五月 2012, 12:54 AM 4100041000 USD41000ID021826 五月 2012, 12:56 AM 4160041600 USD41600ID022726 五月 2012, 12:58 AM 5000050000
38、 USD50000ID024426 五月 2012, 1:03 AM9000090000 USD90000ID024526 五月 2012, 1:03 AM7000070000 USD70000ID024826 五月 2012, 1:03 AM140000140000 USD140000ID025726 五月 2012, 1:06 AM130000130000 USD130000ID026626 五月 2012, 1:08 AM5400054000 USD54000ID026926 五月 2012, 1:09 AM7600076000 USD76000ID027826 五月 2012, 1:1
39、1 AM8000080000 USD80000ID028526 五月 2012, 1:15 AM1500015000 USD15000ID028926 五月 2012, 1:17 AM6800068000 USD68000ID029826 五月 2012, 1:20 AM6000060000 USD60000ID031026 五月 2012, 1:23 AM4000040000 USD40000ID031426 五月 2012, 1:25 AM125000125000 USD125000ID032926 五月 2012, 1:31 AM9200092000 USD92000ID033126 五
40、月 2012, 1:31 AM108000108000 USD108000ID033926 五月 2012, 1:35 AM135000135000 USD135000ID034126 五月 2012, 1:35 AM2900029000 USD29000ID035026 五月 2012, 1:40 AM5300053000 USD53000ID035526 五月 2012, 1:42 AM5600056000 USD56000ID035926 五月 2012, 1:43 AM6800068000 USD68000ID036726 五月 2012, 1:49 AM8900089000 USD8
41、9000ID036926 五月 2012, 1:50 AM4750047500 USD47500ID037026 五月 2012, 1:50 AM130000130000 USD130000ID037326 五月 2012, 1:51 AM4193241932 USD41932ID038826 五月 2012, 2:00 AM4700047000 USD47000ID039226 五月 2012, 2:01 AM5000050000 USD50000ID039526 五月 2012, 2:03 AM4588045880 USD45880ID039626 五月 2012, 2:03 AM7000
42、070000 USD70000ID040026 五月 2012, 2:05 AM4700047000 USD47000ID040126 五月 2012, 2:05 AM4000040000 USD40000ID041726 五月 2012, 2:17 AM5600056000 USD56000ID042826 五月 2012, 2:27 AM US $30,000.00 30000 USD30000ID043126 五月 2012, 2:33 AM6000060000 USD60000ID044726 五月 2012, 2:49 AM5100051000 USD51000ID045826 五月
43、 2012, 3:03 AM8000080000 USD80000ID046126 五月 2012, 3:06 AM125000125000 USD125000ID046526 五月 2012, 3:09 AM6000060000 USD60000ID051226 五月 2012, 4:18 AM6500065000 USD65000ID051526 五月 2012, 4:25 AM7600076000 USD76000ID052326 五月 2012, 4:40 AM7260072600 USD72600ID053026 五月 2012, 5:00 AM8230082300 USD82300
44、ID055026 五月 2012, 5:35 AM5000050000 USD50000ID057326 五月 2012, 6:54 AM9000090000 USD90000ID057926 五月 2012, 7:18 AM9000090000 USD90000ID058626 五月 2012, 7:50 AM115000115000 USD115000ID060226 五月 2012, 8:56 AM90 k90000 USD90000ID061426 五月 2012, 10:31 AM 6100061000 USD61000ID062426 五月 2012, 11:03 AM 50000
45、50000 USD50000ID062726 五月 2012, 11:05 AM 9500095000 USD95000ID063726 五月 2012, 11:37 AM 8000080000 USD80000ID080126 五月 2012, 9:10 PM4850048500 USD48500ID080826 五月 2012, 9:43 PM4800048000 USD48000ID083126 五月 2012, 11:05 PM 4000040000 USD40000ID085627 五月 2012, 3:19 AM3200032000 USD32000ID087627 五月 2012
46、, 10:13 AM 8745687456 USD87456ID094528 五月 2012, 12:17 AM 7000070000 USD70000ID095428 五月 2012, 1:47 AM135000135000 USD135000ID097028 五月 2012, 6:51 AM6000060000 USD60000ID113828 五月 2012, 6:39 PM9000090000 USD90000ID119128 五月 2012, 11:13 PM 6000060000 USD60000ID119828 五月 2012, 11:33 PM 8800088000 USD88
47、000ID121529 五月 2012, 12:29 AM 6000060000 USD60000ID122729 五月 2012, 1:44 AM100000100000 USD100000ID126529 五月 2012, 8:47 AM4000040000 USD40000ID126729 五月 2012, 9:15 AM8200082000 USD82000ID127529 五月 2012, 10:08 AM 7000070000 USD70000ID130329 五月 2012, 1:53 PM8000080000 USD80000ID135529 五月 2012, 6:38 PM1
48、25000125000 USD125000ID136429 五月 2012, 7:12 PM125000125000 USD125000ID136929 五月 2012, 7:47 PM5750057500 USD57500ID137129 五月 2012, 7:52 PM$80,000 USD80000 USD80000ID137529 五月 2012, 8:40 PM$60,000 USD60000 USD60000ID138529 五月 2012, 9:42 PM120000120000 USD120000ID138729 五月 2012, 9:46 PM97,000 USD97000
49、USD97000ID139329 五月 2012, 10:02 PM 150000150000 USD150000ID139829 五月 2012, 10:24 PM 136000136000 USD136000ID140129 五月 2012, 10:47 PM 130000130000 USD130000ID140529 五月 2012, 11:06 PM 4000040000 USD40000ID140929 五月 2012, 11:20 PM 4000040000 USD40000ID141329 五月 2012, 11:44 PM 8800088000 USD88000ID14173
50、0 五月 2012, 12:25 AM 120000120000 USD120000ID141830 五月 2012, 12:34 AM 107000107000 USD107000ID142030 五月 2012, 12:50 AM 8100081000 USD81000ID142430 五月 2012, 1:15 AM7200072000 USD72000ID142830 五月 2012, 1:48 AM7500075000 USD75000ID143430 五月 2012, 2:22 AM111000111000 USD111000ID143930 五月 2012, 4:13 AM610