Sql access excel vbaproiecte

...employees to access, update and input additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - Prior experience building work order or similar task management apps. Ideal candidate has worked on projects requiring direct connection...

...experience in dealing with Payability reports and utilizing accounting software such as QuickBooks, Xero or Wave. Key responsibilities include: - Reconciling my marketplace sales with Payability reports - Preparing monthly balance sheets - Generating monthly income statements - Compiling monthly cash flow statements Please note that I receive daily Payability reports from my marketplace. I have access to all necessary sales data from the marketplace, so the main focus will be on reconciling these figures with the Payability reports. Accuracy and attention to detail are crucial for this project. Ideal skills and experience: - Proven experience with reconciliations - Expertise with accounting software such as QuickBooks, Xero or Wave - Knowledge of e-commerce and marketplace s...

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...

As a client looking to ensure the reliability and effectiveness of my operations, I need an advanced Android emulator expert. The primary focus of this role will be on using emulators to access banking apps via desktop. Skills & Experience: - Comprehensive knowledge of Android emulators. - Expert in various Technicalities like rooting and Magisk - Proven experience in debugging Android applications. - Strong ability to optimize emulator performance. Please note, only advanced level candidates with relevant experience should apply. This is a critical role that requires keen attention to detail and a high level of expertise on Android emulators.

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

... * Fee payment system: A system that allows for the easy payment of fees is mandatory. User Roles: * Admin: They will have the highest level of authority and be able to oversee all operations. * Teachers: They should be able to manage grades, check attendance, and have access to their respective class information. * Students: They will have limited access, primarily to check their grades and attendance. * Accountant: They will handle the fee payment system and manage financial records. * Library and Staff: Will have access based on their functions for smooth operations. Ideally, you should have proven experience in Java and a strong understanding of the necessary functionalities a school management website would require. Please provide a portfolio of previous simi...

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

I require a Linux WHM expert to assist with a critical data recovery issue. Specifically. Suddenly our mysql stop working. We had a dump of data but we need to solve the mysql issue or reinstall it (we can provide WHM and root access), and upload the data dump. Key Responsibilities: - Troubleshoot and resolve the MySQL data recovery issue. - Ensure the retrieved data is accurate and complete. We would like to know why this happends, to avoid it happends in future, by checking server logs. Ideal Skills and Experience: - Extensive experience with Linux WHM. - Proven track record in MySQL data recovery. - Understanding of data security and privacy best practices. - Prompt and effective communicator.

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

As a marketing agency, we need a professional and sleek web designer that can build us a portfolio website. This simplistic, yet striking, aesthetic will be underscored by a black and white c...a portfolio website. This simplistic, yet striking, aesthetic will be underscored by a black and white color scheme. The crucial pages include: - A Home page to welcome users and give a brief about the agency - An About Us page to detail our company story, mission, vision, and team - Our Services page to highlight our marketing offerings with compelling copy - A Contact Us page, allowing easy access for prospective clients to reach out to us Designers with a proven track record in portfolio website design, and are well conversant with trendy and minimalist aesthetics would be ideal for thi...

I'm looking for a proficient React developer to help implement the frontend of a single page application. The wireframe is ready and this will be a client-side rendered app. It is designed in Figma and you will gain access to the design pages. In the project, some animations have to be implemented which are mostly simple css animations (e.g button color transitions and smoothly opening dropdown / dropup menus). There will be some real time string data that has to be displayed. However, this project is only about creating the components and the animations with the relevant hooks / states so that in a subsequent step, the backend data can be displayed. Other than displaying the dropdown menus, dummy pages should be displayed in the workspace when some of the buttons are pressed...

Hello, I need someone who has some knowledge of PS4 coding, I have sample files from PlayStation themself etc. I'm needing a PRX file created which is essentially a DLL for PS4, I'm needing this PRX to be able to send a notification, and read/write memory too for certain games, it would have to be coded specifically for that game I'm ... I need someone who has some knowledge of PS4 coding, I have sample files from PlayStation themself etc. I'm needing a PRX file created which is essentially a DLL for PS4, I'm needing this PRX to be able to send a notification, and read/write memory too for certain games, it would have to be coded specifically for that game I'm pretty sure, I already have one made for another game just not got access to the source.

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewed the file, wr...

We are seeking a highly organized and detail-oriented virtual assistant to assist with the remote viewing of properties in New York City. Responsibilities: - Contacting Property Agents: - Proactively reach out to...conferencing platforms (Zoom, Google Meet, etc.). - Ability to work independently and manage multiple tasks simultaneously. - Excellent written and verbal communication skills. Additional Information: -This is a freelance position with flexible hours. -Compensation will be discussed based on experience and qualifications. -Strong organizational skills and the ability to prioritize tasks are essential. -Access to reliable internet and video conferencing equipment is required. You should be based in the United States. Please note: Only shortlisted candidates will be ...

...Two Different Forms: Create user-specific forms for event entry. Commercial users' forms will include membership management and payment functionalities. Google Maps API Integration: Utilize Google Maps JavaScript API to overlay event data on a map, employing custom markers and interactive elements. Backend and Security: Set up a secure server environment with robust authentication and role-based access control. Implement secure payment processing for commercial users. Responsive Design: Ensure the application is fully responsive and functional across all devices and platforms. Skills Required: Proficiency in HTML, CSS, JavaScript, and frameworks like React or Angular. Experience with backend technologies such as Node.js, Python (Django or Flask), or PHP. Strong knowledge of...

...hourly, daily, and weekly games. • Integrate features that allow for easy management and scheduling of game cycles. 4. User Interface and Experience: • Design an intuitive and user-friendly interface for both participants and administrators. • Optimize the platform for mobile devices to accommodate the majority of users who will access it via SMS. 5. Security and Compliance: • Implement robust security measures to protect user data and prevent unauthorized access. • Ensure compliance with relevant regulations and standards governing lottery operations and SMS services. 6. Reporting and Analytics: • Incorporate reporting and analytics tools to track participation rates, game performance, and other key metrics. • Provide insights ...

I'm in need of a comprehensive website that can serve as both an ecommerce platform and an informational hub. Here's what I'm looking for: Key Features: - We need a user-friendly and fully responsive ecommerce section that includes: - Product listings: You will b...ecommerce website building tools and platforms. - Strong understanding of web security protocols. - Ability to create clean, professional, and visually appealing designs. - Excellent communication skills and a collaborative work ethic. Some examples include: The website should also have an admin access for our staff to update things like photos, stock availability, keywords etc. with their login, according to their seniority.

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

... This can be done by synchronizing with the NTP server or some other way you can propose. We would like the webpage to keep working during the synchronization with NTP server but could accept a small downtime as long as the webpage automatically goes back online after synchronization. All necessary details and scope of the project will be shared further once we proceed. There will be remote access provided to the custom PCB to test and validate the firmware changes. All changes must be done without affecting the main firmware functionalities and will be verified to be working before project can be considered completed. Ideal skills for this job would include: - Strong base in STM32 programming - Familiarity with Wiz5500 and its integrations - Flexibility and adaptability t...

I am currently facing a critical issue with my IPTV management panel. I believe someone has managed to breach my database and access unauthorized information. Your main tasks would be to: - Identify and fix the breach - Implement stronger security measures to prevent future breaches I need a professional well-versed in PHP and with experience dealing with database invasions. It is crucial that you have a good understanding of IPTV systems and their security challenges. Your task is to not only repair the damage but also to ensure that a similar incident cannot occur in the future. I am looking for someone with excellent communication skills, who can keep me updated on their progress and explain the changes they are making to my system. Please bid only if you are confident you...

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

I'm looking to hire ...user interfaces. Ability to conceptualize and implement modern design aesthetics for both the application interface and icon design. 4) Graphic Design: Experience in graphic design, specifically in creating visually appealing and contemporary app icons that align with brand identity. 5) Security and Permissions: Knowledgeable about Android security protocols, particularly in managing filesystem access and permissions as per Android version 13 requirements. 6) Device Compatibility: Familiarity with device-specific features, such as handling special device files (/dev/qrandom, /dev/random) and ensuring cross-device compatibility. This project is intended to be a fast turnaround to refine the app’s usability and aesthetic to ensure it is both professi...

I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenance would be required....

I am looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Idea...

webscraping cdiscount using python and export it into excel

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are ...extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing (that the easy part). The objective is to create about 7,000 individual mailings each month and to run the automation about twice per week. I need help finding the right OCR tools to work with power automate. ...

I'm seeking a proficient Pine Script developer to assist in creating a new script with a focus on developing a custom technical indicator. Your task will be to emulate a paid script I have access to, using the description of the invite only scrip & chart price datas, settings of the indicator Key Responsibilities: - Create a new Pine Script from scratch - The script should be similar to the paid one I currently have Qualifications: - Extensive experience in Pine Script coding - Proven track record with technical indicator scripts - Familiarity with both price and volume data - Attention to detail and ability to emulate existing scripts accurately Your strong Pine Script coding skills and technical indicator knowledge will prove invaluable in carrying out this task. I lo...

...ahorros significativos que la implementación de un software de gestión de gastos, específicamente Rindegastos, puede ofrecer a la empresa. Formato del Modelo: Excel Adaptable: El caso de negocio debe estar en un formato de hoja de cálculo Excel, permitiendo personalizar y modificar los parámetros de ahorros y otros datos específicos de cada cliente. Presentación PowerPoint: La información del Excel debe trasladarse a una presentación en PowerPoint modelo, facilitando la exposición y discusión de los beneficios y datos financieros en reuniones con la gerencia o stakeholders de la empresa. Contenido Específico: Análisis de Costo-Beneficio: El Excel debe permitir comparar ...

I'm looking for an Excel file that contains a list of companies in Dubai, specifically from the Technology and Hospitality industries. The file should include the following information for each company: - Company name - Address - Phone number - Category of business Key requirements: - Data should be accurate and up-to-date - Companies must fall into the Technology or Hospitality industry

I'm looking for a skilled Python developer who can help me implement the Google Sheets API for password protection. Key Requirements: - Utilize Python to work with the Google Sheets API. - Implem...Google Sheets API for password protection. Key Requirements: - Utilize Python to work with the Google Sheets API. - Implement password encryption for security. - Set up a system for managing user access, with individual passwords for each user. Ideal qualities in a freelancer: - Proficient in Python. - Experienced in working with the Google Sheets API. - Knowledgeable about encryption methods for data security. - Capable of setting up user authentication and access controls. Successful delivery of this project will result in a password-protected Google Sheet that allows f...

Seeking an experienced PL/SQL developer to assist with multiple tasks in my project. This includes: - Oracle database management - XML table manipulation - JSON parsing - Dynamic SQL operations - Development of PL/SQL objects - Utilization of collections and arrays in PL/SQL The project will also involve intricacies such as: - Error handling and exception management - Performance optimization - Crafting of database triggers and stored procedures - Harmonious integration with other systems - Performing data migration and transformation tasks Ideal freelancers for this project should be adept in PL/SQL and Oracle development, with particular skill in SQL*Plus and PL/SQL Developer tools.

I am looking for an experienced professional to install a SIP trunk server on a Linux system. As part of the project, you should also set up access to the live voice stream with the primary purpose of real-time transcription. Key Requirements: - Install and configure a SIP trunk server on a Linux system. - Enable access to a live voice stream for real-time transcription. Ideal Candidate: - Proficient in Linux server administration. - Experienced in SIP trunk server installation. - Familiar with real-time transcription processes. - Skilled in setting up live voice stream access. - Strong problem-solving and troubleshooting abilities.

I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.

...can assist me with various tasks in Microsoft Excel and content writing. The ideal candidate should be proficient in Python and C programming languages. In Excel, I require help with: - Data entry and organization: Assisting me in organizing existing data and entering new data into specific format. - Formulas and calculations: Creating formulas and performing calculations on the data. - Power point: Making power point presentation. - Programming: Automating specific tasks using Python and C programming. In terms of content writing, I need support with: - Copy paste: Help me in copy paste some data. - Story: Writing a story. - Resume: Writing a professional resume. The ideal candidate for this project should have a good understanding of Excel and programming, p...

...emphasis on securing various applications. The scope of work includes web applications, mobile applications, and desktop applications. Key Responsibilities: - Identify and correct various security vulnerabilities specifically: cross-site scripting (XSS), SQL injection, and session hijacking. - Devise strategies to enhance the security of all our applications. - Regularly conduct security checks to identify potential threats. Ideal skills: - Proven experience in securing different application platforms. - In-depth understanding of XSS, SQL injection, and session hi-jacking. - Comprehensive knowledge of network security and data protection. I need someone who is adept in application security to safeguard our digital assets. Your expertise will play a fundamental role in...

I'm looking for an expert in Excel who can assist me with data analysis and spreadsheet design. The main objective of this project is to create compelling data visualizations. Key Tasks: - Analytical reviewing and summarizing of data - Design of clear and comprehensive Excel spreadsheets Objective: - Creating simple charts and bar graphs for data visualization The ideal freelancer for this project should exhibit solid skills and previous experience with data insights extraction, spreadsheet design, and data formatting. Familiarity with basic data visualizations such as charts and bar graphs is essential.

I need a skilled developer with proficiency in React (particularly version 16), Ubuntu, and Apache for a project deployment. Key responsibilities will include: - Managing server configurations - Installing project dependencies - Configuring Apache for the application Having hands-on experience with the above tasks is crucial for effective task execution. We have access to the production server and all necessary credentials will be provided. Understanding of server-side deployment intricacies and problem-solving skills are as well essential for this task.

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

I think I'm on the right track other times to recognize the patterns of the text which are similar to the elements of a command I would have used regex and other but with the AI I can submit the command to it and it will be able to extract the elements. data that interests me will you be able to support me in this project access to an AI with APIs ? my preference is for a free AI, a free API and with the possibility of sending it a PDF file

...create an informational website for my business. This site will serve as a hub for all the details about our services, team, and contact information. Key Requirements: - The website will have 11 or more pages, so I need someone who can navigate large scale website creation with ease. - I require a seamless and secure credit card payment integration. This is essential for potential clients to easily access and pay for any services offered. Ideal Skills and Experience: - Proficiency in web development, including experience with creating large-scale sites. - Proven experience in integrating credit card payment systems into websites. - A good understanding of UX/UI design principles to make the website user-friendly and engaging. - Strong communication skills to ensure a smooth and...

I am looking for a Python developer who can help me build a web application that integrates with AWS Lambda functions to access DynamoDB. The primary goal of this app is to streamline data access and processing. Key responsibilities will include: - Developing a secure, reliable web app with Python - Utilizing AWS Lambda functions for DynamoDB access - Ensuring efficient data handling and processing The ideal candidate should have: - Strong experience in Python web development - Proficiency with AWS services, especially Lambda and DynamoDB - A good understanding of data handling and processing - Prior experience with serverless architectures would be a plus. Your main focus will be on the backend, so front-end development is not required. If you have these skills...