Excel VBA tool for windows manufacturer

Months of full time word. Thousands of VBA code rows. Advanced tool for wooden windows manufacturer. The tool allows to design windows, to calculate total price (include all materials prices, all kind of work cost etc.), to build specifications with drawings, to build specifications for materials suppliers, to export data in specific format for automated production line etc. Ad...
Read More

Interactive Excel Dashboards

Excel based tool for income, expenditures, assets etc. structure analysis. The dashboard (see the screenshot) allows to select any age range (or multiple age ranges), then VBA code automatically highlight selected ranges in the age ranges table and corresponding bars of the histogram as well as refreshes all tables and pie charts below to show income, expenditures, assets struc...
Read More

Excel VBA Tool for a Large Corporation

Complex Excel VBA project. Months of full time work. More than 10 thousands of VBA code rows. Complex Excel ribbon tabs and VBA forms created, progress bars used Multiple VBA procedures created: to open template files, to migrate data from older versions, to import and clean data from excel files, to perform complex calculations, to refresh pivot tables, to build matrix d...
Read More

Printable Interactive Excel Form

Printable interactive order form with add row, remove row and reset functionality. Just in one click user can add/remove rows in different sections of the form. As well as reset button will remove all added rows. User can use either buttons (visible but non printable) on the form or buttons on the ribbon. All values inputted into user added rows automatically included into calc...
Read More

Excel tool to parse OCRed PDFs

Excel VBA tool to parse multiple large OCRed PDF documents into CSV files. SQL queries used to get data from source files fast and  w/o opening the files in Excel. Regular Expressions used to split data into rows and columns, to verify data formats, to remove trash characters, to fix OCR errors. The tools is able to detect and fix multiple OCR errors or highlight and log record...
Read More