Excel admin task

100.0 GBP

100.0 GBP peopleperhour Technology & Programming Overseas
5 hour ago

Description

I have a spreadsheet with approx 500 rows.
Each row contains information that I need organised into multiple rows.
for example, a row may contain the following information: (/ indicates a column)
BIBRCALWconfig / SKU / BIBRCALW / colour / White / SKU / BIBRCALBL / colour / Black
The 1st column is our main part number and needs to appear in column A for each subsequent row. It also needs to appear on its own in the row above.The rows need to be split by the SKU. For example the result for the exmapl above would be...
BIBRCALWconfigBIBRCALWconfig / SKU / BIBRCALW / colour / WhiteBIBRCALWconfig / SKU / BIBRCALBL / colour / Black
Please see attached spreadsheet, the 1st 3 products have been complete to show you how we require the rest of the data.

Go Now
关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Project Title Integration & Workflow Optimization: Karbon → QBO → GoCardless Project Overview We are an accountancy firm that: Uses QuickBooks Online (QBO) for invoicing. Collects payments via GoCardless (direct debit). Manages clients and workflow in Karbon (currently not used for invoicing or time-based billing). Key Goals Centralize Time Tracking & Billing in Karbon Standardize workflow so invoices generate in Karbon (leveraging timesheets for profitability). Handle annual fee increases, margin adjustments, and variable pricing in Karbon. Sync to QBO & GoCardless Karbon invoices automatically sync to QBO. GoCardless integration in QBO continues for DD collection. Payment status is visible in QBO and/or Karbon. Improve Profitability Analysis Use Karbon’s time data to review client profitability. Integrate into an annual fee-setting process (bulk updates to client fees). Training & Documentation Provide training for staff on new billing and reporting processes. Document integrations and custom configurations. Current Environment & Pain Points QBO + GoCardless: Invoices managed directly in QBO; GoCardless handles recurring DD. Karbon (CRM): Central client/workflow platform, not used for billing or standardized time tracking. Pricing Complexity: Varying fees, annual increases, different payment methods, and recharged software costs with different margins. Reporting Challenges: Profitability reviews are manual and time-consuming. Project Objectives Consolidate Billing in Karbon Create invoices in Karbon using timesheets to determine billing amounts. Automate fee increases and margin adjustments. Streamline Data Flow (Karbon → QBO → GoCardless) Finalized Karbon invoices sync to QBO seamlessly. Keep GoCardless recurring DD triggered via QBO. Ensure payment status flows back for easy reconciliation. Profitability Analysis & Annual Review Export or report on Karbon time data (staff cost rates) for profitability. Support bulk fee updates in Karbon. Create dashboards or reports to guide pricing adjustments. Training & Documentation Train staff on billing, time tracking, and fee updates in Karbon. Provide SOPs on the new workflows. Scope of Work Phase 1: Discovery & Planning Review Karbon, QBO, and GoCardless setups. Map out final workflow: timesheet entry → invoice creation in Karbon → sync to QBO → DD collection → reconciliation. Deliverables: Workflow diagram, implementation plan, timeline. List of required plugins/tools. Phase 2: Configuration & Integration Karbon Timesheet Setup: Establish service categories, cost rates, and client engagement tracking. Karbon Invoicing: Configure recurring and ad hoc invoice templates, including logic for annual and margin-based increases. Karbon–QBO Integration: Sync finalized invoices and confirm accurate client/product mapping. QBO–GoCardless: Ensure existing DD processes trigger from newly synced invoices. Deliverables: Fully functional Karbon–QBO integration. Tested sample invoices covering multiple billing scenarios. Documentation on creating/updating clients, margins, and annual fee increases. Phase 3: Reporting & Profitability Analysis Set up or configure reporting in Karbon, QBO, or a BI tool (e.g., Power BI). Generate reports on hours logged vs. invoiced costs. Provide data exports or dashboards for year-end fee reviews. Deliverables: Custom reports/dashboards for profitability. Documentation on running/interpreting reports. Phase 4: Training & Handover Conduct training (remote/recorded) for staff. Provide SOPs covering the entire billing process, annual fee increases, and margin updates. Handover meeting to finalize knowledge transfer. Deliverables: Training sessions (recorded or live). Written SOPs and user guides. Technical Requirements Strong familiarity with Karbon, QBO, and GoCardless integrations. Ability to configure Karbon timesheets, invoicing, and QBO syncing (API work, middleware like Zapier/Make). Experience with accounting workflows and fee structures. Skilled in documentation and staff training. Proposal Requirements Background & Experience: Emphasize previous Karbon/QBO projects. Approach & Methodology: Outline strategy for each project phase. Proposed Timeline: Phase-wise estimates and go-live target. Itemized Pricing: Cost per phase + any support fees. References/Case Studies: Examples of similar work. Evaluation Criteria Understanding of Karbon–QBO integration and accounting firm needs. Proven track record in billing and profitability workflows. Clear, comprehensive project approach. Transparent pricing. Relevant references/testimonials.
3000.0 GBP Technology & Programming peopleperhour Overseas
2 days ago
We are a software company. For one of our projects we need to download information from a website containing articles about medical topics. The website contains cca. 10000 HTML pages of paged listing of articles in Czech language. The list contains titles of articles, each title having a link to the detail HTML page with the article text. We need someone to produce wget and other scripts and download the titles of all articles, parse the links from those titles, download the detailed pages of the articles and distill the text that is shown in the page. The titles as well as the detail pages mostly have the same structure so this allows for an automated work. But it is not so in 100% cases, there may be several types of structure so it may require some attention as to how to distill the correct information. The result of this work will be a set of static HTML files. You can view this structure under https://fomenot.com/z/dwld24/main.html I.e. the result will contain the contents of the article separated into paragraphs of normal text and captions (nothing else, no images or other texts). We only want the main text of the article that is visible on the screen for the user. No other text or html content. Another result will be the raw HTML output for each of the detail pages For accepting the output, we will do our check of the result. If we find errors, we will give examples of these errors and we will expect the vendor to fix all such errors in the result, not just those examples. If there are only a few errors we may not be able to find them and it is ok. But if we find any we will require correcting them. We expect that the raw HTML files will be 100% error free (for these we will not give examples, we just would demand fixing them). For the text-based results we will give examples before demanding to fix them. An example of such a source page you can find here: https://www.idnes.cz/onadnes/zdravi/2 You can see a list of articles, each having a link leading to the detail and then a paging control that can load more articles from the next page. This is NOT the page we need to download but similar. Putting here the example only that you understand what is the task. Let us know if you could do it and for what price. We will provide the real links to the selected candidate.
250.0 EUR Technology & Programming peopleperhour Overseas
2 hour ago

HuntsBot,a one-stop outsourcing task, remote job, product ideas sharing and subscription platform, which supports DingTalk, Lark, WeCom, Email and Telegram robot subscription. The platform will push outsourcing task requirements, remote work opportunities, product ideas to every subscribed user with timely, stable and reliable.

简体中文 English

Platform

Support

Links

Contact US

Any questions or suggestions during use, you can contact us in the following ways:

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.