Fill spreadsheet with pdf data jobs
...conducting interviews, assessing candidates' suitability, and supporting the hiring process until the positions are successfully filled. Key Responsibilities: - Conducting thorough interviews with potential candidates for the IT Project Manager role. - Assessing candidates' qualifications, skills, and suitability for the position. - Collaborating with the hiring team to shortlist and present the most qualified candidates. - Providing feedback and recommendations on potential hires. Ideal Skills and Experience: - Proven experience as a technical recruiter, particularly in IT-related roles. - Familiarity with IT Project Manager roles and responsibilities. - Strong interviewing and assessment skills. - Excellent communication and interpersonal abilities. - ...
I am looking for a skilled freelancer to help me co...mentions in bio or recommendation Deliverables: - A completed spreadsheet with the extracted information for all 400 prospects. - The information should be concise, 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....
create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout pla... Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concep...
create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout pla... Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concep...
Beginner level freealancer to create ...you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format 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 ...
We need the following features: 1. Login/ registration 2. Stripe integration 3. Place and order 4. After placing order, user can upload files to start project 5. Admin receives files from order. 6. Email notification about order progress to user and admin 7. Admin uploads final report pdf to order and marks complete 8. User can download report from order page. End of flow. More details: What specific features would you like to include in the SaaS dashboard? User management, Payment processing, Upload and download files How do you envision the user interface of the SaaS dashboard? Modern and intuitive design What level of user access control do you need? Basic (e.g., admin and user roles only)
...column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient More agentes are necessary. ADMINISTRATOR PAGE: The administrator can add, edit or remove an agent. Just Name, Surname, phone, email, username, password The administrator can see the list of products, delete one, add another line, edit one line. AGENT PAGE: If the agent logins he can see a list of all the products with quantity bigger than 2. On each raw we want to put a s...
...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. Send me a picture for example of one of our sofas send previous projects 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. Po...
I am looking for someone that can design homes using SoftPlan software. I have already started the design & can email the SoftPlan files & digital PDF copy of the plan we need drawn.
...These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate for non-technical users. It is essential that this application runs efficiently on a Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application...
...Hospitality • Insurance • Legal • Podcasting • Real Estate • And More! Some copy we’ve used before: • Virtual Assistant Services - Admin Tasks - Sales Calling - Customer Support - Lead Gen - Data Entry • Success Begins with the Right Team • Reduce Costs up to 70% Branding Guidelines: Brand Colors: Blue (#2092E1) and Orange (#F66E0A) Font: Roboto family Target Audience: • MSME: The design should appeal to micro-, small-, and medium-sized enterprise (MSME) business owners, executives, and hiring managers in the U.S. • Gender-Neutral Appeal: The design should resonate with both genders within our target audience. Other Guidelines: • Focus on Clarity and Conversion. Deliver a clear message ...
I require a straightforward, user-friendly spreadsheet that calculates energy savings based on specific input. My needs are very particular. Here are the key aspects: Input Specifications: - It should only take one input: an initial savings value representing the savings our product offers. Calculation Requirements: - I expect the spreadsheet to perform calculations for both percentage and dollar amount savings. Results Format: - The results should be shown as simple numbers; I don't need them displayed as percentages or any graphical representations. The freelancer fit for the task should be proficient in spreadsheet software and have experience in building similar savings calculators. A good understanding of energy savings would be advantageous.
A weight loss workbook that is appealing to look at and easy to use. Key Components: - The workbook will have textual content that is structured and visually appealing. - It should...fields, checkboxes, and dropdown menus. These should be designed to be user-friendly and intuitive. The ideal freelancer for this project should have: - A strong understanding of design principles. - Proficiency in creating fillable PDFs with interactive elements. - An understanding of educational content design would be an advantage. - Good communication skills to ensure that the design aligns with the educational goals. Content should contain Weekly weight Daily checkboxes for did I stop when full? eat what I wanted? Notice when I was hungry? Daily movement fill in the blank Spot fo...
...looking for an experienced PCB designer who's proficient with Altium Designer. The project specifically involves a multilayer PCB design. A strong attention to detail and a good understanding of circuit board layout is crucial for this project. Key Requirements: - Proficiency in Altium Designer - Experience with multilayer PCB design with large PCB Boards - Ability to understand and implement complex circuit board layouts - Attention to detail Please provide examples of your previous PCB design work using Altium. A portfolio demonstrating your experience in multilayer PCB design will be highly regarded. This is an LED board which needs layout editing with adding few more components. Please Show your previous work with dense Layout with No...
...help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity ...
I'm seeking a Python developer experienced with web scraping. This job involves setting up a Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautifoulsoup 4 / Scrapy if sufficient and Selenium oth...
...Oracle Apex 20.1 and have an issue with Jasper Reports not executing properly. This can be a server side issue in JasperServer because the reports and applications are working fine in our development environment but in UAT are failing. I need a skilled professional who can troubleshoot and fix this issue. Your main tasks will include: - Analyzing the current setup and identifying what's causing the problem with PDF output. - Implementing the necessary changes to ensure Jasper Reports are correctly executed from Oracle Apex The ideal freelancer for this project would have: - Proficiency in Oracle Apex. - Strong experience with Jasper Reports - Past experience in troubleshooting and fixing similar issues, including server side issues. - Familiarity w...
I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.
We have print data for packaging but in the wrong format. It's a PDF and all single elements needed to create the new print data are delivered. We need someone who can build this 1:1 If there are questions - just let us know.
...converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and accuracy. 1. Google takeout data ...
...Verses We are developing a spreadsheet-based database of the 500 most popular New King James Version (NKJV) Bible verses and collation (into Excel or Google Sheets). The output must be in the NKJV and adhere to a strict protocol - The quotation - Source in a specified format (e.g. 2 Kings 3:2-5 - Maximum 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. We are happy to answer relevant questions for clarification. Ideal Skills: - Native English - Familiarity with the Christian Bible - both Old and New testaments - and various translations - Experience with Bible verse collation or similar projects would be a plus - Famil...
I need assistance with editing and formatting a document into MLA style. - The ideal candidate should have strong editing and formatting skills, especially in MLA style. - Proficiency in working with Google Docs is a must. - Experience with academic writing or editing is a plus. The task involves transforming the existing document into MLA format, ensuring all citations, quotations, and formatting adhere to MLA guidelines. The document is currently in PDF format and needs to be converted to Google Docs.
I require a one-time data scraping project completed on multiple websites. - TASK: The task involves scraping text content from: Google searches: Commercial Real estate agency Saudi Arabia Commercial Real estate agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experien...
...developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher 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 m...
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.
Create a design for a product listing on Amazon. The product is a cover for a towbar. You can find the full description in the assignment in PDF format. Deadline - 7 days
...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 ideal candidate needs to have a keen eye for detail and strong knowledge in medicinally related calculations. This is not only a spreadsheet editing task, but als...
Seeking guidance over the phone or video call on how to fulfil requirements for a Disclosure Review Document relating to a High Court Lawsuit I am a litigant in person for, I have a direct access barrister. I just need guidance, I can do the work myself. I know I need to search my ema...on how to fulfil requirements for a Disclosure Review Document relating to a High Court Lawsuit I am a litigant in person for, I have a direct access barrister. I just need guidance, I can do the work myself. I know I need to search my emails related to each issue and number them, I don't know if I can put it all in pdf or provide attachments of the emails. I will need to prepare a disclosure certificate and an extended disclosure list of documents. You must be familiar with this and E...
I'm in need of a talented graphic designer to revamp my wedding pricing packages with a fresh, clean, modern, yet minimalistic design. Key requirements: - An approach focused on minimalistic, clean aspects to make the presentation elegant and easy to understand. - Bold typography must be taken into consideration for striking design elements. - A graceful color scheme with neutral tones, such as white, gray, beige to give a subtle, refined look. The successful applicant would ideally have: - A keen eye for clean, modern design aesthetics - Solid experience with typography - Expertise in creating minimalistic designs The file is required to be delivered in PDF format. Submissions should display understanding and capture these key elements to be consi...
I'm in need of an exciting architectural rendering for advertising purposes. My ideal freelancer will produce a rendering based on my plans which i will upload to them in either AutoCAD, softplan, or pdf formats. i am looking for exterior front and right side views only .
I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation 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 advan...
I'm seeking a professional to assist me in creating a user-friendly system that allows for the seamless download of academic ebooks in PDF format. The goal is to provide a platform where users can easily access and download academic ebooks in a legitimate and secure manner. Key Project Requirements: - The system should be designed to offer academic ebooks for download in PDF format exclusively. - Academic material will be provided but needs to be refined. Ideal Skills and Experience: - Experience in web development and database management. - Proficiency in ebook handling, especially in PDF format. - Understanding of user experience and interface design. - Knowledge of security protocols for online platforms. For Sample you can download the following for referen...
I have a small LinkedIn network of less than 1100 connections and 1500 followers. I'm looking for someone who can help me consolidate their details into a neat spreadsheet with their emails. Key Requirements: - Extracting email addresses: You'll need to be able to extract the email addresses of my connections and followers. - Data presentation: Organize the data in a clear, logical manner which makes the spreadsheet easy to navigate. - Timeliness: I'm aiming for a quick turnaround on this project, ideally within 24-48 hours. Since I have explicit permission from my contacts to collect their emails, this project is ethical and should proceed smoothly. I'm looking forward to seeing how you can help me in this task.
MY FACE...URL: (please don’t email me direct) I have set up my Facebook campaign demographics and happy with this. But I now want to add the fb pixel to my website to track users who visit my ‘thank you’ page which shows up automatically after an application form is submitted via jotform. The main objective of my website and fb campaign is to get more people to fill out the form here: Please quote for the following work. 1. Set up appropriate fb pixel on my website. 2. Advise on better more affective add creative 3. Any other changes to improve objective Please only contact me with a quote if you have read this in full and confirm that you fully understand my requirements. Thank you.
I have 33x sets of product data in a spreadsheet. I need each product's specifications to be created in a standardized PDF format. The level of detail should include everything detailed on the spreadsheet. The data on the spreadsheet is broken down into the following sections, which must be reflected on the product specifications. - Production Information - Packaging - Pallet Configuration - Physical Data - Chemical & Microbiological Tolerances - Storage - Labeling You will be responsible for: - Creating individual product specifications from provided data. - Ensuring all specifications are formatted consistently in PDF format and include our company logo provided. - Include all the information provided in each produ...
I'm seeking a skilled Python programmer with OpenCV experience, preferably one who has dealt with table detection from PDF and images before. The primary skills desired include: - Python programming - Knowledge of OpenCV - Familiarity with table and structure detection Your main task will be to develop a program that can accurately identify table structures within input files. The files will be PDFs or images, or both. You're expected to program a feature that detects these components: - Cell boundaries - Text within the cells - Overall table structure For the sake of this project, merged cells should be discerned as a single entity during the detection process. Your solution should demonstrate precision in merged cell detection. I look forward to ...
...have a specific PDF file that I need to convert to React-pdf. Key requirements: - Convert a specific PDF file to React-pdf: I have a particular PDF file that needs to be converted to React-pdf format. Ideal skills and experience for the job: - Proficient in React: You should have a strong command of React, particularly with handling PDF files in a web application. - Experience with PDF manipulation: Prior experience in converting PDF files to other formats, particularly in the context of web development, will be beneficial. - Familiarity with image retention in PDF conversions: Experience in preserving images during PDF conversions, especially in the context of React-pdf, will b...
I'm in need of a skilled graphic designer for a long term project. The primary task would involve vectorising, adjusting, and refining client logos. Typically, I receive these logos in JPEG, PNG, and PDF formats. The job typically requires 1-2 adjustments per client request. Key responsibilities: - Adjusting existing logos based on client requirements - Vectorising and refining logos as needed Ideal candidate should have: - Experience in vectorising and adjusting logos - Proficiency in handling JPEG, PNG, and PDF formats - Expertise in making precise adjustments in limited iterations - Strong communication and interpretative skills to understand client's vision and requirements.
...Review and Analysis: Review the draft PowerPoint presentation. Identify areas needing visual improvement and enhancement. Analyze the provided color palette for application. Design Implementation: Redesign each slide, incorporating the color palette. Enhance the maps by refining colors, labels, and overall aesthetics. Ensure all elements (charts, graphs, images) are visually appealing and aligned with the presentation’s theme. Quality Assurance: Review each redesigned slide for consistency and professionalism. Make adjustments based on feedback to ensure high-quality output. Ensure that all slides adhere to the guidelines and project Review and Delivery: Conduct a final review of the entire presentation. Make any necessary final adjustments. Deliver the enhanced PowerPo...
I have a WooCommerce pet food dropshipping website linked to a warehouse FTP spreadsheet containing around 8 thousand products. I need technical development for inventory synchronization with the warehouse FTP spreadsheet on a hourly basis.
...onboarding: Efficiently source, screen, and onboard new talent. - Human resources policies and procedures: Develop, implement, and maintain HR policies and procedures. - Employee relations and conflict resolution: Manage and resolve any workplace conflicts that may arise. - Performance Management: Ensure timely completion of performance management systems. Key Performance Indicators: - Time to fill vacant positions: Reduce the duration between a position becoming vacant and it being filled. - PMS completion: Ensure that all employees complete their performance management systems in a timely and thorough manner. Ideal Candidates should have: - Proven experience as an HR Operations Manager or similar role. - A solid understanding of HR practices and labor laws. - Excellent commun...
I am in need of an experienced graphic designer to develop a digital PDF business catalog (you will find attached a catalog that is similar to what we're looking for) for my consulting and training services. Key Requirements: - Create a professional and engaging layout that effectively showcases my services - Incorporate appropriate branding elements to ensure consistency with my business identity It's important that the catalog is visually appealing and effectively communicates the value of my services. The ideal freelancer for this project will have a good eye for design, strong attention to detail, and an understanding of how to create a cohesive and impactful piece of digital marketing material. Please include any relevant samples of your previous work in...
I'm in need of an ex...process. Here are the specifics: - The primary function of the app is to automatically fill in OTPs. It should have a clear, user-friendly interface that makes the process seamless for the user. - The app should be designed to read OTPs from SMS, so the developer should have a good understanding of how Android's SMS system works. - The app should be secure and reliable, ensuring that the OTPs are filled in accurately and in a timely manner. Ideal Skills and Experience: - Proven experience in Android development, particularly in creating apps that interact with SMS. - Experience with creating secure and reliable applications, particularly those that handle sensitive data like OTPs. - Familiarity with best practices in us...
...helping young children to develop their phonetic skills in a fun and engaging way. Ideal skills and experience for this job include: - Strong background in early childhood education, particularly in phonics - Experience in designing educational materials for children - Creativity and ability to develop engaging animal-themed designs - Ability to create both digital (PDF, apps) and physical (printed) versions of the cards - Familiarity with appropriate language and concepts for the preschool age group Your primary task will be to design and develop the set of phonics cards, ensuring that they are both educationally sound and engaging for young children. It's essential that you have a good grasp of phonics and early childhood development, as well as the ability to cre...
...application. - Document Merging: The app should have the capability to merge documents. - Text Processing: The application should be able to process text. File Formats: - The app should support the following file formats for document import: PDF, Word (docx), and text files. The ideal candidate for this job should have: - Proficient in both iOS and Android app development. - Experience with document processing and merging. - Knowledge of file format compatibility. Please provide samples of your previous work, especially if you have developed applications with similar features. The Db is already designed Here is some key points: User interface in the app • Login/ register (Email verification) • Forgot password • Show the historical orders ...
I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box
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 in need of a professional resume tailor...Tracking System) friendly and highlight my expertise in DevOps and Site Reliability Engineering. The final resume should be provided in PDF format. Ideal freelancers for this project would have: - Experience in resume writing, specifically for technology jobs - Understand ATS compliance to ensure the resume doesn't get overlooked - Ability to highlight specific skills for DevOps / Site Reliability Engineering - Exceptional writing, formatting, and design skills to make the resume stand out Craft the content carefully, with a full grasp of the technology industry standards and jargon. Your attention to detail will be vastly appreciated. Looking forward to working with a professional who can enhance my chances of ...
I'm looking for a skilled graphic designer to create an alternate version of my existing religious conference flyer. The theme of the conference is "The Time is Now."...theme or design. the schedule will be attached. Key Requirements: - Modify the color scheme to fit the theme better, using the colors from the AWC logo. - Update the images used to something more appropriate - Revise the text content for clarity and impact I need the new version delivered in PDF, JPEG, and PSD formats ASAP. If you have experience with religious or community-related designs, that would be a big plus. Please include samples of similar work in your proposal. Also, if you have experience with video, I would like a promo video created as well as a separate project. Looking...
