{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["データベース化する表","output","参考ピボットテーブル"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":59,"n_cols":37,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,null,"2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","年度計"]
["人数","原価要員数",30,30,30,30,30,30,30,30,30,30,30,30]
[null,"販管要員数",15,15,15,15,15,15,15,15,15,15,15,15]
[null,null,null,null,null,null,null,null,null,null,null,null,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]
["ｺｰﾄﾞ","科目名              ","4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月","年度計"]
[4111,"売上高",50000000,50000000,45000000,50000000,50000000,50000000,50000000,50000000,40000000,50000000,50000000,60000000,{"$f":"SUM(C6:N6)","v":595000000}]
[5421,"給与(原)",18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,23000000,221000000]
[5423,"賞与(原)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[5425,"法定福利費(原)",2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,3220000.0000000005,30940000.000000004]
[5429,"外注委託費(原)",1500000,1500000,1500000,1500000,1500000,1500000,1500000,1500000,0,0,0,0,12000000]
[5442,"賃借料(原) ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[5452,"保険料(原)",20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,240000]
[5455,"旅費交通費(原)",6020000,6220000,11220000,7050000,6650000,6650000,7500000,6950000,6350000,6920000,6320000,6720000,84570000]
[5456,"通信費(原)",300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,3600000]
[5457,"接待交際費(原)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[5458,"消耗品費(原)",250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,550000,3300000]
[5459,"運送費(原)",40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,480000]
[5460,"会議費(原)",85000,85000,85000,85000,85000,85000,85000,85000,85000,85000,85000,85000,1020000]
[5461,"書籍代(原)",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,600000]
[5479,"雑費(原)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[5600,"その他（原）",null,null,null,null,null,null,null,null,null,null,null,null,0]
[5700,"売上原価",{"$f":"SUM(C7:C21)","v":28785000},{"$f":"SUM(D7:D21)","v":28985000},33985000,29815000,29415000,29415000,30265000,29715000,27615000,28185000,27585000,33985000,357750000]
[6000,"売上総利益",{"$f":"C6-C22","v":21215000},21015000,11015000,20185000,20585000,20585000,19735000,20285000,12385000,21815000,22415000,26015000,237250000]
[6111,"役員報酬",1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,12000000]
[6112,"給与手当(役員報酬除く）",9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,108000000]
[6114,"賞与",null,null,null,null,null,null,null,null,null,null,null,null,0]
[6116,"法定福利費",1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,14040000]
[6117,"福利厚生費",226000,226000,226000,226000,226000,268000,226000,226000,426000,268000,226000,226000,2996000]
[6122,"顧問報酬",300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,3600000]
[6211,"派遣社員",0,0,0,0,0,0,0,0,0,0,0,0,0]
[6212,"消耗品費",377000,252000,252000,252000,252000,252000,377000,252000,252000,252000,252000,252000,3274000]
[6213,"賃借料",1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,12355200]
[6215,"保険料",0,0,0,1400000,0,0,0,0,0,40000,0,0,1440000]
[6216,"修繕維持費",482000,532000,842000,482000,482000,882000,482000,482000,782000,482000,482000,982000,7394000]
[6217,"租税公課",0,0,600000,15000,0,50000,0,0,0,0,0,50000,715000]
[6218,"減価償却費",290000,290000,290000,290000,290000,290000,290000,290000,290000,290000,290000,290000,3480000]
[6219,"貸倒引当金繰入",0,0,0,0,0,0,0,0,0,0,0,200000,200000]
[6221,"旅費交通費",735000,735000,465000,465000,465000,465000,450000,450000,450000,450000,450000,450000,6030000]
[6222,"通信費",43000,43000,43000,43000,43000,43000,43000,43000,43000,43000,43000,43000,516000]
[6223,"会議費",35400,35400,35400,35400,35400,35400,35400,35400,35400,35400,35400,35400,424800]
[6224,"水道光熱費",45000,45000,45000,45000,45000,45000,45000,45000,45000,45000,45000,45000,540000]
[6225,"支払手数料",250000,500000,260000,250000,200000,300000,200000,200000,300000,250000,200000,300000,3210000]
[6226,"新聞図書費",9700,9700,9700,9700,9700,14700,9700,9700,9700,9700,9700,14700,126400]
[6227,"銀行手数料",5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
[6228,"販促・広告費",135000,0,0,500000,0,0,135000,0,0,500000,0,0,1270000]
[6229,"接待交際費",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,600000]
[6230,"諸会費",null,null,null,null,60000,20000,60000,null,null,null,null,60000,200000]
[6231,"寄付金",0,0,0,30000,0,0,0,0,0,30000,0,0,60000]
[6233,"運送費",15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,180000]
[6234,"教育･トレーニング費 ",null,null,null,null,null,null,150000,null,null,null,null,500000,650000]
[6235,"紹介手数料",0,0,0,0,0,0,630000,0,0,0,0,630000,1260000]
[6236,"採用費",null,null,null,null,null,null,null,null,null,null,null,null,0]
[6249,"雑費",0,0,0,0,0,0,0,0,0,0,0,0,0]
[7000,"営業利益",{"$f":"C23-SUM(C24:C53)","v":6017300},5777300,-4622700,3572300,5907300,5350300,4032300,5682300,-2817700,6550300,7812300,9367300,52628600]
[7111,"受取利息",0,0,0,0,0,0,0,0,0,0,0,0,0]
[7119,"雑収入",0,0,0,0,0,0,0,0,0,0,0,0,0]
[7211,"支払利息割引料",0,0,0,0,0,0,0,0,0,0,0,0,0]
[7219,"雑損失",0,0,0,0,0,0,0,0,0,0,0,0,0]
[8000,"経常利益",{"$f":"C54+C55+C56-C57-C58","v":6017300},{"$f":"D54+D55+D56-D57-D58","v":5777300},-4622700,3572300,5907300,5350300,4032300,5682300,-2817700,6550300,7812300,9367300,52628600]

{"sheet":"output","index":1,"n_rows":414,"n_cols":4,"rows_kept":414,"cut":false,"hidden":false,"merged":[]}
["コード","科目名称","年月","金額"]
[4111,"売上高","2017-04-01",50000000]
[5421,"給与(原)","2017-04-01",18000000]
[5425,"法定福利費(原)","2017-04-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-04-01",1500000]
[5452,"保険料(原)","2017-04-01",20000]
[5455,"旅費交通費(原)","2017-04-01",6020000]
[5456,"通信費(原)","2017-04-01",300000]
[5458,"消耗品費(原)","2017-04-01",250000]
[5459,"運送費(原)","2017-04-01",40000]
[5460,"会議費(原)","2017-04-01",85000]
[5461,"書籍代(原)","2017-04-01",50000]
[5700,"売上原価","2017-04-01",28785000]
[6000,"売上総利益","2017-04-01",21215000]
[6111,"役員報酬","2017-04-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-04-01",9000000]
[6116,"法定福利費","2017-04-01",1170000]
[6117,"福利厚生費","2017-04-01",226000]
[6122,"顧問報酬","2017-04-01",300000]
[6212,"消耗品費","2017-04-01",377000]
[6213,"賃借料","2017-04-01",1029600]
[6216,"修繕維持費","2017-04-01",482000]
[6218,"減価償却費","2017-04-01",290000]
[6221,"旅費交通費","2017-04-01",735000]
[6222,"通信費","2017-04-01",43000]
[6223,"会議費","2017-04-01",35400]
[6224,"水道光熱費","2017-04-01",45000]
[6225,"支払手数料","2017-04-01",250000]
[6226,"新聞図書費","2017-04-01",9700]
[6227,"銀行手数料","2017-04-01",5000]
[6228,"販促・広告費","2017-04-01",135000]
[6229,"接待交際費","2017-04-01",50000]
[6233,"運送費","2017-04-01",15000]
[7000,"営業利益","2017-04-01",6017300]
[8000,"経常利益","2017-04-01",6017300]
[4111,"売上高","2017-05-01",50000000]
[5421,"給与(原)","2017-05-01",18000000]
[5425,"法定福利費(原)","2017-05-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-05-01",1500000]
[5452,"保険料(原)","2017-05-01",20000]
[5455,"旅費交通費(原)","2017-05-01",6220000]
[5456,"通信費(原)","2017-05-01",300000]
[5458,"消耗品費(原)","2017-05-01",250000]
[5459,"運送費(原)","2017-05-01",40000]
[5460,"会議費(原)","2017-05-01",85000]
[5461,"書籍代(原)","2017-05-01",50000]
[5700,"売上原価","2017-05-01",28985000]
[6000,"売上総利益","2017-05-01",21015000]
[6111,"役員報酬","2017-05-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-05-01",9000000]
[6116,"法定福利費","2017-05-01",1170000]
[6117,"福利厚生費","2017-05-01",226000]
[6122,"顧問報酬","2017-05-01",300000]
[6212,"消耗品費","2017-05-01",252000]
[6213,"賃借料","2017-05-01",1029600]
[6216,"修繕維持費","2017-05-01",532000]
[6218,"減価償却費","2017-05-01",290000]
[6221,"旅費交通費","2017-05-01",735000]
[6222,"通信費","2017-05-01",43000]
[6223,"会議費","2017-05-01",35400]
[6224,"水道光熱費","2017-05-01",45000]
[6225,"支払手数料","2017-05-01",500000]
[6226,"新聞図書費","2017-05-01",9700]
[6227,"銀行手数料","2017-05-01",5000]
[6229,"接待交際費","2017-05-01",50000]
[6233,"運送費","2017-05-01",15000]
[7000,"営業利益","2017-05-01",5777300]
[8000,"経常利益","2017-05-01",5777300]
[4111,"売上高","2017-06-01",45000000]
[5421,"給与(原)","2017-06-01",18000000]
[5425,"法定福利費(原)","2017-06-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-06-01",1500000]
[5452,"保険料(原)","2017-06-01",20000]
[5455,"旅費交通費(原)","2017-06-01",11220000]
[5456,"通信費(原)","2017-06-01",300000]
[5458,"消耗品費(原)","2017-06-01",250000]
[5459,"運送費(原)","2017-06-01",40000]
[5460,"会議費(原)","2017-06-01",85000]
[5461,"書籍代(原)","2017-06-01",50000]
[5700,"売上原価","2017-06-01",33985000]
[6000,"売上総利益","2017-06-01",11015000]
[6111,"役員報酬","2017-06-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-06-01",9000000]
[6116,"法定福利費","2017-06-01",1170000]
[6117,"福利厚生費","2017-06-01",226000]
[6122,"顧問報酬","2017-06-01",300000]
[6212,"消耗品費","2017-06-01",252000]
[6213,"賃借料","2017-06-01",1029600]
[6216,"修繕維持費","2017-06-01",842000]
[6217,"租税公課","2017-06-01",600000]
[6218,"減価償却費","2017-06-01",290000]
[6221,"旅費交通費","2017-06-01",465000]
[6222,"通信費","2017-06-01",43000]
[6223,"会議費","2017-06-01",35400]
[6224,"水道光熱費","2017-06-01",45000]
[6225,"支払手数料","2017-06-01",260000]
[6226,"新聞図書費","2017-06-01",9700]
[6227,"銀行手数料","2017-06-01",5000]
[6229,"接待交際費","2017-06-01",50000]
[6233,"運送費","2017-06-01",15000]
[7000,"営業利益","2017-06-01",-4622700]
[8000,"経常利益","2017-06-01",-4622700]
[4111,"売上高","2017-07-01",50000000]
[5421,"給与(原)","2017-07-01",18000000]
[5425,"法定福利費(原)","2017-07-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-07-01",1500000]
[5452,"保険料(原)","2017-07-01",20000]
[5455,"旅費交通費(原)","2017-07-01",7050000]
[5456,"通信費(原)","2017-07-01",300000]
[5458,"消耗品費(原)","2017-07-01",250000]
[5459,"運送費(原)","2017-07-01",40000]
[5460,"会議費(原)","2017-07-01",85000]
[5461,"書籍代(原)","2017-07-01",50000]
[5700,"売上原価","2017-07-01",29815000]
[6000,"売上総利益","2017-07-01",20185000]
[6111,"役員報酬","2017-07-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-07-01",9000000]
[6116,"法定福利費","2017-07-01",1170000]
[6117,"福利厚生費","2017-07-01",226000]
[6122,"顧問報酬","2017-07-01",300000]
[6212,"消耗品費","2017-07-01",252000]
[6213,"賃借料","2017-07-01",1029600]
[6215,"保険料","2017-07-01",1400000]
[6216,"修繕維持費","2017-07-01",482000]
[6217,"租税公課","2017-07-01",15000]
[6218,"減価償却費","2017-07-01",290000]
[6221,"旅費交通費","2017-07-01",465000]
[6222,"通信費","2017-07-01",43000]
[6223,"会議費","2017-07-01",35400]
[6224,"水道光熱費","2017-07-01",45000]
[6225,"支払手数料","2017-07-01",250000]
[6226,"新聞図書費","2017-07-01",9700]
[6227,"銀行手数料","2017-07-01",5000]
[6228,"販促・広告費","2017-07-01",500000]
[6229,"接待交際費","2017-07-01",50000]
[6231,"寄付金","2017-07-01",30000]
[6233,"運送費","2017-07-01",15000]
[7000,"営業利益","2017-07-01",3572300]
[8000,"経常利益","2017-07-01",3572300]
[4111,"売上高","2017-08-01",50000000]
[5421,"給与(原)","2017-08-01",18000000]
[5425,"法定福利費(原)","2017-08-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-08-01",1500000]
[5452,"保険料(原)","2017-08-01",20000]
[5455,"旅費交通費(原)","2017-08-01",6650000]
[5456,"通信費(原)","2017-08-01",300000]
[5458,"消耗品費(原)","2017-08-01",250000]
[5459,"運送費(原)","2017-08-01",40000]
[5460,"会議費(原)","2017-08-01",85000]
[5461,"書籍代(原)","2017-08-01",50000]
[5700,"売上原価","2017-08-01",29415000]
[6000,"売上総利益","2017-08-01",20585000]
[6111,"役員報酬","2017-08-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-08-01",9000000]
[6116,"法定福利費","2017-08-01",1170000]
[6117,"福利厚生費","2017-08-01",226000]
[6122,"顧問報酬","2017-08-01",300000]
[6212,"消耗品費","2017-08-01",252000]
[6213,"賃借料","2017-08-01",1029600]
[6216,"修繕維持費","2017-08-01",482000]
[6218,"減価償却費","2017-08-01",290000]
[6221,"旅費交通費","2017-08-01",465000]
[6222,"通信費","2017-08-01",43000]
[6223,"会議費","2017-08-01",35400]
[6224,"水道光熱費","2017-08-01",45000]
[6225,"支払手数料","2017-08-01",200000]
[6226,"新聞図書費","2017-08-01",9700]
[6227,"銀行手数料","2017-08-01",5000]
[6229,"接待交際費","2017-08-01",50000]
[6230,"諸会費","2017-08-01",60000]
[6233,"運送費","2017-08-01",15000]
[7000,"営業利益","2017-08-01",5907300]
[8000,"経常利益","2017-08-01",5907300]
[4111,"売上高","2017-09-01",50000000]
[5421,"給与(原)","2017-09-01",18000000]
[5425,"法定福利費(原)","2017-09-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-09-01",1500000]
[5452,"保険料(原)","2017-09-01",20000]
[5455,"旅費交通費(原)","2017-09-01",6650000]
[5456,"通信費(原)","2017-09-01",300000]
[5458,"消耗品費(原)","2017-09-01",250000]
[5459,"運送費(原)","2017-09-01",40000]
[5460,"会議費(原)","2017-09-01",85000]
[5461,"書籍代(原)","2017-09-01",50000]
[5700,"売上原価","2017-09-01",29415000]
[6000,"売上総利益","2017-09-01",20585000]
[6111,"役員報酬","2017-09-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-09-01",9000000]
[6116,"法定福利費","2017-09-01",1170000]
[6117,"福利厚生費","2017-09-01",268000]
[6122,"顧問報酬","2017-09-01",300000]
[6212,"消耗品費","2017-09-01",252000]
[6213,"賃借料","2017-09-01",1029600]
[6216,"修繕維持費","2017-09-01",882000]
[6217,"租税公課","2017-09-01",50000]
[6218,"減価償却費","2017-09-01",290000]
[6221,"旅費交通費","2017-09-01",465000]
[6222,"通信費","2017-09-01",43000]
[6223,"会議費","2017-09-01",35400]
[6224,"水道光熱費","2017-09-01",45000]
[6225,"支払手数料","2017-09-01",300000]
[6226,"新聞図書費","2017-09-01",14700]
[6227,"銀行手数料","2017-09-01",5000]
[6229,"接待交際費","2017-09-01",50000]
[6230,"諸会費","2017-09-01",20000]
[6233,"運送費","2017-09-01",15000]
[7000,"営業利益","2017-09-01",5350300]
[8000,"経常利益","2017-09-01",5350300]
[4111,"売上高","2017-10-01",50000000]
[5421,"給与(原)","2017-10-01",18000000]
[5425,"法定福利費(原)","2017-10-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-10-01",1500000]
[5452,"保険料(原)","2017-10-01",20000]
[5455,"旅費交通費(原)","2017-10-01",7500000]
[5456,"通信費(原)","2017-10-01",300000]
[5458,"消耗品費(原)","2017-10-01",250000]
[5459,"運送費(原)","2017-10-01",40000]
[5460,"会議費(原)","2017-10-01",85000]
[5461,"書籍代(原)","2017-10-01",50000]
[5700,"売上原価","2017-10-01",30265000]
[6000,"売上総利益","2017-10-01",19735000]
[6111,"役員報酬","2017-10-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-10-01",9000000]
[6116,"法定福利費","2017-10-01",1170000]
[6117,"福利厚生費","2017-10-01",226000]
[6122,"顧問報酬","2017-10-01",300000]
[6212,"消耗品費","2017-10-01",377000]
[6213,"賃借料","2017-10-01",1029600]
[6216,"修繕維持費","2017-10-01",482000]
[6218,"減価償却費","2017-10-01",290000]
[6221,"旅費交通費","2017-10-01",450000]
[6222,"通信費","2017-10-01",43000]
[6223,"会議費","2017-10-01",35400]
[6224,"水道光熱費","2017-10-01",45000]
[6225,"支払手数料","2017-10-01",200000]
[6226,"新聞図書費","2017-10-01",9700]
[6227,"銀行手数料","2017-10-01",5000]
[6228,"販促・広告費","2017-10-01",135000]
[6229,"接待交際費","2017-10-01",50000]
[6230,"諸会費","2017-10-01",60000]
[6233,"運送費","2017-10-01",15000]
[6234,"教育･トレーニング費 ","2017-10-01",150000]
[6235,"紹介手数料","2017-10-01",630000]
[7000,"営業利益","2017-10-01",4032300]
[8000,"経常利益","2017-10-01",4032300]
[4111,"売上高","2017-11-01",50000000]
[5421,"給与(原)","2017-11-01",18000000]
[5425,"法定福利費(原)","2017-11-01",2520000.0000000005]
[5429,"外注委託費(原)","2017-11-01",1500000]
[5452,"保険料(原)","2017-11-01",20000]
[5455,"旅費交通費(原)","2017-11-01",6950000]
[5456,"通信費(原)","2017-11-01",300000]
[5458,"消耗品費(原)","2017-11-01",250000]
[5459,"運送費(原)","2017-11-01",40000]
[5460,"会議費(原)","2017-11-01",85000]
[5461,"書籍代(原)","2017-11-01",50000]
[5700,"売上原価","2017-11-01",29715000]
[6000,"売上総利益","2017-11-01",20285000]
[6111,"役員報酬","2017-11-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-11-01",9000000]
[6116,"法定福利費","2017-11-01",1170000]
[6117,"福利厚生費","2017-11-01",226000]
[6122,"顧問報酬","2017-11-01",300000]
[6212,"消耗品費","2017-11-01",252000]
[6213,"賃借料","2017-11-01",1029600]
[6216,"修繕維持費","2017-11-01",482000]
[6218,"減価償却費","2017-11-01",290000]
[6221,"旅費交通費","2017-11-01",450000]
[6222,"通信費","2017-11-01",43000]
[6223,"会議費","2017-11-01",35400]
[6224,"水道光熱費","2017-11-01",45000]
[6225,"支払手数料","2017-11-01",200000]
[6226,"新聞図書費","2017-11-01",9700]
[6227,"銀行手数料","2017-11-01",5000]
[6229,"接待交際費","2017-11-01",50000]
[6233,"運送費","2017-11-01",15000]
[7000,"営業利益","2017-11-01",5682300]
[8000,"経常利益","2017-11-01",5682300]
[4111,"売上高","2017-12-01",40000000]
[5421,"給与(原)","2017-12-01",18000000]
[5425,"法定福利費(原)","2017-12-01",2520000.0000000005]
[5452,"保険料(原)","2017-12-01",20000]
[5455,"旅費交通費(原)","2017-12-01",6350000]
[5456,"通信費(原)","2017-12-01",300000]
[5458,"消耗品費(原)","2017-12-01",250000]
[5459,"運送費(原)","2017-12-01",40000]
[5460,"会議費(原)","2017-12-01",85000]
[5461,"書籍代(原)","2017-12-01",50000]
[5700,"売上原価","2017-12-01",27615000]
[6000,"売上総利益","2017-12-01",12385000]
[6111,"役員報酬","2017-12-01",1000000]
[6112,"給与手当(役員報酬除く）","2017-12-01",9000000]
[6116,"法定福利費","2017-12-01",1170000]
[6117,"福利厚生費","2017-12-01",426000]
[6122,"顧問報酬","2017-12-01",300000]
[6212,"消耗品費","2017-12-01",252000]
[6213,"賃借料","2017-12-01",1029600]
[6216,"修繕維持費","2017-12-01",782000]
[6218,"減価償却費","2017-12-01",290000]
[6221,"旅費交通費","2017-12-01",450000]
[6222,"通信費","2017-12-01",43000]
[6223,"会議費","2017-12-01",35400]
[6224,"水道光熱費","2017-12-01",45000]
[6225,"支払手数料","2017-12-01",300000]
[6226,"新聞図書費","2017-12-01",9700]
[6227,"銀行手数料","2017-12-01",5000]
[6229,"接待交際費","2017-12-01",50000]
[6233,"運送費","2017-12-01",15000]
[7000,"営業利益","2017-12-01",-2817700]
[8000,"経常利益","2017-12-01",-2817700]
[4111,"売上高","2018-01-01",50000000]
[5421,"給与(原)","2018-01-01",18000000]
[5425,"法定福利費(原)","2018-01-01",2520000.0000000005]
[5452,"保険料(原)","2018-01-01",20000]
[5455,"旅費交通費(原)","2018-01-01",6920000]
[5456,"通信費(原)","2018-01-01",300000]
[5458,"消耗品費(原)","2018-01-01",250000]
[5459,"運送費(原)","2018-01-01",40000]
[5460,"会議費(原)","2018-01-01",85000]
[5461,"書籍代(原)","2018-01-01",50000]
[5700,"売上原価","2018-01-01",28185000]
[6000,"売上総利益","2018-01-01",21815000]
[6111,"役員報酬","2018-01-01",1000000]
[6112,"給与手当(役員報酬除く）","2018-01-01",9000000]
[6116,"法定福利費","2018-01-01",1170000]
[6117,"福利厚生費","2018-01-01",268000]
[6122,"顧問報酬","2018-01-01",300000]
[6212,"消耗品費","2018-01-01",252000]
[6213,"賃借料","2018-01-01",1029600]
[6215,"保険料","2018-01-01",40000]
[6216,"修繕維持費","2018-01-01",482000]
[6218,"減価償却費","2018-01-01",290000]
[6221,"旅費交通費","2018-01-01",450000]
[6222,"通信費","2018-01-01",43000]
[6223,"会議費","2018-01-01",35400]
[6224,"水道光熱費","2018-01-01",45000]
[6225,"支払手数料","2018-01-01",250000]
[6226,"新聞図書費","2018-01-01",9700]
[6227,"銀行手数料","2018-01-01",5000]
[6228,"販促・広告費","2018-01-01",500000]
[6229,"接待交際費","2018-01-01",50000]
[6231,"寄付金","2018-01-01",30000]
[6233,"運送費","2018-01-01",15000]
[7000,"営業利益","2018-01-01",6550300]
[8000,"経常利益","2018-01-01",6550300]
[4111,"売上高","2018-02-01",50000000]
[5421,"給与(原)","2018-02-01",18000000]
[5425,"法定福利費(原)","2018-02-01",2520000.0000000005]
[5452,"保険料(原)","2018-02-01",20000]
[5455,"旅費交通費(原)","2018-02-01",6320000]
[5456,"通信費(原)","2018-02-01",300000]
[5458,"消耗品費(原)","2018-02-01",250000]
[5459,"運送費(原)","2018-02-01",40000]
[5460,"会議費(原)","2018-02-01",85000]
[5461,"書籍代(原)","2018-02-01",50000]
[5700,"売上原価","2018-02-01",27585000]
[6000,"売上総利益","2018-02-01",22415000]
[6111,"役員報酬","2018-02-01",1000000]
[6112,"給与手当(役員報酬除く）","2018-02-01",9000000]
[6116,"法定福利費","2018-02-01",1170000]
[6117,"福利厚生費","2018-02-01",226000]
[6122,"顧問報酬","2018-02-01",300000]
[6212,"消耗品費","2018-02-01",252000]
[6213,"賃借料","2018-02-01",1029600]
[6216,"修繕維持費","2018-02-01",482000]
[6218,"減価償却費","2018-02-01",290000]
[6221,"旅費交通費","2018-02-01",450000]
[6222,"通信費","2018-02-01",43000]
[6223,"会議費","2018-02-01",35400]
[6224,"水道光熱費","2018-02-01",45000]
[6225,"支払手数料","2018-02-01",200000]
[6226,"新聞図書費","2018-02-01",9700]
[6227,"銀行手数料","2018-02-01",5000]
[6229,"接待交際費","2018-02-01",50000]
[6233,"運送費","2018-02-01",15000]
[7000,"営業利益","2018-02-01",7812300]
[8000,"経常利益","2018-02-01",7812300]
[4111,"売上高","2018-03-01",60000000]
[5421,"給与(原)","2018-03-01",23000000]
[5425,"法定福利費(原)","2018-03-01",3220000.0000000005]
[5452,"保険料(原)","2018-03-01",20000]
[5455,"旅費交通費(原)","2018-03-01",6720000]
[5456,"通信費(原)","2018-03-01",300000]
[5458,"消耗品費(原)","2018-03-01",550000]
[5459,"運送費(原)","2018-03-01",40000]
[5460,"会議費(原)","2018-03-01",85000]
[5461,"書籍代(原)","2018-03-01",50000]
[5700,"売上原価","2018-03-01",33985000]
[6000,"売上総利益","2018-03-01",26015000]
[6111,"役員報酬","2018-03-01",1000000]
[6112,"給与手当(役員報酬除く）","2018-03-01",9000000]
[6116,"法定福利費","2018-03-01",1170000]
[6117,"福利厚生費","2018-03-01",226000]
[6122,"顧問報酬","2018-03-01",300000]
[6212,"消耗品費","2018-03-01",252000]
[6213,"賃借料","2018-03-01",1029600]
[6216,"修繕維持費","2018-03-01",982000]
[6217,"租税公課","2018-03-01",50000]
[6218,"減価償却費","2018-03-01",290000]
[6219,"貸倒引当金繰入","2018-03-01",200000]
[6221,"旅費交通費","2018-03-01",450000]
[6222,"通信費","2018-03-01",43000]
[6223,"会議費","2018-03-01",35400]
[6224,"水道光熱費","2018-03-01",45000]
[6225,"支払手数料","2018-03-01",300000]
[6226,"新聞図書費","2018-03-01",14700]
[6227,"銀行手数料","2018-03-01",5000]
[6229,"接待交際費","2018-03-01",50000]
[6230,"諸会費","2018-03-01",60000]
[6233,"運送費","2018-03-01",15000]
[6234,"教育･トレーニング費 ","2018-03-01",500000]
[6235,"紹介手数料","2018-03-01",630000]
[7000,"営業利益","2018-03-01",9367300]
[8000,"経常利益","2018-03-01",9367300]

{"sheet":"参考ピボットテーブル","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
["合計 / 金額",null,"列ラベル"]
["行ラベル","科目名称","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","(空白)","総計"]
[4111,"売上高",50000000,50000000,45000000,50000000,50000000,50000000,50000000,50000000,40000000,50000000,50000000,60000000,null,595000000]
[5421,"給与(原)",18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,18000000,23000000,null,221000000]
[5425,"法定福利費(原)",2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,2520000.0000000005,3220000.0000000005,null,30940000.000000004]
[5429,"外注委託費(原)",1500000,1500000,1500000,1500000,1500000,1500000,1500000,1500000,null,null,null,null,null,12000000]
[5452,"保険料(原)",20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,null,240000]
[5455,"旅費交通費(原)",6020000,6220000,11220000,7050000,6650000,6650000,7500000,6950000,6350000,6920000,6320000,6720000,null,84570000]
[5456,"通信費(原)",300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,null,3600000]
[5458,"消耗品費(原)",250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,550000,null,3300000]
[5459,"運送費(原)",40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,40000,null,480000]
[5460,"会議費(原)",85000,85000,85000,85000,85000,85000,85000,85000,85000,85000,85000,85000,null,1020000]
[5461,"書籍代(原)",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,null,600000]
[5700,"売上原価",28785000,28985000,33985000,29815000,29415000,29415000,30265000,29715000,27615000,28185000,27585000,33985000,null,357750000]
[6000,"売上総利益",21215000,21015000,11015000,20185000,20585000,20585000,19735000,20285000,12385000,21815000,22415000,26015000,null,237250000]
[6111,"役員報酬",1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,null,12000000]
[6112,"給与手当(役員報酬除く）",9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,9000000,null,108000000]
[6116,"法定福利費",1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,1170000,null,14040000]
[6117,"福利厚生費",226000,226000,226000,226000,226000,268000,226000,226000,426000,268000,226000,226000,null,2996000]
[6122,"顧問報酬",300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,null,3600000]
[6212,"消耗品費",377000,252000,252000,252000,252000,252000,377000,252000,252000,252000,252000,252000,null,3274000]
[6213,"賃借料",1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,1029600,null,12355200]
[6215,"保険料",null,null,null,1400000,null,null,null,null,null,40000,null,null,null,1440000]
[6216,"修繕維持費",482000,532000,842000,482000,482000,882000,482000,482000,782000,482000,482000,982000,null,7394000]
[6217,"租税公課",null,null,600000,15000,null,50000,null,null,null,null,null,50000,null,715000]
[6218,"減価償却費",290000,290000,290000,290000,290000,290000,290000,290000,290000,290000,290000,290000,null,3480000]
[6219,"貸倒引当金繰入",null,null,null,null,null,null,null,null,null,null,null,200000,null,200000]
[6221,"旅費交通費",735000,735000,465000,465000,465000,465000,450000,450000,450000,450000,450000,450000,null,6030000]
[6222,"通信費",43000,43000,43000,43000,43000,43000,43000,43000,43000,43000,43000,43000,null,516000]
[6223,"会議費",35400,35400,35400,35400,35400,35400,35400,35400,35400,35400,35400,35400,null,424800]
[6224,"水道光熱費",45000,45000,45000,45000,45000,45000,45000,45000,45000,45000,45000,45000,null,540000]
[6225,"支払手数料",250000,500000,260000,250000,200000,300000,200000,200000,300000,250000,200000,300000,null,3210000]
[6226,"新聞図書費",9700,9700,9700,9700,9700,14700,9700,9700,9700,9700,9700,14700,null,126400]
[6227,"銀行手数料",5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,null,60000]
[6228,"販促・広告費",135000,null,null,500000,null,null,135000,null,null,500000,null,null,null,1270000]
[6229,"接待交際費",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,null,600000]
[6230,"諸会費",null,null,null,null,60000,20000,60000,null,null,null,null,60000,null,200000]
[6231,"寄付金",null,null,null,30000,null,null,null,null,null,30000,null,null,null,60000]
[6233,"運送費",15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,null,180000]
[6234,"教育･トレーニング費 ",null,null,null,null,null,null,150000,null,null,null,null,500000,null,650000]
[6235,"紹介手数料",null,null,null,null,null,null,630000,null,null,null,null,630000,null,1260000]
[7000,"営業利益",6017300,5777300,-4622700,3572300,5907300,5350300,4032300,5682300,-2817700,6550300,7812300,9367300,null,52628600]
[8000,"経常利益",6017300,5777300,-4622700,3572300,5907300,5350300,4032300,5682300,-2817700,6550300,7812300,9367300,null,52628600]
["(空白)","(空白)"]
["総計",null,156017300,155777300,130377300,153572300,155907300,155350300,154032300,155682300,117182300,156550300,157812300,189367300,null,1837628600]