<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p.msonormal0, li.msonormal0, div.msonormal0
{margin-right:0in;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.EmailStyle18
{font-family:"Calibri",sans-serif;
color:windowtext}
span.EmailStyle19
{font-family:"Calibri",sans-serif;
color:windowtext}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
-->
</style><style type="text/css" id="owaParaStyle"></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hello Again,
<div><br>
</div>
<div>I hope I'm not veering into the realm of scam, but I have another update.</div>
<div><br>
</div>
<div>Using the "Clear Caches" button rather than the "Generate Chart" button appears to put the x's back into the Excel and CSV charts. While this fixes the problem I'm looking to solve, I suspect that cached scores changing the spreadsheet values of excused
problem parts is not the desired behavior. I will be creating a bug report shortly and believe I know how to address the problem.
<div><br>
</div>
<div>I suggest those using the Grade Assessment Chart spreadsheets use the "Clear Caches" button, especially for older homeworks that might have cached scores.</div>
<div><br>
</div>
<div>Lee</div>
<div><br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF984356" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> lon-capa-admin-bounces@mail.lon-capa.org [lon-capa-admin-bounces@mail.lon-capa.org] on behalf of Bynum, Lee Hamilton [leebynum@illinois.edu]<br>
<b>Sent:</b> Wednesday, December 06, 2017 1:28 PM<br>
<b>To:</b> list about administration and system updating<br>
<b>Subject:</b> Re: [LON-CAPA-admin] Excused Problems In Excel<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal">Diving deeper, it looks like the excel and csv grade assessment charts and the html grade assessment charts are showing different things. The spreadsheet versions are showing the computed points and the html version is replacing those
points with characters in the case of things like excused problem parts. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">The cases in which I am seeing x’s in the spreadsheet grade assessments come from when the computed points are invalid for some reason. I suspect those are caused by scores being logged prior to the problems being excused.</p>
<p class="MsoNormal"> </p>
<div style="border:none; border-left:solid blue 1.5pt; padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> lon-capa-admin-bounces@mail.lon-capa.org [mailto:lon-capa-admin-bounces@mail.lon-capa.org]
<b>On Behalf Of </b>Bynum, Lee Hamilton<br>
<b>Sent:</b> Tuesday, December 5, 2017 3:43 PM<br>
<b>To:</b> lon-capa-admin@mail.lon-capa.org<br>
<b>Subject:</b> [LON-CAPA-admin] Excused Problems In Excel</p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hi Everyone,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">We have noticed that the grade sheets generated for Excel and CSV are placing 0’s in the place of x’s, most of the time. In at least one problem a single student retained their excused x’s in Chrome and Safari, but not Firefox. The HTML
grade sheets are working fine, so it feels as though something is going wrong with Spreadsheet::WriteExcel.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Is anyone else experiencing similar behavior?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Lee</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>