[LON-CAPA-users] Slow spreadsheet calculations

lon-capa-users@mail.lon-capa.org lon-capa-users@mail.lon-capa.org
Tue, 2 Jan 2007 12:08:57 -0500

<div>I see what you mean with the number of resources. A couple of follow o=
n questions:<br><br>1)&nbsp; If I do a spreadsheet calculation, then immedi=
ately re-run it, the second run still takes the same time as the first run.=
 It sounds as though student level spreadsheets (or subsets) should be save=
d, so the second run would be faster. Am I missing something?<br><br>2)&nbs=
p; Is there something I can do to tell it not to calculate folders of probl=
ems? For example, I have a large number of problems that will not be starte=
d until the end of the year. I tried marking them Hidden, and setting open =
date off in the future, but no impact on the calculation time. 25 seconds p=
er student seems to be the rule.<br><br>Thanks,<br>brew<br></div><font colo=
r=3D"#990099">-----lon-capa-users-admin@mail.lon-capa.org wrote: -----<br><=
br></font><blockquote style=3D"border-left: 2px solid rgb(0, 0, 0); padding=
-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">To: l=
on-capa-users@mail.lon-capa.org<br>From: Guy Albertelli II &lt;guy@albertel=
li.com&gt;<br>Sent by: lon-capa-users-admin@mail.lon-capa.org<br>Date: 12/2=
9/2006 06:26PM<br>Subject: Re: [LON-CAPA-users] Slow spreadsheet calculatio=
ns<br><br><font face=3D"monospace" size=3D"3">Hi Brew,<br><br>&gt; Wow. So =
these guys using the system to do 6000 students have to run<br>&gt; 50 hour=
s to get their spreadsheet?<br><br>Well maybe, maybe not.<br><br>Time to ca=
lculate is linearly related to number of resources and<br>number of student=
s. I suspect that your course has a notably higher<br>number of resources..=
..<br><br>Additionally, generally one shouldn't need to do a complete<br>re=
calculation of everything. And thus if there was 50 hours of calcs<br>to do=
 it is spreadout over the entire term. (And if you offer up the<br>SPRS to =
the students. They can soak up some of that time for you.)<br><br>So genera=
lly one shouldn't see a time wait this high.<br><br>Other people prefer usi=
ng CHRT and just getting a Excel spreadsheet<br>dump of the data and then m=
uck with it in Excel.<br><br>All that being said, yes I'd love to make the =
SPRS faster but haven't<br>been able to improve it more yet. (Although it's=
 much better than it<br>was, used to take more than 10 minutes a student.)<=
br><br>-- <br>guy@albertelli.com &nbsp; 0-7-1-6-27,137<br>=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F<br>LON-CAPA-users maili=
ng list<br>LON-CAPA-users@mail.lon-capa.org<br><a href=3D"http://mail.lon-c=