Hi All,
I have a Excel template for my Humidity and Temperature reading
With the help of the forum expert (Vikas_Gautam) http://www.excelforum.com/members/575994.html
I achieved what I want but my computer is so slow.
Is there any method that makes the calculation faster? because if I will apply it to my datasheet that containing
20 sensors my computer takes time to calculate the given data.
Please find the attached template.
Thank you.
Do you need separate tables for each sensor?
If not, you could use a helper column in Raw, and copy this down (I used E - this can be hidden)
=COUNTIF($A$2:A2,$K$1)
Then to pull the data...
=INDEX('Raw Data'!B$2:B$26066,MATCH(ROW(A1),'Raw Data'!$E$2:$E$26066,0))
copied down and across
Your file is slow because you have almost 100 000 sumproduct formulas
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FDibbins,
Thank you for the reply, Im sorry I didnt get what you mean my a "helper column in Raw"
I have a worksheets for all my sensors that will pull out the data from the Raw Data sheets.
If you dont mind I would appreciate if you can show me a sample file to that.
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks