Sql update vba excel jobs

...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel ...

I need help with a multifaceted update to my CV. The goal is to add my latest work experience, update my skills section, and revise my existing educational information. Having this rendered in both PDF and Word formats would be ideal. Below are the key aspects I'll need assistance with: - Integration of recent work experience: I have a new job role that I want to incorporate into my CV fluidly. - Refreshing my skills section: My skills repository has expanded, and I need these articulately highlighted in my CV. - Revising education details: There have been some changes to my academic details that need revising for accuracy. - Design and Layout: I value aesthetics and would love for my CV to visually stand out. - Content and wording: Fluency in English...

I am looking for an expert to manage and promote my Etsy shop, as well as open my google business shop. I have an inventory of handmade and unique items, and I need help with both platforms for better visibility and improved customer engagement. Your tasks would primarily include: - Inventory Management: Keeping track of existing inventory, update listing details if necessary and coordinate to replenish stock. Knowledge of Etsy’s listing system is necessary. - Promotion: Create and execute Social Media promotion strategies for both Etsy Shop and Google Business. You should have experience in leveraging different social media platforms for business promotion. Ideal candidate would have prior experience managing Etsy shops and Google Business listings, with proven results in...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.

...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...

I will setup your project update

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

...to register and log in to the site. - Search Functionality: An effective search feature for users to easily find the products they're looking for. - Listing Ads: Apart from regular product listings, the platform should have the functionality for users to list ads. - Admin Panel: An administrative panel for both user and general site management. - Blog Admin: Capability for an admin to manage and update the site's blog. Ideal Skills: - Proficient in full-stack development - Experience with e-commerce and classified ads platforms - Knowledge of user authentication and authorization - Familiarity with search functionality integration - Prior experience in building admin panels If you're confident in your skills and have a track record of developing similar projects,...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...

I'm in need of a competent WordPress developer to assist me in make the site is in to two language English and Thai. You need to create multi language button. Customer able to switch back and forth between two language. I also need developer to update all new current plugin and make the site load faster. Need SEO plugin install and social networking login.

I'm in need of a personal website that is both aesthetically pleasing and functional. I'm looking for a classic and traditional visual style that will be appealing to visitors. The main feature of the site will be a live tracking page that provides real-time updates. This tracking page will need to be updated manually at times and also have the ability to automatically update information. Key Requirements: - 6-page personal website - Classic and traditional visual style - Functional, user-friendly layout - Live tracking page with both manual and automatic updating capabilities - Automated email alerts sent at specific intervals - The tracking page should include live updates Ideal Skills: - Proficiency in front-end and back-end web development - Experience in building pe...

I need to : 1. rename an app from to 2. rename same app from to 3. adjust url's acording to domains provided 4. adjust register form adding one more field 5. adapt newly created apps with new logo, new colors 6. upload to google store

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I need a skilled Wordpress professional to update and arrange my blog posts on my Elementor site. The updates include text editing, adding and replacing images, and adjusting the layout. Key Tasks: - Update 4 blog posts: The main task is to rewrite some of the content and add or replace images where necessary. This update should be done meticulously to maintain the quality and consistency of the posts. - Arrange 3 PDFs for publishing: You would need to work on 3 PDF files which include images. Your task will be to convert them for web use and publish them on the site. - Elementor and Wordpress proficiency: You must have a good understanding of Elementor and Wordpress to carry out the necessary updates and arrangements. The project is of top priority and needs to b...

I'm in need of an experienced PHP developer to create a comprehensive web-based portal. This platform will serve as a central hub for both my customers and employees, as well as allow administrators to manage and update the content effectively. Key Features: - User authentication: Implement a robust user authentication system to ensure only authorized personnel can access the portal. - Content Management System (CMS): Create a user-friendly CMS that allows the administrators to update, upload, and manage text and image content on the portal. User Roles: - Customers: The portal will be used by customers to interact with our services. Ensure seamless user experience and accessibility. - Employees: Employees should have access to specific tools and information. Develop...

I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...

I have an excel file, need add product categorie on a column - budget 100€

I need assistance with updating content and images on my website, and creating a contact form specifically for booking appointments. Key Requirements: - Add both text and image content: The website requires new text and image content. These need to be seamlessly integrated into the existing structure while ensuring they are engaging and relevant to our target audience. - Create a booking appointment contact form: A custom contact form will need to be designed and implemented on the website. This form will be the primary method for customers to book appointments. A user-friendly, clear and secure form is essential for this task. Ideal Skills: - Proficient in HTML and Wordpress: You should have a solid background in HTML and Wordpress to ensure that the new content seamlessly integrates w...

...product details (name, description, price, category, etc.). Inclusion of at least 100 sample products for demonstration. recommendation system: Generate recommendations based on simple rules and user behavior. For example, you can recommend products that are popular among other users, products in the same category as the ones the user has viewed, or products with similar price ranges. Store and update user view history in the database. Display recommended products on the user dashboard based on the user's preferences and view history. Search with Basic Recommendations: Enhance the search functionality to provide basic recommendations. Modify the search algorithm to consider user preferences and recommended products while retrieving search results. Implement autocomplete or s...

...analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an...

I need a heartfelt and warm letter to be written urgently for my uncle. It should encompass a personal update. I would like to talk to express what needs to be included. The ideal candidate for this project should be: * Proficient in English with excellent writing skills * Experienced in ghostwriting heartfelt communication * Able to deliver within a short timeframe, ideally within 24 hours * Someone who can handle sensitive, personal content with care

...product details (name, description, price, category, etc.). Inclusion of at least 100 sample products for demonstration. recommendation system: Generate recommendations based on simple rules and user behavior. For example, you can recommend products that are popular among other users, products in the same category as the ones the user has viewed, or products with similar price ranges. Store and update user view history in the database. Display recommended products on the user dashboard based on the user's preferences and view history. Search with Basic Recommendations: Enhance the search functionality to provide basic recommendations. Modify the search algorithm to consider user preferences and recommended products while retrieving search results. Implement autocomplete or...

I'm looking for a skilled professional to support and expand my existing WordPress-based ecommerce website. Here's what the role entails: - **Maintenance & Updates**: Your primary responsibility will be to maintain and update the website. This includes ensuring all the features work seamlessly, fixing any issues that may arise, and conducting regular checks to ensure everything is running correctly. It's crucial that you are thorough in your maintenance work, as any issues could potentially affect sales or customer retention. - **Feature Additions**: I am currently looking to add new features to my website. Whilst currently I'm looking for design changes, future additions may include user reviews and ratings, live chat support, and membership/subscription o...

Hello, I need complet the Amazon categories catalogue excel in french

...Overview: We urgently require a talented and experienced Figma designer with strong proficiency in React.js to update the design and content of our financial services website. The successful candidate will be responsible for revamping existing static pages to make them live, responsive, and dynamic. This role demands immediate availability and the ability to deliver high-quality work within a tight deadline. Responsibilities: Revamp Existing Website Interface Quickly analyze and update the current design and content of the static pages. Ensure new designs are modern, user-friendly, and engaging. Efficiently translate Figma designs into functional React.js components. Design and Update Sections Redesign the following sections, ensuring compatibility with React.js:...

Our project aims to enhance the Django website running on Ubuntu by addressing several key issues. We will streamline Google registration, fix email registration to avoid redundant data requests, and update the logo. We'll verify email confirmation, resolve logout errors, and ensure the machine names display fully. We'll adjust font sizes, reorganize dashboard boxes, correct console errors, and fix icon colors. Additionally, we'll refine machine information display, adjust button states, and update dropdown menu functionality. Finally, we'll correct API settings visibility and fix data display issues on the profile page and other sections.

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I am interested in making over the living area of my studio apartment with a rustic minimalist furnishing style. My budget for this project is more than $1000, which will be used to purchase high-quality pieces that...background, preferably with an emphasis on rustic-minimalist styles. Familiarity with the Palermo rural farm house aesthetic - Knowledge of cost-effective shopping for furnishing - Capability to work within the set budget while ensuring the quality of the furniture Deliverables: - A comprehensive plan for the living area including suggested furniture and decor - Execution strategy and timeline for the update - List of vendors to buy from within the budget Your role is vital to realizing my vision for a cozy, rustic living area. If this sounds like your expertise, ap...

I'm looking for a small change on the attached advertising banner ae. I need someone to simply update the text from "2015" to "2024".

Update Version for Heliopolis IFC Blender+FBX+ Unreal with google cesium Map

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

Update Version for Santa Lucia IFC Blender+FBX+ Unreal with google cesium Map

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I'm looking for a skilled WordPress developer to update my existing website's functionality. Key Requirements: - Enhance user experience by updating site's functionality - Ensure the site's user login and registration works seamlessly - Implement any additional interactive features that could enhance user engagement The project will include: - An initial audit of my current site's functionalities - Implementing the new features in a way that doesn't disrupt the current design and layout Ideal Skills: - Strong experience in WordPress development - Proficient in implementing user login and registration systems - Ability to integrate interactive features seamlessly Please share your past work, and how you intend to approach this project.

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

...Mobile App and Website Developer Are you a skilled freelance developer with expertise in crafting seamless experiences across mobile and web platforms? We're seeking a talented individual to collaborate with us on an exciting project to develop a modern and user-friendly job search platform. Key Functionalities: - User Registration and Profile Management: Enable users to create, manage, and update their profiles to streamline the job search process. - Real-Time Messaging: Facilitate communication between job seekers and employers through real-time messaging functionality. - Advanced Search and Filtering: Empower users to discover relevant job listings based on specific criteria such as location, industry, and job type. - Subscription-Based Fees: Implement a flexible subsc...

I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I need a skilled programmer for a crucial task: changing all website links and references from . to .au. The project is intended for an existing business site. Additionally, we will require the professional to update SEO settings in all lines of code to reflect the .au domain replacing . Key Responsibilities: - Convert all references of . to .au throughout the entire website - Update SEO settings to accommodate the new domain - Ensure smooth transition without any loss of data or functionality Ideal Candidate: - Proficient in web development and coding - Extensive experience with SEO and domain migration - Attention to detail to ensure no broken links or missing references - Excellent communication skills to provide updates and seek clarification - Familiarity with the

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

Hey there, I’m interested in building a kind of niche product, basically a coloring app framework for iOS and Android, but the app would use my own artwork. I’d like to be able to reskin it, update it, and add more images as I wanted - so maybe a template with placeholders that I could reskin? I did some basic coding long ago and I’ve bumped around in Swift a bit, so I think if placeholders were inserted I’d be okay doing the reskinning. Functionality that I’d be looking for: - iOS and Android both (maybe quote for each individually, in case we’d have to do one at a time due to cost?) - splashscreen while itloads, then on to the main screen - thumbnails of images, divided into themes - when the user clicks an image it’d take them to the col...

...searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skills for reporting and discussing the progress...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...