Welcome to Add-Innovation. Construction of this site has been suspended for several years while we've concentrated on consultancy in SAS, MS/Office and VBA. This has strengthened our knowledge and experience.
We're now back into R&D mode and updating this site. All our add-ins are being redeveloped and updated. Any expiry dates will be replaced while we offer free macros. Microsoft removed the module which enabled graphs to be added in user forms (which we used extensively). We've coded around that and will relaunch the macros accordingly. Only "What's Eating My Megabytes" and the "HeatMap" to go.
We're still in consultancy but more recently have been diverting time to learning new skills and packages. We will be enhancing this web-site with many MS/Expression Blend improvements, updating (and enabling) our add-ins to work under Office 2010, and even adding a development blog to "Skeletons in Wellingtons" !
We've pushed our integration of MS/Office applications even further than before, and will be adding details of that development to this store.
For example, a recent development saw replacement of FOCUS programs and laborious process notes, with a one click mainframe SAS to Excel approach. The SAS application presented the feeds one a single page with a start date selection. One click crunched & emailed the mainframe data to the clients MS/outlook account. A VBA macro behind outlook recognised the email and opened an index to determine how to deal with the attachment. The index would show where to store the attachment (adding a link in the email and removing the attachment from the mail), and which macro controlled spreadsheet to open to process it. The mail was tidied away to a history folder.It's a symphony of data manipulation.
Add-Innovation specialise in Information Technology Design and Programming. Our main areas of expertise lie in SAS Programming and Application Design, Visual Basic for Applications, and Microsoft Office Applications, with over 20 years of commercial experience. The mix of these skills is extremely useful in rapidly developing low maintenance, highly integrated office solutions utilising the best features of the tools on your desktop.
We've also experience in Ab Initio programming, coupled with "shop for data" taking their product beyond data transform & load operations. Our experience with dozens of other programming languages, platforms and operating systems coupled with a wide scope of business experienced leaves us well positioned to analyse your requirements and design the optimium solution.
Please note that this is an evolving site, starting with the Excel Add-Ins and Excel help section. Please be patient while the remaining sections are developed. Click on the header to go to the index section for each area.
VERY New, VERY Cool Stuff :
Toolbar ; Instantly add an automatic top / bottom 3 indicator to your data
as a subtle, non-cluttered additional column running alongside your data.
email us for more info ...
Outlook macro to save your attachments elsewhere and replace them with hyperlinks to that location, freeing your inbox space so you're only left with the text.
Seperate outlook macro to zip the attachment sent to you, and keep it in the mail as a zip file should you not want to use the above. We use both off a toolbar and never delete any emails - we just manage the attachments on our archive drives.
MAPS and GIS in Excel. Microsoft removed the pretty much unused mapping features in Excel, we've recreated them in an add-in so you just point to your locations id, and point (once) to the location of the id to postcode / location file (which we can help set up), and it will ;
Pop up a user form showing all the location details as a quick reference tool.
Allow export of the data into Excel anywhere you want.
Insert a query to update it whenever you want, or whenever the data changes.
Show the data on a map ; link the point sizes to a given column of data ; link the point colours to a given column (e.g. if you use traffic lighting).
Coming soon, we'll allow you to group ranges to another identifier where you don't have a map reference or post code (e.g. a regional centre), and allow mapping based on that centre point, with drill up / down functionality.
New features (added June 2013) ;
Click to change the location reference data ;
Click to change the map image ; (e.g. to show sales within department of a supermarket ; stock control in a warehouse ; number of visitors by department in a supermarket ; air flow within an engine ...)
enhanced on screen help for every feature ;
Statistical analysis option added which enables rudimentry analysis of any data displayed by the reference tool, including all basic statistics (mean / mode / median / max / min / range / standard deviation), distribution table and distribution chart, and box plot. Charts, distribution table, box plot, and statistics can all be exported to your spreadsheet with a single click.
Map animation options to visually show data (e.g. pace of market penetration)
Categorise points using an additional column, adding an additional legend. More control options for point appearance (size, width / area selection, 3D or simple).
Enhanced control of defining each location's point on the map, or automating the calibration of positional data to map to the right positions on our image.
It's all happening so quickly ! Oh the perils ! Read the development blog !
COOKIES : We eat them, but don't use them at all (currently) on this site. We'll update this notice immeditately if we do.
PRIVACY : We never divulge details of any user who browses this site, emails us, or uses our tools, to anyone, ever.
Excel Usage & Formula Tips,
|Hints, Tips, and
Resources for VBA,
Applications in ;
|SAS Programming Tips,
Maintenance free applications,
Reduce, Re-use & Recycle SAS Tools,
Macro & Datastep Windows
|Ab Initio coding
Hints and Tips,