Forum Discussion
Data help
It's hard even to know where to start. For one thing, you know what that picture shows, but it's not really clear to someone seeing it for the first time. Is it representative of what you have--a separate sheet like that--on each of the 500 individual kids in your program? And is it where you enter the data? Or is it some kind of output or summary display that then gets turned into a progress chart by that laborious process you speak of?
What you need probably isn't a formula so much as a whole revamping of how your collect and store the indicators--i.e., the raw data--of how they're proceeding in connection with the various goals.
Excel is really good at creating summary reports--whether tabular or graphic--but works far better when working with a clean database. That is counter-intuitive to people who are used to laying things out in a reporting format right from the start [which is what it looks like you have here, though that may be an incorrect interpretation].
Is it in any way possible to upload a representative sample of the actual workbook, different spreadsheets (if there are different formats or different parts to this whole)...after first removing any actual names of individuals? That would give us a better starting point than the image by itself. I'm sure there are people here who can help. What you face, though--and you realize this--is potentially a pretty massive task.