Power Utility Pak For Excel Free Download
It’s Cyber Monday, and we’re all supposed to spend the day shopping online, so I’m having a sale on my Pivot Table add-in –.You can get it today for 30% off, and the sale ends at midnight (Eastern time) tonight, Dec. You don’t need to enter a discount code – the priced will be reduced automatically when you add it to the shopping cart. See the Key FeaturesYou can see three of the time-saving features in this short video. save and apply your favourite pivot table settings. clear old items from a pivot table.
change all the data fields to the Sum function.Time-Saving FeaturesThe add-in is easy to install, and it creates a new tab on the Excel Ribbon. You can see some of the other tools in the screen shots below. For example:.
Click to set Currency or Number format. Print a list of pivot tables or cache information.
Turn Autofit on or offGet the DiscountTo see all the details, and buy the add-in at 30% off, please visit this page on my Contextures website: –.The sale lasts until midnight December 2nd, 2013, Eastern Standard time. No discount code is required – the price will be automatically reduced in the shopping cart. Author Posted on Categories. It’s Black Friday in the USA – the busiest shopping day of the year.
This event has spread to Canada too, so I’m having a sale on my latest Excel add-in –. You can get it today for 50% off, with the discount code CTXBF13. The sale ends at midnight (Eastern time) tonight. See the Key FeaturesYou can see three of the time-saving features in this short video.
Click to make a backup of the active workbook. Protect or unprotect all sheets, with or without a password.
Create a menu sheet, with a hyperlink to each worksheet in the fileTime-Saving FeaturesThe add-in creates a new tab on the Excel Ribbon, and you can see some of the other tools in the screen shots below. For example:. Create a Concatenate formula that combines all the selected cell values. Sort the sheets in alphabetical order. Fill blank cells with the values from aboveGet the DiscountTo see all the details, and buy the add-in at 50% off, please visit this page on my Contextures website:.Use the discount code: CTXBF13The code is good until midnight tonight, Eastern Standard time – November 29, 2013. Author Posted on Categories. I'm working on some pricing reports for a client, and one of the requests was for a Pocket Price Waterfall chart.
I hadn't made one of those before, and fortunately the client sent me a sketch of the chart that they wanted. It looked something like this.The good news was that it looked similar to other that I've made. However, instead of two highlighted columns, to show start and finish, it had several highlighted columns. The Pocket PriceThe term 'pocket price' was new to me, and some Googling led me to an article published by McKinsey & Company in 2003 – The Power of Pricing.
They coined the term 'Pocket Price' to describe the amount that you actually get from a customer, after the hidden costs and off-invoice discounts that might exist. The article shows a waterfall chart, similar to the one that my client wanted. Maybe that's where they got the idea!
Add the Extra ColumnsTo experiment with adding more highlighted columns, I started with the cash flow from a previous blog post, and added rows for the Quarterly totals. In the previous version, there was only one number in the End column, and I needed a number in each Quarter row, where I wanted a highlighted column.I created a new formula in the End column, cells C4:C14, to check the Net Cash Flow column (G). If that cell is empty, show the sum of the previous amounts.=IF(LEN(G4)=0,SUM(B3,E3:F3)-D4,')The Base column is the reverse, showing the sum if the cell in column G is NOT empty.=IF(LEN(G4)=0,',SUM(B3:C3,E3:F3)-D4)The Revised Waterfall ChartHere is the revised waterfall chart, with a highlighted column for each quarterly total, ending in September.Then, I used the same formulas with some faked Pocket Price data, to create the Pocket Price waterfall chart. There aren't any green columns, because all of the values are negative amounts, bringing down the price.And now I'm ready to create the real Pocket Price waterfall chart, whenever we get to that stage in the project. Download the Sample FileTo see the waterfall charts and the worksheet formulas, you can download the. The file is in Excel 2007 format, and zipped.
There are no macros in the file. Waterfall Chart Utility and VideoIf you need to make waterfall charts, take a look at Jon Peltier's time-saving. While working on this chart, I discovered that Jon's add-in has this multi-highlighted column feature built in.
It also handles data that crosses the X Axis, with totals in the negative amounts.To see how I used Jon's add-in to quickly create a sample Pocket Price waterfall chart, please watch this Excel video tutorial. Tomorrow, Tuesday June 7th, John Walkenbach is having another deep discount sale on his Excel add-in – (PUP).Remember, Father's Day is this month, so this could be the perfect gift for the dad who has everything. Or give your kids the link, and let them buy it for you! 24 Hours OnlyThe sale price is in effect for only 24 hours, starting at 12 noon, Eastern Time, so act quickly if you're interested. Even at its full price of $40, the PUP is a great investment, but during the sale it's over 80% off – only $7.77! The older version, for Excel 2003 and earlier, is $6.66.While you're shopping, you can also buy the password to the PUP's VBA source code, for only $20.
That's its regular price, but definitely worth buying. It's a rare opportunity to see under the hood of a professional Excel add-in, and could save you many hours of programming, if you're trying to do something similar. PUP FeaturesFor your small investment of $7.77, you'll get these features in the Power Utility Pack:. more than 70 general purpose Excel utilities. 53 worksheet functions. 6 non-serious amusements, for when you need a break from number-crunching.You can read about all the, but don't spend too much time reading – remember, the sale is only 24 hours! Author Posted on Categories.
Tomorrow, May 3rd, John Walkenbach is having a 2-hour sale on his Excel add-in –. Even at the full price of $40, it's a worthwhile investment, but during the sale it's over 80% off – only $7.77! The older version, for Excel 2003 and earlier, is $6.66.You can also buy the password to the VBA source code, for only $20.
Kutools For Mac Excel 2016
That's a bargain too, because it saves you countless hours of writing that code yourself, of wasting time looking for sample code online. PUP FeaturesFor your small investment of $7.77, you'll get these features in the Power Utility Pack:. more than 70 general purpose Excel utilities. 53 worksheet functions. 6 non-serious amusements, for when you need a break from number-crunching.You can read about all the, but don't spend too much time reading – remember, the sale is only 2 hours! Author Posted on Categories.
We have a very famous waterfall here in Canada, and it creates gorgeous photos, like this one from my fall 2008 vacation.You can create waterfalls in Excel too - Waterfall Charts. They might not be as spectacular as Niagara Falls, but can be useful for showing how values change. There are details here for creating a simple waterfall chart, and a video that shows the steps. Net Cash FlowFor example, in a small business, the net cash flow might be a positive number one month, and a negative number the next.
In the Waterfall Chart shown below, the red columns represent a negative number, that brings the cumulative cash total down. Earlier this month, I had the pleasure of flying out of Chicago's O'Hare airport. I was checking in at the ungodly hour of 6 AM on a Sunday, and hoped that would be a quiet time at the airport.
The streets near the downtown hotel were almost empty, so that was encouraging, but the closer the taxi got to the airport, the busier things got. Not a good sign!There was no line at the Air Canada counter (woohoo!), but there was no counter agent either. He showed up a couple of minutes later, and that part of the process went quickly.
(The same guy showed up at the gate later, to take our tickets, and attached the jetway to the airplane when it arrived. I figured he'd fly the plane too, but he didn't!)Then, it was on to the dreaded security checkpoint, and the inevitable long wait.One poor gentleman actually passed out in the line, and fortunately recovered quickly, aided by a paramedic, who was also in line. That's another bad sign, if you have to step over people, to get through security.And what does all this suffering have to do with Excel, you ask? Well, to help you plan your next trip, I found a website that lists the wait times for. From their data, I created an (Box and Whisker Chart), for a few of the security checkpoints at O'Hare.
You can do something similar for your airport, and choose the best time to fly. Hint: It is not Sunday at 6 AM. Program s2 unissula semarang.
Create Statistics from Your DataTo create a box plot, you'll calculate the the MIN, MEDIAN and MAX for each series. Then, use the PERCENTILE function, to find the lower quartile (Q1) and upper quartile (Q3). You can calculate the AVERAGE too, if you'd like to show that on the chart.Based on those numbers, you'll calculate the differences, to find the size of each box and whisker.Then create and format a stacked column chart (boxes), with error bars to show the highs and lows (whiskers).Unfortunately, I don't remember which checkpoint I went through, but I'll bet that it was Checkpoint 6. Jon Peltier's Box Plot UtilityIf you need to make box and whisker charts, or other custom chart types, the will make it much easier and quicker for you to create them. It adds a new sheet in your workbook, calculates the statistics for your data, then creates and formats a box and whisker chart.
It will pay for itself very quickly, in the time you'll save. Watch the Box Plot VideoTo see the steps for creating an Excel Box and Whisker chart, watch this Excel video tutorial.
It's recorded in HD, so select that option when viewing it, if you can, for a clearer picture. 15, 2015 - Adapx, Inc.
Has ceased operations I loved the idea of a pen that could magically send my data to Excel, but it didn't work out as well as I'd hoped. 😉 Anyway, here's my review of Capturx Forms for Excel, made by Adapx, Inc.For the past couple of years, I've worked with a client that has factories around the world.
As part of their safety program, employees fill in printed checklists, then send them to the Safety Officer, who enters the data in Excel. As you can imagine, this takes time, and is prone to data entry errors. An Enticing OfferRecently, I was asked if I'd like to test a digital pen and Capturx Forms for Excel.
With it, I could create and print blank forms in Excel, then use the pen to fill them in. Later, that data could be imported into Excel, with one click of a button.That sounded good, so I accepted the offer, and the pen and software arrived a few days later. If the product worked well, my client could test it in their plants, and possibly save some time and headaches.Well, it took a while, but I'm finally done testing. I loved some of the features, but there were frustrations and disappointments along the way. Stalling on the InstallationInstallation was the first obstacle to overcome. Several components had to be installed before the Capturx program, and it took several tries before everything finally worked. I won't bore you with all the details, but I seriously considered putting everything back into the box and returning it.I'm not sure if there was a problem with my hardware, or conflicting software, or something else.
The documentation didn't provide any tips for installation problems, nor did the company website. There's product information online, but no search feature that I could find. It's Not You, It's Your PrinterThrilled at finally getting the program to work, I created a simple form, and was ready to test the digital pen. You need to print the forms on one of the compatible printers.
I have a black and white laser printer, not one of the colour postscript laser printer on the list.When I told the company rep about the problem, she sent some sample forms by courier. I was able to keep testing, without buying a new printer. Here's one of the sample forms that I used for the test.Also, while reading the printer information, I noticed that the dot pattern that's printed on the forms 'gets used up as you print.' When the dot pattern is gone, you need to purchase more from the Adapx website. So, if you use this solution, you'll have some ongoing costs. The Good NewsOnce I was up and running, my mood definitely improved. I filled in a couple of forms with the digital pen, then docked the pen in its base.
In Excel 2007, a Capturx tab appeared on the Ribbon, and with a single click, I imported the forms' data.I could compare the imported data to the original writing, and easily make changes where necessary.From the Master Template sheet, I could create a summary of all the imported forms.The summary cells are linked to the original sheets, so they'll update if you change the forms' data. However, new sheets aren't added automatically.
You have to delete the summary sheet, and create a new one. A Few More ProblemsI hit a few more snags while working with the Capturx Forms for Excel add-in. For example, it was painfully slow to move through the workbook. When I clicked on a different sheet tab, it took several seconds for the sheet to activate.Excel has crashed a few times while using it, especially when trying the Sort Worksheets feature. When I deleted the Summary sheet, the sort feature worked, but it took more than 10 minutes to complete.The sample workbook has 95 completed forms in it, which seems like a reasonable number. In a real life situation, you'd probably have many more forms than that. Maybe the features work well in a smaller workbook, but that somewhat defeats the purpose of digital input.
The Final Word on Capturx Forms for ExcelI had high hopes for the digital pen and Capturx Forms for Excel, and some of those dreams came true. The pen worked like a charm, and even with my bad handwriting, there was a good recognition rate for the imported data.For me, the main drawback is the slow performance. If you're collecting lots of data, how could you manage it with this software?
Maybe you could use Excel to import the data, then export it to Access, or another database.Also, the Help could be better, with a search function on the website. For example, I couldn't figure out how to create a Summary sheet, and nothing in the notes or built-in help provided any clues. After several experiments, I finally got it working. The company is currently offering online training sessions, so that might help with some of the confusing features.There's potential for a great product, but Capturx Forms for Excel needs some improvement before I can recommend it to my clients.
The MovieIf you'd like to see the digital pen and Capturx Forms for Excel in action (I cut out the inaction bits), you can watch this short video. John Walkenbach is having a 2 hour – over 80% OFF the regular price. You can get all your Christmas shopping done early, if you act fast! I'm sure that all your family and friends would love an awesome Excel utility.The PUP sale is Tuesday, November 3, from 11:00 am to 1:00 pm U.S.
Eastern Daylight Time (that's 4:00 pm – 6:00 pm GMT).Go to his to buy either version:.: $7.77 (normally $40.00).: $6.66 (normally $39.95). The complete VBA source code is available for an additional $20.00If you'd like to see the PUP utility before you buy it, you can.
PUP FeaturesJohn sent me a complimentary copy of PUP v7 last year, and I. I still highly recommend it, so if you've ever thought about buying it, this is your opportunity.Even if you use just a few of its many features, you'll get more than your money's worth. Where else can you get a Table of Contents creator, Change Case tool, Dice Game and tons of other features, for under $8? How Do You Price Software?If you create an Excel utility and offer it for sale, how do you decide what to charge? Do you check out the competition and price your utility in the same range? Do you crunch a pile of numbers in Excel, and base your price on the results?To help you with pricing, you can download a free pdf file of the book Don't Just Roll the Dice: Usefully Short Guide to Software Pricing, by Neil Davidson, of Red Gate Software. If you prefer a physical copy of the book, you can.The book explores the economics and psychology of pricing, and the author cites his own experiences (good and bad) with software pricing.
Other Features
It's easy to read, with clear explanations and examples, and ends with a product pricing checklist. It also has this sensible advice: 'Practice trumps theory. Try out your pricing and see what happens.'
Author Posted on Categories Posts navigation.