Thank you Frank.
There is a bit of theory behind size, focal length and "sharpness" or circle of confusion (CoC). I usually skip it and use a calculator on the net. Mr Pinhole for example. Why? well read on and you will see.
In general however, a pinhole doesn´t focus or have a focal plane as such. Any size (as long as it small enough compared to the film/paper format and focal length) will work. However the so-called CoC is relative to the pinhole size, so a smaller pinhole will normally give sharper pictures. However you do get diffraction with pinholes too, so you need to make sure the material you punch a hole in is ideally no thicker than the diameter of the pinhole, preferably much less. Also, a smaller hole will give longer exposure times, so there is no easy way out. Another issue is the focal length and coverage. A shorter focal length has less coverage. Two of my cameras have focal lengths of 85-90mm. This will have an image circle of less than 170mm. Which is one reason one gets vignetting, the other being that since there is no optical correction, the edges of the frame will get less light, (in effect have a different focal length than the centre) and therefore experience fall-off. Curved film plane will help a lot on the latter, and a bit on the former).
A calculator will give you a size relative to the focal length. The shorter the focal length the smaller the hole. 90mm focal length, a hole of 0.300mm to 0.400mm is normal. The f-stop is a factor of focal length over aperture. So 0.300mm will give an f-stop of approx 300. That is 7.5 stops slower than f16
So I upped mine to 0.500mm Not as sharp, but an f-stop of 170 approx is two stops faster, which helps.
How to make a hole? I use a soft drink/soda can. I put a small dent in it with a ball head hammer, then I sand the dent down as far as I dare (600-1200 grit). Then find a small needle and rotate it whilst putting pressure on it centre of dent. Sand a bit more, and repeat. Eventually a hole will appear. Make sure that there are no burrs. I measure the size and just how much it resembles a circle with a scanner. I set it to a factor of 2541dpi (1x254i or 2x2541, 3x or 4x - depending on scanner resolution). But lets say I use 2541dpi. 2541dpi equals 100 pixels pr mm. So a hole 50 pixels across is 0.500mm.
This is the scan of the pinhole in the pano camera: