Google Sheets OPR Calculator

Gracious professionalism is competing with a team one minute, and helping them fix their robot the next. It is cheering for FIRST, rather than just your team, and most importantly: it is looking at the future and saying, "Together, we can do that" - WakeZero [more]

		Chief Delphi > FIRST > General Forum
Google Sheets OPR Calculator

Thread Tools

Rate Thread

Display Modes

#14

25-10-2016, 22:17

Ether

systems engineer (retired)

no team

Join Date: Nov 2009

Rookie Year: 1969

Location: US

Posts: 8,088

Re: Google Sheets OPR Calculator

Quote:

Originally Posted by Ether

There should be no looping involved.

Here's some pseudo-code which creates A, b, and T with one non-looping pass thru the 8column data

I just ran that code on my 10-year-old desktop PC using a simple non-compiled (scripting) language.

It took 220 milliseconds to read your 8column data (102 teams and 204 matches)
from a disk file and populate A, b, and T.

I would hope Google's scripting language could do the same in a comparable time.

Last edited by Ether : 25-10-2016 at 22:30.

« Previous Thread | Portal | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump

All times are GMT -5. The time now is 10:41.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.