Respected sir,
sir i have two sheets in 1st sheets i have data of constant offset distance,in 2nd sheet i have to make data according requirement,i have attached that sheets please help me so that just click in one switch i will get the result.
Respected sir,
sir i have two sheets in 1st sheets i have data of constant offset distance,in 2nd sheet i have to make data according requirement,i have attached that sheets please help me so that just click in one switch i will get the result.
Can you give more details how the calculation in column C is done: Give an example
- Battle without fear gives no glory - Just try
Ok sir i am sending the example sheet to you the main sheet is sheet 1
all calculation will be done from it
the 2 sheet is the result according to the requirement
so need to connect that 2 with vba and operated with just a switch to get calculated level from desired offset.
See next UDF
Please Login or Register to view this content.
Last edited by PCI; 03-22-2016 at 05:22 PM.
Respected sir
everything is fine ,but if little bit modification is done then it will be excellent,
i have attached the example sheet for your observation.
Pls reply me.i am waiting sir
I cannot answer right now I'm at work
If you want to do the calculation with an offset of 0 I will suggest to enlarge the data table with values evaluated at offset 0.
But I 'm not sure this gives some correct result: see the chart in the file attached.
To evaluated values using only the last interval leads to some wrong trend
BTW The function code has been changed to
Please Login or Register to view this content.
Last edited by PCI; 03-24-2016 at 06:06 PM.
Respected sir why it is not working with last offset 20.000 ?
I cannot understand that,am i doing any mistake?
SIR WILL I SEND YOU A SKETCH IN AUTOCAD?I THINK THAT WILL HELP YOU TO FIGURE OUT THE PROBLEM
Last edited by anindya.zen; 03-25-2016 at 03:28 AM.
WILL I SEND YOU A SKETCH IN AUTOCAD => I don't have Autocad
I apologize the test was not complete, try next code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks