Analyse-it blog The latest news on new features and software releases.

24-Sep-2015 Analyse-it 4.20 released: Support for Excel 2016

Microsoft officially released Office 2016 a couple of days ago, and Analyse-it version 4.20 now adds support for Excel 2016.

Over the next few weeks we will tweak the Analyse-it user interface so it matches the new Office 2016 user interface styles. Line styles on the plots in Excel 2016 now also appear a lot thicker, due to anti-aliasing (smoothing), so we will decide whether to address that in a future update – let us know what you think.

If you have active maintenance you can download and install the update now, see updating the software. If maintenance on your licence has expired you can renew it to get this update and forthcoming updates, see renew maintenance.

27-Nov-2008 Spot the difference: Numbers stored as text

In clearly titling this blog post, we’ve probably already revealed the answer, but... Can you spot the difference between the two rows of values in the Excel spreadsheet shown below?

Sorry, it’s a trick question, because (visually) there is no difference. The difference is how the values are stored by Microsoft Excel. The value 57 in the cell on second row is actually stored as a text string, not a number.

Continue reading article  

30-Oct-2008 Using INDIRECT to refer to cells on Analyse-it analysis reports

A customer contacted us last week to ask how to refer to cells on an Analyse-it report worksheet, from a formula on another worksheet. The customer often used Analyse-it's refresh feature, to repeat the statistical analysis and update the statistics, and direct references to cells on the report were being lost on refresh.

As an example, suppose you have used Analyse-it linear regression to calculate the linear relationship between installation cost and the number of employees required, distance to the site, and the cost of machine being installed. Analyse-it would calculate the effect of each variable on the final cost, technically known as regression coefficients, which you can then use to predict installation costs for jobs in future.

Continue reading article  

25-Sep-2008 Print an Excel chart full-page

Although the charts in Analyse-it are large so they’re easy to read when printed, sometimes you need to print a chart to fill the full page. You can do so easily, without resizing the chart, in just a few steps:

Chart size is only limited by the page size your printer supports.

Continue reading article