国外牛人用excel做的动态仪表盘优秀案例教材.xlsx
- 文档编号:235635
- 上传时间:2022-10-07
- 格式:XLSX
- 页数:69
- 大小:466.07KB
国外牛人用excel做的动态仪表盘优秀案例教材.xlsx
《国外牛人用excel做的动态仪表盘优秀案例教材.xlsx》由会员分享,可在线阅读,更多相关《国外牛人用excel做的动态仪表盘优秀案例教材.xlsx(69页珍藏版)》请在冰豆网上搜索。
ExcelDatavisContest-Chandoo.org-2014ContestRulesMakeadashboardorsetofcharts.HelpusunderstandstatetostatemigrationtrendsandinterestingfactsUseanystandardExcelfeature(noadd-ins,noPowerPivotetc.)YoucanuseMacros&VBAtoaddinteractiontocharts.(Codemustbecommentedclearlyandsourcesshouldbecredited)Youcanaddadditionaldemographicoreconomicdataaslongas,YouusepubliclyavailabledatasourcesYouprovidelinkstothedatasourcesandcreditthemExamples:
Percaptiaincome,weatherorlivingconditionsYoumayignoretheMarginofErrordata(providedinextremerightinthedatatables).Youmaysubmitmorethanoneentry.Forvoting&selectingwinnersonly1entryfromeachindividualisconsidered.ImportantDatesConteststartdate9thofApril,2014Lastdateforsubmission20thofApril,2014Lastdayofsubmission,hurryup!
Howtosubmityourentry?
EmailSendto:
Subject:
Dataviscontest2014Include:
Yourworkbook,Yourname,EmailAddress&VersionofExcelusedtomakeitFacebookJoinchandoo.orgfanpage(Clickhere)Sendyourentryasamessage(withworkbookasattachment)Include:
Yourworkbook,Yourname,EmailAddress&VersionofExcelusedtomakeitWhatdoyouget?
FirstprizeiPad(Latestversion)16GBSecondprizeiPadMini(latestversion)16GBThirdprize(2nos)SamsungGalaxyTab3HowwinnersareselectedWinnerswillbeselectedbyvotingandapanelofjudges(toberevealed).Ifthereisatie,Judgesdecisionwillbegivenmoreweightage.FinePrintPrizeswillbedeliveredthruA.IfyouarelocatedinacountrywhereshippingAmazongoodsisnotpossible(orprohibitivelyexpensive)youwillbeofferedachoiceofeithergettingmoneypaymentorpurchasefromalocalwebsite.YoualsoagreethatChandoo.orgreservestherighttoshowcaseyourfiles,sharethem,usethemincourses&trainingprogramsoranyotherpublicationasdeemedfit.Youagreetosharethecopy-rightofyourworkbookwithChandoo.orgindefinetlyfornocompensation.Chandoo.orgmaygetintouchwithyouifweneedanyclarificationsorweareunabletouseyourfile.Chandoo.orgreservestherighttodisqualifyacontestentrybasedonsolediscretion.Forupdatesonrules,dates&policies,pleaseclickbelowlink:
http:
/chandoo.org/wp/2014/04/09/visualize-state-migration-contest/VisitContestWebsiteVisitChandoo.orgYoucanuseMacros&VBAtoaddinteractiontocharts.(Codemustbecommentedclearlyandsourcesshouldbecredited)Youmaysubmitmorethanoneentry.Forvoting&selectingwinnersonly1entryfromeachindividualisconsidered.Lastdayofsubmission,hurryup!
Winnerswillbeselectedbyvotingandapanelofjudges(toberevealed).Ifthereisatie,Judgesdecisionwillbegivenmoreweightage.PrizeswillbedeliveredthruA.IfyouarelocatedinacountrywhereshippingAmazongoodsisnotpossible(orprohibitivelyexpensive)youwillbeofferedachoiceofeithergettingmoneypaymentorpurchasefromalocalwebsite.YoualsoagreethatChandoo.orgreservestherighttoshowcaseyourfiles,sharethem,usethemincourses&trainingprogramsoranyotherpublicationasdeemedfit.Youagreetosharethecopy-rightofyourworkbookwithChandoo.orgindefinetlyfornocompensation.Chandoo.orgmaygetintouchwithyouifweneedanyclarificationsorweareunabletouseyourfile.Chandoo.orgreservestherighttodisqualifyacontestentrybasedonsolediscretion.DatavisualizationoftheinternalmigrationintheU.S.from2010to2012Preparedby:
JorgeSupelanoExcelVersion:
2013Selectayear2012.andseethegeneraltrendsSelectaStateAlabama.andseethetrendfor2012inthatstatePopulationdecreased0.1%Top5statesrepresent51.9%ofallthearrivalsTop5statesrepresent54.7%ofallthedeparturesNote:
DuetoMarginofErrors(whichwereignored),somenumbersmaynotaddupTotalMovementsMostandleastactivestatesArrivalsDepartures108,823105,565(88,979)(135,811)NetMigrationMostactivestatesFloridaTexasNewJerseyNewYork19.0%10.7%10.1%7.1%4.9%Peoplearrivedfrom.Top5statesGeorgiaFloridaTennesseeTexasNorthCarolina25,00020,00015,00010,0005,000017.0%12.7%11.1%9.2%4.7%Peopledepartedto.Top5statesFloridaGeorgiaTennesseeTexasMississippi20,00015,00010,0005,0000Outof310millionpeopleintheU.Sin2012,roughly7million(or2.3%),settledinanewstateand38million(or12.2%)movedwithintheirstate481,496953,7891,723,117655,46514.7%8.9%7.5%MovementswithinastateMostandleastactivestatesNevadaArizonaNewYorkNewJersey%oftotalstatepopulation2.1%1.1%(1.0%)(7.0%)Wheretheimpactisbigger%ofstatepopulationgainedandlostNorthDakotaDelawareNewJerseyAlaskaInternalmigration590,32613%Settlersfromotherstates2%Sameresidence1yearago104,600109,210Loss4,610Gain0ArrivalsandDeparturesArrivedDepartedGeneraltrends2012CounterTotalpop310,212,7551Sameresidence1yearago263,612,59685.5%2Differentresidence,samestate1yearago37,696,59712.2%3Intrastatemigration7,070,3452.3%4308,379,538100.0%56Outo
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 国外 牛人用 excel 动态 仪表盘 优秀 案例 教材
![提示](https://static.bdocx.com/images/bang_tan.gif)