{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["機器の在庫リスト"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"機器の在庫リスト","index":0,"n_rows":9,"n_cols":19,"rows_kept":9,"merged":[[0,1,0,5],[0,6,0,9],[0,10,0,12],[0,13,0,14],[2,1,2,6],[2,7,2,18]]}
[null,"機器の在庫リスト"]
[]
[null,"物理状態",{"$nulls":5},"財務状況"]
[null,"資産/シリアル番号","品目の説明 (製造元とモデル)","場所","状態","仕入先","残存保証期間 \n(年) ","初期値","頭金","購入/リース日","ローン期間 (年)","ローン金利","毎月の返済額","毎月の運用コスト","毎月のコスト\n合計","ローン期間終了\n時の予想価格","年間の定額減価\n償却費","毎月の定額減価\n償却費","現在の価格"]
[null,123,"製造モデル","本店","良い","市町村",5,{"v":30000,"d":"¥30,000.00"},{"v":5000,"d":"¥5,000.00"},{"$f":"DATE(YEAR(TODAY())-2, 1,1)","v":"2016-01-01"},4,{"v":0.1,"d":"10.00%"},{"$f":"IFERROR(IF(AND(データ[[#This Row],[初期値]]>0,データ[[#This Row],[初期値]]<>データ[[#This Row],[頭金]]),-1*PMT(データ[[#This Row],[ローン金利]]/12,データ[[#This Row],[ローン期間 (年)]]*12,データ[[#This Row],[初期値]]-データ[[#This Row],[頭金]]),0),0)","v":{"v":634.0645858686797,"d":"¥634.06"}},{"v":200,"d":"¥200.00"},{"$f":"IFERROR(データ[[#This Row],[毎月の運用コスト]]+データ[[#This Row],[毎月の返済額]],\"\")","v":{"v":834.0645858686797,"d":"¥834.06"}},{"v":20000,"d":"¥20,000.00"},{"$f":"IFERROR(IF(データ[[#This Row],[初期値]]>0,SLN(データ[[#This Row],[初期値]],データ[[#This Row],[ローン期間終了\n時の予想価格]],データ[[#This Row],[残存保証期間 \n(年) ]]),0),0)","v":{"v":2000,"d":"¥2,000.00"}},{"$f":"IFERROR(データ[[#This Row],[年間の定額減価\n償却費]]/12,0)","v":{"v":166.66666666666666,"d":"¥166.67"}},{"$f":"IFERROR(データ[[#This Row],[初期値]]-(データ[[#This Row],[年間の定額減価\n償却費]]*((TODAY()-データ[[#This Row],[購入/リース日]])/365)),0)","v":{"v":25013.698630136987,"d":"¥25,013.70"}}]
[null,456,"製造モデル","本店","たいへん良い","市町村",3,{"v":5000,"d":"¥5,000.00"},{"v":5000,"d":"¥5,000.00"},{"$f":"DATE(YEAR(TODAY())-1, 1,1)","v":"2017-01-01"},null,null,{"$f":"IFERROR(IF(AND(データ[[#This Row],[初期値]]>0,データ[[#This Row],[初期値]]<>データ[[#This Row],[頭金]]),-1*PMT(データ[[#This Row],[ローン金利]]/12,データ[[#This Row],[ローン期間 (年)]]*12,データ[[#This Row],[初期値]]-データ[[#This Row],[頭金]]),0),0)","v":{"v":0,"d":"¥0.00"}},{"v":20,"d":"¥20.00"},{"$f":"IFERROR(データ[[#This Row],[毎月の運用コスト]]+データ[[#This Row],[毎月の返済額]],\"\")","v":{"v":20,"d":"¥20.00"}},null,{"$f":"IFERROR(IF(データ[[#This Row],[初期値]]>0,SLN(データ[[#This Row],[初期値]],データ[[#This Row],[ローン期間終了\n時の予想価格]],データ[[#This Row],[残存保証期間 \n(年) ]]),0),0)","v":{"v":1666.6666666666667,"d":"¥1,666.67"}},{"$f":"IFERROR(データ[[#This Row],[年間の定額減価\n償却費]]/12,0)","v":{"v":138.88888888888889,"d":"¥138.89"}},{"$f":"IFERROR(データ[[#This Row],[初期値]]-(データ[[#This Row],[年間の定額減価\n償却費]]*((TODAY()-データ[[#This Row],[購入/リース日]])/365)),0)","v":{"v":2515.981735159817,"d":"¥2,515.98"}}]
[null,789,"製造モデル","東海岸","中程度","市町村",6,{"v":50000,"d":"¥50,000.00"},{"v":20000,"d":"¥20,000.00"},{"$f":"TODAY()","v":"2018-06-29"},5,{"v":0.05,"d":"5.00%"},{"$f":"IFERROR(IF(AND(データ[[#This Row],[初期値]]>0,データ[[#This Row],[初期値]]<>データ[[#This Row],[頭金]]),-1*PMT(データ[[#This Row],[ローン金利]]/12,データ[[#This Row],[ローン期間 (年)]]*12,データ[[#This Row],[初期値]]-データ[[#This Row],[頭金]]),0),0)","v":{"v":566.137009320328,"d":"¥566.14"}},{"v":40,"d":"¥40.00"},{"$f":"IFERROR(データ[[#This Row],[毎月の運用コスト]]+データ[[#This Row],[毎月の返済額]],\"\")","v":{"v":606.137009320328,"d":"¥606.14"}},{"v":1500,"d":"¥1,500.00"},{"$f":"IFERROR(IF(データ[[#This Row],[初期値]]>0,SLN(データ[[#This Row],[初期値]],データ[[#This Row],[ローン期間終了\n時の予想価格]],データ[[#This Row],[残存保証期間 \n(年) ]]),0),0)","v":{"v":8083.333333333333,"d":"¥8,083.33"}},{"$f":"IFERROR(データ[[#This Row],[年間の定額減価\n償却費]]/12,0)","v":{"v":673.6111111111111,"d":"¥673.61"}},{"$f":"IFERROR(データ[[#This Row],[初期値]]-(データ[[#This Row],[年間の定額減価\n償却費]]*((TODAY()-データ[[#This Row],[購入/リース日]])/365)),0)","v":{"v":50000,"d":"¥50,000.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(データ[[#This Row],[初期値]]>0,データ[[#This Row],[初期値]]<>データ[[#This Row],[頭金]]),-1*PMT(データ[[#This Row],[ローン金利]]/12,データ[[#This Row],[ローン期間 (年)]]*12,データ[[#This Row],[初期値]]-データ[[#This Row],[頭金]]),0),0)","v":{"v":0,"d":"¥0.00"}},null,{"$f":"IFERROR(データ[[#This Row],[毎月の運用コスト]]+データ[[#This Row],[毎月の返済額]],\"\")","v":{"v":0,"d":"¥0.00"}},null,{"$f":"IFERROR(IF(データ[[#This Row],[初期値]]>0,SLN(データ[[#This Row],[初期値]],データ[[#This Row],[ローン期間終了\n時の予想価格]],データ[[#This Row],[残存保証期間 \n(年) ]]),0),0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(データ[[#This Row],[年間の定額減価\n償却費]]/12,0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(データ[[#This Row],[初期値]]-(データ[[#This Row],[年間の定額減価\n償却費]]*((TODAY()-データ[[#This Row],[購入/リース日]])/365)),0)","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(データ[[#This Row],[初期値]]>0,データ[[#This Row],[初期値]]<>データ[[#This Row],[頭金]]),-1*PMT(データ[[#This Row],[ローン金利]]/12,データ[[#This Row],[ローン期間 (年)]]*12,データ[[#This Row],[初期値]]-データ[[#This Row],[頭金]]),0),0)","v":{"v":0,"d":"¥0.00"}},null,{"$f":"IFERROR(データ[[#This Row],[毎月の運用コスト]]+データ[[#This Row],[毎月の返済額]],\"\")","v":{"v":0,"d":"¥0.00"}},null,{"$f":"IFERROR(IF(データ[[#This Row],[初期値]]>0,SLN(データ[[#This Row],[初期値]],データ[[#This Row],[ローン期間終了\n時の予想価格]],データ[[#This Row],[残存保証期間 \n(年) ]]),0),0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(データ[[#This Row],[年間の定額減価\n償却費]]/12,0)","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(データ[[#This Row],[初期値]]-(データ[[#This Row],[年間の定額減価\n償却費]]*((TODAY()-データ[[#This Row],[購入/リース日]])/365)),0)","v":{"v":0,"d":"¥0.00"}}]