Time for another round of cool charting / info-graphic ideas around the web.
Most Popular Baby Names – all the way from 1880
Nametrends is a cool website totally dedicated to analyzing and showing baby name trends. They have pretty interesting stuff like, how baby names ending with -lie (charlie, willie, ellie etc.) fared from 1880. Go ahead, see the neat stuff at nametrends. [via kottke]
Flare toolkit for visualizing in Flash
Flare is a powerful tool for visualizing large amounts of data using Action Script. Check it out. [via FlowingData]
Funny map of online communities
This cartoonish visualization from XKCD pokes fun at the sizes and boundaries of various online communities. Really hilarious and neatly done. [via cool infographics]
This is a non-linear info graphic that talks about how designers approach problems. The site >think>draw>make is a dedicated to visualizations of design processes. See it. [via cool infographics]
What info is hidden in a bar code?
This pretty visualization of bar codes uses information contained in the black stripes to generate Bezier curves (ahem!) that look like a tree, hence the name bar-code plantation 🙂 [via swissmiss]
Also see:
- Excel Links around the web – [July 29]
- Excel Links Around the Web [July 22]
- Cool Infographics / Charts of the Week [July 24]
Have any visualizations, graphs or cool charting ideas and want them featured here? Drop a comment.
11 Responses to “Who is the most consistent seller? [BYOD]”
The Date column in the sample file is Text not Dates
[…] http://chandoo.org/wp/2015/02/18/calculating-consistency-in-excel/?utm_source=feedburner&utm_med… […]
Great Chandoo. Keep it up, Looking forward more from BYOD..
Thanks
With Excel 2013 the pivot table could be connected to the data model which provides a distinct count.
This will do for invoice count
=COUNTIF(F:F,H12)
Instead of
=COUNTIFS(sales[SELLER],$H12)
Excellent document. How did you make the last graphic? Witch app. Thanks for answer.
Can someone tell me what =countif(sales[date],sales[date]) is counting? The value is 19. Its found in the =SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))
Hi Chris,
=countif(sales [date],sales[date]) function is counting the unique dates in the table.
Vândalo
Excellent document!
Can you explain more about the calculation on Weighted consistency? More specific the small number is 0,00001 ?
How come the number should be smaller if there is more sellers?
Hi,
Not understood this formula: {=SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))}
Please explain.
Thanks.