Training Home Page

Orange Belt Introduction
Favourites
Saving Calculations
Cookies
Local Scales
Export to Excel
Video Demonstrations
Self Assessment

Black Belt Introduction
Calculation Construction
NI
Pensions
Inflation
Self Assessment

Back to SiriusWeb.

Add more than one Calculation into a Spreadsheet

You can build up a costing profile by adding costings into one Excel spreadsheet.

There are several ways of approaching this task, but to make sure that your calculations are recognised numerically in Excel (thus facilitating further calculation) it is recommended that you use one of the export to excel options rather than simply selecting the results table and pasting it into Excel.

Back

Continue

1. Complete the first calculation and click the export to Excel link located at the top or bottom of the page.
   
   
   
   
   
2. Click the Save option.
   
   
   
   
   
   
   
3. Go into Excel and open up the new spreadsheet.
   
   
   
   
4. Set up the spreadsheet in the required format.
   
   
   
   
   
5. Click back to SiriusWeb and complete the next calculation (don't forget, if the calculation is similar to the first one, say just a different category of staff, to use the orange back button to save having to enter all the parameters again).
   
   
6. On completion of the calculation click the Export to Excel link again but this time opt for the Open option.
   
   
7. As you have used the export function you can now copy the relevant information and paste it into the previously saved spreadsheet.
   
   
   

Back

Continue

Version 2.227b © Copyright the University Of Leeds 2002 - 2018
Before using SiriusWeb please read the terms and conditions and Privacy Notice
Web site development: Gary Taylor and Lorna Halson
Original developer:  Scott Hennessy.