We report results from a survey on spreadsheet use and experience with textual programming languages (n=49). We find significant correlations between self-reported formula experience, programming experience, and overall spreadsheet experience. We discuss the implications of our findings for spreadsheet research and end-user programming research, more generally.

Time series of topographic data are becoming increasingly widespread for monitoring geomorphic activity. Dense 3D time series are now obtained by near-continuous terrestrial laser scanning (TLS) installations, which acquire data at high frequency (e.g. hourly) and over long periods. Such datasets contain valuable information on topographic evolution over varying spatial and temporal scales. Current analyses however are mostly conducted based on pairwise surface or object-based change, which typically require the selection of thresholds and intervals to identify the processes involved and fail to account for the full history of change. Detected change may therefore be difficult to attribute to one or more underlying geomorphic processes causing the surface alteration. We present an automatic method for 4D change analysis that includes the temporal domain by using the history of surface change to extract the period and spatial extent of changes. A 3D space-time array of surface change values is derived from an hourly TLS time series acquired at a sandy beach over five months (2967 point clouds). Change point detection is performed in the time series at individual locations and used to identify change processes, such as the appearance and disappearance of an accumulation form. These provide the seed to spatially segment ‘4D objects-by-change’ using a metric of time series similarity in a region growing approach. Results are compared to pairwise surface change for three selected cases of anthropogenic and natural processes on the beach. The obtained information reflects the evolution of a change process and its spatial extent over the change period, thereby improving upon the results of pairwise analysis. The method allows the detection and spatiotemporal delineation of even subtle changes induced by sand transport on the surface. 4D objects-by-change can therefore provide new insights on spatiotemporal characteristics of geomorphic activity, particularly in settings of continuous surfaces with dynamic morphologies.