Janbros' 2-stroke excel for ports, heads and pipes

General forum on engines, transmissions, gearing and modifications to each

Moderator: rztom

Message
Author
User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Janbros' 2-stroke excel for ports, heads and pipes

#1 Post by JanBros » Sun Jan 05, 2020 2:42 pm

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.

Image

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 !

85RZwade
Posts: 396
Joined: Tue Nov 12, 2019 5:49 pm
Location: Southwet Washington

Re: Janbros' 2-stroke excel for ports, heads and pipes

#2 Post by 85RZwade » Sun Jan 05, 2020 3:32 pm

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
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

User avatar
kobra
Posts: 798
Joined: Sun Sep 16, 2018 12:53 am
Location: Bay Area CA

Re: Janbros' 2-stroke excel for ports, heads and pipes

#3 Post by kobra » Sun Jan 05, 2020 4:43 pm

Wow.

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#4 Post by JanBros » Sun Jan 05, 2020 7:11 pm

85RZwade wrote: Sun Jan 05, 2020 3:32 pm 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
"The Land of Francorchamps" in my profile , it doesn't ring a bell ?
Skip the Neatherlands, come to Belgium :smt002
Last edited by JanBros on Sun Jan 05, 2020 7:15 pm, edited 1 time in total.
if it runs, you can race it !

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#5 Post by JanBros » Sun Jan 05, 2020 7:14 pm

oops, seem to have made an error with the links, fixxed it now.
if it runs, you can race it !

85RZwade
Posts: 396
Joined: Tue Nov 12, 2019 5:49 pm
Location: Southwet Washington

Re: Janbros' 2-stroke excel for ports, heads and pipes

#6 Post by 85RZwade » Sun Jan 05, 2020 8:21 pm

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
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

User avatar
Smoker
Posts: 4784
Joined: Sun Mar 23, 2008 8:08 pm

Re: Janbros' 2-stroke excel for ports, heads and pipes

#7 Post by Smoker » Tue Jan 07, 2020 6:22 pm

Thanks much, Jan!

I will try to download and check it out soon.

Looks like an interesting learning tool.

Always appreciate your guidance.

User avatar
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

#8 Post by Questo vecchio rz » Fri Jan 10, 2020 10:58 pm

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.
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

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#9 Post by JanBros » Sat Jan 11, 2020 8:26 am

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 :smt002
if it runs, you can race it !

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#10 Post by JanBros » Sat Jan 11, 2020 9:51 pm

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 !

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#11 Post by JanBros » Mon Jan 13, 2020 4:52 pm

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 !

jacky71
Posts: 1
Joined: Sat Apr 30, 2022 2:05 pm

Re: Janbros' 2-stroke excel for ports, heads and pipes

#12 Post by jacky71 » Sat Apr 30, 2022 5:41 pm

Hi,
it's still available?
the 2 links seem not to work
thank you

User avatar
Smoker
Posts: 4784
Joined: Sun Mar 23, 2008 8:08 pm

Re: Janbros' 2-stroke excel for ports, heads and pipes

#13 Post by Smoker » Sat Apr 30, 2022 9:03 pm

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.

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#14 Post by JanBros » Sun May 01, 2022 12:49 pm

yes still available.
just clicked on both links and they work.
if it runs, you can race it !

User avatar
JanBros
Posts: 197
Joined: Tue Jan 20, 2015 8:18 pm
Location: The Land of Francorchamps

Re: Janbros' 2-stroke excel for ports, heads and pipes

#15 Post by JanBros » Mon Oct 24, 2022 3:22 pm

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
if it runs, you can race it !

Post Reply