You install excel, you put in formulas by selecting a cell and typing "=" Then it calculates things. If you ask more specific questions, you can get more specific answers.
If you ask more specific questions, you can get more specific answers.
Or you can wait a while Tomas and maybe someone won't give you such a smartass answer in the Newbie forum and might actually say something constructive and helpful.
I would suggest joining a team or obtaining a mentor.
Providing direct calculations of any kind is technically against the rules as it is openly discussing game mechanics. Not allowed.
I will say that excel / google sheets is a good place to start - collect and organize your data and see what works for you and develop some regression analysis to create equations.
Joining a team will allow you access to a larger breadth of data! There are also some public data sources out there if you search!
please, how to make a simple calculator for calculating data in MS Excel?
There isn't, really, if you need to ask this.
Is GPRO Organiser still a thing? Starting up, for me it was a great way to capture data that I had no idea how to use, and use data I had no idea how to capture.
Greg gave great advice, if only that was the OP's question. He didn't ask anything regarding "direct calculations" rather he asked how to setup a calc in excel
Is GPRO Organiser still a thing? Starting up, for me it was a great way to capture data that I had no idea how to use, and use data I had no idea how to capture.
This was good for me too, but I don't know if it's still around either. Handwritten data collection is good too as it sort of drills the knowledge into you a bit like revision notes back in the day. Also don't forget if you have supporter status all your past data is available for you within the game.
Hi, please, how to make a simple calculator for calculating data in MS Excel? thanks for the tips
Hey mate
Excel is a good place to start when it comes to transforming data. Key word there is start. Once you get very good, handling lots of data is a bit impractical in excel so you would jump ahead from there to other options (google is your friend there).
When I wanted to become better at excel itself, I found this site: https://exceljet.net/
Some of its guides include template sheets which guide you through different functions. Start simple, and work your way to a higher level over time. Excel is very easy to do fairly complicated things because there's no 'syntax' (programming code), think of it as a foot in the door to developing a decent programming & analysis skillset...
For the raw basics, press the windows key + left (or right) with excel & this video on split screen:
Best bit of advice yet as regards to the original question Luke, well done. And I thought (according to Ilia) all you had to do was select a cell, type =, and that was it, job done without even entering any data!
@David Andrewartha (A38) You do realise Ilia missed a step or two in the explanation. i.e. 'Select a cell = 'Select a function' : SUM/ AVG Select data etc. However, even that is not enough to complete a calculation. Just a few steps more... best learned from Excel Tutorials.
Tomas to help you on your way, after the race, download the race analysis as an Excel sheet. (Bottom of laps shown) Do this before the next race since you are not a supporter you don't have a record of the analysis beyond that.
Record all the other data on the race analysis. I copy/paste use Word document for the file.
Yes, it's still around. Has some bugs for some people, but I'm using it to collect data for now, until I get my own tool off the ground. If I remember correctly, the guy maintaining GPRO Organizer is working on a complete rewrite as a browser-based (but not web-based, so hopefully no data leaks) tool.
You do realise Ilia missed a step or two in the explanation.
Yeah, that was my point mate. I always think if you can't say something helpful when someone asks for advice it's far better to say nothing than to take the piss out of them.
=VLOOKUP —> reads values from tables based on a particular row =IF —> changes the output of a cell based on whether a condition is true or false. Can be embedded multiple times eg =if(A1=1,if(…))