The invention discloses a method for calculating a
harmonic constant of tide short-term
observation data based on Excel, and relates to the technical field of
ocean tide analysis. According to the method, a simple, convenient and efficient tidal
harmonic constant calculation scheme is provided through an Excel
matrix function and a least square method principle, and the method is particularly suitable for
processing short-term tidal
observation data. The method comprises the following specific steps: establishing a basic parameter input interface, a calculation area interface and a result display interface in an Excel worksheet; inputting constant parameters,
observation time and
tide level data; calculating a basic astronomical element, a sub partial tide coefficient, an astronomical
phase angle, a quasi-
harmonic partial tide amplitude coefficient and a
lag correction value through an Excel formula; and constructing a
tide level linear equation and solving a contradictory equation set, and finally outputting harmonic constants (amplitude H and
lag angle g) of each partial tide. The method is simple and convenient to operate and high in calculation efficiency, does not need to depend on professional
software, reduces the use threshold, and is suitable for non-professionals to quickly and accurately carry out tidal
harmonic analysis.