{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["入力表","仕入先取引稟議書","入力表(例)","顧客管理","ヘルプ","管理者画面"],"not_rendered":{"charts":0,"images":189,"macros":1,"external_links":0,"defined_names":3,"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":52,"n_cols":33,"rows_kept":52,"cut":false,"hidden":false,"merged":[[46,7,46,8],[51,1,51,3],[32,23,32,29],[19,23,19,29],[20,23,20,29],[27,23,27,29],[28,23,28,29],[23,23,23,29],[31,23,31,29],[24,23,24,29],[22,23,22,24],[30,23,30,24],[22,26,22,27],[29,23,29,27],[30,26,30,27],[21,23,21,27],[47,2,47,3],[48,2,48,3],[49,2,49,3],[27,1,28,2],[27,3,27,9],[33,28,33,29],[25,28,25,29],[46,2,46,3],[9,3,9,6],[43,3,43,6],[39,1,39,2],[42,3,42,6],[39,7,39,10],[36,1,36,18],[19,1,20,2],[42,1,43,2],[12,3,12,4],[14,3,14,4],[40,3,40,8],[41,3,41,8],[13,3,13,4],[13,5,13,14],[14,9,14,10],[14,5,14,8],[14,11,14,12],[3,23,3,29],[4,23,4,29],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,4,6,5],[8,7,8,8],[3,3,3,15],[4,3,4,15],[3,16,3,18],[4,16,4,18],[17,23,17,25],[17,26,17,27],[18,26,18,27],[25,23,25,25],[25,26,25,27],[18,23,18,25],[26,23,26,25],[26,26,26,27],[33,23,33,25],[33,26,33,27],[1,16,1,18],[5,3,5,15],[6,6,6,15],[7,3,7,15],[8,9,8,11],[18,4,18,5],[19,3,19,9],[2,1,2,18],[9,9,9,12],[18,1,18,2],[10,9,10,10],[11,3,11,4],[17,1,17,2],[10,5,10,8],[11,5,11,8],[6,1,7,2],[8,1,8,2],[8,3,8,6],[9,1,9,2],[9,7,9,8],[10,3,10,4],[16,1,16,18],[11,9,11,10],[17,3,17,6],[45,1,45,18],[10,11,10,14],[11,11,11,14],[12,5,12,14],[39,11,39,13],[37,7,37,10],[38,7,38,10],[37,11,37,14],[38,11,38,14],[37,1,37,2],[38,1,38,2],[37,3,37,6],[10,1,14,2],[43,7,43,10],[40,1,41,2],[27,10,27,16],[19,10,19,16],[39,3,39,5],[42,15,42,18],[43,15,43,18],[43,11,43,14],[42,11,42,14],[42,7,42,10],[38,3,38,6]]}
[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,null,null,null,null,null,"作成日：","2024年6月24日",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,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,"住所",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,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,null,"至",null,null,null,null,null,null,null,null,null,null,null,null,"和暦表示"]
[null,null,null,"令和",{"$f":"IF($AA$26=\"\",\"\",TEXT($AA$26,\"e\"))","v":""},"年",{"$f":"IF($AA$26=\"\",\"\",TEXT($AA$26,\"m\"))","v":""},"月",{"$f":"IF($AA$26=\"\",\"\",TEXT($AA$26,\"d\"))","v":""},"日","令和",{"$f":"IF($AC$26=\"\",\"\",TEXT($AC$26,\"e\"))","v":""},"年",{"$f":"IF($AC$26=\"\",\"\",TEXT($AC$26,\"m\"))","v":""},"月",{"$f":"IF($AC$26=\"\",\"\",TEXT($AC$26,\"d\"))","v":""},"日",null,null,null,null,null,null,{"$f":"IF(E21=\"\",\"\",\"自　\"&D21&E21&F21&G21&H21&I21&J21&\"　～　至　\"&K21&L21&M21&N21&O21&P21&Q21)","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D21=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&E21&\".\"&G21&\".\"&I21)),\"\",DATEVALUE(\"H\"&E21&\".\"&G21&\".\"&I21)),IF(ISERROR(DATEVALUE(\"R\"&E21&\".\"&G21&\".\"&I21)),\"\",DATEVALUE(\"R\"&E21&\".\"&G21&\".\"&I21)))","v":""},null,"～",{"$f":"IF(K21=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&L21&\".\"&N21&\".\"&P21)),\"\",DATEVALUE(\"H\"&L21&\".\"&N21&\".\"&P21)),IF(ISERROR(DATEVALUE(\"R\"&L21&\".\"&N21&\".\"&P21)),\"\",DATEVALUE(\"R\"&L21&\".\"&N21&\".\"&P21)))","v":""}]
[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,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,null,null,null,null,null,"西暦(kintone)"]
[]
[null,null,null,"自",null,null,null,null,null,null,"至",null,null,null,null,null,null,null,null,null,null,null,null,"和暦表示"]
[null,null,null,"令和",{"$f":"IF($AA$34=\"\",\"\",TEXT($AA$34,\"e\"))","v":""},"年",{"$f":"IF($AA$34=\"\",\"\",TEXT($AA$34,\"m\"))","v":""},"月",{"$f":"IF($AA$34=\"\",\"\",TEXT($AA$34,\"d\"))","v":""},"日","令和",{"$f":"IF($AC$34=\"\",\"\",TEXT($AC$34,\"e\"))","v":""},"年",{"$f":"IF($AC$34=\"\",\"\",TEXT($AC$34,\"m\"))","v":""},"月",{"$f":"IF($AC$34=\"\",\"\",TEXT($AC$34,\"d\"))","v":""},"日",null,null,null,null,null,null,{"$f":"IF(E29=\"\",\"\",\"自　\"&D29&E29&F29&G29&H29&I29&J29&\"　～　至　\"&K29&L29&M29&N29&O29&P29&Q29)","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&E29&\".\"&G29&\".\"&I29)),\"\",DATEVALUE(\"H\"&E29&\".\"&G29&\".\"&I29)),IF(ISERROR(DATEVALUE(\"R\"&E29&\".\"&G29&\".\"&I29)),\"\",DATEVALUE(\"R\"&E29&\".\"&G29&\".\"&I29)))","v":""},null,"～",{"$f":"IF(K29=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&L29&\".\"&N29&\".\"&P29)),\"\",DATEVALUE(\"H\"&L29&\".\"&N29&\".\"&P29)),IF(ISERROR(DATEVALUE(\"R\"&L29&\".\"&N29&\".\"&P29)),\"\",DATEVALUE(\"R\"&L29&\".\"&N29&\".\"&P29)))","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西暦(kintone)"]
[]
[]
[null,"保険等情報"]
[null,"保険の名称",null,"第三者工事保険",null,null,null,"労災保険/雇用保険",null,null,null,"労災上積保険"]
[null,"加入状況"]
[null,"補償金額",null,null,null,null,"万円",null,null,null,null,null,null,null,"万円"]
[null,"健康保険\n加入有無",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,"末日(翌月5日必着)",null,null,"    支払日：",null,"　手形 翌月末日／振込 翌月末日"]
[null,null,"材工共：",null,"60万以上　手形 50％(サイト90日)　振込50％"]
[null,null,"納　材：",null,"30万以上　手形100％(サイト120日）"]
[null,null,"リース：",null,"30万以上　手形100％(サイト120日)"]
[]
[null,{"$f":"\"ver:\" & 管理者画面!G2","v":"ver:20230710"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"笠原工業株式会社"]

{"sheet":"仕入先取引稟議書","index":1,"n_rows":51,"n_cols":37,"rows_kept":51,"cut":false,"hidden":true,"merged":[[9,1,9,9],[1,8,3,9],[1,5,3,5],[10,1,10,4],[0,8,0,9],[2,13,2,15],[0,6,0,7],[1,6,3,7],[6,1,6,9],[4,1,4,2],[10,7,10,8],[7,1,7,9],[5,12,5,15],[3,1,3,2],[3,3,3,4],[5,1,5,9],[8,3,8,9],[0,0,2,4],[10,5,10,6],[8,0,9,0],[4,3,4,4],[4,5,4,6],[2,25,2,27],[2,16,2,24],[29,12,29,13],[29,20,29,21],[28,12,28,27],[7,26,7,28],[6,26,6,30],[6,18,6,24],[7,29,7,30],[17,26,17,28],[17,29,17,30],[16,26,16,30],[16,11,16,17],[16,18,16,24],[29,14,29,15],[29,22,29,23],[2,11,2,12],[3,11,3,12],[42,0,43,0],[47,0,48,0],[36,0,37,0],[30,3,30,4],[47,7,47,8],[43,3,43,5],[43,6,43,8],[47,1,47,2],[47,3,47,5],[36,8,36,9],[36,1,36,2],[36,4,36,5],[43,1,43,2],[36,6,36,7],[40,1,40,9],[41,1,41,9],[38,1,38,9],[39,1,39,9],[31,4,31,5],[28,0,35,0],[28,7,28,9],[29,7,29,9],[44,0,46,0],[11,1,11,4],[26,4,26,5],[27,4,27,5],[13,3,13,5],[19,3,19,9],[21,1,21,3],[14,1,14,2],[13,1,13,2],[14,3,14,9],[19,1,20,1],[20,3,20,9],[17,3,17,9],[11,7,11,9],[12,3,12,5],[15,1,15,2],[18,3,18,9],[16,7,16,8],[13,7,13,9],[17,1,18,1],[11,5,11,6],[23,1,23,3],[26,0,27,0],[26,6,26,7],[32,11,32,18],[12,7,12,9],[12,1,12,2],[29,3,29,6],[26,8,26,9],[27,8,27,9],[16,1,16,3],[22,1,22,3],[15,3,15,9],[21,7,21,9],[22,7,22,9],[21,4,21,6],[22,4,22,6],[23,7,23,9],[23,4,23,6],[24,1,24,4],[25,1,25,4],[12,0,15,0],[24,8,24,9],[25,8,25,9],[16,0,20,0],[24,0,25,0],[33,11,33,12],[33,15,33,16],[28,1,28,2],[29,1,29,2],[24,6,24,7],[26,1,26,3],[27,1,27,3],[25,6,25,7],[30,11,30,12],[31,11,31,12],[28,3,28,6],[27,6,27,7],[30,8,30,9]]}
["仕入先取引稟議書",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,0,"当月","【新規】","振込"]
[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,1,"翌月","【変更】","手形","株式会社","（株）"]
[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,2,"翌々月","【更新】","相殺（部門間）","有限会社","（有）"]
["【新規】","申請日",null,{"$f":"TODAY()","v":"2024-06-24"},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,3,"翌々々月",null,"相殺（売掛金）","合名会社","（名）"]
["コ－ド",null,null,"インボイス登録番号",null,{"$f":"顧客管理!EU2","v":""},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,4,"4ヶ月後",null,null,"合資会社","（資） "]
["ﾌﾘｶﾞﾅ(半角)",{"$f":"顧客管理!H2","v":""},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,5,"5ヶ月後",null,null,"合同会社","（同）"]
["会社名",{"$f":"顧客管理!B2","v":""},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,6,"6ヶ月後",null,null,"独立行政法人","（独）"]
["ﾌﾘｶﾞﾅ(半角)",{"$f":"顧客管理!EF2","v":""},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,7,"7ヶ月後",null,null,"学校法人","（学）"]
["住所","〒",{"$f":"顧客管理!C2","v":""},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,8,"8ヶ月後",null,null,"公益財団法人","（公財）"]
[null,{"$f":"顧客管理!D2","v":""},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,9,"9ヶ月後",null,null,"一般財団法人","（一財）"]
["担当者",{"$f":"顧客管理!K2","v":""},null,null,null,"資本金",null,{"$f":"顧客管理!L2","v":0},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,"公益社団法人","（公社）"]
["ＴＥＬ",{"$f":"顧客管理!E2","v":""},null,null,null,"ＦＡＸ",null,{"$f":"顧客管理!F2","v":""},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,{"$f":"顧客管理!DS2","v":""},null,null,"支店名",{"$f":"顧客管理!DU2","v":""},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,{"$f":"顧客管理!DV2","v":"普通"},null,null,"口座番号",{"$f":"顧客管理!DW2","v":""},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,{"$f":"顧客管理!DX2","v":""},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,"口座名義",null,{"$f":"顧客管理!DY2","v":""}]
["建設業許可\n\n＊必ず添付してください。",{"$f":"顧客管理!EA2","v":"無"},null,null,null,"許可番号","第",{"$f":"顧客管理!BC2","v":""},null,"号"]
[null,{"$f":"顧客管理!EJ2","v":""},"許可年月日",{"$f":"入力表!X21","v":""}]
[null,null,"許可業種",{"$f":"入力表!X25","v":"と"}]
[null,{"$f":"顧客管理!EK2","v":""},"許可年月日",{"$f":"入力表!X29","v":""}]
[null,null,"許可業種",{"$f":"入力表!X33","v":0}]
["保険の名称","第三者工事保険",null,null,"労災保険/雇用保険",null,null,"労災上積保険"]
["加入状況",{"$f":"顧客管理!DE2","v":"未選択"},null,null,{"$f":"顧客管理!DG2","v":"未選択"},null,null,{"$f":"顧客管理!DI2","v":"未選択"}]
["補償金額",{"$f":"顧客管理!DF2","v":0},null,null,null,null,null,{"$f":"顧客管理!DJ2","v":0}]
["健康保険加入　　有　　無","健康保険/厚生年金"]
[null,{"$f":"顧客管理!DH2","v":"未選択"}]
["事業所　　　　　整理記号等","営業所の名称",null,null,"健康保険",null,"厚生年金保険",null,"雇用保険"]
[null,{"$f":"顧客管理!DK2","v":""},null,null,{"$f":"顧客管理!DZ2","v":""},null,{"$f":"顧客管理!DL2","v":""},null,{"$f":"顧客管理!DM2","v":""}]
["支払条件","締日",null,"支払日",null,null,null,"サイト",null,null,null,"締日","支払情報"]
[null,{"$f":"L30","v":0},null,{"$f":"AD30&\"・\"&AD31","v":"・"},null,null,null,{"$f":"IF(N34<=0,\"\",N34&\"日起算　サイト\" & R34&\"日\")","v":""},null,null,null,null,"振込",null,null,null,null,"日",null,"%","手形",null,null,null,null,"日",null,"%",null,{"$f":"IF(Q30>0,M30&O30&Q30&R30,\"\")","v":""}]
[null,"基準額",null,{"$f":"L32","v":0},null,"でんさい",{"$f":"顧客管理!ER2","v":0},"利用者番号",{"$f":"顧客管理!ES2","v":""},null,null,"基準額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y30>0,U30&W30&Y30&Z30,\"\")","v":""}]
[null,"基準額無し叉は以下の場合 　  　【",null,null,null,null,"】で支払う","*安全協力会費"]
[null,"基準額超過の場合",null,null,"振込",{"$f":"S30","v":0},"％",null,null,null,null,"サイト"]
[null,null,null,null,"手形",{"$f":"AA30","v":0},"％",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,"㊞"]
[]
["2部提出（経理部・事業部各1部保管）",null,null,null,null,null,null,null,"顧客コード"]
["*上記添付書類（会社案内・経歴書・信用調査書）がない場合・・・別紙企業調査表を添付の事"]

{"sheet":"入力表(例)","index":2,"n_rows":52,"n_cols":33,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,16,4,18],[4,23,4,29],[5,1,5,2],[5,3,5,15],[1,16,1,18],[2,1,2,18],[3,1,3,2],[3,3,3,15],[3,16,3,18],[3,23,3,29],[6,1,7,2],[6,4,6,5],[6,6,6,15],[7,3,7,15],[8,1,8,2],[8,3,8,6],[8,7,8,8],[8,9,8,11],[4,1,4,2],[4,3,4,15],[9,1,9,2],[9,3,9,6],[9,7,9,8],[9,9,9,12],[10,1,14,2],[10,3,10,4],[10,5,10,8],[10,9,10,10],[10,11,10,14],[11,3,11,4],[14,3,14,4],[14,5,14,8],[14,9,14,10],[14,11,14,12],[16,1,16,18],[17,1,17,2],[17,3,17,6],[11,5,11,8],[11,9,11,10],[11,11,11,14],[12,3,12,4],[12,5,12,14],[13,3,13,4],[13,5,13,14],[19,1,20,2],[19,3,19,9],[19,10,19,16],[19,23,19,29],[20,23,20,29],[21,23,21,27],[17,23,17,25],[17,26,17,27],[18,1,18,2],[18,4,18,5],[18,23,18,25],[18,26,18,27],[27,1,28,2],[27,3,27,9],[27,10,27,16],[27,23,27,29],[28,23,28,29],[22,23,22,24],[22,26,22,27],[23,23,23,29],[24,23,24,29],[25,23,25,25],[25,26,25,27],[25,28,25,29],[29,23,29,27],[30,23,30,24],[30,26,30,27],[31,23,31,29],[32,23,32,29],[33,23,33,25],[33,26,33,27],[33,28,33,29],[26,23,26,25],[26,26,26,27],[39,1,39,2],[39,3,39,5],[39,7,39,10],[39,11,39,13],[40,1,41,2],[40,3,40,8],[41,3,41,8],[36,1,36,18],[37,1,37,2],[37,3,37,6],[37,7,37,10],[37,11,37,14],[38,1,38,2],[38,3,38,6],[38,7,38,10],[38,11,38,14],[51,1,51,3],[45,1,45,18],[46,2,46,3],[46,7,46,8],[47,2,47,3],[48,2,48,3],[49,2,49,3],[42,1,43,2],[42,3,42,6],[42,7,42,10],[42,11,42,14],[42,15,42,18],[43,3,43,6],[43,7,43,10],[43,11,43,14],[43,15,43,18]]}
[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,null,null,null,null,null,"作成日：","2023年6月6日",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,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,null,null,null,null,null,null,null,null,null,"T000000000000"]
[null,"ﾌﾘｶﾞﾅ(半角)",null,"ﾌｸｼﾏｹﾝｽｶｶﾞﾜｼｼｮｳﾆﾝﾀﾞﾝ161"]
[null,"住所",null,"〒","962-8502"]
[null,null,null,"福島県須賀川市上人坦１６１"]
[null,"担当者",null,"笠原太郎",null,null,null,"資本金",null,null,null,null,"百万円"]
[null,"ＴＥＬ",null,"0123-45-6789",null,null,null,"ＦＡＸ",null,"1234-56-7890"]
[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,"利用者番号",null,"0123456789"]
[]
[null,"建設業許可 ※必ず添付してください"]
[null,"許可の有無"]
[null,"許可番号",null,"第","0123456789",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,"令和",{"$f":"IF($AA$26=\"\",\"\",TEXT($AA$26,\"e\"))","v":""},"年",{"$f":"IF($AA$26=\"\",\"\",TEXT($AA$26,\"m\"))","v":""},"月",{"$f":"IF($AA$26=\"\",\"\",TEXT($AA$26,\"d\"))","v":""},"日","令和",{"$f":"IF($AC$26=\"\",\"\",TEXT($AC$26,\"e\"))","v":""},"年",{"$f":"IF($AC$26=\"\",\"\",TEXT($AC$26,\"m\"))","v":""},"月",{"$f":"IF($AC$26=\"\",\"\",TEXT($AC$26,\"d\"))","v":""},"日",null,null,null,null,null,null,{"$f":"IF(E21=\"\",\"\",\"自　\"&D21&E21&F21&G21&H21&I21&J21&\"　～　至　\"&K21&L21&M21&N21&O21&P21&Q21)","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D21=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&E21&\".\"&G21&\".\"&I21)),\"\",DATEVALUE(\"H\"&E21&\".\"&G21&\".\"&I21)),IF(ISERROR(DATEVALUE(\"R\"&E21&\".\"&G21&\".\"&I21)),\"\",DATEVALUE(\"R\"&E21&\".\"&G21&\".\"&I21)))","v":""},null,"～",{"$f":"IF(K21=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&L21&\".\"&N21&\".\"&P21)),\"\",DATEVALUE(\"H\"&L21&\".\"&N21&\".\"&P21)),IF(ISERROR(DATEVALUE(\"R\"&L21&\".\"&N21&\".\"&P21)),\"\",DATEVALUE(\"R\"&L21&\".\"&N21&\".\"&P21)))","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西暦(kintone)"]
[]
[null,null,null,"自",null,null,null,null,null,null,"至",null,null,null,null,null,null,null,null,null,null,null,null,"和暦表示"]
[null,null,null,"令和",{"$f":"IF($AA$34=\"\",\"\",TEXT($AA$34,\"e\"))","v":""},"年",{"$f":"IF($AA$34=\"\",\"\",TEXT($AA$34,\"m\"))","v":""},"月",{"$f":"IF($AA$34=\"\",\"\",TEXT($AA$34,\"d\"))","v":""},"日","令和",{"$f":"IF($AC$34=\"\",\"\",TEXT($AC$34,\"e\"))","v":""},"年",{"$f":"IF($AC$34=\"\",\"\",TEXT($AC$34,\"m\"))","v":""},"月",{"$f":"IF($AC$34=\"\",\"\",TEXT($AC$34,\"d\"))","v":""},"日",null,null,null,null,null,null,{"$f":"IF(E29=\"\",\"\",\"自　\"&D29&E29&F29&G29&H29&I29&J29&\"　～　至　\"&K29&L29&M29&N29&O29&P29&Q29)","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&E29&\".\"&G29&\".\"&I29)),\"\",DATEVALUE(\"H\"&E29&\".\"&G29&\".\"&I29)),IF(ISERROR(DATEVALUE(\"R\"&E29&\".\"&G29&\".\"&I29)),\"\",DATEVALUE(\"R\"&E29&\".\"&G29&\".\"&I29)))","v":""},null,"～",{"$f":"IF(K29=\"平成\",IF(ISERROR(DATEVALUE(\"H\"&L29&\".\"&N29&\".\"&P29)),\"\",DATEVALUE(\"H\"&L29&\".\"&N29&\".\"&P29)),IF(ISERROR(DATEVALUE(\"R\"&L29&\".\"&N29&\".\"&P29)),\"\",DATEVALUE(\"R\"&L29&\".\"&N29&\".\"&P29)))","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西暦(kintone)"]
[]
[]
[null,"保険等情報"]
[null,"保険の名称",null,"第三者工事保険",null,null,null,"労災保険/雇用保険",null,null,null,"労災上積保険"]
[null,"加入状況"]
[null,"補償金額",null,null,null,null,"万円",null,null,null,null,null,null,null,"万円"]
[null,"健康保険\n加入有無",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,"末日(翌月5日必着)",null,null,"    支払日：",null,"　手形 翌月末日／振込 翌月末日"]
[null,null,"材工共：",null,"60万以上　手形 50％(サイト90日)　振込50％"]
[null,null,"納　材：",null,"30万以上　手形100％(サイト120日）"]
[null,null,"リース：",null,"30万以上　手形100％(サイト120日)"]
[]
[null,{"$f":"\"ver:\" & 管理者画面!G2","v":"ver:20230710"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"笠原工業株式会社"]

{"sheet":"顧客管理","index":3,"n_rows":2,"n_cols":151,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["顧客コード","社名（本社）","郵便番号","住所","TEL","FAX","備考","ﾌﾘｶﾞﾅ(半角ｶﾀｶﾅ）","評点","前","代表者","資本金","設立年","設立月","決算期","請求締日","支払締日","業種","仕入先コード","後","最新稟議決済日","業種コード","許可有無","「特」業種[土]","「特」業種[建]","「特」業種[大]","「特」業種[左]","「特」業種[と]","「特」業種[石]","「特」業種[屋]","「特」業種[電]","「特」業種[管]","「特」業種[タ]","「特」業種[鋼]","「特」業種[筋]","「特」業種[舗]","「特」業種[しゅ]","「特」業種[板]","「特」業種[ガ]","「特」業種[塗]","「特」業種[防]","「特」業種[内]","「特」業種[機]","「特」業種[絶]","「特」業種[通]","「特」業種[園]","「特」業種[井]","「特」業種[具]","「特」業種[水]","「特」業種[消]","「特」業種[清]","「特」業種[解]","特般[特]","特般[般]","許可番号","特建設業許可自","特建設業許可至","「般」業種[土]","「般」業種[建]","「般」業種[大]","「般」業種[左]","「般」業種[と]","「般」業種[石]","「般」業種[屋]","「般」業種[電]","「般」業種[管]","「般」業種[タ]","「般」業種[鋼]","「般」業種[筋]","「般」業種[舗]","「般」業種[しゅ]","「般」業種[板]","「般」業種[ガ]","「般」業種[塗]","「般」業種[防]","「般」業種[内]","「般」業種[機]","「般」業種[絶]","「般」業種[通]","「般」業種[園]","「般」業種[井]","「般」業種[具]","「般」業種[水]","「般」業種[消]","「般」業種[清]","「般」業種[解]","申請月商額","申請極度額","決定極度額","仕入売上の品種等","取引高の見通し","振込日","手形日","起算日","サイト","基準額","振込","手形","基準額無し、基準額以下","委託判定[製造委託]","委託判定[修理委託]","委託判定[情報作成委託]","委託判定[役務提供委託]","委託判定[非該当]","添付書類[会社案内]","添付書類[経歴書]","添付書類[信用調査]","添付書類[建設業許可証]","第三者工事保険","保障金額（第三者）","労災保険/雇用保険","健康保険/厚生年金","労災上積保険","保証金額（労災上積）","営業所名称","厚生年金保険番号","雇用保険番号","支払条件チェック[材工共(60万以上半金半手)]","支払条件チェック[納材・リース(30万以上手形100%)]","支払条件チェック[労務費・設計料(振込100%)]","安全協力会費","銀行コード","銀行名","支店コード","支店名","預金種別","口座番号","ふりがな","口座名義人","健康保険番号","許可区分","取引開始の動機","TDBコード","般建設業許可自","般建設業許可至","住所ﾌﾘｶﾞﾅ（半角ｶﾀｶﾅ）","振込支払月","手形支払月","カテゴリー","特","般","下請該当","製造委託","修理委託","情報成果物作成委託","役務提供委託","支払条件","仕入先でんさいチェック","利用者番号","建設業法","インボイス登録番号"]
[null,{"$f":"IF(入力表!D5=\"\",\"\",入力表!D5)","v":""},{"$f":"IF(入力表!E7=\"\",\"\",入力表!E7)","v":""},{"$f":"IF(入力表!D8=\"\",\"\",入力表!D8)","v":""},{"$f":"IF(入力表!D10=\"\",\"\",入力表!D10)","v":""},{"$f":"IF(入力表!J10=\"\",\"\",入力表!J10)","v":""},{"$f":"IF(仕入先取引稟議書!B42=\"\",\"\",仕入先取引稟議書!B42)","v":""},{"$f":"IF(入力表!D4=\"\",\"\",入力表!D4)","v":""},{"$f":"IF(仕入先取引稟議書!B37=\"\",\"\",仕入先取引稟議書!B37)","v":""},null,{"$f":"IF(入力表!D9=\"\",\"\",入力表!D9)","v":""},{"$f":"ROUNDDOWN(入力表!J9,1)","v":0},null,null,null,null,{"$f":"IF(仕入先取引稟議書!L30=\"\",\"\",仕入先取引稟議書!L30)","v":""},null,{"$f":"IF(仕入先取引稟議書!B5=\"\",\"\",仕入先取引稟議書!B5)","v":""},null,null,null,"有",null,null,null,null,1,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,{"$f":"IF(入力表!E19=\"\",\"\",入力表!E19)","v":""},{"$f":"IF(入力表!X23=\"\",\"\",TEXT(入力表!X23,\"YYYY-MM-DD\"))","v":""},{"$f":"IF(入力表!AA23=\"\",\"\",TEXT(入力表!AA23,\"YYYY-MM-DD\"))","v":""},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,{"$f":"仕入先取引稟議書!E38","v":0},{"$f":"仕入先取引稟議書!G38","v":0},{"$f":"仕入先取引稟議書!I38","v":0},{"$f":"IF(仕入先取引稟議書!B40=\"\",\"\",仕入先取引稟議書!B40)","v":""},{"$f":"IF(仕入先取引稟議書!B41=\"\",\"\",仕入先取引稟議書!B41)","v":""},{"$f":"仕入先取引稟議書!Q30","v":0},{"$f":"仕入先取引稟議書!Y30","v":0},{"$f":"仕入先取引稟議書!N34","v":0},{"$f":"仕入先取引稟議書!R34","v":0},{"$f":"仕入先取引稟議書!L32","v":0},{"$f":"仕入先取引稟議書!S30","v":0},{"$f":"仕入先取引稟議書!AA30","v":0},{"$f":"IF(仕入先取引稟議書!E32=\"\",\"\",仕入先取引稟議書!E32)","v":""},null,null,null,null,1,null,null,null,null,"未選択",{"$f":"入力表!D40","v":0},"未選択","未選択","未選択",{"$f":"入力表!L40","v":0},{"$f":"IF(入力表!D44=\"\",\"\",入力表!D44)","v":""},{"$f":"IF(入力表!L44=\"\",\"\",入力表!L44)","v":""},{"$f":"IF(入力表!P44=\"\",\"\",入力表!P44)","v":""},null,null,null,"無",null,{"$f":"IF(入力表!F11=\"\",\"\",入力表!F11)","v":""},null,{"$f":"IF(入力表!L11=\"\",\"\",入力表!L11)","v":""},"普通",{"$f":"IF(入力表!L12=\"\",\"\",入力表!L12)","v":""},{"$f":"IF(入力表!F13=\"\",\"\",入力表!F13)","v":""},{"$f":"IF(入力表!F14=\"\",\"\",入力表!F14)","v":""},{"$f":"IF(入力表!H44=\"\",\"\",入力表!H44)","v":""},"無",{"$f":"IF(仕入先取引稟議書!B39=\"\",\"\",仕入先取引稟議書!B39)","v":""},null,{"$f":"IF(入力表!X31=\"\",\"\",TEXT(入力表!X31,\"YYYY-MM-DD\"))","v":""},{"$f":"IF(入力表!AA31=\"\",\"\",TEXT(入力表!AA31,\"YYYY-MM-DD\"))","v":""},{"$f":"IF(入力表!D6=\"\",\"\",入力表!D6)","v":""},{"$f":"IF(仕入先取引稟議書!O30=\"\",\"\",仕入先取引稟議書!O30)","v":""},{"$f":"IF(仕入先取引稟議書!W30=\"\",\"\",仕入先取引稟議書!W30)","v":""},"工建","","","非該当","","","","","",null,{"$f":"IF(入力表!L15=\"\",\"\",入力表!L15)","v":""},"非該当",{"$f":"IF(入力表!Q5=\"\",\"\",入力表!Q5)","v":""}]

{"sheet":"ヘルプ","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["「セキュリティの警告」メッセージが出た場合は以下の手順で対応"]
["　「コンテンツの有効化」をクリック→次の画面で「はい（Y）」をクリック"]

{"sheet":"管理者画面","index":5,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"工建事業本部取引調査表",null,null,null,null,20230710,"版"]
[]
[]
[]
[null,null,"パスワード"]