+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Calculating %A*-C in Result Spreadsheets in Technical; Hi, I knocked up a quick and dirty set of macros in excel to automatically calculate %A*-C (or equivalent) in ...
  1. #1

    Join Date
    Jul 2005
    Location
    Rugby
    Posts
    432
    Thank Post
    17
    Thanked 66 Times in 61 Posts
    Rep Power
    35

    Calculating %A*-C in Result Spreadsheets

    Hi,

    I knocked up a quick and dirty set of macros in excel to automatically calculate %A*-C (or equivalent) in a Sims marksheet exported spreadsheet. The macros append a formula (that supports filtering of records) to blank cells at the top of the rows, will detect between GCSE/BTEC results etc, and should support similar spreadsheets from any source.

    If anyone is interested in seeing/using this then please let me know and I'll upload it.

    Matt

  2. #2

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,839
    Thank Post
    1,624
    Thanked 1,883 Times in 1,399 Posts
    Blog Entries
    2
    Rep Power
    427
    I wouldn't mind having a look if thats ok

  3. #3

    Join Date
    Jul 2005
    Location
    Rugby
    Posts
    432
    Thank Post
    17
    Thanked 66 Times in 61 Posts
    Rep Power
    35
    I've uploaded the files here.

    Import the Add-In (grade macros.xmal) into excel with Excel Options -> Add-Ins then follow the notes in the sample spreadsheet.

    Let me know how you get on.

    Matt
    Attached Files Attached Files

  4. #4

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,839
    Thank Post
    1,624
    Thanked 1,883 Times in 1,399 Posts
    Blog Entries
    2
    Rep Power
    427
    Is there of doing it without macros??

  5. #5

    Join Date
    Jul 2005
    Location
    Rugby
    Posts
    432
    Thank Post
    17
    Thanked 66 Times in 61 Posts
    Rep Power
    35
    Copy and paste formula...?

SHARE:
+ Post New Thread

Similar Threads

  1. Count the number of Girls and Boys in a spreadsheet
    By EaglesNerd in forum How do you do....it?
    Replies: 4
    Last Post: 22nd March 2011, 12:58 PM
  2. Non-EDI Results in SIMS
    By Sivadam in forum MIS Systems
    Replies: 4
    Last Post: 27th August 2009, 12:43 PM
  3. Replies: 19
    Last Post: 18th March 2008, 03:19 PM
  4. Replies: 2
    Last Post: 28th January 2008, 12:56 AM
  5. Calculating a variety of % in SIMS
    By sixfootsy in forum MIS Systems
    Replies: 6
    Last Post: 15th January 2008, 04:47 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
  •