Find Jobs
Hire Freelancers

A dynamic Excel funtion

£10-20 GBP

Zavřený
Zveřejněno skoro před 5 roky

£10-20 GBP

Zaplaceno při doručení
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
IČ projektu: 20105063

O projektu

23 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
23 freelanceři nabízejí v průměru £21 GBP za tuto práci
Avatar uživatele
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 v 1 dni
5,0 (136 recenze)
5,9
5,9
Avatar uživatele
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 v 1 dni
4,8 (97 recenze)
5,7
5,7
Avatar uživatele
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 v 1 dni
5,0 (104 recenze)
5,5
5,5
Avatar uživatele
£ 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 v 1 dni
5,0 (71 recenze)
4,9
4,9
Avatar uživatele
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 v 1 dni
5,0 (30 recenze)
4,6
4,6
Avatar uživatele
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 v 1 dni
5,0 (1 recenze)
2,0
2,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Good at excel Relevant Skills and Experience I have been working on excel
£18 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I'll give my 100% in your work and try to finish your work in time
£11 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I have experience in data entry and excel. M committed to my work.
£18 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
data entry
£18 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I will Show my quality Relevant Skills and Experience Ya i have a experience in data entry
£18 GBP v 1 dni
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z ISLE OF MAN
Douglas, Isle of Man
0,0
0
Členem od čvn 26, 2019

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.