Đã Đóng

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

Kĩ năng: Excel, Visual Basic, Xử lí dữ liệu, Nhập liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Douglas, Isle of Man

ID dự án: #20105063

26 freelancer đang chào giá trung bình £20 cho công việc này

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 Thêm

£21 GBP trong 1 ngày
(91 Nhận xét)
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 Thêm

£20 GBP trong 1 ngày
(111 Nhận xét)
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 Thêm

£20 GBP trong 1 ngày
(82 Nhận xét)
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 trong 1 ngày
(26 Nhận xét)
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 Thêm

£10 GBP trong 7 ngày
(9 Nhận xét)
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 Thêm

£30 GBP trong 1 ngày
(5 Nhận xét)
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 Thêm

£10 GBP trong 1 ngày
(5 Nhận xét)
1.6
aj916ad

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

£11 GBP trong 1 ngày
(0 Nhận xét)
0.0
manojdn

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

£18 GBP trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0
£18 GBP trong 1 ngày
(0 Nhận xét)
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 Thêm

£20 GBP trong 7 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
0.0
mukeshmehra941

data entry

£18 GBP trong 1 ngày
(0 Nhận xét)
0.0
Shweta0595

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

£18 GBP trong 1 ngày
(0 Nhận xét)
0.0
£18 GBP trong 1 ngày
(0 Nhận xét)
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 Thêm

£18 GBP trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

£10 GBP trong 2 ngày
(0 Nhận xét)
0.0
cinderellaaslam

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

£18 GBP trong 1 ngày
(0 Nhận xét)
0.0