Simplify Your Shipping Process with Bilty Format in Excel for Shipping

Bilty format in excel for Shipping

foreign [Music] your One Stop Shop for all your Excel needs today we have a Google Sheets Edition a logistics transport calculator for you you can use this calculator to estimate your cost for transportation it's a very basic calculator you can build upon it and add more layers and custom fit it to your needs but you can use this as a starting point so the the file has three sheets the calculator itself where you need to choose the source and destination all right these are drop down lists that we'll see later you need to Define for example the fee and percentages and of course you can add more and more layers to that and you have to decide which product you want again drop down list and what quantity and the calculator will show you the volume in containers and metric tons and the um total volume for this line and eventually will show you the total weight total cost and the final cost of course with the fee okay so this is uh the first sheet the main sheet I just want to tell you if you guys enjoy the content that I'm publishing please make sure to subscribe like and share with your friends and colleagues to help this channel grow I would really appreciate that if you just squash that button thank you so where some of the information is coming from there's a sheet called product data where you define the product like table chair and sofa and the volume and containers and metric tons then to use the drop down if you're not familiar with that that's very simple go to data data validation and here you select list from you know what I'll just do it from the beginning go to data data validation it will look like this you click over here on this and you just select the first one and I just like to keep this blank and that would just give it everything that you have all the way down and reject input as I don't want you to be able to input any other value save and that's it that's how you do the drop down list very easy very simple so that's the product data transport cost is where you define the source and destination and the costs and you'll notice that I only highlighted this column because I'm using the transpose formula to give that same names in the column in the row so you have a source and distillation and the logic here is that here you would put the the cost to transport one container from here to here so from Paris to Tokyo it's five hundred dollars but inside London it's 125 and of course you can change that however you see fit so these are the two um data sheets so we covered how we do the product drop down list the quantity of course there's a number again this is the drop down list same as before only for this column and this I'm using index match and of course you can use only um you can use also vlookup if you want but I just used index match for this and if you're not familiar with index match and the index sheet formula basically asks certain table what column or what row you want to find and then what column and gives you the exact location it's very useful if you have a changing column header okay so that's the index match to capture these this is just the multiple of quantity and wait container cost again index match only over here and the total cost I am just using Roundup because the prices per container so it's a Roundup of the number of containers times the container cost weight is the weight and that's about it fee and total cost times V plus 1. all right so that's it hope you enjoy the content and I will see you next time