Excel formula if date is greater than 30 days from todayงาน

I am in urgent need of a specialist with deep knowledge of the Tron blockchain platform. The task at hand consists of ...with deep knowledge of the Tron blockchain platform. The task at hand consists of deploying a pre-existing smart contract. To excel in this, you'll require: - Proficiency and extensive experience with Tron blockchain. - Knowledge and previous experience with smart contract deployments. - Ability to deliver the task as soon as possible. Your prime responsibility is to successfully deploy this existing contract on the Tron chain. No development or modification is required - I need an expert who can handle the deployment swiftly and flawlessly. If you have the knack for troubleshooting blockchain challenges and are comfortable working und...

I'm looking for a skilled freelancer to shoot a 30-second video highlighting key aspects of my product. Key Video Objectives: • Demonstrate product features • Highlight the design and aesthetics of the product • Display its functionality • Accentuate its innovativeness The ideal freelancer for this project would be experienced in video production, particularly product videography, with a keen eye for detail and aesthetics. A background in marketing could also be beneficial in effectively showcasing the product. The goal is to create a crisp, clear, appealing video that captures all the unique features of our product within a brief 30-second timeframe.

I need a label designed -I have the file in JPG and just needs to be copied. I don't have files just the JPG. Label Size: - 96mm x 50.8mm Labels per Sheet - 10 Avery Template - L7113 Product Code: AV980019 Final design to be supplied in HiRes PDF. *PLEASE NOTE* Before awarding the job I need to be confident you understand the request and willing to sho...just needs to be copied. I don't have files just the JPG. Label Size: - 96mm x 50.8mm Labels per Sheet - 10 Avery Template - L7113 Product Code: AV980019 Final design to be supplied in HiRes PDF. *PLEASE NOTE* Before awarding the job I need to be confident you understand the request and willing to show me a draft of the design before I assign the job. * I will only ask you to show me a draft if I am ready to as...

sebuah poster spaider man cocok untuk anak kecil

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional wh...

I need swift assistance with my Flutter app. Recently, I purchased a script from CodeCanyon and introduced a few new features with the help of the original developer. Now, I am in need of further modifications including: - Adjustments to font, color, and layout - Alterations in the layout, more specifically, changes in navigation menus and positions of buttons. The successful freelancer must be highly skilled in Flutter and UI/UX design. Familiarity with CodeCanyon scripts will also be a plus. Since I require these tweaks to be done ASAP, having a track record of quick turnaround times is crucial. i need to today before night indian time

...Up-to-date knowledge in navigating Etsy's platform, preferably experience in recovery or setting up new accounts. - Experience with setting up print on demand services, particularly with Printify. Here's what you should know about the job: - I currently have a legacy Etsy account and another one that's been suspended. - I am yet to decide whether to recover the suspended account or create a new one, making your input and advice on this crucial. - The ideal freelancer should be able to guide me through whichever process we decide on (account recovery or new account setup) and ensure a successful integration with Printify. - You must be willing to show me what you did via web meeting or creating a video so I can see what to do going forward and I have to fix...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

Looking for a CPA from Philippines with strong English skills, multi-years work experience in Xero, QBO, MYOB, Sage for US/Australia/NZ companies. Tax filing experience would be an added skill. Overall engagement would start small but can grow into a full time engagement depending on the quality of work delivered. The role would entail shift working and the work hours will be a function of client requirements. (PH night shift/early morning shift). Only looking at Individual Freelancers, team bids will be rejected. If this description excites you, happy to chat. Experience in automation in accounting and comfort with writing accounting / finance content preferred. The price range quoted is monthly price range.

I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.

I'm seeking an e...generally improve my gameplay, having a broad understanding of key strategies, character usage, and gameplay mechanics is essential. **Expected Outcomes:** - **Personalized Strategies:** Tailored approaches to improving my gameplay, considering my current skill level and preferred characters. - **Practice Routine:** A structured practice schedule that focuses on areas needing improvement. - **Feedback Sessions:** Regular feedback sessions where we review gameplay footage together and discuss strategies for improvement. Ideal candidates would have experience coaching other players and a deep understanding of Brawl Stars' mechanics. Being patient and articulate when explaining concepts is also crucial. Looking forward to transforming my gameplay...

...give me completion date and time and your comfortable bidding price for the milestone 1 and milestone 2. I will need to start this immediately. I will be paying each milestone when you are done. There are 2 milestones. Please try and send us sample of milestone 1 and 2 you done in screenshots, so we know you understand the requirement to start. I will be also providing you the 4 design template with 4 design (total 4 x 4, 16 designs). And also providing you the 8 printing labels. So you need to adjust the 16 design to fit into those 8 labels which means the total variation and the files you will be sending me is 128 .ai files (16 design x 8 labels = 128 ai files). You are required to complete this project within the time and cost you originally gave in the quote . There...

I'm seeking a professional who can manage my bookkeeping needs, including GST compliance and registration, and also handle auditing and ITR filing. Key Responsibilities: - Bookkeeping: I need assistance with managing my financial records, ensuring accurate and up-to-date bookkeeping. - GST Registration: I require support in registering for GST. - GST Compliance Management: Ensuring that my business is in line with GST regulations and making timely compliance filings. - Auditor: I need someone who can maintain and present my financial records for auditing. - ITR Filing: Preparing and filing my Income Tax Returns in a timely manner. Ideal Skills and Experience: - Proven experience in bookkeeping and financial management. - In-depth knowledge of GST regulations and compl...

I've a research paper I've done on this problem: "Start with $1 million portfolio. Invest 70% in 10 actively managed mutual funds that have outperformed over 10 years. Allocate 30% to 20 individual stocks screened for earnings growth, valuations, profitability and momentum. Back test over 15 years versus S&p;P 500. Evaluate returns, risk and rebalancing strategies." unfortunately the feedback i got was "You claim that you did portfolio optimization but there is no information how you did it. There is no covariance matrix no correlation coefficients obtained from data " I'm looking for someone to help me complete this project before may 5th , 11:59PM pacific time. I am seeking a financial expert to optimize my por...

I'm looking for a video content creator who can create less than one-minute long explainer, tutorial, and promotional videos. The videos are intended for an adult audience, so the tone, language, and visual elements should suit that demographic. You should be experienced in: - Crafting engaging and concise video content - Developing explainer and promotional videos - Creating tutorial videos - Understanding and targeting adult audiences Please provide examples of your previous work, particularly any videos targeted at adults or projects with similar brief lengths. Remember, the key is to effectively communicate information and evoke interest within a short timespan.

...a Python coding expert. The exact purpose of this code is unspecified, with the task or problem also undefined. Therefore, the perfect freelancer must be able to think on their feet and handle a variety of Python-related tasks with adaptability. Moreover, there's no firm preference regarding supplemental programming language or framework. Your ability to work in diverse scenarios will be crucial here. Concept The ads folders are stored in the folder of 'C:UsersKALAVANIDownloadsVideo' and should be played in VLC media player at full screen using the following Python code: After the ads finish, and the normal broadcast can continue. Ads should be run on a priority basis. The folder named 'C:UsersKALAVANIDownloadsVideo1' is considered h...

I require an experienced graphic designer to create an illustration based on a supplied photograph. - The ideal freelancer for this project would have experience in creating realistic digital illustrations. - Your task would be to convert the image into an illustrated graphic, capturing the finer details in black and white. - As a proficient graphic artist, you should be able to analyze the provided photograph and be capable of replicating its elements in the final illustration. - Black and white shades would be the primary color scheme for this project. - Exceptional attention to detail and a keen eye for duplicating reality onto a digital platform would be crucial for achieving the desired result. - Please include previous examples of realistic digital illustrations in your bid. Apprec...

I'm in need of a WordPress developer who can transform my current website, adding fresh content and features to make it more engaging and efficient. Key Features and Improvements: - Integrate a 'Products' tab with a range of 10-50 items and their respective prices - Develop a product package selection system that...Extensive experience in e-commerce integration - Strong grasp of UX/UI design principles - Ability to create a visually appealing website - Good understanding of website speed optimization I'm looking for a developer who can not only fulfill these requirements but also provide creative input and innovative ideas to make my website truly stand out. The goal is to enhance user experience, increase engagement, and ensure the website is up to ...

I'm in need of a skilled audio engineer that can seamlessly mix three particular songs ...around 2:15 minutes. I have all the individual audio files ready to go. I would like it to go area codes, low and the beep beep. • The prime areas to be featured from each song are different sections, not specifically limited to chorus, verse, or instrumental. Your creative inputs would be valuable. • Proficiency in audio mixing software is a must • Prior experience in creating hip hop music preferred • Clear communication and understanding of musical features would be greatly advantageous. I'm looking for someone who understands the rhythm and beat of hip hop music and can integrate the songs seamlessly. The ultimate goal is unique and creative ...

I'm in need of a skilled audio engineer that can seamlessly mix three particular songs ...around 2:15 minutes. I have all the individual audio files ready to go. I would like it to go area codes, low and the beep beep. • The prime areas to be featured from each song are different sections, not specifically limited to chorus, verse, or instrumental. Your creative inputs would be valuable. • Proficiency in audio mixing software is a must • Prior experience in creating hip hop music preferred • Clear communication and understanding of musical features would be greatly advantageous. I'm looking for someone who understands the rhythm and beat of hip hop music and can integrate the songs seamlessly. The ultimate goal is unique and creative ...

need Simple live chat system between 2 users, no designing needed. 1. login using php 2. show list of users fetched from db 3. on clicking a user, initiate chat (if the other user not blocked the requested user) 4. the chat should be live, realtime. and the data to be stored in mysql db 5. option to block user should use php as backend and bootstrap as front end . you can use firebase budget AUD 50 and should be done today please don't bid and ask for more time and money

I need a professional who can scrape product prices from Starbucks and Dunkin Donuts' websites. The main focus will be Coffees, Beverages, and Food items. Key Requirements: - Scraping: Extract product name and price from two apps/websites. - Data Organization: Provide the scraped data in a clean and organized format. Ideal Skills: - Proficient in Web Scraping: Experience in scraping data from various websites. - Data Management: Ability to organize and present scraped data efficiently. This project will require attention to detail in maintaining the data integrity throughout the scraping process. The scraped information should be accurate and up-to-date.

...Safari page. The function of this workflow should be to take the current open web page (which I am viewing in Reader view) and save it as a pdf to the Finder, specifically, to a set folder on my device. Here's what I'm looking for: 1. **Compatibility:** The Automator workflow should be compatible with macOS Mojave. 2. **Naming the PDF:** The saved PDF needs to be automatically titled with the Date in a yyyy-mm-dd format at the beginning of the file name. The website always provides the remainder of the file name, which I want to keep. 3. **Additional Functionality:** No additional functions are required beyond saving the web page as named PDF to a specific folder. The ideal candidate for this task would be someone with significant experience in scripting Au...

...school buses, aiming to provide real-time GPS tracking for parents and enhance the overall bus tracking experience. Key Features: - **Real-Time GPS Tracking**: This feature is crucial. It should be able to accurately display the location of the school bus on a map. Parents should be able to view the bus's whereabouts in real-time. - **Parent Notifications**: It's important that parents receive notifications when the bus is nearby or approaching their designated stop. These notifications should be timely and reliable. - **Multi-Bus Tracking**: The app should allow parents to track not just one, but multiple buses. This is especially helpful for parents with multiple children attending different schools or taking different buses. -** show pickup time and...

...Javascript ,Python, and React.js. I need ongoing support for several project and there is no specific deadline. The ideal candidate should have strong programming skills in these languages and frameworks. I have several projects that need various development work. Most projects are built in python using django or flask. One project is using react with a django backend so you'll be expected to know some react as well. Our stack (usually): -Python -Django -Docker -Flask -React -Html -CSS -Javascript I will give you various tasks within each project and you'll work on them. Initially I will provide defined tasks with set requirements but then eventually it will be hourly work. Expectation is 3-4 hours/day, 4 days a week. Preferably Thursday through...

I am looking for some with a high level of skill with excel to update my existing financial model. The expected revisions are: -Updating the revenue projections: -Modifying the expense assumptions: The current expense assumptions must be modified and updated to include fresh cost elements. -Incorporating additional performance metrics: I desire additional performance metrics that can assist me in making informed business decisions. This is a fairly simple job and should only take a couple of hours (maybe less) but there maybe on going work if done well. Time is urgent and would need to start today

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

As an investor, I require a CFA-qualified professional to assist with complex bond pricing tasks. Specifically, my investment portfolio focuses on municipal bonds and I ...tasks. Specifically, my investment portfolio focuses on municipal bonds and I am keen on better understanding their quantitative pricing. Key tasks will include: - provide spreadsheet with all cash flows and formula - extrapolate discount rate using forward sofr and muni curve - The perfect candidate will have a strong background in quantitative investment analysis, a solid understanding of bond markets, and proven experience in pricing municipal bonds. In-depth knowledge and practical application of quantitative pricing models will also be highly advantageous. In the end, I just want excel spreadsheet d...

I would like the shadows removed from these photos.

I'm looking for a skilled web designer who can infuse some creativity into updating my website's homepage. Your responsibilities will include updating the colors and fonts, improving the layout and organization, and revamping the logo. Since I haven't decided on a specific color scheme or ...suggestions. Please note that I only need HTML and any style sheets or JS files. Ideal candidate: - Experience in web design and UI/UX. - Strong graphic design skills, particularly with logo design. - Proficiency in HTML and CSS. - Good understanding of color theory and typography. - A creative mind able to deliver innovative designs. Your bid will be more competitive if you can deliver the finished designs at an earlier date. Looking forward to unveiling a new and impr...

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

Hi! Your job 1. Go to a website (url in brief) every day to every other day 2. On that website click a link to open another website. This website is NOT live/active yet. 3. Open the list of names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the email is sent, change body of email and when the scraping starts/stops as well as frequency (daily or every other day).

We specialize in marketing for large construction compani...action-styled, brand promotion videos for social media. We have various 1 minute style videos we would like to create on top of "hype" style social media ads for the construction companies we work for. We would provide you with drone footage and close up footage. Ideal Skills and Experience: - Expertise in editing videos especially for social media platforms - Solid knowledge of crafting 1 minute and 30-second videos - Adequate experience in the fast-paced, action genre - Proven track record of creating engaging videos for brand promotion End product should not lack in excitement and should effectively promote our brand. I look forward to working with an editor who can deliver quality, professional videos to cap...

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry and copying

...subcategories while others do not - Social Sharing: Implement a feature that allows users to invite friends through the platform - User-friendly Design: Create an engaging and attractive design that is user-friendly - Product Properties: Ensure that every product has distinct properties like size or weight - Multilingual Support: Enable the website to support at least 2 languages - Order Confirmation: Request for a confirmation before finalizing an order - Signup by mobile number or email - Admin Control: Grant admin control to manage various aspects of the site, including services picked from the shop, and the ability to add new features to the home board - User Profile and Order Management: Implement a user profile page, cart page, my order section, and invoice generatio...

I'm looking for an experienced Flutter developer to help me create a Point of Sale (POS) page compatible with various platforms such as web, iPad, Mobile, and Windows. Please be aware that there's currently no API in my existing source code. If you're unable to handle this task, I may consider hiring someone else. However, I'm interested in understanding your requirements before making a decision. Kindly note that my budget for this project is up to $120. If your pricing exceeds this limit, I kindly request you not to bid for the project. (300$ IF 1 WEEK TO FINISH THE PROJECT) ( Contact me for more details )

...Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from E...

...developer to create a custom plugin that integrates with Revit 2024. The plugin will automate the retrieval of quantity data from specific Revit schedules and perform calculations based on user-selected options. Requirements: Proficiency in Autodesk Revit plugin development. Access to Revit 2024 installed on your PC for testing and development. Ability to work independently and efficiently. Project Details: The objective is to develop a plugin that performs the following tasks: Retrieve quantity data for four specified materials from predetermined Revit schedules. Display the retrieved quantities in a user interface within the plugin. Prompt the user to select from three predefined conditions (each associated with a specific percentage) using a dropdown m...

I am in need of an expert to perform a thorough resume rewrite. My main goal is to put a greater emphasis on my skills in Digital Advertising, as I am planning to submit my resume for the role of Performance Marketing Specialist. Skills & Experience Required: 1. Proven expertise in professional resume writing 2. Profound understanding of the digital advertising space 3. The ability to highlight my relevant qualifications for the role in a concise, yet effective way Despite not wanting a professional summary section, I am open to other recommendations that will make my profile more attractive to potential employers.

I'm looking to revamp my project's exterior with a modern landscaping and facade design. Key Aspects: - **Landscaping**: - Focus on the addition of new, modern plants and flowers. - Incorporate outdoor lighting to enhance the overall ambiance of the space. - Integrate a seating area, possibly with a modern design aesthetic. Ideal Candidate: - Experience with modern landscaping and facade design. - Proficiency in selecting and planting new, modern plants and flowers. - Knowledge of outdoor lighting systems and their application in landscaping projects. - Skilled in creating comfortable and visually appealing seating areas. Feel free to share your portfolio showcasing similar projects you've worked on. Looking forward to collaborating with a creative and skille...

...platform, which will include a website and mobile application. Provide mockups for Mobile and Web site. The number of mockups can vary but this is not very complicated. The mockups should give idea of flow of application and navigation. Primary Features: - A platform offering business services, promoting social connectivity. - Live chat feature enabling users to interact instantly. - A sophisticated system for sharing photos and videos. - Capability to match business services with end-users. - Capability for the business to buy advertising space on the website and mobile application - A market place where customers can buy products from the different businesses Business Services: - Job listings service allowing businesses to post open positions. - Business network...

I am seeking a proficient interior designer to revamp my open-plan kitchen primarily, but also overall touch-up to encompass the dining and lounge areas with a TV space. While all areas need attention, the kitchen redesign is top priority. Key requirements: - Follow a Modern design aesthetic: Pure lines, minimalist decor, functional and bold use of colors are essential. A keen eye for modern design ideas and up-to-date trends is fundamental. - Enhance aesthetics: The ultimate aim is to redesign my open-plan areas into harmonious and aesthetically pleasing spaces. Skills and Experience: - Proven experience in interior design, specifically using modern design concepts. - Exceptional attention to detail, creativity and innovative thinking. - Ability to provid...

I require assistance with the submission of my entrepreneurship paper to an international academic journal. My paper falls within the 6000 word count range. The freelancer should ideally possess the following: - Expert knowledge and experience in academic paper submission, particularly within entrepreneurial ...following journals: - entrepreneurship theory and practice - journal of small business management - international small business journal - Journal of Entrepreneurship (Q2) - Small Enterprise Research
 (Q2) - "Journal of entrepreneurship and innovation in emerging economies" (Q2) - "Journal of Research in Marketing and Entrepreneurship" (Q2) Due date 5 days. The task entails publishing the paper in to the journal within the time-frame. note:...

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

Hi Judith Mueller,I hope this message finds you well. Thank you for considering me for the opportunity to refine the project output through a liv...refine the project output through a live session.I propose a four-hour live session to collaborate on fine-tuning the project deliverables. During this session, we'll focus on [briefly mention the tasks or areas to be addressed, e.g., refining the banner and discussing design concepts for the website].My hourly rate is $10, making the total cost for the four-hour session $40. I'll be available to start the session at 1:30 PM CET today, as per your let me know if you agree to proceed with this proposal. Once accepted, I'll be ready to start the session at the agreed-upon forward to our regards,Rahul

Dear Ammar, Thank you for considering me for the final assessment. I appreciate the opportunity to continue with the evaluation process. Quote Details: Date: Tuesday, 7th May Scope of Work: Final Assessment Compensation: $12 I confirm my availability for the assessment on the specified date and accept the compensation of $12 as mentioned. I am fully committed to dedicating the necessary time and effort to ensure a successful assessment. Please provide me with the necessary instructions and details for the assessment. I look forward to receiving the link containing the instructions. Thank you for your consideration. I am eager to proceed with the final assessment and demonstrate my capabilities. Best regards, Aditya Shinde

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

I'm in need of a highly skilled HTML/CSS assistant who can take 6 design images that I already have and turn them into fully functioning web pages. The purpose of these pages is to provide information about a service or product, so it's crucial that they're laid out in a clear and user-friendly manner. Furthermore, the final product needs to be fully mobile responsive, so it's accessible and easy to navigate on any device. Key requirements: - Transform 6 design images into web pages - Ensure user-friendly layout for service/product information - Make the pages fully responsive on all devices

...following Python code: After the ads finish, and the normal broadcast can continue. Ads should be run on a priority basis. The folder named 'C:UsersKALAVANIDownloadsVideo1' is considered high priority and should be played three times an hour. The folder named 'C:UsersKALAVANIDownloadsVideo2' is medium priority and should be played twice an hour. The folder named 'C:UsersKALAVANIDownloadsVideo3' is low priority and should be played once an hour. Videos should be picked randomly from each folder, but every video should be played according to the priority basis mentioned above. The maximum duration for an ad is upto 4 minutes. After the ad finishes, the normal broadcast can continue. To monitor errors, cre...