background preloader

Peltier Tech Blog

Peltier Tech Blog
Constable Henry: Just a moment, sir. I know everyone in this neighborhood, but I’ve never seen your face before. Can you account for yourself? Freddy: Yes, I am Dr. by The FrankensTeam This guest post is from the E90E50 FrankensTeam, i.e., Roberto Mensa, Kris Szabó, and Gábor Madács. While I was reading Jon’s work using VBA Approaches to Plotting Gaps in Excel Charts I started to think, because I felt there had to be another solution which was waiting to be discovered… Jon provided two different VBA routines as a solution for the problem: one changes the chart series formatting, the other changes the underlying data. Some time ago I realized that it is possible to use union of ranges in chart series. Now, a few months later, thinking about the gap problem… Eureka! The union of separate ranges could be a solution, especially if we can build it up using the UDF within a named formula! Let us explain how it could work. The series formula of the chart looks like: =SERIES("ref to rng",,line_chart! Related:  Data visualisation tools

Data Visualization Review: Gephi, Free Graph Exploration Software I do not often get to play with networks, yet I find them fascinating and full of knowledge gathering potential. The data visualization works of Moritz Stefaner, Jer Thorp, and Mark Lombardi captivate me. I am intrigued by relationships, how we perceive them, and how we can understand them. Gephi, the "Open Graph Viz Platform", is not just for the hobbiest node nerd. So what is Gephi capable off? Gephi interface displaying airline traffic data. Pros — Options! Cons — Interface is a bit cluttered. Main interface displaying the Diseasome data. Review Overall, Gephi is a useful and interesting tool. There are some plugins available for Gephi that extend the functionality. The only thing keeping Gephi from being a professional grade tool is its bugginess and lack of documentation. Graph of Minard's data using Gephi and the GeoLayout plugin. For the Purists Gephi is a purist's delight. Two nerdy charts of network statistics that Gephi will output.

bayapartmentbroker | Just another real estate investing blog Contextures Excel Blog SWF Charts > Introduction XML/SWF Charts is a simple, yet powerful tool to create attractive charts and graphs from XML data. Create an XML source to describe a chart, then pass it to this tool's flash file to generate the chart. The XML source can be prepared manually, or generated dynamically using any scripting language (PHP, ASP, CFML, Perl, etc.) XML/SWF Charts makes the best of both the XML and SWF worlds. Features: Quick generation of charts and graphs from static or dynamic data (any scripting language) Full updates and data streaming without reloading the web page. Testimonials I just wanted to pass along how well your script worked for our stock performance page. Good work! This is amazing software. Just want to thank you for this wonderful upgrade. I purchased your product a couple days ago and first had time to sit down and work with it this morning. Wow, you are the best! Thanks for your great script. I am very excited to have found your product on "hotcripts". You are freaking amazing. THIS ROCKS!

Moneychimp: learn Stock Investing, Index Funds, Valuation Models, and more. Excel VBA Macros for Absolute Beginners - 15 Examples File download - ANALYSISTABS - Innovating Awesome Tools for Data Analysis! Excel VBA Macros for Absolute Beginners – These 15 macros provides the easiest way to understand and learn the basics of VBA to deal with Excel Objects. Learning Basic Excel VBA By Examples is the easiest way to understand the basics of VBA to deal with Excel Objects, in this tutorial we will not covering any programming concepts, we will see how to access the different Excel Object using VBA. Excel VBA Macros for Absolute Beginners – Download file with 15 Examples: Example 1: How To Access The Excel Range And Show The Value Using Message Box While automating most of the Excel Tasks, we need to read the data from Excel spread sheet range and perform some calculations. Example 2: How To Enter Data into a Cell After performing some calculations using VBA, we generally write the results into worksheet ranges. Example 3: How To Change The Background Color Of A Particular Range The following example will help you in formatting a cell or range by changing the background color of a range.

Student Performance Dashboard Dashboard Description: Top section gives comparative analysis of Class teachers Maths class (based on latest math assessment score) with the her other classes, overall school performance and district. Looking at the data her current class performance is below Average compared to her other classes. Class Summary: All Students are categorised in different colors based on their latest math assessment score. Similar to performance, I have categories behavioural data in different shades of blue. Top Right section gives comparative analysis of detailed student performance with other classes, school and district level students. Right bottom gives overall details of students which requires special disciplinary and performance attention.

The 99 Best Business Books - The Personal MBA - The Personal MBA: Master the Art of Business “You wasted $150,000 on an education you coulda got for a buck fifty in late charges at the public library.” Will Hunting (played by Matt Damon), Good Will Hunting MBA programs don’t have a monopoly on advanced business knowledge: you can teach yourself everything you need to know to succeed in life and at work. The Personal MBA features the very best business books available, based on over ten years and thousands of hours of research. This page lists all Personal MBA recommended books and resources for easy printing, bookmarking, and reference. Here are the 99 business books The Personal MBA officially recommends… click on the title of each book to read a detailed description of each book and why it’s important, or the buttons to the right for additional reviews. Books purchased through this website support The Personal MBA’s ongoing research. Read This First For Best Results... Buy the Book: WANT TO BE NOTIFIED WHEN UPDATES ARE PUBLISHED? Business Creation Value-Creation & Testing Marketing

Hive Plots - Linear Layout for Network Visualization - Visually Interpreting Network Structure and Content Made Possible