A tool for expanding and exporting compact Excel databases – Standard operating procedure and application to the CSIAPS database


  1. Nandlall, S.D.
Corporate Authors
Defence Research and Development Canada, Ottawa Research Centre, Ottawa ON (CAN)
The Commercial Satellite Imagery Acquisition Planning System (CSIAPS) is an application designed by Defence Research and Development Canada (DRDC). CSIAPS assists collection managers in planning acquisitions of satellite images and Automatic Identification System (AIS) ship navigational data. The database of platform parameters used by CSIAPS is currently updated at DRDC using a shared Excel file containing multiple spreadsheets. Since many satellites and sensors share similar properties—particularly those from the same vendor or constellation—it is desirable to reduce repetitions in this Excel file in order to minimize file size and manual error. However, the CSIAPS application is designed to ingest data that is normalized and atomic, which makes it difficult to create a compact Excel file in cases where much of these data are repeated. This document describes a tool that allows the DRDC Excel database of platform parameters to be expressed in a compact (but non-atomic) format and automatically exported to a normalized (but larger) version for ingestion into CSIAPS. The syntax for expressing data in compact form within Excel is described, followed by a standard operating procedure for exporting the compact database into a normalized form that can be imported into CSIAPS. The tool described herein could also be adapted to expand other compact Excel spreadsheets before being sent to a larger database or service.

Il y a un résumé en français ici.

CSIAPS;(Commerical Satellite Imagery Acquisition Planning System);database;macro;VBA (Visual Basic for Applications);satellite;sensor;beam
Report Number
DRDC-RDDC-2017-D144 — Reference Document
Date of publication
01 Dec 2017
Number of Pages
Electronic Document(PDF)

Permanent link

Document 1 of 1

Date modified: