since I need to wind some coils for a project, I made some calculations using a well known formula that I found on web (see the attached Inductors Formulae.doc), but suddendly I though that a spreadsheet is more useful than tampering with pocket calculator.
Then I did it (see Coil_calc.JPG).
The first sheet allows you to insert coil winding data (fields in green): no. of turns, coil support diameter, wire size, number of paralleled wires (close wound) and turns spacing. On yellow and orange fields you'll find computed results.
In the second sheet (see Res_by_turns.JPG) you'll find a table that, given the data entered in the first page and the number of turns from 0,25 to 51 in 0,25 turns step, returns the following parameters:
- coil inductance
- coil lenght
- total lenght of wire
The file is an excel spreadsheet that you'll find in the zip file Cylindrical coil calculator.zip attached here.
The sheet cells are protected (except those in green where you enter parameters) to avoid accidental modifications, but you can unprotect and modify the sheets as you like.
I'ts not a very big contribution, but I hope it is a tool that can save you some time in designing coils.