| User: Verotiana -- 2014-08-05 << 1225 1227 >> |
| Hits: 3213 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to calculate the average of the numbers in the same column? |
| Input Sample: |
| 1,Energy consumed (in mAh)in Transmit mode = 0.007811 2,Energy consumed (in mAh)in Transmit mode = 0.007891 3,Energy consumed (in mAh)in Transmit mode = 0.007703 4,Energy consumed (in mAh)in Transmit mode = 0.013797 5,Energy consumed (in mAh)in Transmit mode = 0.007679 |
| Output Sample: |
| Average energy in transmit mode = 0.008976 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open text file 2. ctrl-h open 'replace' dialogue * set 'search for pattern' to: * uncheck 'print unmatched unit' option * click 'advanced' tab, set 'run following for each matched unit' to: * set 'insert end text' to: 3. click 'replace', done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |