Create an excel file following the structure of supplied file to produce calculated values in the dated area (Q1 to CNxx).
Code Logic: if headerdate=(startdate+activitydays),insertvalue of sum(quant/activityrate),"null")
Long-Hand Description:
IF the headerdate [as known from the first cell of this column] EQUALS the startdate [as known from the cell in the same row in the fifth column] PLUS the activitydays [as known from the associated croptype range determined from selectable named dropdown list from same row in the second column [croptype range on same sheet] THEN insert the value of the sum of the Quantity [as known from cell in the same row in the fourth column] DIVIVED BY the activityrate [as known from the associated croptype range determined from selectable named dropdown list from same row in the second column [different row as the acivitydays] OTHERWISE leave cell blank.
sample hard-coded values in row 8 and 9.
Column F to P hidden in normal use.
Unless a better method can be achieved easier
Hello,
I think I could complete this project.
I could upload a YouTube video tommorow where you could see if it is done properly.
I have a question whether the cells are valid values:
Q9 (1)
AD8 (null)
AL8(empty)
etc.
Best Regards
Jan Krzyzak
$30 USD em 3 dias
5,0 (6 avaliações)
3,0
3,0
14 freelancers estão ofertando em média $37 USD for esse trabalho
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to discuss with you about the project.
Hello
I am an excel expert and would like to bid on the project posted by you.
I have completed more than 100 projects in excel.
FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work.
Quick turnaround.
Rgds
Rohit Pithisaria
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros.
Check my reviews. They speak for themselves.
Best regards
I have completed many tasks in Excel. I can sure do this one also. However, some seems amiss in you long hand description. First the number of opening square brackets [ is not equal to the closing square brackets ]. I am unable to find out what the activity rate is. Is it the numbers (plants/hr) in the second row?
Dear,
Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years.
Regarding The project:
Please more info in PM if you are interested.
Thank you. :)
I await your reply.
With Kind Regards
Boris
I have very extensive knowledge and experience (16 years) with Excel and VBA coding. The project that you describe is very simple and I believe that I've bid accordingly. I hope to have the opportunity to work with you.