Question about Microsoft Office Professional 2007 Full Version for PC

Hi

I have a database of a person's working hours where I have his three months

extra or less working hours. I want an average of all the three months.

Can someone help me with the formula for this average. Here the average

formula is not giving the correct value.

Month 1 Month 2 Month 3 Average

-08:31:00 -24:50:00 21:01:00 ?

Hi Aviks,

Normal average works well for linear distribution, but here is non-linear distribution of work. So here is the formula that has been taken from project management concepts. Please try for different values of x and y

Try to keep x+y=6

=(StandardWorkingHr*x+(ActualWorkingHr-StandardWorkingHr)*y)/(x+y)

e.g.

=(StandardWorkingHr*5+(ActualWorkingHr-StandardWorkingHr)*1)/5)

if you can share data with me, I can give you the exact formula.

Posted on Mar 09, 2009

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

This is a mathematical notation for a function of a variable x.

Let there be two quantities say the number of hours worked per week (x) and the salary you get paid (y).

The number of hours you work is the independant variable. The salary paid is the dependant variable.

For each amount of hours you work, your boss calculates the salary that is owed you at the end of the week. The method your boss uses to calculate your salaray is the function.

Symbolically, this can be represented as

Salary ($)=f(hours vorked) or

y=f(x)

For example: if the hourly rate is 8$/h and you work 35h then what is owed you is

35h*8$/h=280$

If you work more hours you will get more pay and if less hours, less pay

The rule is y=8*x

Let there be two quantities say the number of hours worked per week (x) and the salary you get paid (y).

The number of hours you work is the independant variable. The salary paid is the dependant variable.

For each amount of hours you work, your boss calculates the salary that is owed you at the end of the week. The method your boss uses to calculate your salaray is the function.

Symbolically, this can be represented as

Salary ($)=f(hours vorked) or

y=f(x)

For example: if the hourly rate is 8$/h and you work 35h then what is owed you is

35h*8$/h=280$

If you work more hours you will get more pay and if less hours, less pay

The rule is y=8*x

Jun 16, 2010 | Vivendi Excel@ Mathematics Study Skills...

Hi,

Thanks for using fixya , but could you be more specific , with the application or the software you are trying to use these functions in ,

eg, Microsoft excel or normal windows calculator .

Thanks

proton

Thanks for using fixya , but could you be more specific , with the application or the software you are trying to use these functions in ,

eg, Microsoft excel or normal windows calculator .

Thanks

proton

Oct 11, 2008 | Computers & Internet

You can access the .pdf manual for your particular calculator here:

http://www.sharpusa.com/files/cal_man_EL1750PIII.pdf

Page 1 for how to set date/time:

“RATE SET”: To set the date, time, and tax rate, set this switch at the “RATE SET” position.

**
Date:**

• Enter in the order of month, day and year, then press to complete the entry.

• Use to separate month, day, and year.

• When is pressed, the number entered is evaluated and displayed as “date” if the

value is within the following range; “Error” is displayed otherwise, and the previously set

date is restored.

Month: 1 - 12; day: 1 - 31; Year: 2000 - 2099 (in 4 digits) or 00 - 99 (in 2 digits)

**
Time:**

• Enter in the order of hour, minutes, then press to complete the entry.

(There is no entry available for the seconds value. The clock starts at zero second.)

• If the hour/minute digit is less than 10, it is not necessary to enter the first digit “0”.

• Use to separate hour and minute values.

• When is pressed, the number entered is evaluated and displayed as “time” if the

value is within the following range; “Error” is displayed otherwise, and the previously set

time is restored.

Hour: 0 - 23 (24-hour system for the hour entry), Minute: 0 - 59

http://www.sharpusa.com/files/cal_man_EL1750PIII.pdf

Page 1 for how to set date/time:

“RATE SET”: To set the date, time, and tax rate, set this switch at the “RATE SET” position.

• Use to separate month, day, and year.

• When is pressed, the number entered is evaluated and displayed as “date” if the

value is within the following range; “Error” is displayed otherwise, and the previously set

date is restored.

Month: 1 - 12; day: 1 - 31; Year: 2000 - 2099 (in 4 digits) or 00 - 99 (in 2 digits)

(There is no entry available for the seconds value. The clock starts at zero second.)

• If the hour/minute digit is less than 10, it is not necessary to enter the first digit “0”.

• Use to separate hour and minute values.

• When is pressed, the number entered is evaluated and displayed as “time” if the

value is within the following range; “Error” is displayed otherwise, and the previously set

time is restored.

Hour: 0 - 23 (24-hour system for the hour entry), Minute: 0 - 59

Apr 27, 2009 | Sharp EL-1750PIII Calculator

Format both cells with the time format "h:mm AM/PM".

Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as: "h:mm"

Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as: "h:mm"

Apr 16, 2009 | Microsoft Excel for PC

Its the same only the interface is different. Use the same technique of the Mathematical algorithm keeping in mind the way the date, time are displayed in their format. Also switch to 24 Hr mode....sodeep

Mar 20, 2009 | Microsoft Office Excel 2007

use the below formula to get the date of the LWD (Monday thru Friday) of the month.

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

Excel is a spreadsheet - it is less structured than a database and all of the data appears on one (or more) pages along with many calculations and summaries of data.

A database is structured so that all the information is kept in the same format for each member record of the database - Databases are better at processing larger volumes of information.

Some tasks can be performed equally well in either spreadsheet or database -

Often data is stored in a database but analysis is done in the spreadsheet.

A database is structured so that all the information is kept in the same format for each member record of the database - Databases are better at processing larger volumes of information.

Some tasks can be performed equally well in either spreadsheet or database -

Often data is stored in a database but analysis is done in the spreadsheet.

Nov 20, 2008 | Microsoft Excel for PC

Hello,

The formula should go like this:

=IF(C11>40,(C11-40)*D11,0)

This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.

Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:

=IF(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

The formula should go like this:

=IF(C11>40,(C11-40)*D11,0)

This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.

Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:

=IF(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

Sep 14, 2008 | Computers & Internet

Just enter using this style

**TIME IN**
**TIME OUT**
** HOURS**
10:00
16:50
6:50
10:22
17:34
7:12
9:00
10:00
1:00

the formula in HOURS is Time Out - Time In

the formula in HOURS is Time Out - Time In

Mar 20, 2008 | Computers & Internet

When i first figured out how to pull data from SQL and put the results in an excel file i referenced these two articles....

Reading and writing excel file using VB.NET (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx)

Get the Values From DataBase and Stored into excell Sheet (http://www.codeproject.com/KB/vb/Getvaluesfromdatabase.aspx)

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"

Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"

Dim cnt As New ADODB.Connection

Dim rst As New ADODB.Recordset

Dim fld As ADODB.Field

'Open the connection.

cnt.Open(stcon)

'Open the recordset.

With rst

.CursorLocation = ADODB.CursorLocationEnum.adUseClient

.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _

ADODB.LockTypeEnum.adLockReadOnly , _

ADODB.CommandTypeEnum.adCmdText)

.ActiveConnection = Nothing 'Disconnect the Recordset.

End With

'Close the connection

cnt.Close ()

Dim exp As Export = New Export()

Dim xlApp As New Microsoft.Office.Interop.Excel.Application

Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )

Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)

Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")

Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation

Dim i As Short

'Turn off Excel's calculation.

With xlApp

xlCalc = .Calculation

.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual

End With

'Write the fieldnames.

For Each fld In rst.Fields

xlRange.Offset(0, i).Value = fld.Name

i = i + 1

Next

'Populate the range.

xlRange.Offset(1, 0).CopyFromRecordset(rst)

'Close the recordset.

rst.Close()

'Make Excel available to the user.

With xlApp

.Visible = True

.UserControl = True

'Restore the calculation mode.

.Calculation = xlCalc

End With

'Release variables from memory.

fld = Nothing

rst = Nothing

cnt = Nothing

xlRange = Nothing

xlWSheet = Nothing

xlWBook = Nothing

xlApp = Nothing

Reading and writing excel file using VB.NET (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx)

Get the Values From DataBase and Stored into excell Sheet (http://www.codeproject.com/KB/vb/Getvaluesfromdatabase.aspx)

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"

Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"

Dim cnt As New ADODB.Connection

Dim rst As New ADODB.Recordset

Dim fld As ADODB.Field

'Open the connection.

cnt.Open(stcon)

'Open the recordset.

With rst

.CursorLocation = ADODB.CursorLocationEnum.adUseClient

.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _

ADODB.LockTypeEnum.adLockReadOnly , _

ADODB.CommandTypeEnum.adCmdText)

.ActiveConnection = Nothing 'Disconnect the Recordset.

End With

'Close the connection

cnt.Close ()

Dim exp As Export = New Export()

Dim xlApp As New Microsoft.Office.Interop.Excel.Application

Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )

Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)

Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")

Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation

Dim i As Short

'Turn off Excel's calculation.

With xlApp

xlCalc = .Calculation

.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual

End With

'Write the fieldnames.

For Each fld In rst.Fields

xlRange.Offset(0, i).Value = fld.Name

i = i + 1

Next

'Populate the range.

xlRange.Offset(1, 0).CopyFromRecordset(rst)

'Close the recordset.

rst.Close()

'Make Excel available to the user.

With xlApp

.Visible = True

.UserControl = True

'Restore the calculation mode.

.Calculation = xlCalc

End With

'Release variables from memory.

fld = Nothing

rst = Nothing

cnt = Nothing

xlRange = Nothing

xlWSheet = Nothing

xlWBook = Nothing

xlApp = Nothing

Jan 03, 2008 | Computers & Internet

220 people viewed this question

Usually answered in minutes!

×