Vba extract data mdb punët
Please watch this video explaning: I have a large CSS file that impacts multiple accounts in GoHighLevel. One specific account has custom styling applied through a theme builder (without manual coding), and I need to extract only the CSS that affects this specific account. I can read CSS, but I’m unsure how this theme builder is selecting the location, as it does not explicitly use an ID selector. Your task will be to identify and isolate the relevant styles. Task Requirements I need a CSS developer who can: Analyze the provided CSS file and determine how it applies styles to different locations. Remove all styles that affect other accounts and leave only the CSS that applies to this specific
Real-Time Data Retrieval: The Python system will connect to the Binomo API to retrieve real-time data for candles (candlesticks) and available assets, with special focus on Crypto IDX assets. This system will extract relevant data such as opening price, closing price, high, low, and volume for each candle, and store it in a .json file for later analysis. Data should be continuously collected and stored in real-time to feed other processes or analyses. The system must handle multiple assets simultaneously. Automated Trading Bot: The automated trading bot will execute trades based on external signals indicating whether the market is bullish or bearish. The bot will read these signals (e.g., Fecha....., alcista,....) and execute the corresponding trades on ...
...create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Query. - Good understanding of da...
I have an Excel wo...Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel ...
...APIs: Google Ads API: Fetch campaign data, adjust bids. Meta Business Suite: Collect engagement metrics. Google Analytics: Extract conversion data. Data Analysis and Machine Learning: Cross metrics (e.g.: CPA + LTV) to identify opportunities. ML model to predict trends (e.g.: seasonality). Generate proactive alerts (e.g.: "CPA above expected in Campaign Y"). Security and Compliance: End-to-end encryption. OAuth 2.0 authentication for APIs. LGPD compliance. Proposed Architecture: Frontend: WhatsApp Business API (receives/processes messages). NLP Layer: Processes the query and extracts intent/parameters. Backend: Query external APIs (Google Ads, Meta Ads). Runs ML models (e.g.: ROI prediction). Generates structured responses. Data Lake: Stores...
...a skilled Python developer to create an online script. This script needs to extract readable data from Twine 2 / Sugarcube saved files. (more info about Twine: ) Key Requirements: - The script should be able to decode saved games to read data. - The script should check if the given saved game is a valid Twine 2 saved game. - The primary data to be extracted includes basic information, mainly the Title. If the initial project is successful, there's potential for expansion to create an editor for saved games. You will be provided with sample Twine 2 saved files for testing. The extracted data needs to be outputted in plain text. Ideal Skills: - Proficiency in Python - Experience with data extraction and decoding Attached is an examp...
I'm seeking a skilled photo editor to merge two family portraits into one, focusing on extracting the best facial expressions from both images. The final product should feature combined faces primarily of the children, as their expressions are the most critical to the overall composition. Key Requirements: - Expertise in photo editing and merging images - Ability to prioritize and extract optimal facial expressions - Experience in family portrait editing The final combined portrait does not require any specific retouches or adjustments, such as skin smoothing, brightness or contrast changes. My main focus is on the facial expressions, so your skills in this area will be especially valuable.
Extract images from the given link and name the images with their respective SKUs
I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that ...template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed operation formulas. - Familiarity with Excel's macro and...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
...enhance the platform’s performance and scalability. Additionally, candidates should be able to develop blockchain-based analytics by leveraging blockchain API platforms to analyze trends and track relevant data. This role offers a base salary of $2,000 - $4,000 per month plus performance-based bonuses for exceptional work and timely delivery. Responsibilities: - Front-End Development: - Implement the provided UI designs using React (mandatory). - Create a responsive and dynamic user interface optimized for a desktop web app. - Integrate front-end components with back-end APIs and ensure smooth data flow. Back-End Development: - Build and deploy the platform’s back-end functionalities using Node.js or similar server-side frameworks like Django or Flask. - Use ...
I am seeking a freelancer who can sift through my most recent YouTube videos and extract the best moments to create 30-60 second viral shorts. Key Responsibilities: - Review my recent YouTube videos for humorous, engaging, or intense content - Edit these into engaging 30-60 second clips Ideal Skills and Experience: - Proficient in video editing software - Understanding of YouTube's content and viral trends - Ability to identify and extract funny moments
...need of a proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and...
I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data...
...requirements, identifies UI components, and generates wireframes with varying fidelity levels. The AI model can be of your choice as langgraph makes it easy to interchange I have tried implementing this on my own , but did not get the best results. Some brief about the Project feel free to add modify steps. Objectives: Automate wireframe creation by processing and interpreting project descriptions. Extract functional requirements including user personas, UI elements, and key design components. Determine necessary pages and site map based on inferred project scope. Generate low- and high-fidelity wireframes to provide a clear visual representation of project requirements. guidelines- High-Level Approach for AI-Powered Wireframe Generation Agent 1. User Input & Requirement ...
Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work
...to create a web scraping program compatible with a MAC M2 processor. The specifics of the data to be scraped, the target websites, and the ultimate use of the data are currently undetermined. Therefore, flexibility and adaptability will be key to this project. Project: Setting in the program where it is possible to store and change login information Website Spamzilla Login information and password Website Ubersuggest Login information and password When clicking on ”start to extract from Spamzilla” button following will happen Login to a Spamzilla Extract predefine filters and make them choicble in the program as a dropdown list When chosen a predefined filter the program began to extract data from the website and import it t...
...need an AI agent that can extract contact data from social media platforms, primarily Instagram, and manage my email marketing tasks. Key Requirements: - Data Extraction: The AI should be able to extract 'Name' and 'Email' from Instagram, FaceBook, Ticktok, X, Youtube and compile this data into a CSV file. - Email Management: It should check for duplicate entries and manage email campaigns, sorting emails based on their status (with a focus on 'Opened'). It should have the ability to send emails in batches. Ideal Skills: - Proficiency in AI development - Experience with data scraping - Understanding of email marketing systems - Ability to create and manage CSV files I'm looking for a professional who c...
We are a Canada-based company looking for a skilled developer to design and implement a custom solution for extracting specific data from documents using a mobile camera. The primary focus will be on reading and structuring medicine-related data from prescriptions, along with capturing other relevant information. Key Requirements: Develop a program to process and extract text using a mobile camera. Utilize open-source models instead of proprietary solutions like OpenAI or Gemini to allow future customization. Design an optimized pipeline for inference and deployment, ensuring efficiency and scalability. Ensure the solution is adaptable for future modifications as per evolving requirements. Preferred Skills & Experience: Experience with OCR (Tesseract, EasyOCR, ...
...Description:** I need a skilled freelancer to perform **web scraping** for a specific project. Here are the details: 1. Scrape data from [website name: stats perform/URL: ]. 2. Extract the following information: - [Specify the data fields you need, e.g., Seasons, Matchday, Results, Match Summary, Opta Points, Match Details, Venue, Attendance, Referee, date, Goal Assist, Cards, Cross ,Foul won, Foul conceded, Goal/Own Goal, Interception ,Offside, Pass, Penalty (Won, Conceded and Taken), Shot, Shot on target, Shot off target, Tackle, Save, Penalty Save] 3. The data should be delivered in [desired format, Excel, CSV]. 4. Ensure the script is reusable for future updates and scraping. 5
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
...FBA Wholesale sellers. The goal of the extension is to help sellers make data-driven decisions about whether a product is worth selling on Amazon based on the analysis of Keepa’s price history and sales rank trends. The extension will need to: - Detect Keepa charts on Amazon product pages and extract relevant data from them. - Use AI to analyze the data from the charts and provide a recommendation about whether the product is a good candidate for Wholesale FBA selling. - Display the analysis results in a simple and user-friendly interface, directly on the Keepa chart page. Key Features and Requirements: 1. Keepa Chart Detection: The extension must detect when a user is on a page with a Keepa chart, and extract data such as price histor...
I need a Node.js expert to create a script that will: - Extract articles from a Google Sheet. The articles are in Rich text format. - Convert them to HTML using an AI API (any of your choice: OpenAI, DeepAI, Hugging Face). - Structure the HTML with headings and subheadings. - Save the final output in a JSON file. Ideal candidates for this project should have: - Proficient knowledge in Node.js. - Experience in working with Google Sheets API. - Familiarity with various AI APIs for text processing. - Ability to structure HTML code correctly.
Description: I am looking for an experienced web scraper to extract product reviews and general product data for Alpine Baby Muffy and Kids Muffy hearing protection earmuffs. Project Requirements: 1. Data Extraction: Target Websites: E-commerce platforms (Amazon, eBay, Walmart, official retailers, review sites, etc.) Primary Focus: Extracting and categorizing customer reviews into: Positive remarks (what customers like) Negative remarks (what customers dislike) Additional Data Points: Product name Price Availability (in stock/out of stock) Retailer name & website URL Product specifications Customer ratings (e.g., average rating, number of reviews) 2. Data Processing & Output: Output the review remarks in a structured format (CSV, Excel, or JSON...
web scraping and video automation developer. Job Description Project Goal: Automate the manual process of collecting business data and generating customized videos for outreach. Key Tasks to Automate: Business Research & Data Collection Scrape Google search results (pages 2–10) for target businesses. Extract business names, website URLs, and email addresses into a spreadsheet. Automated Video Generation Create a script/tool that: Simulates browser activity (e.g., scrolling, mouse movements) for a list of URLs. Overlays a pre-recorded talking-head video onto the automated browser activity to create a single, seamless video. Vimeo Upload & Link Tracking Automatically upload generated videos to Vimeo. Save Vimeo video links back to the spreadsheet...
You give me a standalone C# solution, which can 1. Read all image files (JPG) in a file folder, 2. Extract text (Chinese Simplified) and save to a doc file in the same file folder, 3. Name the doc file the same as the image file. You can get a hint here: Sample Input and sample output are given in attached files. Steps: 1. You work on your own. 2. When you are ready, I send you an image file, you send me back the generated doc file in 2 minutes. 3. If the quality is fine, you send me code, and I test on my computer. If everything is good, I will pay you.
...Chat bot must have self learning power, Sone features that i need: 1.1 Natural Language Processing (NLP) • Understands user queries in natural language. • Supports multi-turn conversations. • Can recognize user intent and extract entities (e.g., names, dates, locations). 1.2 Multi-Platform Integration • Works on web, mobile, WhatsApp, Facebook Messenger, Telegram, Slack, etc. • API support for integrating with third-party apps (CRM, e-commerce platforms). 1.3 Context Awareness & Memory • Remembers previous interactions within a session. • Can retrieve past data (e.g., user preferences, order history). 1.4 Predefined & AI-Generated Responses • Combination of scripted responses (FAQs) and AI-generated replies. &bull...
I'm in need of a reliable and efficient data scraper who can pull order details from my Aliexpress account into an Excel file. The scraper should allow me to manually set a date range for the data I want to extract. -Data Requirements: I will provide a template for the data. - Frequency of Task: I would like the scraper to be user-friendly enough so that I can set a start and end date for future data scraping tasks each time I run the scrapper. Ideal skills for this project include experience with web scraping, familiarity with Aliexpress, and proficiency in Excel. A good understanding of data handling and the ability to create a user-friendly interface will be an added advantage. I have attached below a sample of output file
I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.
I need an expert in web scraping who can extract email addresses of faculty professors from various university websites in the educational sector. Ideal skills and experience: - Proficiency in web scraping tools and software - Previous experience in data extraction from educational websites - Excellent attention to detail to ensure data accuracy - Knowledge of data privacy laws and ethical considerations in data scraping - Ability to deliver the work in a timely manner
Website Data Scraping for The Electric Radiator Superstore Objective: To scrape and extract all relevant data from the above website for internal use. The extracted data must be well-organised, accurate, and easy to navigate for future reference. (Wordpress based but do not want to use the WP plugin) Scope of Work: 1. Data to Scrape: • Product details (e.g., product names, descriptions, specifications, features, images, pricing, and PDFs, if available). • Blogs and articles (titles, content, and associated metadata such as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structu...
I'm looking for a freelancer who can transfer contact details from multiple web pages into a spreadsheet. Key Tasks: - Extract contact details from approximateley 50 web pages - Populate a spreadsheet with the information as specified Please refer to the attached spreadsheet for specifics on the contact details to be collected. Web site is on the spreadsheet. Please make sure you are able to access the site and understand the project before bidding.
...placing a monochrome image or color layer behind it. It is crucial to retain the shadows of objects in front of the wall (e.g., plants, furniture, lamps) to ensure the final result looks as realistic as possible. Requirements: Wall Transparency: Remove the wall color completely, making it transparent. Ensure smooth and precise masking around objects in front of the wall. Shadow Retention: Extract and preserve the shadows on the wall from objects like furniture and decor. Adjust the shadows so they remain realistic when placed over different wall colors (use appropriate blending modes, e.g., Multiply, if needed). Output Format: Deliver the final file as a high-resolution PNG with transparent wall areas. Additional Notes: The lighting and shadows must appear natural and seam...
...should extract the payment link and send it to a specified Telegram group or chat via Telegram Bot API. Key Requirements: Secure Login & Session Management Implement a login form within our web application. Handle session cookies, tokens, and any necessary authentication details to maintain the user’s logged-in state with VFS Global. Appointment Scheduling & Group Bookings Parse/scrape the appointment scheduling pages to identify available time slots. Allow users to enter multiple passport details (group bookings). Confirm the chosen appointment time(s) via the relevant POST requests. Payment Link Extraction After confirming appointments, automatically retrieve the payment link from the response or subsequent pages. Provide a reliable method (HTML/JSON parsing)...
I need a proficient web scraper to extract 30,000 datasets from a single German fashion website. This includes product names, descriptions, prices, and product images (approximately 4 images per product, around 30 kB each). Key requirements: - Meticulous attention to detail to ensure accurate data capture - Experience with handling images during data scraping - Ability to deliver clean, well-organized data The final dataset should be delivered in either CSV or SQL format. Please be prepared to demonstrate your previous work in web scraping.
...API Integration and Data Management System We are seeking a skilled developer to create a backend system that integrates OpenAI’s ChatGPT with a database for storing and parsing AI-generated responses. This project requires API integration expertise, database management skills, and the ability to build a scalable and secure solution. Key Responsibilities: • ChatGPT API Integration: Send user inputs to ChatGPT, handle API responses, and implement robust error handling. • Database Management: Store inputs and ChatGPT responses in a database (Firestore) with an efficient schema. • Response Parsing: Extract and structure data from ChatGPT responses for further use. • API Endpoint Development: Build or enhance a REST API to manage user inputs ...
...perform file uploads, select different AI models, and generate a summary of the uploaded document using a prompt. The summarized response is then saved to a file which is downloadable by the user. Key Responsibilities: - Upgrade the existing codebase to integrate additional AI models, particularly GPT4o and Anthropic, to the system using their respective APIs. note that while I've used PyPDF to extract the text for the Ollama model, I'd like to use OpenAI or Anthropic API with uploading the PDF directly to their services rather than doing the extraction/OCR locally. - Ensure seamless interaction and functionality across all integrated AI models - Implement the necessary enhancements to make the system more robust and versatile Ideal Skills and Experience: - Proficien...
web scraping and video automation developer. Job Description Project Goal: Automate the manual process of collecting business data and generating customized videos for outreach. Key Tasks to Automate: Business Research & Data Collection Scrape Google search results (pages 2–10) for target businesses. Extract business names, website URLs, and email addresses into a spreadsheet. Automated Video Generation Create a script/tool that: Simulates browser activity (e.g., scrolling, mouse movements) for a list of URLs. Overlays a pre-recorded talking-head video onto the automated browser activity to create a single, seamless video. Vimeo Upload & Link Tracking Automatically upload generated videos to Vimeo. Save Vimeo video links back to the spreadsheet...
I'm working on a high school project involving a basic calculation app APK. I need a freelancer to extract the arithmetic operations from the source code and provide them in a plain text document as a step-by-step list of formulas. Ideal Skills: - Proficient in working with APKs and understanding app source code - Excellent written communication skills for clear, concise explanations. The app only performs basic arithmetic operations: When entered inpurts. I need the extracted formulas listed in a simple format.
I've inherited a project pushed to GitLab. I need to extract the 'Published' internal data (and types) within the Project application so I can identify what's available to 'Subscribe' to when creating a ROS node. The application is in C++. I'm a newbie to GitLab, so need to know how to do this and get guidance. The ideal freelancer will have: - Very Good Experience with GitLab - Experience in C++ - Familiarity with ROS (any version) - Ability to document clearly. Any format will do, PDF would be ideal. - Capable of identifying data structures and types.
The primary goal is to estimate blood pressure from PPG involves extracting true values for training from videos. The videos are in MP4 format, and I need ...primary goal is to estimate blood pressure from PPG involves extracting true values for training from videos. The videos are in MP4 format, and I need assistance from someone skilled in data analysis, machine learning and medical imaging interpretation. Please note: - The primary goal is to estimate blood pressure from PPG data. - The successful freelancer will need to accurately extract the necessary data from the provided videos. - PPG data analysis will be highly advantageous. - Proficiency in machine learning will be necessary for training the model with the extracted data. - The ppg...
...exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in writing Windows batch files. - Excel VBA. - Experience with file handling and FTP in a Windows environment. I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., , ). Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line. The batch file shoul...
My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.
I'm seekin...agents that can enhance our operational efficiency. The goal of this project is to develop comprehensive workflow automation solutions that can streamline our business processes and extract meaningful insights from a variety of data sources. Ideal Skills and Experience: - Proficient in AI and machine learning - Experienced in developing automation agents - Understanding of comprehensive workflow automation - Capable of handling diverse data sources Key Project Components: - Developing AI-driven solutions for automating critical business operations - Creating intelligent systems that can analyze and interpret data - Delivering projects that enhance operational efficiency and effectiveness Let's arrange a meeting to discuss this opportuni...
Looking for an experienced developer to writer a script and scrape a website for data attributes that gets sent to an API. Details to be discussed in chat.
I'm looking for a proficient web developer who can create a web scraper for a real estate website, specifically propertyfinder.com. The scraper should be able to extract comprehensive property details, agent information, size, pictures, bedrooms, and location. Key Requirements: - Extract data from - Save the scraped data in Excel/CSV format. Ideal Skills: - Proficient in web scraping - Familiarity with real estate websites - Excellent data handling skills. Please include examples of similar projects you've completed in your proposal.
...document processing workflow. A PDF document containing client information (e.g., name, address, and mortgage details) needs to be uploaded. Certain fields must be extracted, validated by a human, and then have the key data fields stored in a Google Sheet for future use. Objective: Design a solution for this process and implement a basic prototype or provide a detailed explanation of the steps you would take. Use a no-code automation tool where possible (eg: n8n) Instructions: Doc Upload Upload a PDF. You can take examples PDF from the internet. Extract key pieces of data (e.g., Name, Address, Mortgage Amount, mortgage number, lender name). Outline assumptions or edge cases you’d consider (e.g., handling missing fields, formatting issues). Doc Validati...
I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.
I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data
I'm seeking a data entry clerk who can help me extract salah timetables from images and websites of approximately 50-100 mosques around the UK every month. This task involves: 1. Visiting the website of each mosque to screenshot the timetable for the current month. 2. Using any reliable tool to extract the data (I can provide access to ExtractTable if needed). 3. Copying and pasting the table columns into a provided template file. 4. Ensuring that the formatting is correct, with columns in the right order and times in 24h format. 5. Sending the completed file back to me. It takes approximately 2-5 minutes per mosque and so, I will pay £0.10 - £0.20 per file completed correctly. That means if you complete 50 timetables over 2 hours, you will ea...