资产负债表公式

B6=QM(“1001”,月,,,,,)+QM(“1002”,月,,,,,)+QM(“1012”,月,,,,,)C6=QC(“1001”,全年,,,,,)+QC(“1002”,全年,,,,,)+QC(“1012”,全年,,,,,)E6=QM(“2001”,月,,,,,)F6=QM(“2001”,全年,,,,,)B7=QM(“1101”,月,,,,,)C7=QC(“1101”,全年,,,,,)E7=QM(“2101”,月,,,,,)F7=QC(“2101”,全年,,,,,)B8=QM(“1121”,月,,,,,)C8=QC(“1121”,全年,,,,,)E8=QM(“2201”,月,,,,,)F8=QC(“2201”,全年,,,,,)B9=QM(“1122??”,月,借,,,,)-QM(“1231??”,月,贷,,,,)+QM(“1231”,月,借,,,,)+QM(“2203??”,月,借,,,,)C9=QC(“1122??”,全年,借,,,,)-QC(“1231??”,全年,贷,,,,)+QM(“1231”,全年,借,,,,)+QM(“2203??”,全年,借,,,,)E9=QM(“2202??”,月,贷,,,,)+QM(“1123??”,月,贷,,,,)F9=QC(“2202??”,全年,贷,,,,)+QC(“1123??”,全年,贷,,,,)B10=QM(“1123??”,月,借,,,,)+QM(“2202??”,月,借,,,,)C10=QC(“1123??”,全年,借,,,,)+QC(“2202??”,全年,借,,,,)E10=QM(“2203??”,月,贷,,,,)+QM(“1122??”,月,贷,,,,)F10=QC(“2203??”,全年,贷,,,,)+QC(“1122??”,全年,贷,,,,)B11=QM(“1132”,月,,,,,)C11=QC(“1132”,全年,,,,,)E11=QM(“2211”,月,,,,,)F11=QC(“2211”,全年,,,,,)B12=QM(“1131”,月,,,,,)C12=QC(“1131”,全年,,,,,)E12=QM(“2221”,月,,,,,)F12=QC(“2221”,全年,,,,,)B13=QM(“1221”,月,,,,,)C13=QC(“1221”,全年,,,,,)E13=QM(“2231”,月,,,,,)F13=QC(“2231”,全年,,,,,)B14= QM(“1401”,月,,,,,)+ QM(“1403”,月,,,,,)+ QM(“1404”,月,借,,,,)-QM(“1404”,月,贷,,,,)+QM(“1405”,月,,,,,)+QM(“1406”,月,,,,,)+QM(“1408”,月,,,,,)+ QM(“1411”,月,,,,,)- QM(“1471”,月,,,,,)+QM(“5001”,月,,,,,)C14=QC(“1401”,全年,,,,,)+QC(“1403”,全年,,,,,)+QC(“1404”,全年,借,,,,)-QC(“1404”,全年,贷,,,,)+QC(“1405”,全年,,,,,)+QC(“1406”,全年,,,,,)+QC(“1408”,全年,,,,,)+QC(“1411”,全年,,,,,)-QC(“1471”,全年,,,,,)+QC(“5001”,全年,,,,,)E14=QM(“2232”,月,,,,,)F14=QC(“2232”,全年,,,,,)E15=QM(“2241”,月,,,,,)F15=QC(“2241”,全年,,,,,)B17=PTOTAL(B6:B16)C17=PTOTAL(C6:C16)E17=QM(“2401”,月,,,,,)F17=QC(“2401”,全年,,,,,)E18=PTOTAL(E6:E17)F18=PTOTAL(F6:F17)B19=QM("1503",月,,,,,)C19=QM("1503",全年,,,,,)B20=QM("1501",月,,,,,)-QM("1502",月,,,,,)C20=QM("1501",全年,,,,,)-QM("1502",全年,,,,,)E20=QM("2501",月,,,,,)F20=QC("2501",全年,,,,,)B21=QM("1531",月,,,,,)C21=QC("1531",全年,,,,,)E21=QM("2502",月,,,,,)F21=QC("2502",全年,,,,,)B22=QM("1511",月,,,,,)-QM("1512",月,,,,,)C22=QC("1511",全年,,,,,)-QC("1512",全年,,,,,)E22=QM("2701",月,,,,,)F22=QC("2701",全年,,,,,)B23=QM("1521",月,,,,,)C23=QC"1521",全年,,,,,)E23=QM("2711",月,,,,,)F23=QC("2711",全年,,,,,)B24=QM("1601",月,,,,,)-QM("1602",月,,,,,)-QM("1603",月,,,,,)C24=QC("1601",全年,,,,,)-QC("1602",全年,,,,,)-QC("1603",全年,,,,,)E24=QM("2801",月,,,,,)F24=QC("2801",全年,,,,,)B25=QM("1604",月,,,,,)C25=QC("1604",全年,,,,,)E25=QM("2901",月,贷,,,,)F25=QC("2901",全年,贷,,,,)B26=QM("1605",月,,,,,)C26=QC("1605",全年,,,,,)E26=QM("2702",月,,,,,)F26=QC("2702",全年,,,,,)B27=QM("1606",月,,,,,)C27=QC("1606",全年,,,,,)E27=PTOTAL(E20:E26)F27=PTOTAL(F20:F26)E28=E18+E27F28=F18+F27B30=QM("1701",月,,,,,)-QM("1702",月,,,,,)-QM("1703",月,,,,,)C30=QC("1701",全年,,,,,)-QC("1702",全年,,,,,)-QC("1703",全年,,,,,)E30=QM("4001",月,,,,,)F30=QC("4001",全年,,,,,)E31=QM("4002",月,,,,,)F31=QC("4002",全年,,,,,)B32=QM("1711",月,,,,,)C32=QC("1711",全年,,,,,)B33=QM("1801",月,,,,,)C33=QC("1801",全年,,,,,)E33=QM("4101",月,,,,,)F33=QC("4101",全年,,,,,)B34=QM("1811",月,借,,,,,)C34=QC("1811",全年,借,,,,,)E34=QM("410410",月,,,,,)F34=QC("410410",全年,,,,,)B35=QM("1532",月,,,,,)+QM("1901",月,,,,,)C35=QC