HTML Cheat Sheet: A Simple Guide to HTML
Want to learn HTML? We've compiled a cheat sheet for you to make the learning process much easier!
...Sheets. Once complete, I should be able to copy-paste raw data straight from our CRM (sample tabs provided) and have the invoice populate instantly without touching any formulas. Key functions I need baked in: • Auto-formatting so the file always prints cleanly in landscape, no matter how many service lines we add. • Dynamic column handling—if I insert extra columns the header must stay intact, and I can hide or show selected columns with a single click. • A dedicated import zone that matches the CRM export fields, ensuring data drops into the correct spots every time. Design requirements: • Custom template styling that reflects our brand, complete with logo, agency name, and a tidy header block for client details plus the invoice date/n...
...backtesting, so accuracy is critical. Even top 85-90% data works. Scope of Work: Input: ~24 PDF Files (Monthly Factsheets). Target Funds: For each month, extract data for the Top 10 Equity Funds (e.g., Bluechip, Midcap, Smallcap, Value Discovery, etc. - list will be provided). Total Volume: Approx. 240 tables (24 months × 10 funds). Output Format: A single Consolidated Excel/CSV file with these columns: Date (Month-Year) Fund Name Stock Name (Full name as in PDF) Percentage (%) (Holding weight) Sector (If available) Requirements: Complete Data: If the sum of holdings es les than 85%, I will reject the work. Attention to Detail: The PDFs have complex multi-column layouts. Rows must not be merged incorrectly and weightage for each stock should be specified correctly ....
I need a reliable script that can pull a complete database of Food & Beverage outlets in Singapore directly from Google (Maps or Search). The scope covers Restaurants, Cafes, Bars, Clubs and Bistros islan...island-wide. For every venue scraped I must receive: • Name • Full address (street, unit, postal code) • Phone number - Type of outlet - Website - General Area Deliverable in Excel. Need 4 tabs representing each region in Singapore. Each tab, consisting of several district within the region. Please ensure: • No duplicates • Accurate field separation (e.g., address split into distinct columns) • Script runs without paid APIs Let me know your proposed method and approximate turnaround time, and feel free to highlight any prev...
...data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Deliverables • A completed Google Sheet with every record accurately transcribed • Range-validation rules applied to all numeric columns, with out-of-range values clearly flagged • A short confirmation note describing any anomalies you discovered and how they were handled When I open the file I should see zero typos, consistent column structure, and all numeric columns protected by the validation rule. If you enjoy meticulous data work and have sol...
I need a clean, well-structured list of Pilates studios, each one accompanied by complete contact details. My goal is to build a reliable outreach d...I’m flexible on the research approach—you might pull data from studio websites, Google Maps, Mindbody listings, Instagram bios, or any other public source—as long as the final spreadsheet is accurate and deduplicated. Please mark any fields you cannot verify so I can review them quickly. Deliverable: a CSV or Excel file ready to import into a CRM, with one row per studio and clearly labeled columns. If you already have a proven template for similar work, feel free to use it; just be sure it fits the fields above. Quality matters more than sheer volume, so let me know your estimated studio count and timeframe wh...
I have five clear pages that need to be re-typed into a single Excel workbook. Each page is already laid out in neat columns and rows and contains a mix of text labels and numeric values. No complex formatting is required—just enter the information exactly as it appears so the sheet mirrors the original structure. A simple .xlsx file with the data placed in the appropriate cells is all I need back. Accuracy and a quick turnaround are my main priorities, so please double-check totals and spelling before you send the file over.
...appears on gathered into a single, well-structured Excel workbook. Please crawl the entire site, not just a few sections, and return each number alongside the key profile details that make the data usable at a glance—name, profile URL, and any other easily captured identifiers shown next to the number. A clean .xlsx with one row per profile, no duplicates, and clearly labelled columns is the only deliverable I’m expecting. If you prefer Python, Scrapy, Selenium, Beautiful Soup or a comparable stack, go ahead; I’m interested in results, not the specific toolset, as long as the script can be rerun later should the site content change. Before delivery, double-check that: • every row contains a valid phone number and url • no pages on the site were ski...
I'm looking for an expert in Excel to create a detailed compensation analysis The model should help in compensation benchmarking analysis . Key requirements: - ability to add multiple surveys into the file and the ability to weight the different surveys different based off position. Built out for at least 3 survey sources - columns for 25th, 50th, and 75th percentiles for base pay, total cash, and long term incentives. Should also include bonus target as a %Ike and bonus actual as a $ value - Detailed compensation insights Ideal skills and experience: - Advanced Excel proficiency - Experience in modeling - Attention to detail - ability to
...scope covers all earthworks, concrete, formwork, reinforcement and associated preliminaries shown in the drawings—no architectural or MEP data is involved, so the task is strictly take-off and quantification from the structural set. I’m looking for a concise spreadsheet (Excel or compatible) that breaks down every measured item, lists units, quantities and brief descriptions, and totals the cost columns ready for pricing. If you use a recognised standard method of measurement, note it in the file so there is no ambiguity on how the figures were derived. Timing is tight: I’d like the first draft within a few days of award and the final, checked version shortly after any feedback. When you reply, focus on your experience creating BOQs for similar groundwork or i...
I need a polished Google Sheets template that lets me manage our business expenses through a single, annual P&L budget worksheet. The sheet must centre on three core sections—Revenue, Operating expenses and Net profit—so I can see at a glance how each line item rolls up into year-end performance. The template should: • follow a true ANNUAL P&L BUDGET layout (12-month columns, annual totals and a clean summary dashboard) • accept granular entries yet keep the front-end simple enough for non-finance staff to update • include built-in formulas that automatically calculate subtotals, gross margin and final net profit • highlight variances between forecast and actuals, and flag any negative trends with conditional formatting • be ...
I need my monthly electricity bills transferred into a clean, well-structured Excel workbook. For every statement I receive, I want one row that captures columns of data: the billing date, usage in kWh, total cost, current read, previous read current usage and any remaining credits that appear on the bill. Edit: I have approx 100 previous bills I would like added to the spreadsheet. Please set up the file so I can keep adding future bills myself—simple data-validated entry boxes or a protected template sheet would be appreciated. A running year-to-date summary that auto-totals usage and spend would be a useful bonus, though not mandatory. Deliverables • Excel file (.xlsx) with the template sheet and at least one sample entry filled in • Clear instructions (a sho...
...a Google Sheet. Your job is to run or improve that automation, confirm the report posts before 11 AM EST, and fix any API hiccups without prompting. Deliverables • 2–4 Instagram-ready Stories/Reels per day • Daily CSV and updated Google Sheet populated via PayPal API • Source project files for each video Acceptance criteria • Videos pass Instagram compression with synced audio • Sheet columns populated: transaction_id, gross_amount, fee, net, customer_email • Script runs unattended for a full 24-hour cycle without fatal errors My stack: Google Drive, Adobe CC, Ubuntu VPS. Use Premiere, After Effects, DaVinci, or your preferred editor, and any PayPal-SDK (Python, Node, PHP) that keeps the workflow reliable. Consistency and clear comm...
Change the door panel and fluted columns on previous cabinet.
...rate/commission). - Final follow-up (21–28 days): Check-in + offer to keep in touch; request permission to share occasional updates. - Personalization: reference mutual connections, company news, or recent LinkedIn activity for each prospect. - Daily throughput: send 10–20 connection requests/day (adjust to avoid limits); follow-up pipeline daily. Lead Management & Nurturing - CRM: Google Sheet with columns: lead, company, source, tags, outreach stage, last contact, next action, notes. - SLA: respond to inbound messages within 24 business hours. - Templates: standardized but editable templates for quotes, follow-ups, intro messages, partnership proposals. - Nurture content: send relevant case studies, one-pagers, seasonal offers, and invites to virtual demos. ...
...Note payment & delivery terms commonly used (advance %, credit days, incoterms if known). Take 3–10 photos of stockyards/tiles/slabs (file names must match vendor rows). Short local intelligence: Which foreign suppliers dominate (Turkey, India, China, Brazil?) and why (price / finish / colour variety / local relationships). Deliverables (final): Google Sheet (structured table — see required columns below) 5–8 page PDF summary (key findings, 3 charts: price distribution, top colours, country-share). Folder of labelled photos (min 3, max 10). Requirements: Based in Ivory Coast and fluent in French. Experience with B2B/ construction materials or prior market research in building supplies is preferred. Able to do phone/WhatsApp calls with vendors and v...
I’m looking to turn an existing floor-plan image into a clean, to-scale DWG that I can drop straight into my CAD workflow. All fixed architectural elements—external and internal walls, columns, built-ins—must be traced accurately so the drawing measures up when printed or imported at 1:1. Please show every door and window opening exactly where they appear on the source, and label each room with its name plus the key linear dimensions I’ve marked. Moveable furniture such as chairs, sofas, and loose décor can be ignored entirely; I only need the architectural shell and critical openings. Deliverables • One DWG file, properly scaled and ready for AutoCAD use • Separate, clearly named layers for walls, doors, windows, room names, and dimen...
...backtesting, so accuracy is critical. Even top 85-90% data works. Scope of Work: Input: ~24 PDF Files (Monthly Factsheets). Target Funds: For each month, extract data for the Top 10 Equity Funds (e.g., Bluechip, Midcap, Smallcap, Value Discovery, etc. - list will be provided). Total Volume: Approx. 240 tables (24 months × 10 funds). Output Format: A single Consolidated Excel/CSV file with these columns: Date (Month-Year) Fund Name Stock Name (Full name as in PDF) Percentage (%) (Holding weight) Sector (If available) Requirements: Complete Data: If the sum of holdings es les than 85%, I will reject the work. Attention to Detail: The PDFs have complex multi-column layouts. Rows must not be merged incorrectly and weightage for each stock should be specified correctly ....
...an email check before marking it complete. If a number bounces or a mailbox hard-returns, it shouldn’t appear in the final file. Feel free to draw on LinkedIn Sales Navigator, company websites, reputable databases, or any other reliable research techniques—as long as the end result is correct and fully verified. Deliverables: • My original sheet returned in Excel/Google Sheets format, with new columns for Name, Email, Mobile, and a brief “Verification note” showing the date and method (phone or email) you used. • A short summary of any companies where no direct details could be obtained after reasonable effort, so I can decide on next steps. Accuracy, completeness, and transparency in your verification process will decide acceptance. If you&r...
...auditors, and key documents at a glance. Core tasks • Spin up the site collection (or sub-site if that suits best), apply clean navigation, and brand it with the company colours we will provide. • Build the Project-Tracking page using out-of-the-box web parts or modern SharePoint Lists—whichever gives a clear dashboard-style view of open, in-progress, and closed utilities audits. • Configure columns for audit type, owner, due date, percentage complete, findings, and next actions. • Set sensible permissions so the audit group can edit while the wider business can view only. • Automate email or Teams alerts when due dates slip, using Power Automate if needed. Ready for expansion such as a dedicated Home page or Document Library can be planned later,...
...(PDFs, scans, CSVs, or emails) and inputting them accurately into the predefined spreadsheet template. Accuracy and consistency matter more to me than speed. I rely on precise formatting, clear naming conventions, and zero duplicate or missing records so that I can later sort, filter, or analyze the data myself. If you see small ways to improve the worksheet’s layout while you work—additional columns, data validation rules, basic formulas—feel free to suggest them, but the core task remains clean data entry inside Excel. Acceptance criteria • Every source record is transcribed once and only once. • All numeric and date fields follow the template’s format. • No blank rows unless intentionally required by the template. • Final ...
I’m looking f...before the model layer. Deliverables 1. A .pbix with: – Power Query steps that convert every source to monthly balances – A hierarchical-schema based on the matrix layout down to the GL Account – The Matrix visual laid out exactly as above, showing correct Opening and Closing balances per month (This is the key complexity and requires design of the data model, report specific columns in the data sources such as +/- DebitCreditFlag, and DAX measures) 2. MS Teams calls to review the requirement and further calls to reconcile the task to iterate it until complete. Please reply with a brief outline of how you would stage the data and any prior projects that demonstrate cash flow or other financial statement work in Power BI. ...
I need a steady stream of fresh B2B contacts and I want them sourced primarily through Apollo. The focus is on Heads of Engineering—any comp...contacts and I want them sourced primarily through Apollo. The focus is on Heads of Engineering—any company that squarely fits the ICP I will share with you. You’ll work through my filtering instructions, gather only decision-makers that match, and verify every record so no generic or bounced emails slip through. Once enriched, please drop each batch into a tidy Google Sheet containing just three columns: Full Name, Email Address, and Job Title. If you’re comfortable digging deep with Apollo, cross-checking details in LinkedIn Sales Navigator or Crunchbase when necessary, and can keep the sheet clean and ready for ...
...reports only) Deliverables 1. Fully functional AppSheet app linked to a clean, well-structured Google Sheet data source. 2. Role definitions set up in AppSheet security so I can just add new user emails later. 3. The Individual Attendance Records view/report with a simple filter by employee and date range. 4. A short hand-off document or screen-share video showing me where to adjust columns, add employees, and create further reports. I work best when I can test early, so please share an initial prototype within the first milestone and iterate from there....
I have a pre-built Excel template that tracks financial figures from an annual report. The raw numbers are on a general ledger associated with the report. I need someone who can organize the General Ledger data, enter it accurately, sort it into the right tabs and columns, and then run a quick analysis to be sure everything reconciles to the report. You will be working solely with financial data—General ledger, financial report, and a few historical comparisons—so precision is essential. Deliverables • The updated template populated with the latest data, sorted and validated • A brief note (or a new sheet) outlining any formulas, lookups, or PivotTables you added, so I can maintain them next cycle Key Objectives & Deliverables • Data Integrati...
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
...sources: company and organisation websites, their public social-media profiles, and well-known online directories. I expect the data to be gathered with a solid scraping workflow (Python, Scrapy, BeautifulSoup, Selenium or an equivalent stack is fine) and then verified so that bounced emails and dead numbers are kept to an absolute minimum. Deliverables • One CSV or Excel file with separate columns for name, company, job title, email, phone, street address, city, state, ZIP/postcode, country, source URL and date collected. • No duplicates; every entry must be unique across the entire sheet. • Accuracy rate of at least 95 % on all contact fields, demonstrated by a small random sample check before final hand-off. If you already have scripts or tools th...
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
...backtesting, so accuracy is critical. Even top 85-90% data works. Scope of Work: Input: ~24 PDF Files (Monthly Factsheets). Target Funds: For each month, extract data for the Top 10 Equity Funds (e.g., Bluechip, Midcap, Smallcap, Value Discovery, etc. - list will be provided). Total Volume: Approx. 240 tables (24 months × 10 funds). Output Format: A single Consolidated Excel/CSV file with these columns: Date (Month-Year) Fund Name Stock Name (Full name as in PDF) Percentage (%) (Holding weight) Sector (If available) Requirements: Complete Data: If the sum of holdings es les than 85%, I will reject the work. Attention to Detail: The PDFs have complex multi-column layouts. Rows must not be merged incorrectly and weightage for each stock should be specified correctly ....
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
...Sheets. Once complete, I should be able to copy-paste raw data straight from our CRM (sample tabs provided) and have the invoice populate instantly without touching any formulas. Key functions I need baked in: • Auto-formatting so the file always prints cleanly in landscape, no matter how many service lines we add. • Dynamic column handling—if I insert extra columns the header must stay intact, and I can hide or show selected columns with a single click. • A dedicated import zone that matches the CRM export fields, ensuring data drops into the correct spots every time. Design requirements: • Custom template styling that reflects our brand, complete with logo, agency name, and a tidy header block for client details plus the invoice date/n...
...data-validation rules, filters, or even quick formulas to speed up the range checks, but accuracy always overrides speed. Because the sheet mixes text columns and numeric columns, please beware of mis-aligned cells, accidental truncations, or copied formatting that could skew the data type. Deliverables • A completed Google Sheet with every record accurately transcribed • Range-validation rules applied to all numeric columns, with out-of-range values clearly flagged • A short confirmation note describing any anomalies you discovered and how they were handled When I open the file I should see zero typos, consistent column structure, and all numeric columns protected by the validation rule. If you enjoy meticulous data work and have sol...
...complaints. The site expects very specific, custom tags, and I’ll share a sample file plus the exact tag map and hierarchy you must follow. Your task is to take the spreadsheet I provide and give me a repeatable way—VBA, Macro based, Power Query, or any approach you prefer—to generate a UTF-8 XML file that matches the structure perfectly. The converter must: • read every row of the sheet, • map columns to the custom tags I supply, • preserve dates, numbers, and special characters exactly as entered, • output a clean XML file ready for immediate website import. Deliverables I expect: 1. A working script, macro, or template‐driven solution I can run any time the spreadsheet changes. 2. One sample XML file generated from my test sheet...
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
...stack you feel is most stable—C#/.NET (WinForms or WPF) or a lightweight Electron build are both fine as long as startup time is fast and the installer is straightforward. Local storage can sit in SQLite or a small embedded SQL Server database; just make sure the data file is easy for me to back up. I’ll provide the exact field list and sample data once we start, but anticipate roughly 15–20 columns, a few dropdowns, and one attachment field per record. All code must be well-commented, and I’d like a brief hand-off call or screen-share at the end so I know how to build and publish future versions myself. Deliverables: • Fully functional Windows executable and installer • Source code with clear comments • README with build instructions ...
...into a clean, well-structured Excel workbook that my team can expand and report on. The focus is solid data organisation first, with some light analysis tools added so anyone in the warehouse can slice the figures later. Here’s what I’d like delivered: • Import the supplied comma-separated file and convert it into a properly formatted Excel Table. • Resize the table so all active rows and columns are included, then give it a clear, descriptive name that makes future formulas easy to read. • Build an Advanced Filter that lets us pull subsets (e.g., by location or stock level) without copying the whole sheet around. • Add a multi-level sort (think category → sub-category → SKU) so items appear in a logical order straight out of the ...
...Arab Emirates • Brands: AL SAMARA At the moment these six fields are mandatory; if you notice other useful fields while you scrape we can discuss whether to add them, but the core deliverable must not be delayed. This is a one-time scrape, so focus on accuracy rather than building an updating pipeline. The finished CSV should have 6,683 complete rows, no duplicates, clean text (UTF-8), and the columns in the order listed above. Please also supply the source script or notebook you use so I can rerun it if necessary. Let me know your estimated turnaround and any technical clarifications you need before starting....
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
...Python script that pulls everything of value out of them and drops it neatly into an Excel workbook. Here is what I expect: • The script must capture every text field that appears on each bill (invoice number, dates, vendor, totals and any other descriptors). • It should identify and export any tabular line-item sections so that quantities, descriptions and prices land in true Excel rows and columns—not as a single block of text. • Embedded images or logos also need to be saved out (ideally into a sub-folder) with a reference back to the originating invoice inside the Excel sheet. Python tools such as pdfplumber, PyPDF2, camelot, tabula-py, pandas and openpyxl are all fine; choose the combination you’re most comfortable with as long as the fi...
...backtesting, so accuracy is critical. Even top 85-90% data works. Scope of Work: Input: ~24 PDF Files (Monthly Factsheets). Target Funds: For each month, extract data for the Top 10 Equity Funds (e.g., Bluechip, Midcap, Smallcap, Value Discovery, etc. - list will be provided). Total Volume: Approx. 240 tables (24 months × 10 funds). Output Format: A single Consolidated Excel/CSV file with these columns: Date (Month-Year) Fund Name Stock Name (Full name as in PDF) Percentage (%) (Holding weight) Sector (If available) Requirements: Complete Data: If the sum of holdings es les than 85%, I will reject the work. Attention to Detail: The PDFs have complex multi-column layouts. Rows must not be merged incorrectly and weightage for each stock should be specified correctly ....
...switch hats and write a brief, engaging summary (≈250 words) that explains what the data shows in plain English. Think of it as a mini blog post that highlights key findings and any surprising trends—concise, reader-friendly, and free of jargon. Because the project combines freelance writing and spreadsheet data entry, I’m looking for someone who is as comfortable with words as with rows and columns. Familiarity with Google Sheets or Excel, a sharp eye for detail, and the ability to turn numbers into a clear narrative are all essential. I’ll share the first dataset as a paid pilot; if we’re both happy, there are more batches ready to go. Deliver each batch as a completed spreadsheet plus its written summary, and please keep turnaround tight (24...
I have a public webpage that ...need that roster converted into a clean Excel (.xlsx) file. Only two data points matter to me for each entry: the member’s name and the company they’re associated with—nothing more. The task is straightforward: • Capture every member on all seven pages. • Keep spelling, capitalization, and any accents exactly as they appear online. • Organize the final spreadsheet with two clearly labeled columns—Name and Company—free of duplicates or blank rows. No login or special access is required for the site. Once the file is complete, simply share the .xlsx and I’ll take it from there. If any ambiguity arises while you’re working, let me know so we can clarify quickly; otherwise, accuracy and a prom...
Very straightforward task. Create an Excel table based on the draft I'll provide. Need to add simple filters to some columns and separate columns into different sections, which could be expanded or collapsed upon clicking on them. It's important that if collapsed the title of the section is still visible so I can understand which section is hidden and I should be able to expand it once I click on the title of the "hidden" section.
I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • replacing about 20 words on one wb I Should get a macro in an xlsm file that I can run on other similar files. attache a file to be changed a file with words to replace and their replacements. an instruction letter at the end I will check the macro file to see that all the replacements were executed.
...Specialist to convert a set of 2D architectural plans (PDF/DWG) into a highly accurate Revit 2024 model. This is the first phase of a larger project; the model must be structured so that MEP systems can be seamlessly integrated in Phase 2. Scope of Work Architectural Modeling: Accurate 3D conversion of floor plans, sections, and elevations. Structural Integration: Include all structural elements (columns, beams, foundations, and load-bearing walls) as per the provided 2D drawings. Family Placement: * Full layout of Kitchen and Bathroom fixtures. Fixtures must be placed as Revit Families (not generic blocks) to allow for plumbing connection points in Phase 2. Phasing/Organization: Ensure correct levels, grids, and room tagging. Technical Requirements LOD 300: The model shoul...
I’m building a fresh information-capture and approval system inside Microsoft 365 and I want the whole flow—from form submission to final approval notice—running hands-free. You’ll start from a clean slate, designing Microsoft Forms that feed directly into Microsoft Lists, then wiring everything together with Power Automate so that: • data lands in the right columns without manual touch • approvals route to the correct people in sequence • email or Teams alerts fire at each stage, including rejection or completion messages I’ll provide the field requirements, user roles, and any branding assets for the form. You’ll translate that into a well-structured list, create the associated flows, test end-to-end, and hand over concise...
...expert to build a clinic appointment system using Google Sheets, , and WhatsApp/SMS. Must deliver end-to-end working system with documentation. Objective (What problem this solves) Automate clinic appointment handling using Google Sheets + WhatsApp/SMS so that: Scope of Work A. Core System (Mandatory) 1. Google Sheet Setup (Just copy paste as is)… o Create master sheet with following columns ONLY: Patient Name Mobile Number Appointment Date Appointment Time Doctor Name Status Booked Confirmed Attended Missed Rescheduled 2. Automation o Trigger when a new row is added or status changes o Automation logic: Booked → Send confirmation message Confirmed → Send reminder (T-1 day) Attended → Mark completed Missed → Send follow-...
...information should appear in a clean table and in charts (bar or line—whichever communicates profit trends best). The report has to live inside Odoo, accessible from the POS reporting menu, refresh off real-time data, and be exportable to Excel or CSV without breaking the formatting. Acceptance criteria • In-app menu entry under POS Reports opens the new “Item-wise Profitability” view. • Table columns: Item, Quantity Sold, Cost/Unit, Price/Unit, Total Cost, Total Sales, Profit, Profit %. • Toggle or separate tab displays corresponding charts for top-selling and most profitable items. • Report honours existing user access rights. • Delivered as an installable Odoo module with clear deployment instructions. If you have built si...
...that combine messy paragraphs with complex tables. Usually, you’d spend hours capturing every word, figure, and symbol to get them into a clean, organized spreadsheet. Why spend days on manual entry when you can do it in seconds? I’ve built a tool called Safeoid that handles the "Final Boss" of data entry: Context-Aware OCR: It captures text exactly as written and places numbers in the correct columns—even from inconsistent pages. Complex Structure: Whether it’s product descriptions with prices or printed totals with signatures, it preserves the structure for Excel or Google Sheets. Accuracy First: No more double-checking manual typos. Get your data delivered in a clean XLSX format without the "human error" tax. To celebrate our l...
My Webflow site needs a focused refresh. On the design side, certain sections call for layout adjustments so columns, grids and spacing line up cleanly, and the typography hierarchy (headings, body text, buttons) must be standardised—no colour-scheme tweaks required. Functionally, several interactive elements built with Webflow Interactions have stopped responding. I need those click- or scroll-triggered effects working smoothly again; forms and basic links are fine, so the fix is limited to the interactions. Deliverables • Layout adjustments and text/font changes completed across all affected pages • Interactive elements repaired and tested across desktop, tablet and mobile breakpoints • Final QA inside Webflow Designer and a republish once everything...
Want to learn HTML? We've compiled a cheat sheet for you to make the learning process much easier!
We explain how to combine colors effectively and then give you 120 free color combinations you can immediately apply to your designs.