How to filter a csv file in excel jobs
I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.
I've got a 14-minute audio file in the M4A format that is incredibly faint – almost like someone whispering. The task I need completed involves amplifying this recording enough that I can discern what's being said. The whole recording requires this enhancement, so your solution needs to be comprehensive, making the entire clip clearly audible. Notably, there's no noticeable background noise to be worried about, just the issue of the main audio being too soft. Ideal candidates for this project should have: - Strong skills with audio editing and enhancement - Experience working with M4A files - Expertise in noise reduction and audio clarity improvement Your task will be to achieve a clear and loud enough audio...
I'm seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount....
Website scrape. - I am looking to scrape data from a website to gather data - The timeframe for obtaining the requested data is 3 to 5 days - I would like the data back in Excel or CSV format - The total # of items to be scraped will total some 6000 rows with 9 columns
...with opening a Quickbooks file that was saved in 2009. The file contains important financial data which I urgently need to access. I am currently using Reckon Accounts 2013 Pro and did not keep the earlier versions of the Quicken software. Based in Australia, I have evidence that I own the company who owns the Quickbook file and the software registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. In addition to a Reckon ...
I'm seeking a skilled web developer to craft a modern and clean website primarily for sharing information and content targeted towards food lovers. Skills & Experience: • Proficiency in modern website design techniques. • Experience creating websites tailored towards a younger demographic. • Ability to create an aesthetic that's clean and modern. • Knowledgeable in web analytics and SEO to maximize reach. Objective: • Create a visually appealing, user-friendly website. • Ensuring the produced website is functional and easy to navigate. • Incorporating elements that pique the interest of young adults. The end result should be a site where users can effortlessly a...
I am in need of an experienced data entry specialist who can assist me with entering basic data into Excel. The data to be entered will be from handwritten notes. Ideal skills and experience for the job: - Proficient in Excel for basic data entry and formatting - Detail-oriented with high accuracy in entering data - Ability to work with handwritten notes - Good communication skills to clarify data points if needed
I'm in need of someone adept in bookkeeping, expense tracking, and financial reporting. You don't have to have experience in a specific software, but being proficient in tools like QuickBooks, Excel, and Xero would be ideal. I need the Account Assistant to handle: - Bookkeeping - Expense Tracking - Financial Reporting In your proposal, please include: - Details of your past work and experience in similar roles - A detailed project proposal outlining how you'll carry out the tasks I'm excited to hear from you, and start working together on this project.
I'm in need of an advanced stock trading tool, equipped with numerous features for an effective investment experience. Key Features: - Real-time data updates: This tool should provide me with real-time updates on stock and option chain data. - Portfolio Management: The tool should offer an efficient system for managing my family and friends portfolios specifically with a filter for selling weekly covered calls and buying protective puts. Analysis and Reporting: - Adjustable alerts: An automated alarm system that forewarns when parity hits a set threshold value. Access: - The tool should be conveniently accessible. I'm open to a paid download or a password-secured website. Ideal Candidate: - Experience with financial softwar...
I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regress...
I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skill...
Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.
Here is a list of about 300 publishers (press houses). Your job is to find a contact email address or/and online form for authors to submit a book proposal for each of the publishers on the list. Most of them have an online form. Get the www link. For each of them, get a contact email address. If there is no email address for authors, get some other general contact email address of the press. You will submit an Excel file with three columns: name of the publisher, email, www link with a form (if there is an online form). In this list I provided, for some publushers there are two names (left and right) or more than two names (one left and several right). In these cases of multiple names, you just need t...
I have python script to copy title and keywords from excel sheet to image metadata , I need to add category to subject filed and price to comment filed so excel sheet will be title , keywords , category , price , data will be copied to image metadata
We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and...
I'm looking for an expert in Wordpress theme customization. I need changes to the homepage layout of my website, specifically a design shift to a full-width layout with banner. But the bigger task is the introduction of a custom functionality. I need a filter integrated directly on the homepage that will cater to a specific user group - females. Key tasks include: - Only show Females on Home Page for Top Members - Only show females with pics in Latest Registered Members - Remove Public Message Button & Make Private Message Button Red and BIGGER - Put a private message button on photo - City use default value "Medellin" and change to a dropdown - Search results on hom...
I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel...
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
I'm looking for a custom PHP script that can collect and store information from a simple form, and appropriately filter and display the data stored in a database. This script is intended to be used for my job site for a new residential property build. Key elements and tasks include: - Collecting and storing data from a simple form. - Implementing a database to store the collected information. - Ability to filter information. - Displaying filtered information on simple pages. Ideal candidates should have experience in: - PHP scripting. - Database management and implementation. - Web development. - Previous experience in creating a similar system would be a plus.
I need a robust order management web application with a strong focus on order tracking, inventory management, and order uploading capabilities. The application should be able to import orders from a CSV file, xlsx file , track the status of each order, and update it when necessary. In addition, it should provide me with insightful inventory and order history reports, enabling us to monitor our stock levels and analyze our order trends effectively. Ideally, freelancers would have prior experience in web application development, with a particular emphasis on order and inventory management solutions. Some knowledge of CSV file manipulation and report generation would be a definite plus. Major Ta...
Consolidated Sales Calendar report put in excel spread sheet.
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send remin...
I need a skilled professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance m...
Someone to edit 1000 illustrator files. I have a template created. I need to have the picture and name replaced (these are provided in google drive). You need to save each file individually as a pdf. These edits are VERY easy. Template file is attached. We only need the front page. Would like to complete first 400 by tomorrow.
...WordPress developer to make precise changes to my WooCommerce e-commerce website. Here are the two key areas I need addressed: - Product Filtering: An addition of advanced filter options for my products is important for enhancing users' browsing experience. I need filters for price range, color, and brand to simplify the search process for my customers. - Design Improvement: I am aiming for an aesthetically appealing site to engage users, hence I need the layout and navigation enhanced. Adding visually appealing elements is essential, and the improvement of mobile responsiveness is also a priority to cater to mobile users. To succeed in this task, you should be proficient in WordPress and English for...
...AMOUNT YOU INTEND TO DO THE WORK FOR *** *** PLEASE DO NOT CONTACT US OUTSIDE OF THE FREELANCER CHAT SYSTEM. UNSOLICITED EMAILS WILL BE IGNORED AND REPORTED *** We're experiencing problems with duplicate results when using a SELECT query in the context of retrieving data from multiple tables in MySQL. I require assistance getting this resolved. The query selects data against two tables. The selection must compare Invoice Details with PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Ite...
I need a skilled web designer capable of creating an informational website, which is visually appealing yet straightforward. Drawing inspiration from a website I'll provide, I'd love to see minimalistic design elements, not only in the site layout but also in the to-be-created logo and graphics. Key specifications and features include: - An attractive landing page: Hook the visitors with a clean, inviting design and meaningful content. - Simple yet effective search engine: That allows users to filter through - Graphic design expertise: Design a minimalistic logo and provide relevant graphics for the site. The overall design aesthetic should be coherent and reflect my brand. - Contact forms: Incorporate int...
I'm in need of an expert in data visualization to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize ...
Research paper on "Future of Runways and Fashion Weeks: How AI Will Redefining Luxury Consumer Experience & Engagement" 10 year scenario plan. Around 60 pages. Time: finished by next week.
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
I'm in need of a talented individual who can build a Python script for me. The ideal candidate would have demonstrated experience dealing with: - Information retrieval from potentially chaotic and unstructured scanned images and PDF files. - The ability to extract and segregate text, images, and tables. - Output the extracted data into a organized CSV file format. Expertise in Python is a prerequisite for this task. A knack for navigating unstructured data and strong knowledge in data extraction would be valuable to ensure a comprehensive approach to this task. Experience with Optical Character Recognition (OCR) could be beneficial too. If this sounds like your kind of challenge, do ge...
Need someone who can analize data from a excel and contact customer with missing data
Edit a photo, quick job More details: What specific changes or edits do you need to be made to the photo file? This question was skipped What information should successful freelancers include in their application? Past work What format do you prefer for the final delivery of the photo file? JPEG
...for someone who can help me implement certain features in my RISE CRM site. If you are not familiar with RISE CRM, this is RISE: This RISE site is going to be SaaS and will use this plugin for that: I want some help to create a custom plugin but also some customization of some existing modules. Here are some details about creating a plugin for RISE:
I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working w...
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. ...
I am looking for an expert in .NET Core application development to Integrate Hangfire into a .NET Core web application for background job scheduling, focusing on configuring Hangfire with SQL Server, setting up dependency injection for job and CSV generation services, and defining job logic for various recurring tasks. This task includes implementing a secure Hangfire Dashboard for job monitoring and management, and creating specific recurring jobs (e.g., monthly, hourly) with logic tailored to business needs, such as generating CSV files. Ensure the solution encompasses database setup instructions for Hangfire, adherence to best practices in job scheduling, and thorough testing of job configurations and executions.
I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this sheets data to be used to determine if a project is currently occupied and to generate a weekly time report by project and employee. - Determine project occupancy: The solution should utilize the check-in/out times to determine whether a project is currently occupied or not. -Occupancy: Displayed on a Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are fre...
I'm in need of an expert blender artist who has background in 3D modelling. The task will involve importing a GLB file into a program called ReadyPlayer. I'm searching for someone who has conducted tasks like this in the past and who has a depth of understanding in this area. Key Skills and Experience: - Extensive experience in 3D modelling - Proficient in blender - Knowledge in GLB file import Interested freelancers are encouraged to apply and include their previous similar experiences. This will aid me in understanding your capabilities and ultimately, deciding who is the best fit. High-quality work is of course a crucial aspect, but so too is the ability to commu...
I am in need of an expert PHP 5.3 developer to provide API integration for my project. The developer will specifically be responsible for the following: - Integration of a File Upload API - Facilitating the upload of documents using this API The ideal candidate for this project would have proficient skills and experience in PHP 5.3 development and API integrations, with a particular focus on File Upload APIs. It would be beneficial if the freelancer has previously worked on projects that involved uploading documents. Strong problem-solving skills and attention to detail are crucial for this role.
I have created 12 editable post not 15,so just send 75 dollars
As the client, I need expertise in transferring .tgz files from Docker images to my Windows 11 computer, specifically the D drive. Requirements: - Experience with Docker - Familiarity with Windows 11 file management system - Knowledge on .tgz files Furthermore, the .tgz files range in size from 100MB to 1GB, so adequate bandwidth and storage must be ensured for successful transfer. Your bid should reflect the complexity of this task including the mentioned requirements. Any additional suggestions to improve the transfer process are welcome.
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
I am currently in need of a talented individual experienced in graphic design, particularly in resizing designs and preparing them for printing. The scope of the project includes: There are 324 pages, each page has 4 labels. Need someone to resize each of the labels to 4"x5" (FILE 1 Attached, will provide complete file later) And put them together for ready to print (See file FINAL EXAMPLE FILE) Successful candidates must include their expertise and experience related to the task as per the application. Experience working with resizing and preparing images for large format printing is highly advantageous.
I'm seeking an expert who can decrypt an AES encrypted .cap file. The file contains encrypted data I need to access for educational purposes. Key requirements include: - Expertise in decrypting AES encrypted files - Ability to efficiently and securely recover the data from the .cap file - Strong commitment to data privacy and confidentiality Please provide examples of similar work you have done in the past, and outline your proposed approach to this task.
I'm in need of a Python developer, experienced in SQlite databases, to build a music file deduplicator tool for my media collection. Key Functionalities: * The tool must identify duplicate music files, informing the user promptly about any match with existing items in the database. * When duplicates are encountered, the tool should not automatically delete but rather prompt me for the next action. Critical Features: * Display full details of the duplicate files detected for user analysis. * Provide a preview of the duplicate files before any proposed action is taken. Ideal candidates should have a solid grasp of Python and SQlite development, and proven experience in creating file management tools. An u...
