Python Forum
simplify my excel work on python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
simplify my excel work on python
#1
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 Big Grin
Reply
#2
The answer is of course yes.
You might want to take a look at the types of packages (code libraries) that are available
for python here: https://pypi.python.org/pypi

You would be particularly interested in this package: https://pypi.python.org/pypi/freight-forwarder
and others here: https://pypi.python.org/pypi?%3Aaction=s...mit=search

And you can find complete applications (as well as more packages) here: https://github.com/explore
Are you willing to put in the time required to learn python?
It's fun to learn, and doesn't take a lifetime to learn.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  I want to simplify this python code into fewer lines, it's about string mandaxyz 5 2,122 Jan-15-2022, 01:28 PM
Last Post: mandaxyz
Thumbs Up [SOLVED] Simplify condition test in if block? Winfried 2 1,710 Aug-25-2021, 09:42 PM
Last Post: Winfried
  Excel password recovery tool for work OTH 4 3,293 Mar-08-2021, 08:56 AM
Last Post: OTH
  How can i simplify this code Jezani_VIII 4 2,763 Aug-25-2019, 02:23 PM
Last Post: perfringo
  How to simplify square finding program? meknowsnothing 3 2,900 Jun-11-2019, 08:20 PM
Last Post: meknowsnothing
  Is it OK to use a context manager to simplify attribute access? nholtz 0 2,044 Jun-11-2019, 01:19 AM
Last Post: nholtz
  Dijkstra code - trying to simplify it grandpapa10 1 2,179 Jan-23-2019, 12:43 PM
Last Post: Larz60+
  Strings read from excel don't work? Tibas 0 2,406 Mar-06-2018, 10:37 PM
Last Post: Tibas

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020