Calcular kpi vba jobs
I need a Freelancer who is highly skilled in excel, VBA macros and web scraping and has good knowledge of soccer fixtures. My project requires collecting data from oddsportal betting site and then distribute the data into an excel table. The data will include the next soccer matches with multiple markets for the current day and all future days including the betting odds in decimals. One macro for the current day another macro for the current day and future days. A toggle button to refresh the current day periodically and a second toggle button to refresh the current day and future days periodically. I would like a message box to confirm the time taken to complete the single refresh and an option to set the time to refresh periodically. I can send a layout of the table on request.
Job Description: *** NO VBA CODE > I DO NOT WANT MACRO ENABLED WORKSHEETS! *** I need an EXCEL file with a config tab to allow me to change the date ranges to pull the following links in the attached file from Fangraphs.com. I have included all the links that I need. It's not a simple "Query > From Web" and paste in the URL as that doesn't pull all the players. I need someone that is a very advanced excel expert and can create the connections to pull ALL PLAYERS (Most links have 250-400 players) and display them in excel. I need to be able to change the dates and then hit a REFRESH ALL and let it run and load the links. Please quote your PRICE, TIMELINE & PROVIDE a sample file using 1 of the links so I can ensure you know how to do this project. You ...
*** NO VBA CODE > I DO NOT WANT MACRO ENABLED WORKSHEETS! *** I need an EXCEL file with a config tab to allow me to change the date ranges to pull the following links in the attached file from Fangraphs.com. I have included all the links that I need. It's not a simple "Query > From Web" and paste in the URL as that doesn't pull all the players. I need someone that is a very advanced excel expert and can create the connections to pull ALL PLAYERS (Most links have 250-400 players) and display them in excel. I need to be able to change the dates and then hit a REFRESH ALL and let it run and load the links. Please quote your PRICE, TIMELINE & PROVIDE a sample file using 1 of the links so I can ensure you know how to do this project. You can use one ...
Your task is to implement VBA code into the attached pptm document so that the user can generate a thumbnails page based on information on a template slide and slides in the same document that have titles corresponding to the fields on the template slide. Please see the specification pdf and the pptm file.
Hey Lucas! Hope you're doing well. I need your help with creating a YouTube thumbnail for my upcoming video "ChatGPT: Automating Excel with VBA like never before." I've attached a couple of images that I want you to use in the thumbnail (pick one) and also, can you add "Excel" and "VBA" logos as well? For the text in the Thumbnail, please simply just write "ChatGPT" in white font. I trust your creativity so you can play around with the design and color scheme. I need this done by January 21st. Let me know if you're available and we can get started. Thanks!
I currently have a Brother Label Printers with working VBA (using Brother SDK) for printing a label right from Excel. What happens is that the Brother Ptouch software (used to develop a template of the label) prints directly from Excel sheet using a command button (VBA) rather than having to open and link and print the Brother PTouch software. THE REQUIREMENT: I have switched off of the Brother QL label printer and now want to only print to the EPSON ColorWorks 4000 label printer. The software and VBA will need to change. I still need to print from the active worksheet using a macro button. Perhaps there is a solution using the EPSON ESC / Label method?
Need vba macro script to use vlook up formula from to remove duplicates from column e:e f:f....i:i
*** NO VBA CODE > I DO NOT WANT MACRO ENABLED WORKSHEETS! *** I need an EXCEL file with a config tab to allow me to change the date ranges to pull the following links in the attached file from Fangraphs.com. I have included all the links that I need. It's not a simple "Query > From Web" and paste in the URL as that doesn't pull all the players. I need someone that is a very advanced excel expert and can create the connections to pull ALL PLAYERS (Most links have 250-400 players) and display them in excel. I need to be able to change the dates and then hit a REFRESH ALL and let it run and load the links. Please quote your PRICE, TIMELINE & PROVIDE a sample file using 1 of the links. [ USE 1 OF THE LINKS AND CREATE A SAMPLE FILE AND SUBMIT IT AND ...
I need a MySQL DB connected to an Excel sheet using VBA Macros. Inside the Excel sheet I need macros to update certain cells from the DB
In order to manage my stock and sales I need someone to implement VBA on my Google sheet. I made a quick 2min video explaining what i want:
We have a set of ledger names (in thousands). We want you to assign groups to the ledgers based on specific keywords in the ledger names. It may involve something like Regex or other pattern-matching algorithms
I need an experienced "Mac" user with expert knowledge of "VBA" for excel. I only need a few completion fix's on an existing Excell Book. On this book there are 10 different sheets as mentioned below as applicable. I want the two graphs replaced with one pie chart and one bar graph with selectable date range and balance of payments indicator across the sheet. 1: On the Tcode tab where it asks for the new Tcode , I need to have a "text copy" of the full transaction string from the "Data, Tab" that it is referencing. 2: On the "main" tab, I what to list each source file accessed, along with its path i.e. C:/Documents/File. Plus, two question placed on the "Main" sheet. "Postcode" and "Ho...
Hi, I need a freelancer to scrape fixtures from The ideal freelance will have good knowledge of excel, VBA and macros. 1 Create a macro to the scrape the next soccer matches from 2 Button "Scrape Current Date" will scrape for the current day and convert the day to the date format. 3 Button "Scrape Current Date + Future Dates" will scrape for the current day and all future dates. On the William Hill website it will scrape Today, all the other days and Future. On the Ladbrokes website it will scrape Today, Tomorrow and Future and convert to date format.
You will find three files in this Project including , , & Your tasks are 1- Find each employee's Service value in and return it to their Sheet in Payroll file on TOTAL SALES value (E45) 2- Find each employee Backbar value in and...xls and return it to their Sheet on Payroll file on TIP value (E47) Please note in these ExportedData, and Tips files we only have 6 Employees but we will have more employees in the future so your code have to be able to accommodate more name, if in the future these two files will have more name. Their name will always be on B column, however the order of the name wont be always the same. Your VBA code will be written on the Payroll file only. ExportedData, and Tips are only input data files.
Hi there, please prepare two codes in Excel - VBA [no other languages] 1. I will deliver a json file to you, which includes an ENCODING OBJECT prepared by OPENAPI rules . Your code should prepare and save the file (example PDF) from the ENCODING OBJECT. 2. Vice Versa: prepare the ENCODING OBJECT by VBA. documentation: OPENAPI Spezification : You need the following call in your code: "produces: application/pdf" Please only apply to this job if you are familar with this kind of job. Cheers!
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
CREATE A VBA FILE AND MAKE OUTPUT EXCEL BASED ON VALUED FEEDED
We are looking for Sales lead generation for Home loan refinance customers in Australia via social media Facebook and instragram advertising. We are looking for highly experienced top performers only. We want someone who can take 100% ownership and drive ROI independently with least supervision. Meeting minimum Sales KPI every month is must ( 60 booked appointments for home loan refinance per month).
I need a scraper from USA to scrape a site. Because the website I want to scrape is only works in USA. I will share website url to shortlisted candidates and if you can show me screenshot then we can discuss further.
I am trying to analyze data from from a webpage which has a filter and makes webpage adjustments based on my specfic state/selection. However, when I run the regular Excel "import from web" code, the data from another "default" state gets imported. Is there a way to apply the filter which can be applied on the webpage via VBA? webpage: Here the code I am using: name:="Table 0 (2)", Formula:= _ "let" & Chr(13) & "" & Chr(10) & " Source = ((""""))," & Chr(13) & "" & Chr(10) & " Data0 = Source{0}[Data]," & Chr(13) & "" & Chr(10) & " #""Changed Type"" = (Data0,{{""Column1""...
Hi, I am looking for an expert in excel and vba macros to help me automate a report that was created already. More details in private. Thanks!
I have one excel workbbok with 2 sheets " Data" and Unknown Customer" User1 will input the details of customer in Sheet data and put the customer name in Ledger name column. Where the user does not know the customer name he willput it as pending/Unknown. Second sheet Unknoen Customer should fetch all such details from data sheet. As and when the user3 input the data in ledger name colum in unknown customer sheet , it should get auto populate in Data sheet. After usre1 complet his work he will sent email to user 4 for completion with specific details from same sheet.
need a help in formulating in excel sheets, the data which we collected from various websites, as per given formart
need a help in formulating in excel sheets, the data which we collected from various websites, as per given formart
...experience in promoting a personal page of entrepreneur. We will start from Instagram and Twitter and later extend to Linkedin and TikTok. Please attach your portfolio to cover letter. Tasks - writing a promotion strategy, writing a content plan, posting (can be auto posting), collabs and speaking arrangements, editing of short videos(optional), promotion, engaging with potential audience. Work with KPI. Please ONLY submit IF: + You have experience in working with entrepreneurs + You know how to create engaging content and your clients have high engagement rate + You worked with English-speaking market + You know how to use different promotional tools (not only hashtags) + You are ready to dive deep in the personality you work with Long-term partnership. Payment can be ...
Hello, I need a excel vba tool which will post data from a csv file into QuickBooks Online. Basically, it will fill out a form and complete the record with success. More details will be shared with short-listed candidates. Pls bid if you have experience with QB API integration with EXCEL. Thanks.
Have 250 page book that needs a simple index in the back of the book. The index contains about 1100 words. I was wondering if someone can create a VBA script to find the indexed words and then recreate the attached image.
i have a multiple clients that i need to send them Separate invoices using excel VBA , Details will be discussed later.
I get a list of EAN's daily from a supplier, i need a way to use the list of barcodes(EAN and also known as UPC) to find and scrape the missing data for shopify. Data is to be scraped from Google Shopping, if it is not available on there then to be scraped from Amazon UK and if not on there then eBay UK I need this to work properly and fast, i am not looking for a custom app or web based solution, ideally looking for all this to be on excel.
Details and format example in attached xlsx file Sample csv file attached as well
I need for a project to use selenium with vba More details in chat
Cao Ajsa, potrebno mi je, trenutno hitno, jedan VBA Script za Excel a ako uspjesno bude, trebat ce redovno manji Scriptovi. Dali si voljna i u mogucnosti, kratkorocno preuzeti projekat? Pozdrav, Borko
I create monthly financial reports for school district grants. I'm looking to automate the task to ensure accuracy, consistency and save time. Ideally the macro would run on all files in a folder, parse the data, create pivot tables to create charts and produce the report. We have some previous reports that can be used as a template. I'm open to dashboard designs.
Wish to sort and update data from different sources into a unique format within a Microsoft Excel template. I believe it will require VBA as I want to build a program / tool which will automatically take data from one excel template and present in another excel template. This program will need to be used again and again maybe every month as new data is received.
Generation of cost sheet based on requirements of clients using VBA macros(detailed description in attached documents). These documents in turn will be used to generate MIS reports and hence need to be formatted in a similar fashion.
For a newly set up referral business unit, we require a zoho one expert, Initial set up will contain a B2C set up of Leads and Contact module and email automation workflow Also need to have the following integration set up 1) phone app (ring central or any other) 2) Easy KPI reporting 3) Email / Phone validation 4) Would be great if can design emails as well but not a demand There is a larger 2nd phase of this project to discuss based on satisfaction of initial phase
Web scraper web crawler data mining Excel macro Excel VBA selenium
Sorry for my bad English language. I want to add an average line to the charts outbound and inbound and the average line changes according to choices in slicers (Without any VBA code). The average line must be straight line and it equal total of the percentage all flights filtered by slicers divide by number of flights. There's a picture explain what I mean and EXEL file. Note: I developed this report through one of the programming languages ​​.. and I can add the average line to the report chart based on the total number of rows of the table .. but this is not what I want .. I want to add the average line that represents percentages according to the chosen filter from slicers only not all rows of the entire table .. Please make sure that you are able to solve this problem b...
i want someone to do for me 2048 game and show how it works via excel on VBA
I need someone who is very good in MS- Excel, VBA and power BI. It is small project that could help a teacher for grading system. Message me only if you know what you are doing. Thank you
...are responsible for professionally growing the Pinterest board based upon CONVERSIONS and Followers. I seek: 1. very professional pins that go beyond the typical Canva type 2. Deep understanding of 2022 and 2023 Pinterest practices 3. Deep awareness of Pinterest Best Practices (you will be tested) 4. Proof of Pinterest boards you have designed and actively managed. Goals - 3 to 5 pins a week - KPI (Key Performance Indicators) - -- Number of Saves -- Number of Shares -- Number of conversions (Go to website) -- Number of comments Board Thoughts - No more than 50 pins per board. - Pins should not blend in with each other This is a LONG-TERM project for the right person. When bidding, please provide samples of active pinterest boards in the chat. I seek high numbers of views ...
i need to copy the table from website which is a dynamic in nature , every 5 mins the data has to be populated in excel using macro vba, futher details will be discussed with consultant directly.
I have a excel vba program to track daily walks, and I have entered data for more than 5 years. See () attached. When I do daily entry, it updates another sheet. Look at( waks ) I need to have it modified to obtain 1. Date entry to be included in user form when I enter daily walks 2. customize to include name of the person 3. calories lost based weight 4. make it more colourful. 5 pdf reports 6. calories lost based weight I will share the formula Please note: freelancer can also work on my desktop using remote control software. I will pay on fixed basis. Please provide your sample vba excel program through chat so that i can give my program in the chat . please indicate how much you will charge so that time will not be wasted for both parties( $10-$15, I have offers
Need VBA excel expert who can make user form as system or better like video i have And can answer my questions
Creation and repair of a macro that does the following; data transformation on a one drive network; transforming and moving FTP files for cash reconciliation. Template for macro already exists and is functioning, but we require aspects to be repaired and additional similar macros to be created.