modelling a random distribution of pores on a grid

padbadger

New Member
Joined
Jan 31, 2005
Messages
1
i have a little problem that i want to write a computer program to solve, but unfortunately I can't program and I was hoping someone could help. I want to randomly distribute circular objects which are 30nm in diameter (they are pores in real life) over a grid (modeling a filtering membrane), with a denstiy of 6 X 10^8 pores/cm^2, then figure out some statistics from the resulting array - such as average inter-pore distance - plus a histogram type plot of inter-pore distance against frequency of occurance.
I will be very grateful for any help.
adam
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
How large is the filtering membrane in cm? Is it square, round, rectangular, eliptical...? If I am reading this correctly -- I think one realitively simple way of doing this is to randomly generate a series of points NxN=N2 (the two space of natural numbers). And then compare their distances using the standard point distance formula D=|x-y| (in this case x and y are vectors in 2-space). If I am understanding you correctly however (entirely possible that I'm not), the average inter-pore distance for any given pore its average distance from all other pores...One problem I see here is that this method could get really hairy as the number of pores increases. You would have to take the distance of each pore from every other pore, so the more pores you have -- the larger the number of calculations. The other problem I see is that most random number generators assume a probability distribution or use a somewhat predictable algorithm to begin with, so your ramdomly generated points, aren't truely random. Anyways, its certainly possible, but it would be nice to know more details about the application -- i.e. what question are you really looking to answer. Hope this helps in some way.
 
Upvote 0

Forum statistics

Threads
1,214,643
Messages
6,120,702
Members
448,980
Latest member
CarlosWin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top