{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["別紙様式２４","残高の集計方法","表１の「関係会社向」けの範囲"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"別紙様式２４","index":0,"n_rows":433,"n_cols":66,"rows_kept":433,"cut":false,"hidden":false,"merged":[[263,51,263,52],[263,53,263,54],[263,55,263,56],[263,57,263,58],[231,51,231,52],[231,53,231,54],[349,17,349,24],[348,17,348,24],[362,15,363,24],[352,30,352,37],[234,30,234,33],[234,34,234,38],[241,34,241,38],[239,34,239,38],[233,30,233,33],[237,34,237,38],[235,30,235,33],[239,30,239,33],[236,30,236,33],[232,6,232,15],[281,17,281,24],[281,25,281,29],[231,59,231,60],[191,51,191,52],[191,53,191,54],[191,55,191,56],[191,57,191,58],[191,59,191,60],[214,51,214,52],[214,53,214,54],[214,55,214,56],[231,55,231,56],[214,57,214,58],[214,59,214,60],[231,57,231,58],[263,59,263,60],[280,51,280,52],[280,53,280,54],[280,55,280,56],[280,57,280,58],[280,59,280,60],[284,38,284,42],[345,38,345,42],[174,25,174,29],[345,30,345,37],[194,25,194,29],[196,25,196,29],[280,30,280,37],[201,30,201,35],[206,6,208,42],[200,38,200,42],[199,38,199,42],[217,38,217,42],[196,38,196,42],[287,38,287,42],[286,38,286,42],[200,30,200,37],[198,38,198,42],[198,30,198,37],[197,38,197,42],[285,38,285,42],[216,38,216,42],[201,36,201,37],[350,38,350,42],[349,30,349,37],[347,38,347,42],[346,38,346,42],[348,38,348,42],[347,30,347,37],[349,38,349,42],[348,30,348,37],[197,30,197,37],[218,38,218,42],[219,38,219,42],[235,34,235,38],[222,38,222,42],[220,30,220,37],[225,6,225,41],[222,6,222,15],[220,6,220,15],[232,25,232,29],[235,21,235,24],[233,34,233,38],[198,25,198,29],[201,38,201,42],[214,25,214,29],[215,38,215,42],[201,5,201,29],[200,8,200,13],[199,25,199,29],[200,25,200,29],[198,8,198,9],[199,17,199,24],[199,30,199,37],[200,17,200,24],[205,6,205,42],[196,30,196,37],[195,30,195,37],[193,30,193,37],[175,30,175,34],[184,6,184,42],[192,25,192,29],[192,17,192,24],[194,38,194,42],[193,38,193,42],[193,25,193,29],[191,25,191,29],[193,17,193,24],[185,6,185,42],[194,17,194,24],[192,38,192,42],[194,30,194,37],[190,5,191,16],[191,38,191,42],[190,17,190,29],[166,25,166,29],[165,25,165,29],[164,25,164,29],[163,25,163,29],[165,38,165,42],[162,30,162,37],[166,30,166,37],[162,25,162,29],[163,38,163,42],[164,38,164,42],[165,30,165,37],[164,30,164,37],[166,38,166,42],[175,38,175,42],[172,13,172,15],[175,35,175,37],[173,30,173,37],[161,17,161,24],[168,17,168,24],[163,17,163,24],[162,17,162,24],[167,17,167,24],[166,17,166,24],[165,17,165,24],[164,17,164,24],[169,17,169,24],[169,38,169,42],[168,38,168,42],[167,38,167,42],[163,30,163,37],[168,30,168,37],[167,30,167,37],[161,25,161,29],[167,25,167,29],[168,25,168,29],[169,25,169,29],[162,38,162,42],[197,25,197,29],[144,7,145,41],[178,6,180,42],[181,6,181,42],[168,8,168,9],[168,13,168,15],[170,38,170,42],[172,30,172,37],[171,25,171,29],[170,30,170,37],[174,17,174,24],[172,8,172,9],[172,17,172,24],[160,17,160,24],[193,5,193,16],[195,8,195,9],[192,30,192,37],[170,25,170,29],[173,25,173,29],[169,30,169,37],[171,17,171,24],[175,5,175,29],[173,17,173,24],[172,25,172,29],[138,30,138,37],[141,17,141,24],[140,6,140,15],[140,17,140,24],[140,25,140,29],[174,30,174,37],[139,30,139,37],[139,38,139,42],[191,30,191,37],[190,30,190,42],[161,38,161,42],[161,30,161,37],[173,38,173,42],[160,30,160,37],[140,30,140,37],[171,30,171,37],[165,13,165,15],[141,6,141,15],[173,5,173,16],[174,8,174,13],[166,13,166,15],[170,17,170,24],[182,6,183,42],[174,38,174,42],[137,30,137,37],[137,38,137,42],[160,25,160,29],[141,38,141,42],[172,38,172,42],[171,38,171,42],[141,25,141,29],[141,30,141,37],[159,30,159,42],[160,38,160,42],[140,38,140,42],[138,38,138,42],[138,25,138,29],[152,7,153,41],[148,7,150,41],[167,8,167,9],[167,13,167,15],[165,8,165,9],[171,8,171,9],[171,13,171,15],[170,13,170,15],[159,17,159,29],[169,8,169,9],[166,8,166,9],[104,34,104,38],[107,30,107,33],[132,38,132,42],[136,38,136,42],[135,38,135,42],[134,30,134,37],[134,38,134,42],[135,30,135,37],[136,30,136,37],[133,30,133,37],[133,38,133,42],[132,30,132,37],[125,30,125,37],[123,25,123,29],[124,17,124,24],[125,6,125,15],[125,17,125,24],[125,25,125,29],[129,38,129,42],[129,30,129,37],[124,38,124,42],[131,30,131,37],[124,30,124,37],[123,30,123,37],[123,17,123,24],[99,34,99,38],[124,25,124,29],[104,21,104,24],[123,6,123,15],[103,30,103,33],[105,21,105,24],[108,34,108,38],[128,38,128,42],[105,34,105,38],[106,30,106,33],[107,34,107,38],[113,7,114,38],[104,7,104,15],[105,7,105,15],[123,38,123,42],[130,30,130,37],[130,38,130,42],[124,6,124,15],[131,38,131,42],[125,38,125,42],[5,7,5,41],[96,34,97,38],[97,21,97,24],[97,30,97,33],[23,27,23,30],[80,6,80,42],[98,5,102,6],[101,8,101,14],[100,16,100,20],[100,25,100,29],[101,34,101,38],[101,30,101,33],[100,34,100,38],[96,5,97,15],[101,25,101,29],[99,21,99,24],[98,8,98,14],[102,8,102,14],[98,30,98,33],[96,16,97,20],[98,16,98,20],[26,31,26,38],[28,23,29,26],[38,23,38,25],[102,25,102,29],[103,21,103,24],[102,30,102,33],[101,16,101,20],[98,25,98,29],[102,21,102,24],[102,16,102,20],[69,6,69,42],[81,6,83,42],[77,6,78,42],[103,34,103,38],[103,25,103,29],[103,7,103,15],[98,21,98,24],[102,34,102,38],[101,21,101,24],[96,25,97,29],[99,30,99,33],[99,25,99,29],[100,30,100,33],[98,34,98,38],[106,16,106,20],[108,30,108,33],[108,16,108,20],[107,16,107,20],[106,21,106,24],[106,7,106,15],[121,5,122,16],[121,17,121,29],[121,30,121,42],[122,17,122,24],[122,25,122,29],[122,38,122,42],[122,30,122,37],[103,5,107,6],[107,21,107,24],[103,16,103,20],[105,30,105,33],[115,7,115,38],[116,7,116,38],[104,16,104,20],[105,25,105,29],[104,25,104,29],[105,16,105,20],[104,30,104,33],[128,17,128,24],[128,25,128,29],[127,6,127,15],[127,17,127,24],[127,25,127,29],[107,8,107,14],[126,6,126,15],[126,17,126,24],[126,25,126,29],[128,6,128,15],[130,6,130,15],[130,17,130,24],[130,25,130,29],[129,6,129,15],[129,17,129,24],[129,25,129,29],[132,6,132,15],[132,17,132,24],[132,25,132,29],[131,6,131,15],[131,17,131,24],[131,25,131,29],[134,6,134,15],[134,17,134,24],[134,25,134,29],[133,6,133,15],[133,17,133,24],[133,25,133,29],[136,6,136,15],[136,17,136,24],[136,25,136,29],[137,17,137,24],[135,6,135,15],[135,17,135,24],[135,25,135,29],[137,25,137,29],[137,6,137,15],[139,6,139,15],[139,17,139,24],[139,25,139,29],[138,6,138,15],[138,17,138,24],[217,25,217,29],[196,8,196,9],[191,17,191,24],[195,25,195,29],[197,17,197,24],[219,30,219,37],[214,30,214,37],[215,30,215,37],[196,17,196,24],[195,17,195,24],[198,17,198,24],[219,6,219,15],[216,6,216,15],[213,30,213,42],[213,5,214,16],[214,17,214,24],[213,17,213,29],[216,30,216,37],[215,6,215,15],[216,17,216,24],[217,17,217,24],[218,6,218,15],[217,30,217,37],[218,25,218,29],[284,17,284,24],[280,38,280,42],[280,25,280,29],[282,38,282,42],[284,30,284,37],[281,38,281,42],[240,6,240,15],[241,6,241,15],[244,30,244,33],[244,34,244,38],[245,30,245,33],[245,34,245,38],[249,21,249,24],[249,30,249,33],[245,16,245,20],[244,25,244,29],[247,6,247,15],[283,38,283,42],[236,34,236,38],[221,17,221,24],[283,25,283,29],[282,30,282,37],[235,25,235,29],[282,17,282,24],[265,21,265,29],[230,16,231,20],[235,16,235,20],[239,21,239,24],[221,25,221,29],[230,30,230,33],[230,34,231,38],[234,16,234,20],[242,25,242,29],[240,25,240,29],[246,34,246,38],[243,30,243,33],[241,30,241,33],[242,34,242,38],[243,34,243,38],[246,30,246,33],[236,25,236,29],[219,17,219,24],[222,17,222,24],[234,6,234,15],[220,17,220,24],[220,25,220,29],[221,6,221,15],[234,21,234,24],[232,16,232,20],[231,30,231,33],[232,30,232,33],[234,25,234,29],[221,30,221,37],[233,6,233,15],[232,34,232,38],[236,16,236,20],[238,16,238,20],[238,21,238,24],[240,34,240,38],[240,30,240,33],[242,30,242,33],[220,38,220,42],[232,5,241,5],[241,25,241,29],[237,25,237,29],[238,30,238,33],[235,6,235,15],[239,6,239,15],[237,6,237,15],[238,6,238,15],[236,6,236,15],[238,34,238,38],[239,25,239,29],[221,38,221,42],[241,16,241,20],[240,16,240,20],[240,21,240,24],[239,16,239,20],[222,25,222,29],[233,25,233,29],[233,21,233,24],[238,25,238,29],[241,21,241,24],[280,17,280,24],[265,16,265,20],[236,21,236,24],[237,16,237,20],[237,21,237,24],[288,17,288,24],[291,38,291,42],[290,25,290,29],[289,25,289,29],[288,25,288,29],[288,30,288,37],[289,30,289,37],[217,6,217,15],[215,17,215,24],[215,25,215,29],[216,25,216,29],[218,17,218,24],[230,25,231,29],[230,5,231,15],[231,21,231,24],[230,21,230,24],[219,25,219,29],[218,30,218,37],[232,21,232,24],[233,16,233,20],[283,30,283,37],[222,30,222,37],[281,30,281,37],[237,30,237,33],[282,25,282,29],[242,5,250,5],[242,6,242,15],[242,16,242,20],[244,6,244,15],[243,6,243,15],[245,6,245,15],[243,16,243,20],[247,16,247,20],[247,21,247,24],[245,25,245,29],[244,16,244,20],[244,21,244,24],[242,21,242,24],[246,25,246,29],[243,21,243,24],[243,25,243,29],[246,6,246,15],[249,6,249,15],[245,21,245,24],[264,5,265,15],[248,16,248,20],[247,30,247,33],[246,16,246,20],[246,21,246,24],[247,34,247,38],[248,30,248,33],[248,34,248,38],[248,21,248,24],[248,25,248,29],[247,25,247,29],[264,16,264,20],[264,21,264,29],[250,6,250,15],[250,16,250,20],[250,21,250,24],[250,25,250,29],[255,7,257,42],[254,7,254,42],[251,16,251,20],[262,5,263,15],[262,16,263,20],[262,21,263,29],[250,30,250,33],[250,34,250,38],[251,21,251,24],[251,25,251,29],[251,34,251,38],[251,30,251,33],[306,38,306,42],[310,25,310,29],[309,30,309,37],[308,30,308,37],[308,38,308,42],[307,38,307,42],[307,25,307,29],[293,5,293,29],[271,6,272,42],[279,17,279,29],[287,8,287,9],[284,13,284,15],[287,30,287,37],[291,5,291,16],[290,8,290,9],[296,6,296,42],[292,8,292,13],[285,30,285,37],[289,17,289,24],[292,17,292,24],[289,13,289,15],[290,30,290,37],[283,17,283,24],[287,17,287,24],[284,8,284,9],[304,30,304,37],[288,8,288,9],[284,25,284,29],[287,25,287,29],[286,25,286,29],[292,25,292,29],[286,30,286,37],[286,13,286,15],[287,13,287,15],[286,8,286,9],[288,13,288,15],[289,8,289,9],[303,17,303,29],[293,30,293,37],[304,17,304,24],[303,30,303,42],[297,6,297,42],[286,17,286,24],[285,17,285,24],[285,25,285,29],[288,38,288,42],[292,38,292,42],[292,30,292,37],[322,38,322,42],[310,8,310,9],[310,13,310,15],[311,17,311,24],[309,8,309,9],[290,17,290,24],[291,25,291,29],[291,17,291,24],[310,17,310,24],[309,17,309,24],[308,8,308,9],[311,8,311,9],[290,13,290,15],[308,17,308,24],[305,38,305,42],[307,30,307,37],[304,38,304,42],[307,17,307,24],[306,17,306,24],[305,30,305,37],[305,25,305,29],[306,25,306,29],[310,38,310,42],[309,38,309,42],[326,38,326,42],[311,13,311,15],[304,25,304,29],[322,30,322,37],[322,25,322,29],[312,25,312,29],[311,25,311,29],[321,30,321,42],[312,38,312,42],[325,17,325,24],[324,17,324,24],[326,17,326,24],[321,17,321,29],[323,25,323,29],[322,17,322,24],[323,17,323,24],[324,25,324,29],[305,17,305,24],[306,30,306,37],[309,13,309,15],[309,25,309,29],[308,25,308,29],[308,13,308,15],[303,5,304,16],[326,8,326,9],[326,13,326,15],[312,17,312,24],[312,8,312,13],[321,5,322,16],[329,38,329,42],[323,38,323,42],[323,30,323,37],[326,25,326,29],[325,25,325,29],[325,38,325,42],[325,30,325,37],[326,30,326,37],[324,30,324,37],[328,8,328,9],[327,8,327,9],[327,13,327,15],[327,17,327,24],[328,17,328,24],[328,38,328,42],[327,30,327,37],[328,13,328,15],[329,13,329,15],[329,25,329,29],[329,30,329,37],[331,25,331,29],[330,25,330,29],[330,13,330,15],[331,7,331,12],[331,13,331,15],[330,8,330,9],[330,17,330,24],[328,30,328,37],[331,30,331,37],[330,30,330,37],[421,5,421,7],[391,5,392,14],[395,5,395,14],[405,5,405,7],[405,8,405,38],[351,38,351,42],[365,6,365,13],[352,25,352,29],[352,17,352,24],[351,17,351,24],[387,7,388,40],[418,8,418,40],[351,30,351,37],[414,5,414,7],[415,5,415,7],[416,5,416,7],[393,23,393,25],[379,23,379,25],[394,6,394,13],[364,23,364,24],[366,15,366,22],[346,6,346,7],[386,7,386,40],[384,7,384,40],[379,6,379,13],[380,6,380,13],[371,6,372,42],[350,30,350,37],[346,30,346,37],[346,25,346,29],[348,25,348,29],[347,25,347,29],[422,5,422,7],[347,8,347,9],[350,8,350,9],[369,6,370,42],[349,25,349,29],[348,8,348,9],[349,8,349,9],[31,27,31,39],[34,28,35,39],[34,23,35,27],[99,16,99,20],[99,8,99,14],[418,5,418,7],[395,23,395,25],[417,5,417,7],[417,8,417,40],[411,17,411,40],[40,28,40,35],[40,23,40,26],[380,15,380,22],[413,5,413,7],[381,6,381,13],[380,23,380,25],[385,7,385,40],[39,23,39,25],[79,6,79,42],[72,6,72,42],[14,9,14,15],[14,18,14,24],[16,19,16,29],[28,27,29,42],[24,27,25,42],[17,19,17,29],[21,31,21,33],[44,7,44,41],[74,6,76,42],[73,6,73,42],[70,6,71,42],[46,7,46,41],[21,34,21,38],[68,6,68,42],[67,6,67,42],[38,28,38,39],[39,28,39,39],[21,24,21,30],[126,30,126,37],[127,30,127,37],[127,38,127,42],[128,30,128,37],[126,38,126,42],[228,20,228,38],[260,17,260,29],[195,38,195,42],[164,8,164,9],[164,13,164,15],[195,12,195,13],[159,5,160,16],[151,7,151,41],[204,6,204,42],[209,6,209,42],[196,12,196,13],[197,12,197,13],[214,38,214,42],[198,12,198,13],[197,8,197,9],[249,34,249,38],[249,25,249,29],[249,16,249,20],[248,6,248,15],[327,38,327,42],[324,38,324,42],[328,25,328,29],[408,6,409,40],[401,7,401,40],[331,17,331,24],[332,38,332,42],[329,17,329,24],[327,25,327,29],[379,15,379,22],[344,30,344,37],[344,17,344,24],[343,17,343,24],[381,15,381,22],[345,17,345,24],[381,23,381,25],[362,5,363,14],[351,25,351,29],[348,13,348,15],[366,6,366,13],[352,8,352,13],[364,15,364,22],[366,23,366,24],[365,23,365,24],[352,38,352,42],[365,15,365,22],[364,6,364,13],[332,30,332,37],[347,17,347,24],[346,17,346,24],[349,13,349,15],[350,13,350,15],[333,30,333,37],[332,25,332,29],[350,25,350,29],[332,8,332,13],[333,5,333,29],[342,5,343,16],[342,17,342,29],[345,25,345,29],[344,25,344,29],[336,6,336,42],[343,38,343,42],[344,38,344,42],[343,30,343,37],[337,6,337,42],[430,5,430,12],[424,8,424,40],[428,5,428,40],[420,5,420,7],[423,8,423,40],[391,15,392,25],[415,8,415,40],[395,15,395,22],[394,15,394,22],[419,8,419,40],[427,5,427,40],[426,5,426,7],[421,8,421,40],[420,8,420,40],[393,6,393,13],[393,15,393,22],[394,23,394,25],[413,8,413,40],[424,5,424,7],[426,8,426,40],[425,8,425,40],[425,5,425,7],[423,5,423,7],[416,8,416,40],[160,51,160,52],[160,53,160,54],[160,55,160,56],[160,57,160,58],[73,55,73,56],[73,57,73,58],[160,59,160,60],[97,59,97,60],[97,57,97,58],[122,57,122,58],[122,59,122,60],[73,59,73,60],[97,55,97,56],[122,51,122,52],[122,53,122,54],[122,55,122,56],[97,51,97,52],[97,53,97,54],[73,51,73,52],[73,53,73,54],[304,59,304,60],[322,51,322,52],[322,53,322,54],[322,55,322,56],[322,57,322,58],[322,59,322,60],[304,57,304,58],[304,51,304,52],[304,53,304,54],[304,55,304,56],[343,59,343,60],[362,51,362,52],[362,53,362,54],[362,55,362,56],[362,57,362,58],[362,59,362,60],[343,51,343,52],[343,53,343,54],[343,55,343,56],[343,57,343,58],[413,45,426,45],[111,7,112,38],[108,5,108,15],[100,8,100,14],[100,21,100,24],[108,25,108,29],[107,25,107,29],[108,21,108,24],[106,34,106,38],[106,25,106,29],[422,8,422,40],[419,5,419,7],[268,6,270,42],[285,8,285,9],[285,13,285,15],[279,30,279,42],[251,5,251,15],[279,5,280,16],[211,14,211,42],[373,6,373,42],[377,15,378,25],[377,5,378,14],[342,30,342,42],[343,25,343,29],[9,5,9,11],[94,13,94,38],[119,12,119,42],[157,14,157,42],[188,14,188,42],[340,19,340,42],[359,21,359,32],[347,13,347,15],[331,38,331,42],[330,38,330,42],[332,17,332,24],[277,19,277,42],[301,19,301,42],[319,19,319,42],[312,30,312,37],[310,30,310,37],[290,38,290,42],[291,30,291,37],[311,38,311,42],[311,30,311,37],[289,38,289,42],[351,8,351,9],[351,13,351,15],[350,17,350,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（日本産業規格Ａ４）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(      )"]
[null,null,null,null,null,"別紙様式24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"北海道財務局長",null,null,"(01)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東北財務局長",null,null,"(02)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"関東財務局長",null,null,"(03)"]
[null,null,null,null,null,null,null,"業　　務　　報　　告　　書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東海財務局長",null,null,"(04)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"北陸財務局長",null,null,"(05)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"近畿財務局長",null,null,"(06)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中国財務局長",null,null,"(07)"]
[null,null,null,null,null,"財務（支）局長",null,null,null,null,null,null,null,"殿",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"四国財務局長",null,null,"(08)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"九州財務局長",null,null,"(09)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"福岡財務支局長",null,null,"(10)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"沖縄総合事務局長",null,null,"(11)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"北海道知事",null,null,"(12)"]
[null,null,null,null,null,null,null,null,null,"2022-04-01",null,null,null,null,null,null,"から",null,{"$f":"EDATE(J15,12)-1","v":"2023-03-31"},null,null,null,null,null,null,"までの業務の状況を次のとおり報告いたします。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"青森県知事",null,null,"(13)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"直近の決算期",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"岩手県知事",null,null,"(14)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"秋田県知事",null,null,"(15)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE(T17,12)-1","v":"2023-03-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"宮城県知事",null,null,"(N01)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"山形県知事",null,null,"(N02)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"福島県知事",null,null,"(N03)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"届出者",null,null,"登録番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"栃木県知事",null,null,"(N04)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$10","v":"財務（支）局長"},null,null,null,null,null,null,"(01)",null,null,"第　　　　　号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"群馬県知事",null,null,"(N05)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"茨城県知事",null,null,"(N06)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（郵便番号",null,null,null,null,null,null,null,"）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"埼玉県知事",null,null,"(N07)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住　　所",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東京都知事",null,null,"(N08)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"千葉県知事",null,null,"(N09)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"電話番号",null,null,null,"(        )        -   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"神奈川県知事",null,null,"(N10)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"新潟県知事",null,null,"(N11)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"商　　号\n又は名称",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"山梨県知事",null,null,"(N12)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"長野県知事",null,null,"(N13)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"静岡県知事",null,null,"(N14)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"氏　　名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"愛知県知事",null,null,"(N15)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（法人にあっては、代表者の氏名）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"岐阜県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"法定代理人",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"三重県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 氏名、商号\n 又は名称",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"滋賀県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"富山県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"石川県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"連絡者",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"福井県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 所属",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"京都府知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 氏名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"奈良県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 電話番号",null,null,null,null,"(     )       -    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"大阪府知事"]
[]
[null,null,null,null,null,null,null,null,"（注）「登録番号」の括弧書については、記載を省略することができる。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"和歌山県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県神戸県民局長"]
[null,null,null,null,null,null,null,"業　　務　　報　　告　　書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県県阪神南民局長"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県県阪神北民局長"]
[null,null,null,null,null,null,null,"目　　次",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県東播磨県民局長"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県北播磨県民局長"]
[null,null,null,null,null,"１",null,"貸付金の種別残高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県中播磨県民局長"]
[null,null,null,null,null,"２",null,"業種別貸付残高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県西播磨県民局長"]
[null,null,null,null,null,"３",null,"貸付金の金額別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県但馬県民局長"]
[null,null,null,null,null,"４",null,"貸付金の期間別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県丹波県民局長"]
[null,null,null,null,null,"５",null,"貸付金の金利別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"兵庫県淡路県民局長"]
[null,null,null,null,null,"６",null,"貸付金の種別内訳（除外貸付・例外貸付）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"鳥取県知事"]
[null,null,null,null,null,"７",null,"総量規制超過部分の貸付残高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"岡山県知事"]
[null,null,null,null,null,"８",null,"消費者向無担保貸付金の金額別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"島根県知事"]
[null,null,null,null,null,"９",null,"消費者向無担保貸付金の金利別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"広島県知事"]
[null,null,null,null,null,"10",null,"事業者向無担保貸付金の金額別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"山口県知事"]
[null,null,null,null,null,"11",null,"事業者向無担保貸付金の金利別内訳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"徳島県知事"]
[null,null,null,null,null,"12",null,"消費者向無担保貸付金の新規契約状況等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"香川県知事"]
[null,null,null,null,null,"13",null,"貸金業協会等への加入状況等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"愛媛県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"高知県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"福岡県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"佐賀県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"長崎県知事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"大分県知事"]
[null,null,null,null,null,null,"（記載上の注意）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"熊本県知事"]
[null,null,null,null,null,null,"１　本報告書は、法の規制を受ける貸付けについて、直近の3月31日時点の計数等を記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"宮崎県知事"]
[null,null,null,null,null,null,"２　「連絡者」は、業務報告書の作成担当者の所属部署及び氏名を記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"鹿児島県知事"]
[null,null,null,null,null,null,"３　目次に掲げる各表について、該当がない場合も「該当なし」の旨記載して提出する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"沖縄県知事"]
[null,null,null,null,null,null,"４　各表の残高の単位（百万円、千円）未満の端数は、特に注記がない限り切り捨てて記載する。\n　このため、各表の残高内訳の合計は「合計」（又は「計」）欄の残高と合致しない場合がある。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"財務（支）局長"]
[]
[null,null,null,null,null,null,"５　各表の「構成割合」は、合計に対する割合を小数点第３位を切り捨て第２位まで記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（ｴﾗｰ表示互換表）"]
[null,null,null,null,null,null,"６　各表中、貸付残高等の実績がない場合は「-」、単位未満の場合は「0」と記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性"]
[null,null,null,null,null,null,"７　各表中、「関係会社」とあるのは、提出業者の親会社、子会社及び関連会社並びに提出業者が\n　他の会社等の関連会社である場合における当該他の会社等をいい、「親会社」、「子会社」及び\n　「関連会社」とは、「財務諸表等の用語、様式及び作成方法に関する規則」（昭和38年大蔵省令\n　第59号）第8条に規定する「親会社」、「子会社」及び「関連会社」をいう。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"チェック","←エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"有有無","金利が未記入。","合不","残高が内訳の合計値より過少（又は過大）。","高額","１件当たり残高金額が過大です。","違法","金利の入力誤り。","誤消","表１の消費者（無担保）残高計と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"有無有","残高が未記入。","不合","件数が内訳の合計値と不一致。"," ",null,"高っ！","金利の記入に間違いはありませんか？","誤計","表１の残高合計と不一致。"," "]
[null,null,null,null,null,null,"８　各表の「件数」は、契約件数を記載する。なお、極度方式貸付けについては、極度方式基本契約\n　に基づく貸付け毎の件数ではなく、極度方式基本契約の件数を記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"有無","残高が未記入。","不不","件数、残高が内訳の合計値と合いません。"," ",null,null,null,"誤誤計","表１の件数合計、残高合計と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"有無無","残高、金利が未記入。","期間","期間の入力に間違いはありませんか？"," ",null,null,null,"誤正計","表１の件数合計と不一致。"," "]
[null,null,null,null,null,null,"９　各表の「残高」は、貸付当初の元本、極度方式基本契約の極度額ではなく、残元本を記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無有有","件数が未記入。"," ",null,null,null,null,null,"正誤計","表１の残高合計と不一致。"," "]
[null,null,null,null,null,null,"10　「平均約定金利」は、加重平均により小数点第３位を切り捨て第２位までを記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無有","件数が未記入。"," ",null,null,null,null,null,"誤誤消","表１の消費者（無担保）件数、残高と不一致。"," "]
[null,null,null,null,null,null,"　　例 ： 無担保貸付残高が55万円、その内訳が18.55%で25万円、17.80%で15万円、9.07%で15万円の\n　　　　場合\n　　　　　　→　(25×18.55%＋15×17.80%＋15×9.07%)÷55＝0.1576(15.76%)\n　　　　　なお、算出不能の場合は推定値を記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無有無","件数、金利が未記入。"," ",null,null,null,null,null,"誤正消","表１の消費者（無担保）件数と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無無有","件数、残高が未記入。"," ",null,null,null,null,null,"正誤消","表１の消費者（無担保）残高と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"有無期","期間が未記入。"," ",null,null,null,null,null,"誤誤事","表１の事業者者（無担保）件数、残高と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無有期","期間の入力誤り。"," ",null,null,null,null,null,"誤正事","表１の事業者者（無担保）件数と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"申無","新規申込件数が未記入。","　",null,null,null,null,null,"正誤事","表１の事業者者（無担保）残高と不一致。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"額無","貸付総額が未記入。",null,null,null,null,null,null,"大大","表１の件数合計、残高合計の数値を超えています。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"数無","貸付件数が未記入。",null,null,null,null,null,null,"大正","表１の件数合計の数値を超えています。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"正大","表１の残高合計の数値を超えています。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　",null,null,null,null,null,"正契大","新規申込件数の数値を超えています。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　",null,null,null,null,null,"正貸大","新規契約件数の数値を超えています。"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　",null,null,null,null,null,"正当小","新規契約件数の数値を下回っています。"," "]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK110=0,\"１　貸付金の種別残高\",\"１．貸付金の種別残高\")","v":"１　貸付金の種別残高"},null,null,null,null,null,null,null,{"$f":"IF(BK110=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK110=0,\"（表１）エラーなし\",\"！（表１）エラー情報あり\")","v":"（表１）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　件数・残高\n　貸付種別　　",null,null,null,null,null,null,null,null,null,null,"件　数",null,null,null,null,null,null,null,"　","残　高",null,null,null,null,null,null,null,null,"平均約定金利"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,"消\n費\n者\n向",null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,"％",null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,"％",null,null,null,"％",null,null,null,null,null,null,null,null,null,{"$f":"BK99","v":"　　（↓エラー情報↓）"},null,null,"件数","残高","金利",null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK98=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,null,"無　　　担　　　保\n（住宅向を除く）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$109=0,AV100=0),0,ROUNDDOWN((Q100/Q$109)*100,2))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$109=0,AW100=0),0,ROUNDDOWN((Z100/Z$109)*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK100","v":""},null,null,{"$f":"IF(Q100=\"-\",0,Q100)","v":0},{"$f":"IF(Z100=\"-\",0,Z100)","v":0},{"$f":"IF(AI100=\"-\",0,AI100)","v":0},1,{"$f":"CONCATENATE(IF(OR(Q100=\"\",Q100=\"-\"),\"無\",\"有\"),IF(OR(Z100=\"\",Z100=\"-\"),\"無\",\"有\"),IF(OR(AI100=\"\",AI100=\"-\"),\"無\",\"有\"))","v":"無無無"},{"$f":"IF(ISNA(VLOOKUP(AZ100,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ100,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(OR(AZ100=\"有有有\",AZ100=\"有有無\",AZ100=\"有有\"),IF(AW100/AV100>BL100,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD100,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD100,BD$76:BE$92,2,FALSE))","v":""},{"$f":"IF(OR(AI100=\"-\",AI100=\"\"),\"-\",IF(AI100>109.5,\"違法\",IF(AND(40.004<AI100,AI100<=109.5),\"高っ！\",\"ok\")))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BF100,BF$76:BG$92,2,FALSE))=TRUE,\"\",VLOOKUP(BF100,BF$76:BG$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AND(BA100=\"\",BC100=\"\",BE100=\"\",BG100=\"\",BI100=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$98=\"表示\",CONCATENATE(BJ100,BA100,BC100,BE100,BG100,BI100),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM100,BN100)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,null,null,"有　　　担　　　保\n（住宅向を除く）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$109=0,AV101=0),0,ROUNDDOWN((Q101/Q$109)*100,2))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$109=0,AW101=0),0,ROUNDDOWN((Z101/Z$109)*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(Q101=\"-\",0,Q101)","v":0},{"$f":"IF(Z101=\"-\",0,Z101)","v":0},{"$f":"IF(AI101=\"-\",0,AI101)","v":0},2,{"$f":"CONCATENATE(IF(OR(Q101=\"\",Q101=\"-\"),\"無\",\"有\"),IF(OR(Z101=\"\",Z101=\"-\"),\"無\",\"有\"),IF(OR(AI101=\"\",AI101=\"-\"),\"無\",\"有\"))","v":"無無無"},{"$f":"IF(ISNA(VLOOKUP(AZ101,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ101,AZ$76:BA$92,2,FALSE))","v":""}," ",null,"-",{"$f":"IF(ISNA(VLOOKUP(BD101,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD101,BD$76:BE$92,2,FALSE))","v":""},{"$f":"IF(OR(AI101=\"-\",AI101=\"\"),\"-\",IF(AI101>109.5,\"違法\",IF(AND(40.004<AI101,AI101<=109.5),\"高っ！\",\"ok\")))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BF101,BF$76:BG$92,2,FALSE))=TRUE,\"\",VLOOKUP(BF101,BF$76:BG$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AND(BA101=\"\",BC101=\"\",BE101=\"\",BG101=\"\",BI101=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$98=\"表示\",CONCATENATE(BJ101,BA101,BC101,BE101,BG101,BI101),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"住　　　宅　　　向",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,{"$f":"IF(AI102=\"-\",0,AI102)","v":0},3,{"$f":"CONCATENATE(IF(OR(Q102=\"\",Q102=\"-\"),\"無\",\"有\"),IF(OR(Z102=\"\",Z102=\"-\"),\"無\",\"有\"),IF(OR(AI102=\"\",AI102=\"-\"),\"無\",\"有\"))","v":"無無無"},{"$f":"IF(ISNA(VLOOKUP(AZ102,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ102,AZ$76:BA$92,2,FALSE))","v":""}," ",null,"-","",{"$f":"IF(OR(AI102=\"-\",AI102=\"\"),\"-\",IF(AI102>109.5,\"違法\",IF(AND(40.004<AI102,AI102<=109.5),\"高っ！\",\"ok\")))","v":"-"},""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"計",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"ROUNDDOWN(IF(AW103=0,0,(AW100*AX100+AW101*AX101+AW102*AX102)/AW103),2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"BK103","v":""},null,null,0,0,null,4,{"$f":"CONCATENATE(IF(OR(Q103=\"\",Q103=\"-\"),\"無\",\"有\"),IF(OR(Z103=\"\",Z103=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ103,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ103,AZ$76:BA$92,2,FALSE))","v":""},{"$f":"CONCATENATE(IF(AV103=SUM(AV100:AV102),\"合\",\"不\"),IF(AND(SUM(AW100:AW102)<=AW103,AW103<=(SUM(AW100:AW102)+3)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB103,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB103,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,"事業者向",null,"無　　　　担　　　　保\n（関係会社向を除く）",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,{"$f":"IF(AI104=\"-\",0,AI104)","v":0},5,{"$f":"CONCATENATE(IF(OR(Q104=\"\",Q104=\"-\"),\"無\",\"有\"),IF(OR(Z104=\"\",Z104=\"-\"),\"無\",\"有\"),IF(OR(AI104=\"\",AI104=\"-\"),\"無\",\"有\"))","v":"無無無"},{"$f":"IF(ISNA(VLOOKUP(AZ104,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ104,AZ$76:BA$92,2,FALSE))","v":""}," ",null,"-","",{"$f":"IF(OR(AI104=\"-\",AI104=\"\"),\"-\",IF(AI104>109.5,\"違法\",IF(AND(40.004<AI104,AI104<=109.5),\"高っ！\",\"ok\")))","v":"-"},""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"有　　　　担　　　　保\n（関係会社向を除く）",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,{"$f":"IF(AI105=\"-\",0,AI105)","v":0},6,{"$f":"CONCATENATE(IF(OR(Q105=\"\",Q105=\"-\"),\"無\",\"有\"),IF(OR(Z105=\"\",Z105=\"-\"),\"無\",\"有\"),IF(OR(AI105=\"\",AI105=\"-\"),\"無\",\"有\"))","v":"無無無"},""," ",null,"-","",{"$f":"IF(OR(AI105=\"-\",AI105=\"\"),\"-\",IF(AI105>109.5,\"違法\",IF(AND(40.004<AI105,AI105<=109.5),\"高っ！\",\"ok\")))","v":"-"},""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"手　　形　　割　　引\n（関係会社向を除く）",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,{"$f":"IF(AI106=\"-\",0,AI106)","v":0},7,{"$f":"CONCATENATE(IF(OR(Q106=\"\",Q106=\"-\"),\"無\",\"有\"),IF(OR(Z106=\"\",Z106=\"-\"),\"無\",\"有\"),IF(OR(AI106=\"\",AI106=\"-\"),\"無\",\"有\"))","v":"無無無"},""," ",null,"-","",{"$f":"IF(OR(AI106=\"-\",AI106=\"\"),\"-\",IF(AI106>109.5,\"違法\",IF(AND(40.004<AI106,AI106<=109.5),\"高っ！\",\"ok\")))","v":"-"},""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"関　係　会　社　向",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,{"$f":"IF(AI107=\"-\",0,AI107)","v":0},8,{"$f":"CONCATENATE(IF(OR(Q107=\"\",Q107=\"-\"),\"無\",\"有\"),IF(OR(Z107=\"\",Z107=\"-\"),\"無\",\"有\"),IF(OR(AI107=\"\",AI107=\"-\"),\"無\",\"有\"))","v":"無無無"},""," ",null,"-","",{"$f":"IF(OR(AI107=\"-\",AI107=\"\"),\"-\",IF(AI107>109.5,\"違法\",IF(AND(40.004<AI107,AI107<=109.5),\"高っ！\",\"ok\")))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BF107,BF$76:BG$92,2,FALSE))=TRUE,\"\",VLOOKUP(BF107,BF$76:BG$92,2,FALSE))","v":""}," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"計",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"ROUNDDOWN(IF(AW108=0,0,(AW104*AX104+AW105*AX105+AW106*AX106+AW107*AX107)/AW108),2)","v":0},null,null,null,null,null,null,null,null,null,"",null,null,0,0,null,9,{"$f":"CONCATENATE(IF(OR(Q108=\"\",Q108=\"-\"),\"無\",\"有\"),IF(OR(Z108=\"\",Z108=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ108,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ108,AZ$76:BA$92,2,FALSE))","v":""},{"$f":"CONCATENATE(IF(AV108=SUM(AV104:AV107),\"合\",\"不\"),IF(AND(SUM(AW104:AW107)<=AW108,AW108<=(SUM(AW104:AW107)+4)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB108,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB108,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,"合　　　　　計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,100,null,null,null,{"$f":"ROUNDDOWN(IF(AW109=0,0,(AW100*AX100+AW101*AX101+AW102*AX102+AW104*AX104+AW105*AX105+AW106*AX106+AW107*AX107)/AW109),2)","v":0},null,null,null,null,null,null,null,null,null,"",null,null,0,0,null,10,{"$f":"CONCATENATE(IF(OR(Q109=\"\",Q109=\"-\"),\"無\",\"有\"),IF(OR(Z109=\"\",Z109=\"-\"),\"無\",\"有\"))","v":"無無"},"",{"$f":"CONCATENATE(IF(AV109=SUM(AV100:AV102,AV104:AV107),\"合\",\"不\"),IF(AND(SUM(AW100:AW102,AW104:AW107)<=AW109,AW109<=(SUM(AW100:AW102,AW104:AW107)+7)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB109,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB109,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ100:AZ109,\"無無無\")+COUNTIF(AZ100:AZ109,\"無無\")","v":10},{"$f":"IF(AZ110=AY109,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY109)-(COUNTIF(BA100:BA109,\"\")+COUNTIF(BC100:BC109,\"\")+COUNTIF(BE100:BE109,\"\")+COUNTIF(BG100:BG109,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY109-COUNTIF(BJ100:BJ109,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"１","　「住宅向」は住宅購入を目的とするいわゆる住宅ローンをいうこととし、住宅を担保に住宅ローン\n以外の貸付けを行う場合を含まない。"]
[]
[null,null,null,null,null,null,"２","　「関係会社向」は提出業者の関係会社及び提出業者の親会社の関係会社に対する貸付けを\n記載する。"]
[]
[null,null,null,null,null,null,"３","　担保には保証を含まない。"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK143=0,\"２　業種別貸付残高\",\"２．業種別貸付残高\")","v":"２　業種別貸付残高"},null,null,null,null,null,null,{"$f":"IF(BK143=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK143=0,\"（表2）エラーなし\",\"！（表2）エラー情報あり\")","v":"（表2）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　先数・残高\n業　種　別",null,null,null,null,null,null,null,null,null,null,null,"先　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK124","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK123=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,"農 業 、 林 業 、 漁 業 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$142=0,AV125=0),0,ROUNDDOWN((R125/R$142)*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$142=0,AW125=0),0,ROUNDDOWN((AE125/AE$142)*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R125=\"-\",0,R125)","v":0},{"$f":"IF(AE125=\"-\",0,AE125)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R125=\"\",R125=\"-\"),\"無\",\"有\"),IF(OR(AE125=\"\",AE125=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ125,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ125,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ125=\"有有\",IF(AW125/AV125>BL125,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD125,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD125,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA125=\"\",BC125=\"\",BE125=\"\",BG125=\"\",BI125=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$123=\"表示\",CONCATENATE(BJ125,BA125,BC125,BE125,BG125,BI125),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM125,BN125)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,"建設業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$142=0,AV126=0),0,ROUNDDOWN((R126/R$142)*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$142=0,AW126=0),0,ROUNDDOWN((AE126/AE$142)*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R126=\"-\",0,R126)","v":0},{"$f":"IF(AE126=\"-\",0,AE126)","v":0},null,2,"無無",{"$f":"IF(ISNA(VLOOKUP(AZ126,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ126,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ126=\"有有\",IF(AW126/AV126>BL126,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD126,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD126,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,"",{"$f":"IF(BK$123=\"表示\",CONCATENATE(BJ126,BA126,BC126,BE126,BG126,BI126),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,"製造業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,3,"無無",{"$f":"IF(ISNA(VLOOKUP(AZ127,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ127,AZ$76:BA$92,2,FALSE))","v":""}," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"電気・ガス・熱供給・水道業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"情報通信業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"運輸業、郵便業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,6,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"卸売業、小売業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,7,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"金融業、保険業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,8,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"不動産業、物品賃貸業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,9,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"宿泊業、飲食サービス業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,10,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"教育、学習支援業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,11,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"医療、福祉",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,12,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"複合サービス事業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,13,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"サービス業（他に分類されないもの）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,14,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"個人",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,15,"無無",""," ",null,"-",{"$f":"IF(ISNA(VLOOKUP(BD139,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD139,BD$76:BE$92,2,FALSE))","v":""}," ",null,{"$f":"IF(BG$143=0,IF(AE139=Z$103,\"正\",\"誤消\"),\"-\")","v":"正"},{"$f":"IF(ISNA(VLOOKUP(BH139,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH139,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"特定非営利活動法人",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,16,"無無",{"$f":"IF(ISNA(VLOOKUP(AZ140,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ140,AZ$76:BA$92,2,FALSE))","v":""}," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,{"$f":"IF(R141=\"-\",0,R141)","v":0},0,null,17,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"合　　　　　　　　計　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,"",null,null,{"$f":"IF(R142=\"-\",0,R142)","v":0},0,null,18,"無無","",{"$f":"CONCATENATE(IF(AV142=SUM(AV125:AV141),\"合\",\"不\"),IF(AND(SUM(AW125:AW141)<=AW142,AW142<=(SUM(AW125:AW141)+18)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB142,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB142,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(BG$143=0,IF(AE142=Z$109,\"正\",\"誤計\"),\"-\")","v":"正"},{"$f":"IF(ISNA(VLOOKUP(BH142,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH142,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ125:AZ142,\"無無\")","v":18},{"$f":"IF(AZ143=AY142,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY142)-(COUNTIF(BA125:BA142,\"\")+COUNTIF(BC125:BC142,\"\")+COUNTIF(BE125:BE142,\"\")+COUNTIF(BG125:BG142,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY142-COUNTIF(BJ125:BJ142,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"１","　業種別貸付残高は貸付先の主な事業（過去１年間における総売上高のうち割合の最も高いもの）により分類\nする。"]
[]
[null,null,null,null,null,null,"２","　業種は、日本標準産業分類により分類する。"]
[null,null,null,null,null,null,"３","　「先数」は名寄せした債務者数を記載する。"]
[null,null,null,null,null,null,"４","　事業を営む個人顧客については、施行規則第10条の23第1項第4号及び第5号、同規則第10条の28第1項\n第3号及び第4号に定める契約に係る貸付けについては、事業性があるものとみなし、それぞれの業種別の欄\nに計上する。また、施行規則第10条の22第1項第4号に掲げる金額を基に算出した法第13条の2第2項に定め\nる基準額の範囲内で契約した貸付けについては「個人」の欄に計上する。"]
[]
[]
[null,null,null,null,null,null,"５","　「個人」欄の残高は、「表１」の消費者向計の残高と一致する。"]
[null,null,null,null,null,null,"６","　「特定非営利活動法人」とは、特定非営利活動促進法（平成10年法律第7号）第10条の規定に基づき設立さ\nれた特定非営利活動法人をいう。　"]
[]
[null,null,null,null,null,null,"７","　残高合計は、「表１」の残高合計と一致する。"]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK176=0,\"３　貸付金の金額別内訳\",\"３．貸付金の金額別内訳\")","v":"３　貸付金の金額別内訳"},null,null,null,null,null,null,null,null,{"$f":"IF(BK176=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK176=0,\"（表3）エラーなし\",\"！（表3）エラー情報あり\")","v":"（表3）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　件数・残高\n　金　額　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK162","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK161=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,"10","万円以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$175=0,AV163=0),0,ROUNDDOWN(R163/R$175*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$175=0,AW163=0),0,ROUNDDOWN(AE163/AE$175*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R163=\"-\",0,R163)","v":0},{"$f":"IF(AE163=\"-\",0,AE163)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R163=\"\",R163=\"-\"),\"無\",\"有\"),IF(OR(AE163=\"\",AE163=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ163,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ163,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ163=\"有有\",IF(AW163/AV163>BL163,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD163,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD163,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA163=\"\",BC163=\"\",BE163=\"\",BG163=\"\",BI163=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$161=\"表示\",CONCATENATE(BJ163,BA163,BC163,BE163,BG163,BI163),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM163,BN163)","v":0.1},0.1,100]
[null,null,null,null,null,null,null,"10","万円超",null,null,null,"30","万円以下",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$175=0,AV164=0),0,ROUNDDOWN(R164/R$175*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$175=0,AW164=0),0,ROUNDDOWN(AE164/AE$175*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R164=\"-\",0,R164)","v":0},{"$f":"IF(AE164=\"-\",0,AE164)","v":0},null,2,"無無",""," ",null,"-",""," ",null," ",null,"",{"$f":"IF(BK$161=\"表示\",CONCATENATE(BJ164,BA164,BC164,BE164,BG164,BI164),\"\")","v":""},0.3,0.3,300]
[null,null,null,null,null,null,null,"30","　〃",null,null,null,"50","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,"","",0.5,0.5,500]
[null,null,null,null,null,null,null,"50","　〃",null,null,null,"100","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",1,1,1000]
[null,null,null,null,null,null,null,"100","　〃",null,null,null,"500","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",5,5,5000]
[null,null,null,null,null,null,null,"500","　〃",null,null,null,"1,000","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,6,"無無",""," ",null,"-",""," ",null," ",null,"","",10,10,10000]
[null,null,null,null,null,null,null,"1,000","　〃",null,null,null,"5,000","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,7,"無無",""," ",null,"-",""," ",null," ",null,"","",50,50,50000]
[null,null,null,null,null,null,null,"5,000","　〃",null,null,null,"1","億円以下",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,8,"無無",""," ",null,"-",""," ",null," ",null,"","",100,100,100000]
[null,null,null,null,null,null,null,"1","億円超",null,null,null,"5","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,9,"無無",""," ",null,"-",""," ",null," ",null,"","",500,500,500000]
[null,null,null,null,null,null,null,"5","　〃",null,null,null,"10","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,10,"無無",""," ",null,"-",{"$f":"IF(ISNA(VLOOKUP(BD172,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD172,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,"","",1000,1000,1000000]
[null,null,null,null,null,null,null,"10","　〃",null,null,null,"100","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,{"$f":"IF(R173=\"-\",0,R173)","v":0},0,null,11,"無無",""," ",null,"-",""," ",null," ",null,"","",10000,10000,10000000]
[null,null,null,null,null,"100億円超",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,{"$f":"IF(R174=\"-\",0,R174)","v":0},0,null,12,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,"",null,null,{"$f":"IF(R175=\"-\",0,R175)","v":0},{"$f":"IF(AE175=\"-\",0,AE175)","v":0},null,13,"無無",{"$f":"IF(ISNA(VLOOKUP(AZ175,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ175,AZ$76:BA$92,2,FALSE))","v":""},{"$f":"CONCATENATE(IF(AV175=SUM(AV163:AV174),\"合\",\"不\"),IF(AND(SUM(AW163:AW174)<=AW175,AW175<=(SUM(AW163:AW174)+12)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB175,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB175,BB$76:BC$92,2,FALSE))","v":""},{"$f":"IF(AZ175=\"有有\",IF(AW175/AV175>BL175,\"高額\",\"ok\"),\"-\")","v":"-"},""," ",null,{"$f":"IF(BG176=0,IF(R175=Q$109,IF(AE175=Z$109,\"正正計\",\"正誤計\"),IF(AE175=Z$109,\"誤正計\",\"誤誤計\")),\"-\")","v":"正正計"},{"$f":"IF(ISNA(VLOOKUP(BH175,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH175,BH$76:BI$92,2,FALSE))","v":""},"",{"$f":"IF(BK$161=\"表示\",CONCATENATE(BJ175,BA175,BC175,BE175,BG175,BI175),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,"１　件　当　た　り　平　均　貸　付　残　高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV175=0,\"\",ROUNDDOWN(AE175/R175,2))","v":""},null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ163:AZ175,\"無無\")","v":13},{"$f":"IF(AZ176=AY175,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY175)-(COUNTIF(BA163:BA175,\"\")+COUNTIF(BC163:BC175,\"\")+COUNTIF(BE163:BE175,\"\")+COUNTIF(BG163:BG175,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY175-COUNTIF(BJ163:BJ175,\"\")","v":0}]
[]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１　貸付残高が直近の事業年度末における自己資金（法人の場合は自己資本）の額を超える貸付先すべて（ただ\n　し、当該先が20に満たない場合は、貸付残高上位20位までの貸付先）について、それぞれの貸付先名、業種、\n　貸付件数及び貸付残高を記載した別途の表（任意様式）を併せて提出する。（自己資金又は自己資本を超える\n　貸付先が無い場合は別途の表の提出は不要）"]
[]
[]
[null,null,null,null,null,null,"２　「自己資金」とは、資産の合計額から負債の合計額を控除した額をいう。"]
[null,null,null,null,null,null,"３　「自己資本」とは、資産の合計額より負債の合計額並びに配当金及び役員賞与金の予定額を控除し、引当金\n　（特別法上の引当金を含む。）の合計額を加えた額をいう。"]
[]
[null,null,null,null,null,null,"４　「合計」欄の件数及び残高は、「表１」の合計件数及び合計残高と一致する。"]
[null,null,null,null,null,null,"５　「1件当たり平均貸付残高」は、小数点第３位を切捨て第２位までを記載する。例：1.25、0.36等"]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK203=0,\"４　貸付金の期間別内訳\",\"４．貸付金の期間別内訳\")","v":"４　貸付金の期間別内訳"},null,null,null,null,null,null,null,null,{"$f":"IF(BK203=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK203=0,\"（表4）エラーなし\",\"！（表4）エラー情報あり\")","v":"（表4）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　            　件数・残高\n　期　間　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK193","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK192=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,"1年以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$201=0,AV194=0),0,ROUNDDOWN(R194/R$201*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$201=0,AW194=0),0,ROUNDDOWN(AE194/AE$201*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R194=\"-\",0,R194)","v":0},{"$f":"IF(AE194=\"-\",0,AE194)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R194=\"\",R194=\"-\"),\"無\",\"有\"),IF(OR(AE194=\"\",AE194=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ194,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ194,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ194=\"有有\",IF(AW194/AV194>BL194,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD194,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD194,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA194=\"\",BC194=\"\",BE194=\"\",BG194=\"\",BI194=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$192=\"表示\",CONCATENATE(BJ194,BA194,BC194,BE194,BG194,BI194),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM194,BN194)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,null,"1","年超",null,null,"5","年以下",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$201=0,AV195=0),0,ROUNDDOWN(R195/R$201*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$201=0,AW195=0),0,ROUNDDOWN(AE195/AE$201*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R195=\"-\",0,R195)","v":0},{"$f":"IF(AE195=\"-\",0,AE195)","v":0},null,2,{"$f":"CONCATENATE(IF(OR(R195=\"\",R195=\"-\"),\"無\",\"有\"),IF(OR(AE195=\"\",AE195=\"-\"),\"無\",\"有\"))","v":"無無"},""," ",null,"-",""," ",null," ",null,"",{"$f":"IF(BK$192=\"表示\",CONCATENATE(BJ195,BA195,BC195,BE195,BG195,BI195),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"5"," 〃",null,null,"10","　〃",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"10"," 〃",null,null,"15","　〃",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"15"," 〃",null,null,"20","　〃",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"20"," 〃",null,null,"25","　〃",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,6,"無無",{"$f":"IF(ISNA(VLOOKUP(AZ199,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ199,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ199=\"有有\",IF(AW199/AV199>BL199,\"高額\",\"ok\"),\"-\")","v":"-"},""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"25","年超",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,7,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,"",null,null,{"$f":"IF(R201=\"-\",0,R201)","v":0},0,null,8,"無無",{"$f":"IF(ISNA(VLOOKUP(AZ201,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ201,AZ$76:BA$92,2,FALSE))","v":""},{"$f":"CONCATENATE(IF(AV201=SUM(AV194:AV200),\"合\",\"不\"),IF(AND(SUM(AW194:AW200)<=AW201,AW201<=(SUM(AW194:AW200)+7)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB201,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB201,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(BG203=0,IF(R201=Q$109,IF(AE201=Z$109,\"正正計\",\"正誤計\"),IF(AE201=Z$109,\"誤正計\",\"誤誤計\")),\"-\")","v":"正正計"},{"$f":"IF(ISNA(VLOOKUP(BH201,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH201,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,"１　　件　　当　　た　　り　　平　　均　　約　　定　　期　　間",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(AE202=\"-\",0,AE202)","v":0},null,9,{"$f":"CONCATENATE(IF(OR(R201=\"\",R201=\"-\"),\"無\",\"有\"),IF(OR(AE202=\"\",AE202=\"-\"),\"無期\",\"有期\"))","v":"無無期"},"",{"$f":"IF(SUM(AV194:AV200)=0,\"-\",IF(AND((BB203-10)<AE202,AE202<(BB203+10)),\"ok\",\"期間\"))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BB202,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB202,BB$76:BC$92,2,FALSE))","v":""}," ",null," ",null," ",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ194:AZ202,\"無無\")","v":8},{"$f":"IF(AZ203=AY202,\"｢該当なし」\",\"\")","v":""},{"$f":"IF(SUM(AV194:AV200)=0,\"-\",(AV194*0.5+AV195*2.5+AV196*7.5+AV197*12.5+AV198*17.5+AV199*22.5+AV200*30)/AV201)","v":"-"},null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY202)-(COUNTIF(BA194:BA202,\"\")+COUNTIF(BC194:BC202,\"\")+COUNTIF(BE194:BE202,\"\")+COUNTIF(BG194:BG202,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY202-COUNTIF(BJ194:BJ202,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"１　期間は約定期間による。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"２　「１件当たり平均約定期間」は加重平均により小数点第３位を切り捨て第２位までを記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"　　　例 ： 1年以下が2件、1年超5年以下の2年が3件、3年が5件、5年超10年以下の6年が3件、\n　　　　　　7年が3件の場合\n　　　　　　　→　(1×2＋2×3＋3×5＋6×3＋7×3)÷(2＋3＋5＋3＋3)＝3.875 （3.87年）\n　　　なお、算出不能の場合は推定値を記載する。　"]
[]
[]
[null,null,null,null,null,null,"３　「合計」欄の件数及び残高は、「表１」の合計件数及び合計残高と一致する。"]
[]
[null,null,null,null,null,{"$f":"IF(BK224=0,\"５　貸付金の金利別内訳\",\"５．貸付金の金利別内訳\")","v":"５　貸付金の金利別内訳"},null,null,null,null,null,null,null,null,{"$f":"IF(BK224=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK224=0,\"（表5）エラーなし\",\"！（表5）エラー情報あり\")","v":"（表5）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　件数・残高\n　金　利　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK216","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK215=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,"　　　10.0 %以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$223=0,AV217=0),0,ROUNDDOWN(R217/R$223*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$223=0,AW217=0),0,ROUNDDOWN(AE217/AE$223*100,2))","v":0},null,null,null,null,null,"",null,null,{"$f":"IF(R217=\"-\",0,R217)","v":0},{"$f":"IF(AE217=\"-\",0,AE217)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R217=\"\",R217=\"-\"),\"無\",\"有\"),IF(OR(AE217=\"\",AE217=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ217,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ217,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ217=\"有有\",IF(AW217/AV217>BL217,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD217,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD217,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA217=\"\",BC217=\"\",BE217=\"\",BG217=\"\",BI217=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$215=\"表示\",CONCATENATE(BJ217,BA217,BC217,BE217,BG217,BI217),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM217,BN217)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,"　　　10.0 %超　　　15.0 %以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,2,"無無",""," ",null,{"$f":"IF(AZ218=\"有有\",IF(AW218/AV218>BL218,\"高額\",\"ok\"),\"-\")","v":"-"},""," ",null," ",null,"",{"$f":"IF(BK$215=\"表示\",CONCATENATE(BJ218,BA218,BC218,BE218,BG218,BI218),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,"　　　15.0  〃　　　18.0  〃",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　 　 18.0  〃　　　20.0  〃",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　　　20.0  〃　　　29.2  〃",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,5,"無無",""," ",null,"-",{"$f":"IF(ISNA(VLOOKUP(BD221,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD221,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　　　29.2  〃",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,6,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"合　計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,"",null,null,0,0,null,7,{"$f":"CONCATENATE(IF(OR(R223=\"\",R223=\"-\"),\"無\",\"有\"),IF(OR(AE223=\"\",AE223=\"-\"),\"無\",\"有\"))","v":"無無"},"",{"$f":"CONCATENATE(IF(AV223=SUM(AV217:AV222),\"合\",\"不\"),IF(AND(SUM(AW217:AW222)<=AW223,AW223<=(SUM(AW217:AW222)+6)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB223,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB223,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(BG224=0,IF(R223=Q$109,IF(AE223=Z$109,\"正正計\",\"正誤計\"),IF(AE223=Z$109,\"誤正計\",\"誤誤計\")),\"-\")","v":"正正計"},{"$f":"IF(ISNA(VLOOKUP(BH223,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH223,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ217:AZ223,\"無無\")","v":7},{"$f":"IF(AZ224=AY223,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY223)-(COUNTIF(BA217:BA223,\"\")+COUNTIF(BC217:BC223,\"\")+COUNTIF(BE217:BE223,\"\")+COUNTIF(BG217:BG223,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY223-COUNTIF(BJ217:BJ223,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"「合計」欄の件数及び残高は、「表１」の合計件数及び合計残高と一致する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(BK253=0,\"６　貸付金の種別残高（除外貸付・例外貸付）\",\"６．貸付金の種別残高（除外貸付・例外貸付）\")","v":"６　貸付金の種別残高（除外貸付・例外貸付）"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK253=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(BK253=0,\"（表6）エラーなし\",\"！（表6）エラー情報あり\")","v":"（表6）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　件数・残高\n　貸付種別",null,null,null,null,null,null,null,null,null,null,"件　数",null,null,null,null,null,null,null,null,"残　高",null,null,null,null,null,null,null,null,"平均約定金利"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,"除　外　貸　付",null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,"％",null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,"％",null,null,null,"％",null,null,null,null,null,null,null,null,null,{"$f":"BK233","v":"　　（↓エラー情報↓）"},null,null,"件数","残高","金利",null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK232=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第1号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$252=0,AV234=0),0,ROUNDDOWN((Q234/Q$252)*100,2))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$252=0,AW234=0),0,ROUNDDOWN((Z234/Z$252)*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(Q234=\"-\",0,Q234)","v":0},{"$f":"IF(Z234=\"-\",0,Z234)","v":0},{"$f":"IF(AI234=\"-\",0,AI234)","v":0},1,{"$f":"CONCATENATE(IF(OR(Q234=\"\",Q234=\"-\"),\"無\",\"有\"),IF(OR(Z234=\"\",Z234=\"-\"),\"無\",\"有\"),IF(OR(AI234=\"\",AI234=\"-\"),\"無\",\"有\"))","v":"無無無"},{"$f":"IF(ISNA(VLOOKUP(AZ234,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ234,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(OR(AZ234=\"有有有\",AZ234=\"有有無\",AZ234=\"有有\"),IF(AW234/AV234>BL234,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD234,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD234,BD$76:BE$92,2,FALSE))","v":""},{"$f":"IF(OR(AI234=\"-\",AI234=\"\"),\"-\",IF(AI234>109.5,\"違法\",IF(AND(40.004<AI234,AI234<=109.5),\"高っ！\",\"ok\")))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BF234,BF$76:BG$92,2,FALSE))=TRUE,\"\",VLOOKUP(BF234,BF$76:BG$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AND(BA234=\"\",BC234=\"\",BE234=\"\",BG234=\"\",BI234=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$232=\"表示\",CONCATENATE(BJ234,BA234,BC234,BE234,BG234,BI234),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM234,BN234)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第2号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$252=0,AV235=0),0,ROUNDDOWN((Q235/Q$252)*100,2))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$252=0,AW235=0),0,ROUNDDOWN((Z235/Z$252)*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(Q235=\"-\",0,Q235)","v":0},{"$f":"IF(Z235=\"-\",0,Z235)","v":0},{"$f":"IF(AI235=\"-\",0,AI235)","v":0},2,"無無無",""," ",null,"-","",{"$f":"IF(OR(AI235=\"-\",AI235=\"\"),\"-\",IF(AI235>109.5,\"違法\",IF(AND(40.004<AI235,AI235<=109.5),\"高っ！\",\"ok\")))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BF235,BF$76:BG$92,2,FALSE))=TRUE,\"\",VLOOKUP(BF235,BF$76:BG$92,2,FALSE))","v":""}," ",null,"",{"$f":"IF(BK$232=\"表示\",CONCATENATE(BJ235,BA235,BC235,BE235,BG235,BI235),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第3号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(Q236=\"-\",0,Q236)","v":0},{"$f":"IF(Z236=\"-\",0,Z236)","v":0},{"$f":"IF(AI236=\"-\",0,AI236)","v":0},3,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第4号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,4,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第5号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,5,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第6号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,6,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第7号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,7,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の21第1項第8号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,8,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"ROUNDDOWN(IF(AW242=0,0,(AW234*AX234+AW235*AX235+AW236*AX236+AW237*AX237+AW238*AX238+AW239*AX239+AW240*AX240+AW241*AX241)/AW242),2)","v":0},null,null,null,null,null,null,null,null,null,"",null,null,0,0,null,9,{"$f":"CONCATENATE(IF(OR(Q242=\"\",Q242=\"-\"),\"無\",\"有\"),IF(OR(Z242=\"\",Z242=\"-\"),\"無\",\"有\"))","v":"無無"},"",{"$f":"CONCATENATE(IF(AV242=SUM(AV234:AV241),\"合\",\"不\"),IF(AND(SUM(AW234:AW241)<=AW242,AW242<=(SUM(AW234:AW241)+8)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB242,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB242,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,"例  外  貸  付","　施行規則第10条の23第1項第1号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,{"$f":"IF(AI243=\"-\",0,AI243)","v":0},10,{"$f":"CONCATENATE(IF(OR(Q243=\"\",Q243=\"-\"),\"無\",\"有\"),IF(OR(Z243=\"\",Z243=\"-\"),\"無\",\"有\"),IF(OR(AI243=\"\",AI243=\"-\"),\"無\",\"有\"))","v":"無無無"},""," ",null,"-","",{"$f":"IF(OR(AI243=\"-\",AI243=\"\"),\"-\",IF(AI243>109.5,\"違法\",IF(AND(40.004<AI243,AI243<=109.5),\"高っ！\",\"ok\")))","v":"-"},""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第1号の2で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,11,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第2号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,12,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第2号の2及び施行規則第10条の28第1項第1号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,13,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第3号及び施行規則第10条の28第1項第2号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,14,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第4号及び施行規則第10条の28第1項第3号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,15,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第5号及び施行規則第10条の28第1項第4号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,16,"無無無",""," ",null,"-","","-",""," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"　施行規則第10条の23第1項第6号で定める契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0,0,0,17,"無無無",""," ",null,"-","","-",{"$f":"IF(ISNA(VLOOKUP(BF250,BF$76:BG$92,2,FALSE))=TRUE,\"\",VLOOKUP(BF250,BF$76:BG$92,2,FALSE))","v":""}," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"ROUNDDOWN(IF(AW251=0,0,(AW243*AX243+AW244*AX244+AW245*AX245+AW246*AX246+AW247*AX247+AW248*AX248+AW249*AX249+AW250*AX250)/AW251),2)","v":0},null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(Q251=\"-\",0,Q251)","v":0},{"$f":"IF(Z251=\"-\",0,Z251)","v":0},null,18,{"$f":"CONCATENATE(IF(OR(Q251=\"\",Q251=\"-\"),\"無\",\"有\"),IF(OR(Z251=\"\",Z251=\"-\"),\"無\",\"有\"))","v":"無無"},"",{"$f":"CONCATENATE(IF(AV251=SUM(AV243:AV250),\"合\",\"不\"),IF(AND(SUM(AW243:AW250)<=AW251,AW251<=(SUM(AW243:AW250)+8)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB251,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB251,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,"合　　　　　計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,100,null,null,null,{"$f":"ROUNDDOWN(IF(AW252=0,0,(AW234*AX234+AW235*AX235+AW236*AX236+AW237*AX237+AW238*AX238+AW239*AX239+AW240*AX240+AW241*AX241+AW243*AX243+AW244*AX244+AW245*AX245+AW246*AX246+AW247*AX247+AW248*AX248+AW249*AX249+AW250*AX250)/AW252),2)","v":0},null,null,null,null,null,null,null,null,null,"",null,null,0,0,null,19,{"$f":"CONCATENATE(IF(OR(Q252=\"\",Q252=\"-\"),\"無\",\"有\"),IF(OR(Z252=\"\",Z252=\"-\"),\"無\",\"有\"))","v":"無無"},"",{"$f":"CONCATENATE(IF(AV252=SUM(AV243:AV250,AV234:AV241),\"合\",\"不\"),IF(AND(SUM(AW234:AW241,AW243:AW250)<=AW252,AW252<=(SUM(AW243:AW250,AW234:AW241)+16)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB252,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB252,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(AND(BG253=0,AZ252=\"有有\"),IF(Q252<=Q$109,IF(Z252<=Z$109,\"正正\",\"正大\"),IF(Z252<=Z$109,\"大正\",\"大大\")),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BH252,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH252,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ234:AZ252,\"無無無\")+COUNTIF(AZ234:AZ252,\"無無\")","v":19},{"$f":"IF(AZ253=AY252,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY252)-(COUNTIF(BA234:BA252,\"\")+COUNTIF(BC234:BC252,\"\")+COUNTIF(BE234:BE252,\"\")+COUNTIF(BG234:BG252,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY252-COUNTIF(BJ234:BJ252,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１","　「除外貸付」とは、法第13条の2第2項に規定する住宅資金貸付契約その他の内閣府令で定める契約をいう。"]
[null,null,null,null,null,null,"２","　「例外貸付」とは、法第13条の2第2項に規定する個人顧客の利益の保護に支障を生ずることがない契約（法\n第13の3第5項に規定する個人顧客の利益の保護に支障を生ずることがない極度方式基本契約を含む。）として\n内閣府令で定めるものをいう。"]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK267=0,\"７　総量規制超過部分の貸付残高\",\"７．総量規制超過部分の貸付残高\")","v":"７　総量規制超過部分の貸付残高"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK267=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK267=0,\"（表7）エラーなし\",\"！（表7）エラー情報あり\")","v":"（表7）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　先数・残高\n　貸付種別",null,null,null,null,null,null,null,null,null,null,"先　数",null,null,null,null,"残　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,"総量規制超過部分の貸付残高\n（自社貸付残高）",null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK265","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK264=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK266","v":""},null,null,{"$f":"IF(Q266=\"-\",0,Q266)","v":0},{"$f":"IF(V266=\"-\",0,V266)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(Q266=\"\",Q266=\"-\"),\"無\",\"有\"),IF(OR(V266=\"\",V266=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ266,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ266,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ266=\"有有\",IF(AW266/AV266>BL266,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD266,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD266,BD$76:BE$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AND(BG267=0,AZ266=\"有有\"),IF(Q266<=Q$109,IF(V266<=Z$109,\"正正\",\"正大\"),IF(V266<=Z$109,\"大正\",\"大大\")),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BH266,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH266,BH$76:BI$92,2,FALSE))","v":""},{"$f":"IF(AND(BA266=\"\",BC266=\"\",BE266=\"\",BG266=\"\",BI266=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$264=\"表示\",CONCATENATE(BJ266,BA266,BC266,BE266,BG266,BI266),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM266,BN266)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ266:AZ266,\"無無\")","v":1},{"$f":"IF(AZ267=AY266,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY266)-(COUNTIF(BA266:BA266,\"\")+COUNTIF(BC266:BC266,\"\")+COUNTIF(BE266:BE266,\"\")+COUNTIF(BG266:BG266,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY266-COUNTIF(BJ266,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１　「先数」は、本報告書作成時点で個人顧客と極度方式基本契約を締結している場合において、直近で実施\n　した法第13条の３第１項及び第２項の規定による調査（途上与信調査）の結果、同条第５項に規定する「基準\n　額超過極度方式基本契約」に該当すると認められた極度方式基本契約（下記２において「当該契約」という。）\n　に係る個人顧客の先数を記載する。"]
[]
[]
[null,null,null,null,null,null,"２　「残高」は、当該契約に係る個人顧客に対する提出業者の３月末時点の貸付残高（当該契約の残元本及び\n　当該契約以外の貸付けに係る契約を同一顧客と締結している場合にはその残元本。）のうち、当該個人顧客\n　に係る法第13条の２第２項に規定する「基準額」を超過している額を記載する。"]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK294=0,\"８　消費者向無担保貸付金の金額別内訳\",\"８．消費者向無担保貸付金の金額別内訳\")","v":"８　消費者向無担保貸付金の金額別内訳"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK294=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK294=0,\"（表8）エラーなし\",\"！（表8）エラー情報あり\")","v":"（表8）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　件数・残高\n　金　額　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK282","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK281=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,"10","万円以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$293=0,AV283=0),0,ROUNDDOWN(R283/R$293*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$293=0,AW283=0),0,ROUNDDOWN(AE283/AE$293*100,2))","v":0},null,null,null,null,null,{"$f":"BK283","v":""},null,null,{"$f":"IF(R283=\"-\",0,R283)","v":0},{"$f":"IF(AE283=\"-\",0,AE283)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R283=\"\",R283=\"-\"),\"無\",\"有\"),IF(OR(AE283=\"\",AE283=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ283,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ283,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ283=\"有有\",IF(AW283/AV283>BL283,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD283,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD283,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA283=\"\",BC283=\"\",BE283=\"\",BG283=\"\",BI283=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$281=\"表示\",CONCATENATE(BJ283,BA283,BC283,BE283,BG283,BI283),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM283,BN283)","v":0.1},0.1,100]
[null,null,null,null,null,null,null,"10","万円超",null,null,null,"20","万円以下",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$293=0,AV284=0),0,ROUNDDOWN(R284/R$293*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$293=0,AW284=0),0,ROUNDDOWN(AE284/AE$293*100,2))","v":0},null,null,null,null,null,{"$f":"BK284","v":""},null,null,{"$f":"IF(R284=\"-\",0,R284)","v":0},{"$f":"IF(AE284=\"-\",0,AE284)","v":0},null,2,"無無",""," ",null,"-",""," ",null," ",null,"",{"$f":"IF(BK$281=\"表示\",CONCATENATE(BJ284,BA284,BC284,BE284,BG284,BI284),\"\")","v":""},0.2,0.2,200]
[null,null,null,null,null,null,null,"20","　〃",null,null,null,"30","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,"","",0.3,0.3,300]
[null,null,null,null,null,null,null,"30","　〃",null,null,null,"50","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",0.5,0.5,500]
[null,null,null,null,null,null,null,"50","　〃",null,null,null,"70","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",0.7,0.7,700]
[null,null,null,null,null,null,null,"70","　〃",null,null,null,"100","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,6,"無無",""," ",null,"-",""," ",null," ",null,"","",1,1,1000]
[null,null,null,null,null,null,null,"100","　〃",null,null,null,"150","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,7,"無無",""," ",null,"-",""," ",null," ",null,"","",1.5,1.5,1500]
[null,null,null,null,null,null,null,"150","　〃",null,null,null,"200","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,8,"無無",""," ",null,"-",""," ",null," ",null,"","",2,2,2000]
[null,null,null,null,null,null,null,"200","　〃",null,null,null,"300","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,9,"無無",""," ",null,"-",""," ",null," ",null,"","",3,3,3000]
[null,null,null,null,null,"300万円超",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"",null,null,0,0,null,10,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,"",null,null,0,0,null,11,"無無","",{"$f":"CONCATENATE(IF(AV293=SUM(AV283:AV292),\"合\",\"不\"),IF(AND(SUM(AW283:AW292)<=AW293,AW293<=(SUM(AW283:AW292)+10)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB293,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB293,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(BG294=0,IF(R293=Q$100,IF(AE293=Z$100,\"正正消\",\"正誤消\"),IF(AE293=Z$100,\"誤正消\",\"誤誤消\")),\"-\")","v":"正正消"},{"$f":"IF(ISNA(VLOOKUP(BH293,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH293,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,"１　　件　　当　　た　　り　　平　　均　　貸　　付　　残　　高　　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV293=0,\"\",IF(AE282=\"百万円\",ROUNDDOWN(AE293/R293*1000,2),ROUNDDOWN(AE293/R293,2)))","v":""},null,null,null,null,null,null,null," 千円",null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ283:AZ293,\"無無\")","v":11},{"$f":"IF(AZ294=AY293,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY293)-(COUNTIF(BA283:BA293,\"\")+COUNTIF(BC283:BC293,\"\")+COUNTIF(BE283:BE293,\"\")+COUNTIF(BG283:BG293,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY293-COUNTIF(BJ283:BJ293,\"\")","v":0}]
[]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"　「合計」欄の件数及び残高は、「表１」の消費者向無担保貸付金の件数及び残高と一致する。"]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK314=0,\"９　消費者向無担保貸付金の金利別内訳\",\"９．消費者向無担保貸付金の金利別内訳\")","v":"９　消費者向無担保貸付金の金利別内訳"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK314=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK314=0,\"（表9）エラーなし\",\"！（表9）エラー情報あり\")","v":"（表9）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　件数・残高\n　金　利　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK306","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK305=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,"10.0","％以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$313=0,AV307=0),0,ROUNDDOWN(R307/R$313*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$313=0,AW307=0),0,ROUNDDOWN(AE307/AE$313*100,2))","v":0},null,null,null,null,"","",null,null,{"$f":"IF(R307=\"-\",0,R307)","v":0},{"$f":"IF(AE307=\"-\",0,AE307)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R307=\"\",R307=\"-\"),\"無\",\"有\"),IF(OR(AE307=\"\",AE307=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ307,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ307,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ307=\"有有\",IF(AW307/AV307>BL307,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD307,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD307,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA307=\"\",BC307=\"\",BE307=\"\",BG307=\"\",BI307=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$305=\"表示\",CONCATENATE(BJ307,BA307,BC307,BE307,BG307,BI307),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM307,BN307)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,null,"10.0","％超",null,null,null,"15.0","％以下",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,{"$f":"IF(AE308=\"-\",0,AE308)","v":0},null,2,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"15.0","　〃",null,null,null,"18.0","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"18.0","　〃",null,null,null,"20.0","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"20.0","　〃",null,null,null,"29.2","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"29.2","　〃",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,6,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,"","",null,null,0,0,null,7,"無無","",{"$f":"CONCATENATE(IF(AV313=SUM(AV307:AV312),\"合\",\"不\"),IF(AND(SUM(AW307:AW312)<=AW313,AW313<=(SUM(AW307:AW312)+6)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB313,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB313,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(BG314=0,IF(R313=Q$100,IF(AE313=Z$100,\"正正消\",\"正誤消\"),IF(AE313=Z$100,\"誤正消\",\"誤誤消\")),\"-\")","v":"正正消"},{"$f":"IF(ISNA(VLOOKUP(BH313,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH313,BH$76:BI$92,2,FALSE))","v":""},"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ307:AZ313,\"無無\")","v":7},{"$f":"IF(AZ314=AY313,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY313)-(COUNTIF(BA307:BA313,\"\")+COUNTIF(BC307:BC313,\"\")+COUNTIF(BE307:BE313,\"\")+COUNTIF(BG307:BG313,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY313-COUNTIF(BJ307:BJ313,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"「合計」欄の件数及び残高は、「表１」の消費者向無担保貸付金の件数及び残高と一致する。"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK334=0,\"10　事業者向無担保貸付金の金額別内訳\",\"10．事業者向無担保貸付金の金額別内訳\")","v":"10　事業者向無担保貸付金の金額別内訳"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK334=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK334=0,\"（表10）エラーなし\",\"！（表10）エラー情報あり\")","v":"（表10）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　件数・残高\n　金　額　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK324","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK323=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,"100","万円以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$333=0,AV325=0),0,ROUNDDOWN(R325/R$333*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$333=0,AW325=0),0,ROUNDDOWN(AE325/AE$333*100,2))","v":0},null,null,null,null,"","",null,null,{"$f":"IF(R325=\"-\",0,R325)","v":0},{"$f":"IF(AE325=\"-\",0,AE325)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R325=\"\",R325=\"-\"),\"無\",\"有\"),IF(OR(AE325=\"\",AE325=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ325,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ325,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ325=\"有有\",IF(AW325/AV325>BL325,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD325,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD325,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA325=\"\",BC325=\"\",BE325=\"\",BG325=\"\",BI325=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$323=\"表示\",CONCATENATE(BJ325,BA325,BC325,BE325,BG325,BI325),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM325,BN325)","v":1},1,1000]
[null,null,null,null,null,null,null,"100","万円超",null,null,null,"500","万円以下",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$333=0,AV326=0),0,ROUNDDOWN(R326/R$333*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$333=0,AW326=0),0,ROUNDDOWN(AE326/AE$333*100,2))","v":0},null,null,null,null,"","",null,null,0,0,null,2,"無無",""," ",null,"-",""," ",null," ",null,{"$f":"IF(AND(BA326=\"\",BC326=\"\",BE326=\"\",BG326=\"\",BI326=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$323=\"表示\",CONCATENATE(BJ326,BA326,BC326,BE326,BG326,BI326),\"\")","v":""},5,5,5000]
[null,null,null,null,null,null,null,"500","　〃",null,null,null,"1000","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,{"$f":"IF(AND(BA327=\"\",BC327=\"\",BE327=\"\",BG327=\"\",BI327=\"\"),\"\",\"←\")","v":""},"",10,10,10000]
[null,null,null,null,null,null,null,"1000","　〃",null,null,null,"5000","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,{"$f":"IF(AND(BA328=\"\",BC328=\"\",BE328=\"\",BG328=\"\",BI328=\"\"),\"\",\"←\")","v":""},"",50,50,50000]
[null,null,null,null,null,null,null,"5000","　〃",null,null,null,"1","億円以下",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",100,100,100000]
[null,null,null,null,null,null,null,"1","億円超",null,null,null,"5","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,6,"無無",""," ",null,{"$f":"IF(AZ330=\"有有\",IF(AW330/AV330>BL330,\"高額\",\"ok\"),\"-\")","v":"-"},""," ",null," ",null,"","",500,500,500000]
[null,null,null,null,null,null,null,"5","　〃",null,null,null,"10","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,7,"無無",""," ",null,"-",""," ",null," ",null,"","",1000,1000,1000000]
[null,null,null,null,null,null,null,"10億円超",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,8,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,"","",null,null,0,0,null,9,"無無","",{"$f":"CONCATENATE(IF(AV333=SUM(AV325:AV332),\"合\",\"不\"),IF(AND(SUM(AW325:AW332)<=AW333,AW333<=(SUM(AW325:AW332)+8)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB333,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB333,BB$76:BC$92,2,FALSE))","v":""},"-",""," ",null,{"$f":"IF(BG334=0,IF(R333=Q$104,IF(AE333=Z$104,\"正正事\",\"正誤事\"),IF(AE333=Z$104,\"誤正事\",\"誤誤事\")),\"-\")","v":"正正事"},{"$f":"IF(ISNA(VLOOKUP(BH333,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH333,BH$76:BI$92,2,FALSE))","v":""},"",{"$f":"IF(BK$323=\"表示\",CONCATENATE(BJ333,BA333,BC333,BE333,BG333,BI333),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,"１　　件　　当　　た　　り　　平　　均　　貸　　付　　残　　高　　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV333=0,\"\",ROUNDDOWN(AE333/R333,2))","v":""},null,null,null,null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ325:AZ333,\"無無\")","v":9},{"$f":"IF(AZ334=AY333,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY333)-(COUNTIF(BA325:BA333,\"\")+COUNTIF(BC325:BC333,\"\")+COUNTIF(BE325:BE333,\"\")+COUNTIF(BG325:BG333,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY333-COUNTIF(BJ325:BJ333,\"\")","v":0}]
[]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１　「合計」欄の件数及び残高は、「表１」の事業者向無担保貸付金の件数及び残高と一致する。"]
[null,null,null,null,null,null,"２　「１件当たり平均貸付残高」は、小数点第３位を切り捨て第２位までを記載する。例：1.25、0.36等"]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK354=0,\"11　事業者向無担保貸付金の金利別内訳\",\"11．事業者向無担保貸付金の金利別内訳\")","v":"11　事業者向無担保貸付金の金利別内訳"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK354=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK354=0,\"（表11）エラーなし\",\"！（表11）エラー情報あり\")","v":"（表11）エラーなし"}]
[]
[null,null,null,null,null,"　　　　　　　　　　　　　　　件数・残高\n　金　利　別",null,null,null,null,null,null,null,null,null,null,null,"件　　　　　数",null,null,null,null,null,null,null,null,null,null,null,null,"残　　　　　高"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"構成割合",null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"表１との整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,null,null,null,null,null,"％",null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,null,null,null,null,null,"％",null,null,null,null,null,{"$f":"BK345","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK344=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,null,"5.0","％以下",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$353=0,AV346=0),0,ROUNDDOWN(R346/R$353*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$353=0,AW346=0),0,ROUNDDOWN(AE346/AE$353*100,2))","v":0},null,null,null,null,"","",null,null,{"$f":"IF(R346=\"-\",0,R346)","v":0},{"$f":"IF(AE346=\"-\",0,AE346)","v":0},null,1,{"$f":"CONCATENATE(IF(OR(R346=\"\",R346=\"-\"),\"無\",\"有\"),IF(OR(AE346=\"\",AE346=\"-\"),\"無\",\"有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ346,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ346,AZ$76:BA$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AZ346=\"有有\",IF(AW346/AV346>BL346,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD346,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD346,BD$76:BE$92,2,FALSE))","v":""}," ",null," ",null,{"$f":"IF(AND(BA346=\"\",BC346=\"\",BE346=\"\",BG346=\"\",BI346=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$344=\"表示\",CONCATENATE(BJ346,BA346,BC346,BE346,BG346,BI346),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM346,BN346)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,"5.0",null,"％超",null,null,null,"10.0","％以下",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV$353=0,AV347=0),0,ROUNDDOWN(R347/R$353*100,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AW$353=0,AW347=0),0,ROUNDDOWN(AE347/AE$353*100,2))","v":0},null,null,null,null,"","",null,null,0,0,null,2,"無無",""," ",null,"-",""," ",null," ",null,"",{"$f":"IF(BK$344=\"表示\",CONCATENATE(BJ347,BA347,BC347,BE347,BG347,BI347),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"10.0","　〃",null,null,null,"15.0","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,3,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"15.0","　〃",null,null,null,"18.0","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,4,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"18.0","　〃",null,null,null,"20.0","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,5,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"20.0","　〃",null,null,null,"29.2","　 〃",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,6,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,"29.2","　〃",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"","",null,null,0,0,null,7,"無無",""," ",null,"-",""," ",null," ",null,"","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,"","",null,null,0,0,null,8,"無無","",{"$f":"CONCATENATE(IF(AV353=SUM(AV346:AV352),\"合\",\"不\"),IF(AND(SUM(AW346:AW352)<=AW353,AW353<=(SUM(AW346:AW352)+7)),\"合\",\"不\"))","v":"合合"},{"$f":"IF(ISNA(VLOOKUP(BB353,BB$76:BC$92,2,FALSE))=TRUE,\"\",VLOOKUP(BB353,BB$76:BC$92,2,FALSE))","v":""},{"$f":"IF(AZ353=\"有有\",IF(AW353/AV353>BL353,\"高額\",\"ok\"),\"-\")","v":"-"},""," ",null,{"$f":"IF(BG354=0,IF(R353=Q$104,IF(AE353=Z$104,\"正正事\",\"正誤事\"),IF(AE353=Z$104,\"誤正事\",\"誤誤事\")),\"-\")","v":"正正事"},{"$f":"IF(ISNA(VLOOKUP(BH353,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH353,BH$76:BI$92,2,FALSE))","v":""},{"$f":"IF(AND(BA353=\"\",BC353=\"\",BE353=\"\",BG353=\"\",BI353=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$344=\"表示\",CONCATENATE(BJ353,BA353,BC353,BE353,BG353,BI353),\"\")","v":""},1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ346:AZ353,\"無無\")","v":8},{"$f":"IF(AZ354=AY353,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY353)-(COUNTIF(BA346:BA353,\"\")+COUNTIF(BC346:BC353,\"\")+COUNTIF(BE346:BE353,\"\")+COUNTIF(BG346:BG353,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY353-COUNTIF(BJ346:BJ353,\"\")","v":0}]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"　「合計」欄の件数及び残高は、「表１」の事業者向無担保貸付金の件数及び残高と一致する。"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(BK371=0,\"12　消費者向無担保貸付金の新規契約状況等\",\"12．消費者向無担保貸付金の新規契約状況等\")","v":"12　消費者向無担保貸付金の新規契約状況等"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK371=0,\"\",\"エラー情報あり\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK371=0,\"（表12）エラーなし\",\"！（表12）エラー情報あり\")","v":"（表12）エラーなし"}]
[]
[null,null,null,null,null,"⑴　新規契約状況"]
[null,null,null,null,null,"　",null,null,null,null,null,null,null,null,null,"件　数　等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力漏れ",null,"合計値整合性",null,"1件当たり単価",null,"金利（109.5%超）",null,"12表内における整合性",null,null,"表示"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK364","v":"　　（↓エラー情報↓）"},null,null,"件数","残高",null,null,"チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示","チェック","エラー表示",null,{"$f":"IF(BK363=\"表示\",\"　　（↓エラー情報↓）\",\"\")","v":"　　（↓エラー情報↓）"},"単価上限","百万円","千円"]
[null,null,null,null,null,null,"新規申込件数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK365","v":""},null,null,{"$f":"IF(P365=\"-\",0,P365)","v":0},null,null,1,{"$f":"IF(OR(P365=\"\",P365=\"-\"),IF(OR(P366=\"\",P366=\"-\"),\"無無\",\"申無\"),IF(OR(P366=\"\",P366=\"-\"),\"↓\",\"有有\"))","v":"無無"},{"$f":"IF(ISNA(VLOOKUP(AZ365,AZ$76:BA$92,2,FALSE))=TRUE,\"\",VLOOKUP(AZ365,AZ$76:BA$92,2,FALSE))","v":""}," ",null," ",null," ",null,{"$f":"IF(AND(BG371=0,AZ365=\"有有\"),IF(P366<=P365,\"正正\",\"↓\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BH365,BH$76:BI$92,2,FALSE))=TRUE,\"\",VLOOKUP(BH365,BH$76:BI$92,2,FALSE))","v":""},{"$f":"IF(AND(BA365=\"\",BC365=\"\",BE365=\"\",BG365=\"\",BI365=\"\"),\"\",\"←\")","v":""},{"$f":"IF(BK$363=\"表示\",CONCATENATE(BJ365,BA365,BC365,BE365,BG365,BI365),\"\")","v":""},{"$f":"IF(Z$99=\"百万円\",BM365,BN365)","v":1000000},1000000,1000000000]
[null,null,null,null,null,null,"新規契約件数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"件",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK366","v":""},null,null,{"$f":"IF(P366=\"-\",0,P366)","v":0},null,null,2,{"$f":"IF(OR(P365=\"\",P365=\"-\"),IF(OR(P366=\"\",P366=\"-\"),\"無無\",\"↑\"),IF(P366=\"\",\"数無\",\"有有\"))","v":"無無"},""," ",null," ",null," ",null,{"$f":"IF(AND(BG371=0,AZ366=\"有有\"),IF(OR(P366=\"-\",P366<=P365),\"正正\",\"正契大\"),\"-\")","v":"-"},"","","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"新規契約率",null,null,null,null,null,null,null,null,{"$f":"IF(OR(AV365=0,AV366=0),\"\",ROUNDDOWN(AV366/AV365*100,2))","v":""},null,null,null,null,null,null,null,"％",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P381=\"-\",0,P381)","v":0},{"$f":"IF(P380=\"-\",0,P380)","v":0},null,3,{"$f":"IF(OR(P380=\"\",P380=\"-\"),IF(OR(P381=\"\",P381=\"-\"),\"無無\",\"額無\"),IF(OR(P381=\"\",P381=\"-\"),\"↓\",\"有有\"))","v":"無無"},""," ",null,{"$f":"IF(AZ367=\"有有\",IF(AW367/AV367>BL367,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD367,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD367,BD$76:BE$92,2,FALSE))","v":""}," ",null,{"$f":"IF(BG$371=0,\"-\")","v":"-"},"","","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P381=\"-\",0,P381)","v":0},{"$f":"IF(P380=\"-\",0,P380)","v":0},null,4,{"$f":"IF(OR(P380=\"\",P380=\"-\"),IF(OR(P381=\"\",P381=\"-\"),\"無無\",\"↑\"),IF(OR(P381=\"\",P381=\"-\"),\"数無\",\"有有\"))","v":"無無"},""," ",null," ",null," ",null,{"$f":"IF(AND(BG$371=0,AZ368=\"有有\"),IF(P381<=P366,\"正正\",\"正貸大\"),\"-\")","v":"-"},"","","",1000000,1000000,1000000000]
[null,null,null,null,null,"（記載上の注意）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P395=\"-\",0,P395)","v":0},{"$f":"IF(P394=\"-\",0,P394)","v":0},null,5,{"$f":"IF(OR(P394=\"\",P394=\"-\"),IF(OR(P395=\"\",P395=\"-\"),\"無無\",\"額無\"),IF(OR(P395=\"\",P395=\"-\"),\"↓\",\"有有\"))","v":"無無"},""," ",null,{"$f":"IF(AZ369=\"有有\",IF(AW369/AV369>BL369,\"高額\",\"ok\"),\"-\")","v":"-"},{"$f":"IF(ISNA(VLOOKUP(BD369,BD$76:BE$92,2,FALSE))=TRUE,\"\",VLOOKUP(BD369,BD$76:BE$92,2,FALSE))","v":""}," ",null,{"$f":"IF(AND(BG$371=0,AZ369=\"有有\"),IF(P394>=P366,\"正正\",\"正当小\"),\"-\")","v":"-"},"","","",1000000,1000000,1000000000]
[null,null,null,null,null,null,"１　新規申込件数は、当該年度の申込件数（既存顧客からの申込件数を含み、貸付条件変更に係るものは除く。）\n  を記載する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P395=\"-\",0,P395)","v":0},{"$f":"IF(P394=\"-\",0,P394)","v":0},null,6,{"$f":"IF(OR(P394=\"\",P394=\"-\"),IF(OR(P395=\"\",P395=\"-\"),\"無無\",\"↑\"),IF(OR(P395=\"\",P395=\"-\"),\"数無\",\"有有\"))","v":"無無"},""," ",null," ",null," ",null,{"$f":"IF(AND(BG$371=0,AZ370=\"有有\"),IF(P395>=P366,\"正正\",\"正当小\"),\"-\")","v":"-"},"","","",1000000,1000000,1000000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AZ365:AZ370,\"無無\")","v":6},{"$f":"IF(AZ371=AY370,\"｢該当なし」\",\"\")","v":"｢該当なし」"},null,null,null,null,"入力漏れ～金利までのエラー数⇒",{"$f":"(4*AY370)-(COUNTIF(BA365:BA370,\"\")+COUNTIF(BC365:BC370,\"\")+COUNTIF(BE365:BE370,\"\")+COUNTIF(BG365:BG370,\"\"))","v":0},null,null,"全エラー数⇒",{"$f":"AY370-COUNTIF(BJ365:BJ370,\"\")","v":0}]
[null,null,null,null,null,null,"２　新規契約件数は、当該年度の契約件数（既存顧客との契約件数を含み、貸付条件変更に係るものは除く。）を\n　記載する。"]
[]
[null,null,null,null,null,null,"３　新規契約率は、新規契約件数を新規申込件数で除した数字を小数点第３位を切り捨て第２位まで記載する。"]
[]
[]
[null,null,null,null,null,"(2-1)　新規貸付状況"]
[null,null,null,null,null,"　",null,null,null,null,null,null,null,null,null,"件　数　等"]
[]
[null,null,null,null,null,null,"新規貸付総額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$X$394","v":"百万円"},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK367","v":""}]
[null,null,null,null,null,null,"新規貸付件数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  件",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK368","v":""}]
[null,null,null,null,null,null,"新規平均貸付額",null,null,null,null,null,null,null,null,{"$f":"IF(AV367=0,\"\",IF(X380=\"百万円\",(P380*1000)/P381,P380/P381))","v":""},null,null,null,null,null,null,null," 千円"]
[]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１","　新規貸付総額は、当該年度に行った新規顧客に対する初回貸付の総額を記載する。"]
[null,null,null,null,null,null,"２","　新規貸付件数は、当該年度に行った新規顧客に対する初回貸付の件数を記載する。"]
[null,null,null,null,null,null,"３","　新規平均貸付額は、新規貸付総額を新規貸付件数で除した数字を記載する。"]
[null,null,null,null,null,null,"４","　上記１から３の数字について把握できない場合は、「(2-2)　当該年度の貸付状況」を記載すること\n（本表(2-1)の記載は不要）。"]
[]
[]
[null,null,null,null,null,"(2-2)　当該年度の貸付状況"]
[null,null,null,null,null,"　",null,null,null,null,null,null,null,null,null,"件　数　等"]
[]
[null,null,null,null,null,null,"当該年度貸付総額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"百万円",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK369","v":""}]
[null,null,null,null,null,null,"当該年度貸付件数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  件",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK370","v":""}]
[null,null,null,null,null,"当該年度平均貸付額",null,null,null,null,null,null,null,null,null,{"$f":"IF(AV369=0,\"\",IF(X394=\"百万円\",(P394*1000)/P395,P394/P395))","v":""},null,null,null,null,null,null,null," 千円"]
[]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１","　貸付総額は、当該年度に行った貸付けの総額を記載する。"]
[null,null,null,null,null,null,"２","　貸付件数は、当該年度に行った貸付けの件数を記載する。"]
[null,null,null,null,null,null,"３","　平均貸付額は、貸付総額を貸付件数で除した数字を記載する。"]
[null,null,null,null,null,null,"４","　「(2-1)　新規貸付状況」を記載した場合には、本表(2-2)の記載は不要とする。"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"○"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"13　貸金業協会等への加入状況等",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AT414=\"\",\"\",\"エラー情報あり\")","v":"エラー情報あり"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AT414=\"\",\"エラーなし\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"１　貸金業協会に加盟している",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(BB426=\"\",BB427=\"\"),\"\",IF(BB427=\"\",BB426,BB427))","v":"←いずれかの欄に○印をご記載下さい！"},null,null,{"$f":"IF(F414=\"○\",1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"２　指定信用情報機関に加盟している",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F415=\"○\",1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"３　電話加入権に質権を設定することを目的とした事業協同組合に加盟している",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F416=\"○\",1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"４　一般社団法人日本クレジット協会に加盟している",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"５　日本クレジットカード協会に加盟している",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"６　包括信用購入あっせん業者又は個別信用購入あっせん業者として登録を受けている",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"７　電気機械器具関係の一般社団法人等に加盟している（関係会社が加盟している場合を含む）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"８　自動車関係の一般社団法人等に加盟している（関係会社が加盟している場合を含む）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"９　日本百貨店協会、日本チェーンストア協会、協同組合連合会日本商店連盟、協同組合連合会日本専門\n　店会連盟に加盟している（関係会社が加盟している場合を含む）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"10　建設・不動産関係の一般社団法人等に加盟している（関係会社が加盟している場合を含む）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"11　質屋の許可を受けている",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"12　公益社団法人リース事業協会に加盟している",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"13　日賦貸金業者として登録されている",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ426","v":""},null,null,null,null,null,null,"",null,null,{"$f":"IF(AND(MID($AF$22,2,1)=\"N\",F426=\"\"),\"←表紙の登録番号\" & AF22 & \"が日賦貸金業者で登録となっています。○を記入して下さい。\",IF(AND(MID($AF$22,2,1)<>\"N\",F426=\"○\"),\"←表紙の登録番号\" & AF23 & \"では日賦貸金業者として登録されていません。\",\"\"))","v":""},null,{"$f":"IF(AND(COUNT(AW414:AW426)>=1,AW427=1),BC426,\"\")","v":""},"←１～12及び13両方の欄に○印が記載されています！"]
[null,null,null,null,null,null,null,null,"14　上記のいずれにも該当しない",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(COUNT(AW414:AW427)=0,BC427,\"\")","v":"←いずれかの欄に○印をご記載下さい！"},"←いずれかの欄に○印をご記載下さい！"]
[null,null,null,null,null,"※　その他加入している団体があればその名称を記載すること"]
[]
[]
[null,null,null,null,null,"（記載上の注意）"]
[null,null,null,null,null,null,"１","　１～１４の該当する項目の左の欄に○印を記載し、参考についてはその名称を記載すること。"]
[null,null,null,null,null,null,"２","　一般社団法人等とは、一般社団法人、一般財団法人、公益社団法人、公益財団法人等をいう。"]

{"sheet":"残高の集計方法","index":1,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[33,1,33,19],[27,1,27,19],[28,1,28,19],[29,1,29,19],[30,1,30,19],[31,1,31,19],[32,1,32,19],[26,1,26,19],[12,1,12,19],[13,1,13,19],[14,1,14,19],[15,1,15,19],[18,1,18,19],[19,1,19,19],[20,1,20,19],[21,1,21,19],[22,1,22,19],[24,1,24,19],[25,1,25,19],[11,1,11,19],[0,0,0,19],[5,1,5,19],[8,1,8,19],[9,1,9,19],[10,1,10,19]]}
["残高の集計方法等について"]
[]
[]
["１．業務報告書と事業報告書の残高集計に関する記載"]
[null,"◆業務報告書「目次」の記載上の注意４"]
[null,"　「各表の残高の単位（百万円、千円）未満の端数は、特に注記がない限り切り捨てて記載する。\n　このため、各表の残高内訳の合計は「合計」（又は「計」）欄の残高と合致しない場合がある。」"]
[null,"・事業報告書の残高の集計方法も、前項記載の業務報告書と同じ扱いになります。"]
[null,"【ポイント】"]
[null,"　・各表の残高内訳欄については、それぞれ単位未満の端数を切り捨てて下さい。"]
[null,"　・各表の「計」や「合計」は、各社で集計した貸付金残高の合計額について単位未満の"]
[null,"　　端数を切り捨てて下さい。"]
[null,"　　※「計」や「合計」の残高は、残高内訳欄の数値の合計と異なる場合がありますので注意"]
[null,"　　　して下さい。"]
[null,"　　　　各表の残高内訳の「合計」　≦　「合計」　→　【正】"]
[null,"　　　　各表の残高内訳の「合計」　＞　「合計」　→　【誤】"]
[]
[]
["２．業務報告書と事業報告書の構成割合について"]
[null,"・上記１.の集計方法をとるため、合計欄にある構成割合は、常に１００％（固定値）になります。"]
[null,"・残高内訳欄毎の構成割合は、残高内訳欄の切捨て処理した額（分子）を「合計」欄の額（分母）"]
[null,"　で除した数値となります。従って、残高内訳欄の各構成割合の数値を合算しても１００％になら"]
[null,"　ない場合があります。"]
[]
["３．業務報告書と事業報告書の残高について（償却前か償却後の数値か？）"]
[null,"・事業報告書では、表９の記載上の注意２において、「貸付金残高は、償却前の貸付金残高とする。」"]
[null,"　と表記されていますので、貸付金残高は「償却前」の数値を記載する必要があります。"]
[]
[null,"・業務報告書については、目次の記載上の注意において、「法の規制を受ける貸付けについて、\n　直近の３月３１日時点の計数等を記載する」とされているだけです。"]
[null,"　"]
[null,"　当然、３月決算以外の業者もありますので、償却が行われていない数値が前提になります。"]
[null,"　事業報告書の表４の記載上の注意１において、３月決算の法人について業務報告書を先に提出す\n　る場合、事業報告書表４と表５の記載は省略できるようになりました。事業報告書は、前記の通\n　り「償却前」の数値記載が義務付けられていますので、同一の数値が記載される業務報告書も\n　「償却前」の数値が記載されていなければならないことになります。"]
[null,"　従いまして、業務報告書に記載する貸付金残高についても、事業報告書同様「償却前」の数値が\n　入ることになります。"]

{"sheet":"表１の「関係会社向」けの範囲","index":2,"n_rows":56,"n_cols":28,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,27,1,31],[22,5,23,8],[22,11,23,14],[2,27,2,31],[4,21,5,24],[10,27,11,30],[16,2,17,5],[16,8,17,11],[16,21,17,24],[4,13,5,16],[10,17,11,20],[22,27,23,30],[16,27,17,31],[22,20,23,23],[55,0,55,32],[28,17,29,20],[38,1,53,15],[38,17,53,31],[32,1,36,31],[28,23,29,26]]}
[]
[null,"表１の「関係会社向」けの範囲",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"「目次」へ戻る"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"「表１」へ戻る"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"親会社",null,null,null,null,null,null,null,"他の会社"]
[null,null,"（親会社の関係会社）"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（子会社）",null,null,null,null,"（関連会社）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"親会社",null,null,null,null,null,null,null,null,null,"他の会社"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（子会社）",null,null,null,null,null,null,"（関連会社）"]
[]
[]
[null,null,"関連会社",null,null,null,null,null,"子会社",null,null,null,null,null,null,null,null,null,null,null,null,"提出業者",null,null,null,null,null,"（提出業者の\n関係会社）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（合算）"]
[]
[]
[null,null,null,null,null,"子会社",null,null,null,null,null,"子会社",null,null,null,null,null,null,null,null,"子会社",null,null,null,null,null,null,"関連会社"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（合算）"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"子会社",null,null,null,null,null,"子会社"]
[]
[]
[]
[null,"　「関係会社」とは、提出業者の親会社、子会社及び関連会社並びに提出業者が他の会社等の関連会社\nである場合における当該他の会社等をいう。\n　表１の「関係会社向」の範囲は、業務報告書提出業者の関係会社及び同提出業者の親会社の関係会社\nに対する貸付けとする。（法の規制を受ける貸付けに限る。）"]
[]
[]
[]
[]
[]
[null,"　　　　　　　　　　　　　＜子会社＞\n\n ○ 議決権の過半数を保有\n ○ 議決権の40％以上50％以下を保有する場合\n　　であって、\n　・ 密接な関係（出資、人事、資金等）があり、他の\n　　同一の内容の議決権行使を行う者と併せて\n　　議決権の過半数を保有\n　・ 役員等が当該会社の取締役会等の過半数を\n　　構成\n　・ 重要な事業方針決定を支配する契約等が存在\n　・ 資金調達の総額の過半を融資\n　　等\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                        ＜関連会社＞\n\n ○ 議決権の20％以上を保有\n ○ 議決権の15％以上20％未満を保有している\n　　場合であって、\n　・ 役員等が当該会社の意取締役に就任\n　・ 重要な融資を行っている\n　・ 事業方針決定に重要な影響を与えることが\n　　推測される事実が存在　等\n ○ 密接な関係（出資、人事、資金等）があり、\n　　他の同一の内容の議決権行使を行う者と併せ\n　　て議決権の20％以上を保有\n ○ 複数の独立した企業により契約等に基づいて\n　　共同で支配"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["（⇒「財務諸表等の用語、様式及び作成方法に関する規則」（昭和38年大蔵省令第59号）第８条を参照）"]