Macro refreshes web queryJobb

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

excel vba programming convert excel sheet function into VBA

...heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability and reliability of the database - Providing recommendations f...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate...

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

Functionalities of desktop application: 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same desktop app Output: macro working without in others that have same desktop

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

Functionalities of desktop app: 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same desktop app Output: macro working without in others that have same desktop

Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

...within the game. The project must be compatible with Windows 10. Candidates should be proficient in at least one of the following programming languages: C++, Python, or Pascal. Payment will be made upon successful demonstration of the emulator working within the game. Note: This project does not involve breaking any game's security measures or installing unsigned drivers. Important Information: Macro usage in the game is permitted and is not considered illegal. Before bidding on the project, please confirm that you have reviewed the code provided in the attachment. The project requires more in-depth and lower-level coding knowledge than the example provided in the attachment. It necessitates knowledge of ring0 level coding." By submitting a proposal for this project,...

...existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong understanding of Excel formulas, formatting, and data transfer functionalities - Excellent communication skills to ensure clear delivery and understanding of the project requirements Your primary focus will be on making sure ...

Develop macro-enabled Excel file to handle CSV

I have made an extension which likes posts of fb one by one and after 5 seconds, page refreshes and then likes new post again one by one. The post which is already liked remains as it is. I am facing an issue that after 1 hour my I'd gets logged out. Mujhe bas yeh chaiye ki vo Waps se login ho jaye I can pay max : 600 rupees

Gostaria de contratar um programador para criar um macro em LUA para diminuiu o recoil de uma arma específica no jogo hunt showdown.

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)

...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 drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards us...

I desire a ...developer with a strong portfolio to create a macro for any use. The objective of the macro is to read a CSV file and automatically send a specific WhatsApp message to each phone number listed in the file. Key requirements include: - import a CSV file (Name,Given Name,Additional Name,Family Name,Phone 1 - Type,Phone 1 - Value) - Creation of a macro that automatically triggers WhatsApp messages. - The macro should be programmed to initiate the messages when it reaches a phone number listed in the CSV file. - The message is from CSV or default the same for all numbers in the CSV file. Ideal Candidate: - Proficiency and extensive experience working with Macrodroid. - A proven track record with similar projects. - Strong attention to detail to ensu...

I require an individual proficient in VB macro script for Mach3. This project entails recreating a Mach4 script that particularly focuses on: - Arc motion control - Tool length calculation from spindle holder to tool tip - B/C axis management and position zeroing I have mach4 script that need to be rewriten to mach3 VB language, I have also a video how it works in mach4 fo refernece. You should be able to implement these specifications based on available documentation. Please remember that the recreated script should maintain as much fidelity to the original Mach4 script as possible. Ideal skills and experiences for the job include: - Familiarity with Mach3 and Mach4 CNC software - Expertise in creating VB macro scripts - Understanding of CNC machine operation, particul...

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

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

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

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.

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

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'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 issues with...

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

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

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

...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: 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 emai...

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

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

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

I need a macro tool that can automatically send predefined messages to Telegram. I would like to implement the ability to send messages to Telegram groups without using Telegram bot. MOST IMPORTANT WITHOUT BOT It must be developed in Python. Key Requirements: - The tool should be designed to work on Windows operating systems. - It should be triggered by a specific keyboard shortcut. - The ability to send both text and media messages is essential. Ideal Skills: - Proficiency in Windows macro tools development - Experience with Telegram API - Strong understanding of media file handling in macro tools Please bid if you have the relevant experience and skills for this project.

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?

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

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." 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 appropriat...

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

...with direct links to the pages/templates where this work has been started. I need someone who is proficient enough with these tools to be fairly self-directed once given access. My web/marketing manager can 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 ...

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

...with direct links to the pages/templates where this work has been started. I need someone who is proficient enough with these tools to be fairly self-directed once given access. My web/marketing manager can 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 ...

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

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...