How to input data in r from excel työt

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

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

...“Neverbounce” "listclean". 1. **Validate Email Addresses:** The platform should be able to cross check every submitted email address and validate them to confirm legitimacy. 2. **Spam Check:** There must be a provision to check and detect spam emails and effectively filter them out. 3. **Remove Invalid Emails:** The system should have the ability to remove invalid email addresses from any uploaded list or one-by-one input. 4. Hard Bounce. 6. Invalid Syntax 7. Toxic Domain 8. Abuse Email 9: API 10: Including All features site Accuracy is extremely vital to this project and the system is expected to give a high accuracy rate of 95-99%. The ideal freelancer for this project should possess strong skills...

...for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highl...

...Elementor expert to build a high functioning webform with advanced form validation. The primary focus of this project is to facilitate order processing, which will require integrating a secure payment gateway. Key requirements: - Advanced form validation: This includes adding custom validation rules beyond basic input validation. - Payment gateway integration: You will need to set up a reliable and secure payment processing system. Ideal freelancer: - Proficient in Elementor and experienced in creating complex webforms. - Familiar with integrating payment gateways for streamlined online transactions. - Skilled in ensuring robust security measures to protect customer data. The successful candidate will be able to d...

...looking to have a professional e-commerce website created on WordPress. This will be a platform where I can showcase and sell up to 50 different products. Key requirements: - Full e-commerce functionality: I need to be able to add, edit and remove products as needed. - Design: A clean and professional design is important to me. It should be user-friendly and responsive. - Payment methods: While I haven't decided on specific payment methods, I would like the site to be able to accept credit card payments as a minimum. I'm looking forward to working with a developer who has experience in creating e-commerce websites, preferably on the WordPress platform. Your input on the best way to set up and mana...

I require precise and efficient data entry services for text-based data that will be entered into reports. The ideal candidate will have: - Proven experience in data entry work. - Familiarity with entering data into document formats. - Great attention to detail, ensuring accuracy of input data. - Ability to work with large volumes of text data. - Familiarity with report formats and terminologies. Please note that accurate and timely completion of this project is of high priority. Your previous experience in data entry for report creation would be greatly beneficial.

...experienced web developer to create a tool designed specifically for planning faculty timetables. This tool will be a web-based application to accommodate users universally. Key Features: - Automated scheduling: The software should be able to suggest best-fit schedules automatically using input data. - Flexible adjustment options: Users should have the option to manually adjust proposed schedules or elements of the timetable. Information Needed: The application must be sophisticated enough to work with the following information: - Course names and codes - Classroom availability - Faculty availability. Ideal skills: - Experience in web development, preferably creating scheduling tools - Understanding of faculty requirements, uni...

I need assistance in creating a poster from a medium-sized old sign (Want to be able to make large poster (A3 or larger maybe even A0) . Here are the essential details about the project: - Provided Materials: I will be providing a high-resolution photograph of the old sign for reference. - Design Details: The goal here is to execute an exact replication of the original sign’s design, so attention to detail will be critical. - Ideal Skills: Proficiency in digital graphic design, photo editing, and image scaling would be perfect for this job. The ideal candidate will also have exceptional eye for detail. I look forward to working with a professional who can help bring the beauty and nostalgia of this old sign into a new medium.

Necesito un excel simplificado y parametrizado (formulado) para comparar si vale la pena comprar o alquilar una propiedad, según gastos y costo de oportunidad.

Looking for a talented React Frontend developer to assist in creating a sophisticated web application. Key requirements: - Proven experience building web applications using React framework - Familiarity with creating intuitive dashboards - Experience implementing authentication features - Ability to integrate a functional chatbot - Detail-oriented and exceptional UI/UX skills - Knowledge in frontend performance optimization Strong applicants will have a depth of experience in the above areas and be ready to hit the ground running. Let's connect to discuss the details further.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the ...

...technology, I'm in search of an adept software developer to create an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your re...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

" DM fiscal policy is set to tighten markedly this year ” Check IMF and world bank websites, or other sites, to see if you could replicate the data below, using excel/ time-series to rebuild the chart from below

AVEVA is a global leader in industrial software. Our cutting-edge solutions are used by thousands of enterprises to deliver the essentials of life – such as energy, infrastructure, chemicals and minerals – safely, efficiently and more sustainably. We’re the first software business in the world to have our sustainability targets validated by the SBTi, and we’ve been recognized for the transparency and ambition of our commitment to diversity, equity, and inclusion. We’ve also recently been named as one of the world’s most innovative companies. If you’re a curious and collaborative person who wants to make a big impact through technology, then we want to hear from you! Find out more at Locatio...

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

I'm looking for a skilled designer who can create 3 pages for me in Breakdance Page Editor. Though I haven't specified the content and functionalities in detail, the focus is to design these pages to meet the purpose of showcasing a portfolio, promoting a business/service, or sharing information or articles. Experience in graphic design, UI/UX, and familiarity with breakdance page editor are crucial for this task. The ideal freelancer for this project should be: - Proficient in graphic design - An expert in UI/UX - Experienced with Breakdance Page Editor Your creative input will be highly valued and appreciated. Looking forward to seeing your portfolio and discussing further details.

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

I'm seeking a Mix Engineer proficient in Logic Pro X to assist me in setting up my vocal chain for recording, and provide guidance on mixing and mastering vocals and beats. Key Requirements: - Experience with recording, mixing and mastering. - Proficiency in Logic Pro X - Extensive experience working with Hip-hop/R&B music The project will involve a Zoom call where you'll guide me through: - Setting up an effective vocal chain for recording in Logic Pro X using Waves plugins. - Providing insights and best practices for mixing and mastering vocals and beats - Addressing any specific queries I may have related to the software and the process Your expertise in this area will be crucial as I aim to optimize my rec...

...looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data ...

I'm seeking an experienced PowerApps developer to assist in creating a system for daily information management. - Data Formatting: The information will consist mainly of text fields, numeric data, images or multimedia, and a predefined set of choices. - User Interface: The system should offer a user-friendly interface for data entry and management. - Data Storage: The daily information should be saved to a centralized excel or table, allowing all authorized users to access the data at any time. The ideal candidate for this project would have prior experience in PowerApps development, particularly in creating systems for data management and user input. Experience with integrating PowerAp...

I'm in search of a skilled vocal coach who can provide online lessons, specifically focusing on R&B. Ideally, you would conduct these sessions twice a week or more. Key requirements: - Experience with online vocal coaching - Ability to teach R&B and Pop singing techniques - Availability for twice weekly lessons - Patience and an encouraging teaching style to help a beginner like me develop skills Please consider the weekly commitment, as well as your familiarity with R&B singing, before applying for this project. I'm excited to embark on this learning journey and appreciate your expertise and guidance.

I'm seeking a skilled React JS trainer to help guide me through the basics of the framework. My aim is to get a well-rounded understanding of React's core concepts, rather than specializing in any one area. Key Training Areas: - React components - State management with Redux - Routing and navigation - Handling forms and user input - Styling with CSS-in-JS As my level of expertise is at a beginner stage, the trainer must be patient, clear, and able to cater to this level. The ideal candidate should possess the following: - Demonstrable experience in React JS - Prior experience in training beginners - Good communication skills - Ability to break down complex concepts into easily digestible parts - Commitment ...

I'm looking for a...jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Number Tit...

Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.

I'm in need of an experienced electrical engineer with expertise in power systems and circuit design. I'm looking to have a flyback converter developed that can meet the following specifications: - Input Voltage: 24 V DC - Output Voltage: 3 V - Load: 5 Ω - Output Current: 1-3 Amps - Load-Voltage Variation: < ± 3% The primary objectives of this project are to achieve a high level of efficiency and to ensure the device can deliver a consistent 3V to the 5 Ω load, while also being able to handle variations within the specified range. Ideal candidates for this project should possess: - Proven experience in designing flyback converters - Proficiency in power systems and circuit design - Ability to...

can you help me with just need to customise "batch number" as "not required" field in products and purchase and sale sections, you can see that

...previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in han...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. 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

...a budding R&B/hip-hop artist, I'm looking for an experienced individual to guide me through the next steps of my music career. I've officially released close to 50 songs, but they haven't gained the traction I was hoping for. In particular, I need help with: - **Social Media Promotion**: I'm active on Instagram, Facebook, and TikTok, posting daily. However, I believe there is still untapped potential in promoting my music on these platforms. I'm looking for strategies to increase my engagement, reach a wider audience, and eventually go viral. - **Artist Branding**: I understand the importance of having a unique and consistent brand as an artist, but I'm struggling to define mine. I need guidance on h...

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen services. My business involves a multitude of services, and I need an within-the-business platform that allows for easy calculation based on user preference. Here are some specifics: - Carousel selection of services: your form should allow selection of various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear ins...

...for an experienced C programmer to create an IEC-104 slave application from a Modbus TCP/IP implementation done in C for Linux. This application will run on Debian and will be primarily used for monitoring and logging purposes. Key Deliverables: - Develop IEC-104 slave application - Implement monitoring and logging functionalities - Ensure seamless integration with existing Modbus TCP/IP implementation Ideal Skills and Experience: - Proficiency in C programming - Experience with Linux, particularly Debian - Prior exposure to Modbus TCP/IP and IEC-104 protocols - Strong understanding of monitoring and logging systems - Ability to deliver clean, efficient and well-documented code If you have prior experience in similar projects or have...

...proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet ...

...(executable) and the objective is to add in certain features (very simple features to begin with for this part 1 of the improvement) and possibly remove some useless features / calculations that may not be needed. Simply a cleanup of the UI. There is no major change into the design and purpose of the app, its simply just as stated; removing redundant features and to add some life improvements to the current App. Feel free to ask me any questions if you want a more in detail description and or images to the current app. Mind you we will be screening candidates to work with before replying to your message as from previous work we notice a lot of automated bidders and responders. A little detail about the app...

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to det...

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculation...

...looking to create a circuit board that will effectively map the I/O operations of a 28 pin ST62T25B6 to an Arduino Nano. In the attached "circuit board pinout xlsx" column B describes the Arduino nano pins for pins 1-14 of the ST62T25B6 Column H describes the Arduino nano pins for pins 28-15 of the ST62T25B6 Pins A4 and A5 (SDA and SCL) and ground and 5V need to be presented in a 4 pin header. (See LCD image below). The hand-created version of the design is show in the images below. I would also like to add two inputs based on the LCA715. The idea for these is shown below. The chip and the resistor can be surface mount, but need two through-holes for the terminal connector. These can go to any convenient unused d...

...this implementation is to provide a means to connect to an IP camera over RTSP and ingest the video+audio streams using gstreamer with golang and the go-gst bindings. Once the stream is ingested we need to break-out in to children pipelines to perform various tasks such as creating HLS segments and persisting to disk for future playback and transcoding H.265 to H.264 so that the stream is compatible with the WebRTC requirement of H.264 support. Functionality The functionality demonstrated in the above diagram is broken out to: Ingest Pipeline Responsible for connecting to the IP camera over the RTSP protocol using the rtspsrc element. Once connected the pipeline needs to prepare the stream fo...

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful i...

We are seeking an experienced web developer to create an advanced instant quote form on our WordPress-based trucking company website. The form will integrate Google Maps for autocomplete suggestions and pull real-time data from Google Sheets to provide visitors with instant truckload quotes. Key Features Required: Google Maps Integration: Autocomplete suggestions for 'Pickup City, State' and 'Delivery City, State' using Google Maps API. Google Sheets Integration: Dynamically pull data from a Google Sheet that includes truckload rates, which are updated weekly. The data includes Pickup and Delivery points, Dead head radius, Max weight, Rate, and Rate per mile. Form Requirements: Fields for Pickup City, State; Delivery...

...skilled developer to create an advanced home affordability calculator. It should be able to utilize a range of user inputs and cater to diverse variables. Key Components: • Calculation of Property Tax, Homeowners Insurance, and HOA Fees • Ability to estimate the largest possible home purchase based on financial data • Consideration of interest rates and their possible fluctuations • Reflection of down payments and portfolio line of credit options Input Requirements: • Annual Income • Monthly Debts • Desired Mortgage Term • Potential Family Gifts • 401k Loan Ideal Skills: • Proficient in financial computing • Experience in creating similar financial calculators • Goo...

I am in need of an expert who has considerable experience in working with Google Forms and Google Sheets. The task involves successively linking and customizing one of my Google Forms to a Google Sheet in order to obtain graphical data representation. Key Responsibilities: - Identify and link my Google Forms to the corresponding Google Sheet. - Customize the Google Sheet to visually represent its data as a line graph. - Note that the data provided for this task will be multiple choice responses. Ideal Skills: - Proficiency in Google Forms and Google Sheets - Data Visualization expertise - Ability to deliver clear, concise, and intuitive line graphs - Strong understanding of data representa...

I am in need of an experienced web designer to create a modern and user-friendly website tailored to my specific business needs. Key Requirements: - I require a website with a polished and professional look, suitable for my business model which I will provide details on. - The site must be functional and easy to navigate, ensuring a positive user experience for potential customers. - Expertise in coding, design and ensuring a responsive layout across all devices is a must. - While I haven't specified a color scheme or branding guideline, I'm open to ideas and would appreciate suggestions that would align with my business. I am seeking a designer who is able to not only create the site, but also provide input on the desig...

...need a professional to scrape the stock information from the first 6 stocks on the first of each month starting from 1/1/2014 till the current date on the Chartmill website. You will need to register for a free account. The filter for 2/5/2024 is ,ind_22,date_2024-05-02&v=1&s=p6m. Key Requirements: - Extract the stock code and all fields that are available on the website for the first 6 stocks. - Ensure data is accurate and up to date. Timeframe: I'm looking to have this completed as soon as possible. Ideal Skills and Experience: - Comprehensive experience in web scraping, particularly from financial websites. - Familiarity with stock market data and terminology. - Ability to deliver a high ...

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at s...

The code stuck when xml is wrong or long or when the close tagID is not found. I want to correct it in order to manage more connection. Consider that the XML is a camera that send more or less 1 xml every 2sec. Here my code: $listen_port = $this->cameraPort; $sock = socket_create_listen($listen_port); if ($sock === false) { $errorcode = socket_last_error(); $errormsg = socket_strerror($errorcode); $this->logger->error($this->logPrefix . "Couldn't create socket: [$errorcode] $errormsg"); return Command::FAILURE; } socket_getsockname($sock, $addr, $port); $this->logger->warning($this->logPrefix . "Server Listening on $addr:$port");...

I need a Python develope...Python developer who can create a script to scrape news in JSON format from moneycontrol at a specified interval and store it in a database. Key Requirements: - Develop a Python script to scrape news in JSON from moneycontrol - Automate the scraping process at a specified frequency - Ensure the scraped news is stored in a database Ideal Skills and Experience: - Proficiency in Python - Experience with web scraping using BeautifulSoup or Scrapy - Knowledge of working with JSON data - Familiarity with databases and data storage - Previous experience in similar projects would be a plus Please note: The project does not have specific requirements for news categories or keywords at t...