"AI Cost Comparison Dynamic Chart Generation using Laravel"

I am looking for a freelancer to create an interactive Excel Dynamic Cost Comparison Chart with an HTML version for my landing page. The ideal candidate should have experience in creating interactive charts and be proficient in Excel and HTML. My budget is 50 dollars for the following work

"Cost Savings Comparison: Lawyer vs. Mediator for Divorce."

"This dynamic chart illustrates the cost savings and differences in service prices for divorce proceedings when choosing between lawyers and mediators. By adjusting the variables, you can see the potential financial impact on your divorce in various scenarios."

To create a dynamic comparison chart in Excel that illustrates the cost savings and differences in service prices between using a mediator and a lawyer for Public Court Divorces, you can follow these steps:

Step 1: Data Preparation

Create a table in Excel that includes the following data variables:

Average Billable Hours for Contested vs. Uncontested Divorce

Spousal Support Billable Hours

Child Custody Billable Hours (for families with 2 children)

Asset Equalization and Disbursement Billable Hours

Lawyer's hourly rate (e.g., $300)

Mediator's hourly rate (e.g., $150)

Calculate the total cost for each variable based on the provided data.

Step 2: Create the Dynamic Chart

Select the data table you created and go to the "Insert" tab in Excel.

Choose the chart type that best represents your data. A bar chart is suitable for comparing costs.

Insert the data into the chart. Your data will be structured with the X-axis representing the variables and the Y-axis representing costs.

Make sure to label the X-axis with the variables and the Y-axis with costs in the desired currency (USD, CDN, or EU).

Step 3: Title and Introduction

Suggest a title for your chart, such as "Cost Savings Comparison: Lawyer vs. Mediator for Divorce."

Write a brief introduction (two sentences) for your chart: Step 4: Disclaimer

Include a disclaimer at the end of the chart to make it clear that the provided data is for informational purposes only and individual costs may vary: "Disclaimer: The data in this chart is based on averages and should be used for informational purposes. The actual costs of divorce may vary based on individual circumstances and location."

By following these steps, you can create an informative and dynamic comparison chart that allows users to input their variables and understand the cost savings associated with using a mediator compared to a lawyer for divorces.

Visitors to the website will input their variables as indicated below to determine their costs and savings using a mediator

(The variables that change if the visitor the website has a contested or uncontested divorce, if they have children, if the divorce involves spousal and child support and asset dissolution and equalization)

The objective of the graph is to show the price and cost savings in various currencies USD CDN or EU of using mediators as compared to using mediators depending on several variables

Lawyers charge 200-400 USD per billable hour so we use 300 USD as an average

Mediators charge between 75 -200 USD per hour so we will use 150 dollars as an average or half of that of a lawyer

The total hours and total cost for both lawyers and mediators for finalizing a divorce is dependent on several variables that will appear on the X axis

Diagram 1 CONTESTED VS UNCONTESTED DIVORCE

Input Question

Is your divorce or separation uncontested and have you and your spouse agreed on all outstanding issues including, spousal and child support and asset equalization?

YES: Show Uncontested values in bar graph for using mediator and lawyer similar to bar graph below . The lawyer values are shown as a wider pastel blue bar graph with the mediator bar graph on top of the lawyer with a thinner pastel green bar graph

NO; Show Contested values in bar graph using a mediator and lawyer similar to bar graph below in the same way

1 Average Billable Hours for Contested VS Uncontested Divorce

Contested Divorce using Lawyer= approx 40 hours or 12,000 CDN dollars for each spouse for a or total of 24,000 CDN for both spouses

Uncontested Divorce using Lawyer =10 hours x300=_3000 CDN per spouse or total 6,000 Dollars____

2 Average Billable Hours for Contested Divorce using a mediator is 20 hours x150 CDN per spouse for a total of 3000 dollars per spouse or 6,000 dollars in total

Average Billable Hours for Uncontested Divorce is 5 hours x150 CDN per spouse or 750 dollars per spouse or 1,500 dollars in total

Add this information and source reference at the bottom as refeence

According to Canadian Lawyer magazine’s survey on legal fees, the average cost of a contested divorce was $12,000 per party

Assuming an average hourly rate of $300/hour plus GST, this would equate to approximately 40 hours of billable time.

Diagram 2

THE COST COMPARISONS OF A CONTESTED DIVORCE

Question 1

Does your divorce or separation involve spousal support?

No- No change in cost values

Yes - Changein cost values as formula below

Spousal Support Billable Hours using Lawyer =5 hours per spouse x300 dollars per hour

Spousal Support Billable Hours using mediators is 2 hours per spouse 150 dollars

Input Question 2;

Does your separation or divorce involve child custody and parental visitation scheduling?

NO- no change in values

Yes change values according to formula below

If yes how many children under the age of 18 years of age are involved?

Child Custody billable hour using lawyers is 10 hours per spouse for families with 1 child and increases by 5 billable hours per extra child

Child Custody billable hours using mediators is 2 hours per spouse for families with 1 child and increases by 2 billable hours per child

Input Question 3

Does your divorce or separation involve asset equaliastion?

If yes what is the combined value of your assets?

No- no change in values

Yes-

Less than 900,000 dollars?

10 billable hours for lawyer 5 billable hours

10 billable hours for lawyer and 5 billable hours for mediator for each million dollar increment

Sample idea of dual Y axis bar chart with table below but in color with the lawyer divorce larger in the background and the Mediator bar thinner using pastel blue color for the lawyer and pastel green for the mediator costs

With table below each bar explaining the billable hours for both mediator and lawyer for each category

[login to view URL]

Project Requirements:

- The chart will compare financial costs.

- The client already has all the data for the comparison chart.

- There will be 4-6 different categories of costs compared in the chart.

Skills and Experience:

- Proficiency in Excel and HTML.

- Experience in creating interactive charts.

- Attention to detail and ability to accurately represent data.

- Strong communication skills to understand the client's requirements and provide updates throughout the project.

AI (Artificial Intelligence) HW/SW ChatGPT Laravel OpenAI PHP

Numer ID Projektu: #37371443

O projekcie