design of conical gears with straight teeth with agma regulations

[simonededonno]

good afternoon, I am a mechanical engineering student I am carrying out a thesis under construction of machines and I have to make a calculation sheet with excel concerning the design of straight toothed conical wheels using the agma regulations.
My main problem is the poor resource of material. I only have the text shigley project and construction of machines, mcgraw-hill.
in the tense for dense conical wheels refers to the legislationansi/agma 2003-b97.
There's someone who has more material about it.
I look forward to your answers, thank you in advance

 

[meccanicamg]

on the shigley's mechanical enginering design find everything you can miss, being a manual of Anglo-Saxon origin.
for what you lack of geometry you can use niemann elements of machines 3.

at the end after you have calculated the various geometric sizes steps to the calculation of resistance/duration and you can make a calculation excel like this:this is the result of a conical couple z1=20 z2=40 m=3 b=22mm pressure angle 200 and input 5kw at 1000rpm and the axes placed at 900 among them in 18crnimo7-6 cemented and hardened.

 

[simonededonno]

thanks to the answer, the spreadsheet you published can have?

 

[meccanicamg]

thanks to the answer, the spreadsheet you published can have?

Unfortunately, no... because it's part of a very big project and it turns out complicated.
But I gave you all the information from where I recovered the formulas. ..just put them together and get a working spreadsheet.
especially for the fact that you have to learn, I would say that the ready jelly is against the principle of teaching.
ask questions, ask for solutions, then valuate.

 

[meccanicamg]

You got it? do we want to compare the results? Have you had a chance to get into it?
or... the meteor fell?