I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
...conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detailed yearly overview of my business's financial health, with a focus on identifying trends and outliers, and ensuring our financial strategy is aligned with our business goals. Ideal Skills: - Advanced Excel proficiency. - Expertise in financial analysis and forecasting. - Strong analytical and problem-solving skills. - Excellent communication and reporting abilities ( need it finished by today )....
I'm looking for a talented designer who can create a brand mascot that will represent our shipping company department. Key Requirements: - Mascot Type: Animal Character - Emotion/Trait: Friendliness - Design Format: Both digital illustrations and 3D model The mascot needs to be appealing, friendly, and easily recognizable. It will be used across various digital and physical platforms to promote our services. Skills and Experience: - Proven experience in mascot design, particularly animal characters - Proficiency in both digital illustration and 3D modeling - Ability to capture and convey emotions and traits through design - Strong understanding of brand representation and appeal Your design will play a crucial role in establishing our brand identity and enhancing customer...
I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.
...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF documents fro...
Write a project on : Porter’s Five Forces: Proficiency in using Porter’s Five Forces model to assess competition within an industry.
I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and functional...
I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere el...
I need an expert to address mesh deformation problems in my 3D characters created in Blender. - The initial modeling was done in Blender. - The primary issue we are facing is mesh deformation. - The character files are in ...in FBX format. Ideal candidates should have: - Proficient experience in Blender - Expertise in character modeling and skinning - A strong background in fixing mesh deformation issues - Knowledge of FBX format and compatibility - Good communication skills to understand the project requirements and provide updates on the progress. IMPORTANT :The main issue is in the mesh called headarms ,the model has many meshes that are disabled to make it easier for you to fix the headarms mesh ,the character has a rig already but when i added the headarms mesh this mesh ...
I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.
I'm in need of a seasoned sales professional who specialises in the freight forwarding industry, particularly within Asia. Being equipped to handle general cargo is essential. The main working model will be commission or profit share based. Responsibilities: * Procure new business effectively * Handle contract negotiations proficiently Ideal candidate must possess: * Proven track record in sales within freight forwarding * Strong understanding of Asian markets * Expertise in the handling and moving of general cargo * Exceptional negotiation skills * Ability to work on a commission or profit share basis Your role will lay the foundation for the expansion of the business in the growing Asian marketplace. This is a fantastic opportunity to participate in, and profit from, the...
I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I'm looking for a skilled Python developer to help me with a scraping project. I need to extract specific product data from a website's table. Skillset: - Proficiency in Python and Scrapy - Experience in web scraping - Familiarity with handling ...and Scrapy - Experience in web scraping - Familiarity with handling web popups The website () contains a table with important product information. For each product, I need the following details scrapped: Certificate Type Certificate Number Product Type Organization Name Country Issue Date Expiry Date in addition to Product Details Brand Model Description Barcode The data should be saved in a CSV file. There are no specific rules or requirements to be followed during the scraping process.
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
TOST is an easy-to-use platform where users can get large quantitative benefits with 10 minutes of work a day. The system ensures the protection of financial data and personal information while enabling risk-free deposits and withdrawals. A deposit of only 30 USDT is required to join, and the compound interest calculation model allows users to increase their account balance with commissions earned by working daily. The purpose of team building is to increase sales and help each other if a problem arises in a WhatsApp group.
I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...
I'm in immediate need of a skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessary skil...
I am looking for a skilled designer to create a poster and matching return card for a dinner. Wording is attached. The poster size should be 8 1/2 x 5 1/2 and the attached card should be 5 1/2 x 4 1/4. Also attached are some of our previous designs which you can use for inspiration. Please create a new look for this year. Ideal skills and experience for this job include: - Proficiency in graphic design software - Experience in creating posters for formal events - Ability to work with custom sizes and formats - Strong attention to detail and an eye for design aesthetics If you think you have the skills and experience needed to create a stunning poster for my event, please submit your proposal. I look forward to seeing what you can come up with!
Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account
I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.
...Proven experience in SaaS and/or tech industry marketing - Ability to create and implement strategies that will help us grow from zero to 1000+ customers within 6 months - Proficiency in various marketing channels such as email marketing, social media advertising, and SEO optimization is a plus (though we are open to new ideas) - Understanding of marketing budgets and the ability to work with a model that has an initial budget of $1000, with 80% of all sales being reinvested into future marketing efforts If you can demonstrate past success in similar projects, and have the creativity and strategic thinking needed to help us grow, we would love to hear from you. Responsibilities: Develop and Execute Marketing Plans: Create comprehensive marketing strategies to increase brand awa...
I need a BIM modeller to ...modeller to create a detailed model from a 2D CAD file. Key Requirements: - File Format: The original 2D CAD file is in DWG format; the BIM model should be created from this file. - Level of Detail: I require a high level of detail for the BIM model. It should be at LOD 300, featuring accurate modeling and detailing with specific assemblies. - Software: Familiarity with Revit, Autodesk BIM 360 is preferred as this is the software I would like the model to be created in. Ideal Candidate: - Proficient in BIM modelling and creating complex models. - Familiar with DWG file format and capable of converting it to a detailed BIM model. - Skilled in Autodesk BIM 360 or similar BIM software. - Capable of working effectively to deliv...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
I'm in need of a skilled Python coder to assist me in deploying Locally Hosted Language Model (LLM) applications. Here are the details: - **Operating System**: The deployment is hybrid, so familiarity with Windows, macOS, and Linux is ideal. - **Purpose**: The primary aim of the deployment is for text ebedding (vector db) and generation. - **Requirements**: Specifically, I'm looking for functionality related to Language modeling and retrieval augment generation in the LLM applications. - mongoDB should be set up runining a .sh file - docker-compose deploy of the app - whisper transformers for stt ttl - AWS S3 bucket for file serving Essential skills for this project include a strong background in Python programming and experience with deploying applications on different...
I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...
I am working on a project that requires interfacing a Raspberry Pi with a Panasonic Servo Driver. I need a professional to perform the following tasks: - Setting up Modbus communication between Raspberry Pi and Panasonic Servo Driver (Model Number: MDDLT55SF) - Setting up CC-Link IE TSN communication between Raspberry Pi and Mitsubishi Driver (Model:MR-J5W3-222G) - Writing code for controlling the servo driver from the Raspberry Pi - Testing and debugging the system - Providing support for any issues that may arise during the project Previous experience with Raspberry Pi and Panasonic Servo Drivers is a must. Additionally, the ideal candidate will have a strong understanding of programming in Python, as well as a background in robotics or industrial automation. GUI in Raspberry...
I am seeking a Blender 3D artist to help me create a mid-poly level 3D model. I already created something, but I'm having some issues I need help with. Job details include: - Creating mid-poly 3D models using Blender Ideal freelancers will have experience: - In Blender 3D modeling and sculpting
...matchups by week), weekly lineups, scoring settings, and league settings The Yahoo API Endpoints you'll need to use as inputs to derive the above data extracts for a particular league are: - the associated League ID (each league created by Yahoo is given it's own unique ID that a league member can provide) - the associated Game Key (there is a unique Game Key provided by Yahoo by fantasy sport and by year) - I have an online resource that outlines the baseline setup for what is required to leverage the Yahoo API, so can provide that I'm looking for a programmer who has experience in web scraping and working with APIs, especially the Yahoo API. Knowledge of fantasy football would be a very helpful plus, but not an absolute necessity. The ideal candidate should be ...
Defined the Scopes of Works, duty, or task (let said the "tasks") show as below: "Basic Scope" (I need you to do) 1. Initial Financial Statement Drafting (Basic Income Statement, Balance Sheet, change of Equity, and cash flow) as of 2024 March 31st (Year End 31-03-2024) 2. Maintain the company account and record transaction recorded (e.g: Journal Enters) 3. Recording and reconciliation of banking, AP, and AR transactions 4. prepare the accounting schedule (The “schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you...
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
I'm looking for a mechanism design expert who can help me with designing a small mechanism. Your main task will be to provide a detailed force analysis, create a CAD model, present concept sketches, generate a Bill of Materials (BOM), conduct Finite Element Analysis (FEA), and provide cost estimates. Key Responsibilities: - Designing a small mechanism (I will specify details if awarded). - Conducting thorough force analysis to ensure the mechanism's efficiency and safety. - Providing a detailed CAD model of the designed mechanism. - Creating concept sketches for visualization. - Developing a Bill of Materials (BOM) for easy procurement of the required parts. - Performing Finite Element Analysis (FEA) to ensure the mechanism's stability. - Providing accurate co...
business profit loss reporting excel(Jan, Feb & March)
I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere el...
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the...
ATTENTION: This is not a project to create a 3D model. It's to create a sample mobile app in Flutter. I need a 3D object renderer programmed in Flutter for PLY files. The intended purpose is visualization rather than animation or virtual reality. The selected candidate should possess: - A strong knowledge of Flutter and 3D rendering techniques. - Previous experience in creating high-quality renderers, as this project demands a high-performance level. The renderer should include the following functionalities: - The ability to rotate objects. - Zoom in and out capabilities. As an expert in this field, you're expected to provide advice on the best techniques and practices to achieve a high-quality 3D object visualization. The Flutter project need to be executable on b...
...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...
I'm seeking an experienced architect or designer to create a detailed commercial floor plan as I am apply for a liquor license permit and it is required to have a floor plan with current occupancy stamp that is not less then 1 year old. These plans need to go beyond the basic layout and should include furniture placement. I am not sure whether I need a 2D or 3D format, I am open to suggestions based on your professional opinion. Previous experience with commercial design is crucial for this project. Your bid should include: - Demonstrated experience in commercial floor plan design - Expertise in both 2D and 3D formats - Suggestions based on your professional experience for 2D and/or 3D floor design Please factor these requirements into your time and cost estimates. Thank you ...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
...LLM text model which behaves like a virtual girlfriend. This text model must be engaging in intelligent dialogues with emotions and feelings. Here are the primary requirements for this project: - Create an AI-driven text model: I need a text model that is capable of engaging in intelligent dialogues. This means understanding context, providing relevant and meaningful responses, and exhibiting emotional intelligence. - Incorporate emotional responses: The text model should be capable of expressing emotions and feelings in a realistic manner. This is crucial for creating a believable and engaging virtual girlfriend. - The model can be trained from scratch or, if you have knowledge of current models, adapt it to your needs. - The person must know ...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
Seeking a long-term Python Data Scientist and Generative AI expert Your task is to develop a prototype chatbot that is powered by Generative AI and Large Language Model (LLM) to respond to user queries using domain-specific knowledge and RAG implementation. The project will focus on integrating LLM frameworks, managing data preprocessing, and implementing the chatbot's user interactions. ONLY people who respond to below screening questions will be considered: 1) Did you fine-tune an LLM model using LoRA or QLoRA? If so, which model did you fine-tune, and what was the use case? 2) Do you have a GitHub profile? If so, can you share the link? 3) Are you proficient in English, and what is your hourly rate?
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
I'm looking an illustrator to create captivating illustrations to accompany my children's short story. The project includes a cover and 14 drawings, all tailored towards 4-8 year-olds. As the story revolves around a child's love for football, a basic understanding of the game would be ideal. I'm looking for cartoon style similar to the attached. Other than the front cover, each page should be related to the 4 lines of the story which will be provided but a summary of the story is that a young boy loves playing football and scoring goals, his team enter a tournament and he has to play in goal but becomes the hero.
