No, this isn’t that impressive. That’s the point. Programming in Excel is not that difficult.
The integration is just Euler integration. Collisions are done with precomputed normals (the normals are computed in Matlab and imported as data into Sheets 3 and 4). The collisions aren’t exact which is why at higher timesteps the particles noticeably interpenetrate the terrain.
The actual Excel macros only handle the drawing and copying the new (x,y, dx, dy) as the starting state for the calculation.
View detailed instructions here: https://spreadcheaters.com/how-to-add-and-subtract-multiple-cells-in-excel/
In this video we discuss how to subtract a cell, or actually a cell value from a column or row in an excel spreadsheet. We go through a detailed example step by step. Transcript/notes Let’s say that you want to subtract a cell value from an entire column, such as in this example excel spreadsheet,…
Subscribe Now: http://www.youtube.com/subscription_center?add_user=ehowtech Watch More: http://www.youtube.com/ehowtech Subtracting a percentage in Microsoft Excel is something that is accomplished by comparing the values of two distinct cells in a table. Subtract a percentage in Microsoft Excel with help from a professional programmer, designer, and developer in this free video clip. Expert: Geoph Essex Filmmaker: Victor Varnado Series…