Automatic processing of Excel/CSV file with data on car wheels_2
22 USD Formation of preliminary price
- The base price is still taken from the column price_4 (file ALZ).
- Our markup percentage is still added to price_4.
- The resulting amount is the preliminary price.
2. Comparison with prices from PO
- The preliminary price (price_4 + %) needs to be compared with the prices for this product in the PO file.
- Product comparison is done by EAN code
-
1 day22 USD
1 day22 USD
Good evening. Everything is ready, I am ready to provide the result, write.
-
1 day22 USD
1 day22 USD
Ready to complete your project right now. Everything will be done with high quality.
-
1 day22 USD
231 2 0 1 day22 USD
Good day.
I am ready to implement automatic processing of ALZ and PO files with markup calculation and comparison by EAN in Python.
I have experience working with Excel/CSV and automation through pandas.
Please clarify the file format and the desired logic after price comparison.
-
2 days22 USD
4927 491 0 2 2 days22 USD
Hello!
Write to me, I will make a script that will allow you to compare any files with prices.
Contact me.
-
1 day67 USD
278 5 1 1 1 day67 USD
Hello, Vlad
Here is how I see the logic: ALZ (price_4) → calculation of pre_price → join with PO by EAN → selection of PO price by rule → comparison → result (for example: pre_price, po_price, delta, delta_%, winner),
I am laying down for safety:
1. EAN as text/number: in Excel it often drops leading zeros or converts to float → we need to normalize (string, trim, without .0)
2. Duplicates of EAN in PO: there may be several rows for one EAN (different warehouses/suppliers) → we need a rule: take minimum, maximum, first, or by column priority
3. Currency/VAT: ALZ and PO may be in different currencies or with/without VAT → we need a clear rule before comparison
4. Empty/0 prices: what do we do if there is no price in PO or it is 0
…
Questions that will help to better assess the task:
1. Which PO price to take if there are several rows for one EAN: min / max / first / by warehouse / by status?
2. Are ALZ price_4 and PO prices in the same currency and format (with/without VAT)?
3. What result is needed at the output: update your price (substitute the better one), or just a comparison report (difference/deviation)?
Regarding the timeline and price, if this is adding logic to an already existing script/pipeline without surprises: EAN is unique, one currency, simple rule for selecting PO price = 3-6 hours, 3000-6000 UAH.
If rules are needed for duplicates of EAN + currency/VAT + data cleaning + report/logging: 1-2 days, 7000-12000 UAH.
Once you send examples of the two files ALZ and PO or at least their structure, column names with EAN and price in PO, I will immediately fix the exact figure and tell you which option of rules is optimal.
-
1 day22 USD
2864 72 0 1 day22 USD
Hello!
I have been working with formulas since 2008, with VBA-Excel (macros) since 2011.
My priorities are optimizing calculations and user convenience.
Let's do it.
-
2 days22 USD
3387 84 0 2 days22 USD
Ready to take it on.
Need to clarify the order details, write!
I use python, uv, github, docker.
Current freelance projects in the category Python
Build a customer classification model1. There is client data in Mongo/SQL (approximately 20,000 entries with raw data). 2. It is necessary to build features and a classification model of clients into behavioral groups based on this data. 3. The project should be completed in Python. AI & Machine Learning, Python ∙ 18 hours 54 minutes back ∙ 28 proposals |
IT Automation of VAT Reporting
223 USD
It is necessary to develop a system for automating the transfer of sales data from the CRM to the accounting system Wafeq. The system should import bank and payment reports, automatically reconcile payments with invoices, generate invoices for VAT reporting, and minimize manual… AI & Machine Learning, Python ∙ 1 day back ∙ 38 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 1 day 12 hours back ∙ 38 proposals |
Automatic video posting on social media according to a scheduleTechnical Assignment (TA) Automatic video publication on social media according to a scheduleProject Description A script/bot (Python preferred, or any other solution of your choice — the main thing is stability and ease of maintenance) is needed, which automatically publishes… Python, Bot Development ∙ 2 days back ∙ 56 proposals |
Bot for receiving/searching applications
28 USD
In short: Create a bot where users can create and find profiles, the bot should have referral links, etc. Everything is detailed below. Client-side bot: Before the /start button, text in the center of the chat: What can this bot do? Welcome to Sugar Secret Agency! -Premium… Python, Bot Development ∙ 2 days 2 hours back ∙ 61 proposals |
Ukraine