Data validation in excel 2007 jobs
I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience ...
I need a meticulous professional to assist with data entry from scanned documents. The data consists of both text and numbers, and needs to be accurately transferred into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Prior experience with data entry from scanned documents - Ability to handle mixed data types (text and numbers) - Strong organizational skills
I'm looking for a ...looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please fee...
I need assistance with an Excel task. The project involves adding rows in Excel based on a specified number in a cell. Key Requirements: - Adding new rows containing specific formulas - Ensuring that the formulas in the new rows reference fixed cells Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in working with Excel formulas - Detail-oriented with a good understanding of fixed cell references in Excel
I'm looking for an expert in ArcGIS Pro to verify and rectify my water utility network datasets. This task is urgent and needs to be completed within a single day. Task Details: - Check 3-5 datasets for geometry and topology rule compliance - Identify and rectify missing connections - Fix incorrect geometries - Resolve violations of topology rules If you have a strong background in GIS, particularly with water utility networks, and can work quickly and accurately under time pressure, I would love to hear from you.
I am looking for a skilled virtual assistant to help with various tasks. ...prioritizing, and responding to emails as necessary. - Scheduling Appointments: Coordinating my calendar and scheduling meetings. - Data Entry: Accurately inputting information into various systems. Essential Skills: - Customer Service Experience: Ability to handle queries and concerns professionally. - Proficiency in Microsoft Office: Particularly Excel, Word, and Outlook. - Social Media Management: Overseeing and updating my social media accounts. Preferred Communication: - Primary communication will be through Email. Ideal Candidate: - A proactive individual with excellent organizational skills. - Able to manage tasks independently and efficiently. - Prior experience in simi...
I'm looking for a ...looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please fee...
...With expertise in ghostwriting and editing, I’ve crafted engaging content across multiple formats, including biographies, memoirs, e-books, fiction, non-fiction, websites, blogs, and product descriptions. Since 2016, I’ve been a full-time freelance copywriter with double Digital Marketing certifications. With a keen eye for detail and a passion for linguistic precision, I am well-equipped to undertake the comprehensive proofreading and editing of any book. I have a proven track record in editing various written materials, including books, with a focus on preserving the author's voice while refining clarity and coherence. With a decade of hands-on experience in the book world, I am eager to provide valuable suggestions to improve content, flow, and ...
...calculations. We need an experienced MySQL developer to extend this cursor with additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsheet. • Update a different table using simple IF conditions based on the calcu...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
...with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Ideal skills and experience: - Extensive experience w...
I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.
...to identify profitable wallets worth copying, based on reliable data metrics such as Profit and Loss (PnL), win rate, and performance over weekly/monthly timeframes. The current implementation is plagued by inaccurate or false data, resulting in wallets with near-zero balances being reported as highly profitable. Despite trying multiple APIs (Solana public API, GMGN API, and BirdEye API) and even scraping data from relevant websites, the results have been inconsistent and unreliable. This project requires a solution that not only filters out fake or non-credible wallets but also provides a robust mechanism to analyze and verify real-world wallet performance. Key Objectives: 1. Data Accuracy: - The output data must accurately ref...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
I'm looking to develop a dynamic mobile application for both iOS and Android. This ...sign-up authentication system is crucial, specifically employing SMS verification as the primary method of user validation. - The app should include a back-end system that allows for easy updates of the PDF documents. - The app also contain notifications system for users. Ideal Skills: - Proficiency in cross-platform mobile app development (preferably with frameworks like Flutter or React Native). - Experience in integrating multimedia content within an app. - Knowledge of implementing secure and reliable user authentication systems. - Ability to create and manage a user-friendly back-end for content updates. This project is perfect for a professional with a solid portfolio ...
...past clients to collect testimonials and success stories that highlight our impact. Marketing Campaign Management Create eye-catching email campaigns using Constant Contact to drive leads and conversions. Develop engaging marketing materials in Canva that stand out in the real estate market. Buyer Engagement Speak with wholesale buyers to understand their preferences and ongoing real estate deals. Build and maintain strong relationships with buyers to streamline deal closures. Transaction Coordination Serve as the point of contact for all parties involved in real estate transactions (sellers, buyers, title companies, etc.). Ensure all documents, contracts, and deadlines are completed accurately and on time. Track progress throughout the transaction process, addressi...
I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail
I am seeking a proficient ...seeking a proficient freelancer with expertise in automating data entry tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minima...
...placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept...
...separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the outline and flo...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
...Deploying the system in a professional or public setting, collaborating with stakeholders, and gathering user feedback. Impact Validation: Ensuring measurable outcomes, such as reducing false positives by 15%, and preparing documentation that highlights the project’s real-world results. Deliverables Fully Functional System: A working prototype with key features. Implementation Report: Details of deployment and stakeholder feedback. Outcome Showcase: Materials to highlight the system’s measurable impact and ethical considerations. Budget and Timeline Total Budget: $130, allocated for development, testing, and deployment. Timeline: 6 weeks, including system creation, deployment, and iteration based on feedback. This project aims to not just build a tool but to de...
I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.
I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates
I am looking for a highly skilled freelancer to resolve an i...domain verification and error codes on a specific platform. This is not a web development project but a targeted fix for an issue involving API responses and verification logic. Requirements: Experience in troubleshooting and resolving API-related errors. Familiarity with email verification systems and domain validation processes. Ability to analyze and manipulate request/response logic efficiently. Proven track record of solving similar issues in a timely manner. Budget: $600 (Expected resolution within hours if you have the relevant experience). If you have the expertise and are confident in your ability to fix the issue quickly, please submit your offer. I will provide the necessary details onc...
I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.
I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous work with travel-...
I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.
...(using Twilio Speech Recognition), and automatically register the details in our backend system. Send an automated confirmation SMS or email to the visitor after successful registration. SMS Registration Automation: Integrate Twilio’s SMS API to automatically process incoming SMS with the license plate number. Parse the SMS content to extract the license plate number and validate it. Register the license plate in the backend and send an automatic confirmation to the visitor via SMS. Backend Development: Develop the necessary backend logic to handle the registration, validation, and storage of license plate numbers. Ensure the registration process is seamless, with automated error handling and fallback mechanisms if data is invalid or unclear. Confirm...
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
Custom PHP Script for Batch Code Update in MySQL Database I am looking for an experienced PHP developer to create a simple and effective script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warning message, rather tha...
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
I need my Excel data modified for better visual appeal and branded to match my website. Requirements: - Apply custom themes and colors to the Excel file. - Incorporate my website's color scheme and font style. - Add my contact number to the header of the Excel file. There's no need to change any of the data, as everything has already been filled.
...using CKEditor, the field crashes and cannot continue. Requirements: Identify and resolve the problem that prevents the correct use of CKEditor in modal windows. Ensure that CKEditor functions (e.g., insertion of images, HTML code, and other elements) are working correctly. Test compatibility on multiple browsers and devices. Complete deletion of tasks, users and other items 2. Requirements: Ensure that deleting tasks, users or other records from the system also removes them from the database. For related attachments: -Safely delete the associated files from the server. -Check that no orphaned files remain after deletion. -Implement validation tests to avoid incomplete deletions or errors during the process. 3. File upload management General requirements: Ensure that ...
I have an Excel sheet with text data in various columns that needs to be sorted according to a specific sequence. The task involves: - Identifying the text data in the columns - Sorting this data following a predetermined custom sequence Ideal candidates for this project should have: - Proficient Excel skills - Experience in sorting data according to custom criteria - Attention to detail to ensure all data is sorted accurately according to the specific sequence
I need someone to create a excel spread sheet to show and auto populate the following cost and expenses Labor Costs: Track employee hours worked in each service category using timesheets or a time tracking system. Record the hourly wage for each employee. Calculate daily labor cost: (Number of employees) x (Hourly wage) x (Hours worked). Supply Costs: Maintain a daily log of all supplies used in each service category. Record the quantity and unit cost of each supply item. Calculate daily supply cost: (Quantity used) x (Unit cost) for each item, then sum up all item costs. Vehicle Mileage: Record the starting and ending mileage for each company vehicle used daily. Calculate the total mileage driven for each vehicle. Fuel Consumption: Collect and retain all gas card rece...
I need an Excel spreadsheet designed for daily expense tracking and financial calculations. The ideal freelancer for this project would be someone with strong Excel skills, particularly in creating formulas and functions for financial analysis. Key Requirements: - Create an Excel spreadsheet for daily expense tracking - Implement financial calculations within the spreadsheet - Ensure the spreadsheet is user-friendly and easy to update Skills & Experience: - Strong proficiency in Excel - Experience with financial spreadsheets - Excellent attention to detail
...portable thermal printers, overseeing stock in delivery trucks, and locating customers on a map. Key features should include: - Stock Management: The app must effectively manage inventory on delivery trucks. - Customer Location: It should assist in pinpointing customer locations on a map. The app needs to function offline with both automatic and manual data synchronization when internet access is available. The dashboard, meant for advanced analytics, should track: - Top Customers - Best-Selling Products - Delivery Staff Performance This dashboard will have role-based access to limit sensitive information. Additionally, the app should support importing a client database from Excel. Ideal skills and experience for this job include: - Proficiency ...
I'm looking for someone to gather various data about food and beverage products from the internet. This includes information such as the manufacturer, marketer, country of origin, and ingredients. Key Responsibilities: - Research and collect data from official websites and retailer sites. - Compile the data into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in online research. - Experienced in data collection and data entry. - Familiar with food and beverage products. - Able to compile information into a clear and organized Excel spreadsheet.
...uploaded documents directly in a separate tab without providing any option to download, print, or save the document. The plugin should enable users to open documents such as PDFs, Word files, and Excel sheets seamlessly while ensuring that the document cannot be downloaded or copied in any way. Security is a top priority, and the plugin must implement robust measures to protect the documents from unauthorized access or sharing. The plugin must be compatible with the latest version of Moodle and integrate smoothly with Moodle’s existing file management system. It should have a user-friendly interface for both administrators and users, ensuring a hassle-free experience. The ideal developer should have proven expertise in Moodle plugin development, with s...
We are seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab for our HR team. The project will involve leveraging pivot tables and other advanced Excel functionalities to create an interactive and automated reporting tool that provides clear insights into key HR metrics. The ideal candidate will have a strong background in data visualization, formula optimization, and dashboard design to ensure efficiency, accuracy, and ease of use. Our goal is to enhance data analysis and reporting capabilities, allowing the HR team to make informed decisions effectively. Delivery flexible but ideally within 2 or 3 weeks
...necessary validation and error handling - Create a basic test suite - Establish a scalable architecture for future enhancements Tech Stack: - Frontend: React + TypeScript + Tailwind - Backend: Node.js/Express + MongoDB - Containerization: Docker Deliverables: - A working prototype with API integration - A basic testing framework - Comprehensive documentation - Deployment setup Key User Role: The system will cater primarily to the Customer user role. Critical Validation Checks: The essential validation checks for the system will include Payment confirmation and Delivery schedule availability. Ideal skills and experience for the job include: - Proficiency in the specified tech stack - Prior experience with API integration - Knowledge in developing...
...Building and training a GAN-CNN hybrid model for CHD detection. Validation: Testing and validating the model to generate results, including metrics like accuracy, sensitivity, and specificity. Deliverables: Fully functional code (Python/TensorFlow/Keras, Google Colab preferred). Final results and visualizations (accuracy metrics, confusion matrix, etc.). Proper documentation of the steps and methodology. I have an example Google Colab notebook that can be shared as a starting point. The preferred deadline is Monday, January 13, but I can extend the timeline slightly if additional time is needed to ensure quality results. Skills Required: Expertise in Python, TensorFlow/Keras, and deep learning. Experience with GANs and CNNs, particularly in medical imaging or rela...
...Machine Learning specialist with experience in large language models (LLM), specifically Llama 3.1. The objective is to configure a training environment (on-premise or in the cloud), for training a specific model for analyzing responses to a sociological survey, fine tuning the model must be carried out and an evaluation pipeline must be designed. The objective is to collaborate with a research team to train a unique and specialized survey data analysis model. Main responsibilities: Configure and maintain training infrastructure (PyTorch, Python, GPU, etc.). Collaborate in the selection and cleaning of data. Adjust the Llama 3 model to respond to specific sociology prompts. Monitor and evaluate the quality of responses (metrics and validation...
Project Summary: Enhancing Office Productivity with MS Office Suite In this project, I leveraged the full potential of Microsoft Office to streamline business operations and enhance productivity. My expertise in MS Office applications, including Word, Excel, PowerPoint, and Outlook, allowed me to deliver high-quality results tailored to meet specific client needs. Key Achievements: Document Creation and Formatting: Created and formatted professional documents, reports, and proposals using Microsoft Word. Implemented advanced formatting techniques and customized templates to ensure consistency and professionalism. Data Analysis and Visualization: Developed complex spreadsheets in Excel to analyze financial data, track budgets, and visuali...
If you you...you bid to consider, please send me in message .. a sample infographic/chart based on the excel file I am attaching here: _____________________ I'm in need of a freelancer skilled in database analysis and Microsoft Excel. The project involves analyzing demographic data from an Excel spreadsheet. Key Responsibilities: - Conduct descriptive analysis on provided demographic data. - Create charts and infographics to illustrate findings. Freelancer Requirements: - Proficiency in Microsoft Excel. - Experience in data analysis, particularly with demographic data. - Ability to create visual representations of data (charts, infographics).
I need a professional to conduct regression analysis, ANOVA tests, and write a brief report on their findings. Key Requirements: - Perform regression analysis (exact type to be determined) and ANOVA tests - Write a concise report detailing the findings - Deliver the report in an Excel file Ideal Skills: - Proficiency in statistical analysis and software - Experience in writing analytical reports - Strong understanding of ANOVA and regression techniques
