Excel vba reference cell by row and column numberJobs
Extract the industry data from the IBIS reports and populate the Excel template
I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center op...
Please don't quote unless you're able to send today. I'm in need of a skilled designer to create (1) ONE flat POD icon (see for image to be converted) for use in printed materials. OPEN TO IDEAS!! This is a SUPER FAST TURN-AROUND. NEED ASAP. Need today. Key Requirements: - Icon S...designer to create (1) ONE flat POD icon (see for image to be converted) for use in printed materials. OPEN TO IDEAS!! This is a SUPER FAST TURN-AROUND. NEED ASAP. Need today. Key Requirements: - Icon Style: Flat design - Usage: Primarily for print materials - Color Scheme: Black and White ONLY Experience in designing for print would be an advantage. The icon needs to be clear, visually appealing, and versatile enough to fit different contexts within print media. SEE Exam...
I am looking for an experienced developer to create an app for iOS, Android, and Web that allows users to register, create events, and manage RSVPs. Here's what you'll need to know: • Platforms: This needs to work for iOS, Android, and be Web-based. • Features: The app should allow for user registration, the ability for those users to create events, and an efficient RSVP management system. • Registration: Users should have multiple options for registering with the app. They should be able to do so through Email, Social media accounts and Phone number. Ideal skills and experience for this job include being versed in cross-platform app development and understanding of database management for user registrati...
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
...skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the d...
...Requirements: - E-commerce Site: The site must be built with the core functionality of an online store. - UI/UX: The most important aspect to this project is the user interface and user experience design. This should be at the forefront of all design decisions. Look and Feel: - The overall look of the site should be clean and minimalist. It's important to me that the design is simple and uncluttered, to create a smooth experience for users. Ideal Skills: - Web Design: A strong portfolio of previous e-commerce sites is essential. - UI/UX: A deep understanding of user experience and interface design principles. - Clean and Minimalist Design: Experience in delivering successful projects with this style is a major plus. Description Brand: Ep...
...looking to have my resume optimized and tailored for different job applications. I have sample resume. You need to edit each resume on the basis on the job description posted on LinkedIn and other websites. Hello, I have a daily target of 25 applications to apply for different job domains. I have a task of 500 applications to be completed within 2 weeks. I will send you the job application link and my sample resume and you have to tailor it according to the role. It should be ATS-friendly and should have a score of a minimum of 85 % in resume worded. I have ready chatbot prompt to make your task easier so that each application resume will take less than 10 minutes. I just need the resume and its score's screenshot, I will add the job l...
I am seeking a VBA developer to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with ...
I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.
I need someone to create a simple data table search and display function for me. The search form will be inside of a page. The search function will read from a specific spreadsheet with organization names and URLs but it will also have keywords and categories that it needs to search. Example: search term: Fatherhood Display: Organizations, categories, URLs with the term "fatherhood" or a category. The results will simply display below the search form in a row: ORG NAME URL. CONTACT INFO (if any) See the attached spreadsheet. I DO NOT want a listing directory with individual pages for listings. All this is should be a search box, and display results statically beneath. I can create a screenshot of necessary. Also it needs to matc...
...highly efficient, detail-oriented freelancer who can design and assemble a one-page website utilizing the content I will provide. All you need to do: - Shape a website from ready-made elements - no element preferences were specified, sample provided for reference. - Take my content and display it in the best possible format - since the provided format was not specified, you'll need the adaptability to work effectively with text, images, HTML code or WordPress-compatible format. - Adjust based on one round of changes post-delivery. Ideal skills and Experience: - Web Design - Web Development - Attention to Detail - Strong Communication Skills - Adaptability and Flexibility - Ability to work with different content formats - quick and accura...
As a WordPress expert with a deep understanding in PHP and AI programming, I'm looking to give my website a much-needed overhaul. What's urgently needed are: - An enhanced user interface to improve the overall aesthetics and user experience. - Noticeable improvement in performance and speed for swift and smooth navigation. - Backend restructuring for efficient operations and seamless dashboard integration. The overall design style of preference is Classic. Moreover, the core of this project is the integration of advanced AI features. These features are specifically: - A recommendation engine to suggest relevant content - Customer behavior analysis to understand users better - Accurate predictive cooking times - A user feedback analysis...
I'm in need of a skilled logo designer to create a unique, personal logo for me. The logo will serve as a representation of my personal brand. Key Requirements: - **Design Style**: I prefer a design style that I will convey through reference photos. - **Color Scheme**: The color scheme will also be conveyed through photos. Ideal Candidate: - Experienced in creating bespoke, personal logos. - Skilled in interpreting client's visual preferences and translating them into a unique design. - Flexible and open to working with visual references provided by the client.
I need a poster designed in a modern and sleek style. The poster should be 1800mm x 1200mm and include the following details: - The text "Tower Hamlets Favourite Estate Agent" - Our company logo - Our company details: PSM Estates, 76 Cambridge Heath Rd, Bethnal Green, London E1 5QJ - Our website: - Our contact number: 020 7117 2671 Ideal Skills and Experience: - Graphic Design: You should have experience in designing posters and have a knack for modern, sleek design styles. - Branding: It's crucial that the poster aligns with our brand, so having experience in maintaining brand consistency in designs is a plus. - Fast Turnaround: We're eager to get this poster out as soon as possible, so the ability to work quickly without compromisi...
I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.
Presupuesto 9 dólares Realizar una hoja de calculo que me arroje el puntaje y la posicion de una oferta respecto a las otras deacuerdo a unas formulas que asignan puntaje deacuerdo al valor que oferten
...Shopify website. The video will be sourced from a link on Shutterstock and should be set to autoplay without sound. It should loop continuously for a seamless viewing experience. Please see the video below: Key requirements include: - Implementing video integration in the top banner of a Shopify website - Ensuring the video autoplays without sound - Enabling the video to loop continuously *Example of the type of display I would like on my website is here: I'm open to suggestions on how to optimally showcase this video on the website. Skills in video integration, Shopify development, and web design are highly desirable. I'm looking forward to seeing your proposals
...a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped with a section for open job cards where I can easily manage and keep track of ongoing tasks. - **Inventory Management:** I prefer a manual entry for inventory items. The system should facilitate the creation and maintenance of inventory templates in an easy and efficient manner. - **Dashboards:** The dashboards should be highly customizable and provide me with a detailed overview of all the key metrics that I need to monitor regularly. The level of customization should be adva...
I need a capable hand to create an AI tool for an Android game that's similar to Subway Surfers. This tool should be built to perform at an intermediate level, hence, it shouldn't struggle with achieving basic tasks but doesn't have to excel at the hardest ones. The ideal freelancer for this job should have experience a deep understanding of artificial intelligence. Key Requirements: - AI Character Movement: The tool must automate the character's movements throughout the game. - Collecting Power-Ups: The AI tool should be clever enough to identify and collect power-ups. - Dodging Obstacles: It is essential that the tool ensures the character constantly avoids obstacles to prolong gameplay. Please note, it's crucial that the tool works seamlessly ...
financial modeling of a project real estate with excel
need css expert to make a website mobile optimized, i have around 7 pages, i can't give access to website, you have to inspect code and provide me css for mobile view alone, i'll give you reference website of the mobile view, budget 1000 INR and should be done tonight.
Tenho em base de dados a localização de imóveis (POLYGON) - com vários pontos de coordenadas. Pretendo efetuar zonamentos e associar um valor para a localização destes imóveis que tenho em base de dados para posteriormente trabalhar números em folha de excel.
...basic application for both iPhone and Android. The fundamental purpose of this app is to establish a seamless connection with a Bluetooth source (specifically, an esp32 sending sensor and pin status data) and store the received data in a local CSV file on the phone. Key Feature Requirements: - The app should function smoothly on both Android and iPhone platforms. (priority is android for now) - Ability to connect over Bluetooth with an esp32 wroom module. The Bluetooth protocol may be either BLE or classic, as I am not entirely certain which one this module uses. - Once connected, the app should be capable of receiving sensor and pin status data. - The app should store this received data in a local CSV file on the mobile device for later access. - A...
I require a skilled native Japanese transcriber to convert my audio recordings to t...require a skilled native Japanese transcriber to convert my audio recordings to text format. The nature of these audio files primarily involves conversations, and the sound quality is high with minimal background noise. To excel in this task, you should: - Have proficiency in Japanese language and transcription techniques. - Be capable of identifying different speakers during the conversations. - Ensure all transcriptions are returned with excellent grammar and spelling. Preferably, you'll have experience with transcription software and can provide evidence of your skills and experience in such projects. Your attention to detail and commitment to t...
I'm in need of a meticulous data entry specialist with a strong command on numbers. The task at hand is to enter numerical data from spreadsheets into a given platform. Key requirements: - Need to collect real number from the given list - Experience with data entry, especially numerical data. Your main responsibility will be to accurately transfer numerical data from spreadsheets to the platform.
Confectionner unemodélisation financière d'un projet immobilier sur excel
I'm seeking an experienced professional who can help ...which is running on Ubuntu. Key Requirements: - Knowledge and expertise in Python, particularly Python 3.x version. - Experience with deploying Flask applications on Linux servers. - Familiarity with Ubuntu and AAPanel is a plus. Some of the tasks you will perform include: - Setting up the Flask project on the AAPanel server. - Configuring the server to run the Flask application smoothly. - Ensuring that the installation is secure and scalable. Please note that Python 3.x is already installed on the server. Your primary focus will be on the Flask project installation and the server configuration. I'm looking for someone who can start working on this project promptly and provide clear...
I need a skilled freelancer to handle the migration and configuration of my current VPS. I have a VPS that needs migrating and configuring. Unfortunately, I'm unable to provide more details regarding the current operating system running on the VPS, and the specific number of websites that need migration. Your expertise in handling such tasks would be invaluable. Key requirements: - Proficient in VPS site migration - Skilled in VPS configuration - Experience working with various operating systems - Familiarity with migrating multiple websites would be beneficial Looking forward to receiving competitive bids from experienced freelancers.
I am currently in need of a website redesign that specifically targets the change of colors and the design of some buttons. This rehaul isn't focused on enhancing UX, increasing conversion rate, or improving visual appeal. The changes will instead revolve around: - Modifying the background color - Adjusting the text color - Changing the button color I will provide the new color theme and scheme, as well as screenshots of the current design for visual reference. Guidance will be given via AnyDesk, while a .gif will be added to a deposit fund button. Freelancers with a keen eye for color coordination and detail, experience in website design, and are familiar with AnyDesk will be suitable for this project. Kindly submit your proposals.
I'm looking for a skilled German translator to translate a large volume of content from English to German....German translator to translate a large volume of content from English to German. The content is related to accounting and POS software. The source material is in Excel format and contains over 10,000 words. Ideal Skills and Expertise: - Fluent in both English and German - Proven experience in translation, particularly related to technical or software content - Proficient in working with Excel files Please note that the translation must be accurate and precise to ensure that the technical terms are properly translated. Your familiarity with accounting and POS software terminology is highly desirable. The software is up to...
I'm looking to get a website designed but have not yet determined the main purpose or target audience. Also, I'm still unsure about the total number of pages required. Ideally, I'd like a design that's flexible and easy to tweak as I decide on these factors. Please share your portfolio if you've done similar uncertain projects before or if you're comfortable working with less specs at the start and able to adapt as we discuss. Strong communication skills, creativity, flexibility, and problem-solving skills are a must.
...following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours...
I'm looking for an expert in the HR module of ERPNext to enhance our current system. Our main focus is to optimize the HR functionalities. We require an experienced professional who can tailor the ERPN...expert in the HR module of ERPNext to enhance our current system. Our main focus is to optimize the HR functionalities. We require an experienced professional who can tailor the ERPNext's HR module to include: - An employee self-service portal - Recruitment and onboarding support - Performance management system - Asset management The successful candidate should be adept at customizing these modules to blend seamlessly with our current workflow. Please note, the scale of the project, in terms of the number of employees and assets, will be comm...
...comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex sales...
...applied, in terms of size, placement, and when alternative versions can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promotional or merchandise items that we may produce. - Store Design: Guidance on the color scheme, logo placement, and overall aesthetic that should be maintained in our physical store. To excel in this project, you should have a proven track record of creating brand guidelines. Proficiency in graphic design, branding, and an understanding of the pet grooming industry would be advantageous. Your work should be detailed, professional, and easy to understand. A great attenti...
...researching and analyzing market trends, particularly those related to the oil and gas industry. Key areas of focus will be on: • Exploration and Production: You should understand or be capable of acquiring knowledge about the latest trends, technologies, challenges, and strengths associated with oil and gas exploration and production. • Refining and Distribution: Closely track the changes in refining processes, distribution chains, best practices, and foresee future trends in the oil and gas industry. •the purification equipment used in Khangiran Gas Purification Plant, the technology and process, the desulphurisation and decarburisation solvents used, the monitoring and control of so...
...who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure data storage, particularly in managing Excel data, and sho...
...user-friendly and secure web login system, specifically for Windows (perhaps using AAD?). - Integration with PowerBI: The login system should be able to seamlessly connect to and display an embedded PowerBI report, ensuring smooth functionality and user experience. It is vital to only display a client's specific data in their report based on their login credentials (perhaps using row-level security?). Ideal skills and experience: - Ecperience in web development: The successful candidate should be well-versed in web-based application development, with a focus on Windows. - Experience with PowerBI: Experience with embedding PowerBI reports into web applications will be highly advantageous. - Understanding of security protocols: A solid understan...
I'm looking for someone to reorganize my Spotify playlist. Key responsibilities...following: 1. Organizing songs based on the artist. This task will require keen attention to detail to ensure that all tracks are grouped by artist. 2. Once sorted by artist, the playlist should be arranged alphabetically. This means starting from artists whose names begin with 'A' going all the way to 'Z'. 3. For artists with multiple songs in the playlist, I want their songs grouped together. So, every batch of an artist's songs should be followed by the next artist's batch in the alphabetical order. Ideal freelancers for this project should have experience in efficient data organization and a proficient understanding of music artists. Knowled...
I am launching a new enterprise and require an expert in OCR technology to design a program for me. The main function of this program would be to detect and digitize human handwriting from forms, consolidating that information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be traina...
... like sales lead generation, market research, and contact information collection. Although I did not mention a specific source site, note that the target is business owners, and their revenue and contact information. Therefore, having experience in scraping from professional networking and business directory websites such as LinkedIn or Yellow Pages would be welcomed. Lastly, the exact number of leads that I need hasn't been defined, so I am open to both small and large-scale operations. Ultimately, their quality is of more importance than mere numerical quantity. Ideal Candidate: -Proficiency in web scraping -Experience extracting from business directory or professional networking sites -Excellent attention to detail -Able to identify ...
I have a simple flowchart in Excel that I need converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which might be a plus.
...with a distinct aesthetic and features. The ideal freelancer for the task will be experienced in creating solid, user-friendly applications with a minimalist design. The key features to be implemented: - User profiles which include detailed user information - A seamless messaging system allowing users to interact - Incorporation of the ‘hashtags’ feature for keyword optimization. Understanding and being able to replicate Twitter’s functionality is crucial, but we’re going for a clean, minimalist design for the user interface. I want it to be neat, easy to use, and visually appealing. For user registration and login, I envision a tighter security system that includes: - Standard Email and password registration - Social medi...
I'm requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arrayed in table format, and I need someone to manually sift through and copy the specific fields of 'Name', 'Date', and 'Description' into an Excel file. Ideal candidate would have: - Excellent attention to detail - Proven experience with manual data entry - Proficient in Excel - Understanding of structured web content This task requires patience, a keen eye for detail, and expertise in transforming web data into organized Excel entries. Interested freelancers need to commit to high levels of accuracy to ensure all data transferred is error-free.
I'm seeking an experienced freelancer to lead a data collection project targeting mobile contact...collection project targeting mobile contact numbers from India exclusively. Key tasks: - Collect a substantial database of mobile contact numbers within India for market research purposes. - Guarantee the accuracy and legitimacy of all collected data. - Strictly adhere to data privacy and protection standards. Ideal Candidates: - Prior experience in data collection specifically with mobile numbers. - Proficiency in data mining and scraping. - Detailed knowledge of data privacy laws in India. - Market research background would be a plus. Your understanding of these requirements and your capabilities in fulfilling them will be critically evaluated. Apply ...
I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file
...Customer will sign up and login with Name & Mobile Number (OTP etc. verification required here.) 3. Customer will get Reward Points which can be redeem as per Product Purchase bases. 4. After login customer can do following: - See Products, Search Product, Add to Cart. 5. only Cash on delivery option will be there. 6. After receiving any order, it will reflect on Admin Dashboard 7. Admin/Operator will call on the given number and discuss for the delivery (offline) 8. Admin/Operator will mark Order done/reject/cancel. 9. If customer refer some other customer both will get some Reward points like new customer will get 10,000 points and referral customer will get 500 points 10. If customer wants any other brand/product other than displayed, he can sel...
Make the design and functionality of the website same as that send the reference website... And also make 6 pages ( home, services, about us, gallaery our story, news).. Provide me the images and content for the website.
