Some of you will know that I have been developing (for the past 2 or more years!) some fast multi-threaded Excel functions using the XLL C++ interface.
After climbing this rather steep learning curve I am now very close to the final release of these functions.
FastExcel SpeedTools is designed to be a state-of-the-art set of tools to help you speed up calculation of slow workbooks:
New calculation methods and modes give you greater control of calculation.
Superfast memory lookup and Compare Lists functions make handling large data volumes easier.
You can eliminate many SUMPRODUCT and array formula bottlenecks with SpeedTools FILTER.IFS.
Additional functions include Regular Expressions, Array Stacking, Array OR/AND, Text and Information functions
The final SpeedTools Beta test is now live and I need more Beta Testers and feedback:
The best 20 Beta test feedback reports received by the end of March will get their own exclusive SpeedTools coffee mug, (and a free license of course!).
Excel 2003 users get a toolbar to choose functions and launch the Function Wizard, and Excel 2007 and later users get 2 additional groups on the Formulas tab.
You will find more information on my website and blog, including some performance comparisons with the built-in Excel functions.
The original Excel file that was printed to PDF using CutePDF
I followed Debra’s instructions and got this result from pdftoexcelconverter.net
It converted the font to Times New Roman and ignored borders, bold, merged cells, underlines, and italics. For pure data though, a pretty good job.
Next, I dragged-and-dropped the PDF into OneNote and chose the “Print Out” option. I right-clicked on the image and chose “Copy Text…” and pasted in Excel.
Yikes. Font conversion is the least of my worries here. Finally, I dragged-and-dropped the PDF into Google Docs and chose the options to convert to Google Docs format and to OCR it. Google Docs converts PDFs to Documents (not spreadsheets) so I wasn’t very hopeful. I didn’t see a way to convert the Doc to a spreadsheet so I saved it as HTML, then opened in Excel.
The whole table is one cell. My conclusion is that OCRing tables is hard.
Microsoft MVPs Dick Kusleika (Daily Dose of Excel) and Mike Alexander (DataPig) are joining together to bring you our acclaimed Power Analyst Boot Camp!
This two-day boot camp is designed for Excel Power Analysts who are looking to more effectively build and manage better data reporting mechanisms. During this workshop, you’ll be introduced to a wide array of tips and techniques that will muscle up your skills in Data Crunching, Reporting, and Automation.
Register early to get a $150 per seat discount. Only $700 for two days of awesome training.
Also, if you didn’t know, Omaha is my home town. That doesn’t just mean that I’ll be more rested during the training, it also means the class will fill up fast as I pressure my colleagues, friends, and family to attend. Don’t wait to sign up. Register here.