Given a value (X) and the number of significant digits (SD)
The number of decimal places is given by the following formula:
=SD - INT(LOG10(X)) - 1
You can then convert to text the appropriate value by using:
=FIXED(X, SD - INT(LOG10(X)) - 1)
ROUND will not work, since you must also change the number of fixed decimal places in the display.
The VALUE function can be used with the "FIXED text" to convert the text to a numeric value for calculations.
maandag 23 februari 2009
maandag 9 februari 2009
HP Pavilion DV7-1145EB
Technische specificaties van de HP Pavilion DV7-1145EB Azerty
MKR 11/02/09 849,-€
- Product
Fabrikantcode NF235EA#UUG - Processor
Processorfamilie Intel Core 2 Duo
Processornummer P7350
Kloksnelheid 2000 MHz
Level 2 cache-geheugen 1066 MB
Front side bus 3 MHz - Geheugen
Intern RAM-geheugen 4096 MB
Geheugen uitbreidbaar
Maximaal RAM-geheugen 8192 MB
Type geheugen SO-DIMM DDR2 - Harde schijf
Capaciteit harde schijf 320 GB
Type Harde Schijf SATA
Snelheid harde schijf 5400 rpm
Aantal schijven (intern) 1 - Beeldscherm
Schermdiagonaal 17 inch
Schermresolutie 1440 x 900 pixels
Schermtype TFT-LCD
Schermoppervlak Glanzend
Widescreen 16:9
Touchscreen n.v.t. - Videokaart
Videokaartfamilie NVIDIA GeForce
Type videokaart 9200M GS
Videogeheugen 256 MB
Totaal videogeheugen 1535 MB
DirectX 10 - Optische drive
DVD-speler/-brander DVD+/-RW DL LightScribe
Blu-ray : NO - Communicatie
RJ45 Ethernet 10/100/1000 LAN (Gigabit Ethernet)
Draadloos netwerk (WLAN) Draadloos 802.11b/g/n (300 Mbit/s)
Bluetooth: NO
Bluetooth-versie N.v.t.
Bluetooth-klasse N.v.t.
RJ11 Modem Ingebouwd 3G modem
Infrarood (IrDA) - Audio
Audiosysteem 3D Sound Blaster Pro compatibel 16-bits
Luidspreker Ja, stereo
Speakers 2
Geïntegreerde subwoofer Altec Lansing Subwoofer - Camera
Webcam - Bediening
Type toetsenbord AZERTY
Volwaardig toetsenbord
Numeriek keypad
Multimediasneltoetsen
Touchpad
Trackpoint: NO
Afstandsbediening - Aansluitingen
USB 2.0
Aantal USB-poorten 4
IEEE 1394 FireWire e-SATA
Dockingstation
VGA
HDMI-out
DVI : No
TV-out : No
TV-tuner : NO
3,5 mm Audio Ja, gecombineerd met microfoon
3,5 mm Microfoon Ja, gecombineerd met audio
Audio-out Mini-jack 3,5 mm
S/PDIF : NO
Cardreader : Yes
Geheugenkaart Memory Stick, Memory Stick Pro, Multi Media Card (MMC), SD (Secure Digital), xD (Xtreme Digital)
ExpressCard-slot :54
PCMCIA-slot : No
PS/2 : NO
Seriëel : NO
Parallel :NO - Beveiliging
Biometrische fingerprint-reader :NO
BIOS-wachtwoord : Yes
Harde schijf bescherming : NO - Accu
Stroomvoorziening Li-Ion-accu
Aantal cellen 8 - Software
Besturingssysteem Windows Vista Home Premium
Taal besturingssysteem Nederlands, Engels, Frans
MS Office Ready - Fysieke eigenschappen
Lengte 28,5 cm
Breedte 39,6 cm
Dikte 4,5 cm
Gewicht 3460 gram
Kleur Zilver - Overige
Model HP Pavilion
Handleiding Nederlands (schriftelijk), Engels (schriftelijk), Frans (schriftelijk), Nederlands (CD/DVD), Engels (CD/DVD), Frans (CD/DVD)
Fabrieksgarantie 2 jaar
Garantietype Pick-up-and-return-garantie
donderdag 29 januari 2009
IE7 shortcutkeys
1.) Ctrl + T - Opens a new tab in the foreground.
2.) Ctrl + Click - Opens links in a new tab in the background.
3.) Ctrl + Shift + Click - Opens links in a new tab in the foreground.
4.) Alt + Enter - Opens a new tab from the address bar.
5.) Alt + Enter - It also opens a new tab from the search box.
6.) Ctrl + Q - Opens up quick tabs, which are thumbnail views.
7.) Ctrl + Tab or Ctrl + Shift + Tab - Allows you to switch between tabs.
8.) Ctrl + N - Switches to a specific tab number. In this case, N can equal anything between the numbers one and eight.
9.) Ctrl + 9 - Switches to the last tab.
10.) Ctrl + W - Closes the current tab.
11.) Ctrl + Alt + F4 - Closes other open tabs.
12.) Alt + F4 - Closes all the tabs.
Now, here are a few mouse shortcuts for you as well!
1.) Click the middle mouse button (if your mouse has one) on a link and it will open up that link in a background tab for you.
2.) Double click any empty space right next to the last tab you have open and it will open up a brand new tab.
3.) If you click on the middle mouse button on one of your tabs, it will close the tab for you.
2.) Ctrl + Click - Opens links in a new tab in the background.
3.) Ctrl + Shift + Click - Opens links in a new tab in the foreground.
4.) Alt + Enter - Opens a new tab from the address bar.
5.) Alt + Enter - It also opens a new tab from the search box.
6.) Ctrl + Q - Opens up quick tabs, which are thumbnail views.
7.) Ctrl + Tab or Ctrl + Shift + Tab - Allows you to switch between tabs.
8.) Ctrl + N - Switches to a specific tab number. In this case, N can equal anything between the numbers one and eight.
9.) Ctrl + 9 - Switches to the last tab.
10.) Ctrl + W - Closes the current tab.
11.) Ctrl + Alt + F4 - Closes other open tabs.
12.) Alt + F4 - Closes all the tabs.
Now, here are a few mouse shortcuts for you as well!
1.) Click the middle mouse button (if your mouse has one) on a link and it will open up that link in a background tab for you.
2.) Double click any empty space right next to the last tab you have open and it will open up a brand new tab.
3.) If you click on the middle mouse button on one of your tabs, it will close the tab for you.
dinsdag 27 januari 2009
Calculate Age
=IF(DATEDIF($A2,NOW(),"y")<10," ","") & DATEDIF($A2,NOW(),"y") & " years, "
& IF(DATEDIF($A2,NOW(),"ym")<10," ","") & DATEDIF($A2,NOW(),"ym") & " months,
" & IF(DATEDIF($A2,NOW(),"md")<10," ","") & DATEDIF($A2,NOW(),"md") & " days"
& IF(DATEDIF($A2,NOW(),"ym")<10," ","") & DATEDIF($A2,NOW(),"ym") & " months,
" & IF(DATEDIF($A2,NOW(),"md")<10," ","") & DATEDIF($A2,NOW(),"md") & " days"
maandag 26 januari 2009
HP-Pavilion-dv7-1150eb
MKR 28ja09 / 999€
17''
Intel Core 2 Duo P8400
3GB Ram
500 GB HD
NVIDIA Geforce 9200M GS 256 MB, HDMI & e-SATA
17''
Intel Core 2 Duo P8400
3GB Ram
500 GB HD
NVIDIA Geforce 9200M GS 256 MB, HDMI & e-SATA
vrijdag 19 december 2008
ADD Windows Vista Taskbar thumbnails
Windows Vista Taskbar thumbnails
HKEY_CURRENT_USER\Control Panel\Desktop\WindowMetrics
KeyValueType:String Value
KeyValueName:MinWidth
KeyValueData:-285
HKEY_CURRENT_USER\Control Panel\Desktop\WindowMetrics
KeyValueType:String Value
KeyValueName:MinWidth
KeyValueData:-285
zaterdag 13 december 2008
All I can ever see is that little red X in my e-mail, in my Web browser
All I can ever see is that little red X in my e-mail, in my Web browser
One of the main areas where people see the red X is in their e-mail. If you use Outlook Express and are having trouble seeing pictures in your e-mail, open it up and go to Tools, Options and choose the Security tab. Make sure the "Block images and other external content in HTML e-mail" box is unchecked. Now, if you're sending an e-mail and people have been complaining to you about the pictures not showing up, try this: open up OE and go to Tools, Options, Send tab. Under the Mail Sending Format section, make sure HTML is selected and then click on the HTML Settings button. From there, make sure the "Send pictures with messages" box is checked. That should solve all of your e-mail issues.
If you're having trouble seeing images in Internet Explorer, go to Tools, Internet Options and click on the Advanced tab. Look for the Multimedia section and make sure the box that says "Show Pictures" is checked. For Firefox, go to Tools, Options and click on the Web Features icon. Make sure the "Load Images" box is checked as well.
Another cause may be that your browser security settings are set too high, which prevents you from accessing the Web site that handles the images. In IE, go to Tools, Internet Options, Security tab and click on the Default Level button. Make sure your settings are set somewhere around the medium level.
Another cause could be your antivirus or firewall settings. Look for a setting that says "Disable Web Bugs" and make sure it's turned off. That should allow all the images to pass through so that you can see them.
There are also a couple other simple reasons why your images may be blocked. One is that you're looking at a Web site that is busy, temporarily shut down or offline. A Web host could also be working on certain things on the site, causing the images to be down. If everything else we've discussed above is set correctly and you're still not seeing the images, that might be your problem. All you can really do is just try the site again later. Also, when you're trying to view images on a Web site or in your e-mail, make sure you're actually connected to the Internet, because they will not show up if you're not online.
One of the main areas where people see the red X is in their e-mail. If you use Outlook Express and are having trouble seeing pictures in your e-mail, open it up and go to Tools, Options and choose the Security tab. Make sure the "Block images and other external content in HTML e-mail" box is unchecked. Now, if you're sending an e-mail and people have been complaining to you about the pictures not showing up, try this: open up OE and go to Tools, Options, Send tab. Under the Mail Sending Format section, make sure HTML is selected and then click on the HTML Settings button. From there, make sure the "Send pictures with messages" box is checked. That should solve all of your e-mail issues.
If you're having trouble seeing images in Internet Explorer, go to Tools, Internet Options and click on the Advanced tab. Look for the Multimedia section and make sure the box that says "Show Pictures" is checked. For Firefox, go to Tools, Options and click on the Web Features icon. Make sure the "Load Images" box is checked as well.
Another cause may be that your browser security settings are set too high, which prevents you from accessing the Web site that handles the images. In IE, go to Tools, Internet Options, Security tab and click on the Default Level button. Make sure your settings are set somewhere around the medium level.
Another cause could be your antivirus or firewall settings. Look for a setting that says "Disable Web Bugs" and make sure it's turned off. That should allow all the images to pass through so that you can see them.
There are also a couple other simple reasons why your images may be blocked. One is that you're looking at a Web site that is busy, temporarily shut down or offline. A Web host could also be working on certain things on the site, causing the images to be down. If everything else we've discussed above is set correctly and you're still not seeing the images, that might be your problem. All you can really do is just try the site again later. Also, when you're trying to view images on a Web site or in your e-mail, make sure you're actually connected to the Internet, because they will not show up if you're not online.
Abonneren op:
Reacties (Atom)