NOTE THAT THIS SPREADSHEET IS NOT TO BE CHANGED AS OF FEB 17. CONTACT JOEL IF YOU THINK YOU NEED TO CHANGE SOMETHING

1.1 Nosecone Harness

JC 2023/01/10

JG asked JC and he said we can assume center of section

*FY 2023/01/12 **RK 2023/02/05

Solidworks

*FY 2023/01/12 **RK 2023/02/05

*FY 2023/01/12 **RK 2023/02/05

Solidworks

*FY 2023/01/12 **RK 2023/02/05

Solidworks

*FY 2023/01/12 **RK 2023/02/05

*FY 2023/01/12 **RK 2023/02/05

Solidworks

RK 2023/02/05

Measured

Measured

JC 2023/01/08

Measured from KotS

JC 2023/01/14

1.4 Nosecone Structure

Weighed KotS nosecone (note that whatever was left of the entire nosecone assembly was weighed including things like the shearpin coupler and eye bolt) **Roman subtracted those out. 1.86-0.45-0.25-0.19

Guess from Cycle 1

Solidworks

Guess based on Solidworks, The coupler won't be getting any smaller, this is the weight of existing

*FY 2023/01/12 **RK 2023/02/05

previous was 0.38, new will be getting longer and a bit bulkier for the connector

*FY 2023/01/12 **RK 2023/02/05

Guess based on solidworks

Solidworks

Measured KotS design

20% more than KotS

JC 2023/01/08

Measured from KotS

JC 2023/01/14

2.1 Recovery Harness

Included in electrical sled estimates

Included in electrical sled estimates

Included in electrical sled estimates

JC 2023/01/10

JG asked JC and he said we can assume center of section

Measured

Measured

CS 2023/01/12

CS 2023/01/12

2.3 Recovery Bulkhead

2.3.1 Recovery Electrical Sled

Estimate based on high level design

Measured equivalent KotS design

JC 2023/01/10

its below the bulkhead, so this is bulkhead distance + guess

CS 2023/01/12

possibility if we get shock cord reduced

if no shock cord reduced, same as last year

theoretrical increase if we get new heavier equipment, but unlikely

CS 2023/01/12

CS 2023/01/12

Bulkhead + eyebolt

Measured Sept, going to become heavier

Measured + increase due to slipring +Included

Estimated worst case

CS 2023/01/12

its at the bottom of the tube, so parachute bay length

CS 2023/01/12

2.4 Parachute Bay Bodytube

Parachute bay bodytube

Solidworks

Solidworks

**RK 2023/02/07 FY 2023/01/13

Bulkhead Upper Coupler

Solidworks

Solidworks

**RK 2023/02/07 AL 2023/01/13

Shear Pin Coupling Ring

Solidworks

Guess based on geometry

3.1 Payload Bay Harness

Measured KotS design

Measured KotS design

JG asked JC and he said we can assume center of section

JD 2023/01/08

Based on conceptual design

JD 2023/01/08

Most of this will probably be dead mass we add on at the end because boards aren't heavy ;-;

JD 2023/01/08

Middle of cubesat

RK 2023-01-15

Pulled from cycle 1 as rough guess

Pulled from cycle 1 as rough guess

Pulled from cycle 1 as rough guess

JG 2023/01/13

RK 2023-01-15

KOTS body adjusted for length

Rough Solidworks Estimate

Payload Adapter Ring #1

Solidworks

Solidworks

Payload Adapter Ring #2

Solidworks

Solidworks

Payload Mount Plate

max increase

Same as shear rign

Payload Shear Ring

Solidworks

Solidworks

Bulkhead Lower Coupler

Solidworks

Solidworks

AL 2023/01/13

Bottom Doubling Ring

Rough design

RK 2023-01-15

4.1 Feedsystem Harness

Hand Calculations on preliminary design

Hand Calculations on preliminary design

JG asked JC and he said we can assume center of section

Design CAD, from Xavier

Estimate upper

SW Mass Evaluation

Old vent valve mass

Guess based on old vent section cad, same as cycle 1 valve. NOTE** Roman made this negative

4.2.2 Vent Section Pneumatics

Estimate of weight of desired pneumatic valve plus manifold plus 0.1 lbs of pneumatic tubing (valve weight found here https://cdn.automationdirect.com/static/specs/gvpminisolvalves.pdf)

Estimate of weight of desired pneumatic valve plus manifold plus 0.1 lbs of pneumatic tubing (valve weight found here https://cdn.automationdirect.com/static/specs/gvpminisolvalves.pdf)

old pneumatic solenoid

Guess. Should be closer to vent bulkhead than vent valve . NOTE** Roman made this negative

4.2.3 Vent Section Electronics

Took one plate from last years design

Took both plates from last year

Hand calculations

Hand calculations

JG asked JC and he said we can assume center of section, JG guessed the crap out of it. NOTE** Roman made this negative

Measured

Measured

JG asked JC and he said we can assume center of section, JG guessed the crap out of it. NOTE** Roman made this negative

Oxidizer Pressure Transducer

Measured

Measured

JG asked JC and he said we can assume center of section, JG guessed the crap out of it as very light . NOTE** Roman made this negative

Oxidizer Plumbing (Incl. Pressure relief valve, burst disk, fittings, and tubes)

Guess (many tubes and fittings will be omitted with new vent bulkhead)

old vent section minus old bulkhead, old vent valve, PCBs, pressure transducer, pneumatics https://waterloorocketry.slack.com/archives/CCWGTJH7F/p1655157232152589

Guess based on old vent section cad, same as cycle 1 valve. NOTE** Roman made this negative

53.75" tank (corresponds to 220 s Isp)

61.78125" tank.

61.78125" tank. Will not get any longer than currently quoted (design lock for length)

half expected tank length

RK 2023/02/05

Printed design, less one oring groove (might cut it off)

Printed design

current, from Zach

end of ox tank+1.2 inch

RK 2023/02/05

Fill plumbing (incl. 2x QC stem fittings, NPT-swage adapter, tube, check valve)

Current design for printed bulkhead

Current design for printed bulkhead

Current design for printed bulkhead

Center of BH

RK 2023/02/05

4.3.1 Injector Valve

SF7 part + some

end of ox tank + 3.5" bulkhead + half 1.1" stem

RK 2023/02/05

can shave around 10-25% of the mass off

MZ, 2023-01-10

MZ, 2023-01-10

Current ground prototype mass with no modifications

MZ, 2023-01-10

end of ox tank + 3.5" bulkhead + 1.1" stem + half of 2.5" valve

RK 2023/02/05

SF7 part + some

end of ox tank + 3.5" bulkhead + 1.1" stem +2.5" valve + half of 2.7" length

RK 2023/02/05

4.3.2 Injector Section Pneumatics

RK 2023/02/05

4.3.3 Injector Section Electronics

Injector Section Electronics Sled

Fasteners rough guess

Fasteners rough guess

RK Set to BH COM

Hand calculations

Hand calculations

**RK Set as center of Fill BH section JG asked JC and he said we can assume center of section, JG guessed the crap out of it as very light

Measured

Measured

**RK Set as center of Fill BH section. JG asked JC and he said we can assume center of section, JG guessed the crap out of it as very light

Hand calculations

Hand calculations

**RK Set as center of Fill BH section. JG asked JC and he said we can assume center of section, JG guessed the crap out of it as very light

Measured

Measured

Set to be just aft of fill BH COM

JG 2023-01-16

4.3.4 Combustion Pressure Plumbing

Combustion Pressure Transducer

Measured

Measured

**RK Fixed to be just aft of IJ bulkheadJG asked JC and he said we can assume center of section, JG guessed the crap out of it as very light

RK 2023/02/05

Combustion Pressure Tube & Fittings

RK 2023/02/05

4.4 Oxidizer Tank Aft Skirt

4.4.1 Rocketside Electrical Disconncet

Guess for small mount

Guess for small mount

Same as longeron

4.4.2 Fill Disconnect Hatch

RK Set to BH COM

Expected value with a 0.95 factor

Require 6.45" longeron, assumed expected case at 3000 lb per longeron. Actually kept same cross sectional area as 2023

Expected value with a 1.5 factor

Guess based on geometry

RK 2023-01-16

Solidworks

Solidworks

RK 2023-01-16

5.1 Combustion Chamber

Guess we could save 10% tops of mass from current CAD

Current design

Possibly gets slightly heavier for airframe interfaces (longerons, fin can)

Injector bulkhead screws

Current design

Unlikely to get heavier

Current design

Unlikely to get heavier

Combustion Chamber Casing

Guess we could save 10% tops of mass from current CAD

Current design

Possibly gets slightly heavier, mostly due to machining tolerances

No unburnt fuel

Small amount of unburnt fuel (SF8 worst case)

Combustion Chamber Liner

Current design

Unlikely to get heavier

Pre-combustor (ignition puck assumed zero)

Guess we could save 25% of mass from current CAD

Current design

Unlikely to get heavier

Current design

Unlikely to get heavier

Current design

Unlikely to get heavier