DIY Constant Height > DIY Screen Curve Calculator (Aussie Bob)

[edit 3-28-2011]

Tony sent me email Fri 3/25 asking his excel file be removed, "Aussie Bob's Omni-CIH Calculator.zip", it had 909 views.

I'm not sure what happened, but I am honoring his request.

Prior thread:

Tony gave "ok", I attach it for download.

File is at bottom of this 1st post, after Tony's comments.

Mod - can you make this a sticky thread?

Tony sent me email Fri 3/25 asking his excel file be removed, "Aussie Bob's Omni-CIH Calculator.zip", it had 909 views.

I'm not sure what happened, but I am honoring his request.

Prior thread:

Tony gave "ok", I attach it for download.

File is at bottom of this 1st post, after Tony's comments.

Mod - can you make this a sticky thread?

Quote:

From: Tony D

Sent: Tuesday, February 03, 2009 3:06 AM

To: R, Mike

Subject: Re: fwd to others or you prefer not? RE: Spreadsheet

Mike,

Nice to hear from you. Distribute away. As long as they have an idea of where it originally came from it saves me a lot of work.

I'd like to see your extensions. Mine were a bit clunky.

Cheers,

TONY.

From: Tony D

Sent: Tuesday, February 03, 2009 3:06 AM

To: R, Mike

Subject: Re: fwd to others or you prefer not? RE: Spreadsheet

Mike,

Nice to hear from you. Distribute away. As long as they have an idea of where it originally came from it saves me a lot of work.

I'd like to see your extensions. Mine were a bit clunky.

Cheers,

TONY.

Quote:

________________________________________

From: R, Mike

Sent: Monday, February 02, 2009 10:14 AM

To: 'Tony D'

Subject: fwd to others or you prefer not? RE: Spreadsheet

Tony;

How are you?

A few guys on AVS forum have recently inquired to your spreadsheet, I've NOT fwd to them because it's not my IP (Intellectual property), are you OK if I privately email them?

Or is there some other reason I should be aware of? I'll respect your wishes.

I used it for my DIY screen and added some calculations to the bottom to help calculate the different distances to the screen for making standing support blocks.

I was going to post that in my Build thread for others usage.

____________________________________

Michael R P.E.

________________________________________

From: Tony D []

Sent: Thursday, January 10, 2008 6:59 PM

To: R, Mike

Subject: Spreadsheet

Mtbdudex,

Herewith the spreadsheet...

For the pincushion and curvature spreadsheet, make sure you select "Home Theatre" (1) from the System Box. Enter "1" for "Home Theater" in cell B25.

If you're familiar with either the SOLVER or the GOAL_SEEK functions of Excel, you can start out with the pincushion and, say, screen height and then work back to the throw distance (or vice versa if you have the throw distance). I've used these functions to verify that the calculations work (and they do seem to).

Dont forget: throw length is from the projector lens, not the anamorphic lens.

The calculator was actually originally written to calculate screen curvature. Pincushion was part of the solution, so I included that formally in the results box.

*******************

You'll also notice a multi-colored box adjacent to the results area. It's an experimental formula I'm trying out to calculate anticipated pincushion percentage directly from just the Throw Ratio. So far it's given pretty accurate results, but raising the TR to the power of 1.9-something-something, needs a sophisticated calculator anyway. The alternative formula is simpler, but less accurate, particularly down the low TR end of the scale. Ignore both if you want to, the figure given in the calculator proper is the most accurate

*******************

Get-one-free-get-another-one-free Dept.: I've also sent as "Sheet #2" my spreadsheet for calculating the tilt and yaw angles to which you'll need to set your anamorphic lens if the projector is installed off-axis from the screen's centre point.

You'd be amazed the difference getting these angles right can make to screen geometry, especially if your projector is mounted significantly off-centre to the screen. Trying to get these angles correct by trial and error is frustrating. You get one end right and the other end drifts out. You get the tilt right and the yaw goes off-centre. Maddening!

You need a good starting point. The angles calculated by this tilt and yaw angle spreadsheet are just the ticket for this. Hint: you can usually get away with calculating the tilt and then getting the yaw right by eye. Sometimes when projectors are installed substantially off center-screen - left or right by more than a foot - the angles change a little as there's a keystone effect (despite offsettable projector lenses) which stretches the picture horizontally more than you can easily predict. The tilt, however, remains pretty accurate.

Advantages when you get your angles right:

1. Best focus across the screen

2. Minimize Pincushion

3. Maximize image symmetry

... quite important, in my book, and a lot of HT fans suffer from these without realising what they're missing out on by not having the accurate angles set for their lens.

Rgds,

TONY D (aka Aussie Bob),

Sydney,

________________________________________

From: R, Mike

Sent: Monday, February 02, 2009 10:14 AM

To: 'Tony D'

Subject: fwd to others or you prefer not? RE: Spreadsheet

Tony;

How are you?

A few guys on AVS forum have recently inquired to your spreadsheet, I've NOT fwd to them because it's not my IP (Intellectual property), are you OK if I privately email them?

Or is there some other reason I should be aware of? I'll respect your wishes.

I used it for my DIY screen and added some calculations to the bottom to help calculate the different distances to the screen for making standing support blocks.

I was going to post that in my Build thread for others usage.

____________________________________

Michael R P.E.

________________________________________

From: Tony D []

Sent: Thursday, January 10, 2008 6:59 PM

To: R, Mike

Subject: Spreadsheet

Mtbdudex,

Herewith the spreadsheet...

For the pincushion and curvature spreadsheet, make sure you select "Home Theatre" (1) from the System Box. Enter "1" for "Home Theater" in cell B25.

If you're familiar with either the SOLVER or the GOAL_SEEK functions of Excel, you can start out with the pincushion and, say, screen height and then work back to the throw distance (or vice versa if you have the throw distance). I've used these functions to verify that the calculations work (and they do seem to).

Dont forget: throw length is from the projector lens, not the anamorphic lens.

The calculator was actually originally written to calculate screen curvature. Pincushion was part of the solution, so I included that formally in the results box.

*******************

You'll also notice a multi-colored box adjacent to the results area. It's an experimental formula I'm trying out to calculate anticipated pincushion percentage directly from just the Throw Ratio. So far it's given pretty accurate results, but raising the TR to the power of 1.9-something-something, needs a sophisticated calculator anyway. The alternative formula is simpler, but less accurate, particularly down the low TR end of the scale. Ignore both if you want to, the figure given in the calculator proper is the most accurate

*******************

Get-one-free-get-another-one-free Dept.: I've also sent as "Sheet #2" my spreadsheet for calculating the tilt and yaw angles to which you'll need to set your anamorphic lens if the projector is installed off-axis from the screen's centre point.

You'd be amazed the difference getting these angles right can make to screen geometry, especially if your projector is mounted significantly off-centre to the screen. Trying to get these angles correct by trial and error is frustrating. You get one end right and the other end drifts out. You get the tilt right and the yaw goes off-centre. Maddening!

You need a good starting point. The angles calculated by this tilt and yaw angle spreadsheet are just the ticket for this. Hint: you can usually get away with calculating the tilt and then getting the yaw right by eye. Sometimes when projectors are installed substantially off center-screen - left or right by more than a foot - the angles change a little as there's a keystone effect (despite offsettable projector lenses) which stretches the picture horizontally more than you can easily predict. The tilt, however, remains pretty accurate.

Advantages when you get your angles right:

1. Best focus across the screen

2. Minimize Pincushion

3. Maximize image symmetry

... quite important, in my book, and a lot of HT fans suffer from these without realising what they're missing out on by not having the accurate angles set for their lens.

Rgds,

TONY D (aka Aussie Bob),

Sydney,

Note: I've seen people referred to this thread a few times lately. Note that there is a newer version. I don't have permission to share though, sorry.

I've PM'd Tony and got his ok to post, here is the DIY Screen Curve Calculator file again.

Aussie Bob's Omni-CIH Calculator.zip 12k .zip file

Aussie Bob's Omni-CIH Calculator.zip 12k .zip file

What do I need to do to open a zip file on an andriod device?

Winzip un-archive app to excel compatible reader app. Search in your android store.

Better yet, do it instead on laptop/desktop to really grasp the information.

There are formulas, etc, not sure if those work on your device.

Do you have access to computer?

Via my 32GB iPhone4 using Tapatalk

Better yet, do it instead on laptop/desktop to really grasp the information.

There are formulas, etc, not sure if those work on your device.

Do you have access to computer?

Via my 32GB iPhone4 using Tapatalk

Will try it at work.

My PC at home is NFG. Somehow I got locked out of my own PC.

My PC at home is NFG. Somehow I got locked out of my own PC.

anyone know how to calculate the distance from the chord to the curve at various points along the chord? other than the middle

i started to tape some grid paper together to make a 1/10scale drawing...but it will still be a lot of grid paper!

i started to tape some grid paper together to make a 1/10scale drawing...but it will still be a lot of grid paper!

Quote:

It's kinda buried in my build thread, http://www.avsforum.com/t/1029683/diy-curved-screen-with-structural-extruded-aluminum-metal-framing/30#post_15302528

Download the excel file in that post, the tab "Pincushion & Screen Curvature" I added my trig 101 to the bottom of it:

paper and pencil

input into excel file

Post pictures of your build in your thread!

I have just sent this as a challenge to some friends...my math-foo has been exchanged for google-foo...in the off chance they succumb... Can you help me calculate a few depth measurements along the chord?

What? Revoke your DIY card!!

Use this, it's on the web, free.

http://planetcalc.com/1421/

Use this, it's on the web, free.

http://planetcalc.com/1421/

Quote:

Can calculate area, arc length,chord length, height and perimeter of circular segment by radius and angle.

This torus all most made me turn it in in 2004!

http://www.avsforum.com/avs-vb/showthread.php?threadid=467141

http://www.avsforum.com/avs-vb/showthread.php?threadid=467141

How the find the angle! Then I'm set