Oct-07-2017, 11:18 PM
Hi guys,
I am currently working at a freight forwarding agency and my work requires a lot of calculations that I usually do on excel or manually. What I would like to know is if there is anyway to be able to create a python program that would facilitate my excel work. what I need is a program in which I can input a lot of data, get the result on different calculations and then save the file.
Example: Product name A B C D E F G H J
Amount in USD 10 20 30 40 50 60 70 80 90
Quantity 19 18 17 16 15 14 13 12 11
Numbers of colis 2 6 5 4 9 78 2 6 43 10
Calculations(output): Fret = sum Amount / Quantity
Cost per product = 10 / 19(product A) 20/18(product B) and so on until J
These are just examples of what kind of results I would like the python program to output.
Hope anyone would be able to refer me to any concept that might help. Thanks in advance. Cheers
I am currently working at a freight forwarding agency and my work requires a lot of calculations that I usually do on excel or manually. What I would like to know is if there is anyway to be able to create a python program that would facilitate my excel work. what I need is a program in which I can input a lot of data, get the result on different calculations and then save the file.
Example: Product name A B C D E F G H J
Amount in USD 10 20 30 40 50 60 70 80 90
Quantity 19 18 17 16 15 14 13 12 11
Numbers of colis 2 6 5 4 9 78 2 6 43 10
Calculations(output): Fret = sum Amount / Quantity
Cost per product = 10 / 19(product A) 20/18(product B) and so on until J
These are just examples of what kind of results I would like the python program to output.
Hope anyone would be able to refer me to any concept that might help. Thanks in advance. Cheers
