Question

Using VBA in excel, Consider a city like Manhattan where avenues run north-south and streets run east-west. Suppose it is a 7 x 10 grid, so there are 70 grid points each marked by an x coordinate and a y coordinate (from (0,0) to all the way to (6, 9). We are interested in the following question: if we locate a fire station at point (i, j), how many points can a truck sent from the station reach within 3 minutes if each unit length takes 30 seconds to travel (north-south or east-west)? Your program should take the location as an input and the number of reachable points in the grid should come out as output.

Answer 1