Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...domains and commercially sensitive terms using stable, consistent replacement values across all files - Strong understanding of data consistency — page identities must match across GSC, GA4, and Shopify exports - Access to established Shopify stores with real organic traffic and at least 6 months of history - Familiarity with GSC non-dimensional property totals (not reconstructed from query-level rows) - Ability to document export methodology, timezones, URL normalisation decisions, and any sampling or filtering applied - CSV or JSON export format preferred Deliverables (initial sample — 60 to 90 days from one store): - GSC daily property totals: date, clicks, impressions, CTR, average position - GSC daily page performance: date, page, clicks, impressions, CTR, avera...
...should be modular, strong, printable, and easy to assemble. Printer Bambu Lab A1 Maximum build volume: 256 × 256 × 256 mm The design should be split into printable pieces if necessary. Phones Design around: Apple iPhone 16 Pro Max with a rugged protective case Approximate design envelope: Width: 86 mm Height: 170 mm Thickness: 18 mm Smaller phones should also fit. Capacity 20 phones Two rows of 10 phones Required Features Phone Cradles Each phone should: Rest at approximately 15° angle Be easy to insert and remove Not rest on the USB connector Be securely supported Have hidden cable routing Cable Management Design hidden cable routing. USB cables should not be visible from the front. Cables should route underneath the station to the rear electr...
...If you already have a proven method for verifying emails or handling departments with multiple sub-units, mention that briefly as well. THis list must NOT have any failed contact information or department centrealized phone numbers but a direct contact number of the faculty or research scientist. Accuracy and completeness are far more important to me than sheer volume. I will review the random rows as a milestone before we proceed to the remainder....
...property and consistent column headers. I will consider the job complete when I can filter, sort, and pivot the sheet without hitting blank or mismatched fields. Key expectations • All target property types covered (apartments, cottages, B&Bs) • Accurate capture of property name, full address, geo-coordinates if shown, amenities summary, and contact phone number • No duplicates, no missing rows, no truncated text • Scraper respects and rate limits or uses rotating proxies where needed • Clear, well-commented code supplied so I can rerun the scrape later (Python, BeautifulSoup/Scrapy/Selenium—use what suits you) If anything on the site requires special handling—JavaScript-rendered content, pagination, or CAPTCHA—please no...
...Delica or similar cylinder beads are my preferred medium, so keep grid sizes and colour palettes compatible with those beads. I’m comfortable with peyote, brick, or square stitch, so feel free to pick whichever technique shows the design best, but note it on the page so makers know what to follow. To keep things user-friendly, each pattern page should include: • A full-colour graph with labelled rows/columns • A legend of bead colours and quantities • Written row-by-row instructions for beginners • A small photo or mock-up of the finished keychain for reference Please lay the final document out in InDesign, Canva, or another tool that exports a clean, high-resolution PDF. If you use BeadTool or BeadCreator for the charts, export those images at...
I’m streamlining a growing dataset of local information and need a detail-oriented assistant to keep it accurate and up to date. The job is straightforward:...into my existing spreadsheet template. You’ll receive clear field-by-field instructions, source links, and an example record to follow. Consistency and speed matter more than volume; I’d rather have one perfectly formatted row than ten that need fixing. Familiarity with Google Sheets or Excel is a plus because that’s where you’ll be working. Deliverable: • Completed and fully verified spreadsheet rows for each batch I assign, ready for immediate use. I’m looking to start as soon as possible, so let me know your experience with similar online-sourced data entry projects and how quickl...
...an efficient pipeline that ingests, cleans, and joins the tables at scale, to writing performant queries and statistical routines that surface trends I can use in decision-making. The stack is open: Apache Spark, Hadoop, distributed SQL engines, or another platform you’re confident will keep runtimes reasonable and costs under control. What matters most is that the solution handles billions of rows without sacrificing accuracy or maintainability and that every step you take is reproducible. Acceptance for the work will be based on: • A documented workflow (code notebooks or scripts plus a short README) that builds the analysis end-to-end. • Clear, interpretable output—aggregate tables or summary metrics—that I can validate against spot checks in ...
I have designed a dedicated home-cinema room and now need a clean AutoCAD 2D layout to take it from concept to build-ready documentation. I’m aiming for a drawing that clearly shows wall dimensions, screen and speaker positions, seating rows, and any acoustic treatments, all laid out to scale. The sample file I’ve attached illustrates the overall footprint and rough placement, but I want the final DWG to look professional and easily sharable with contractors. Please include precise furniture placement—once we begin I’ll forward a list of the exact seats, media console, and side tables (with model numbers and dimensions) so you can block them in accurately. Key things I’m looking for: • Correct scaling and dimensioning throughout. • Layer...
I have a collection of online databases that need to be brought together in a single, well-structured Excel workbook. The records include ...specified sites, enter it into the template I provide, and double-check that every value lines up with the correct header. I’ll share the URLs, access credentials (if required), and the exact column order once we start. Key points I care about • Accuracy over speed – no misplaced decimals or truncated text. • Consistent formatting – for instance, dates should follow the same style across all rows. • A clean, duplicate-free final workbook delivered in .xlsx format. If you’re comfortable extracting mixed data from web sources, cross-verifying it, and laying it out neatly in Excel, I’d love to h...
...Itinerary Experience Design complete trip management including: * Timeline * Flight segments * Hotels * Airport transfers * Activities * Boarding passes * Travel documents * Visa reminders * Weather * Airport instructions * Emergency information --- ## Seat Map Experience Design an intuitive seat selection experience. Include: * Interactive seat maps * Aircraft layouts * Cabin sections * Exit rows * Extra legroom * Premium seats * Seat comparison * AI seat recommendations --- ## Airport Experience Design information-rich airport pages. Include: * Airport maps * Terminal guides * Gates * Lounges * Restaurants * Walking directions * Parking * Transportation * Security wait times --- ## User Profile & Settings Design: * User profile * Travel preferences * Preferr...
I have a collection of online databases that need to be brought together in a single, well-structured Excel workbook. The records include ...specified sites, enter it into the template I provide, and double-check that every value lines up with the correct header. I’ll share the URLs, access credentials (if required), and the exact column order once we start. Key points I care about • Accuracy over speed – no misplaced decimals or truncated text. • Consistent formatting – for instance, dates should follow the same style across all rows. • A clean, duplicate-free final workbook delivered in .xlsx format. If you’re comfortable extracting mixed data from web sources, cross-verifying it, and laying it out neatly in Excel, I’d love to h...
I have an Excel workbook that has grown messy after months of manual entries. I need a sharp-eyed Excel specialist to bring it back into shape. Here’s exact...new data set I’ll provide. • Audit all existing formulas—SUMIF/S, VLOOKUP/XLOOKUP, pivots, percentages—and correct anything that is returning the wrong results or referencing the wrong ranges. Acceptance criteria The file comes back with: 1. No broken formulas or #ERROR values. 2. Customer, product, and sales tabs perfectly aligned with the master lists I supply (no duplicates, no stale rows). 3. A brief changelog sheet summarising what you corrected or replaced so I can track the updates. If you’re quick with data cleansing and know your way around advanced Excel functions, this...
...Number of houses or flats in the project • Key amenities mentioned by the developer or seller • Cost per house / flat (latest listed price or price range) Deliverables 1. A CSV or Excel file with at least 1,000 complete rows that meet the above criteria. 2. The scraping script (Python + BeautifulSoup/Scrapy, Node.js with Cheerio/Puppeteer, or a comparable stack) well-commented so I can rerun it later. 3. Brief run instructions and any environment requirements. Acceptance criteria • No duplicate projects. • All mandatory fields populated for 95 %+ of rows. • Only Bengaluru addresses; anything outside the city will be rejected. Please factor in the usual anti-bot countermeasures on these portals (CAPTCHAs, dynamic content, pa...
I need a streamlined workbook that keeps my retail product inventory accurate without constant manual intervention. All stock data will arrive from another system—typically a CSV or Excel export from our POS—so the file must let me import that f...Script are all fine if they keep the workflow one-click simple: “Import → Refresh → Decide.” Acceptance criteria 1. Import template accepts the raw export file with no column edits from me. 2. A single action updates stock, sales metrics, and low-stock flags. 3. All formulas or code are documented so I can tweak thresholds or add SKUs later. 4. Workbook performs smoothly with at least 5,000 rows of product history. Once the file matches these points, I’ll test it with live POS exports; when...
I need a streamlined workbook that keeps my retail product inventory accurate without constant manual intervention. All stock data will arrive from another system—typically a CSV or Excel export from our POS—so the file must let me import that f...Script are all fine if they keep the workflow one-click simple: “Import → Refresh → Decide.” Acceptance criteria 1. Import template accepts the raw export file with no column edits from me. 2. A single action updates stock, sales metrics, and low-stock flags. 3. All formulas or code are documented so I can tweak thresholds or add SKUs later. 4. Workbook performs smoothly with at least 5,000 rows of product history. Once the file matches these points, I’ll test it with live POS exports; when...
...data cleansing. The main focus is on standardising every field—dates, currencies, product codes, customer IDs—so the data can be trusted for downstream reporting. Once the formats are consistent, I want a concise exploratory analysis in Python (Pandas, NumPy, Matplotlib or Seaborn) that highlights high-level trends, seasonality, and any obvious outliers. If you spot missing values or duplicate rows along the way, feel free to resolve them; the primary acceptance criterion, however, is clean, consistently formatted data backed by a short insight summary. Deliverables • Python notebook or script that performs the cleaning and analysis • A cleaned CSV (or Parquet) file ready for further modelling • A brief report (PDF or Markdown) outlining the m...
I need a browser-based application where a user can drag-and-drop CSV, Excel, or JSON files, then talk to the system in plain English to fix messy data—especially rows or columns riddled with missing values. After the cleaning step, the same conversational interface should let the user request summary statistics, build quick charts, or even forecast trends. The workflow must always begin with a rock-solid imputation or other suitable treatment of nulls. Core flow I have in mind: 1. Upload: accept the three formats above and automatically profile the dataset. 2. Clean: surface any fields with gaps, let the user choose (or confirm an AI suggestion) for how those gaps are handled—mean/median substitution, forward fill, deletion, etc.—and produce a cleaned version tha...
I need a clean, ready-to-use database of 3,000 business-domain email addresses belonging to employ...and website. There is no regional or company-size restriction, so feel free to source from any province and from firms large or small. Deliverables (Excel or CSV): 1. Email address 2. Employee name (if available—title alone is fine when names are not public) 3. Company name 4. Official company website 5. Verification status / score for that email Acceptance criteria: • At least 3,000 rows that satisfy all bullet-point rules above. • A verification report or proof from the tool you used (e.g., NeverBounce, ZeroBounce, Hunter) showing an expected bounce rate below 5 %. • No duplicates. If any address hard-bounces during my spot check, I will send i...
...list every distinct irrigation project and record: • Project name • Constituency • Year sanctioned (official approval or foundation‐stone date) • Year completed/commissioned – or current status if unfinished • Name of the minister who held portfolio responsibility at sanction (and, if different, at completion) • Source URL or citation for verification Structure the spreadsheet so rows are first grouped by constituency and, within each constituency, ordered chronologically by sanction year. One row per project is enough; no merged cells or hidden columns, please. Accuracy is critical because the file will underpin academic research. Cross-check dates and ministerial names across at least two reputable sources wherever possible an...
...inside a MySQL database and I need reliable help entering new records, updating existing ones, and keeping the data clean and well-organised. The work is entirely database-based—no spreadsheets or external CRMs—so you’ll be working directly with MySQL tables. Here’s what I expect: • Accurate entry of new customer details supplied in batches (CSV or Excel). • Careful validation against existing rows to eliminate duplicates and obvious errors. • Routine clean-up: correcting formatting issues, standardising phone and address fields, and flagging incomplete records for my review. • Simple SQL queries or views that let me pull segmented customer lists quickly. Everything must stay compatible with the current MySQL setup; no changes...
...installers (residential must be a real part of what they do) - Sole traders / 1-person firms - National chains or PE-backed groups - Lead-gen agencies, brokers, manufacturers, distributors, suppliers - Any company with no findable phone or website Columns: | Company name | Website | Province | Company size| Decision maker | DM phone | Google reviews | Note | PROCESS - I need a sample (10-15 rows) matching every criterion above before I hire for the full batch. - Reply with: your price per verified lead, turnaround for 250, and confirmation you can hit the reject list....
...dash["A8"]="Ending Balance";dash["B8"]="=Inputs!B5+B7" cf["A4"]="Cash Flow Item";cf["B4"]="Amount" cf["A4"].fill=hdr;cf["B4"].fill=hdr rows=[("Opening Balance","=Inputs!B5"),("Cash from Sales","=INDEX(Inputs!B:B,MATCH("Sales",Inputs!A:A,0))"), ("COGS","=-INDEX(Inputs!B:B,MATCH("COGS",Inputs!A:A,0))"), ("Operating Expenses","=-SUMIFS(Inputs!B:B,Inputs!A:A,"Operating Expenses")"), ("Financing Inflow","=INDEX(Inputs!B:B,MATCH("Financing Inflow",Inputs!A:A,0))"), ("Financing Outflow","=-INDEX(Inputs!B:B,MATCH("Financing...
A Google Apps Script is required that keeps an eye on a specific Shared Drive folder, reads every new PDF dropped there, pulls the text inside each file (all PDFs follow the same layout), and then appends the captured fields to a running Google Sheet without overwriting prior rows. Core flow • Trigger: On-upload or timed trigger scans the folder for new PDFs. • Extraction: Parse text directly—no tables or forms, just plain body text in a predictable order. • Mapping: Identify the same key values every time and place them into predefined columns. • Output: Append the results to the bottom of one master sheet, preserving existing data. • Idempotency: Flag each processed PDF so it never imports twice. The deliverable is the fully commented...
I need the resource-allocation data that currently sits in several CSV exports from Azure DevOps move...lightweight ETL script) as long as the end result is an MS Project file where every resource from the CSVs appears correctly and is ready for further scheduling. I’ll provide a sample CSV and the full data set after kickoff; you’ll return a working .MPP (or a reproducible script that generates it) plus brief setup notes so I can repeat the process later. Acceptance criteria • All CSV resource rows appear in MS Project with accurate names and roles. • Any additional fields we agree on (availability, capacity, workloads, etc.) are populated in the correct Project columns. • No data loss or duplication across multiple CSVs. • Import method is ...
...publications for announcements, LinkedIn profiles for current leadership contacts, and supplier sites that often reference future facilities. Feel free to enrich the file with any other relevant fields you uncover (square footage, power capacity, commissioning date, etc.). Deliver the data in Excel or CSV, clearly separating operating, under-construction, and planning/permit entries. I will sample several rows against their public records and LinkedIn profiles; accuracy on those checks is the acceptance gate for payment. Let me know your proposed approach, the tools or scripts you’ll rely on, and an estimated turnaround time so we can get started right away....
...transferred accurately into our central database. The information arrives already structured in rows and columns, yet I still rely on you to double-check each value, flag obvious inconsistencies, and keep the original formatting logic intact while you populate the database tables. You will be working directly in our web-based data-entry interface, so familiarity with spreadsheet shortcuts (Excel / Google Sheets) and a steady eye for detail are essential. I will share a short style guide that explains field naming conventions, accepted date formats, and the validation rules built into the form; once you are comfortable with those, the task flows quickly. Acceptance criteria • 100 % of the rows from the supplied spreadsheets appear in the database with no missing fiel...
...Verification: each email must pass a validity check (Bounce rate under 5% on ZeroBounce, NeverBounce, Hunter, or a similar service). Deliverable – One Excel or CSV file containing 5,000 unique, validated email addresses, delivered no later than end of day Monday (my local time, GMT+8). Include firm name and website beside each email so I can cross-reference quickly. Acceptance Criteria 1. 5,000 rows minimum after cleaning. 2. <5 % hard-bounce rate on a random sample I will test. 3. 0 entries from public webmail or flagged generic prefixes. If anything is unclear, let me know now so we can lock requirements before you start....
...immediate process command over our CRM data linkage, global commission-based sales representative onboarding, and outbound pipeline metrics. Core Technical Deliverables & Task BlocksBlock 1: HubSpot Data Architecture & Stripe IntegrationLead Ingestion: Clean, validate, and upload our initial seed database of 600 verified UK commercial fleet leads via a CSV spreadsheet Mapping: Map incoming rows natively across our five custom live company properties, enforcing strict data validation on the fleet_vehicle_count attribute (15-to-250 sweet spot).Payment Integration: Link our active Stripe merchant API credentials directly into the HubSpot Commerce Hub to activate our active, no-code staging invoice 2: Global SDR Team Sourcing & DeploymentTalent Acquisition: Source, scre...
I need reliable help collecting product information and images from company websites and Google, then entering it into my website with absolute accuracy. The focus is strictly on product names, clear descriptions, and c...never compromises correctness—every entry must exactly match the source. You’ll work in hourly blocks, updating me at the end of each session with the sheet link so I can review progress. If I spot consistent accuracy over the first 200 rows, I’ll extend the assignment for the rest of the catalog. Deliverable • Completed spreadsheet populated with verified product names, descriptions, and prices, ready for immediate upload to my store. Start as soon as you can; let me know how many hours per day you can commit and when you can deliver the ...
...the template must accommodate variation themes, compliance fields, and any category-specific tabs Amazon requires. Core columns such as SKU, Ingredients, and Health Benefits are vital, but the sheet should also contain every additional field Amazon flags as required for successful listing, including those related to images, safety information, and fulfilment. If macros can speed up duplication of rows or highlight missing mandatory data, please build them in. Deliverables • A ready-to-use .xlsm file aligned with Amazon’s current Ayurveda/Health & Personal Care flat-file specifications • Built-in validation or highlighting to catch omissions before upload • A brief usage note or screen-recording that shows how to add a new product and run validati...
Description: Need a small automation task built using Google Sheets + Apps Script + Gemini API (paid tier). Input: Google Sheet with 22,000 rows. Column F has company website URLs. What's needed: Script that visits each website URL (Column F), extracts text content. Sends extracted text to Gemini API (structured JSON output) to generate: Company summary (100-150 words) Personalized first cold email (60-70 words) — fixed template with variable opening line Personalized follow-up email (30 words) — fixed template with variable opening line Short catchy subject line (3-4 words, personalized) Outputs go into 4 separate columns without breaking formatting (clean text, no stray line breaks/commas that would break CSV export). Handle failed/blocked websites gracefully ...
I have a growing collection of customer information that must be transferred into a master spreadsheet. Every record needs to include the customer’s full name, phone number, and email address exactly as they appear in my source files. You’ll receive scanned PDFs and a small batch of...format inconsistencies (proper capitalization, no extra spaces, working email syntax). When you finish, I expect: • a fully populated spreadsheet with all supplied customers entered • built-in filters left untouched and formulas still functioning • a brief log noting any illegible entries or duplicate records you had to flag Accuracy is more important than speed, but I’d like the first 200 rows completed within 48 hours so I can review sample work before we...
I need a brand-new, neatly structured contact list compiled from scratch. Accuracy is more important than volume: each entry must include full name, company (or organization), direct phone number, and a valid email address. I will confirm the exact sourcing method and final file format once we begin, so ...Excel, CSV, or feeding the data into a lightweight database if needed. The list will be used for future outreach campaigns, so duplicates, incomplete fields, or generic addresses (e.g., info@) are not acceptable. I will provide guidance on the target industries and any compliance considerations before you start gathering data. Once the initial draft is delivered, I’ll review it and send back any rows that need verification or correction; a clean, finalized version will clos...
...intact while ending up with plain-text files I can edit freely. Here’s how I see the workflow. For every batch you receive, you will transcribe the running text into a UTF-8 .txt document, retaining all headings, bullet points, and line breaks exactly where they belong. Any table or small chart that appears on the page should be lifted out and rebuilt in an accompanying Excel spreadsheet so the rows, columns, and any basic formulas mirror what I sketched. Finally, every handwritten equation must be rendered in LaTeX code so I can drop it straight into a paper later without retyping. Deliverables for each note set: • one .txt file containing the full transcribed text, with placeholders referencing each table or chart’s filename • one .xlsx file holding al...
I need a browser-based application where a user can drag-and-drop CSV, Excel, or JSON files, then talk to the system in plain English to fix messy data—especially rows or columns riddled with missing values. After the cleaning step the same conversational interface should let the user request summary statistics, build quick charts, or even forecast trends, but the workflow must always begin with a rock-solid imputation or other suitable treatment of nulls. Core flow I have in mind 1. Upload: accept the three formats above and automatically profile the dataset. 2. Clean: surface any fields with gaps, let the user choose (or confirm an AI suggestion) for how those gaps are handled—mean/median substitution, forward fill, deletion, etc.—and produce a cleaned versi...
...intact while ending up with plain-text files I can edit freely. Here’s how I see the workflow. For every batch you receive, you will transcribe the running text into a UTF-8 .txt document, retaining all headings, bullet points, and line breaks exactly where they belong. Any table or small chart that appears on the page should be lifted out and rebuilt in an accompanying Excel spreadsheet so the rows, columns, and any basic formulas mirror what I sketched. Finally, every handwritten equation must be rendered in LaTeX code so I can drop it straight into a paper later without retyping. Deliverables for each note set: • one .txt file containing the full transcribed text, with placeholders referencing each table or chart’s filename • one .xlsx file holding al...
...available, so the algorithm must squeeze maximum insight from this dataset alone. Here’s what I need from you: • A collaborative-filtering engine (memory- or model-based—convince me which makes more sense for scale) that ingests the ratings/reviews and outputs personalised movie suggestions in real time. • Clean API endpoints so the front-end can request “Top Picks” and “Because You Watched…” rows with millisecond-level latency. • Core streaming platform features—catalog browsing, playback, basic user profiles—implemented just far enough to demonstrate the recommender in a realistic environment. Acceptance criteria 1. Given a cold-start user with fewer than five ratings, the engine must still return at...
...fallback logo logic in the code querying images must be completely stripped out. Fix RAG Data Retrieval & Precise Category Filtering: Currently, the AI returns generic store homepages or broad categories instead of matching user intents (like "Trip to Phuket" or a specific dress) to precise offers, hotels, or items. Developer Action: Ensure the API connection properly filters and reads rows based on the 6 main categories, subcategories, and keyword tags in the Google Sheet. Smart Cross-Selling, Bundles & Exact Link Binding (Gemini-Like Experience): The AI agent must act as a smart, persuasive advisor capable of generating complete weekly packages (e.g., combining flights, hotels, and activities) or fashion sets/cross-selling (e.g., suggesting matching acce...
I have a 7-page PDF listing taxi fares for multiple locations. I need that content delivered in two editable formats: • A Word document whose layout, fonts, tables, and spacing mirror the PDF exactly so it can be printed or shared without any visual differences. • An Excel workbook with the same information laid out as plain data—clean rows and columns only, no formulas—so prices and locations can be updated quickly. Accuracy is critical: every fare, heading, and note must transfer correctly, and the Word file should look identical to the source when viewed side-by-side. Once complete, send both files so I can review and sign off.
I’m building a Python-based chatbot that can listen to a use... • A minimal CLI or REST endpoint so I can ask questions locally and see the answers returned. I’ll extend the front end later. Acceptance criteria 1. All code runs locally with a and concise setup notes. 2. Rephrased but semantically similar questions still locate the correct row(s) in the database. 3. Average response time under two seconds on a table of roughly 50 000 rows. Once this baseline is working, we can discuss optional refinements such as confidence scoring, answer summarisation, or a caching layer, but the first milestone is a reliable question-answer flow backed by the database. Let me know which NLP tools you prefer, any pretrained embeddings you’ll need, and a rough deliver...
A Google Apps Script is required that keeps an eye on a specific Shared Drive folder, reads every new PDF dropped there, pulls the text inside each file (all PDFs follow the same layout), and then appends the captured fields to a running Google Sheet without overwriting prior rows. Core flow • Trigger: On-upload or timed trigger scans the folder for new PDFs. • Extraction: Parse text directly—no tables or forms, just plain body text in a predictable order. • Mapping: Identify the same key values every time and place them into predefined columns. • Output: Append the results to the bottom of one master sheet, preserving existing data. • Idempotency: Flag each processed PDF so it never imports twice. The deliverable is the fully commented...
I need a dependable person to attend the Jalandhar expo this September and collect specific exhibitor details for me. Your only focus is on each exhibitor’s Company Name and the primary Contact Person attached to t...ask for a business card or verify spellings on signage, note down the contact’s full name, job title, phone and email when available, and double-check entries for accuracy before submission. Deliverable • A clean CSV (UTF-8) with two mandatory columns—Company Name and Contact Person—plus any extra contact fields you manage to capture, saved in exhibitor-name order with no duplicates or blank rows. I will be available by phone throughout the event if you need clarifications and will release payment once the CSV opens error-free and matche...
...Excel spreadsheet. From every card please capture: • Company name • Any contact details shown on that card (phone, email, website, etc.) • The WhatsApp number revealed when the WhatsApp icon is tapped The final deliverable is a single, well-structured Excel file where every row represents one company and each field is placed in its own column. Data integrity is crucial, so duplicates, blank rows, and broken characters should be removed or flagged for review. Because there are thousands of entries, I expect an automated approach (Python, BeautifulSoup, Selenium, or similar mobile-app scraping tools) combined with manual spot-checks to ensure accuracy. Please be sure your method respects any rate limits or anti-scraping measures built into the app. Acceptanc...
I need support with day-to-day data work: accurately entering information into Excel or Google Sheets, carrying out straightforward copy-paste assignments, and running quick ...short set of formatting rules. Your job is to populate the sheet, apply simple formulas where noted (think VLOOKUP, CONCAT, data validation), flag any ambiguities, and return the file on or before the deadline. Acceptance criteria • 100 % of requested rows completed • No spelling or numeric errors when cross-checked against the source • Columns match my template exactly, with consistent date and number formats • File delivered in XLSX and, if requested, a Google Sheets link Let me know how quickly you can process roughly 1 000 rows and point me to a similar project you&rsq...
Hello, I am looking for a professional data-visualisation specialist to convert approximately nine data tables into a range of clear, informative, and publication-quality charts. Each table is relatively small, generally around 5 columns × 6 rows or 4 columns × 4 rows. I would like different chart types to be selected based on the nature of each dataset, rather than using the same chart format throughout. The visualisations should clearly communicate the main findings, comparisons, trends, and relationships within the data. Key requirements: * Approximately nine tables to be visualised * Different and appropriate chart types for each dataset * Professional, informative, and explanatory presentation * Charts should not have a generic or AI-generated appearance ...
...precision matters more; anything that doesn’t align exactly to the template will be bounced back for correction. Maintain the original web order so I can cross-reference easily. Please mention any browser extensions or productivity tools you prefer for bulk copy-paste so I can make sure they align with our security policy. If you can start right away, let me know your realistic turnaround time per 500 rows and any questions you have about the workflow....
I have a handful of spreadsheets—fewer than one-hundred total rows—that need to be brought into my Zoho Books account. The files don’t share a common layout, so each sheet requires a quick review, light clean-up, and proper field mapping before upload. Three kinds of records are involved: Invoices, Contacts and Expenses. Once everything is imported I should be able to open Zoho Books and see each invoice matched to the correct contact, with the related expense coded to the right category. You’re free to use any combination of Zoho Books’ CSV template, manual entry, or the native import tool, as long as the end result is accurate and no duplicate contacts are created. A brief note describing the mapping you used will help me trace any issues later. De...
I already have a photo reference of my current Schedule of Rates and only need it replicated in Excel with professional, easy-to-read formatting. No data entry or formulas are required at this stage—your focus is purely on layout. Here is what I expect: • Structure the worksheet so that headings, sub-headings, and rate rows mirror the photo sample exactly. Create ever expanding list to populate for pricing and or schedule of rates. I may need these rates to feed into other tabs at a later date. - • Align and merge cells where it improves readability, but keep the sheet flexible for future edits. Deliverable: the finished .xlsx file styled precisely to the reference image, error-free and ready for me to populate with figures later. If you have any quick s...
Need a Python programmer to complete a project. Most of the program is already built. It needs to be completed and optimized to reduce the amount of errors spit out so it can be a repeatable process weekly. Some data is bad data in the database that needs to be cleaned. Attached is the functional Python script that creates 3 files: Rave ready rows Dupes that were eliminated Errors (e.g. signed up for a text message; no phone number) This is an HOA where owner’s register to access private documents. During registration they have the option to opt-in to receive emergency alerts through a company called Rave. The website exports all users and the respective data needed for Rave (See ). We need a program that can be run that will turn the data into the
...Spreadsheet — Fix and Full QA Brief What this job is This is a UK Excel workbook (11 tabs) sold as a standalone spreadsheet product on Etsy. It is not a companion to a separate workbook, so it must not reference one anywhere in the file. The buyer is typically someone acting as executor after a bereavement, often doing this for the first time and not confident with Excel. They will not manually resize rows or widen columns to see text that has been cut off. If a note, reference number, or date is not visible exactly as typed, they will assume it was not saved, which matters more here than it would in an ordinary spreadsheet. Fix and test with that person in mind, not just against the list below. Attached is a sample copy filled with a full fictional estate (dates, notes,...
Step by step guide for using MySQL database engine from Node.js