{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["はじめに","変更履歴","設定シート","リソースグループシート","リソース料金シート","(参考)画面イメージ","入力リスト"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":0,"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":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["<リソースについて>"]
["設定シートにてリソースグループ設定の項目を使う場合は、リソースグループシートとリソース料金シートにて詳細を記入してください"]
[]
["＜商品概念図＞"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["＜商品作成フロー＞"]

{"sheet":"変更履歴","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,2,21,2],[16,1,21,1],[17,3,18,3],[4,2,5,2],[11,1,12,1],[14,1,15,1],[14,2,15,2]]}
["<変更履歴>"]
[]
[null,"Ver","更新日","更新シート","更新内容"]
[null,0.1,"2020-11-09","-","新規作成"]
[null,0.11,"2021-02-08","はじめに","[変更履歴]シートの新規作成"]
[null,null,null,"■記入例\n★設定シート","■商品設定に以下の項目を追加\n・製品カテゴリ\n・大量注文\n・製品画像\n・契約情報\n・依存関係有無\n・無料期間有無\n\n■含まれるサービス（★付き：サービス情報のヒアリングシートより転記）\n・料金設定有無の説明文を修正\n（変更前）※ありの場合、右記の項目はすべて記入すること\n（変更後）サービス単位/項目単位/SELECT項目かを記入\n          ※サービス単位/項目単位の場合、右記の項目はすべて記入すること\n\n■SELECT項目設定(料金)を追加\n"]
[null,0.12,"2021-02-16","■記入例\n★設定シート","■含まれるサービス（★付き：サービス情報のヒアリングシートより転記）\n・料金設定有無の説明文を修正\n（変更前）サービス単位/項目単位/SELECT項目かを記入\n          ※サービス単位/項目単位の場合、右記の項目はすべて記入すること\n（変更後）サービス単位/特性単位/SELECT項目かを記入\n          ※サービス単位/特性単位の場合、右記の項目はすべて記入すること\n・料金設定有無の入力形式を変更\n　(変更前)自由入力\n　(変更後)プルダウン\n・料金設定有無の選択によって入力不要セルをグレーアウトする機能を追加\n　「SELECT項目」選択時にF列～H列,J列～L列をグレーアウト"]
[null,"1.0","2021-03-05","-","1.0版化"]
[null,"1.1","2021-03-05","■記入例\n★設定シート","■商品設定に以下の項目を追加\n・商品属性\n\n■商品属性をシート下部に追加"]
[null,"1.1","2021-03-24","■記入例\n★設定シート","セルの色で必須項目と任意項目を判別できるように変更\n\n■商品設定(料金)に以下の項目を追加\n・税率の設定項目を追加\n・適用開始日\n・適用終了日\n\n■含まれるサービスに以下の項目を追加\n・税率\n\n■SELECT項目設定(料金)に以下を追加\n・税率\n・オペレータによる請求書テキストの変更可否\n・オペレータによる料金の変更可否"]
[null,"1.1.1","2021-04-12","■記入例\n★設定シート","卸/小売記入セルを追加\n\nサプライヤ企業名記入セルを追加"]
[null,1.2,"2021-06-28",null,"見た目を大幅に変更"]
[null,null,"2021-07-16","設定シート","ヘッダ名「契約情報」を「契約条件」に変更\n\n「キー」に関するヘッダ名を「○○キー情報」に変更\n\n「適用開始日」に関するヘッダ名を「○○適用開始日」に変更\n\n「適用終了日」に関するヘッダ名を「○○適用終了日」に変更\n\n「説明」に関するヘッダ名を「○○説明」に変更\n\n「商品属性」が「あり」以外の場合は、「商品属性詳細」がグレーアウトされるように変更"]
[null,"1.2.1","2021-09-13","はじめにシート","<商品概念図>を追加\n\n<商品設定フロー>を追加"]
[null,"1.2.1","2021-10-26","設定シート","リソースグループ設定を追加"]
[null,null,null,"-","リソースグループシートを追加\nリソース料金シートを追加"]
[null,"1.2.2","2022-07-25","全体","リンクボタン追加に伴い、マクロファイルへ変更"]
[null,null,null,"設定シート","補足資料へのリンクボタンを追加"]
[null,null,null,null,"（参考）画面イメージへのリンクを追加"]
[null,null,null,"リソースグループシート","補足資料へのリンクボタンを追加"]
[null,null,null,"リソース料金シート","補足資料へのリンクボタンを追加"]
[null,null,null,"（参考）画面イメージ","設定シートへのリンクを追加"]
[null,"1.2.3","2022-12-09","設定シート","料金設定(割引き)の「対象期間」に「請求期間」を追加"]
[null,"1.3.0","2025-12-08","(参考)画面イメージ","新UIの画像を追加、旧UIの一部画像を最新のものに差し替え"]

{"sheet":"設定シート","index":2,"n_rows":152,"n_cols":32,"rows_kept":152,"cut":false,"hidden":false,"merged":[[132,3,132,9],[132,10,132,11],[132,15,133,15],[132,16,133,16],[132,17,133,17],[132,13,133,13],[132,14,133,14],[132,12,133,12],[132,29,132,31],[123,22,124,22],[123,23,123,28],[123,29,123,31],[132,18,133,18],[132,19,133,19],[132,20,133,20],[132,21,133,21],[132,22,133,22],[123,5,124,5],[123,6,123,12],[123,13,123,19],[123,20,124,20],[123,21,124,21],[132,0,133,0],[132,2,133,2],[132,1,133,1],[114,29,114,31],[123,0,123,3],[114,0,114,3],[114,23,114,28],[114,4,115,4],[114,5,115,5],[114,6,114,12],[114,13,114,19],[114,20,115,20],[114,21,115,21],[114,22,115,22],[123,4,124,4],[132,23,132,28],[105,0,105,3],[105,20,105,25],[105,26,105,28],[105,4,106,4],[105,5,106,5],[105,6,105,12],[105,13,105,16],[105,17,106,17],[105,18,106,18],[105,19,106,19],[53,0,54,0],[53,3,53,9],[53,23,53,28],[53,29,53,31],[53,16,54,16],[53,15,54,15],[53,17,54,17],[53,18,54,18],[53,19,54,19],[53,20,54,20],[53,21,54,21],[53,1,54,1],[53,2,54,2],[53,10,53,11],[53,12,54,12],[53,22,54,22],[44,0,44,3],[35,29,35,31],[44,6,44,12],[44,23,44,28],[44,29,44,31],[35,4,36,4],[44,4,45,4],[35,5,36,5],[35,21,36,21],[35,20,36,20],[35,22,36,22],[35,13,35,19],[44,5,45,5],[26,26,26,28],[35,23,35,28],[53,13,54,13],[53,14,54,14],[26,13,26,16],[26,19,27,19],[26,18,27,18],[26,17,27,17],[44,22,45,22],[44,13,44,19],[44,20,45,20],[44,21,45,21],[1,3,1,5],[26,0,26,3],[35,0,35,3],[26,6,26,12],[26,20,26,25],[26,4,27,4],[26,5,27,5],[35,6,35,12]]}
[]
["商品区分設定",{"$f":"HYPERLINK(\"#A\"&ROW(A79),\"記入例はこちら\")","v":"記入例はこちら"},null,"色の凡例"]
["卸/小売","サプライヤ企業名",null,"必須","任意","入力不要","■補足資料■はこちら↓"]
["小売商品"]
[]
["商品設定"]
["商品キー情報","商品名(請求書表示名)","内部で使用する名称","商品説明","商品適用開始日"]
[]
[]
["割り当てチャネル","製品カテゴリ","大量注文","製品画像","契約条件","依存関係有無\n※ある場合は、仕様を記入","無料期間有無\n※ありの場合は、\n内容を記入",{"$f":"\"商品属性\n※ありの場合は、\"&ROW($A70)&\"行目の\n「商品属性詳細」に内容を記入\"","v":"商品属性\n※ありの場合は、70行目の\n「商品属性詳細」に内容を記入"}]
[]
[]
["含まれるサービス（サービス情報のヒアリングシートより転記）"]
["サービスキー情報","サービス表示名"]
[]
[]
[]
[]
["料金設定"]
["種類","補足\n例：割引:初月無料、\n　　  分割:毎月/6回払い　etc","料金(税抜き・円)","税率","オペレータによる料金の変更可否\n※画面イメージあり"]
[]
[]
[]
[]
[]
["料金設定(一括払い)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位",null,null,null,"補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","卸先の販売単位での請求","機能詳細",null,null,null,null,null,null,"料金",null,null,null,"料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
["料金単位","サービス名","特性名","SELECT項目",null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否\n※画面イメージはこちら↓","料金(税抜き・円)","税率","オペレータによる料金の変更可否\n※画面イメージはこちら↓","ポイント還元",null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能\n※画面イメージはこちら↓","上限数","サービス提供後に項目の\n追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
[]
[]
[]
[]
[]
[]
["料金設定(定期払い)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位",null,null,null,"補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","卸先の販売単位での請求","機能詳細",null,null,null,null,null,null,"料金",null,null,null,null,null,null,"料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
["料金単位","サービス名","特性名","SELECT項目",null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否\n※画面イメージはこちら↓","料金(税抜き・円)","税率","請求周期","オペレータによる\n料金の変更可否\n※画面イメージはこちら↓","前払い/後払い","秒割/日割\n※設定しない場合は「‐」","秒割/日割の契機",null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能\n※画面イメージはこちら↓","上限数","サービス提供後に項目の\n追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
[]
[]
[]
[]
[]
[]
["料金設定(分割払い)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位",null,null,null,"補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","卸先の販売単位での請求","機能詳細",null,null,null,null,null,null,"料金",null,null,null,null,null,null,"料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
["料金単位","サービス名","特性名","SELECT項目",null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否\n※画面イメージはこちら↓","料金(税抜き・円)","税率","請求周期","支払回数","初回支払回数","オペレータによる料金および\n支払回数の変更\n※画面イメージはこちら↓","廃止時に残りの\n分割払いをすべて支払う",null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能\n※画面イメージはこちら↓","上限数","サービス提供後に項目の追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
[]
[]
[]
[]
[]
[]
["料金設定(割引き)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位","割引形式","補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","機能詳細",null,null,null,null,null,null,"対象期間",null,"割引頻度","計算に使用される情報","税率","上限","割引金額/率（％）","オペレータによる料金の変更可否\n※画面イメージはこちら↓","計算対象","適用対象","料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
[null,null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否\n※画面イメージはこちら↓","日数/月数/請求期間数\n※数字で入力してください","ヶ月/日/請求期間",null,null,null,null,null,null,null,null,null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能\n※画面イメージはこちら↓","上限数","サービス提供後に項目の\n追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
["商品単位"]
["商品単位"]
["商品単位"]
["商品単位"]
[]
[]
["リソースグループ設定　※複数ある場合、下記の内容をコピーして利用"]
["商品内でのリソースグループ表示名","商品内でのリソースグループキー情報","商品に含めるリソースグループ","料金分類","リソースグループ適用開始日\n※設定しない場合は商品を作成した日付","リソースグループ適用終了日","リソースグループ表示順","この機能の必須・任意","初期表示","複数の設定が可能\n※画面イメージはこちら↓","下限","上限","サービス提供後に項目の\n追加・削除可否"]
[]
[]
[]
[]
[]
[]
["商品属性詳細"]
["商品属性キー情報","設定値","商品属性適用開始日\n※設定しない場合は\n商品を作成した日付","商品属性適用終了日"]
[]
[]
[]
[]
[]
[]
[]
["記入例"]
["商品区分設定",{"$f":"HYPERLINK(\"#A\"&ROW(A2),\"シート入力に戻る\")","v":"シート入力に戻る"}]
["卸/小売","サプライヤ企業名"]
["小売商品"]
[]
["商品設定"]
["商品キー情報","商品名(請求書表示名)","内部で使用する名称","商品説明","商品適用開始日"]
["test_retail_offer","ex社防犯システム","テスト小売商品","テスト用の小売商品です","2020-11-13"]
[]
["割り当てチャネル","製品カテゴリ","大量注文","製品画像","契約条件","依存関係有無\n※ある場合は、仕様を記入","無料期間有無\n※ありの場合は、\n内容を記入",{"$f":"\"商品属性\n※ありの場合は、\"&ROW($A149)&\"行目の\n「商品属性詳細」に内容を記入\"","v":"商品属性\n※ありの場合は、149行目の\n「商品属性詳細」に内容を記入"}]
["channel1, channel2","なし","可","あり","なし","なし","あり（初月無料）","あり"]
[]
["含まれるサービス（サービス情報の設定補助シートより転記）"]
["サービスキー情報","サービス表示名"]
["CONTRACT_SERVICE","契約サービス"]
[]
[]
[]
["料金設定"]
["種類","補足\n例：割引:初月無料、\n　　  分割:毎月/6回払い　etc","料金(税抜き・円)","税率","オペレータによる料金の変更可否\n※画面イメージあり"]
["一括",null,100000,0.1,"不可"]
["定期払い（1ヶ月毎）",null,10000,0.1,"不可"]
["分割","毎月/12回払い",200000,0.1,"不可"]
["割引","初月無料"]
[]
[]
["料金設定(一括払い)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位",null,null,null,"補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","卸先の販売単位での請求","機能詳細",null,null,null,null,null,null,"料金",null,null,null,"料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
["料金単位","サービス名","特性名","SELECT項目",null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否","料金(税抜き・円)","税率","オペレータによる料金の変更可否","ポイント還元",null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能","上限数","サービス提供後に項目の\n追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
["商品単位",null,null,null,null,null,"初期費用","onetimePayment",null,"初期費用","OP0001","OP0001","不可",100000,0.1,"不可","なし",null,null,0,"必須",null,"不可",null,"不可","不可","-","〇","-"]
[]
[]
[]
[]
[]
["料金設定(定期払い)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位",null,null,null,"補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","卸先の販売単位での請求","機能詳細",null,null,null,null,null,null,"料金",null,null,null,null,null,null,"料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
["料金単位","サービス名","特性名","SELECT項目",null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否","料金(税抜き・円)","税率","請求周期","オペレータによる\n料金の変更可否","前払い/後払い","秒割/日割\n※設定しない場合は「‐」","秒割/日割の契機",null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能","上限数","サービス提供後に項目の\n追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
["商品単位",null,null,null,null,null,"定期料金（毎月）","regularPayment",null,"定期料金（毎月）","RP0001","RP0001","不可",10000,0.1,"1ヶ月毎","不可","前払い","日割り","開始時および終了時",null,null,1,"必須",null,"不可",null,"不可","不可","-","〇","-"]
[]
[]
[]
[]
[]
["料金設定(分割払い)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位",null,null,null,"補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","卸先の販売単位での請求","機能詳細",null,null,null,null,null,null,"料金",null,null,null,null,null,null,"料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
["料金単位","サービス名","特性名","SELECT項目",null,null,"表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否","料金(税抜き・円)","税率","請求周期","支払回数","初回支払回数","オペレータによる料金および\n支払回数の変更","廃止時に残りの\n分割払いをすべて支払う",null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能","上限数","サービス提供後に項目の追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
["商品単位",null,null,null,null,null,"本体料金（分割）","splitPayment",null,"本体料金（分割）","SP0001","SP0001","不可",200000,0.1,"1ヶ月毎",12,1,"可","支払う",null,null,2,"必須",null,"不可",null,"不可","不可","-","〇","-"]
[]
[]
[]
[]
[]
["料金設定(割引き)　※複数ある場合、下記の内容をコピーして利用"]
["料金単位","割引形式","補足\n設定者宛の補足事項はここに記入\n※画面上に入力欄はなし。","機能詳細",null,null,null,null,null,null,"対象期間",null,"割引頻度","計算に使用される情報","税率","上限","割引金額/率（％）","オペレータによる料金の変更可否","計算対象","適用対象","料金適用開始日\n※設定しない場合は\n商品を作成した日付","料金適用終了日","表示順","機能属性",null,null,null,null,null,"課金発生タイミング"]
[null,null,"補足\n設定者宛の補足事項がここに記入\n※画面上に入力欄はなし。","表示名","機能キー情報","料金説明","請求書内訳名","商品コード","GLコード","オペレータによる\n請求書内訳名の変更可否","日数/月数\n※数字で入力してください","ヶ月/日",null,null,null,null,null,null,null,null,null,null,null,"この機能の必須・任意","初期表示","複数の設定が可能","上限数","サービス提供後に項目の\n追加・削除可否","プロビ中の追加・削除可否","サービス提供開始時\n(一部)","サービス提供開始時\n(全て)","サービス廃止時\n(一部)"]
["商品単位","パーセント割引","初月無料","初月無料","firstMonthFree","初月無料","初月無料","FMF0001","FMF0001","不可",2,"ヶ月","1ヶ月毎","料金",0.1,"∞",100,"可","1MonthFree","1MonthFree",null,null,3,"必須",null,"不可",null,"不可","不可","-","〇","-"]
["商品単位"]
["商品単位"]
["商品単位"]
[]
[]
["リソースグループ設定　※複数ある場合、下記の内容をコピーして利用"]
["商品内でのリソースグループ表示名","商品内でのリソースグループキー情報","商品に含めるリソースグループ","料金分類","リソースグループ適用開始日\n※設定しない場合は商品を作成した日付","リソースグループ適用終了日","リソースグループ表示順","この機能の必須・任意","初期表示","複数の設定が可能","下限","上限","サービス提供後に項目の\n追加・削除可否"]
["モバイル1台購入","mobileOneBuy","モバイル","ONE_BUY",null,null,1,"任意","なし","不可",null,null,"不可"]
["モバイル2台購入","mobileTwoBuys","モバイル","TWO_BUYS",null,null,2,"任意","なし","可",2,2,"不可"]
["タブレットオプション","tabletOption","タブレット","TABLET_CHARGE",null,null,3,"任意","なし","不可",null,null,"不可"]
[]
[]
[]
["商品属性詳細"]
["商品属性キー情報","設定値","商品属性適用開始日\n※設定しない場合は\n商品を作成した日付","商品属性適用終了日"]
["ターゲットID",123456789,"2021-03-08"]
["配送区分","設置あり","2021-03-08"]

{"sheet":"リソースグループシート","index":3,"n_rows":66,"n_cols":25,"rows_kept":66,"cut":false,"hidden":false,"merged":[[58,0,58,4],[58,5,58,9],[57,0,57,4],[57,5,57,9],[9,10,9,14],[54,5,54,9],[55,5,55,9],[56,5,56,9],[53,0,53,4],[54,0,54,4],[55,0,55,4],[56,0,56,4],[50,0,50,4],[51,0,51,4],[9,15,9,19],[9,20,9,24],[10,0,10,4],[10,5,10,9],[10,10,10,14],[10,15,10,19],[10,20,10,24],[5,10,5,14],[5,15,5,19],[5,20,5,24],[6,10,6,14],[6,15,6,19],[6,20,6,24],[7,10,7,14],[7,15,7,19],[7,20,7,24],[6,5,6,9],[8,10,8,14],[8,15,8,19],[8,20,8,24],[2,0,2,4],[3,0,3,4],[53,5,53,9],[5,5,5,9],[8,5,8,9],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[7,5,7,9],[9,0,9,4],[9,5,9,9]]}
[]
["リソースグループ設定",null,{"$f":"HYPERLINK(\"#A\"&ROW(A50),\"記入例はこちら\")","v":"記入例はこちら"},null,null,null,"■補足資料■はこちら↓"]
["テナントキー情報"]
[]
[]
["リソースグループキー情報（1）",null,null,null,null,"リソースグループキー情報（2）",null,null,null,null,"リソースグループキー情報（3）",null,null,null,null,"リソースグループキー情報（4）",null,null,null,null,"リソースグループキー情報（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,null,"リソースグループ説明"]
[]
["表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示","表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示","表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示","表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示","表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示"]
[1,null,null,null,"なし",1,null,null,null,"なし",1,null,null,null,"なし",1,null,null,null,"なし",1,null,null,null,"なし"]
[2,null,null,null,"なし",2,null,null,null,"なし",2,null,null,null,"なし",2,null,null,null,"なし",2,null,null,null,"なし"]
[3,null,null,null,"なし",3,null,null,null,"なし",3,null,null,null,"なし",3,null,null,null,"なし",3,null,null,null,"なし"]
[4,null,null,null,"なし",4,null,null,null,"なし",4,null,null,null,"なし",4,null,null,null,"なし",4,null,null,null,"なし"]
[5,null,null,null,"なし",5,null,null,null,"なし",5,null,null,null,"なし",5,null,null,null,"なし",5,null,null,null,"なし"]
[6,null,null,null,"なし",6,null,null,null,"なし",6,null,null,null,"なし",6,null,null,null,"なし",6,null,null,null,"なし"]
[7,null,null,null,"なし",7,null,null,null,"なし",7,null,null,null,"なし",7,null,null,null,"なし",7,null,null,null,"なし"]
[8,null,null,null,"なし",8,null,null,null,"なし",8,null,null,null,"なし",8,null,null,null,"なし",8,null,null,null,"なし"]
[9,null,null,null,"なし",9,null,null,null,"なし",9,null,null,null,"なし",9,null,null,null,"なし",9,null,null,null,"なし"]
[10,null,null,null,"なし",10,null,null,null,"なし",10,null,null,null,"なし",10,null,null,null,"なし",10,null,null,null,"なし"]
[11,null,null,null,"なし",11,null,null,null,"なし",11,null,null,null,"なし",11,null,null,null,"なし",11,null,null,null,"なし"]
[12,null,null,null,"なし",12,null,null,null,"なし",12,null,null,null,"なし",12,null,null,null,"なし",12,null,null,null,"なし"]
[13,null,null,null,"なし",13,null,null,null,"なし",13,null,null,null,"なし",13,null,null,null,"なし",13,null,null,null,"なし"]
[14,null,null,null,"なし",14,null,null,null,"なし",14,null,null,null,"なし",14,null,null,null,"なし",14,null,null,null,"なし"]
[15,null,null,null,"なし",15,null,null,null,"なし",15,null,null,null,"なし",15,null,null,null,"なし",15,null,null,null,"なし"]
[16,null,null,null,"なし",16,null,null,null,"なし",16,null,null,null,"なし",16,null,null,null,"なし",16,null,null,null,"なし"]
[17,null,null,null,"なし",17,null,null,null,"なし",17,null,null,null,"なし",17,null,null,null,"なし",17,null,null,null,"なし"]
[18,null,null,null,"なし",18,null,null,null,"なし",18,null,null,null,"なし",18,null,null,null,"なし",18,null,null,null,"なし"]
[19,null,null,null,"なし",19,null,null,null,"なし",19,null,null,null,"なし",19,null,null,null,"なし",19,null,null,null,"なし"]
[20,null,null,null,"なし",20,null,null,null,"なし",20,null,null,null,"なし",20,null,null,null,"なし",20,null,null,null,"なし"]
[21,null,null,null,"なし",21,null,null,null,"なし",21,null,null,null,"なし",21,null,null,null,"なし",21,null,null,null,"なし"]
[22,null,null,null,"なし",22,null,null,null,"なし",22,null,null,null,"なし",22,null,null,null,"なし",22,null,null,null,"なし"]
[23,null,null,null,"なし",23,null,null,null,"なし",23,null,null,null,"なし",23,null,null,null,"なし",23,null,null,null,"なし"]
[24,null,null,null,"なし",24,null,null,null,"なし",24,null,null,null,"なし",24,null,null,null,"なし",24,null,null,null,"なし"]
[25,null,null,null,"なし",25,null,null,null,"なし",25,null,null,null,"なし",25,null,null,null,"なし",25,null,null,null,"なし"]
[26,null,null,null,"なし",26,null,null,null,"なし",26,null,null,null,"なし",26,null,null,null,"なし",26,null,null,null,"なし"]
[27,null,null,null,"なし",27,null,null,null,"なし",27,null,null,null,"なし",27,null,null,null,"なし",27,null,null,null,"なし"]
[28,null,null,null,"なし",28,null,null,null,"なし",28,null,null,null,"なし",28,null,null,null,"なし",28,null,null,null,"なし"]
[29,null,null,null,"なし",29,null,null,null,"なし",29,null,null,null,"なし",29,null,null,null,"なし",29,null,null,null,"なし"]
[30,null,null,null,"なし",30,null,null,null,"なし",30,null,null,null,"なし",30,null,null,null,"なし",30,null,null,null,"なし"]
[]
[]
[]
[]
[]
[]
[]
["記入例",null,{"$f":"HYPERLINK(\"#A\"&ROW(A2),\"シート入力に戻る\")","v":"シート入力に戻る"}]
["テナントキー情報"]
["TENANT"]
[]
["リソースグループキー情報（1）",null,null,null,null,"リソースグループキー情報（2）"]
["mobileResourceGroup",null,null,null,null,"tabletResourceGroup"]
["リソースグループ表示名",null,null,null,null,"リソースグループ表示名"]
["モバイル",null,null,null,null,"タブレット"]
["リソースグループ説明",null,null,null,null,"リソースグループ説明"]
["モバイルグループ",null,null,null,null,"タブレットグループ"]
["表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示","表示順","リソースキー情報","卸テナントキー情報","卸商品キー情報","初期\n表示"]
[1,"A_MOBILE_1",null,null,"なし",1,"TABLET_1",null,null,"あり"]
[2,"A_MOBILE_2",null,null,"なし",2,"TABLET_2",null,null,"なし"]
[3,"A_MOBILE_3",null,null,"なし",3,"TABLET_3",null,null,"なし"]
[4,"B_MOBILE_1",null,null,"なし",4,null,null,null,"なし"]
[5,"B_MOBILE_2",null,null,"なし",5,null,null,null,"なし"]
[6,"B_MOBILE_3",null,null,"なし",6,null,null,null,"なし"]

{"sheet":"リソース料金シート","index":4,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,0,10,0],[5,3,10,3],[5,4,10,4],[5,5,10,5],[5,6,10,6],[0,2,0,3],[33,5,38,5],[33,6,38,6],[33,7,33,11],[3,0,3,1],[2,0,2,1],[30,0,30,1],[31,0,31,1],[33,0,38,0],[33,1,38,1],[33,2,38,2],[33,3,38,3],[33,4,38,4],[5,7,5,11],[5,2,10,2],[5,1,10,1]]}
[null,null,"色の凡例"]
["リソース料金設定",{"$f":"HYPERLINK(\"#A\"&ROW(A30),\"記入例はこちら\")","v":"記入例はこちら"},"必須","任意",null,"■補足資料■はこちら↓"]
["テナントキー情報"]
[]
[]
["リソースキー情報","卸テナントキー情報","卸商品キー情報","請求書内訳名","税種別","商品コード","GLコード","料金分類"]
[null,null,null,null,null,null,null,"料金分類キー情報（1）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（2）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（3）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（4）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（5）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可"]
[]
[null,null,null,null,null,null,null,"料金分類説明","料金分類説明","料金分類説明","料金分類説明","料金分類説明"]
[]
[null,null,null,null,null,null,null,"料金分類1での料金","料金分類2での料金","料金分類3での料金","料金分類4での料金","料金分類5での料金"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["記入例",{"$f":"HYPERLINK(\"#A\"&ROW(A2),\"シート入力に戻る\")","v":"シート入力に戻る"}]
["テナントキー情報"]
["TENANT"]
[]
["リソースキー情報","卸テナントキー情報","卸商品キー情報","請求書内訳名","税種別","商品コード","GLコード","料金分類"]
[null,null,null,null,null,null,null,"料金分類キー情報（1）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（2）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（3）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（4）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可","料金分類キー情報（5）\n※半角英数字と-(ハイフン)_(アンダーバー)のみ可"]
[null,null,null,null,null,null,null,"ONE_BUY","TWO_BUYS","TABLET_CHARGE"]
[null,null,null,null,null,null,null,"料金分類説明","料金分類説明","料金分類説明","料金分類説明","料金分類説明"]
[null,null,null,null,null,null,null,"1台購入時の金額","2台購入時の金額","タブレットの料金"]
[null,null,null,null,null,null,null,"料金分類1での料金","料金分類2での料金","料金分類3での料金","料金分類4での料金","料金分類5での料金"]
["A_MOBILE_1",null,null,"モバイル本体料金","Y","PRO_CODE","GL_CODE",50000,48000]
["A_MOBILE_2",null,null,"モバイル本体料金","Y","PRO_CODE","GL_CODE",52000,50000]
["A_MOBILE_3",null,null,"モバイル本体料金","Y","PRO_CODE","GL_CODE",54000,52000]
["B_MOBILE_1",null,null,"モバイル本体料金","Y","PRO_CODE","GL_CODE",56000,54000]
["B_MOBILE_2",null,null,"モバイル本体料金","Y","PRO_CODE","GL_CODE",58000,56000]
["B_MOBILE_3",null,null,"モバイル本体料金","Y","PRO_CODE","GL_CODE",60000,58000]
["TABLET_1",null,null,"タブレット料金","Y","PRO_CODE","GL_CODE",null,null,30000]
["TABLET_2",null,null,"タブレット料金","Y","PRO_CODE","GL_CODE",null,null,32000]
["TABLET_3",null,null,"タブレット料金","Y","PRO_CODE","GL_CODE",null,null,34000]

{"sheet":"(参考)画面イメージ","index":5,"n_rows":127,"n_cols":16,"rows_kept":127,"cut":false,"hidden":false,"merged":[[0,1,0,13],[0,15,0,29]]}
[null,"旧UI",null,null,null,null,null,null,null,null,null,null,null,null,null,"新UI"]
[]
["＊「オペレータによる料金の変更」「オペレータによる請求書テキストの変更」のイメージ",null,null,null,null,null,null,{"$f":"HYPERLINK(\"#'設定シート'!A26\",\"設定シートへ\")","v":"設定シートへ"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["＊「複数の設定が可能」の画面イメージ",null,null,null,{"$f":"HYPERLINK(\"#'設定シート'!A26\",\"設定シートへ\")","v":"設定シートへ"}]

{"sheet":"入力リスト","index":6,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["料金単位","種類","可/不可","あり/なし","必須/任意","卸/小売","前払い/後払い","秒割/日割","秒割/日割の契機","周期（頻度）","廃止時の残りの分割料金","割引形式","ヶ月/日/請求期間","計算に使用される情報","〇/-"]
["商品単位","一括","可","あり","必須","卸商品","前払い","-","開始時および終了時","1ヶ月毎","支払う","金額指定割引（適用対象選択可）","ヶ月","料金","〇"]
["サービス単位","定期払い（1ヶ月毎）","不可","なし","任意","小売商品","後払い","秒割り","開始時","2ヶ月毎","支払わない","パーセント割引","日","ユニット","-"]
["サービス特性単位","定期払い（2ヶ月毎）",null,null,null,null,null,"日割り","終了時","3ヶ月毎",null,"金額指定割引（適用対象選択不可）","請求期間","取引件数"]
["サービス特性単位(SELECT単位)","定期払い（3ヶ月毎）",null,null,null,null,null,null,null,"6ヶ月毎"]
[null,"定期払い（6ヶ月毎）",null,null,null,null,null,null,null,"12ヶ月毎"]
[null,"定期払い（12ヶ月毎）"]
[null,"割引"]
[null,"分割"]