Hi guys,I was wondering if any of you have implemented or have an idea on how to solve this as I have been stuck with this for 2 days. I have to read an excel sheet and I wan't to rewrite some tables. Most of the code is working fine, but there is a table with about 106 columns which is giving me problems. The keys are the columns and the values are the columns that the given column needs to make the operation in the excel formula.For example (I attached an image as well):B => CC => CD => B....I => C, K , IJ => C, K, B, AJ, AKK => C, H, CKexampleThe problems as I said is that I'm not able to calculate the values starting from column "I" as the formula depends on the values from "K" which depends on the values from the column "CK" (C and H can be calculated) and CK has more dependencies and it just keeps spreading.I mapped all the element with it's dependencies, so I was trying to implement an algorithm that told me the path needed to solve the variables (like first solve CK => K => I), that is find the origin or the first column that has no dependencies to be calculated.Does anybody has any suggestion?Thanks!
Submitted August 05, 2020 at 01:23AM by AlanArg12
No comments:
Post a Comment