{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KPI ダッシュボード","KPI データ"],"not_rendered":{"charts":6,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"KPI ダッシュボード","index":0,"n_rows":81,"n_cols":1,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,8],[80,0,86,21]]}
["KPI ダッシュボード"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Smartsheet のダッシュボード機能「Sight」の詳細はこちら"]

{"sheet":"KPI データ","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,10,1,11],[0,0,0,9],[1,5,1,6],[16,2,16,4],[1,0,1,1],[1,7,1,9],[1,2,1,4]]}
["KPI データ"]
["製品",null,"予算",null,null,"支出純額",null,"収入",null,null,"利益率"]
["番号","名前","目標","実績","残高","追加分","合計","目標","実績","残高","粗利益","純利益"]
[1,"アイテム 1",12986800,25651300,{"$f":"(C4-D4)","v":-12664500},2428300,{"$f":"F4+D4","v":28079600},110091600,107335700,{"$f":"I4-H4","v":-2755900},{"$f":"(I4-D4)/I4","v":0.76101800239808381},{"$f":"(I4-G4)/I4","v":0.73839458819386283}]
[2,"アイテム 2",23760500,8561800,{"$f":"(C5-D5)","v":15198700},1059800,{"$f":"F5+D5","v":9621600},21553400,87816200,{"$f":"I5-H5","v":66262800},{"$f":"(I5-D5)/I5","v":0.90250318278404218},{"$f":"(I5-G5)/I5","v":0.89043479449122143}]
[3,"アイテム 3",24942000,26425900,-1483900,1052700,27478600,82071900,119378400,37306500,0.77863750896309547,0.76981933080021181]
[4,"アイテム 4",22653800,29336800,-6683000,2059200,31396000,62024200,42034500,-19989700,0.30207805493106854,0.25308972391725842]
[5,"アイテム 5",10947800,17400300,-6452500,2039200,19439500,82117700,117581100,35463400,0.85201448191928808,0.83467155860933429]
[6,"アイテム 6",12916000,24956700,-12040700,1449000,26405700,90126300,101576600,11450300,0.75430660211111611,0.74004150562235793]
[7,"アイテム 7",21378500,7925500,13453000,1558200,9483700,87852800,73375100,-14477700,0.89198651858736822,0.87075043168595345]
[8,"アイテム 8",12828300,12230000,598300,2160600,14390600,83838000,95598300,11760300,0.87206885478089047,0.84946803447341634]
[9,"アイテム 9",17543800,11994300,5549500,2066700,14061000,107315700,92409500,-14906200,0.87020490317553933,0.84784031944767579]
[10,"アイテム 10",25375500,25518700,-143200,1234700,26753400,114104700,106107400,-7997300,0.75950122234641504,0.7478648991493525]
[null,null,{"$f":"SUM(C4:C13)","v":185333000},{"$f":"SUM(D4:D13)","v":190001300},-4668300,{"$f":"SUM(F4:F13)","v":17108400},{"$f":"SUM(G4:G13)","v":207109700},841096300,943212800,102116500,{"$f":"SUM(K4:K13)/10","v":0.77443193319969061},{"$f":"SUM(L4:L13)/10","v":0.75423751863906441}]
[]
[]
[null,null,"負債資本比率"]
[null,null,"年度","負債","資本"]
[null,null,2007,361343900,329320200]
[null,null,2008,350877600,344185400]
[null,null,2009,371945700,353184400]
[null,null,2010,331021200,335405100]
[null,null,2011,394520200,347615500]
[null,null,2012,393815200,353846800]
[null,null,2013,373370600,372703700]
[null,null,2014,352669800,342540500]
[null,null,2015,363297100,373404100]
[null,null,2016,320648700,367707400]