Python parse excel työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Dataset + python + finance concepts

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Develop website using html, css, jquery, python

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

File attached

Offline typing job,data entry job

...activities - Integrate the website and dashboard with blockchain technology and smart contracts - Implement data visualization for real-time coin metrics and staking rewards - Ensure top-notch security practices to protect user funds and data Required Skills: - Proficiency in frontend development (HTML, CSS, JavaScript) and modern frameworks like React or Angular - Experience with backend languages (Python, Node.js) and RESTful API development - Familiarity with blockchain technology, cryptocurrencies, and decentralized applications - Understanding of smart contracts and cryptocurrency protocols - Expertise in responsive web design and creating intuitive user interfaces - Knowledge of data visualisation libraries and charting tools - Strong security mindset and implementation o...

...produce PDF reports based on specific user actions in the system. The details of the report to be generated are yet to be finalised, but can include elements like text, images, or tables. The report should be generated using a provided HTML template. The report should be pixel perfect as compared to the HTML template with page size of A4. Key requirements: - Proficient in AWS Lambda - Preferably Python programming - Experience in generating PDF documents programmatically - Knowledge of building AWS Lambda functions that are triggered from APIs such as AWS API Gateway or AWS Lambda function URLs - Preference will be given to those with an understanding of creating visually appealing and professional looking PDFs. - Proficiency in HTML and CSS for working with templates - Experti...

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

I'm looking for a qualified freelancer ...for the appointment Considering the constraints of the website, I require a script that can still function proficiently with a limited number of appointment slots. Moreover, it must be programmed to input login credentials. A crucial requirement is that it can bypass or solve captcha verifications, ensuring a smooth booking process. The essential skillset for this project comprises expertise in Python, as the script should be developed in this language. Familiarity with web scraping and script-making is essential. Knowledge of dealing with booking systems or captcha verifications would be a remarkable advantage. The ideal freelancer is able to create an efficient, reliable script that can consistently secure appointments on Almaviva E...

I am in need of a developer skilled in Python for a project concerning the creation of a tablet finder application compatible with Windows. The primary feature of this application must be search filters, specifically, those able to find tablets based on their MAC addresses. Ideal candidate would posses: - Proficient in Python - Experience in creating search filters - Familiar with MAC addresses - Working knowledge of Windows compatibility - Detail-oriented and able to work autonomously. The focus of this project is the development of a reliable application that can perform complex searches based on a tablet's MAC address. This is a specialized task requiring detailed and specific skill sets.

I urgently need an experienced web scraper who can extract data efficiently from multiple websites. Applicants' guidelines are as follows: 1. Websites for Scraping: Due to security concerns, the websites to be scraped will only be shared with the selected freelancer. 2. Application Contents: I didn'...freelancers to include in their applications. However, demonstrating your skills, experience, and past work related to web scraping will surely be a significant advantage. 3. Project Deadline: I require this project to be completed as soon as possible. Please include your estimated completion date in your proposal. Ideal Skills & Experience: - Proven experience in web scraping - Knowledge of Python, Selenium or other scraping tools - Strong attention to detail - Able ...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

...BE DONE THAT IS THE CONDITION) I need a skilled frontend developer to create basic HTML/CSS pages. You will need to integrate these frontend pages with a Python backend. The project involves adding JavaScript for client-side validation and implementing AJAX page transitions. After pressing the 'save' button on one of the pages, the page should transition to the next. The data inputted should be sent to the Python backend for processing. Key Requirements: - Proficient in HTML, CSS, and JavaScript - Experience with client-side validation and AJAX - Prior work experience that showcases your frontend development skills - Proficiency in Python is a must for the backend implementation Please provide me with your relevant past work when you apply for this proje...

for taking BLS algeria appointments for spain visa fast and easy

I'm in need of a skilled developer to create an intelligent transaction monitoring platform with big data capabilities, s...to ensure seamless operation. Target Audience: This platform is primarily aimed at banking and financial institutions, as well as e-commerce companies. Preferred Technology Stack: - Java & Python for the core of the platform. - Big Data technologies for processing large volumes of data. - In-Memory DB for fast data storage and retrieval. - Drools & JBPM for fraud detection and management. The ideal candidate should have experience in developing similar platforms, with a solid grasp of real-time monitoring, fraud detection, data visualization and big data technologies. Strong background in Java, Python, with a good understanding of Drools...

...related to hardware, software, and network setups. Overview: I'm looking to create an MVP of an AI-assisted technical service desk tool. The goal is to prototype the core capabilities of ingesting, analyzing, and responding to support issues using machine learning techniques. Project Description: The tool will allow end users to upload tickets, logs, configs, and other pertinent files. It will parse, extract, and vectorize content to understand issues. An explainable ML model like LIME will then diagnose the problem and provide steps, code samples, etc to resolve it. The LLM will be RAG augmented based on a vector protocol of a list of sites to augment the LLM. Key Criteria for Success: Robust technical execution that meets core requirements Modular, extensible architect...

Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...

Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.

I am looking for an advanced AI expert who is proficient in Python to help me understand and manipulate a developed Python package on a tutoring basis. The link of the package is: I am interested in the cylinder problem here: Key Responsibilities: The tutor should help me to make changes in the code, track the flow of the data, know the dimensions of the data, debug errors that I may encounter, and how to create more figures as well. Level of Expertise: Advanced. It's important that the tutor is proficient in AI and Python, and can guide me through the learning process at an advanced level.

I'm looking for a Python expert to help me set up a pipe network simulation and analyze the pressure data for detecting potential water leaks. The primary goal of this project is to simulate a water pipe network and subsequently identify potential leaks using pressure drop analysis. The simulation should be able to model the flow and pressure properties of a complex network of pipes. Key tasks: - Setting up the pipe network simulation using Python - Conducting pressure drop analysis for leak detection - Providing an intermediate level of detail in the analysis report - this should include the locations and estimated sizes of the potential leaks Ideal candidates for this project should have: - Proven experience in Python programming - Understanding of hydrauli...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I am looking for a skilled professional who can design an emulator for Windows platform. This emulator should primarily support the programming language Python, and should be able to cater to users who wish to use Python for completing assignments. Key requirements: - Platform: Windows - Main functionality: Assignment completion tool - Supported programming language: Python Ideal Skills and Experience: - Strong proficiency in software development, particularly in designing emulators - Proficiency in Python programming language - Experience working with Windows platform - Previous experience in developing educational tools or software is a plus

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...

I’m seeking a full stack web developer with proficiency in HTML, CSS, JavaScript, Python, Ruby, PHP, Node.js, and React to create a comprehensive hotel booking website. The primary aim of this project is to offer a user-friendly and efficient space for users to book hotels while enjoying a smooth and seamless experience. Features desired include: - Search functionality to enable effortless hotel discovery - Booking management to track and manage users' bookings - Incorporation of customer reviews to enhance customer confidence and choices - Integration of online payment solutions for smooth financial transactions - A Room availability calendar for easy checking of room availability - Multi-language support to cater to a global audience - A chat bot for 24/7 custo...

...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...

I'm uncertain whether my Windows system already has Python installed. I require assistance to get it up on my system, if it isn't already there. Primarily, I am looking for someone to help configure a Python script that will carry out automatic reservations on a specific website. This role will ideally suite someone with: - Proficiency in Python scripting - Strong understanding of automation using Python - Experience in setting up Python on the Windows platform - Knowledge of web interaction through code, in particular, reservation processes. here is the link to the script and its dependencies. I will need to work with you on zoom live to do this. I have node.js on windows

...Sagemaker Machine Learning models. Key Requirements: - **AWS Services**: Your primary focus will be on utilizing Amazon S3 and Amazon Sagemaker effectively within the architecture. - **Programming Languages**: Familiarity with both Python and R is important, given that my models are built in those languages. - **Model Operations**: Your design should focus on enabling batch predictions and facilitate model training and retraining for the Machine Learning models. Ideal Skills: - Experience with Amazon S3 and Amazon Sagemaker are a must. - Proficiency in Python and R for fine-tuning or troubleshooting the models. - Familiarity with designing architectures for batch predictions and model training/retraining. - Strong understanding of DevOps principles and AWS best practices...

Mail server is getting attacked, I need to create a windows service constantly checking a .txt log file for preset keywords like "Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/de...example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempts – No need to restart the service when we change settings – Highly configurable, ban anything that comes through a log file.

I'm on the lookout for skilled blockchain backend developers with proficiency in Python, JavaScript, and Solidity. Your understanding of Ethereum and experience in blockchain will prove to be incredibly valuable. The key features I need you to support in the blockchain backend are smart contracts and the development of decentralized applications (DApps). Ideal Skills and Experience: - Proficient in Python, JavaScript, and Solidity - Experience with Ethereum - Prior work in blockchain development - Knowledge of smart contracts - Proven experience in DApp development Your ability to deliver efficient and secure blockchain backend solutions, that facilitate the execution of smart contracts and the development of DApps, will be crucial for the success of this project.

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

I need to create a script to consume a SOAP service with WSSecurity to Encrypt and Sign the XML, an example is the way SOAPUI is configured to consume the service. Preferably in Python, but the language is free. Necesito crear un script para consumir un servicio SOAP con WSSecurity para Encriptar y Firmar el XML, el ejemplo mas cercano que puedo dar es la forma en la que SOAPUI se configura para consumir el servicio. Preferiblemente que sea en python, pero el lenguaje es libre

Hi, I am a python programmer and I am trying to learn how to code with the OpenHoldem framework, but since I have very little knowledge of C++, I feel a bit overwhelmed by the huge documentation, for this reason I am searching for someone with experience with OpenHoldem, and who already knows how to play poker to be able to understand what I want my bot to do, and transcribe it in code. I already have a warbot profile so I do not need a full poker bot from scratch. Details: - the bot is going to play spin (3 players) on a poker skin already available in the warbot list - it needs to adapt based on the opponents (I will provide with a list of players against whom it has to change some choices in game) -it needs to base its choices on a few specific decisional processes that I will ...

...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...

...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...

I need a Python expert with an ability to cover various functionalities as per the need. The project might involve data analysis, web scraping, automation, or could be anything else as per the project requirements. The ideal candidate should have: - Expertise in Python programming and its different libraries. - Experience with data analysis, web scraping, automation. - Strong problem-solving skills. While applying, please share: - Your past work related to Python programming. - Your Python programming experience level. - Detailed proposal of how you can assist in this project.

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

...The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to send...

...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...