Query excel datasheetmunkák

...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 fi...

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'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.

...I am currently a student in a business school and I am preparing for a makeup session 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 i...

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'm urgently in need of a skilled PostgreSQL coder for query optimization. My project requires immediate attention and must be expedited due to its pressing nature. Key Responsibilities: - Query optimization in PostgreSQL Ideal Candidate: - Has extensive experience in PostgreSQL - Ability to start immediately - Has a deep understanding of query optimization - Prior experience with database performance enhancement Please specify your prior experience with query optimization in PostgreSQL and your availability to start the project.

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...

...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 difficult j...

I have built out an Alteryx web scraping model that mostly works, however, there are some issues, i think it's due to something related to the latitude and longitude requirements of the API perhaps, some cities work and others don't. I am looking to query by city to see which dental services are available in that city. Within the attached model i have provided the list of cities, the website to query, some additional customizations required and some details on the issues. I mostly just want the Download tool configured to pull from all cities, i can cleanup the JSON outputs myself, though feel free to do that :) I would like to scrape the Sunlife Lumino Website.

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 urgently require a proficient and experienced tax consultant to address personal income taxes, focusing on property. Unfortunately, I skipped the previous query about whether I'm after tax planning advice or assistance in filing tax returns, but I'm very open to discussing both services. As this is rather pressing, I need support to begin immediately. Ideal candidates should have: - Vast experience in tax consulting, specifically personal income taxes and property - Exceptional skills in income tax planning and/or assisting with filing of tax returns - Availability to start at once and prioritise this project If you possess these qualifications, please get in touch. Looking to move swift with the right expert.

I urgently require a proficient and experienced tax consultant to address personal income taxes, focusing on property. Unfortunately, I skipped the previous query about whether I'm after tax planning advice or assistance in filing tax returns, but I'm very open to discussing both services. As this is rather pressing, I need support to begin immediately. Ideal candidates should have: - Vast experience in tax consulting, specifically personal income taxes and property - Exceptional skills in income tax planning and/or assisting with filing of tax returns - Availability to start at once and prioritise this project If you possess these qualifications, please get in touch. Looking to move swift with the right expert.

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...

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 ...

I'm seeking a proficient Excel expert capable of creating an efficient lookup file for me. The premise is to compare product names and SKU numbers across a medium-sized dataset, ranging from 101 to 1000 rows. Time efficiency is paramount, as the project needs to be completed ASAP. Ideal bidders will have: - Outstanding proficiency in Excel, particularly in creating and managing lookup files. - Exceptional attention to detail to ensure accuracy in comparing product names and SKU numbers. - Ability to deliver a fast turnaround time as this project needs immediate attention. Thank you in advance for your time and bid.

I need an experienced Excel user to input numeric data into an Excel sheet in tabular form. This project is focused on data entry and does not require any formula or calculation implementation. The ideal candidate should have: - Experience with Excel data entry - Diligence in maintaining data accuracy - Ability to work effectively with numeric data - Typing proficiency to ensure target is met in the given time Please ensure high accuracy, as the data entered will be used internally. The project timeline is flexible and can be discussed further during the hiring process.

More details: Which specific data do you want to extract from your Facebook account? Group name, link, public/no public, number of user For which specific groups do you want to extract data from your Facebook account? I am connect...specific groups do you want to extract data from your Facebook account? I am connected to hundreds of groups, I would like to extract their data What specific data do you want to extract from each group? Group name, Group link, number of member,, public or no public group I am connected to hundreds of groups, I would like to extract their data. I would like to save the extracted data in csv or excel. Group name, group link, number of members in the group, whether the group is public or not - that's all the data I'm interested in from the grou...

As someone with an advanced level of experience in Tableau, I'm on the hunt for equally qualified professionals who can assist me greatly in data visualization tasks. The successful candidate should have: - Expertise in working with large data sets within Tableau - Proficient skills in using Excel or CSV files as data sources - Exceptional ability in portraying complex data in a simple and visually appealing manner. Your top-notch skills in developing insightful visuals are what I require for my project. Join me, if you're all about turning raw data into striking visuals.

I need a specialist to develop and implement an operational dashboard on Tableau. I intend to use Excel spreadsheets as the main data source. Key requirements: - Proven experience in creating interactive dashboards in Tableau - Familiarity with Excel and data interpretation - Experience in representing operational metrics visually Ideal Freelancer: - Strong background in data analysis - Proven experience with Tableau - Understanding of operational KPIs would be advantageous The primary focus for the dashboard will be on operational metrics. This is crucial to the overall success of the project. Your expertise in crafting engaging, insightful visual representations of complex data will be key. I look forward to seeing your previous work and discussing how we can work to...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

I am in need of an SQL wizard, specifically well-versed in MySQL, who can dive into my database schema to rectify some complex queries. ...queries. This will require a profound understanding of JOINs, subqueries, stored procedures, and other advanced SQL concepts. - Performance tuning of SQL queries: Your task is not just to make them work, but optimize these queries. This will include ensuring they run efficiently, making suitable indices, tuning any other aspects of query execution. Necessary skills include: - Strong experience in writing complex SQL Queries - Excellent Knowledge in MySQL query optimization - Proficiency in reading and understanding others code to ensure your queries efficient and readable Anticipating your proactive engagement in discussing database d...

I have a project that requires precise date entry into an Excel sheet. The specifics of the project include: - Typing dates from a digital document into an Excel sheet. - All dates should be inputted strictly using the DD/MM/YYYY format. Ideal Skills/Experience: Candidates with exceptional attention to detail are highly preferable. I am looking for someone who has proficiency in Excel and has a track record of precise typing. Ability to handle digital documents with ease is also a must. Your accuracy and speed will be key for this project. I look forward to receiving your bid if you can meet these requirements!

am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess the...

...and Enrol on Payment. Where a student is enrolled on a course upon payment. We need a similar enrolment plugin to work with the Razorpay payment gateway. Freelancer expertise: Moodle + PHP + Mysql (We are using Mysql for our installations) Main Steps involved : --------------------------------- 1. Make a Moodle Enrolment Plugin to work with the Razorpay gateway. 2. Provide us with a simple SQL query that will dump the details of all the users enrolled via the new plugin (User ID, enrolled course, amount paid, date of enrolment etc.) Relevant example : --------------------------------- This type of work has already been done for other payment gateways like Paytm, and PayU. There is also a plugin for the Razor Payment gateway on GitHub. However, that throws an error. You can u...

I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like something you can handle, apply now and let's work...

I'm in need of a freelancer with solid expertise in Excel, specifically in using mathematical functions. This project revolves around efficiently applying these to enhance data organization in my spreadsheet. Skills and Experience: - Extensive knowledge in Excel mathematical functions - Proven ability to handle complex Excel formulas - Prior experience in tasks requiring detailed data organization - Sharp attention to detail and time management Please be ready to showcase samples of your past related work upon your proposal. Your role is crucial in achieving a structured and organized Excel sheet.

I'm in need of a freelancer with solid expertise in Excel, specifically in using mathematical functions. This project revolves around efficiently applying these to enhance data organization in my spreadsheet. Skills and Experience: - Extensive knowledge in Excel mathematical functions - Proven ability to handle complex Excel formulas - Prior experience in tasks requiring detailed data organization - Sharp attention to detail and time management Please be ready to showcase samples of your past related work upon your proposal. Your role is crucial in achieving a structured and organized Excel sheet.

I need an excel sheet designed with advanced functionalities. Unfortunately, I am unable to pinpoint exact features at this time, but as we progress, we'll identify what specifically is needed. Some functionalities might include a data entry form, automated calculations, and conditional formatting. Ideal Skills: - Intermediate level expertise in Excel. - Ability and creativity to suggest functionalities and features for the sheet. - Knowledge of data entry, formulas, functions and conditional formatting. Please include in your application: - A brief summary of your experience with Excel. - Any similar projects you've worked on, if applicable. - Suggestions for possible features for the sheet, based on your experience.

In need of an SQL/PLSQL developer proficient in writing intermediate SQL queries, specifically JOIN operations and subqueries. The project involves manipulation of numerical/textual data. The ideal candidate should have: - Strong experience in SQL/PLSQL development - Proven track record of writing advanced SQL queries including JOIN operations and subqueries - Excellent understanding of numerical data manipulation - Demonstrated ability to deliver efficiently and accurately This is a short-term project with the potential for future collaborations. Your responsiveness and attention to detail will be appeciated.

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

...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 difficul...

I need help with a set of questions that need to be solved on Excel with a focus on spreadsheet modelling and data table. Ideal Experience and Skills: - Advanced knowledge of Excel including formulas, charts and graphs - Experience in creating spreadsheet models - Expertise in data tables Application Requirement: To ensure best fit for this task, freelancers should include examples of past work specifically dealing with Excel spreadsheet problems and modelling.