Tuesday, June 20, 2017

carpooling, ride sharing.

Hi guys,

I am living in Islamabad Pakistan since 2012 for the job purpose, and almost travel to my home town Mansehra every week, and I think 80% of Islamabad people lives outside the capital, and most of them travel on weekends to their home towns, the most disturbing thing for me to travel on weekend was, and even still have that issue is catching local transport from bus station, because on weekends most of peoples prefer to leave for home early hours on Friday, so if you are late and have office work to complete and leave after 17:00 then confirmed that you will not get any local transportation. So I have thought many times about the thousands of private vehicles and their alone owners which travel though out the same city and having empty seats with them, and I always thought that why these people don't give lift or share rides with those peoples who really needs it, and I am petty sure that the vehicle owner also thinking about his/here fuel expanses, so he/here can get an excellent relief in his vehicle fuel expanses. I searched many time on internet for such website by which I can get access to these vehicles to travel with, but after searching hours I got only two website where you can get your ride and post your ride as well if you needed. 
1. www.aajul.com: this website is newly developed and have very good user interface ease to understand, by passing through few steps you can post your rides with little bit of details. 

2. www.carpoolworld.com : this website regarding carpooling and ride sharing is older then aajul.com but don't have such friendly user interface as the aajul.com has. it asks you to put a lot information before posting your need of ride or ride sharing. 
  

Friday, April 28, 2017

How to pick on cell value to multiply/add/subtract with all other cells.

Excel is amazing software allows you to function any way you want to do, here i will demonstrate you to use single cell value to multiply/add/subtract to all other cell values, like if you want to multiply the single exchange rate to all of your worksheet for example; the exchange rate is PKR 100 for $1 and  you want to check the amount in local currency like PKR currency so you have to multiply the PKR100 to each cell amount of the sheet so you don't need to be worried use the following method to solve this issue.

write exchange rate in one cell  


now enter the formula for multiply but enter the this $ sign before and after the row name like below. 

now drag down your formula to all cells it will pick the value only from one cell E1 of exchange rate. 

Let me know if you have any question.