We are happy to announce a new CMDB integration with i-doit from Synetics. Synectics offers a free open source and a commercial edition. Together with i-doit, we have created a tailored JDisc Discovery version called “JEDI” (JDisc Essential Discovery for i-doit). Current information discovered by JDisc can be easily imported into i-doit. The data import [...]
Zum Blog JDisc
At JDisc, we do not like long update cycles. Customers need new features and bugfixes as soon as possible and not once or twice a year. That’s why we frequently release builds with new features and some bugfixes. Build 2923 concentrates on improvements for the networking add-on and on some bugfixes for very large environments. [...]
Zum Blog JDisc
I cannot stress often enough that the best source for new ideas are our customers and prospects. Recently, a prospect asked whether we could read the signal strengths that WLAN access points are sending with. Our standard answer to questions like “Can you collect information x from device y” is: Yes, if the device exposes [...]
Zum Blog JDisc
We are glad that we could win Protogen, an Australian firm that offers services and innovative IT solutions to their clients, as value added reseller for our products. Protogen offers solutions in the area of business intelligence, collaboration systems, information architecture, CRM software solutions, and much more. With JDisc Discovery, Protogen offers a product in [...]
Zum Blog JDisc
JDisc keeps on moving forward with its network inventory and documentation software JDisc Discovery and releases build 2921 after a two month development cycle. Our development delivered a bunch of new features, improvements, and some bug fixes. The changes affecct integrating common network troubleshooting tools, improvements within the network topology algorithm, support for new devices [...]
Zum Blog JDisc
JDisc Discovery has greatly improved its layer 2 topology detection by using the port forwarding database. A switch maintains a table of mac addresses that are connected to each port. When looking at all switches, we can detect the switch topology. However, in some situations, the mac forwarding information is not complete. Switches drop mac [...]
Zum Blog JDisc
VLANs are a common technology to provide a segmentation for local area networks. Creating different segments contributes to address issues such as security or scalability. Network traffic can be separated by VLANs even if devices are connected to the same switch. The switch also assures that broadcast in one VLAN dooes not get forwarded to [...]
Zum Blog JDisc
JDisc has released a new version of its network inventory and documentation product JDisc Discovery. We have improved our products in three different areas. A new reporting mode enables IT consulting and service providers to leave a read-only version with the discovered data at the customer at no cost. JDisc extends its device detection with [...]
Zum Blog JDisc
No one likes to wait for new features or bugfixes. Therefore, JDisc frequently releases minor updates every four to six weeks. This time, the new build includes some bugfixes within the network topology resultion, some enhancements, that help when dealing with license management projects and the detection of locally attached printers, scanners and card readers. [...]
Zum Blog JDisc
JDisc Discovery is pretty interesting for IT consulting and service providers. It’s cost effective and flexible project license is the key for our consulting partners. Currently, we are working on making our offer even more appealing. So far, JDisc did a great job of discovering a customers network. It gathers all plenty of hardware- and [...]
Zum Blog JDisc
How to find sum of top 3 values based on filtered criteria [video]
Zum Original Blog Chandoo.org
Today, lets tackle an interesting problem.
Lets say you are looking at some data as shown aside and wondering what is the sum of budgets for top 3 projects in East region with Low priority. How would you do that with formulas?
This article is inspired from a question asked by acpt22 in our forums.
Sum of top 3 values based on filtered criteria [video]
Watch below video to understand how to find sum of top 3 values using formulas & pivot tables.
Watch this video on our YouTube channel.
Download Example Workbook
Click here to download example file and play with it. …
Zum Original Blog
Autor: Chandoo
How to transpose a values in a row to column using formulas… [Quick tip]
Zum Original Blog Chandoo.org
This is interesting, I am in Columbus to meet one of my college friends. I remember him as a very meticulous person from college days. So it is no surprise when he showed me his massively impressive finance tracker last night. He has been tracking expenses, income, credit card payments and gas (petrol) consumption since 2008. Very impressive indeed.
Then out of blue he said, he has a problem with his spreadsheet. In this own words,
When entering data for credit cards, I use one column per card. But in my report view, I want to show credit card details in …
Zum Original Blog
Autor: Chandoo
I am meeting Mr. Excel aka Bill Jelen tomorrow. What do you want to ask him? (book giveaway too)
Zum Original Blog Chandoo.org
One of the beautiful things about working on internet is you know so much about people even before you meet them first time. I think I first heard about Mr. Excel in 2006, when I started my career as business analyst. I landed on mrexcel.com while searching for something related to doing cluster analysis using Excel. In a way, mrexcel.com inspired me to share my thoughts and techniques on Chandoo.org.
So it wont be an understatement when I say, I feel like a kid in candy store knowing that Bill Jelen aka Mr. Excel is just a few …
Zum Original Blog
Autor: Chandoo
Excel Links – from USA edition
Zum Original Blog Chandoo.org
Hello there,
My travel to US was fantastic and fun. Many thanks to Jocelyn & Rob Collie, who found a nice apartment for us and made sure we are settled down in almost no time. Weather has been excellent so far too with lots of sunshine and blue skies. We went to a nearby park the other day and kids really loved walking on trials and exploring.
Gentle reminder
Today is last day to sign-up for my USA Masterclass
Today is last day to join my USA Advanced Excel & Dashboards masterclass with early bird discount. If you live …
Zum Original Blog
Autor: Chandoo
How to create a column chart with background image in Excel ?
Zum Original Blog Chandoo.org
Tony sends this chart and asks if it can be done in Excel.
It sounded like a good challenge for a lazy Sunday morning. So here we go. (Posting it on Monday).
Now I could not get an oil rig photo or that data. So I made up few numbers and used a photo of Flinders street station I took when I was in Melbourne last year.
Step 1: Arrange the data.
Arrange the data like this.
Step 2: Create a column chart
Select the data, insert a stacked column chart (why not a regular column chart?, you will understand in a …
Zum Original Blog
Autor: Chandoo
Thank you, we are flying to US tonight
Zum Original Blog Chandoo.org
This is a personal note, not an Excel tip. So grab a cup of coffee, relax and read on.
As I pack our bags and run the last checks, one thought keeps crossing my mind. ‘How impossible all this sounded just a few years ago’.
When I quit my well paying corporate job in April, 2010 to embark on this exciting journey of making you awesome in Excel, I never thought I would one day take my family and visit USA. I had bigger worries. I just became a dad to twins. Both Jo & I quit our jobs. …
Zum Original Blog
Autor: Chandoo
10 Rookie mistakes to avoid when making dashboards [video]
Zum Original Blog Chandoo.org
Are you making these 10 rookie mistakes when creating dashboards?
Watch below to video to understand what these mistakes and how to avoid them.
10 Rookie mistakes to avoid when making dashboards [23 mins]
More resources on Excel dashboards
Excel dashboards – Information, examples & tutorialsCreating a KPI dashboard using Excel – 6 part tutorialSales dashboards – 32 examples & downloads
Do you make any of these mistakes?
When I made my first dashboard in Excel (a balance scorecard for our department), I made almost all of these mistakes. Today, I am more careful. But I still forget to do print settings or make small …
Zum Original Blog
Autor: Chandoo
How to create an Interactive Chart in Excel? [Tutorial]
Zum Original Blog Chandoo.org
Imagine you have a worksheet with lots of charts. And you want to make it look awesome & clean.
Solution?
Simple, create an interactive chart so that your users can pick one of many charts and see them.
Today let us understand how to create an interactive chart using Excel.
PS: This is a revised version of almost 5 year old article – Select & show one chart from many.
A demo of our interactive Excel chart
First, take a look at the chart that you will be creating.
Feeling excited? read on to learn how to create this.
Solution – …
Zum Original Blog
Autor: Chandoo
Chart for wall hygrometric physic (or how to create a chart with custom x axis intervals?)
Zum Original Blog Chandoo.org
Livio, one of our readers from Italy sent me this interesting problem in email.
I would like to prepare an xy linear graphic as representation of the variation of temperature trough a wall between two different bulk temperature i.e. outside and inside a house. This graphic should show the temperature gradient trough the wall thickness. The wall is normally made by different construction materials (different layers, as bricks, insulation, …..) and so the temperature change but not as a straight line with only one slope, instead as few lines with different slopes (see below figure) Calculations are not difficult, …
Zum Original Blog
Autor: Chandoo
Learn Top 10 Excel Features
Zum Original Blog Chandoo.org
Last week, we had a lovely poll on what are your favorite features of Excel? More than 120 people responded to it with various answers. So I did what any data analyst worth his salt would do,
I downloaded all the 120+ comments data
I home brewed a large cup of coffee and started gulping it.
I started analyzing the comments
So here are the top 10 features in Excel according to you.
1. Excel Formulas
63 people (50%) said Formulas are their favorite feature in Excel. Of course, you can say, Formulas & Functions are Excel!!! . They are what Excel is made of. But then …
Zum Original Blog
Autor: Chandoo
Some charts try to make you an April fool all the time (or why 3d pie charts are evil)
Zum Original Blog Chandoo.org
Recently I saw a big screaming ad that said “the chartbuster rules”. Of course, I know that chartbusters rule. Not just because I was one of them
So I got curious and read on. And I realized the ‘chartbuster’ is actually a car, not some cool, spreadsheet waving, goatee sporting dude like Jon Peltier. What a bummer!
And then to my horror of horrors, I saw the exploding 3d pie chart, with reflection effects & glossy colors. And the sole purpose of the chart is to create an impression that Verna sells better than any car …
Zum Original Blog
Autor: Chandoo
How to create interactive calendar to highlight events & appointments [Tutorial]
Zum Original Blog Chandoo.org
One of the popular uses of Excel is to maintain a list of events, appointments or other calendar related stuff. While Excel shines easily when you want to log this data, it has no quick way to visualize this information. But we can use little creativity, conditional formatting, few formulas & 3 lines of VBA code to create a slick, interactive calendar in Excel. Today, lets understand how to do this.
But first, a reminder to join my Advanced Excel masterclass in USA
As you may know, I am running my first ever Advanced Excel & Dashboards Masterclass in USA this …
Zum Original Blog
Autor: Chandoo
What is your favorite feature of Excel? [poll]
Zum Original Blog Chandoo.org
Its Friday, time for another poll.
This weeks topic is inspired from a discussion Jordan started in our forums (#).
What is your favorite feature of Excel?
I will go first.
My favorite features are,
Conditional formatting: Quickly highlight something that is not alright (or meets conditions), see trends with data bars or heat maps.
Pivot tables: Turn data in to understandable information with just a few clicks. When combined with slicers & conditional formats, becomes very powerful.
Formulas: Ofcourse, with out formulas, Excel would be a glorified notepad!
What about you? What are your favorite features in Excel? Go ahead …
Zum Original Blog
Autor: Chandoo
How well do you know your LOOKUPs? – Quiz Answers & Discussion
Zum Original Blog Chandoo.org
Last week, we had our very first quiz – “How well do you know your LOOKUPs?“. I hope you have enjoyed it.
Today lets understand the answers & explanations for this quiz.
First a summary of results (and controversies):
More than 3,200 people attempted the quiz. Roughly 45% of you got correct answers. That said there were 4 questions where 90% of you made mistakes. This is mainly because these questions & answer choices were ambiguous. As this is the first time I ran a quiz on Chandoo.org, it was a learning experience for me too. I promise to keep …
Zum Original Blog
Autor: Chandoo
10 things that wowed me in Excel 2013
Zum Original Blog Chandoo.org
As you may new, the newest version of Excel is out for a while. I have been using it since last 6 months and enjoying it. Today, lets understand 10 things in 2013 that wowed me (and probably you too).
Flash Fill
Imagine Flash (the super hero, not browser add-in) is using Excel to extract the middle names of all his villains. Now, flash being flash, do you think he will slowly type out the middle names one at a time? Of course, he can learn Excel formulas and do it in one stroke. But he is too busy running around & …
Zum Original Blog
Autor: Chandoo
