Vba excel add list references jobs

Write a heading in your bid: Your location & if civil engineer then yes /if not then no for eg. " Lucknow, yes/No" Note: please read the project details before bid . I will only consider the profile with heading only. I need Lucknow candidate for this project. And if you a...you are a civil engineer then type yes otherwise no. I'm looking for a civil engineer based in Lucknow to assist with a data entry project. The ideal candidate will have experience in construction and be able to understand the context of the data. Key Responsibilities: - Data entry from PDF files into Excel spreadsheets - Ensuring accuracy and attention to detail Skills and Experience: - Based in Lucknow - Civil engineer - Familiarity with construction project data - Proficient in Excel...

I'm looking for an Excel expert to create a financial data sheet for budget tracking. The sheet will need to: - Support budget tracking - Include automatic calculations Ideally, you have prior experience in creating similar sheets and can provide examples of your work. Your understanding of financial data and budget tracking will be crucial to the success of this project. Please ensure you have the necessary skills to create a comprehensive, user-friendly Excel sheet.

Mining and Critical Raw Materials Market Report (research) (10-12 pages) Your task will be to create a comprehensive 10-12 page report based on the already prepared and attached below presentation, references, and a provided sample report as a reference (report's graphics not required for current project. They are optimal). List of Topics for the Report: 1. Executive summary. 2. Critical Raw Materials Overview 3. Outlook Per Critical Material Raw (Material-specific trends, challenges, and advancements: copper, lithium, nickel, cobalt, graphite, rare earth elements). 4. CRM Solutions Framework (innovations in urban mining, biomining, advanced recycling technologies, and precision mining techniques. Emerging technologies for improving CRM recovery and sustainability). 5...

I need assistance in extracting data from PDF documents and entering it into an Excel spreadsheet. Data to be extracted: - Invoice Number - Date - $ Amount Looking forward to your bids!

Job Assignment: Automated Deployment of Cosmos RPC Node and Monitoring Stack We are seeking experienced professionals with strong expertise in Ansible, Bash, and Helm to demonstrate their ability to ful...and Helm. If necessary, include minimal use of other tools or techniques to enhance the deployment. Open-Source First: Prefer open-source Helm charts and repositories whenever possible. Extensibility: Optionally demonstrate advanced features like CI/CD pipelines or scaling configurations, if time allows. Deliverables A GitHub repository containing: Ansible playbooks and roles. Helm charts (or references to open-source charts used). Bash scripts (if any). A README with detailed documentation and instructions. A summary describing your approach, decisions made, and any challenges en...

I'm looking to set up a straightforward cloud flow with Microsoft Power Automate. This flow should be triggered whenever any changes occur in a specific Excel file stored in SharePoint. Key Features: - Activation of a pre-written desktop flow upon detecting any alterations in the Excel file. - No additional tasks or notifications required post desktop flow execution. - The sole trigger for this cloud flow is any sort of modification to the Excel file. Requirements: - Proficiency in Microsoft Power Automate is essential. - Experience with SharePoint and Excel is highly desirable. - Skills in setting up simple, effective automation flows. Please note, this project does not require any error handling or notifications in case of flow failures.

Job Assignment: Automated Deployment of Cosmos RPC Node and Monitoring Stack We are seeking experienced professionals with strong expertise in Ansible, Bash, and Helm to demonstrate their ability to ful...and Helm. If necessary, include minimal use of other tools or techniques to enhance the deployment. Open-Source First: Prefer open-source Helm charts and repositories whenever possible. Extensibility: Optionally demonstrate advanced features like CI/CD pipelines or scaling configurations, if time allows. Deliverables A GitHub repository containing: Ansible playbooks and roles. Helm charts (or references to open-source charts used). Bash scripts (if any). A README with detailed documentation and instructions. A summary describing your approach, decisions made, and any challenges en...

I'm seeking an experienced professional to manage and enhance our Kaufland account over the next three months. If you excel in this role, there's potential for continued employment. Your primary responsibility will be to increase sales through targeted marketing campaigns on Kaufland, as well as optimizing our product listings for maximum visibility and appeal. Previous experience with Kaufland is a must, and a proven track record of driving sales on the platform will be a significant advantage. Our marketing strategy will be focused on Kaufland-specific ads. Therefore, familiarity with the platform's advertising systems and strategies is crucial. Your ability to create compelling ad content and strategically position our products within the marketplace will be key ...

...at any time to know which vehicles were present at a certain date. It is also possible to choose which fields to export from the Vehicle tab Provides the history of vehicles on a certain date with information on totals broken down by type of management (vehicles subject to Article 36, VAT Exposed,...) Export Vehicle Data The programme allows you to export the entire list or part of it to Microsoft Excel, to Microsoft Word or to a normal text file It is also possible to choose which fields to export from the vehicle data sheet Print Declaration of Liability: Have you sold a vehicle? Do you need to print the Declaration of Liability for the customer to sign? prepare a form with your own logo, company name,... Automatically print the form with all cus...

Our Wikipedia page needs a comprehensive update. The ideal freelancer will have experience with Wikipedia editing and publishing, and a strong understanding of how to improve the credibility of a page. Key tasks include: - Removing red flags and ensuring they don't return - E...- Updating images and logos We're looking for someone who can make both minor edits and significant rewrites to links, text, and images. A mix of academic publications, news articles, and official reports will be considered for new sources. Skills and experience required: - Proven Wikipedia editing experience - Excellent writing and editing skills - Ability to source and evaluate credible references - Familiarity with replacing images/logos on Wikipedia pages - Understanding of Wikipedia'...

...addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel, Google Sheets). Strong web research...

I'm seeking a meticulous data entry expert who can assist in manually entering data from my scanned documents into an Excel spreadsheet. Ideal Skills: - Proficient in data entry - Excellent attention to detail - Familiarity with Excel Experience Required: - Previous experience with manual data entry from scanned documents is a plus - Proven track record of maintaining data accuracy

I'm looking for a skilled mobile app developer to create an engaging social networking app for Android. Key Aspects: - The app should have a clean, user-friendly interface and seamless functionality typical of high-quality social networking platforms. - Experience in building similar apps would be a huge plus. - Understanding of Android development tools and adher...Experience in building similar apps would be a huge plus. - Understanding of Android development tools and adhering to best practices in coding, testing, and debugging is essential. - Creativity and an eye for graphic design would be beneficial, but I am also open to hiring a separate graphic designer if necessary. Please only apply if you have a solid portfolio of Android apps and can provide references from pr...

Decentralized finance (DeFi) has surged as a disruptive force, solving ch...relation and based on the book of DeFi and the Future of Finance, which will be shared as well. Guidelines 1. The assignment should be well-structured, and presentation should look professional. The submission should include an executive summary, analyses, tables, charts, conclusions……etc. 2. The references should be written in APA style, including in-text citations and a reference list. 3. The word limit for the written report is between 4000-5000 words, not including appendices and list of references. 4. Please write the word count on the cover page of the assignment. Use your own words and do not copy and paste from any source. 5. The use of Generative AI is stric...

...developer to integrate the jstree-table plugin (a plugin for JSTree) into my current solution that uses both JSTabulator and JSTree. I have two working versions on CodePen – one for JSTabulator + JSTree and another for JSTree with jstree-table: - JSTree with jstree-table: - JSTabulator + JSTree: GitHub references: - JSTabulator: (excellent docs!) - JSTree: (excellent docs!) - JSTree-table: The task: Integrate the jstree-table plugin into my existing JSTabulator + JSTree solution without losing any of the current features, including sorting, filtering, editing, and synchronization

Top Skills, Strengths, and Experience: I excel in digital marketing and sales, with a proven ability to craft effective strategies that drive results. My expertise includes social media marketing, SEO, lead generation, and conversion optimization. I have strong analytical skills, enabling me to identify growth opportunities and deliver data-driven solutions. My communication and relationship-building skills are a key strength, helping me connect with clients and foster long-term partnerships. Services Offered: Digital Marketing Strategy Development: Crafting tailored campaigns to meet business goals. SEO and Content Marketing: Improving online visibility and engaging target audiences with high-quality content. Social Media Management: Creating, scheduling, and analyzing content ...

...dashboard will track various Key Performance Indicators (KPIs), which are outlined in a provided PDF. Initially, the data source will be from Excel. Language: Arabic then English Key Details: - Primary Users: The dashboard is intended for Executives, so it should be intuitive and visually appealing. - Visualizations: The dashboard should include a variety of visualizations, specifically Bar charts, Line graphs, and Pie charts. - KPIs: The KPIs to be tracked have already been defined and can be found in the PDF document. Ideal Skills: - Extensive experience with Power BI/Tableau - Ability to create executive-level dashboards - Proficiency in Excel - Knowledge of data visualization best practices - Experience interpreting and visualizing business data Your bid should ref...

I need an experienced Excel expert to correct errors on my existing timesheet salary calculator. Skills and experience required: Strong proficiency in Excel, experience in financial modelling, and familiarity with creating interactive and automated Excel sheets.

I'm looking for someone to edit my inventory data in Excel. The task involves moving data from one file to a new one with a different layout. The new layout requires: - Reordering columns - Adding new fields - Combining data from multiple sheets There are specific formatting requirements for the new layout, which includes the use of certain cell colors and font styles. Ideal candidates for this project should have: - Extensive experience with Excel - Strong attention to detail - Ability to follow specific formatting guidelines - Experience working with inventory data.

...and specific product IDs. here is the app: I have attached the locations, productids for which data needs to be scraped. I have also attached the sample data for fields which we need. Key Requirements: - Scrape data from the Costco mobile app for various locations and product IDs. - Gather a pre-defined list of information for each product (to be shared in an Excel file). - Output the data in a CSV file. Initially, I need the data for one location. If the first batch is successful, I will require the code used for the scraping as well. Ideal Skills: - Proficient in data scraping and using tools for web and app data extraction. - Experience with Python or similar programming languages for scraping and coding. - Ability to deliver

I'm seeking an experienced Amazon FBA Stock Manager to estimate stock requirements for new product launches. Your primary responsibilities will include: - Forecasting sales for current products - Managing seasonal inventory trends - Coordinating with logistics partners - Analyzing sales data The ideal candidate should h...dynamics - Experience in managing stock levels to maximize in-stock rates for both new and existing products - Ability to maintain a healthy Inventory Performance Index (IPI). Prompt communication is key, especially when informing the team about stock in China that needs to be liquidated. Skills in market demand forecasts, competitor analysis and supplier lead times are crucial. Proficiency in Excel is a must, and familiarity forecasting tools will be highl...

Please Sign Up or Login to see details.

I'm seeking an experienced Amazon FBA Stock Manager to estimate stock requirements for new product launches. Your primary responsibilities will include: - Forecasting sales for current products - Managing seasonal inventory trends - Coordinating with logistics partners - Analyzing sales data The ideal candidate should h...dynamics - Experience in managing stock levels to maximize in-stock rates for both new and existing products - Ability to maintain a healthy Inventory Performance Index (IPI). Prompt communication is key, especially when informing the team about stock in China that needs to be liquidated. Skills in market demand forecasts, competitor analysis and supplier lead times are crucial. Proficiency in Excel is a must, and familiarity forecasting tools will be highl...

I have an automated MATLAB script designed for image denoising problems (IDP). I need assistance with refining the results output, enhancing the script to combine autoencoders with a conjugate gradient optimization method, and creating two versions of the script to handle salt-and-pepper noise and Gaussian noise. Key Tasks: - Troubleshoot and improve the results output, focusing on the numbe...Experience: - Proficient in MATLAB, with a strong background in image processing and denoising techniques. - Experience with autoencoders and various optimization methods, particularly the conjugate gradient method. - Ability to troubleshoot complex scripts and improve their performance. - Familiarity with handling different types of noise in image processing. I will provide few articles as refe...

I'm looking for a comprehensive list of lawyers consultancy firms across the Europe. The list should include: - Email addresses - Phone numbers - Physical Address - LinkedIn The ideal candidate for this project should have experience in data collection and web research. Proficiency in English and familiarity with EU's legal consultancy landscape will be a plus. Please ensure the information is accurate and up-to-date. Thank you!

I'm in need of a proficient freel...companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the requirements, kindly refrain from...

I'm in need of a proficient freel...companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're not in agreement with the budget or are unable to fulfill the requirements, kindly refrain from...

...restrictions: - Visibility of Microsoft Word and Excel icons on all local users' desktops. - Display of a specific, read-only folder on the C drive on all local users' desktops. The folder is a custom one, please reach out for specifics. The technician must have Windows 11 23H2 to ensure effective troubleshooting. Microsoft's Office 2021 should be included in the XML. Ideal skills and experience for this project include: - Proficiency in creating assigned access XML files for Windows 11 - Familiarity with Microsoft Configuration Designer - Access to Windows 11 23H2 and Office 2021 for effective troubleshooting - Ability to follow specific, detailed requirements attached is the xml file i am working with, i need someone that can edit it in order for word,ex...

**Project Description: I am seeking a skilled freelancer to transform an existing employee schedule from a basic Excel format into a modern, visually appealing design. The goal is to enhance the user interface and overall aesthetics, making it intuitive and easy to navigate for both management and staff. The redesigned schedule should incorporate interactive elements and be adaptable to various devices, ensuring accessibility and usability. The ideal candidate will have experience in UI/UX design and a strong understanding of creating visually engaging digital tools.

I need a professional-grade Excel template with dropdown lists to help track visa statuses for employees. The template should have the following fields: - NAME/LAST NAME - PROFILE (Dropdown: RADS or OPS) - CONTRACT TYPE (Dropdown: FT or PT) - VISA PROCESS CALL (Dropdown: yes, not yet) - DATE (blank) - VISA (Dropdown: requested, lodged, granted, renewed) - FAMILY (Dropdown: yes, no) - VISA EXPIRES (blank) - PASSPORT NO (blank) - PASSPORT EXPIRES (blank) - RELOCATION (Dropdown: initial consultation, 5 days package, in progress) - FLIGHT (Dropdown: initial consultation, booked) - IT (Dropdown: requested, not yet) - CONTRACT (Dropdown: signed, approved, amended, in progress) - REPORTING COUNTRY (Dropdown: SCAN, UK, NA) - COUNTRY (Dropdown: AUS,NZ) - OFFICE LOCATION (Dropdown: Noosa, Sy...

...customer data. The primary focus will be on gathering staff contact information for 250 companies. I want the entire staff contact list with email and phone. This is the list of the 250 companies with their website links. Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide First Name, Last Name, Title, Company Address, Company

...interviews. Conclusion Summary: Training that includes personal experiences can significantly enhance paramedic confidence in end-of-life communication. Recommendations: Incorporate these findings into paramedic training programs. Visuals Graphs/Charts: Survey results, comparison of confidence levels. Images: Training scenarios, role-play sessions. Diagrams: Study design, data collection process. References Cite all sources used in your research. Design Tips Layout: Follow a logical flow from left to right, top to bottom. Text: Use bullet points and short paragraphs for clarity. Font: Use a sans-serif font like Arial or Helvetica; ensure readability from a distance. Colors: Use a simple, consistent color palette with good contrast. White Space: Leave enough space between sections...

I need a PowerBI dashboard to monitor project performance. The dashboard should track progress against milestones and budget vs actual costs. The data sources include Excel spreadsheets and various Cloud services. Ideal skills and experience for this job include: - Proficiency in PowerBI - Experience in project performance tracking - Skills in connecting PowerBI to Excel and Cloud services - Expert in data visualization and interpretation -Understanding of budgeting terms - developing a dashboard that can be updated by end user

I'm seeking a professional to help me generate a lead list for promoting a new physical product via WhatsApp in Kuwait. Key Requirements: - The leads should primarily target individual consumers, not businesses. - The leads must be organized by their specific location within Kuwait. Ideal Skills: - Experience in market research and lead generation. - Familiarity with WhatsApp as a marketing tool. - Knowledge of the Kuwaiti consumer market would be advantageous. I look forward to your proposals.

Please Sign Up or Login to see details.

I'm looking for a skilled developer to build an app delivering professional services (task management/organisation)...monetary/other value); that information will then need to be collated and presented to other users. Key Features: - Task management capabilities - User-friendly interface - Notifications - Capacity to involve multiple users - Users will input preferences and information will be provided/priorities will be amended based on those preferences - On the 'backend', I want it to create something like an excel spreadsheet, so data can be gleaned and used - Cross-platform compatibility Ideal Skills: - Proficiency in iOS and Android app development - Experience in building apps - Strong UI/UX design skills Please provide examples of simil...

I'm in need of a freelancer who can help me draft an audit report for a small city. The ideal freelancer for this project should be a seasoned report writer with extensive experience with Microsoft word and excel.

...Instagram Handle Date of Birth Correlation with Photo File Number The Name, Email, and Phone Number fields are critical and must be thoroughly checked to ensure zero errors. Requirements: Proven experience in data entry and handling scanned or photographed documents. Strong attention to detail to ensure data is accurate and complete. Ability to organize all extracted information into an Excel or Google Sheets file. Familiarity with automated processes (OCR or other tools) for extracting optional fields is a plus. Fluency in English for categorizing and understanding the fields. Adherence to confidentiality when handling sensitive data. Deliverables: A structured spreadsheet with all extracted data, categorized by field. Error-free entries for critical fields (N...

...support, customized control panel per user. Modern Interface: Clean, user-friendly and mobile-friendly interface. Per Message Charge: A system of charging per message sent. Users are charged according to the campaign type and sending volume. 2. WhatsApp Marketing Tools Bulk Message Sending: Sending messages to multiple people with a single click. Uploading Contacts: Uploading numbers in bulk via Excel/CSV file. Message Scheduling: Automatic sending of messages at a specific date and time. Multimedia Messages: Sending messages that support images, videos, documents and other media files. 3. Chatbot Features Auto Responder: Automatic sending of predefined responses to incoming messages. Smart Chatbot: Customizable message flows based on user behavior. Keyword Detection: Sending m...

need done 8 images according to client need

...have .com or .se domains to target the Swedish market effectively. Content in Swedish: All anchor texts and surrounding content should be written in Swedish to ensure relevance and alignment with our target audience. Proven Track Record: The consultant must demonstrate previous successful projects where a PBN link-building strategy resulted in significant ranking improvements. Case studies or references showcasing similar achievements are highly desirable. Transparency and Reporting: We expect regular updates and reports on the progress of the link-building strategy, including the domains being used, link placements, and ranking improvements. If you have the expertise, proven results, and access to a high-quality PBN network, we would love to discuss further collaboration....

I have a spreadsheet with 186 scientific references for a book I’m writing. I need the location of the downloads for each reference, and I need them formatted according to APA citations. When the downloads are free, I also want a zip file containing all the .PDF files for the article. The main goal of this project is three-fold: - Finding the download locations for each reference. - Formatting all references to APA citation. - Creating a zip file repository of the references, when free I do not have any download locations for the references, so each line item must be searched. Any invalid references should be highlighted. The spreadsheet is attached, delivery should be in Google Sheets with my data as a starting point.. Ideal Skills: - Proficien...

E-commerce Product Optimization Overview: Our website's navigation is hindered by an overwhelming number of products and outdated categories, making it difficult for customers to find and compare items. We are seeking a project-based contractor to streamline and reorganize our product categorization, improving usability and searchability for a better ...Function-Based Categorization: Products are grouped by primary function, enabling intuitive exploration, discovery, and comparison. Streamlined child categories under each parent category to eliminate redundancy. Products are assigned to the most relevant single category, avoiding cross-category duplication. Next Steps Enhanced product titles and descriptions based on logical categories Skill Sets: Excel chat-GPT Familiarity...

I'm in need of a skilled web scraper capable of extracting data from a webpage with 5,500 products. These products do not have variants, which should simplify the task. Data to be scraped: - Product name...products. These products do not have variants, which should simplify the task. Data to be scraped: - Product name - Product Part Number - Product description (The product descriptions aren't formatted the same way for each product. They are inconsistent but similar.) The final deliverable should be an Excel/CSV file containing all the scraped data, sorted by product name. Ideal skills for this project include: - Proficient in web scraping - Proficient with AI - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in ...

I require a professional who can convert my PDF files into editable Excel and Word formats while preserving the original formatting. The ideal freelancer for this job would have excellent attention to detail and experience with data conversion. After the conversion, I may need some additional services such as adjusting the layout and design or proofreading and editing text, so flexibility and a good command of English would be an asset.

...a fully freelance, remote position offering flexible hours. You will be paid per valid appointment you secure. Responsibilities: -Research & Generate Leads: Find and compile your own leads (no lead list provided) using tools like Google, Google Maps, or YellowPages. -Cold Calling: Initiate outbound calls to potential prospects, using both English and Spanish confidently. -Appointment Setting: Use our provided script (with the freedom to adapt your approach for better results) to schedule appointments with business owners. -Data Entry: Record all leads and appointments in our provided Excel templates. -Quality Assurance: Each appointment will be evaluated for validity before payment is released. Requirements: -Bilingual Fluency: Must be able to speak and write Eng...

I'm in need of a Power BI dashboard that pulls from an Excel sheet to monitor regulatory compliance deadlines for various applications. The dashboard should showcase key information, such as application deadlines, compliance status, and the departments responsible for each application. Key Requirements: - Proficiency in Power BI and Excel is a must - Experience in creating dashboards for compliance tracking is preferred - Ability to ensure the dashboard can be updated on a weekly basis, in line with the Excel sheet Ideal Skills: - Power BI - Excel - Compliance Tracking - Data Visualization - Dashboard Creation

...stylized cloud icon integrated with the initials "C" and "R" to form a recognizable symbol. Key Elements: A cloud-shaped icon with creative use of the initials "C" and "R." Subtle references to music, such as soundwaves, a record, or musical lines. Modern typography for "CLOUD 3 RECORDS," bold and clean. A metallic or gradient finish for a premium look (optional). Deliverables: High-resolution files (PNG, JPEG, SVG). Vector files (AI, EPS) for scalability. Dark and light background versions. Color Scheme: Metallic tones (copper, gold, or silver) for a premium feel. Blue or white accents for cloud references. Optional dark tones for contrast.- The design should be modern and sleek. - The logo should convey a sense of pro...

...entry skills, you can include additional skills such as using Excel formulas or knowledge of accounting software. * Define the completion time: Provide a realistic completion time estimate. * Define the budget: Indicate the budget range you have prepared. Data Entry Freelancer Required for 2024 Financial Budget Project We are looking for a meticulous and efficient data entry freelancer to help us enter 2024 financial data into a spreadsheet. This project includes: * Data: 2024 company transaction, expense, and revenue data. * Format: Data will be provided in Excel format. * Time: Project is expected to be completed within 2 weeks. * Skills: Experience in data entry, a basic understanding of accounting, and the ability to use Excel formulas are a plus. If you are i...

I've got an Excel dataset of 3500 parts that needs to be linked with their corresponding part drawings in the parts manual, which are all available as digitized PDF files. Ideal skills for the job include: - Proficiency in Excel - Attention to detail for accurate linking - Familiarity with handling and interpreting part drawings from PDF files The goal is to create a comprehensive and user-friendly reference that connects each part to its corresponding drawing.