[BACK]Return to default_assesscalc CVS log [TXT] [DIR] Up to [LON-CAPA] / loncom / interface / spreadsheet
File:  [LON-CAPA] / loncom / interface / spreadsheet / default_assesscalc
Revision 1.7: download - view: text, annotated - select for diffs
Fri Aug 1 13:47:26 2003 UTC (20 years, 9 months ago) by matthew
Branches: MAIN
CVS tags: version_2_9_X, version_2_9_99_0, version_2_9_1, version_2_9_0, version_2_8_X, version_2_8_99_1, version_2_8_99_0, version_2_8_2, version_2_8_1, version_2_8_0, version_2_7_X, version_2_7_99_1, version_2_7_99_0, version_2_7_1, version_2_7_0, version_2_6_X, version_2_6_99_1, version_2_6_99_0, version_2_6_3, version_2_6_2, version_2_6_1, version_2_6_0, version_2_5_X, version_2_5_99_1, version_2_5_99_0, version_2_5_2, version_2_5_1, version_2_5_0, version_2_4_X, version_2_4_99_0, version_2_4_2, version_2_4_1, version_2_4_0, version_2_3_X, version_2_3_99_0, version_2_3_2, version_2_3_1, version_2_3_0, version_2_2_X, version_2_2_99_1, version_2_2_99_0, version_2_2_2, version_2_2_1, version_2_2_0, version_2_1_X, version_2_1_99_3, version_2_1_99_2, version_2_1_99_1, version_2_1_99_0, version_2_1_3, version_2_1_2, version_2_1_1, version_2_1_0, version_2_11_0_RC2, version_2_11_0_RC1, version_2_10_X, version_2_10_1, version_2_10_0_RC2, version_2_10_0_RC1, version_2_10_0, version_2_0_X, version_2_0_99_1, version_2_0_2, version_2_0_1, version_2_0_0, version_1_99_3, version_1_99_2, version_1_99_1_tmcc, version_1_99_1, version_1_99_0_tmcc, version_1_99_0, version_1_3_X, version_1_3_3, version_1_3_2, version_1_3_1, version_1_3_0, version_1_2_X, version_1_2_99_1, version_1_2_99_0, version_1_2_1, version_1_2_0, version_1_1_X, version_1_1_99_5, version_1_1_99_4, version_1_1_99_3, version_1_1_99_2, version_1_1_99_1, version_1_1_99_0, version_1_1_3, version_1_1_2, version_1_1_1, version_1_1_0, version_1_0_99_3, version_1_0_99_2, version_1_0_99_1, version_1_0_99, version_1_0_3, version_1_0_2, version_1_0_1, version_1_0_0, version_0_99_5, version_0_99_4, loncapaMITrelate_1, language_hyphenation_merge, language_hyphenation, bz6209-base, bz6209, bz5969, bz2851, PRINT_INCOMPLETE_base, PRINT_INCOMPLETE, HEAD, GCI_3, GCI_2, GCI_1, BZ5971-printing-apage, BZ5434-fox, BZ4492-merge, BZ4492-feature_horizontal_radioresponse
Bug 840, default spreadsheet should show proper available points on
excused and partially excused problems.

<field col=A row=0>
if ("[stores_0_solved]" eq 'excused') {
    'excused';
} elsif (M0) { 
    if(K0) {
        if (K0 == M0) {
            "correct";
        } elsif (K0 < M0) {
            K0.'/'.M0.' correct';
        } else {
            'correct';
        }
    } else {
        "incorrect";
    }
} else {
    '';
}
</field>

<field col=B row=0>'Tries:'</field>
<field col=C row=0>
if (M0) {
    [&EXPANDSUM(PART;stores_PART_tries)]/M0;
} else {
    '';
}
</field>

<field col=D row=0>'Timestamp:'</field>
<field col=E row=0>[timestamp]</field>
<field col=F row=0>
if ([timestamp]>100000000) { 
    $tmp = localtime([timestamp]); 
    $tmp =~ s/\s/&nbsp;/g;
    $tmp;
} else {
    '';
}
</field>

<field col=G row=0>'Duedate:'</field>
<field col=H row=0>[parameter_0_duedate]</field>
<field col=I row=0>
if ([parameter_0_duedate]>100000000) { 
    $tmp = localtime([parameter_0_duedate]); 
    $tmp =~ s/\s/&nbsp;/g;
    $tmp;
} else {
    '';
}
</field>

<field col=J row=0>'Attempted Parts:'</field>
<field col=K row=0>
[&EXPANDSUM(PART;(stores_PART_solved !~ /^(\W?excused\W?|)$/ ?1:0))]
</field>

<field col=L row=0>'Solved Parts:'</field>
<field col=M row=0>[&EXPANDSUM(PART;(stores_PART_awarded?1:0))]</field>

<field col=W row=0>'Available Points:'</field>
<field col=X row=0>
if ("[stores_0_solved]" eq 'excused') {
    0 
} else { 
    [&EXPANDSUM(PART;parameter_PART_weight*(stores_PART_solved !~ /^\W?excused\W?$/ ? 1 : 0))];
}
</field>

<field col=Y row=0>'Awarded Points:'</field>
<field col=Z row=0>
if ("[stores_0_solved]" eq 'excused') { 
    0 
} else { 
    [&EXPANDSUM(PART;parameter_PART_weight*stores_PART_awarded)]
}
</field>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>