Vbscript change excel pivot table data source jobs
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...
I need an age verification popup for my website that is displayed upon entry to any page. Key requirements: - Ability to change validation type (e.g. Over/Under 18; Date-of-birth, Year-of-birth) - see images - Ability to change images, text, background and redirection address (for Under 18) - To remember age verification forever (for Over 18s) and this session for Under 18s I already have a mock up design and imagery files available. The website is hosted by Neto e-Commerce and I have full access to all files.
The Soul Barn logo existing logo to be adapted Please read* 1. I would like to keep the barn out line. 2. Keep the words ‘The Soul Barn’ but change the font to something a bit more interesting 3. Add the word Noosa (remove Noosa Hills) 4. Add ‘Animal Assisted Therapy’ under the barn in smaller font 5. Change the background colour to one provided 6. Open to a creative flair on font I'm searching for a talented graphic designer to help breathe new life into my company's logo. I am currently not satisfied with the existing design and want to focus on modifying the color scheme and typography, with a possible addition of few words. Key components of the project include: • Transitioning the color scheme to earth neutral tones from its...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportuni...opportunities; * Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer o...Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Create min 3 queries using...
...consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous wo...
...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...
...expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's ...
I'm looking for a skilled Python developer with experience in GPU programming using CUDA to assist in a project that involves image processing and data analysis. - I have a python code and I need to modify it to work with GPU the code takes an image changes its pixels one by one and each pixel change calculates new image hashes if images hash satisfies some specs it save image and code ends. this is whole python code is doing now. it is a 40 lines code. very simple for someone who knows how to code on cuda.
...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. *...
...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 – 200 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 automati...
I'm looking for a seasoned VPS server expert who can help in fixing an issue regarding firewall ports. After the VPS company automatically migrated the server, the websites on it stopped working. They have said, it might be due to a change in settings or policies, So it looks like a 15 min job to do. All our projects are in Laravel that are there on the server. So please do the relevant settings and make it work. This task needs to be done on any desk and budget for this is Rs.500
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight meas...for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of sto...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...
I need an experienced animator to make some small edits to a short animation. The changes required include: - Change to our existing logo and branding - Alternations to a small part of the explanation
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I'm looking for an experienced Solution Architect to help me with a digital transformation project. The main goal of this project is to undergo a significant change to modernize and improve our current IT infrastructure and processes. Key requirements for this solution include: - Scalability: The solution must be able to scale with the growth of our business and handle increased workloads without compromising performance. - Reliability: We need a dependable infrastructure that ensures minimal downtime and data loss. - Cost-effectiveness: The solution should be efficient in terms of both initial cost and long-term maintenance. I'm particularly interested in leveraging Cloud-based solutions such as AWS, Azure, and GCP for this project. Ideal candidates should have a...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...
I am looking for someone who is extremely quick at designing and putting twists on the photos I share with you while keeping them within the same aesthetic. Please mimic the images I’ve posted here and change them ever slightly. Product design is what we're looking for, anyone who is quick to design in Canva or photoshop. Canva is a must though as this is where we keep all of our designs. Please take a look at our site We use printify to upload designs, please look we have bags, tumblers, blankets, wallets and we stay within those categoies with new designs... the summer is coming for the USA so we can do a Faith Beach collection. Please see some examples of bags below. Pay attention to colors, these colors sell, dont be afraid to use the exact colors from the
...Raspberry Pi 5. I have the camera working perfectly fine on my DELL computer. However, I'm unable to use the camera with my Raspberry Pi 5. This is what I've done so far. 1. I first installed the pip3 and Python 3 Virtual Environment by running. - sudo apt install -y python3-pip python3-virtualenv 2. I then created and activated the Virtual Environment by running. - python3 -m venv projectsenv - source projectsenv/bin/activate 3. Then I installed opencv while inside the virtual environment - pip3 install opencv-contrib-python 4. After that I installed the depthai dependencies for Linux (still in the environment) - sudo wget -qO- | bash 5. Then I installed depthai (still in the environment) - python3 -m pip install depthai 6. Then I cloned the
I am looking for someone to change logo and add score on the following template: Just want someone to complete same in 5-6 hours as morning we have an event.
...extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The credentials will...
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...
I'm in need of an interior designer with experience in modern design aesthetics who can completely transform my living room and dining area. My preference is for a neutral color scheme with whites, grays and browns being the prominent tones. Key Elements include: - A medium sized and mpressive dining table, as I often entertain guests - A comfortable seating area that promotes relaxation, chats, and comfort. - Media Wall - Maximization of natural lighting - an aesthetic that capitalizes on light will be highly favored - Incorporation of features like a console, mirrors, wall art, center rugs, a media wall, and sofas with accent that combine style and utility. Special Attention should be paid to: - Nice, lush curtains that complement the modern aesthetic and enhance the spa...
When button clicked, the field of another table will changed to required. Only FTP no cpanel
I have the source code for an open source tool that I need help compiling. It's crucial that the compiled tool is compatible with macOS. Additionally, I have a patch that needs to be applied. I would require concise documentation that outlines the key steps to apply the patch and compile the tool. Expertise in C, open source tools, compiling, and patch application is essential. The ability to provide clear and concise documentation is also a must.
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
...similar to the included "reference ". Please also notice the "reference " which contains a mockup of the top part of the website and the color scheme. The top menu contains links within the same page (anchors), so only one page, no sub pages. Notice that the hero area is a photo carousel consisting of multiple photo. The carousel must change the picture automatically every 3 seconds, but also have controls to change the picture with clicking. The photos to be used on the website are attached. Also the text to be used on the page is included. The implementation must work with any browser size, including mobile devices. The implementation must work with Chrome based browsers but also with latest Firefox browser. At the bottom of the page, there shall ...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
...in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel docu...
I am in need of an experienced iOS/Android developer with website development knowledge to create an in...are parents and the main purpose of the platform is to provide attendance notifications Key Requirements: - The platform needs to cater to both app and website users, with user accounts and profiles enabled on both. - Ease of use and parents-friendly interface is crucial to make the platform engaging and accessible to its target audience. Note: I already have the website. probably needs a small change for the push notification Ideal Skills: - Proficiency in iOS and Android app development - Strong understanding of website development - Experience in creating user accounts and profiles on both apps and websites - Familiarity with designing platforms for students or educational...
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
...website is: everytime a user reloads or opens the page users sees new person data from the database. A sample of the database with 5 examples is provided in the json format. We plan to have 1000 entries in this json at least. The database includes: Photo (each person will have at least one phone), name, birthday, occupation, transaction table, ... (please see the json file). Animations: when a user scrolls down new information block appears. Layout: The page should start with a photo of the person and a name on the left. See the attached file. In the middle of the page should be a table with trasactions, use a component from react here (or other possible framework): DData for the table comes from the json file. Please add in the bottom after all informatio...
I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
...tasks for my project. Although I chose to skip specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the web services to connect the DB to our mobile app. Techn...
I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.
I have a websit...adjusting the layout and design to suit various screen sizes, ensuring the website looks great and functions well on all devices. - The homepage needs some tweaking in terms of text and picture layout. The aim is to ensure everything is evenly spaced and aligned, fixing any width issues that may be present. - On the SHOP page, the category section on the left needs to be turned off. - Also change all fonts across the site to match the one used on the homepage. - Finally, I'd like to double check all the settings and make the webshop ready to go live. I am looking for a web designer with experience in responsive design and layout, as well as a good understanding of font usage. The ideal candidate should be able to work efficiently and effectively to make...
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
Only FTP will be provided. Link 1 column with another table. and amend existing API only
I'm looking for a talented designer to create a comprehensive brand guidelines document for my real estate company. The primary goal of this project is to ensure consistency in our brand representation across all platforms. Key Deliverables: - A detailed brand guidelines document: This document will serve as a blueprint for our brand identity to be shared with partners, ensuring that ...guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate brand values into visual elements - Experience working in the real estate industry would be a plus, but not a necessity. The successful candidate will play a key role in shaping how our brand is perceived in the market, and I'm excited to see what you can bring ...
I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.
...us in creating custom email signatures for 10 users. The design aspect is extremely important to us, so we are looking for someone with a good eye for design and creativity. Key Deliverables: - Custom email signatures with visually appealing design. - Each signature should include a personal V-card (QR contact card) for the user. - Incorporation of rotating banners which we can schedule, change easily, link, and deploy across all users. - An active countdown clock feature within the signature. - Compatibility with Microsoft Outlook, our primary email client. Additional Requirements: - While not essential, the ability to track interactions (clicks) on the email signature elements would be a nice to have. Ideal Skills and Experience: - Strong graphic design skills w...
I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.
We're looking for a talented Wordpress expert skilled in Avada theme for a set of simple layout modifications and fixes to our website. Specific tasks are: -Fix the mobile menu. Currently it is showing the default theme menu items. Change this so that it reflects the desktop menu links we have created, and make sure it is not shown when on the desktop site. -The testimonials section on the home page (mobile and desktop) is not displaying properly. Check and fix -Stop the rollover effect on the career sector, so that on rollover nothing changes. -Point the website contact form to the email address info@domain. set it up and test that it works throughout the site. -Disable the pop-up that appears on the home page when you scroll down. -Poin...
I'm looking for a detail-oriented researcher to help me gather information on EU and UK investment figures. Requirements: (1.) The no. of people (and total and average volumes (in EUR)) making personal investments... your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be ref...
