Still hoping for this!!
Just go to the Data tab and enter in the stats for any motor you want, and they will populate in the drop down cells for each tab you use.
Does anyone have a google sheets version of the calculator available? My school issued laptop doesn’t currently have Office on it
i got you.
edit: shared it with you on your gmail…
Alternatively, the calculator made by Aren Hill and Dillon Carey is native to google sheets and its pretty useful too. FRC Mechanical Design Calculator (By Dillon Carey and Aren Hill)
You can just download it and then upload it to your Google Drive. No need to have Office locally.
Hadn’t tried it yet but wanted to ensure it doesn’t lose any functionality.
If you’re having trouble figuring out the download links (stats show most people don’t use the date-codes to figure out what the LATEST version actually is)…
I’m planning to keep the links at https://johnvneun.com/calc updated.
I just fixed them to reflect the changes to Chief Delphi.
I have plenty of updates to the sheet halfway done, but my 2018 “got away from me” due to some job changes. My ambitions keep seeming to over-reach my capability. (maybe this is a good opportunity for me to remind myself to “build within my limits.”)
JVN’s calculator works fine after import in my experience. Some of the image/text formatting goes weird is all, don’t let that scare you.
The iterative-calculators for sprint distance that Ari and Alpard have built in Excel (at separate times) do not work in Google Docs. Fortunately, Aren & Dillon’s calculator is native to Docs and does Follow SPang’s link above.
Aren & Dillon’s calculator goes into significantly more depth, so I find JVN’s easier to teach with more inexperienced students - basically, JVN makes a larger number of invisible assumptions, on things that don’t matter to >95% of teams, so we can move faster to answer questions like “what gears do I need to use 6” wheels to move 14fps" instead of getting side tracked on exact DC wire sizes and run lengths.
Is there a spreadsheet calculator with 3 Neo as an option? Has anyone created one? Please share it if you have
JVN Calc.xlsx (1.4 MB)
Please see attached.
As the first page says – Note, this calculator is provided as a design reference ONLY.
Great! Thanks so much.
I think it’s worth mentioning that @JVN has announced he will be making no further updates to the calculator.
As someone who has maintained something far more frivolous for almost (but not quite) as long, thank you for the years of maintaining a cornerstone of the semi-enlightened-or-better robot designer world.
Hi everyone, I’m now using this Design Calculator to make an Intake but I have the question about how to obtain de Drag Load on Intake Mechanism, I don’t understand what it is and how to calculate it
In most cases (as in when you’re picking up an object off a flat floor) this will just be the weight of the object. If it’s on a incline, the drag load will be smaller, but it’s really just safest to put this value at the weight of the object.
The bottom line is this value is going to be nearly impossible to actually calculate. It’s very dependent on the geometry of your intake, the object you’re trying to intake, and a few thousand other factors.
My suggesting for calculating intakes is to look at the mechanism’s free speed. The rule of thumb is you want it to be at least double the speed of your drivetrain so you can intake while driving at full reverse (instead of having to wait to finish intaking before beginning to reverse). Then as long as you have a reasonable amount of power, you should be fine.