Create Look up form from multiple ranges

£20-250 GBP

Закрито

Опублікований

about 10 years ago

£20-250 GBP

Оплачується при отриманні

Job is to create a form that can return a hauliage price for shipping goods around the UK, from UK to rest of EU, and rest of EU to UK. We would enter the following criteria to be presented with a price: Country from and to Postcode Size of pallet (choice of 6 different sizes) No of pallets (up to 6) Within each country postcodes are grouped into different zones. Each zone will return a price per pallet, varying according to the size of each pallet and how many pallets are being carried. There is a also a different price for going UK to Other country than from Other country to UK. The price presented will take all above factors into account and would be a total price rather than a price per pallet. We have all the data on paper, so the look up data would need to be put onto excel before the form is created. If you have any questions please contact through this site.

Data Entry

Data Processing

Excel

ID проекту: 5847565

Про проект

17 пропозицій(-ї)

Дистанційний проект

Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

17 фрілансерів(-и) готові виконати цю роботу у середньому за £142 GBP

@priyal1997

Dear Sir, I am happy to help you on this task. I have both advanced excel skills and a strong financial background which are essential in this project. I have already developed such currency look-up worksheets for various purposes and I assure you that I will create a dynamic and perfect model for you. If you are comfortable with my ratings and reliability, please share your existing date. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal

£250 GBP за 3 дні(-в)

5,0

(97 відгуки(-ів))

6,2

@maverick44000

Hi Liam. I have read the description and I have understood the project requirements mostly however a few things need further explanation. Kindly discuss in detail, so I may make a sample for you prior to formal awarding of the project. Regards. Usman.

£150 GBP за 3 дні(-в)

5,0

(38 відгуки(-ів))

6,0

@zExcel

Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

£138 GBP за 1 день

5,0

(69 відгуки(-ів))

6,0

@chriskerpini

Hello, This can be done with VBA code and formulae. A dialog box will allow you to enter the criteria or select them from drop-down lists, and the VBA code will do the rest accurately and efficiently. My only question has to do with the format of your data: Saying "we have all the data on paper", do you mean printed pages? And if yes, how many pages there are? Depending on the total number of pages, their importing into Excel sheets could be easy or time-consuming... That's why my bid is for 3 days; I can't give an accurate estimation without an answer to this question. For the coding part of the project I need max 1 day, but I'm not sure for the rest... A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA programs, of almost any kind and difficulty levels, for both training purposes and business. Looking forward to hear from you, Kind regards, Chriskerpini

£120 GBP за 3 дні(-в)

5,0

(22 відгуки(-ів))

4,7

@gitapodder1989

I am the top ranking statistics and mathematics freelancer ( ranking 1) in freelancer.com.I am master in using excel formula and functions. I have gone through your project and can surely help you completing this.

£150 GBP за 7 дні(-в)

5,0

(16 відгуки(-ів))

4,6

@siddhu1986

Hi, Experienced Web Developer. Have worked on such script before. Recently I did an Ebay Delivery Price Estimator (data coming from Excel datasheet converted to Website Database). This will need HTML/PHP. Regards, Sid

£98 GBP за 2 дні(-в)

5,0

(4 відгуки(-ів))

4,1

@rumapaul

Hello I am interested to work on this project I have few queries, please contact me through PM Waiting for your reply Thank You

£150 GBP за 3 дні(-в)

4,3

(14 відгуки(-ів))

3,8

@aarifakhtar

Hi: I have sample form ready. I can share it with you. However, the website does not allow freelancer to communicate with employers unless the employer is the one who starts the conversation. Please connect with me to discuss more.

£166 GBP за 7 дні(-в)

5,0

(6 відгуки(-ів))

3,5

@hdlong66

Dear liamdg. I'm interested in your project and can start immediately. Please provide info to key in the form. I can do data entry also creat formula in Excel to extract info by several conditions. Wait for your positive reply. Thank you.

£80 GBP за 7 дні(-в)

5,0

(9 відгуки(-ів))

3,5

@viktormihalkov

Hi Liam, I was leading a data analytics division for one large company where I had full responsibility for all reporting done across the departments. I would like to support the project. If you award it to me, I can start within a day. Please don't hesitate to raise any additional questions that you might have. Kind regards Viktor

£120 GBP за 2 дні(-в)

5,0

(5 відгуки(-ів))

3,3

@dank111

Hi, My name is Dan. I am an expert in excel and can help you achieve the desired results. I am excellent with advanced lookup function with multiple ranges. I can code the formulas and embed them in the form so that the user can input the criteria and hits Calculate to display the results. It will be great if you could share the data range for me to have a look. Thanks ! Regards Dan

£116 GBP за 3 дні(-в)

5,0

(3 відгуки(-ів))

1,6

@ElaineTeo

I have skill work with excel program,i can build system with excel for make simply report with nice view, please check my portfolio, and I am graduated in accounting courses. In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables. So I very confidence can give you what you want as soon as possible, I can start my work in any time.

£25 GBP за 3 дні(-в)

3,9

(2 відгуки(-ів))

1,7

@shourav24092

A proposal has not yet been provided

£150 GBP за 3 дні(-в)

4,0

(2 відгуки(-ів))

1,6

@prasoonkrdubey

I am good in excel and have experience of about 9 years, actually I enjoy working on excel. Prasoon

£244 GBP за 5 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@mansibagga

I handle large amount of data on daily basis and use reference ranges regularly. I can carry out your assignment with ease and speed.

£200 GBP за 4 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@bowenr78

I work on very similar projects daily and should easily be able to create a form for you using the information you have. I am new to freelancer (hence the lack of reviews). If you send me a private message I can send you an example of a form I have created during my day job. Best regards, Richard

£111 GBP за 1 день