MIS Systems Thread, SIMs Reporting in Technical; hi all,
i wish to export marksheets from sims.net into an existing spreadsheet. currently staff copy and paste names and ...
4th March 2009, 03:31 PM #1
- Rep Power
i wish to export marksheets from sims.net into an existing spreadsheet. currently staff copy and paste names and grades from sims into a spreadsheet, which then calculates percentages and shows charts.
i would prefer sims to export to this spreadsheet and give information without the copy+paste bit. i can export reports into a blank spreadsheet but that's as far as i've got.
any suggestions would be greatly appreciated.
IDG Tech News
4th March 2009, 03:57 PM #2
You can edit the excel template. Or is that just word?
Last edited by matt40k; 4th March 2009 at 03:59 PM.
5th March 2009, 03:49 PM #3
- Rep Power
whenever i amend the template, nothing is added. if i select standard portrait/landscape it adds the results.
5th March 2009, 04:30 PM #4
- Rep Power
Have you tried linking an external data source (the sims export spreadsheet) to the spread sheet with the formuli in?
Excel - Data - Import external Data - Import Data.
If you set up the link correctly then any changes made in the external file will update in the file you wish to use to manipulate the data.
See attached image.
Top data is import from original file
Bottom data is original file with changes with update enabled.
If that makes sense.
2 Thanks to pacapps:
pale_kid (6th March 2009), vikpaw (7th March 2009)
6th March 2009, 08:01 AM #5
- Rep Power
thanks for your suggestion, i'll try it out today!
i tried it and it seems a lot less simple than asking staff to just copy and paste the results in! it's a shame there's no obvious way of just outputting to an existing spreadsheet with the formulae in (without the intermediate step).
Last edited by pale_kid; 6th March 2009 at 08:47 AM.
7th March 2009, 08:38 AM #6
Wouldn't it be better to perform the calculations in SIMS. The formula functionality is improving and means the data is live. This way staff can review their own information and generate a chart if they wish.
There are ways to set up a report which then uses an excel template (basically you modify the built in one to have extra macros and automated calculations), however creating a report to export that data is a pain. There is a thread regarding this on Capita's SupportNet
I try to move to the point where unless absolutely necessary data is not exported. It's only printed out like that if it needs to be presented or used in a meeting. Otherwise it stays in SIMS so that if a teacher goes in and amends data e.g. notices a grade was incorrectly input then the analysis is also immediately up to date.
I have used the method you suggest of copy pasting. With one sheet set up full of complex formulas linked to another sheet where i just paste the output of a report from SIMS. I use it to manipulate the staff data ready for importing to our PHP based intranet.
By Stuart_C in forum MIS Systems
Last Post: 3rd March 2009, 11:16 AM
By mtnewman in forum MIS Systems
Last Post: 2nd September 2008, 08:55 AM
By russdev in forum Educational Software
Last Post: 1st May 2008, 12:03 PM
By Oops_my_bad in forum MIS Systems
Last Post: 20th March 2008, 07:28 PM
By TechMonkey in forum How do you do....it?
Last Post: 8th February 2008, 07:53 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread