Spreadsheet for Folded Horn Layouts...

[Brian Steele]

Introducing BOXPLAN-BP8P. This BOXPLAN assists in the design of an 8th order BP alignment for a given driver. Note that the workbook is definitely still in "beta", so if you come across any bugs, please let me know ASAP.

 

[Brian Steele]

...and for version 0.2, I've added the option to have one or two drivers, and the layout and calculation for Lp2 is done a bit differently (the layout assumed for the previous version of the workbook results in a value for Lp2 that's too long to be useful).

 

[maxolini]

Post a copy of the BOXPLAN.TXT export file created by the workbook.

ID=BOXPLAN
Ang=2.0 x Pi
Eg=2.83
Rg=0.1
Fta=0
S1=180
S2=181
Par=0.1
F12=0
S2=181
S3=450
Par=103.1
F23=0
S3=450
S4=1610.1
Par=33.3
F34=0
S4=1610.1
S5=900
Par=18.6
F45=0
Sd=908
Bl=23.19
Cms=0.000053
Rms=3.4
Mmd=153.6
Le=1.51
Re=5.5
TH=1
Vrc=0
Lrc=0
Ap1=0
Lp=0

 

[Brian Steele]

Brian,
when i import a driver from HR on the cubo spreasdheet
i get the below error


View attachment 1290702

Ok, I think I misread your message - it's an issue with trying to import Driver data? Is it happening with one Driver, or all Driver data that you try to import from HR?

 

[maxolini]

All of em

 

[Brian Steele]

Interesting. I'm not sure what could be causing that. The other macros in the workbook function without issue?

 

[maxolini]

Actually not, if I change the size of the box to accommodate a 15 driver ,when I click optimize until the red numbers go away, the layout change too small making the driver outside the cabinet