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

国外牛人用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%56Outof310millionpeopleintheU.Sin2012,7roughly7million（or2.3%）,settledinanewstate8and38million（or12.2%）movedwithintheirstate9101112131415161718192021222324252627282930313233343536373839404142434445464748495051AlphabeticaldataStatesArrivalsDeparturesNetmigrationPop1yrandoverInternalmigrationAlabama104,600109,210（4,610）4,764,428590,326Alaska33,41584,068（50,653）721,18690,613Arizona232,457206,84225,6156,468,907953,789Arkansas76,94864,96711,9812,912,680373,046California493,641566,986（73,345）37,572,7385,046,618Colorado205,060161,53043,5305,123,944751,921Connecticut80,31187,023（6,712）3,555,319334,918Delaware34,75725,1499,608906,57686,003DistrictofColumbia53,83059,513（5,683）624,84761,992Florida537,148428,325108,82319,114,6202,380,288Georgia277,466252,26225,2049,796,5471,236,302Hawaii55,14561,509（6,364）1,374,852134,827Idaho59,28355,1914,0921,573,036210,151Illinois208,755277,953（69,198）12,725,1191,441,191Indiana134,137144,597（10,460）6,457,067805,228Iowa75,76073,3252,4353,035,469362,938Kansas88,28493,134（4,850）2,848,708381,695Kentucky112,787103,0049,7834,328,626521,511Louisiana91,21595,956（4,741）4,545,914528,406Maine27,52338,574（11,051）1,315,586151,438Maryland154,983157,664（2,681）5,816,472549,973Massachusetts142,577158,156（15,579）6,580,641626,380Michigan133,981175,733（41,752）9,778,9801,268,105Minnesota101,042115,946（14,904）5,315,228653,012Mississippi73,50066,9476,5532,947,696339,807Missouri162,930142,75420,1765,951,913801,093Montana37,69033,8323,858995,544126,463Nebraska43,26648,816（5,550）1,829,420237,937Nevada124,28598,88225,4032,725,280481,496NewHampshire50,48438,69611,7881,309,203125,118NewJersey130,223219,202（88,979）8,772,744655,465NewMexico54,69363,921（9,228）2,060,595226,243NewYork270,053405,864（135,811）19,352,1531,723,117NorthCarolina273,149238,66334,4869,640,4901,149,080NorthDakota38,21323,95914,254689,83884,294Ohio196,391199,202（2,811）11,414,6351,440,815Oklahoma108,972102,5726,4003,762,311531,347Oregon118,925108,18210,7433,857,465560,673Pennsylvania215,500237,156（21,656）12,630,0821,252,378RhodeIsland33,44630,4982,9481,040,527101,165SouthCarolina156,705127,41829,2874,668,886564,350SouthDakota26,05122,5343,517821,669115,606Tennessee177,098163,84313,2556,378,278783,077Texas507,752402,187105,56525,711,7913,656,070Utah87,87082,1655,7052,805,440373,980Vermont24,43120,0564,375620,22461,242Virginia250,653238,54012,1138,085,389915,242Washington215,494180,46235,0326,815,763904,695WestVirginia47,12547,425（300）1,837,518174,112Wisconsin99,19297,7241,4685,660,677693,737Wyoming31,14932,228（1,079）569,73477,324Gainsandlosses（absoluteandrelative）StatesrankedNetmig-rankedABSPop1yrandover%Florida108,823108,82319,114,6200.6%Texas105,565105,56525,711,7910.4%Colorado43,53043,5305,123,9440.8%Washington35,03235,0326,815,7630.5%NorthCarolina34,48634,4869,640,4900.4%SouthCarolina29,28729,2874,668,8860.6%Arizona25,61525,6156,468,9070.4%Nevada25,40325,4032,725,2800.9%Georgia25,20425,2049,796,5470.3%Missouri20,17620,1765,951,9130.3%NorthDakota14,25414,254689,8382.1%Tennessee13,25513,2556,378,2780.2%Virginia12,11312,1138,085,3890.1%Arkansas11,98111,9812,912,6800.4%NewHampshire11,78811,7881,309,2030.9%Oregon10,74310,7433,857,4650.3%Kentucky9,7839,7834,328,6260.2%Delaware9,6089,608906,5761.1%Mississippi6,5536,5532,947,6960.2%Oklahoma6,4006,4003,762,3110.2%Utah5,7055,7052,805,4400.2%Vermont4,3754,375620,2240.7%Idaho4,0924,0921,573,0360.3%Montana3,8583,858995,5440.4%SouthDakota3,5173,517821,6690.4%RhodeIsland2,9482,9481,040,5270.3%Iowa2,4352,4353,035,4690.1%Wisconsin1,4681,4685,660,6770.0%WestVirginia（300）3001,837,518（0.0%）Wyoming（1,079）1,079569,734（0.2%）Maryland（2,681）2,6815,816,472（0.0%）Ohio（2,811）2,81111,414,635（0.0%）Alabama（4,610）4,6104,764,428（0.1%）Louisiana（4,741）4,7414,545,914（0.1%）Kansas（4,850）4,8502,848,708（0.2%）Nebraska（5,550）5,5501,829,420（0.3%）DistrictofColumbia（5,683）5,683624,847（0.9%）Hawaii（6,364）6,3641,374,852（0.5%）Connecticut（6,712）6,7123,555,319（0.2%）NewMexico（9,228）9,2282,060,595（0.4%）Indiana（10,460）10,4606,457,067（0.2%）Maine（11,051）11,0511,315,586（0.8%）（300）（1,079）1,4682,435（2,681）（2,811）MostStablestatesNetMigrationWestVirginiaWyomingWisconsinIowaMarylandOhioMinnesota（14,904）14,9045,315,228（0.3%）Massachusetts（15,579）15,5796,580,641（0.2%）Pennsylvania（21,656）21,65612,630,082（0.2%）Michigan（41,752）41,7529,778,980（0.4%）Alaska（50,653）50,653721,186（7.0%）Illinois（69,198）69,19812,725,119（0.5%）California（73,345）73,34537,572,738（0.2%）NewJersey（88,979）88,9798,772,744（1.0%）NewYork（135,811）135,81119,352,153（0.7%）AbsoutegainsandlossesRelativegainandlossesRelativegainsandlossesMostactiveNorthDakota2.1%Florida108,823Delaware1.1%NorthDakotaTexas105,565Nevada0.9%DelawareNewHampshire0.9%NewJersey（88,979）Colorado0.8%NewJerseyNewYork（135,811）Vermont0.7%AlaskaSouthCarolina0.6%Florida0.6%MoststablesWashington0.5%WestVirginia（300）SouthDakota0.4%Wyoming（1,079）Arkansas0.4%Wisconsin1,468Texas0.4%Iowa2,435Arizona0.4%Maryland（2,681）Montana0.4%Ohio（2,811）NorthCarolina0.4%Miss