Question about Microsoft Excel for PC

Open Question

Spread sheet problem

Dear Friend, In my P6, if i check the monthly plan for my project, am getting a cumulative value.But if i go for the weekly distribution, i am getting a different value. For Ex. The cumulative percent planned upto the month of July is 17.5%, but in the weekly distribution, in 26th July itself my cumulative planned value is 18.07%. Could you please help me to solve this issue. Regards Nair

Posted by on

Ad

5 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Ad
siFixedIt4Me
  • 18 Answers

SOURCE: Macro

Hi alwinkumar

You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.

Private Sub resetForm()

'formname.itemname = value
UserForm1.Label1 = "Hello World"

End Sub

For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below

numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count

Posted on Jul 19, 2008

Ad
t0pc4t
  • 132 Answers

SOURCE: EXCEL

When you say prepare . .
What data is going in - and what needs to come out ?

At the moment - it looks like you just need standard coloumn control...
From the standard input columns do you need to break the data down into specifics (Ie time frames etc...which will incorporate cumulatives..)
I would personally suggest using MS Access - you will have greater control and GUI to minimize accidental deletion etc..

Posted on Aug 18, 2008

  • 36 Answers

SOURCE: Creating vacation accrual spreadsheet

Here is one way to do it:
1. In column A enter the name
2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)
3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)
4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)
5. In column E, put this formula:
(D2/30)*1.25 (assuming this is line 2)
You can then copy these lines as many times as you need to, total them, etc.

Posted on Dec 30, 2008

ali_zulfikar
  • 156 Answers

SOURCE: Change of colummn

Macro1
Sub Dist1()
'
' Dist1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+D
'
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), _
TrailingMinusNumbers:=True
End Sub

Macro2
Sub Dist2()
'
' Dist2 Macro
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Selection.Copy
ActiveCell.Offset(0, 2).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub

if have any probs pl contact me

Zulfikar Ali
ali_zulfikar@yahoo.com
09899780221

Posted on Mar 21, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I pull a figure from a spread sheet and add it to another in the same file.....


Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

2 Answers

What Exactly Is A Forecast?


a forecast in business is the presumption that the goals set by the business plan will be met at all key indicator points

Nov 17, 2015 | Retail Supplies

1 Answer

I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help?


I assume that the dates you want adjust are in date form and are in regular columns (or rows).
If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))
where the original date is in cell A3.
You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

Oct 17, 2013 | 1996 Italdesign Formula

1 Answer

Sony wega lcd tv blue dots


thats caused by the optical block which is very expensive to replace. Sony has had alot of issues with the blue dots on the screen its not worth repairing due to the high cost of the optical block

Feb 28, 2013 | Sony Grand WEGA KDF-60XS955 60" Rear...

1 Answer

P5 tutorial


i am a p3 user i want to use p6 but i dont understant how to use for that i need p6 tutorial so that i can use p6 easily

Jun 25, 2009 | Primavera Project Planner P3 (PRIMAVERAP3)...

1 Answer

I have printer HP PSC 500 S/N SGH02E112T WORKED FOR 5 YRS - NOW WILL NOT PRINT EXCEL SPREAD SHEETS OR WORD DOCUMENTS - STILL PRINTS EMAIL AND INTERNET DOCUMENTS HAVE HAD OTHERS CHECK SETTINGS...


Friend,

There's apparently a problem bwtween your Office suite and the spooler. Usually uninstalling/reinstalling the Office suite will fix the problem. (please do a backup of all your Office documents before proceeding!)

When reinstalling, please make sure that any antivirus program is shut down or deactivated during install, in some cases for example Norton Antivirus will block files that need to be updated, causing problems. You SHOULD use some form of virus protection when using your computer, don't get me wrong! :)

//Al

Mar 08, 2009 | HP PSC 1210 All-In-One InkJet Printer

2 Answers

Primavera financial reporting


Have you considered creating a regular export from P6 and using Access or some other reporting tool to generate your reports? I could set you something if I new the specifics of what you are trying to get.

Feb 10, 2009 | Primavera Contractor 6.1 Full Version for...

1 Answer

Need a formula for excel


select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

3 Answers

Primavera P6


I am new in P6. I have a problem that how can we add target in any project like P3? Can u please help me.

Jun 20, 2008 | Primavera Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

14 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2851 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...