$$Excel-Macros$$ Probability (Gaussian) Distributions with known means and standard deviations using existing excel functions
Okay, I have a series of numbers like the table below:
Value 1 Value 2 Value 3Value 4 Value 5 Value 6
MeanSt
Dev ~% Prob
Series A67.09 64.31 70.47 64.43 54.73 64.21 5.86
4.66%
Series B68.60 59.70 62.27 74.55 70.14 67.05 6.02
6.17%
Series C66.28 68.31 62.86 72.61 66.58 67.33 3.56
9.60%
Series D61.16 67.95 71.56 68.33 75.88 68.98 5.41
7.36%
Series E62.02 68.27 68.97 68.25 68.81 67.27 2.95
10.63%
Series F66.44 71.39 67.27 69.69 63.56 67.67 3.02
11.40%
Series G65.52 66.27 68.29 70.05 65.72 67.17 1.95
11.19%
Series H65.99 67.85 66.98 70.59 69.76 68.24 1.91
17.81%
Series I64.67 69.30 66.30 68.63 66.91 67.16 1.85
10.98%
Series J62.41 69.51 66.91 67.38 68.88 67.02 2.79
10.20%
69.31296719 1.0
What I want to determine is the probability (based on the mean and
standard deviation) for each series that the next value will be the
highest value in the empty column. For example what is the probability
that the next value in Series 1 will be the highest value in column
"Value 6". I think the answer is roughly 4.66%
I can do a rough approximation using normdist on some dummy variable
and the using solver have the sum of the normdist probabilities sum to
1. Thats how I generated the numbers in the last column. Alternatively
I can do Monte Carlo simulations, but thats time consuming. So I'm
looking for a more elegant and precise solution using the existing
functions in Excel!
I believe the general equation has the form below:
Prob{t(min\A) < x} = Prob{min{t(B), ..., t(J)} < x} = Prob{not all
{t(B), ..., t(J)} > x} = 1 - Prob{all {t(B), ..., t(J)} > x} =
1−∏k∈(S∖A)[1−Φk(x)]
where Φk is the Gaussian CDF for t(k).
Although the above equation is for the probabilities for the lowest
value, I'm guessing substituting "max" for "min" and "<" for ">" will
get the right equation. The question then is, can you solve the
equation in excel? And how difficult is it?
Thank you in advance for any assistance you can provide.
Michael Hayes
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Auto Formatting
When I do web queries and create pivot tables in Excel 2007, I really dislike the automatic column width formattingthe columns are often so narrow that my data is unreadable...is there a way to turn off the auto column format function? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Web Data Queries
I just downloaded the Excel 2007 Web Data Add-in...I have two general questions: 1. I cant seem to get a web page from a secure server (https) to load...are there any issues here? 2. I have gotten data from a page like Yahoo finance, but once the data is imported it is static...how do you keep the data dynamic. For example how do you have the DJIA (Dow Jones Industrial Average) change in the spreadsheet as soon as it changes in Yahoo? I"m guessing these questions may be addressed in the tutorial, but the link to the tutorial is broken...so I would appreciate any insights. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Calculation based on changing conditions
Steve, Lets assume that your columns are labeled A, B & C. meaning that cell A2=2, B2=3, C2=5 put this formula in cell C2, =IF(B2="",A2+C1-A1,B2+A2) Copy that formula down. Michael On Aug 28, 12:43 am, xsrossiter wrote: > Hello, > > I am using Excel 2002 SP3 and hope to find a conditional solution > using formulas rather than a macro. In column A are a series of > values, column B has values at irregular intervals, and column C > contains calculated values based on a value in column B until a new > value in column B is encountered and then it incorporates the new > column B value in its calculation. > > A B C > 2 3 5 > 6 9 > 8 11 > 4 2 6 > 15 17 > 8 10 > 21 8 29 > > For example, column C contains a formula to sum columns A and B. It > adds 3 to whatever value is in column A until the fourth row at which > point it adds 2 to whatever value is in the A column and finally as it > gets to the seventh row begins adding 8 to A column values. > > Is there some formula that can be placed in column C that will follow > this logic and avoid using a macro? Column A at this point has 86 rows > and column B has 14 values at varying intervals. > > Thanks for your help and time. > > Steve -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need help with a formula
Beckie or is it Becky? Im hoping someone has a more elegant solution than I do...the only way I know how to do it is to create three additional columns. In cell AZ3 I put this formula =IF(R3="NA",IF(T3="NA",IF(V3="NA",IF(X3="NA",IF(Z3="NA",IF(AB3="NA",IF(AD3="NA","NOT CLOSED",AC$1),AA$1),Y$1),W$1),U$1),S$1),Q$1) In cell BA3 I put this formula =IF(AF3="NA",IF(AH3="NA",IF(AJ3="NA",IF(AL3="NA",IF(AN3="NA",IF(AP3="NA",IF(AR3="NA","NOT CLOSED",AQ$1),AO$1),AM$1),AK$1),AI$1),AG$1),AE$1) and in cell BB3 I put this formula =IF(AT3="NA",IF(AV3="NA",IF(AX3="NA","NOT CLOSED",AW$1),AU$1),AS$1) Copy those formulas down your sheet Then in Cell P3 I put this formula =IF(MIN(AZ3:BB3)=0,"NOT CLOSED",MIN(AZ3:BB3)) Copy that down. This will solve your problem until someone provides a more concise & elegant solution. Michael Hayes On Aug 19, 6:18 am, wrote: > The NA is not an error from a formula. Attached is detail of what I am > looking for. Thanks in advance! > > > > From: excel-macros@googlegroups.com > [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack > Sent: Thursday, August 19, 2010 12:27 AM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Need help with a formula > > Hi Becky, > If XL has put NA in a cell, you must already have a formula there. > You'll need to send a sample workbook so we can see get the whole > picture. > Regards - Dave. > > > Date: Wed, 18 Aug 2010 12:15:30 -0700 > > Subject: $$Excel-Macros$$ Need help with a formula > > From: rebecca.math...@kraft.com > > To: excel-macros@googlegroups.com > > > I am trying to create a formula: > > For a given range which most values are "NA", I want the cell to > > return the value of the cell that is above the first cell that > > contains value <0 (not NA). > > > -- > > > --> Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip> 2. Join our LinkedIN group @ > > http://www.linkedin.com/groups?gid=1871310> 3. Excel tutorials > athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes > > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group > athttp://groups.google.com/group/excel-macros/subscribe > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group > athttp://groups.google.com/group/excel-macros/subscribe > > Excel Help Example.xls > 43KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Removing selected letters and symbols from a cell
Alex, This a "Text to Columns" function. Select the column, use the Text to Columns/ delimited function with "space" as an indicator. In Excel 2007 "Text to Columns" can be found on the Data tab. On Aug 18, 4:51 am, Alexander Cargill wrote: > Hi all I was wondering if you could help. I have a sheet with entrys into a > cell that looks like this: > > AAECHO::DELTA (422|279) K24 > > AALPHA::HOTEL (447|319) K34 > > ALPHA::FOXTROT (445|320) K34 > > ALPHA::GOLF (446|319) K34 > > ALPHA::INDIGO (448|320) K34 > > ALPHA::JULLIET (449|319) K34 > > ALPHA::KILO (448|323) K34 > > BRAVO::ALPHA (459|317) K34 > > BRAVO::DELTA (463|318) K34 > > CHARLIE::BRAVO (426|330) K34 > > All I want to be left with is a sheet with entry's like this: > > 422|279 > > 447|319 > > 445|320 > > 446|319 > > 448|320 > > 449|319 > > 448|323 > > 459|317 > > 463|318 > > 426|330 > > And the data that has K and a number behind it in a separate column(there is > multiple K numbers). If you could help ide be most grateful. > > Many thanks > > Alex Cargill -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Etracting sales data as per desired criteria
Kalyan I think Pivot table is your required solution using BP Group as your Pivot Table Report Filter. On Aug 18, 6:18 am, Kal xcel wrote: > Dear Experts, > > I am attaching a file where I have raw data of Depot, Customer group, Month > and Sales data. There are 16 types of customer group. I need depot wise > month wise & Distributor+Super stockist wise(customer group) sale data. > > I tried with sumifs & sumproduct formula, but it's not working properly. > > Pivot table is not my required solution. > > Thanks in advance > > Kalyan > > Monthly sale report.xlsx > 2214KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: count if with multiple conditions
This is a simple exercise with pivot table. On Aug 12, 3:42 am, HARI NAIR wrote: > In the attached file I want to know three results, how many persons given 4 > marks, out of which how many females , how many males.Please help me. Thanks > in advance. > > Regards, > > Hari > > Book1.xls > 59KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: find a value of intersection of two graph in excel
Cell B4 isnt blank...I suggested that he put his X Axis coordinates beginning in cell B4. In cell B4, I said enter the number 1. In cell C4 enter the number 2 etc. Part of the difficulty in solving the math behind this problem is that there were missing variables. The X axis coordinates were missing. I suppose you could impute the X axis coordinates (using a count function), but I choose not to do that. Cell C5 may or not be blank depending on the series of numbers in row 2 and row 3. If there is no intersection between those series values (C2 & C3) and the prior series values ( B2 & B3) the formula in cell C5 will return "N/A". If there is an intersection, then cell C5 will not be blank. Michael Hayes On Aug 5, 10:35 pm, anandydr wrote: > @ Michael Hayes > > Dear Michael, > > I went through the solution you sent for Mr Sudhir. Using his > spreadsheet I used the formula you have suggested. I got the results > but not the logic behind. How are we getting results even though the > cells B4 & C5 are blank, and what are these being used for??? > > Regards, > Anand > > On Aug 6, 1:40 am, Michael Hayes wrote: > > > > > Sudhir, > > > I am assuming by the subject matter of your posting you need to find > > the X and Y coordinates of any place on the graph where series 1 and > > series 2 intersect. So if I understand your request correctly, this > > should help > > > Lets put your X axis coordinates in cells B4 through E4. So in cell B4 > > enter 1, in cell C4 enter 2 etc. > > > Then starting in cell C5 put this formula to determine if there is an > > intersection =IF((B2-B3)*(C2-C3)>0,"N/A",B4+(B2-B3)/((B2-C2)-(B3-C3))) > > Copy that formula to cells D5 and E5 > > > That formula will tell your X axis coordinate of intersection (if > > applicable) > > > Then in cell C6 enter this formula =IF(C5="N/A","N/A",+B2-((B2-C2)*(C5- > > B4))) copy that formula over to cells D6 and E6 > > > That formula will tell you your Y axis coordinate where the graphs > > intersect (if applicable) > > > Email directly if you need a copy of the edited spreadsheet. > > > Michael Hayes > > > On Aug 5, 9:34 am, sudhir kumar wrote: > > > > hi friend, > > > i have a problem , i made two graph in excel sheet intersecting with each > > > other. now i want to highlight the value of the intersection point. plze > > > help > > > > -- > > > Regards- > > > Sudhir Kumar > > > Design Engineer, > > > Conceptia Software Technologies Pvt. Ltd. > > > Email id-sudhir.p...@gmail.com, > > > > graph.xls > > > 29KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: find a value of intersection of two graph in excel
Sudhir, I am assuming by the subject matter of your posting you need to find the X and Y coordinates of any place on the graph where series 1 and series 2 intersect. So if I understand your request correctly, this should help Lets put your X axis coordinates in cells B4 through E4. So in cell B4 enter 1, in cell C4 enter 2 etc. Then starting in cell C5 put this formula to determine if there is an intersection =IF((B2-B3)*(C2-C3)>0,"N/A",B4+(B2-B3)/((B2-C2)-(B3-C3))) Copy that formula to cells D5 and E5 That formula will tell your X axis coordinate of intersection (if applicable) Then in cell C6 enter this formula =IF(C5="N/A","N/A",+B2-((B2-C2)*(C5- B4))) copy that formula over to cells D6 and E6 That formula will tell you your Y axis coordinate where the graphs intersect (if applicable) Email directly if you need a copy of the edited spreadsheet. Michael Hayes On Aug 5, 9:34 am, sudhir kumar wrote: > hi friend, > i have a problem , i made two graph in excel sheet intersecting with each > other. now i want to highlight the value of the intersection point. plze > help > > -- > Regards- > Sudhir Kumar > Design Engineer, > Conceptia Software Technologies Pvt. Ltd. > Email id-sudhir.p...@gmail.com, > > graph.xls > 29KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Create a Unique Name List
If you can copy everything to the new column, the rest of it can be done easily with a pivot table. On Jul 17, 12:31 am, Scott wrote: > Hi, > I'm trying to create a list of unique names from a list of names (some > duplicates) that exist on 15 different sheets within a spreadsheet. > So I want the unique list to copy to a new sheet in column A and I > want to be able to sum the values (in this case hours) for each of > those people on those 15 sheets to the new sheet in columns B, C and D > (ST hours, OT hours and DT hours). If anyone has some code that would > accomplish this it would be appreciated. > thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE
Hameet,
Try the concatenate function
=CONCATENATE("I have "&B1&" hands and "&C1&" Eyes")
Notice the spaces for the text inside the quotation marks...you need
those spaces to format your sentence properly.
On Jun 15, 6:37 pm, Harmeet Singh wrote:
> this should help. see attached file
>
> Warm Regards,
>
> Harmeet Singh
>
>
>
> On Tue, Jun 15, 2010 at 6:43 PM, big smile wrote:
> > Hellow Friends
>
> > Can it possible that
>
> > in cell lets ex. in B1 I write -
>
> > The gross total is Rs. ---[ Cell value of A1 ].
>
> > In between any sentence i want the cell value from any other cell.
>
> > can it possible in between the cell also.
>
> > For ex. -- The gross total is Rs. [ c1] & the gross weight is Rs. [ c2]
>
> > where c1 & c2 is the cell value
>
> > Thanks
>
> > Good Day
> > From Big Smile
> > Savla
>
> > --
>
> > ---
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
>
>
> eg.xls
> 18KViewDownload
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Legal Notice/Splash Screen
Dave In general I agree with you. The algorithms can be copied. The catch here is that only parties that would be interested in my algorithms are large insurance carriers with deep pockets. Concurrent with writing this program, I'm also serving as an expert witness for a very large insurance company who is alleging intellectual property theft by a competitor. Millions of dollars are at stake. And a large portion of the intellectual property at issue are a series of spreadsheets I developed in the 90's. I didnt think the stuff I did in the 90's was all that clever or unique, so I didnt do anything to protect what I was doing. Now 15 years later, there is this big lawsuit and I can see now what I could have done to make my clients case stronger. So, this legal case has made me more cautious...I know I cant prevent copying, I just want anyone who does copy or steal the program to do so with clear knowledge of the potential liability associated with such acts. And hey if they do steal my work again, I'll be flattered and then let the attorneys handle everything. Thanks for your input. Michael Hayes On Jun 14, 9:06 am, Dave Bonallack wrote: > Hi Michael,If you want to stop people copying your algorithms, then Excel is > not the platform to use. Its security is about as good as wet tissue paper; > Excel 2007 being slightly better, as good as dry tissue paper.The advantage > of using Excel is that you can design a workbook that meets very specific > needs, and so is often not useful to another user with slightly different > needs. My advice: if you are being paid to produce the current workbook, take > the money for your work, keep a copy of your algorithms for another day, and > move on to your next Excel project.Regards from Brasil - Dave > > > > > > > Date: Sun, 13 Jun 2010 13:48:50 -0700 > > Subject: $$Excel-Macros$$ Legal Notice/Splash Screen > > From: m99pan...@gmail.com > > To: excel-macros@googlegroups.com > > > Good Afternoon to all, > > > I'm developing a spreadsheet to calculate insurance rates for a large > > client. Within the spreadsheet are some highly proprietary algorithms > > that I developed that describe the relationships between costs and > > "richness" of benefits.My client believes this spreadsheet/program > > will have some definite commercial value upon completion. So basically > > I need to think about intellectual property protection. Therefore I > > have two questions: > > > Any advice on the simplest way to provide some degree of intellectual > > property protection on a spreadsheet or the algorithms within the > > spreadsheet? > > Any way to create a "splash screen" or some legal notice that pops up > > whenever the program is opened? And the user cant continue without > > acknowledging the notice? > > > Thanks > > > Michael Hayes > > > -- > > --- > > --- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know > > they can subscribe to group > > athttp://groups.google.com/group/excel-macros/subscribe > > _ > View photos of singles in your area! Looking for a hot > date?http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Legal Notice/Splash Screen
Kavita, Thank you. I have been using this book as a coaster: "Excel 2007 VBA for Dummies"...looks like I'm going to have to read it now. I think I'm going to need more coffee. Michael Hayes On Jun 13, 11:50 pm, kavita ahuja wrote: > Hi Michael, > > You can us userforms in excel VBA to show the notice and you can put a > button on the userform and if the user clicks on the button, then only the > spreadsheet will be displayed > > Regards > Kavita > > > > On Mon, Jun 14, 2010 at 2:18 AM, Michael Hayes wrote: > > Good Afternoon to all, > > > I'm developing a spreadsheet to calculate insurance rates for a large > > client. Within the spreadsheet are some highly proprietary algorithms > > that I developed that describe the relationships between costs and > > "richness" of benefits.My client believes this spreadsheet/program > > will have some definite commercial value upon completion. So basically > > I need to think about intellectual property protection. Therefore I > > have two questions: > > > Any advice on the simplest way to provide some degree of intellectual > > property protection on a spreadsheet or the algorithms within the > > spreadsheet? > > Any way to create a "splash screen" or some legal notice that pops up > > whenever the program is opened? And the user cant continue without > > acknowledging the notice? > > > Thanks > > > Michael Hayes > > > -- > > > --- > > --- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Legal Notice/Splash Screen
Good Afternoon to all, I'm developing a spreadsheet to calculate insurance rates for a large client. Within the spreadsheet are some highly proprietary algorithms that I developed that describe the relationships between costs and "richness" of benefits.My client believes this spreadsheet/program will have some definite commercial value upon completion. So basically I need to think about intellectual property protection. Therefore I have two questions: Any advice on the simplest way to provide some degree of intellectual property protection on a spreadsheet or the algorithms within the spreadsheet? Any way to create a "splash screen" or some legal notice that pops up whenever the program is opened? And the user cant continue without acknowledging the notice? Thanks Michael Hayes -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
