Excel 2003 vba worksheet name Jobs
I'm in need of a proficient English-speaking virtual assistant with experience in Excel spreadsheets. The assistant will primarily be responsible for data entry tasks related to product inventory, invoces, and customer templated outreach. Key Responsibilities: - Extracting Text from Photos. - Managing product inventory through Excel spreadsheets - Creating product descriptions and attributes, along with photos and prices. - Performing data entry tasks on a regular basis Ideal Skills & Experience: - Proficiency in English - Strong experience with Excel spreadsheets - Previous experience with ZOHO CRM is preferred - Good understanding of data entry tasks and product inventory management. Availability: - Must be available from 10am-6pm EST time zone.
I need an Excel spreadsheet that outlines a loan amortization schedule over a 5-year period with differing interest rates. Requirements: - The schedule must account for both fixed and variable interest rates. - The spreadsheet should not contain any visual aids - just the data itself. - Include a column that shows the remaining loan balance after each payment. - The schedule should clearly show the breakdown of principal vs. interest in each payment. Ideal Skills: - Proficiency in Excel, particularly with complex formulas and functions. - Strong understanding of loan amortization and interest rate variations. - Experience in creating clear and organized spreadsheets. Include options for extra payments in the loan amortization schedule.
I need an expert in UiPath and SAP ERP for seamless integration. The primary focus is on ERP systems, specifically SAP. Main task: 1. export data from few tables based on selection screen from excel, data from 2 SAP systems 2. create table in excel Ideal Skills: - Proficiency in UiPath - Extensive experience with SAP ERP - Understanding of ERP system functionalities - Strong problem-solving skills - Excellent communication and collaboration capabilities I am looking for a professional who can ensure efficient and effective integration of UiPath with our SAP ERP system. Please provide relevant examples of your previous work in your proposal.
I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel proficienc...
...function to locate products by name or code. - Save completed orders. - Generate a PDF with order details (products, quantities, prices, discounts applied, etc.). 3.2 Order Consolidation Menu - Allow selection of multiple previously placed orders. - Generate a consolidated PDF containing all selected items, sorted by manufacturer. - Visually identify already consolidated orders (e.g., with a color change or status label). 3.3 Client Management Menu - Register and edit client information. - Assign a personalized discount for each client. - Automatically apply assigned discounts to orders placed by clients. 3.4 Inventory Management Menu - Enable adding, modifying, or deleting inventory products. - Upload and store product images. - Migrate the existing database in Excel...
... Margin Percentage: the profit margin between internal cost and displayed cost. Project Notes: a space for adding any observations or specific details. Image Upload: the ability to upload and associate images with the project. Crucial Part of the Upload Process: The image upload is one of the most important features. To correctly upload images, a Shooting List must first be uploaded in CSV or Excel format, containing the following information for each product: Product Barcode Product Code Product Category Product Gender Product Color Delivery Date (if applicable) Return Date (if applicable) These details will also serve as filters for quick search at the top of the page, allowing for organized project management. Each product will have a folder where images can be uploaded. Th...
Description: I need a freelancer to create a custom Excel template for tracking distributors of IV pump brands across multiple regions and countries. This project is for template design only—no research or data collection is required. Template Requirements: 1. Columns: • Country: Pre-filled and organized by region (see target regions and countries below). • Distributor Name: Name of the distributor (or indicate “Direct Sales” if the brand sells directly in that country). • Website: Distributor’s website. • Key Contact(s): Name, email, phone (if known). • Notes/Details: Space to input Market presence, market share, and relevant details. • Active in Market: Checkbox or dropdown to indicate whether the ...
...user-friendly interface using HTML, CSS, and JavaScript for file uploads and process initiation. Use frameworks like Bootstrap for responsive design. 2. Backend Functionality Use Flask as the backend framework. Define the following endpoints: File Upload: For users to upload Excel files. Template Management: To manage and list Word or PDF templates. Contract Generation: To fill templates with Excel data and create output files. Log Viewing: To display logs and errors to users. 3. Process Flow Excel Data Processing: Read the uploaded Excel files and save the data into a database (e.g., SQLite). Template Filling: Use docxtpl for Word templates and fillpdfs for PDF forms within Flask routes to generate the necessary documents. Parallel Processing: Utilize tools ...
Arabic Speakers Only (The job is don in Arabic language) I'm seeking a professional to assist with cleaning and categorizing a grocery product list in an accounting system. The tasks involve: Data Cleaning: - Reviewing and refin...main and sub-categories that I will provide. - Classifying each product in the list and linking it to the appropriate main and sub-categories. Work Requirements: - Previous experience with product lists and classification. - Proficient in Excel or similar programs. - High level of accuracy and attention to detail. - Ability to work quickly and efficiently. Question 1: The product list consists of more than 2000 items. Question 2: I have specific names for the main and sub-categories. Question 3: The preferred format for organizing the products is...
I have an existing Excel spreadsheet that needs a makeover. The main focus is on improving the layout and readability to make it aesthetically pleasing for presentations. Key Requirements: - Enhancements should align with a professional and clean style, devoid of unnecessary clutter or distractions. - Use of custom fonts and consistent formatting to elevate the visual quality of the spreadsheet. - Organizing sections with clear headings to guide the viewer through the data smoothly. Ideal skills for this project include: - Proficient in Excel with a keen eye for design. - Experience in creating professional-grade spreadsheets. - Ability to apply custom fonts and maintain consistent formatting throughout. Feel free to select professional color schemes at your discretion.
Please convert this provided document for PDF to editable Excel keeping source content, formatting, and visuals.
...Provide insights into sales performance by analyzing historical data to uncover trends, opportunities, and areas for improvement. Key Tasks: Data Collection: Gather and clean historical sales data, including sales volume, revenue, product details, customer demographics, and geographic information. Data Transformation: Process and transform raw data into a structured format using tools like Python, Excel, or Power BI to facilitate easy analysis. Trend Analysis: Identify patterns and trends in sales, such as peak seasons, customer preferences, and sales by region or product category. Customer Segmentation: Segment customers based on demographics, purchasing behavior, and sales history to provide tailored insights for marketing and sales strategies. Forecasting: Use statistical mod...
*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.
I'm seeking a professional with extensive experience in SQL databases and the development of a Local LLM (Large Language Model) system. The primary goal of this LLM system will be to facilitate data analysis and reporting. Key Responsibilities: - Design and implement a databse from an excel files and ten LLM system capable of interpreting and processing structured data from databases. - Optimize the system for efficient data analysis and reporting. - Ensure the system can handle large datasets effectively. Ideal Skills and Experience: - Proficiency in SQL (MySQL, PostgreSQL). - Prior experience in creating LLM systems. - Strong background in data analysis. - Excellent reporting skills. Prior experience will be validated
I'm seeking a tech consultant for creating an Excel plug-in that sends customized notifications based on user commands. The plug-in should work on both Windows and macOS. Key aspects to cover in our consultation: - Identifying the most suitable tech solutions for this project and for making a similar plug-in for PowerPoint. - Strategies to ensure the plug-in can be used on company laptops without being blocked by security protocols. - Setting up a secure landing page with payment options and unique download keys for each user. - Ensuring the source code remains inaccessible to users post-installation. The ideal candidate for this project should have extensive experience in software development, particularly in creating Excel and PowerPoint plug-ins. Familiarity with c...
...advanced Excel financial modeler to build a valuation model that compares the profitability of two potential projects. The model should incorporate a summary tab, income statement, balance sheet, and cash flow statement. The main goal is to ascertain which project offers better overall profitability. You'll be utilizing the discounted cash flow method to determine key financial metrics: Internal Rate of Return (IRR), Net Present Value (NPV), and Return on Investment (ROI). Key tasks include: - Building a comprehensive Excel model using provided key terms and assumptions. - Implementing a comparison of the two projects' key metrics (IRR, NPV, and ROI) on the summary tab. - Ensuring the model is fully functional and user-friendly. Ideal skills for this job incl...
I'm seeking an Excel professional to update an old worksheet. The task involves: - Adjusting custom formulas and calculations - Correcting errors in existing data - Adding new data entries - Removing outdated or incorrect data - also bulid a follow-up plan with for each team member and teams - Optimizing existing formulas to improve performance - Generating visualization charts for better data representation - Automating routine tasks using VBA or macros - Updating cell formatting for consistency and readability - Linking to external data sources for real-time updates Ideal candidates should possess: - Proficient Excel skills - Experience with custom formulas - Strong data entry and correction abilities The task should be quick for an expert. The new da...
I'm looking for a professional who can capture live data from the Nifty option chain and deliver it to me in Excel. Key Requirements: - Capture specific data points: Strike prices, Volume, and Open Interest - Update frequency: Real-time Ideal Skills and Experience: - Proficient in data capturing and analysis - Experienced in working with financial market data - Able to deliver data in Excel format The data should be updated every minute. Capture additional data points as specified. Data should be captured using the official exchange API or broker terminal. Include charts and graphs for visualizing the captured data. Include line,bar charts for visualizing the captured data.
I'm looking for a comprehensive list of email contacts for city administrators and city events coordinators in Chicago and every suburb within 50 miles. Requirements: - Contacts should primarily be government officials. - List should include full name, email address, and job title for each contact. - Final deliverable should be in an Excel spreadsheet. Ideal skills and experience for the job include: - Proficiency in data collection and research. - Prior experience in generating contact lists, especially in public sector. - Ability to deliver clean, well-organized data in specified format.
Packaging a Kivy App for Android I have developed a Python-based app using Kivy that I want to package for Android devices. The app includes the following features: 1. Dependencies: The app processes Excel files using pandas. There also an image. 2. Widgets and Code: The rest of the app consists of Kivy widgets and Python code. Current Challenge: I am using Windows as my primary development environment and need assistance with: 1. Setting up a functional Linux environment (e.g., WSL, Virtual Machine, or Docker) to support Buildozer. 2. Configuring Buildozer to successfully package my app into an Android .apk file. 3. Resolving any issues related to the inclusion of pandas and other dependencies. 4. Ensuring the images and other resources are properly bundled with...
I'm seeking a skilled Pytha 3D modeller proficient with Pytha software, who can help create detailed models for a Media Wall Unit. The main focus of this project is to develop 3D mode...details required. 1. Create 3D Shop Drawings insert dimension, having parametric properties to change the dimensions of the cabinet easily. 2. Generate cutting list of panels exported in an excel sheet 3. Cutting list exported to an optimiser for the total number of plywood panels required. 4. Exploded design drawing 5. Label showing the panel name, picture of where the dowel holes are located, edging sides. 6. Insert connectors such as screws, dowels and fixing systems. 7. Bill of materials generation with required hardware such as drawer rails, connectors, hinges and dowels with export...
I would like to create a sales tracker on excel. I want the sales data sheet to have the following information: date of first appointment, lead number, source, call duration, outcome, date sold, product, units sold, finish, discount, book price, price left, core price, split (%), conservation area (yes/no), building work (yes/no), next action date, notes. I would like the excel document to calculate the following: overall/monthly/weekly conversion rate in decimal (sales appointments / sales), overall/monthly/weekly core price, average split percentage (weekly/monthly/overall, weekly/monthly/overall commission earned and monthly uplift earned (more details on this when needed), average conversion rate per units sold <5, 5-10, 11-15, 15+, average sales conversion on firs...
I'm in need of a seasoned data scraper with extensive experience in collecting information from LinkedIn Sales Navigator. I am aiming to gather data on 77K HR professionals. Specific Data to be Scraped: - Name - Job Title - Company - Email Address - Phone Number - LinkedIn Profile URL - Location - Industry - Years of Experience - Gender Deliverables: - The collected data should be delivered in an Excel spreadsheet. - This is a one-time data collection project. Ideal Skills and Experience: - Proven experience in data scraping, particularly from LinkedIn. - Proficiency in Excel and data management. - Excellent attention to detail to ensure data accuracy. - Ability to handle and process large volumes of data. Please only apply if you have the required skills an...
3d modelling city name sign and rendering
I'm in need of a seasoned market analyst who specializes in chart patterns. The primary focus will be on identifying entry and exit points using specific patterns: Head and Shoulders, Double Top/Bottom, and Cup and Handle. Ideal skills for this project: - Expertise in chart pattern recognition - Proficiency in stock market analysis - Ability to ...Shoulders, Double Top/Bottom, and Cup and Handle. Ideal skills for this project: - Expertise in chart pattern recognition - Proficiency in stock market analysis - Ability to identify potential entry/exit points - Proficiency with technical indicators like RSI, MACD, and Bollinger Bands. Your role will be crucial in helping me effectively navigate the stock market. Please provide the analysis in an Excel spreadsheet with all releva...
I'm seeking a meticulous data entry specialist to help me input product details sourced from the internet into an Excel spreadsheet. Key Responsibilities: - Researching and sourcing product details from online platforms - Accurately inputting the data into an Excel spreadsheet Ideal Skills: - Proficiency in Excel - Strong attention to detail - Experience in data entry and online research - Ability to meet deadlines The project will involve entering details for between 100 and 500 products. The freelancer can use a customized format for organizing the product details in the Excel spreadsheet. The data entry will include collecting and entering the product name and price. Please include the product description as well. Please include the followin...
I'm looking for an Excel expert to create a recipe calculator for me. This calculator should have the functionality of scaling recipes by a percentage. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating complex Excel tools - Understanding of recipe scaling Please let me know if you can help.
I'm seeking a professional to assist with a creation of 10 photos for a my website. - Existing photos : I need you to create gif with my photos and videos for my tree products - Data Format : need you to list what you have done in a Spreadsheet (Excel/CSV).
Project Description: We require an experienced professional to create a customized report from an Excel database. The project involves: 1. Extracting and organizing specific data from the Excel file. 2. Designing a visually appealing and functional report format. 3. Ensuring the report can be generated dynamically if required. 4. Delivering the final report within 01 hours. Requirements: • Proficiency in Excel (advanced functions, pivot tables, macros, etc.). • Experience in report generation and formatting. • Attention to detail and ability to deliver on tight deadlines. • Knowledge of integrating Excel data into other reporting tools. Please include examples of similar projects in your proposal and specify how quickly you can comp...
I'm in need of a skilled programmer who can create an Excel VBA plug-in for me. The primary function of this plug-in will be to detect user actions within Excel and display selected messages on the top corner of the screen. Ideal skills and experience for the job include: - Proficiency in Excel VBA programming - Experience in developing Excel plug-ins - Knowledge of creating and linking macros to buttons Please only apply if you can deliver a high-quality, efficient solution.
Hello, i've some troubles with Vlook and i need help, see attached file
Determine if an employee came late or early, left late or early, took a 30 minute break or not when applicable
Hi, I want this website to be scrapped. Please check the sample page which I want following data to be extracted Name,Designation,Mobile No, Email There is also data of the Sarpanch and Secretary on the same page but not in the table. Somehow I also want their contact information. I want all data of U.P to be extracted and put in Excel sheet. the scrapper shud go into each District Panchayat Name> Panchayat Samiti Name> Village Panchayat Name> and then take out members name/contacts/emails.
Bitte melde dich an oder Loge dich ein um Details zu sehen.
...will parse XML files and extract relevant details into a predefined Excel format. Essential Features: - The software should specifically extract relevant information from the XML files. - The utility should follow a modular approach. This means every component should be independent and interchangeable. - A key requirement is the reusability and extensibility of the codebase. The software should be built in such a way that it can be easily adapted for future use or extended with new features. - The software should include robust error handling mechanisms to manage various XML parsing errors and data extraction issues. Ideal Skills and Experience: - Proficiency in Java is a must. - Prior experience with XML parsing and Excel file creation. - Strong understanding of modular...
I'm looking for a machine learning expert who can help me analyze my financial data in Excel. The main aim is to identify trends over time which could help in forecasting future performance. Key Requirements: - Proficient in Excel and machine learning techniques - Experience with financial data analysis - Ability to identify and interpret trends over time The ideal candidate will have a strong background in data analysis and machine learning, specifically with financial data. You should be able to deliver insights that could help in forecasting future performance based on identified trends.
... and KYC (Know Your Customer) integration for identity verification. Secure login using JWT (JSON Web Tokens). Technical Details: Implement APIs for user authentication (register, login, logout), verification (email, phone), and KYC integration (e.g., using Jumio or Onfido). Package Management: Create, edit, delete, activate/deactivate package listings. Multi-step form for package details (name, description, availability dates, location, price). Display a list of created packages. Technical Details: Implement CRUD (Create, Read, Update, Delete) operations for package management via APIs. Orders & Tracking: View a list of orders placed on their packages. View detailed order information (sender, receiver, delivery address, status). Real-time order status updates (e.g...
I'm looking for a skilled data extractor to assist me with a project involving a large PDF file. The...extractor to assist me with a project involving a large PDF file. The document has over 800 pages and contains tables with more than 3000 rows. Here's what I need: - Data Extraction: The data is mixed, containing both text and numerical values. - Excel Representation: The extracted data should be accurately represented in an Excel file. The tables in the PDF have a consistent layout throughout the document, making the extraction process more straightforward. Ideal skills for this project would include: - Proficiency in data extraction - Advanced Excel skills - Attention to detail to ensure accurate data representation. Please reach out if you have th...
I'm seeking an Excel expert for a 2-hour project. Example work : i have 10 sheets with C column as commodity column in excel. i want distinct names from all those sheets in my existing sheet named "LEDGER" I have asked ai, but i need someone who can do. The data to be processed will include financial data.
I want to convert my Google Slides presentation to Video and my Google Slide's Narrator Notes/Editor notes should be Artificial voice over for the output video. After Video conversion Video should be uploaded to my YouTube channel at specific mentioned time. (Approx Every day 4:00PM) Points to consider below: 1. This automation shoul...Different customizations will be applied for each regional language. Please ensure the Artificial voice over files are provided in MP3 format. Implement a weekly backup schedule for all video files and project data to avoid data loss. The initial videos will be reviewed and approved by the client before final upload. The separate data for video titles, thumbnails, and descriptions will be provided in Excel format. No subtitles will be included...
I need an Excel specialist who can help me with a project focused on financial tracking and budgeting. Key Responsibilities: - Design an Excel sheet for comprehensive financial tracking. - Create a budgeting tool within the Excel sheet. - Incorporate graphs and charts for visual interpretation of data. Ideal Skills: - Proficiency in Excel, particularly with budgeting and financial tracking tools. - Experience with data visualization in Excel. - Strong understanding of financial management.
We have PDF copies of timesheets from our construction crews (approximately 100–150 sheets, each covering 5–20 personnel). These timesheets are submitted by the end of the day on Monday, and we require them to be entered into an Excel spreadsheet for upload into our software by Tuesday morning when the office opens. This task will be required once a week for the next three months. We can provide the employee names in Excel format, enabling data validation to improve accuracy. This is an urgent requirement. Please let us know if you can assist. Thank you!
I'm looking for an Excel expert to help me consolidate information from individual staff timesheets into a master view. Key tasks: - Total hours worked and all related hours into a comprehensive weekly view. - Utilizing separate Excel files for each employee's timesheet. - Designing the master view in a standard table format with appropriate graphical representations (charts). Ideal candidates will be proficient in Excel, have experience with data consolidation and analysis, and be able to create clear and informative visual representations of data. Please utilize bar charts for graphical representations.
I'm seeking a professional to create a project management spreadsheet for a small team of 1-5 users. The spreadsheet needs to have specific functionalities: - Task assignment and tracking:...management spreadsheet for a small team of 1-5 users. The spreadsheet needs to have specific functionalities: - Task assignment and tracking: The ability to allocate tasks to team members and monitor their progress. - Timeline and milestones: A clear representation of project timelines and key milestones. - Googlesheets -Top overview of the days todo Ideal candidates should be proficient in Excel or Google Sheets, with a strong understanding of project management principles. Experience in creating similar spreadsheets is highly desirable. Please include examples of your previous work in...
I require a statistics expert to analyze some survey data using descriptive statistics. The analysis should be done in Excel. Ideal Skills and Experience: - Proficient in Excel for data analysis - Strong understanding of descriptive statistics - Experience with survey data analysis - Ability to present findings in a clear, understandable manner
I need an expert in Excel Macros who can create a workbook that can filter data based on specified criteria and generate both Word documents and PowerPoint presentations. Our corporate team should be able to click through the applicable criteria in the excel workbook and then have this generate a word doc and/or powerpoint with all the needed information. The output should be well-structured and organized chronologically, although custom-lay out and creative ideas are welcomed. The data to be included in these documents will encompass: - Tables and graphs - Text summaries - Images and diagrams Ideal candidates for this project should possess the following skills: - Proficient in Excel Macros - Experience in automating Word and PowerPoint from Excel...
I need a precise Excel spreadsheet that will automatically pull player statistics from Breaking Point. The spreadsheet should be user-friendly, allowing me to add new data weekly without complications. Requirements: - Expertise in Microsoft Excel: The freelancer should be highly skilled in creating complex, automated spreadsheets. - Web Scraping: The project involves extracting data from the internet, hence the freelancer should be proficient in web scraping. - Understanding of Sports Statistics: Familiarity with player statistics and sports data will be advantageous in understanding the project's requirements. - Good Communication Skills: The freelancer should be able to explain how to update the spreadsheet in simple terms. Please note, a good payment will be provide...
...ODOO system is used to manage leads, sales, inventory, and finances, but there are gaps we aim to address to optimize our workflow. --- ### **Current System Overview** 1. **Lead and Proposal Management:** - CRM is fully configured and operational for managing leads and opportunities. - Proposals are created in Odoo, but material and labor cost calculations are performed externally using Excel spreadsheets. This is what we aim to unify within the system. 2. **Inventory Module:** - Fully configured, with tracking for material entries and exits. - Not connected to proposals or projects, and there is no material traceability by project. 3. **Purchasing Module:** - Suppliers and products are registered in the system. - Purchase orders are not yet generated autom...
...into a single Excel sheet. Key Requirements: - Transcribe both textual information and numerical data accurately - Import all data into a single sheet in Excel - Attention to detail to ensure all information is captured correctly - Provide specific guidelines for data formatting within the Excel sheet. - Clearly specify the date formats to be used if the handwritten notes contain date information. - Ensure that all data remains confidential and is handled securely. - Establish a procedure for dealing with unclear handwriting to minimize errors. Ideal Skills and Experience: - Proficiency in Excel - Experience with data transcription - High level of accuracy and attention to detail - Ability to work with mixed data types Please use a table format for the la...
I'm currently seeking a skilled professional to help me improve my proficiency in Excel and other Microsoft Office applications, with a specific focus on data analysis and visualization. Ideal Skills: - Extensive knowledge of Microsoft Excel - Proficiency in other Microsoft Office applications - Excellent teaching and communication skills - Experience with data analysis and visualization techniques Key Areas of Focus: - Mastering Excel: I need to focus on data analysis and visualization techniques in Excel. - Proficiency in Microsoft Office: I want to enhance my overall Microsoft Office skills. I'm looking for someone who can provide me with practical lessons and exercises, tailored to my current skill level and learning pace. Your ability to commu...