Anil kumar M » Публикация

Аннотация This book deals with how to add complete unit conversion capability to worksheet - Excel as Unit converter About This Book Professionals use their own calculation worksheets for performing speedy calculations, data analysis, research or decision making based various inputs. Ours is global village! People abroad, literatures and laboratory equipments provide inputs in different system of units. Even within same country, there is a variation of units. In our calculation worksheet, this demands that we should incorporate unit conversion to quickly make calculations and decisions after conversion to our own familiar system of units. For example, psi is the pressure unit that is common in British and we Indian scientists and business men want it to quickly convert to N/mm2 to think and decide how much you have specified! What is new about unit conversion? Unit conversion is nothing new. There exist plenty of websites and references which gives conversion of any unit to another. But you waste time for toggling between references to web pages and back to your worksheet - a good amount of time is lost and moreover, once you leave the reference, you still doubt whether you made any mistake in reading out, remembering and entering the converted result back to your worksheet. Excel already have some conversion functions? Yes, but totally inadequate. just 3 or 4 variation of pressure will not make your worksheet smart! There are many many What is the solution for this? You need flexibility to convert any units within spreadsheet itself. Is it not a good idea? Converting within a worksheet in a mouse click enable one to handle any system of units in seminars, discussions or in between a call. variations a simple parameter pressure can be specified by another person. Is it by macro / user defined functions / VBA and all? No. Entirely by simple "Do It Yourself" equations and conversion factors, within your worksheet. Complete flexibility! How many variations in a particular measurement unit (for instance PRESSURE) you want in your worksheet is entirely decided by you. Will it work with any spreadsheet like MS Excel and other programs like Open Office? Absolutely fine with such programs. Is it simple to use? Yes. Normally you will have a single system of unit convenient for your calculations. If your input is a different unit, just select that unit by a drop-down click. That is all you have to do. Even between a phone call, you can do such simple task and respond to your guide or customer or client! Such ready-to-use programs (unit converters) are already available in market? Already available programs are add-ins which you have to invoke by manual interventions or to enter certain complicated equations each time there is a unit conversion needed. The present technique do not involve any keyboard typing to convert a unit. JUST A MOUSE CLICK AND SELECTION! THAT IS ALL YOU NEED TO CONVERT IN EXCEL!. Also there is no assurance of its accuracy as it is not set up by you. Needless to say, such add ins are not universal and may cause malfunctioning as it is based on VBA or UDFs. Any system of units (Metric, SI, British or any other system of your choice) Any category of unit (Pressure, density, velocity, flow rate, viscosity to mention a few) Simple and error free and can be verified and satisfied. "Do it yourself" set-up technique A full working and self-explanatory template to design any unit system conversion is included with the book Easy and accurate conversion