Sort refresh data exceldela
I'm in need of a seasoned developer who can create a cross-platform (Desktop and Web) Excel plug-in/add-in. The primary purpose of this tool will be automating report generation by pulling data from various APIs.
I'm seeking assistance with data inputting from multiple Excel workbooks. The data is related to racing and includes: - Prices Ideal candidates for this project should have experience with Excel, data inputting, and ideally some understanding or interest in racing data. Attention to detail and accuracy are paramount as the integrity of the data is crucial.
I'm seeking a skilled Excel/Google Sheets expert to assist with my trading analysis file. The sheet is pivotal for determining entry prices, evaluating trade quality, and tracking profit and loss. Key Responsibilities: - Improving and fixing complex formulas related to entry price calculations - Ensuring all calculations are accurate and reliable Ideal Qualifications: - Proficient in Excel and Google Sheets - Strong comprehension of financial calculations and trading concepts - Experience in data organization and creating visualizations Please note, while the initial focus will be on fixing and enhancing the entry price calculations, I may require additional support with data structuring and visual representation in the future. Accuracy and reliability ...
I'm in need of a proficient freelancer who can modify an existing Excel spreadsheet I use to calculate final grades for my college classes. The sheet automatically calculates grades based on a letter grade (A-F) scale, but need to be updated in order to accommodate a new grading scale I have adopted. This involves the following key requirements: - Automatic Grade Calculation: The Excel sheet should be capable of computing the final grades based on individual scores. - Letter Grade System: The sheet should use a letter grade system (A-F) for grading. I am using a relatively new grading system to determine final grades in my college courses. It is called SPECS grading (short for “Specifications” grading). To summarize, a student will “Pass” an...
Creating a reporting template in Excel with VBA
I have a wine list spreadsheet with over 11 categories that needs to be put in alphabetical order in each category. Your tasks will include: - Arranging the wines in the inventory to match the order of the wine list - Maintaining the use of existing categories with no need for new ones -arranging the wines in each category of...each category. Your tasks will include: - Arranging the wines in the inventory to match the order of the wine list - Maintaining the use of existing categories with no need for new ones -arranging the wines in each category of the wines list in alphabetical order There is no special formatting required for each category. The ideal candidate for this project should have extensive experience with Excel, be detail-oriented, and able to follow instructions a...
I'm looking for a freelancer to create a simple, minimalist style landing page for me. The page should have fields for: - Name - Date of Birth - Mobile Number - Course - College Name - Job Profile The page should also include a button to submit this information. On...page should have fields for: - Name - Date of Birth - Mobile Number - Course - College Name - Job Profile The page should also include a button to submit this information. Once the information is submitted, it should be saved in the backend where I can easily access it by exporting it to Excel. Ideal skills and experience for this job include: - Proficiency in web development and design - Experience with creating minimalist style pages - Knowledge in backend data management - Ability to implement E...
I need a skilled Excel expert to set up a spreadsheet for me that will calculate invoices based on product or service details, and automatically generate invoices from the spreadsheet.
...gather comprehensive data on all authors from Seeking Alpha. This project involves: - Collecting information on the number of followers each author has. - Compiling their contact details, including email addresses, phone numbers, and social media handles. - Checking if they have a LinkedIn account and a YouTube channel, and providing details about these platforms. - Recording engagement metrics such as the number of likes, comments, and shares each author's articles receive. The primary purpose of this data collection is for research. Please note that the ideal candidate for this project should have excellent data research skills and experience in data mining. Proficiency in using social media platforms for research and data collection is also e...
Lan, You converted a pdf to excel for me a few months ago. We discussed a price of $70.00 per conversion going forward. Can we still do this? I have @ 15 pdf to convert. The only change is need the corresponding diagram also brought over.
I'm looking for a data expert to scrape various details from Indian college websites. The specific information I need includes: - Fees Range - Highest Package - NIRF Ranking - City - State - Ownership (Private/Government) - Courses offered - A brief description about the college (under 100 words) -College Name The breadth of the project includes gathering data on all types of courses offered, specifically: - MBA - BTech - MBBS - LLB The following cities college should be included are: bhubaneshwar chennai bangalore mumbai pune kolkata delhi hyderbad adndhra pradesh dehradun guwahati sikkim haryana Gujrat Bhopal Lucknow Noida Kanpur Patna Ranchi Raipur raurkella bbsr Jamshedpur Siliguri Nagpur Kolhapur Wardha Mangalore Mysore goa bhillai Chandigarh Trichy Coimbato...
...viaggi. Qualifiche: Istruzione: Laurea in Amministrazione Aziendale, Comunicazione o in un campo correlato preferita. Esperienza: Minimo 2 anni di esperienza in un ruolo simile, preferibilmente a supporto di esecutivi senior. Competenze: Eccellenti capacità organizzative e di gestione del tempo. Forti capacità di comunicazione scritta e verbale. Competenza nella Suite Microsoft Office (Word, Excel, PowerPoint, Outlook). Capacità di gestire informazioni sensibili e riservate con discrezione. Elevata attenzione ai dettagli e precisione. Capacità di multitasking e di stabilire priorità efficacemente. Proattività e capacità di anticipare necessità e potenziali problemi. Esperienza con strumenti di lavoro remoto come Zoom, Sla...
I'm looking for a data expert to scrape various details from Indian college websites. The specific information I need includes: - Fees Range - Highest Package - NIRF Ranking - City - State - Ownership (Private/Government) - Courses offered - A brief description about the college (under 100 words) -College Name The breadth of the project includes gathering data on all types of courses offered, specifically: - MBA - BTech - MBBS - LLB The following cities college should be included are: bhubaneshwar chennai bangalore mumbai pune kolkata delhi hyderbad adndhra pradesh dehradun guwahati sikkim haryana Gujrat Bhopal Lucknow Noida Kanpur Patna Ranchi Raipur raurkella bbsr Jamshedpur Siliguri Nagpur Kolhapur Wardha Mangalore Mysore goa bhillai Chandigarh Trichy Coimbato...
I'm looking for a VBA expert who can help me with data analysis and reporting using Excel. The main focus will be on data visualization. The ideal freelancer should be able to: - Automate tasks in Excel using VBA - Create custom functions or tools tailored to my data analysis needs - Design and implement effective data visualizations The data will primarily be sourced from Excel spreadsheets. Previous experience with data visualization in Excel is crucial, as is a strong understanding of VBA. It is a secret code game for family fun, not for resale. I will provide 11 lines of letters maximum 400 in each line. Lines 1 to 11. I need a dialogue box with. A multiplier selection box whereby I can put in a number from...
I'm looking for a seasoned developer to create a cross-platform (Desktop and Web) Excel plug-in/add-in. This tool's primary purpose will be to automate report generation, pulling data from various APIs. Key Requirements: - Development of an Excel add-in that works seamlessly on both desktop and web versions. - Implementation of automated report generation functionality. - Ability to pull data from APIs for report generation. - Incorporation of user authentication for some APIs. Ideal Skills: - Proficiency in Excel add-in development. - Strong understanding of API integration. - Experience with automating report generation in Excel. - Knowledge of implementing user authentication for API access. Your expertise will enable me to streamli...
Wir erhalten von einem Fremdanbieter ein Excel File, welches per E-Mail gesendet wird, dieses muss direkt an eine API von unserem Ticketsystem gesendet und importiert werden. Die Parameter sind vorgegeben. Anbei die Schnittstellen Anforderungen und das Muster Excel welches per E-Mail versendet wird.
...*This role is not open for applicants from Pakistan, Nigeria, Nepal, or Bangladesh. *Our target market includes North America, Europe, the Philippines, and the Middle East. *Proficiency in spreadsheets is essential for lead tracking and updates. *This is a full-time, long-term role (6+ months) with monthly enrollment targets. If you’re ready to make a lasting impact in the lives of learners and excel in a dynamic sales role, apply now!...
...Module -- Signup form (4-page wizard) -- Email, Facebook, and Google authentication -- Forgot Password functionality -- Reset Password functionality -- Candidate/Recruiter login flows - Job Module -- Create, edit, delete, and view job details -- List and filter jobs -- Suggest jobs -- Export jobs (Excel, CSV, PDF) - Candidate Module (For Recruiters) -- Update, approve, and delete applications -- View candidate details -- List and filter candidates -- Export candidates (Excel, CSV, PDF) - Profile Module -- Add, update, and view user details - Chat Module - Analytics Module - Dashboards for candidate, recruiter, and admin users Responsibilities: For the Payment Module, your responsibilities will include: - Implementing Stripe and PayPal payment gateway...
a) Formulate a multiple-objective programming model for the problem. b) Solve the problem using a goal programming approach. Use Excel Solver c-) Interpret the results of your solution. d-)Question 2:Use Gradient Search (the method of steepest ascent) to approximate the optimal solution to the following problem
Position: Freelance Data Entry Specialist Type: Remote, Part-time Duration: Project-based Overview: We are seeking a detail-oriented and efficient Data Entry Specialist to convert data from images into a structured Excel sheet. The task requires manually extracting information from images and accurately entering it into a predefined Excel format. The data includes names, entry dates, exit dates, total number of days, and category-wise details. Responsibilities: 1. Review and analyze the provided images to identify and extract relevant data fields. 2. Enter data into an Excel template with the following columns: Name Entry Date Exit Date Total Number of Days Category 3. Calculate the Total Number of Days using the p...
I'...automate data extraction from a primary Excel file, which contains 5 to 10 sheets. You'll be pulling basic line items and transferring them to a pre-defined template file. This template should be linked to the primary file, allowing for seamless updates whenever the primary file is refreshed. For anyone given instance, Both Primary file and Template file will have same line items. Key Responsibilities: - Extract basic data from the primary Excel file and populate a template file - Link the template file to the primary file for easy data refresh - Ensure the entire process is repeatable for future data sets Ideal Skills: - Proficient in Python programming - Experienced in Excel data manipulation - Familiar wit...
As a hiring manager, I need a diligent and efficient assistant to help with reviewing job applications, entering candidate data into our company system, and managing data processing. This role can be part-time or full-time, with a competitive salary. Ideal Candidate Skills: - Strong data entry skills - Proficient in Excel and Word - Experience with data processing Key Responsibilities: - Reviewing and approving job applications - Entering candidate information into the company system - Data processing Proficiency in Excel and Word is a must. Experience with HR software and previous hiring manager experience are not required but will be an advantage.
...strong data collection and Excel skills. The task involves gathering data from about 1,500 colleges in the Delhi NCR region. The information needs to be systematically organized in Excel, separated into sheets by college type (Science, Arts, Commerce, Management, Engineering). Key Data Points: - College name - College type - Region (New Delhi or NCR) - Placement Coordinator's name - Placement Cell Email ID - Placement Cell Person of Contact (in full name format) - Placement Cell Phone Number Sources: The data should be primarily sourced from official college websites. Validation: The accuracy of the data needs to be ensured through manual verification. Ideal Skills: - Proficient in Excel - Strong attention to detail - Exce...
As a hiring manager, I need a diligent and efficient assistant to help with reviewing job applications, entering candidate data into our company system, and managing data processing. This role can be part-time or full-time, with a competitive salary. Ideal Candidate Skills: - Strong data entry skills - Proficient in Excel and Word - Experience with data processing Key Responsibilities: - Reviewing and approving job applications - Entering candidate information into the company system - Data processing Proficiency in Excel and Word is a must. Experience with HR software and previous hiring manager experience are not required but will be an advantage.
...(Commission-Based) Contract Type: Commission-Only (No Upfront Payment) Work Type: Remote Description: We are seeking a skilled and results-driven professional to join our team as a Sales Representative and Upwork Bidding Specialist. In this role, you will be responsible for identifying opportunities, bidding on projects, and closing deals directly with clients. This position is ideal for individuals who excel in client communication, sales, and Upwork bidding strategies. Key Details: This is a commission-only role with no upfront payment or base salary. Earnings are entirely performance-based, with competitive commission rates for each successful deal. A formal contract will outline the terms of this commission-based position. Responsibilities: Bid on Upwork projects and cr...
I'm looking for a freelancer who can help me with recurring Excel tasks and has basic accounting knowledge. The tasks will include: - Data analysis - Report generation - Normalized PnL The freelancer will need to use basic Excel formulas. In terms of accounting tasks, the freelancer will be responsible for creating financial statements. Ideal Skills and Experience: - Proficient in Excel - Basic accounting knowledge - Experience in data analysis and report generation - Capable of creating financial statements The tasks will need to be completed on a daily basis.
I need someone who can help me debug my Excel financial tracker. I have seven organisations and ten monthly statements concerning cash flow. I need to work on my SUMPRODUCT formula across different sheets. The key requirements for this job include: - Skill in Excel, particularly with debugging formulas. - Experience with financial statements and trackers. - Ability to identify and rectify issues with data inputs across multiple sheets. Input will be financial statements in Microsoft Excel format (XLS/XLSX). The output expected is to debug formulas that are not working. I am using SUMPRODUCT, which works for a few financial statements but not for a few institutions. I suspect these are data type errors (number formats). I need help resolving these. I do ...
Job Description: Python/Excel Macros Developer for Data Automation Task We are seeking a developer experienced in Python, Excel Macros, or any suitable solution to automate a data from excel to another excel . Below are the requirements: The Primary Excel file will contain 3 to 6 sheets. Extract specific line items (details to be provided) from these sheets and feed the data into a predefined Template file of our choice. Ensure the Template file is linked to the "Primary Excel" file, enabling it to refresh data whenever required. Repetition for New Data: The entire process should be repeatable, means if Primary file is updated then it should allowing new data in "Primary Excel...
I need a proficient Android app developer to build an app focused primarily on data entry, specifically for inventory details. The app will be used for production and sales tracking and should have a user-friendly interface for easy data input and management. Key Features: - Focus on Data Entry: The primary function of the app should be to allow users to easily input inventory details. This could involve creating various forms for different types of inventory items. - Inventory Details: The app will primarily be used to enter and track inventory details. Therefore, the app should have capabilities to categorize and sort different inventory items. - Sales Tracking: Although the primary focus is on data entry, the app should also have basic sales tracking ...
I'm currently enrolled in a Coursera course on Excel Macros and need support getting through assignments and projects. Ideal Skills and Experience: - Proficiency in Excel Macros - Experience in teaching or tutoring - Ability to conduct engaging live sessions - Patience and good communication skills I would appreciate step-by-step guidance during live sessions. Please be prepared to help me understand the course material and complete my assignments and projects successfully.
I'm looking...a freelancer to help me with data entry from a PDF file of 855 pages into an Excel spreadsheet. The data size is approximately 3500 rows and consists of mixed content. Key Requirements: - The freelancer should have experience with data entry, particularly from PDF to Excel. - Attention to detail is crucial, as the data is mixed (text, numbers, etc.) and needs to be accurately transcribed. - Basic understanding of Excel is needed, though no complex formatting will be required. - I would prefer a freelancer who can carry out basic data cleaning (e.g., removing duplicates) during the process, though the primary focus will be on data entry. Ideal Skills: - Proficient in Excel - Excellent attention to d...
I'm looking for a freelancer who can assist me with automating some basic tasks using LIPS in Windows. The tasks involve working with Excel and AutoCAD. Tasks include: 1. Copying mixed data from an Excel sheet and creating both Bar and Line Charts in AutoCAD. 2. Updating the scale on both the X and Y axes. 3. Transferring all text data into an Excel sheet using mouse clicks. Ideal Candidates Should: - Have experience with LIPS in Windows. - Be proficient in Excel and AutoCAD (all versions). - Understand how to create both Bar and Line Charts in AutoCAD. - Have excellent attention to detail for data copying and chart scaling.
I have a number of PDF files that require manual data entry into an Excel spreadsheet. Attention to detail and accuracy is paramount for this task. Ideal Skills and Experience: - Proficient in manual data entry - Experienced with handling PDF files - Highly skilled in Microsoft Excel - Detail-oriented and accurate
...typing, creating and managing spreadsheets, and performing a wide range of computer tasks. I'm offering my services to clients in need of a reliable and efficient Virtual Assistant. With my capabilities, here's what I can provide: - Fast and accurate data entry in both English and Hindi. - Spreadsheet creation, formatting, and management to organize and analyze your data. - General computer tasks to support your business operations. Ideal skills and experience for job candidates include: - Proficiency in Microsoft Office Suite, especially Excel. - Strong typing skills in Hindi and English. - Attention to detail and a commitment to accuracy. - Ability to work independently and deliver tasks on time. - Good communication skills to ensure clarity and pre...
...on: o Part name o Part type o Vehicle type o Manufacturer o Production date o Other specifications (e.g., condition, material, compatibility). • Barcode and QR code generation and scanning for each item. The system should also allow direct printing of barcode labels from the application for easy labeling and tracking. • Stock alerts for low inventory levels. • Bulk upload functionality via CSV or Excel. • Grouping and Classification Display: o Support for grouping items based on categories such as new, used, original, and duplicate parts. o Display the number of items in each group. o Highlight the cheapest items within each group. o Provide classification options based on specific attributes for easier navigation and decision-making. • Add, update, and d...
I have a list of RERA numbers that I need data scraped from the MahaRERA website. Requirements: - Data should be scraped and organized as per the headers in the provided Excel file. - The final output should be delivered in an Excel file. Please note, this is a one-time project.
I need assistance with data entry and restructuring of files in the gravity folder. There are 35 files that require modification to match a consistent structure - using the 'birba file structure' as a reference. Requirements: - Standardize all files to have the same header, even if there is no data. - Add a 'File Name Column' to each file using the existing file name without the extension. - Ignore any extra columns in the original files. Final Deliverables: Both .xlsx and .csv versions of the restructured files. Ideal Skills and Experience: - Proficient in Excel with data entry experience. - Previous work with file restructuring is preferred. - Attention to detail and ability to follow instructions precisely.
...brand's uniqueness, such as highlighting the craftsmanship, ethical sourcing, or luxury appeal of the diamond rings. 2. Leveraging Relationship Skills: Building connections with the target audience through personalized engagement, empathy, and authentic communication. 3. MBTI-Driven Role Fit: best suit individuals with creative, empathetic, and audience-driven MBTI types (e.g., ENFJ or ENFP), who excel at connecting with and inspiring others. For success, the social media marketer should: • Understand the target demographic (e.g., couples, gift buyers). • Be skilled in visual storytelling, as platforms like Instagram and Pinterest are key for such businesses. • Build community through interactive content and consistent engagement. • Use analytics to refin...
I have an Excel workbook with approximately 40-50 individual worksheets, each containing a dashboard. These dashboards pull data from a main worksheet. I'm looking for a professional to convert these dashboards into a web portal for my clients to view. Key Requirements: - Creation of a main HTML page with hyperlinks to each dashboard page and a return link to the main page. - Conversion of the dashboard sections to HTML for online display. - Implementation of a script to periodically update the data in the dashboards. I can provide a virtual private server and a custom URL for the portal. While the project is based on Excel, I'm open to using an alternative such as Google Sheets if it's easier. I'll supply you with the Excel file, a...
Job Title Virtual Assistant f...• Certifications (GOTS, OEKO-TEX, BSCI). • Communicate professionally via email or calls to request quotes and additional information. • Organize findings into a clear Google Sheet or Excel document for comparison. • Follow up with manufacturers to clarify details or request updates. • Assist in ordering samples and tracking their shipment. Skills and Qualifications • Strong research and data-gathering skills. • Excellent written and spoken English communication skills. • Experience in supplier sourcing or similar research-based tasks. • Ability to organize information clearly in Google Sheets/Excel. • Familiarity with sustainability certifications like GOTS, OEKO-TEX, and BSCI...
I'm looking for someone to design a spreadsheet that can help me track daily attendance, automatically calculate absenteeism, turnover rate, retention rate etc
I'm seeking a data analysis expert proficient in Excel to help interpret my mixed data set. The analysis will be primarily descriptive in nature. Key Requirements: - Proficiency in Excel is a must - Experience with descriptive analysis - Ability to work with mixed data (both numerical and categorical) Skills and Experience: - Prior experience in data analysis - Knowledge of statistical concepts and methodologies - Strong attention to detail and ability to communicate findings clearly
...etc. Key Tasks: - The SPIDER should scan the web, proprietary databases, and social media platforms for new images and text that match the saved data. - It should compile these findings into an Excel file and send them to the associated patient email. - For Phase I, run all images through Google Image and report results by newly discovered data. Ideal Candidate: - Proficient in using Google Image Search for image recognition, with experience developing SPIDER programs. - Able to refine image recognition technology over time. - Familiar with creating specifications for software development. - Capable of batch processing and analyzing large data sets. - Excellent communication skills for reporting and sending compiled findings. Future Opportunities: There ...
I'm in need of a dedicated V...Calendar. Key Responsibilities: - Remote tasks: Downloading files and transferring to the server - Personal tasks: Ordering food through apps and reminding me of appointments ordering things, searchging for things, messaging people for me for status updates. - Business tasks: Assisting with interviews and organizing my Google Calendar Skills and Experience: - Proficiency in Microsoft Excel and Google Calendar - Familiarity with Zoom or similar video conferencing tools - Excellent English communication skills - Ability to follow directions This role requires the VA to be available from 10am to 6pm EST. The VA will frequently communicate with external parties on my behalf. Therefore, strong interpersonal skills and professionali...
I'm seeking a developer with expertise in creating Excel add-ins for both Microsoft Excel Desktop and Excel Online. The add-in needs to incorporate: - Data analysis tools: This will help in processing and interpreting complex datasets. - Custom formulas: I need unique formulas tailored to my specific data needs. - Data visualization: The ability to transform data into visual insights is crucial. Moreover, the add-in must be able to integrate with external databases. Therefore, experience in working with APIs and databases is essential. A strong background in data science and software development is highly desirable. Please provide examples of similar projects you've completed.
...amount paid and the date of payment. The school is divided into classes and departments, e.g. First grade has classes I-1, I-2, I-3... Class II has classes II-1, II-2, II-3... … Department names and class numbers are defined by the administrator User levels: The application should have 4 types of users: 1. Administrator - opens the year, forms classes, assigns a class leader, loads students from an excel file, and every day loads a pdf file containing the student's payments, which the system should recognize and assign to the student 2. The director - has insight into the payment of all students in the school and can see the total sum by departments, classes and at the level of the whole school 3. Class head - has insight into the payments of students of his class on...
I need an Excel file that should be able to process tables of times, ISO, and diaphragm. Key functionalities: - Automatic adjustment of exposure: The file should be able to adjust the exposure of the photos automatically based on the provided data. This project requires: - Proficiency in Excel: The freelancer should have advanced Excel skills to create a complex, yet user-friendly spreadsheet. - Understanding of photography: A basic knowledge of photography principles will help in understanding how to set up the correction tables. - Experience with data processing: The ability to handle large amounts of data efficiently is crucial for this project. Please note, this Excel file should be capable of handling batch processing, not just sin...
I need a skilled Excel VBA programmer to enhance my current Excel workbook with new macros. The primary aim of these macros is to automate data entry tasks, specifically dealing with text data. Your responsibilities will include: - Modifying existing macros or creating new ones to facilitate the automation of data entry - Ensuring the macros can handle various forms of text data effectively Ideal candidates should have: - Proficient experience in Excel and VBA programming - Previous experience in creating or modifying macros for data entry purposes - Excellent understanding of handling text data within Excel Please provide examples of similar projects you've worked on, and your approach to tackling this task.
I'm seeking a professional with REAL PowerPoint and advanced Excel skills to transfer and format content from Excel into PowerPoint slides. This task should take 2-3 hours to complete. Please note: - No need for content creation in either Excel or PPT. - Professional and timely work is a must. I'm looking for someone with experience who can guarantee quality work within the specified time frame.
