# Thread: Formular, matching function input to output

1. ## Formular, matching function input to output

Hey Guys,

I am looking or a formular that uses the variables states below to get the
result in percentage.

It would be amazing if anyone has an idea - it has to work with sets containing
anything from 2 to 5 triangles.

Have a great weekend,

Polynaux

2. Originally Posted by polynaux
Hey Guys,

I am looking or a formular that uses the variables states below to get the
result in percentage.

It would be amazing if anyone has an idea - it has to work with sets containing
anything from 2 to 5 triangles.

Have a great weekend,

Polynaux

Why do you need a formula for this, what is wrong with a table of some kind?

RonL

3. Hi CaptainBlack,

I need a way to automate it because its part of my freelance software project (a solution-selection system).

That is what I have so far, it determines if the user input (e.g. for three attributes) is low, medium or high but does not yet consider the actual percentage value.

Dim j As Integer = 1 ' has to start with 1 because a multiplication with 0 would be 0
Dim k As Integer = 0 'AttributeNameInArray- starting with 0
Dim TotalAttr As Integer = CriteriaAttributeNames.Length - 1
Dim inputAssessmentMembership As String
Dim inputAssessment As Integer = TextBoxHiddenInputAssessmentForEachRow.Text 'gets the input value
For Each item As String In CriteriaAttributeNames
If inputAssessment < j * (10 / TotalAttr) Then
inputAssessmentMembership = CriteriaAttributeNames(k).ToString
Exit For 'exit loop
End If
j = j +1
k = k +1
Next item

e.g where 'CriteriaAttributeNames(0).ToString = low, 'CriteriaAttributeNames(1).ToString = medium, 'CriteriaAttributeNames(0).ToString = high

I will keep thinking and give you an update in 5 hours if I came up with something but thanks for showing interest anyway.

Polynaux

4. not quite there yet but I realize that there must be a way.

100 - (input x 100/a) comes closer, where a ist the number of triangles or attributes.

for a = 3 this would be

1 - 66%
2 - 33%
3 - 0,1%
4 - -33%
5 - -66%
6 - 0%
7 - 133%
8 - 166%
9 - 100%
10 - 100+%

for a = 5

1 = 80%
2 = 60%
3 = 40%
4 = -33% ,....works not to well here - the formular has to be tweaked.

but I realized that for a = 5 in my graph above, 2,4,6,8 = 0 (x axis interception).

a = 3 it would be 3,3333 and 6,66666 so there might be a possibility to built on that.

polynaux

5. hmm no enlightenment yet.
I suppose I could specify the responsing y axis value by assigning them
in my program manually - which would not be really a brilliant solution and not scalable at all (imagining for example user input between 1 and 100 instead of 1 to 10)