Help duplicating a calculator into Excel

[rham243]

Can anyone help me in duplicating the following calculator in Excel or at least point me in the right direction? Anything helps, thanks in advance!!

http://www.ajoster.com/resources/coil-calculator

[candybg]

Sure. You'll need some data (ie weights of each material per specific measurements). Other numbers can be calculated from that, except for the relationship between the coil diameter and the length or weight of the material. I'd guess the second would require some knowledge or understanding of calculus.

[ben_hensel]

Dynamic Dropdowns for the unit & material selections, driving into different lookup tables using INDEX(MATCH), multiplied by a unit conversion if necessary.

Manual input where necessary. All of that feeds into the output value calculations.

Wrap =IF(ISBLANK, "", calculation) to keep the output calculation cells empty until you've got enough data, if you'd like.

[mehmetcik]

Does the existing calculator work?

If your tape is 200m lomg and 1mm thick the cross sectional area

Please Login or Register  to view this content.

metres sq

Coliled up that means Pi x r^2 = 0.2

Please Login or Register  to view this content.

= Diameter in millimeters

Please Login or Register  to view this content.

The calculator returns:- 71mm when you use a spool of diameter 50mm

[mehmetcik]

Does the existing calculator work?

If your tape is 200m lomg and 1mm thick the cross sectional area

Please Login or Register  to view this content.

metres sq

Coliled up that means Pi x r^2 = 0.2

Please Login or Register  to view this content.

= Diameter in millimeters

Please Login or Register  to view this content.

The calculator returns:- 71mm when you use a spool of diameter 50mm


Assuming Copper C102 and a tape width of 1000mm
Volume

Please Login or Register  to view this content.

So weight

Please Login or Register  to view this content.

g / m^3 = 8941kg/M^3

Please Login or Register  to view this content.

= 1788 Kg

Calculator returns: 17883422.1



Enter 200 into the coloured text box.

I have only programmed that one textbox of the four optional boxes.

I will do the rest once someone checks my math.

[mehmetcik]

I just realised that a tiny modification of the code will dramatically improve the Userform.

When Testing to see if textboxes 5 to 8 are empty.
Instead of simply exiting, set the WFlag to 0 and then exit.

I have no VBA or even Excel here. I am crippled.