Baby Is A Butterfly Quote

Anyone who has spent some time with the Visual Basic have been confronted sooner or later following problem: one day, that too without knowing why, you lose the natural disposition of the VBE (Visual Basic Editor) where it was on the left, the project window on top and in the properties window bottom right, the VBA code.

You are then for example in the following situation:

You trusting what the books say and the help of Microsoft, you can blandly try to click right in the body (not the title!) of the Project window and select "Dockable". In this case, either (1) you're lucky and the block fits on the left, or (2) you have bad luck and part block is horizontally above, or (3) the window moves without fit on a board.

In case 2, double click on the banner of the window to make non-contiguous to an edge, as in the case 3.

In cases 2 and 3, reduce this to the VBE window in case it would be full screen. Then select the window frame by grasping its title banner and move toward the edge where you want to dock it. The window is represented by a frame with a thick gray line when moving.

when you move the window towards the edge of the top, you'll see at some point the thick border of the window become dotted line end with a horizontal rectangle. If you release the mouse button at this point, the window will be docked horizontally.

However, if you move the window the same way to the left edge, you will at some point a vertical rectangle dotted end, and releasing the button, then you will anchor the window vertically. It is the goal we wanted to achieve:)

Note 1 - had to VBE window is not full screen so you can go beyond the left edge of the window at least half of width of the store window to see the show end border. This is the trap that all those who tried in vain to reframe the VBE windows fell when - like me - they were full screen, hoping to "see better" what was happening.

Note 2 - All these problems could have been avoided if Microsoft had thought of creating two commands - Anchorage Anchorage horizontal and vertical - instead of a single control ... Or had they simply defined the anchor by default being vertical, which would have been smarter still ... Who indeed would want to anchor the windows horizontally?

Pooping Normal During Pregnancy

Merry Christmas!

A little message to wish you all a Merry Christmas!

I did not find much on the Internet seeking Christmas and Excel. Here, however, an address where you can download some examples:

http://chandoo.org/wp/2010/12/15/christmas-cards-in-excel/

What I published More interesting is the Christmas tree below, with the balls that create a blinking effect in Color Change:

And a little distraction as a Christmas present! With Word, either in 2003 or 2007 (I have not tested on 2010), so have fun to enter a blank document, then validate:

= rand (200.99)

With Word 2003, you will get 19,800 times " Use this gentleman a beer and kiwis " . With Word 2007, 2200 will be both a text of 1332 characters beginning with " Insert tab, the galleries ... "

There are always surprises with Microsoft ...

In conclusion, you are with a " œ Easter egg " for Christmas!

How To Watch Digital Playground For Free

two-axis chart in 2007

We saw in the two previous articles how to make Excel 2003 in a graph with two axes Y.

The big surprise, when trying to insert a graphic that is going to do with the command "All types of graphics," which is at the bottom of each family of graphs is that there over two-axis graph Y which is offered in Excel 2007, besides the two graphs very special position in the family "Fellow." Let us therefore

a simple histogram to represent the whole (see picture below). Of course, this is not satisfactory because we want to place the last series - Total - on an axis to the right and turn it into a curve.

No problem with that, there are two operations to be performed ...

First, right click on one of the four bars of the last series, then the command "Format a series data "and" Secondary Axis ". The series 'Total' is then represented by a thick histogram in the foreground.

then re-click Right then the "Change Chart Type Data Series" (which, among us, is a command name totally stupid! The last three words are too many ...) and select a curve.

that remains is to perfect representation, to both the red curve and the values of the right axis. We then get the desired result:

How Do You Work Hardy-weinberg Problems

A graph improved two-axis graph with two axes

We saw in the previous article that one of the problems of graph with two axes in Excel 2003 - and we have the same problem with and 2007 versions 2010! - That is, by default, the first half of the series is associated with the left axis and the second to the right axis.

This is not suitable for common situations where - as in the example of the last article - you want to associate the n-1 first sets the axis to the left, and only the last set to the right axis.

Suppose we have 8 series, 7 series of products and a series of total. If we proceed as we did four days ago, we default to the left and 4 sets 4 sets right.

We will then make 6 consecutive operations: for series 5-7, we have to change their type of graph and their axis.

Then there is a more effective solution: create a simple histogram to start with the 8 series. Then select the series 8 (total), change its chart type, then its axis ... Result: 2 operations instead of 6:)

A tip - When making a graph of this type (here we took the example of previous section), remember to make the graph clearer still.

How so? Well just as we have done here: we have put the total in red (a thick red line) and we also put in red the values of the right axis, so that the user understands that is "Total" is red, and it corresponds to the right axis. It's so simple, but how many people think?

Gentital Warts Jacuzzi

in 2003

often in practice that we seek to build a graph with two Y-axes, especially when the magnitude series is not homogeneous, for example if one represents the same graph in various sales and margins associated

... In the example below, we want to compare the quantities sold by product with total unit sales of all products. In this paper, we analyze how to achieve this with Excel 2003 and we will see in a later article how it happens with Excel 2007 (and therefore 2010) ...
When you go through the wizard and graphical tab "Custom Types", several types of graphs to two Y axes are available on the screenshot below: Curve - Histo. 2 axes, curves - Histogram, Curves with two axes.

The disadvantage is that in each case, Excel places half of the series on the left axis and half on the right axis. We see clearly in the graph below, where two series are histogram with the left axis and two in the curve with the right axis.

Note - In early versions of Excel, a simple dialog box in the creation of graph used to select the number of series associated with the left axis. Alas, this great feature has disappeared one day because it disturbed the users too "lambda".

This is unfortunate because often it is desired to have a series on the right axis. In this case, to put the third series, Pentium C, histogram and on the left axis, we have to go through two operations for this series: first change graph type and change of axis ...

Microsoft Rt2300 Usb Adapter

limits the solver of Excel reports

The Excel solver was déveoppé by Frontline Solvers "which, on its website http://www.solver.com/ do not hesitate to also tell you that he can sell you better live!

The Excel solver is limited to 200 variables, other solvers - whether add-ins for Excel or not - can go up to thousands of variables. Another limitation of the Excel Solver, Frontline forget that just happened to clarify, is far more serious: the solver of Excel is really reliable for linear models Continuing (linear programming).

Certainly, the solver of Excel gives you the right to specify that a particular variable is full or Boolean. Certainly, it allows you to define models with nonlinear constraints, with formulas containing such functions if () or max (), variables squared,

... But in solving problems containing such variables or such formulas, we have observed (and the list is not exhaustive) the following phenomena:

● solver says that one solution is optimal when it is not

● solver says there is no feasible solution then there are

● solver found or not found the optimal solution according to the order constraints

The result of my experiences is this: the Excel Solver is reliable, I repeat, that for continuous linear models .

To conclude this series on the solver where we started, here's a riddle that you can play to resolve. If anyone knows about this riddle (Found in English on the Internet at multiple locations), I will be happy to do him honor.

In 10 years, Tim will be twice as old as Jane was when Mary was nine times the age of Tim. 8 years ago, Mary was half as old as Jane will be when it will be a year older than the age that Tim will be when Mary will be 5 times as old as Tim in 2 years. When Tim was 1 year old, Mary was 3 years older than Tim did when Jane will be 3 times as old as Mary was six years before the year in which Jane was half as old as Tim will be when Mary will be 10 years older than she was when Jane was the third age Tim will be when Mary will be 3 times the age she was when Jane was born. What are their ages now?

Olders Women With Nylons

When we run the solver, three responses are possible. In the best case (see Figure 1), the solver finds the solution and offers three reports. Two other cases are possible: the solver finds no feasible solution - then you put constraints incompatible - or he finds a solution infinite - you do not put enough stress

... Let's look at where the solution been found. Then simply select one or more reports in the window and validate to obtain them.

Each report takes a leaf placed upstream of the active sheet. Regret over the names of such sheets: they are too long, with
"Answer Report 1", "Sensitivity Report 1", "Limits Report 1". For my part, I have them named "Responses", "sensitivity" and
"Limitations": it is rarely effective to have names of tabs feature.

Whatever your goal, maximization, minimization or target value, the only report that gives you real information useful is the sensitivity report. It had been translated into the first version of Excel Solver. Alas, in later - and for over 15 years! - It is horribly mistranslated: either Microsoft has used a machine translation software, or the work was entrusted to a trainee with IQ below 100 ...

To tell you how it's bad, imagine, then, that the term "Shadow cost "has been translated as" shadow cost ", a term that I will not find in any book of French economy! Translation is not only filthy, but the presentation of results is not consistent with that of conventional optimization software, so I've developed for my clients a macro that converts the infamous relative sensitivity of the solver of Excel in a report useful and effective.

really useful information found in the report of sensitivity is precisely the marginal value (or the shadow cost Reduced cost, depending on the block in question), and the interval in which it is valid.

Take the case of the B10 cell (plant 2 to warehouse A). This cell is blank, there is nothing in transporting the optimal solution. If we had to carry a unit to continue to respect the constraints online column, he should make a move according to the four corners of the red rectangle (see Figure 3): B10 add, remove as E10, E11 add and remove in B11. This would represent an additional cost of EUR 8: +3, -1, +14, -8. Well, it is precisely the result shown in E14 in the sensitivity report!

This kind of useful information found in the report of sensitivity!

Unblocking Doe Websense

optimization solver with solver with solver

After our first foray to the solver four days ago, we find today's ability to find the solution to an optimization problem.

We have three factories and four warehouses (A, B, C and D). The table in B2: E14 represents unit transport costs of each plant to each warehouse. Line 5 represents the needs of each warehouse and column G which is available at each plant.

The problem to be solved is to find the quantities to be transported (block B9: F11) that will, within the constraints of need and availability, minimize total cost in G14 evaluated by the formula = SUMPRODUCT (B2 : F4, B9: F11) . B12: F12 and G9: G11, finally, we are the vertical and horizontal.

The problem is solved easily by using the solver as we see below with the result, then by setting the solver who has to get it:

Note - Do not you satisfied with the settings above! You must also, before clicking the button "Solve" button
go through the "Options" and check the options " Assume Linear Model "and" Assume Non-negative ".

If you miss the last option, the Excel solver fails to converge! Indeed, he tried in vain to carry negative quantities to reduce the total cost.

If you forget to specify that the model is linear, there will be small rounding errors, and in addition, you will not benefit - after the resolution - all useful information (in particular, the marginal values ).