Algorithm for filling a column in excel using "company codings" RRS feed

  • Question

  • Hello all,

    Nice to be here. I have been learning C# for a while for personal reasons and also for Unity.

    Today, from a client, I have received a long excel sheet. My duty is use this information to make our product codings. Then use that codings to make a quotation. Then I wonder, since it is a very long excel, is it possible to use C# in excel? It seems it is possible but a little complicated. But besides of that, I couldnt able to write an algorithm for this, because it is a little complicated and out of my league. May I ask you guys help regarding with this? Please see the table below.

    So customer has sent me this excel with 3 values and I will make the "Coding" column. As you can see in the information, I explain the standart coding text and then I explain the codings for valuables. One of the problem is "Value 3" column has 2 valuables inside.

    Is it possible to make an algorithm for such table?

    Thank you very much for your help in advance!

    Standart coding 100="Value 3B coding"="Value 1 coding"=E="VALUE 3A"="VALUE 2"=NH
    For value 1 codings X=20 y=10
    For Value 3B Codings 6= Jack, 8= Clara, 10=Ted
    value 1 value 2 value 3 coding
    X 0/100 A:100 B:6 100=Jack=20=E=100=0/100=NH
    Y 0/60 A:120 B:8 100=Clara=10=E=120=0/60=NH
    Y 0/60 A:183 B:10 100=Ted=10=E=183=0/60=NH

    Monday, December 21, 2020 1:44 PM