topic Re: Setting up a large set of parameters correctly the first time in Fusion Design, Validate & Document Forum

Setting up a large set of parameters correctly the first time

Anonymous — Sun, 01 Jul 2018 23:20:06 GMT

Watch out, its another guitar question. Guitar makers have some specific geometry that has to work out. There are many ways to calculate the math and it starts from Pythagoras. Basically, if you have a string of a given length, SL, then the notes are placed along the string by a formula. This is easy to calculate in Excel. I have been trying for a few hours to import a file into Fusion with the Parameter I/O app. It keeps giving me an error no matter how I prepare the file. Updating this from a file would save tons of tedious data entry. All I can think of is there have never been any user values entered in this model. Do I have to hand create all of these Names then update the values by importing the .csv?

index error - list index is out of range

My .csv file looks like this:

Fret 1	mm	35.92 mm
Fret 2	mm	33.904 mm
Fret 3	mm	32.001 mm
Fret 4	mm	30.205 mm
Fret 5	mm	28.510 mm
Fret 6	mm	26.910 mm
Fret 7	mm	25.400 mm
Fret 8	mm	23.974 mm
Fret 9	mm	22.628 mm
Fret 10	mm	21.358 mm
Fret 11	mm	20.160 mm
Fret 12	mm	19.028 mm
Fret 13	mm	17.960 mm
Fret 14	mm	16.952 mm
Fret 15	mm	16.001 mm
Fret 16	mm	15.103 mm
Fret 17	mm	14.255 mm
Fret 18	mm	13.455 mm
Fret 19	mm	12.700 mm
Fret 20	mm	11.987 mm
Fret 21	mm	11.314 mm
Fret 22	mm	10.679 mm
Fret 23	mm	10.080 mm
Fret 24	mm	9.514 mm
Fret 25	mm	8.980 mm
Fret 26	mm	8.476 mm
Fret 27	mm	8.000 mm
Fret 28	mm	7.551 mm
Fret 29	mm	7.128 mm
Fret 30	mm	6.727 mm
Fret 31	mm	6.350 mm
Fret 32	mm	5.994 mm
Fret 33	mm	5.657 mm
Fret 34	mm	5.340 mm
Fret 35	mm	5.040 mm
Fret 36	mm	4.757 mm

Re: Setting up a large set of parameters correctly the first time

Anonymous — Sun, 01 Jul 2018 23:30:13 GMT

Ah, the first field needs a comment.

Re: Setting up a large set of parameters correctly the first time

etfrench — Mon, 02 Jul 2018 01:48:24 GMT

Can you use the formula directly in Fusion 360 instead of importing as a CSV?

Re: Setting up a large set of parameters correctly the first time

Anonymous — Mon, 02 Jul 2018 02:58:59 GMT

No the formula is (String Length-Sum(previous frets))/17.817 (The modern version of the Rule of 18). I tried. Even having 70 parameters in a drawing slows my computer drastically. I can imaging if the formulae were more complicated.

Re: Setting up a large set of parameters correctly the first time

etfrench — Mon, 02 Jul 2018 04:50:18 GMT

It's too bad none of the patterns can use a formula like this.

Re: Setting up a large set of parameters correctly the first time

HughesTooling — Mon, 02 Jul 2018 10:06:59 GMT

@Anonymous Have you tried Sheeter?

Mark

Re: Setting up a large set of parameters correctly the first time

HughesTooling — Mon, 02 Jul 2018 10:21:51 GMT

@Anonymous What does your CSV file look like, have you tried a simple export import just using a couple of parameters in Fusion.

My test worked fine importing into an empty file, this is what was in the CSV file.

"Test1","mm","10 mm",""
"Test2","deg","10 deg",""
"d3","mm","70 mm",""
"d4","mm","50 mm",""

Note model parameters are converted into user parameters when imported into a new design.

Mark