Excel spreadsheet test data jobs
I'm looking for a skilled Perl expert to help me remove duplicates in an Excel dataset. The removal process should be based on multiple columns, ensuring a thorough cleanup. Ideal Skills & Experience: - Strong proficiency in Perl programming - Proficiency in data analysis - Expertise in Excel and handling large datasets - Prior experience in removing duplicates from Excel based on multiple columns Communication: I prefer to have project updates through video calls, so please be comfortable with this form of communication. Your ability to walk me through the process will be highly appreciated.
We are seeking an experienced...closing module are handled individually by company, ensuring that only the relevant sessions for the company to which the user has access are displayed. Improved Closing Data: Correct and enhance data collection during the closing process, ensuring that partial payments and payments from other sessions are accurately recorded and reported. Integration with Expense Module: Enhance the integration of the expense module with the account closing system so that expenses are automatically recorded within the corresponding session and correctly reflected in closing reports. Deliverables: Updated and documented source code. Test reports demonstrating the proper functionality of the applied corrections. Detailed technical documentation outlining...
I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.
1. Set a timer to trigger at the specified time X minutes after the start of the trading session. 2. When the timer triggers, capture the closing price of the most recent 1-minute candle. 3. Calculate the buy and sell entry prices as (+X) pips and (-X) pips from the captured ...position as well based on strategy inputs. 8. In manual mode, use the price provided by the user as the initial price instead of capturing the 1-minute candle closing price. 9. If there is an existing open position, the strategy should be able to detect it and use it for further calculations as described above. * I should get strategy notifications "email & audio alerts. * I should be able to back-test & optimize using FXCM TradeStation desktop. * Do you provide NDA to the strategy? * Do you prov...
...first site. I'll forward the images and text and the SEO keywords. You will 1. Rebuild and layout the site in accordance with the 'Golden Ratio' and as per the wireframe I've built in Figma. 2. Compress and add all the images including their SEO and keywords alt tags etc to each of the images. 3. Build the page to ensure it has a 90 to 100 Page speed score. 4. Test it on all devices. Other basic Interactive elements: - "call' from the device - "direction' to provide a popup dropdown for google maps or apple maps - 'links to social in footer' - 'link to open email address to contact in the footer" - 'anchor text on the page to direct from the Price section in the header to the Price area further down ...
...Excellent attention to detail and a creative mindset. Ability to meet deadlines and work methodically. Proficiency in design software (e.g., Adobe Photoshop, Sketch). What We Offer: A paid test project to gauge fit and skill level. Opportunity for regular daily projects if initial results are satisfactory. A long-term partnership for a freelancer who proves to be talented, hardworking, and smart. Fair compensation reflective of the quality and creativity of the work. Application Instructions: Please submit your portfolio along with your application. Selected candidates will be contacted to discuss the test project details, followed by an evaluation to move forward with the long-term collaboration. We look forward to seeing your creativity and to starting a rewarding work...
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape websites that index local business like Yelp, Yellow Pages, Google Maps, etc. I have provided an Excel template to follow. For every entry, we will pay $0.10.
...games, primarily available on Steam. The task involves researching and providing valid EAN numbers for each downloadable game version listed in our Excel file. The current file includes titles and other relevant details, but lacks the EANs, which are crucial for our inventory management and logistics processes. Your task will be to fill this gap by identifying the correct EANs for these digital products. This project has the potential to expand in the future to include more games and other platforms. Therefore, we are looking for someone who can perform this work efficiently and accurately. If you have experience in retrieving specific data for digital products and a keen interest in video games, please submit your detailed proposal through the platform. Include your ap...
...an expert in Excel spreadsheet design to create a comprehensive and user-friendly accounts receivables sheet for my business. Key Features: - Calculation of total receivables - Aging analysis of receivables - Customer-wise summary of receivables - Report by department - Aging report - Total Sales - VAT report - Report by month Specific Formulas and Calculations: - Sum - Average - Count - Xlookup Data Organization: - By customer name - By invoice date - By payment due date - By month - By department Ideal Skills: - Proficiency in Excel and experience in creating complex spreadsheets - Strong understanding of accounting principles and reporting - Attention to detail to ensure accuracy in formulae and data organization - Ability to design a user-frie...
Urgently require a proficient Excel whizz who can efficiently perform financial calculations and analysis, especially pertaining to crypto sales and purchases. Aside from these, I require assistance in creating bespoke reports and summaries that will aid in decision-making among other business aspects. - **Financial Analysis**: Ability to perform rigorous financial analysis is crucial for this project. This includes but not restricted to calculations of various crypto sales and purchases. - **Report Generation**: Need customized, detail-oriented reports and summaries of all crypto activities in a coherent, easy-to-understand manner. Ideal candidates should have: - Extensive experience and knowledge in managing and analyzing financial data using Excel - Familiarity...
I have a project where I need someone to extract data from PDF files and input it into an Excel spreadsheet. Key Requirements: - Extracting data from PDF files - Inputting the extracted data into an Excel spreadsheet Ideal Skills and Experience: - Proficiency in data entry - Experience with data extraction from PDF files - Advanced Excel skills - Attention to detail and accuracy
...Requirements: Language Conversion: The existing strategy needs to be translated into cTrader's proprietary language. - **Real-time Data Analysis:** The cTrader version should have the ability to analyze real-time data, just as the TradingView strategy does. - **Automated Trading Execution:** The cTrader bot should be able to automatically execute trades based on the parameters of the strategy. - **Backtesting Capabilities:** The coder will need to implement backtesting features, allowing me to test the strategy's performance historically. Ideal Freelancer: - Proficient in Python and cTrader's language - Experienced in developing trading bots - Understands real-time data analysis - Has an understanding of backtesting capabilities and automate...
...need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing all the subtasks. Speed and profi...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...
I need to scrape base salary information from Glassdoor for about 2000 companies. Key project requirements: - Scraping Glassdoor for base salary and range info only for every job function/title. - Compiling this data into an Excel spreadsheet Ideal skills include: - Proficient in web scraping techniques - Experience with data analysis Website: (it is free but need to register and complete the profile to see the information)
Hi guys, we have an excel contact list. In that list we have persons & companies with their contact details. We coded an script wich monitors an gmail inbox. When emails are sent from specific mails to this inbox the python script should read the body and depending on the request in mail syript should send requested Excel back. There are 8 different excel saved locally wich the script can take and send back. So depending on the contect of the mail script should choose the right excel file and send this with an text like "here your requested Contact List Periskop in attachment. kind regards" If its help. in attachmend an little python script we wrote to send back an mail
As an entrepreneur, I'm swamped with a ton of ta...but also skilled in email management, appointment scheduling, light accounting, and spreadsheet tasks. Here's what the job entails: - Managing my emails and scheduling appointments - Helping with light accounting and maintaining spreadsheets - Entrusted with some data entry duties The ideal candidate would have: - Proven experience in similar roles - Exceptional command over English - Strong skills in using spreadsheet and email tools You should expect to work around 10-20 hours a week. This job requires professional-level English fluency given the nature of the tasks at hand. Excellent organizational skills and an eye for detail would be a big plus for this role. If this sounds like a role you can ...
I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in...
I'm looking for a meticulous quality assurance expert to conduct careful testing on my website, which comprises approximately 35 pages. The website's primary purpose is to promote a product or service, needing specific focus on: - Functionality and Performance: I want the user journey to be seamless, without any glitches. It's crucial that you guarantee every link leads to the correct page. Also, test our site's search functionality for accuracy, relevancy, and speed. Confirm that all features are running smoothly and efficiently. - Content & Information Accuracy: Ensure all content, from page text to the captions, is free of spelling and grammatical errors. Also, verify that all information presented aligns with our product or service offering. Please no...
i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.
...setups. Install the WordPress theme and ensure the website is operational with the new domain. Milestone 2: Integration and Customization (3 days) Customize the WordPress theme and set up the blog section. Integrate Acuity Scheduling and test its functionality. Develop and test the instant quote form using Formidable Forms. Milestone 3: Final Adjustments and Testing (2 days) Install and configure the web messaging plugin. Conduct thorough testing of the entire site to ensure all components are functioning correctly. Make any necessary adjustments based on test results. Requirements: Proven experience with WordPress migrations, especially from Wix to WordPress. Strong understanding of WordPress theme customization and plugin integration. Ability to work within tigh...
I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you'd be interested in.
I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to ensure the information is accurately documented. - Profici...
I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friend...
...another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL – limit) GTT, and trades (only completed- not rejected) from the main account to child accounts 3) Order Modification: If we cancel/modify any order on price and quantity, the cancellation/modify should also be cancelled/modified in all accounts 4) Primary account selection : Should have functionality of changing the primary account in excel , we can have predefined criteria for...
...a system that can handle test ordering and results reporting efficiently. Key Features: - The software should have a user-friendly interface for test ordering. This includes a feature to input patient details, assign specific tests and generate necessary documentation. - The system should be able to track these orders effectively, ensuring that there are no errors or omissions in the process. - I will also need a robust results reporting system. This should be able to receive, process and display test results in a clear and accessible way for both patients and our team. - The software should be compatible with Windows operating system. Integration: - The software should integrate seamlessly with our existing billing and invoicing system. This means that all te...
I have a photo that contains a mix of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurately r...
We are hosting a Dungeons and Dragons (DnD) themed interactive fiction writing contest to test our new tool, with which anyone can turn a story idea into an interactive narrative. We are hosting the contest to get 1) some great writers onto the tool (don't worry - you retain full rights over your work!!) and 2) to get feedback on the tool we've been building. Hence we are seeking participants. One of the categories of the contest is DnD, so I'm looking for fans of DnD specifically. People who have experience either playing the game or DMing. The theme and settings of your contest submissions should revolve around the legendary world of DnD. If you like, you can also add RPG elements, as the tool, for example, allows for dice rolls, inventory, character attributes, ...
I am seeking writers with an interest in one of the categories below to test an interactive narrative writing tool by creating exciting, choose-your-own-adventure stories. Key responsibilities: - Experiment with the tool to generate a captivating story (3 episodes, minimum ~400 words per episode) - Provide feedback on the user-friendly nature and functionality of the writing tool. Skills and Experience: - Experience in writing engaging stories - if you have experience with choose-your-own-adventure, then that's great - Prior experience in testing software is not necessary but is a plus - Good writing skills / knack for storytelling The ultimate goal for US is to test the tool. Is it fun? What could be better about it? What should be removed, added, changed? Additi...
I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional formatting in the ...
I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-...designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating str...
...specifically in data analysis and mobile application development. Unfortunately, I skipped a question on the required operating system, so ideally, you should be able to work on multiple platforms. Key responsibilities: - Analysis of complex data sets to influence mobile application development. - Conceptualize, design, program, test, and improve a mobile application based on data findings. Important Skills: - Expertise in data analysis (Python, R, SAS, or related tools). - Proficiency in mobile application development, with experience in both iOS and Android a plus. - Strong problem-solving capabilities and attention to detail. In addition to your technical skills, having a keen eye for user-centric design based on data results would be ben...
I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel...
I would like to hire a professional to extract and organize Amazon Seller details using web scraping techniques. After you find the company name on Amazon, i need you to scrape the web for their contact information since Amazon ...since Amazon wont disclose it on Specifically, this project involves: - Extracting Amazon seller information from the website -Use that Amazon seller information to scrape the web for email and contact details - Organizing the data in an Excel spreadsheet The main goal of this exercise is to generate leads from this data. Ideal Skills: - Proficient in web scraping techniques - Ability to handle and manipulate data in Excel - Experience in lead generation would be a plus as it will help in creating a strategic approac...
I'm in need of a proficient developer who can create and implement a Power Automate flow. The purpose of this flow is to copy rows from Table A and migrate them over to Table B, all within our data verse. The condition for the migration is dictated by a specific value in a column; more specifically, in the "Test Status" column. If a row in Table A possesses "Test Status" in the specified column, then it should be copied over to Table B. Required Skills: - Power Automate proficiency - Experience with data verse - Attention to detail, as accurate copying is essential Please note, the rows in question are not to be deleted from Table A after copying. They should remain intact. The ultimate goal is to have a duplicate in Table B.
I need a skilled professional to install the Laravel project files onto my CPanel as soon as possible. Key Requirements: - Install Laravel project files on CPanel - Ensure all files are correctly placed and configured - Test and verify the installation Ideal Freelancer: - Proficient in Laravel framework - Experienced with CPanel installation - Can work quickly and efficiently to meet ASAP deadline
I'm in need of an experienced developer to fine-tune my website's sharing funct...background in web development, specifically in configuring sharing functionality. A good eye for design and aesthetics is also crucial, as the success of this project relies on the accurate representation of content through both the brief description and the accompanying image. The freelancer for this project should have his/her own WordPress development environment and be able to suggest and test on required plugins for this project's development. The freelancer should be able to provide demo of similar function before being awarded of this project. Your work should result in a seamless and engaging sharing experience for our users, maximizing the appeal of the shared content and en...
I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with inte...
Job Title: Experienced YouTube Ads Media Buyer for Travel Industry Compensation: $600 per client Location: Remote/Anywhere About the Job: Join our team as a YouTube Ads Manager and be part of something ...and be responsible for the following tasks: *Setting up and launching YouTube campaigns *Setting up retargeting pixels, custom conversions etc. *Daily management of YouTube campaigns once they go live *Build & A/B test high-converting landing pages. * etc, etc Requirements: *Good English with clear communication. *Experience setting up, launching and managing effective YouTube campaigns *Proven track record that you’re able to prove *Knowledge of landing pages, funnels, conversions, testing etc. *Ability to check on client campaigns and report results into a Google ...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process autom...
I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel is a plus.
...+-1-|-2-|---------+ # ++++a+++|----5----+ # +-3-|-4-|---------+ # ++++++++b++++++++++ # +-------|--7-|-8--+ # +---6---|++++c+++++ # +-------|-10-|-9--+ # +++++++++++++++++++ the approach should return 10 as the total number of patches. (The numbers in the simplified case above are just added for the sake of clarity. The image data does not contain those numbers, obviously). - finally, given that the real estate registry needs to book-keep all the boundaries created, the program shall build an output image of the size of 1x(N+1). The image encodes as the first pixel the color of the background. Then it should encode "the color hierarchy" of all the N colors used to subdivide the ...
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.
...specific needs of each client. This role is crucial in ensuring that our AI communications are not only functional but also engaging and contextually appropriate. ?Responsibilities: - Design and implement conversational prompts based on specific client requirements. - Work closely with our tech team to ensure seamless integration and functionality across different messaging platforms. - Continuously test and optimize prompts to improve interaction quality and user satisfaction. - Stay updated with the latest developments in AI and conversational design to implement cutting-edge solutions. ? Requirements: - Proven experience in conversational AI and prompt engineering, preferably with OpenAI's Assistant API. - Strong understanding of natural language processing and AI com...
