Excel vba calculation tool jobs
Hi Hayat K., This is the offer for the job we discussed at the address: 264 NW 33RD ST, MIAMI, FLORIDA 33127 This work must include: MEP+ Fire alarms + fire safety plan (sprinklers)+ Energy Calculation !AkvrE0F9C9XU4jv03r1o8ZCuyr_h?e=3wkRhE
For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.
I'm seeking help to create a landing page that will serve as a tool for validating a market opportunity. Key Requirements: - The primary objective of the landing page is to verify the potential of a specific market opportunity. - I would like the landing page to be designed in a way that it can be measured effectively - both in terms of interest generation and data collection for market validation purposes. Ideal Freelancer: - Experience in designing effective landing pages for market research purposes. - Proficient in using analytics tools to monitor and interpret landing page metrics. - Ability to understand market potential and design a page that effectively communicates with the target audience. - Prior experience in market validation through landing pages would be a plus...
...our Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry - Attention to detail and accuracy - Ability to work independently and meet daily deadlines - Familiarity with purchase order generation is a plus. A successful candidate will not only update the inventory data accurately and promptly but will also be able to adapt to any changes in stock levels in real-time, ensuring ou...
I'm looking to hire an experienced data scientist or researcher to gather data on trending topics from Twitter. Here's what you'd do: - Leveraging Twitter's API or any robust scraping tool, you'll gather and record data around trending topics globally or as requested. - After collection, these data will need to be organized in a clear, concise and easy-to-read format. Skills & Experience: - Experience with data collection on social media platforms, particularly Twitter - Strong understanding of Twitter's API or proficient in web scraping techniques - Ability to interpret and analyze collected data effectively Please only bid if you're comfortable and experienced with large-scale social media data collection and analysis. The specific da...
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data s...
...seamless offline experience, while also being capable of working online. - The primary features of the app should focus on creating and sending invoices, as well as generating vehicle inspection reports. The app should be designed to be intuitive, practical, and user-friendly. It should streamline the process of managing invoices and generating vehicle inspection reports, making it an essential tool for our workshop. Ideal Skills and Experience: - Proficiency in Android app development - Prior experience with creating invoicing and reporting functionalities - Strong understanding of offline-online app capabilities - UI/UX expertise for an intuitive user experience - Knowledge of workshop management systems is a plus If you believe you have the skills and experience necessary t...
I'm looking for a highly skilled Shopify expert to create an online store for my car detailing shop. The store will feature a range of organizing equipment such as shelves, cabinets, tool racks, polisher hangers, brush hangers, etc. Ideal candidates will have: - prior experience in e-commerce, specifically Shopify - stellar web design skills for a user-friendly, aesthetic site - knowledge of car detailing business or related products is a definite plus but not required. Looking forward to your innovative proposals.
I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.
I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more
Access Points setup. Provision (x3 Test Devices) for now using the Software Management Tool. License/Registration only. Possible SSID, Security Settings, Guest/Staff SSIDs and other Wireless parameters if we need anything. The main thing is get them configured locally with the most basic setup and a Client Connection before we proceed to next steps on more devices. Omada Controller and Licenses available to manage the devices. Please only get in touch if you've set these up before. Unfortunately, I don't have enough time to start interviewing people. If you're confident enough then please get in touch. Immediate start.
Description: We are seeking a proficient individual or team to create a data collection tool to capture crucial information for our programs. The project involves gathering data related to attendance, classroom IDs, session IDs, and artifacts (pictures of classrooms as evidence) from WhatsApp/SMS communication channels. Project Scope: The primary data points to be collected include: Attendance records of students attending weekly sessions. Classroom IDs where sessions take place. Session IDs for each session conducted. Artifacts: Pictures of classrooms as evidence of session conduct. Schools & Instructors: Our program spans across 100 schools with 37 instructors and 13,000+ students Each instructor is responsible for conducting weekly sessions twice a week. Instructors are ...
I'm in need of an expert react developer capable of working on both web and mobile platforms. The ideal candidate should demonstrate proficiency in: - React JS and React Native. - Building a content management and publishing system. - Implementing product catalogs and shopping carts. The design has been completed, so your task will be to turn these designs into a functional tool. Your understanding of the design and its translation into a working product will be pivotal to the success of this project. There are 2 different projects. 1. E-commerce website(which is 50-70% ready)(Used react js, Node js, Mongo db) 2. real estate mobile app publishing on apple app store(it is getting rejected because of some policies, which needs to be fixed and upload app successfully on app st...
I am seeking to develop an image editing and creation tool that provides a good balance of features for both professionals and beginners like me. The tool should support: - Basic editing functions such as crop, rotate, and resize. - Filters and effects to adjust brightness, contrast, saturation, and more. - A variety of text and sticker overlays for customization. - Aspects of Photoshop’s functionality, although I am flexible and open to suggestions on this regard. The ideal candidate for this task would be someone with experience in software development, particularly in the field of graphic software, who can respect the balance between simplicity and professional capacity in the tool’s design. Your understanding of Photoshop would be an asset. Looking forward t...
...expertise on my customer relationship management (CRM) project. This task encompasses various aspects including: - CRM Development: Despite a missing specific feature request, it is assumed basic aspects of CRM will be needed i.e., sales tracking, task management, and customer management. - Image Editing Feature: This includes incorporating basic tools for image resizing and cropping into the CRM tool. - Bug Fixing: There have been some technical issues detected with the CRM, particularly relative to user interface problems and functionality hitches; I would love these resolved in due time. Given the significance and the somewhat extensive nature of the project, it is heavily required that the freelancer possesses a high level of expertise and experience with Laravel and PHP ...
Bus I'm looking to build a bus booking website for a local operator. This site will need to possess the following features: - An online booking system to streamline the reservation process - A seat selection tool, giving users the ability to choose their preferred seating - Implementation of real-time bus tracking for up-to-date travel information - An easy way for administrators to add new boarding and exit points, bus types and route details - Database of all the bookers which book through us. - Need login system in built its good if we have login with Google option in it Payment: The website should have UPI as a payment method for customers to handle online transactions seamlessly. There is currently no time limit on this project. Freelancers with experience in web deve...
...aiming to develop an artificial intelligence tool that is customizable for any kind of website development. To ensure that this project suits your skillset and capabilities, I have listed some critical requirements and preferred skills: Key Features: - The tool needs to feature automatic coding, primarily in Python. Primary Functionality: - The tool should be poised to serve all website types - be it e-commerce platforms, blog-based sites, or informational websites. Skills and Experience: - Proven experience in AI implementation - Expertise in Python and understanding of coding automation - Extensive background in web development, across various platforms In essence, my vision is to make web development optimized and streamlined by AI. A tool that not ...
... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to mai...
Provide a design and selection of fastenings for a clay tiles. The job deliverables is a calculation report.
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
...creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you could confirm whether yo...
LINE WORKS is a popular business communication tool, mainly in Japan. You dont need to it or know Japanese to help me get an access token though. I urgently need someone who can provide me with a LINE WORKS access token for my backend. The process is cumbersome and involves several times of sending data in specific formats back and forth, but it should be easy for someone familiar with the process. I will give you the specific IDs needed before you start. The instructions on the LINEWORKS dev page are only in Japanese, so you need a translation tool. Here is the link> Key Requirements: • Expertise in Lineworks API • Proficiency in Python • Ability to deliver within a tight deadline
I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.
I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.
Bus I'm looking to build a bus booking website for a local operator. This site will need to possess the following features: - An online booking system to streamline the reservation process - A seat selection tool, giving users the ability to choose their preferred seating - Implementation of real-time bus tracking for up-to-date travel information - An easy way for administrators to add new boarding and exit points, bus types and route details - Database of all the bookers which book through us. - Need login system in built its good if we have login with Google option in it Payment: The website should have UPI as a payment method for customers to handle online transactions seamlessly. There is currently no time limit on this project. Freelancers with experience in web deve...
I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.
...confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific rea...
I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.
...acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end result would result in a u...
I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experience with similar tasks and ca...
Role Description This is a contract remote role for a Content Writer. The Content Writer will create blogs and Landing pages for our online tutoring platform. We can share samples in private chat. Key points: Keywords should be SEO specific. Blogs should be infographic Images should be created using canvas or any other tool so to avoid copyright issues. <20% AI <10% Plagiarism Qualifications Web Content Writing Knowing WordPress is a plus
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm looking for a skilled professional who can assist me in entering text data into our project reports. Ideal Skills and Experience: - Experience working with project reports - Proficient in digital data entry - Attention to detail The reports will be provided in digital format, such as Excel or Word. The main task will be to ensure all text data is accurately entered. Additionally, the ideal candidate should be able to ensure the report maintains a professional and consistent format throughout. You may be asked to apply company branding or use specific fonts and sizes. The ability to work with minimal supervision and meet deadlines is a plus.
I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.
I have a PDF document that is a mix of scanned and text-based content that I need converted into an editable Word or Excel format. I need this completed as soon as possible. The output needs to be fully editable, meaning that the text should be recognized and convertible to a format where I can change, add or remove text as needed. This means the scanned parts should be OCR-ed accurately.
I'm seeking an experienced freelancer for a data entry project. The task involves converting PDF files containing mixed data, both textual and numerical, into Excel. Ideal Expertise: - Proven experience in data entry - Proficiency in Excel and PDF conversion - Accuracy and attention to detail Please ensure all data in the PDF files is correctly transferred to the specified Excel format. I'm looking to post this project up to 100 Rupees. If you have the skills and can handle this type of work, I encourage you to bid.
I have a small set of textual data that needs to be typed into an Excel sheet. The purpose of this project is to prepare the data for analysis. Key responsibilities: - Type less than 100 rows of textual data into an Excel sheet. - Ensure data accuracy and consistency. Ideal skills for this project include: - Experience with data entry. - Proficiency in Excel. - Attention to detail to avoid errors. The successful freelancer will need to deliver the Excel sheet with the data accurately typed within the given timeframe.
Design of steel stairs according to provided dimensions and detail and provide a calculation report with the drawings as well as a BOQ
Hello, i have created a logo in AI tool, but there are typos in the name, i need someone to take this JPG attached and do the following changes: 1) Change the White color to Yellow (including the text and the arrow with the charts) 2) Change to yellow color to Blue (Please note in the yellow circle there is gradients of several colors i want similar pattern in blue gradients) 3) the word CAPIITAL should be CAPITAL please note the First that will provide this logo or a very similar in PSD format will win
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Su...
I'm looki...handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational skills and attention to detail. A sound understanding of database principles and Excel function...
The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.
I'm in search of a complete script for a courier system that offers multiple shipping services. I need a ready-to-implement solution that allows managing various types of shipments, such as express, standard, scheduled, international, among others. Ideally, the script should include features such as real-time shipment tracking, integration with different transportation companies, automatic calculation of rates based on weight and destination, as well as the ability to generate shipping labels and manage online payments. If you have a script that meets these requirements or similar, I look forward to learning more details and exploring how it can be adapted to my specific business needs!
I'm in need of a professional who can help me with analyzing medication adherence rates. I need someone who knows the concept of MPR and/or PDC with experiences, so help me what data is needed to obtain these results. also know how to use Kaplan-meier method to analyze persistence data with this. The data source for ...pharmaceuticals. - Experience in working with electronic health records or similar data sources. - Familiarity with statistical software that can handle the Kaplan Meier method. - Strong understanding of medication adherence metrics and their significance. I'm open to suggestions on the most suitable statistical software to use for this project. The ideal candidate should be able to propose the best tool for this specific analysis and explain why it's ...
...amount of time spent by students on watching videos of tutors hence calculate the amount of wage payable to online tutors on the web. 5. Dashboard of tutors should show the total amount of screentime of his/her videos (which will be updated once per day) 6. Payment system which could transfer 50% of the total revenue into a pool for the wage of tutors which will then be paid to tutors in the calculation method of (=money in pool x total watch time of video of certain tutor / total watch time of videos of all tutors) and leaving the rest for the company. 7. A discount scheme which allows students from poorer families to be able to enjoy a 60% off price for the membership. 8. An application system in which students from poor families could apply for the discount which will be app...
I require the creation of a tool capable of searching for a specific keyword among hundreds of PDF files.
I'm lookin...experienced with Magento and be able to set up the website and integrate all necessary plugins and features. - Choosing and customizing a pre-made theme: I am looking for a pre-made theme that can be customized to fit the needs of a kitchen cabinet ecommerce site. - Integrating essential features: I need the site to have a live chat support, customer reviews section and a product customization tool. These features are key to the success of the site. Ideal skills and experience for this project would include: - Proficiency in Magento and its customizations - Experience with ecommerce websites, and preferably kitchen or furniture specific - Strong understanding of UX/UI design - Ability to integrate and optimize plugins for live chat, customer reviews and product...
I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats needed. TY
