Spreadsheet: 181409d1348028863-mapping-data-from-multiple-rows-into-one-how_to_auto_map_live
Sheet: Admin-Ent1

 |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19
Code | Account description |  | Forecast LE
 |  |  | 2013-01-08 00:00:00 | 2013-02-08 00:00:00 | 2013-03-08 00:00:00 | 2013-04-08 00:00:00 | 2013-05-08 00:00:00 | 2013-06-08 00:00:00 | 2013-07-08 00:00:00 | 2013-08-08 00:00:00 | 2013-09-08 00:00:00 | 2013-10-08 00:00:00 | 2013-11-08 00:00:00 | 2013-12-08 00:00:00 | FY
101 |  |  | 17.04841175 | 17.04841175 | 17.04841175 | 19.337189395 | 19.337189395 | 19.337189395 | 19.337189395 | 19.337189395 | 19.337189395 | 19.70084187099999 | 19.70084187099999 | 45.428678531 | 251.998733893
103 |  |  | 1.5 | 2.5 | 2.5 | 1.5 | 1.5 | 2.5 | 1.5 | 1.5 | 2.5 | 1.5 | 1.5 | 3.5 | 24
104 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
105 |  |  | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 18
106 |  |  | 0 | 0.4 | 0 | 0.4 | 0 | 0 | 0 | 0 | 1.308 | 0 | 0 | 0 | 2.108
109 |  |  | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 1.81826238 | 21.81914856
111 |  |  | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 1.196 | 14.352
112 |  |  | 3.3494307 | 3.3494307 | 3.3494307 | 3.818350998 | 3.818350998 | 3.818350998 | 3.818350998 | 3.818350998 | 3.818350998 | 3.818350998 | 3.818350998 | 3.818350998 | 44.413451082
115 |  |  | 0 | 0 | 15.62778 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 20.62778
117 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2
118 |  |  | 5 | 12.4 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27.4
122 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
125 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
126 |  |  | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 0.88 | 10.56
127 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
128 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
129 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
201 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
202 | Air ticket Domestic |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
205 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
206 | Hotel bill Domestic |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
209 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
210 | Travelling - other-Domestic |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
301 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
303 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
304 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
307 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
309 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
402 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
404 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
501 |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 2.4
503 |  |  | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 162.7 | 1952.4
601 |  |  | 38 | 18 | 42.5 | 18 | 38 | 25 | 38 | 18 | 42.5 | 18 | 42.5 | 20.936 | 359.436
602 |  |  | 0 | 0 | 4.36 | 0 | 0 | 4.36 | 60 | 0 | 4.36 | 0 | 0 | 4.36 | 77.44
605 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
606 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
608 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
609 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
610 |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 37
611 |  |  | 21.3 | 16.3 | 16.3 | 16.3 | 16.3 | 16.3 | 16.3 | 16.3 | 16.3 | 16.3 | 16.3 | 21.3 | 205.6000000000001
612 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
613 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
614 |  |  | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 2 | 2 | 4 | 30
615 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
616 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
410 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
412 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
413 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
618 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
620 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
621 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
622 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
623 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
624 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
625 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
626 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
627 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
632 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
633 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
634 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
635 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
636 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
637 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
639 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
641 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
643 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26.814 | 0 | 0 | 15.369 | 42.183
645 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
648 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
649 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
701 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
702 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
705 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
706 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
821 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
823 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
646 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
647 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
825 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
826 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
827 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
890 |  |  | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 40.48 | 485.7600000000002
899 |  |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 30
900 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
604 |  |  | 0 | 0 | 0.8 | 0 | 0 | 0.8 | 0 | 0 | 0.8 | 0 | 0 | 0.8 | 3.2
619 |  |  | 29.28 | 34.28 | 29.28 | 29.28 | 29.28 | 29.28 | 44.28 | 39.28 | 29.28 | 29.28 | 29.28 | 39.28 | 391.3599999999999
704 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL |  | 333.75210483 | 320.55210483 | 353.03988483 | 309.909802773 | 324.509802773 | 317.669802773 | 400.509802773 | 316.509802773 | 365.2918027730001 | 309.873455249 | 329.373455249 | 373.066291909 | 4054.058113535
 | Man powercost | 0 | 23.09610483 |  | 38.72388483 | 25.85380277299999 | 25.85380277299999 | 25.85380277299999 | 25.85380277299999 | 25.85380277299999 | 25.85380277299999 | 31.21745524899999 | 26.21745524899999 | 51.94529190900001 | 0
 | Remaining (With out Staff cost) | 0 | 310.656 |  | 314.316 | 284.056 | 298.6560000000001 | 291.816 | 374.6560000000001 | 290.6560000000001 | 339.4380000000001 | 278.656 | 303.156 | 321.121 | 0