Refresh query vbaроботи

I'm looking for someone to transform my 35 process flow procedures from Visio to Microsoft Word. The goal is not just to convert these diagrams, but to apply complex formatting including tables, graphics, and appealing textual arrangement. More specifically, - Maintain high levels of detail from the original Visio files, however, please refresh the colored flow diagrams to normal boxes coloured royal blue. - Keep as many graphical elements as possible during the Visio to Word conversion. This task necessitates a good understanding of both Visio and Word. The ideal candidate would be proficient in graphic design and document formatting, with an eye for detail and the ability to interpret and present complex information in an easy-to-understand manner. Prior experience worki...

...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 identifying and fixing bugs and security issues. Experience with API development and integration. Ability to work with the existing database structure without alterations. Good communication skills and ability to provide regular updates. Deliverables: Fully upgraded CodeIgniter 4 project with all features and functionalities working as expected. Optimize...

I am looking for a product designer to enhance the packaging of my packaged drinking water product. The primary goal of this project is to refresh the product's packaging, making it more contemporary, appealing, and user-friendly while maintaining a minimalist and clean style. Key Requirements: - Experience in packaging design, particularly in the consumer goods industry - Proven track record of creating minimalist and clean designs - Familiarity with product packaging for beverages or similar consumer goods is a plus The ideal candidate should be able to understand the essence of minimalism and apply it effectively to the water packaging design. They should also have a strong understanding of the consumer goods market and be able to create a design that stands out on the she...

looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...

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 proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

I need an experienced WordPress developer to work on specific page updates with Elementor and ensure they're completed by Monday morning. Key Requirements: - Implement design changes: The primary goal is to refresh the brand image, ensuring it's consistent with our current branding. - Efficient and quick: This is an urgent task, I need someone who can start today and complete it by Monday morning. Ideal Skills and Experience: - Proficient in WordPress: You should be well-versed in WordPress, particularly in working with Elementor. - Strong design sense: Experience with design and branding is crucial to ensure the updated pages align with our brand image. - Time management: The ability to work under tight deadlines and deliver high-quality results promptly is extremely im...

I'm seeking a talented graphic designer to refresh our website design for on mobile and desktop platforms . Must make the website quicker and incredibly user friendly. Key Requirements: - I need the website to have a clean, professional look that accurately reflects the informative content. - It should be user-friendly and intuitive to navigate, focusing on providing a seamless user experience. - The design should incorporate a consistent color scheme and typography that aligns with the overall branding. Ideal Skill Sets: - Strong understanding of user experience and user interface design. - Proficiency in graphic design software and tools. - Prior experience in designing and developing informational websites. - Excellent communication skills to ensure that the

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.

I am looking for a freelancer to assist with cleaning and 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 A...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 added advantage. If you are interested in this project, please include any relevant experience in...

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

...success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web design packages with confidence, highlighting the value we br...

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

...Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to the courier for confirmation. Technical Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with ...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

I have a Node.js website where a critical bug has surfaced. Every time I log in with one ID, the session automatically switches to another ID after a page refresh. This is causing severe disruptions and needs urgent attention within 24 hours. Key Aspects: - Immediate resolution of the login bug that switches sessions. Ideal Skills and Experience: - Proficient in Node.js and troubleshooting login related issues. - Quick turnaround to address the issues within the specified time frame.

...across editing the design, content, and functionality aspects. (I just bought this from Astra Pro with Spectra, essential, Optimizer and YOAST - along with the Godaddy WordPress hosting) I have decent content from another of my sites to copy across to - Compress components with gzip Add Expires headers Make fewer HTTP requests Design Updates: - Changing colours: I want to refresh the colour scheme of the website to make it more vibrant and engaging - Updating fonts: The current font is outdated. I need a modern, sleek, and readable font to be implemented - Redesigning the logo: A logo redesign to reflect the updated color scheme and font Content Updates: - Updating text: The text content on the website needs to be refreshed to be more compelling, accurate and engaging

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I'm seeking a WooCommerce expert for my website's redesign, specifically the homepage. Additionally, the project includes implementing new product categories and enhancing the checkout process. Key improvements required: - Homepage Redesign: The existing presentation needs a facelift. Let's make it more modern with better user-friendly navigation. My products should be the highlight. I'd love to see your creative ideas on how to best showcase less than 50 products. - New Product Categories: Currently, I feel the product categories are inadequate. I need newer, more relevant ones added to better classify my products. - Checkout Process: Consumers love simplicity, so let's make sure that ours is as straightforward and streamlined as possible. Ideal freelancer for...

I'm in need of an HTML JS developer to refresh the front-end of my existing website. My web site uses pages that have components generated in JS. Many of the properties are created / set in javascript are difficult to support and change. I would like the properties moved to a CSS file where they can be set more easily. I need a developer who works hard and long hours like myself. Obviously excellent HTML/CSS/Javascript are essential for the right developer. May lead to more work doing exciting new development . .

I'm looking to extensively update the homepage of our golf course's website. Occupying a unique space in the golfing industry, we need a skilled professional who can elevate our online presence. Specifically, the tasks would involve a revamp of our site that is on jonas club management software - Revamping the visual design and page layout. This will give enhanced visual appeal and improved UX. - Integrating a video: A critical part of the new designs will be the addition of video content. Thus, proficiency in embedding and optimizing web video content is extremely crucial to this project. - Implementing an Event RSS feed: The next major addition will be an Event RSS feed. Our chosen professional should have extensive experience in working with RSS feeds to ensure seamless in...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

Hello Özkan I’ll just make the official project for the 5 illustrations here, that we discussed earlier. To refresh, we would like 3 of the images to be of the BygMax character and 2 of Rasmus. I will attach a picture you can use as inspiration (please ignore the one with yellow background). Best regards The BygMax Team

I'm looking for a WordPress developer who can refresh the layout of my site. Key Responsibilities: - Overhauling the overall layout. one page only. Ideal Skillset: - Proficient in WordPress - Strong eye for typography and layout - Experience in UI/UX design would be a plus Your work will be vital in making my website more engaging and enhancing the user experience. I look forward to discussing this project with a professional who is passionate about website design.

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web design packages with confidence, highlighting the value we br...

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...

I'm looking for a WordPress developer to assist me in fixing some style issues on my website. Quote first one page, then we can talk about refresh of the site, so I need, on elementor 1. fix styling on testimonial 2. fix color on box 3. copy paste some call to actions

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

...file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weigh...

i need some help to refresh the jwt based on springboot 3 project

..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...

I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I am seeking a proficient Squarespace expert to refresh and enhance my website. The ideal candidate should have excellent knowledge in Squarespace content management and functionality tweaking. Key Task Areas: • Content Updates: I need additional pages and sections integrated seamlessly into my existing site. The new content should be in line with the current design for consistency. • Functionality Improvements: I am looking at improving the functionality of my website's existing features. Also, there is room for optimizing the overall website performance. Previous experience in similar projects will be preferred. I am looking forward to a proactive freelancer who can suggest creative ways to keep my website updated and efficient. Looking at a quarterly retainer...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

...Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experi...

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Ski...