jimbojames136

Hi All, After some extensive searching and experimenting. Ive finally given in and turned to you guys for help. Im trying to get my mail merge to page break for each new class that is in the source data. Ive followed some of the guidance for doing this that others have posted with no joy. I've attached my documents and id be very greatful if anyone could point me in the right direction with it. Class Data Label Test1.xlsClass Data Labels Test.doc thanks for your help James

Hi All, Just wondering how people have their Census Returns set up (Inculding Workfoce Census).... i.e; Where do you have it set to publish validated files to? Who has access to said files? Do you print copies of summary document out and distribute? Do you manage all areas of return, or do you delegate to other people to manage those areas? (e.g Staff Contracts)

Hi im having a problem with a scatter graph. I have my two sets of data that i want to plot on a scatter graph. column A and Column B. (amongust other data) I have a formula to populate both columns from another worksheet else where. Column A = =IF('Data Input'!J2=0,"",'Data Input'!J2) Column B is something similar. No matter what kind of formatting i try, or any combination of formulas, i cannot get this data to plot onto the graph. However if i manually enter the data into column A rather than using the above formula. It Works! why? hopefully someone could shed some light on this for me? maybe even a resolution? thanks James

Hi, The online mode for Excel has never worked for us, and we also use a smoothwall. Using offline mode has'nt cause me any major headaches so far.

I don't even use the <> I have my Individual Report set up with a table. If a student doesn't have grades in that aspect, it removes the row from the report.

Now Fixed

Hi All, don't know if someone can help. I have this graph as you can see the first data point is showing series "Attain" , Point "5.3" (1,7.0) where I actually need this to plot is Series "Attain" , Point "1" (5.3,7.0) no matter what I change I cant seem to get it to work. Can anyone out there help? thanks James

Thanks Vikpaw, it turns out it was just SIMS being silly and its now rectified itself.....

Don't know why but last couple of days when creating a new report the results are being displayed strange. just want forename, surname & ethnicity. However when Ethnicity comes out instead of it filling one cell in excel, its filling a cell for each word. For instance,"information not yet obtained" is filling four cells. Normally this would have just populated once cell as its that child's ethnicity. anybody got any ideas? thanks James

You can make aspects inactive, this will hide them from general viewing.

Yeah we plan on using the new 9-1 grades in En & Ma. I've already started creating the new aspects to accommodate the grades.

I better not install that then

Possible the update for windows 8.1 is KB3023222. This is an update waiting for me to install, and my SIMS is still fine.

Hi Guys, wondering if anyone can help me spot what im doing wrong. I have 3 columns and a lookup table Column 1 Contains a Grade (A,B,C etc) Column 2 Lookups up the Value of that grade, with an iferror to stop #N/A =IFERROR(VLOOKUP([@Maths],Grade_to_Points,2,FALSE),"") Column 3 looks at Column 2 and if the value is greater than 5 return M =IF([@[Maths Points]]>=5,"M","") Now the problem I have is Column 3 returns M for every Cell, even though column 2 cells are blank...... what am I missing? any help much appreciated. thanks James

I assume that this is in SIMS? is Main Teacher set in Nova?

no worries, glad I could help!

Do you use Group filters and Course links on the Marksheet template?

@LosOjos I'd be interested to see the additions you have made as that would save me a lot of time when entering the data next year.

That is much better, I had no idea this existed. Just goes to show there are many more hidden areas of SIMS left to discover for me

glad i could help. I'm not sure on the filtering, i have had problems like that before. Haven't figured out why yet.

I've PM'd you or i would have if my browser would let me. give this a look. you will need to add your template to the Form Report user defined output, and set the fields as required. Attendance By Code.rar

so you want to be able to run a report on all students between a set date range with a specific code? with address details and put it all into a template in word?

We use this, and has been a very effective tool to show staff progress for their subject. We update it each time we collect data from staff, to get a "where we are now picture", but this is a time consuming process. I have also looked at the hidden sheets and formula's but there are some complex calculations that I couldn't get to the end of. I did however add in some extra fields to aid in group analysis.

Could you not design a report and use the "Form Report" with a user-defined template?

Hi all, i have used some macro code to perform a find and replace on a formula in a table. (see below) i keep getting the " we couldnt find anything to replace" error box even though it does replace part of the formula. Im also aware that this probably isnt the cleanest way of doing it? i call this sub from another sheet that uses a listbox Sub English() ' ' English Macro ' Changes Data to English ' ' Keyboard Shortcut: Ctrl+Shift+W ' Range("C3:L21").Select Range("L21").Activate Selection.Replace What:="$L$6:$L$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$M$6:$M$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$N$6:$N$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$O$6:$O$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$P$6:$P$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$Q$6:$Q$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$R$6:$R$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$S$6:$S$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$T$6:$T$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="$U$6:$U$500", Replacement:="$K$6:$K$500", LookAt _ :=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub thanks James