nerochoices.blogg.se - Openoffice calculate equation of line

#Openoffice calculate equation of line software
#Openoffice calculate equation of line series

Click Keep Result to enter the result in theĬell with the variable value. A dialog appears informing you that the Solving In this example, the amount invested in Fund X (cell C2) should not be greater than the total amount available (cell C4) and should not be less than 0.

Enter limiting conditions for the variables by selecting the Cell reference, Operator and Value fields.

In this example, you need to find the amount invested in Fund X (cell C2). That means that any vector that is parallel to the given line must also be parallel to the new line. We know that the new line must be parallel to the line given by the parametric equations in the problem statement. We know a point on the line and just need a parallel vector.

Click in the By changing cells field and click on cell C2 in the sheet. To answer this we will first need to write down the equation of the line.

Select Maximum or Minimum if the target cell value needs to be one of those extremes. In this example, the target cell value is 1000 because your target is a total interest earned of $1000.

Select Value of and enter 1000 in the field next to it.In this example it is cell B4 containing total interest value. Dimension lines automatically calculate and display linear dimensions as you.

#Openoffice calculate equation of line software

In the sheet, click in the cell that contains the target value. Powered by Apache OpenOffice, this is a premier office software suite for.

In cell B4, enter the formula B2+B3 as the total interest earned.

In cells B2 and B3, enter the formula for calculating the interest earned (see below).

In cell C3, enter the formula C4-C2 (total amount - amount invested in Fund X) as the amount invested in Fund Y.

Typically, the name of a function is an abbreviated description of what the function does.

Enter an arbitrary value (0 or leave blank) in cell C2 as amount invested in Fund X. Alternatively, it may be as complex as calculating the standard deviation of a sample, or a hyperbolic tangent of a number.

Total amount invested: 10000, in cell C4.

Interest rates: 8 and 12, in cells D2 and D3.

Column labels: interest earned, amount invested, interest rate, and time period, in cells B1 thru E1.

Row labels: Fund X, Fund Y, and total, in cells A2 thru A4.

How much money should be invested in each fund to earn a total interest of $1000? Y is a higher risk fund with 12% interest rate.

Fund X is a low risk fund with 8% interest rate and Fund Let's say you have $10,000 that you want to invest in two mutual funds for one year. Depending on the complexity of the task, this may take some time. Once you have finished setting up the rules, click the Solve button to begin the automatic process of adjusting values and calculating results. You can also define the constraint that one or more variables must be integers (values without decimals), or binary values (where only 0 and 1 are allowed). If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, you can set the constraint that one of the variables or cells must not be bigger than another variable, or not bigger than a given value. For arguments that you would like to change, you need to add two rules to define a range of possible values: the limiting conditions. If you want the argument to remain unchanged, you enter a rule that the cell that contains it should be equal to its current entry. It is specifically designed to minimize or maximize the result according to a set of rules that you define.Įach of these rules defines whether an argument in the formula should be greater than, lesser than, or equal to the figure you enter. The difference is that the Solver deals with equations with multiple unknown variables. And if you format that cell as a date, DD/MM/YYYY HH:MM:SS, then you'll read a pretty " 01:00:00" there.Tools > Solver amounts to a more elaborate form of Goal Seek. And if you sum that number with 25569, you have an OpenOffice day for that timestamp.Īlright, let's put all the pieces together: let's say cell A2 contains a UNIX timestamp 1341104400, then this formula =A2/86400+25569 Now, if you divide a UNIX timestamp by 86400 (the number of seconds in a normal day), that will give you the number of days between the epoch and that timestamp (and some decimal, that you can use to calculate the time of day). As it seems, OpenOffice's "day 0" is December 12th, 1899 that implies that January 1st, 1970 is day 25569 for OpenOffice.

#Openoffice calculate equation of line series

The problem is: you have a time series of data in a spreadsheet, and the time is expressed as UNIX timestamps (seconds since the epoch, 00:00:00 UTC, and not taking into account leap seconds): how can you convert those timestamps in a readable date like, e.g., " 01:00:00"? … I found a very useful suggestion in the OpenOffice community forum. This is not something I discovered myself, rather it's something that I'll need every now and then when doing extemporary reports of UNIX-timestamped data.