Excel reference cell by row and column number jobs
I'm looking to create a binding within Openhab for an Elmo alarm system. The binding needs to enable the following functionalities: - Remote arming and disarming of the alarm system. - Monitoring the status of individual sensors and zones. - Sending sensor states to OpenHAB items. I do have a similar project that was written in Python for Home Assistant which I can provide as reference and guidance. Ideal Skills: - Strong experience with Openhab binding. - Proficiency in Python programming. - Familiarity with the Elmo alarm system will be a plus.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge and understanding of Medical Informatics - Ability to summarize a...
...automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. ...
I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.
I need to design a new version that is better than my reference and has the same style Logo usage guidelines ,Color palette,Typography guidelines,Iconography
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.
Beginner level freealancer to create an mcq list for moodle quiz website...the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th...
...intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd col...
...combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be a...
I need an AI website that shows daily stock picks, weekly stock picks and monthly stock picks but there must be limited number of picks and there must be a paid version that shows special picks. For example, AI picks 10 stocks daily but shows only 7 of them, does not show the best first 3 stocks to buy and users need to pay monthly fee to see first 3 stocks.
...contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities, have good experience with Python, and can ensure accurate extraction of the specified player statistics from the table on the website, I'd love t...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong atte...
Create a bright and bold 12' x 40' billboard to effectively promote our B2B Virtual Assistant service. This design should turn heads, deliver a clear message, and drive results! Use the below information to craft the best billboard you can do! You may utilize some of the copy provided or create your own copy based on the information provided. Company/Service Information: • We are a US-based staffing agency that provides Virtual Assistant Services to micro-, small-, and medium-sized enterprises worldwide. • Our Virtual Assistants come from all over the world. • We have been in business for more than a decade. Our services: • Admin Support • Business Support • Marketing Support • Technical Support Industries we serve: &bu...
Provide instructions on how to restrict access to AWS WorkMail by IP address and any other ways to further improve security.
...involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for us...
...to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking
I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.
...a mix of digital and paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representatio...
...spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the us...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
...looking for Web and mobile app developers for cs cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically
...that mirrors the design and functionality of a specific reference page. The only customization needed is the branding elements – the name and logo. Key Project Deliverables: - Full WordPress site development featuring an online store - Customization of the site with a new name and logo - Advanced SEO with keyword research and implementation - Website security reinforcement Key Requirements: - Expertise in WordPress website development, particularly on an e-commerce site - Proven experience in SEO, specifically in advanced keyword research - Strong command of Arabic language and understanding of Arabic market trends - Familiarity with payment gateway integrations, particularly with credit card processing - Prior experience in website secu...
...entertainment project. This teaser should be set in a realistic forest environment and convey a mysterious and dark atmosphere. Key Points: - Entertainment Purpose: The main goal of this project is to create a teaser that captivates and engages the audience, setting an intriguing tone for the content to come. - Realistic Style: The forest setup should be modeled in a realistic style to enhance the immersion and believability of the teaser. - Mysterious and Dark Atmosphere: The teaser should convey an overall eerie and enigmatic mood, setting a mysterious tone that hints at the entertainment content without revealing too much. Ideal Skills and Experience: - 3D Motion Graphics: Proficiency in creating engaging and captivating 3D m...
...professional who can create and manage a LinkedIn marketing campaign for my AI solution company, Smoomer AI. *** If interested, send me a sample LinkedIn marketing plan for review. *** This campaign's goals are to increase brand awareness, generate leads, and drive traffic to our website, smoomer.com. It is specifically targeted at Disability Law Firms. I will be using CloselyHQ () to manage this campaign. Familiarity with this platform is a huge advantage. The main message we want to convey to this audience is our expertise in AI solutions that can benefit and improve their operations. This should be done in a way that resonates with them, highlighting how our solutions can address their specific needs and challenges. Ideal skills and exper...
...adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for re...
...data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be consi...
I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.
I need assistance with calculating the correct motor size and torque requirements for an industrial application. Key Job Details: - Use your expertise to analyze the load the motor will need to move. - The ideal motor should be able to handle the load efficiently and effectively. - I'll need detailed calculations (with reference) to be shared at the end of the project. Preferable Skills: - Experience in industrial machinery - Expertise in motor sizing and torque calculation. The motor will operate in a standard factory environment, moving a load that is constant and predictable. I would appreciate it if you could provide examples of similar projects you've worked on in the past. Attached is a similar project example.
I'm in need of a Python application that can connect around 200 Android and iPhone devices to a PC via USB cables, allowing me to perform various automated tasks and workflows on them. Key Requirements: - **Bulk Control**: The app should be able to interact with all connected phones simultaneously. I should be able to create and assign tasks to each phone individually, or define tasks that apply to all devices. - **Task Automation**: I need the app to automate several types of tasks, which include: - Web browsing or searches: The app should be able to instruct the phones to browse certain websites or perform specific searches. - App testing or usage: The app should be capable of launching and interacting with various applications on the phones. - Con...
I'm seeking a professional to assist me in creating a user-friendly sy...the seamless download of academic ebooks in PDF format. The goal is to provide a platform where users can easily access and download academic ebooks in a legitimate and secure manner. Key Project Requirements: - The system should be designed to offer academic ebooks for download in PDF format exclusively. - Academic material will be provided but needs to be refined. Ideal Skills and Experience: - Experience in web development and database management. - Proficiency in ebook handling, especially in PDF format. - Understanding of user experience and interface design. - Knowledge of security protocols for online platforms. For Sample you can download the following for referenc...
I'm in need of an HTML JS developer to refresh the front-end of my existing website. My web site uses pages that have components generated in JS. Many of the properties are created / set in javascript are difficult to support and change. I would like the properties moved to a CSS file where they can be set more easily. I need a developer who works hard and long hours like myself. Obviously excellent HTML/CSS/Javascript are essential for the right developer. May lead to more work doing exciting new development . .
Start your offer with the word in the attachment, otherwise we d...Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 ...
...professional drawing of my mixed-use building purchased in 1973. Unfortunately, the DOB and HPD don't have an original layout drawing of my property, which is hindering my process of applying for a Letter of No Objection (LNO) and obtaining a Certificate of Occupancy (CO). The preferred freelancer will have: - A track record in architectural drawing and a deep understanding of building standards prior to 1938. - Proficiency in making comprehensive drawings without original blueprints or plans as a reference. - Broad experience in designing detailed plans that are acceptable for DOB and HPD procedures. - Ability to deliver work within an agreed timeline, as speediness is crucial for this project. This is an urgent job and having previous...
...preferably one who has dealt with table detection from PDF and images before. The primary skills desired include: - Python programming - Knowledge of OpenCV - Familiarity with table and structure detection Your main task will be to develop a program that can accurately identify table structures within input files. The files will be PDFs or images, or both. You're expected to program a feature that detects these components: - Cell boundaries - Text within the cells - Overall table structure For the sake of this project, merged cells should be discerned as a single entity during the detection process. Your solution should demonstrate precision in merged cell detection. I look forward to bids from those passionate about computer vision tasks and ...
We are looking for a reliable, dedicated and knowledgeable VA on a long term basis. Our company operates within cryptocurrency and finance, making it highly beneficial that the selected VA has a strong understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collabora...
I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.
...generate leads and boost conversions at an affordable price. Key Project Details: - The campaign is aimed at both local and national customers. It's important that the specialist can tailor the ads to these specific audience segments. - The overall goal is to increase the number of leads the campaign brings in and to ensure a high conversion rate. Ideal Freelancer: - Proficient in Google AdWords and has a proven track record of generating leads and boosting conversions. - Experience in managing campaigns for both local and national customers. - Ability to work within a tight budget and still deliver effective results. - Strong analytical skills to constantly optimize the campaign for better performance. Please only bid on...
...iOS, Android, and Web, the app's functionalities must include: - Property Search: An intuitive, user-friendly interface for users to search properties. - Filter options: Users can filter search results based on different criteria. - Saved favorites: Users can bookmark their preferred properties for future reference. The app should also facilitate user interaction with features allowing: - User registration/login: Smooth user registration and login process. - Agent registration/login: Smooth Agent registration and login process. - Property listing details: Detailed information showcased for each property listing on Map. - Contact agent/owner: Messaging feature to facilitate communication between users and property agents/owners. Ideal candidat...
I am in need of an experienced Japanese to English translator. The project will consist of translating a number of documents from Japanese to English. The documents to be translated will vary in field, including legal, business, and technical documents. The ideal candidate should be well-versed in translating such material, and be able to deliver accurate and high-quality translations.
I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommo...secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Pro...
Looking for a graphic designer who can create a set of modern and minimalist branding graphics for my product. Photos shows the fruit packer robot in place over a conveyor with multiple units next to each other. Logo, branding colors and photos of machines in a factory are in the data set. Machine currently have a blue logo sticker. This will be removed and replaced with new branding. Orange should be used sparingly as there are lots of machines in a row next to each other and don't want the branding to be over powering. The front an rear needs a location for an ID numbers (shown in the photos) Clear windows can have some branding but it needs to be subtle and not obscure the view too much. The top of the machine is not visible so does ...
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including tr...
I need a creative and professional freelancer to design an impressive paper bag packaging for gifting purposes. The design should reflect a balance between aesthetics and functionality. Key Requirements: - Design an innovative bag packaging design for paper bags which are used for gifting purpose - Must have an understanding of current design trends and its impact on customer behavior. - Experience in package design preferred, especially in the realm of gift products - Strong graphic design, layout and conceptual skills About the design: - Bag colour should be pink with mild patterns in the background. - Expecting a floral design with white flowers, multi colour birds (or peacock) and green leaves with in-depth details in each element, the finish ca...
...them with an already active set with a lot of basic content (basic analysis, from set .ITs); Objective: digital sale of GREEN RIGHTS, starting in the EU and BRICS area; with option to generate some apps to upload NFT/DeFi (Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: present clearly your o...
I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English
