Find Jobs
Hire Freelancers

A dynamic Excel funtion

£10-20 GBP

Kapalı
İlan edilme: neredeyse 5 yıl önce

£10-20 GBP

Teslimde ödenir
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
Proje No: 20105063

Proje hakkında

23 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 5 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
23 freelancers are bidding on average £21 GBP for this job
Kullanıcı Avatarı
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 understand everything exactly. Can we discuss this further on personal chat? I am sorry I know nothing about music/frequencies so I would need you to explain me your requirements in a bit more detail, you can leave the excel implementation for the same on me. I look forward to a positive and prompt response from your side. Regards Sourabh
£20 GBP 1 gün içinde
5,0 (136 değerlendirme)
5,9
5,9
Kullanıcı Avatarı
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 Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
£20 GBP 1 gün içinde
4,8 (97 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
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 project. Thanks
£30 GBP 1 gün içinde
5,0 (104 değerlendirme)
5,5
5,5
Kullanıcı Avatarı
£ 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 assure you I will deliver your project within very short time and for VERY CHEAP rate. Please CONTACT me before closing the project, I will send you a DRAFT project file to ensure my expertise. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
£10 GBP 1 gün içinde
5,0 (71 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
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 1 gün içinde
5,0 (30 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
Hi...I have worked on Baccarat prediction Excel, a model similar to this. Please allow me to show you my work on the project. It is a prediction model similar to this one. Best regards Neeti
£55 GBP 1 gün içinde
5,0 (1 değerlendirme)
2,0
2,0
Kullanıcı Avatarı
Relevant skills and experience. I m quick learner and ready to take new challenges required to perform better. I m particular about my schedule and manage time efficiently.
£18 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi, the following is my proposal: You will be able to change the "Open" string value individually by keying in e.g. "E2", "C1", etc. The value on the "Open" string and the on the frets will be adjusted accordingly displaying the note name and the corresponding frequency. From fret 1-20, each fret is increased by one semi-tone automatically based on the value entered on the open string. Similarly, you will be able to change the note name on the chord table, the freq on the Hz column is adjusted according to the model. There will be a drop down button to select Frequency Graph or Ratio Graph to be shown at the same location as requested. I hope my proposal meet your requirements.
£15 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Good at excel Relevant Skills and Experience I have been working on excel
£18 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 Experience Excel, data entry, C, C++, Java
£18 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I'll give my 100% in your work and try to finish your work in time
£11 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I have experience in data entry and excel. M committed to my work.
£18 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
data entry
£18 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 on search engines with the best exposure over the Internet. We can fulfill your desire. We have Highly Trained Professionals & Experienced Workforce, who provide Good Support and Effective Output and ensure we give Committed Timely Deliveries, that is the Mantra of our Success and we never Compromise on our Quality, Services & Support Aspects. What Makes Us Different! We work with a Pool of Professionals to relate to the Clients’ Requirements. We have Data Scientists, Digital Marketers, SEO experts, Data Analysts, Developers, Business Intelligence Analysts, Engineers and Business Operators. This not only gives us an added Edge but also helps us in solving a Problem in Entirety and Helps Clients’ address their issues in Depth. Last week i was completed similar Project.
£20 GBP 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
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 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I will Show my quality Relevant Skills and Experience Ya i have a experience in data entry
£18 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   ISLE OF MAN bayrağı
Douglas, Isle of Man
0,0
0
Haz 26, 2019 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.