50 函数综合运用

单独考试——总账会计,,,,,,

,根据给出的12月期初余额表和12月凭证流水文件，汇总得到12月25日前（含25日）的如下格式的科目汇总数据,,,,,

,科目代码,方向,期初余额,25日前（含25日）借方发生,25日前（含25日）贷方发生,期末余额

,1001,借,,,,

,1002,借,,,,

,100201,借,,,,

,1012,借,,,,

,1101,借,,,,

,110101,借,,,,

,110102,借,,,,

,1111,借,,,,

,1121,借,,,,

,1122,借,,,,

,112201,借,,,,

,112202,借,,,,

,112203,借,,,,

,1123,借,,,,

,1131,借,,,,

,1132,借,,,,

,1221,借,,,,

,122101,借,,,,

,1231,贷,,,,

,1401,借,,,,

,140101,借,,,,

,140102,借,,,,

,140103,借,,,,

,140104,借,,,,

,140105,借,,,,

,140106,借,,,,

,140107,借,,,,

,140108,借,,,,

,140109,借,,,,

,140110,借,,,,

,1403,借,,,,

,140301,借,,,,

,140302,借,,,,

,140303,借,,,,

,140304,借,,,,

,140305,借,,,,

,140306,借,,,,

,140307,借,,,,

,140308,借,,,,

,140309,借,,,,

,140310,借,,,,

,1404,贷,,,,

,140401,借,,,,

,140402,借,,,,

,140403,借,,,,

,140404,借,,,,

,140405,贷,,,,

,140406,贷,,,,

,140407,借,,,,

,140408,借,,,,

,140409,借,,,,

,140410,借,,,,

,1405,借,,,,

,140501,借,,,,

,1406,借,,,,

,1407,贷,,,,

,1408,借,,,,

,1411,借,,,,

,141101,借,,,,

,1471,贷,,,,

,1501,借,,,,

,150101,借,,,,

,150102,借,,,,

,1502,贷,,,,

,1503,借,,,,

,150301,借,,,,

,150302,借,,,,

,1511,借,,,,

,151101,借,,,,

,151102,借,,,,

,151103,借,,,,

,1512,贷,,,,

,1521,借,,,,

,1531,借,,,,

,1532,贷,,,,

,1541,借,,,,

,1601,借,,,,

,1602,贷,,,,

,1603,贷,,,,

,1604,借,,,,

,1605,借,,,,

,1606,借,,,,

,1701,借,,,,

,1702,贷,,,,

,1703,贷,,,,

,1711,借,,,,

,1801,借,,,,

,1811,借,,,,

,1901,借,,,,

,2001,贷,,,,

,2101,贷,,,,

,2111,借,,,,

,2201,贷,,,,

,2202,贷,,,,

,220201,贷,,,,

,220202,贷,,,,

,220203,贷,,,,

,220204,贷,,,,

,2203,贷,,,,

,220301,贷,,,,

,2211,贷,,,,

,221101,贷,,,,

,221102,贷,,,,

,221103,贷,,,,

,221104,贷,,,,

,221105,贷,,,,

,221106,贷,,,,

,221107,贷,,,,

,221108,贷,,,,

,221109,贷,,,,

,221110,贷,,,,

,2221,贷,,,,

,222101,贷,,,,

,22210101,贷,,,,

,22210102,贷,,,,

,22210103,贷,,,,

,22210105,贷,,,,

,22210106,贷,,,,

,222102,贷,,,,

,222103,贷,,,,

,222104,贷,,,,

,222105,贷,,,,

,222107,贷,,,,

,222110,贷,,,,

,222111,贷,,,,

,2231,贷,,,,

,2232,贷,,,,

,2241,贷,,,,

,2251,贷,,,,

,2261,贷,,,,

,2311,贷,,,,

,2312,贷,,,,

,2313,贷,,,,

,2314,贷,,,,

,2401,贷,,,,

,2501,贷,,,,

,2502,贷,,,,

,2702,借,,,,

,2711,贷,,,,

,2801,贷,,,,

,2901,贷,,,,

,3001,借,,,,

,4001,贷,,,,

,4002,贷,,,,

,400201,贷,,,,

,400202,贷,,,,

,4101,贷,,,,

,4102,贷,,,,

,4103,贷,,,,

,4104,贷,,,,

,410401,贷,,,,

,410402,贷,,,,

,4201,借,,,,

,4301,贷,,,,

,430101,贷,,,,

,430104,贷,,,,

,5001,借,,,,

,5101,借,,,,

,5201,借,,,,

,5301,借,,,,

,6001,贷,,,,

,6011,贷,,,,

,6021,贷,,,,

,6031,贷,,,,

,6041,贷,,,,

,6051,贷,,,,

,6061,贷,,,,

,6101,贷,,,,

,6111,贷,,,,

,6301,贷,,,,

,6401,借,,,,

,6402,借,,,,

,6403,借,,,,

,6411,借,,,,

,6601,借,,,,

,6602,借,,,,

,660201,借,,,,

,660202,借,,,,

,660203,借,,,,

,660204,借,,,,

,660205,借,,,,

,660206,借,,,,

,660207,借,,,,

,660208,借,,,,

,660209,借,,,,

,660210,借,,,,

,660211,借,,,,

,660212,借,,,,

,660213,