Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
I have several worksheets that contain related records spread across different columns and rows. I need one streamlined Excel file where those pieces are automatically brought together in the right order, without losing any existing formulas. Here is what I’m after: • Combine specific columns or rows from the current sheets into a single, tidy table. • Keep the data dynamically linked so that any update in the source instantly reflects in the consolidated view. • Where a straightforward link isn’t possible, set up the most efficient lookup formula—XLOOKUP or VLOOKUP should do the trick—to pull the right value. The finished workbook must remain fully editable; no macros are required for now. Clean structure, clear cell references,...
I’m building a fresh prospect list and need someone who can automatically pull contact information from a set of business websites I’ll supply. The goal is simple: turn each URL into clean, usable lea...being captured correctly. Deliverables • A working script (with clear setup notes) or a lightweight app that runs on Windows or Linux. • CSV or Excel file containing the scraped contacts, one row per business. • Brief README explaining how to add more sites or tweak the selectors. Acceptance criteria • At least 95 % of the supplied pages return the requested fields. • No duplicate rows. • Emails and phone numbers validated to standard formats. If this sounds straightforward to you, let me know your preferred tools and a r...
...into one well-organized Excel workbook. Each PDF follows the same layout, and I want every sheet copied exactly—both the narrative text and the numerical data—onto its own tab named after the original file. Here is what the job involves: • Download all fourteen PDFs directly from the government site I will share. • Extract every piece of text and every number into Excel, preserving columns, rows, and any simple formatting that appears in the source. • Create a separate tab for each file, using the file’s name as the tab title. • Double-check that totals and subtotals match the PDFs; if a page refuses to download cleanly, type the figures in manually so the spreadsheet remains complete. • Deliver one clean .xlsx file ready for ...
I need a PDF document where both rows and columns are misaligned. Requirements: - Align rows and columns as needed - Replace one small image - Open to feedback during the process Ideal skills and experience: - Proficiency in PDF editing tools - Attention to detail - Ability to follow feedback and make adjustments
I have several online databases that contain English-language text which must be transferred, word-for-word, into a structured spreadsheet. The job is strictly manual: no scraping utilities or automated tools—just careful copy-and-paste with constant visual checks for accuracy. Scope of work • Navigate the URLs I pro...assigned records are present, with no omissions or duplication. • Each row passes a quick spot-audit of five random entries without error. • Final spreadsheet opens in Microsoft Excel and Google Sheets without broken characters. Deliverable: one completed .xlsx file returned by the mutually agreed deadline. I’m available throughout the project for clarification and will review your first few rows immediately to confirm formatting be...
The task is straightforward: transfer information contained in several digital files—mostly Word documents and a few existing Excel sheets—into one consolidated Excel workbook that I will share at the start of the project. All data must appear exactly as in the source fil...sharp eye for detail are enough. Deliverable • A fully populated Excel spreadsheet, saved in .xlsx format, mirroring every entry from the supplied digital files. Acceptance criteria • 100 % field-to-field accuracy (spot checks will be performed). • Consistent text case and numeric formatting exactly as provided. • No blank rows, merged cells, or hidden characters. Once you finish, send back the updated workbook and a quick confirmation of the total rows added so I...
I’m just getting started with Excel and would like someone to walk me through setting up and troubleshooting simple formulas. The focus is strictly on mathematical calculations—nothing advanced, just core arithmetic functions such as SUM, AVERAGE, MIN, MAX and similar operations across rows, columns, and filtered ranges. What I need from you • A short video call or screen-share session (Zoom, Meet, or Teams—whatever suits you) where you demonstrate the steps live and answer my questions. • A clean sample worksheet that shows each formula in action so I can reverse-engineer it later. • A brief written recap highlighting the exact cell references and any common pitfalls you think a beginner should avoid. I don’t require data entry or deep...
HOTEL DATABASE RESEARCH Budget: $300 | 7 Days | Target: ~1,300 hotels FILES: I provide with 649 luxury hotels pre-filled (name, city, country, brand, descriptions). You return it completed with ~650 new rows added and all URL columns filled in. TASK 1 — ADD MICHELIN KEY HOTELS Go to → Hotels → Browse by country. Extract: ALL Three Key hotels globally (~143) ALL Two Key hotels globally (~572) Skip One Key entirely. Before adding any row, check if it already exists. If yes, just fill in Michelin Key Tier + URLs. If no, add full row. For each new hotel fill all 22 columns including all 8 URLs before moving to the next hotel. TASK 2 — FIND URLs ON 8 PLATFORMS For every hotel in the file (existing + new) find the hotel page
The task is straightforward: transfer information contained in several digital files—mostly Word documents and a few existing Excel sheets—into one consolidated Excel workbook that I will share at the start of the project. All data must appear exactly as in the source fil...sharp eye for detail are enough. Deliverable • A fully populated Excel spreadsheet, saved in .xlsx format, mirroring every entry from the supplied digital files. Acceptance criteria • 100 % field-to-field accuracy (spot checks will be performed). • Consistent text case and numeric formatting exactly as provided. • No blank rows, merged cells, or hidden characters. Once you finish, send back the updated workbook and a quick confirmation of the total rows added so I...
Scope of Work: 1. Clean Up Existing File * Review current Excel tracker (inventory + profit tracking) * Remove duplicate / unnecessary columns * Standardize formulas across all rows * Fix inconsistencies and errors ⸻ 2. Clean Up Historical Data (Important) * Review and correct existing transactions * Ensure past entries are consistent and usable * Fix or flag: * Missing data * Incorrect formulas * Misclassified expenses or sales * Help bring the file to a “clean baseline” I can trust going forward ⸻ 3. Profit & Revenue Accuracy * Validate and correct all profit calculations * Ensure accurate handling of: * Purchase price * Platform fees * Shipping costs * Taxes (if applicable) * Remove any need for manual calculations ⸻ 4. Invent...
...Review the flagged outputs of my script - these are rows that definitely need attention and fixing. 2. Check that team names, divisions, stages, roles are consistently named throughout the workbooks 3. Correct other data entry mistakes like typos, misplaced figures, incorrect totals, etc. More details about the data - Refer to the sample Match Results, Person Stats, and Standings files (which need to be reviewed) as well as the source files (source of ground truth) - There are around 40-50 franchise (ie. sports teams) files that serve as the source of person stats, which will need to be referenced occasionally for certain errors - Total data to be reviewed spans 5 tournaments Deliverables - Validated Excel files ready for analysis - Flagged rows that were unable to be re...
Our nightly Databricks notebook that ingests structured data from Azure Data Lake has crept from a consistent 3-hour f...partitioning strategy, file format selection, caching, Delta Lake optimisation, cluster sizing, Auto Loader configuration—whatever combination gets us there is fair game as long as it remains maintainable and cost-conscious on Azure. Deliverables • Revised notebook (or modular scripts) with all performance-related changes clearly commented • Brief before-and-after report showing key metrics: input rows per second, stage/task durations, and total runtime • Short hand-off note outlining any cluster-level settings or schedule tweaks applied Acceptance criterion: a full test run on my workspace that completes in ≤ 3 hours while prod...
...listings or location-based search in Brilliant Directories? Have you handled CSV imports into Brilliant Directories? Have you configured claim listings, paid tiers, featured listings or sponsored placements? Have you customised BD design using settings/light CSS without heavy widget edits? How would you approach one business listing serving multiple suburbs or regions without creating duplicate result rows? Please do not apply if you have not worked directly with Brilliant Directories before. I am looking for a BD specialist, not a general web developer who is willing to learn the platform during the project....
...a similar library is perfect, provided it respects the site’s and rate limits so we avoid any blocking. I’m happy to receive the script alongside the spreadsheet so the data can be refreshed later, but the primary deliverable is the finished Excel file. Accuracy matters more than speed: the list should be as comprehensive as the source allows, free of broken characters or half-filled rows. If certain specialties or names appear more than once, include them only once unless the website explicitly distinguishes multiple practices. Let me know your estimated turnaround and any clarifying questions, and we can get started right away....
I am assembling a master database of 100,000 fresh, accurate B2B contacts from companies whose corporate emai...Corporate email address (no Gmail, Outlook etc.) 6. Country 7. Optional but appreciated: direct phone and LinkedIn URL 8. Proof of Ionos / 1&1 hosting (e.g., captured MX record or ISP flag) Quality expectations • 100 % unique records—no duplicates. • Hard-bounced emails under 2 %. • All entries supplied in CSV or Excel with UTF-8 encoding. Acceptance criteria – Minimum 100,000 rows that meet all “Required data columns”. – Random sample of 1,000 records must pass ZeroBounce or NeverBounce at 98 %+ validity before final hand-off. Timeline is flexible, yet let me know how long you need for collection and ...
...file and insert or update records across the relevant tables—items, locations, and stock levels—according to our existing schema. Because a single row affects multiple tables, I need custom mapping logic rather than a one-table bulk insert. Duplicate keys, missing required columns, or invalid data types should be flagged and summarized to the user in a simple report before any commit occurs; valid rows proceed, invalid ones are skipped. Tech Stack The project runs on PHP 8.1 with PDO, MySQL 5.7, and a small MVC framework I wrote myself. Keep dependencies minimal—Pure PHP or well-maintained Composer packages only. Deliverables • PHP controller, model, and view updates for “Export” and “Import” • Reusable helper class for ...
I need a lightweight Excel + Power BI build that lets me plan every internal audit and then watch the schedule come alive in a clear Gan...3. A short hand-off note or video showing how to add new audits, staff or milestones without breaking formulas or visuals. Acceptance criteria • Adding an audit in the Audit Plan instantly extends the Gantt with correct phase lengths. • Governance milestone conflicts appear clearly when an audit overlaps one of the four dates. • No hard-coded ranges; solution works if I insert additional rows or new staff. • Report refresh completes without errors from a single “Refresh” action in Power BI. Please send a detailed project proposal outlining your approach, the key formulas or DAX tricks you plan to use, and...
...working Google Sheet that needs a tidy upgrade. The core of the job is to insert and verify a series of basic formulas—mainly SUM, AVERAGE and a few similar functions—so every total and summary figure updates accurately without manual checks. Alongside that, I want a lightweight Apps Script to automate the repetitive touches I still handle by hand: clearing or copying ranges, time-stamping new rows, maybe firing a daily refresh. Nothing heavy or enterprise-grade, just clean, dependable code that sits in the Sheet and runs silently in the background. Here’s how we’ll work: • You review the current file (view-only link provided once we start) and map out where the formulas should live. • You write or correct the formulas, test them with sam...
...around a Chipone IC and I need a complete circuit developed for it. The goal is very clear: the board must display still images, videos cleanly and reliably on an 80 × 40 pixel matrix, even when it is mounted in demanding outdoor installations. Key points you should know • Functionality: image display only, no scrolling text or animated graphics at this stage. • Pixel matrix: 80 columns by 40 rows (a custom resolution that sits between the usual 64 × 64 and 128 × 128 panels). • Environment: the board will live in high-humidity, high-temperature and dusty locations, so component selection, conformal-coating recommendations and connector placement must respect that. • Core driver: Chipone IC family (please specify the exact part you pr...
...Google Sheet (or Excel if you prefer), double-check for typos, and hand the file back to me before Monday morning. I’ll supply a ready-made template so you always know where each value belongs. Consistency counts; the column order, date formats and any currency symbols must match the template exactly so my downstream reports don’t break. A quick spot-check for obvious anomalies (totals, missing rows, misaligned names) is part of the task. Turnaround: once a week, same schedule, ongoing for as long as the quality stays high. If you use tools like Adobe Acrobat, OCR, or data-scraping utilities to speed things up, that’s fine—just keep the final sheet 100 % editable and free of hidden characters. Deliverable every cycle: the updated spreadsheet, error rate...
...containing only tables and grids have to be turned into a clean, fully-editable Excel workbook. I want every table recreated so that the row-column structure matches the source exactly, but with customized formatting that improves readability rather than simply duplicating the PDF’s appearance. After conversion, the spreadsheet should: • keep numerical data as numbers, not text • preserve all header rows and sub-totals in their correct positions • apply my preferred formatting once I supply the style guide (colours, widths, alignment, or any conditional rules we agree on) Accuracy matters more than speed, so automated copy-paste that breaks merged cells or misplaces decimals is not acceptable. I will provide the PDFs and confirm the formatting rules before ...
...containing only tables and grids have to be turned into a clean, fully-editable Excel workbook. I want every table recreated so that the row-column structure matches the source exactly, but with customized formatting that improves readability rather than simply duplicating the PDF’s appearance. After conversion, the spreadsheet should: • keep numerical data as numbers, not text • preserve all header rows and sub-totals in their correct positions • apply my preferred formatting once I supply the style guide (colours, widths, alignment, or any conditional rules we agree on) Accuracy matters more than speed, so automated copy-paste that breaks merged cells or misplaces decimals is not acceptable. I will provide the PDFs and confirm the formatting rules before ...
...containing only tables and grids have to be turned into a clean, fully-editable Excel workbook. I want every table recreated so that the row-column structure matches the source exactly, but with customized formatting that improves readability rather than simply duplicating the PDF’s appearance. After conversion, the spreadsheet should: • keep numerical data as numbers, not text • preserve all header rows and sub-totals in their correct positions • apply my preferred formatting once I supply the style guide (colours, widths, alignment, or any conditional rules we agree on) Accuracy matters more than speed, so automated copy-paste that breaks merged cells or misplaces decimals is not acceptable. I will provide the PDFs and confirm the formatting rules before ...
...analytical queries; PostgreSQL with time-series extensions, or a comparable solution, is acceptable. Stream processing via Node.js, Python (FastAPI, Django Channels), or another well-supported stack should calculate aggregates, outliers, and rolling KPIs in real time. Analytics Engine Real-time analytics is mandatory. I expect sub-second latency on dashboards for datasets in the low millions of rows. The engine must support ad-hoc filters (date range, customer segment, product line) and produce downloadable summaries (CSV or PDF). Security & Deployment Role-based access control, token-based authentication, and basic audit logging need to be in place. The finished app should run in Docker containers so I can deploy to AWS or Azure with minimal tweaks. Deliverables &bu...
I maintain a master Excel workbook that tracks our daily sales figures. Each day I will forward you a simple data sheet (CSV or PDF) containing the latest numerical totals. Your job is to transpose those numbers into the correct rows and columns of my existing spreadsheet, double-check for input errors, and save the file in the same format so it is ready for my morning review. Because the figures drive automated formulas and pivot tables, absolute accuracy is critical; a single misplaced digit will throw off the dashboards we rely on. After you finish each update, a quick glance over the calculated summaries should confirm everything reconciles before you mark the task complete. Daily turnaround is essential. I typically send the source file by 6 p.m. my time and need the updated ...
I’m putting together a multi-camera team for an upcoming live concert and need an operator whose specialty is tight, expressive close-ups of the performers. This is an event shoot inside a medium-sized music venue, so you’ll be working in a fast-paced, ever-changing lighting environment where quick thinking and precise framing matter. You’ll be responsible for: • B...or crushed shadows despite concert lighting shifts. 3. Audio isn’t mandatory, but ambient scratch track is a plus for sync. If you thrive on handheld or gimbal work right in the pit, know how to anticipate musicians’ moves, and can manage your own setup without constant supervision, I’d love to see links to similar concert close-ups you’ve shot. Let’s capture those moments...
...containing only tables and grids have to be turned into a clean, fully-editable Excel workbook. I want every table recreated so that the row-column structure matches the source exactly, but with customized formatting that improves readability rather than simply duplicating the PDF’s appearance. After conversion, the spreadsheet should: • keep numerical data as numbers, not text • preserve all header rows and sub-totals in their correct positions • apply my preferred formatting once I supply the style guide (colours, widths, alignment, or any conditional rules we agree on) Accuracy matters more than speed, so automated copy-paste that breaks merged cells or misplaces decimals is not acceptable. I will provide the PDFs and confirm the formatting rules before ...
...data-cleaning pipeline that consolidates the three source types into one analysis-ready dataset • Interactive dashboards or reports that highlight inefficiencies, trends and anomalies within the production process • A concise recommendations brief that outlines proposed process adjustments, predicted impact and quick-win priorities Acceptance criteria • All insights trace back to verifiable rows in the original data sources • Dashboards refresh automatically when new data is added • Recommendations include quantified time or cost savings estimates With these outputs, I’ll be able to justify changes to scheduling, resource allocation and preventive maintenance, ultimately accelerating throughput while cutting waste. Let me know which to...
...record for those products—description, vendor name, PO number, PO date and unit price. Each time I drop a fresh list of product codes into Sheet1 I want every matching row from Sheet2 to appear automatically beside it, without any manual filters, copy-pasting or one-by-one look-ups. All data columns from Sheet2 must be returned exactly as they are, and I don’t need totals or summaries—just the raw rows that belong to the products I enter. The solution can be a dynamic array formula set-up (FILTER, XLOOKUP, INDEX/MATCH), Power Query, or a lightweight VBA routine; whatever is fastest and most reliable inside Excel. Deliverable: the workbook (or template) with the automated pull already wired up and a short note showing where to paste my product list so everyth...
...shown Match the camera perspective and vanishing point from Google Earth Equipment must be perspective-correct and realistically composited into the scene Do NOT recreate the site from scratch Do NOT use a generic flat rectangular site Components must fit within supplied site boundary and layout geometry BESS Layout: 3 rows across × 9 rows deep White BESS containers with green PCS units PCS units on both inside and outside rows Container short ends visible to camera Rows receding diagonally into image with proper perspective Deliverables: 2 high-resolution rendered images Daytime realistic industrial style PNG and JPG output Editable source file preferred (SketchUp / Blender / PSD etc) Preferred Software: Blender SketchUp + Lumion/Twinmotion 3ds M...
I have a spreadsheet with 1,977 rows laid out as First Name, Last Name, Phone Number, plus a Company column and category that is populated for every contact. I need the entire list turned into a single, clean .vcf file that WhatsApp can import in one step on an Android device. Please map each field precisely: • Given Name + Family Name → the vCard name fields • Phone Number → mobile/tel field • Company → org field Use a vCard 3.0 (or newer) specification so the file is universally accepted. After conversion, verify that the total number of cards equals 1,977 and that a test import to WhatsApp shows names and companies exactly as they appear in the sheet. Deliverable: • One .vcf containing all 1,977 contacts, ready for immediate WhatsApp import, ...
...modules to plug directly into headers. The board must handle data transfer with an Android device (USB Host) while giving the plugged-in ESP32 control over the phone's charging power. 2. Module Headers & Interfaces Block A: Plug-and-Play Module Sockets Instead of soldering raw chips, provide female header pin sockets so the following modules can plug straight into the board: ESP32 DevKit Socket: Dual rows of female headers matching the exact pin footprint of a standard 30-pin ESP32 DevKit V1. Display Interface: A 1 times 9 female pin header breaking out the required GPIO/SPI pins from the ESP32 socket to control a 9-pin display. RFID Reader Interface: A 1 times 8 female pin header breaking out the hardware SPI lines from the ESP32 socket to connect an external 8-pin RF...
I have a 5-slide presentation titled "Next Gen Tax Reporting Automation" for a large enterprise. ...hover states, secondary icons, connector lines Pale Blue: #D6E0F5 — card backgrounds, section fills, subtle shading White: #FFFFFF — slide backgrounds, text on dark fills Dark Navy: #152560 — slide titles, bold text, deep contrast elements Accent Green: #1A7A4A — used only for Indirect Tax modules (ITC, GSTR-2B, EXIM) to distinguish from Direct Tax Neutral Gray: #F4F6FB — background panels, table rows Typography is clean sans-serif (Inter or Cipla's internal font if available), all caps for slide titles, sentence case for body. Minimalist flat vector icons in white on Cipla Blue fills. No gradients, no shadows. Corporate pharmaceutical aes...
...Augmentation, Balancing 4.4 Mathematical model: Add equations for Softmax + Weighted BCE Loss for multi-label. Remove "causal" if my code has no do-calculus. Rename to "Dynamic Modality Gating". Keep 4.5-4.11 same, fix grammar only. 3. SECTION IV. RESULTS & DISCUSSIONS [Rewrite 4.5, 4.7, 4.8 completely] 4.5 Multimodal Fusion Benefit: Create Table 2: Model | Macro-AUROC | Micro-AUROC | F1. Rows: Image-only, Text-only, Ours. Use my CSV data. 4.7 Comparison to Related Work: Compare to 3 papers 2020-2024. Add table. No fake SOTA claims. 4.8 Limitations and Threats to Validity: Write 1 paragraph: "subset size 1,495 pairs may limit generalization", "single-site MIMIC data", "no radiologist reader study", "causal...
I’m looking for a seasoned B2B lead generation specialist who can connect Topsky Guanggao Electronic Technology Co., Ltd. with decision-makers inside large Consumer Electronics corpo...(bounced or catch-all addresses will be rejected) – LinkedIn URL for both the individual and the company Acceptance Criteria • All companies operate in the Consumer Electronics sector and qualify as large corporations. • Each email address must pass verification tools such as Hunter, NeverBounce, or similar, with a deliverability score above 95 %. • No entries may duplicate existing rows or use generic email aliases. If you have a proven track record of sourcing high-quality, purchase-ready prospects in the electronics manufacturing space, I’m ready t...
I have an Excel sheet listing 271 white–background T-shirt images (Column A, rows 2-272). For every shirt I need two new visuals that replicate my references in row 1: • Column B: a clean product display that looks exactly like the B1 sample—same angle, background, and layout. • Column C: a male-model mockup in the style of C1—identical model, pose, lighting, and framing. I work exclusively in Photoshop, so layered PSD or smart-object workflows are perfectly acceptable on your side. The B1 display shot is already colour-correct; please keep it as-is and simply match the look—no extra colour or shadow tweaks. Quality rules I will check against: – Same neutral background and identical male model across the whole set. – Precise cut-o...
...of the template, and double-check that every value lands in the correct column, preserves number formats, and keeps formulas intact where they exist. Consistent formatting is critical; the finished sheets must look identical to the template I provide. Deliverable: one clean, fully populated Excel workbook (or multiple, depending on volume) that matches my template without stray styles or missing rows. Accuracy and quick turnaround are both important, but I’m more interested in zero-error results than in rushing....
I need mixed text and numerical records pulled from several specified online databases and entered accurately into a structured Excel spreadsheet that I will provide. All fields must retain ...I will provide. All fields must retain their original formatting and character encoding, and any numerical values should remain fully editable for later calculations. The workflow is straightforward: access the URLs I supply, capture every required field, paste the information into the corresponding columns of the sheet, then double-check for completeness and consistency. Typos or mis-aligned rows are not acceptable, so a quick self-audit before delivery is essential. Please return the finished Excel file once the entire dataset is transferred and verified. i need someone to help me appl...
...of the template, and double-check that every value lands in the correct column, preserves number formats, and keeps formulas intact where they exist. Consistent formatting is critical; the finished sheets must look identical to the template I provide. Deliverable: one clean, fully populated Excel workbook (or multiple, depending on volume) that matches my template without stray styles or missing rows. Accuracy and quick turnaround are both important, but I’m more interested in zero-error results than in rushing....
...of the template, and double-check that every value lands in the correct column, preserves number formats, and keeps formulas intact where they exist. Consistent formatting is critical; the finished sheets must look identical to the template I provide. Deliverable: one clean, fully populated Excel workbook (or multiple, depending on volume) that matches my template without stray styles or missing rows. Accuracy and quick turnaround are both important, but I’m more interested in zero-error results than in rushing....
...workbooks that now need a thorough clean-up. The raw files contain duplicate entries, inconsistent phone and address formats, occasional spelling mistakes, and a few empty fields that must be handled correctly. Your task is to take these spreadsheets and return a single, well-structured file ready for analysis and import into our CRM. Scope • Import the original workbooks I provide. • De-duplicate rows while keeping the most complete record for each customer. • Standardise column headers, date formats (DD/MM/YYYY), phone numbers (E.164), and address cases. • Flag obviously invalid or missing data so I can review it later. • Deliver the final output in Excel (.xlsx) plus a short change log outlining the key cleaning actions you performed. Accep...
...of the template, and double-check that every value lands in the correct column, preserves number formats, and keeps formulas intact where they exist. Consistent formatting is critical; the finished sheets must look identical to the template I provide. Deliverable: one clean, fully populated Excel workbook (or multiple, depending on volume) that matches my template without stray styles or missing rows. Accuracy and quick turnaround are both important, but I’m more interested in zero-error results than in rushing....
I need a clean, reusable Excel sheet that turns my Amazon data into an insightful monthly Sales Analysis. The file should let me drop in the raw export from Seller Central and instantly show: • Total Sales by month, SKU, and marketplace • Customer Demographics visualised so I can spot trends at a glance Please build it with clear tables, formulas that won’t break when rows grow, and Pivot Tables or Power Query if that makes updating easier. A couple of easy-to-read charts would be great for quick reviews. Deliverables 1. Unlocked Excel workbook ready for my data 2. Brief, one-page guide explaining where to paste exports and how to refresh the visuals If anything in my request needs clarification, let me know up front so we land on a sheet that works perfe...
I have a set of web-based databases that contain sizeable amounts of text records. Your task is to pull the required fields exactl..., so close attention to detail and a quick eye for inconsistencies are essential. I will supply: • direct links to the databases • a sample row that shows the target format • cloud access to the working file for real-time progress checks Before we begin I’ll run through the naming conventions and show you a short demo; after that, you can work independently. I’ll review your first fifty rows for accuracy, offer feedback if needed, and then give the green light for the remaining entries. Deliverables are complete when every assigned record is transferred, the file passes a final spot-check for 100 % accuracy, and the ...
...spelling or numbering errors before you mark the batch complete. If you spot anything unclear or illegible, flag it in a notes column rather than guessing. Deliverables: • A fully populated Excel workbook for each batch • A short note highlighting any rows you could not verify Please be comfortable working with basic Excel functions (filters, conditional formatting, and data validation) so the final sheet stays tidy and searchable. Fast yet careful workers are highly encouraged; let me know your typical turnaround time for, say, 100 rows so I can schedule the next set of files accordingly....
...of the template, and double-check that every value lands in the correct column, preserves number formats, and keeps formulas intact where they exist. Consistent formatting is critical; the finished sheets must look identical to the template I provide. Deliverable: one clean, fully populated Excel workbook (or multiple, depending on volume) that matches my template without stray styles or missing rows. Accuracy and quick turnaround are both important, but I’m more interested in zero-error results than in rushing....
...of the template, and double-check that every value lands in the correct column, preserves number formats, and keeps formulas intact where they exist. Consistent formatting is critical; the finished sheets must look identical to the template I provide. Deliverable: one clean, fully populated Excel workbook (or multiple, depending on volume) that matches my template without stray styles or missing rows. Accuracy and quick turnaround are both important, but I’m more interested in zero-error results than in rushing....
...Metal Framing Drywall Insulation Acoustical Ceilings Painting & Coatings Power Washing General Cleaning Floor Protection Doors, Frames & Hardware Division 10 Specialties Carpentry / Blocking as needed Miscellaneous Repairs & Patching Acceptance Criteria: The file must open in Excel without compatibility issues. Sample data must calculate correctly without requiring manual refresh. Hiding or unhiding rows by CSI Division, trade, or phase must not break formulas or totals. Markup adjustments must update all applicable pricing automatically. All formulas must remain intact and protected while allowing editable input fields for estimating. * Change up the "FINAL" sheet differently and make it look professional as this will be the proposal being sent to customers...
I have a set of web-based databases that contain sizeable amounts of text records. Your task is to pull the required fields exactl..., so close attention to detail and a quick eye for inconsistencies are essential. I will supply: • direct links to the databases • a sample row that shows the target format • cloud access to the working file for real-time progress checks Before we begin I’ll run through the naming conventions and show you a short demo; after that, you can work independently. I’ll review your first fifty rows for accuracy, offer feedback if needed, and then give the green light for the remaining entries. Deliverables are complete when every assigned record is transferred, the file passes a final spot-check for 100 % accuracy, and the ...
I will hand you an Excel workbook containing roughly 4,400 hyperlinks. Each link takes you to a record in the same public financial databas...the requested fields exactly as they appear. • Transfer the contact details—Phone number, Postal address, company website, and LinkedIn profile URL—into their assigned columns. • Record the four specific financial data points I flag inside the sheet, keeping their numeric formatting intact (no added symbols or text). Deliverable A single, fully populated copy of my template with all 4,400 rows completed and ready for immediate analysis. Accuracy matters more than speed, yet I would like steady progress updates so I can spot-check the work as you go. If this process sounds clear and your attention to detail is sol...
Step by step guide for using MySQL database engine from Node.js