Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
I am looking for a signed and stamped Ohio Professional Engineer (PE) structural set for a temporary shade structure for a three-day event in Columbus, Ohio. This project requires a 24-hour turnaround. Project Details: - Structure: Fabric canopy (220 ft long x 24 ft wide) composed of several small triangles. - Support: Wire cables rigged between two rows of seven existing telephone poles, with shade material attached to the cables. - Requirements: Signed Ohio PE stamp demonstrating compliance with high-wind conditions and an action plan to evacuate the structure at 40 mph sustained winds. I will supply the preliminary drawings, as well as the connection and rigging details. Your role will be to review, refine where necessary, and seal the structural set to meet City of Co...
...officer name, email, and notes. Primary source material should come straight from each club’s own web page; if a club doesn’t publish addresses, you may cross-check LinkedIn or wider browser searches, but validated email addresses take priority because I need to avoid another high bounce rate. Where an address simply cannot be confirmed, the officer’s full name is still useful, yet please flag those rows so I can see at a glance which contacts lack emails. Key points • Keep the spreadsheet format exactly as it is now. • Include the names of new officers alongside any replaced emails. • Note your source in the “notes” column and mark unverifiable addresses clearly. • Aim for clean, deliverable-ready data by 30 September; ...
I have between 50 and 100 documents that contain a mix of text and numeric values. I will supply the...piece of information transferred into a single, well-structured Excel workbook. Your job is to: • copy the data from the documents into Excel, • clean and format each column so everything is consistently typed, capitalised and aligned, • insert basic formulas where totals or averages are required, and • rearrange rows or columns whenever it improves clarity. Accuracy is critical—every figure must match the source, and the sheet should be free of duplicates, blank rows and stray characters. The final workbook should be ready for analysis the moment I receive it. Please let me know your best price and how quickly you can turn the task aro...
...quotes it is a spring boot website with database. Here is what I expect: • A minimal but complete codebase that compiles and runs with a single `./mvnw spring-boot:run`. • All database connection details externalised in ``, ready for me to swap in my own credentials. • A SQL script (or Flyway/Liquibase migration) that creates the necessary schema and seeds a couple of sample rows so I can see data flowing end-to-end. • Simple HTML (Thymeleaf or similar) served from the backend—no heavy frontend build pipeline is needed. • Clear README instructions covering project structure, how to build, run, and import the database. I will test the result by running the project locally, connecting it to my own PostgreSQL instance, and browsing the p...
I have a series of web pages that contain data tables I need transferred into a single, well-structured Excel spreadsheet. The task is straightforward: open each page, capture every row and column exactly as it a...well-structured Excel spreadsheet. The task is straightforward: open each page, capture every row and column exactly as it appears, preserve the numerical formatting, and paste it into the workbook I’ll provide. No re-typing—just clean, precise copy-and-paste work that keeps headings, units, and any embedded hyperlinks intact. Accuracy is key. Before sending the finished file, please spot-check for missing rows, merged cells, or stray characters so the spreadsheet mirrors the online tables perfectly. The final deliverable is one Excel (.xlsx) file ready for...
I have roughly 2,000 ...name, amount + date, and the specific product details—and then place the results into a set of clearly labelled, separate sheets. Think of one tab for each natural grouping (e.g. vendor, month, or any other logic that keeps the data easy to scan); the final structure just needs to be intuitive and consistent. While you are transferring the data, please run a duplicate-entry check. If two or more rows carry the same vendor, date, amount and product combination, I want them flagged so I can decide what to keep. A simple “DUPLICATE” marker in an extra column is fine as long as it is obvious. I’ll supply the current Excel file and expect back an .xlsx workbook that opens with no errors, holds the categorised sheets, and highlights duplic...
...a deeper information experience covering: * Complete flight timeline * Airports / terminals * Layovers * Aircraft * Cabin * Fare * Baggage * Amenities * Seat information * Airline information * Booking information #Seat Map & Selection# Design an intuitive aircraft seat map with: * Available / occupied / selected seats * Cabin sections * Premium / extra-legroom seats * Window / aisle * Exit rows * Seat characteristics * Pricing * AI recommendations #Itinerary & Trip View# Design a clear trip experience including: * Trip overview * Flight timeline * Segments * Layovers * Airports * Booking information * Boarding passes * Travel documents * Visa/travel reminders * Notifications It should support both simple and complex multi-city journeys. #Airport Information# De...
I have an Excel workbook packed with text-only entries—names, addresses, and general descriptions—that now suffers from duplicate rows, uneven formatting, and the occasional spelling slip-up. I need the file returned in a polished state so it can feed directly into a mail-merge and reporting workflow without surprises. Here’s what I expect you to handle: • Removing duplicates across every column so each record appears only once • Correcting formatting issues such as stray spaces, inconsistent capitalization, or broken line breaks • Fixing spelling mistakes while leaving brand names and proper nouns intact Deliverable: the original workbook cleaned and saved in .xlsx format, plus an optional second sheet or change log highlighting what was mo...
...in transferring cell values, data alignment, and chart structure is essential. Your job is to recreate every page in two separate outputs: • a clean .docx that mirrors the original text, tables, and embedded charts, and • a well-structured .xlsx where each table is placed on its own sheet, ready for formulas or further analysis. The key success factors are: • Data integrity—no dropped rows, merged cells, or shifted figures • Consistent fonts and table styling close to the source so the documents remain reader-friendly • Charts reproduced so they can be edited natively in Word or Excel Please let me know how you plan to handle the tables and charts extraction and roughly how long you’ll need once you see a sample file. I&rsqu...
I have a collection of PDF and Word documents that need to be transformed into clean, well-organized spreadsheet records. The core of the job is straightforward copy-and-paste work: lift text exactly as it appears in each source file and place it into the correct rows and columns of either Excel or Google Sheets—whichever you prefer. Accuracy is everything here; typos or shifted columns create downstream problems for me, so I’ll be checking consistency in spelling, capitalization, and formatting. Speed also matters, but never at the expense of precision. A quick turnaround on each batch helps keep the wider project on schedule. Although light online look-ups may pop up from time to time, the overwhelming majority of your hours will be spent extracting text from exi...
I have a single Excel/CSV file (no more than 5,000 rows) containing sales figures that I need transformed into crisp, decision-ready insights. First, the dataset must be scrubbed—removing duplicates, resolving or imputing any missing values, and standardising basic formats—so the numbers tell an honest story from the start. Once the data is spotless, I want a short but thorough exploratory analysis that zeroes in on two angles: how performance varies across regions and what the figures reveal about each product category. I’m especially interested in discovering any high-performing pockets or lagging segments that a quick glance might overlook. For visual storytelling, I prefer bar charts and would like up to five of them: each one should highlight a key findi...
I have several Excel workbooks that contain customer records and I’ve noticed the same phone numbers appearing more than once. Your task is straightforward: scan every sheet, spot rows that share an identical phone number, and give me back a version of each file where those duplicates are either eliminated or clearly flagged on a separate tab—whichever you find cleaner to implement. I do not need help with missing values or formatting issues right now; the focus is solely on duplicate detection. Excel-native solutions such as advanced filters, Power Query, or a short VBA routine are all acceptable, as long as the final files open without macros blocked warnings and every surviving record is unique by phone number. Please provide the cleaned Excel files plus a brief sum...
...out precisely—every name and address it contains, plus any full text paragraphs. Once captured, place the data into Excel or Google Sheets so that each document’s details stay together, meaning the file ends up neatly grouped by document type rather than split across columns. Accuracy matters more than speed. Before handing the file back, double-check your work for omissions, spelling slips, or rows that drift out of place. In your offer, tell me about earlier image-to-spreadsheet projects you’ve handled and quote the total price you expect for this batch. Deliverables • A clean spreadsheet (Excel or Sheets) grouped by document type, fully populated with names, addresses, and paragraph text. • A short note flagging any sections of an image that w...
I need a production-ready solution to integrate the official WhatsApp Business API with Excel for Phase 1. Key functionalities: 1. Excel Integration: Automate sending messages based on data rows containing customer numbers and dynamic fields. 2. Message Templates: Support pre-approved templates for bills and promotions with fields auto-populated from Excel. 3. Attachments & Links: Attach PDFs (for billing) or banners (for promotions) and include clickable links. 4. Error Handling & Logs: Real-time error handling, delivery status logs, and exportable records back into Excel. 5. Ease of Setup: Provide a simple setup with step-by-step documentation for my team. Phase 2 will include advanced features like receiving inputs via WhatsApp (e.g., customer requests) to update Excel ...
I need several PDFs and scanned handwritten pages transferred into a single Excel workbook. The source material is a real mix—tables beside blocks of text, short bullet lists, and the occasional note scribbled in the margin—so your approach will probably combine OCR with careful manual proofing. I’m not asking for elaborate formatting; standard rows and columns are fine as long as every piece of information from the originals is captured accurately and placed logically. You’re free to decide how many worksheets to use, but the data from each PDF or handwritten page should be easy to trace back if I ever need to reference the source. Accuracy is the priority: spelling, numbers, and line breaks must match what’s on the page. When you’re finished, s...
I have a set of raw information that must be transferred into a neatly organised Excel spreadsheet. Your role is purely data entry: copy the figures, text, and any other details I supply and position them in the exact columns and rows I specify, applying consistent formatting along the way. Accuracy is the priority. I will spot-check the finished file, so every value should match the original source without typos, skipped lines, or misplaced decimals. Basic Excel tools such as Find & Replace, Data Validation, and simple formulas are welcome if they help keep the sheet tidy and error-free. Deliverables • One fully populated, well-formatted Excel workbook • All required fields completed and aligned with my heading structure • Turnaround time: 7 days from proje...
I have an inventory spreadsheet in Excel that’s getting hard to read at a glance because every new entry lands wherever it pleases. What I need is a clean, repeatable way to reorder all rows strictly by the Quantity column, lowest-to-highest (or highest-to-lowest if that proves more practical). The file is under 5,000 rows, uses standard .xlsx formatting, and has no macros at the moment. The job is straightforward: • Open the sheet in Excel (Office 365). • Apply an accurate numerical sort on the entire dataset so each product line keeps its details intact. • Double-check that no values shift out of alignment during the process. Once done, send back the updated .xlsx plus a short note on the exact steps you followed so I can repeat them on future u...
...well-structured spreadsheets. The work is straightforward but must be handled with absolute accuracy, consistent formatting, and careful attention to detail. You will receive source files in mixed formats (PDF scans and Word documents) along with clear column headers; your job is to enter every record into Excel exactly as shown, double-checking for typos or misplaced values as you go. Every few hundred rows I would like a quick spot-check summary, and—once the full sheet is complete—a brief visual overview prepared in Microsoft PowerPoint, as that is my preferred presentation tool. The deck only needs one title slide plus 3-4 simple charts generated from the newly entered data, so familiarity with Excel-to-PowerPoint chart linking will be helpful. Deliverables &bul...
...ready for analysis or upload to our internal tools. Accuracy and consistency matter more to me than speed, but prompt delivery is still important because the information feeds directly into daily reports. Here is what you can expect once we start: I will share a sample data set plus clear formatting rules. You process it, return the finished file, and if everything matches the rules (no missing rows, correct column order, validated totals), we move on to the next batch. I handle quality checks within 24 hours and give feedback right away so you always know where you stand. Please be comfortable with Excel functions such as VLOOKUP/XLOOKUP, pivot tables, text-to-columns, and basic data validation. If you also know a bit of SQL or Google Sheets that is a bonus, but not required&m...
...instructions for the target entry screens plus a sample completed record. Deliverables: • All revenue lines entered in the platform, preserving original formatting and descriptions. • A completion log noting any anomalies you spot (duplicate entries, missing periods, unusual values). • Final confirmation that platform totals match the source spreadsheet totals. Acceptance criteria: 1. 100 % of rows entered and verified. 2. No transcription errors when I run the reconciliation check. 3. Work delivered by the mutually agreed deadline. Familiarity with Excel data filters, quick keyboard shortcuts, and double-entry or cross-check techniques will make this job straightforward. Let me know your availability and the volume you can handle each day so we can get ...
...clean any obvious formatting issues, and upload the data through phpMyAdmin or a command-line import—whichever you’re most comfortable with—as long as referential integrity is maintained. I will supply: • The database schema with field definitions and constraints • Source files organised by table • Clear mapping notes showing which column each text element belongs to What I expect back: • All rows entered without duplication • Primary and foreign keys respected • A brief log of any anomalies you encounter and how you resolved them • A final SQL dump so I can verify the new state of the database on my end If you’re experienced with MySQL imports, character-set handling, and quick spot checks for data cleanline...
I have a collection of scanned documents ...validation rules already in place. Your job is simply to read each scan, key the information into the correct cells, double-check for typos, and flag anything that looks unclear or illegible. Deliverables: • A fully populated spreadsheet for each batch, matching the provided template • A short “issues” tab that lists any entries you could not verify from the scans Acceptance criteria: • 100 % of rows completed; all mandatory columns filled • No transcription errors when spot-checked against the original scans • Spreadsheet passes built-in validation rules without warnings If you are meticulous, comfortable working in Sheets/Excel, and can start right away, I’d love to hear how quickly...
...possible on the attached reference photo. I want the overall shape, proportions, layered appearance, and diamond placement to closely replicate the reference. The ring should be 10K yellow gold, ring size 6.25, with a wide, substantial masculine profile. The face should have the same four-row graduated diamond design shown in the reference. The two center rows should form the larger/heavier diamond section, while the top and bottom outer rows should contain smaller round diamonds. Please maintain the visible yellow-gold borders/separators between the diamond sections as shown in the reference. I want the diamond sizes, spacing, alignment, and overall proportions to resemble the reference as closely as possible. IMPORTANT DESIGN CHANGE: The diamond design should NOT go a...
...records from our Winomkar Excel workbooks, processes them, and returns clean, ready-to-use sheets without any manual touch-ups. The script (whether built in Python, VBA, Power Query, or another reliable tool you prefer) must open the source files, carry out the required data operations, and then save or export refreshed results in the same folder structure. Please make sure the automation: • Sorts rows according to the parameters I can define at run time • Filters data on multiple columns with dynamic criteria • Performs built-in or custom calculations as specified in a config section • Copies results to designated summary sheets • Validates every entry against simple rules I will provide (e.g., mandatory fields, data type checks) • Gener...
... Watch YouTube videos for correct form. - *Rest is Important:* Muscle grows when you rest, not when you train. Sleep 7-8 hours. - *Don't Skip Warm-up:* 5 minutes walking or jumping jacks before training. - *Progress Slowly:* If 10 squats become easy, do 12. Then add 2kg dumbbell. *3. Simple Weekly Plan* *Day 1 - Lower Body:* Squats, Lunges, Glute Bridge *Day 2 - Upper Body:* Push-ups, Dumbbell Rows, Shoulder Press *Day 3 - Full Body:* Squats, Push-ups, Plank, Deadlift with light weight *4. Diet for Strength* - Eat protein: Eggs, Chicken, Dal, Paneer, Soya chunks - Drink 3 liters of water - Avoid junk food and cold drinks *Conclusion* Don't compare yourself with others in the gym. Everyone started as a beginner. Be consistent for 30 days and you will see the change. ...
I keep a growing list of clients and need every record kept accurate and tidy in a single Excel workbook. You will manually browse the specified website, copy each client’s ...link, the template Excel file, and a short set of naming conventions so everything stays uniform. As new names appear online, you will add them; if any entry changes, you will update it rather than duplicating. Deliverables • Updated Excel workbook containing every client number and complete contact details, checked for duplicates • A brief change log (date, rows added/edited) for transparency I’ll review the first 20 rows as a milestone to be sure the format is correct; once approved, you can proceed with the rest. Consistent formatting, zero typos, and no missing fields...
...data. Accuracy is critical. Every value must match the source sheet character-for-character, including punctuation, spacing, and capitalization. I will spot-check entries directly against the original files before marking the job complete. Please be comfortable navigating both Excel and web forms, able to keep a steady pace while maintaining 100 % precision. Let me know your estimated throughput (rows per hour) and any previous experience handling similar simple copy-paste projects....
...point out which ones after we start—so please copy those and ignore the rest. The finished workbook should let me filter or sort on date, amount, description, and the preserved category column without breaking any formulas. Deliverable: • One clean Excel file containing all three statements merged into a single, chronologically ordered sheet with the specified categories intact and no duplicate rows....
I need hel...everything in Google Sheets, you must be comfortable working there: importing data, using SUM, IF, and simple percentage calculations, and creating filters so I can quickly drill down by project or cost category. Consistent formatting is important; currency should display in USD with two decimals, and dates should follow the YYYY-MM-DD format. Before we wrap up I’ll review the file for accuracy. Rows that don’t match the source figures, missing labels, or broken formulas will need correction. When everything reconciles, please share the final sheet back to me with editing rights removed and a view-only link enabled for my stakeholders. If this sounds straightforward to you and you have an eye for detail, let’s get started—my source files are re...
I’m refining an existing Shopify store and need an expert in Liquid, HTML and modern CSS to reshape its visual flow. The priority is design-focused: specifically, layout adjustments that lift conversion potential without rebuilding the entire theme. Scope • Homepage: reorder sections, refine spacing, typography and imagery so the hero, collection rows and trust badges guide visitors naturally toward products and calls-to-action. • Navigation menu: streamline the top bar, optimise dropdown behaviour and ensure a clean, mobile-first experience. I’ll supply theme access, current style guidelines and reference stores that capture the look and feel I’m after. Please work in a development theme so I can preview changes before publishing. Acceptance &bu...
...formatting, and a touch of basic cleaning (removing extra spaces or obvious duplicates as you go). I’ll send the source documents in PDF and Word right after we kick things off and will verify each batch daily so you get prompt feedback and milestone releases. When you respond, please highlight your experience with similar manual Excel data-entry projects and, if possible, let me know your usual rows-per-hour pace so we can lock down a realistic timeline....
I have a PDF that holds a little over two-hundred rows of mixed letters and numbers—think product codes, IDs, brief labels—that all need to live in a clean, well-structured Excel workbook. Your job is to lift every character exactly as it appears, place each field in its correct column, and keep the original ordering intact. The PDF is not a scan with fuzzy text; it is a digital file, so copy-and-paste or a reliable PDF-to-Excel tool such as Adobe Acrobat, Able2Extract, or even Power Query should work. Whichever method you prefer is fine as long as the final sheet is accurate and uniformly formatted—no merged cells, stray spaces, or wrapped lines that break the flow. Once finished, return an .xlsx file that I can open in Excel 2019 without prompts or compatib...
...customer privacy and ensures compliance with applicable data-protection and KYC requirements. Project Requirement: Total requirement: 400–500 qualified leads Geography: Pan India Submission: Daily Excel file Project Budget/Payout: ₹12,000–₹15,000, subject to lead quality and mutually agreed terms. Payment structure can be finalized based on accepted/qualified leads, rather than simply the number of rows submitted. I need a steady stream of 400–500 fresh, qualified personal-loan prospects and I’m focusing on borrowers in India’s tier-2 cities. Every contact you supply must be: • Employed with a demonstrably stable income • Carrying a good credit score (ideally 700+ or the local bureau’s equivalent) • Located in a tier-2 ci...
...feed our map and the hours will appear on the store profile pages. Deliverables: • One spreadsheet (Excel or Google Sheets) containing: – Store name – Street address (with city, state, postcode) – Opening hours in a clear format (e.g., “Mon-Fri 9 am-6 pm”) – Longitude and latitude in separate columns I will provide the current sheet template; you only need to append the missing rows. Feel free to use Python, BeautifulSoup, Selenium, or any other scraping stack you prefer—just make sure the final data is complete and consistent. Before handing over the file, please do a quick sanity check (spot-check at least 10 random locations) to confirm that the map pins line up correctly on Google Maps. ...
...pull balances, transaction totals, and KPI metrics; about 300 rows (five columns each) must be keyed in with two-decimal accuracy, standard thousand separators, and dates in YYYY-MM-DD format. You’ll receive login credentials and my template. No formulas are required—this is pure data entry—but consistency and an eye for outliers are crucial. Work is ongoing: the first catch-up batch (three months of history) should be completed within 48 hours, after which we can settle into a daily update rhythm. Deliverables • Updated Excel file containing every provided record • Quick spot-check report flagging any missing or out-of-range values • One-paragraph summary of issues or notable trends Acceptance criteria: 100 % of rows present...
I have a colle...text and numbers—that must be captured accurately in Excel. Your job is straightforward data entry with no additional analysis or visualization required. Here’s what I need from you: • Transfer all records into an Excel or Google Sheets file. • Format the spreadsheet so every entry sits in the correct column and the entire sheet is organised by category. • Identify and remove any duplicate rows. • Double-check spelling, figures, and overall consistency so I receive an error-free file. • Return the completed, neatly formatted workbook by the deadline we agree on. Proficiency with MS Excel, Google Sheets, and general data-entry best practices is essential. If you’re detail-oriented and can turn this around quick...
I have an existing Excel-based form that needs to run itself instead of relying on manual copy-and-paste. The form captures three kinds of input—free-text notes, numeric values (including dates or currency), and predefined multiple-choice selections—and all of them must be va...the flow is seamless: enter data → click submit → record lands in the database with zero pop-ups or security warnings. Deliverables • The updated Excel file with all code unlocked and documented. • A connection script or DSN instructions for the database hand-off. • A short read-me that shows how to add new validation rules or table columns in the future. I’ll test by entering sample rows; success means every field is validated correctly and the informati...
...sheet, such as industry, head-office location, and staff size The sheet is ready for you to work in place, so there is no need to find profiles yourself—simply enrich what is already listed. Accuracy matters more than speed; dates should match what appears on LinkedIn, and company details should come from the company page or a reliable public source. I will spot-check records after the first 50 rows. If everything lines up, you can proceed with the rest uninterrupted. Please let me know what tools or extensions you normally use for LinkedIn data so I can confirm they comply with LinkedIn’s terms before we start. You will be using your own tools and linkedin accounts if required....
I have a collection of text-based records that need to be typed accurately into an Excel spreadsheet. Everything will be provided in clearly labelled source documents; your role is to enter each line exactly as written, keep the co...before saving. I’m concentrating on manual data entry because I want a human eye on every detail rather than an automated import. Consistency in spacing, capitalization, and basic formatting is important, but no complex formulas or analysis are required—just clean, error-free text in the right cells. When the file is complete, return the finished workbook plus a brief note confirming the number of rows you entered and any obvious issues you spotted along the way. That’s all there is to it, and if we work well together, I’ll hav...
...as it appears, and place it into a single, clean master file that I will supply. Because these are budget reports, totals must reconcile once your entry is complete; I will be cross-checking formulas, so attention to detail is critical. No formatting surprises—I want consistent column order, date formats, and currency symbols throughout. Deliverable acceptance will be based on: • 100 % of rows present with no transcription errors • Column headings and cell formats matching the template I provide • Final file returned in .xlsx and delivered within the agreed timeline If you are comfortable working solely from Excel sheets and confident you can preserve the integrity of sensitive financial data, I’d like to hear how soon you can start and y...
...as it appears, and place it into a single, clean master file that I will supply. Because these are budget reports, totals must reconcile once your entry is complete; I will be cross-checking formulas, so attention to detail is critical. No formatting surprises—I want consistent column order, date formats, and currency symbols throughout. Deliverable acceptance will be based on: • 100 % of rows present with no transcription errors • Column headings and cell formats matching the template I provide • Final file returned in .xlsx and delivered within the agreed timeline If you are comfortable working solely from Excel sheets and confident you can preserve the integrity of sensitive financial data, I’d like to hear how soon you can start and y...
I have several bank statements saved as PDFs where each transaction is prese...and the built-in sqlite3 module would suit me perfectly, though I’m open to another stack if you clearly outline the advantages. Deliverables • Well-documented source code for the parser • SQLite schema (single table is fine) and a sample database produced from one of my PDFs • Simple run instructions so I can feed in new statements whenever I need • A brief log or report highlighting any rows that could not be parsed cleanly or looked suspicious If you can build in light data cleaning—trimming whitespace, removing duplicates, flagging malformed dates—that will be a plus. Let me know your expected timeframe and a short outline of how you plan to tackle the e...
I have between one and five PDF files that contain purely numerical data laid out in complex, nested table structures. I need every figure lifted out of those PDFs and placed into an Excel workbook so the spreadsheet mirrors the original hierarchy—parent rows, indented subtotals, and any multi-level groupings must stay intact. Accuracy is everything: each value should land in the correct row and column, with no dropped decimals or shifted totals. If you prefer using automated tools such as Python-pdfplumber, Camelot, Tabula, or Adobe Acrobat batch scripts, that’s fine, but manual checks are mandatory to guarantee the final sheet reconciles perfectly with the source. Deliverables • One Excel file per PDF (or a single multi-sheet workbook if that’s cleaner) ...
...without wrestling with odd formatting. What has to come across • All tables exactly as they appear in the PDFs, each on its own sheet or clearly separated in one sheet. • All narrative paragraphs and list items placed logically—one sentence or list point per cell works well—so nothing ends up merged or hidden. Formatting expectations Standard Excel formatting is all I’m after: clear rows and columns, default fonts, and numeric values preserved as numbers. No need to replicate fonts, colours, or layout quirks from the original PDF. Accuracy and clean structure matter far more than cosmetic fidelity. Tools are up to you—whether you lean on Adobe Acrobat, OCR utilities, Power Query, or a custom script—as long as the final .xlsx ...
I have a collection of PDF d...double-checked for spelling, punctuation, and consistent capitalization. No automated scraping or OCR shortcuts here; careful copy-paste and visual verification are essential. Deliverable • A fully populated spreadsheet that mirrors the field order in the template • Zero empty cells where information exists in the source • Uniform formatting (dates, phone numbers, currency) exactly as shown in sample rows I’ll share I will supply: 1. A folder of PDFs (typically 2–4 pages each) 2. The blank template and a style guide for data formats 3. A short checklist for your own QA before you send the file back Please include a brief note on your turnaround time per 100 PDFs and any past projects that prove you can keep err...
...“FinalVersionCleardyneSubtotaledSpreadsheet.” I need it reorganised so the rows are first sorted by the “code” column and then subtotalled under each code category exactly the way it appears in my reference file, “Example of Subtotals.” After the last code block, insert one final line that shows the combined net total of all deposits and withdrawals (no separate columns for each—just the single figure). Please keep the subtotals directly beneath each code group, match the formatting style you see in the sample workbook "Example of Subtotals", and leave every other column and formula intact. When you’re done, send back the updated workbook; no extra sheets or summaries are required. Deliverables • Updated Excel wor...
I have several Excel sheets that track investment-return figures and I need every line copied into a clean, consolidated master file. All source material is already typed, so you...clean, consolidated master file. All source material is already typed, so you will not be deciphering handwriting—just transferring figures with perfect accuracy. Your job is straightforward: • Open each provided workbook. • Verify totals and date formats match the original. • Enter the data into the template I supply, keeping column order and decimal precision intact. I will spot-check random rows against the originals; any mismatch beyond 0.1 % will be sent back for correction. The finished spreadsheet should be ready for pivot-table analysis with no blank cells, formula error...
I need help bringing an existing financial spreadsheet fully up to date. All raw figures are ready, but I’m short on time to transfer everything accurately. Your task is to enter the new financial data into the correct rows and columns, double-check totals against the source figures, adjust or insert formulas where needed, and leave clear notes for any anomalies you spot. The file is in Excel, so please be comfortable with basic functions such as SUM, IF and simple percentage calculations; no complex macro work is required. Once finished, I’d like the workbook returned error-free, neatly formatted, and ready for internal reporting.
...thousand individual lines. Each line has up to six text fields that must be typed exactly as written and placed in the correct column. Because the material includes abbreviations, mixed languages, and occasional special characters, absolute accuracy is critical; a single typo can change the meaning. Deliverables • A single Excel workbook (or shared Google Sheet) containing all records, with header rows and cell formats already applied. • A brief change log noting any illegible entries you flagged and the decisions we made to resolve them. Acceptance Criteria • 99.9 % character-level accuracy verified by random spot checks. • Uniform date, number, and text casing across every sheet. • Completion within the mutually agreed deadline. If you type qui...
I have three CSV files, 50,000 rows each, that must be turned into unique, GS1-compliant 2D Datamatrix codes and then flowed onto A3 sticker sheets that my printer will supply. Once I send you that layout template, every page should hold a tightly aligned matrix of codes, with the first-to-last code number clearly printed in the header so we can identify the contents at a glance. You will need to: • Generate the 150,000 GS1 2D Datamatrix symbols directly from the CSV data, keeping checksum and application identifiers intact. • Place them into the provided A3 template so the spacing matches the die-cut sticker grid. • Output press-ready, high-resolution PDFs (one per sheet) that my printer can send straight to plate without further tweaks. I will review a small...
Step by step guide for using MySQL database engine from Node.js