Excel macros jobs

I have several spreadsheets filled with plain text that must be re-entered into a new master file. Everything you need is already organised in Excel/Google Sheets—no numbers to crunch and no images to handle—just clean, consistent text. Your task is simple: • Transfer each text field into the matching column of the template I supply. • Keep the original formatting, punctuation and line breaks intact. • Flag anything that looks incomplete or unclear in a separate “Issues” tab. Deliverables • Fully populated master spreadsheet, ready for immediate use. • Issues log listing any rows you could not confirm. Acceptance will be based on complete row coverage, correct column alignment and zero uncorrected typos. I will share a small ...

...and prospect segments, map touch-points along the buyer journey, and outline frequency, cadence, and offers. • Creative & copy – craft attention-grabbing subject lines, persuasive body copy, and strong calls-to-action that speak to repeat buyers as well as people who have never purchased before. • Technical setup – build responsive templates in my current ESP (let me know which platforms you excel with), set up automation flows, and ensure deliverability best practices (SPF, DKIM, list hygiene, etc.). • Testing & optimisation – run A/B tests on subject lines, send-times, content blocks, and offers; track open, click-through, and conversion metrics; and refine each send based on real-time data. • Reporting – provide a con...

...well-signposted sections on results interpretation and key limitations so the audience walks away with a balanced view of the study’s strengths and caveats. Deliverables • PowerPoint file (~12-15 slides) calibrated for a 20-minute talk • Speaker notes beneath each slide that form a ready-to-read script • Visuals (charts, flow diagrams) created inside the deck or embedded from R, Python, or Excel—whichever you prefer—as long as the source files are included Acceptance criteria The slide deck must follow my brand template (I will supply it), finish within the allotted time when read aloud at a normal pace, and accurately reflect every figure or statement back to the original manuscript text. If you are comfortable distilling clinical trial ...

I have a PDF document whose content is organised entirely in tables, and I need every one of those tables transferred into an editable Excel file. Accuracy is critical—the row and column structure must be preserved so that the data can be filtered, sorted, and analysed without additional cleanup on my side. Deliverables • One Excel workbook containing all tables from the PDF, each table neatly placed in its own sheet or clearly separated within a single sheet (whichever keeps the layout intuitive). • No data loss, merged-cell issues, or misaligned headers; totals and subtotals should match the source exactly. Please let me know your estimated turnaround time and any questions you might have about the source file.

I have a set of records—some purely textual, others numerical—sitting in an online database. I need every field moved into a clean, well-structured Excel spreadsheet while maintaining full accuracy and consistency. Scope • Log in to the online database I provide and capture each mixed-data record exactly as displayed. • Validate spellings, numbers, and basic formatting as you go; no content changes, just tidy and consistent entry. • Organize the final workbook with clear column headings, frozen header row, and simple filters so I can sort and analyse the data immediately. Deliverable • One Excel (.xlsx) file containing every record from the source database, verified and ready for use. Timeline and quality are important to me, so attentio...

I’m ready to level-up my online presence and would like to begin with a series of image designs tailored for Facebook. The immediate goal is a set of professional, corporate-style graphics that feel polished and trustworthy while still catching the eye in...those next stages. I value clear status updates, draft checkpoints, and timely delivery; if revisions are needed, I appreciate fast turnaround. Deliverables for this phase: • 8–10 high-resolution Facebook image posts (PNG + source files) • Variations for stories and ads where appropriate • A brief style guide noting fonts, colours, and layout rules so future video assets stay on brand If you excel at blending creative flair with a corporate aesthetic—and you’re comfortable expanding into m...

I need a fully-fledged weight-loss programme that blends smart nutrition with effective training and clear pr...estimates, and workout performance, plus a brief tutorial on how to use them. Acceptance criteria • Meals align with a sensible calorie deficit tailored to a 30-year-old, moderately active individual (I will provide exact stats once we start). • Workouts complement the nutrition plan and progress logically across the four weeks. • All documents delivered in editable formats (Google Sheets or Excel, plus PDF versions). • Clear, concise explanations accompany each section so I understand the “why,” not just the “what.” If you have questions about food preferences, allergies, or training limitations, let me know up front s...

I need every piece of engineering intelligence buried in my legacy P&ID drawings lifted into a clean, structured Excel file. The drawings arrive to you as searchable PDFs, and I will send the exact tag-naming and line-label conventions that must be followed. This is not a simple OCR job. You will have to read the schematics like a process engineer: • identify each piece of equipment, every line number and size, all pressure and temperature design data, motor or HP ratings, valves, PSVs, instruments, local indicators, switches, controls, and the relationships that connect them; • transfer the information into the spreadsheet so that tags, descriptions, operating/design figures and interconnections are all in their correct columns; • confirm that nothing is...

...Calculate MS support structure weight (kg) Identify bracket, anchor and fixing quantities Estimate installation labour cost for GRC and MS Include scaffolding cost based on height Provide rate analysis (material + labour) Prepare final BOQ in Excel Provide a summary sheet suitable for client quotation Required Experience: GRC panels, jalis, cornices, moulded elements MS RHS/SHS/angle support frames Façade installation methodology Quantity surveying for architectural precast Ability to read architectural drawings (PDF + DWG) Deliverables: BOQ (Excel) GRC area calculation MS weight calculation Installation cost sheet Final summary sheet Important: This is NOT a generic civil estimation job. Only apply if you have façade/GRC/MS experience......

I have already drafted all the core information for my Freelancer.com profile—name, professional title, “about me” text, key skills (Data Entry, Virtual Assistance, Internet Research, Microsoft Excel, Google Docs, PDF Conversion, and more), the languages I speak (English and Amharic), plus a short “Why choose me?” section. What I need now is a communications-savvy freelancer who can transform this raw copy into a concise, persuasive, and well-formatted profile that will attract clients looking for accurate data entry, reliable virtual assistance, and thorough online research. Here’s what I’m expecting: • Refine the language so it reads naturally and confidently, without sounding generic or repetitive. • Structure the cont...

...Invoice platform so that every transaction is reported to ZRA automatically and in the correct format—no manual uploads, no compliance headaches. Core features I expect out of the box: • Inventory management that handles thousands of SKUs, flags low-stock items in real time and produces reorder suggestions • Detailed sales reporting with daily, monthly and year-to-date insights exportable to Excel or PDF • A simple customer loyalty module that tracks repeat buyers and applies discounts or points at checkout Because this will run on our in-store desktops, the application must install locally, work smoothly on a standard Windows environment and offer an easy way to back up or restore data. Internet connectivity in-store can be patchy, so an offline-firs...

...month-end I’ll rely on you to prepare the standard Profit & Loss, Balance Sheet and Cash-flow plus any management or statutory reports I request. Because this is an ongoing role, the file in Tally must always reflect real-time figures I can trust for decision-making. Please be fully fluent with 9 shortcuts, GST configuration, bank import and voucher classifications; if you also know Excel for quick cross-checks, even better. Deliverables I expect: • Daily posting of all vouchers with correct ledger allocation • Weekly reconciliation of bank, cash and GST ledgers • End-of-month P&L, Balance Sheet and any ad-hoc financial reports in PDF and in-product format • A short summary highlighting anomalies, overdue receivables or unusual variances...

I'm looking for a freelancer to do Excel data entry for me. The list contains of 723 out of approximately 20% are not applicable to fill in. Out of the remaining 80% of 723 lists each one of them contain another subfolder of Excel files that will be downloaded separately and added into a master folder Excel list that I want from you. The proceeded Excel file on each varies from 5-200 or higher on each I would estimate but its difficult to say exactly since all list must be downloaded separately to see exact numbers. All these individual subfolder Excel files must be saved in one Excel file too and added into a master folder Excel file too. 3 things needs to be typed in manually from your end on each company lines in Excel. Phone...

...architectural drawings in PDF, TIFF, or common CAD formats. • Let users set the plan scale, then measure counts, linear runs, areas, and volumes with click-and-drag tools. • Each measured item should drop straight into an estimating worksheet where labour, material, and markup values can be edited on the fly. • Calculations must refresh in real time, and the finished estimate should export cleanly to Excel or CSV. User experience I’m after a professional, detail-rich interface: dockable panels, layered plan view, colour-coded highlights, right-click context actions, and keyboard shortcuts—something seasoned estimators can live in all day without clutter or gimmicks. Tech considerations I’m open to your preferred stack—Electro...

...receiving inbound loads, staging outbound orders, keeping stock rotated, and making sure every pallet meets temperature and shelf-life requirements before it leaves the dock. Because freight moves both in and out every day, you’ll also coordinate with carriers and 3PL partners so trucks are booked, paperwork is ready, and any delays are flagged early. Day-to-day you will: • Update the WMS / Excel sheets in real time as product arrives or ships. • Prepare all transport documents—BOLs, packing lists, customs forms—so drivers never wait. • Track each shipment’s location and temperature data, sharing quick status notes with me and our customers. • Maintain clean, organized pick faces and follow FIFO to eliminate spoilage. Accept...

I need an Excel-based rework tracker that captures every instance of rework on our manufacturing lines and then converts that raw data into a clear, automated weekly performance summary. Here’s what I’m picturing: • A clean input sheet where operators or supervisors log part number, date, shift, defect type, root cause, quantity and any comments. . Tracker needs to show what’s in the inventory. Meaning it will have to add all the same type of rework and subtract when input says rework is done. Both type of input will be manual entry. • Behind the scenes, formulas or Power Query consolidate the entries and a macro (or similar one-click routine) refreshes all calculations and charts. • A “Weekly Report” tab that automatically rolls up KPIs...

I need a reliable partner to help me gather two specific data sets—resident details...distribute it to society committees (or their appointed representatives), follow up to maximise response rates, and then collate everything into a clean, well-labelled spreadsheet ready for analysis. Deliverables • A shareable online survey link that mirrors the approved questionnaire • A status log showing which societies have responded and which still need follow-up • A consolidated Excel or Google Sheets file containing all collected resident details and maintenance records, with duplicates removed and fields properly validated I will review and accept the work once the dataset covers at least 90 % of the targeted societies and passes a random spot-check for a...

I need a full production-ready tech pack for a T-...approval on the first pass. The pack must clearly document stitching construction, exact label and hang-tag positions, plus all print or embroidery placements with colour call-outs and scale. Front, back and detail views should be laid out in an illustrator-friendly file (AI or layered PDF) and paired with a spec sheet in Excel or Google Sheets so measurements stay editable. Deliverables • Illustrated tech pack (AI/PDF) with call-outs • Measurement/spec sheet (Excel/Sheets) linked to illustrations • Colour-separated artwork files for prints or embroidery I’ll review for completeness, consistency between pages, and factory readability before sign-off. Let me know your typical turnaround and a...

I’m sitting on a spreadsheet full of customer records that look like a ransom note—random upper-case bursts, all-lowercase names, and addresses that flip...take a quick web pass—open the customer’s own site or a reputable directory to confirm the spelling of the company name and primary contact. If something clearly doesn’t match, flag it. • Deliver the cleaned file in the same structure I provide (likely Excel or Google Sheets) plus a brief change log noting any records you had to flag or couldn’t verify. Acceptance is simple: no stray caps, consistent casing throughout, and a sheet free of obvious errors once spot-checked. I expect this to be a straightforward scrub, so if you have strong Excel, Google Sheets, or OpenRefine skills...

I’m running TallyPrime and all of my stock items are already organised by product type. The challenge is that some products need more than one HSN code, depending on where or how they are dispatched, yet I still want to keep a single master item to pres...class), and the system must respect all of TallyPrime’s native tax calculations. Acceptance criteria • One stock item can hold two or more HSN codes. • At voucher time the intended HSN can be selected or auto-applied, and the chosen code prints on invoices and populates GST returns. • No loss of existing batch, MRP, or stock ageing data. • Works entirely inside TallyPrime (no external Excel macros). If you’ve created similar TallyPrime customisations—especially using TD...

I’m commissioning a slick, 30–45-second promotional video that instantly signals “premium” to prospective clients of my influencer-marketing agency. The core objective is simple: amplify brand awareness by showing, not telling, how our data-dri...video in 16:9 and 9:16 (H.264, 1080p minimum). 2. Editable project files (Premiere Pro or After Effects). 3. Separate clean version for captioning plus SRT file. 4. Simple style guide summarising fonts, colours and music licence. Acceptance criteria: smooth pacing, no clip or audio artefacts, consistent colour grade, and growth metrics visually prominent for at least three seconds. If you excel at snappy storytelling, kinetic typography and sharp digital-marketing visuals, let’s get started—I&rsqu...

...master Excel or Google Sheets workbook. Once the sheet is tidy, every contact detail—name, phone, email, and address—has to be cross-checked against reliable web sources to make sure the data is accurate and up to date. When the verification step is done, the final workbook must follow my formatting guidelines (column order, header style, conditional colour coding). I will share a short style guide and a small sample so you can mirror the look and feel exactly. Deliverables • Cleaned and consolidated customer-info spreadsheet • Column-by-column log of any corrections made, including URLs or screenshots that confirm each updated contact detail • Final file delivered in Excel and Google Sheets formats, formatted to the provided guidelines...

...converted into a single, well-structured Excel workbook. Some of these PDFs contain selectable text you can copy directly, while others are scanned images that will require reliable OCR before the content can be placed in the spreadsheet. I will supply an Excel template with pre-defined columns and formatting guidelines; your task is to populate it faithfully, preserving line breaks and text order exactly as they appear in the source. I expect clean, error-free entries, so please use tools you trust—Adobe Acrobat, ABBYY FineReader, or any OCR software that delivers high accuracy—then proof the result before saving. If any characters remain unclear after OCR, create a brief comment log noting the page number and context. Deliverables • Completed Excel...

I have several spreadsheets full of plain text that need to be entered into a new master sheet exactly as specified. Your job is to work through each row, copy or type the text into the designated columns, keep original spelling / capitalisation intact, and flag anything that looks incomplete or duplicated. You’ll be working directly in Excel or Google Sheets, so familiarity with basic functions—filter, find-and-replace, simple formulas for counts—is important for speed and consistency. I will share the source files, a template of the final sheet, and a brief field-mapping guide as soon as we start. Deliverable: the completed master spreadsheet with every entry transferred and a short note listing any rows you marked for review. Accuracy comes first; once tha...

...re-typed into clean, editable files. The pages include plenty of numbers as well as text, so precision is critical—every figure has to match the source exactly. A steady typing speed of 35–60 wpm is fine as long as accuracy stays high throughout. Microsoft Word and, where tables or calculations appear, Microsoft Excel should be used so the final files mirror the original layout and can be searched, edited, and archived easily. Deliverables • One properly formatted Word or Excel file for each scanned page • Correct spelling, punctuation, and—most importantly—error-free numerical data • File names that follow the original document order for straightforward cross-checking I will review the work by comparing it against the ...

...must be transferred, line by line, into a structured Excel workbook. The task is entirely text-based—no numbers or calculations—so accuracy in spelling, punctuation, and spacing is essential. I will supply the PDFs and a template spreadsheet with the required column headers. Your job is to read each PDF, capture the relevant text exactly as it appears, and place it in the corresponding cells. If a PDF page includes headers, footers, or incidental content, leave those out unless I flag them as needed. Deliverables: • Completed Excel file populated with the extracted text • A brief note highlighting any unreadable characters or ambiguous passages Before starting, confirm you can open standard PDFs and work comfortably in Microsoft Excel (or ...

I need a clean, gap-free OHLC data set for the Nifty 50 index on a 1-minute timeframe covering 1 January 2020 right up to the end of the current trading day. I will supply an Excel template that already lists every required timestamp; simply populate the Open, High, Low and Close columns against each row. Key points • Source must be Zerodha only (Kite historical API or another Zerodha-backed feed). • No extra fields are necessary—just the four price columns. • Final delivery should be the same workbook returned to me in .xlsx format, ready for immediate use. Before we wrap up, I’ll verify the file for missing intervals, incorrect time zones (IST), or obvious outliers. Once everything checks out, the job is complete.

I need a clean, well-structured Excel database pulled from Google Maps that contains automotive upholstery workshops (bengkel jok mobil), car-interior restoration services, and sellers of headliner fabric across Jakarta, Tangerang, Bandung, and every other city on the island of Java. Please extract only three fields—Nama usaha, Nomor telepon, and Alamat lengkap—and drop any listing that does not show a phone number. In addition, keep just the businesses that pass a minimum-review threshold; I will confirm the exact number with you before you begin so you can apply the filter directly during scraping rather than post-processing. The final deliverable is a single Excel file, neatly organised in separate columns and free of duplicates. My target deadline is withi...

...posted transaction must satisfy: Total Debits = Total Credits. Posted transactions must not be silently edited or deleted. Corrections must use proper reversal/adjustment procedures. 3. Cashbook & Banking Cash and petty cash Bank accounts Credit cards Receipts/payments Deposits/withdrawals Transfers Customer/supplier payments Bank reconciliation Statement vs book balance Reconciliation history CSV/Excel bank imports Architecture should support future bank-feed integrations. 4. Accounts Receivable Customer records Contacts/addresses Credit limits Payment terms Sales invoices Credit/debit notes Customer payments Partial payments Payment allocation Refunds Discounts Overpayments Customer statements A/R aging Outstanding invoices Customer balances 5. Accounts Payable Supplier/ve...

...project data is NOT required. No fake or incorrect mobile numbers will be accepted. No fake or invalid email IDs will be accepted. Chairman/Secretary/Managing Committee contact number is mandatory for every society. Email ID is mandatory for every society. No duplicate society records will be accepted. Google Maps/location details must be provided. Data must be submitted in a properly organized Excel or Google Sheets format. The freelancer should provide regular progress updates during the project. Freelancer should systematically cover different areas of Pune and Pimpri-Chinchwad to achieve the target. Required Data for Each Society The following information is required for every housing society: Society Name Complete Address Area / Locality Google Maps Location Approximate Nu...

...economists work across consulting firms, government departments, central banks, think tanks, and policy institutions. The courses emphasize real-world case studies, hands-on analytical tools, and practical applications, covering topics like competition economics, macroeconomic forecasting, and public policy evaluation. In addition, the program fosters essential technical and professional skills, such as Excel modelling, data analysis, and effective economic writing, empowering students to enhance their employability and confidently navigate real-world economic challenges. Role Description This is a remote contract role for a Competition Economist. The role involves working with the founder to create case studies based on the person's experience. These case studies ...

...sources include: * Official organization websites * Government websites * Foundation websites * Annual reports * Grant announcements * LinkedIn * Procurement websites * University websites * Press releases * Official event websites Please include source links. If something cannot be confirmed, mark it: **Unverified** Do not invent or guess information. ## Final Deliverable Please provide one Excel or Google Sheets workbook containing: ### Tab 1 – Organizations The 15–20 organizations and all research. ### Tab 2 – Decision Makers Names, positions, contact information, LinkedIn, and sources. ### Tab 3 – Funding & Opportunities Grants, previous awards, contracts, RFPs, events, and other useful findings. ### Tab 4 – Top 5 Your five str...

Don’t bid if you don’t have an example of a...Development • Healing • Meditation • Visualization • Tasawwur • Tasawwur-e-Ism-e-Allah Zaat • Asma-ul-Husna • Dhikr & Remembrance of Allah • Tazkiyah (Self-Purification) • Islamic Spiritual Development • Sufi Teachings Deliverables: - • 150 backlinks per month • Unique referring domains • Unique IP addresses • URL of backlink placement • Domain metrics (DR/DA if available) • Monthly report in Excel or Google Sheets Important Please provide: 1. Examples of previous backlink work. 2. Sample websites where links will be placed. 3. Your monthly price for 150 backlinks. 4. Estimated indexing rate. 5. Whether backlinks are manually created. Only ...

I provide reliable virtual administrative support to help businesses stay organized and efficient. I can manage emails, organize inboxes, enter and verify data in Excel, schedule and coordinate appointments, and prepare documents using Microsoft Office. My focus is accuracy, fast response times, organization, and attention to detail. I can follow instructions carefully, manage multiple tasks, identify calendar conflicts, maintain consistent data formatting, and handle repetitive administrative work efficiently. I am comfortable working independently, communicating professionally, and adapting to new systems and workflows. I aim to provide dependable day-to-day support while helping reduce administrative workload and keep operations running smoothly.

...now sits in an online database into our updated system. I will export the records as spreadsheet files and send them to you as email attachments; you’ll open each file, verify every field, and enter the data into the new platform with consistent formatting and zero omissions. Because these files contain private contact details, confidentiality is critical. You should already be comfortable with Excel or Google Sheets and able to spot duplicates, flag missing information, and follow the simple naming conventions I’ll provide. Accuracy and speed matter more to me than raw volume, but I’d like a daily status note so I can track progress. I’m looking for a Nepal-based freelancer who can start right away and let me know roughly how many rows you can handle pe...

...repetitive clicks and produce complex calculation models behind the scenes. I will supply the raw workbooks and explain the logic I follow today; you will translate that logic into dynamic formulas (INDEX/MATCH, SUMPRODUCT, LET, XLOOKUP, array functions, or whichever functions make the solution clean and future-proof). The end result should be a model I can hand to non-technical colleagues—no VBA or macros this time, just powerful native formulas that run everything automatically as soon as new data is pasted in. Deliverables • Updated workbooks with clearly labeled, audited formula chains • Brief inline comments or a one-page guide so I can tweak ranges or assumptions later If you’ve built similar formula-driven models before and enjoy squeezing ...

I have a short PDF (between 1 – 10 pages) that contains nothing but straightforward, linear text. I need every word moved into a single column in an .xlsx file while keeping the original sequence intact—no omissions, no re-ordering, and absolutely no spelling alter...bolding them or leaving an empty row before each one so they remain easy to spot. Key points you must follow: • Proof-read while you transfer: if the OCR has swapped characters (e.g., “I” for “1”, “rn” for “m”), quietly correct them. • Do not try to recreate any layout; one continuous column is all that’s required. • Final delivery is a clean .xlsx file, ready to open in the latest version of Excel. I value high accuracy over speed, s...

I have a set of online databases that need to be mined and transcribed into a single, well-structured Excel spreadsheet. The records contain a mix of text fields and numeric values—company names, addresses, IDs, dates, prices, and similar content—so careful attention to formatting is essential. I will provide: • Direct links or login credentials for each database • A template workbook that defines the exact column order and data-validation rules Your job is to: • Retrieve each record from the specified sources • Copy every text and number field accurately, preserving spelling, capitalization, and numerical precision • Populate the workbook sheet-by-sheet, adhering to the template’s data types, drop-downs, and conditional formats ...

My workbook needs a clean, single-page entry form—built entirely in VBA—that pushes every submission straight into a master data sheet. The form will capture mixed data, so text, numbers and dates all have to slot neatly into their respective columns without manual cleanup. Key functions to weave in: • Data validation that blocks bad formats on the spot • Dropdown lists for controlled choices • Auto-population of fields that can be derived from existing entries or reference tables • Well-commented VBA code tying it all together, including the macro that writes records to the master sheet The interface should load instantly when the file opens, resize gracefully on different screens and clear itself after each save. I’ll sign off once new re...

...tables or bullet points. Your task is straightforward: open each PDF, isolate every word from the specified two sections, and enter the material accurately into an Excel workbook I’ll provide. Each PDF should occupy its own row, with separate columns for the Introduction and for the Summary so I can filter and sort later. Accuracy is critical: line breaks do not matter, but every sentence and keyword must be captured exactly as written, without omissions, additions, or spelling changes. If a file is unreadable or the required sections are missing, note that clearly in the sheet rather than guessing. Deliverables • Completed Excel file populated with the extracted Introduction and Summary text for all PDFs • A brief log (simple text is fine) flagging ...

...focus will be: • Entering the numbers into clearly structured Microsoft Excel spreadsheets, following my column layout and file-naming conventions. • Cleaning and organizing the data as you go—removing duplicates, standardizing number formats, fixing obvious inconsistencies, and flagging anything that looks questionable. Accuracy is critical; totals must reconcile and every record must line up with its source. I will provide the raw files, the target template, and brief written guidelines. Regular check-ins over chat or email keep us on schedule, and I expect the first batch turned around within two days of receipt. If we work well together, there will be additional datasets to process. Proficiency in Excel functions such as conditional formatting,...

I am looking for an experienced data cleaning specialist to review, clean, standardize, and organize raw datasets into accurate, analysis-ready files. The project may involve Excel, CSV, Google Sheets, or similar structured data. The ideal freelancer should be comfortable working with large datasets and identifying inconsistencies without changing the underlying meaning of the data. Accuracy, attention to detail, and data confidentiality are essential. Key Tasks Clean and standardize raw datasets. Identify and remove duplicate records. Correct formatting and inconsistent data entries. Handle missing, blank, or incomplete values appropriately. Standardize names, addresses, dates, phone numbers, and categorical fields. Identify and correct obvious typographical errors. Check numeric...

...including cost-centre allocation. 14. REPORTS & DASHBOARDS Dashboards should include: Total employees Joinings/exits Payroll cost Department/project-wise payroll Attendance Leave PF/ESIC/TDS Contract expiry Pending approvals Reports: Employee Master Attendance Leave Salary Register Payroll Summary Payslip Register PF ESIC TDS Project-wise payroll Cost-centre-wise payroll Exit/F&F Contract expiry Excel/PDF export required. 15. SECURITY & ACCESS Roles: Super Admin HR Payroll/Finance HR Manager Reporting Manager Employee Management Employees should only see their own data; managers their teams; Finance/HR only relevant information. Required: Role-based access HTTPS/SSL Audit trail Change tracking Login history Backup/recovery Restricted access to salary, bank...

I need the content of several PDF files—each combining text fields like names or descriptions with associated numbers such as quantities and prices—typed cleanly into a single Excel spreadsheet. I will share a simple template so every column lines up the same way across all records. Accuracy is more important than speed: dates must stay in date format, currency values in number format, and spellings must match the source exactly. Once the transfer is complete, give the file a quick pass using Excel’s basic validations (filters, totals) to catch obvious slips before you return it. If any figure is hard to read or a label seems unclear, flag the cell in yellow so I can double-check later. Deliverable: • One fully populated .xlsx file that mirrors the PDFs, rea...

...(Python & Excel) Overview: A complete, automated system designed to streamline gym operations, track memberships, and monitor financial health. Built using a powerful combination of Python and Excel, this project removes the manual guesswork from daily gym administration, allowing owners to focus on their clients. Key Features: Automated Fee Tracking: Easily monitor which members have paid for the current month and quickly identify outstanding dues. Financial Tracking (P&L): Built-in Profit & Loss formulas to give gym owners an instant, accurate view of their revenue and expenses. Member Database: Organized, structured data management for quick access to member records and renewal dates. Data Integration: Smooth interaction between Python ...

I’m refining a full business plan as the foundation for stepping into a CEO role, and the missing piece is a rock-solid set of financials. Specifically, I need detailed cash flow projections that slot neatly into the broader plan and can stand up to investor scrutiny. Here’s what I’m after: • A dynamic 3-to-5-year cash flow model in Excel or Google Sheets, complete with clear assumptions, sensitivity toggles, and automated visuals. • Line-item breakdowns for operating, investing, and financing activities so I can pinpoint working-capital needs month by month. • Brief, bulletproof commentary I can drop straight into the Financial Projections section of the plan—explaining key drivers, seasonality, and risk mitigation. • A quick walkt...

I’m putting together a showcase-worthy sales workbook for my Data Entry & Excel portfolio and need an expert touch. The dataset is retail-focused and will be a mix of records I supply and additional, realistic entries you create to round it out. Everything must live in a single Excel file and look clean, consistent, and professional. Here’s what I’m after: • A well-structured table that holds customer and product details, quantities, unit prices, order dates, payment status, and a calculated line total. • Thorough data cleaning and formatting so every field is validated, dates align to one format, and currency values carry two decimals. • Built-in formulas (SUMIFS, COUNTIFS, IF, XLOOKUP or similar) for automatic totals. • Sort...

...export containing about 500 rows of electronics sales data that I need entered into a clean, easy-to-share file. The export arrives as standard .sql/.csv dumps straight from MySQL, so you’ll be working directly with those raw tables. Your job is to lift every field—order date, SKU, product name, quantity, price, customer region and any discount codes—and place them into the template I provide (Excel or Google Sheet, whichever you prefer). Accuracy is critical: the final sheet has to match the source values exactly, preserve any leading zeros, and carry over special characters. Deliverables • Completed spreadsheet with all 500 sales records properly mapped to the template headers • A brief note explaining any anomalies you spot (e.g., missing ...

I have a sizeable set of financial data that needs to be turned into a clean, well-structured workbook ready for immediate reporting or deeper analysis. Here is what I need done: • Data cleaning: remove every duplicate entry and correct any inconsistent formats so dates, currency, and percentages all display uniformly. • Logical organisation: sort and filter the data into an intuitive layout that anyone on my team can follow at a glance. • Formula layer: build a solid framework of Sum, Average, IF statements, plus VLOOKUP and HLOOKUP so common comparisons and roll-ups are automatic. • Final polish: apply clear headings, freeze panes, and light conditional formatting so key figures stand out without clutter. The finished file should open with no warnings, pass ba...

...granny flat and shed. New planting along the southern fence. Integrated drainage, irrigation and exterior lighting. The final package must include construction drawings, dimensions, levels, sections, planting plans, full plant schedule, irrigation plan, lighting plan, material schedule, quantity take-off, approximate labour hours, construction details, 3D visualisations and editable DWG/3D/Excel files. The existing house, pool, proposed granny flat and proposed shed must remain in their documented locations. Applicants must provide a recognised Landscape Architecture qualification, examples of comparable residential construction-documentation projects, a sample drawing set, methodology, fixed fee, timeline, revision allowance and clear exclusions. Applications provi...