Program sort excel file työt

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be share...

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

Buget: $150 Steps: 1) Find 5 vision models that does semantic segmentation. Could be from: , or other sources. Important: models should be recent (from the last 9 years: 2015-2024), well known and having an research article about the model with results. Because we are going to benchmark them and get new results. Make sure all found models can be executed and re-trained in the free version of Google Colab using GPU environment. Models should not be too big or complex, it should comply with Google Colab free version limits. 2) Create a free version of Google Colab notebook using GPU environment. In notebook do the following: 2.1) change each model's

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essence and p...

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

I need an expert in Solid Works CAD, specifically proficient with STEP files, to help with revising my current plastic enclosure design file. Your task will involve adding drill holes in the specified areas on the plastic enclosure model. Key Tasks: - Making additions of drill holes, specifically on the top of the plastic enclosure. - The placement of these holes must be relative to other components. - Save the revision to a STEP file. - Create a 2D PDF document highlighting the measurements of each hole that was added. Ideal Candidate: - Detailed understanding of Solid Works CAD. - Proven experience with STEP files. - Ability to extrapolate relative positioning of drill holes. - Proficiency in creating 2D PDF documents. In your application, please include your experienc...

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look forward to seein...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

...seeking a skilled programmer with experience in FORTRAN IV to develop a computer program that simulates the behavior of flames under various conditions. This project is currently in the initial concept and design phase, and I require both the creation of the program and a detailed write-up on the algorithm and methodology. Key Requirements: - Proficient in FORTRAN IV programming. - Strong understanding of combustion processes and multiple-flame systems. - Ability to translate complex combustion models into efficient code. - Experience with scientific programming and algorithm development. Project Scope: - **Development of a Multiple-Flame Combustion Model**: The core task is to develop a FORTRAN IV computer program capable of simulating flame behavior in differe...

...with different products, then put his address files in etc. and finally the bot needs to create a crypto invoice for the cryptocurrency of choice at current price and wait for payment confirmation from the crypto pay gate. Finally, once the order is confirmed, the bot needs to process all order information into a .txt or .csv file and save it locally on the machine. The script should also be able to decrypt PGP encrypted address information automatically. 2) Some sort of APIs between the bot script and all the messengers desktop sessions listed above that allow the bot script to communicate with each messenger. The purpose of this is to allow running regular non-business, non-shop affiliated messenger accounts as effective bot shops. I do NOT want to use shop-affiliated i...

I am seeking an experienced Wikipedia editor who can help me create a WikiPage about myself. The focus of this page will encompass: - My professional achievements - Educational and Certification background - Personal hobbies and passions - Philanthropic & volunteer work - Addition of about 200 article and podcast links available online This p...should provide proper citations and ensure a neutral tone throughout the WikiPage as per Wikipedia's norms. You MUST provide me with reference material you have already created if you don't your bid goes in the rubbish bin. I will provide you with my bio. I have a one-in-the-world name that will make your research very easy, every Google hit for my name will be about me, so you don't need to sort me out from all the ot...

...exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeli...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data analysis - ...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and resolve data entry issues Understanding of data privacy a...

Need to upgrade my existing excel macro, very simple project

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

I'm seeking an Android developer to create a chat application that supports file sharing and offline messaging capabilities. Key Responsibilities: - Develop an Android chat application - Implement a file sharing feature within the chat - Include a system for offline messaging Ideal Skills: - Proficient in Android development - Experience in implementing file sharing and offline messaging in apps - Excellent understanding of chat applications' workflows and designs. The goal here is to ensure seamless communication with efficient file sharing even while offline.

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with develo...

I'm launching a loyalty program and need a modern, minimalist website and mobile app to facilitate it. This will be an integral part of my business and it needs to be done right. Here's what I'm looking for: *User Registration: A secure area for customers to create their own accounts. *Points Tracking: System to keep track of customers' accrued points. *Rewards Redemption: A mechanism to allow customers to trade in their points for rewards. *Lucky Draw: Periodically, there will be lucky draws for members. *Social Media Integration: The platform should support Integration with Facebook and Instagram for wider customer reach and efficient communication. I'm looking for a freelancer with solid experience in developing loyalty websites/apps, clean an...

We're in need of a ...item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search is not working. When new user is create a Confirmation email should be sent with password. Implement Forgot password. All this is done on an out of box blazer application. and no fancy application or complex coding, just basic. Hence, I have a fix budget of INR 1250 rupees. Message only if you are interested to wrok on this with price. File for the project will be s...

I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.

I'm in need of a professional to download content from my Pinterest account and sort the images by theme for personal use. Their primary duty will be to segregate the images, ensuring they are carefully differentiated and organized. Subsequently, all the pictures should be stored in JPEG format. The ideal freelancer for this project should: - Have experience with Pinterest image downloading - Know how to organize digital photos effectively - Be adept in managing files, particularly JPEG file type With proper categorization by theme, I anticipate easy accessibility and improved personal usage of the images.

...that the main page has main search on all items in all stores. - you can access any store, each individual store has its own search, category list, offers, most bought. - It also has auctions for items. - Each list must have refining option (price, time of post, (if cars then mileage, make year, and car brand) (if food then type of food ) (if clothes then size, color, type)). - "it also has sort by<> price option" - It also has live streams for marketing product and auctions It also has posts. You van post and items have comments, likes, and share option. - now the customer has a profile he/she can follow a store, save an item, make comments and like posts - live streams should avoid smart detection of any misbehavior on streams - live streams should can ...

...write an upload/download tool for usenet in the first step. Thank you! My Requirements are: -Combine the settings of the programs mentioned (ngPost, Nyuu, NewsUP, SabNZBd) -download functions like the program "sabNZBd" -for Windows (With a proper installation routine and as an .exe file!!) -Python -NNTP (Network News Transfer Protocol) -modern GUI and a nice logo :) -source code, commenting on the source code properly ! -expandable ! -API usage -work with rss feeds -Periodic check if files still complete -option for hidden autostart -The program is supposed to download a certain sort of links like url use with an browser or pdf with an pdf viewer -rar/7zip support -multipar support () -automate posts by scanning folder(s) -auto delete files/fold...

This job requires programming experience to create and design an app based on the attached PowerPoint where I have detailed each page of the app. The data needed for the app will be supplied in an Excel file. The bid is to create the app for both iPhone and Android. App programming and graphic design experience is mandatory for this project and will require more than a basic knowledge of app creation. The rough project should be completed in 1-2 months. Please review the PowerPoint as it has very detailed information and don't hesitate to ask any questions.

macro based excel project with auto copy data and paste in chrome through selinium

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

Hello, We are looking for a freelancer or company to repair and import a SQL Server corrupted file (about 25 Gb) corresponding to a MS Dynamics 2008 database. The file is generating the error "File size property incorrect" while trying to import (see attached file). Please let us know if you have some experience with similar recovery. Due to the size of the file we will need you to work remotely on our system directly.

Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5...overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file ...

... THEME 2 Both themes are made by the same designer, so coding should be similar. I already own both themes and can provide the code. Most Important changes (but not limited to) - Sitewide: I want titles/description to display over thumbs with a transparent background, and drop down when hovered over (as in theme #1) - I want the sort buttons shown at the top of each page in Theme 1 to replace the ugly drop down sort menu in theme 2. - I want the header menu (but transparent) from THEME 1 - Video Page: I want the video page layout/style from theme 1 - Video Page: I want “models” to display as they do in Theme 1, but slightly tweaked: both models on one row, side by side…as opposed to on top of each other - a Few other changes that would be easier to e...

I'm in need of a proficient Data Entry operator who can efficiently handle tasks like data entry, content management, and file organization on a daily basis. The job requires some familiarity with basic Web and Network technologies like Wordpress, Godaddy, etc . General understanding of website operation are needed. Workloads will vary, as the work requirements are not on a fixed schedule or volume. Proficiency with data related software is highly advantageous. Excel knowledge is must. If worked on Tools like Zoho etc, it will be preferred.

I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.

I'm in need of a Python programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requir...programmer skilled in web scraping to help me extract text content from mostly text-based PDF files. Requirements: - Extensive experience in Python and specifically Python libraries for web scraping. - Should deliver the extracted text content in an Excel file. Ideal Skills: - Experience in PDF scraping, especially text-based. - Strong Python programming skills. - Excel file formatting. This will involve working with mostly text-based PDFs and programming a Python script to scrape the text content, and subsequently placing that data into an Excel file. Experience with similar projects will be highly adva...

Is a task require basic Excel skills with four tasks in total need it in 5-6 hours

I require a qualified specialist to generate sales leads for my green fertiliser project targeted at farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website codi...farmers, agricultural businesses, and gardeners in the UK. Your tasks will include: - Enhancing visibility through SEO optimisation - Website coding in PHP - Creating engaging and informative web content and blogs - Using LinkedIn Sales Navigator for lead generation Your understanding of the farming world will be a great asset for this project. Delivery of the sales leads should be through an Excel spreadsheet, Emails, and my CRM platform. Past experience in a similar role, particularly within the agricultural industry, will be highly...

I am looking for a developer to create a multilingual WhatsApp chatbot. The chatbot must be built on Twilio, and should be capable of answering user queries promptly and effectively in both Arabic and English. Skills and experience needed for this project: - Proficiency in chatbot development, specifically on the Twilio platform - Experience in designing chatbots that excel in query resolution - Strong command of both Arabic and English in a development context Please make sure to highlight any similar projects you've completed in your proposal, with specific details on chatbot functionality and multilingual support.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful c...

I have a Korean version of the PPT file. I want to convert it to an Adobe AI file for printing. There are also BitMap graphics, so I will need to do a good job when converting them. I need to create the AI file to be at least 3000 px vertical for printing.

The website will be an eCommerce platform for a unisex cosmetics store. Targeted towards both men and women, the website will feature diverse products for a wide audience. Key Requirements: - Create a Product Catalog: Should be designed to accommodate 100-500 different cosmetics products with options for customers to sort and filter based on their preference. - Integrate Customer Reviews: A section where customers can leave reviews on the products they've bought, which will ensure transparency and foster trust. Ideal Skills: - Experience in eCommerce website development - Knowledge and comprehension of efficient product catalog design - Experience with customer review mechanisms - Understand gender-inclusive design principles.

I'm looking for an experienced Power BI professional to help me create an interactive and insightful dashboard. Here's a brief of what I need: - Implement Interactive Dashboards: With emphasis on user engagement, the dashboards should be interactive and user-friendly. - Data Visualization: The dashboard should visually represent the data from Excel spreadsheets in a clean, easy-to-understand format. - Interactive Charts & Drill-Down features: I want a dashboard where users can interact with charts and explore detailed views of our data. Ideal Skills: - Experience in Power BI - Proficient in data visualization - Deft with interactive chart development, and drill-down feature set up Your task is to guide me on how to create this, using an existing example as ...

i have excel framework that contains multiple user inputs the convert the outputs to a graphs and charts i need to convert the excel sheet to a website.

I'm seeking a knowledgeable individual to help me navigate and set up NovelCrafter for writing my novel. Key tasks include: 1. Facilitating a Codex setup 2. Guiding the development characters 3. Crafting a program layout. I will need assistance in importing elements of my existing novel into the new structure, as well as ongoing support as I create new content. Ideal skills & experience: - Familiarity with NovelCrafter and its unique features and functions - A background in literature or creative writing - A keen understanding of character development - Good teaching ability, to empower me to take over the project independently Candidates should be available to start immediately as the project completion is required ASAP.

I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would make you a standout candidat...