{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["依頼書","送付リスト"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2],[7,1,7,2],[3,6,3,7],[4,6,4,7],[19,1,19,4],[34,1,34,2],[34,3,34,4],[3,1,3,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[29,1,29,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[39,1,39,4]]}
[null,null,null,null,null,null,"番号","郵便番号","住所","会社名","部署・担当者","１列目勘定科目","１列目金額","２列目勘定科目","２列目金額","３列目勘定科目","３列目金額"]
[null,null,null,null,null,null,1,{"$f":"VLOOKUP(G2,送付リスト!A:K,2,FALSE)","v":"600-0000"},{"$f":"VLOOKUP(G2,送付リスト!A:K,3,FALSE)","v":"京都市下京区塩小路通天川６７"},{"$f":"VLOOKUP(G2,送付リスト!A:K,4,FALSE)","v":"金澤金属株式会社"},{"$f":"VLOOKUP(G2,送付リスト!A:K,5,FALSE)","v":"経理部・山田様"},{"$f":"IF(VLOOKUP($G2,送付リスト!$A:$K,6,FALSE)=\"\",\"\",VLOOKUP($G2,送付リスト!$A:$K,6,FALSE))","v":"受取手形"},{"$f":"IF(VLOOKUP($G2,送付リスト!$A:$K,7,FALSE)=\"\",\"\",VLOOKUP($G2,送付リスト!$A:$K,7,FALSE))","v":5000000},{"$f":"IF(VLOOKUP($G2,送付リスト!$A:$K,8,FALSE)=\"\",\"\",VLOOKUP($G2,送付リスト!$A:$K,8,FALSE))","v":"売掛金"},{"$f":"IF(VLOOKUP($G2,送付リスト!$A:$K,9,FALSE)=\"\",\"\",VLOOKUP($G2,送付リスト!$A:$K,9,FALSE))","v":8400000},{"$f":"IF(VLOOKUP($G2,送付リスト!$A:$K,10,FALSE)=\"\",\"\",VLOOKUP($G2,送付リスト!$A:$K,10,FALSE))","v":"未収入金"},{"$f":"IF(VLOOKUP($G2,送付リスト!$A:$K,11,FALSE)=\"\",\"\",VLOOKUP($G2,送付リスト!$A:$K,11,FALSE))","v":100000}]
[]
[null,"2014-05-12",null,null,null,null,"印刷開始番号を入力",null,1]
["〒",{"$f":"H2","v":"600-0000"},null,null,null,null,"印刷終了番号を入力",null,3]
[null,{"$f":"I2","v":"京都市下京区塩小路通天川６７"}]
[null,{"$f":"J2","v":"金澤金属株式会社"}]
[null,{"$f":"K2","v":"経理部・山田様"}]
[null,"株式会社岡部工務店"]
[null,"京都市左京区一乗寺松ノ内町99"]
[null,"経理部　担当　常盤"]
[null,"TEL075-123-4567"]
[]
[null,"残高確認依頼書"]
[]
[null,"　拝啓　貴社ますますご清栄のこととお慶び申し上げます。平素は格別のご愛顧を賜り厚く御礼申し上げます。"]
[null,"　さて今般弊社の会計監査に当たり、弊社の会計監査人であるフラミンゴ監査法人は、平成２６年３月３１日時点における弊社の貴社に対する取引残高等の確認を望んでおります。\n　つきましてはご多忙中誠に恐縮ですが、貴社残高とご照合いただき、「当社残高」欄に貴社残高をご記入・ご捺印の上、同封の返信用封筒にて直接フラミンゴ監査法人宛に、平成26年5月31日頃までにご返送下さいますようお願い申し上げます。"]
[null,"　残高に差異のある場合は、恐れ入りますが、差異金額および差異理由等を摘要欄へご記入いただければ幸いに存じます。"]
[null,"　なお、当依頼書はお支払の督促ではございませんので、念の為申し添えます。"]
[null,"敬具"]
[]
[null,"記"]
[]
[null,"- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -"]
[]
[null,"年　　　月　　　日"]
[]
[null,"残高確認書"]
[]
[null,"御住所　　　　　　   　　　　　 　 　    　　　　　1"]
[]
[null,"御社名　　　　　　   　　　　　　 　    　　　　　印"]
[]
[null,"当社の株式会社岡部工務店に対する2014年3月31日現在の残高を次のとおり確認します。"]
[null,"株式会社岡部工務店",null,"当社残高"]
[null,"勘定科目","金　　額","勘定科目","金　　額"]
[null,{"$f":"L2","v":"受取手形"},{"$f":"M2","v":5000000}]
[null,{"$f":"N2","v":"売掛金"},{"$f":"O2","v":8400000}]
[null,{"$f":"P2","v":"未収入金"},{"$f":"Q2","v":100000}]
[null,"摘要（差異金額及び差異理由等）"]

{"sheet":"送付リスト","index":1,"n_rows":251,"n_cols":11,"rows_kept":251,"cut":false,"hidden":false,"merged":[]}
["No.","郵便番号","住所","会社名","部署・担当者","１列目勘定科目","１列目金額","２列目勘定科目","２列目金額","３列目勘定科目","３列目金額"]
[1,"600-0000","京都市下京区塩小路通天川６７","金澤金属株式会社","経理部・山田様","受取手形",5000000,"売掛金",8400000,"未収入金",100000]
[2,"650-0000","神戸市中央区海岸通９－９－９","芳賀商事株式会社","理財部・山下様","売掛金",10800322]
[3,"336-0000","さいたま市浦和区広小路西９－９－９","有限会社海沼プラ販売","経理部御中","売掛金",325821,"未収入金",540000]
[4,"525-0000","草津市西草津９－９－９","篠田商店株式会社","経理課御中","売掛金",7356541]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]