Thursday, August 25, 2016

calculate calender days resource available

HiI am building a spread sheet that shows how many days a resource will be available in each month of a year based on a start and end date.Each line of the sheet (B6 onwards) is dedicated to 1 individual resource and that individual is not repeated in other rows.The formula below works great using a start date but I need to build in an end date so be more accurate.=IF($L6>0,IF(O$5>$I6,O$4*$L6,IF(O$4-NETWORKDAYS(O$5,$I6,Data!$B$6:$B$14)>0,(O$4-NETWORKDAYS(O$5,$I6,Data!$B$6:$B$14))*$L6,0)),"")This formula is used in cells C6 through Z6 therefore each cell represents 1 month.formula Cell ref defination.Cell L6 is a percentage number stating their default availability per working day i.e.100% will be full working day whereas 50% would mean only for 1/2 a day.Cell O5 is a calender month in the format Jan-11Cell O4 is the working days available in the month shown in O5Cell I6 is the start date i.e.05/04/2011 Cell j6 would be the end date

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

Another Safe way to Repair the Problem: calculate calender days resource available:

How to Fix calculate calender days resource available with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

BSOD ntoskrnl.exe (nt+0x14DCA0) Frequent crashes of W 8.1

Hello,

recently I have bought a new computer with W 8.1 and so far so good.However I get frequent but not periodic BSODs and restarts of the system regardless of system usage or any running program.Sometimes it happens just right after the login screen dissappears. That´s really unplesant.My BIOS is up to date, no new updates are availible.It seems to be caused by ntoskrnl.exe (nt+0x14DCA0) according to Who Crashed program...Here´s the analysis:

To install drivers and other optional updates

To install optional updates, you need to review and then select them from the list of updates that Windows finds for your computer. Optional updates are not installed automatically.

Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.

In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.

If any updates are found, click View available updates.

Select the optional updates that you want, and then click Install. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Another Safe way to Fix the Problem: BSOD ntoskrnl.exe (nt+0x14DCA0) Frequent crashes of W 8.1:

How to Fix BSOD ntoskrnl.exe (nt+0x14DCA0) Frequent crashes of W 8.1 with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.

How to Fix C:\PROGRA~2\INTERN~2\Launcher.exe with SmartPCFixer?

1. Download Error Fixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Burnt DVD can play on my computer ok, but not on the DVD players, why?

I followed the instructions on Microsoft DVD Maker to burn a slide show. I am using the 2011 version of Microsoft DVD Maker, and my computer is running Microsoft Window 7. It works fine and it can play on my computer like it should be, but it can not be read on the DVD players (I tried 2 players, both say no disk), and it cannot play. I used a DVD+R blank disks, and I used the the master format to play on the DVD players. I tried 3 different speed of burning, fast, medium and slow, but it still cannot play on the DVD players. I also tried two different levels of resolution (HD and regular DVD setting for saving the movie files) on the movie files, but I still has the same problem. This is getting extremely frustrated, as I used the software before, and it was ok. Can somebody help and shed some light?

Keys to the Problem Burnt DVD can play on my computer ok, but not on the DVD players, why?

How to Avoid Downloading Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Don't install download manager

Many sites suggest or require you to install an installer or a download manager before allowing you to download a program you may be interested in downloading. These tools almost always cause your computer more problems and may even have malware or other spyware. Avoid any site claiming anything must be installed first before you can continue with your download.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Another Safe way to Fix the Problem: Burnt DVD can play on my computer ok, but not on the DVD players, why?:

How to Fix Burnt DVD can play on my computer ok, but not on the DVD players, why? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your system. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Solutions to the Problem Bought laptop with Windows 8--How do I backup the system in case it crashes?

Why not do it a couple ways.Easiest way is to make yourself a system image using the control panel / Windows 7 file recovery.

Another way might be read up on the RecImg command.

http://support.microsoft.com/kb/2748351?wa=wsignin1.0

Turn on FileHistory in control panel and then you can just reinstall windows, if you have a windows dvd.

I actually like the free EaseUS Todo Backup 2x weekly save 4. & the win system image daily. Works well for me. With the easeus I can get any single file or folder or all, anytime - plus its preOS option gives a nice easy way to use f8, or reimage, or access to the win8 repair environment at boot.

Download the Microsoft Windows ISO (installation device) from the following website:

http://www.microsoft.com/en-us/software-download/windows10

Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.

Extract the ISO file to a separate USB device or burn the program to a compact disc.

Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Another Safe way to Repair the Problem: Bought laptop with Windows 8--How do I backup the system in case it crashes?:

How to Fix Bought laptop with Windows 8--How do I backup the system in case it crashes? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your system. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed

Bypass the save as macro free workbook pop-up

HelloI was wondering is there a way to bypass the save a macro free workbook pop-up when I try to saveas.I have two buttons on my template file one of the buttons is assigned to a macro that saves the file by getting info from the file.Below is the code.Sub SavingFile()Application.ScreenUpdating = False Dim myPath As String Dim myFile As String Dim myExt As String Dim FileFormat As Long Dim mySerial As String'' Set Varibles' myPath = "K:\Engineering\Project Planning Sheets\" myFile = "44OP-" & Range("AB8").Value & "_" & Range("H5").Value & "_" & Range("G8").Value myExt = ".xlsx": FileFormatNum = 51 mySerial = ""ActiveWorkbook.SaveAs Filename:=myPath & myFile & mySerial & myExt, _ FileFormat:=FileFormatNumApplication.ScreenUpdating = TrueEnd Sub As a side note, is there a way to remove the button so the user does not seet them when saving to a macro-free file

Solutions to the Problem c drive is not accessable.

1.What is the make and model of the computer?2.Do you remember making any changes to the computer?3.What is the security software installed on the computer?4.What is the exact and complete error message?5.Have you logged in as administrator?

Method 2.Follow these steps in safe mode to grant yourself full permission to access the drive:You must be logged on as an administrator to perform these steps1.Click on start and then click on computer.2.Right click on C drive and click Properties, and then click the Security tab.3.Click Advanced, and then click the Owner tab.4.Click Edit, and then do one of the following:· To change the owner to a user or group that is not listed, click Other users and groups and, in Enter the object name to select (examples), type the nameof the user or group, and then click OK.

· To change the owner to a user or group that is listed, in the Change owner to box, click the new owner.5.If you want to take ownership of the contents of the folder, select the Replace owner on sub containers and objects check box.6.Click OK, and then click Yes when you receive the following message: You do not have permission to read the contents of directory folder name.Do you want to replace the directory permissions with permissions granting you Full Control?7.Click yes.All permissions will be replaced once you click yes.

NOTE:-> An administrator can take ownership of any file on the computer.

-> Assigning ownership of a file or a folder might require you to elevate your permissions using User Access Control.You may refer these links for help:What are permissions:http://windows.microsoft.com/en-us/Windows7/What-are-permissionsWhat to know before applying permissions to a file or folder:http://windows.microsoft.com/en-US/Windows7/What-to-know-before-applying-permissions-to-a-file-or-folder

Method 3.You can run the Microsoft Safety Scanner to make sure that the computer is free from viruses.Microsoft Safety Scanner: http://www.microsoft.com/security/scanner/en-us/default.aspxSafety Scanner Disclaimer: There could be a loss of data while performing a scan using Microsoft safety scanner to eliminate viruses if any.Hope this helps.

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Recommended Method to Fix the Problem: c drive is not accessable.:

How to Fix c drive is not accessable. with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed

C:Windows\System32|DeviceCenter32.dll is either not designed to run on Windows or it contains an error.

I receive the following error on EVERYTHING I try to open on my HP laptop.

C:Windows\System32|DeviceCenter32.dll is either not designed to run on Windows or it contains an error.Try installing the program again using the original installation media or contact your system administrator or the software vendor for support.

I have download all the HP and Microsoft updates and I still get this error when I try to open any program.How can i correct this?

Anwsers to the Problem C:Windows\System32|DeviceCenter32.dll is either not designed to run on Windows or it contains an error.

Hi, As this could be a virus or trojan issue. You need to follow the below forum link to run Malware scan on your computer and check for the issue. http://social.answers.microsoft.com/Forums/en-US/vistasecurity/thread/ba80504b-61f1-4d71-960f-b561798b7b42 As a workaround you may perform an online scan on your computer and check for the issue. Now visit the below provided link to perform an online scan on your computer. http://onecare.live.com/site/en-us/default.htm Thanks and Regards:I.Suuresh Kumar- Microsoft Support.

Visit our Microsoft Answers Feedback Forum and let us know what you think.

Use the System File Checker tool to repair corrupted or missing system files:

Click Start.

Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).

The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.

Type or copy paste the below command line into it without quotes:

"Sfc /scannow"

Recommended Method to Repair the Problem: C:Windows\System32|DeviceCenter32.dll is either not designed to run on Windows or it contains an error.:

How to Fix C:Windows\System32|DeviceCenter32.dll is either not designed to run on Windows or it contains an error. with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

When I restart my computer, I receive the message BTTray error unable to start Bluetooth stack service.I have looked at some of the answers for the problem and it looks like the best solution is to uninstall the drivers and reinstall them.I just got my computer a week ago and it has been having this problem each time I turn it on.It is an HP DV6 6070CA running windows 7 Premium 64 bit.I would try to uninstall my drivers and reload them but I am unsure which drivers I am supposed to uninstall.When I go to device manager, under the section labelled Bluetooth Radios there are two things listed, Broadcom 2070 Bluetooth and Microsoft Bluetooth Enumerator.I can click on both of them and get the uninstall driver option but do I uninstall both of them? Also do I have to reinstall them manually? I am kind of novice when it comes to these things and I could really use some help, any answers?