Excel vba lookup script jobs

...should skip the additional fields and proceed with the normal checkout process, including any athlete-specific data fields. Data Fields to Collect for Athletes: The form must capture specific details such as: Full Name Date of Birth Blood Type Allergies Passport or ID copy upload (mandatory) Export Functionality: The system must allow the export of all registered athletes into an Excel file. The exported Excel file should include all the collected personal data in separate columns (e.g., Full Name, Date of Birth, Blood Type, Allergies, etc.). Uploaded documents (e.g., Passport or ID copies) should also be exportable or downloadable. Additional Notes: The solution must integrate seamlessly with WooCommerce's existing checkout process. The form and its functionality s...

AI Developer Needed to Create a Script-to-Song System Using TV Show Scripts and Video Clips Please take a look at this example video to get an idea of the style we’re aiming for: Description: We are seeking an experienced AI developer to build a unique system that can take full-length episodes of The Sopranos (or any TV show with available transcripts/subtitles) and create a musical song by extracting iconic lines, making them rhyme, and stitching together video clips from the show. The system should automatically perform the following steps: Key Requirements: Transcript and Subtitle Extraction: The system needs to process video episodes of The Sopranos and extract corresponding dialogue from subtitle files or generate it through speech-to-text

Please Sign Up or Login to see details.

I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively

...the attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5. 6. 7. 8. 9. https://www.truckplanet.com/Tanker+Trucks 10. 11. Then for any vehicles that meet all of the Criteria listed below, fill out all of the columns of the Excel sheet. You will

I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.

Project Description The goal is to transform an existing script that uses Google Documents AI to extract invoice data into a complete system that manages the data in a relational database and provides an interactive web interface for managing and viewing this data. Additionally, the system should allow user management with specific functionalities for assigning and managing invoices. Project Requirements 1. Data Migration Modify the current Python script to insert data directly into a relational database (e.g., PostgreSQL or MySQL) instead of exporting it to a CSV file. 2. Database Design a database to store: Invoice Data: Invoice number, date, amount, client, supplier, details, etc. Users: Name, email, password (encrypted), roles (admin/user), and assigned root folder. Me...

I'm seeking a talented content creator with a knack for writing engaging video scripts. These scripts will be tailored for my social media platforms - Facebook, Instagram, and Twitter. Ideal Skills: - Proficiency in crafting compelling video scripts - Understanding of different social media platforms - Ability to create content that resonates with a diverse audience Experience: - Prior experience with content creation for social media is highly desirable. - A portfolio of video scripts or social media content is a plus. I look forward to reviewing your proposals.

python automation to generate data from website using API

I'm looking for a Pine Script developer to help me create an indicator for the Nifty 50 that checks for both bullish and bearish divergences between stock prices and option prices. I have the algorithm and formulas ready; I just need a coder to implement it. The task isn't complex, but it does require a solid understanding of Pine Script and experience with the Indian stock market. Key Responsibilities: - Develop a Pine Script based on provided algorithms/formulas - Create an indicator to detect both bullish and bearish divergences - Ensure the indicator checks divergence in the stock prices and option prices Ideal Skills: - Proficient in Pine Script - Knowledgeable in the Indian Stock Market, specifically Nifty 50 - Experience in creating stock mar...

I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.

We need a small project done, to help our dev team as they're busy. Task is to make a Java EE tool that processes a CSV file with "Name" and "phone number" columns. For each record, it will: 1. Make an API call to Elevenlabs' text-to-MP3 service to synthesize a one-minute voice file with a script including the "Name". 2. Send the generated MP3 file to the corresponding phone number via Slybroadcast's API. You need to have previous experience with Java Spring Boot and API integrations, particularly with audio synthesis and telephony APIs. Key Tasks: - Read and process a provided sample CSV file. - Make API calls to Elevenlabs and Slybroadcast. - Handle phone numbers in local format without country code. I've got accounts for bot...

Hi, I have done it as discussed.

I'm seeking a seasoned Python programmer to enhance my current Python automation script. The automation is currently running on my local machine. Key Requirements: - Performance optimization: The script needs to run more efficiently. - New features: I have a few ideas for new features to add, but I would appreciate your input as a Python expert. - Bug fixes: There are a few bugs that need to be addressed. Ideal Skills and Experience: - Extensive experience with Python programming - Strong problem-solving skills for debugging - Ability to optimize performance - Creative thinking for suggesting and implementing new features

...Vendor/contractor database for outsourced maintenance or repairs. • Assign tasks to staff/vendors and track progress/costs. 8. Advanced Analytics • Occupancy trends, vacancy patterns over time. • Maintenance cost analysis (by property/unit). • Potential for predictive insights (rent forecasting, AI-driven maintenance). 9. Import/Export & Data Migration • CSV/Excel bulk-import for existing records (properties, tenants, etc.). • CSV/Excel export for accounting, sharing with partners, or offline analysis. • Simple data migration tools to ease transition from legacy systems. 10. Security & Compliance • Role-based access control, encrypted credentials, and secure endpoints. • Audit logging (track who edited what ...

I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks

EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce on lase...

I'm seeking an expert in the sports betting industry who can alter a filter in my script that's integrated with a Telegram channel. Ideally, you should have experience with Betburger API and know how to modify specific filters, particularly the value percentage. Key Requirements: - Modify existing odds ranges to narrow the scope - Adjust the betting odds filter accordingly - Integrate with Betburger API if necessary The ideal freelancer for this project will have a deep understanding of sports betting and be able to make precise adjustments to the script. Experience with Telegram integration and Betburger API is a significant advantage.

I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that the data is correctly organized.

I'm looking for a professional who can help me modify the current log filtering criteria in my Python script on the server. Ideal Skills and Experience: - Proficient in Python scripting - Experience with log filtering - Server management skills - Ability to modify existing code The successful freelancer will have to connect to the server where the script is hosted, review the current filtering criteria and make necessary modifications as per our discussion. Clear communication and understanding of the requirements are crucial for this project.

...transitions, add sub titles, and other elements to enhance the video Ideal Skills: - Proficiency in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experience in creating content for social media platforms, particularly Instagram Please provide examples of your previous work, especially if you have experience with product showcase videos. The script is as follows and the raw footage will be me reading the script. [Attention-Grabbing Opening] Are you struggling to get bookings on Airbnb? Where your listing appears on the Airbnb platform has a huge impact on how many bookings you receive. It can mean the difference between being fully booked or having your property sit empty. The good news? Getting your listing to the top of Airbnb’s search resul...

I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intuitive interface. Plea...

I'm seeking a talented scriptwriter and PowerPoint expert to help me craft an engaging script and presentation for an upcoming awards ceremony. Key Requirements: - Script Development: The script should cover the opening speeches and welcome, as well as introduce award nominees. It needs to be engaging, respectful and fitting for an awards ceremony. - PowerPoint Creation: The PowerPoint needs to align with the script, visually complementing the speeches and helping to engage the audience. The opening speeches will be delivered by the event host. Therefore, the script should be written in a way that is easy for the host to deliver, with appropriate pauses and cues for applause. Ideal Skills and Experience: - Previous experience writing scripts fo...

I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!

ERP Data Migration Consultant Responsibilities: Analyze and resolve data duplication issues in inventory and client-stored wine records. Generate and review reports to identify discrepancies in purchase orders (POs) and sales orders (SOs). Collaborate with internal teams to reconcile discrepancies between Xero and Wine Owners. Propose and implement solutions, including script-based corrections, to rectify the migration dataset. Provide guidance and recommendations to prevent future data migration errors. Work closely with our ERP partner, Wine Owners, to ensure all adjustments align with system requirements. Requirements: Proven experience in ERP data migration and troubleshooting, preferably with platforms like Wine Owners or similar inventory management systems. Expertise in ...

I'm seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and ability to present d...

I'm looking for a simple yet effective Pine Script that implements a trend-following strategy using Simple Moving Averages (SMA) on TradingView. I basically want to backtest trading various ETFs against index moving averages, with adjustable buy/sell points based on the length of moving averages selected. Key requirements: - The script must incorporate SMA-based trend-following mechanics. - It should be simple, user-friendly, and easily adjustable to different timeframes and assets. Ideal candidates will have: - Proficiency in Pine Script with a portfolio of similar trading scripts. - Solid understanding of trend-following strategies and the use of SMAs. - Experience with TradingView platform. This is a straightforward project for a freelancer with the righ...

I'm looking for a professional Unity developer to create a script for a game. You can see the exact requirements in the attached video. The task is to write a script for waves of monsters attacking castle, or rather, control their movement behaviour, because there is an existing Monster Spawner script, so the freelancer should either modify existing script, or create a new script - also imported into the project is the Blaze AI tool, the freelancer can also use that, or use the built in NavMesh Agent system. Skills and experience required: - Extensive knowledge of Unity and 3D game development - Strong understanding of game design principles - Creative thinking and problem-solving skills - Previous experience in developing PC games - Ability to wor...

I need assistance with a personal project involving a Telegram channel. After integrating a Betburger API into the channel, I require alterations to the filters in the server-side script. The primary focus of these changes is to filter media content. Key Responsibilities: - Modify existing filters on the server-side script to better manage media content - Ensure the script works seamlessly post modifications Ideal Skills: - Proficiency in working with Messaging APIs, specifically Telegram's - Experience in modifying server-side scripts - Strong understanding of media content filtering I am looking for a freelancer who can help me with this task promptly and efficiently. Experience with Telegram and its APIs will be highly advantageous.

I'm looking for an experienced Pine Script developer who can build a custom range-based price indicator for me. Key Requirements: - Deep understanding of range-based indicators and price movements - Proficiency in Pine Script - Previous experience building custom indicators on TradingView The main output of this project will be a unique indicator that I can use to track price ranges. It should be able to provide clear and accurate signals based on the price range movement. Please include examples of previous Pine Script indicators you have developed in your proposal.

I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details

I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: ...Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projec...

We are looking for...unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for reporting progress. Payment Structure: - $100 for every 50 live and verified links. - Bonuses available for exceptional performance and securing links from high-authority sites (DA 50+). Websites You Can Offer in Exchange:

I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.

I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills

...database. The project involves transforming the way I track my nutrition, currently done via an Excel spreadsheet, into a more sophisticated system leveraging FileMaker's capabilities. Key Requirements: - Each day should be a separate record in the database - Daily food items will need to be selectable via both a search function and a drop-down menu/list - Nutritional values should be linked from a resident table - The system should generate summary reports over various time periods (week/month/year) and allow data to be assembled in different ways (e.g. grams of protein from seafood in March, average grams of tuna per day, etc.) - The database should utilize advanced structures with relational and lookup features, which I currently lack the skills to create Nutriti...

I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you have a solid ...

...addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel, Google Sheets). Strong web research...

I have a hidden crm form script on my contact page that I need removed. see screenshot. Also when adding new crm script there is an error with recaptcha see screenshot. Pls only bid if you are available now

PHP Survey Script Tweaks Project Description: I have installed a raw PHP survey script and require the following customizations to improve its functionality and user experience: Optimize CSV Import Performance: Currently, importing large CSV files takes too long and sometimes fails to provide a file for download. I need this process optimized for efficiency and reliability. Enhance Graph Display: The results include graphs, but the values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for...

...freelancers! ? We are looking for a talented UGC (User-Generated Content) Creator to produce an engaging video simulating live gameplay for our gaming app. The content should feel authentic, exciting, and relatable to attract new users. What we need: Live Simulation: Record yourself playing the game as if it’s happening in real time. Scripted Lines: Follow our provided script with enthusiasm and natural delivery (script will be shared). Engaging Performance: Showcase emotions like excitement, suspense, and joy while "winning" or reaching milestones in the game. High-Quality Video: Clear visuals and audio (recorded in a well-lit and quiet space). Example of the required style: Casual and energetic tone. Background setup resembling a home gaming environment...

...supported by FTP connection (download, list files). DB connection implementation in OIC orchestrated integration. * Good hands-on experience in either FBDI based integration or web service-based integration. Knowledge of Report service is a plus, but not mandate. * Good hands-on experience in monitoring, debugging of OIC integration and migration of OIC components. * Good hand-on experience of Lookup configuration. Knowledge of Library configuration and certificate & Key management is a plus, but not mandate. * Understanding of large file manipulation with segment read is a plus, but not mandate. * Understanding of Encryption and decryption in FTP connection and stage file activity is a plus, but not mandate. * Good hands-on experience of SQL and basic of PLSQL. * Knowledge o...

I need a PHP script capable of generating and signing JSON Web Tokens (JWT) offline. The signing process should replicate the behavior of an existing system where the private key is inaccessible. The goal is to simulate the signing mechanism without relying on direct access to the private key. Requirements: Develop a PHP script to interact with a given API endpoint that requires signed JWTs for authentication. Analyze the target system's logic to understand its signing requirements. Implement a solution to generate valid JWTs based on the system's structure and expected behavior, bypassing any dependency on direct private key access. The script should include: JWT header generation (e.g., alg: RS256, typ: JWT, kid: key ID). Payload creation based on specifi...

Delivery Cost Mapping for WooCommerce example below Base Pricing by County and Weight Tier County Light (€) Medium (€) Medium Heavy (€) Heavy (€) Very Heavy (€) Fastway (€) Dublin 20 30 60 80 100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcha...

...data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Experience with Figma to web replication - Strong understanding of minimalistic design principles - Ability to work wi...

I'm in need of a talented writer who can create a Nukkad Natak script for street play at a college event . The script should focus on the Indian judicial system, incorporating needed reforms and a touch of satire. The primary aim is to engage and entertain the general public with a humorous entire street play will be in Hindi Ideal Skills and Experience: - Strong background in script writing, particularly Nukkad Natak. - In-depth understanding of the Indian judicial system and its reforms. - Ability to infuse satire and humour into serious subject matter. - Excellent comprehension of audience engagement techniques.

I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .

...in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Excel and Go...

Looking for a detail-oriented data entry specialist for product catalog management. (~1,500 products) Key responsibilities: Manual data entry of product information into Excel/Google Sheets Accurately copying product image URLs from provided online sources Following provided guidelines for data organization Requirements: Strong attention to detail Proficiency in Excel/Google Sheets Reliable internet connection Ability to handle repetitive tasks with accuracy We provide full training and ongoing support throughout the project. Part-time/flexible hours available. Please share your relevant experience and availability to get started.

We are looking for a DLL written in C# that can be used with MS Access through VBA code using late binding. The library should be capable of sending controlled error emails from MS Access and returning a response confirming the success or failure of the sending.