Below are some frequently asked questions for when it comes to using EQUS or deciding if this Excel add-in is right for your needs.
If you have just starting running EQUS with Excel and don’t know what to do, don’t worry just keep the EQUS window visible and it will do its best to visualize any formula you select while using Excel normally.
However, if you are having trouble running EQUS have a look at our troubleshooting_guide.
What does EQUS stand for?
EQUS stands for Enhancing the Quality and Usability of Spreadsheets
How does EQUS show the cells it is visualizing?
EQUS analysis the equation in a cell and works out each computation involved. This allows it to present the visualization and the intermediate computed values.
Can I print EQUS visualizations?
The best way of printing an EQUS visualization is to take a screen grab of it, paste it into a document, and print it.
Can I copy EQUS visualizations?
The best way of copying an EQUS visualization is to take a screen grab of it.
How many worksheets can I have open?
EQUS places no limit on the number of worksheets.
How many workbooks can I have open with my EQUS licence?
EQUS places no limit on the number of workbooks open.
Does EQUS work with Office 365?
Yes- The EQUS plugin operates fully with Excel 2016 with Office 365 provided there is an on device installation.
Does EQUS work with implicit intersections?
Yes- The EQUS plugin operates fully with implicit intersections.
Does EQUS work with named cells and ranges?
Yes- The EQUS plugin operates Excel’s naming facility.
More Capabilities – What EQUS Can Do for You
Is EQUS accessible?
Yes – EQUS setting for visualization can be configured to suit the specific needs of those with partial visual impairments. Since EQUS operates with Excel the accessibility features supported by Excel are also available. See our configuration instructions.
Can I re-size the EQUS viewing pane?
Yes – the pane can moved and resized as you wish.
Can I edit Excel equations while EQUS is visualizing?
Yes – Excel operates as normal so you can edit an equation, select its cell and see it visualized.
Can I use EQUS offline?
Yes – However, note that EQUS will occasionally check for updates when connected to the internet.
Will EQUS handle the functions of trigonometry?
Yes
Will EQUS handle exponentials and natural logarithm?
Yes
How does EQUS present “pi”?
As with Excel, EQUS shows “pi” as a function with no parameters (written in Excel as “PI()”), it shows a truncated version of the value pi.
Will EQUS work with Visual Basic in Excel?
Yes
Getting EQUS working
When an EQUS licence expires, what happens?EQUS will give you warnings before the licence expires. When it does expire, you’ll not longer see the EQUS tab and visualization. Excel will carry on operating as normal.
If I move to a new machine, will I still be able use a single users licence? Yes, you’ll need to install EQUS on the new machine and use your licence key (the licence key and the link are in the emails you get).
What does installing involve?You’ll be emailed a licence key and a link to an executable. Running the executable will be put the EQUS software on your machine and when you run Excel, you’ll be reminded of the licence conditions and asked for your licence key. (Depending on your machine, the install may require that additional software from Microsoft is installed, the dialogue will lead you through that.)
Limitations – Some things EQUS does not do
Can I edit Excel equations using EQUS?
No – you must still edit equations in Excel and visualize them in EQUS. EQUS is designed to visualize and therefore support understanding equations while using Excel.
Will EQUS work between different Excel workbooks?
The EQUS Expert allows between workbook references. However vanilla EQUS limits references to within a workbook. EQUS Expert allows between workbook references.
Will EQUS work with array formulas?
No – however, Excel will operate as normal. A design decision to keep the visualization clear and simple meant that array based formulas are not visualized. We are researching how best to visualise and operate with array formulas.
Will EQUS work with VLOOKUP?
Yes – EQUS Expert will visualize vlookup (and similar functions).
However, vanilla EQUS will not visualize vlookup.
Will EQUS work with HLOOKUP?
Yes – EQUS Expert will visualize hlookup (and similar functions).
However, vanilla EQUS will not visualize hlookup.
Will EQUS work with Table references?
EQUS will operate with some Table references but not all uses of tables will be visualized.