Perl search excel file jobs

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kno...

I'm seeking the expertise of a seasoned digital marketing freelancer to enhance my agency's operations. One who's adept in an array of digital marketing services including: - Search Engine Optimization (SEO) - Social Media Marketing - Content Marketing - Website Design and Development - PPC - Meta Ads - Google Ads - Market Research The crux of this collaboration pivots on the generation of leads and conversions. Furthermore, the successful applicant will concentrate their strategies towards the working professionals demographic aged between 26-50. I strongly encourage enthusiastic digital marketing professionals with a proven track record in the above areas to apply. Your ability to design and implement result-oriented strategies that effectively cater to our tar...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

...will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL database once the project is complete. Ideal candidates for this project should have: - need to change php file and combine database. - Proficient experience in PHP and MySQL. - Demonstra...

I need an experienced WordPress developer to investigate and resolve an issue with my website's frontend file upload. Key Tasks: - Identify and rectify the problem causing files not to appear after successful upload. Additional Details: - The files are supposed to be visible on the frontend of the website, but currently, they are not showing up after being uploaded. - The uploaded files are intended to be visible only to logged-in users. Ideal Skills: - Proficiency in WordPress development and debugging. - Experience with frontend file upload functionalities. - Understanding of user permissions and visibility settings in WordPress. I am looking for a professional who can efficiently troubleshoot and resolve this frontend upload issue to ensure the system works flawl...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I have a simple STL file that I need to be transformed into a 3D model for visualization purposes. This project requires proficiency in SketchUp specifically and making elevation on pdf. Key requirements: - Transforming an existing STL file into a 3D model - The 3D model should be optimized for making 3d images I am looking for an experienced professional who can deliver high-quality and visually appealing 3D models with 2d elavations on autocad or pdf . An understanding of SketchUp is essential for this task. I will attach the product design in STL format upon agreement with a freelancer

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I'm in need of a talented audio professional to help me clean up a series of speech-based audio files. These files suffer from significant background noise, specifically static or electronic noise. This noise needs to be removed, without compromising the speech content. Key responsibilities: - Identify and isolate the static or electronic noise. - Employ appropriate tools and techniques to clean the audio. - Deliver high-quality audio files free of noise. Ideal candidate: - can use AI - Proficient in audio editing software such as Audacity, Adobe Audition, etc. - Previous experience in cleaning audio files, especially speech. - Strong attention to detail. - Able to work efficiently and meet deadlines.

I have an excel file, need add product categorie on a column - budget 100€

We are looking for a programmer to create the search engine for our magento 2.4.6 with Proto Theme website using Algolia search. The programmer has to implement the algolia search engine using his own code following the guidelines published by Aloglia to use it in the main page and in the search results page. It must include the following Filtering by attributes ( brands, specific attributes, color, etc) Keyword filtering Filtering by categories The search results should be displayed in a js block on the home page and in the search results. The theme used in magento 2.4.3 is "Fatest by codazon". Please only serious people, we don't want people who spend half as much time searching as doing the work on stackoverflow. Some exa...

...persistent issues with Google Search Console and I need an expert to help me resolve them. Key tasks involved: - Fixing Indexing Issues: There are some pages on my site that aren't being indexed properly by Google. This could be due to various reasons like crawling errors, server problems, etc. - Resolving Sitemap Errors: I've been receiving errors related to the sitemap of my website. This could be contributing to the indexing problems. - Addressing Mobile Usability Issues: Google has flagged some mobile usability issues on my site. I want to ensure my website is fully mobile-friendly and complies with Google's guidelines. Ideal Skills and Experience: - Strong understanding of Google Search Console: You should have a deep understanding of how Google S...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

I'm in the process of starting an enterprise a...this new business. It should be beautifully designed, user-friendly, and effectively present our business details, mission, and services. As for the SEO, emphasis is on technical aspects. Your job would entail ensuring the structure of our site is search-engine friendly and meets all backend requirements for optimal ranking. Ideal skills and experience: - Expert in website design, preferably with portfolio of business sites - Proficient in Technical SEO with a good understanding of backend website requirements for optimal search engine ranking Your proposal should include a brief outline of your design approach and your experience in technical SEO. I look forward to collaborating with you to boost the online p...

Hello, I need complet the Amazon categories catalogue excel in french

My goal is to have a complete informational website developed for my business. With a focus on offering key details like: - About Us: A section devoted to explaining our business and its values - Services: A clear and comprehensive listing of all our services - Conta...number, email address, and physical location - Pricing: Transparent pricing information for our services The ideal freelancer for this project should have prior experience in developing informational websites with an easy to navigate user interface. Proficiency in web design and development and a keen eye for detail is necessary. Knowledge of SEO to help maximize the visibility of the website on search engines is also appreciated. Be prepared to collaborate closely to ensure the website accurately represents the...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

Please Sign Up or Login to see details.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

My Wordpress site has some issues. Also a lot error alerts in Google search console need expert to fix that

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

...you a skilled freelance developer with expertise in crafting seamless experiences across mobile and web platforms? We're seeking a talented individual to collaborate with us on an exciting project to develop a modern and user-friendly job search platform. Key Functionalities: - User Registration and Profile Management: Enable users to create, manage, and update their profiles to streamline the job search process. - Real-Time Messaging: Facilitate communication between job seekers and employers through real-time messaging functionality. - Advanced Search and Filtering: Empower users to discover relevant job listings based on specific criteria such as location, industry, and job type. - Subscription-Based Fees: Implement a flexible subscription model to unlock ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I need a command-line program that can convert .mpz files to .xlsx files. The program should be written in Python. If anyone can do it, please send me the message. Key Requirements: - Input: The program should take a .mpz file (protected password) as input. - Output: The extracted files should be converted to .xlsx format. - Handling: The program should be able to handle files up to 200mb in size. Skills/Experience Required: - Proficient in Python programming - Experience with file handling and conversion Note: A graphical user interface is not required, the program should be command-line only.

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

Please Sign Up or Login to see details.

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

[NO AUTO GENERATED APPLICATIONS… WILL BE DELETED] I need someone familiar with affiliate marketing programs and sites. Someone that can find me some good affiliate products for me to ask. I'm hoping you can find impressive products that have potential to go viral. Tell me some good affiliate products into Instagram. You will search programs like Clickbank, Sharesale, etc. In your application tell me about some products that you have found for clients. Have you ever sold affiliate products through Instagram?

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

One of our clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed ...

...Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automat...

I am looking for a skilled Google Ads expert to help me run an effective campaign. - Ideal candidate will have expertise in all areas of Google Ads: Search, Display, and Video Campaigns. - The primary goal of this campaign is to increase website traffic. - The target audience for these campaigns is yet to be determined. The successful candidate should be able to provide insights on the target audience and develop a strategy that can effectively drive traffic to my website. You should be able to propose a campaign that can provide measurable results. The ideal candidate should have a proven track record of managing successful Google Ads campaigns, ideally for clients with similar goals.

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and S...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and s...

I have a photo of a medal that I would like to have converted to a svg file for printing. I want the outlines of the kings head, text and contours in black. Also the clasp with the text *1858 Gustaf V †1950 in black. The ribbon should be black also. Show examples and the best one gets the job.