+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: comparing two excel sheets in QTP (/Thread-comparing-two-excel-sheets-in-QTP)
comparing two excel sheets in QTP - kodhanrajesh - 08-31-2011
Hi
Please help me to compare below both spreadsheets as mentioned in the below and attached the both of the spreadsheets.
Source A+B=Target J
Source C= Target G
Source D= Target E
Source I = Target M
Please help me out. Thank in Advance!!.
Source file
A, B, C, D, E, F, G, H, I
2011, Jan, Loans due from /to Gp ops, Aviva I Total (G014), None, None, None, Plan 2011-2013 V3, 101760000
2012, Apr, Loans due from /to Gp ops, Total Non-Insurance, None, None, None, Plan 2011-2013 V3, 244967233.4
2012 Apr Investment in Gp ops Total Non-Insurance None None None Plan 2011-2013 V3 -1.352
2012 Apr Ordinary Share Capital Total Non-Insurance None None None Plan 2011-2013 V3 -73832207.78
2012 Apr Share premium Total Non-Insurance None None None Plan 2011-2013 V3 -124861191.3
2012 Apr Currency translation reserve Total Non-Insurance None None None Plan 2011-2013 V3 79556.192
Target file
A, B, C, D, E, F, G, H, I, J, K, L, M
PLAN, 2010, Dec, YTD, NI_TM1_IVOT, GBP, Goodwill cost reserve, [ICP None], [None], 2011_Feb, [None], [None], -713360000
PLAN, 2010, Dec, YTD, NI_TM1_IVOT, GBP, Goodwill cost reserve, [ICP None], [None], 2011_Apr, [None], [None], -713360000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Property and equipment [ICP None] [None] 2011_Apr [None] [None] 30561912.65
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Loans [ICP None] [None] 2011_Apr [None] [None] 9360000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Rec and other fin assets [ICP None] [None] 2011_Apr [None] [None] 92387363.09
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Int bearing borrowings [ICP None] [None] 2011_Apr [None] [None] -7387981.6
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Pension obligations and other prov [ICP None] [None] 2011_Apr [None] [None] -289751282.9
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Net tax asset_liability [ICP None] [None] 2011_Apr [None] [None] -19606548.3
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Bank overdraft [ICP None] [None] 2011_Apr [None] [None] -141556.84
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Payables out of RI ops [ICP None] [None] 2011_Apr [None] [None] 6698946.539
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Other Liabilities Other [ICP None] [None] 2011_Apr [None] [None] -104714830.3
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Goodwill [ICP None] [None] 2011_Apr [None] [None] 713360000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP Other indefinite intangibles [ICP None] [None] 2011_Apr [None] [None] 12400000
PLAN 2010 Dec YTD NI_TM1_IVOT GBP NI Profit [ICP None] Non Prop Non Life Reinsurance_Casualty 2011_Apr Personal Motor Ops and Non Core 1631759.161
PLAN 2010 Dec YTD NI_TM1_IVOT GBP NI Profit [ICP None] Proportional Non Life reinsurance 2011_Apr Personal Motor Strategic Partnerships -49142.24157
PLAN 2010 Dec YTD NI_TM1_IVOT GBP NI Profit [ICP None] Proportional Non Life reinsurance 2011_Apr Homeowner RAC Insurance Aviva Underwritten 80900.72001