I'm in need of an expert in Excel to create a spreadsheet that will automate data entry, perform calculations, and generate reports. The complexity isn't clear yet, as I'm unsure how many different tasks will need to be automated. The suitable candidate should have: - Proficiency in Excel, including advanced features - Experience with automation within Excel - A good understanding of data entry, calculations, and report generation I'm open to a dialogue to specify the details further. On the first tab in Excel, I'd like to have all the individual contributors. Then have a tab after that for each individual to show their trends over the months. Anything over 95 is considered good and below 95 would be not good. There are 15 con...
There is an excel file to modify according special rules
...Someone who can combine data from other files, and websites, and connect it into one spreadsheet. Key requirements: - Website image scraping - Combine data of external websites with existing spreadsheets / excel csv files. - Data scrape images from external websites, and copy url to match the google spreadsheet lines - Download mass URL of these images into a separate accessible folder for future management. Potentially around 50,000 lines of data to manage and enter. Ideal Skills: - Google Spreadsheets - Data Organization - Image uploading and management - Web form integration - Excel We will provide as much data as possible. your job is to enter it in. Most of the database is in English, some of the entry is in Japanese. some example of websites we will ...
I am looking for a seasoned professional who can leverage artificial intelligence (AI) analytics to enhance my business efficiency. The project will involve: - Data analysis - Predictive modeling - Natural language processing These tasks aim to utilize machine learning (ML), as well as harness the power of Azure Databricks, Azure Data Lake Storage, Copilot, and Azure Data Factory. This project will also use Azure Kubernetes to ensure that the analytics processes are scalable. The main goal is to augment our standard business processes and make them more effective by leveraging these technologies. The data to be analyzed is structured and originates from various sources like Excel, CSV, SQL, etc. Ideal skills for this project include: - Proficient in AI analytics ...
More details: What type of data do you need to convert? Text data What is the desired output format for the converted text data? Excel spreadsheet Do you require any specific data manipulation or analysis within the Excel spreadsheet? Data sorting and filtering
I have an Excel sheet that contains text data and I need it to be parsed. I am looking for a Python expert who can use pandas to extract the text data and present it neatly in a new Excel sheet. Key requirements: - Extracting text data from an Excel sheet using Python pandas - Presenting the extracted text data in a new Excel sheet - Sorting and filtering the extracted text data as per business requirements Ideal Skills: - Excellent knowledge of Python, especially pandas - Proficiency in working with Excel sheets - Experience in sorting and filtering text data - Strong attention to detail and commitment to quality
...pieces that align with Verve Clothing's brand identity. 2. Trend Awareness: Stay updated with current fashion trends, especially in bottomwear, and incorporate them innovatively into designs. 3. Color Sense: Strong understanding of color theory and the ability to create visually appealing color palettes for bottomwear collections. 4. Software Proficiency: Proficient in CAD (Computer-Aided Design) software for creating technical drawings and Adobe Creative Suite (Illustrator, Photoshop) for design presentations and mock-ups. 5. Portfolio: A diverse portfolio showcasing previous bottomwear designs, demonstrating creativity, attention to detail, and understanding of trends. 6. Collaboration: Ability to collaborate effectively with the design team, patternmakers, a...
I am looking for an experienced freelance to convert my past year's Profit and Loss statement into a fully itemised budget for the upcoming year. This will encompass the following elements: Key Requirements: - Extract and organise data from a PDF P&L statement - Formulate an Excel-based budget plan for the upcoming year including Revenue, Expenditure, and Cost of Goods Sold - Base projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using ...
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
...put as an example (can be another one) 2- Download the information to excel and using chatgpt for excel modify the description of each fair so that the content is original (we will give access to the plugin for excel with enough credits and chatgpt 4). 3- by means of chatgpt for excel modify the date format 4- include a no follow link to the fair in question. 5- (very important) check that Chatgpt does not make mistakes in the description or dates (this happens very often) We will not release the milestone if we see mistakes. 5- Create a dynamic calendar for wordpress that removes the old dates and leave only the content from the date of the current day. You can also use a plugin if it exists. Very important:
...in need of a skilled professional who can help me showcase live game data directly from an Excel spreadsheet on my WordPress website. Key Requirements: - Real-time data update: The data should be updated on the website as soon as changes are made in the Excel file. Ideal Skills: - Proficient in Excel: The freelancer should be well-versed in Excel in order to effectively parse and represent the data in a user-friendly manner. - WordPress Expertise: A solid understanding of WordPress is essential to ensure the data is displayed correctly on the website. - Experience with Real-time Data: Previous experience in displaying real-time data is a huge advantage. I don't have a specific plugin in mind for this task, so I'm open to suggestions. Howe...
...If you’re a top Rep with experience who takes initiative, self-motivates and make things happen this is the job for you. We have a market filled with opportunity and are happy to offer aggressive compensation - provided you bring results. tinyB chocolate specializes in Brazilian chocolate truffles called brigadeiros. We offer chocolate-making team building activities, chocolate gifts and chocolate-filled LavaCookies. Our work has earned a 5-star rating from consumers and Fortune 500 companies alike. We often hear people say that our products are some of the best they’ve ever tried. DESCRIPTION/RESPONSIBILITIES We’re expanding into an exciting new market and are looking for a self-motivated, experienced sales rep who will call on General Managers of ...
...options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existing Excel sheet for this trading sys...
I am in need of a freelancer well-acquainted with data entry for translating text data into a usable Excel spreadsheeet. Key Requirements: - Proficiency in text data entry - Experience working with a diverse range of project types - Skilled in Excel, especially formatting and data organization Your task will be to translate the original data (which could be a PDF file, printed hardcopies, handwritten notes, or a different format depending on the project) into neat, easy-to-read Excel spreadsheets. Prior experience with Excel and other similar tasks will be crucial for completing this project accurately and efficiently.
I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.
I am trying to fetch ebay api token. Code works in php but not in vba
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
...seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount. This task requires not only technical skills in Excel but al...
...knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. In addition to a Reckon Accounts 2013 Pro file of the data I can use, at minimum I need from you an Microsoft Excel or Libre Calc file of all of the data in its fields that I can work with. Ideal professionals for this task should: - Have proven experience with Quickbooks, especially old/legacy versions - Be familiar with potential issues of opening older Quickbooks files using newer versions - Be able to ensure that data integrity is maintained throughout the process To show you're up for...
I am in need of an experienced data entry specialist who can assist me with entering basic data into Excel. The data to be entered will be from handwritten notes. Ideal skills and experience for the job: - Proficient in Excel for basic data entry and formatting - Detail-oriented with high accuracy in entering data - Ability to work with handwritten notes - Good communication skills to clarify data points if needed
I'm in need of someone adept in bookkeeping, expense tracking, and financial reporting. You don't have to have experience in a specific software, but being proficient in tools like QuickBooks, Excel, and Xero would be ideal. I need the Account Assistant to handle: - Bookkeeping - Expense Tracking - Financial Reporting In your proposal, please include: - Details of your past work and experience in similar roles - A detailed project proposal outlining how you'll carry out the tasks I'm excited to hear from you, and start working together on this project.
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regression analysis, time series analysis, and hypothesis testing is strongly requir...
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or errors - A backgroun...
Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must...and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
...si/COBISS/bibliografije/ Your job is to find a contact email address or/and online form for authors to submit a book proposal for each of the publishers on the list. Most of them have an online form. Get the www link. For each of them, get a contact email address. If there is no email address for authors, get some other general contact email address of the press. You will submit an Excel file with three columns: name of the publisher, email, www link with a form (if there is an online form). In this list I provided, for some publushers there are two names (left and right) or more than two names (one left and several right). In these cases of multiple names, you just need to do it for one name/publisher, not more. If one of the few n...
I have python script to copy title and keywords from excel sheet to image metadata , I need to add category to subject filed and price to comment filed so excel sheet will be title , keywords , category , price , data will be copied to image metadata
We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explaining fully and showing...
I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution p...problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel at...
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
Consolidated Sales Calendar report put in excel spread sheet.
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send reminders.
...skilled professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance my workflow. Please remember to include your relevant experience in ...
...THE WORK FOR *** *** PLEASE DO NOT CONTACT US OUTSIDE OF THE FREELANCER CHAT SYSTEM. UNSOLICITED EMAILS WILL BE IGNORED AND REPORTED *** We're experiencing problems with duplicate results when using a SELECT query in the context of retrieving data from multiple tables in MySQL. I require assistance getting this resolved. The query selects data against two tables. The selection must compare Invoice Details with PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File F...
...to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone who enjoys working with data, has a keen eye for detail, and is able ...
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
Need someone who can analize data from a excel and contact customer with missing data
I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Excel and hav...
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.
I'm seeking a proficient Microsoft Word VBA expert. Your responsibility will be: - Automating repetitive tasks to increase efficiency - Creating custom macros to fulfill specific needs - Developing interactive forms, enhancing our team’s productivity The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is def...
I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this s...Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - Strong problem-solving skills and attention to detail. Looking forward to seeing your proposals!
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
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, ...
