what formula or calculations are done here !I don't know

[montecarlo2012]

I have a spreadsheet where supposedly the percentages are calculated
somebody in 30 days show up 5 time then on column B they say the percentage is 3.3
and so on but still I don't know the operation here to get this result
also I don't know if I am in the right place here to ask this let me show you a screen shut
so just for kindness you resolve to help me please.

so if in 12 day shows up 4 times then the % is 6.7 for me to write a vba routine I have to know what math they make here
anybody please

 

[jimrward]

Without knowing the significance of things, the calculation in column B is as follows
=(20/numberofdays) x days
so in B2 it will be =(20/30) x 5 which is 3.333333
B3 it will be =(20/30) x 4

B9 it will be =(20/20) x 6

B17 it will be =(20/12) x 4 which is 6.666666666

the cells in B are formatted with 1 decimal place so 6.6666666 is 6.7

 

[montecarlo2012]

jimrward, work for the first part but not for the other,
thank you for stop and work out for my problem.
thank you.

 

[jimrward]

works for me, I will do an excel version later and post

 

[montecarlo2012]

Hello jimr is fine I figure out the weird way this people do this, and I discover it is not a percentage what really happen,
so ones I got the math now I have the code
here we go

Sub Caprice()
    Dim starpoint As Double
    Dim endpoint As Double
    
    For i = 2 To 15
        starpoint = ((Range("A" & i).Value * 10) / Range("$A$1").Value) * 2
        endpoint = ((Range("A" & i).Value * 10) / Range("$A$1").Value) * 2
        Range("B" & i).Value = starpoint
      
    Next i
End Sub

and thank you again for your company

 

[jimrward]

Ok cool we have same answer different method, I am not a mathematician but spotted a pattern