I gang

Edit Formulas and Verify Excel Spreadsheet

We have an almost complete spreadsheet with a number of formulas (Vlookups, Ratio Multipliers, Matches) and variables that need editing and verification.

The spreadsheet works with 10 input variables, with a resulting 10 output variables.

Each variable impacts on the output differently, and there are matrices in separate sheets that determine each factor, along with multiplier ratios based on these matrices.

You will have 10 test cases (input and target output) to work with and the formulas/matrices will need to be edited so that each test case is equal to the target output.

You may be required to edit formulas, multipliers, structure of calculations and matrices.

A high level of experience in Excel and Data Analysis is favored.

Please check attachment for example.

Some explanation: Each input test case (Located in rows 15-24) is pasted in column B separately to a resulting output figure (Column P). The output is then pasted in each test case outputs in rows 28-37. Rows 54-63 will then measure the difference between rows 28-37 and 41-50 (standardised results). This is where the target results are nearest to 0 with the exception of 4 for CL.

Our aim is to adjust the ratios and format of the formulas/workings to have very minimal difference in each output case when compared to the standardised results.

We will send the remaining 2 test cases once the spreadsheet has been updated so that we can test its accuracy, since there are only 8 test cases at the moment.

Evner: Databehandling, Excel, Matematik, Statistisk analyse, Statistikker

Se mere: how to find errors in spreadsheet formulas, excel formulas, data validation excel, excel formula editor online, check formula in excel shortcut, error checking excel 2016, check excel formula online, online excel formula generator, excel spreadsheet quickbooks, send bulk mail excel spreadsheet, reformat excel spreadsheet, year plan excel spreadsheet, excel spreadsheet surgery cost, convert excel spreadsheet label, locking formulas excel spreadsheet, excel object programmatically parse rows spreadsheet, excel spreadsheet formulas, excel spreadsheet formulas webpage, convert excel spreadsheet formulas webpage, edit save excel spreadsheet joomla

Om arbejdsgiveren:
( 0 bedømmelser ) Australia

Projekt ID: #18033077

Tildelt til:

krajahs

Hi, I hope you're doing great today! I'm very excited to offer my service. I've read your project description with great interest and my skills appear to match your requirements well. I've also viewed the attachment a Flere

$120 AUD på 1 dag
(1 bedømmelse)
0.0

36 freelancere byder i gennemsnit $152 på dette job

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Flere

$210 AUD in 4 dage
(288 bedømmelser)
7.6
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Flere

$194 AUD in 3 dage
(93 bedømmelser)
6.9
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Flere

$150 AUD på 1 dag
(182 bedømmelser)
6.6
sonarkaushik

I am very able to edit the formula and verify the excel sheet flawlessly as per your requirement. I am ready to start. regards

$194 AUD in 3 dage
(53 bedømmelser)
5.8
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis Flere

$100 AUD in 2 dage
(70 bedømmelser)
5.7
olaideejiwole

I have Masters degree in Economics and Statistics with 7years of professional experience working as a Quantitative Analyst (in the field of Statistics). A professional statistical analyst seeking opportunity to provid Flere

$100 AUD på 1 dag
(22 bedømmelser)
5.1
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Flere

$150 AUD in 3 dage
(58 bedømmelser)
5.4
$138 AUD in 2 dage
(51 bedømmelser)
5.1
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Flere

$194 AUD in 5 dage
(29 bedømmelser)
4.8
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Flere

$100 AUD in 10 dage
(14 bedømmelser)
3.4
gsanggara

Dear Sirsenor, I am interested and available to work on your project. with typically detail oriented person, I am able to work on your project with high accuracy & best quality work. I have read through your proj Flere

$100 AUD in 3 dage
(18 bedømmelser)
3.6
paulodayto08

Hi Good Day! A serious freelancer here. I can help you to complete your excel works in 2 days. I am a vba macro developer for over 8 years now and has  strong knowledge with Ms Excel Formulas and Functions. I creat Flere

$150 AUD in 2 dage
(14 bedømmelser)
3.3
CronyTech

I'm expert in MS Excel formulas and I can do what you need. I have used all types of advanced formulas in Excel and I also have good background on Data analysis. I understand the analysis of the formulas has to be made Flere

$166 AUD in 5 dage
(2 bedømmelser)
1.7
AMC1979

Hello! It is more than likely that nobody reads what I am writing. The positioning algorithm of this platform does this ... Still, I'm going to make some reflections before commenting on your work: 1. I do not h Flere

$100 AUD in 5 dage
(2 bedømmelser)
1.3
Srinivasa2018

I have taken a look at the file. I find very interacting formula and hence will take sometime to understand and edit, thus keeping a week as duration for this project.

$111 AUD in 5 dage
(0 bedømmelser)
0.0
$111 AUD in 7 dage
(0 bedømmelser)
0.0
jorgekoifman

This kind of free lance job is what I was looking for. Fully experienced working with Excel and these kind of formulas.

$194 AUD in 10 dage
(0 bedømmelser)
0.0
arachrzt

Hi, I Have free time now. You can hire me as soon as possible. I will deliver the project between 1-3 days (depending on the difficulty of the project)

$111 AUD in 3 dage
(0 bedømmelser)
0.0
xlsmaster77

As I have a direct experience with a project with similar settings and scope, I am able to realize the project in a very reasonable time and in the highest quality.

$194 AUD in 10 dage
(0 bedømmelser)
0.0
$111 AUD in 3 dage
(0 bedømmelser)
0.0