Ive been trying to get a spreadsheet going on google sheets to calculate dollar values according to my own altered versions of the depth charts projections. Ive finally figured out all the maths involved in actually calculating dollar values, but now im stuck on the formatting of the spreadsheet, particularly linking the sheet with the value calculations to the sheet with the projections.
Since the depth charts projections are listed with FG Id's i was wondering how you actually link them to Ottoneu ID's instead, as i believe many people do that and it is a much easier way of doing it. Currently my spreadsheet pulls the projections based on FG ID's and it is a bit of a mess which ive spent a lot of timing cleaning up already but want to ask if there is an easier way.
So basically all im asking is how people use the combination of ID's in their spreadsheets. And also the formulas you use (ie VLOOKUP to link from one sheet to another).
Sorry about the extended message, and if i dont make any sense haha