Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
After installing and later deleting a meta-tag/SEO plugin, my WordPress back-end refuses to return to normal. The overall layout is now different, affecting the Dashboard, the Post editor, and the Page editor screens. Buttons, panels, and even the TinyMCE blocks are sitting in the wrong spot...templates, and leave me with a clean, conflict-free install. Deliverables: • Cleaned and restored Dashboard, Post editor, and Page editor screens • Short report on what was altered and how it was fixed • Guidance on preventing similar issues in future I can grant full cPanel and wp-admin access immediately so you can begin inspecting , plugin residues, or rogue database rows. Quick turnaround appreciated—once the default layout appears and works flawlessly, we&...
I have two parallel tasks that need the same level of care and accuracy. First, I will provide batches of raw information that must be entered into well-structured spreadsheets. All formulas are already set up; your job is to copy the values into the correct rows and columns, remove any inconsistencies, and hand the file back in a clean Google Sheets format (Excel is fine as long as nothing breaks on import). Second, I need short business texts translated between English and the following languages: Spanish, French, German, and Arabic. The tone must stay professional and any glossary terms I supply have to be respected. I expect a human review for fluency and correctness—machine output alone will not meet the mark. Deliverables • Updated spreadsheet for each data bat...
...template of the final master sheet. Your task is to copy or re-type the text into the corresponding columns, check for duplicates, and keep the overall structure intact. A quick turnaround is appreciated, but accuracy is non-negotiable; one misplaced character skews our internal searches and reports. Once finished, send back the updated master workbook and a brief note confirming the total number of rows you entered so I can cross-check our counts....
I have fewer than 1,000 rows of financial figures that must be transferred accurately into an Excel workbook. The source material consists of PDF statements and CSV exports, and each record includes date, account, description, debit, credit, and running balance. Your primary responsibility is precise data entry—values must reconcile perfectly with the originals and preserve their number formatting for later analysis. If you’re comfortable adding simple checks (SUM totals, running balances, or conditional-formatting flags for outliers) please let me know; it will speed up my own review once the file is complete. Deliverable • A clean, fully-populated Excel file (.xlsx) containing every record from the source documents, ready for any follow-on tasks such as cl...
I have two parallel tasks that need the same level of care and accuracy. First, I will provide batches of raw information that must be entered into well-structured spreadsheets. All formulas are already set up; your job is to copy the values into the correct rows and columns, remove any inconsistencies, and hand the file back in a clean Google Sheets format (Excel is fine as long as nothing breaks on import). Second, I need short business texts translated between English and the following languages: Spanish, French, German, and Arabic. The tone must stay professional and any glossary terms I supply have to be respected. I expect a human review for fluency and correctness—machine output alone will not meet the mark. Deliverables • Updated spreadsheet for each data bat...
I have several PDF files that contain a...locked the project to any pre-defined template. What matters is a clear, consistent structure that allows me to filter and analyse the data easily once the hand-off is done. The full set of PDFs will be shared as soon as we start. I require the finished .xlsx file returned within 3 calendar days. Please run a final self-check before delivery so there are no typos, misplaced decimals, or missing rows. Deliverable • One Excel workbook (.xlsx) containing the fully transcribed and proof-checked data. Acceptance criteria • 100 % character-for-character match with the original PDFs • Logical, uniform column arrangement suitable for immediate analysis • File delivered on or before the 3-day deadline, opening error-f...
I have two parallel tasks that need the same level of care and accuracy. First, I will provide batches of raw information that must be entered into well-structured spreadsheets. All formulas are already set up; your job is to copy the values into the correct rows and columns, remove any inconsistencies, and hand the file back in a clean Google Sheets format (Excel is fine as long as nothing breaks on import). Second, I need short business texts translated between English and the following languages: Spanish, French, German, and Arabic. The tone must stay professional and any glossary terms I supply have to be respected. I expect a human review for fluency and correctness—machine output alone will not meet the mark. Deliverables • Updated spreadsheet for each data bat...
...preferred spreadsheet template, and a short field guide that clarifies how I want blank cells, merged headers, and date fields handled. Deliverables • A completed Excel or Google Sheet containing every row and column from the supplied URLs • A quick spot-check report noting any anomalies you noticed while transcribing (inconsistent totals, missing figures, etc.) Acceptance criteria: 100 % of rows transferred, no dropped characters, and numerical cells that calculate correctly when I run a SUM check. If you are comfortable working directly from HTML tables and double-checking your own work for accuracy, this will be a smooth, quick project....
...will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please outline your approach to data cleaning in Excel (Power Query, formulas, VBA, etc.) and tell me how you will QA your work before hand-off. A quick sample on the first 100 rows will help us confirm formatting early. Looking forward to working with someone who appreciates the nuances of financial data integrity and can turn this around promptly....
...to build a very simple, single-page "Live Event Monitor" dashboard. This is a small task that should take an experienced developer less than 12 hours. Project Requirements: Frontend: Create a clean, responsive table using Bootstrap 5. Data Source: A local .json file located on the server. Dynamic Updates: Use AJAX (jQuery or Vanilla JS) to poll the JSON file every 5 seconds and update the table rows without refreshing the page. Environment: The project must be configured to run on IIS (Internet Information Services). Functionality: The table should display: Timestamp, Event Level (Info/Warning/Error), and Message. If the Event Level is "Error," the text should appear red (Bootstrap text-danger). A simple "Live/Offline" status indicator at the top....
...to build a very simple, single-page "Live Event Monitor" dashboard. This is a small task that should take an experienced developer less than 12 hours. Project Requirements: Frontend: Create a clean, responsive table using Bootstrap 5. Data Source: A local .json file located on the server. Dynamic Updates: Use AJAX (jQuery or Vanilla JS) to poll the JSON file every 5 seconds and update the table rows without refreshing the page. Environment: The project must be configured to run on IIS (Internet Information Services). Functionality: The table should display: Timestamp, Event Level (Info/Warning/Error), and Message. If the Event Level is "Error," the text should appear red (Bootstrap text-danger). A simple "Live/Offline" status indicator at the top....
...Trial Balance to Audit Notes Tab Project Overview: I need a simple software tool or macro/script that automates a repetitive data entry task. The Current Manual Process: 1. I receive a client's Trial Balance (Excel file). 2. I open my standard Audit Report template (Excel file). 3. I manually look up account balances (e.g., "Revenue", "Trade Receivables") in the TB and type them into specific rows in the "Notes" tab of my template. 4. Once the Notes tab is populated, my Financial Statements (FS) update automatically because they are already linked with formulas. What I Want Built: A tool (web, desktop, or Excel Add-in) where I: · Upload the Trial Balance Excel file. · Upload my Audit Template Excel file. · The tool matc...
I need my source material—PDF tables, scanned sheets, and a few Word pages—typed with 100 % accuracy into the Excel template I will provide. The content is mixed: some rows carry purely numerical figures, others include product names, codes, or short notes, so careful attention to both numbers and text is essential. Workflow • I email the template and the raw files. • You key in every field, keeping the exact order, spelling, and number formats I’ve set up. • When finished, return the workbook; I’ll review spot checks and confirm totals match the originals. Acceptance criteria 1. All records present and in the correct columns. 2. No transcription errors or misplaced decimals. 3. File remains in .xlsx format with the existing sheet...
...technical data specialist to extract this information via data-scraping scripts or OCR tools into a cleanly formatted, sortable Microsoft Excel sheet. Project Requirements & Rules No Manual Typing: You must use automated scraping scripts (Python/Selenium/BeautifulSoup) or premium OCR parsers to prevent human entry errors in phone numbers and email addresses. Zero Data Deletion: Do not delete any rows, states, or categories. Keep the entire dataset 100% intact. Delivery Timeframe: 48 hours from project award. Final Excel Grid Deliverables The final .xlsx sheet must feature standard multi-column filters on the top row, mapped to these exact column headers: Company Name Address State Postcode Total Employees Corporate Phone Corporate Email Product Type How to Apply ...
I have a backlog of raw inventory figures that must be keyed into both an Excel spreadsheet and my Tally system. The job is straightforward: take the sou...fine; it helps me gauge your speed and attention to detail. Deliverables • Clean, fully-formatted Excel sheet with all inventory fields completed • Updated Tally data file reflecting the same records • One-page summary confirming item count and any discrepancies spotted during entry Acceptance criteria • 100 % match between Excel and Tally quantities and SKUs • No blank or duplicated rows unless they exist in the source documents • Work returned in the agreed timeline If you are comfortable juggling Excel formulas (for quick totals) and navigating Tally’s inventory module, I&rsqu...
...budget", "roof replacement cost" - General Volume: "recommend roofer", "local roofing", "need roof work", "roof inspection" 4. Anti-Blocking Configuration: Must include random sleep delays and stealth libraries (e.g., undetected-chromedriver or playwright-stealth) to mimic human browsing behavior and prevent local IP bans or bot-detection blocks. 5. De-duplication: The script must check existing rows in the output sheet and automatically filter out/skip duplicate posts from previous scans so I do not contact the same person twice. 6. Data Fields Needed: The script must extract the Date, the Link to the active post, the Name of the user, and the Text snippet of the post. 7. Output Deliverable: A simple local Python script t...
...Display only the 8 core statuses listed below in this exact sequential order. • Hide all other existing, native, or plugin-generated statuses from this active view (but keep them registered in the system backend for future use). Implement Color-Coded Navigation Links Apply the following color scheme strictly to the top navigation text and button elements only (do not alter the color of the main order rows or customer emails): 1. Orders — Black 2. Processing — Blue 3. On Hold — Yellow 4. Special (New Custom Status) — Red 5. Amendments (New Custom Status) — Green 6. Re-Send (New Custom Status) — Orange 7. Acknowledged (New Custom Status) — Dark Orange 8. All — Light Blue Technical Constraints & Notifications • No Email A...
I need my current grocery-store flyer redesigned into a fresh, modern layout that lives in Canva so I can update it myself every week. The finished file should be one page with eight clearly defined squares (two rows of four or any balanced grid you feel looks best). Each square must act as a drag-and-drop photo frame for product close-ups; below every frame I want an editable text field for the product name and a second editable field for the price. Please keep the overall look bright and colorful while still reading clean and contemporary—nothing heavy or vintage. Once the template is delivered I should be able to swap images, change copy, and export to PDF without touching the design structure. Key things I’ll check on delivery: • All eight photo placeholders s...
...SQL, validation status, row counts, and execution duration. 2. Database Connections & Performance Controls Set up a dedicated, completely read-only database connection inside Symfony to ensure absolute security at the database layer. Enforce a strict 10-second query timeout at the connection level to protect live application performance from expensive queries. Implement a hard cap of 1,000 rows maximum returned to the application per query. 3. Frontend UI & Document ExportIntegrate a clean, functional chat interface page within our existing Bootstrap 4 admin dashboard. The UI must feature a text input field, a scrollable conversation thread, formatting of results into clean Markdown tables, and a standard data disclaimer. Add a "Download as Word" butt...
I have a stack of PDFs that need to be turned into a single, tidy Excel spreadsheet. Every value in those files must be transferred exactly, then any duplicate rows removed, and finally the sheet formatted according to the guidelines I will send you the moment we start. The workflow is straightforward but precision-heavy: open each PDF, copy the required fields, paste them into the correct columns, run the de-duplication step, and give the file a quick visual pass to confirm totals, dates, and text all line up with the source. I will check the finished workbook against my guideline sheet, so please be confident with Excel functions such as conditional formatting or simple lookup formulas that help catch errors fast. Turnaround time matters almost as much as accuracy, so let me...
I need fast and accurate data entry work done. Job Details: - Type data from PDF/Image into Excel or Google Sheets - Approx 500 rows - Columns: Name, Phone, Address, Email - Accuracy: 99% required - Delivery: Within 24 hours - File format: .xlsx or Google Sheet link Please only apply if you can start immediately.
I have a stack of PDFs that need to be turned into a single, tidy Excel spreadsheet. Every value in those files must be transferred exactly, then any duplicate rows removed, and finally the sheet formatted according to the guidelines I will send you the moment we start. The workflow is straightforward but precision-heavy: open each PDF, copy the required fields, paste them into the correct columns, run the de-duplication step, and give the file a quick visual pass to confirm totals, dates, and text all line up with the source. I will check the finished workbook against my guideline sheet, so please be confident with Excel functions such as conditional formatting or simple lookup formulas that help catch errors fast. Turnaround time matters almost as much as accuracy, so let me...
...vehicle, location, exception rule, date, and occur within the approved 60-second timing rule. * Complete missing employee and department information. * Convert employee numbers to uppercase. * Populate coordinates where a valid location match is available. * Generate the Weekly Exception Report. 4.2 Weekly KM Reporting The platform will: * Retrieve or import trip and kilometre data. * Remove blank rows, invalid trips, and duplicates. * Standardise driver names, dates, times, and reporting groups. * Consolidate duplicate driver records. * Sum kilometres by driver. * Assign missing reporting groups as **No updated department**. * Exclude **Unknown Driver** records. * Generate cumulative Month-to-Date totals. * Preserve historical report structures. 4.3 Monthly and Cross-Month L...
...will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please outline your approach to data cleaning in Excel (Power Query, formulas, VBA, etc.) and tell me how you will QA your work before hand-off. A quick sample on the first 100 rows will help us confirm formatting early. Looking forward to working with someone who appreciates the nuances of financial data integrity and can turn this around promptly....
I have a backlog of raw inventory figures that must be keyed into both an Excel spreadsheet and my Tally system. The job is straightforward: take the sou...fine; it helps me gauge your speed and attention to detail. Deliverables • Clean, fully-formatted Excel sheet with all inventory fields completed • Updated Tally data file reflecting the same records • One-page summary confirming item count and any discrepancies spotted during entry Acceptance criteria • 100 % match between Excel and Tally quantities and SKUs • No blank or duplicated rows unless they exist in the source documents • Work returned in the agreed timeline If you are comfortable juggling Excel formulas (for quick totals) and navigating Tally’s inventory module, I&rsqu...
I need an up-to-date, well-qualified database of Canadian contacts split between two groups: General...should be delivered in XLSX or CSV and include, for every record, the contact’s full name, job title, direct email, direct phone (where available), city/province, company or clinic name, and a working LinkedIn URL. All data must be sourced legally and double-checked for accuracy; no more than a 5 % bounce rate will be accepted on the emails. Deliverables • Separate sheets (or clearly tagged rows) for GP doctors and business executives • Minimum 95 % email deliverability, with verification date provided • Source or validation note for each contact (e.g., LinkedIn, company site) Completion is confirmed once I spot-check a random sample and the data mee...
...number per contact and make sure it connects. - Contact person should be a relevant point of contact (Director, Principal, Placement Officer, Program Coordinator) rather than a generic reception line where avoidable. - Avoid any duplicate organizations or individuals. Required spreadsheet fields Org Name | Contact Person Name | Designation | Phone Number Acceptance criteria - Minimum 250 unique rows, maximum 300. - Every number must ring through or be otherwise validated within the last week of delivery. - No repeats across any of the four columns. - File submitted in XLSX or a shareable Google Sheet. - A sample of 20-30 entries to be shared first for quality review before full delivery....
I'm seeking assistance to improve my Property Division and Equalization chart. It's nearly done but needs some enhancements and corrections. Key tasks include: - Verifying and refining existing formulas. - Fixing and enhancing the credit/debit adjustments section (around six rows). - Adding functionality for specific row insertions to display certain data. - Ensuring the equalization column (Y/N) works as intended. - Formatting updates and flexibility for ongoing adjustments. Ideal Skills and Experience: - Proficiency in spreadsheet software (Excel, Google Sheets) - Strong attention to detail - Experience with property division calculations - Ability to create automated updates and dynamic charts.
...(Name | Email | Phone). An intermediate level of virtual-assistant experience will help you keep pace without sacrificing accuracy; what matters most is a sharp eye for typos, misplaced characters, and extra spaces. Strong English skills are essential so we can clear up any illegible entries quickly. Deliverable • A Google Sheet (shared back with edit access) containing 250 clean, fully verified rows. Please flag any unreadable items in a separate tab rather than guessing. Once you’re ready, tell me how soon you can start and your expected turnaround time so we can lock in the schedule....
...• Print setup and page layouts. • Formula review and optimization. • Data validation. • Protection where appropriate. • Production-ready workbook architecture. Workbook Structure • Tab 1 – Catalogue Information • Tab 2 – Master Equipment Database • Tab 3 – Customer Catalogue Export 2. Customer Catalogue Export • Include only selected equipment. • Apply optional section discounts. • Remove blank rows. • Generate a clean presentation-ready dataset. • Serve as the only data source for PowerPoint. 3. Premium PowerPoint Design The PowerPoint is as important as the Excel workbook. The objective is to establish a premium visual identity for major customer opportunities. • Large centred company stacke...
...electrical or plumbing yet. Here’s exactly what I’m after: • Overall floor plan of the warehouse showing exterior dimensions, door and window locations and sizes. • Interior walls configured to create separate rooms as discussed, with wall types and thicknesses noted. • An attached office drawn with its precise dimensions plus window placement called out clearly. • Pallet racking laid out in rows. • Exact placement of approximately twenty machines/equipment pieces; I will supply their footprints once we start, so leave them easily editable on separate layers. Please organize the drawing with logical, named layers (walls, windows/doors, racking, equipment, annotations) so minor revisions are straightforward. Deliver the native D...
...descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. • All required columns completed and compliant with my built-in validation checks. • Spreadsheet opens without errors or broken formulas. The moment you accept, I’ll hand over the files and would like the finished sheet back within three days. Clear,...
...descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. • All required columns completed and compliant with my built-in validation checks. • Spreadsheet opens without errors or broken formulas. The moment you accept, I’ll hand over the files and would like the finished sheet back within three days. Clear,...
...descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. • All required columns completed and compliant with my built-in validation checks. • Spreadsheet opens without errors or broken formulas. The moment you accept, I’ll hand over the files and would like the finished sheet back within three days. Clear,...
...you can work from home and pick your own hours as long as daily progress is visible in the shared file. Accuracy is critical: I run periodic spot-checks and will return any row with typos, mismatched data types, or missing mandatory cells. Typical workflow • Download or copy the day’s incoming sheet. • Standardise text case, split combined fields, and flag duplicates. • Paste the verified rows into the master Google Sheets workbook, keeping all formulas intact. • Add a short note in the “Log” tab summarising what was done that session. Acceptance criteria • 99 % field accuracy across the batch. • No broken formulas or altered sheet protections. • Daily log entry completed. If you’re comfortable livi...
... consistent input of textual content into the designated fields of our spreadsheet and cloud database. Here’s what I need from you: • Fast yet meticulous typing of the supplied documents, emails, and notes into Google Sheets and our web-based CRM. • Consistent formatting and spelling so the final dataset is instantly searchable. • A quick progress update each day so I can track completed rows and flag any ambiguous entries right away. I’ll share the template, log-in credentials (via LastPass), and a short style guide the moment we start. Turnaround for the first batch is 48 hours; if everything lines up, there will be regular weekly drops of similar size. Accuracy is the only thing more important than speed—please double-check every recor...
...necessary changes to ensure it accurately aligns with your actual business processes. ● Data Migration Scripts: ○ Python data migration scripts via the Frappe API to securely process legacy data from regional spreadsheets. The script ingestion parameters explicitly map to the provided data realities. ○ Rows lacking complete mandatory attributes will be automatically tagged with a custom status fi eld: data_status: Needs Review. This approach preserves historical context while routing unverified rows directly to dashboard data-cleansing queues for ongoing internal verification. ● Sprint Review Reports: Bi-weekly reports detailing the progress of configuration against the project timeline. 4.3 Phase III: Validation and Readiness ● User Acceptance Test (UAT) Plan: A detaile...
I have several Excel spreadsheets holding strings of information—names, addresses, reference notes, short descriptions—that all need to be brought into one clean, consistent master sheet. Every entry must be copied exactly as written, checked for s...Excel without any import steps. Simply follow the field order I supply, keep capitalization exactly as shown, and flag any illegible or duplicate items in a separate tab so we can review them later. Deliverable: • A final Excel workbook containing all supplied records, perfectly aligned with the provided template and free of typos or extra spaces. I will verify accuracy by spot-checking random rows—anything under 99 % match will be sent back for correction—so please double-check as you go. Looking forward ...
I need an extra pair of hands to transfer information into spreadsheets quickly and accurately. All of the raw information is ready; the job is purely about getting it into the right cells, double-checking for typos, and keeping each sheet neatly formatted so it remains easy to sort and filter. You should already feel comfortable working in Excel or Google S...off, I’d like you to flag it rather than guess. Once we agree on a file-sharing method, I’ll send the first batch of data along with a short set of naming conventions. From there you can begin, send back the completed sheet for review, and we’ll move on to the next batch. If this first round runs smoothly, there will be more work to follow. Let me know how soon you can start and roughly how many rows you c...
...will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please outline your approach to data cleaning in Excel (Power Query, formulas, VBA, etc.) and tell me how you will QA your work before hand-off. A quick sample on the first 100 rows will help us confirm formatting early. Looking forward to working with someone who appreciates the nuances of financial data integrity and can turn this around promptly....
...redesign and not a creative exploration project. I already have a detailed visual instruction manual showing: - page structure - section layouts - row/column arrangements - module placement - colours - typography - spacing - padding - border radius - shadows - mobile behaviour - visual references for each section Your job is to recreate the design inside WordPress using native Divi Builder sections, rows, and modules. Important: - No single HTML block - No screenshot-based page - No hard-coded static layout unless absolutely necessary - Everything should remain editable inside Divi Visual Builder - Use native Divi modules as much as possible - Avoid unnecessary plugins - Avoid complex custom code The goal is to create reusable Divi Library sections so future long-form pages c...
I need a PowerShell script to delete entire rows based on specific text in any column chosen. Requirements: - Identify a specific column containing scattered cells with specific text - Delete entire rows where this text appears - Ensure the script runs efficiently on large datasets Ideal Skills and Experience: - Proficiency in PowerShell - Experience with data manipulation in spreadsheets - Ability to write efficient scripts for bulk actions Please include examples of similar work done.
Please Sign Up or Login to see details.
I have a batch of PDF documents whose contents need to live inside a clean, well-structured Excel sheet. The job is straightforward: open each PDF, copy the required text exactly as it appears, and paste it into the correct columns and rows in Excel. Accuracy and consistency are essential—I rely on the spreadsheet for further analysis, so every character, space, and line break matters. Along the way, I may ask you to smooth out an occasional heading or sentence so it reads naturally once it’s in Excel, but there is no heavy rewriting involved. Think of it as light touch copy-editing rather than full-scale copywriting. You’ll finish when every PDF has been processed and the final Excel file matches the source material perfectly. If you’re meticulous with tex...
...well-commented SQL query (or set of queries) that calculates monthly and quarterly attrition rates for entry-level employees. • A short Python (pandas) routine that executes those queries, pushes the results to an Excel file, and time-stamps each export so historical runs are preserved. Acceptance criteria 1. SQL returns the correct counts and percentages when spot-checked against sample rows in MySQL. 2. The Python script runs from the command line without manual edits, captures the latest data, and drops the finished Excel report into a designated /reports folder. 3. Column names and date formats in the Excel sheet match my existing reporting style (I’ll share a template). The database connection string, table schema, and my current ETL code will be pro...
...descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. • All required columns completed and compliant with my built-in validation checks. • Spreadsheet opens without errors or broken formulas. The moment you accept, I’ll hand over the files and would like the finished sheet back within three days. Clear,...
...follow-up questionnaire of open-ended text questions—at least eleven of them—and capture every answer. The enhanced flow must automatically push the following into a single, shared Google Sheet (one tab only): • the Product selection • the Topic selection • each response to the 11+ open-ended questions • date-time stamp and Slack user ID for traceability I do not want separate tabs; all rows should land in the same sheet so the data set is easy to filter and pivot later. You can extend the existing Workflow Builder configuration if possible, or invoke Slack’s API via a custom function or an external service (Apps Script, Zapier, Make, etc.)—whichever meets Slack’s security model and keeps the hand-off seamless to end us...
I need fast and accurate data entry work done. Job Details: - Type data from PDF/Image into Excel or Google Sheets - Approx 500 rows - Columns: Name, Phone, Address, Email - Accuracy: 99% required - Delivery: Within 24 hours - File format: .xlsx or Google Sheet link Please only apply if you can start immediately.
I need a clean, well-structured Excel workbook that works as a practical “database” for my florist business. Excel is the platform I’m most comfortable with, so every core function—from entering new records to searching past ones—must happen inside the spreadsheet without relying on ... and no broken formulas • A brief “how-to” note or short screen-recording showing me how to add new entries, run a basic lookup, and extend the table structure Acceptance criteria • All formulas return the expected results after I test with sample data • No VBA security warnings or compatibility issues on Office 365 for Windows • File size remains manageable (under 5 MB with 500 sample rows) If anything in the scope needs clarif...
I need my existing workbook given a clean, consistent face-lift. Every sheet already calculates correctly, so please leave all data, formulas, column widths, and sheet names untouched. The task is strictly formatting: • Apply only the built-in, Standard Excel themes for cell styles and colours. • Replace any manual fills or ad-hoc fonts so headers, sub-totals, and data rows follow a clear visual hierarchy. • Check every worksheet to be sure the new styling is applied uniformly and no stray colours remain. Delivery: the fully formatted .xlsx file plus a short note (one paragraph is fine) describing any global style choices you made. Accuracy and completeness are critical—if the file prints neatly and every cell uses a theme colour, the job is done.
Step by step guide for using MySQL database engine from Node.js