ctaylor17

Alright it's working now. Thanks guys

I am trying to make a bill of materials that include price, quantity, and shipping cost. A teammate created a formula to add up the total cost and I am duplicating it for my part of the budget, but it is just returning "#VALUE". Also, when I click on the formula he wrote to view it then press enter it returns "#VALUE" even though it was had the correct number before I clicked on it and pressed enter. Bellow are screenshots of my process: the correct total is displayed, I double click on the number to view the formula, I press enter and it returns "#VALUE"

Even though it is plugged into the m.2 slot it could use the SATA interface instead of PCI-e. Here is an m.2 SATA ssd:http://www.newegg.com/Product/Product.aspx?Item=N82E16820147398

I am using the Asus z170-a motherboard, i5 6600k cpu, and a single 8GB stick of ram. My samsung 950 pro ssd is running slow. I am only getting ~560 MB/s read and ~95 MB/s write. I used the samsung magician software to test speeds. I think that the m.2 is using SATA instead of PCI-E for some reason witch would explain the ~550 MB/s read speeds, but wouldn't I still be getting ~550 MB/s write speeds too? I installed the NVMe driver and my bios is up to date. Could it be the motherboard that is causing a problem? Faulty drive? I have also reinstalled windows and followed the correct procedure for installing windows on an m.2 drive. M.2 storage (EX. Samsung M.2 950 Pro) to install OS like Win 7, 8.1 or 10) For Windows 8.1, 10 only: a. BIOS->Boot->CSM (Compatibility Support Module)->Disable b. BIOS->Boot->Secure Boot->OS Type->Other OS c. BIOS->Boot->Secure Boot->Key Management->Clear Secure Key d. F10 (save and exit) e. Install OS only with bootable UEFI media. f. Re-enter BIOS after first restart during the OS installation, it will be shown within the BIOS g. BIOS->Boot->Secure Boot->OS Type->Windows UEFI mode h. BIOS->Boot->Secure Boot->Key Management->Install Default Secure Boot Keys i. F10 (save and exit) j. It should resume the installation, if not, completely power down the system and turn it back on after 10 seconds. k. Note: do not connect any external devices to the computer during the installation and best if only the M.2 SSD is installed on the system. l. Install Samsung NVMe drivers for performance

It looks like an excellent phone especially for the price.

It depends on your budget and what you will be using it for. If you will be mostly gaming LGA1151 and an i5 6600k should do great or if you want to spend more you can change out the i5 for an i7 6700k.

At the $200 price point the 480 would be better just there isn't another current generation card for $200.

The 1060 has 6gb of vram

My recommendation would be to get the GTX 1060. The more powerful 1060 will perform better than the 480 even though it has more vram.

The PSU is FINE you aren't going to be pulling more than 500 watts with one GPU

His PSU is fine. I would upgrade to an i7 4790k CPU or save up a little more and upgrade to skylake with the i7 6700k and DDR4.

Since the light being produced by the LEDs is green the film won't change the color. If you put a color filter over white light witch is a mix of all colors then it will produce the color of the filter because the only color that can shine through is the color of the filter(all other colors are blocked). It won't work.

If your graphics card isn't a bottleneck then I would recommend the i7 4790k, but your CPU might not be the thing bottle necking your PC. Depending on what graphics card you are using it might make more sense to upgrade your graphics card.

What graphics card are you using?

http://www.gigabyte.us/products/product-page.aspx?pid=5823#kf this is a lot slimmer that the alienware and should suit your needs.