Natashac15

Hi, I was wondering if anyone can help me please. I am wanting to make up a Progress 8 marksheet for my current year 9's, does someone have a template I could possibly import and maybe change around, or do I have to start from scratch. please can someone advise me? Many thanks in advance.

Thank you for the comments. I am currently just going over macros to familiarise myself with it all. I was wondering if any one can help me produce this sort of report please, so Behaviour weekly/half termly/term/year will calculate points, attendance will calculate percentage for each week, term/year etc. Thank you in advance. Info weekly Half termly term year Behaviour / / / / Bullying / / / / Attendance / / / / Punctuality / / / / DTs / / / / Exits / / / / Average ATL and residual +/- / / / Interventions / / / /

Thank you I will try this. Are you any good with recording macro's/formulas in excel, so when I run a report from SIMS this is all automatically calculated? Does that make sens, Thank you

HI just wondering if someone is able to send me the ReportData.xls file as I can not seem to find this. I want to strat creating foprmulas/macros so when I run a report from SIMS all data will automatically work out percentages. If anyone also has any tips on this I would appreciate any help. Thank you. My email is [email protected]

Hi . Wondering if anyone can help me please, I am using a custom defined RTF report In SIMS, I have put in all my dad that was needed and the report is fine, BUt when I edit the template and add the school logo the report does not run? Can someone help please? Thank you

thank you all for your comments, this is all really helpful, I am new to macros/VB, does anyone have a report template they could possibly send me that I can use that has formulas/macros already recorded by any chance, I also need the spreadsheet to automatically produce percentages for ethnicity vulnerable group attendance. Hope this makes sense. Thank you again

Hi please can anyone help me. I am new to producing reports through sims inexcel. Basically i want sims to run a report which already contains formulas and gives me the data with me having to filter. I need help with producing an interventions report which contains ppi info, ethnicity number ofinterventions, intervention comment i need all this data but with percentages already worked out when i run this report? Can soneone help? Also needhelp with another report which when i pressrun i want it to produce pivot table? Thank yoy