search

NahuelSovos98 / STS_InternalReviewBot

0 stars 0 forks source link

SC - State Balancing #30

Closed NahuelSovos98 closed 1 year ago

NahuelSovos98 commented 1 year ago

Steps:

  1. Download Detail worksheet
  2. Paste Detail worksheet into the SC tool file
  3. Do screen scraping in Local Taxes tab (Taxsolver) - Output: List of GROSS for each county
    • Apply this regex: (COUNTY LIST) [\d.\,]+ [\d.\,]+
    • Replace COUNTY LIST for this config value and separate by pipe : StateBalancing_SC_CountyList
  4. Make a dictionary of GROSS with the List of Gross (separate each match by blank space, the 1st item is county, the 3hd item is Gross)
  5. Read Tool table from F1 cell
  6. For each row in table
    • Look for the TS gross using the dictionary.
    • Paste it into the table (in TS Gross column)
    • TS Gross = Dictionary (County name)
    • TS Tax column = TS Gross * 0.01
    • Diff column = Tax - TS Tax
    • If (Diff <> 0) then add to DictionaryCountyDiff (Key: County ; Value: Diff)
    • End for each
  7. Check DictionaryCountyDiff if it has any value
  8. If DictionaryCountyDiff.Count <> 0, then throw BE: The following county list has difference: COUNTY NAME + Difference

Think about the best way to report this message in the Review sheet