EXCEL for MAC (16.4) addin / 3D visualisation of datapoints
€30-250 EUR
Cerrado
Publicado hace más de 3 años
€30-250 EUR
Pagado a la entrega
EXCEL for MAC (16.4) addin / 3D visualisation of datapoints
EXCEL addin 3D-Chart
FOr EXCEL for Mac (16.41)
The addin should enable me to
1. Select an area of 4xN records, whereby
a. The records in the first column shall be the Label of the record (text or Numeric)
b. The records in the second, third and fourth column shall contain the X, Y, and Z values
c. For any N between 4 and 5000 (3<N<5000)
2. Create a 3D chart which shows each record as datapoint in a 3-D visualization
3. With the option to also show the label of
a. one,
b. a selection of or
c. all of the datapoints
The 3D chart shall be truly 3-dimensional
It must be able to
1. rotate around any of the three axis (x,y and z)
2. zoom in and out
3. select the scale of the three axis x,y and z as
a. automatic OR
b. manual (by inputting minimum and maximum)
4. show droplines
a. for
i. one,
ii. a selection of or
iii. all of the datapoints
b. from the datapoints to the planes (e.g. from the x/y/z point to the plane X/Y/0, and/or X/0/Z, and/or 0/Y/Z…. where
c. the dropline starts at the X/Y/Z value of a record and ends at X/Y/0 and/or X/0/Z and/or 0/Y/Z
5. show the x,y, and z axis
6. show the “walls” (the planes, identified by X/Y/0 and X/0/Z and 0/Y/Z ) slightly colored
7. produce a mesh that wraps the datapoints (like a net that wraps a tree, the total surface of all triangles is minimized (therefore, no negative “dents”))
8. show the “cutting line” of the mesh in respect of the “walls”
9. if there is no cutting line, show the shadow of the mesh onto the walls (which co-incides with the drop-lines of the points defining the mesh)
10. if you have questions, raise them.
11. Do NOT ask me to message you with a standard answer. If you want me to message you, your message must start with "Dear Bernhard , I hear you loud and clear" . Else, you havent read until here, waste my time and therfore you will be automatically eliminated from potential freelancers.
Hi there,
I would like to work on your project and want to be discussions. I have 4+ years of experience in the field. I can start working immediately on this project if needed. I have gone through the job description and understand your requirements. I can complete this work with high quality. Message me for more discussion.
Thank you.
I am a MBA Certified + PhD Scholar (Digital Marketing) with having 7 years of writing experience.
Also, I am an IELTS certified professional with an overall band of 8.
I already have 4 published researches of mine and the 5th one is in process. This guarantees my good writing skills.
I am producing unique and quality content for my clients since 2013. I can provide you 100% quality content even in a short period.
I can assure you, "You will hire me again and again after getting my first service".
I look forward to hearing from you. Kind regards,
Greetings,
Hi,
If you are trying to find an excel expert then you are at the right place.
You can get-
Dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Maintain large sets of Excel data in a list or table
Macros and VBA
Dynamic report with Excel PivotTables
Microsoft Excel’s AddIn, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks by mastering the power of Macros and VBA
Creating effective spreadsheets
Managing large sets of data
VLOOKUP
COUNT & COUNTA
COUNTIF & COUNTIFS
AVERAGE & AVERAGEA
SUM, SUMIF & SUMIFS
LEFT, RIGHT & MID
IF
Ranges
Pie, Column, Bar and Line charts
Tons of tips and tricks
1-click forecasting, 3D maps
I am waiting for your response.
Regards
Prateek