How to use a phase tester to determine the current-carrying contacts
A phase tester is a screwdriver with transparent handle and an additional function: with its help, you can detect voltages in the range of 100-250 volts.
While you hold the tip to a contact, such as a wall outlet and touch the metal button on the rear end with a finger. a voltage is present at the contact, then the current flows through the device, your body and the ground. to display a phase controller built-in neon lamp.
That it is received no electric shock at the high resistance of the auditor of about one megohm, which leads strength to a harmless low current.
Iphone: the volume of data to measure
You want to have consumes, know the volume of data with your iphone on the go ? then read here how you can find the fuel consumption display in ios, and even data-intensive apps individually can disable it.
How to determine the volume of transferred data
With the following working steps, you will find out how much data your iphone or ipad to consume.
- Open the settings , and select the heading Mobiles network (4. Entry from the top).
- Scroll down a bit until you see the list of installed Apps with data usage.
- Also see the data consumed in the mobile network since the last Reset of the counter. Including the data when Roaming abroad.
- The list of Apps shows you the data usage per application. In Bedartf you can prohibit individual Apps the mobile use.
The conditional formatting of excel for a blank or filled-in cells
Especially in large excel marked tables, it can be consuming to find the places in which data is entered. we show how you are using in such cases, excel’s conditional formatting to all the completed cells are clearly marked.
<, h2>do not change color when cell is empty
- Select the area in which the user enters data.
- tab, Click Start on Conditional formatting – New rule
- then Select the last rule type, the formula to determine the formatting of cells, use.
- As a formula, you use =(isEmpty(<first cell>)=FALSE)
- you have to enter instead of the placeholder <first cell> the address of the first cell top left in the marked area.
- Format give you now an eye-catching Format, if the formula is true, such as a strong background color.
The result looks like maybe so:
The function isempty() returns false, if the cell is fill. however, she reacts the same way to input text, such as headings or formulas. that’s why it is important to select in the selection, only the cells in which actual data are entered. otherwise, the column headers appear, for example, be highlighted and the overview is back there.
What to consider in a residual current protection switch to
More and more are also incorporated in a private house called the keep “error current protective switch” (the “fi-switch”), which provide increased security to the inhabitants against dangerous electric shocks.
Such a switch is if in your electrical distribution built-in, you should work on the following concerns: the fi-switch triggers when a connection between the zero – and the protective conductor is made even if the line was de-energized (e.g., flipping the toggle switch at the backup machine).
Have to set so if you want to avoid all the clocks, weckradios and the like in your house or apartment (even many alarm systems are extremely annoyed, on power interruption), then you are a good fit, that is never neutral and earth get in contact with each other!
To receive and send faxes with a fritzbox
You want to send with the fritzbox fax and receive? then read our guide to do so.
Many of the fritz! box models support fax, the received documents will then be forwarded either by e-mail as a pdf to you or on the fritzbox stored. werbefaxe cause then no paper waste, but you can easily delete it. what devices support this feature, you will find, for example, on this side of the avm wiki.
Fritzbox fax received
The best way is to dedicate one of the phone numbers of your isdn connection (msn) alone at the reception.
Go to the web interface of your fritzbox to the menu item telephony – telephony devices , and then click the button new device setting in the right pane.
When selecting the type you select from the bottom of the category “in the box integrates” the option fax.
Now you will see a screen with the basic settings
These settings knows the fritzbox for the fax reception
The fax-id is the phone number, the receiving side when sending your box. this should be the correct number, to avoid confusion. best to write the number in the international variant, as in the example with “+49” for germany, followed by the area code without the leading zero.
Including the variants for the further processing of the arrived faxes to come. practically, the e-mail version is safe. because you can view a fax on the go, if you have access to e-mail. enter in the address field of your address.
Alternatively, or in addition, you have the originals on one of the locations of the fritzbox drop, either on the internal memory of the box (only some devices) or a connected usb media.
Choose continue, then the fritzbox asks for the phone number to which the fax is to respond. please check the appropriate msn.
Account details for e-mail
Enter if you have not yet entered any notifications, directions options (system – push service), then your fritzbox asks now, according to the account data for e-mail.
The requires you to be able to your fritzbox via an e-mail account to send messages. it can be just as the account with which you want the faxes received, as well as a different account.
You need some data, such as your user name for e-mail, password, and the smtp server that is for the shipping charge. some of the well-known mail providers, the fritzbox knows some of the data already, so you need to enter only the most necessary.
Receiving a fax check
You send over a fax machine or the fax services, as in the case of arcor.de or gmx.de a document to the phone number. the shipping, works out to be the worst hurdle is already managed.
Now, depending on your settings, also soon an email arrives with a pdf file as an attachment. you have activated the internal storage, you can access the file sharing of the fritzbox, to come directly to the fax.
You have assigned for the share, still no drive letter, it works the fastest over the following entry in the windows start menu
Alternatively you can use it instead of the name “fritz!nas” the ip address of the box.
Each fax appears in this directory with the date and number of the sender.
Windows: the print job does not remove queue to delete
It can happen that a print job in the queue to cross, and will not be printed. the attempt to delete it is then displayed by the message “is deleted…”, the print job is to continue to hang and blocked all of the following prints. the solution is, the service “print spooler” stop and restart, which flushes the queue and removes the blockade.
The print queue delete
- The control of the services, please refer to the computer management. With Windows 10 click with the right mouse button on the start button and select in the appearing menu, select computer management – .
- on Windows versions 7 and 8, type “computer management” in the search box to the taskbar or the start menu.
- In the left part of the computer management to services and applications
- Within this section, you call up the sub-item, services, .
- Right now appears a long list of installed services.
- Go to item queue.
you don’t Want to search for a long time, you can click the list and give a “dru” and are the same on the target.
- Click the service with the right mouse button and select “Exit”. Alternatively, you can use the same name Link on the description of the service.
- Now you have a pop-up window about the progress of the operation.
- Once the service has been successfully shut down, wait a few seconds and use the same way as just to enable the Option to Start the queue again.
If you can now the see what’s printing, then the “lazy” entry should be gone. possibly behind the queued jobs are probably already printed.
Excel: millimeter, square meter and other measurement units to use
You are working in excel, currencies, is the automatic insertion of the euro symbol in the respective cells no problem – for this, excel has the practical euro button that does this for you. but you need other units, such as square feet, cubic meters or kilograms, you need to go the other way.
First things first: the direct type of the unity in the cell leads to the goal. for example, if you enter “25 kg”, then excel no longer displays the so, see the content but as a number. the result: you can no longer use the value in a formula. excel displays the error value is #num! instead of the result.
You create some solve this problem so that the right side of the cell with the numeric value of a cell for the unit of measure. but this is quite impractical, because when you move you have to move then this cell and the right optical distance to the numeric field is hard to get a handle to.
In word, the characters deep-set instructions and shortcuts
For chemical formulas, or other purposes, you have to put in writing individual characters in depth. they will appear smaller and below the surrounding characters. how to in word.
This gives you the conditional formatting of excel
With the establishment of conditional formatting excel provides an opportunity for effective optical effects, which are furnished in nu. that is not enough, you can reach by your own rules, goals, and individual goals.
The conditional formatting
Works the basic principle: based on the contents of cells of an effect on the optics. the conditional formatting colors, for example, all cell values of a in a eye-catching color, the fall from a normal value range, marked in a calendar, week-ends, colored, or in a list of orders, their delivery times are exceeded.
It is easiest if you use excel 2010 offered pre-made conditional formatting to provide such a cell depending on the value of a color. then you can differentiate it easily low of high cell values.
To leave the cells depending on value
- colorize, you Select a range of cells with numerical values.
- Click on tab Start icon on the Conditional formatting.
- From the opening selection menu, use the Option colour scale.
- Select one of the available gradients. They differ only in color, not in the function.
The result is a coloring of the cells, wherein the lowest value in the area of the first color, a medium value, receives the second and a high value for the third color. here, for example, the colour scale red-yellow-green, which shows a good cost in which months the phone is out of control
The colors are dynamic: if you change in the above example, the value for march at 40 euro, it will change the color of the field to the green.
Windows: – free of one’s own computer display
With time, one loses the overview of the folder are now free anyway? windows brings exactly to this purpose, a suitable tool that gave you all the important information, to free overview, of course, displays.
As you can see, what are the free gifts of your pc in the network accessible
- Click with the right mouse button on the start button in the lower left.
- Select from the menu that appears, select computer management.
- Click in the left-hand edge of the column to the point shared folders.
- Now you can see to the right, all of the existing shares.
Not all of the shown to be free of other directly usable. in the case of the shown in the image to a network share c$, d$, and so on, it is hidden, administrative shares. the help in the management of the computer via the network.