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 firstname.lastname@example.org 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 email@example.com as they will be able to answer any questions, and not me.
DUDE! Nice contribution from the team! I’m sure that instead of people deciding to drill holes (AKA - Swiss Cheeseing it) they will be able to keep track of their weight during the build - instead of after!
Surgeon General Warning - “Swiss Cheesing” has been noted to cause losses, structural failure, and even total robot failure. Please refrain from drilling holes into your robot to help keep weight down.
Thanks. We hope to someday get around to making it an add in on our team website. If anyone has anything that they use and think other teams might even consider using, if you could, please weigh it(in pounds) and the appropriate unit(per inch, per square inch, etc.) and email it to firstname.lastname@example.org and it’ll be put on the database and updated so that it is a better utility for everyone. Thanks! :]
Very cool, guys! This will be so useful for anyone trying to put together a BOM for their team, too. I’ve been putting the robot BOM together for 93 since 2001 and could’ve used something like this awhile ago!
I’ve used a spreadsheet like this for several years. It is also helpful to have a weight budget for sub assemblies and track them separately. I would suggest posting a unprotected version so that new components can be changed or added pending the contents of the kit. Also, tracking assemblies of custom parts is very useful.
CyberBlue: could you please post the ‘protection’ password? There are other pieces that are not on that list that teams might use. Such as different types of extruded aluminum. Bosch, 80/20, and IPS don’t weigh the same, and a method 470 uses (what we call “cored IPS”) to lighten IPS also isn’t listed.
When I was in high school (a long long time ago in a galaxy far away…) I worked for an auto parts store that had an actual tester for these devices that charged them up to full charge. We sold Delco parts and this part was from the Delco Remy line. After testing we would throw them to each other as a joke. Just one of the things that contributed to the callouses on my hands.
We are sorry for the delay of the Weights Databse v 2.1. We wanted to make sure that all new kit parts were weighed, minus the parts the we were missing from FIRST. The new version contains 2 locked sections holding parts the people submit to be posted on the new database, as well as an unlocked section where individual teams may add their own parts and weights to their downloaded databases.
This version will be posted very shortly, I promise. Please continue to email email@example.com with parts and weights (and short descriptions if possible) that you would like to be put on the new database.
PLEASE NOTE: With the new version, parts would placed in their respective categories, so amounts are NOT “pasteable” from v1 to version 2.1. However, with all v.2’s, amounts will be pasteable from one update to the next. The new parts that firstname.lastname@example.org recieves will be added at the end of the last locked category, so only those amounts will need added.
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.
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.
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!
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.