Excel macro vba odbc querytableemplois

I'm in need of an expert who can effectively integrate Interactive Brokers Excel API for streaming real-time options data. I need only 2 types of data 1 stocks last price 2 open interest of every option price

I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp⁡((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible wi...

I need an Excel wizard to refine my availability calendar. The Calendar is Google Sheets-derived and ought to be fairly straightforward for a skilled Excel user. The tasks include: 1. Date Formatting: Revise the date format from its current mm/dd/yyyy to dd/mm/yy. Your expertise in Excel functions and formulae will be key to achieving this seamlessly. 2. Color Coding: Reconfigure the colour of booking designations based on the occupant. I want a color-coding system involving red, blue, green, pale blue and purple. Your keen eye for design and detail, as well as your understanding of conditional formatting, will enable you to implement this effectively. This engagement requires proficiency in MS Excel and Google Sheets. Familiarity with conditional formatting ...

...below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I look forward to reading your detailed proposals!...

I need an excel system for One Drive that will enable me to effectively monitor my business' trash expenses. The following features should be included: - Data entry for each individual bill spent on trash. I'll manually enter the amount spent on each bill. - Calculation of total trash expenses over a given period. - Monthly reporting of trash expenses, to aid financial planning and cost analysis. Having experience in Excel, formulas, complex calculations and reporting will be handy for this project. If you're familiar with One Drive, that's even better. Perfect for someone who is detail-oriented, precise, and efficient.

I am in need of a skilled freelancer to carry out web scraping in a professional and timely manner. The ideal candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. ...candidate will have significant experience in the field of data mining and extraction. Your task will be to scrape text content, images, and product information from specified websites. Please ensure you highlight your experience in your application. Upon completion, I'll need the scraped data to be organized and delivered in an Excel Spreadsheet format for ease of analysis. Key Skills: - Web scraping - Data mining - Data extraction - Proficiency in Excel, for the clea...

Join our team as a Telemarketer and earn commission-based pay for your hard work! We do not require any upfront payment from our employees - all compensation is provided after the completion of tasks. If you are motivated, results-driven, and ready to excel in a dynamic sales environment, we want to hear from you. Contact us today to learn more about this exciting opportunity!

More details: What is the purpose of the Excel sheet data typing project? Data entry What type of data will be entered into the Excel sheet? Both numerical and textual data What is the source of this data? Manual entry

I'm looking for a professional experienced in Power Automate Desktop to autom...looking for a professional experienced in Power Automate Desktop to automate a task I regularly deal with. The task involves extracting specific 'pricing details' from multiple webpages, and subsequently transferring this data into an Excel file. Skills and Experience: - Proficiency in Power Automate Desktop - Expertise in web data extraction and management - Knowledge of Excel data handling Please note that the automation must be able to cover multiple pricing details - whether they are listed singularly or in package form, and accurately convey them into the Excel file. Prior experience with this type of automation is a plus. The successful candidate will have the capaci...

Veuillez vous inscrire ou vous connecter pour voir les détails.

I need a professional to extract emails, phone numbers, and usernames from Instagram users' followers. These data are crucial to launching my marketing campaign. After the completion of extraction, I want the data to be delivered in an excel spreadsheet. Skills in Instagram API and data mining will come handy and are thus ideal for this job. An experience in extracting big data sets from social platforms will also be advantageous.

I need an expert with a strong background in Python to extract specific data from a PDF file. You'll need to accurately shift this data to a structured CSV or Excel spreadsheet. Key Responsibilities: - Browse a folder containing PDF files - Extract text-based information from the source files - Extract each line item and append it to the existing list if not add to the list - Focus on retrieving numeric data and dates specifically - Ensure the dates are formatted as 'DD/MM/YYYY' - Generate a log of processed files and errors if any Skills & Experience: - Python programming - Data extraction, wrangling, and analysis - Previous work with PDF data extraction strongly preferred - Attention to detail is vital, to ensure accurate data extraction - Understanding of d...

I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given th...

I'm in dire need of a proficient professional with strong skills in Microsoft Excel, particularly with linking and integrating data across spreadsheets. The focus is on nutritional data, specifically numerical data. Key Project Requirements: - Experience in managing numerical data in Excel - Ability to flawlessly link different Excel sheets for seamless data retrieval - Hands-on ability to import nutritional data from a database to an Excel sheet - Strong attention to detail to ensure accuracy and consistency of imported numbers Your efforts will greatly simplify my day-to-day management of nutritional data. An understanding of nutritional data or related fields will be a strong advantage, though is not entirely necessary. Speed and accuracy are of utmos...

...File types: To include: pdf, ms word, Excel, CSV, text, XML, JSON User acceptance: To be able to query openAI about the file and get responses that relate exclusively to the reference file. Code: Native JavaScript. Can use external libraries. Should run on any server without installing plugins. Specifications: - The file constitutes mixed data, encompassing both numerical and textual information. - The system should seamlessly interact with the entirety of the file. - The primary task involves integrating the API to fetch data from the stored file, read and analyse it as required, and send appropriate responses. Ideal Skills & Experience: - Robust knowledge about APIs, specifically in relation to Excel integration. - Experience in handling Excel files wit...

I am in need of a unique yet straightforward website, primarily dedicated to sharing an event calendar and notes from various day trips. I would like it to be easy to update. Right now I have excel tables. Want easy to share and update (no public update). Can share what I have now. Want the ability to add a few links to other sites, to add a small number of pages or a subsite in case I start a small side gig - for example an airport shuttle service Key Features Required: Event Calendar: - The ability for me to add events, complete with crucial details like date and time. - Display of these events should be flexible, allowing both a monthly and weekly view. Day Trip Sharing: - Each day trip note needs to be in an individual blog post format. - I would also like an interactiv...

I am in urgent need of a dedicated virtual assistant fluent in data entry for text and numbers into Microsoft Excel. The task at hand will involve: - Populating an Excel database with text and numerical information. - Using five different fields for each entry. An ideal candidate should possess: - Proficiency with Microsoft Excel and an understanding of its usage for data management. - An acute attention to details to ensure data accuracy. - Proficient typing speed for quick data entry. - Data management and administration experience are beneficial. I will provide the sources from where the data is and can be accessed for input into an Excel workbook I have built. See attached workbook. The tabs are broken out by states here in the USA. Please note ...

I need expert guidance and daily minimum 3 hours mentorship for at least 2 weeks to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI appl...

Looking for old Forex Excel files need IT, UK Leads if you have some lists give me the info how many have you got? info must have name, last name, email, phone number bulk needed around 1m per geo if you have it send me small image to see the fields, cost amount

...Conduct a thorough comparison between ITA GAAP and Romanian GAAP to identify key differences affecting financial reporting. Excel Spreadsheet Design: Develop a structured Excel workbook that includes: Separate sheets for the original financial statements of both companies. A detailed analysis of the differences between ITA GAAP and Romanian GAAP. A consolidated financial statement sheet with extensive account details according to Italian accounting principles. Financial Statement Reconciliation: Adjust the Romanian company's financial statements to align with Italian accounting standards. Highlight differences and reconcile them in a dedicated column within the Excel workbook. Consolidated Financial Reporting: Aggregate the adjusted financial data into a fin...

I require a highly skilled Power BI professional to automate reports based on customer data currently stored in Excel spreadsheets. Tasks: - Familiarize themselves with the data structure in our Excel spreadsheets. - Use Power BI to automate the reporting of this data. Ideal Skills: - Advanced understanding of Power BI and its functionality, specifically in regards to report automation. - Experience with data analysis, particularly of customer data. - Expertise in Excel, able to work with complex spreadsheets. Your ability to work 'real time' using screen-share technology is essential. This will help ensure a seamless integration of your work into our existing system. Freelancers who have successfully conducted similar projects in the past will be highly r...

I'm in need of a proficient data entry specialist, particularly knowledgeable in Excel. The data to be entered is not just simplistic entries, it involves working with links between spreadsheets and complex formulas. Here's what I require: - Fascinating skills in Excel data entry - Proficiency in creating links between spreadsheets - Ability to handle complex formulas within Excel - Competence in creating both pivot tables and graphs based on entered data This project requires an individual with advanced knowledge in Excel, and strong precision to detail. The ideal freelancer should have excellent organizational skills and previous experience working with similar projects.

I'm seeking seasoned professionals who excel in website development, mobile app creation, and graphic design to bring my multi-faceted e-commerce concept to life. The scope includes: - Crafting an e-commerce website - Developing a corresponding mobile app - Deploying enticing graphic designs I aim to establish a platform for selling products/services, highlighting the necessity of expertise in similar business-oriented projects. Ideal Skills include: - Proficiency in e-commerce website development - Expertise in mobile app development, iOS and Android - Exceptional creative graphic design capability - Excellent understanding of UI/UX principles Proven experience in similar projects will significantly increase the chances of collaboration. Looking forward to innovative, ...

I am looking for a highly experienced Program Management Consultant to take the lead in designing, implementing, and maintaining operational processes for a large company. Key focus will be on rolling out and managing new processes, with a goal of increasing productivity and enhancing project delivery. What I'm looking for: - Proven experience in implementing new processes - Stro...Strong portfolio showcasing successful process improvements - Ability to optimize operations for enhanced productivity Successful freelancers should include examples of relevant past work in their applications. The ideal candidate can demonstrate past success in streamlining operations and effectively managing new process rollouts. Your proposal should clearly show your ability to take on and excel...

I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.

...company's B2B program as Excel and XML within a certain period of time. The B2B program installed on my computer was installed on my desktop with keys and passwords via remote connection. The information I want from this program; I want a program that can quickly capture the stock code of the product, product description, original number of the product, price of the product, image URL of the product, and stock quantities of the product in which warehouses within a certain period of time. After making this program, it should automatically upload this data to my own website, which I purchased with a ready-made theme, as soon as possible. I need someone who can integrate and do this. The ready-made themed site I purchased uploads data in bulk with an XML address and Excel...

I need assistance in extracting specific elements from 250 Excel spreadsheet addresses - specifically, the city, state, and ZIP codes. The purpose of this extraction is ultimately to import this data into a specialized software. Ideal Skills: - Strong grasp of Excel - Experience in data extraction and manipulation - Familiarity with data importation process for software applications Deliverables: - Clean and well-organized list of city, state, and ZIP code data extracted from 250 addresses - Recommendations on best practices for importing this data into software.

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

...regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data input - Implementing error-checking measures to ensure data integr...

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

I am in need of a freelancer who is an expert in Excel to assist me with data analysis. The ideal candidate should have advanced skills in Excel and should be proficient in general data analysis techniques. The specific tasks that I require help with include data analysis, formula creation, and formatting and design. The freelancer should also be experienced in working with a variety of data sets. If you have the required skills and experience, please apply for this project.

I'm looking for an Excel expert to create a spreadsheet for me. Here are the key features I want: - Automatic calculations: I need the spreadsheet to automatically calculate sums and percentages. Prior experience in creating automatic calculations in Excel is important. - Graphs: I would like the spreadsheet to include bar graphs. This will visually display the data in digital format, so freelancers with skills in creating and managing graphs in Excel would be ideal. The final deliverable should be a user-friendly Excel spreadsheet that meets the above requirements. As such, attention to detail, proficiency in Excel, and a knack for visually representing data are all necessary skills for this job. I want to make an Excel that allows me t...

...Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 2,500 website pages, and then make sure the data is correct in the excel spreadsheet (or csv). Please share what tool you will use and if there is any additional cost to us for usin...

I require a proficient assistant with expertise in data entry, Excel, Word and Adobe Photoshop. The tasks involve: - Data Entry: Handling data entry tasks, few in number (fewer than 50 entries), which includes handling mixed data i.e. numeric as well as textual data. - Excel and Word: Manipulating and analyzing said worked data using Excel functions and creating detailed reports or documentation using MS Word. - Photoshop: Require basic graphic editing skills in Adobe Photoshop. Ideal skills for the job would be attention to detail, good command over Microsoft Excel and Word functionalities, and fundamental Photoshop skills. Past experience in data entry and graphic design would be highly appreciated.

I have 8 lines of attached php code working fine and operational. I need help to convert it into MS Access VBA

I need someone to convert 20 PDF files into Excel spreadsheet format. Secondly, once converted to Excel format, I need a slightly new design (colour scheme) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert

I require a dependable and sharp personal assistant with a Bachelor's degree in engineering, possessing profound knowledge and fluency in English. This role involves a monthly salary of 500 USD and demands a high level of availability and smart handling of various tasks that are crucial to my personal and business needs. The assistant I'm looking for should excel in: - Managing my emails and setting appointments efficiently - Undertaking research-oriented tasks alongside adept data management - Facilitating the tasks with ChatGPT for diverse purposes - Seamlessly handling Airbnb business-related tasks including managing reservations, bookings, and ensuring guest satisfaction - Coordinating with housekeeping services ensuring the property is well-maintained, alongside regu...

I require a freelancer to create a dynamic bar chart that represents the changes in my agricultural product'...project involve: - Understanding the bar chart should reflect the comparison of yearly production versus previous years. - Displaying the data dynamically to show changes on a yearly basis. - Importing data from a spreadsheet format to be presented in the chart. The ideal candidate for this project should have robust experience in data visualization and analysis, with proficiency in tools such as Excel and data visualization software like Tableau or PowerBI. They need to practice attention to detail and have the ability to interpret and represent complex data in an easy-to-understand and aesthetic graph. Familiarity with agricultural data or past work in similar proj...

...are updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. 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 175 INR and Good review, Dont expect more I am not big fish. it is diff...

As a manufacturing business, we are in urgent need of an Excel expert who can efficiently create a comprehensive daily production report. This report will play a crucial role in tracking and informing us on: - The quantities produced each day - The quantities produced processed through different process - Purchase quantities from Outside - Monitoring dispatch - The respective production time for each product - Any machine downtime that occurs Each of these factors are vital elements to monitor in our production process. In addition to a total quantity count, we're also interested in having a breakdown of quantities produced, batch-wise. Ideal candidate should: - Have excellent skills in Excel, particularly in advanced functions and data visualization - Be able to ...

More details: What type of data do you need to enter? Text data What is the source of your text data? Digital files What type of digital files are the data in? Excel spreadsheets

In need of a professional to design and implement a Power Automate flow for auto-generating and sending reminder statements to my firm's clients, based on the information provided via ...to that email. If there is no email in this column, it should then use the Matter Email. I believe this would be possible with an Expression? My other note is when the flow has gathered all the attachments for one Matter No., if I insert dynamic content ‘Matter Email’, does it know just to pick the email address from any of the Excel rows for that matter (which should be the same)? 7. Once the email is sent, I want it to populate the respective column in the Excel spreadsheet with a date that the email was sent. For example, the 45 day flow should populate ‘Sent 45&rsq...

I'm on the hunt for someone adept in social media advertising, influencer marketing, and email marketing. Your task will be to effectively promote my digital marketing product to entrepreneurs and regular day people who want to make passive income with digital marketing. My product boasts the key benefit of increased website traffic. To excel at this job, you'll need outstanding skills in digital marketing channels, an understanding of the specific target audience, and a knack for persuasive selling. A successful sale of the $497 course means a 20% commission for you. Let's step up the digital marketing game together.

Adaptar planilha existente para melhor eficiência e design mais bonito para apresentação. a planilha deve atender mulheres executivas que buscam conhecer suas despesas, e alcançar a sua independência financeira para futura aposentadoria ou independência financeira do marido. levando em consideração seus investimentos, inflação e media de rentabilidade de seus investimentos.

I need professional guidance on creating custom modules on ...Specifically, I need a tutorial tailored towards the Data Analytics and CRM sections of the software. The custom module should incorporate the following functionalities: - Data visualization - Customer segmentation - Contact communication history For seamless operation, the module should be able to integrate data from the following sources: - ERPNext platform's database - External APIs - CSV/Excel files The ideal freelancer for this task should have a robust understanding of ERPNext software and have experience in module customization. Data analytics and CRM specialization as well as proficiency in integrating diverse data sources will be a significant asset. The ability to clearly explain and instruct on the proc...

looking for java script expert for the JavaScript Macro Development to sheet automation the task is - - Writing a JavaScript macro to duplicate the last visible sheet within a file and providing it with a new name as a part of an automated procedure. - Once duplicated and renamed, the new sheet should be moved to a specific location inside the file. - Modifying the contents of the copied sheet as necessary. - Implementing a notification function once the procedure is completed successfully. - Adding protection to specific cells within the sheet. more detail on chat

I am looking for a freelancer who can assist me with the following tasks: Data entry in Excel: - I need help with entering data into Excel spreadsheets. - The freelancer should be proficient in Excel and have experience with data entry tasks. - Accuracy and attention to detail are crucial for this task. Autocad 2d: - I also require assistance with 2D drawings in Autocad. - The freelancer should be skilled in Autocad 2D and have experience with creating accurate and detailed drawings. - Knowledge of architectural or engineering drawings is preferred. Autocad 3d: - Additionally, I need help with 3D modeling in Autocad. - The freelancer should be proficient in Autocad 3D and have experience with creating realistic and detailed 3D models. - Knowledge of architectural or...

Hi Gupta I have a PDF which I would like converting to Excel please. The volume is 6 pages, printed 2 pages wide (there are 18 columns) it is 3 pages long. Please confirm availability and time needed to complete. Regards

I'm in need of a proficient Excel expert who can develop a dashboard for courier pricing data. The focus of this project is to allow analysis and comparison amongst different courier companies to determine the most cost-effective options based on weight categories. The desired end product should function as a calculator and feature: - Comparison of pricing between various courier agencies to identify the most economical options - Filter and sorting capabilities based on weight categories Based on these needs, the ideal candidate should have extensive experience with Excel, particularly in creating interactive and functional dashboards, and be able to work within the deadline of March 26th. You should also be knowledgeable in data analysis to capture significant insight...

I'm seeking an experienced Excel developer to bring organization to my data. The main focus of this project will be to create a structure within Excel that will allow for simple and intuitive navigation. Key responsibilities: - Create an organized structure for a large amount of data - Build an easy-to-use system for future data entry Ideal skill set: - Sound understanding of Excel capabilities - Proven experience in organizing and structuring data within Excel - Detail-oriented and highly organized To apply, please provide: - Evidence of past projects similar in nature - A detailed proposal on how you plan to tackle this task. Your main goal will be to create a system in Excel that allows for efficient and organized handling of data. Looking ...