hi There, How do i calculate the distance travelled using excel

[Rameshkumar]

HI Everyone, Greetings!

I am new to this forum, I have a situation where I need to calculate the distance travelled by a (warehouse) picker in a warehouse using excel sheet. I am not familiar with excel, however I can learn if you can share information please..

 

[NARAYANK991]

Hi ,

Excel cannot do anything unless there is some data to process ; what is your data like ? Can you upload a workbook with enough data in it ?

Narayan

 

[Rameshkumar]

case: a warehouse picker has to travel multiple location to pick an order ( Ex: starting point to A1 to B1 to B4), how can I measure the travel distance using excel please. thank you

 

[NARAYANK991]

Hi ,

Is this what you wanted ?

Narayan

 

[Rameshkumar]

HI Narayan, Thank you , I need to calculate the distance traveled in multiple points ex" starts A1 goes to B1 then to B5 and then to A7 then to B3" so the total distance traveled will be A1+B1+B%+A7+B3 .. how to do it and where can i learn please.
also i have basic query , let say , have a cell B3 and i named the cell as "orange' is it possible to assign a value to the cell B# which is named orange , thank you

 

[NARAYANK991]

Hi ,

Please upload a sample workbook clearly showing how you will specify all the points of travel. The same goes for your second question.

Narayan