Code extract data excel file row jobs

Python Aliceblue api Aws or azzure deployment Algotrading Testing Google sheets The code is already written y me 80 % of work in code is done I need pro help in testing indetail, fix bugs and make sure it runs as intended. Make sure all testing is done with old features and also new onces added....deatiled testing is expected...need to deploy in local and cloud aswell ( full assistance in it )

I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )

I need a proficient web scraper to extract car models and prices from various car rental websites, specifically Hertz, Avis, Sixt, and Budget. This data will be collected on a weekly basis.

...Experience using Vendor Central and AMS portals is an advantage. • Strong interest in e-commerce and digital marketing. • Excellent written and verbal communication skills with the ability to adapt to different audiences. • Strong understanding of budgets, targets, and product pricing. • Proficiency in analysing sales data and making data-driven recommendations. • Self-motivated and proactive with exceptional organisational skills. • Proficient in Microsoft packages including Excel and PowerPoint. • Knowledge of graphic design is an advantage. Join our team as an Amazon Account Executive and take your career to new heights! Apply now and be a part of a dynamic and innovative organisation that values your skills and offers growth ...

I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

I need a WordPress developer to create a simple function that does the following: **Fetch Data from SQL: Retrieve the correct row from an SQL database based on a value passed in the URL query (e.g., ?workorder=12345). Extract the corresponding URL from the database. Display PDF: Use the retrieved URL to display a PDF file in a viewer, such as , in the same way as in this demo: **Integrate with Forminator: Pass the retrieved URL into a hidden field in a Forminator form, allowing it to be submitted with the form. **Additional Information: * The website is built with Oxygen Builder. * You will have access to all necessary systems to complete the task. * If you have experience with WordPress, SQL, PDF viewers (e.g., ), and Forminator, this task should

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all meas...for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both importe...

...domain. Our task is to find existing code for specific space-related applications, run the code on our computers, and understand how it works. (meaning we just have to run existing code from the internet e.g. GitHub... modifications on the source are allowed but no writing of code with no reference of an existing code) We have already identified the following applications and their corresponding GitHub repositories: 1. Crater detection on planetary surfaces Repository: [YOLOv5 Moon and Mars Crater Detection]((Krishna).ipynb) 2. Colorizing grayscale telescope images Repository: [Colorizing Space Images with GANs](

I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.

...looking for an experienced data analyst who can help me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data...

I'm in need of an expert who can create G-code from scratch for a Ghost Gunner 3 CNC machine, specifically focused on firearm component manufacturing using 3D printed parts. - G-Code Creation: The main task involves developing G-code to manufacture various firearm components, including lower receivers, upper receivers, and trigger assemblies, from 3D printed parts. - CNC Proficiency: A deep understanding of the Ghost Gunner 3 CNC machine is essential, along with expertise in G-code programming. Ideal candidates for this project would have a background in firearm component manufacturing, CNC operation, and G-code programming. Good attention to detail and adherence to safety and legal standards in firearm manufacturing is crucial.

I'm seeking a talented writer experienced in crafting Wikipedia articles to create a biographical piece about a public figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional resea...figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional research and writing skills - Ability to adhere to Wikipedia's standards and guidelines - Capable of creating a compelling and neutral biography I can provide a wealth of resources including: - News articles - The official website of the subject - Interviews Your task will be to sift through these materials, extract the most relevant information, and present it in a manner that's suitable for Wikipedia. Please ensure to maintain a neutral point of view and adhere to Wikipe...

...ensure deadlines are met. 5. Sugarcrete Initiative: Research and compile a list of bagasse suppliers in Belize for future brick manufacturing. Track costs related to Sugarcrete separately from gym expenses. Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week...

...for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and identify automation oppor...

...fields: Auto-filled: Requester Name, Department, Date & Time, Sequential Request Number (per department). User Inputs: Area (dropdown, multi-selection) Line (dropdown, multi-selection, filtered by Area) Room (dropdown, multi-selection, filtered by Line) Equipment (dropdown, multi-selection, filtered by Room) Priority Level (dropdown, single selection) Description (text field) Attachment (optional file upload) All fields (except attachment) are mandatory. Approval Workflow: Requests are submitted by any user but require approvals as follows: Department Manager: Approve, Reject, or Comment (send back to requester) Editable approval Engineering Manager: Approve, Reject, or Assign to Section Head (with auto-tracking of assignment date/time) Notifications for approvals/rejections...

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I'm seeking assistance with modifying a flat file database. The task primarily involves updating existing records. This is a one-time project.

I'm looking for someone to develop a practical file for a BTech Computer Science and Engineering workshop. The file will be primarily for educational purposes. Key Components of the Practical File: - A well-structured written section that includes theory explanations - Diagrams relevant to the workshop content - White blank pages for additional notes or observations - Diagrams that will help visualize complex concepts Ideal Freelancer: - a strong background in computer science and engineering - Excellent writing skills - Experience creating educational materials

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience

I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets

...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...

... This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Responsibilities: - Collaborate with me in developing a web application using Java. - Implement features such as user authentication and database interaction. - Create engaging weekly content to facilitate the learning and development process. Ideal Skills: - Proficiency in Java and experience in web application development. - Familiarity with Visual Studio Code (VSC). - Experience in implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I ...

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I need a professional who can help me extract data from my Clover POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, wit...

I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets

...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of...

I'm looking for a professional teste...my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management. Experience with secur...

Format file like previous projects

I'm seeking an automation expert to help extract product information from an FTP server and update my Shopify store. Key Requirements: - Extract product information from the FTP server - Automate the process to ensure regular updates on Shopify Ideal Skills and Experience: - Proficiency in data extraction from FTP servers - Experience with Shopify updates - Automation expertise - Familiarity with product information management. Note: The specific product information to be extracted and updated, as well as the format of the data on the FTP server, will be discussed further. Please bid if you have relevant experience and can provide references.

I'm looking for a freelancer who can help me convert a PDF file into an editable document. This involves typing out the content of the PDF, with the following specific requirements: - The document should be formatted as a simple text format. - Maintaining the original layout is not necessary, but accuracy in transcription is crucial. - Attention to detail and a commitment to producing high-quality work are essential. Ideal skills for this job include strong typing abilities, proficiency with word processing software, and experience with document formatting. Please note, there are no specific sections of the PDF that require prioritization or special attention.

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

Are you an experienced graphic designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ec...

I need help adjusting the size and bleed areas on some card files I have. - Current Format: The files are in PDF format. - Task: There are 30 cards (60 pages front and back) that need overall size adjusting according to specific dimensions provided by my card printing manufacturer. All content is already in place, so this is minimal work. - Software: I have tried using Adobe Acrobat for adjustments, but it hasn't been successful. If you have experience with this type of project and are able to help, I would greatly appreciate it. Thank you in advance.

I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.

Build laravel transcoding panel features - dashboard show, cpu utilzation by grapihc using widgets, show total connections, show total streams online/offline/ show per row each gpu statics with utilzation graphics , show total in and outgoing network metrics/ usage of traffic (from uptime second til now realtime) if reboot server then start from 0 traffic data - page live streams , show stream details (kbps/audio/codec/videocodec/total connections/uptime stream/restart stop buttons, mini popup jwplayer or hls player to show live stream - add stream, support multi source setup, select gpu , select profile for transcode, select output http stream/rtmp stream output *( rtmp,rtsp,rtp,rtmpe, udp,http,mpegts,ts,hls,dash all protocols) - profiles for transcoding (attach to gpus) (a...

I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/2...

Job Title: Develop a Workflow for Scraping Global Mosque & Muslim-Based NGO Data with Detailed Documentation ________________________________________ Job Description: I am looking for a skilled automation expert to build a workflow that scrapes Google for global contact details of mosques and Muslim-based NGOs. The workflow must allow for targeted searches by category (e.g., society, charity, non-profit) and be optimized for credit efficiency in Make.com. The final system should produce structured data outputs and include clear, beginner-friendly documentation. ________________________________________ Scope of Work: 1. Automation Workflow: 1) Build a workflow to scrape Google for the following details: a. Organization Information: i. Organization Name ii. Organization

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

I'm looking for a freelancer who can help me convert a PDF file into an editable document. This involves typing out the content of the PDF, with the following specific requirements: - The document should be formatted as a simple text format. - Maintaining the original layout is not necessary, but accuracy in transcription is crucial. - Attention to detail and a commitment to producing high-quality work are essential. Ideal skills for this job include strong typing abilities, proficiency with word processing software, and experience with document formatting. Please note, there are no specific sections of the PDF that require prioritization or special attention.

...attacks). Saving user data to the database: If all details are correct, the system will store the information and grant access. Constraints: The system must maintain a security log for every login attempt. The system should support a smooth experience when there are 500 simultaneous users. 2. Use Case: Create a New Project User Actions: Entering project details: The manager will enter the project name, description, target date, and assigned users. Constraints: The project name cannot be empty and must have a minimum length of 3 characters. The date cannot be in the past. The system supports assigning up to 10 employees to a project. System Actions: Verifying project data: The system will ensure all fields are entered correctly and valid. Constraints: The system will veri...

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,

# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf usi...postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability to follow instructions and submit applications appropriately. - Good communication skills for reporting progress. - Experience using MS Word, MS Excel, Google Doc, Google sheets. # Compensation: - $10 for every 100 applic...

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Column K:...

I'm looking for a skilled web scraper with API development experience. The task involves extracting product information from three specific websites. Key Requirements: - Extract product descriptions from specified websites - Develop an API to facilitate this - Present data in a user-friendly JSON format Ideal Skills: - Strong background in web scraping techniques - Proven experience with API development - Attention to detail - Ability to work independently If you've successfully completed similar projects in the past, I would love to hear from you!

I need assistance with my Android app which reads a .bds file from Busy Accounting software's MS Access database. Currently, the app can read the file but cannot update it without causing corruption. I want to be able to add new records and modify existing ones. Key Requirements: - Diagnose and resolve the corruption issue when trying to update the .bds file. - Implement functionality to add new records and modify existing ones from the Android app to the .bds file. Essential Skills: - Experience with Busy Accounting software and .bds file structure. - Proficiency in Android app development, particularly with direct file access. - Knowledge of MS Access database management. Please note, I need a solution that does not require manual updates...

...striking pop art style inserts. * Text/Graphics: Display of our band name and album title, using preferred fonts and open to evolving styles. * FX Styles: VHS Aesthetic, Dark Noire, Glitchy, Vintage MTV, Pop Art (like the old Batman TV visuals). Materials Provided: A mix of live show photos and VHS-digitized footage, ranging from crisp to vintage blur, via Dropbox. Bonus Skills: 1. Ability to extract usable snippets from low-profile films and YouTube visuals. 2. Capability to animate still images using AI technology. Please share your ideas and cost estimates for bringing this vision to life. Thanks! Johnny Xmas...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.