Tamamlanmış

Update Excel Data Spreadsheet

Excel workbook - works ok but needs to be able to be printed with standard format and check links so they don't break.

The sheet was done but not completed. It needs the final touches.

What it is is taking a basic csv file of lab results and converting it into something useful.

At present we can into a data section, this uses macros to change it convert it into a sheet that can be printed - this sheet uses ranges to say whether it is high or low. We then examine this to give some recommendations and then using a drop down sheet we then add some comments.

The colours on the results page are too bright - there are some cells that aren't linked properly (just the paddock name and the property name (customer name) in the header (set at Dorrington at the moment), when i select the from the dropdown box in the recommendations it adds these and if i want to write something different i do this in the centre column. This is OK but when i use the format button it doesn't seem to print in the same type or size. It all just needs a tidy up and checking.

f you import the lines of data from the CSV lab results into the Data page of the spreadsheet you will then see the results in the Analysis results. This is fine other than the colour being too bright and the two heading issues i mentioned (sample reference and the Dorrington in the header)
The second page is where all the links are that need fixing. Firstly change the order so that the comments are first and recommendations are second - recommendations only need a small amount of room. Comments work by drop down box - firstly we choose a heading pH/Calcium from the dropdown box. and then in the second row the dropdown box gives the comments that we usually use to explain what is needed with the nutrient from the first list. If this doesn't say what we want we then use the third column to comment with what we want. If there are several comments that we need we have to choose the first drop box heading and then again the second. Once this is complete we then use the Add Visual Format button on the Button sheet and it formats the result page. This doesn't change the typeface or the size to the same so we can read it properly - an it is where there are problems if it is not done exactly as required. Finally there are multiple results where we would only need three at the most. See what you can d0.

Beceriler: Veri İşleme, Excel, Microsoft Office, Visual Basic

Daha fazlasını gör: Get Data Entry Done - 04/06/2017 02:56 EDT, https blog zazzle com 2016 04 22 featured designer julieerieewn x, excel summary spreadsheet workbook 2010, query update excel data using classic asp, update excel data sql table, generate urls excel data spreadsheet, fix phone excel spreadsheet, script update excel data source, excel filling spreadsheet data macro, update excel workbook, visual basic code update excel shared workbook, excel copy data spreadsheet macro, excel vba update imported data, excel macro script insert data spreadsheet, update excel data php, update excel data, visual basic update excel data, excel data workbook, fix css dropdown menu, marketing spreadsheet, sample product delivery spreadsheet, fix advert webite, drupal spreadsheet, web based spreadsheet msaccess

İşveren Hakkında:
( 2 değerlendirme ) Seymour, Australia

Proje NO: #16759550

Seçilen:

fatimatuzzohura

Hi, I am experienced on Excel and VBA. I can start your job immediately also. Please contact me to discuss the project . Thanks

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% AUD
(122 Değerlendirme)
6.1

Bu iş için 19 freelancer ortalamada $45 teklif veriyor

deepabittu

ready now ready now ready now ready now ready

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(208 Değerlendirme)
6.4
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(65 Değerlendirme)
5.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(36 Değerlendirme)
5.5
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(25 Değerlendirme)
4.7
standarditech

Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. I will complete this task with your timeline and [login to view URL] give me a chance to serve Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(75 Değerlendirme)
4.9
microwebtechs

Hello sir, I am ready for start work now and complete all soon, please hire me and share work [login to view URL]

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(28 Değerlendirme)
4.4
datakillers

Hi I am ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always Daha Fazla

in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
4.1
in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(2 Değerlendirme)
1.9
signeortasaso199

I will do this for only $ 5 in three days I’m 2 years experience in data entry and microsoft office I want to make myself a review so i work with little price and high quality .

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
amarendrayadav46

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
Louisleroux

Good day, I'm new with Freelancer, but I am experienced in Excel and I'm a registered Financial Accountant in South Africa with 7 years experience! My focus is on accuracy and time efficiency! I will gladly accept you Daha Fazla

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
thsvo

Hello sir I am a data entry worker and i know how can i do it [login to view URL] you give me a chance i will give my best for you Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(1 Yorum)
0.0
crea8ivevibez

Hi there, I consider myself to be the perfect choice for your job post regarding Update Excel Data Spreadsheet. I am new freelancer on this platform. I have the required skills and experience in this domain, hav Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
berainy

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0