How to summarize data in excel using pivot table jobs
...yahoo data scraper is required to retrieve data and place it into a MsAccess database that runs on a Windows Computer. Set up the scraping environment: Write a script to scrape Yahoo Finance: Use the requests library to fetch the HTML content of the Yahoo Finance page, and BeautifulSoup to parse and extract the desired data. Extract the relevant data from the page Connect to Microsoft Access database (on a Windows Computer) Establish a connection to the Access database. Insert the scraped data into the Access database: Use SQL commands to insert the data into the MsAccess Access table. Automate the scraping process: Set up a scheduling tool like Windows Task Scheduler to ru...
...looking for a highly skilled Personal Assistant to support me in a wide range of tasks, including business operations, marketing, research, data management, and administrative work. You should be organized, detail-oriented, and proactive, with a strong ability to handle multiple responsibilities efficiently. Key Responsibilities: - Administrative Support: Manage schedules, emails, travel arrangements, and other organizational tasks. - Marketing Assistance: Help with digital marketing tasks, content creation, market research, and campaign coordination. - Business & Research Support: Conduct research, prepare reports, and analyze business or industry trends. - Data & Excel Work: Organize and manipulate data in Excel, ...
I'm looking for an expert web developer to create a comprehensive portfolio website for my business. The site should be engaging, user-friendly, and professionally designed to effectively showcase our services and accomplishments. Key requirements include: - A well-structured "About Us" section to provide insight into our business and team. - An informative "Services Offered" section, detailing what we bring to the table. - A convincing "Client Testimonials" section, which will help build trust with our potential customers. Ideal skills for this job include proficiency in web design and development, experience with portfolio websites, and a good understanding of e-commerce site principles. A knack for creating ...
I'm looking for an experienced AWS professional to deploy my MERN stack project which utilizes microservices on AWS, specifically using Beanstalk and S3. The project involves several microservices, including Authentication, Clients, Transcription, and Chat. The deployment has to happen from my computer as I also want to learn the process. Key Responsibilities: - Deploy the MERN project on AWS Beanstalk and S3 - Ensure smooth functioning of all microservices Ideal Skills: - Proven experience with AWS Beanstalk and S3 - Proficiency in deploying MERN stack applications - Familiarity with microservices architecture - Experience with setting up persistent storage on AWS Please note I am a beginner and i am learning development. I want to unders...
...Android and iOS that allows users to engage in live-streamed game challenges, such as chess, card games, and dominoes. Users can place monetary bets, and winnings are distributed as follows: 40% to the winner 10% to the loser as a consolation prize 50% to the app 2. Core Features: A. Games & Live Streaming Support for games like chess, card games, dominoes, and more. Live streaming system within the app, allowing users to play in real-time. Options to create private and public game rooms. B. Betting System & Financial Distribution Before starting a challenge, each player deposits an amount as a participation fee. The total amount is collected in an in-app wallet. After the game ends, the winnings...
I'm looking for a freelancer who can convert my Word documents (DOCX) to PDF. The job does not involve editing, extracting, or adding specific elements like images, hyperlinks, or a table of contents. It simply requires a reliable professional who can handle this straightforward task. Ideal skills for this job include: - Proficiency in Microsoft Word and PDF conversion software - Detail-oriented - Able to meet deadlines
I'm seeking an expert in customer service queue management systems. You will be helping me solve queuing question. Ideal skills and experience for the job include: - Excel - Proven track record of improving queue efficiency - Strong problem-solving skills - Excellent communication skills to explain complex concepts in a simple way
For a shared Excel file on Sharepoint, need two scripts (or a way to do the following): 1. On opening the Excel file, hide any row in which all dates in the row are more than 7 days from the current date. 2. On opening the file, any cell that has a date with text in bold and the date is today or before, will have the cell background turn white and the cell text turn red.
...showing the day in a life of three different characters using technology. No sound needed as someone will be narrarating these in person. We just want to be able to show the actions happening in a compelling way with animation. I will provide relevant contextual screenshots or videos of what should be shown on any computer screens or in any specific office space. Our timeline is less than a week to get this project done. Here is the script for context on timing: (Storyboard can be provided if needed for shot by shot, what should show.) Information Worker: Alex It's the evening, and Alex is home planning his workday for tomorrow. Using Copilot, he summarizes his tasks and meetings. He doesn't normally plan to...
I am looking for draftsman to complete some house plans with CAD and dimensions for the attached excel sheet. Please get in contact of you have any queries Regards
...experienced Excel professional to create a 5-tab spreadsheet based on a study I have. (Toddler Parameters, Toddler Budget, Infant Parameters, Infant Budget, Total Budget tabs) - The first two tabs will be for data input and analysis results, respectively. Information for the parameters are found on the study, (Total staff, salary, total students, overtime, ) parameters should include all costs and revenues. - Text descriptions will be the primary parameters to be plugged into the spreadsheet. - The spreadsheet should feature automated calculations and data validation to ensure accuracy and ease of use. Categorys in the toddler and infant budget tabs should be label by months (Jan - Dec) screenshot of examples of what it should look li...
I need help modifying an Excel spreadsheet to ensure names and addresses are formatted correctly for UPS shipping software. This project mainly involves changes to the layout and overall formatting of the spreadsheet. See attached files from Unishippers as to format needed and spreadsheet that needs to be changed
I'm looking for a skilled data scientist to train Bert based on text classification using a bulk of PDF documents. Key Responsibilities: - Provide required coding to train Bert - Write codes to execute a series of textual analysis (e.g., sentiment analysis, specific sentence identification) - Model hyperparameters sets - performance analysis (including ensuring fine tuning. - Evaluation of trained Bert and baseline models Ideal Skills: - Proficiency in advanced machine learning - Strong statistical skills - Prior experience with training Bert
I'm looking for a qualified professional who can materialize 8 attached plans onto the original DWG plan. The end deliverable should be a meticulously prepared presentation in DWG format with: - A legend on each drawing detailing room names, dimensions and material specifications. - The specific drawing title blocks that I will provide. - A comprehensive summary table with quantities and surface areas for each drawing. Please note, the work must be professional and meticulous. I only accept qualified individuals. Thank you.
I need a comprehensive report based on two tasks: 1. A detailed analysis of Qlik's e-book "Turn your Excel Reports into Stunning Dashboards." This should include what you learned and insights on data visualization, dashboard design, and excel integration. 2. An exploration of a business application from the Microstrategy website. You'll need to choose an industry, select a business application, and write a report on the insights gained from the associated video. The final report should be 4-5 pages long, formatted in APA style, and include at least three references. Ideal candidates will have strong skills in data analysis, report writing, and familiarity with APA formatting. Experience with Qlik and Microstrategy is ...
Request for Assistance in Creating Interactive Filtered Tables Using VBA in Excel I am reaching out to seek your expertise in creating an interactive Excel model that includes dropdown boxes and filtered tables using VBA. The goal is to replicate a system where selecting an item from a dropdown box (e.g., a country) automatically filters a table to display relevant data. Key Requirements: Dropdown Boxes (Combo Boxes): Create dropdown boxes that allow users to select specific criteria (e.g., cities, statuses). The dropdown should be populated with a predefined list of items. Interactive Filtering: Upon selecting an item from the dropdown, the corresponding table should automatically filte...
I need someone to create a quick stock summary sheet. I will provide an Excel file with the 2024 sales data, along with an example format. Your task is to locate the corresponding buy data from the 2020-2022 period using the transaction records I provide and complete the final 2024 Excel sheet based on the given format. Do not use AI please. I will send the buy data ,once you are selected
I am in need of an expert in operations research and mathematical modeling who can develop a multi-objective, multi-period location-routing model, based on several critical assumptions like heterogeneous vehicle and differents types of products. Ideal Skills: - Proficiency in developing complex models for multi-objective optimization. - Strong understanding of both location and routing optimization. - Proficiency in GAMS programming. For this task, I expect the following deliverables: 1. Review the proposed model and adjust the formulation as needed to ensure valid results. 2. Refine the mathematical model in GAMS and validate it using test instances in Excel. 3. Implement the multi-objective weighting method to sol...
I'm looking for an experienced UiPath developer to create a game bot for me. The bot will be used to automate actions in a math-based game. The game bot should: - Automate in-game actions - Solve math problems Ideal candidate skills: - Proficiency with UiPath - Game bot development experience - Skills in automating complex tasks Please provide examples of previous work, particularly any related to game bot development, in your bid.
I'm looking for a skilled Excel expert to create a comprehensive tracking sheet for my daily store visits. The sheet should have a tab for each day, and a master tab that compiles all customer information and interaction feedback. Requirements: - Track customer interactions during each store visit. - Record specific details about each customer interaction, primarily comments and feedback. - Categorize feedback into follow-up items. Ideal Skills: - Proficiency in Excel. - Experience with data tracking and analysis. - Ability to create user-friendly and organized spreadsheets.
I need to make next VR content for multy player in Unity or other suggested program as following covering as much swimming movies - Breaststroke - Butterfly -Backstroke - Fron Crawl - Trudgen - Butterfly - Sidestroke • Virtual swimmer - to swim in the standard way (the correct way) which means to move his arms, head and legs in the most accurate and correct way . • Each student wearing the headset can see the virtual swimmer and follow him ( the student will be laying on a table and moving his arms as swimming to give him the feeling like he is in the water and swimming. • The teacher can control the movement of the virtual trainer for all students at same time, he can pause the trainer at certain point or...
I'm looking for an Excel expert who can create an intuitive spreadsheet for tracking job preparation based on asset availability. Key features: - The spreadsheet should track various statuses such as: - Not Started - In Progress - Completed - Asset not available - Mobilized - Ready for mobilization - Color-coded cells indicating the status of job preparation and mobilization. Ideal skills: - Proficiency in Excel - Experience with project tracking tools - Good understanding of color-coding for status tracking With this tool, I'll be able to easily monitor the progress and prepare accordingly.
I am looking to develop a website for hosting my VR content built in Unity. The website should allow users to sign in, access their VR content based on their subscriptions, and provide detailed tracking of time spent on each piece of content. Here are the key features I need for the website: ________________________________________ 1. User Login System • A login page where users can register and authenticate using their credentials (email/password, or a preferred method). • Users should have their own personal account where they can manage their subscriptions and content access. • Admin panel to manage user access, subscriptions, and content. ________________________________________ 2. Subscription Management • Users should be a...
New CI project or similar framework to manage some reporting requirements. We are currently doing the process manually but would like to automate. 1. Attach to an existing database and display a main grid of records 2. Create additional tables in DB as needed to accomplish tasks 3. Each record will have several actions that can be done to each i. update status ii. Attach documents iii. view details iv. update 4. System will also have ability to run reports that will export into excel as needed. 5. We will have several other functions i. mana...
I have 2 lists of English words (totaling around 200 words) that need to be converted into MP3 audio files. The words should also be translated into Arabic. Key Requirements: - Provide an intermediate work just to check that our mutual understanding is correct Additional Information: - A female voice should be used for female-specific words, and a male voice for all other words. - Use a standard pronunciation - We will discuss in detail how to manage the verbs
...professional to support my CRM and Operations team from Monday to Friday, 9-5. The role primarily revolves around using ConnexOne, SQL, PowerBI, and Python, alongside some basic administrative tasks. Key Responsibilities: - Primarily using ConnexOne to assist with various CRM tasks - Utilizing SQL for querying, setting up campaigns, and loading data - Equal focus on setting up campaigns, loading data, and Python scripting - Leveraging PowerBI for data visualization and reporting Ideal Skills and Experience: - Proficient in ConnexOne with prior experience in a CRM role - Strong SQL skills for data manipulation and campaign setup - Familiarity with Python for basic scripting tasks - Competent in usin...
We are looking for a fresher to join our startup as an Inventory Management Assistant. This role is perfect for someone who is eager to learn about inventory control, stock management, and supply chain processes in the fashion and apparel industry. As a growing garments brand, we need a dedicated individual who can help us keep track of stock, manage entries, and assist with order fulfillment. Key Responsibilities: ✅ Inventory Tracking & Management: Maintain accurate stock levels, update inventory records, and ensure real-time tracking of available products. ✅ Amazon & Meesho Listings: Add and update inventory on Amazon, Meesho, and other e-commerce platforms to ensure stock accuracy. ✅ Stock Entry & Updates: Regularly update stock counts in ...
I'm seeking an Excel Online expert to help me set up individual spreadsheets for each of my collaborators, linked to a global billing spreadsheet. Key Requirements: - Create separate, individual Microsoft Excel Online spreadsheets for each collaborator. - Each spreadsheet should have 'Edit permissions' for the respective collaborator, allowing them to input their own data. - The data from the global billing spreadsheet should be reflected in the individual sheets automatically and in real-time, without the collaborator having access to the global spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel Online. - Experience with setting up complex spreadsheet systems. - Knowledge in...
Data gathered to an Excel file. Data gather to excel file
Client has prvided me images of the parts and assembly to be done in Solidworks.
I'm in need of an Excel sheet specifically designed for calculating construction costs. The sheet should encompass: - Material Costs - Labor Costs - Total Project Cost In addition, I'd like the sheet to incorporate specific Excel functions and formulas such as: - Sum and Averages - Conditional Formatting Ideal candidates for this project should have a strong background in Excel, particularly with creating complex sheets for cost analysis. Experience in the construction industry would be a plus. Please bid with a brief overview of your relevant experience and examples of similar projects you've completed.
If you know how to use it, then I have a job for you
...multi-user app (one requires an administrator and other users) that acts as an exam preparation site for multiple courses. Frameworks to be used These are the mandatory frameworks on which the project has to be built. Flask for application back-end Jinja2 templating, HTML, CSS and Bootstraps for application front-end SQLite for database (No other database is permitted) Note: All demos should be possible on your local machine. Roles The platform will have two roles: Admin - root access - It is the superuser of the app and requires no registration Admin is also known as the quiz master There is only one admin to this application The administrator login redirects to the quiz master/admin dashboard The administrator will manage all the other users The admi...
I'm a university student seeking a mentor to help me navigate my data module. The focus is primarily on using Excel functions to sort numerical data. Key Responsibilities: - Interpret and explain the tutorials provided - Help me understand and apply Excel functions to sort numerical data - Provide guidance on data analysis techniques Ideal Skills: - Proficient in Excel - Strong understanding of data analysis - Previous experience tutoring or mentoring university students Looking forward to your bids.
...room for ongoing updates and scalability. The model should also support reworking and enhancement of an existing model to better suit the current requirements. Scope of Work: National Cattle Export Overview: Volume & Value of Cattle Exports: Forecasted data on national export volumes, values, and growth trends. Key Markets & Export Destinations: Breakdown of export destinations, pricing dynamics, and trends in demand. Government Policies & Trade Agreements: Consideration of how national policies, regulations, and trade agreements impact exports. Exporter-Specific Financial Modeling: Exporters' Profiles: Creation of a detailed model for each exporter, incorporating data on size, volume of exports, customer base, and operational char...
I'm in need of a professional who can assist in improving my handbook significantly. This includes adding new chapters, formatting the content to ensure consistent font styles and proper alignment and spacing, and creating a table of contents that includes only chapter titles. The first run through of edits has been completed and I'm looking for someone to add a few things and put on the finishing touches to publish to the company. Key Tasks: - Adding new chapters to the handbook - Formatting the content for consistency and proper alignment - Revising the table of contents with chapter titles only - Conducting a final review of the handbook Ideal Skills and Experience: - Strong background in editing and form...
I'm in need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior
I'm looking for an experienced Excel macro developer to create a macro that will import data from a specific TXT file on my computer and format it to match my PDF example. I currently pull the data from an IBM and it is saved on my windows computer as "AP Data." I then need to be able to open an excel workbook and run a macro that will import "AP Data" and format it so it matches the PDF example identically. All numbers in the excel worksheet after import need to be formatted as accounting so something that appears on the PDF Example as 7.50- will change to (7.50). The print area needs to match the PDF example. There are page numbers at the top ri...
I'm looking for a professional with expertise in Bartender Software. I need to create barcodes pulling from specific fields in a Master data spreadsheet. The spreadsheet is located in Egnyte and is co-edited using Microsoft Excel Online. The fields I am interested in include GTIN, Catalog Number, Lot Number, Serial Number, Expiration Date, and Quantity. This data needs to be pulled from filtered data based on a blank Allocation column (see attached spreadsheet) Ideal skills and experience for the job: - Proficiency with Bartender Software. - Experience in barcode generation and software integration. - Attention to detail to ensure accurate data pull for barcode creation. ...
I'm looking for a professional with extensive experience in Microsoft Access and data manipulation to help me combine 12 separate inventory-related queries into a single table. Key Requirements: - All 12 queries currently share the same table structure, which simplifies the merging process. - The end goal is to prepare the consolidated data for export. Ideal Skills: - Proficient in Microsoft Access - Strong background in data management and analysis - Experience with data export processes
...Features & Modules 1. User Roles & Access Control • Admin (Owner): Full control over system functions. • Staff (Employees): Can add expenses, view their reimbursements, and check vehicle file status. 2. Vehicle File Management • Ability to create a new file for each vehicle clearance using: o Chassis Number / File Number (Unique Identifier) o Client Name o Vehicle Details o Status: Pending, In Progress, Cleared o Total Expenses Incurred • Staff members can only add expenses if the file is active. • Admin has access to re-open a file in case a staff member forgot to add an expense. 3. Expense Tracking & Reimbursement • Staff members can log daily expenses for each file by selecting: o Chassis/File Numbe...
I'm seeking for a professional who can help me extract contact information from customer accounts on the website www.food-servi...for a professional who can help me extract contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting contact information from customer accounts on the website - Delivering the extracted data in an Excel spreadsheet Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail to ensure all relevant contact information is extracted - Experience with delivering data in Excel format Please provide a concise proposal detailing your experience and approach to this project. Show me scr...
I am in need of a skilled female Indian professional with expertise in Tally and Excel to assist with data entry and recording. The primary focus will be on tracking expense and income. Key Responsibilities: - Accurate data entry of expenses and income into Tally and Excel - General assistance and guidance in categorizing data Ideal Candidate: - Proficient in Tally and Excel - Excellent attention to detail - Able to provide guidance in data categorization - Female Indian professional
...looking for a professional to help me implement an email campaign aimed at real estate agents to an existing database of newly selected prospects in the South African market using MailChimp. Key Components of the Project: - The main goal of this campaign is to generate leads. - To introduce Real Estate Brilliance as the authority in realtor training in SA. - The target audience is specifically real estate agents. - I have 13 emails and 12 free guides prepared that will be used in the campaign. - Automation of 13 email campaign - 1 email per week. - FREE Guide to be sent as an immediate follow-up email when the download button is clicked. - Linking the relevant company website page to the CTA button - The Agen...
I am looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short t...looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina, South Carolina, Alabama, and Georgia. in the form of an Excel spreadsheet. All hosts are acceptable and there are no specific criteria for inclusion in the list. The ideal candidate should have experience in data mining and compiling email lists. Attention to detail is crucial to ensure that the list is accurate and up-to-date. The list should contain the following: Name, phone number, and email address, and should all be valid an...
I'm seeking a professional to rework my estimating spreadsheet. This is primarily for estimating material and labor costs. The spreadsheet should provide a detailed breakdown of costs, not just a high-level summary. Spreadsheet calculates the amount of concrete, tile, coping and plaster based off of pool dimensions. Inputs are Perimeter, water surface area, interior Surface area, distance of the equipment from the furthest edge of the pool Spreadsheet allows you to pick from a list of material that included the material cost along with a "kit" of other items that are required to complete that Piece of the project.. for example: a pool skimmer kit may include, Skimmer, PVC Pipe, PVC Fittings, Glue, and Labor hours.. All of the items in the Kit ...
I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.
I'm seeking assistance with a data entry task involving daily stock prices. Key Responsibilities: - Copy stock prices from the NSE website and Investing.com. - Paste the information accurately into an Excel file. Ideal Skills: - Proficient in Excel. - Detail-oriented to ensure data accuracy. - Familiarity with stock market terminology is a plus. Experience: - Previous data entry experience, particularly with financial data, will be highly regarded.
