+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Macros in sims.net reporting in Technical; Hi Wonder if anyone can help. I am not an excel expert. I would like the population analysis to populate ...
  1. #1

    Join Date
    Jun 2012
    Location
    Bridgend
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Macros in sims.net reporting

    Hi

    Wonder if anyone can help.

    I am not an excel expert.

    I would like the population analysis to populate in the report and then forumals there to work out some figures dependant on the population analysis figures.

    i.e.

    Year 1 has a population of 61 pupils and then I would like to times this figure by 2,647 to get a total. They would like to know 5% of this total.
    Very simple calucations, but I would like this all to happen automatically.
    I have recorded the macro successfully, but dont know how to embed the calculations. Do I included them in the macro?? do I put them in first on the reportdata?? I have tried everyting without success.
    Hope some clever person out there can help me.

    Many thanks
    Tracey

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    @mahonta

    Check out this post for some initial help, and see how you get on. Edit Excel Output

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Historical Ethnicity Report in Sims.net
    By Disease in forum MIS Systems
    Replies: 7
    Last Post: 23rd May 2012, 03:08 PM
  2. [SIMS] Deleting rooms in SIMS.net
    By Sylv3r in forum MIS Systems
    Replies: 5
    Last Post: 20th April 2012, 10:00 AM
  3. [SIMS] Nova T4? All functions now in SIMS.net and T6?
    By localzuk in forum MIS Systems
    Replies: 9
    Last Post: 9th June 2011, 10:07 AM
  4. [SIMS] SIMS.net Reporting
    By MikeW in forum MIS Systems
    Replies: 2
    Last Post: 24th November 2010, 11:11 AM
  5. [solved] Missing data in SIMS.net Report
    By MrLudwig in forum MIS Systems
    Replies: 3
    Last Post: 27th November 2009, 08:43 AM

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
  •