Asp ms sql dataemplois

I'm seeking a proficient Python expert who can assist with script editing and fixing. Your primary task would revolve around addressing logic errors within my script starting from some instruction I will provide. This role perfectly fits an individual with in-depth Python understanding and extensive experience in dealing with logical errors and fixing scripts-resultantly enhancing ...Python understanding and extensive experience in dealing with logical errors and fixing scripts-resultantly enhancing overall script performance. A first problem is that the script seems bound by particular dependencies and being poorly documented it is difficult to understand what causes the startup problem. Fixed that, we will move to the final editing of the script used to save output data...

Interactive Looker dashboard 1 Layout Data come sql server 4 tables pivot in excel

...Ability to send an email notification to me whenever a form is submitted. - Save submission data to a database for future reference and access. - Integrate seamlessly with our CRM system to streamline lead management. **Form Fields Required:** - Must include fields for Name, Email Address, Phone Number, and Location. - The flexibility to add other fields as necessary depending on future requirements. **Display Preferences:** - The form should be integrated as a sleek sidebar widget that doesn't intrude on the user's browsing experience but is easily accessible. **Ideal Skills and Experience:** - Proficient in WordPress plugin development with a solid understanding of PHP, JavaScript, and SQL. - Experience with WordPress API and email handling within Word...

OPEN POSITION: Data Base Developer ROLE RESPONSIBILITIES : -Develop and maintain our database system using PHP and SQL. -Optimize database performance for efficiency and scalability. -Collaborate with the development team to implement new features and functionality. -Troubleshoot and resolve database issues in a timely manner. -Stay updated on industry best practices and technologies. REQUIREMENTS : -Proficiency in PHP and SQL is essential. -Experience with HTML -JavaScriptand/or React is a plus. -Strong problem-solving skills and attention to detail. -Excellent communication and collaboration abilities. -Passion for gaming and travel is a bonus! Part time job 300 USD/Month

Overview: Seeking experienced Core PHP developer to update existing APIs and...measures and authentication. * Test thoroughly for bugs and optimize performance. * Coordinate with team for front-end integration. * Provide documentation and support. Requirements: * Proven Core PHP API development experience. * Familiarity with maintaining and updating APIs. * Proficiency in RESTful API development. * Experience with JWT/OAuth and OTP platform integration. * Strong MySQL and SQL query skills. * Effective communication and collaboration. * Git version control experience. Duration: 4-5 weeks from Feb 20, 2024. Note: Interested candidates are requested to provide their resumes along with relevant work samples showcasing their experience in updating and developing APIs, specifically i...

I am looking for a freelancer to prepare complete document on MSSQL server GAP analysis report looking forward to connect me : (removed by Freelancer.com admin) Thank you...

...ability to effectively train others. If you're skilled in data analysis, visualization, SQL, programming (Python, R), and other BI essentials, join us for global projects. What We're Looking For: Business Intelligence Experts with Training Skills: Data analysis, visualization, and SQL Programming (Python, R) Business acumen and problem-solving Effective communication and domain expertise Data warehousing and modeling ETL processes and OLAP Statistical analysis and machine learning Big data technologies (Hadoop, Spark) Agile methodologies and data-driven decision-making Cloud technologies (AWS, Azure) and data security NoSQL databases and web scraping Natural Language Processing (NLP) and sentiment analysis API integrati...

...skilled web developer to create two web-based forms that will collect critical data in the form of dates, and efficiently store this data in a SQL database. The primary purpose of these forms is to streamline the process of gathering and analyzing specific timeline data crucial for my project's success. **Key Requirements:** - **Form Design:** Design two user-friendly web forms capable of collecting dates. Prioritize simplicity and ease of use to encourage accurate data submission. - **Database Integration:** Utilize SQL for backend storage. Experience with SQL is a must, as the forms need to seamlessly update the database in real-time. - **Report Generation:** Ability to generate summary reports from the collected data. The...

I'm seeking a skilled freelancer to assist with a web scraping project two specific websites and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python - Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed.

I want to live stream monitoring cameras to a web application in asp .net core 6 mvc if you have done such work you might contact for more details.

I am in need of an experienced ReactJS developer for the ...creation of a sophisticated front-end application. The key features of the application must include: - User Authentication: Integrating a secure sign-in system to protect user data. - Responsive Design: The application must look and function consistently on various screens sizes and devices. - Integration with APIs: The application needs seamless integration with multiple APIs. The application must be capable of interacting with an SQL database for data storage and retrieval. Having expertise in SQL database management would be greatly beneficial for this project. Ideal Skills: - Proficiency in ReactJS and SQL - Understanding of responsive design principles. - Experience in API integration....

...handling extensive property listings. - Capable of implementing advanced search functionalities (Note: Specific search features like location-based, price range, and property type search are to be confirmed). Ideal Skills: - Expertise in JavaScript, HTML, CSS for front-end development. - Proficiency with back-end development (e.g., PHP, Ruby on Rails, Django). - Experience with SQL or NoSQL databases for storing property data. - Familiarity with SEO best practices to enhance the platform's visibility. - A creative mindset to design an engaging user interface. The project timeline was not specified, so I am open to discussing feasible deadlines. I'm looking for someone who not only has the technical skills but also a passion for creating meaningful online experi...

I changed company & would like to change the address on my current website (only) asp

Create a new .net 7.0 application that will fully implement the protocol LNURL-auth. The following functions of LNURL-auth need to be implemented: -register -login -link -auth Documentation for LNURL-auth can be fou... Please read the documentation and make sure you fully understand the project before applying. To apply, please type what the sha256 of "helloworld" is to show you know knowledge of hashing, and please type the last sentence of the documentation to show you have read it fully. A linux machine will be given that ready for you to deploy to. The database will be sql server. **Ideal Skills and Experience:** - Proficient in .NET 7.0 framework. - Strong background in developing authentication systems. - Python experience is a plus

...seamlessly connect website forms to a database for storage is essential. ### Ideal Skills and Experience: - Expertise in web development, particularly in troubleshooting and fixing website forms (contact forms specifically). - Proficiency in programming languages such as HTML, CSS, JavaScript, PHP, and SQL. - Experience with email delivery systems and setting them up to receive notifications from website forms. - Knowledge in database management, specifically for storing submission data from web forms. - Strong problem-solving skills and attention to detail. This project requires someone who can promptly and effectively diagnose the issue with the contact form, implement a fix, and set up both email and database notification systems. It's vital for improving my web...

I am seeking a Power BI expert who can help me with data visualization, report creation, and the development of dashboards for interactive KPI monitoring. Familiarity with operational KPIs and experience in utilizing SQL databases for data sources are essential. Key responsibilities will include: - Visualizing and interpreting data - Creating in-depth, detailed reports - Designing interactive dashboards to facilitate efficient KPI monitoring The ideal freelancer will: - Be proficient in Power BI tools. - Have experience in the use of SQL databases. - Have a proven track record of operational KPI analysis. I will provide all necessary data from a SQL database. I look forward to working closely with a qualified consultant to improve our ...

I am looking for an experienced web developer skilled in user-friendly design and database management to create an employment website. It needs to have an intuitive interface where both employers and employees can easily register, submit and approve timeshee...generated payment slip with payment details for employers to forward payments and for the employees to view their payslips after adjusting 7. Document upload and download specified to jobs assigned The ideal candidate for this project will demonstrate a clear understanding of database management systems, user experience design, and web development best practices. Proficiency in HTML, CSS, JavaScript, SQL, and experience with user registration systems will be beneficial. Previous experience working on similar platforms will ...

...report (15 - 20 pages) on a theology topic. The topic will be communicated to the selected researcher(s). Required qualifications: 1. Excellent English writing and speaking skills 2. Awareness of theology topics such as Islamic monotheism, Hindu Advaita Vedanta, and New Age Spirituality. 3. Experience doing research and documentation Preferred qualifications: 1. Proficiency in Google Docs and MS Office 2. Interest in spirituality-related topics The right freelancer will have a PC with good internet connectivity for conducting research, report writing, and discussions with the team. The report will be prepared through research, knowledge sharing, and discussions. The compensation will be on an hourly basis for the duration of the project. The freelancer is required to commi...

I want Job Portal like ,Backend should be C#/MVC , DB-SQL Server 2019 PFA

...solution tailored to track and monitor project management and related accounting. The system will facilitate the control and management of work orders by incorporating features such as client and supplier master data, a detailed general ledger (first note), and advanced functionalities for work order creation, cost allocation, and revenue tracking. Goals: 1. Visualizing revenue and expenses. 2. Creating visualizations for profit and loss statements. 3. Creating visualizations for balance sheets To avoid wasting time, please: 1) refrain from excel only experience, we are looking for MS BI expert only. 2) we have internally development skills, so we can identify quickly the skill level and seniority 3) Every set of tasks are decided before and estimated and shared the ...

...embarking on a research project that requires detailed data from several Stoic-centric subreddits. Specifically, I'm interested in collecting: - Post titles - Dates of posts - Original post text - Comment text The target subreddits for this project are: - r/Stoic - r/Stoicism I'm only looking to scrape data from posts within a specific date range, which will be shared with the selected freelancer. **Ideal Skills and Experience:** - Proficiency in Python, specifically with libraries like BeautifulSoup, Scrapy, or PRAW for Reddit data scraping. - Experience with data manipulation and storage, potentially using pandas and SQL. - Ability to work with APIs, if necessary. - Familiarity with Reddit's structure and rules relating to dat...

I'm in need of an expert to create a Microsoft Word add-in with specific features that...create a Microsoft Word add-in with specific features that enhance efficiency and productivity. The add-in should only be compatible with Microsoft Word. The scope of work includes the following functions: * Text formatting * Automating repetitive tasks * Document review * Track changes management The perfect candidate for this project would be familiar with Microsoft Word development, expert in MS Office plugins, and experienced in designing user-friendly and customizable interfaces. Your past experience with similar project will be prioritized. Strive for efficiency and user-friendliness in every feature you create for this add-in. Please reach out with PM with previous examples al...

I'm in need of a skilled node.js developer to complete a solution that integrates PayPal payment gateways. A familiarity with these systems is essential. The successful applicant will also be required to utilized this node js solution as a custom Microsoft Office plugin Key Responsibilities: - PayPal integration with node.js solution - Node js based Microsoft Office plugin (addin) Ideal skills and experience: - Proficiency in node.js - Experience with PayPal API's - Experience in Microsoft Office Suite plugin development - Deep understanding of payment processes - Strong problem-solving skills.

...processes, request submissions, and response management. The development stack should include ASP.NET Core MVC and APIs for data retrieval and manipulation, leverage SQL Server for data storage, be deployable in a Docker environment on local PCs for development purposes, and ultimately, be scalable and compatible with Azure for cloud deployment. High-Level Requirements: 1. User Authentication and Authorization: • Implement secure user authentication with role-based access control. • Support multiple user roles, ensuring proper authorization. 2. Staffing Requests: • Develop APIs for entities to submit staffing requests with customizable parameters. • Ensure a scalable solution for data retrieval and manipulation. 3. Response Management: &bu...

I need an experienced MS SQL developer to make specific modifications to our in-place custom ERP system. Key Tasks: - Report Generation: The expert should be able to develop new reporting formats, presenting our data in better, more insightful ways. - Data Integration: Seamless integration of data from various sources within our organization is critical. I'm not looking for any user interface modifications at this time, so you can focus on the technical aspects of data handling and report generation. The project should be completed within a month. This role requires a skilled individual with experience in MS SQL and ERP customization. A history of similar data integration and report generation tasks would be advantag...

I'm currently in urgent need of Simple accounting services including bookkeeping and tax preparation for my service-based business. The ideal ...urgent need of Simple accounting services including bookkeeping and tax preparation for my service-based business. The ideal professional should embody: - Significant experience and expertise in bookkeeping, tax preparation, and producing financial statements. - Strong working knowledge and understanding of MS Excel as all of my current accounting data is recorded on this platform. - Any one with/without experience can be considered, With the condition that He/She has been using MS Excel and Gsheet for a significant time Your proposal should demonstrate your proficiency in these requirements. Looking forward to an eff...

...This tool will play a pivotal role in my ongoing efforts to bolster web application security, and its development will be documented in a comprehensive thesis paper. Ideal Skills and Experience: - Proficient in Python, with the ability to leverage its capabilities in developing a vulnerability scanner. - Deep understanding of web application architectures and common security vulnerabilities (e.g., SQL injection, XSS). - Experience with cybersecurity practices, specifically in vulnerability identification and assessment. - Familiarity with existing vulnerability scanning tools and methodologies. - Strong analytical skills to effectively assess system weaknesses and suggest mitigations. - Ability to document the development process and findings for inclusion in a thesis paper. Ke...

I require a specialist with proficiency in Word and power automate to create sheets using mailmerg...of the 1000s of pages is selected and then a macro is invoked to change the font of that particular selection. Task 2 Friom Excel Sheet create mailmerge sheets but It should pick up data only of certain date and mail-merge it with the form example all entries of 12/1/2014 should be mailmerged on the form and data of no other date should appear on the form. And a total number of entries with male and female should be auto populated in the appropriate colums. After the forms are generated with mailmerge. The macro of ctrl-alt-s should apply to all sections with certain fonts. So, if you are well versed with Ms-word including macros and may be powerautomate. I need yo...

I'm seeking ...understanding of MudBlazor framework. Have a good command over Layouts and Navigation, Forms and Validation, and Data table implementation, crucial for successful project fulfillment. A deep understanding and proficiency with .NET Core Entity Framework and SQL Server is required. If you're a tech-savvy problem solver ready to dive in immediately, this project is for you. Key Requirements: - Expertise in .NET 8 - Proven skills in Blazor, strong understanding of MudBlazor Framework - Solid experience with .NET Core Entity Framework and SQL Server - Ability to start immediately on the project Desired Skills: - Full-stack development - Proficiency in Layouts and Navigation, Forms and validation, and Data table implementation - Good Proble...

Job Title: Senior Full Stack .NET Developer Monday to Friday [Removed by Admin] 4-5 hours/day IST Night (7am to 12pm IST) Salary: 50,0...Salary: 50,000 INR per month Job Description: We are seeking a highly skilled and experienced Senior .NET Developer to join our team. The ideal candidate should have strong proficiency in C#, ASP.NET MVC, and the .NET Framework, along with expertise in various web-related technologies such as HTML, CSS3, JavaScript, and jQuery. Additionally, familiarity with database technologies including SQL Server and T-SQL is essential for this role. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: C# ASP.NET MVC .NET Framework Entity Framework HTML CSS3 JavaScript T...

I'm on the hunt for a knowledgeable and experienced IT professional who can create custom server performance alerts through SQL Sentry SolarWinds. Outlined below are the specifics of the task: The Alerts: - I require alerts that are focused primarily on the cessation of SQL Services and Browser Services. You'll need a comprehensive understanding of server performance aspects and how to interpret them in a beneficial way. Alert Notifications: - Once these services stop, I'd like to receive both email and push notifications. You'll need to proficiently set up these modes of alerts within the software. Skills Needed: - Proficiency in SQL Sentry SolarWinds - Comprehensive understanding of server performance indicators - Ability to customise alerts a...

Need a guy who is an expert on Ms word document. Please bid who can start right now.

We have company email accounts in MS 365 with a custom domain. We would like these to be the same logins for our on premises Windows Server 2019 server. We had previously configured this using the default Server Manager, but in our fresh installation we would like to stick to Windows Admin Centre, as it is the more modern way to configure Windows Server. We would like someone to complete this setup process for us in WAC (connecting Azure ARC) and making it so the login accounts for the server are the same as organisations the 365 accounts.

I am looking for an experienced frontend developer with some backend, deployment and SQL knowledge to create a personal application for managing my father's business. I need someone who can handle: - Good frontend knowledge - understand backend systems and sql queries - Integration with existing systems - Generate technical helpful utilities for automating small tasks - Have good interaction and team support The personal application should feature: - Inventory management - Accounting of day to day finances - Customer and employee You should have a strong understanding of data security, frontend, deployment and file types. Experience in creating similar apps would be beneficial. PS- Not for an enterprise level application, this will be a tool for my father a...

...scripts and tools to extract data from various online sources efficiently and accurately. This role involves analyzing and collecting data that is crucial for our business intelligence, market research, and strategic planning efforts. The Web Scraping Specialist will work closely with our data analysis and IT teams to ensure the quality and reliability of data collected. Responsibilities: Design, develop, and maintain web scraping scripts and tools to extract data from targeted websites. Ensure the integrity and accuracy of scraped data through rigorous testing and validation processes. Manage and optimize the performance of web scraping activities to handle large volumes of data without compromising on speed or efficiency. Work with ...

?I cover the full spectrum of AWS Cloud consulting services, from assessments, strategy, and roadmap, to design, build, and migration – and from adoption, optimization, and management to data and analytics and security. ✨My Skills are following : · Deep understanding of cloud and cloud native principles and practices · Hands-on experience with cloud environments - AWS, GCP, Azure · AWS Services:EC2, EC2 container service, Lambda, Elastic beanstalk, S3, EFS, Storage gateway, Glacier, VPC, Direct connect, Transit Gateway, ELB, Auto Scaling, ACM, Cloud Front, Cloud Formation, Cloud Watch, Cloud Trail, SNS, SES, SQS, SWF, IAM, RDS, DynamoDB, Elasticache, Redshift, AWS Backup · Operating Systems: UNIX, Redhat LINUX, Windows · Networking & P...

We are in need of a skillful and ...and responsive website. Utilize React.js and Angular.js to build interactive user interfaces and single-page applications. Develop backend functionalities using Node JS and integrate them seamlessly with the frontend. Implement database solutions using Postgres SQL to ensure efficient data storage and retrieval. Optimize website performance and ensure cross-browser compatibility. Stay updated with the latest web development trends and technologies. Ideal candidate: Experienced website developer with expertise in Node JS, Postgres SQL, React.js and Angular.js. Must have a broad knowledge on website development especially for informational websites with e-commerce aspects. This position requires creativity, attention to detail and stro...

Requirements: Experienced in TypeScript and JavaScript. RESTful API SQL schemas JWT/OAuth

I'm seeking an expert in Oracle SQL or PL/SQL to craft a sophisticated query that will be pivotal for our reporting needs. The essence of this project revolves around retrieving data effectively, necessitating an adept handling of multiple table joins. **Key Requirements:** - Deep understanding of Oracle database systems. - Proven track record in writing complex SQL or PL/SQL queries. - Proficiency in creating queries for data retrieval aimed at reporting, with an emphasis on efficiency and accuracy. - Experience with complex joins involving multiple tables, ensuring seamless data integration and optimization. **Ideal Skills and Experience:** - Excellent knowledge of Oracle's advanced features and best practices. - Strong proble...

I am looking for an experienced professional to help me optimize existing SQL queries on a SQL Server database platform. The complexity of the queries is at an intermediate level, and the aim is to optimize performance and potentially add new features where necessary. The ideal candidate should have great familiarity with SQL Server and be able to provide solutions to suit my requirements. I am open to suggestions on how best to approach the project and welcome discussions to come to a conclusion. If you have the skillset and the experience necessary to help me with this project, please reach out to me.

I am in need of a freelancer who can meticulously clean a data set composed of numerical information. The dataset contains fewer than 10 variables, but it's crucial that each one is handled with precision. The primary objective is to remove any and all duplicates to ensure the integrity and uniqueness of the data. Ideal Skills and Experience: - Proficiency in data cleaning techniques and tools - Experience with databases and data analysis software (e.g., SQL, Excel, Python Pandas) - Keen attention to detail to identify and remove duplicates - Understanding of data structure and optimization for numerical data - Ability to work efficiently without compromising data accuracy The project will require a brief discussion to understa...

...a 1-hour educational Zoom session on data anonymization, with a focus on the K-Anonymity technique using ARX Anonymization Tool . My goal is to effectively anonymize sensitive information such as email, username, and gender in SQL databases. Ideal Skills and Experience: - Proficiency in ARX Anonymization Tool or similar open-source tools compatible with Mac. - In-depth knowledge of K-Anonymity and its application in real-world scenarios. - Experience in teaching or tutoring, with an ability to explain complex concepts to beginners. Requirements: - Demonstrate the step-by-step process of anonymizing data using K-Anonymity. - Provide practical examples specifically tailored to SQL databases. - Offer guidance on best practices and common pitfalls in data...

We're in need of a highly skilled Flutter developer who can wo...platforms. The duties will include: - Implementing functionalities such as user authentication, push notifications, and in-app purchases. - Undertaking complete redesigning of our app, UI/UX enhancements. - Conducting feature enhancements following our guidelines and specifications. - Employing necessary bug fixes to enhance user experience and satisfaction. - Backend work is on Laravel PHP and MY SQL. Ideally, we're looking for someone with great experience in Flutter, app design, and a good understanding of user-experience design on mobile, coupled with demonstrable ability in bug fixing and feature enhancements. Kindly reach out if you match these skills and are ready for the task. Preferred who are fr...

In order to replicate and extend the results of the study ...methodology and results. As I am interested in replicating and possibly extending this findings. 1. The model that they employ is from the seminal paper of Shah and AlMansoori. They only added few constraints which are in the paper.  2. The data are already in the paper given at the appendicies. 3. They used Gurobi 9.5 which were the available versions at that time. And that versions are almost the same in terms of time. You can use the latest which will be faster. They used python to code the model. They used Spyder and MS Excel for coding and data manipulation whenever necessary.  4. You can check or phd thesis which is available in the attachment.  Could you please check that papers and h...

...of someone with strong understanding of accounting systems like QuickBooks, Xero or FreshBooks, and proficiency in SQL for a data consolidation project. With no specific accounting systems mentioned, versatility and adaptability will be ideal for this project. Your role will encompass: - Extracting data dumps from multiple unspecified accounting systems. - Importing this data into a SQL database. - Creating data views based on different selected filters. - Generating reports based off this data. The ideal freelancer should have: - Experience in handling data from different accounting systems. - Extensive knowledge in SQL. - A proven ability to work with flat, simple data structures. - The creativity and resourcef...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, minitab, and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

I'm seeking a Senior .Net developer for an interview support with profound experience and proficiency in MVC Framework, SQL Server, and .Net Core 5.0 to be part of my team. Key Skills: - Strong expertise in MVC Framework - Profound knowledge in SQL Server - In-depth understanding of .Net Core 5.0 - Proficiency in using cloud platforms such as Azure and AWS - Good working experience with Angular, React Determining Factors: - Familiarity with Azure and AWS - Working proficiency in Angular, React Please bid if you possess the qualifications stated above. Your expertise in these areas is highly sought after and will expedite the completion of the project. Preference will be given to those with the relevant skills and experience. Be ready to provide samples of your pre...

...and track user activities within the admin panel for auditing purposes. 12.**Avatar Upload with Crop Feature:** Allows users to upload and customize their profile avatars with a cropping tool. 13. **Active Sessions Management:** Enable users to view and manage their active sessions for enhanced security. 14. **Client-side and Server-side Form Validation:** Implement validation mechanisms to ensure data integrity and security at both the client and server levels. 15. **Fully Customizable Settings Section:** Provide administrators with the ability to customize various aspects of the admin panel through a dedicated settings section. 16. **Complete Documentation:** Deliver comprehensive documentation covering installation, configuration, and usage of the admin panel. 17. **Object-ori...

Create a Kotlin or Java project using Android Studio 2022 that supports Samsung Galaxy A12 phone using Android OS 12. The app should contain one button, two checkboxes and progress bar. This project will use WIFI to upload images that were previously taken by the phones camera app to an SQL Database after scanning a QR Code. Code should be commented and there should be instructions on how to compile and install to phone. See attached PDF for full details.

I'm searching for an expert in Advanced Databases who can construct an exam paper of advanced difficulty. Ideal Skills and Experience: - Comprehensive knowledge of Advanced Databases - Experience in creating exam papers and academic content Requirements: - The ex...expert in Advanced Databases who can construct an exam paper of advanced difficulty. Ideal Skills and Experience: - Comprehensive knowledge of Advanced Databases - Experience in creating exam papers and academic content Requirements: - The exam paper should contain 10-20 questions - Questions should be of advanced difficulty level - Questions should test in-depth knowledge of Relational algebra, sql queries and intro concepts of databases Please ensure the draft is challenging and appropriately represents Adva...