Projek mini excelproiecte

I'm in need of a LinkedIn account holder to assist with job postings. This role involves making 10 free job posts per month and responding to all applicants. Each post takes about 10 minutes, totaling approximately 1.5 hours monthly. The posting schedule is every 3 da...closing the job and initiating a new one thereafter. The content for the postings is standardised and simply requires copying. Key Responsibilities: - Make 10 free job posts per month on LinkedIn - Respond to all applicants - Follow the posting schedule of every 3 days This job is manageable and many people currently do it for me, so you'll be integrating into a team. Performance is key; if you excel at this task, there is potential for continued work over several months. To apply, please include '...

necesito obtener datos a diferentes hojas de excel desde la base de datos en msql de mi pagina web, tengo avances que funcionan hasta cierto punto, necesitan ajustes para lograr lo esperado.

I'm seeking a freelancer proficient in data analysis and visualization, particularly using Excel. The primary focus of this project will be analyzing and visualizing sales data. Key Responsibilities: - Conduct in-depth analysis of sales data - Utilize Excel for data visualization - Provide insightful interpretations of the data Ideal Skills & Experience: - Strong analytical skills - Proficient in using Excel for data visualization - Experience in analyzing financial data data - Good understanding of data analysis and visualization principles If you also have content creation skills, especially in writing blogs or content writing, that would be a bonus. However, the primary focus is on data analysis and visualization.

Description: I need VBA and Excel automation expertise to integrate a new productivity KPI into an existing report. The POS vs. Opportunity report already contains automated VBA scripts and formulas, so this task requires enhancing the functionality without disrupting the existing structure. Project Overview: Integrate a Productivity KPI: Track registrations completed per team member and calculate registrations per hour. Data Source: Supervisors maintain a separate daily registrations report (Excel). Goal: Combine this KPI seamlessly into the current POS vs. Opportunity sheet. Requirements: Add columns for Registrations Completed, Hours Worked, and the calculated Productivity (Reg/hr). Maintain the current VBA automation and ensure no integrity issues....

I'm seeking a meticulous data entry specialist to help me input product details sourced from the internet into an Excel spreadsheet. Key Responsibilities: - Researching and sourcing product details from online platforms - Accurately inputting the data into an Excel spreadsheet Ideal Skills: - Proficiency in Excel - Strong attention to detail - Experience in data entry and online research - Ability to meet deadlines The project will involve entering details for between 100 and 500 products. The freelancer can use a customized format for organizing the product details in the Excel spreadsheet. The data entry will include collecting and entering the product name and price. Please include the product description as well. Please include the following detai...

I'm in need of a diligent and resourceful individual to help me locate the email addresses of business contacts from an Excel spreadsheet. The initial task involves 2000 entries, but if the results are satisfactory, there is a larger batch of over 50,000 entries waiting. Key Responsibilities: - Use various methods (visiting websites, Google Maps, social media, etc.) to find the emails - Transfer data from 'contact us' pages with a contact form into a separate spreadsheet - Remove entries with contact forms instead of emails from the email spreadsheet Compensation: - Pay will be based on a per-email-found basis - Separate payment for entries that end up in the contact form spreadsheet Criteria for Acceptable Emails: - No generic or default or invalid emails - Perso...

I'm in need of a proficient English-speaking virtual assistant with experience in Excel spreadsheets. The assistant will primarily be responsible for data entry tasks related to product inventory, invoces, and customer templated outreach. Key Responsibilities: - Extracting Text from Photos. - Managing product inventory through Excel spreadsheets - Creating product descriptions and attributes, along with photos and prices. - Performing data entry tasks on a regular basis Ideal Skills & Experience: - Proficiency in English - Strong experience with Excel spreadsheets - Previous experience with ZOHO CRM is preferred - Good understanding of data entry tasks and product inventory management. Availability: - Must be available from 10am-6pm EST time zone.

I need an Excel spreadsheet that outlines a loan amortization schedule over a 5-year period with differing interest rates. Requirements: - The schedule must account for both fixed and variable interest rates. - The spreadsheet should not contain any visual aids - just the data itself. - Include a column that shows the remaining loan balance after each payment. - The schedule should clearly show the breakdown of principal vs. interest in each payment. Ideal Skills: - Proficiency in Excel, particularly with complex formulas and functions. - Strong understanding of loan amortization and interest rate variations. - Experience in creating clear and organized spreadsheets. Include options for extra payments in the loan amortization schedule.

I need an expert in UiPath and SAP ERP for seamless integration. The primary focus is on ERP systems, specifically SAP. Main task: 1. export data from few tables based on selection screen from excel, data from 2 SAP systems 2. create table in excel Ideal Skills: - Proficiency in UiPath - Extensive experience with SAP ERP - Understanding of ERP system functionalities - Strong problem-solving skills - Excellent communication and collaboration capabilities I am looking for a professional who can ensure efficient and effective integration of UiPath with our SAP ERP system. Please provide relevant examples of your previous work in your proposal.

I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel proficienc...

... Margin Percentage: the profit margin between internal cost and displayed cost. Project Notes: a space for adding any observations or specific details. Image Upload: the ability to upload and associate images with the project. Crucial Part of the Upload Process: The image upload is one of the most important features. To correctly upload images, a Shooting List must first be uploaded in CSV or Excel format, containing the following information for each product: Product Barcode Product Code Product Category Product Gender Product Color Delivery Date (if applicable) Return Date (if applicable) These details will also serve as filters for quick search at the top of the page, allowing for organized project management. Each product will have a folder where images can be uploaded. Th...

Description: I need a freelancer to create a custom Excel template for tracking distributors of IV pump brands across multiple regions and countries. This project is for template design only—no research or data collection is required. Template Requirements: 1. Columns: • Country: Pre-filled and organized by region (see target regions and countries below). • Distributor Name: Name of the distributor (or indicate “Direct Sales” if the brand sells directly in that country). • Website: Distributor’s website. • Key Contact(s): Name, email, phone (if known). • Notes/Details: Space to input Market presence, market share, and relevant details. • Active in Market: Checkbox or dropdown to indicate whether the brand is actively sol...

...user-friendly interface using HTML, CSS, and JavaScript for file uploads and process initiation. Use frameworks like Bootstrap for responsive design. 2. Backend Functionality Use Flask as the backend framework. Define the following endpoints: File Upload: For users to upload Excel files. Template Management: To manage and list Word or PDF templates. Contract Generation: To fill templates with Excel data and create output files. Log Viewing: To display logs and errors to users. 3. Process Flow Excel Data Processing: Read the uploaded Excel files and save the data into a database (e.g., SQLite). Template Filling: Use docxtpl for Word templates and fillpdfs for PDF forms within Flask routes to generate the necessary documents. Parallel Processing: Utilize tools ...

Arabic Speakers Only (The job is don in Arabic language) I'm seeking a professional to assist with cleaning and categorizing a grocery product list in an accounting system. The tasks involve: Data Cleaning: - Reviewing and refin...main and sub-categories that I will provide. - Classifying each product in the list and linking it to the appropriate main and sub-categories. Work Requirements: - Previous experience with product lists and classification. - Proficient in Excel or similar programs. - High level of accuracy and attention to detail. - Ability to work quickly and efficiently. Question 1: The product list consists of more than 2000 items. Question 2: I have specific names for the main and sub-categories. Question 3: The preferred format for organizing the products is...

I have an existing Excel spreadsheet that needs a makeover. The main focus is on improving the layout and readability to make it aesthetically pleasing for presentations. Key Requirements: - Enhancements should align with a professional and clean style, devoid of unnecessary clutter or distractions. - Use of custom fonts and consistent formatting to elevate the visual quality of the spreadsheet. - Organizing sections with clear headings to guide the viewer through the data smoothly. Ideal skills for this project include: - Proficient in Excel with a keen eye for design. - Experience in creating professional-grade spreadsheets. - Ability to apply custom fonts and maintain consistent formatting throughout. Feel free to select professional color schemes at your discretion.

Please convert this provided document for PDF to editable Excel keeping source content, formatting, and visuals.

...Provide insights into sales performance by analyzing historical data to uncover trends, opportunities, and areas for improvement. Key Tasks: Data Collection: Gather and clean historical sales data, including sales volume, revenue, product details, customer demographics, and geographic information. Data Transformation: Process and transform raw data into a structured format using tools like Python, Excel, or Power BI to facilitate easy analysis. Trend Analysis: Identify patterns and trends in sales, such as peak seasons, customer preferences, and sales by region or product category. Customer Segmentation: Segment customers based on demographics, purchasing behavior, and sales history to provide tailored insights for marketing and sales strategies. Forecasting: Use statistical mod...

*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.

I'm looking for a skilled designer and/or craftsman to create 3D models for 5 types of plastic pieces for a board game, so I can send them to a 3D print farm and get a few thousand made. I need four figures and 1 base piece the figures can stack on. The base pieces must also stack, so that a figure can stand on a stack of base pieces. I would like the base pieces to basically be 22mm mini poker chips (I've them similarly before in other games). The four figures needed are 1) a man standing with a spear and shield, no headgear, long hair, generic looking; 2) a dhow-type vessel; 3) a fist holding a hammer; 4) a fist holding a crumpled paper resembling a contract. Ideal Skills and Experience: - Proficiency in designing game pieces - Understanding of board game mechanics...

I'm seeking a tech consultant for creating an Excel plug-in that sends customized notifications based on user commands. The plug-in should work on both Windows and macOS. Key aspects to cover in our consultation: - Identifying the most suitable tech solutions for this project and for making a similar plug-in for PowerPoint. - Strategies to ensure the plug-in can be used on company laptops without being blocked by security protocols. - Setting up a secure landing page with payment options and unique download keys for each user. - Ensuring the source code remains inaccessible to users post-installation. The ideal candidate for this project should have extensive experience in software development, particularly in creating Excel and PowerPoint plug-ins. Familiarity with c...

...advanced Excel financial modeler to build a valuation model that compares the profitability of two potential projects. The model should incorporate a summary tab, income statement, balance sheet, and cash flow statement. The main goal is to ascertain which project offers better overall profitability. You'll be utilizing the discounted cash flow method to determine key financial metrics: Internal Rate of Return (IRR), Net Present Value (NPV), and Return on Investment (ROI). Key tasks include: - Building a comprehensive Excel model using provided key terms and assumptions. - Implementing a comparison of the two projects' key metrics (IRR, NPV, and ROI) on the summary tab. - Ensuring the model is fully functional and user-friendly. Ideal skills for this job incl...

I'm seeking an Excel professional to update an old worksheet. The task involves: - Adjusting custom formulas and calculations - Correcting errors in existing data - Adding new data entries - Removing outdated or incorrect data - also bulid a follow-up plan with for each team member and teams - Optimizing existing formulas to improve performance - Generating visualization charts for better data representation - Automating routine tasks using VBA or macros - Updating cell formatting for consistency and readability - Linking to external data sources for real-time updates Ideal candidates should possess: - Proficient Excel skills - Experience with custom formulas - Strong data entry and correction abilities The task should be quick for an expert. The new data entries wil...

I'm looking for a professional who can capture live data from the Nifty option chain and deliver it to me in Excel. Key Requirements: - Capture specific data points: Strike prices, Volume, and Open Interest - Update frequency: Real-time Ideal Skills and Experience: - Proficient in data capturing and analysis - Experienced in working with financial market data - Able to deliver data in Excel format The data should be updated every minute. Capture additional data points as specified. Data should be captured using the official exchange API or broker terminal. Include charts and graphs for visualizing the captured data. Include line,bar charts for visualizing the captured data.

I'm looking for a comprehensive list of email contacts for city administrators and city events coordinators in Chicago and every suburb within 50 miles. Requirements: - Contacts should primarily be government officials. - List should include full name, email address, and job title for each contact. - Final deliverable should be in an Excel spreadsheet. Ideal skills and experience for the job include: - Proficiency in data collection and research. - Prior experience in generating contact lists, especially in public sector. - Ability to deliver clean, well-organized data in specified format.

Packaging a Kivy App for Android I have developed a Python-based app using Kivy that I want to package for Android devices. The app includes the following features: 1. Dependencies: The app processes Excel files using pandas. There also an image. 2. Widgets and Code: The rest of the app consists of Kivy widgets and Python code. Current Challenge: I am using Windows as my primary development environment and need assistance with: 1. Setting up a functional Linux environment (e.g., WSL, Virtual Machine, or Docker) to support Buildozer. 2. Configuring Buildozer to successfully package my app into an Android .apk file. 3. Resolving any issues related to the inclusion of pandas and other dependencies. 4. Ensuring the images and other resources are properly bundled with...

I'm seeking a skilled Pytha 3D modeller proficient with Pytha software, who can help create detailed models for a Media Wall Unit. The main focus of this project is to develop 3D mode...details required. 1. Create 3D Shop Drawings insert dimension, having parametric properties to change the dimensions of the cabinet easily. 2. Generate cutting list of panels exported in an excel sheet 3. Cutting list exported to an optimiser for the total number of plywood panels required. 4. Exploded design drawing 5. Label showing the panel name, picture of where the dowel holes are located, edging sides. 6. Insert connectors such as screws, dowels and fixing systems. 7. Bill of materials generation with required hardware such as drawer rails, connectors, hinges and dowels with exported into...

I would like to create a sales tracker on excel. I want the sales data sheet to have the following information: date of first appointment, lead number, source, call duration, outcome, date sold, product, units sold, finish, discount, book price, price left, core price, split (%), conservation area (yes/no), building work (yes/no), next action date, notes. I would like the excel document to calculate the following: overall/monthly/weekly conversion rate in decimal (sales appointments / sales), overall/monthly/weekly core price, average split percentage (weekly/monthly/overall, weekly/monthly/overall commission earned and monthly uplift earned (more details on this when needed), average conversion rate per units sold <5, 5-10, 11-15, 15+, average sales conversion on firs...

I'm in need of a seasoned data scraper with extensive experience in collecting information fr...from LinkedIn Sales Navigator. I am aiming to gather data on 77K HR professionals. Specific Data to be Scraped: - Name - Job Title - Company - Email Address - Phone Number - LinkedIn Profile URL - Location - Industry - Years of Experience - Gender Deliverables: - The collected data should be delivered in an Excel spreadsheet. - This is a one-time data collection project. Ideal Skills and Experience: - Proven experience in data scraping, particularly from LinkedIn. - Proficiency in Excel and data management. - Excellent attention to detail to ensure data accuracy. - Ability to handle and process large volumes of data. Please only apply if you have the required skills and ...

I'm in need of a seasoned market analyst who specializes in chart patterns. The primary focus will be on identifying entry and exit points using specific patterns: Head and Shoulders, Double Top/Bottom, and Cup and Handle. Ideal skills for this project: - Expertise in chart pattern recognition - Proficiency in stock market analysis - Ability to ...Shoulders, Double Top/Bottom, and Cup and Handle. Ideal skills for this project: - Expertise in chart pattern recognition - Proficiency in stock market analysis - Ability to identify potential entry/exit points - Proficiency with technical indicators like RSI, MACD, and Bollinger Bands. Your role will be crucial in helping me effectively navigate the stock market. Please provide the analysis in an Excel spreadsheet with all releva...

I'm seeking a meticulous data entry specialist to help me input product details sourced from the internet into an Excel spreadsheet. Key Responsibilities: - Researching and sourcing product details from online platforms - Accurately inputting the data into an Excel spreadsheet Ideal Skills: - Proficiency in Excel - Strong attention to detail - Experience in data entry and online research - Ability to meet deadlines The project will involve entering details for between 100 and 500 products. The freelancer can use a customized format for organizing the product details in the Excel spreadsheet. The data entry will include collecting and entering the product name and price. Please include the product description as well. Please include the following detai...

I'm looking for an Excel expert to create a recipe calculator for me. This calculator should have the functionality of scaling recipes by a percentage. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating complex Excel tools - Understanding of recipe scaling Please let me know if you can help.

I'm seeking a professional to assist with a creation of 10 photos for a my website. - Existing photos : I need you to create gif with my photos and videos for my tree products - Data Format : need you to list what you have done in a Spreadsheet (Excel/CSV).

Project Description: We require an experienced professional to create a customized report from an Excel database. The project involves: 1. Extracting and organizing specific data from the Excel file. 2. Designing a visually appealing and functional report format. 3. Ensuring the report can be generated dynamically if required. 4. Delivering the final report within 01 hours. Requirements: • Proficiency in Excel (advanced functions, pivot tables, macros, etc.). • Experience in report generation and formatting. • Attention to detail and ability to deliver on tight deadlines. • Knowledge of integrating Excel data into other reporting tools. Please include examples of similar projects in your proposal and specify how quickly you can comp...

I'm in need of a skilled programmer who can create an Excel VBA plug-in for me. The primary function of this plug-in will be to detect user actions within Excel and display selected messages on the top corner of the screen. Ideal skills and experience for the job include: - Proficiency in Excel VBA programming - Experience in developing Excel plug-ins - Knowledge of creating and linking macros to buttons Please only apply if you can deliver a high-quality, efficient solution.

Hello, i've some troubles with Vlook and i need help, see attached file

Determine if an employee came late or early, left late or early, took a 30 minute break or not when applicable

Hi, I want this website to be scrapped. Please check the sample page which I want following data to be extracted Name,Designation,Mobile No, Email There is also data of the Sarpanch and Secretary on the same page but not in the table. Somehow I also want their contact information. I want all data of U.P to be extracted and put in Excel sheet. the scrapper shud go into each District Panchayat Name> Panchayat Samiti Name> Village Panchayat Name> and then take out members name/contacts/emails.

...will parse XML files and extract relevant details into a predefined Excel format. Essential Features: - The software should specifically extract relevant information from the XML files. - The utility should follow a modular approach. This means every component should be independent and interchangeable. - A key requirement is the reusability and extensibility of the codebase. The software should be built in such a way that it can be easily adapted for future use or extended with new features. - The software should include robust error handling mechanisms to manage various XML parsing errors and data extraction issues. Ideal Skills and Experience: - Proficiency in Java is a must. - Prior experience with XML parsing and Excel file creation. - Strong understanding of modular...

I'm looking for a machine learning expert who can help me analyze my financial data in Excel. The main aim is to identify trends over time which could help in forecasting future performance. Key Requirements: - Proficient in Excel and machine learning techniques - Experience with financial data analysis - Ability to identify and interpret trends over time The ideal candidate will have a strong background in data analysis and machine learning, specifically with financial data. You should be able to deliver insights that could help in forecasting future performance based on identified trends.

Project: Next.js-Based Peer-to-Peer Package Delivery...functionalities, including registration, package management, order tracking, payments, chat, and more. Key technical aspects include REST APIs, MongoDB, JWT authentication, Stripe Connect, WebSockets, and KYC integration. The project also requires advanced features like multi-language support, support tickets, and restricted item management. Crucially: The attached Word document and the Breakdown Excel table are integral parts of this proposal and define the detailed requirements and scope of the project. The developer is required to comprehensively read, understand, and sign these documents, committing to implementing all aspects outlined within them. These documents are legally binding and form the basis of the contractual ...

I'm looking for a skilled data extractor to assist me with a project involving a large PDF file. The...extractor to assist me with a project involving a large PDF file. The document has over 800 pages and contains tables with more than 3000 rows. Here's what I need: - Data Extraction: The data is mixed, containing both text and numerical values. - Excel Representation: The extracted data should be accurately represented in an Excel file. The tables in the PDF have a consistent layout throughout the document, making the extraction process more straightforward. Ideal skills for this project would include: - Proficiency in data extraction - Advanced Excel skills - Attention to detail to ensure accurate data representation. Please reach out if you have th...

Job Title: Data Entry Specialist Description: We are looking for a reliable and detail-oriented data entry freelancer to assist with our data management needs. The candidat...completeness of data entries. Organize and maintain files for easy access and retrieval. Review data for errors or discrepancies and resolve issues as needed. Meet daily/weekly productivity goals while maintaining high-quality standards. Follow privacy and data protection standards. Requirements: Strong typing skills and attention to detail. Proficiency in data entry tools such as Microsoft Excel, Google Sheets, or specialized software. Ability to work independently and manage time effectively. Prior experience in data entry is a plus but not mandatory. Good communication skills for updates or clari...

I'm seeking an Excel expert for a 2-hour project. Example work : i have 10 sheets with C column as commodity column in excel. i want distinct names from all those sheets in my existing sheet named "LEDGER" I have asked ai, but i need someone who can do. The data to be processed will include financial data.

I want to convert my Google Slides presentation to Video and my Google Slide's Narrator Notes/Editor notes should be Artificial voice over for the output video. After Video conversion Video should be uploaded to my YouTube channel at specific mentioned time. (Approx Every day 4:00PM) Points to consider below: 1. This automation shoul...Different customizations will be applied for each regional language. Please ensure the Artificial voice over files are provided in MP3 format. Implement a weekly backup schedule for all video files and project data to avoid data loss. The initial videos will be reviewed and approved by the client before final upload. The separate data for video titles, thumbnails, and descriptions will be provided in Excel format. No subtitles will be included...

I need an Excel specialist who can help me with a project focused on financial tracking and budgeting. Key Responsibilities: - Design an Excel sheet for comprehensive financial tracking. - Create a budgeting tool within the Excel sheet. - Incorporate graphs and charts for visual interpretation of data. Ideal Skills: - Proficiency in Excel, particularly with budgeting and financial tracking tools. - Experience with data visualization in Excel. - Strong understanding of financial management.

We have PDF copies of timesheets from our construction crews (approximately 100–150 sheets, each covering 5–20 personnel). These timesheets are submitted by the end of the day on Monday, and we require them to be entered into an Excel spreadsheet for upload into our software by Tuesday morning when the office opens. This task will be required once a week for the next three months. We can provide the employee names in Excel format, enabling data validation to improve accuracy. This is an urgent requirement. Please let us know if you can assist. Thank you!

Project: Interactive Lessons on ESP32, IMU6050, and GPS for Real-Time Data Visualization and Storage I am looking for an expert to provide interactive lessons starting from scratch on how to use the ESP32 with the IMU6050 sensor (accelerometer and gyroscope) and a mini GPS sensor. The lessons should cover: Setting up and using the ESP32 with the IMU6050 and GPS sensor. Collecting data from these sensors and displaying it in real-time on a website. Storing this data for later use. The lessons should be hands-on, with clear step-by-step guidance and practical examples. The ideal candidate should have experience in the mentioned components, as well as real-time data projects.

I'm looking for an Excel expert to help me consolidate information from individual staff timesheets into a master view. Key tasks: - Total hours worked and all related hours into a comprehensive weekly view. - Utilizing separate Excel files for each employee's timesheet. - Designing the master view in a standard table format with appropriate graphical representations (charts). Ideal candidates will be proficient in Excel, have experience with data consolidation and analysis, and be able to create clear and informative visual representations of data. Please utilize bar charts for graphical representations.

I'm seeking a professional to create a project management spreadsheet for a small team of 1-5 users. The spreadsheet needs to have specific functionalities: - Task assignment and tracking:...management spreadsheet for a small team of 1-5 users. The spreadsheet needs to have specific functionalities: - Task assignment and tracking: The ability to allocate tasks to team members and monitor their progress. - Timeline and milestones: A clear representation of project timelines and key milestones. - Googlesheets -Top overview of the days todo Ideal candidates should be proficient in Excel or Google Sheets, with a strong understanding of project management principles. Experience in creating similar spreadsheets is highly desirable. Please include examples of your previous work in...

I require a statistics expert to analyze some survey data using descriptive statistics. The analysis should be done in Excel. Ideal Skills and Experience: - Proficient in Excel for data analysis - Strong understanding of descriptive statistics - Experience with survey data analysis - Ability to present findings in a clear, understandable manner