+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1

    Join Date
    Mar 2009
    Location
    uk
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMs Reporting

    hi all,

    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.
    thanks.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    You can edit the excel template. Or is that just word?
    Last edited by matt40k; 4th March 2009 at 04:59 PM.

  3. #3

    Join Date
    Mar 2009
    Location
    uk
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    whenever i amend the template, nothing is added. if i select standard portrait/landscape it adds the results.

    any ideas???

  4. #4

    Join Date
    Oct 2005
    Posts
    1
    Thank Post
    0
    Thanked 2 Times in 1 Post
    Rep Power
    0
    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.

    HTH

    Paul
    Attached Images Attached Images

  5. 2 Thanks to pacapps:

    pale_kid (6th March 2009), vikpaw (7th March 2009)

  6. #5

    Join Date
    Mar 2009
    Location
    uk
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks for your suggestion, i'll try it out today!


    <<edit>>
    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 09:47 AM.

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. SIMS Attendence reporting
    By Stuart_C in forum MIS Systems
    Replies: 6
    Last Post: 3rd March 2009, 12:16 PM
  2. Sims Reporting - Deleting Favourites
    By mtnewman in forum MIS Systems
    Replies: 2
    Last Post: 2nd September 2008, 09:55 AM
  3. Reporting Software.
    By russdev in forum Educational Software
    Replies: 10
    Last Post: 1st May 2008, 01:03 PM
  4. Auto-reporting in SIMS and permissions
    By Oops_my_bad in forum MIS Systems
    Replies: 2
    Last Post: 20th March 2008, 08:28 PM
  5. Behaviour Reporting
    By TechMonkey in forum How do you do....it?
    Replies: 8
    Last Post: 8th February 2008, 08:53 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •