Update data source pivot excel vb script jobs

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...

...create a Roblox script for my new simulation game. Key Requirements: - The script should primarily focus on implementing engaging game mechanics for a simulation genre. - The game is designed for Player versus Environment (PvE) interactions. Ideal Skills & Experience: - Prior experience with Roblox game development is essential. - Proficiency in Lua, the scripting language used in Roblox. - Understanding of game mechanics for simulation genre. - Experience with Player versus Environment (PvE) gameplay. I'm looking for someone who can deliver a script that not only meets these requirements but can also bring innovative ideas to enhance the gameplay experience. Looking for someone to make me an Updated and improved Miners Haven Script on roblo...

I need a script that can bypass security measures on my website which uses Cloudflare. This is not for any malicious intent, but for testing and troubleshooting purposes. Key Points: - The script should be specifically designed for websites - The main purpose is to bypass Cloudflare security measures - I didn't specify the customization level, as I'm open to options that might suit my needs better Ideal Skills: - Familiarity with Cloudflare security measures and how to bypass them - Ability to create a script that can seamlessly integrate with any website - Experience working with security testing tools or scripts Please provide a proposal that outlines your experience in this area and how you plan to approach this particular project.

Hey Mate, got a job for you. Please see attached sheet. Need to report on data sheet, data will be updated month to month. Not sure if this can be done with pivot table? but I'm not familiar with dealing with time calculations. Tab 1 Data table 1 + summary by driver: Average Total time (F) by driver (B). Tab 2 Data table 2 + summary by Sub function code: Average Total time by Sub Function (C). Need ability to exclude rows where F is blank or greater than 17 hours.

I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.

I'm looking for an experienced Webflow developer to update certain sections of a website. 1. Scroller section with right side image sticky to be created. You may copy and use public webflow templates to acheive this but match colour and font of existing site. 2. Addition of headers and titles in some sections Make sure all work is responsive Please see drive for exact work - Please give exact bid and timeline. Would be great if you can start work now.

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...

This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):

I am urgently seeking an expert in .NET Core technologies, who can be available for a project, starting Wednesday, April 17th, 2024 at 7pm Eastern Standard Time. This project calls for around two hours of dedicated commitment and it's nature will be revealed closer to the event. Although the specific tasks related to .NET Core aren't clarified ...in .NET Core technologies - Capability to implement bug fixes, adopt new features or handle code reviews - Excellent problem-solving skills - Ability to work quickly and accurately under time constraints Past experience in prompt and effective .NET Core based problem-resolution is a plus. Even though the project's main goal has not been identified yet, an ideal applicant should be flexible to pivot the work as per the need. ...

This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):

...number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will b...

I'm looking for a skilled Affinity Publisher designer to create a monthly newspaper for the catering and hospitality sector. Key Requirements: - The newspaper should have a modern and sleek design, appealing to a wide audience. - Your task will be to create a stunning layout, incorporating the latest trends in graphic design. - You should be able to work with a monthly update schedule, ensuring the newspaper is ready for distribution in a timely manner. Ideal Skills: - Strong proficiency in Affinity Publisher, with a strong portfolio of previous newspaper or editorial design. - Ability to understand and match the aesthetic required for an advertising publication. - Excellent communication skills to ensure the publication meets our advertising goals. We will discuss monthly b...

I will explain my project details in the chat

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to...

I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...

...program will ask if the PCR test result is negative or positive and that will decide what type of patient we have and what information we will ask for. 2. Print patient information It will print all the patient information using the toString Method 3. Submit a PCR test result It will ask for the patient id and update the pcr test value for that patient. Any regular patient who gets a positive PCR test should be considered a covid19 patient from that moment. (Hint: copy old object data to the new object) a covid19 patient will be discharged if the PCR test result was negative. 4. Do rounds  It will ask you to enter the current temperature for every Covid19 patient.  It will treat all the patients currently admitted to the hospital and print out each patient’s id and...

I'm seeking a skilled freelancer to create an engaging explainer video regarding my software. The primary purposes are to provide its introduction and explain its key features & benefits to our potential customers on a my given script. The ideal candidate for this project should possess: - Proficiency in animation or any suitable format for explainer videos with audio. - Previous experience in creating software or tech related explainer videos with audio. - Capacity to distill technical and complex software information into a user-friendly and easily digestible format. - Excellent storytelling skills for narrating the software benefits effectively. - Understanding of software marketing and how to appeal potential customers. The successful freelancer would turn my softwa...

I need a custom code component created for my PowerApps Canvas App. Key Requirements: - The component should decrypt static text encrypted with AES or any other simple algorithm Deadline: - I need this project completed ASAP. Ideal Skills and Experience for the Job: - Strong experience with C# programming, Java script or any language that we will use to achieve the goal - Prior experience with creating code components for PowerApps Canvas Apps. - Proficiency in encryption/decryption methods

I have a billboard design that needs a text update. While I do have the original design files, unfortunately, they're not in vector format. Key requirements: - Slight creative adjustment to the text to fit the design: The update will require minor modifications to maintain the overall design aesthetic and message of the billboard. - Non-vector file: As the original files are not in vector format, the freelancers will need to work with the available files and ensure the quality is maintained during the update. - Experience with billboards: Prior experience with billboard designing is preferred as the freelancer would need to understand the specific requirements and limitations of billboard designs. - Graphic design skills: Strong graphic design skills are crucial ...

convert coordinates into url using webscraping python

We're on the lookout for a proficient Wordpress developer to assist with theme customization, plugin installation, and content update tasks. Experience is pivotal as we're not just looking for someone to get the job done but who can also advise us on better practices and improvements. Key tasks include: - Theme Customization: Help us modify our existing theme to better fit our brand and enhance user experience. It's vital that you have a solid grounding in PHP and CSS. - Plugin Installation: Evaluate, install, and set up necessary WordPress plugins that will add to our site's functionality. - Content Updates: Regularly update site content based on the needs of our evolving business. Given the nature of these tasks, we're not just looking for someo...

Adjustments to the Botanical Bliss render as discussed in PM. (adding 2" and adding a 2nd tape line).

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

I need a talented scriptwriter and PowerPoint designer to create a persuasive presentation for my F1 in Schools team. This presentation should: - Highlight our project's k...engineering skills, design abilities, strategic planning, and our efforts in marketing and securing sponsorships. - Effectively showcase our project to impress judges and potential sponsors. Given the urgency, someone available to complete the task ASAP would be ideal. Skills and experience required: - Proficiency in script writing, particularly in creating persuasive narratives. - Expert knowledge in PowerPoint, including the ability to visually represent information and data effectively. - Experience in creating presentations aimed at persuasion and promotion. - Quick turnaround time without co...

Update android app to be supported android TV

I am looking for a skilled developer to create a Window...skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Se...

Hi Soumya Sekhar M.,can you provide me a support to update the faker app with a new

I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the system is currently not allowing the addition or update of database records, although deletion is possible. Key requirements and responsibilities: - The main issue is resolving the problem of not being able to add or update database records. - There are no error messages displayed, so a deep understanding of PHP and MySQL is needed to identify and solve the root problem. - Once the issue is resolved, the next step would be to optimize the application to prevent similar issues in the future. Ideal skills: - Proficient in PHP and MySQL - Experience in working with and debugg...

Looking for someone to help update my linkedin profile

I'm in need of legal research focusing on probate, trusts and trust administration within Colorado, to support a forthcoming filing. The research will require identification of the relevant probate laws and legal codes in Colorado, specifically in the area of some specific aspects I will share in private. This summary should encompass the most current laws - so an update on recent changes in laws is important. The goal is to provide me with supportive applicable laws to my filing Ideal candidates for this project should be well-versed in probate law, specifically related to trust administration. A background in legal research and a familiarity with the Colorado legal system will be highly advantageous. Accuracy, attention to detail, and the ability to convey complex legal i...

...sort the data in ascending or descending order based on specific columns. - **Filtering**: Users should be able to filter the data based on specific criteria to find the information they need efficiently. - **Pagination**: The grid should support pagination, allowing users to navigate through the data in chunks. The data for the grid will be provided through an existing API, so the successful candidate will need to have a solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edit data directly in the grid**: The grid shou...

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within E...

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I'm looking for a skilled graphic designer to help me update my current logo. The task involves incorporating an abstract style 'X' letter behind the existing logo. Add X to my logo, on a white, black and blue background. Provide files as requested in the attached document for various uses marketing, print uses. Key Requirements: - Add the 'X' letter to the current logo as shown in the attachement. - Position the 'X' behind the existing logo Ideal Skills and Experience: - Proficiency in graphic design - Experience in logo modification/embellishment - Strong understanding of abstract design - Ability to blend new elements seamlessly with existing design

I have a magento webstore running on magento 2.3.4. I want to update it to the latest version with all patches, while maintaining current customers/database/products. I also want usps first class mail parcel/usps ground advantage to show up again as a shipping method.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

Please read the job listing below before creating something. I need a logo designer who could give my logo a sleek revamp. It currently contains a truck, which needs to be replaced with a car trailer. Here's what the job entails: - Remove the existing truck element from the logo - Replace it with a single car trailer - Modify the existing text to fit my new business - Update the phone number as required Nicely's Trailer rental LLC 304-673-7378 Do not change to colors, font, or layout. The ideal candidate will have a keen eye for design, experience in typography, and a knack for transforming an idea into a visual. Your ability to work with different colors, layouts and elements will be vital in this project. Understanding my brand and channeling it into the redesi...

I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I need an experienced web developer to adjust text and pictures on my website. - Update Text and Picture: The task involves replacing certain phrases within the existing text so it looks good when hovering over the text/picture of our existing provider. - Picture and Text Placement: I need a new provider's picture and text added to the 'Our Providers' section of the webpage. - Button Links: Additionally, the task includes changing a link so that it opens within the same window as the webpage, rather than a new tab. This will be required across several buttons on different parts of the website. Completion Deadline: This task needs to be completed as soon as possible. Ideal Freelancer: - Proficient in web development and website design. - Ability to work with...

I'm seeking a talented script writer to develop a script for a desktop application focused on content management. Key Points: - The script should be engaging and compelling. It has to be tailored for desktop applications, keeping in mind the medium's characteristics and audience. - The target software is a Content Management System (CMS), hence the script should be easy to understand and navigate for users who are managing content. - The script has to be designed for software, not a movie or a play. This means it needs to be technically detailed and efficient for users. Ideal Skills and Experience: - Prior experience in script writing in the software industry, especially for desktop applications. - Understanding of Content Management S...

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...

...perspective correction script which is currently struggling with shapes that have more than 4 points. I have a Python script that does perspective correction of the images. It works in cases where the shape has 4 corners. If a shape has more than 4 corners, the script will not work. Please see attached and The script obviously fails on the "L" shapes. The has the expected result simulated. Attached is a zipped folder with everything you need to start. To run a script, use this command {filename} Example The "source" folder has various source images that have working and non-working cases. I need a solution that will work in most "non-working" cases. This script also has a function that

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

...specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Googl...

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

I'm looking for a skilled web developer to revamp my current website, which is built on WordPress an...Incorporate fields for first about 8 fields. - File upload capability: Users should be able to upload documents, images, and videos Skills and Experience: - Proficiency in WordPress and Elementor - Strong knowledge of web design and user interface principles - Experience in implementing user registration and form functions - Familiarity with secure data handling and processing Would like custom script work so I"m not paying monthly/annual script fees. This project would suit a developer with a strong background in web design, user registration, and file upload capabilities, who can deliver a secure and user-friendly solution that also include good seo skil...