Example cost comparison excel jobs

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I am in need of a skilled photographer to capture professional headshots of 1-5 individuals on my team. These photos will be used across various platforms including our company website, our LinkedIn profiles, and other social me...has experience and can masterfully utilize natural light for high-quality results. Ideal Skills and Experience: - Proven experience as a professional headshot photographer - Expertise in outdoor photography utilizing natural lighting - High quality portfolio demonstrating past work - Ability to guide subjects for best results in terms of posture and expressions. Your bid should include the total cost for the entire photoshoot and delivery of edited, print-ready images. Communication skills, professionalism, and timeliness are essential for success in thi...

I am in need of a skilled professional who can assist me in setting up th...creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements...

I have an MP4 movie in which I have a green segment that lasts 5-10 seconds. I need a simple .jpg image to be inserted into that segment. The image may need to be modified to fit properly. Key Points: - The green segment in my MP4 movie is 5-10 seconds long. - The .jpg image that needs to be inserted is simple with minimal detail. - There is no need for any animation effects...understanding of image editing is required to ensure the .jpg fits well into the green segment. - Attention to Detail: As the image needs to be modified to fit properly, attention to detail is key. - Communication: Clear communication during this project is essential to ensure that the final product meets my expectations. I had to choose the price bracket but feel this is a very quick job that should cost ar...

I'm in need of a profession...need of a professional who can help me with a detailed cost estimation on concrete, rebar, and form work for a construction project. Key deliverables: - Detailed cost estimation: I'm looking for an itemized breakdown of costs by category. This will help me understand the expenses involved and make informed decisions. Skills and experience required: - Concrete, rebar, and formwork expertise: You should have a solid background in these areas to accurately estimate the costs involved. - Construction cost estimation: Experience in creating detailed cost estimations for construction projects is highly preferred. - Proficiency in Excel: The final document is expected to be provided in Excel format, so fa...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

...your country requiring bribes to release goods probably were for items such as expensive phones and laptops, not a bunch of simple electronics components. Put simply: I suppose a customs official looking at an iPhone 14 Pro might think, “Wow! This is an expensive phone. Yeah, this guy has money. Let me get a bribe out of him.” Whereas, if he were to look at a few ESP32 development boards which cost less than $5 (Five Dollars) each? Meh. I doubt he’s even going to think about asking for a bribe for such items. I suppose corrupt local customs officials are greedy, not foolish.z ✻ TIME FRAME ✻ I am not in a rush. However, this project must be completed within the next 60 (sixty) days. ✻ BEING WRONG ✻ Stand in front of a mirror and practice saying, “I ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I am looking for a skilled freelancer to help me compile personalized information from a list of 400 LinkedIn prospects. The list includes their LinkedIn profile URL, email, phone, name, current employer, current title...relevant, and suitable for use in a personalized outreach message. *Opportunity for ongoing work. Skills Required: - Attention to detail - Strong research skills - Familiarity with LinkedIn - Excellent written communication Timeline: The project needs to be completed ASAP. Budget: Please provide your rate and total cost for completing this project. To Apply: Submit your proposal with a brief description of your experience with similar projects. Include an example of how you would personalize a message based on a LinkedIn profile. Looking forward to ...

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...

...predetermined disciplines, then select date/time according to Instructor's calendar availability. There is an ability for the student to schedule a set of sessions for a whole subject or many subjects, with a specific Instructor, then determine date/time according to the Instructor Calendar. The Student who created the session, can also invite other students to his created session(s), in this case the Cost is different & shared. The Online Session: It is an online video lectures, where some teaching tools are shared such as; a white board, text-based materials (eBooks), interactive quizzes, shared screen and Other teaching models (will be discussed personally) Instructor Privileges There are two categories of Instructors (Hired & Freelance) The Instructor Discip...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

...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 else to be found. (399 USD, INCLUDED!) ➡️ Numerous attachments with clien...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 50...mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and s...

...garage from 20'x20' to 20'x40'. I am based in Lombard, and as such, require drawings that are suitable for submission to the Village of Lombard for permit approval. Key Requirements: - The primary focus of the drawings should be on the extension of the garage from 20'x20' to 20'x40'. - You will need to include an electrical layout in the drawings. - I am particularly interested in obtaining low-cost drawings that are still of high quality and acceptable to the authorities for permitting purposes. Your Expertise: - Proven experience in drafting and designing architectural drawings, particularly for garage extensions. - Familiarity with the building and permit regulations and requirements in Lombard, Illinois, or a willingness to research ...

Description: I have a collection of sofa images taken in a factory setting that need to be placed in new backgrounds such as houses, and compiled into a PDF catalogue for virtual display. Tasks: Replace the factory background of each sofa image with a house background. Ensure proper lighting and perspective adjustments for realistic integration. Create a visually appealing PDF catalogue...showcasing the sofas in different house settings. Provide high-quality images for virtual display. Deliverables: Edited sofa images in new house backgrounds. PDF catalogue file with all the sofa designs. High-resolution images optimized for virtual display. Criteria for Selection: Experience with background replacement and catalogue design. Portfolio showcasing similar work. Proposed timeline and ...

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

...will be examined by other Chinese academics, candidates should take care to prevent any copyright breaches. This is because the curriculum will be evaluated. In order for us to go forward with this contract, we kindly request that contenders submit their proposals, which should include the projected amount of time that will be needed, the number of lessons that will be included, and the overall cost for completing the project, which should include any adjustments that may be required. In the event that you want to submit your idea, kindly include the following information: Taking into account a daily commitment of three to five hours, the time period that is anticipated to be required to do this activity is around one to two weeks. The speed has to be moderate and should ...

...from this mailer for low to moderate income residents. I would like to have information about the NYSERDA Empower+ program, and the financial incentives available through this program Here's what I'm looking for: * Compelling design: Draw potential customers in with a visually appealing layout. * Suggested content: NYSERDA Empower+ Program, free home energy assessment and free application, low-cost or FREE heat pumps (heating/cooling) for program eligible candidates. Modifying the income limits on the back of the post card attached to reflect the below: -Household size of 1= $36,420.00 or less -Household Size of 2= $47,640 or less -Household size of 3= $58,848 or less -Household size of 4= $70,056 or less -Household size of 5-= $81,264 or less -Household size of 6= $9...

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star re...

...with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. An example of the required spreadsheet format is av...

...Condition:** Custom exercises to make you fitter, faster, and stronger. - **Mental Toughness:** Cultivate a winner's mindset to overcome challenges. - **Sports Specific Expertise:** Train with drills tailored to enhance football performance. - **Personal Development:** Track and measure progress, adjusting strategies to maximize effectiveness. 4. **Pricing and Call to Action:** - **Cost:** £500 per participant - **Text:** "Ready to transform? Reserve your spot now and start your journey to becoming a champion!" 5. **Footer:** - **Contact Information:** Provide phone number, email, and website for registrations. - **Social Media Links:** Icons for Facebook, Instagram, and Twitter for participants to follow for updates and community engag...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

***************ONLY BID FULL PROECT COST NO RESERVE BIDS****************************************** ****************NEED TO BE NO MORE THAN 3 HOUR DIFFERENCE IN TIME FROM UK********************* I'm in need of a proficient report designer/builder to create some Sage 50 reports in Business Central. The designer should be able to create and design reports in a visually appealing manner. Key Requirements: - Design and build Sales, Purchase and Inventory reports. - In the Sales report, include Sales revenue, Sales quantity, and Customer names. - Present the Sales report in a table format. Ideal Skills and Experience: - Proficient in Sage 50 and Business Central. - Expertise in report design and building. - Ability to present data in a visually appealing way. - Good communicatio...

Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and android. We are a web-development company that has developed a community platform that connects people and encourages them to support each other through sharing time, knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wishes

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

...maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The ...

Start your offer with the word in the att...Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 hours of starting our...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I require an experienced Web Developer to undertake a project we have. The website we need is a comparison website for Coach hire. This will entail a booking system where Coach companies (Operators) will bid/tender for work etc. Below are the features. User Registration and Authentication: • Users can sign up using their email or social media accounts. • User accounts store personal information, trip history, and preferences. Operator Registration and Authentication: • Coach operators can register and provide details about their services, pricing, preferred locations, etc. User Dashboard: • Users can submit trip details including location, and passenger count. • Users receive quotes from multiple operators. • Users can view and manage their tri...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

...BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designin...

...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.

The project “PlayBox (OTT Platform)” Includes No Any type of Subscrition So Any person use this platform free of cost. In general, depending on who you ask, there is usually a certain lack of consensus regarding the definition of OTT. Operators, hardware manufacturers and OTT platforms – as well as their audiences – see things differently and have other things in mind as far as OTT is concerned.

...target customer segments in the regional area. - Scope: The geographic focus of this study is primarily regional, so the ideal candidate should have experience in analyzing and understanding local market dynamics. - AC System Aspects: The business model is built around AC systems that are characterized by energy efficiency and sustainability, advanced technology, and a focus on affordability and cost-effectiveness. An ideal candidate should have a deep understanding of these elements and how they relate to the market. Skills and Experience: - Prior experience in conducting market feasibility studies, especially in the AC sales and maintenance industry, and a proven track record of delivering actionable insights. - Strong analytical skills and the ability to interpret market da...

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

...lithium tantalate as an alternative material in the production of smartphone components. This project is specifically targeted toward academic researchers, and the final output is expected to be in the form of presentation slides. Key aspects of the project: - Investigate the potential of lithium tantalate: The main goal of this research is to assess whether lithium tantalate could serve as a cost-effective and efficient alternative material to the ones currently in use. - Academic audience: Given the nature of this project, the target audience for the final output will be academic researchers. Therefore, the content and analysis should be tailored to this group. - Presentation slides: The final deliverable for this project will be a set of presentation slides. These should be ...

I'm looking for a video editor to enhance 5 educational videos (around 2-4 minutes per video). You can quote me per minute of adding in the text + the cost to add in the branding on each video. The primary goal is to insert key branding elements throughout the videos. These include: - My company's logo - A watermark - A small banner featuring the company branding at the bottom throughout the videos In addition, I would like the editor to incorporate subtitles at the bottom of the videos. The subtitles should be clear, easy to read, and complement the educational content. We will have the videos transcribed, will need you to match it up to the sound. The videos are in Spanish and English. This is important, as you will need to understand Spanish to know where to align ...