Thread 'ping Ageless: question about wiki RAC spreadsheet'

Message boards : BOINC Manager : ping Ageless: question about wiki RAC spreadsheet
Message board moderation

To post messages, you must log in.

AuthorMessage
ProfileJoseph Stateson
Volunteer tester
Avatar

Send message
Joined: 27 Jun 08
Posts: 641
United States
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 · Report as offensive
ProfileJord
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 29 Aug 05
Posts: 15585
Netherlands
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 · Report as offensive
Richard Haselgrove
Volunteer tester
Help desk expert

Send message
Joined: 5 Oct 06
Posts: 5143
United Kingdom
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 · Report as offensive

Message boards : BOINC Manager : ping Ageless: question about wiki RAC spreadsheet

Copyright © 2025 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.