ping Ageless: question about wiki RAC spreadsheet

Author	Message
Joseph Stateson Volunteer tester Send message Joined: 27 Jun 08 Posts: 641	Message 31607 - Posted: 16 Mar 2010, 7:53:01 UTC Jord: I downloaded the excel spreadsheet at http://www.boinc-wiki.info/Recent_Average_Credit and I cannot make it work. All I see is #NAME? indicating an unknown name. I noticed you were listed in the wiki credits as the one to shoot down. Anyway, the following is what I am staring at: so is the spreadsheet broken? ID: 31607 ·

Jord Volunteer tester Help desk expert Send message Joined: 29 Aug 05 Posts: 15483	Message 31609 - Posted: 16 Mar 2010, 9:07:55 UTC - in response to Message 31607. Hmm, you see #NAME, I see #MACRO (In OpenOffice Calc 3.1.1) I haven't a clue. I don't know who made the sheet, but I suspect it's Paul Buck. Even though my name is in the change history, I no longer keep the Unofficial Wiki up-to-date. ID: 31609 ·

Richard Haselgrove Volunteer tester Help desk expert Send message Joined: 5 Oct 06 Posts: 5082	Message 31611 - Posted: 16 Mar 2010, 9:43:10 UTC The problem seems to be in the ROUNDDOWN cells (columns O, T, Y for PC #1, #2, #3 respectively). If you make a trivial edit in, for example, cell O18 - I just put a space at the end - and press enter, it gets recognised (in Excel 2002). Then just drag the corner handle down to replicate the formula down the rest of the column. ID: 31611 ·

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.