On page analysis for my website jobs

...the background for each member. Files that members will upload for analysis by pressing the relevant button will be kept in this folder. Once the files are uploaded, they will first be quarantined. If the file does not contain viruses, trojans or malicious code, a virus scan will be performed first. Quarantine will be lifted. The uploaded files will be used for artificial intelligence to learn and analyze. After the artificial intelligence performs the analysis and gives an output, the analysis result will be shown to the user. Temporary files will be deleted when the member logs out of the site. When the buttons on the page are pressed on legal documents uploaded by users, the person performing the function of the button, ...

I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to prod...expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to ma...

Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expressi...level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation materia...

W...using Aveva's E3D software. For this need, we need to model the disciplines of: Civil; Mechanics / Piping (we have already modeled the piping and can deliver it via ); Electrical; Automation / Instrumentation. We will send all projects in the 2D version. It is necessary to create the database using Brazilian technical standards for the petochemical area, which we will provide. We need to receive from this project: - Database; - Plants and Sections extracted from E3D; - Lists of Materials. The deadline for delivering the project is 04/22/2024. All projects must be configured and delivered in Brazilian Portuguese. We will attach all projects for preparation and will be available for questions during the preparation. We attach the project revi...

We need a simple marketing sheet to email potential customer about our company. I have attached a rough drawing of what we would like and some graphics to be used. Below is what text needs to be added. There is an image for paint2 that needs to be the background with an opacity so its not too loud. Final file should be Photoshop. Dimensions - 8.5x11 Text box 1 - Quality Repairs With Lifetime Warranty Text box 2 - Can Start Repairs Immediately Text box 3 - Locally Owned and Operated Text box 4 - Excellent Google Reviews Text box 5 - 2 Convenient Locations Location 1 540 Charles Hardy Parkway Dallas, GA 30157 770-966-2845 Location 2 1350 South Marietta Parkway Marietta, GA 30067 770-795-0323

As a company specializing i...projections, and growth strategies. - Market Analysis: A detailed assessment of the real estate market, including trends, potential growth areas, and target demographics. - Competitive Analysis: A thorough evaluation of our competitors, their strengths, weaknesses, and how we can position ourselves effectively in the market. The intended audience for this business plan is banks or financial institutions, grants, non-profit organizations and government organizations. Therefore, the plan should be data-driven, well-researched, and clearly demonstrate the potential for a solid return on investment. Experience in the real estate market and in securing funding from banks or financial institutions, or other funding sources would ...

I am seeking an MS Office expert to evaluate and discuss a log-in report from my MS Office 365 account. The report includes several IP addresses outside of my own, and I am concerned these may indicate unauthorized access. Key requirements and responsibilities for the project include: - Analyzing the report: Understanding and interpreting the log-in report to identify all IP addresses associated with the account. - Identifying discrepancies: Determining the reasons behind the presence of multiple IP addresses not connected to my usage. - Providing insights: Advising on the potential risks, implications, and actions that should be taken in the case of unauthorized access. This role requires a freelancer with: - Proficient knowledge of MS Office ...

I'm in need of an urgent literature review on the subject of nanofluids and their application in enhancing heat transfer. This review will need to focus primarily on the various CFD numerical approaches employed in said research. The ideal freelancer for this project should have: - A strong background in mechanical engineering or a related field, with specific expertise in heat transfer and nanofluids. - Extensive experience conducting and summarizing literature reviews. Key aspects of this project include: - A comprehensive summary of current research in the field, focusing on the role of nanofluids in heat transfer enhancement. - Specific attention to the use of Finite Element Method in Computational Fluid Dynamics (CFD). - In-depth analysis of ...

...insightful, interactive dashboards on Qlik Sense. Objectives: Redevelop and enhance the existing Qlik Sense application to provide a more intuitive and interactive user experience. Incorporate advanced analytical features to uncover deeper insights into sales data, with a focus on comparative temporal sales analysis. Key Features Required: Interactive Dashboards: Develop dashboards that allow real-time interaction with data. Ensure the dashboards are user-friendly and provide clear, actionable insights. Advanced Filtering and Drill-Down Functionality: Enable detailed examination of data down to individual product sales. Include robust filtering options to analyze data across various dimensions and timeframes. Implement features to compare sales by location o...

I need a freelancer to analyse three different types of vision transformer models: ViT, DeiT, and CCT. The evaluation must focus on their performance in classifying various eye diseases such as Glaucoma, Macular Degeneration, and Diabetic Retinopathy. The key objective of this project is to pinpoint the most efficient model for the task at hand. Skills and Experience: - Proficiency in working with ViT, DeiT, and CCT models. - Strong background in analysing classified images of eye diseases. - Proven record of implementing different vision transformer models for disease classification tasks. These are the research questions I need in my research 1. Which eye diseases may be detected using the primary classification image models? 2. Which datasets are used ...

I need an experienced Shopify developer to replace the default theme cart page with the Kaktus app cart page on my Shopify store. It is very crucial that the Kaktus app cart page matches the overall design and branding of my store. Ideal Skills and Experience: - Proficient in Shopify platform - Extensive experience in theme customization - Strong understanding of cart page functionality - Proven track record of incorporating third-party apps into Shopify stores - Design skills to ensure seamless integration with my store's current look and feel Please bid only if you have hands-on experience with theme customization on Shopify and can deliver a high-quality, visually consistent Kaktus app cart page that ali...

I'm looking for a skilled web designer to create an engaging landing page with the main purpose of generating leads. Details: - This project will need to collect the following information from the leads: email addresses and phone numbers. - Once collected, the leads need to be contacted or notified via email, phone call, and SMS. Ideal Candidate: - Proven experience in designing effective lead-generating landing pages. - Outstanding UI/UX skills. - Knowledge of email and SMS marketing. - Familiarity with data protection and privacy regulations. The ultimate goal of this project would be to create a user-friendly landing page that efficiently collects and manages our lead information. This is a great opportunity for any web designer looking to showcase ...

My website (mobile version only) has some loading issues. I need to fix this. (See the images), Only enter real price, fictitious prices ​​will be reported to the freelancer.

Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - E...difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation materia...

...can create an AWS Step Function Diagram for my GenAI project. The main goal is to gain a clear visual representation of the workflow, especially focusing on the model training and evaluation phases. Key Objectives: - Visualize Workflow: This project involves understanding the process steps of GenAI and creating a clear, easy-to-follow diagram that represents the workflow. Ideal Skills & Experience: - Proficiency in AWS: The candidate should have a deep understanding of AWS Step Functions and how to create diagrams within the platform. - AI/ML Knowledge: Familiarity with the AI/ML domain, including model training and evaluation processes, will be highly beneficial. - Analysis and Optimization: A background in process optimization or workflow analy...

I am looking for a seasoned professional to assist me in growing my stock market focused Telegram group. The primary objective is to attract potential investors and also provide stock analysis and investment strategies to beginner investors and experienced traders. Key Responsibilities: - Utilize your expertise in growing telegram groups to add 1000 plus members to my existing stock market group. - Share latest stock analysis, investment strategies, and other insightful information about the stock market. Ideal Skills and Experience: - Proven track record in growing Telegram groups specifically in the stock market/financial sector. - Proficiency in stock analysis and investment strategies, with an understanding of what would be most beneficial ...

I'm in need of a professional engineer who can help me assess the wind load on a shelter structure in a coastal area. The ultimate goal is to ensure the structural integrity and safety of the Industrial Analyzer Shelter that I'm planning to construct. Key aspects of the project include: - Wind Load Calculation: The engineer should be capable of conducting thorough wind calculations, considering the specific environmental factors associated with a coastal setting. - Structural Integrity: The aim is to guarantee that the shelter design can withstand the maximum wind conditions expected in the location, maintaining its integrity and safety over time. Ideal Skills and Experience: - Engineering Background: The ideal candidate should have a strong background in structural engi...

I'm looking for a skilled developer who can take my SVG/FIGMA design and convert it into a responsive landing page using Bootstrap. Requirements: - Convert provided SVG/FIGMA design to a responsive landing page - Implement the landing page using Bootstrap - Apply a color scheme Skills and Experience: - Proficient in HTML, CSS, and JS - Experience working with SVG images and/or FIGMA designs - Strong understanding and experience with Bootstrap - Prior experience with responsive web design Please note, the landing page doesn't need any specific sections like "About Us" or "Contact Form" - just the landing page itself.

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab upda...

I am looking for a seasoned professional to assist me in growing my stock market focused Telegram group. The primary objective is to attract potential investors and also provide stock analysis and investment strategies to beginner investors and experienced traders. Key Responsibilities: - Utilize your expertise in growing telegram groups to add 1000 plus members to my existing stock market group. - Share latest stock analysis, investment strategies, and other insightful information about the stock market. Ideal Skills and Experience: - Proven track record in growing Telegram groups specifically in the stock market/financial sector. - Proficiency in stock analysis and investment strategies, with an understanding of what would be most beneficial ...

I'm in need of an Excel expert who can assist me with a...an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of sim...

I am looking for a seasoned professional to assist me in growing my stock market focused Telegram group. The primary objective is to attract potential investors and also provide stock analysis and investment strategies to beginner investors and experienced traders. Key Responsibilities: - Utilize your expertise in growing telegram groups to add 1000 plus members to my existing stock market group. - Share latest stock analysis, investment strategies, and other insightful information about the stock market. Ideal Skills and Experience: - Proven track record in growing Telegram groups specifically in the stock market/financial sector. - Proficiency in stock analysis and investment strategies, with an understanding of what would be most beneficial ...

Hello, Just accept the qutoe of £275 . So we can start working on it.. Thanks ?

Complete SPSS data analysis to test hypotheses relating to social media usage and exercise addiction. The goal is to identify and delineate trends and patterns from the data. Include a report for the results using APAstyle

I need to fix errors, and update profile page with facebook and twitter live feeds

Hi NXSOL PRIVATE LIMITED, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm seeking a PPC executive with extensive experience in managing Google Ads and Facebook Ads. Key Responsibilities: - Crafting and optimizing PPC campaigns on Google Ads and Facebook Ads - Analyzing data to generate valuable insights and drive campaign success - Monitoring campaign performance and adjusting strategies as needed Ideal Skills: - Strong understanding of Google Ads and Facebook Ads platforms - Proficient in data analysis and making data-driven decisions - Strategic thinker with excellent problem-solving skills - Experience in increasing website traffic through Facebook Ads - Excellent communication and reporting skills

I need a skilled web developer to create modern and minimalist landing pages for me on a recurring basis. The primary goal would be to promote a product or service, and these pages should be integrated with email marketing tools. Key Requirements: - Experience in designing and developing landing pages in wordpress - Proficiency with modern and minimalist design - Understanding of email marketing tools integration - Ability to deliver at least 3 landing pages per week Send me your landing page references. THANKS

Hi NXSOL PRIVATE LIMITED, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Research Assistant for a Research Project Project Duration: [ 3 months] Overview: We are seeking a highly skilled and motivated Research Assistant to support a significant research project led by a University. The ideal candidate will possess a strong background in financial databases, data analysis, and academic research, with proven expertise in using Stata for data organization and analysis. Responsibilities: Download and extract data from financial databases and annual reports as well as others as required. Efficiently merge and manage datasets from multiple sources to ensure consistency and accuracy. Conduct thorough literature reviews in finance and related fields to support research objectives. Utilize Stata to analyze complex datasets, perform econom...

...experiencing slow loading times, large file sizes, and high server response times on my Wordpress site, and would like to do everything possible to improve my page speed score. To address these issues, I have already implemented some performance optimization techniques, such as minifying CSS and JavaScript files, enabling caching, and compressing images. For this job, I'd highly value your expertise in: - Additional Wordpress page speed improvements - Identifying areas that I might have overlooked - Further technical optimization techniques Being familiar with Litespeed Cache - the plugin I have used - would be a big plus. I am hoping to find a meticulous, experienced freelancer who can quickly and effectively enhance my site'...

I'm seeking an experienced AI developer, proficient in data analysis, a variety of machine learning model development, and natural language processing to bring an image recognition project to life. Specifically, I'm looking for your contributions to: - Thoroughly analyze large quantities of data and draw insightful conclusions from it - Develop advanced machine learning models to fulfill our needs - Apply natural language processing techniques for improved project outcomes - Design and develop AI models to meet project requirements - Convert AI/ML models into APIs that other developers can use - Perform statistical analysis on big data sets - Manage project infrastructure and the development of AI models and projects - Work with other machine ...

...and hardware sources on Raspberry Pis. The collected data is to be transferred between devices and to AWS. Here's an overview of what the project entails: - Data Consolidation: You will be tasked with gathering data from different sources within the app and hardware on Raspberry Pis. - Duplicate Handling: Duplicates in the data set should be automatically identified and deleted before the upload process. - Data Transfer: The consolidated data is to be sent between the Raspberry Pis and also to the AWS platform. - Post-Upload Data Management: After the data is uploaded, you will need to ensure that the data is deleted from the original source. - Dashboard Development: The project also includes the creation of a dashboard with the functionality for historical ...

...cater to the growing population. Key Responsibilities: - Analyzing the geographical data to determine how schools are currently distributed in the region. - Analyzing student enrollment numbers and school capacity data to understand where the demand for new schooling is most pressing. - Identifying the area with the highest population density as this correlates with the need for more school facilities. - Data visualization to showcase potential location for new schools based on data Ideal Skills and Experience: - Proficiency in data analysis, particularly in the education sector. - Capable of working with geographical data. - Strong understanding of population dynamics and how they relate to school planning. - Past experience in regional development...

I'm looking for an experienced data scraper who can extract text data from marketing websites for subsequent data analysis.

...bring my Canva landing page to life. The text is already generated and ready to be incorporated into the design. Key Details: - I will provide a mood board to guide your design process. - The color scheme and overall aesthetic will be clearly indicated in the mood board. Please Include in Your Bid: - Samples of your past work, specifically, designs on Canva would be preferred. Design Elements: - The design should be image-focused. Please incorporate high-quality, suitable images into your layout. Ideal Freelancer: - You should have experience in Canva - An ability to deliver high-quality designs that match the desired aesthetic outlined by my mood board. - Past successful engagement involving the creation of landing pages would be an ideal addition. Th...

I'm in need of a digital marketing freelancer who's experienced in Search Engine Optimization (SEO) and Social Media Marketing, particularly for a Business-to-Consumer (B2C) audience. Specifically, the project will focus on Facebook and Instagram. Key Tasks: - Conduct an in-depth SEO analysis to boost our online visibility and website traffic - Create and implement a robust social media strategy - Manage and optimize our Facebook and Instagram accounts - Regularly generate engaging content and posts - Monitor performance, analyze data, and make data-driven adjustments Ideal Candidate: - Proven track record in both SEO and Social Media Marketing - Prior experience with B2C marketing is a strong advantage - Specific expertise in Facebook and Instagram ...

We require an FMEA expert. Our focus is on electrical and mechanical hardware systems like circuit boards, power supply, control systems, and communication systems. Your role requires you to create a detailed questionnaire and out of it to create a comprehensive analysis document for managuing risks. The ideal candidate must posess: - Proven experience conducting multiple FMEA activities in the past 24 months (provide evidence) - Specialised knowledge on electrical/ mechanical hardware analysis - Proficiency in examining circuit boards, power supply units, and control systems Kindly note that those without proof of previous FMEA execution need not apply. We seek someone who can help us entirely avoid or reduce risk. Your proficiency in identifying, an...

My company is undertaking a project to sell mobile phones to FoodPanda merchants via a 24-month subscription plan. I am using Zoho CRM Contacts module to capture all merchant information, including payments and delivery details. For most of the integrations with other common apps I am using Zoho Flow. As part of the payments, I am using Curlec by Razorpay (Curlec) to collect once off payment (for full upfront for hardware) as well as recurring payments (monthly data connectivity) via direct debit. Curlec obviously is not in the list of supported apps in Zoho Flow but they do have APIs. I want to be able to: 1) Push information to Curlec's direct debit authorization form (so the merchants don't have to key in the details again) such as merchant name, b...

We're seeking a skilled developer to redesign our Radius Manager client software. Currently, when a client's account is set to default, we want the system to direct them to an 'account suspended' page. This page should clearly state that the suspension is due to payment issues. Your tasks include: - Design an 'account suspended' page to be shown when a client's account defaults - The page must state that the 'client is suspended due to payment' - Deployment should be such that this task is executed upon account suspension - The notification about account suspension due to payment should be displayed on a webpage Ideal Experience and Skills: - Experience in client side engineering and UI frameworks - Proficie...

...data analyst to analyse data in SPSS to test my hypotheses relating to social media usage and exercise addiction. The goal is to identify and delineate trends and patterns from the data. I'd prefer to receive the results in a comprehensive report that I can include in a lab report. Key Tasks: - Analyze data - perform correlation, regression, mediation or moderation - Identify trends and patterns - Create a comprehensive report summarizing the analysis, report all results in APA style Ideal Skills: - Proficiency in SPSS, ideally with at least a Bachelors level degree in Psychology - Strong data analysis and interpretation skills - Ability to present findings in a clear, concise manner Experience: - Prior experience with social media metrics analysis is...

For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets...

I'm in need of a skilled Pspice professional who can design simple circuits and conduct simulation analysis urgently for a prototype testing project. Key Responsibilities: - Design simple circuits in Pspice - Conduct simulation analysis - Ensure the circuits are feasible for prototype testing Ideal Skills: - Proficiency in Pspice - Proven experience in circuit design and simulation - Ability to work quickly and efficiently, meeting tight deadlines - Understanding of prototype testing requirements This project is ideal for someone who is well-versed in Pspice and can quickly deliver high-quality results. Your expertise will be pivotal in the success of the prototype testing process.

I am seeking a professional well-versed...analytical and problem-solving skills - Experience in interpreting and analyzing complex data - Proven track record in modeling and statistics - Excellent communication and reporting abilities This task requires someone who can not only understand the theoretical underpinnings of these disciplines but can also apply them in practice. The project is expected to involve a mix of research tasks, data analysis, and potentially the creation of mathematical models. A successful freelancer will be able to navigate the nuances of both Game Theory and Economics, and provide actionable insights from their findings. No teams or companies please. Also, please mention your area of expertise while applying. Automated/ Generic applications will not be en...

As a single phase domestic supply owner in North Yorkshire, I am looking for an experienced electrical engineer who can successfully perform a detailed power system analysis for me. Your foremost task will include: - Analyzing the reason behind the overreading meters, potentially due to harmonics. - Recommending a solution to address the problem. - If the solution is outside the property presenting a paper to OFGEM detailing the science behind the problem, the solution and the party responsible for implementing the solution (Power Supplier or Electricity Board) Ideal Skills: - Strong understanding of single phase domestic supply systems. - Expertise in load flow studies and power system analysis. - Proficient in diagnosing and resolving iss...

I'm looking for a skilled PHP developer to help me complete a landing page with order function and integrate Stripe payment gateway. Landing page is designed already and has some initial PHP code already. The landing page is part of our Affiliate program. Each Affiliate gets their own landing page with their own contact details displayed. Affiliates promote this page and earns a commission on each sale through the page. All this should be recorded in the DB. They way it should work is like this: The code should then take the "username" and use it as a variable to select the right Affiliate in the DB with the corresponding username. Now it takes the details for that Affiliate and shows on the landi...

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent c...

I'm looking for an SEO and content expert to boost my website's visibility, generate leads, and beat out competitors on keyword searches. Key Requirements: - SEO: I need someone to optimize my website for search engines. Your work will involve keyword research, on-page optimization, and link building to ensure my site ranks highly on search engine result pages (SERPs). - Competition Analysis: Identify my competitors, analyze their SEO strategies, and help me outperform them. This may involve identifying gaps in their content and exploiting them, or finding new keywords to target. - Content Writing: The core of this project involves creating engaging and search engine optimized content. This...

Hi, I'm trying to update my workflow. I currently manage a lot of images, and I need to do the following: 1) Bulk scan and assess the images for quality. In the past I've used but this isn't the most accurate method. Sometimes it will miss images that are extremely pixelated and blurry, or filter out good images by mistake. I'm not sure if I should be using something like Amazon Rekognition, Google Cloud Vision, or Microsoft Azure instead? Or if I can save money and still get good results with a local option like OpenCV? I guess it depends on speed and accuracy. 2) I'd also like to be able to scan images in bulk and detect any text. Same question as far as whether or not

I have a need for a spreadsheet that allows me to calculate total price based on numerous factors: Various products with different prices per user and minimum sale prices Total Price based on a calculation of User Count (factoring a minimum that must be met - Hard set) Price factoring in a margin that can be manually entered and calculated Price that factors off of the previous input with an additional margin calculation that can be manually changed Key Requirements: - Data Entry: I will manually input sales data into the spreadsheet. - Calculation: The spreadsheet should be able to calculate unit prices and margins based on the sales data provided. Ideal Skills: - Advanced Excel skills: Proficiency in creating complex formulas for unit price and margi...