Row column increment vba macro jobs
I am working with GridCore library from .NET Core. I am having issues getting the column headers to be displayed with the filters added. Now, I am only able to display the column headers titles. I need someone that has proven experience using this library and can give me the solution.
One excel file with macro as per the customer requirement
Project Budget: $125 Project Level: Standard Project Overview: Simple Python script with a HTML front end to allow a user to upload a CSV list of “prompts” and have each one sent as a request to the OpenAI API. There will be multiple prompts on each row. The script will need to move through each column, retrieve the output from OpenAI API, before moving onto the next row. The script should insert the result/text output from each column/prompt/request into a prompt output column of the CSV, then over onto the next row & then automatically download the updated CSV file for the user. Technical Requirements - Server Type: Ubuntu 22.04 - Script Type: Python - Front End Type: HTML - Front End Functionality: - Input API Key into a te...
I need an experienced Python developer with solid skills in webscraping to gather data from the Premier League's stats page (). The required task involves capturing all available statistics and organizing them into rows and columns within a single CSV file: every season is a row, with different statistics as columns. Applicants should be able to provide the following: - Evidence of past work, particularly related to webscraping. - Their robust experience in Python language and relevant industries. - Detailed project proposals outlining strategy and timeline. Given specified needs, Python is the preferred programming language for this project. Previous experience in similar webscraping projects is desirable, demonstrating your ability to
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
...not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabled and adjusted from the admin panel For the selected tariff, pdf invoices should be generated (the form will be provided) with the calculation of the invoice amount depending on the day of the month when the tariff wa...
...not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabled and adjusted from the admin panel For the selected tariff, pdf invoices should be generated (the form will be provided) with the calculation of the invoice amount depending on the day of the month when the tariff wa...
...the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It ...
...supports and deflection check. Additionally calculations for one timber post (probably glue-lam) determining the demand stresses making sure the bending stresses about y and x axis are both 0, determine strength capacity (design for compressive and bending strength) check cross section resistance adequacy and check member stability Finally with a rough working out to calculate the transfer load of column needed for a clay stiff pad foundation in my design Skills & Experience: - Proven civil engineering background with a heavy bias on structural design - Proficiency in load calculations - Extensive experience in material specification - Sound understanding of technical manuals and structural design - Superior problem-solving abilities Involvement in similar projects in ...
I am actively seeking a Google Ads specialist who can assist in increasing my overall sales revenue. Key requirements for the venture involve: - Comprehensive knowledge of Google Ads. The expert should understand campaign setup, optimization, and continuous management. - Experience with physical goods advertisement. The expert should have a track rec...- Experience with physical goods advertisement. The expert should have a track record of successful Google Ad campaigns related to physical products targeting the general public. - Detailed sales-driven strategies. The expert should offer methods of tracking ad efficiency and giving feedback on potential improvements for ad campaigns to drive increased sales figures. Over al all we need is increment in sales on website through g...
Add column to existing table Amend existing API. Only ftp will be provide for work
Scrape license data from the FL DBPR website and deliver into an excel spreadsheet. Two counties: Osceola and Polk. Two license types: Vacation Rental - Dwelling and Vacation Rental - Condo. In the attached spreadsheet the required fields t...Condo. In the attached spreadsheet the required fields to identify the license type and county are shown in screenshots and the second tab as an example. The extracted data is then to put into tabs for each county and license type. Multiple rental locations for a primary name should have multiple entries (rows) with the license details repeated and only the rental location being different each row. There maybe some dynamic features in the website that complicates data extraction. Website:
Good morning I would like to have a simple download counter for my website. This feature should work with mysql php JQuery, add a simple IP control to not increment the counter on each click, then show the download count. A simple "variable php" feedback on the number of downloads will be enough for me, I will take care of displaying it on the site. In the "assets/javascript" directory you have a file in s file there is a function "$("#download").click(function (e)" Config Server : PHP 7 .. 8
The main goal of this project is to improve our React application so it looks professional and has a better overall UX. Below are some of the requirements and will be broken down into milestones. Work items (subject to change before the project starts, may have minor ch...move your cursor over the left pane (left pane scrollbar appears) and move it to the center of the screen (left pane scrollbar disappears) 3. scroll bar should be very thin, maybe 10 pixes on all browsers - Chrome, Firefox, Safari and Edge. 4. Header seems too crowded and needs a bit more spacing and need to increase height ( will send the value later) 5. When you see the list view (one item per row) the logo for walmart seems to go off the screen/item box, it should be within the item box and have some spacing ...
I am in need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel reports. I am looking for s...
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your b...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and d...
I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the prop...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient i...query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Ex...
...pagination, allowing users to navigate through the data in chunks. The data for the grid will be provided through an existing API, so the successful candidate will need to have a solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edit data directly in the grid**: The grid should allow users to modify the data directly within the grid and update the database accordingly. - **Select multiple rows for batch actions**: Users should be able to select multiple rows to perform batch actions, such as deleting or updating multiple entries at once. Ideal ...
...going to be separate for all pages. The header is supposed to be a branch of a tree with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage...
I need to manually add text and picture annotations to a PDF document . I have a pdf document but pictures do not show up some places in the document, I have the pictures and need someone to have two columns with the original on the left and add the pictures in a second column on the right of the original document where they should have been inserted . there are about 15 photos that need to be matched up . should not be more than 2 hours . also there are 8 names that need to be inserted wherever they show up in the document .
I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Ability
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Prof...query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Ex...
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...
I am experiencing a problematic error with my Excel sheet. An error message k...sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding of Excel functions and spreadsheet error troubleshooting is also required to successfully deli...
...have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively. The 5 different grading options are: Not yet started Not yet submitted Submitted for marking Partially Complete - More work to submit Competent Each cell and submission option will be selected from a drop down list and needs to have a different fill colour (#b4c6e7, #ffd966, #ffff00, #fff2cc, #92d050). The row directly below the ce...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
As the client for this project, I urgently require an expert in VBA.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel format:
...ages-python Need simple process (like click action button and select file with image urls) to extract numeric digits TEXT_DETECTION on JPG images hosted on cloud server using API. ATTACHED: - Sample of image from url and what is required to be extracted. - Data under green header is to be extracted from jpeg file name in image urls - Digits extracted from google vision api to be put under column with header "Google Extracted Text" REQUIREMENTS: - Your relevant experience with Google Vision API or similar text extraction APIs. - Your proposed approach for implementing the extraction process. - A sample of the API usage and extraction results. - Your estimated timeline and cost for completing the project. ******Please note that applications without a sample of API...
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - E...
I'm in need of a developer to create a dynamic list system for my dealership website. This system will display users' offers for cars, ranking them from high to low based on offer amounts. Key Features: - List should be displayed in a table format, with each row representing a user's offer. - The list should auto-update in real-time as new offers are submitted, providing a seamless and dynamic user experience. - Each row should contain the username of the user, their offer amount, the car model and year of the offer, and the date and time the offer was submitted. Skills and Experience: - Experience with dynamic, real-time web applications - Proficiency in front-end development for creating a table format display - Knowledge of back-end technologies for real-...
I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
...currently have a database setup in Airtable. It has all the data that I need for my dashboard inside. But special formulas will be needed to calculate certain aspects of the dashboard. Example: I receive a total of 4 individual payments from a vendor. I initially receive 3 of the 4 payments a week after the sale, but I don't receive the 4th payment until ~a month later. Each payment is a separate row in Airtable, but the grouped payments all use the same SAN#. Therefore, I need Airtable to think, "Okay, I've received the $120, $70, and $35/$45 payment for SAN# 12345, but I haven't received the $20 payment yet." The $120, $70, and $20 are always the same value. The $35 sometimes could be $45. Then the dashboard would show me which sales do not hav...
Development and Enhancement of Excel VBA Project Tracker.
I am looking for an expert in website speed optimization to improve the mobile page speed of my website. The main goal is to enhance user engagement. I believe an improved page speed will keep my visitors on the site longer, resulting in more interaction. Additionally, I need my blog pages laid out in a single column format. This should be optimized to ensure a seamless user experience across multiple devices. While there are no specific responsive elements advised on, the developer should ensure general responsiveness throughout the page, including any present text content, images, or embedded videos. Ideal Skills: - Proficiency in website speed optimization - Experience with responsive website design - Expertise in blog layout design Experience in SEO will be an added advanta...
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experienc...
...been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous,...
• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to ne...• Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book...
I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.
I am on the lookout for an imaginative and skilled illustrator that can transform a promotional photo into a glamourous illustration. We have a promotional photo that we need to stylize to look illustrated. This photo has 9 people in it. The base photo is provided in this bri...glamour in illustrative work. Deliverables will include the Photoshop or Illustrator files in print quality. I've included an example of the type of styling that we are trying to achieve. It borders on cartoon and stylized photo. We are after glamour, sparkles and bling in the resultant image. I would propose that for the first milestone, we concentrate on one of the girls sitting in the front row to settle and agree on the style. From there we can apply that style to the others in the shot and t...