How to input data in r from excelcông việc

I'm looking for an excel expert to help build and format an advanced product database for the services industry. I already have an existing excel spreadsheet with many items already programmed so this will just be added on. This will revolve around three main components: -Product database containing items -Drop down menu to insert products from database -Custom Graph A strong working knowledge of Excel features, particularly Pivot tables, VLOOKUP function and conditional formatting is a necessity. It would be ideal if you also have experience in data management for the services industry. Your expertise will enable the creation of an effectively organized and easy-to-manage database.

I'm in need of an expert data entry professional who can help me with my data entry task. - I have a significant amount of data in an Excel spreadsheet that needs to be entered into a new system accurately and efficiently. - The work involves transferring the information from the spreadsheet into the new system, and maintaining the integrity of the data throughout the process. - Attention to detail is a key requirement, as any inaccuracies in data entry could have serious implications. - Experience working with Excel spreadsheets and handling large volumes of data is essential for this project. If you are a diligent and experienced data entry operator who can ensure the accur...

I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.

Hi Dholi R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...seeking a freelancing whiz who could use an AI to accurately reproduce the melody of "How Bizarre" by OMC but with my specially written lyrics on sewage pollution. Here are the specifics: - Outcome: I'm keen to have an exact musical replica of "How Bizarre", but with my twist of sewage pollution lyrics. - Vocal style: The AI must be able to mimic the original vocal style as it beautifully blends with the song – try to keep it as similar to the OMC original as possible. - Time Frame: My need is immediate, so the faster you can generate this, the better! Ideal Skills: - Proficiency in artificial intelligence, particularly in the field of audio or music generation. - Previous experience with a ...

I am in need of a part-time bookkeeper/data entry specialist to help with monthly financial tasks. - Software: We use Excel for our bookkeeping and data entry tasks. - Frequency: The assistance will be required monthly, making it a recurring project that's ideal for someone seeking a consistent workload. - Tasks: The primary duty will be logging daily financial data for the monthly income. This includes categorizing, reconciling, and ensuring the accuracy of the data. Batches will be sent monthly and need to be processes within 72 hours of receiving . Ideal candidates should have: - Proficiency in Excel is a must. - Experience in bookkeeping or data entry, preferably for small businesses. - Excelle...

I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I'm looking for an Excel expert to assist me with data cleaning tasks and applying conditional formatting in my Excel spreadsheet. Key Tasks: - Remove blank rows and columns: The spreadsheet has some unnecessary empty rows and columns that I need to be removed to make it more concise and easy to manage. Ideal Skills and Experience: - Proficiency in Excel: Expertise in Excel 2010, 2013, 2016 or later versions is a must. - Data Cleaning: Experience in data cleaning tasks, particularly removing blank rows and columns, is highly desired. - Conditional Formatting: Ability to set up conditional formatting to help me visually identify and manage data more effectiv...

I am seeking an experienced Excel professional to set up a comprehensive spreadsheet for tracking various scooter specifications. Given data must include the following: - Brand - Model - Engine Displacement - Maximum Speed - Weight Capacity - Availability in Different Colors: This will need to be formatted such that each color has its own individual column. - Price: The price listed should reflect the Manufacturer's Suggested Retail Price (MSRP). - Additional Features: This may include factors like ABS, Bluetooth connectivity, etc. - Fuel Efficiency: Recorded in km/l or mpg. The ideal candidate will have proficient skills in data organization, Excel formatting, and data entry. Experience in automotive or sc...

I have a step-by-step procedure, currently in PDF format extracted from Excel, that needs to be transcribed into a Word document and then formatted into a professional presentation. Detailed Requirements: - The content to be transcribed is text only. - The final formatted document should be in PDF format. - The presentation should be designed with a flexible layout, featuring one or multiple procedures per page, depending on the length of each procedure. Ideal Candidate: - Proficient in Microsoft Word and PDF formatting - Experienced in creating professional, clear, and concise presentations - Strong attention to detail - Capable of judicious layout design.

...am looking for an Excel expert to help me create a custom ELO ranking system for our pool and other sports. The system should integrate seamlessly with Excel for easy data input and allow us to rank players based on their performances in these sports. We need an Excel system that will integrate with our app. We need the Excel to stand alone as a backup to our app and test the ranking system before integrating it completely into the app. The players will use a paper scorecard to record the match, and then we will enter the game information into the Excel template to track and update players' score and rankings. Ideal Skills: - Proficiency in Excel to develop ...

I'm looking to engage with a skillful Excel whiz who excels (pun intended) in a variety of Excel formulas. In particular, I need someone who has proficiency in: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Average and standard deviation Non-installation expenses - Average and standard deviation Other fees - Average and standard deviation Freight

I am creating a unique photography book centered around my dog that passed away. The role involves: - Layout and design of the entire book - Creative input for aligning the given pet photos with the coffee theme - Selecting appropriate photos I provide based on their relevance - Ensuring the final print-ready book is beautifully crafted and visually compelling Ideal freelancers will have significant experience in book design, especially with photography books. A love for pets is a bonus. The project requires efficient communication and keen attention to detail. Your skills in photo editing and layout design will be essential in creating this cohesive, thematic book.

For this project, we need an expert in data analysis who can help us make major strategic decisions by identifying trends, patterns, and evaluating performance. We are yet to finalize the specifics of the data being analyzed, but you should be prepared to handle diverse data sets. Key Responsibilities: • Data interpretation and analysis • Report generation and presentation Required skills and experiences: • Proficient in Microsoft Excel and Python • Demonstrated experience in data analysis • Strong ability to identify patterns and trends • Excellent problem-solving skills Further information regarding the data to be analyzed and the purpose of the analys...

I'm in need of a freelancer who is proficient in Microsoft Excel to create 3 comprehensive pro forma sheets and 4 sensitivity analysis sheets. The purpose of these sheets will be for financial forecasting, specifically in a year-by-year breakdown. Ideal Skills: - Advanced Microsoft Excel proficiency - Previous experience in financial forecasting - Attention to detail - Excellent analytical skills Please note, the project entails: - Creating 3 pro forma sheets - Developing 4 sensitivity analysis sheets - Ensuring a year-by-year breakdown for the financial forecasting - Providing a high level of accuracy and attention to detail - Adhering to deadlines with commitment If you have a solid background in financi...

Estoy buscando un experto en Excel para realizar cálculos de ventas y rendimiento. Es importante que el freelancer tenga un sólido conocimiento en: - Realización de cálculos en planillas de cálculo Excel. - Generación de informes de ventas y análisis de rendimiento. Las funciones específicas de Excel a utilizar serán determinadas de acuerdo a los trabajos a realizar. Las habilidades con diversas funciones de Excel (suma, promedio, porcentaje, ordenamiento, etc.) son idóneas para realizar los cálculos de manera eficiente. La precisión y la rapidez son características esenciales para este proyecto.

I have a large number of scanned images that I need to be translated into an Excel spreadsheet. The data in these images need to be sorted and inputted in a clear, organized manner. Specifically: - You will be given scanned images of textual data that need to be translated into Excel. - It will be vital that you have a great attention to detail, ensuring that all data is accurately entered. - The data will need to be sorted in a logical manner within the spreadsheet. If you have experience in data entry, especially into Excel, and if you can show a portfolio of similar work, I would be interested in hearing from you.

I am trying to develop a C# add-in for personal use, but I'm having troubles getting it to work correctly. It seems like my troubles lie somewhere in the packages I'm using or how my project is configured, so this could be a pretty easy fix, but I'm not sure. I'll provide you with the code I have, which should theoretically already work, and all I am asking is that you can get the code to run, send me the Visual Studio project, and I am able to run it on my own system. Here's my end goal for the project, just to give you a better idea, however you won't have to do this, I'll describe what I need done in the next paragraph: Open excel, button in Excel add-in ...

...like someone to repair all my XUIONE php files for me, there are 91 php files to repair, I'll give you an example here. Please only contact me if you can do this <?php echo ' '; if (count(get_included_files()) != 1) { $_PAGE = getPageName(); include ''; if ($rModal) { } else { echo ' <footer class="footer">' . "rn" . ' '; if ($rMobile) { } else { echo ' <a href="#" class="scrollToTop" id="scrollToBottom"><button type="button" class="btn btn-info waves-effect waves-light"><i class="fas fa-caret-down"></i></button></a>' . "r...

I need an experienced professional to build a comprehensive excel model for financial analysis. Key Requirements: - The model should primarily focus on budget forecasting and commission analysis. - It should be designed for annual updates, therefore, it should be easily understandable and modifiable. Ideal Skills and Experience: - Proficiency in Excel and financial modelling. - Strong understanding of budget forecasting and commission analysis. - Experience in building user-friendly, efficient excel models. This project is suitable for someone who has a strong background in finance, as well as a proven track record in creating advanced financial models using Excel. A keen eye for detail and the ability to deliver a hi...

THIRD time posting this, it seems people do not read the requirements and conditions. I need a fully bilingual professional (I will interview in English) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress And others You must be a FAST learner, attentive, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that it will be full-time. First there is a task I’ll give as a test. Payment for part-time during trial per...

I need help creating a CSV file or Excel data sheet. I need a professional who can assist with: - Creating a CSV file or Excel data sheet - Formatting the data accurately - Ensuring the file is easily accessible and understandable - Potentially, assisting with data input This project may require someone with a good eye for detail, data management skills, and experience with Excel or similar software. Please apply to discuss further.

I'm in need of a freelancer who can create a CSV or Excel file for the ecommerce platform we're using. While we haven't decided on the specific data types yet, it's likely the file will include product, pricing, and inventory information. I highly value the skill and experience over promises. So, in your application, please provide examples of past work in this area rather than comprehensive project proposals exclusively. Although we didn't specify whether we need a test file before the start, we're flexible in this area, and are open to discussing what works best for the freelancer in correlation to their workflow. Experience with ecommerce platforms would be advantageous, as well as strong att...

...require a text-to-image AI application to be developed for iOS and Android that can generate realistic scene imagery based on inputted text. The main functionality of the app should include: - Image Generation: The app should be capable of generating realistic scene images based on the text input given by the user. Additionally, I would like the AI system, instead of being strictly limited to existing concepts, to exhibit a dose of creativity as well. This means that the AI should be able to propose novel combinations of concepts, along with creating images from existing ones. Ideal qualifications for the role would include extensive experience in artificial intelligence, image processing, and mobile application development. Th...

I need a professional developer to assist with creating a Shopify template. The design is based on a Magento template from my another shop. Key requirements for this project include: - Creating a Shopify template that closely mirrors the design of an existing Magento template, incl. graphics and layout - Keep the menu structure from the Magento shop I am looking for someone with the following skills: - Proficient in Shopify and Magento, with the ability to translate designs between the two platforms

MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great ...

I'm urgently in need of SEO specialist to work on two of my projects. Your expertise will focus on both my Web Design project and Ecommerce services project. As my main goals are to significantly increase organic traffic, improve my search engine rankings, and boost website conversions, I would appreciate your strategic input on these areas.

I'm in need of a sleep analysis professional to help me interpret the data from an overnight sleep study. The primary goal is to analyze the different sleep stages present in the data. Key Responsibilities: - Analyzing the provided CSV sleep data - Identifying and labeling different sleep stages - Providing an insightful report on the sleep stages found Ideal Skills: - Proficiency in EEG analysis - Strong knowledge of sleep stages and their interpretation - Experience with CSV data analysis - Previous work on overnight sleep studies - Ability to provide clear and concise reports The EEG data must be manually analyzed, labeled, and provided. Please note that expertise in sleep stage analysis ...

Hi Mostafijur R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I want a formula in column D of the attached spreadsheet to convert the date in column C to DD/MM/YYY

...expertise in creating financial models. Specifically, I'm focused on individuals who have had hands-on experience with similar past work. Here's what you need to know. Key Requirements: - Proven experience in financial modelling is a must. Prior work will be a deciding factor in the selection process. - The ability to creatively input charts is necessary. Although I haven't specified the exact chart types, expect to work with line, bar or pie charts. Flexibility and innovation on this will be appreciated. Ideal Candidate: - You are proficient in financial modelling and analytics. - You have a creative eye for data visualization and charting. - You value accuracy and precision in your work. To ...

i have a directory site. Where you can find 34000 data available. i want company name, website, email, phone, address and source link. i will share the website with selected freelancer. Please type "cat" in your proposal. so I understand you read the project description.

...freelancer to create a powerful custom order form in Excel. Though the specific features were not clearly defined, freelancers would potentially be working on creating dropdown menus, calculation formulas, and conditional formatting. Key Skills: - Proficiency in Excel - Previous experience in creating Excel forms Responsibilities: - Building dropdown menus - Establishing calculation formulas - Implementing conditional formatting Data Capture: The successful form should be able to capture: - Customer details - Product details Applications should include examples of past works similar to this project for review. Your understanding and experience in handling similar projects will greatly contribute ...

I'm in need of a talented designer to generate a black and white, cartoonish graphic from a given photo. Your mission should focus on these key aspects: - Emphasizing the character in the photo while creating the graphic. - Incorporating a cartoonish style for the representation of the character. - Using a black and white color scheme throughout the graphic. Ideal skills for this project will include graphic design, understanding of cartoon styles, and expertise in focusing on specific photo elements. Experience in outline graphics and caricaturing will also be beneficial. Both the character and the overall feeling should be well-represented but with a hint of whimsy and creativity. I look forward to seeing your unique take on this ta...

...using their API. The system should allow for the following: - Dashboard Functionality: The system should feature an intuitive dashboard with the ability to upload and manage email lists. This is crucial as the system will be used to send emails to a large database of recipients. - Email Sending: When sending emails, I want the system to allow me to manually select and attach a file to each email. - emails list will be upload through excel sheet - Email Appearances: The emails sent through this system should mimic regular emails in appearance. This means the sender name, subject title, and general layout should be similar to a typical email, to increase the likelihood of engagement and reduce chances of being marke...

I'm seeking an excel expert to handle high-volume data entry and organization tasks in an excel sheet. Key Requirements: - Data Entry and Organization: The primary task is to input a large volume of data and ensure that it's correctly organized. This includes dealing with more than 10 columns or multiple sheets, hence, experience and comfort working with complex data is crucial. - Cleaning: I need the data to be cleaned and correctly formatted. Ideal Skills and Experience: - Proficient in Excel: Extensive experience working with Excel and handling complex data structures. - Attention to Detail: The ability to accurately input and organize da...

I'm looking for an experienced fashion designer or technician equipped with prerequisite skills in creating spec-filled tech packs. These tech packs will be specifically for a variety of clothing items, including: - Coats - Jeans - Sweaters - Scarves - Hats - Gloves The ultimate goal of these tech packs is to enable effective designing of the items. Therefore, the ideal freelancer should have: - Expertise in clothing design, specifically the items listed above - Experience in creating tech packs - Strong understanding of materials, stitching, functionality, aesthetics, and the overall design process. Your input will be crucial in the design process, an experience in this area is paramount.

...(I will interview in English) to do some tasks for my agency, such as: PR Outreach Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress And others You must be a fast learner, attentive, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes. This job will start part-time as a test period, after that it will be full-time. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD Results bonus: 50 USD If your work complies with my quality requirements and you give more than asked, you’ll get performance and results bonuses each month. After a two-month period...

I'm looking for an inspired artist, experienced in logo design. You will apply your cartoonist expertise to produce a logo that reflects the essence of our brand in a playful and engaging manner. KEY ASSETS: - Experience in cartoon character design, specifically for logos - Intuitive understanding of branding - Ability to make recommendations for color and design elements CORE REQUIREMENTS: - Create a logo using a cartoon style - Prior experience in cartoon logo design is preferred. NOTE: While there are no strict requirements for specific colors or symbols at this stage, your creative input will be greatly appreciated in these areas during the design process.

...Platform** **Description:** We're on the lookout for a top-tier website developer to construct a review and rating platform inspired by Yelp, tailored for service providers across various sectors. This role extends beyond basic development; we need your expertise in branding—from logo design to color schemes—to forge a distinct visual identity. Our goal is to foster a platform where users can freely rate and critique services ranging from marketing to software development, underpinned by robust security measures to maintain integrity and trust. In pursuit of transparency, we will incorporate features allowing businesses to "claim" their profiles, thereby bolstering credibility. Add...

I'm seeking an experienced Excel macro specialist to take on a key role in automating my work tasks. Let's dive into specifics: I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data...

...pages created in Figma. Your primary task is to bring these designs to life using Vue3. Key requirements and expectations: - **Level of Interactivity**: I'm looking for a highly interactive experience. So, it's not just about implementing what's static in the design but also adding animations. - **Focus**: The main focus of this project is translating the static designs into working Vue3 pages. It's crucial that you maintain the fidelity of the design and ensure that the code is clean, efficient, and well-documented. Ideal skills and experience: - **Vue3**: You need to have a solid understanding of Vue3 and its core concepts. - **Figma**: Proficiency in interpreting Figma designs and implementing them. - **Interactivity*...

I...concept in mind, I am looking for a skilled illustrator to provide their creative input. Key Points: - The illustrations must be realistic in style, ensuring they're visually appealing while also fitting the intended use on a website. - I will provide a general idea for each illustration, but I'm open to the artist's interpretation and creative input. - The timeline for this project is very short - I need all three illustrations completed within the next 3-4 hours. Ideal Freelancer: - Experienced illustrator with a strong portfolio of realistic illustrations, particularly for websites or digital media. - Ability to work quickly while maintaining a high level of quality and attention to detail. - Strong communi...

I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.

I'm in need of a freelancer to help me clean up my girl's Instagram following. All the guys need to be removed, and I'd like only female connections to remain. The reason for this is to focus on female connections. Key Requirements: - Identify Male Profiles: You'll be required to identify male profiles based on various criteria - profile name, profile photo, and profile content and activity. This means checking the names, pictures, and what they post to see if it hints at their gender. - Remove Male Profiles: Once identified, all male profiles should be removed from the following list. This means you need to be thorough and diligent in this task. If you're going to take on this project,...

...seeking a highly skilled professional to develop an Android app focused on warehouse stock tracking. Here’s the overview of the core functionality the app should have: - **Stock Level Updates**: The app should encompass a real-time updated inventory that reflects the current stock levels. I'm interested in exploring the possibility of updates via manual input and barcode scanning. Ideal candidate should have: - Strong experience in Android app development - Knowledge in inventory management or similar apps - Familiarity with using barcode scanning for inventory tracking(Barcode scanning could be a future option, not interested to have it in the early version, could be integrated at later stages off the app) A successful col...

I'm looking for a skilled electrical engineer to design a tailor-made AC to DC converter with specific features and requirements. Key Features: - The converter needs to have voltage regulation, current limiting, and overload protection. - The input voltage range should be 200-240V, ensuring it's compatible with standard power supplies in a wide range of settings. - The desired output for this project is 24V and 4.2A. Ideal skills and experience for this job would include: - Strong background in electrical engineering, particularly in power electronics. - Previous experience in designing AC to DC converters with similar features. - Ability to ensure the design is cost-effective and reliable for long-term use.

...looking for an experienced programmer who can develop a WhatsApp bot: Please go through each point and give brief explanation on how you will achieve this. 1) I have data in access db format. 2) I want a whatsapp bot which can access this database and reply to the message automatically after searching the database . While there's no mandatory requirement for a specific programming language or framework, an expert understanding of chatbot technologies and experience in creating instant messaging bots would be a great bonus. The successful candidate will need to interpret my project goals into a working bot, therefore excellent communication and understanding are key. To meet my urgent need for this function, I need the project com...

I'm in need of an experienced Power BI expert to assist me in creating daily reports from Excel/CSV files. Key Responsibilities: - Develop daily reports using Power BI, based on data in Excel/CSV files. - Ensure that the reports are insightful, visually appealing, and easy to understand. - Provide assistance in setting up an automated process for updating the reports on a daily basis. Ideal Candidate: - Proven experience in Power BI, specifically in report creation. - Proficient in managing data from Excel/CSV files. - Capable of creating visually engaging and informative reports. - Familiarity with setting up automated daily updates is a plus.

Hi Ashish R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.