**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facilitate collaboration and know...
...specific applications and tracks changes over time. System Administrators will use the script to identify current and historical versions of important software. The script would be executed locally as a scheduled task. Use Cases • User specifies applications for which to monitor version information • User schedules script to run at the desired interval • User analyzes report generated by script using Excel Inputs • The script should take a file with an application name to be tracked on each line • The script should require Administrator privileges Outputs • The script should output a CSV file in the $WINDIRTempSVT folder that contains the software version report • Each line in the software version report should include: o Computer Name o Soft...
I am seeking an expert in data visualization to create a pivot chart that can accurately represent my organization’s financial data. The focus of this pivot chart will be on expense analysis. Key requirements: - Ability to categorize expenses by department, project, and type of expense - Clear knowledge of financial data manipulation - Proficiency in Excel or any similar data visualization tool Ideal Skills: - Strong background in data visualization, particularly pivot charts - Proficiency in financial data interpretation - Detail orientation to ensure all categories of expense are correctly entered and represented This project will help us understand our cost drivers better and make informed budgeting decisions. Freelancers with previous experience in similar projects ...
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
I am looking for a skilled freelancer to assist me in organizing my Excel sheet data. The purpose of this organization is to pave the way for comprehensive statistical analysis. Key Responsibilities: - Organizing data in a user-friendly format - Ensuring that data is accurately inputted and maintained - Setting up the Excel sheet for further statistical analysis Ideal Skills and Experience: - Proficiency in Excel and data entry - Strong organizational skills - Understanding of statistical analysis - Previous experience with data organization for statistical purposes
need an expert in a multi-project task tracking Gant chart multi suppliers provide document control he must be an expert in MS excel and need to provide a solution for tracking ad document control by excel or another software he is an expert in it we can use later
I'm looking for a professional with advanced skills in data mining and excel to extract specific text information from a website into an excel spreadsheet. This job requires an understanding of website data scraping. The successful candidate should have: - Proven experience with Web Scraping. - Expert knowledge in Data mining and Excel. - The ability to handle large sets of information efficiently and effectively. - Accuracy and attention to detail. - Knowledge of and web scraping ethics. The task primarily involves text data mining, here are the specifics: - Extract exact information from a website. - The exact text data to be mined will be communicated to the successful candidate. This opportunity is ideal for someone with a knack for managing large ...
...can! **Data Collection** Data can be collected (legally) from anywhere. You may use data that you already have; or from sites that allow you to download the data, for example, [UCI Machine Learning Repository]() or [Kaggle Datasets](); or via web scraping; or via an API. We can restrict ourselves to data that would fit nicely into a spreadsheet. The content and amount of data are not the main consideration, as long as the data has: - at least 10 variables - three or more data types - two or more problems: missing data, inconsistencies, errors, categorical data that needs to be converted to numeric, entries like text that need to be converted into proper features, etc. - if the data does not have enough problems, you can substitute
I am seeking an experienced Excel expert to create a functional timeline sheet. As the project specifics were not indicated, the freelancer must be capable of handling a wide range of tasks including but not limited to designing tasks description, start and end dates, and task dependencies. The sheet needs to be well-organized, potentially categorized by project phases or team members, or put in chronological order. This can be further discussed as the project progresses. It's crucial that the timeline offers a clearly visible trajectory of tasks, milestones, or a high-level overview of the project timeline. It will be helpful if the freelancer possesses: - Expertise in Excel - Strong attention to detail - Understanding of project management processes - Ability to wo...
I'm in need of a professional who can scrape specific data from a website onto an Excel spreadsheet. The requirement is to list information in a table format. Key Requirements: - Scraping of content descriptions from the website - Transferring the extracted data into an Excel database The data should be organized in a clear and structured manner, following the format I will provide.
I'm in need of an Excel sheet that is set up for data analysis purposes. Key Requirements: - Utilize Pivot Tables: The main goal of the sheet is to leverage Pivot Tables for efficient and effective data analysis. - One-time setup: This is a one-time project, so the sheet will be used for data analysis and won't require regular updates. Ideal Skills: - Proficient in Excel: An expert in Excel who is comfortable working with large data sets and has a deep understanding of Pivot Tables. - Data Analysis Experience: Previous experience with data analysis is a plus, especially with a focus on creating actionable insights. - Attention to Detail: The ability to accurately set up the Excel sheet to ensure data integrity and reliable analysis. I'm lookin...
...specifically email addresses and fax machine numbers, for doctor's offices in Hamilton, Ontario. The desired freelancer will have: - Proven experience in data scraping and data entry. - Ability to independently source from multiple platforms or websites. - Knowledge and capability to deliver the data in an Excel spreadsheet format. Primary Tasks: - Data scraping for email addresses and fax numbers across various sources. - Ensure accurate, complete data entry into the Excel spreadsheet. - Verification of compiled data to ensure its accuracy. This project is ideal for freelancers with a keen attention to detail and a dedication to data accuracy and integrity. If the quality of your submitted work is high then I would love to pay you to complete a ...
I'm looking for a skilled Excel and Adobe professional to automate a series of Excel forms that have varying formats and information, with the data from a single fillable heading. Below are some key details: - Excel Version: The forms are based on different versions of Excel, as I'm not sure which ones to be exact. A freelancer who is proficient in all versions will be ideal. - Application Requirements: Please include detailed project proposals in your application. Experience with similar projects will also be a plus. - Final Documents: I need the final documents in both XLSX and PDF formats. The main goal of this project is to create a fillable heading where client information can be input on one page and have it automatically populate to the other ...
I'm looking for a Microsoft Access professional to work on generating a report concerning my inventory data. Your key tasks will include: - Utilize existing inventory data to create a excel sheet that shows all data required in one place.
I have a daily dataset of the prices and funding fees of cryptocurrencies from Binance. I'm seeking an Excel expert to automate the task of calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a ...
As a part of my marketing campaign, I'm seeking a professional who can meticulously gather the contact information of celebrants in the entire South UK. The final output should be in a convenient Excel spreadsheet format. Key Responsibilities: - Data Mining: Cover all regions in South UK to get a comprehensive list of celebrants. - Accuracy: The data should include celebrants' name, location, phone number, and email address. I want 500 celebrants listed. Please bid to complete this project. Do not message me to have a chat further or look to increase a price posted. This is unfair on the people following my instructions and bidding.
I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.
I need a freelancer with proficiency in data collection and Excel to handle a minor task for me. The project is straightforward, with only 28 rows of data that need to be collected. I'll need the following information included in each row: - 12 columns of data - Each row will contain Text, Dates, Phone numbers, Links, etc. - Other miscellaneous data related to my project requirements that need to be captured. The ideal candidate for this position is skilled in Excel, organized, and pays great attention to detail. Prior experience in data mining will be a huge plus.
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first...
Do you excel in Excel? Are you a pro at product cataloging and social media savvy? We're hiring an E-commerce Operations Specialist! Responsibilities: Data management wizardry in Excel Catalog listing perfection for top-notch quality Media editing mastery for captivating visuals Google sleuthing for competitive price analysis Shopify expertise and social media finesse Requirements: Excel expertise Catalog listing experience Media editing skills Google search proficiency Shopify knowledge Social media savvy Ready to level up your e-commerce career? Apply now!
I'm in need of a detail-oriented data entry operator to transfer data from my handwritten notes into a structured Excel spreadsheet. The critical aspect of the task involves entering data in a date-wise manner. Key Tasks: - Translate data from handwritten notes into digital form - Create a spreadsheet that categorizes data by date Ideal Skills: - Strong attention to detail - Prior experience with Excel data entry - Good understanding of date-based data organization - Ability to read and interpret handwritten notes Your experience with similar tasks will ensure speed and accuracy in this project. Preference will be given to those who can demonstrate previous success in such projects.
I'm in need of someone who can assist me in developing Excel formulas for financial equations, focusing specifically on profit and loss analysis. - You should be an expert in using Excel for financial analysis. - You will need to create tailored formulas to handle profit and loss calculations effectively. - Experience in business finance, particularly in profit and loss statement analysis, is greatly preferred.
I am looking for a reliable virtual assistant to help me with a variety of tasks ranging from email management, scheduling, data entry and documentation to managing Excel sheets and handling calls. Your communication skills are crucial and you should be comfortable with a variety of communication tools. Ideal skills and experience include: - Prior experience as a virtual assistant - Proficiency in time management and organizational skills - Strong communication skills - Familiarity with a variety of communication tools including email, instant messaging apps and Whatsapp calls I expect to communicate with my virtual assistant on once per day 1-2 hours a day basis. The right candidate would be someone who is proactive and can work independently to get the job done. Must be fluent...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
I'm in need of a professional to craft 2-5 comprehensive accounting spreadsheets, capable of automatic calculations, data validation, and the production of financial statements. Key Features: - Automatic calculations - Data validation - Generation of Financial Statements These spreadsheets will be primarily used by Accountants. Therefore, candidates with a background or experience ...of accounting principles will be prioritized. Familiarity with both simple and complex financial procedures is ideal, as is proficiency in creating user-friendly spreadsheets that streamline and simplify data handling and mathematical operations. All interested professionals are encouraged to bid, particularly those with a keen eye for detail and the ability to design effective, efficient spreads...
I'm looking for an Excel expert to create a robust template for tracking and analyzing student results data. This template will be used to perform in-depth statistical analysis. Key requirements: - Statistical Analysis: The main focus of this project is on statistical analysis of the student results data. Your experience with advanced Excel functions and statistical tools will be crucial for this. - Input Data: The data will be entered using forms within Excel. It's essential that these forms are user-friendly and efficient, allowing for accurate data collection. - Visual Representations: I need the data to be visually represented in the form of charts, graphs, and tables. Experience with data visualization and formatting is required to ensure that the data...
...real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead our efforts in leveraging machine learning technology, guiding and managing our talented teams to innovate and excel. Exciting Growth: VRAS is expanding rapidly, and we're looking for our next partner to join us on this thrilling journey. Equity Only Offer: This partnership opportunity is equity-only, reflecting our commitment to building a collaborative and mutually beneficial relationship. Future Salary: A rewarding salary is guaranteed once the project secures funding....
As someone managing integral data via Excel, I am experiencing significant issues with formatting errors, especially concerning chart alignment for printing. I'm keen to hire an expert who is well-acquainted with handling these challenges. Key facets you should focus on include: - Rectifying formatting issues: Your primary task will be to identify and correct any formatting discrepancies in my Excel charts that hinder smooth printing. - Specialized in Alignment: A considerable part of the task involves aligning the charts properly to ensure hassle-free printing. Hence, a solid grounding in Excel chart alignment is necessary. Ideal Candidate: - Proficient in Microsoft Excel, specifically adept at creating and formatting charts. - Excellent problem-sol...
I'm looking for a freelancer who can type up data from an XLS Excel sheet. The data is related to different categories and I want it organized accordingly. Additionally, I would need some basic analysis done on this data; think simple calculations like sum and average. Ideal Skills: - Proficiency in Excel, specifically with XLS files - Experience in data entry - Ability to perform basic calculations Please note: This project doesn't require any complex analysis like pivot tables or charts, just simple arithmetic operations.
I am looking for an Excel expert who can assist in improving formulas and functions related to my current project. The focus will mainly be on Lookup and reference functions. Key Responsibilities: - Review existing Excel worksheets - Improve or create Lookup and Reference functions as needed - Verify functionality and accuracy of updates Necessary Skills: - Proficient in using Excel 2013 - In-depth knowledge of Excel formulas, specifically Lookup and reference functions. Experience with complex Excel functions is a plus. The goal is to streamline my workflows, so efficiency and attention to detail are critical for this role.
Looking for a large list of investors who have worked in or showed interest in various entertainment industries provide data in excel: name | company | industry | location | email address We're paying $50 for every 1,000
...among professionals within the specified countries and sectors. Companies’ details (I will provide the below mentioned list of companies): United Arab Emirates (UAE) – 75 companies Saudi Arabia – 50 companies Turkey - 50 companies Singapore - 50 companies Hong Kong - 77 companies Thailand - 50 companies Total 352 Companies Data Required: (I will provide you a template excel file, in which you can provide the below details) • Company's Name • Company’s website • Full Name of the key person (First & Last name) • Job Titles / Role in the company • Email Address (official and private) • Mobile/Phone Number • LinkedIn Profile (most important) Lead priority (Searching Key Words): 1st pri...
I have a data analysis project that I completed within the required timeframe. This project involved analyzing sales data to identify trends. Key Points: - Project Type: Data Analysis - Goal: Trend Analysis - Data Source: Sales Data Ideal Skills and Experience: - Proficient in Data Analysis Tools: The ideal candidate should have a strong background in using data analysis tools such as Excel, Python, R, or any other relevant software. - Experience in Trend Analysis: A proven track record of conducting trend analysis is essential for this project. - Familiarity with Sales Data: Prior experience with sales data analysis would be considered a significant advantage. The successful completion of this project relies on the ability to extract meaningful insights from sales data and pres...
I need an Excel template tailored for my existing business to manage deliveries, sales, and balance quantities on orders. Key Features: - Advanced Formulas & Conditional Formatting: I require this to ensure the template is robust and can visualize data effectively. - Data Points Tracking: I need the template to include sections tracking: - Product names and categories - Customer names and contact details - Delivery dates and quantities - Profits and balances on Purchase Orders (POs) - Daily load outs reports The ideal freelancer for this job should have: - Proficiency in Excel, with extensive experience in creating advanced templates with conditional formatting. - A good understanding of business processes, especially in sales, deliveries, and inventory ...
I need a freelancer who is proficient in research and data collection. The task involves sifting through the websites of independent bookstores located specifically on the East Coast ...the US and acquiring the contact information of procurement officers. Key Tasks: - Identify independent bookstores on the East Coast - Extract the email addresses of the procurement officers Required Skills: - Excellent web research skills - Proficient in the English language - Exceptional attention to detail - Data collection and organization The final dataset should be delivered in a spreadsheet. Please ensure all collected email addresses are valid and error-free. This project could certainly become a repeat job for thorough and efficient freelancers. Having an interest in the book industry ...
I have a project that entails transferring text data from a PDF into Excel. Given that the information is well-structured, this task should be a smooth process for anyone proficient in data entry and comfortable handling documents in both PDF and Excel formats. Key Tasks: - Transcribe text accurately from the PDF to Excel - Ensure data maintains its structured format Ideal Skills: - Extensive experience with data entry - Proficiency in PDF and Excel - Detail-oriented and high accuracy rate A successful completion of the project would entail an Excel sheet in which the transferred text data from the PDF maintains its original structure.
...as proficiency with Excel or similar spreadsheet software. Key tasks: - Visit a pre-specified website and navigate to the list of potential investors. - Carefully extract the following details for each investor: Name, Fund name, and 'Sweet Spot' investment amount. - Collate this information in a well-organized Excel spreadsheet. - Find and add a link to each investor's LinkedIn profile alongside their extracted details. Specific requirements: - A meticulous approach to uphold the accuracy of data. - Experience or familiarity with Excel or similar spreadsheet software. - Strong data extraction and entry skills. - A detailed project proposal demonstrating understanding of the tasks involved. Upon successful completion of the pr...
Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new a...
...am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in ...
...management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal candidate for this job should have extensive experience in Excel, particularl...
I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.
I need a data entry expert to gather leads from various sources and input them into a spreadsheet. Location: already Done Name of Company: already Done Email: need to collect Contact: need to collect I can pay 500 INR for 500 Valid Leads.
I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermedi...primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV conversion - Familiarity with Git...
Entering data into an Excel sheet is the primary task for this project. Unfortunately, I cannot specify the volume of data that needs entering as I skipped this information. However, please rest assured that there is no immediate rush, so you can complete the project at a pace that suits you. Ideal skills and experience for this job would include: - Proficiency in Excel data entry - High attention to detail - Excellent typing speed and accuracy - Relevant experience in data entry jobs If your profile matches these criteria, I'd be delighted for you to submit a bid. Looking forward to potentially working with you.
I'm looking for a skilled data entry professional who can assist me with inputting data. The exact details of ...data and proficient in working with different formats. Your responsibilities will include, but are not limited to: - Efficiently and accurately entering data into the required format - Ensuring that the data is correctly categorized and organized - Checking for errors and handling them appropriately Ideal Skills and Experience: - Proven experience in data entry - Proficiency with Microsoft Excel and other relevant software - Strong attention to detail and accuracy - Excellent time management and organizational skills Please note that the volume of data may vary depending on the project, so a flexible approach and willingness to adapt to different task size...
I need a proficient expert in Excel to type numeric data and carry out basic arithmetic calculations. The scope of the project includes: - Data entry of numeric information into an Excel sheet. - Applying basic arithmetic operations to the input data. The ideal candidate should have: - Proficient skills in Excel, specifically with numerical data entry and calculations. - A keen eye for detail ensuring accuracy in calculations. - An excellent understanding of basic arithmetic operations.
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
I have code for login trading accound and fetch token data. I need to update 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. 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 600 INR an...
I need a proficient freelancer to extract and simplify excel data encompassing text, numeric, and date and time data from a significantly sized data file (approximately 5000 rows). The simplified output should be in the form of an Excel file. Ideal Skills and Experience: * Proven experience in data extraction and simplification. * Proficiency in Excel. * Excellent attention to detail. * Ability to work with large datasets. Responsibilities: * Carefully extract specific data segments. * Accurately simplify data for ease of understanding. * Convert the processed data back into an Excel file. * Ensure absolute accuracy throughout the process.
I need a skilled professional who can create some form of wizard (general office365 tools) that lets me enter personal and cv/resume types of data and then turns it into a word based cv using layout that I will provide. The word cv template must be amendable by me. The output is to remain a word document. I need it to be something that will work when my computer is offline not connected to internet I have attached a first cut of the word document template and it is the hello highlighted pieces that represent the inputs and show how/where tables need to be populated. the intent is to enter data and have a consistent cv created for all members
