Janbros' 2-stroke excel for ports, heads and pipes
Moderator: rztom
Janbros' 2-stroke excel for ports, heads and pipes
My newyear's present to you all :
My 2-stroke spreadsheet is ready (for now at least), so I'm throwing it on the net so everybody can use it.
It contains pages for ports, the head and FOS pipe
On the seperate ports pages (exhaust and transfer), it calculates the STA numbers (Specific Time.Area) of your ports and you can matcch them to the target's, determinned by the BMEP
On the Head page, you can design your head and it calculates the MSV (Mean Squish Velocity) 100% accurtly with Blair
On the FOS-pipe page, it calculates a Frits Overmars FOS pipe, and you can ad a Wobbly-duct , and you can add extra header/diffusor/baffle sections to the pipe.
And you can print the final portmap to scale, so you can cut-out the ports, stick in in your cylinder and see where you'll need to grind some more.
you are free to do with it what you want, as long as it is not for commercial use. If somebody has idea's to improve or add extra features, please share so we can all benefit.
In the manual I've tried to explain how it works, please read it first before you ask questions.
25/12/23 :
I've changed my FOS-exhaust page, so it includes the header and diffuser %'s, and some other changes.
excel : https://greentrade.international/Janbro ... ke2.0.xlsm
doc : https://greentrade.international/Janbro ... ke2.0.docx
and a stand alone Exhaust, which has an extra exhaust-comparator sheet
https://greentrade.international/Janbro ... E_3.0.xlsm
My 2-stroke spreadsheet is ready (for now at least), so I'm throwing it on the net so everybody can use it.
It contains pages for ports, the head and FOS pipe
On the seperate ports pages (exhaust and transfer), it calculates the STA numbers (Specific Time.Area) of your ports and you can matcch them to the target's, determinned by the BMEP
On the Head page, you can design your head and it calculates the MSV (Mean Squish Velocity) 100% accurtly with Blair
On the FOS-pipe page, it calculates a Frits Overmars FOS pipe, and you can ad a Wobbly-duct , and you can add extra header/diffusor/baffle sections to the pipe.
And you can print the final portmap to scale, so you can cut-out the ports, stick in in your cylinder and see where you'll need to grind some more.
you are free to do with it what you want, as long as it is not for commercial use. If somebody has idea's to improve or add extra features, please share so we can all benefit.
In the manual I've tried to explain how it works, please read it first before you ask questions.
25/12/23 :
I've changed my FOS-exhaust page, so it includes the header and diffuser %'s, and some other changes.
excel : https://greentrade.international/Janbro ... ke2.0.xlsm
doc : https://greentrade.international/Janbro ... ke2.0.docx
and a stand alone Exhaust, which has an extra exhaust-comparator sheet
https://greentrade.international/Janbro ... E_3.0.xlsm
Last edited by JanBros on Mon Dec 25, 2023 11:41 am, edited 7 times in total.
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
I imagine that was a lot of work for you to create; to freely share it like this is very generous! If I ever get back to the Netherlands, the potato fries and Bosch ball are on me!
Thank you, Wade
Thank you, Wade
85 RZ350 daily rider Toomeys, FZ swinger & wheel, Fox shock, Raasks
85 RZ350 JLs, FZ swinger, Katana rear & CBR929 front wheel, CBR600F4 forks & brakes
75 RD350 Ritter-tuned top end, PWK28s, JLs, HPI, TDR wheels, GSX-R forks, Motolana swinger
85 RZ350 JLs, FZ swinger, Katana rear & CBR929 front wheel, CBR600F4 forks & brakes
75 RD350 Ritter-tuned top end, PWK28s, JLs, HPI, TDR wheels, GSX-R forks, Motolana swinger
Re: Janbros' 2-stroke excel for ports, heads and pipes
"The Land of Francorchamps" in my profile , it doesn't ring a bell ?
Skip the Neatherlands, come to Belgium
Last edited by JanBros on Sun Jan 05, 2020 7:15 pm, edited 1 time in total.
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
oops, seem to have made an error with the links, fixxed it now.
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
The error is mine! I truly should have known, as my wife and I spent a few days in your lovely country on the same trip which took us to the Netherlands. I know a nice place for beers in Brussels!
Apologies, Wade
Apologies, Wade
85 RZ350 daily rider Toomeys, FZ swinger & wheel, Fox shock, Raasks
85 RZ350 JLs, FZ swinger, Katana rear & CBR929 front wheel, CBR600F4 forks & brakes
75 RD350 Ritter-tuned top end, PWK28s, JLs, HPI, TDR wheels, GSX-R forks, Motolana swinger
85 RZ350 JLs, FZ swinger, Katana rear & CBR929 front wheel, CBR600F4 forks & brakes
75 RD350 Ritter-tuned top end, PWK28s, JLs, HPI, TDR wheels, GSX-R forks, Motolana swinger
Re: Janbros' 2-stroke excel for ports, heads and pipes
Thanks much, Jan!
I will try to download and check it out soon.
Looks like an interesting learning tool.
Always appreciate your guidance.
I will try to download and check it out soon.
Looks like an interesting learning tool.
Always appreciate your guidance.
- Questo vecchio rz
- Posts: 1116
- Joined: Sun Aug 16, 2015 5:55 pm
- Location: Reconquista of California
Re: Janbros' 2-stroke excel for ports, heads and pipes
Bravo, A fellow enthusuast, who cares about his friends in the hobby willing to share for all to enjoy.
And not just for minimal profits..
I think many will thank you and your fellow comrades knowledge will live on mechanically in a fair share of 2 strokes around the world.
Nice guy you are.
And not just for minimal profits..
I think many will thank you and your fellow comrades knowledge will live on mechanically in a fair share of 2 strokes around the world.
Nice guy you are.
Banshee (Baja) race bike,+ 2 A Arms,L.E.Ds, Toomey, +4 stroker IMS tank, run flats.
96 GSXR SRAD, Future Yoshimura rep.
85 custom Tri-Z
RZ/YZR bike(project)
86 VFR750 RC24 Merkel replica (project)
Royal Enfield Bullet 500
96 GSXR SRAD, Future Yoshimura rep.
85 custom Tri-Z
RZ/YZR bike(project)
86 VFR750 RC24 Merkel replica (project)
Royal Enfield Bullet 500
Re: Janbros' 2-stroke excel for ports, heads and pipes
it's my feeling it would be outrages to ask money for knowledge from smarter people than me who have shared this knowledge for free, all I've done is bring it together in 1 excel
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
a small error has come up : on the Data page , in cell Q14 both "exhaust new" should be "exhaust old" , so change it yourself or download it
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
some more corrections for "IF" errors in situations I hadn't tested yet, and added a page you can print and take into your shed to write down all the needed input data.
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
Hi,
it's still available?
the 2 links seem not to work
thank you
it's still available?
the 2 links seem not to work
thank you
Re: Janbros' 2-stroke excel for ports, heads and pipes
Good question! Still available?
Not sure that I ever downloaded it, since I don't have home internet.
Now, I have a good laptop for CAD, and I can use the school Wi-Fi.
Not sure that I ever downloaded it, since I don't have home internet.
Now, I have a good laptop for CAD, and I can use the school Wi-Fi.
Re: Janbros' 2-stroke excel for ports, heads and pipes
yes still available.
just clicked on both links and they work.
just clicked on both links and they work.
if it runs, you can race it !
Re: Janbros' 2-stroke excel for ports, heads and pipes
due to a new post from Frits : https://www.kiwibiker.co.nz/forums/show ... r/page2494
new links in first post
I made a small correction to the calculation of the target Bd and transfer STA to get the correct target-value spot-on again with the new BMEP of the RSA
new links in first post
I made a small correction to the calculation of the target Bd and transfer STA to get the correct target-value spot-on again with the new BMEP of the RSA
if it runs, you can race it !