Format cash flow statement excel trabalhos
...creator of a backend designed with Microservices, I am currently seeking an experienced professional with proficiency in Node.js ( Framework) to comprehensively review my backend code. Key Responsibilities: - Inspect and evaluate the data handling and database management of my application. Any proposed modifications should aim at promoting the efficiency and performance of data flow within it. - Scrutinize the security implementation for potential vulnerabilities. Recommendations for enhancements should be accompanying any identified weak points. - Critically assess the performance and efficiency of the present code and propose changes that will render the backend of my application more effectively. Ideal Skills and Experience: - Extensive experience in backend code review
Por favor, Cadastre-se ou Faça Login para ver os detalhes.
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
...analytics on an individual's mental capacity during work. I propose the development of a wearable device that monitors and analyzes cognitive functions, offering insights into flow states, situations of high stimulation, potential burnout risks, and daily mental strain. This innovative device, worn on the head and equipped with EECG/FMRI and other neural/blood flow tracking capabilities, aims to provide real-time data on the user's brain state. The accompanying app, leveraging ML, AI and analytics tools, interprets this data to offer actionable insights. Key features and objectives of the proposed solution include: Flow State Recognition: Identify and analyze periods of optimal focus and productivity to enhance overall performance. Stimulation Awareness...
...degree of functionality should be prioritized: - Capture signatures from the Topaz T-LKB755SE-BHSB-R SignatureGem LCD 4x3. This are the available SDKs /software combaine what you need i am on a windows pc with the topaz in front. Python is main but load or do what you need. The captured signatures should be saved in a format that's optimal for database storage and for use in official forms. The preferred database management system for storing these signatures is SQLite3. The ideal freelancer for this role should have: - Extensive experience in Python programming. - Developed skill with hardware integration (preferably with Topaz products). - Proficiency in working with SQLite3 database management system. Your previous
I've written a book and I'm in need of a professional who can format it. The book was created in A4 size (8.27 x 11.69 inches) and it contains both images and text. I need someone who understands the intricacies of print formatting, especially in the context of a color-printed book. Key requirements include: - Setting up appropriate margins and bleedlines: I need the pages to be formatted correctly for print, ensuring that no content is cut off during printing. - Handling images: There are images within the book that need to be aligned and presented appropriately within the text. - Color management: Since the book will be printed in color, I need someone who can ensure that the colors are accurately represented in the final print version. I'm seeking a freelancer ...
I need a skilled data entry specialist to help me with a project that involves entering text from physical documents into a database. Key Requirements: - Data Entry: The main task will involve accurately transcribing text from physical documents into the database. - Attention to Detail: It's crucial that the data is entered accurat...ability to handle physical documents carefully and maintain their integrity is required. Ideal Skills and Experience: - Proven experience in data entry, preferably with physical documents. - Proficiency in database management. - Strong attention to detail. - Ability to handle physical documents with care. - Previous experience with similar projects would be a bonus. The expected output format for the project is a well-structured and orga...
...transaction format. The tool should have the following features: - **Batch Conversion Capability:** The tool should be able to handle multiple PDF files at once, converting them into QIF format with ease. - **Automatic Categorization of Transactions:** I'd like the tool to automatically categorize transactions within the converted QIF files. This feature will save time and enhance the usability of the tool. Furthermore, the tool should adhere to specific formatting requirements for the converted QIF files, including: - **Date Format:** The converted QIF files should have the date format specified. - **Account Number Format:** The converted QIF files should have the account number format specified. - **Currency Format:** The conver...
...startup focused on helping early-stage FinTech companies acquire high-quality leads and accelerate growth. We're seeking a seasoned lead generation specialist to join us on this exciting journey. Project Details: You'll be responsible for crafting a comprehensive lead generation strategy targeting decision-makers within the FinTech space, specifically early-stage startups. We aim for a steady flow of qualified leads with in-depth information like Name, Email, Title, Company Size, Industry, Revenue Range, and Social Media presence. These leads will be nurtured through targeted email marketing campaigns and social media outreach. Ideal Candidate: We're looking for a freelancer with at least 3 years of B2B lead generation experience within the FinTech industry. Yo...
I'm looking for someone who can model 2 phase flow (humid air and ice) on a flat plate and is an expert in CFD. Since the plate is cold, there will be frost formation on it.
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
I'm keen to collaborate with a developer adept in Chrome extension and AI, in particular, machine learning. The key objective is to establish a Chrome extension capable of executing automated tasks. - Chrome extension work-flow - When I call on Google meet or Zoom, extract the questions of the recruiter or technical manager. - Making the answer (will use ChatGPT or AI) with the questions extracted and show it to popup on current web page. - Skills and Experience needed: - Proficient in Chrome extension development - Solid experience in AI, specifically with Machine Learning - The Task: - The extension must be proficient in automated tasks. When it comes to the type of automated tasks, the focus is on AI capabilities. With your expertise, I'm confident we c...
I'm in need of a unique, event-ready coffee trolley with a built-in coffee machine, and the capacity for custom branding to fit my business aesthetic. Key requirements: - An integrated coffee machine that can handle...quality drinks - Aesthetic design that complements an event space (e.g. sleek, elegant) - Capable of accommodating custom branding elements Ideal skills for this project: - Experience in the design and fabrication of mobile food service units - Proficiency in custom branding implementation - Knowledge of effective and efficient coffee machine integration - Understanding of event space setups and flow to ensure the trolley is both practical and attractive. If you have experience in creating custom event coffee trolleys, please share your portfolio along with...
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
I require a skilled illustrator to bring life to my children's book with vivid watercolor style illustrations. You need to create a total of twenty-three watercolor illustrations with a vibrant color palette. There's no direct guidance on the main focus of the illustrations, giving you creative freedom. I'm looking for someone wit...palette. There's no direct guidance on the main focus of the illustrations, giving you creative freedom. I'm looking for someone with: - Experience in designing children's book illustrations. - Proficiency in watercolor style illustrations. - Proven ability to work with vibrant colors. - Capable of visual storytelling, since the main focus wasn't specified. With these in mind, let your creativity flow and help ...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
...company logo, our phone number, email address, QR codes to our Google and TripAdvisor reviews and some standard verbiage as part of the design. Skills and Experience: - Proficient in graphic design software - Experience with minimalist designs - Ability to integrate QR codes into design - Strong understanding of brand consistency Final Deliverable: The final design should be delivered in a PDF format. I would also like a one page document created that will go on the front desk in a stand up plexi glass holder. I would like it to look and say almost exactly what the image says that I uploaded below. I would also like this to have the same google and TripAdvisor QR code as found on the business card....
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and...
...will be highly preferred due to the nature of our business. This comprehensive understanding is crucial to effectively tailor our privacy policy. In summary, we need a top-flight legal writer experienced in e-commerce, international data protection law, and Shopify privacy policy crafting. Your fine-tuned skills will help simplify often intricate and confusing legal language into a user-friendly format for our individual consumers....
...realistic silhouette of a Bearded Vulture. The silhouette should be accurate in proportion and detail. -Banner design: Create a visually appealing banner incorporating the Bearded Vulture silhouette. Add small elements such as the species name, logos, website, height and size info of the species, and other design elements to make the banner attractive. -File format: Provide the final design in vector files to ensure scalability (or any file format needed if requested by printing company) -Ownership: Transfer all rights to the design to our organization upon completion. The designer will be provided with an accurate illustration of the Bearded Vulture to generate the silhouette. Visual identity guidelines of the NGO will be provided to ensure consistency with our branding....
I'm looking for an experienced professional to create a bold, colorful, text-only PDF document...PDF document for promotional purposes. Key deliverables include: 1. A visually appealing, well-structured PDF document 2. The implementation of a bold, colorful theme to align with our brand voice Given the nature of the project, a keen eye for design and strong skills in creating promotional content are ideal. It's important that you can express information in an engaging, easy-to-understand format. However, the main focus should not be solely on design but the alignment of the text layout to the overall visual concept as well. This PDF aims to stand out yet convey the necessary information effectively. Your previous experience working on similar promotional materials will b...
I'm running a window cleaning company in the York region of Ontario in Canada, and I need help recruiting clients. Here's what I'm looking for: - **Recruitment**: I need someone to focus on recruiting residential houses only, ensuring a continuous flow of work for our team. - **Method**: I'm open to various methods for reaching potential customers, from traditional cold calling to any other approach you are comfortable with. However, I'm not interested in online advertising. - **Requirements**: The houses you recruit must be in the York region. Additionally, each recruited house should provide a minimum of $200 in business. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate re...
I have an existing logo in PNG format created with Adobe Illustrator that I need to have recreated as an SVG file. The project is urgent and I need it completed as soon as possible. Key Requirements: - Recreate an existing PNG logo as an SVG file - Maintain the original design and quality - Urgent completion is needed Ideal Freelancer: - Experienced in Adobe Illustrator - Proficient in creating SVG files - Able to work under tight deadlines - Strong attention to detail Not willing to pay more than $10 for it - must be able to deliver same day.
We have various miscellaneous small jobs that need done. SOP (Statement of project) is defined in attachment. Please see attachment in whole & then respond. Thank you.
I'm in need of ...with visible footprints so that we can color them in CMYK (each mouse gets one color) - Ensure the design is in a cartoon style - Deliver the design in Adobe Illustrator format (vector) - design should be animation-ready through Adobe apps You should have: - Proficient skills in Adobe Illustrator - Proven experience in creating cartoon mascots - Ability to deliver high-quality, unique designs - Strong communication skills to understand my vision and bring it to life - A good understanding of scale and proportion as the design will be used for a variety of purposes including website, print materials, merchandise, and wide format art. The successful freelancer will be well-compensated and have the opportunity for more work in the future. Looking forwar...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
La tarea sera la gestión completa de cuentas para los anfitriones de distintas pl...de propiedades. Necesitamos especialistas en atención al cliente que puedan encargarse de las tareas administrativas y la gestión de cuentas. Los requisitos para el solicitante incluyen gran atención a los detalles, título universitario, acceso al correo electrónico y conocimiento del uso de un dispositivo (computadora o teléfono), herramientas de software básicas (Microsoft Office - Word y Excel). Necesitamos miembros rápidos, precisos y especializados. Es obligatorio aprobar una prueba corta/terminar una tarea, que podría durar entre 2 y 4 horas, con posibilidad de extenderse hasta 1 semana, si el candidato está inv...
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
I'm in need of skilled programmers to develop interfaces for my Place and Route EDA flows. The ideal candidate will have experience in the following: - Proficiency in Python and/or C++ - Familiarity with VHDL, Verilog, and Syst...need of skilled programmers to develop interfaces for my Place and Route EDA flows. The ideal candidate will have experience in the following: - Proficiency in Python and/or C++ - Familiarity with VHDL, Verilog, and SystemVerilog - Experience in file input generation - Strong file parsing capabilities - Ability to manage EDA flows using TCL The interfaces need to be able to handle the entire EDA flow, from file input generation to error reporting. Experience in developing similar interfaces will be a big advantage. Please include relevant work sampl...
I'm embarking on a journey to increase visitor traffic to my new blogging site and need a savvy SEO coach to guide me. The scope will: • Develop and implement effective SEO strategies from scratch. • Skills in keyword research and sele...growth strategies and Google Analytics are key. • The ideal candidate will have a proven track record in enhancing organic search results and the ability to monitor and evaluate web analytics, tweak strategies and maximize results. • Training me on maintaining and enhancing these efforts will be part of the engagement. The goal is to enhance my site’s online presence, build a healthy organic traffic flow and to learn the basics of SEO management for future self-sufficiency. Excited to foster a collaborative relations...
...prototype is a structural one, so the ideal candidate would have experience in product design. Requirements: Conceptual Sketches: Rough sketches that outline the basic concept of the diptube design. These sketches should capture the key components and their relationships. Functional Diagrams: Create diagrams that illustrate how the diptube will function within the larger system. This could include flow diagrams to show the movement of fluids through the diptube. Component Layout: Develop a layout of the individual components within the diptube assembly. This will help visualize how everything fits together and identify any potential issues with spacing or accessibility. Mechanical Drawings: Produce detailed drawings of each component, highlighting dimensions, tolerances, and ...
Title: Demystifying Bitcoin: A Comprehensive Guide to the World's Leading Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulat...
I am in need of a skilled photo editor to provide advanced editing for a set of 30 images. This comprises of not just light adjustments or retouching, but manipulating the images and even adding new elements to enhance them. The details required are as follows: - The images need to be edited to an advanced level, including manipulation and addition of elements. - The final format for the image edits will need to be in JPEG. - These images must be delivered in high resolution. For this task, I require an expert who has extensive experience with photo manipulation and has an excellent command of photo editing software. An eye for details, creativity, and accuracy is a must. Proven experience in delivering high-resolution image edits and an ability to work to tight deadlines will be ...
Title: Demystifying Bitcoin: A Comprehensive Guide to the World's Leading Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulat...
...create a hanging placard in my car that gives passengers the option to contact me directly for rides, whether it's for airport pickups/drop-offs or just running errands around town. This way, I can bypass Uber's fees and provide a more personalized service to my customers. Additionally, I thought it would be helpful to have another placard or sign displaying my barcodes for payment apps like Venmo, Cash App, PayPal, and Zelle. This way, passengers can easily tip me for my services, helping me out financially while also adding a touch of humor to the experience. I have a few ideas for the design and wording of these placards, and I'd love to hear your thoughts on how to make them practical and effective. Let's brainstorm together and come up with something th...
...professional to assist in transitioning our medium-sized business from cash-basis accounting to accrual-basis accounting. The primary reason for initially using the cash-basis method was its simplicity. However, as we have grown, the necessity for accrual accounting has become apparent, and we are ready to implement this method to improve financial reporting. Tasks and Requirements: - Assess the current cash-basis accounting system and propose a structured plan to shift to an accrual accounting system - Help the team understand the nuances of the new system for seamless operation post-transition - Regular follow-ups until the new accounting system is smoothly functioning Ideal candidates should have: - Proven experience with both cash-basis and accrual acc...
I'm seeking a talented and experienced writer for an engaging argumentative essay. The specific topic is not set, but it should be related to either education, technology or health. Here are more details about the project: - Word Count: Your essay must exceed a total of 1000 words. - Writing Style: It's crucial that the entire essay is written strictly in MLA format. Ideal Candidate: - Should have significant experience in argumentative essay writing - Solid understanding and command of MLA writing guidelines - Expertise related to one or more of the proposed topics (education, technology, health) will be highly valued. If you're passionate about these topics and can write compelling arguments, please make a bid.
...enhance the user navigation flow of my existing website using React-Router. Key Requirements: - The primary goal is to significantly improve the user experience through better navigation. - You need to implement dynamic page loading in order to make the user experience even smoother. - The website also needs to have better link management, making it easier for users to find the information they are looking for. Ideal Skills and Experience: - Strong knowledge and experience in React and React-Router. - Prior experience in enhancing user navigation flow in websites. - Proficiency in implementing dynamic page loading. - Familiarity with link management best practices. Your primary focus will be on enhancing the website's user experience and streamlining the navigat...
I'm looking for someone associated with the University of Pittsburgh who is able to scan four pages from a book located at University of Pittsburgh's ULS. This task is for a research project. - No specific scanning device required, an iPhone scan or clear photo will suffice. - No need to convert the scans into any specific format, as they will be used just for reference purposes. The book is in Japanese, but I can guide you even if you only know English.
I am looking for work done to make a 2-page spread for advertisement purposes. The spread will be included in an event pamphlet. The spread needs to include our company logo, business overview, product information, and contact details. The file must in an 8.5" x 11" format with a 3mm bleed for printing purposes. I have attached two pages as a starting point, and other images to be included.
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...
...making work more flexible, organised, and productive. - Intranet & Internal websites: We require a system that allows for effective communication and information distribution across different levels of our company, from employees to executives. Existing SharePoint Tools Desired: - SharePoint workflows: We are interested in integrating SharePoint workflows to systematise and visualise process flow. - SharePoint lists: The use of SharePoint lists for information storage and accessibility is also required. - PowerApps: Implementing PowerApps within our SharePoint environment for mobile-friendliness and easy customization is essential. Skills and Experience Needed: - Proven experience in SharePoint development - Understanding of SharePoint workflows, SharePoint lists, a...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm seeking a junior performance assistant to work with me in the paid performance role. While professional experience is not required, a solid understanding of soc...Responsibilities: - Assist in the setups and management of performance campaigns - Work on the optimization of these campaigns for maximum effectiveness - Help in the analysis of data and reporting Ideal Skills & Experience: - Some knowledge of social media algorithms and metrics - Simple mathematics for budget planning - Interest in exploring and understanding paid performance - Ability to understand the flow and work in a fast-paced environment This role would be perfect for someone looking to start their career in the paid performance industry. The right candidate will have the opportunity to learn and ...
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
I'm looking for an experienced video editor to create a 30-second commercial for my Meal Plan website. Requirements: - The commercial should be based on a voiceover provided by me. The voiceover is already recorded and polished, I just need you to add the visual component. - The ad should be 30 seconds long, so you'll need to match the visuals to the voiceover timing. - The ad sho...- **Attention to Detail**: Ensuring that the video is timed correctly against the voiceover. Nice effects and great transitions should be the main focus. This is an ad for social media platforms. I WANT TO RUN THIS AD ASAP SO IF I FIND A WINNER SOON I WILL END THE CONTEST EARLY AND PICK MY WINNER! please grab photos and product images from please edit video into vertical format for ree...
