Minitab formulas jobs

...to build that dashboard directly inside my existing file. I want the data to stay live, so please rely on formulas, pivot tables or connected ranges rather than static copies. The key feature I’m after is INTERACTIVE FILTERS: I should be able to slice the view quickly by date, category and account to understand cash flow at a glance. If you feel a small chart or summary table would clarify a point, you’re welcome to include it, but the interactivity is the priority. Deliverables • A polished Google Sheets dashboard that updates automatically as I add new rows • Slicers or another native Sheets filtering method that lets me toggle period, category and account without breaking formulas • A short note in the sheet explaining where to paste f...

...or annual granularity that I can toggle • Debt module that accommodates interest-only, amortizing, or refinance scenarios and feeds correctly into the cash-flow waterfall • Sensitivity tables or data-table toggles for at least rental growth, exit cap rate, and interest rate • Clear, well-labeled summary dashboard pulling the key metrics I’ll use for day-to-day decisions Please keep the formulas transparent—no hard-coded numbers outside a clearly marked assumptions tab—and organise the workbook so I can later duplicate it for mixed-use deals that combine retail, office, and residential components without rebuilding from scratch. Send the model unlocked, along with a short read-me or loom walkthrough showing how to adjust the main drivers an...

I have a set of PDF documents that contain text-based tables, and I need every cell of those tables copied into the matching fields of an Exce...blank or illegible cells should be flagged in a separate “Notes” column rather than guessed. When you return the finished workbook I’ll spot-check it against the source PDFs; a clean comparison with no misaligned rows or typos will be the acceptance criterion. Familiarity with Excel functions like wrap text, text-to-columns, and basic data validation will make the task easier, but no advanced formulas are required. Send back the completed Excel file together with a brief log of any issues you encountered (for example, unreadable characters or missing pages). Once I confirm everything lines up perfectly, I’ll re...

My beauty and wellness label, Ruvera, is ready to turn our essential-oil range into scroll-stopping Reels and I’m looking for a part-time creator who can jump in right away. Your main focus will be short-form, product-showcase Reels that capture our clean, minimalist aesthetic while ...will help you thrive: familiarity with mobile-first tools like CapCut, Canva or Lightroom, a genuine passion for wellness, and the ability to hit quick turnaround targets—ASAP delivery is the priority for our launch calendar. In return, you’ll shape the voice of a growing label, work remotely to your own schedule, and receive premium Ruvera products to feature and enjoy. If showcasing beautiful formulas in aesthetic, engaging Reels sounds like your style, I’d love to see a qui...

I need an end-to-end Excel solution that turns my raw operational data into clear, action-oriented insights. The workbook should import or paste data easily, clean it behind the scenes, then surface the story through a mix of charts, pivot tables, and an interactive dashboard. Here’s what I expect to receive: • A structured data model ready for refresh without breaking formulas or links • Dynamic pivot tables that let me slice performance by date, department, and any additional fields you spot as valuable • Visually consistent charts and graphs that highlight trends, outliers, and KPI progress • A dashboard page with slicers, drop-downs, or buttons so non-technical users can explore the numbers themselves • Clear documentation of any VBA, ...

...the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas. Deliverables • Fully populated Google Sheets file with all source data entered exactly as provided • Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges • Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your e...

...duplicate rows, fixing inconsistent SKU and product name spellings, and aligning column structures—before combining them into a single master workbook. Once the data is unified, I need it laid out in a clear, standardised structure and enhanced with conditional formatting so key variances (such as cost changes or missing prices) stand out immediately. Feel free to leverage Power Query, advanced formulas, or VBA if it speeds things up; just be sure the final workbook remains easy for a non-technical user to maintain. Deliverables • One Excel workbook containing all price data, fully de-duplicated and merged. • Consistent column order, naming, and data types across every tab. • Conditional formatting rules that highlight outliers, blanks, and cost v...

My beauty and wellness label, Ruvera, is ready to turn our essential-oil range into scroll-stopping Reels and I’m looking for a part-time creator who can jump in right away. Your main focus will be short-form, product-showcase Reels that capture our clean, minimalist aesthetic while ...will help you thrive: familiarity with mobile-first tools like CapCut, Canva or Lightroom, a genuine passion for wellness, and the ability to hit quick turnaround targets—ASAP delivery is the priority for our launch calendar. In return, you’ll shape the voice of a growing label, work remotely to your own schedule, and receive premium Ruvera products to feature and enjoy. If showcasing beautiful formulas in aesthetic, engaging Reels sounds like your style, I’d love to see a qui...

...the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas. Deliverables • Fully populated Google Sheets file with all source data entered exactly as provided • Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges • Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your e...

...Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in 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 a...

...the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas. Deliverables • Fully populated Google Sheets file with all source data entered exactly as provided • Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges • Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your e...

...columns that perform calculations based on conditional logic drawn from the existing data. I will share the file along with a brief description of the rules each column should follow so you can drop in the formulas, test them, and ensure they update dynamically as new rows are added. What I need from you: • Insert the two new columns in the correct place without disturbing current formatting. • Build the custom conditional formulas exactly to spec (I’ll outline the “if-this-then-that” rules). • Confirm the results are accurate across several sample scenarios and that the formulas remain intact when the sheet is filtered, sorted, or extended. If you have a knack for efficient spreadsheet logic in Excel or Google Sheets, this s...

I need an Excel model for financial forecasting, specifically for patient modeling. Key Requirements: - Financial forecasting expertise - Experience in patient modeling - Proficiency in Excel Ideal Skills and Experience: - Strong background in financial modeling - Familiarity with healthcare data and metrics - Advanced Excel skills, including formulas and data visualization Please provide examples of similar work done.

...that works as long as it stays up to date. • The output should be easy to export—CSV or an Excel sheet is fine—so I can drop the figures straight into my accounting software later. • A small dashboard or at least a clear command-line summary that flags anomalies (negative net pay, unusually high deductions, etc.) would be a plus. Deliverables 1. Source code or spreadsheet template with all formulas visible. 2. A short setup guide that walks me from raw employee roster to final tax amounts in one pay cycle. 3. Sample data file showing five fictitious employees for testing. Acceptance criteria • Running your solution with the sample data reproduces the same totals you provide in the guide. • Tax tables can be updated without rewriting...

...month (ideally formatted so I can PDF it straight from the sheet) At this stage the only source you have to deal with is the manually entered bank records—no extra validation rules are required beyond the standard accuracy that comes with solid formulas and clear cell protection. As our process matures, I may add other data feeds later, so please structure the workbook so additional connections (CSV import or direct database links) can be slotted in without a full rebuild. Deliverables 1. Fully functional spreadsheet (Excel preferred) with all formulas, pivot tables or Power Query steps documented in-file 2. Step-by-step notes so I can update the source data, refresh the monthly view, and export the underwriter report without extra help 3. A quick test run us...

...true data extraction from images or PDFs. Every captured value then needs to be placed into a structured Google Sheets document I’ll share before we begin, with the columns already labeled for you. Accuracy is more important than speed: spellings, figures, and any special characters must match the source exactly. Please retain the original order of the rows so the data aligns with my existing formulas in adjacent sheets. Deliverable • A complete, clean Google Sheets file populated with all entries from the supplied online sources, ready for immediate use....

...Google Sheet. Before anything goes in, each numerical field has to be checked against the specific upper- and lower-bound ranges I’ll provide; if a value falls outside that range, simply flag it in a separate “Issues” column instead of altering it. The flow is straightforward: validate, enter, double-check. You may rely on Google Sheets’ built-in 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 a...

...that shared field so I can view, sort and report on recruitment progress in one place instead of two. Here is what I need from you: • Move the data from the two source sheets into a new Smartsheet, mapping every column accurately. • Use “Study Site by Country” as the key to eliminate duplicates and align rows coming from each file. • Preserve existing dropdowns, conditional formatting and formulas, or rebuild them inside Smartsheet when direct copying is not possible. • Add light summary metrics at the top (totals per country and an overall recruitment count) so I can see progress at a glance. • Provide a brief hand-off note explaining any cross-sheet references you set up, so I can maintain or refresh the sheet later without help. ...

...into Excel and formatted so the sheet is clear, logical, and ready for analysis. Each record must land in the correct column, with headings aligned and consistent styling applied throughout. Data-accuracy checks are essential: I’ll need you to validate numeric fields, flag anomalies, and ensure no duplicates slip through. Basic functions such as sort, filter, conditional formatting, and simple formulas will help keep everything tidy. Deliverables: • A fully populated Excel workbook with clean, labeled columns and rows • Built-in accuracy checks (e.g., data validation rules, error highlights) • A brief note summarizing any issues found and how they were resolved If you’re detail-oriented and comfortable working in Microsoft Excel, I’...

The project centers on a manually-entered sales spreadsheet that requires a full Excel-based analysis focused on monthly sales performance. I will...professional charts—line, clustered column, or a pivot chart—must then visualise month-over-month results so trends and anomalies are unmistakable at a glance. Deliverables • Cleaned Excel file with all transformation steps traceable • Pivot table dashboard summarising monthly sales performance • Chart sheet highlighting key trends with brief written commentary (1-2 paragraphs) Accuracy of formulas, readable field naming, and a layout that lets non-technical managers drill down without altering the structure will be the yardsticks for acceptance. Feel free to suggest additional breakdowns if they s...

I need a single Excel workbook that can build and police our small team’s roster for me. At its core the sheet must: • Calculate each employee’s daily and weekly hours automatically and highlight anyone who ends up rostered for more than seven straight days. • Apply additional rule-based ...without manual re-wiring. I’m happy for you to use native Excel functions, dynamic arrays, Power Query and/or lightweight VBA—whatever keeps the file fast, easy to maintain and secure. A brief control panel where I can type new business rules (days-off limits, weekend shift length, paid-time-off codes) would be ideal. Please include a detailed project proposal outlining your approach, key formulas or macro steps, and an estimated timeline so I can see ...

...professional who understands the MTD/PCB Computerised Payroll System inside out. Your main task will be to help our team to finalise every calculation before the file goes to the officers at LHDN. I want an expert eye on the logic behind the figures, cross-checking every field so that the submission aligns 100 % with current LHDN guidelines. Scope of work • Review the existing payroll and tax formulas inside the CPS file. • Validate each step against the latest LHDN compliance notes. • Correct or flag any discrepancies, then prepare the clean, fully documented accreditation packet ready for upload. Acceptance criteria • All calculations pass LHDN’s automated validation without error. • Supporting notes clearly map each figure to t...

I need an Excel file to track my stock investments. The file should be able to import data from CSV files. all need to be automated updation of from data pulling from website(free source) to putting systematically store and integrate that data in excel by dat...that data in excel by date order and there after process with below ratios. I should be able compare past data outcomes with new one also Essential features include: - Key Ratios: Beta, Alpha, Sharpe Ratio, Portfolio Beta, Variance, Standard Deviation - Visualizations: Line Charts to display the data trends Ideal Skills and Experience: - Proficiency in Excel, especially in creating complex formulas and importing CSV data - Experience with financial metrics and investment tracking - Ability to create clear and informative l...

I need focused validation applied to one of my Excel workbooks so every field only accepts the information it is meant to hold. The goal is to prevent bad entries at the source and flag anything that slips through before it causes downstream issues. You can expect to work directly inside an .xlsx file I will provide, create the necessary Data Validation rules—drop-downs, custom formulas, dependent lists, or any other built-in options—and return the sheet ready for everyday use. If it makes sense, feel free to suggest complementary touches like quick error-checking messages or gentle input restrictions for related columns, but the core deliverable must remain rock-solid validation. When you reply, please link to past work that shows you have already set up or audited va...

I have a raw set of customer records that must move from messy spreadsheets to a structured, analysis-ready format. The job starts in Excel—think Power Query, advanced formulas, or VBA for quick wins—then shifts to Python (Pandas, NumPy, openpyxl) so the process can run automatically whenever fresh data arrives. Here’s what I need from you: first, clean and normalise the fields (remove duplicates, unify date and address formats, fill or flag missing values). Next, reshape the information into tidy tables that feed our reporting model. Finally, package everything into a repeatable Python script that reads the latest file, runs the full transformation pipeline, and exports polished XLSX/CSV outputs along with a simple log of what changed. Deliverables • One ...

...the sheet must automatically calculate key performance indicators using the built-in IRR and NPV functions. Once the records are in place I should be able to adjust any cash-flow figure and see the updated returns instantly, so please structure the worksheet with clear cash-in, cash-out and date columns linked to those formulas. Deliverables • Fully populated Google Sheets file with all source data entered exactly as provided • Correctly configured IRR() and NPV() formulas referencing dynamic cash-flow ranges • Quick note inside the sheet (or a short Loom clip, if you prefer) explaining where to add future transactions without breaking the calculations I’ll share the raw files and a field-by-field mapping right after kickoff. Let me know your e...

...The model must cover a single fiscal year and flow seamlessly from the Income Statement through the Balance Sheet into the Cash Flow Statement, with schedules for working capital, capex, and debt clearly feeding back into the core sheets. Because this will underpin my own discounted cash-flow and multiple-based checks, accuracy and transparency are critical. Please build in clean, traceable formulas, keep hard-codes isolated, and structure the file so assumptions can be tweaked without breaking the model. I typically work in Excel, so deliver in .xlsx with no macros unless absolutely necessary. Deliverables • Integrated 1-year Income Statement, Balance Sheet, and Cash Flow Statement • Assumption sheet with drivers clearly labeled • Automatic valuation o...

I need an Excel spreadsheet to track driver hours and overtime. Requirements: - Daily working hours, overtime hours, and totals for the month. - Data presented in a clear, organized spreadsheet format. - Include formulas for: - Sum of hours - Overtime calculations Ideal Skills and Experience: - Proficiency in Excel - Experience creating tracking spreadsheets - Strong attention to detail Looking forward to your bids!

I’m looking...file should be easy to expand; I’ll probably add and archive habits over time, so formulas, tables or pivot-based solutions that scale without much manual tinkering are essential. A polished, at-a-glance dashboard (think conditional formatting, percentage rings or bar visuals) that rolls up performance for the current month and lets me compare previous months would be perfect. Deliverables: • Fully-functional .xlsx habit tracker with integrated charts, graphs and progress bars • Auto-updating dashboard summarising monthly completion status and total time spent • Brief, step-by-step notes showing how to add new habits or extend the date range No need for macros if the same outcome can be achieved with formulas, but I’m ope...

I’m pulling together several small research datasets and need one reliable person who can do two things equally well. First, you’ll take the raw numbers I supply, enter them with perfect accuracy into my Google Sheets template, double-checking formulas as you go. This is classic spreadsheet data entry: clear headings, no stray spaces, every cell formatted correctly for later analysis. Once each sheet is complete, you’ll 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 ...

My beauty and wellness label, Ruvera, is ready to turn our essential-oil range into scroll-stopping Reels and I’m looking for a part-time creator who can jump in right away. Your main focus will be short-form, product-showcase Reels that capture our clean, minimalist aesthetic while ...will help you thrive: familiarity with mobile-first tools like CapCut, Canva or Lightroom, a genuine passion for wellness, and the ability to hit quick turnaround targets—ASAP delivery is the priority for our launch calendar. In return, you’ll shape the voice of a growing label, work remotely to your own schedule, and receive premium Ruvera products to feature and enjoy. If showcasing beautiful formulas in aesthetic, engaging Reels sounds like your style, I’d love to see a qui...

I have a small batch of printed pages—no more than fifty—that need to be keyed into a clean, editable digital format. The originals will be provided as high-resolution scans, so everything is clearly legible; what matters most is accurate transcription and consistent formatting. The work is pure text data entry. There are no tables, formulas, or complicated layouts—just straightforward paragraphs that should read exactly as they appear on the page, free of typos. Spelling, punctuation, and line breaks must match the source unless I indicate otherwise. Deliverables: • A single Microsoft Word file (or Google Docs if preferred) containing the full, proof-read transcription • A brief note highlighting any uncertain words or smudged sections you encounter ...

I have several raw data files that need to be organised in Excel so the information is accurate, searchable, and presentation-ready. The core of the job is straightforward: • Enter data from PDFs and text documents into Excel with zero transcription errors. • Clean and f...analytical views (filters, sorts, conditional formatting) work smoothly. I will provide the source files and a brief for each sheet. All work should stay within Excel; no third-party add-ins are required. Turnaround for the first batch is three days, and I’m happy to review interim files as you progress to ensure we stay aligned. If you’re comfortable with meticulous data entry, know your way around formulas like VLOOKUP/XLOOKUP, SUMIF(S), and can present tidy, well-labelled spreadsheets...

...we start. The sheet already contains 500 company names; every row simply needs three additional fields completed: primary contact name, work email, and direct phone number. Your job is to research each company, locate an appropriate contact (ideally someone in sales, marketing, or leadership), and enter the verified details in the designated columns without changing the existing formatting or formulas. Please use reliable public sources, company sites, or professional networks to ensure the information is current and accurate. Deliverable: • My Google Sheets file returned with all 500 rows fully populated, consistent capitalization, and no broken email formats. • Anything you could not verify should be clearly flagged for quick follow-up. A fast, detail-oriented ap...

I need an easy-to-navigate e-book that works as a quick-look reference manual for everyday Excel work. The focus is on two core areas—Formulas & Functions and the built-in Data Analysis tools—and I only want a basic but well-organized overview for each. Think of it as something a user can flip open, spend two minutes skimming, and walk away knowing which feature to try next. Here’s what matters most to me: • A clean structure with a clickable table of contents so readers can jump straight to VLOOKUP, SUMIFS, PivotTables, or the Analysis Toolpak without hunting around. • Plain-language explanations supported by one or two concise examples per topic rather than deep theory. • Screenshots or annotated images where a picture saves paragraphs of ...

I have an existing list of photos that holds roughly 1,500 rows of mix...provide—please set those headings in bold so they stand out. • Accurate transfer of every record I send you: around 1,500 rows containing only text and number values. • A single .xlsx file as the final deliverable (a CSV saved from that sheet is fine as an optional extra). The sheet is used primarily for ongoing data entry, so simplicity and consistency matter more than elaborate formatting. No formulas or calculations are required, but the layout must mirror the source exactly so my team can slot new rows in without adjusting anything. If you are meticulous with data entry, comfortable working in Excel, and can complete the rebuild quickly, I’m ready to send over the source material and...

I need a straightforward platform that lets me enter raw exam scores, have them graded automatically, and release the final results to students in a clean, secure interface. The grading engine has to support three schemes out of the box—CGPA, traditional letter grades, and a simple pass/fail toggle—so I can choose the one that fits each course without rewriting formulas every term. Grade boundaries, GPA weightings, and pass thresholds must stay fully editable from an admin panel. Once the marks are processed, the system should publish them to a student-facing portal where each learner can log in and view only their own transcript. A printable report and optional CSV/PDF export will help when we need physical copies or bulk data sharing. Role-based authentication, a smal...

...and website content updates. Must be willing to take instructions over the phone. Key Responsibilities * Create, edit, and manage Excel spreadsheets * Perform data entry, formatting, and organisation within Excel * Assist with content uploading and editing on a Squarespace website * Follow the instructions provided over phone calls Required Skills & Experience * Strong Microsoft Excel knowledge (formulas, formatting, data organisation) * Experience with Squarespace website editing and content management * Excellent spoken English communication * Ability to understand instructions provided verbally via phone * Strong organisational skills and attention to detail * Reliable internet connection and ability to work remotely Location Requirement Applicants must be based in Austral...

I have a raw set of customer records that must move from messy spreadsheets to a structured, analysis-ready format. The job starts in Excel—think Power Query, advanced formulas, or VBA for quick wins—then shifts to Python (Pandas, NumPy, openpyxl) so the process can run automatically whenever fresh data arrives. Here’s what I need from you: first, clean and normalise the fields (remove duplicates, unify date and address formats, fill or flag missing values). Next, reshape the information into tidy tables that feed our reporting model. Finally, package everything into a repeatable Python script that reads the latest file, runs the full transformation pipeline, and exports polished XLSX/CSV outputs along with a simple log of what changed. Deliverables • One ...

I have a small sales dataset that needs to be transformed into a clear, at-a-glance dashboard in Excel. Here is exactly what I’m after: • Re-organize the raw data into a tidy, structured table that will be easy for me to update later. • Calculate and display...and display three headline figures—Total sales, Number of transactions, and Average sale value—so they stand out immediately. • Create a concise summary panel that pulls those key numbers together. • Add one straightforward Pie chart to visualise the breakdown of sales. • Keep everything on a single, well-formatted worksheet so colleagues can open the file and understand it instantly. All formulas should be transparent and editable; please avoid hard-coding. When finished, s...

...a clear, actionable picture of how we are performing. The core focus is on revenue- and profit-related metrics (sales volumes, margins, growth rates, month-over-month comparisons, year-to-date figures, etc.). I will supply the workbooks exactly as they stand; your job is to turn those rows and columns into insight. The process I have in mind starts with cleaning and structuring the sheets so formulas, pivot tables, or a preferred analytics script (Python / Pandas, R, Power Query—whatever you are comfortable with) can run without errors. Once the data is solid, I’d like to see: • A concise summary of key revenue and profit indicators, spotlighting any spikes, dips, or anomalies. • Visuals that speak for themselves—charts or dashboards embedded in Ex...

I need a clear, spreadsheet-based financial model that tells me exactly how cash will move in and out of the business from day one and shows, in days, when my original investment is likely to be recovered. Here is what I expect the model to cover: • Total upfront i...calculation that converts cumulative cash flow into “days to recover investment,” so I can instantly see how long it takes before the venture is cash-positive. The structure should be flexible enough for me to swap in figures for different product lines—think of the samosa example I gave—while keeping the logic intact. Please develop the file in Excel or Google Sheets with clean, readable formulas (no hard-coded numbers hidden in calculations) and include a concise user guide tab so ...

I have a raw set of customer records that must move from messy spreadsheets to a structured, analysis-ready format. The job starts in Excel—think Power Query, advanced formulas, or VBA for quick wins—then shifts to Python (Pandas, NumPy, openpyxl) so the process can run automatically whenever fresh data arrives. Here’s what I need from you: first, clean and normalise the fields (remove duplicates, unify date and address formats, fill or flag missing values). Next, reshape the information into tidy tables that feed our reporting model. Finally, package everything into a repeatable Python script that reads the latest file, runs the full transformation pipeline, and exports polished XLSX/CSV outputs along with a simple log of what changed. Deliverables • One ...

...can edit. • Sales tracking must aggregate daily, weekly, and monthly totals in a separate “Sales” tab and appear in AppSheet dashboards. • Supplier management should let me view supplier contact info, last purchase date, and reorder lead time from inside the app. Deliverables - A Google Sheet structured with Products, Suppliers, Transactions, and Sales summary tabs, including all required formulas or Apps Script triggers. - An AppSheet app connected to that sheet with barcode scanning enabled for product in/out, conditional logic for stock alerts, and summary dashboards. - Short Loom or similar walkthrough video plus a PDF quick-start guide so my team can hit the ground running. Success criteria • Scanning a product reduces stock, logs a s...

I need an interactive Power BI dashboard built from Excel/CSV exports that I’ll provide. The sole focus is customer engagement, so the model and visuals should surface churn, retention, active-user trends, session frequency, and any other insight you recommend for quickly reading engagement health. You’ll co...desktop and the Power BI Service. The report must refresh seamlessly whenever I replace the source files and come with a short note explaining tables, relationships, and calculated measures so I can extend it later. Deliverables: • Finished .pbix file with the customer-engagement dashboard • Instructions for refreshing with new Excel/CSV data • Brief documentation of data model and key DAX formulas Please share any similar work you’ve ...

...can edit. • Sales tracking must aggregate daily, weekly, and monthly totals in a separate “Sales” tab and appear in AppSheet dashboards. • Supplier management should let me view supplier contact info, last purchase date, and reorder lead time from inside the app. Deliverables - A Google Sheet structured with Products, Suppliers, Transactions, and Sales summary tabs, including all required formulas or Apps Script triggers. - An AppSheet app connected to that sheet with barcode scanning enabled for product in/out, conditional logic for stock alerts, and summary dashboards. - Short Loom or similar walkthrough video plus a PDF quick-start guide so my team can hit the ground running. Success criteria • Scanning a product reduces stock, logs a s...

I need a web-based portal that lets my cosmetics clients log in securely, create a new product entry, and work through a simple, guided checklist to upload every file needed for compliance—formulas, packaging artwork, test reports, manufacturer certificates, and more. For them the essentials are straightforward: a “Create Product” button that instantly opens a dedicated folder and an intuitive drag-and-drop zone to add PDF, Word (DOC/DOCX), or Excel (XLS/XLSX) documents. On my side, the regulatory team must be able to see each dossier in a clean dashboard, follow its progress, leave notes, request missing items, and finally mark it as “Approved” or “Needs Revision.” Automated status updates should appear in the client’s view so they ...

I need a clean, professional‐looking Excel dashboard dedicated to financial analysis, with the emphasis on budget forecasting. All underlying sheets are ready; what’s missing is an intuitive front-end that lets me monitor how actual spendin...tools you prefer—PivotTables, named ranges, Power Query, slicers, even a bit of VBA if that streamlines refreshes—so long as the file remains fully editable in the latest Microsoft 365 desktop version. Interactive elements or automated report snippets are welcome bonuses, but polished visuals are the non-negotiable deliverable. Once complete I will review the workbook for clarity, accuracy of formulas, and ease of updating. If figures, labels or colour choices need minor tweaks, we’ll iterate quickly until the dashboa...

I need all mixed data—numbers and text—lifted accurately from a PDF and placed into Google Sheets. Once the transfer is complete, I expect advanced formatting: formulas where they add value and conditional formatting set up to highlight any duplicate entries automatically. Deliverables: • A Google Sheet populated with every record from the PDF, checked for integrity • Conditional-formatting rule that flags duplicates clearly • Any supporting formulas documented in-cell or with a brief note so I can tweak them later Attention to detail is critical; the sheet should be ready for immediate analysis the moment you hand it back.

I need help populating a fresh Google Sheet with mixed data—both text entries and numbers—exactly as I supply them. Everything will be typed directly into the online spreadsheet; no offline files are involv...directly into the online spreadsheet; no offline files are involved. Accuracy is my top priority, so I’ll share the source material and simply want it transcribed without omissions or extra characters. You’ll receive view-and-edit access to the sheet the moment we start. Once the data is in, a quick pass to ensure column alignment and consistent cell content is all I’m looking for; no special formulas or complex formatting are required at this stage. Deliverable: a fully populated Google Sheet reflecting every item from my source notes, ready for...