A machine shop has two automatic milling machines. Machines operation output data is in XML format. To improve the energy efficiency of the machines, operation data of power consumption and time stamps for each operation need to be extracted from the XML file. The extracted data will be calculated and then saved for analysis and comparison.Find a solution in software for this problem

Save extracted time stamps and data into a data file

Calculate the average power consumption of each operation

download link to xml file : http://s000.tinyupload.com/?file_id=46661814451637765780

or copy text into new xml file

2500 27 SPINDLE -8.28686 71 -16.8377 9 -15.52957 14 100 100 EX4002 б ¦ ²Dޠ¶²Ͳ ¼øÀ޻² OPEN DOOR THEN CLOSE APRIRE E CHIUDERE LA PORTA ABRIR/CERRAR PUERTA TUER OEFFNEN,DANN SCHLIESSEN OUVRIR LA PORTE PUIS LA FERMER UNAVAILABLE UNAVAILABLE UNAVAILABLE UNAVAILABLE UNAVAILABLE UNAVAILABLE UNAVAILABLE UNAVAILABLE UNAVAILABLE 3937 3938 3940 3944 3943 3943 3939 3937 3937 3931 3925 3921 3919 3920 3918 3918 3920 3922 3919 3915 3913 3910 3907 3904 3899 5805 5805 5807 5807 5806 5803 5801 5797 5794 5790 5786 5784 5781 5780 5777 5776 5779 5779 5784 5789 5794 5800 5803 5807 5808 7128 7134 7136 7136 7143 7141 7141 7141 7140 7143 7142 7144 7143 7147 7154 7155 7158 7159 7161 7162 7160 7163 7163 7166 7170 19437 19430 19416 19414 19423 19429 19426 19420 19421 19435 19440 19425 19414 19409 19413 19420 19412 19407 19414 19423 19439 19440 19434 19441 19455 8795 8792 8794 8801 8804 8800 8802 8805 8810 8810 8801 8793 8795 8798 8796 8790 8784 8789 8797 8798 8796 8797 8805 8815 8818 12572 12579 12585 12584 12581 12591 12602 12602 12598 12596 12593 12601 12596 12588 12596 12599 12609 12616 12612 12618 12629 12636 12637 12629 12623 UNAVAILABLE UNAVAILABLE UNAVAILABLE AVAILABLE ARMED UNAVAILABLE 1.4866400000 1.4863000000 -0.1750000000 210 20955 X Y Z UNAVAILABLE 11 ACTIVE AUTOMATIC 4088.4088 % O4088(SPINDLE TEST CODE) X29.5880 19