Excel vba select sheets print jobs
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I'm in need of a creative professional to design a business card for me. Key Requirements: - The card should...card for me. Key Requirements: - The card should include my Name, Job Title, and Company Name. - I'm open to adding more information so please feel free to ask. - I'm looking for a Bold and Colorful design style, something that will stand out. - The business card will need to be designed for both digital and print. Ideal Skills/Experience: - Experience in creating engaging and visually appealing business card designs. - Proficiency in graphic design software for both digital and print formats. - A creative eye for bold and colorful designs. Please share your past works and let me know what kind of information you need from me to get started. Look...
I'm looking for experienced, and potentially local (NC, SC, GA) writers who are passionate and knowledgeable about boating, for articles to be published in a boating magazine. The project requires the creation of informati...tips - Popular boating destinations - Upcoming boating events - Boating accessories - Boating clubs Ideal Skills: - Excellent writing capabilities - Solid knowledge about boating - Ability to captivate both beginners and experienced boaters as well as boat enthusiasts Deadline: We are looking to launch a magazine in the summer in the Carolinas & Georgia. Our first deadline is June 1st, and we print 6 issues per year. Willing to hire as an ongoing writer if we find the right fit. Local knowledge is a plus! I look forward to catching your wave of creati...
...Additionally I have also provided some old Nike logos that I like to give you an idea. Also the logo should be easily printable to apparel so the logo should be black & white. What is your price? How many revisions do I get? Key Project Details: - Type: Logo Design - Style: Modern Primary Uses: - Website - Print (Business cards, brochures) - Merchandise (T-shirts, mugs) The ideal candidate will have: - Strong portfolio of modern logo designs - Ability to design for both digital and print mediums - Experience in creating logos that work well on merchandise Please include a link to your portfolio in your application....
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...
I require assistance with building financial reports specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing financial reports, - Solid knowledge in standard balance sheets creation. The final product should be a standard balance sheet report that can integrate seamlessly into my workflow. Individuals with keen attention to detail are highly preferred.
I'm looking for a talented and creative logo designer who can create an abstract style logo. The logo will need to be versatile, suitable for use across various platforms such as my website, print materials, and social media. The key color scheme I have in mind is black with a matte red. Ideal Skills: - Proficiency in designing abstract logos with a modern touch - Experience in creating versatile logos for different mediums - Strong understanding of color psychology and the ability to work with specific color schemes Please share your portfolio which showcases your previous logo design work, especially with abstract styles.
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I'm looking for a talented 3D Modeller with expertise in product printing to create a high quality model. This project does not require any texturing, but needs to be of a level detail ideal for 3D printing. Experience in designing for 3D print is essential for this project. The color is indifferent.
NO 3D LOGO RENDERS. NO AI GENERATED LOGOS. I am seeking a skilled graphic designer to recreate a existing logo from a PNG file. The goal is to have the logo look completely identical but with editable text. It is critical that no design elements are changed and the colour scheme remains identical. If you are experienced in creating logos with editable text a...the font file for the text, so a match will need to be found or a very similar looking font used. Please start your bid with "Celebrate little victories", otherwise it will be ignored. You will have to deliver the final version of the logo in an editable format (.ai, .psd or .cdr), all the fonts used in the design, the final palette with hexadecimal codes as well as printable files. We will select a bid today (...
...Resources and Safety), I need to be able to select the responsibilities or accomplishments I wish to include for each past employer. I need to reduce my 5 page resume and tailor each resume for each employer. Currently spending an hour or more to tailor each resume. Key features: - Customizable sections - Ability to choose responsibilities to add for each employer from a list of responsibilities that can be added to. - The following sections are to be included: (1) Name/Contact information (2) Summary (3) Professional Experience (4) Technical Skills (5) Professional Designations (6) Education (7) Certifications. Export formats: - PDF - Word Not sure what format this would best be suited for. Could use Excel, Access, Word (as long as can select the data ie check b...
Looking for someone who knows how to use the program bar tender to design and print stickers for my products.
I need a skilled professional to convert my medium-sized plastic electrical equipment into a 3D model optimized for 3D printing. Key Requirements: - The item to have the same size as the original model - The final 3D model should be optimized for 3D printing specifically. Ideal Skills: - Expe...to have the same size as the original model - The final 3D model should be optimized for 3D printing specifically. Ideal Skills: - Experience with 3D modelling and rendering. - Proficiency in 3D printing optimization. - Knowledge of the AnyCubic 3D printer will be a huge plus. Please include a brief overview of your relevant experience when applying. I have some plastic pieces that I need to print out because when I scan them myself there's a little bit of a difference and I need i...
I'm in need of a talented illustrator to create some cartoon stickers for me. These illustrations are going to be used for my small business. - The style I...need of a talented illustrator to create some cartoon stickers for me. These illustrations are going to be used for my small business. - The style I'm looking for is a fun, engaging cartoon style. - The stickers will be printed on sheets, so I don't need them to be in a specific shape. - It's crucial that the illustrations are vibrant, eye-catching and cute. I don’t have a big budget so please keep this in mind:) The ideal candidate for this job is someone with experience in creating high-quality, engaging cartoon illustrations. Experience in designing for print. Please provide samples ...
...manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-down list. They should be able to start typing the name of the exercise and the drop-down list should filter based on their text. Eg. if they type 'squat', the contents of the drop-down list should narrow to all exercises that contain the word 'squat'. - Exclusive admin rights: I would like to have sole control ove...
I'm looking for a programmer to help me build a visa appointment bot for personal use. Key Requirements: - This is a personal project, not for a business, and the primary goal is to automate the task of securing a visa appointment. The Bot: - The bot should be able to navigate a visa appointment booking system, select the appropriate options, and secure an appointment on my behalf. Skills and Experience: - Proficiency in bot programming and automation is crucial. - Experience with task automation and appointment booking is a plus. - Understanding of web scraping and navigation is a requirement. - Attention to detail is important to ensure the bot selects the correct options during the appointment booking process. Please get in touch if you have prior experience with ...
I'm looking for a skilled designer to create a logo/graphic that encapsulates the essence of my 100% employee-owned commercial HVAC company. We believe in people-first principles, building relationships, and trust. Key Points: - The logo should primarily incorporate the colors blue and green. - The intention is to use this logo across both our website and print materials. - Should aesthetically resemble the new company logo attached Ideal Skills and Experience: - Proven experience in logo design, with a strong portfolio showcasing versatile design styles. - Understanding of branding principles, particularly in relation to reflecting company values. - Ability to deliver a design that is both modern and timeless, suitable for use across different mediums.
...without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Statu...
...bright and colorful flyers that are striking and attention-grabbing - Designing social media graphics that are engaging and aligned with contemporary trends - Creating print media designs that are visually appealing and convey information effectively - Developing digital advertising content that is impactful and drives conversions The ideal candidate for this role would have a proven track record in both flyer and media design, with a strong portfolio that showcases: - Experience in creating compelling and colorful flyer designs - Ability to create engaging and effective social media graphics - Proficiency in creating print media designs that are visually appealing and informative - Experience in designing digital advertising content that drives results If you believe yo...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I need to make a new version of the enclosed little explainer graphic. The changes must be: - Colors and style match better with our flyer - Easier to see the text - following points added (arrow can be to left side of the product): - No electricity needed - installed in 4 minutes As base you must use the photo of the product where the hose is grey - which is also enclosed...(arrow can be to left side of the product): - No electricity needed - installed in 4 minutes As base you must use the photo of the product where the hose is grey - which is also enclosed. If you feel you need to understand the product better before you do this - have a look at our video: I need this in sufficient resolution to use both in print and online.
Need a solution A barcode app to print and track our inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Size/Expiry/Selling PriceA/X/X/X/X/X/XX/XX/XXXX/XXXXXX.00Item description must print on the lable More details: We wish to use this app to count our inventory using bar code scanners Also when items are placed in a box to transfer between two shops, we need it to be able to use the scanner and count accuracy. Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
I'm in need of a comprehensive warehouse inventory replenishment tracking system for our Fastener drawer at Home Depot. The system should have a focus on reporting and analytics, real-time bin shrink, and work with an electronic keypad and analog/digital interface. Key Features: - **Reporting and Analytics:** The system should provide insightful reports on inventory levels and...or product...... its probably going to be based on a simple reason to move forward ( like the developer has done it already with Home Depot, or a provided realistic not full functioning sample gets provided for assessment) Anything that has the name Crown Bolt 8979, a graph, a chart.... even done on the existing Ai created spreadsheet would be impressive to the stire lecel personel who will select...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to send...
I need an expert to help me select the most suitable all in 1 programming language for building various applications targeting multiple platforms (mainly web) 1. I would like to build applications for Web, iOS, Android, Windows 10, Linux, and MacOS & embedded systems (like micro controllers) from single code base 2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Da...
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
I have an Excel sheet with construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualization and report ...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
I need a system that automates some feature on my website, focusing on identifying specific numbers and responding accordingly. Main Features for Automation: - Identify 1-digit numbers from the website - Track 10 consecutive numbers less than 2 - Upon detection, the system should: - Fill amount and apply for bet. Ideal Skills and Experience: - Profic...consecutive numbers less than 2 - Upon detection, the system should: - Fill amount and apply for bet. Ideal Skills and Experience: - Proficient in web automation - Experience with identifying and tracking specific data on websites - Ability to integrate a betting mechanism in the automation process Please note that this project is not for developing a betting site. It's focused on automating a few select features on an ex...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I'm in need of a skilled digital print designer for a clothing line. The prints I need include abstract, floral, and geometric designs. These will be used for dresses. Key Responsibilities: - Create high-quality digital prints design - Design prints that are suitable for clothing, particularly dresses,crop-tops,co-rds,t-shirts, - Ensure the prints are original and in line with current trends - Deliver designs on time and to brief Ideal Skills and Experience: - Proficiency in graphic design software such as Adobe Illustrator - Strong portfolio of previous digital print designs, particularly for clothing - Understanding of fashion trends and willingness to adapt designs accordingly - Excellent communication skills to understand and fulfill design briefs If you have a pa...
I'm looking for an experienced logo designer who could aid in creating a branding logo for my business. This should showcase our professionalism, creativity, and modernity. The logo should ...personality. - Abstract Shapes: A unique and distinct abstract shape that complements the typography and illustration. Ideally, the freelancer will have: - Deep understanding of graphic design principles - Experience with typography and abstract designs This logo will primarily be used for branding purposes. So, it should be versatile enough to be applied across various mediums such as digital and print. It should instantly resonate with our brand's personality and mission. This won't just be a logo, but a symbol of our brand's identity. So, put on your creative caps and...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
I'm in need of a skilled 3D illustrator, specifically someone well-versed in creating cartoon-like characters. The project consists of creating an engaging scene depicting a South Indian family enjoying their meal. The expressions and postures of the characters should primarily focus on cooking and serving. The aim is to use this illustration as a colorful and vibrant representation of South Indian culture in a pamplet for food product promotion. Experience or familiarity with Indian culture would be highly appreciable, but visual creativity is paramount. If you believe you can bring these characters to life with your artistic skills, I'd love to connect with you.
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
...cross-platform service app similar to URBAN CLAP. The app should be available on both Android and iOS devices. Key Features: - User Registration: Users should be able to create accounts and log in securely. - Service Provider Registration: A feature that allows service providers to register and offer their services on the app. - Service Booking: Users should be able to browse available services, select, and book them. - Payment Integration: A secure payment gateway should be implemented to facilitate transactions between users and service providers. Ideal Skills and Experience: - Proficient in cross-platform app development - Knowledge of creating user-friendly and engaging interfaces - Experience in integrating secure payment gateways - Previous experience in developing servic...
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
...visually stunning print materials that will be used to advertise my products. Key Responsibilities: - Designing captivating brochures that can effectively market my products. Clear and concise designs are essential. - Creating eye-catching posters that will grab attention and entice potential customers. Ideal Skills and Experience: - Proven experience in print design, particularly in creating marketing materials. - A strong understanding of design principles and the ability to apply them in a way that promotes a product effectively. - Proficiency with design software such as Adobe Creative Suite. Please provide examples of your previous work in your bid. I'm looking for a designer who has a keen eye for detail, creativity, and a good understanding of effective mar...
