{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":51,"n_cols":8,"rows_kept":51,"merged":[[1,0,1,7],[3,0,3,1],[5,0,5,1],[5,2,5,4],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2]]}
[{"$nulls":7},{"$f":"TODAY()","v":"2021-12-04"}]
["請求書"]
[]
[null,null,"様"]
[]
["合計金額",null,{"$f":"F51","v":{"v":0,"d":"¥0"}}]
[]
[]
[{"$f":"IF(A2=\"\",\"\",IF(A2=\"請求書\",\"下記の通り、ご請求いたします。\",\"下記の通り、領収したしました。\"))","v":"下記の通り、ご請求いたします。"},{"$nulls":3},{"$f":"IF(A2=\"領収書\",\"但し、自動車整備費用として\",\"\")","v":""}]
[]
["No.","内訳",null,"単価","数量","金額","備考"]
[{"$f":"IF(B12=\"\",\"\",ROW()-11)","v":""},null,null,{"$f":"IF(B12=\"\",0,VLOOKUP(B12,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"$f":"D12*E12","v":{"v":0,"d":"¥0"}}]
[{"$f":"IF(B13=\"\",\"\",ROW()-11)","v":""},null,null,{"$f":"IF(B13=\"\",0,VLOOKUP(B13,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
[{"$f":"IF(B14=\"\",\"\",ROW()-11)","v":""},null,null,{"$f":"IF(B14=\"\",0,VLOOKUP(B14,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B15=\"\",0,VLOOKUP(B15,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B16=\"\",0,VLOOKUP(B16,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B17=\"\",0,VLOOKUP(B17,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B18=\"\",0,VLOOKUP(B18,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B19=\"\",0,VLOOKUP(B19,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"$f":"D19*E19","v":{"v":0,"d":"¥0"}}]
["",null,null,{"$f":"IF(B20=\"\",0,VLOOKUP(B20,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B21=\"\",0,VLOOKUP(B21,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B22=\"\",0,VLOOKUP(B22,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B23=\"\",0,VLOOKUP(B23,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B24=\"\",0,VLOOKUP(B24,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B25=\"\",0,VLOOKUP(B25,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B26=\"\",0,VLOOKUP(B26,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B27=\"\",0,VLOOKUP(B27,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"$f":"D27*E27","v":{"v":0,"d":"¥0"}}]
["",null,null,{"$f":"IF(B28=\"\",0,VLOOKUP(B28,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B29=\"\",0,VLOOKUP(B29,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B30=\"\",0,VLOOKUP(B30,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B31=\"\",0,VLOOKUP(B31,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B32=\"\",0,VLOOKUP(B32,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B33=\"\",0,VLOOKUP(B33,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B34=\"\",0,VLOOKUP(B34,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B35=\"\",0,VLOOKUP(B35,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B36=\"\",0,VLOOKUP(B36,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B37=\"\",0,VLOOKUP(B37,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B38=\"\",0,VLOOKUP(B38,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B39=\"\",0,VLOOKUP(B39,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B40=\"\",0,VLOOKUP(B40,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B41=\"\",0,VLOOKUP(B41,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B42=\"\",0,VLOOKUP(B42,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B43=\"\",0,VLOOKUP(B43,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"$f":"D43*E43","v":{"v":0,"d":"¥0"}}]
["",null,null,{"$f":"IF(B44=\"\",0,VLOOKUP(B44,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B45=\"\",0,VLOOKUP(B45,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B46=\"\",0,VLOOKUP(B46,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
["",null,null,{"$f":"IF(B47=\"\",0,VLOOKUP(B47,Sheet2!$C$2:$D$27,2,0))","v":{"v":0,"d":"¥0"}},null,{"v":0,"d":"¥0"}]
[{"$nulls":5},{"v":0,"d":"¥0"}]
[{"$nulls":4},"小計",{"$f":"SUM(F12:F48)","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"消費税",{"$f":"F49*0.05","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"合計",{"$f":"F49+F50","v":{"v":0,"d":"¥0"}}]

{"sheet":"Sheet2","index":1,"n_rows":27,"n_cols":4,"rows_kept":27}
["種類","顧客名","内訳","単価"]
["請求書","相川　春樹","ノーマルタイヤ",{"v":7500,"d":"¥7,500"}]
["領収書","井上　智彦","スタッドレスタイヤ",{"v":9000,"d":"¥9,000"}]
[null,"宇佐美　京子","タイヤ交換工賃",{"v":1000,"d":"¥1,000"}]
[null,"遠藤　利光","エンジンオイル",{"v":2500,"d":"¥2,500"}]
[null,"緒方　省吾","エンジンオイル交換工賃",{"v":500,"d":"¥500"}]
[null,"河合　和樹","ブレーキオイル",{"v":1500,"d":"¥1,500"}]
[null,"木下　文恵","ブレーキオイル交換工賃",{"v":500,"d":"¥500"}]
[null,"栗山　一郎","パワステオイル",{"v":2000,"d":"¥2,000"}]
[null,"剣持　章人","パワステオイル交換工賃",{"v":1500,"d":"¥1,500"}]
[null,"小島　大介","オートマオイル",{"v":3000,"d":"¥3,000"}]
[null,"坂上　まどか","オートマオイル交換工賃",{"v":1000,"d":"¥1,000"}]
[null,"篠崎　順子","オイルエレメント",{"v":1000,"d":"¥1,000"}]
[null,"須藤　寿明","オイルエレメント交換工賃",{"v":300,"d":"¥300"}]
[null,"瀬戸　優貴","エアーエレメント",{"v":5000,"d":"¥5,000"}]
[null,"曽根　直彦","エアーエレメント交換工賃",{"v":1500,"d":"¥1,500"}]
[null,null,"バッテリー",{"v":30000,"d":"¥30,000"}]
[null,null,"バッテリー交換工賃",{"v":3000,"d":"¥3,000"}]
[null,null,"タイミングベルト",{"v":20000,"d":"¥20,000"}]
[null,null,"タイミングベルト交換工賃",{"v":2000,"d":"¥2,000"}]
[null,null,"ワイパー",{"v":700,"d":"¥700"}]
[null,null,"ワイパー交換工賃",{"v":500,"d":"¥500"}]
[null,null,"ランプ（大）",{"v":500,"d":"¥500"}]
[null,null,"ランプ（中）",{"v":300,"d":"¥300"}]
[null,null,"ランプ（小）",{"v":150,"d":"¥150"}]
[null,null,"ラジエター",{"v":25000,"d":"¥25,000"}]
[null,null,"ラジエター交換工賃",{"v":2500,"d":"¥2,500"}]