Build a script that will take 3 spreadsheets, perform calculations on them and produce a new spreadsheet
$250-750 USD
ชำระเงินเมื่อจัดส่ง
Summary
1) I have 2 excel stock lists from two suppliers
2) I have 3 websites. The stock for these 3 websites are in an excel spreadsheet with three worksheets
3) I need the stock on the 3 sites to be updated by the combined stock available from both suppliers
4) This must happen as follows: I upload the two excel stock lists and the the excel spreadsheet with the 3 sites separated on 3 worksheets. The program needs to produce a new spreadsheet where the stock on the three worksheets are updated to show the combined stock available from both suppliers
5) The Unique Identifier for the stock is called SKU (NewSku), and that is what is used to look up the stock counts on all the spreadsheets
Programming requirement:
I need a script that will run on my linux server. Not on a desktop PC. Please indicate what programming language you intend to use. My preference is PHP or similar. If you do not submit your programming language with the bid, it will be ignored. The script does not need a fancy interface. I can upload the input files into a directory and the script can deposit the output file into a directory, if that is easier. If the excel sheets are an issue, we can separate the inout and output sheets into CSV files. Therefore working with CSV files, in stead of excel sheets.
Steps:
Step1: Stocklist 1
1.1) Create new sku (refer to formula in spreadsheet Column O)
1.2) Remove all duplicates
Step 2: Stocklist 2
2.1) Create new sku (sku (refer to formula in spreadsheet Column K)
2.2) Remove all duplicates
Step 3: Stocklist 1 and 2 - combine into Combining Stock Lists spreadsheet
3.1) Combine stocklist 1 and 2, into one stocklist with these columns:
NewSKU, Total stock (add the stock from stocklist 1 and 2 together) - column Y and Z (See spreadsheet: combining stock [login to view URL]
Some SKUs will be on both stocklists, some skus only on either 1 or 2. The stock for all the skus on all the stock lists must be included on TOTALSTOCK
Step 4: New Stocklist - quantities combined for all three sites
This is the output desired from the program
4.1) Lookup sku on each of the the three worksheets (site 1, 2 and 3) in the website spreadsheet and list the total stock as contained in Combining Stock Lists spreadsheet
4.2) If a sku on the worksheets (1,2 and 3) are not on the TotalStock spreadsheet, the stock must be set to 0 (zero).
Attached files:
I'm including excel sheets to clarify and to demonstrate how this might be done manually on excel. The sheets only show the first 100 rows. Please keep in mind that the original stock lists can have up to 400,000 rows. You have to design a program that can handle large excel files - the biggest ones around 40 MB.
The columns and format of the input files will be the same as these supplied files.
Thank you
หมายเลขโปรเจค: #35093367
เกี่ยวกับโปรเจกต์
มอบให้กับ:
Hello. I get what needs to be done and I can definitely do it. My first choice is to do it in Python because it is better suited to data processing tasks, but I can do it in PHP if you prefer. It can also still be a cl เพิ่มเติม
freelancer 75 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $508
Hello, Warm Greetings! I am pretty sure I can produce high-quality and perfect results for your project. By using Python, I used to make AI engines, BOT, Web Scraping Tools, and so on. PHP, Python are my major, so you เพิ่มเติม
Hi, Hope you are doing well. I checked your description in "Build a script that will take 3 spreadsheets, perform calculations on them and produce a new spreadsheet". I'm a senior developer with 9 years of experience i เพิ่มเติม
I am Python developer and I can build this Python script that will perform calculations on given files and generate a new spreadsheet and I am pretty sure that I can complete every bit of your requirements. Further det เพิ่มเติม
Hi there,I'm biddin on your project "Build a script that will take 3 spreadsheets, perform calculations on them and produce a new spreadsheet" I have read your project description and i'm an expert in Python and machin เพิ่มเติม
Hello Magiel G., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Python, Apache Lets connect in chat เพิ่มเติม
Hi there, I believe I can help you with this project as i have the experience with PHP, Python and Apache. here is my portfolio: https://www.freelancer.com/u/ayesha0124
HI! I have done similar type of work before I am an expert web programmer. I am familiar with Laravel and I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, Reac เพิ่มเติม
PHP. Programming language I suggest PHP sir . I will combine 3 stock data sheets of website/supplier into new CSV based upon condition for new stock value . Please let me know sir when you here thank you.
Hello I am professional Software engineer with specialization in Web and Software development I have 4years experience in developing such script I did my MSSE from NUST Islamabad Please open message box for me so we ca เพิ่มเติม
Hi there, I can develop script in Python for this. Please ping me back for further discussion. Looking forward to hearing from you soon. Regards, Pooja Bohra
Hello, I've read your requirement carefully and I'm very interested in your project. As a full-stack PHP developer and have worked on various technologies for the past 5+ years including PHP, CSV, Sass and Excel. I wo เพิ่มเติม
Hello How are you ? I have read your job description and I can complete your project . I have rich experience of developing and handling web project including import and export excel file and customizing it . As you me เพิ่มเติม
I will code it in C# .net core which will run on Linux. It won't have a GUI, just a console window so you can run on your server. Does it need a web interface if you say 'upload' or will they be able on the server?
what programming language I intend to use.--> Python or PHP Hello, I'm fullstack expert, with over 13 years experience dealing with web, I can help build script that will take spreadsheet and perform calculation . I'v เพิ่มเติม
✔✔✔✔ Nice to see your posting ✔✔✔✔ Hi, Magiel G.. I read your job posting and feel I can help you successfully complete your project now. I am good at PHP, Apache and Python and I have completed the same project recent เพิ่มเติม