const _ = require('lodash')
const Excel = require('exceljs')
let workbook= new Excel.Workbook()
workbook.xlsx.readFile('./rece.xlsx')
.then(()=>{
  let sh=workbook.getWorksheet(1)

  _.range(2,29872).forEach((x)=>{
    let t=sh.getCell(x,1).value
    let seikyu=sh.getCell(x,2).value
    let henkan=sh.getCell(x,3).value
    let sa=seikyu - henkan
    switch(t){
      case 'ア':
        switch(seikyu > 84200) {
          case true:
            sh.getCell(x,6).value=0.99
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case 'イ':
        switch(seikyu > 55800) {
          case true:
            sh.getCell(x,6).value=0.99
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case 'ウ':
        switch(seikyu > 26700) {
          case true:
            sh.getCell(x,6).value=0.99
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case 'エ':
        switch(seikyu*3 > 5760) {
          case true:
            sh.getCell(x,6).value=1
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case 'オ':
        switch(seikyu*3 > 3540) {
          case true:
            sh.getCell(x,6).value=1
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case '現役並み':
        switch(sa > 26700) {
          case true:
            sh.getCell(x,6).value=0.99
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case '一般':
        switch(sa > 4440) {
          case true:
            sh.getCell(x,6).value=1
            break
          default:
            sh.getCell(x,6).value=0.9
        }
        break
      case '低所得Ⅰ':
        switch(sa > 2460) {
          case true:
            sh.getCell(x,6).value=1
            break
          default:
            sh.getCell(x,6).value=0.9
        }
        break
      case '低所得Ⅱ':
        switch(sa > 1500) {
          case true:
            sh.getCell(x,6).value=1
            break
          default:
            sh.getCell(x,6).value=0.9
        }
        break
      case 'A上位所得者':
        switch(seikyu > 50000) {
          case true:
            sh.getCell(x,6).value=0.99
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case 'B一般':
        switch(seikyu > 26700) {
          case true:
            sh.getCell(x,6).value=0.99
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      case 'C低所得者':
        switch(seikyu*3 > 3540) {
          case true:
            sh.getCell(x,6).value=1
            break
          default:
            sh.getCell(x,6).value=0.7
        }
        break
      default:
        sh.getCell(x,6).value=0.7
    }
  })
  // sh.getColumn(6).numFmt='0.00'
  workbook.xlsx.writeFile('./test.xlsx')
  .then(()=>{
    console.log('done!')
  })
})