+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, SIMs reports and Macros in Excel in Technical; Hi, This is my first time here so apologies in advance. I have been reading SIMs forums and seeing that ...
  1. #1

    Join Date
    Nov 2011
    Location
    Surrey
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMs reports and Macros in Excel

    Hi, This is my first time here so apologies in advance.

    I have been reading SIMs forums and seeing that people are writing Macro's in Excel within a SIMs report, and I would very much like to be able to do that.

    I asked SIMs and was told "The Professional Services team DO NOT have a report writing product. What they can offer is a Consultancy day where a report could be one of the end products, but it is a minimum 1 day consultancy at 1 day consultancy rates."

    Someone mentioned an Advanced Training Handbook on here, but I couldn't find it anywhere to download. I really just want to be able to do a little tidying up in Excel with a Behaviour report for example, by putting it into a Pivot table say.

    I am not an expert in Excel, but a little better than average.

    Hope someone can help.

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,664
    Thank Post
    1,484
    Thanked 1,263 Times in 857 Posts
    Rep Power
    803
    Hi Gill,

    welcome to EduGeek.

    I have sent you a PM that should help

  3. Thanks to LosOjos from:

    Mirmo (29th November 2011)

  4. #3

    Join Date
    Nov 2011
    Location
    Surrey
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thank you so much , I couldn't reply to your PM as I have to have at least two before I can do that.

    I have a nice bit of bed time reading!

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    hey Gill
    I just modified an excel macro that dumps emails to outlook. Was fairly straightforward.
    I can't remember what is in the advanced docs.
    Is that the document entitled Excel Macro Reporting.doc ?
    Not sure what you've got now, but this thread may also be useful, if for nothing else, the examples. Edit Excel Output

  6. #5

    Join Date
    Nov 2011
    Location
    Surrey
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    hey Gill
    I just modified an excel macro that dumps emails to outlook. Was fairly straightforward.
    I can't remember what is in the advanced docs.
    Is that the document entitled Excel Macro Reporting.doc ?
    Not sure what you've got now, but this thread may also be useful, if for nothing else, the examples. Edit Excel Output
    Thank you so much I did it

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Cool. Is it something funky that you can share ..?

  8. #7

    Join Date
    Nov 2011
    Location
    Surrey
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    Cool. Is it something funky that you can share ..?
    Not funky at all, sorry, it was just producing a report with three pivot tables. We have introduced a Uniform Infringement sanction in behaviour through the register and the Year Mangers want to see the list every week as a group, by students and by the teachers issuing them, and I didn't fancy creating the pivot tables every time.

    So simple and not as clever as some of the things the rest of you have been doing I am sure, but I can't believe how easy it was in the end. Thank you so much.

  9. #8
    CAM
    CAM is offline


    Join Date
    Mar 2008
    Posts
    4,371
    Thank Post
    875
    Thanked 411 Times in 311 Posts
    Blog Entries
    61
    Rep Power
    314
    Doing this is fun and a good show-off tool. It can also be used to strip the date format fix that exports all numbers as text.

    I made one for the SLT in charge of attendance and she is clamouring for more.

  10. #9

    Join Date
    Dec 2011
    Location
    Wiltshire
    Posts
    4
    Thank Post
    2
    Thanked 2 Times in 1 Post
    Rep Power
    0
    Hi, Sorry to jump in but wuld it be possible to send me a copy of the Advanced Training Handbook? I'd find it really useful!

  11. #10

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,258
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    183
    Quote Originally Posted by Bernie View Post
    Hi, Sorry to jump in but wuld it be possible to send me a copy of the Advanced Training Handbook? I'd find it really useful!
    That's a definite No, No as far as Capita are concerned.

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Quote Originally Posted by Bernie View Post
    Hi, Sorry to jump in but wuld it be possible to send me a copy of the Advanced Training Handbook? I'd find it really useful!
    @Bernie - follow my link in post #4 That should give you an idea of what you can do.

  13. Thanks to vikpaw from:

    Bernie (5th December 2011)

  14. #12

    Join Date
    Dec 2011
    Location
    Wiltshire
    Posts
    4
    Thank Post
    2
    Thanked 2 Times in 1 Post
    Rep Power
    0
    Thanks vikpaw

  15. #13

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    136
    Thank Post
    27
    Thanked 26 Times in 22 Posts
    Rep Power
    18
    Afternoon all,

    Just in case it helps anyone else who is heading down the SIMS macro editing path and can't find the C:\Program Files\SIMS\SIMS .net\tempRpt\ReportData.xls folder as described in the excellent document linked above (as I couldn't!) I found mine in the My Documents\tempsimsrpt folder on my roaming profile account.

    Pandora's box has been well and truly opened.

  16. Thanks to Ecclesbury from:

    vikpaw (7th December 2011)



SHARE:
+ Post New Thread

Similar Threads

  1. SIMS exported Marksheets (Formatted) in Excel
    By tben2505 in forum MIS Systems
    Replies: 2
    Last Post: 4th November 2011, 12:53 PM
  2. SIMS/Reporting/Assessment Post in Peterborough
    By Andie in forum Educational IT Jobs
    Replies: 0
    Last Post: 21st May 2011, 11:02 PM
  3. [MS Office - 2003] First pesty macro in Excel. Trolling me hard.
    By El_Nombre in forum Office Software
    Replies: 7
    Last Post: 28th January 2011, 02:13 PM
  4. Header and footer in excel
    By ful56_uk in forum Office Software
    Replies: 2
    Last Post: 22nd January 2010, 10:38 PM
  5. Macros in Excel 2003
    By LeonieCol in forum Office Software
    Replies: 1
    Last Post: 8th May 2009, 05:09 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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