Projek mini excelpráce
...search results: - Store name and address - Contact information - Website (if any) - Contact person's name (if available) The towns / cities names will be provided in an Excel sheet, and the freelancer will need to: Search for auto parts stores in each town via Google. Scrape the relevant data (store name, contact number, address, website). Compile and organize the scraped data into an Excel file. Requirements: Experience with web scraping and the use of tools like Selenium, BeautifulSoup, or Scrapy. Experience using Google Custom Search API or SerpApi to extract structured results from Google searches. Proficiency with Excel (to organize and output the data in a structured format). Ability to work with proxy services and Captcha solving if needed, to avoi...
As a building company, I need a comprehensive Excel spreadsheet for quoting purposes. The spreadsheet should cater to both commercial and residential buildings and should include all necessary aspects for quoting. Key Features: - Inclusive of all trades: plumbing, electrical, roofing, tiling, etc. - Incorporation of all structural purchases - Detailed breakdown of individual wages with hourly rates - Everything needed to quote on commercial and residential buildings in Australia - All Excel workings need to be in metric measurements - A single, unified template for all quotes Ideal Skills and Experience: - Proficiency in Excel - Understanding of building trades and associated costs - Familiarity with commercial and residential building processes in Australia - Expe...
Busco un profesional en Power BI para desarrollar un reporte visual e interactivo basado en un archivo Excel con varias hojas (denominadas "Lam") que ya contienen datos calculados. Requerimientos: Conectar y cargar el archivo Excel. Crear gráficos interactivos (barras, líneas, tablas) para mostrar acreditaciones, canjes, saldos y porcentajes de redención. Incluir filtros y segmentaciones para explorar datos por hoja, fechas o miembros. Diseñar un tablero visualmente atractivo y fácil de usar. Entregar el archivo Power BI (.pbix) listo para usar. Adjunto el archivo en excel y un ejemplo hecho en power bi
I need assistance converting an Excel calculator into a calculator that I can embed in a Word document, so that when the word document is turned into a PDF the calculator still works and is editable by the user. This could be done using Python to create the calculator. I can see two scenarios to achieve this:- 1 The Word document will be regularly updated , so the calculator should be embedded in the word document. 2 The calculator could be embedded in a separate pdf and the word pdf and calculator pdf merged each time the word document is updated. Requirements: - Integrate an editable calculator into the PDF that performs basic arithmetic Ideal Skills: - Python - Ability to create interactive elements within a PDF - Attention to detail and ability to follow instructions accura...
I need a professional who can create an Excel report in a dashboard format tracking the performance of our management. The report should encompass: - KPIs (Key Performance Indicators) - Financial performance - Employee productivity Ideal candidates for this project should be proficient in Excel, with experience in dashboard creation and performance reporting. Strong analytical skills and understanding of management metrics will be a plus.
...of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate performance monitoring and decision-making. Technical Requirements: Design the system to be flexible and capable of integrating with existing devices (such as RFID readers) while supporting future expansions. Ensure the system interface is user-friendly for non-technical users. Include an activity log to track and document any modifications made to the data. Additional Notes: The system is intended for managing the inventory of a retail store's warehouse and focuses on simplifying the stock management process. The system does not need to rely on a specific programming language or platform; using Excel files as a working platform is acceptable as long as t...
...of the current inventory and overall stock value. Exportable reports (e.g., in Excel or PDF format) to facilitate performance monitoring and decision-making. Technical Requirements: Design the system to be flexible and capable of integrating with existing devices (such as RFID readers) while supporting future expansions. Ensure the system interface is user-friendly for non-technical users. Include an activity log to track and document any modifications made to the data. Additional Notes: The system is intended for managing the inventory of a retail store's warehouse and focuses on simplifying the stock management process. The system does not need to rely on a specific programming language or platform; using Excel files as a working platform is acceptable as long as t...
I'm looking for a detail-oriented and resourceful individual to find high-quality products for our dropshipping store specializing in pet supplies (dog, cat, and small pets). The ideal candidate will search for trending, affordable, and reliable products on AliExpress, collect relevant product data, and organize it in an Excel spreadsheet for easy reference.
I'm in need of a dynamic excel sheet that will assist in managing the daily and weekly activities of our vehicles. This sheet should be able to track various aspects such as: - Maintenance schedules: Keep tabs on when each vehicle is due for maintenance. - Fuel usage: Monitor fuel consumption over time to identify any discrepancies or patterns. - Trip logs: Record details of each trip for future reference. The ideal freelancer for this project should be highly proficient in Excel and have experience in creating dynamic, interactive spreadsheets. They should also have an understanding of vehicle operations and be able to incorporate relevant features into the planner. Key features of this planner should include: - Automated scheduling: The sheet should be able to auto...
I require an Excel expert who can help me create complex data lookup and reference formulas. Specifically, I need assistance with VLOOKUP and HLOOKUP.
...one-off gig, but a long-term collaboration aimed at scaling the store. Key Responsibilities: - Develop fully functional niche eCommerce sites on OpenCart, alongside a comprehensive master site. - Initial upload of 100 products, inclusive of category creation and filter setup. - Quarterly addition of a minimum of 300 products, with a target of 10,000 by year-end. I will provide all product data in Excel format and URL to images. - Implement necessary APIs for automated order fulfillment. - Regular site maintenance, including yearly opencart CMS and theme upgrades. - Gradually incorporate SEO support and an affiliate marketing module, and collaborate with influencers over time. Ideal Candidate: - An individual (not an agency or company) - Proven expertise in OpenCart, with a port...
I'm looking for someone to help me merge several files, including Excel, CSV, and one HTML table, into a single unified Excel file. The files contain various investor types and their information. Key Requirements: - Combine all information from the original files into the new table. - Prioritize the organization of the table by investor names. - Categorize the unified table by investor type. Ideal Skills and Experience: - Proficient in Excel with strong data handling skills. - Experience in data consolidation from various file types. - Ability to categorize and format data in a logical manner. Please note, I want all the information from the original files to be included in the new table. The final product should be an easy-to-navigate table that is organized ...
...to store, edit, view BOM. - Functionality to filter data based on all possible fields with multi level sorting. Allow full flexibility for user to filter and sort data based on multiple fields. - Report generator to generate all types of reports. User selects multiple fields and multiple sorting options to generate reports to track consumption and show inventory levels. - Import/export data to Excel format - Backup/restore database - Page to add/view/delete suppliers - Settings page to manage various options and create look up tables for various fields. - Data display must use pagination - Access & activity logging Your responsibilities will include: - Designing and implementing the web interface - Ensuring the system is robust and able to handle a large amount of data - Ma...
I need a detail-oriented virtual assistant to help with data entry tasks. The primary responsibilities will include: - Inputting data from a specific website into spreadsheets. Ideal skills and experience: - Proficiency in using spreadsheets (Excel, Google Sheets) - Previous experience in data entry - Strong attention to detail - Ability to work independently and meet deadlines.
...experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to b...
...wiring plan with proper lighting and outlet placements. - HVAC system design for optimal air circulation and comfort. Detailed Space Requirements: Ground Floor (2,500 sq. ft.): - Customer Engagement Area: - Customer Lounge: 300 sq. ft. - Cafe: 150 sq. ft. - Vehicle Display Area: Spacious and prominently placed. - Service & Support Areas: - 2 Detailing Rooms: 200 sq. ft. each - Mini Salon: 80 sq. ft. - Studio Room: 100 sq. ft. - RO Treatment Plant: Visible to customers. - Store Room: 100 sq. ft. - Accessory & Alloy Wheel Racks. - Washroom: 50 sq. ft. (for customer and staff). First Floor (750 sq. ft.): - Office Room for administrative tasks. - Working Cabin for 5-6 team members. - Store Room for inventory. - Studio Room for 2 team me...
...who can assist me primarily with creating engaging presentations in PowerPoint. Your role will also encompass data analysis in Excel and document formatting in Word. Key Responsibilities: - Crafting compelling PowerPoint presentations, inclusive of custom graphics and charts, animations and transitions, and overall template design and layout. - Conducting thorough data analysis in Excel. - Formatting documents in Word to a professional standard. Additionally, I require assistance in boosting my Instagram followers and likes organically, without risking a ban on the platform. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (PowerPoint, Excel, Word). - Exceptional graphic design skills, particularly for creating PowerPoint presentations. - Exp...
...experience. Login & Registration Validation: Implement mobile login with OTP and email confirmation. Streamline the registration process for a smoother user experience. Admin Invoice Correction: Resolve gaps in invoice details. Make the delivery address mandatory during order placement. Order Fulfillment Text: Change "Order Fulfill" text to "Dispatched" in the admin panel. Order Download Excel Sheet: Add fields like SKU, product name, contact details, coupon codes, and shipping address. Display transaction ID from the payment gateway in invoices. Order History: Enable date-wise order history in both admin and user panels. Email/Text Notifications: Set up email SMTP and text notifications for order updates. Review Module: Validate reviews to b...
I'm looking for a proficient software developer to create a Desktop application for managing our company's incoming and outgoing documentation. This project aims to transition our current system, which relies heavily on MS Excel and VS Code, to a more streamlined and efficient software solution. Key Requirements: - The software should be a desktop application, specifically designed for Windows operating system. - It should incorporate functionalities for automated data entry, and reporting and analytics. - Ideally, the software will transform our current manual processes into a fully automated system, significantly improving our operational efficiency. Skills and Experience: - Proficiency in desktop application development, with a strong focus on Windows systems. - Exten...
I'm seeking a skilled ASP.NET developer to create a simple one-page application for report display. The design should be modern and minimalist. Key features of this project include: - **Report Grid**: The grid should include sortable columns, pagination, and search functionality. - **Export Functionality**: The application should support exporting reports in Excel and PDF formats. - **Design**: A clean, modern and minimalist design is crucial for this project. I will handle the ADO connection string and SQL command creation. Proficiency in ASP.NET and web form development is required. Experience with creating interactive report displays will be a significant advantage.
I'm seeking an experienced MS Excel and Word instructor for live one-on-one sessions. Here’s a curriculum to teach the basics of Microsoft Excel and Word, structured over four weeks. Each week focuses on progressively building skills. This plan assumes 1–2 hours of daily study. after 4 weeks training , there has to be another 1 month of hand holding. Week 1: Introduction to Excel and Word** ### **Day 1: Getting Started with Microsoft Office** - Overview of Microsoft Excel and Word. - Installing/setting up Microsoft Office on your computer. - Familiarize yourself with the Ribbon, Toolbar, and Navigation. ### **Day 2: Basic Navigation and Layout** #### Excel: - Opening, saving, and closing Excel files. - Understanding rows, colu...
I am looking for an experienced Quantity Surveyor for a commercial construction project. The role will require a commitment of at least two months and will involve: - Cost Estimation: Accurately est...construction project. The role will require a commitment of at least two months and will involve: - Cost Estimation: Accurately estimating costs for various project components. - Contract Management: Overseeing contracts to ensure compliance and manage any necessary amendments. - Material Quantity Take-Off: Determining the required quantities of materials for the project. Proficiency in Microsoft Excel is a must, as this will be the primary tool for cost analysis and projections. Experience in commercial construction is essential, while familiarity with AutoCAD or Procore would be adv...
...engaging social media graphics for the Apes Of TON project. The primary focus will be on appealing to our target audience - crypto enthusiasts, airdrop farmers, and general public. You will be part of core team of the project and will have potential to convert this role as full-employment if you perform outstanding. Meanwhile the project launch it's mini-app till the launch of our token $APES in exchanges you will be earning $APES token allocation in mini-app and will also have potential to earn more rewards during the progress of project. X Page of Apes Of TON: Note: this is only volunteer role at the moment, if you willing to invest your skills in the project you are welcome, you will be rewarded gradually with growth of project. Key Responsibilities: - Design c...
I'm looking for a freelancer who can create a mini Android app for me. This app will utilize my integrated supervision grid for a test project. Key Features: - The primary functionality of the app is real-time data monitoring. - The app should take 'User inputs' as its data source for sending notifications. User Interface: - I envision a simple and minimalistic user interface for the app. Ideal Skills and Experience: - Proficiency in Android app development. - Experience with real-time data monitoring apps. - Ability to create simple and minimalistic user interfaces. - Good understanding of handling user inputs for notifications.
I'm looking for a comprehensive list of church emails across the United States. The list should be segmented by size of congregation, denomination, and state. Ideal Skills and Experience: - Proficient in data collection and organization - Familiar with Google Sheets and Excel - Prior experience in generating email lists - Ability to send emails on my behalf This project involves: - Providing a segmented list of church emails - Sending an email to all contacts Please note that the source of email collection was not specified. However, the following sources are encouraged: - Church websites - Public directories - Social media profiles
...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the
I'm in need of an Excel expert who can create a mathematical function for me. Key Requirements: - The function should focus on financial calculations, specifically for budgeting and forecasting. - I need it to assist me in planning and managing my finances effectively. Ideal Skills: - Proficiency in Excel, particularly in creating complex functions. - Strong background in financial mathematics. - Experience in budgeting and forecasting. Please include examples of similar projects you've completed in your proposal.
I'm looking for an experienced freelancer who can create a tutorial video for Microsoft Excel using screen recording techniques. Key Requirements: - Proficiency in Microsoft Excel is a must. - Experience in creating screen recording tutorial videos. - Ability to convey complex information simply and clearly. The final deliverable should be a comprehensive, easy-to-follow, and engaging tutorial video that covers various aspects of Microsoft Excel.
I'm in need of a detailed construction estimate in Excel for a residential/commercial new build. The estimate should encompass all aspects of the project costs, including: - Material costs - Labor costs - Permit fees - Subcontractors - Suppliers - Payments The ideal freelancer for this project should have extensive experience in construction estimating and Excel, with a keen understanding of both residential and commercial construction costs. Please provide samples of similar work you've done.
I've converted my inventory book into an Excel spreadsheet. I'm looking for a freelancer who can upgrade this into a more sophisticated, user-friendly inventory system, with specific features and improvements. Key Features: - Automated stock updates: This will assist in keeping track of the inventory in real-time, without needing manual input. - Real-time analytics: I want to have insights and statistics about my inventory at my fingertips. - User access controls: I need to manage who can see and interact with different parts of the inventory. Interface Preference: - The upgraded system should have a spreadsheet-like interface. I am comfortable with Excel, and a familiar interface would make it easier for me to adapt to the new system. Areas for Improvement: - Th...
I'm looking for a freelancer to convert a product catalog PDF into a Microsoft Excel file. The task involves: - Extracting product names, prices, and details - Listing products multiple times for different sizes or variations (2-4 sizes) The catalog contains 700-800 products. Please note: - Only text details need to be extracted, no images. - Different sizes or variations are listed as separate entries in the PDF. - Each product should be placed on a new row in the Excel file. This is a straightforward data entry task. Accuracy and timely delivery are essential.
...studys to strengthen credibility and relevance must contain visble link and rel NO FOLLOW . References do not count towards to characters article lenght. Every article must to be linked with Anchor text to MINIMUM 2 Product from internal shop. Every article must to link to MINIMUM 2 outside DO FOLLOW links from list provided to you. Publishing schedule need to be listed in an Excel sheet on FOUR columns: WE NEED DATA IN EXCEL TO DO SEO. IT IS ANOTHER ESSENTIAL PART THUS OTHERPEOPLE WILL IMPROVE TEXTES PROVIDED BY YOU AFTER YOU FINISH YOUR QUEST. ID / URL / Anchor /Date Number of article from 1 to 52 Exact URL adress to article. Anchor text / Keyword. Prompting AI tools like ChatGPT are encouraged for content generation. Ask us about access to MISTRAL AI and our interna...
I need an experienced Excel professional to adjust the margins of my Excel file. The goal is to fit the content properly for printing. The file primarily contains text and numbers. Ultimately, I want the margins set up so that they automatically fit the content. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience with formatting for print - Attention to detail
I'm seeking an expert in Microsoft products and Excel to build a comprehensive Real Estate Financial Modeling system. The model should cater to detailed property analysis, investment forecasting, and cash flow management, among other features. Key System Features: - In-depth property evaluation - Predicting investment returns - Managing cash flow - Implementing a Tier-1, Tier-2, Tier-3 Waterfall Modeling - Structuring a Joint Venture (JV) within the model - Accounting for disproportionate returns - Applying an intricate waterfall logic and structure - Summarizing distributions and cash flow The top priorities for this project are detailed property analysis, investment forecasting, and cash flow management. The system should be capable of integrating with various data sources...
I'm seeking an experienced web developer to create a responsive website for me. This platform will be used for field data collection, specifically meter readings. The site should be capable of generating various reports from the collected data, with features that allow these reports to be downloaded in Excel and PDF formats. Furthermore, the site needs to facilitate the sharing of reports and notifications via Email, WhatsApp, and SMS. The project specifics include: - User Interface: The site will have a form-based interface for data entry. The interface needs to be user-friendly and efficient, allowing easy input of meter reading data in the field. - Reporting: The platform needs to generate both summary and detailed reports from the submitted data. These reports should be e...
I need assistance with combining two Excel sheets. The task is to transfer values from column 2 of the source sheet to column 2 of sheet A. The values are a mix of numbers and text, and they are jumbled in the source sheet. Key Tasks: - Discussion on handling duplicate entries in column 2 of the source sheet - Converting all values to text in the destination sheet - Discussion on how to manage blank or missing values in column 2 of the source sheet Ideal Skills and Experience: - Proficiency in Excel - Excellent data management skills - Ability to discuss and devise solutions for data handling issues Please note that certain aspects of the project, such as how to handle duplicates and missing values, will require discussion.
I need assistance with combining two Excel sheets. The task is to transfer values from column 2 of the source sheet to column 2 of sheet A. The values are a mix of numbers and text, and they are jumbled in the source sheet. Key Tasks: - Discussion on handling duplicate entries in column 2 of the source sheet - Converting all values to text in the destination sheet - Discussion on how to manage blank or missing values in column 2 of the source sheet Ideal Skills and Experience: - Proficiency in Excel - Excellent data management skills - Ability to discuss and devise solutions for data handling issues Please note that certain aspects of the project, such as how to handle duplicates and missing values, will require discussion.
I have two Excel sheets, A & B. My primary requirement is to delete all the email addresses from Sheet A that are not in Sheet B, along with the entire corresponding row. The ideal freelancer for this project should have: - Strong proficiency in Excel - Experience with data manipulation and cleanup - Attention to detail Note: Sheet A's headers can be adjusted, but those of Sheet B must remain unchanged.
...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the
I'm in need of two figures and one table for my academic Overview: The client requires two figures and one table for an academic paper, adhering to a traditional academic style with black, white, and shades of grey. These figures represent Proactive Pathway and Reactive Pathway, with distinctions in their design content. The deliverables must be hig...figures. Refer back to the original drafts and comments provided for specific adjustments. Present two drafts (one for each figure) in the next update. Ideal skills and experience for the job: - Proficiency in creating academic figures and tables - Experience with statistical, comparative and categorical data - Ability to create both diagrams and illustrations - Proficient in using software such as Excel, R, and Adobe Illustrato...
I need speed and experience to converting a set of PDF files into Excel. The data includes everything as is ( text, tables, and image) - Accuracy of conversion. You should have experience in data conversion with a keen eye for detail and precision, and be able to maintain the original layout of the PDF files in the Excel files.
I need an Excel file that generates a leave calendar for all months, which incorporates a master list of employees and teams. This file should be fully configurable and able to be exported into a markdown format for easy publishing on Confluence or a wiki. Key Features: - The leave calendar should allow for customizable leave types. - The master list of employees and teams will need to be managed through manual data input. Ideal Skills: - Advanced Excel proficiency, particularly in creating dynamic and user-friendly spreadsheets. - Experience with leave tracking systems will be a plus. - Familiarity with Confluence or similar platforms for markdown export. Please ensure the final product is intuitive and easy to use, even for non-technical team members.
I am looking for a professional who can develop a detailed financial model for expense planning. The primary focus will be on forecasting our expenses accurately to help guide our future spending and investment decisions. Ideal Skills and Experience: - Expertise in financial modeling and forecasting - Strong analytical and statistical skills - Experience in expense planning - Proficiency in Excel or other financial modeling software - Ability to present complex financial data in a clear and understandable manner. Please note that the project scope may involve analyzing various types of expenses, so experience with operational expenses, capital expenditures, and fixed vs variable costs could be beneficial.
I'm looking for a skilled econometrician to build forecasts for key macro-economic indicators in Saudi Arabia. The primary purpose of these forecasts is for policy making. The indicators to be forecasted include: - GDP growth - Private sector growth - Inflation - Credit to private sector growth - Money supply growth - Unemployment The preferred method for this p...is already available and posted online, so data collection is not necessary. Ideal skills and experience for this job include: - Extensive knowledge and experience in time-series econometrics, specifically with the ARDL method - Strong understanding of macro-economic indicators and oil dependent economies like GCC - Proficiency in econometric software - Ability to present the models in Excel format ...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I have an autocad in pdf format with gps co-ordinates I want gps co-ordinates to mention in excel sheet
I have a collection of handwritten notes that need to be transcribed into an Excel spreadsheet. The data entry should be thorough and capture all text and figures from the original notes. Ideal Skills and Experience: - Proficient in Excel - Excellent attention to detail - Ability to transcribe handwritten notes accurately - Past experience in data entry from handwritten notes I expect the entered data to be in an organized and easy to navigate Excel spreadsheet. Please be prepared to commit to a project that requires patience and meticulousness.
I'm looking for a professional who can assist me in co...web scraping, and API integration. The ideal candidate should be flexible and able to adapt to different data collection methods as per project requirements. - Prior experience in alternative data collection methods will be beneficial. - The ability to think creatively and find unique data sources is a plus. Furthermore, the format of the data collection will be flexible, not limited to CSV, Excel, or Database formats. - Knowledge of various data formats and the ability to work with different data types is essential. - Proficiency in data manipulation and software tools for data collection will be highly valued. Please note that the specifics of the data collection methods and formatting will be discussed during the b...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
