[LON-CAPA-users] (no subject)

[Gerd Kortemeyer]

Hi,

Maybe try the builtin function int:

int(0.5+1000.*$z)/1000.

- Gerd.

> On Nov 2, 2015, at 5:13 PM, Rex Abert <ABERTR at tcc.fl.edu> wrote:
> 
> Mark-
> 
> I've tried that.  The function &roundto($x,$n) works fine in problem scripts, but returns "undefined" in the spreadsheet.
> 
> Rex Abert
> Associate Professor of Mathematics
> Tallahassee Community College
> ________________________________________
> From: lon-capa-users-bounces at mail.lon-capa.org [lon-capa-users-bounces at mail.lon-capa.org] on behalf of Lucas, Mark [lucasm at ohio.edu]
> Sent: Monday, November 2, 2015 5:01 PM
> To: Discussion list for LON-CAPA users
> Subject: Re: [LON-CAPA-users] (no subject)
> 
> Rex,
> 
> There is a function: roundto(x,n)  available in perl safe space within the coding of a
> problem. You might try it to see if it works in the spreadsheet.
> 
> $y = &roundto($z,3);
> 
> will round z to 3 decimal places.
> 
> Later,
> Mark
> 
> 
> On Nov 2, 2015, at 4:40 PM, Rex Abert <ABERTR at tcc.fl.edu> wrote:
> 
>> I have a question about rounding values to, say, 3 or 4 digits in the spreadsheet.  I've come up with the following hack that does the job, but i was wondering if there was a more elegant (built-in?) way to do it.
>> 
>> 
>> $x = &SUMSEQ("T","regexp:Homework")/&SUMSEQ("S","regexp:Homework")*100;
>> $x *= 1000;
>> $x = int($x);
>> $x /= 1000;
>> $x;
>> 
>> In the above code, columns S and T contain points available and points earned, depending on whether the due date has passed or not.
>> 
>> Rex Abert
>> Associate Professor of Mathematics
>> Tallahassee Community College
>> _______________________________________________
>> LON-CAPA-users mailing list
>> LON-CAPA-users at mail.lon-capa.org
>> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
> 
> --
> Mark Lucas                                                              email: lucasm at ohiou.edu
> 252D Clippinger Lab                                             phone: (740)597-2984
> Department of Physics and Astronomy                     fax: (740)593-0433
> Ohio University
> Athens, OH 45701
> 
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users at mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users at mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users

--
Gerd Kortemeyer, Ph.D.
Associate Professor of Physics
Director, LON-CAPA Project
Michigan State University
http://www.msu.edu/user/kortemey/