Basic Math - Google Sheets for AEC
The video tutorial demonstrates basic math functionality using a spreadsheet, specifically Google Sheets, to manipulate data for mathematical calculations. The example involves calculating rock elevation by subtracting rock depth from surface elevation. The process begins by typing an equals sign in a cell to initiate a formula, selecting cell E3 for surface elevation, entering a minus sign, and then selecting cell F3 for rock depth. Pressing enter calculates the result. The formula can be copied to other cells by dragging, which automatically adjusts cell references. If formatting is overwritten, it can be restored using the paint format tool. The tutorial emphasizes that the method can be adapted for different calculations, such as determining surface elevation from rock elevation and depth by adding the respective values. The focus is on simple math operations like addition and subtraction, highlighting the versatility of spreadsheets in handling various data sets and calculations. The tutorial aims to provide a foundational understanding of using formulas in spreadsheets to derive new data from existing information, catering to users who need to perform basic mathematical operations in their data analysis tasks.
On this page of the site you can watch the video online Basic Math - Google Sheets for AEC with a duration of hours minute second in good quality, which was uploaded by the user AEC Software Technology 11 November 2024, share the link with friends and acquaintances, this video has already been watched 25 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
