Perl excel macrosprojekty

As part of my project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and consideration of this project.

Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.

I need assistance with a large-scale data extraction from an Excel spreadsheet. The data includes about 38000 line items, from which I require certain specific pieces of information – namely, the Names, Addresses, and Email Addresses. This extracted information will be used for creating a logical and organized mailing list. Here are the important elements of the project: - Extracting Names, Addresses, and Email Addresses from approximately 38000 line items - No specific extraction criteria or conditions to follow Ideal freelancers for this job would have experience in data extraction, data entry and be efficient in Excel spreadsheet operations. Precision and attention to detail are paramount for this role, as the information gathered will directly impact the efficacy ...

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.

I'm in need of a proficient professional who can provide a detailed quantity take-off for a project Value RM3.4 Million equivalent to USD711,000. Key Responsiblities: - Providing a comprehensive full building quantity take-off service. - All data to be provided in Excel Format - Complete within 2 days. - Initial tender quantity will be provided, to compare it with taking-off quantity (re-measurement) Ideal Skills: - Familiar with Planswift would be a plus - Experience with industrial-type construction projects. - 5+ years experience in Quantity Surveying Field - Strong analytical skills and attention to detail. - Familiar with Malaysia standard of measurement, SMM2 By offering this service, you will provide an integral part of the planning and budgeting process for the succ...

Need a freelancer that can extract a list of cities (200 - 400) from a website and provide in an excel sheet. Quick job for the right freelancer. Pays $20

I'm in need of an Excel expert who can assist me in creating an advanced tracking system for specific KPI's and security measures. For the KPI tracking, you'll work with: - Sales - Profit Margin - Customer Satisfaction It's also crucial for the data we manage is secure with a well-setup security system. Data security is paramount, and I need these set up: - Data encryption - User authentication - Firewall protection Moreover, the security measures should include an effective incident tracker that, in case of any violation, notifies me through email. Skills needed: - Expert in Excel - Understanding of Data Security - Knowledge in setting up email notifications. Please, only apply if you have a strong understanding of these areas.

I require an expert who can handle a multifaceted data analysis task. This project (Excel dataset) revolves around a questionnaire survey I've conducted for research purposes. Key Tasks: - Carry out descriptive statistics - Conduct correlation analysis - Perform validity and reliability tests Specifically, I need the following tests to be utilized: - Chi-Square test - Cronbach’s statistic - Item-total correlation - Discriminant & Construct validity The ideal candidate should have solid experience in statistical analysis (no preferred Software), a strong understanding of the mentioned statistical tools, and an academic or marketing background to comprehend the intricacies of my research. Familiarity with surveys and questionnaire analysis will be a significant adva...

I'm currently working on my MBA project, and I'm looking for a statistician with a strong background in regression analysis and Excel. Here's an overview of what I'll need from you: - Perform a comprehensive regression analysis: I've chosen to focus my research on this area of statistics. - Use Excel for this project: I have decided to use Excel for this project due to its simplicity and because it's a tool I'm familiar with. - Complete the project as soon as possible: I'm running on a tight schedule, so time is of the essence. Required Skills: - Strong grasp of regression analysis - Proficiency in Excel - Ability to work under a tight deadline This project is quite urgent, so I'd appreciate a swift response from ...

In this project, I'll need your expertise with Excel to map names across multiple tabs - K1, K2, and K3 - against a listing in the 'mapping' tab. Before you agree, you should understand that each name could be slightly different, meaning you can't rely completely on automation; you will need to manually review and align each entry. Key Responsibilities: - Copy names directly from tabs K1, K2, and K3 into columns E, F, and G respectively. - Use unique identifiers to categorize and organize this data. - If a name in K1, K2, or K3 doesn't match any entry in the 'mapping' tab, leave the corresponding cell in columns E, F, or G blank. The successful freelancer for this project will ideally be proficient in Excel, detail-orientated and has a st...

We need a specialist to scrape names, addresses, location, and contact details from a targeted database website. This is primarily for data analysis purposes. The scraped data will be required to be cleaned and structured for our specific data analysis tools. Therefore, attention to detail will be paramount in this project. Requi...from a targeted database website. This is primarily for data analysis purposes. The scraped data will be required to be cleaned and structured for our specific data analysis tools. Therefore, attention to detail will be paramount in this project. Requirements: - Proven experience in web scraping - Knowledge of data cleaning techniques, specifically for data analysis - Proficiency in working with Excel files - Attention to detail - Adherence to privacy r...

I'm seeking a proficient Excel expert to combine and simplify my existing Excel spreadsheets. Your main task will be: Do you think you could create a tab, call it AMC priority exercises, and consolidate the JEP & OCE tab into 1 timeline? - Consolidating spreadsheets into one, focusing on data entry and organization. For an ideal candidate: - Proficiency in Excel data manipulation and optimization is necessary. - Familiarity with event planning would be a plus. Main objectives: - Simplify data entry and make it less time-consuming. - Arrange the data by rows for easy navigation and understanding. - The data mainly consists of date or time-based data for numerous organizational events. With your help, I aim to streamline my event planning process by having ...

The task is centered around entering text data taken from digital documents into an Excel spreadsheet. Accuracy and attention to detail are a must. Take data out of pdf and word documents and enter into an excel file for few of the fields that are required. We can try using python or other scripts but maybe manual as well. Total of 62 reports (rows of data) to be entered. Key requirements: - Ability to convert data from digital documents to text format - Proficient in data entry - Strong Excel skills - Detail-oriented - Ability to deliver work within the stipulated timelines Please ensure you have the necessary skills and experience before placing a bid. Looking forward to your proposals.

...the top 10 companies in each of the 30 predefined categories, across UAE. Essential information to gather: Company name, headquarters location, service category, website URL, service area, and contact details (name, email, and phone number) for two key personnel, accompanied by a concise company description (2-3 sentences). Google review score as well. The deliverable is to be in one master excel sheet which can be filtered based on category & location. Ideal candidates should demonstrate strong research capabilities, an understanding of the UAE business landscape, and proficiency in data organization. Kindly provide an estimate of the time and cost for this project in your proposal. I need a lump sum price and estimated timeline to receive the information. Data to ...

I am in need of a seasoned professional to assist with Dental disease data collection research. While the specifics are still under wraps, you will need a knack for adaptation along with a strong understanding of both quantitative and qualitative da...Exceptional ability to interpret objectives and extract essential data - Fluent and skilled in English - Good team work - Good time management Knows how to use AI technology to collect and gather data Job description: 1) to gather and collect data using available AI technology 2) to screen and filter accurate and valid data from collected responses 3) to collect and compile data in Microsoft word/excel 4) to collect non-repetitive data with at least 3000 words 5) to identify true information and content about dental diseases wi...

I am looking for a talented video creator capable of producing promotional videos for Instagram reels. The perfect freelancer for this project should have a solid background in creat...background in creating engaging mixed media content and understand how to effectively promote a product or service in a concise manner. Here's what you need to know: - The videos need to be 15 seconds long - The style should be a blend of live action and animation, creating a visually appealing mixed media format - The main purpose is promotional where we want to promote our short courses on Excel, ChatGPT etc. With your bid, please include examples of similar projects you've completed previously. Looking forward to your creative proposals. I will pay $4 per video. Please mention "...

I'm seeking an Excel specialist with a high attention to detail, particularly proficient in pivot tables, data analysis, and data organization and capable with macros. The main tasks encompass: - Building pivot tables to consolidate our vast data - Conducting data analysis for sales and customer information - Structuring and formatting the data for better understanding and usage The specific datasets we'll be working with involve customer information and financial data, aiming to create comprehensive financial reports. This project forms a core part of our decision-making process, facilitating improved customer service, and enabling us to make data-driven business decisions. Ideally, you should have prior experience in medical finance or a similar field and be...

I need a freelancer with a solid understanding of football, player performance analysis, and team tactics analysis. This project involves writing and publishing an insightful research paper on these topics. Key Requirements: * Experience in sports analytics especially within football. * Ability to analyze and interpret structured/tabular data (CSV, Excel, etc) * Strong understanding of player analysis and team tactics within football. * Excellent research writing and academic publishing skills. * I already possess data for this research. Knowledge in handling dataset is a must. Your main responsibility will be to handle all aspects of the research paper from drafting to publishing. You're expected to leverage the dataset I have to generate meaningful insights and conclusi...

I require a seasoned data entry specialist with proficiency in Microsoft Excel to work on a part-time basis, specifically during evening hours from 8PM to 11PM. Requirements: - Advanced knowledge in Microsoft Excel - Capacity to work for 20+ hours per week - Experience with data entry jobs Although the role is part-time, reliability during designated work hours is essential. The ideal candidate will possess strong attention to detail and the ability to accurately input data. Prior experience working in similar roles will be highly regarded.

I need a professional with good experience in MS Excel financial calculations and an understanding of key financial modelling techniques such as NPV and IRR. You'll also need to write a short 850-word report based on the results of the calculations completed. Details to be discussed through chat.

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ☺️ Thank You. Regards, Nimra

...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm seeking a professional who's highly proficient in Excel formulas, specifically those used for data analysis. The task involves working with sales data, therefore any previous experience with sales data manipulation is crucial for this role. Key responsibilities: - Derive insights from sales data using advanced Excel formulas. - Analyzing large data sets and using analytical toolbox of Excel. Ideal Candidates: - Advanced knowledge of Excel, specifically formulas. - Prior experience with sales data analysis. - Detail-oriented with the ability to manage large data sets. - Proven analytical skills.

I need the excellent services of a data entry expert to input text data from online sources into Microsoft Excel. The project requires keen attention to detail and proficiency in handling Excel. Ideal Skills: - Proficient Excel user - Fast typing speed - Acute attention to detail - Ability to efficiently extract data from online sources Experience: - Previous experience in data entry - Proven track record of using Excel for large-scale data entry operations.

I'm in need of a custom web application for my reselling business, which mainly deals with digital goods. ...then selling them to our customers. These transactions primarily involve digital goods. I have a team in place that interacts with customers and facilitates the sale of our products. Our business model is such that we acquire items from our vendors on an as-needed basis and then sell these items to our customers through an online marketplace. Currently, we are managing our transactions using Excel sheets. Whenever a sale is made, the staff records it in a spreadsheet. I'm considering sharing a screenshot from one of our daily sheets for better understanding. Based on the data in these sheets, I calculate payments to vendors, wages for our staff, and commissions ...

I need a proficient data visualizer to convert my raw excel data into easy-to-understand line charts and bar graphs. The goal of these charts and graphs is to display information in a visually appealing and digestible manner for both presentations and general visualization. Only looking for 2-3 visualizations for a very small set of data currently in excel table form (ie 5 data points of comparison between 2-3 company members). Here's what I am specifically looking for: * Conversion of data into line charts and bar graphs * Charts and graphs made should be presentation-ready * No specific color theme or design preference Ideal skills and experience: * Proficiency in Excel or similar software * Strong background in data visualization * Ability to prese...

I am searching for a proficient Excel specialist to design a concise tracking sheet for our company's business travel. This Excel sheet will keep track of both flight and employee details. Your task is to ensure that the sheet: - Efficiently records comprehensive information on each booking. - Offers easy generation of reports on these bookings. - Facilitates the monitoring of upcoming business trips. Vital flight details to include range from the booking reference, flight cost, to the departure date. Other notable data encompasses the traveler's name, department, destination, booking request, confirmation dates, the travel memo number, and the authorization information. The ideal freelancer for this project should have extensive experience building out detailed ...

I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order

I am seeking a part-time administrative assistant with strong skills in Microsoft Excel. The main task will be data entry, so accuracy and attention to detail are crucial. Experience with handling large databases is a major plus. Skills and Experience: - Proficient in Microsoft Excel - Prior experience in data entry - Good attention to detail - Ability to work independently and efficiently - Understanding of database management is an advantage This is a remote position, so good self-management and reliable internet connection are also essential. Please include any relevant administrative and data entry experience in your bid.

I am looking for an expert who can customize Excel sheet navigation to meet my specific needs. The successful candidate should be able to create an Excel sheet that: - Moves to the right when I press 'Enter' for the first time - Moves to the left and then down when I press 'Enter' again - Allows this unique navigation pattern to loop without the need for any additional keyboard inputs Skills & Experience Required: - Proficiency in Excel functionalities - Experience in VBA coding for Excel - Good attention to detail - Ability to complete tasks quickly and efficiently

My project requires implementing a conversion from specific sheets in an XLS file to XML. I would appreciate a freelancer who can: - Focus on converting only select sheets from the XLS file - Use the XML schema already provided - Handle complex data structures present in the XLS file The ideal freelancer should be comfortable with both XLS and XML file formats, a...I would appreciate a freelancer who can: - Focus on converting only select sheets from the XLS file - Use the XML schema already provided - Handle complex data structures present in the XLS file The ideal freelancer should be comfortable with both XLS and XML file formats, and have previous experience with complex data structures. Adequate knowledge in pivot tables and nested tables within an Excel environment will be b...

As a firm highly invested in our online security, we're seeking a skilled cyber security professional to undertake a one-off project centered around the analysis of our firewall logs. Primary tasks will include: - Detailed analysis of our firewall logs - Identifica...logs. Primary tasks will include: - Detailed analysis of our firewall logs - Identification of potential threats within these logs - Generation of comprehensive reports on any security incidents discovered We require these reports to be delivered, conveniently and in an easily navigable format, via Excel spreadsheets. Ideal candidates will possess experience in cyber security, specifically with a focus on firewall log interpretation and threat detection, alongside robust knowledge of Excel for repor...

We're seeking a freelance social media specialist who is passionate about Twitter and well-versed in web3 technology. This role requires a strong commitment with a minimum availability of 8-10 hours daily. Proficiency in Microsoft Excel is essential. Requirements: - Avid user of Twitter - Knowledgeable about web3 technology - Reliable WiFi connectivity - Ability to commit to 8-10 hours daily - Proficient in Microsoft Excel

We're seeking a freelance social media specialist who is passionate about Twitter and well-versed in web3 technology. This role requires a strong commitment with a minimum availability of 8-10 hours daily. Proficiency in Microsoft Excel is essential. Requirements: - Avid user of Twitter - Knowledgeable about web3 technology - Reliable WiFi connectivity - Ability to commit to 8-10 hours daily - Proficient in Microsoft Excel

I need someone with attention to detail to manually input data from 100-500 business cards into an Excel sheet or CRM system. - The information to capture includes Full Name and Title, Contact Information, and Company Details from each business card. - Proficiency in Excel or CRM data entry and a knack for accuracy are crucial.

I am on the lookout for someone with proficient skills in Excel and data entry to transform text data into an Excel sheet. The project requires: - Typing up to 1000 entries of text data in Excel. - Maintaining accurate data by ensuring consistency with pre-existing data in the Excel sheet. Detailed concentration, speed and excellent attention to detail will be vital for this job. Experience in data entry and familiarity with Excel formatting are key skills for this project. Accuracy is of utmost importance to ensure the seamless flow of data in the sheet.

As part of an effort to create UI PATH scripts for automation using SAP and EXCEL integration, we need to create a DEV/QA ENVIRONMENT, it is only one environment named DEV/QA, and install software to have an environment for the creation of UI PATH's bots: 1.) Create and configure a Virtual Server 2.) Install the UI PATH suite 3.) Prepare and validate that all connections to SAP/QA are already in place. SAP/QA environment already exists. 4.) Create the folder structure and copy data and documents needed for BOTS such as EXCEL files 5.) Validate the access to other apps such as Mail Server and a web application named: CIM DATABASE 6.) Validate all the components are in place and available for UI PATH bots creation 7.) Prepare technical documentation about the DEV...

I'm in need of a developer to create a unique dashboard that will enable me to send a single attachment in the form of a CV to thousands of recruiters, using email addresses that I will upload via an Excel sheet. The platform needs to incorporate the following features: * Ability to send a singular attachment to multiple recipients: the design should allow me to send only one attachment to all recruiters. * Non-customizable email content: I require the same message to be sent to all recruiters, hence the platform does not require any custom message design. Prediction and project completion should be as soon as possible due to the urgency of my requirements. Ideal skills for the job include proficiency in bulk emailing systems, platform development, and fluency in common p...

I am seeking a skilled AI professional who can build a cost-reducing model for my supply chain operations. The primary goal is to minimize operational expenses through intelligent analysis and optimization. Key Tasks: - Create an AI model focused on cost reduction us...supplier performance data are received monthly, hence the model needs to accommodate this cycle. Your contribution to this project will play a crucial role in increasing efficiency and driving down costs, therefore I look for someone with a high degree of responsibility and commitment. You need to build the model, take input files, run it and share an output. Please share below items: Output excel Formulation Working Model in python along with input files, so that you can run it detailed working solution for und...

I need an experienced Python developer who can proficiently extract tables from a PDF document. Key Requirements: - The tables in the PDF are mostly well-structured ...there might be few exceptions where you will need to handle irregularities. - You must have extensive experience in handling and extracting data particularly for inconsistent or complex table structures. - The final scraped data should be delivered in an Excel file. Ideal Candidate: - Extensive experience with Python and data scraping, with particular experience in handling table data. - Proficient in using Python data scraping tools like BeautifulSoup, Scrapy etc. - Good understanding of handling and transforming data in Microsoft Excel. - Strong problem-solving skills to handle potential challenges with ...

I am looking for a h...proficient individual who can aid in a sequence of tasks namely, data entry, data formatting, web research and eBook writing. Key Responsibilities: - Deliver efficient and accurate data entry and data formatting services. - Conduct comprehensive web research. - Write high-quality content to result in a solid eBook of less than 50 pages. Ideal Candidate: You should have: - Superior skills in Excel for data entry tasks. - Attention to detail for data formatting. - Strong web research abilities. - Excellent writing skills for creating professional and engaging eBook content. This project is a comprehensive blend of technical data tasks and creative writing. Therefore, an ideal candidate would be one who has these diverse skills. I look forward to your ...

In this project, the main task is to ext...from models. I require an experienced freelancer that's proficient with manual data transcription from PDFs into Excel. Your Tasks: - Extract specific data from two PDFs - Transcribe this data manually into an Excel file - Break down the data into two separate worksheets following the template provided Deliverable: - Final data presentation in Excel formatted as plain tables - Two tables with summary statistics (one for each PDF) - Two tables with models marked in yellow (one for each PDF) The ideal person for this project will be experienced in data transcription and should have excellent attention to detail to ensure accurate transcription of the data from the PDFs to the Excel document. Looking forward to ...

I am looking for a proficient Canva and Excel user to help me create a book that will be published. This book must contain information from 500 different database records and be presented in an organized and visually appealing way. The data to be included from each record includes: - Company's Name - Address - Date - Contact details such as a phone number Additionally, I require a specific formatting for each aspect of the record. The format will be: "Company's Name - Address (in format: Street, City, State, Zip) - Date (in format: Month, Day, Year) - Phone number (in format: Area Code - Number)". Ideal skills for this project include: - Proficiency in usingCanva and Excel - Attention to detail, especially in data entry and formatting - Graphic desig...

As a growing company, we're seeking a thorough and dedicated data entry executive, who can commit to 4-5 hours per day. Responsibilities: - Completing online form submissions - Ensuring accuracy and timeliness of data input Skills and Experience: - Should be comfortable using Word and Excel - Should have good internet skills - Proven experience with data entry - Highly organized with attention to detail - Efficiency with online platforms and form submissions - Ability to maintain confidentiality Ideal for dedicated individuals who can contribute positively to our operations. Your work will significantly influence the efficiency of our business. You will need to be proficient with online systems, fast yet meticulous in your approach. 10 worksheets need to be submitted to...

I am looking for a meticulous and experienced Excel wizard who can perform a data cleaning task on a large file (more than 1000 rows) in Excel 2007-2013 (.xlsx) format. Your responsibilities will include: - Removing duplicates - Removing empty rows/columns - Fixing formatting issues Ideal candidates should have extensive experience with data analysis, data cleaning, and Excel. Problem-solving skills and close attention to detail will be critical for this role. Your previous experience in handling large data sets in Excel will be a major advantage. Resulting clean data should be in line with Excel best practices. Thanks for your interest in my project!

...reservation is made, this will be reserved. There will be a management panel and incoming reservations will appear in that management panel. 3) We will be able to download the reservations made to Excel according to the template we have. 4) There will be a user login section in the reservation section and only the customers we have added from the management panel will be able to log in to this section and we will be able to define special prices for the people to whom we give this login. 5 ) These prices will not appear in the reservation section, but they will appear when we download them to Excel 6) The customers we log in will be able to add their own workers as users, but will be able to make reservations through the main company. 7) Prices can be fixed, the p...

I'm looking for a seasoned software developer with a keen expertise in AI, able to develop a sophisticated utility tool. This tool will need to analyze data from varying PDF reports, and present compact, informative comparisons in an Excel format. Key requirements: -Application of AI techniques to process descriptive text data into singularized words. -Talent for working with varying data formats and locations within PDF files, extracting and examining text data. Please refer to the sample input and output documents. - Sample Demonstration: Please provide a sample demonstration showcasing your ability to develop a solution for this project. The demonstration can be a limited-scale prototype or a simulation that highlights your approach to the following key functionalities:...

...accurately extracting vehicle tax data from 'a website'. The program should be adaptable, allowing for export in various formats per requirements. **Core Task:** - Create a script to scrape 'a website' for specific data. **Data Points:** - Vehicle registration number - Vehicle make and model - Vehicle tax amount,etc **Output Requirements:** - Script must allow data export to be configurable (CSV, Excel, JSON). - The script should allow proxy configurations - The script shoud be able to update each record once in every 3 days. ( to be scheduled in cron ) *** VERY IMPORTANT *** - You will deploy the script in a given VPS - We'll need to see the script working to accept your delivery - As part of the requirement, you will need to setup the script and let...