Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #).
I need a blank spreadsheet where the user can input the following:
Input: Base #, Sensor # (or all sensors connected to that base), Date (single date).
The spreadsheet would generate the following output:
Output 1: a curve showing time on X-Axis, # of cars on the Y-Axis, # of trucks on the Y-axis (say every 5-minute time intervals)
Output 2: a curve showing time on X-Axis, % trucks on the Y-axis (say every 5 minutes)
18 freelancere byder i gennemsnit $42 på dette job
Dear client I have previously carried out a number of projects in excel using macros and formulas. I understand the scope of work in this project. I can do this project for you with perfection. Roy
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
I am an Excel specialist with a lot of experience in creating automation tools using complex formulas and VBA. Feel free to contact me so we can discuss the details of this project.
Hi If you shared your desired output, for the selected values, it would be easier for me to get the same graph, otherwise we would be talking about the graph. Best Regards, Serdar Yalcin