Excel vba sql update statementεργασίες

Hello, I need convert a PDF invoice to Excel to import to our invoices software

...for: * Distinct use of a beautiful spectrum of colors. A full blend of colors one might expect in a rainbow should be apparent in the design. * While I don't have a specific symbol in mind, I encourage the creative freedom to introduce elements that playfully reflect the characteristic of the brand, while preserving its professional appeal. * Message and Feel: the logo needs to send a clear statement of creativity. It should also suggest a child-friendly vibe. *This logo will be for a pediatric speech language pathology private practice. The name of the practice will be The Speech and Language Place which plays off of SLP which stands for speech-language pathologist. The ideal freelancer for this job would possess creativity and a solid understanding of color psychology...

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately represents the updated data informa...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

reproduire le même a l'identique copier coller avec les calcule automatique les formule de la ou il ya tout les chiffre

...half-duplex. 6a) The RS485 command should trigger an RGB LED sequence and the speaker sound effect. The command contains a reader ID. The reader accepts commands only if the reader ID matches. 6b) When an RFID card is applied, the reader reads a password-protected memory block and sends it to RS485 with the reader's 4-byte ID. 6c) The RS485 command should be able to change the reader's 8-byte ID and update it in EEPROM. 7) One or two digital sourcing outputs that can send a pulse to a lock or an indicator lamp. Let's say 500mA. 8) One or two digital inputs, sinking, working in the full range of the power supply voltage. 9) Power voltage range 5-26VDC. A decent capacitor must compensate for possible voltage drop when an output is energized. 10) External connections:...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX for the programm...

I need an AutoCAD expert to help me make some modifications to existing DWG drawings. - The main task is to flip and rotate the drawings so that the garage is on the right side. - The title blocks also need an update to complete the modifications. Additionally, the foundation sheet must reflect a 3-course stem wall with footer. Ideal skills: - Proficiency in AutoCAD - Experience with architectural drawings - Ability to update title blocks - Attention to detail for flipping and rotating drawings - Ability to accurately reflect a 3-course stem wall with footer on the foundation sheet

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'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I cu...

I need a Laravel developer to update my Laravel-based app with a new feature. The update is focused on the user interface, so I am looking for a specialist in Laravel with a strong front-end development portfolio. Key requirements include: - Extensive experience working with Laravel - Proven track record in front-end development - Ability to implement new features while maintaining the overall functionality of the app

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

una pagina web que...seran enviados a su correo y whatapp, tambien tendran la opcion de cambiar su clave o recuperar su clave; los socios podran ver el historial de ventas, comisiones, pagos realizados, saldo, estadisticas, la informacion sera enviada a su correo y whatapp, tambien tendran la opcion de cambiar su clave y recuperar su clave. todo tiene que ser almacenado en una base de datos que se pueda exportar a excel, la pagina web tiene que ser amigable y podra visualizarse desde una computadora, tablet y telefono celular. la pagina web debe estar en idioma español y tener la opcion de cambiar a idioma ingles, el proyecto incluye el codigo fuente el proyecto debe tener la opcion de ofertar varias promociones a los clientes, estas promociones se deben visualizar al inicio ...

Παρακαλούμε Κάνε Εγγραφή ή Κάνε Είσοδο για να δεις λεπτομέρειες.

...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...

Let's do it. let's do it. let's do it

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'm looking for an expert to set up Redis in a Rocky Linux podman container. The aim is to ensure that it communicates over TLS using a Let's Encrypt certificate. Key Tasks: - Configure Redis to communicate over TLS - Integrate a Let's Encrypt certificate Ideal Candidate: - Proven experience with Rocky Linux and podman - Strong understanding of TLS and Let's Encry...Candidate: - Proven experience with Rocky Linux and podman - Strong understanding of TLS and Let's Encrypt - Excellent problem-solving skills The successful candidate will make sure the Redis instance is optimally secured and can communicate over an encrypted channel. I can provide the certificates and build process. podman run --name rediscontainer -it rockylinux:9.3-minimal bash microdnf -y u...

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...

...visitors can view and purchase our products. Signup . The order processed should print on the certain computer linked to the website. It should be supported by Strong Backend database . Key Features: - I need a custom-built website, not a WordPress or Shopify site. - The CMS should have robust product management tools, allowing me to add, remove, or update items under different categories. - Content editing is essential. I need to be able to update the content of the site regularly. - The CMS should also include user account management. This will allow registered customers to have accounts on the site with their own profiles, order history, etc. - Additionally, I need the ability to send promotion messages to registered customers. This will be a key part of our marketin...

I'm looking for a professional who can design a 3D logo. I have a strong preference for a bold and impactful style that will make a statement. The primary use of the logo will be on print materials, so it's important that the design is versatile and can be easily replicated across different media. The ideal candidate for this project will have: - Extensive experience in logo design, particularly in 3D - A portfolio that demonstrates a versatile and impactful design style - The ability to work with minimal input and still produce creative, original designs.

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

...plan on a page that is interactively linked with a provided Excel spreadsheet. Key features should include: * A timeline showcase of milestones directly linking said timeline with the respective Excel data. * Key deliverables and their progress status, again directly pulled from Excel. * Risks and dependencies associated with each milestone or deliverable. * Utilization of data visualization elements like pie charts, bar graphs, and line graphs to represent the status and progress of each aspect dynamically. Preferably, updating Excel should automatically update the PowerPoint plan, allowing for a real-time, accurate portrayal of project progression. Required skills and experience: * Extensive knowledge about PowerPoint and Excel * Experie...

I'm seeking a Django/ Java Script with Bootstrap expert who can assist with the layout and design of my website atplands.com. The primary goal of this project is to update the site's visual appearance. My website: Reference downloadable Theme code: Key tasks include: - Reviewing the current website and providing recommendations for improvements - Collaborating with the team to create a new, fresh look for the site - Ensuring the new design is functional and user-friendly Ideal skills for this project include: - Strong experience with Django/ Java Script with Bootstrap - Proven track record of working on front-end development using JavaScript/Bootstrap - A good eye for design and layout - Ability to understand and implement JavaScript

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the Excel...

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I need an Android app that includes an integrated Tapjoy offerwall. The main functionalities of the app should include: - User Registration: Users s...Registration: Users should be able to log in using their email and password. - Offerwall Integration: The app should have a single Tapjoy offerwall integrated into it. This is the core feature of the app. - User Balance: The user's balance should automatically update after they complete an offer. Ideal skills and experience for this job include: - Proficiency in Android development, including experience with integrating third-party offerwalls. - Understanding of user registration and secure login systems. - Experience in developing apps that update user balances automatically. - Knowledge of Tapjoy or similar offerwall ...

Hi Bhawan, creating this milestone to record the hours to date. Tracking of 14.5 hours as of 19 May.

...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...

I need someone with experience in Shopify and the Order Printer app to assist me in updating the 'Order Forms' and 'Tax Invoice' templates. The previous version of the app has been updated, and as a result, the code for these templates needs to be adapted. The 'Order forms template' must have: Order Number and Order Date Notes from Customer Quantity, Item Details fields including variants and customisation details. Estimated Delivery Date Customer & Shipping Details The 'Tax Invoice' must have: TAX INVOICE Logo Order Number and Order Date Business Name & Address ABN: Customer Name & Address Quantity, Item Details and variant Pricing, Discounts etc Tax displayed as GST Your main focus will be to ensure that the 'Order...

I will deliver the complete updated website

We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.

I need a professional who can convert a 1-10 page PDF document into a fully editable Word file. The main purpose of this conversion is to be able to easily edit and update the contents of the document as needed. Key requirements: - Conversion of a 1-10 page PDF file into an editable Word document. - Retaining the formatting of the original PDF to ensure the Word file looks professional. - Including images from the PDF into the Word document, maintaining their quality and positioning. Ideal skills and experience for this project: - Strong experience with PDF to Word conversions. - Proficiency in Microsoft Word and a good eye for detail to ensure the final Word file is accurate and retains the formatting of the PDF. - Experience with handling images in Word documents. If you think ...

Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

...CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in ident...

I need an engaging and distinctive logo for my Asian food truck business, 'Wok Wow'. The logo should make a bold statement while maintaining simplicity. Key Requirements: - Integration of a wok into the logo design - Bold and simple typography - A minimalist aesthetic - An Asian feel representative of our cuisine Color Preferences: - Predominantly red, black and yellow Font Preferences: - Should not be too generic, it needs to set us apart Ideal skills & experience: - Comprehensive experience in logo design - Experience with food and beverage industry preferred - Strong understanding of the Asian aesthetic - Excellent typography skills This logo will represent us across various marketing channels so I require someone with an understanding of creating adap...

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...

Update, Fix, and Add Features to the website - Add strong security and Chat option in WhatsApp. The same changes will be applied to 3 conferences websites

Seeking a talented designer to create a modern and sophisticated coffee bag design. This project will employ a primarily black-and-white color scheme or a solid color with some gold writing, offering a clean look and feel. Key Features: - Abstract design elements to be incorporated, abstract or a simple design statement - Image should evoke a sense of simplicity and elegance, aligning with a modern aesthetic. Ideal Candidate Should Possess: - Strong experience in packaging design, particularly dealing with food products. - Ability to communicate ideas visually, verbally, and in writing. - Proven ability delivering high-quality designs supporting an upscale brand image.

Project Details Docker and K8s * Containerize any Microservices based app (Frontend and Backend and DB) and run it as a nonroot user. * Write Kubernetes artefacts to deploy above container on K8s. * Setup Database in Kubernetes cluster. * Deploy microservice to Kubernetes cluster. * Ensure that applicati...microservice to Kubernetes cluster. * Ensure that applications are able to communicate with each other. * Only Ul should be Publicly accessible and not the backend. CI-CD * Automated Application Deployment via CICD. * Setup Jenkins in the Ec2 instance created via Terraform. * Create CICD pipeline to automate the actions done in Phase 1 with stages like Build and Push, push the images to Dockerhub, Update the Kubernetes Artifacts with latest image tag and deploy to th...

I am in need of a skilled and experienced mold designer to create a mold for a 10L water tank made of ABS. Please read above statement before bidding - I WANT MOLD DESIGN for BLOW MOLD PROCESS (NOT TANK DESIGN) Key Requirements: - Material: The water tank is to be made of ABS. It's crucial that the mold design is specifically tailored for this material, considering its properties and requirements during the molding process. - Capacity: The water tank needs to have a capacity of 10 liters. The mold design should ensure that this capacity is accurately met in the final product. - Shape: I envision the water tank to have a bulged shape. The mold should be designed accordingly to be feasible for CNC Machining and Casting as well (By checking negative drafts ) Skills and Exper...