I am working on designing and creating a solar powered car for the Solar Car Challenge. The car will have to race from Dallas, TX to Minneapolis, MN in 5 days (~5 hours of driving a day) along back roads. My team is still in the planning/concept generation phase and I'm in charge of designing the solar array. To begin designing, I need to first know how much power the car will consume per hour.
My textbook gives the power consumption of a car as $$ P_{w} = F_{foward}v = (F_{roll}+F_{air})v $$ where $F_{roll} = \mu_{r}mg$ and $F_{air} = (1/2) C_{d}A\rho v^2 $. I'm assuming a rolling resistance coefficient of 0.017, a drag coefficient of 42, and the estimated mass and frontal area of the car are 275 kg and 2.45 m$^2$, respectively. I thought a good way to estimate the minimum required speed $v$ would be to get the elevation of the route (Google Maps with "avoid highways and toll roads" selected) at various points and plug it into the formula above.
Using this elevation finder, I was able to get the elevation at a certain distance for ~27,000 points and export the data into Excel. If I understand correctly, $V(t)$ would be given by $$ V(t) = \frac{\left(\sum _{n=1}^{27298}\sqrt{dx^2+dy^2}\:\right)}{dt} $$
Where $dx$ is a change in horizontal distance, $dy$ is a change in elevation, and $dt$ is change in time. I have the data and I have the equation, but I'm not sure how to convert this into something that Excel can use to get my speed.
Here is the spreadsheet of all the data points.