Macro refreshes web querypekerjaan
I am looking to develop a VBA macro that can automate advanced data analysis. The macro should feature predictive modeling capabilities and be able to analyze a variety of data sets. I may or may not have the data sets needed for the macro, so I am open to suggestions from experienced freelancers. If you have expertise in this area and can help create a macro that meets my needs, please get in touch!
I am looking to develop a VBA macro that can automate advanced data analysis. The macro should feature predictive modeling capabilities and be able to analyze a variety of data sets. I may or may not have the data sets needed for the macro, so I am open to suggestions from experienced freelancers. If you have expertise in this area and can help create a macro that meets my needs, please get in touch!
Hi, Very urgent!!. I have an unfinished Flutter app. I need you to do the following: IMPORTANT: MUST... I have an unfinished Flutter app. I need you to do the following: IMPORTANT: MUST HAVE EXPERIENCE WITH BLOC AND SQFLITE! NEED IT DONE ASAP, MAX within 12 hours!! 1) Read data from SQFlite and display in a Calendar. Eg. If I added a record today 20th Aug, then it should show in a calendar with a marker on the 20th Aug date on the calendar 2) Search records via keywords. I have the specific query ready, you just need to implement it and display the data. Please add your GitHub username so I can add you as a contributor to show you the code. Sadly I can't pay more than $35. I apologise for that. Please add "I have experience with SQFLite and Bloc pattern" b...
...elucidating the logic, input parameters, and utilization of the modified function. - A meticulously tested function, accompanied by tangible proof of testing using furnished sample data. **Requirements:** Applicants for this role must demonstrate proficiency in the following areas: - Profound expertise in SQL Server (T-SQL) programming. - A thorough comprehension of SQL functions and adeptness in query optimization. - The ability to decipher and translate specific conditions into executable logic for prefix/suffix addition. - A track record of crafting lucid technical documentation. - Familiarity with database schemas, table structures, and the nuances of relationships therein. **Submission Requirements:** In response to this RFP, interested developers are required to submit pr...
I want to configure Google Cloud to auto-send specific query data from Google Big query to Firebase Firestore. I am looking for a freelancer who can help me do the setup. If you have done this before you will be able to do this in 10 minutes. Please ping me with "I've done this before" if you can help.
...channel) on the local hard drive (in a defined folder) and creates an HTML file for opening the list in the browser at a later time. One file for each input link. The HTML file has the option to sort the list content by video length, channel etc. 3) Waits a user-defined number of seconds to avoid the IP getting flagged as a bot, repeats the steps for the next URL until all URLs are scraped. 4.) Refreshes pages after a set number of minutes (which can be adjusted by the user for each link) 5.) Automatically repeats steps 1-4 and adds new results to the previous local file. (Does not save duplicates.) 6.) The local file should look like a long search result list if opened. Links should be clickable, same as on Youtube and sortable by video length. See attachment example Needed...
Hello! I am excited to announce the launch of an ERP specifically designed for Chemists and Pharmacists. To promote this innovative solution, I am currently seeking Medical Representatives / ERP Sales Person to join our team. As a ERP Sales/Medical Representative, you will receive a generous commission of 25% for your successful promotions. If you're interested in thi...Annual charges will be $200. Which include domain and hosting extension and upgrade and maintaininv for the year. Check this blog to know about the features of Software This project will not be assigned to one person. It will have milestones to those who have got a client. Please message if you have any query, confusion or problem.
I am looking for a skilled Excel macro VBA developer to create a dynamic graphic project timeline for my project. Dynamic Elements: - Gantt chart: The graphic timeline should include a Gantt chart that visually represents the project's tasks and their durations. Design and Layout: - I have a specific design in mind for the graphic timeline. The developer should be able to incorporate my design into the Excel macro VBA code. Automatic Update: - The macro should be able to automatically update the graphic timeline based on data changes. This means that any changes to the project's tasks or durations should be reflected in the Gantt chart without the need for manual updates. Ideal Skills and Experience: - Strong proficiency in Excel macro VBA develop...
...I'm looking for a Freelancer who can commit to helping me achieve my goal and take the project to the next level. If you have the experience, creativity, and dedication to make this project a success, then I'm definitely interested in hearing from you. Please feel free to reach out with any relevant experience and suggestions. Thanks! Objective: - Develop a comprehensive marketing strategy for Macro Panda Roma Target Market: - Focus on the North American market Using social media, and adult advertising platforms Skills and Experience Required: - Expertise in marketing strategy development - Strong understanding of the international market - Proven track record of success in creating effective marketing campaigns....
I am looking for an expert freelancer who can create a macro for standardizing law review pieces for publication. The particular pieces I want to standardize are articles, and the length of these articles will exceed 20 pages. I will provide a specific format or style guide that needs to be followed; however, the freelancer is welcome to suggest solutions or options during our discussions. If you are confident in your ability to successfully complete this project, please contact me and I will provide more detailed information. Thank you for your time and interest.
I'm looking for an experienced freelancer to help me create a real-time prompt generator/optimiser for a ChatGPT API/VBA macro. This project requires an advanced level of technical expertise, so I am looking for applicants who can demonstrate a variety of past work and relevant experience.
Referal Tree calcuation for each user's downline business. for 5 lakh users database mysql need faster calculation. The database is mysql. and u need to perform query in a way that daily it will get calculated in half an hour. and then write a code to calculate payout based on some little conditions
Assist in automating the process of generating a post-trade order file for a PMS Client 1. Develop a new macro that takes inputs from the pre-trade order file and portfolio reports to generate a post-trade order file. 2. Find the difference in units for each security bought/sold between Pre-order and actual execution (obtained from contract notes). 3. If the difference between intended and actual units is zero, the macro should allocate desired units to each client as specified in the pre-trade order file. 4. If actual units bought/sold are less than intended, provide a mechanism for the PMS team to manually allocate units to clients or implement a predefined logic. Next Phase Convert the above post allocation file in an uploadable Excel format with details such as Client ...
your job is to implement a rest api client in Java to query and to provide filtering functions like this code: It is even the same API! todos: - implement models via jsonschema2pojo => 1st generated and working version is provided to you! => you need to tidy up based on logical features (disk, ram, cpu, network, ...) into custom classes - implement filtering on top of JPA CriteriaBuilder/compiletime safty - CPUs - disk size, type, count - RAM total, modules-count, ecc - networking see also here: milestones: ms1: define Entities for json data map DTOs to Entities implement model 2 entity mapping (preferably
I am looking for a Google maps expert who can help me find a bug in my Excel macro script. The script has worked for years. Currently, the script's stoped work. Identification of the issue and a proposed fix.
We will break this activity into two broad phases:​ ​ 1) Filling table in Excel for email fields – An Excel table needs to be created outlining the various fields and their values, necessary for this purpose. ​ ​ 2) Interface – A file containing the relevant macro(s) needs to be developed, which will have an easy user interface. Bare minimum inputs (for example, username and password of the sender's email id) need to be specified by the user. Thereafter, he will click a button and the macros will trigger the emails. ​ ​ NOTE: The emails will be triggered through Outlook. Therefore, implementation of Outlook is of utmost important. ​ I am looking for a developer who can create an auto-emailer using VBA Macros for Outlook. The ideal candidate should have experienc...
I will add the following features to the following bots: 1. Remove duplicate bot I will add a feature...to the following bots: 1. Remove duplicate bot I will add a feature that will allow this bot to search on e-mail too (currently it only uses phone number) 2. Macro bot I will add features that will make this bot better at error handling and recovering from errors. 3. Gmail bot I will add some more dynamic features that can be determined in the Excel-input file. These features including: - Being able to specify multiple e-mail subjectnames in the Excel file, that the robot will process - Being able to specify an e-mail subjectname in the Excel file, that should be excluded from processing by the robot. - Being able to specify a query in the Excel file, the robot will pr...
...advanced familiarity with VBA Macros to develop a record comparison tool. The primary purpose of the tool is to compare records across multiple datasets. There is a file attached which has the earlier version of the same macro. Datasets: - The client can either provide specific datasets or the freelancer can provide them, as long as the tool works as intended. Description: 1) Find Replace component - There are two main sheets in the macro viz. Data and Report. We need to enable the user to carry out find / replace for multiple values in either of the two sheets, through a macro. Such find / replace may be subject to additional conditions based on some other fields. Also the replace field to be mentioned by the user, which can be different from the find field. Ex...
I am looking for someone to help with labelling products through Excel. The items I need labelled are not food products or clothing items, but metal parts. We have a Macro that grabs information from an Excel and copies the data into a print file. But we need it to grab additional information now.
I had one application which uses MS Access as Database. I also had a query. I want to optimize that query for fast retrieve of the data.
...should be capable of registering booking requests, collecting key details such as dates, products, quantity, and any special requirements. 2. **Quote and Budget Queries**: When receiving a quote or budget request, the bot must gather details of the required service, destination, origin, type of cargo, and other relevant data. It should then either provide a preliminary estimate or redirect the query to the sales team. 3. **Service Information**: When inquired about services, the bot should offer predefined answers about the range of services the company offers, standard rates (if applicable), and how to start a shipment. 4. **Sales and Promotions**: For inquiries about promotions or sales, the bot should be able to showcase current offers, special packages, and any other perti...
Ya he estado en conversaciones con mi Querido desarrollador Ravi C. @Webxpert4u , y este Proyecto es personal para él. Por lo tanto, no es necesario que nadie más me haga ofertas... Aún así, ya verás la de ofertas que voy a tener porque todas van en automático, sin leer ABSOLUTAMENTE NADA del proyecto!
I am seeking an experienced and highly skilled Full Stack Web Developer to lead the design, development, and implementation of a cutting-edge dating website and matching app, with enormous potential. I will consider customizing any robust reputable white label DATING software. The successful candidate will play a pivotal role in creating an exceptional user experience through innovative features, seamless functionality, and an intuitive interface. This role requires a strong foundation in web development, experience with dating websites & templates, app development, and proficiency in a variety of software and skills relevant to this project. This project will incorporate various features to enhance the user experience and streamline the vetting and matching process. The ...
I have several pdf forms that are filled everyday by several users and saved to a cloud. After it, all forms are validated in order to fix Whats wrong and past them to the same folder. On acrobat I use the option “merge forms into a spreadsheet” and create a csv file with all data extracted from these forms. The file is imported on an Excel file where a VBA macro is runned and the information organized on tables. O would like to automatize all these tasks.
Greetings!!!! I'm looking for macro-enabled google sheet. The sheet is meant to be record data entries related to purchase, dispatch, receive, storing and consumption of various goods/materials from various locations and machines. The purpose is to mainly record inter-transfer of goods between company's locations and provide available stock at the end of the day. An important note is that the goods that dispatched and received are can be consumed at location/handover to any employee/put in machine use. I need following reports - 1. A report showing up-to-date available stocks of goods after adding inward subtracting outward and consume of goods for a particular good for any location during given point of time. 2. A report showing date-wise cons...
Excel macro needed to copy named ranges from 1 sheet and paste them into another sheet - will need a user selection interface so basic macro process would be as follows: 1. user runs macro by selecting Ctrl+Shft+I or similar 2. message box pops up asking user which named range they would like to insert (if this could be drop down selection it would be good) 3. macro then copies that named range and pastes it into the next available roww in the sheet where the user is working Sample doc attached with main sheet and then sheet of named ranges (there would be 50+ named ranges to select from on the actual document and would want to be easily able to add them to the selection process)
...carefully curated to align with different artistic styles, such as minimalistic, abstract, or nature-inspired designs. Users will have the freedom to personalize their virtual assistant's appearance to suit their individual tastes. 3. Interactive Visual Feedback: To enhance user engagement, our virtual assistant will provide interactive visual feedback. For instance, when responding to a user's query, the assistant may display animated graphics or subtle visual cues to indicate that it is actively processing information. This artistic touch will add an element of delight and intrigue to the user's experience. 4. Artistic Voice Assistant: Going beyond visual aesthetics, we aim to imbue our virtual assistant with an artistic personality. The assistant's voice ...
I have several pdf forms that are filled everyday by several users and saved to a cloud. After it, all forms are validated in order to fix Whats wrong and past them to the same folder. On acrobat I use the option “merge forms into a spreadsheet” and create a csv file with all data extracted from these forms. The file is imported on an Excel file where a VBA macro is runned and the information organized on tables. O would like to automatize all these tasks.
Title: Dynamics 365 query using Power Automate Project Description: I am looking for a freelancer experienced in Dynamics 365 and Power Automate to assist me with extracting specific contact information from Dynamics 365. Data Extraction: - The main focus will be on extracting contact information from Dynamics 365. - The extracted data should be presented in JSON output format. Skills and Experience: - Strong knowledge and experience in Dynamics 365 and Power Automate. - Proficient in working with JSON output and extracting data from Dynamics 365. Data Extraction Frequency: - The data extraction should be performed on demand, whenever required. If you have the necessary skills and experience in Dynamics 365 and Power Automate, and can efficiently extract contact information fr...
I am looking for a MySQL performance tuning helper who can assist me in improving the performance of my small (less than 1GB) database. The specific performance issue I am currently facing is slow query execution. The table has 16742 rows. The query is as simple as select * from test where FirstName = 'aa' and LastName = 'bb' and DOB = '1950-12-20'. The duration takes about 0.2 sec to 1.1sec when using Workbench to do query test. I am looking for a helper who really knows the MySQL performance tuning and also can do AnyDesk remotely.
I am looking for an experienced Excel expert who can help me build automation macros using Excel's built-in features. Although I have a general idea of the tasks that need to be automated, I do not have a specific task in mind. Skills and experience required: - Strong knowledge of Excel and its built-in features for automation - Proficiency in creating macros using Excel's built-in features - Ability to understand and interpret general ideas for automation tasks - Experience in developing efficient and user-friendly automation solutions in Excel If you have the expertise and skills required for this project, please submit your proposal.
Hi, I want to store the data for the below two endpoints into an AWS database. The data fetch should execute every day at a given time and just accumulate data into it for past 12 months (once it reaches to 12 months of data, it can delete older one): AWS database. The data fetch should execute every day at a given time and just accumulate data into it for past 12 months (once it reaches to 12 months of data, it can delete older one): I would also like to learn how to be able to query it with python as I need to do some analysis on it (once there is some data stored).
...requirements I have in mind for the website: * Design Concept: I would like the overall design to exude professionalism, reliability, and innovation. The use of a clean and minimalistic style is preferred to ensure the content stands out. * Navigation: The navigation menu should be intuitive and user-friendly, allowing visitors to easily find the information they are looking for. * Query Forms: The website should include query forms that prospective clients can fill in to express their interest in our services. * Candidate Submissions: Potential job candidates should have the option to answer specific questions and submit their CVs through a designated form. * Responsive Design: The website must be fully responsive and optimized for various devices, including desktops, tab...
I am looking for a Salesforce REST API expert who can assist me with API integration and data manipulation. Tasks Assume that I already have the auth token thats sent to salesforce I need a one or two pager Google doc with the correct endpoints and the correct query and body params that I need to send to salesforce to get that data 1. Be able to fetch all contacts in salesforce paginated 2. Be able to fetch all report names in salesforce 3. Be able to fetch contacts by report names (id) 4. Be able to fetch call logs either all or for a given contact 5. Be able to create call logs for a given contact (contact id) I am using javascript's native fetch for this, so need the answers in javascript No development work is needed, I need these as a Google Doc
...specific searches. Key Features of the Tool: Automated Queries: The tool should enable users to paste a URL and automate the opening queries Frequency Analysis: The developer will need to establish a built-in analysis system to track the number of times a specific search is performed. IP Proxysation: Strong knowledge of IP proxysation is necessary to ensure the tool's smooth operation and to avoid query blocks. Additional Requirements: Proficiency in programming and relevant languages for tool development. Ability to work independently and troubleshoot technical issues. Previous experience in similar projects would be an advantage. If you are a developer who is creative and passionate about automation, IP proxysation, and search engines, we would be thrilled to collabor...
...max out at 500 results per query so you may have to individually search each letter of the alphabet and pull the results and in some cases break it down even further when a letter returns more than 500 results. Source of the Data: - The data to be scraped is located on a website. Type of Data: - I am specifically interested in scraping contact details from the website. I need the Persons Name, Address, Phone Number, Email, Fax and Website and license status. Preferred Format: - I would prefer the scraped data to be delivered in Excel format. Skills and Experience: - Experience in web scraping and data extraction. - Proficiency in Python or any other suitable programming language for web scraping. - Knowledge of
I have several pdf forms that are filled everyday by several users and saved to a cloud. After it, all forms are validated in order to fix Whats wrong and past them to the same folder. On acrobat I use the option “merge forms into a spreadsheet” and create a csv file with all data extracted from these forms. The file is imported on an Excel file where a VBA macro is runned and the information organized on tables. O would like to automatize all these tasks.
I have several pdf forms that are filled everyday by several users and saved to a cloud. After it, all forms are validated in order to fix Whats wrong and past them to the same folder. On acrobat I use the option “merge forms into a spreadsheet” and create a csv file with all data extracted from these forms. The file is imported on an Excel file where a VBA macro is runned and the information organized on tables. O would like to automatize all these tasks.
I am looking for a freelancer who can customize my affiliate travel website. The specific customization I need includes design and layout changes. I have examples of specific designs and layouts that I want to emulate, so the ideal candidate should be able to incorporate these examples into the website. I would like to be involved every step of the way...for the job: - Proficiency in website design and layout customization - Experience with affiliate travel websites - Ability to incorporate specific design examples into the website - Excellent communication skills to provide regular updates and collaborate effectively with me throughout the process. apart from the customization i need to add 3 pages 1 about us and one speacial offer page where a query form will be added and conta...
I have 2 tables and I want to combine them. I beleive VBA can be helpful here. I want rows in the one table to be repeated for any respective word from the other table. Description with example table output will be provided.
...on the website/app initially. Required Features: - Logo design for the website and app. - Web and Mobile Friendly website. - Web and App interface and user experience is priority. It should be rich and smooth. - Property search feature should be robust with advanced capabilities like searching Title or Content or any part of the listing and coming up with precise listings as per user query. - Property Sorting should be robust. - Property Listing interface we provide to Seller should be very simple and easy. - Integrate Google Maps to locate the properties and for other location based services. - Other details would be mentioned during implementation. Ideal Skills and Experience: - Proficiency in web development and design. - Experience in creating real esta...
Looking for a developer to undertake conversion of mysql queries to mysqli for a php website.... the website has been working fine until it stopped when the hosting company "upgraded" the php version or something... i dunno how much to put in so please read carefully... auto bid will be ignored...
...design in mind: I have a specific design in mind for the wallboard, see attached wireframe photo in files Preferred Platform: - Web: The wallboard should be developed for the web platform. Process: - Microsoft GraphAPI will need to be queried once a day at midnight to pull in all users within that department, on this query it will also pull down the photo, department, name, phone, cell phone. - Microsoft GraphAPI will need to be pulled every 30 seconds to obtain all users presence information to include current teams status, any custom status, and time status was set. This information will likely be stored in a database, that database will be queried by the web page visible to end users who want to know status of specific department. On the 30 second interv...
your job is to implement a rest api client in Java to query and to provide filtering functions like this code: It is even the same API! todos: - implement models via jsonschema2pojo => 1st generated version is provided to you => you need to tidy up based on logical features (disk, ram, cpu, network, ...) into custom classes - implement spring boot environment - implement filtering on top of java objects, filters are required - CPUs - disk size, type, count - RAM total, modules-count, ecc - networking see also here: milestones: ms1: implement filters by given params above this is already provided to you:
...freelancer who can help me with a project to create a simple web page that runs an Oracle SQL query and saves the output as a CSV file. HTML page, should have a Text Area, which will take SQL statement as input, large text upto 5000 char and submit button, upon submit, it will run a .net program to run the input SQL on the Oracle database and save the results a a CSV/excel file. Purpose of running the SQL query: - I need to perform data analysis on the Oracle database. SQL query: - I already have the SQL query ready, so no assistance is needed in creating it. Ideal skills and experience: - Strong knowledge of IIS (Internet Information Services) to set up the web page. - asp.net or .net C# or similar experiance - Experience in web de...
...reset the step count every midnight and re-measure it. - Even if the app is not turned on, the number of steps can be initialized at midnight and counted from the beginning. - Even if you do not use the app for a long time (eg, 7 days), you can reset the number of steps at midnight and start counting from the beginning. - You can check the number of steps stored in the device through a query. - Last 7 days, 30 days, etc. - Even if the app is not running after the device is turned on from the off state, the step count notification can be run in the notification. - Even if you delete and reinstall the app, you can manage the number of steps for that day without losing them. - Even if you delete and reinstall the app, you can manage the step count data for the past da...
I need the macro to do this: -- Trigger -> Screen Content (use regex to get text) -- Actions -> Read screen content and save to dictionary -> Set variable with ride value -> Set boarding and trip mileage variables -> Set variable with ride value divided by total mileage -> Display pop- up with the result of how much I will earn per km run in that race -> Take screenshot. Macro has to work by reading the screen content in all situations, when the Uber Driver app is open in the foreground and with the popup. You can use the attached , you just have to adjust them for the euro and respective values ​​per km and time per minutes This macro is for Uber Driver app for Portugal. I send some example configs but that works in Brazil with the local cur...
I am looking for a freelancer to create a screener website for me. The backend is already in place with data stored in SQL and Python will be used for querying. Purpose of the website: - Displaying information - Filtering and sorting data Design and layout: - I have a specific design in mind for the website interface Important features/functions: - Interactive elements such as forms or surveys Ideal skills and experience: - Proficiency in frontend development - Experience with SQL and Python - Ability to create a visually appealing and user-friendly interface
I am looking for a freelancer who can help me set up automated emails from HubSpot based on incoming emails. Skills and Experience: - Proficiency in HubSpot and email automation - Experience with Gmail and integrating it with HubSpot - Strong understanding of customer query responses and how to automate them - Ability to set up 1-3 different types of automated emails Project Details: - I currently use Gmail as my email platform - I would like to automate responses to customer queries - I need to set up 1-3 different types of automated emails If you have the necessary skills and experience, please reach out to discuss the project further.
I need help with a math project involving cricket team analysis. I have 22 players labeled P1 to P22. From these, I need to pick 11 players for a cricket team. I have a sheet named "TEAM A...interpret the results later. In essence, I'm looking for a more efficient way to analyze the matching players between possible combinations and user teams, while also understanding the popularity of specific combination sets and their player count ranges. I'd greatly appreciate assistance in setting up a dynamic analysis sheet with formulas and explanations. I prefer to use - Excel - may be power query, or any other method. We can supply data in excel, csv. I am open for any other Free /open source tool including BI Tools, PHP/ Python program as well. Let me share your pro...