Search the Community
Showing results for tags 'spreadsheet'.
Found 1 result
For capturing high-resolution multispectral images of a 19th century landscape painting (36 x 50 inches), I found it helpful to create a spreadsheet for planning purposes, and also to supplement the shooting notes as a record of what was done. To get complete coverage of the painting at the desired resolution for RTIs and photogrammetry (500 ppi for RTIs, and up to 2600 ppi for certain details), it was necessary to take a series of overlapping images. The spreadsheet takes basic information about the object (size, material, UV sensitivity), camera and lens (format, sensor and pixel dimensions, focal length, and settings), and calculates various parameters (working distances for the camera sensor and light source, minimum size of the reflective spheres, number of images, and storage requirements) for the project, given the desired target resolution and various wavebands (UV, visible, and IR) to be captured. This information is useful for estimating the space and time requirements for capturing RTIs and photogrammetry. Since the painting is on the east coast of the U.S. and I'm in California, it was important to have a good understanding of these parameters before shipping equipment across country and for arranging studio space in which to do the work. The spreadsheet was also helpful for selecting the macro lens for the project. The storage requirements are based on a RAW image file size of 20 Mb (a slight overestimate for my 16 Mp camera) and don't take into consideration the processed file sizes. For example, generating .dng files with embedded RAW images approximately doubles the RAW file size, and exporting .jpg images adds approximately 50 percent to the storage. The final processed .ptm and .rti files range from approximately 250 Mb to 350 Mb per RTI, so accordingly, additional storage will be needed to process the files. The spreadsheet only estimates the storage needed for RAW image acquisition. Another variable is the amount of overlap for the images. For general imaging and RTIs at a given resolution, the spreadsheet uses 10 percent overlap, and for photogrammetry, it uses 66 percent overlap for the camera oriented horizontally. The spreadsheet calculates the distance to shift the camera in horizontal and vertical directions to get complete coverage of the object. It assumes three images per position for photogrammetry (horizontal and two vertical orientations) and 36 images per position for RTIs. These parameters can be adjusted for particular project needs. The input parameters are entered into the spreadsheet using metric units. A companion worksheet mirrors the format of the metric spreadsheet and automatically converts all the distances from metric to English units, for convenience. An example of the spreadsheet is attached, showing the calculations for this project. [see update below.]