Spending too long in Excel? We can automate your Excel tasks, saving you time and reducing frustration.
Excel Add In allowing R analysis and charts to be performed in any Workbook.
Struggling with manually processing your data? Bespoke software for efficient and accurate data analysis.
We typically work with engineers, scientists and consultants automating time consuming data manipulations, implementing custom algorithms or building data visualization tools enabling action on the information rather than dealing with mechanics of data manipulation. Our solutions can be built as robust Excel Add Ins or standalone applications and all bespoke software comes with documentation and a perpetual license to use on as many of your companies computers as required. As we have considerable experience of developing tools in Excel we can also automate any existing Excel process and replace slow and unreliable VBA macros.
Demos and Trials
A free Excel Add In allowing you to produce some basic statistical charts.
Run R code from Excel and get results and charts on the worksheet. Try our 30 day free trial.
Free Excel Add In allowing Excel data to be saved and imported for an R workspace.
Another update has been made to Sharp-R bringing it to version 1.2. The main changes are, Multiple function files. Built in standard functions. Changes to the XML function files. Bug fixes. We have increased the number of function files that can loaded at any time to three. So now more custom functions can be quickly[…]
This is the second part in a series of posts on the flexibility of our Excel Add In Sharp-R, that allows functions defined in R code to be run on data in any Excel worksheet. Part one looked as exploratory data analysis. This post deals with time series analysis which is a complex area and standard Excel is limited in what can be done. […]
A recent post on R Bloggers, linked to an article on DataScience+ that details how to use R to plot error bars on bar charts to indicate the variability in a particular variable. There are many other articles that detail this type of chart, sometimes referred to as “dynamite plots” which have a major flaw as the bar hides much of the information needed to make a decision on the variability of the data.