solvent | A calculator with equations and variables | Apps library

I have data from multiple suppliers which I wish to compare. The data shown in the image below has been previously transformed via a series of steps using power query. The final step was to pivot the Supplier column (in this example consisting of X,Y,Z) so that these new columns can be compared and the maximum value is returned.

How can I compare the values in columns X, Y and Z to do this? Importantly, X Y and Z arent necessarily the only suppliers. If I Add Say A as a new supplier to the original data, a new column A will be generated and I wish to include this in the comparison so that at column at the end outputs the highest value found for each row. So reading from the top down it would read in this example: 3,3,1,1,5,0.04,10 etc.

Thanks

Link to file https://onedrive.live.com/?authkey=%21AE_6NgN3hnS6MpA&id=8BA0D02D4869CBCA%21763&cid=8BA0D02D4869CBCA

M Code:

Background: The table below contains example data from relevant documents (the names of documents are MSDS, RMQ, COA, Technical Data sheet) for materials A,B,C etc. The information from these documents includes the date, Heavy Metal impurities and Residual Solvent impurities and their amount in ppm (parts per million).

Using power query I have sorted this data so that the 2 tables shown in the image below are produced.

These containing the highest amounts of heavy metals (blue) and residual solvents (yellow) found across the documentation as well as source of the document containing this value. To replicate the spreadsheet I have provided the (quite extensive) M code at the bottom. Very Briefly though for this problem; "Heavy Metals" and "Residual Solvents" are phrases used as delimiters to split the data accordingly.

Minor Problem: Although pleased with how the table functions, I didn't feel that the 'splitting of a split column' (see M code) is an entirely satisfactory solution to separate the data. Subsequently I've realised that If a cell were to accidently not include "Heavy Metals" as a delimiter the logic would cause the Residual Solvent data for this cell to be lost (as is the case for Cell 4E (Material C, technical data Sheet)).

I may just insist to those using this spreadsheet to ensure these phrases are always present however I wanted to ask here to see if anyone had any clever alternatives to the M Code provided so that although the Heavy Metals may be missing without the delimiter (or if spelled incorreclty), the Residual Solvents are still pulled through.

I appreciate that this is rather a tasking job for someone to look at, and fortunately it is a relatively minor issue so any advice would just be a bonus. I also just through it was quite quite interesting to show how power query can be used to split seemingly complex data within a cell. Also please note that the Data in the table is 'messy' to test if this causes any problems.

M Code: This is the Code for just the Residual Solvents Table. Power query splits the data into heavy Metals and Residual Solvents and then depending on the table removes the appropriate columns.

I have a one-column CSV. Each cell has a large text that's the source code from a page in a database of company descriptions (I'm only including a small portion of the text, it's more extensive.) There are about 30,000 cells/companies in the CSV.

https://bern.korea.ac.kr/pubmed/32818866

I have a csv that contains the names of the samples at the first line of the file which I would like to return to a list in order to rename the experimental data that comes later. The file essentially looks like this for the first two lines:

I've tried using a few different methods but just can't seem to figure it out.

Here is my data:

I have a function with an argument. This argument needs to be one of two kind of interfaces. So i write it like this:

No problems to speak of and nor am I currently a user. I am seeing advice on the best implementation practice for flowsheet models. Is there a framework to create custom flowsheet objects in GEKKO/chemical? Is the flowsheet module a mature and equal feature of GEKKO?

I am dealing with a number of applications which would benefit from the ability to inherit flowsheet objects from a yet to be developed custom library, if possible. One such item could be a tubular reactor as described here where it is solved in COMSOL (http://umich.edu/~elements/5e/web_mod/radialeffects/unsteady/index1.htm). Scenarios could involve several unit operations connected in series with recycle streams such as mixer settlers in solvent extraction which also has multiple liquid phases (organic and aqueous). It is worth nothing that all of the models would be of the unsteady state type.

I appreciate the thoughts of the user group in this respect.

I'm creating a python quiz game for my class. However, I'm having difficulty with wrong answers throwing me a "UnboundLocalError: local variable 'score' referenced before assignment" error. There is also the fact that score will not accumulate, or add up to the total at the end of the game. I'm concerned once I figure out to properly let my program replay these issues will only complicate things further. I've looked at a few other threads and tried methods like changing "score=+1" to a different variant like score= score+1 but I can't figure this out with my level of experience.