CHECK THESE SAMPLES OF Programming MS Excel to freeze panes
...from that, the rest of the companies reported the positive returns in the given time frame. Results One basis of the results computed on the Microsoft Excel sheet along with the graphs, the analysis of 120 trading days’ activity clearly reflects that SAP performed remarkably well earning a gain of around $90,000, whereas Microsoft turned out to be the worst among all five participants reporting a net loss of around $55,000. The other three software designing firms produced mediocre results, presenting net gains $15,000, $9,000 and ?12,000 by oracle, Intuit and Sage respectively. Source Yahoo! Finance was used as the data source from the stock price data was retrieved. The reason for choosing this financial database is...
6 Pages(1500 words)Essay
...1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Microsoft Excel is a toolthat the various members of an organization utilize for various purposes and reasons. Among the most prominent users of Excel are the managers who happen to serve as the decision-makers in the firm. These people gain the most from the numerous tools that the software offers its users.
Managers can utilize Excel in several ways and for several scenarios as well. Primarily though, the spreadsheet is most valuable when managers ponder on and engage in the decision making process. Its value lies in the fact that...
2 Pages(500 words)Essay
... in the program.
b)
void Time::setTime (int hh, int mm, int ss);
{
hour = (hh>=0 && hh<24) h :0;
mnute = (mm>=0 && mm<=60) m : 0;
second = (ss>=0 && ss <60 ) s : 0;
}
Time::Time()
{
hh=mm=ss=0;
}
c) Int Time::timesAreEqual (Time &tl, Time &t2);
{
if ( t1.hour= t2.hour && t1.minute == t2.minute && t1.second == t2.second );
return 1;
else
return 0;
}
Question 28
a) A pointer is a variable that holds some memory address.
b) An array in C++ is a variable that holds subsequent memory locations up to the number declared by the user. The first element in the array has the index 0.
d) when the statements q1 = &x; and q2 = &y; are executed pointer q1 get the value of x and q2 gets the value of y.
x
78
y
96
x=78 y=96... Question 29
a) Dynamic data structures can grow or shrink according to the wish of the programmer. Static values do not hold this property; once declared they remain fixed to the defined length.
b) After the assignment chPtr = new char[10]; chPtr content will be the memory location where char[10] is stored.
Question 30
a) Encapsulation in object oriented programming is a technique that integrates data and operations to make an object. The benefits of encapsulation are abstraction and security. Abstraction in the sense that the operations and properties of an object are hidden from the outside world who is not...
9 Pages(2250 words)Research Paper
...interferences
The polyatomic interferences are only obtained for Se 78 and 80. Co and Mo can be easily quantified using ICP-MS.
Determination of Se by ICP-MS and DRC method
The determination of Se should be done by ICP-MS and not by DRC mode because the response obtained for Se 82 in DRC shows lower response as compared to good counts in ICP-MS. The chances of error are less when ICP-MS is employed for estimation of metals.
Enclosures: Excel Sheet containing calculations
Appendix
Table 1: Calculations and Calibration for Mo 95
Table 2: Calculations and Calibration for Se 80 DRC
Table 3: Calculations and Calibration for Se 78
Table 4:...
3 Pages(750 words)Lab Report
...My Business and Number of Answer Report For any business to realize an increase in profits at the end of a given duration, quite a number of factors can be varied. Two parameters were chosen for this business model and that is: sales and cost of sales while maintaining all the other factors constant, e.g. those relating to customers. To do this, a spreadsheet named “Profit Analyzer” was created that projects the expected profits depending on how these two chosen parameters are expected to vary quarterly i.e. their percentage rate of increase or decrease (Ken Kaufaman, 2010). When a percentage rate of change is entered under the “Variations” column for either of the two parameters, say 105% if sales are projected to increase... Business and...
2 Pages(500 words)Essay
...Logic and Programming Programming A problem Analysis Chart Given information The information provided is that children below 18 Years of age should not be considered as customers for purchases.
Required Results
Processing required
Solution Alternatives
The only alternative is to use the “if” condition to test whether the age is greater than, equal to or less than 18.
2. A flowchart
3. A chart showing input, output, and processing
Year of Birth
YOB
Year Today
YT
Age
(YT-YOB)
Status
Accepted / Rejected
4. Algorithm (Pseudo code)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace...
1 Pages(250 words)Essay
...INFS 3100 EXCEL ASSIGNMENT DUE: Wednesday, February 11 (beginning After 12:50 pm the assignment is considered a day late. See syllabus for late policy.
Helpful Hint: Don’t forget to “Lock Cells” (Use absolute cell references) as needed when doing calculations for this assignment.
Instructions: (use formulas or functions unless otherwise noted)
1. Download and open the template found on D2L. (Filename: 3100 Excel Assignment 1 Outline Spring 2015)
2. Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” Cell.
3. Set the value of January “Production” equal to the “Initial Production” Cell.
4. Set the value of January “Units Sold” equal to the “Initial Units Sold” Cell.
5. Management predicts... “Not...
1 Pages(250 words)Assignment
...0.017865252
Observations
156
ANOVA
df
SS
MS
F
Significance F
Regression
1
0.036215891
0.036215891
113.4699513
0.00
Residual
154
0.049151755
0.000319167
Total
155
0.085367646
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
Intercept
0.000882052
0.001452188
0.607394753
0.544483536
-0.00199
0.003751
-0.00199
0.003751
S & P 500(Excess Return)
0.997221135
0.093616207
10.65222753
0.00
0.812283
1.182159
0.812283
1.182159
Part C
Jensen’s alpha
Jensen’s alpha is used to determine the abnormal return of a security or portfolio of securities over the theoretical expected return. The security could be any asset, such as stocks, bonds and or the derivatives.
In regards to Jensen’s...
11 Pages(2750 words)Essay
...INTRODUCTION TO FINANCE Project Report May 12, Executive summary: As the granny flat has a positive NPV (Net Present Value) of $10144.73, s the IRR (internal rate of return) is greater than Required Return. IRR is at 13.48% (12372/91750*100) which is greater than the required return of 4.51%. This investment has a payback period of 8 years. As this granny flat has a greater than required Rate of Return, and a large NPV, the construction of this granny flat should go ahead, as it is a good investment.
Q2) Rental Revenue
renting for whole granny flat with 2 bedrooms- $455. Electricity bill- $350 per quarter which is taken from the average of small (3500kWh pa) household scenario.(insert grapgh)
Water bill Per week- $27.22
Service...
2 Pages(500 words)Essay
...
Flyguys Project Report
Part 1
Flyguys has several requirements that can be met through proper usage of Access and Excel both. However, each of those software has its own pros and cons. Flyguys is interested in implementing a system that enables them to achieve three major goals; record keeping, reward system and reporting. This report takes a look at each of these requirements separately and identifies and analyzes the ways in which MS Office can come to Flyguys’ rescue.
MS Office is replete with options and ways to facilitate record keeping (Couch, 2013). Flyguys wants to keep records in a system which allows them to update, append and delete the records when necessary (FLIGHT...
8 Pages(2000 words)Coursework