Excel macro saves next cell textbox jobs

Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...

i need to find wordpress plugin and make integration to my website with below detail. reservation system 1. hourly base reservation as we always work at night, today as ours is starting from 5pm until 4am next morning 2. duration (how many hours) and number of people per reservation when request reservation 3. able to post only limited rooms to online (we will make availability with only 3 salas out of 7 salas on online) 4. back end, admin has no limit to post reservation even out of open hours 5. Admin (Backend) able to move reservation hour or reduced / extend duration 6. clients can't change reservation after confirmed or can't cancel 7. reservation status showing either by color or text (sala unassigned/arrived/left) 8. able to work with stripe (payment method : c...

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

...coaches & my own personal brand. I run a short-format content agency that edits videos for coaches. Videos will be primarily talking head videos. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid 8USD for every video-edit. Paid on a per video basis (not hourly) The process is super streamlined! All videos are tailored by me -> You get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits the ...

...each topic in the training. I've attached a draft PPT which covers topics that need to be covered in detail. Below are the links to where the detailed content for each topic could be found. With the help of following content, create a detailed PPT deck for each of the topics. Each deck should contain a slide including- Prerequisites, What will be learned in this topic, what would be learned in next topic. 1️⃣ Fundamentals of Generative AI: 2️⃣ Fundamentals of machine learning: 4️⃣ Fundamentals of Computer Vision:

Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm seeking a skilled marketing professional to construct a comprehensive investment offering. This is projected to facilitate the acquisition of an apartment complex in the next 3 months. **We will collaborate on the financial projections, specific business plan, etc. - we need someone who can beautify the hard data (text/financial projections/graphs/maps) and make it digestible to read for a prospective investor. Our end goal is to have TWO forms of this investment offering (a summary teaser that is high-level, and a more granular deck that contains additional detail) that we can recycle on future acquisitions by altering text & numbers without having to re-create the entire pitch** The offering must contain: - Detailed information on the property and a projecti...

...plan that proves the viability and potential of this venture. - A strategic approach to engaging investors and securing their financial backing. - A clear explanation of how the dealership will target and capture the ATV/UTV/Watercrafts market. - An analysis of the competitive landscape and a strategy for differentiating the dealership. - Projections for growth, revenue, and profitability over the next 3-5 years. Ideal Skills and Experience: - Proficiency in Business Plan Writing: Experience in creating successful business plans that have resulted in securing funding. - Market Research: A strong understanding of the ATV/UTV/Watercrafts market, including key players and market dynamics. - Financial Analysis: Ability to develop detailed financial projections and demonstrate the fi...

I'm in need of a social media expert who can provide training across Facebook, Instagram and YouTube. Key Requirements: - Content Creation: The ideal candidate should be well-versed in creating engaging, high-quality content that resonates with our target audience on each platform. - Social Media Advertising: Knowledge and experience in developing and imp...YouTube algorithms and best practices - Experience in creating and executing successful social media advertising campaigns - Proficiency in analyzing social media data and using it to inform strategy - Excellent communication and training delivery skills, with the ability to engage and educate a variety of team members. If you have the skills and experience to take our social media presence to the next level, I'd lo...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

I'm seeking a skilled JavaScript developer with experience in to assist with my current project. The task at hand involves integrating our front-end with MongoDB Atlas to create a live search bar for machine parts. Key Responsibilities: - Connect framework with MongoDB Atlas to enable real-time data retrieval for live search functionality. - Implement a user-friendly, intuitive search bar that allows for quick and efficient product searches. - Develop a product display page that showcases detailed information about the machine parts. Ideal candidates for this position should: - Be proficient in JavaScript and have prior experience working with Next.js. - Possess a solid understanding of MongoDB Atlas or a similar NoSQL database. - Have a keen eye for design and UX to ensure a sea...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

...is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Mac...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I am looking for a skilled individual to revise my R Easy Demand System. Although details weren't specified regarding the exact areas of the system that necessitate revision, the successful ... It will be updated to become easi2. The easi package currently uses 3sls for the estimation stage. The revise version should have an option to choose either 3sls (the current method), or gmm (the method from the new script). 3. When the gmm option, allow an option to take additional covariates (instruments). The first step, is to make sure this script is working. Next, I am looking to add the script to this package: The package currently uses 3sls for the estimation, and want to add an option gmm based on the script I shared with you.

We need animated transitions using our logos to transition from one image/camera to the next like you would see in a sports tv broadcast

Budget is is in project. Don't place a placeholder amount / bid. I am here to select and not to increase budget. This project is for next 5 hours max. If you can not work now no need to bid. My developer will be available then but I am impatient and ready to hep him NOW. I am looking for a professional who can help me with troubleshooting and possibly resolving issues in my web-based API around E*Trade. We will connect/ login/ get token to use whatever needed. The task is relatively brief and should not take more than a few hours for an experienced developer. Please provide details of your relevant experience to help me make an informed decision.

...intended for placement on the homepage of our website www.icigo.com. You may utilize the images provided here : First contract details (post-contest): Here are the specifications for the remaining banners: - 1x 220x360px banner with the text "Louez. Conduisez. Profitez. ICIGO." with a punchy style. It will be displayed next to the banners in the right-sid ein some pages of our website such as - 1x 430x200px banner withe the text "Louez. Roulez. Découvrez avec ICIGO". It will be displayed in the mobile version of our index page - 2x 1300x140px banner. 1 with the text "ICIGO vous conduit, partout en Guadeloupe" 1 with the text "Votre aventure, votre voiture. ICIGO" they

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

...Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a couple hours? thoughts ?...

...(savings/current account) AND the total volume of people's personal savings in ALL other medium (stocks/bonds/ISA's/funds, mutual funds (separately REITS and other RE funds), crypto/gold/commodities/on-line platforms/crowdfunding etc) for the UK 2. Same as (1 above) for the EU (1) and (2) are urgent - next 14-18 hours 3. Not so critical but a "nice to have" - so please quote separately. The split of 1 and 2 if possible by each investment media (stocks/bonds/ISAs/etc as above in 1 and 2. This is not so urgent - say next 48-72 hours Ideal Skills and Experience: - Researching economic data - Proficiency in Data Analysis: The data provided should be relevant, accurate, and up-to-date. - Knowledge of Economic Indicators: Understanding the factors that ...

I need a proficient Matlab Simulink professional to simulate the current production in a semi-truck's solid oxide fuel cell. This should take into account multiple variables, specifically: - Temperature - Pressure - Fuel flow rate These should be varied at high levels in the simulation. With a requirement for medium precision, the model should sufficiently represent the real-world scenario without too much granularity. The goal is to understand how these variables affect the current production. The ideal candidate should have a strong background in thermodynamics, system simulations, and Matlab Simulink. Experience in solid oxide fuel cells and vehicular simulations would be a significant advantage.

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

I'm seeking a highly skilled developer to integrate Dialogflow into my ManyChat chatbot for the primary purpose of customer support. Ideal Skills: 1. Previous experience in Dialogflow integration 2. Expertise in chatbot development for customer support. Your responsibilities will include: 1. Create a HTTP request inside ManyChat flow builder tha...responsibilities will include: 1. Create a HTTP request inside ManyChat flow builder that return the answer from Dialogflow, so I can use this answer in my chatbot. A successful completion of this project involves creating a chatbot that can effectively handle customer queries, troubleshoot issues, and provide instant responses. The end product should be a tool that enhances our customer servicing system, saves time, and improves s...

I have a long audio file, and I need a simple video cre...for a creative individual with an eye for detail, who can match the images to the content of the audio. Key Points: - The audio is more than 5 minutes long, so the video will need to be of a suitable length. - You will be responsible for sourcing images that are relevant to the content of the audio. - I am looking for a slideshow style video, so each image should transition smoothly into the next. - This project is more about the visual representation of the audio, rather than complex editing or animation. Ideal Skills: - Experience in video editing and creation - Good eye for choosing and matching images to audio content - Ability to create a coherent and engaging video from start to finish - Familiarity with creating ...

Brief for Digital Marketing Agency Services Company Overview: We are a small, family-run training provider based in the UK, specializing in professional development and educational services. Our goal is to double our turnover in the next 12 months. Learn more about us at https://debrastevens.co.uk. Project Objective: We are seeking a digital marketing agency that can partner with us on an ongoing basis to enhance our online presence and drive significant growth. The agency should have a strong background in SEO, PPC, content creation, and overall digital marketing strategy tailored to the training and development sector. Scope of Services Required: • SEO and Backlinking: Improve our search engine rankings and online visibility through effective SEO practices and quality b...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

...first name Parents last name Assigned Doctor Notes from doctor Date of birth Parents contact number Parent email Next appointment date Medication needed Patient / kid user Should arrive at the login page Once logged in should have a dashboard page listing Navigation should allow them to enter a games page, info page listed at the top A welcome card welcoming the firstname + lastname on the dashboard page Info page should list the details of what is on file Patient number Patient first name Patient last name Parents first name Parents last name Assigned Doctor Notes from doctor Date of birth Parents contact number Parent email Next appointment date Medication needed Parent user Parent users should arrive at the ...

I urgently require a React / Blockchain Developer to resolve a deprecated node error within the next 24 hours. This project is time-sensitive and requires a professional with the following skills: - Expertise in React - Experience with troubleshooting node errors Unfortunately, there is no existing documentation or error logs for the project. Your ability to quickly identify and fix this issue will be crucial.

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

I need an experienced Ember.js developer to bring my project to the next level. The project requires multiple improvements. The project needs to be updated to the latest version of nodejs. I have included in the attachments the and to get an understanding of what will need to be done. Some packages are no longer maintained and alternatives will have to be found, updated or created. The project environment is set up for Linux so good if you have that setup already on your local machine. Please don't ask what the budget as it is already listed in this posting, your bid is the budget. No payout will be made until the project is complete. Key Responsibilities: - Adding new features to the existing framework - Implementing performance enhancements - Providing updates

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided