Refresh web query data vbapráce
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monit...landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calcul...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Pr...landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine
...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 bring to their business. Closing the Deal: You'll guide clients through the sales process, securing their commitment to a website project...
I have a plugin that uses shortcodes, so i have tried to show via php in the checkout sidebar of woocommercel, it works only when you refresh the page, after page load its disappear.
...potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Too...
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 looking for a talented WordPress developer to help me with some fixes and updates on my website. The project includes: - Updating existing content: I need to refresh the existing content on my website. This involves tweaking language, adding new information, and ensuring a consistent tone across all pages. - Improving site speed: It's essential that my website loads quickly and efficiently. I need someone who can assess the current speed of my site and implement the necessary changes to improve it. Ideal candidates should have: - Proven experience in WordPress website management - Proficiency in content creation and editing - Strong understanding of website optimization and speed enhancement
I'm looking for a professional designer to help me refresh my logo as part of a rebranding effort. I've decided to stay with the existing color scheme, font style, and symbol/icon, but I want to modernize and freshen the overall look. Key Points: - The redesign is part of a rebranding exercise, so the new logo should align with my updated brand identity. - I wish to maintain the current color scheme, font style, and symbol/icon, but I'm open to their reinterpretation. - The new logo should reflect a minimalist, vibrant, and slightly vintage-inspired aesthetic, steering clear of being too busy or complex. Ideal Skills and Experience: - Extensive experience in logo design, particularly in the context of rebranding. - Proficiency in working with existing brand elements...
...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 bring to their business. Closing the Deal: You'll guide clients through the sales process, securing their commitment to a website project...
Hello, I am currently looking for an experienced graphic designer to refresh my company's logo. It's a modern styled logo and I'd love to retain the current color scheme. However, the key to this update is that I want the refreshed version to be much more dynamic. We need to make a Wayne Dresser Ovation gas pump look good with logo Ideal skills and experience: - Proven graphic design experience - Strong creativity and design skills - Ability to understand and incorporate company color schemes - Good understanding and previous experience in branding - Experience in creating dynamic logo designs Looking forward to receiving your exciting proposals!
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
I'm looking for a talented designer to help me modernize my current bold and vibrant logo. The main goal of this project is to refresh and modernize the logo while retaining the original color scheme and symbol/icon. Key Requirements: - Modernize the existing logo to better reflect the brand's values and image. - Retain most of the original color scheme and symbol/icon. - Use a better font and text design for the brand - Keep the sun and use palm trees, Tampa florida skyline shadow (partial okay) , and the sun in the background or foreground Ideal Skills and Experience: - Previous experience in logo design, specifically with modernizing existing logos. - Strong understanding of color psychology and brand values. - Creative and innovative approach to logo design, while r...
...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to dr...
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.
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...
...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 Site Tools -> MySQL -> PHPMyAdmin. Here, you can directl...
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'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.
...dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be...
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...
...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 bring to their business. Closing the Deal: You'll guide clients through the sales process, securing their commitment to a website project...
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 databas...candidate should 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 a...
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.
I'm looking for a talented web developer to help improve my existing website. The changes I seek span 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
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 . .
...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 integration. The ideal person for this task would have substantial experience in web design, specifically with Jonas software due to our website's backend. They should also have a solid understanding of UX design, typography, graphic design and familiarity with integrating video and RSS f...
...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 integration &...
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).
...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 bring to their business. Closing the Deal: You'll guide clients through the sales process, securing their commitment to a website project...
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(&quo...
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.
