Hello, friends
This Excel tool can be used to calculate the dimensions of the trapezoidal paper strip segments necessary to obtain geometric solids with radial symmetry, according to Ricardos method.
For now, two types of paper-roll-built solids can be obtained:
Domes (hemisphere, ellipsoid, deformed ellipsoid, paraboloid, cone ) To be used e.g. as inner supports for petal constructions in missiles, fuel tanks, bombs, torpedos, radial engine crankcases;
Wheels (flat rim + tire with circular section) Good for most WWI/WWII aircraft, and probably also for other uses (Vespa scooters maybe);
Variants/enhancements will follow soon. Ricardo uses some other shapes which are a little more complex.
I did my best to make the tool easy to use. It contains some notes and schemes drawn inside., for guidance. There is also some error checking to call your attention to mistakes and make sure that feasible measurements and options are being input. The generated data is also plotted to help visualize the final rolled shape and the set of paper strip segments.
As most of us use standard A4/letter home printers, the size of the paper limits the width of the paper strip segments. The two worksheets marked with (C) will calculate dimensions for sets of paper strips with a fixed, constant segment width (your choice). Example: for A4 (297 mm x 210 mm) I usually set this to 280 mm. All segments will be 280 mm in width.
If you have access to large-format printers/plotters, you may want to use the worksheets marked with (P). These calculate the data for a fixed number of paper segments (your choice), but with variable size. Example: I want exactly 15 segments for my shape. Segment width varies from segment to segment and some of these may be 500 mm in width.
Confused? Just have a look at the plots each worksheet generates.
Once the data is generated, you can use any CAD software you like to draw the trapezoids according to the calculated dimensions and send the drawings to a printer.
Any question? We can discuss in this thread, or just drop me a PM.
Regards
João
PS: The Excel file is totally harmless for your PC/Mac.
This Excel tool can be used to calculate the dimensions of the trapezoidal paper strip segments necessary to obtain geometric solids with radial symmetry, according to Ricardos method.
For now, two types of paper-roll-built solids can be obtained:
Domes (hemisphere, ellipsoid, deformed ellipsoid, paraboloid, cone ) To be used e.g. as inner supports for petal constructions in missiles, fuel tanks, bombs, torpedos, radial engine crankcases;
Wheels (flat rim + tire with circular section) Good for most WWI/WWII aircraft, and probably also for other uses (Vespa scooters maybe);
Variants/enhancements will follow soon. Ricardo uses some other shapes which are a little more complex.
I did my best to make the tool easy to use. It contains some notes and schemes drawn inside., for guidance. There is also some error checking to call your attention to mistakes and make sure that feasible measurements and options are being input. The generated data is also plotted to help visualize the final rolled shape and the set of paper strip segments.
As most of us use standard A4/letter home printers, the size of the paper limits the width of the paper strip segments. The two worksheets marked with (C) will calculate dimensions for sets of paper strips with a fixed, constant segment width (your choice). Example: for A4 (297 mm x 210 mm) I usually set this to 280 mm. All segments will be 280 mm in width.
If you have access to large-format printers/plotters, you may want to use the worksheets marked with (P). These calculate the data for a fixed number of paper segments (your choice), but with variable size. Example: I want exactly 15 segments for my shape. Segment width varies from segment to segment and some of these may be 500 mm in width.
Confused? Just have a look at the plots each worksheet generates.
Once the data is generated, you can use any CAD software you like to draw the trapezoids according to the calculated dimensions and send the drawings to a printer.
Any question? We can discuss in this thread, or just drop me a PM.
Regards
João
PS: The Excel file is totally harmless for your PC/Mac.
Aucun commentaire:
Enregistrer un commentaire