Cyber Blue 234 robot weights calculator

[Chris Fultz]

Here are some feature of the latest update:

There are three sections:

1. Section for everything CyberBlue has weighed.
This section is locked except for quantity that you add.

2. Section for new items that you and others send to us to add.
This secrion is locked except for quantity that you add.

3. Section for you to add your own items. Calculation is there,
but you add description, weight per, quantity.

The weight is total ed in 3 cells
1. From the CyberBlue generated sections
2. From the user defined section
3. Total of #1 & #2 above.

As we add new items, we WILL NOT increase the location or values of any of the items in Section 1. This way, if we release an update, you will be able to cut and paste your existing data into the new file and the cells will align.

If we make a correction, we will fix the error cell and add a note to indicate what was changed.

I would recommend you put in a freeze at row 6. That will keep the column identifiers visible as you scroll down the file. We will add this feature in on the next update.

Please advise of any items we need to add for other teams to use and any error you find.

[Matt Adams]

I tried to send a number of obvious corrections to the email address supplied a couple of days ago, and evidently in this newest update changes were not made. To ensure that teams have accurate information, I've listed a few things that need revision. I would still consider this calculator to be in it's testing stages... I think that this is a great start to what could be a wonderful tool for teams, but the amount of responsibility for something like this is VERY large. I'm sure that 234 is doing it's best to keep all of the information as accurate as possible.

Corrections needed:

All of the 1/16 and 1/8 aluminum angle they list have no dimensions for the leg lengths... which makes these unusable.

1/4" bolts... 1.5 inch weighs almost 3 times as much as a 1.00 inch bolt? It's only 1/3 longer...

Lexan... how can 3/16 inch lexan weigh 33% of 1/8 inch?

In addition, there's a number of weights that only have a single significant digit to them, such as the drill motor and its transmission. It would be nice to have this weight more accurate than to the nearest pound.

Overall, good job.. but since there are significant errors in some of the components, I'm worried about what I can use with 100% confidence...

Check and double check, and then repost. I'm VERY excited to see the final product!

Matt

[Robo-Knights]

Originally Posted by David Kelly

The students from Cyber Blue 234 have come up with a weights calculator for teams to use this season. Although the calculator is far from the goal that we would like to have it at, its a great start for this season. With this calculator, you will be able to easily track the weight of your robot before it is even put together. This calculator will only be able to track more parts with your help! If you have a part that you would like to see put onto the calculator, please send all the necessary info to weights@cyberblue234.com If you are able to take a picture of the item, that would also be great for when this database plans to be a website based version next year. You may download the calculator here


Please send all questions and queries to weights@cyberblue234.com as they will be able to answer any questions, and not me.


Give it a try!!

Thanks for this great contribution.

[JAH]

Thanks for all of the good comments. We should be coming out with another update soon so keep checking! Thanks!

Weights Team

[djcapelis]

I really don't see the point in holding the cells locked and protected...

Can't you just copy and paste that data out anyways? I mean... if you can use the spreadsheet you shouldn't have a hard time taking all the useful stuff and copying it into something you can write too... so it seems the protection is quite useless.

So why protect your document for no appearent reason and make it harder for teams to use it? I mean, don't get me wrong, I think it's a great thing you're doing here, but your urge to control the information seems odd to say the least.

[Collin Fultz]

the reasons for locking the cells have been posted earlier in this discussion. if you have a problem with it, take the time to weigh everything yourself. for those willing to accept that the cells are locked and (wether they agree with the locking or not) continue to use the weight calculator, we wish you the best of luck with this year's robot!

[djcapelis]

Originally Posted by collin234

the reasons for locking the cells have been posted earlier in this discussion. if you have a problem with it, take the time to weigh everything yourself. for those willing to accept that the cells are locked and (wether they agree with the locking or not) continue to use the weight calculator, we wish you the best of luck with this year's robot!

Don't flip out, I'm just wondering as to your reasoning really... why would you need to "protect the integrety" of the spreedsheet? I mean, the official copy would obviously be posted by your team. It's seems a bit odd to post something but not allow people to modify it for their own uses or help you correct it.

I appreciate the work your team is doing, I'm just questioning why you're securing the content. If I didn't appreciate your work I would have posted the unprotected copy that I just created.

[JAH]

Originally Posted by djcapelis

It's seems a bit odd to post something but not allow people to modify it for their own uses or help you correct it.

There is a user defined section allowing you to input whatever you'd like and have it calculated into the total amount so you can make it for your own uses. If need be, add more rows and extend the code however far you need. If there are any corrections needed, please email them to weights@cyberblue234.com so that everyone who downloads a copy can have the corrections, not just your team. Thanks!

-Weights Team

[Matt Fultz]

"Cyber Blue 234" is written everywhere on the weight calculator. It is property and a product of Cyber Blue team 234. That is why we lock all cells that we feel don't need changing, as to protect our name and our team in a product that we have made.

We leave space for personal team adding, and we are willing to make all changes addressed.

Matt Adams-
I personally apologize for the delay of your changes. These have been made in the recent update, and it will be posted very soon. Thank you for bringing those, and more in the future, to our attention.

Thanks to all who have helped on the correction of database, and please keep the corrections coming.

Thank you

[JAH]

Update posted! Check out the newest version of the database. We've gone back and fixed the errors that we have received and added a few more things of our own. Let us know what you think! weights@cyberblue234.com

Thanks!
-Weights Team

See signature for link!

[JAH]

Another update posted. We were told that there was some trouble in opening the latest version of the database on computers running Windows 2000, ME, 97, etc. That should be fixed and there are a few new items that we input. If anyone really has any items they are putting on theirs, email them to us so we can put them on the master. weights@cyberblue234.com

Check signature for link!

-Weights Team

[Joe Ross]

Originally Posted by JAH

Another update posted. We were told that there was some trouble in opening the latest version of the database on computers running Windows 2000, ME, 97, etc. That should be fixed and there are a few new items that we input. If anyone really has any items they are putting on theirs, email them to us so we can put them on the master. weights@cyberblue234.com

I can't open the latest version on windows 2000 with Excel 2000. I hadn't tried any of the other ones, so I don't know if this is a new problem or not.

[JAH]

I've reuploaded the file again. It is being saved as a Microsoft Excel 97-2002 & 5.0/95 Workbook. That should work. If it isn't, I'm not exactly sure why this isn't working so please let me know if you have any idea on how to fix the problem. Thanks.

-Weights Team

[Joe Ross]

Originally Posted by JAH

I've reuploaded the file again. It is being saved as a Microsoft Excel 97-2002 & 5.0/95 Workbook. That should work. If it isn't, I'm not exactly sure why this isn't working so please let me know if you have any idea on how to fix the problem.

Still won't open for me. However, I was able to open it in gnumeric on linux, so it must be triggering some type of odd bug in excel or windows.