国外牛人用excel做的动态仪表盘优秀案例教材表格推荐下载.xlsx

国外牛人用excel做的动态仪表盘优秀案例教材表格推荐下载.xlsx

《国外牛人用excel做的动态仪表盘优秀案例教材表格推荐下载.xlsx》由会员分享，可在线阅读，更多相关《国外牛人用excel做的动态仪表盘优秀案例教材表格推荐下载.xlsx（69页珍藏版）》请在冰豆网上搜索。

Percaptiaincome,weatherorlivingconditionsYoumayignoretheMarginofErrordata（providedinextremerightinthedatatables）.Youmaysubmitmorethanoneentry.Forvoting&

selectingwinnersonly1entryfromeachindividualisconsidered.ImportantDatesConteststartdate9thofApril,2014Lastdateforsubmission20thofApril,2014Lastdayofsubmission,hurryup!

Howtosubmityourentry?

EmailSendto:

Subject:

Dataviscontest2014Include:

Yourworkbook,Yourname,EmailAddress&

VersionofExcelusedtomakeitFacebookJoinchandoo.orgfanpage（Clickhere）Sendyourentryasamessage（withworkbookasattachment）Include:

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