{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["製品メトリック ダッシュボード","製品データ"],"not_rendered":{"charts":4,"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":"製品メトリック ダッシュボード","index":0,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,0,79,14],[0,0,0,8],[1,0,1,13],[27,0,27,5],[27,8,27,13],[47,0,47,13]]}
["製品メトリック ダッシュボード"]
["製品収入"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["収入内訳",null,null,null,null,null,null,null,"タイム トゥ マーケット"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["勝敗比"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Smartsheet のダッシュボード機能「Sight」の詳細はこちら"]

{"sheet":"製品データ","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9],[4,0,4,1],[17,0,17,9],[9,0,9,1],[10,0,10,1],[1,0,1,13],[2,0,2,1],[3,0,3,1],[12,11,12,13],[12,0,12,9],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1]]}
["製品メトリック データ"]
["製品収入"]
["製品名",null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月"]
["アイテム 1",null,4721600,24471400,24654900,23506200,16288100,9652800,2923500,2593400,23339700,7847900,18479900,24821500]
["アイテム 2",null,1919300,3208600,9311700,4586200,6285300,5551300,2294500,1508400,4534700,5773600,2014200,4528400]
["アイテム 3",null,22200600,18000900,9999800,21503000,19526200,27226000,12812300,16395000,21391400,18019100,11189000,26049500]
["アイテム 4",null,3946900,5866100,6061200,9945600,3906200,4268900,5319700,2302600,3316500,8834200,849200,3479800]
["アイテム 5",null,23477000,4660700,23231300,25597900,28227900,8367700,25459300,5046100,23968500,10642500,22953500,20068200]
["アイテム 6",null,20149400,18691100,20351500,23444500,18189400,16017500,26634000,17505500,9446900,20977900,27554100,26876100]
["アイテム 7",null,27411000,14901200,26077400,10779400,3572100,22542500,6208500,13087400,19469500,1944700,3188900,3193000]
["アイテム 8",null,8217100,20404700,4471000,10021700,11539500,14575100,1578600,3794400,3841500,7039500,2504000,6750800]
[]
["収入内訳",null,null,null,null,null,null,null,null,null,null,"タイム トゥ マーケット"]
[null,"アイテム 1","アイテム 2","アイテム 3","アイテム 4","アイテム 5","アイテム 6","アイテム 7","アイテム 8","すべて",null,null,"新規","既存"]
["年間収入",{"$f":"SUM(C4:N4)","v":183300900},{"$f":"SUM(C5:N5)","v":51516200},{"$f":"SUM(C6:N6)","v":224312800},{"$f":"SUM(C7:N7)","v":58096900},{"$f":"SUM(C8:N8)","v":221700600},{"$f":"SUM(C9:N9)","v":245837900},{"$f":"SUM(C10:N10)","v":152375600},{"$f":"SUM(C11:N11)","v":94737900},{"$f":"SUM(B15:I15)","v":1231878800},null,"日数",57.6,22.4]
["パーセント",{"$f":"B15/J15","v":0.14879783628064708},{"$f":"C15/J15","v":4.1819211435410689E-2},{"$f":"D15/J15","v":0.18208999132057471},{"$f":"E15/J15","v":4.716121423633559E-2},{"$f":"F15/J15","v":0.17996949050507241},{"$f":"G15/J15","v":0.19956338237170734},{"$f":"H15/J15","v":0.12369366207130117},{"$f":"I15/J15","v":7.6905211778950988E-2},{"$f":"SUM(B16:I16)","v":1},null,"目標",55,20]
[]
["勝敗比"]
[null,"アイテム 1","アイテム 2","アイテム 3","アイテム 4","アイテム 5","アイテム 6","アイテム 7","アイテム 8","すべて"]
["勝率",0.73,0.75,0.91,0.85,0.89,0.82,0.28000000000000003,0.84,{"$f":"SUM(B20:I20)/8","v":0.75875000000000004}]
["敗率",{"$f":"1-B20","v":0.27},{"$f":"1-C20","v":0.25},8.9999999999999969E-2,0.15000000000000002,0.10999999999999999,0.18000000000000005,0.72,0.16000000000000003,{"$f":"SUM(B21:I21)/8","v":0.24125000000000002}]