A third-order upwind scheme for the advection-diffusion equation using spreadsheets

摘要: In this study, numerical solution of advection-diffusion equation with third-order upwind scheme by using spreadsheet simulation (ADE-TUSS) is carried out. This a user-friendly and flexible algorithm for the one dimensional (ADE). The ADE-TUSS based on description ADE (TU) advection term second-order central finite representation. For governing equations, (SS) technique used instead conventional techniques. can be obtained explicit, implicit Crank-Nicolson schemes only changing values temporal weighted parameter in algorithm. It clear literature that diffusion causes great deviations model results when first- or are used. order to decrease obtain oscillation free results, an artificial usually defined sizes time step and/or grid set small values. Reduce increases computational generally requires writing fairly complex code high However, taking into account TU has been out iterative proposed simulate transient solution, simple macro carries cycle help VBA feature spreadsheets. One most important advantages it does not require matrix algebra at each solutions. test model, two examples having analytical solutions solved. Results showed use high-order very applicable ADE. Moreover, problem drastically prevented model.