Total End_DB and End CR.xlsx

	B	D	E	J	K	L	M	N	O	P	R
1
2									Làm thủ công
3				Row Labels	Beg_DB	Beg_CR	Amt_DB	Amt_CR	End_DB	End_DB
4	Bài Toán			KH000001			1,680,000	1,680,000	0	0
5				KH000002	0	0			0	0
6	Chỉ có 02 Table là chính : SDDK và Phát sinh			KH000003	47,800,002	0	151,300,003	83,600,002	115,500,003	0	67,700,001
7	Còn Table còn lại là danh mục để 2 table chính thiết lập Relationship mà thôi			KH000007			55,290,001	55,290,001	0	0
8				KH000010			110,000	110,000	0	0
9	Bài toán cần tính tổng dòng cuối cùng			KH000016			9,100,000	9,100,000	0	0
10				KH000018			68,700,017	68,700,017	0	0
11	Total End_DB = ?		Nếu End_xx là số dương	KH000019	18,600,000	0	768,960,097	650,510,022	137,050,075	0
12	Total End_CR = ?		Nếu End_xx là số âm	KH000022			20,500,000	20,500,000	0	0
13				KH000025	270,000	0	158,560,017	159,278,108	0	448,091
14	Số đúng là như bảng bên cạnh			KH000029			21,040,000	21,040,000	0	0
15				KH000031			80,650,000	47,950,000	32,700,000	0
16	Total End_DB =	17,809,082,741		KH000053			4,200,000	4,200,000	0	0
17	Total End_CR =	853,000,421		KH000058	0	350,000	55,740,007	55,490,007	0	100,000
18				KH000064			40,350,001	40,350,001	0	0
19				KH000065			2,550,000	2,550,000	0	0
20				KH000068			3,300,000	3,300,000	0	0
21				KH000069			14,530,000	14,530,000	0	0
22				KH000071			147,815,000	147,815,000	0	0
23				KH000074	46,200,000	0	200,750,000	201,150,000	45,800,000	0
24				KH000076			102,150,020	102,150,020	0	0
25				KH000077	0	0			0	0
26				KH000086			1,300,000	1,300,000	0	0
27				KH000089			9,300,000	9,300,000	0	0
28				KH000092			25,300,001	25,300,001	0	0
29				KH000098			10,620,000	10,620,000	0	0
30				KH000105			69,000,015	69,000,015	0	0
31				KH000107	9,140,001	0	358,511,898	351,966,901	15,684,998	0
32				KH000109			6,800,000	6,800,000	0	0
33				KH000113	0	0			0	0
34				KH000114	0	46,000	253,900,032	234,650,000	19,204,032	0
35				KH000119	7,800,000	0	43,530,000	51,330,000	0	0
36				KH000124			19,800,000	19,800,000	0	0
37				KH000131			9,900,000	9,900,000	0	0
38				KH000132			76,590,000	76,590,000	0	0
39				KH000137			110,000	110,000	0	0
40				KH000138			140,000	140,000	0	0
41				KH000147			0	0	0	0
42				KH000150	2,138,850,001	0	3,108,498,702	5,247,348,703	0	0
43				KH000156			44,345,000	44,345,000	0	0
44				KH000158			23,870,001	23,870,001	0	0
45				KH000162			32,410,001	32,410,001	0	0
46				KH000172	343,750,000	0	47,831,163	391,581,163	0	0
47				KH000175	149,627,822	0	54,800,005	175,700,000	28,727,827	0
48				KH000181			220,000	220,000	0	0
49				KH000189			59,530,002	59,830,001	0	299,999
50				KH000199			30,000,006	30,000,006	0	0
51				KH000202			18,350,004	18,350,004	0	0
52				KH000211			3,520,000	3,520,000	0	0
53				KH000214			13,200,000	13,200,000	0	0
54				KH000216	31,230,000	0	173,110,035	204,340,035	0	0
55				KH000225	53,810,000	0	498,030,086	422,110,063	129,730,023	0
56				KH000228			220,000	220,000	0	0
57				KH000232	24,792,090	0	133,400,000	126,592,090	31,600,000	0
58				KH000236			9,950,000	7,950,000	2,000,000	0
59				KH000238	53,999,000	0	142,175,007	148,859,455	47,314,552	0
60				KH000246	1,313,744,739	0	1,645,222,137	2,211,696,849	747,270,027	0
61				KH000255			550,000	550,000	0	0
62				KH000256			900,000	900,000	0	0
63				KH000257			4,950,000	4,950,000	0	0
64				KH000258			120,000	120,000	0	0
65				KH000275	13,000,000	0	69,800,002	82,800,002	0	0
66				KH000278	45,300,000	0	177,800,044	223,100,044	0	0
67				KH000282	1,935,001	0	88,858,518	90,793,519	0	0
68				KH000283			156,280,034	156,280,034	0	0
69				KH000284			73,300,016	73,300,016	0	0
70				KH000290	0	300,000	17,740,000	18,180,000	0	740,000
71				KH000291			22,700,000	22,700,000	0	0
72				KH000301			880,000	880,000	0	0
73				KH000304			1,980,000	1,980,000	0	0
74				KH000307	0	126,720,000	642,400,000	934,030,000	0	418,350,000
75				KH000316			594,750,000	594,750,000	0	0
76				KH000320	945,460,229	0	1,347,909,998	2,053,250,227	240,120,000	0
77				KH000327			37,100,000	37,100,000	0	0
78				KH000329	63,937,910	0	1,001,870,170	921,557,949	144,250,131	0
79				KH000340			540,000	540,000	0	0
80				KH000344			21,850,000	22,150,000	0	300,000
81				KH000348	129,240,000	0	639,460,029	733,300,022	35,400,007	0
82				KH000353			206,570,016	184,920,008	21,650,008	0
83				KH000359	23,090,000	0	1,034,540,118	1,043,230,034	14,400,084	0
84				KH000360			2,600,000	2,600,000	0	0
85				KH000366			59,870,010	59,870,010	0	0
86				KH000374			6,160,001	6,160,001	0	0
87				KH000375			4,200,000	4,200,000	0	0
88				KH000380	70,000	0	1,630,001	950,001	750,000	0
89				KH000382			9,450,000	9,450,000	0	0
90				KH000388	79,649,989	0	1,771,720,006	1,790,303,012	61,066,983	0
91				KH000393			76,520,018	44,320,008	32,200,010	0
92				KH000401	0	271,305,780			0	271,305,780
93				KH000403	0	390,000	20,300,001	19,910,001	0	0
94				KH000404	242,584,002	0	9	242,584,011	0	0
95				KH000417			740,000	740,000	0	0
96				KH000420			1,050,000	1,050,000	0	0
97				KH000424			35,410,004	35,410,004	0	0
98				KH000432			2,013,300,001	2,013,300,001	0	0
99				KH000445			75,650,013	56,850,010	18,800,003	0
100				KH000446			0	0	0	0