Excel vba sql update statementроботи

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...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...

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...

...diverse target audience which includes the general public, builders, engineers, architects clients, and a specific building industry/niche market. Use the details of the amarco website and show the format you suggest. Key elements of the project include: - A fresh, modern and responsive design: I'm looking to update the layout and overall design of my website to make it more visually appealing and engaging for visitors. - We want to update the website to display, mention and outline with text and images the expansion of the company as a builder and developer services provider. - Enhanced navigation: The new design should include improved navigation to ensure that users can easily find the information they need and seamlessly navigate through the website. - Ad...

I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your focus should be on creating an strategy with clear execution steps and compelling content to update the website and also for email and content marketing channels. Experience and skills needed: - Refine the messaging for our company website - Proven track record in B2B product marketing - Expertise in email and content marketing strategies - Strong understanding of optimization for these marketing channels - Ability to create relevant, impactful content that resonates with business clients Your task will be to help me reach businesses effectively and persuasively ...

necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in need of a talented graphic designer who can create a modern, bright, and bold logo for my brand. Key requirements for the logo: - Modern Style: I'm looking for a sleek and contemporary logo, something that resonates with current design trends. - Bright & Bold Color Scheme: The logo should use vibrant, eye-catching colors. Think of colors that stand out and make a statement. Ideal skills and experience: - Proven experience in creating high-quality, modern logos - A strong understanding of color theory and how to use bright and bold colors effectively in design - Ability to create a design that can work well across various platforms and sizes.

I'm in need of an exceptional landing page that focuses on promoting my product. While I have some branding elements like color schemes and logos, I'm open to creative interpretations within this framework. Key Requirements: - The main objective is to showcase the features of the product in a...much time until FIRE. The app is available on iOs, MacOs and Android and I have the links for all of the platforms and I would like the landing page to have the standard AppStore/PlayStore download links/buttons. I am opened to suggestions for the hosting part, maybe Wix can be a good candidate, not sure. The only requirement will be to be able to connect a domain because I have my own domain. UPDATE: Redesign this page please ->

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I need an experienced graphic designer to assist with my small city council campaign. The project entails: - Modifying an existing political yard sign to update the campaign message and include contact information. - Creating designs for campaign mailers and email materials. The ideal candidate should have previous experience with political or non-profit campaigns, and possess excellent attention to detail. Familiarity working with print and digital media is also required. A refined sense of aesthetics, familiarity with current design software, and an understanding of the political landscape will be appreciated. This is a campaign for reelection, so basic design is complete; some simple updates to yard signs is required, as well as working with the candidate on campaign mailers. ...

Freelancer hiring for Seo Expert, Social media Expert My friend is looking for a freelancer who can do 1. seo activities on a daily basis, update the sheet. 2. Do work on social media with posting stories, highlight creation, daily activities on social media. #seo #remote #freelanceseo #seofreelancer #socialmedia #socialmediaexpert #freelancer #freelance #daily2/3

...#4, ACER, $.. We will post for the winner 4 separate jobs, each will be separate awarded before start! If same computer we can’t fix, is no pay, of course To start communication you need to answer with: “4 computers” so I know you read my listing 1, I have on older HP laptop, have not used since 2021, run on Microsoft Office Enterprise 2007 Can’t go online: “YOUR CLOCK IS BEHING” - I go to “Update Date and Time” - Go to “Change date and Time” - “X Unable to continue” you don’t have a permission to perform this task. - I tried on Youtube, that was not helpful: “How to Fix Windows 10 Errors 2021 | Start Menu Not Working ~ Settings Not Opening - 100% Fix” 2, LENOVO laptop: IdeaPad 3 15IIL05,...

...of the week - Travel tips and inspiration - Call to action to book - Contact information **Deliverables:** - Fully designed and tested email templates for each of the emails listed above. - Integration with Constant Contact to ensure automated sending based on the specified triggers. - Initial setup and testing of the weekly deals newsletter template, with instructions on how to update it with new deals each week. **Requirements:** - Experience with Constant Contact email campaign setup. - Strong copywriting skills to craft engaging and persuasive email content. - Proficiency in email design to create visually appealing templates. - Knowledge of email marketing best practices and automation workflows. **Deadline:** Please provide an estimated timeline for proj...

...simple and efficient development process. • Scope: The project will include updating page colors, fonts, and images to reflect our brand. The template will remain largely unchanged to maintain development simplicity. • Deliverables: A visually appealing website that aligns with our brand identity, using both vector and image overlays where appropriate. Key Requirements: 1. Brand Integration: • Update the template with our brand colors and fonts. • Ensure consistency in design elements across all pages. 2. Image Customization: • Replace existing template images with branded images or vector graphics. • Apply color overlays or shading to images to match our brand's aesthetic. 3. Minimal Template Changes: • Keep the original template structur...

...app from the apple store – must facilitate the option to enable users to subscribe to a quarterly payment model. This is a must. 2. Error trapping - must be able to fail a call or function without crashing the app 3. All dates are in dd/mm/yyyy 4. The Search function must work across all prizes not just those currently calling 5. The code must be deposited in our github 6. Apple must accept the update 7. All drafts must use a version number on the front screen which are incremented for each version 8. Must use our new logo (to be supplied) Additional functions - A new section in the app to cover prize stats This section enables users to get finalists to each art prize using the api’s supplied. This includes: 1. Get finalists for a given prize for a given year (using ...

I'm looking to revamp the Projects Page of my website with the main goal of realigning it. Key requirements: - Update the design of the Projects Page - Realign the Featured Projects section - Ensure consistency with the rest of the site This is a simple WorPress Fix

We are seeking a skilled developer or development team to create a comprehensive web crawler system. This system should scrape, structure, and update information from web pages, handle large projects, and be accessible via a powerful API. The system should offer user-friendly features for both individuals and businesses and include flexible user management for both customers and employees. Project Requirements 1. Web Crawling and Data Extraction -Develop a system capable of scraping entire websites and extracting data from each page. -The system should divide the scraped information into sections to facilitate easy reading and understanding. -For e-commerce sites, the system should identify and structure the following information: --Product category (including breadcrumbs for hiera...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.

...accounts and log in. - Push Notifications: Utilizing notifications to engage with users and keep them updated with the latest offers, deals, and more. - Connected to WordPress Shop: The app should effectively fetch and display product data from the existing WordPress shop, ensuring real-time updates of the product catalog. - Custom Stock Management: Admin should have the capability to manage and update stock information with ease. - Bidding Auction System: A unique feature allowing customers to place offers on products, creating a dynamic shopping environment. - Custom Photo Upload: Customers should be able to upload custom photos from their devices to the WordPress shop. This feature will enhance personalization and engagement. Ideal candidates for this project should have: - P...

...This includes setting up the website from scratch, making sure all the necessary pages are created, and ensuring it's user-friendly. - **Arabic Language Support**: The website should be developed in a way that fully supports the Arabic language, including all aspects such as product descriptions, user interface, etc. - **Manual Product Management**: I prefer a system where I can manually add and update products. The chosen freelancer should be able to create a simple and efficient system for me to do this. - **Payment Methods**: I'm looking to offer 'Cash on Delivery' as the primary payment method. This should be seamlessly integrated into the website. Ideal Skills and Experience: - **E-commerce Website Development**: A proven track record of creating suc...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...

I'll provide you a link to one webpage where the HTML is available that I need to be made responsive across all devices. This means that the layout and content on the site should adjust automatically to the screen size of the device being used. Show me what you did including the new CSS and I should be able to update more pages myself using what you did as a guide. I do not want anything to look much different on a computer/PC screen than it does now. Just make it also work on cellphones, tablets, etc. I'll test your work on the website and ask a few friends to test on their devices then pay you. But I may need more help later which I'll also pay you using Freelancer if needed. Thank you

I'm searching for a professional who can address the issue of an incorrect .p12 key in my Android application. Key Tasks: - Troubleshoot the current .p12 key to identify the cause of the issue - Generate a new key for the application - Update the app with the new key to ensure proper functionality Experience and Skills: - Demonstrable experience with Android app development - Proficiency in handling .p12 key issues - Strong knowledge of Android security protocols and practices I'd appreciate someone who can take care of this process. The applicant should also be able to confirm compatibility of the new key with the versions of Android the app is currently supporting. Please include any relevant experience you have in maintaining and updating Android apps in your propos...

I'm looking for someone who can do an easy update to my website Check out this area of the website, where I have my books listed: I need to add 7 or 8 of my latest books to what you see there. I'll supply the images and the text. The website is a Wordpress site hosted on Namecheap. Requirement: Please only bid exactly what you're willing to do the work for.

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...

I require an expert in WordPress, Elementor, and The7 theme to assist with updating my website. - I am currently running Elementor version 3.1.1 and The7 ...theme to assist with updating my website. - I am currently running Elementor version 3.1.1 and The7 theme version 10.10.0. - I don't believe there were any customizations done to thse. - I am looking for someone who can update these elements while ensuring that the current design and functionality remain unchanged. Ideal Skills and Experience: - Proficiency in WordPress, Elementor, and The7 theme. - Experience in updating WordPress websites while maintaining current design. - Strong understanding of Elementor and its integration with themes. I have tried to update them myself - but I get messages saying the ...

I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...