Lukket

A dynamic Excel funtion

Hello, Interesting project! Should take less than 30 mins

I'm making a model on Microsoft Excel to visualise the frequencies of notes on a guitar neck. I've placed an image under the model to demonstrate the appearance I am trying to create. It's important to be able to view the full model on one screen without using the scroll bars. I ran into difficulty as many of the values computed are contingent upon each other as will be explained below. I have split the task into three sections for clarity:

Note, the Green table on the left illustrates each note name of the musical alphabet and it's frequency. The difference between each note e.g. C0 and C0/D0 is called a semi-tone

Section 1:

I was producing a model guitar in Excel based on the image below the model (Please see attached). I have input the standard tuning on the "Open strings". Is it possible for the following frets 1-20 to accordingly increase by 1 semitone systematically based on the "Open strings" values. For example, "F2 87.31" would automatically follow "E2 82.41" under fret 1, and F2/G2 92.50 would follow this under fret 2 and so on up to fret 20.

It is also important that the "Open strings" can be changed individually. For example, the "E2 82.41" can be tuned down to "C2 65.31". In this case, Fret 1 would automatically adjust to "C2/D2 69.00" and Fret 2 would adjust to "D2 73.42" and so on upto fret 20.

Section 2:

I have made a table above the guitar neck model which currently shows the note names of the "open" strings in the model and their frequencies to the right as labelled under "Hz". From this, the music ratio's are automatically calculated onto a graph. Is it possible to link this with the model? For example, you could change the "Note name" E4 in the table to equal "fret 1" on the model (Which is F4) with the Hz on the table also increasing from 329.63 to 349.23.

Section 3:

It would also be beneficial to place the frequency graph and ratio graph in the same place with a drop down option to choose which one would be shown as to keep the model on one screen.

Best regards,

John

Evner: Excel, Visual Basic, Databehandling, Dataindførsel

Se mere: dynamic excel form, create dynamic excel report visual basic, chart dynamic excel cell time stock data, good dynamic excel chart, dynamic excel charts row, vba dynamic excel, vba form dynamic excel, solver inputs dynamic excel vba, dynamic excel forms, dynamic excel graphs, excel funtion, chart dynamic excel 2003, excel funtion environment, dynamic excel model, convert dynamic excel php, dynamic excel page, build a dynamic web page based on input data provided

Om arbejdsgiveren:
( 0 bedømmelser ) Douglas, Isle of Man

Projekt ID: #20105063

26 freelancere byder i gennemsnit £20 på dette job

polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Flere

£21 GBP på 1 dag
(91 bedømmelser)
6.6
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. What you have explained looks definitely possible but I did not understan Flere

£20 GBP på 1 dag
(111 bedømmelser)
5.6
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Flere

£20 GBP på 1 dag
(82 bedømmelser)
5.6
sevillajk01

hello! let me help you with your project. I would love to discuss with you more on details. I offer high quality and accurate output. Hope you will consider me, thanks.

£15 GBP på 1 dag
(26 bedømmelser)
4.4
sergeyprince

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o Flere

£10 GBP in 7 dage
(9 bedømmelser)
2.6
rashedkhanrubel

Hi, I have read the project description & seen your attached file. I shall solve your problem very easily as one of my guitarist friend is beside me right now. Please send a message so we can discuss more & start the p Flere

£30 GBP på 1 dag
(5 bedømmelser)
2.5
AnowarRatul

£ 10 GBP ONLY !!!!! Sir, I have seen your attachment and understand your requirements very well, it is quite basic to me. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I can Flere

£10 GBP på 1 dag
(5 bedømmelser)
1.6
aj916ad

I'll give my 100% in your work and try to finish your work in time

£11 GBP på 1 dag
(0 bedømmelser)
0.0
manojdn

I will Show my quality Relevant Skills and Experience Ya i have a experience in data entry

£18 GBP på 1 dag
(0 bedømmelser)
0.0
Floatplanes

I have the sheet completely built and ready to use. I can send a picture if you would like to verify before accepting. Pricing can be negotiable.

£50 GBP på 1 dag
(0 bedømmelser)
0.0
£18 GBP på 1 dag
(0 bedømmelser)
0.0
SpeedTailV

Dear, The online world has become a very competitive place today, and every business wants a stronger visibility here in order to reap maximum benefits. In addition, the last thing that a business wants is top ranking Flere

£20 GBP in 7 dage
(0 bedømmelser)
0.0
akhiljamdar

i have been working in Excel by [login to view URL] of some financial issue , i am looking into part time job. i will do your job by giving 100%

£14 GBP in 2 dage
(0 bedømmelser)
0.0
mukeshmehra941

data entry

£18 GBP på 1 dag
(0 bedømmelser)
0.0
Shweta0595

I have experience in data entry and excel. M committed to my work.

£18 GBP på 1 dag
(0 bedømmelser)
0.0
£18 GBP på 1 dag
(0 bedømmelser)
0.0
Vikieee

Hi sir... i read your description...and I Would like to work with you..and i am new in this so would like you guide me in some case....so i get better knowledge...so i am waiting for your response. Relevant Skills and Flere

£18 GBP på 1 dag
(0 bedømmelser)
0.0
vasu123g

Hello I'm good in MS office like Ms exal and word PowerPoint and food in data typing yen good skills at data typing with words.......

£18 GBP på 1 dag
(0 bedømmelser)
0.0
hayteekeys5

My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle - etc. A professional having more than 5 years of experience in financial modeling, VBA macros, MS Of Flere

£10 GBP in 2 dage
(0 bedømmelser)
0.0
cinderellaaslam

Good at excel Relevant Skills and Experience I have been working on excel

£18 GBP på 1 dag
(0 bedømmelser)
0.0