"
]]>
',[Sheet Names])
]]>
XLSX_FolderImport (67)
C:\Users\ka769397\OneDrive - Sprint\TEMPORARY\00-Temp Scheduling Folder\Test\099\Powertax Summary.xlsx|||Combined Report
Create
Powertax Summary.xlsx
Table=Combined Report
XLSX_SheetReader (76)
Container 54
C:\Users\ka769397\OneDrive - Sprint\TEMPORARY\00-Temp Scheduling Folder\Test\099
Powertax BU *.xlsx
dir C:\Users\ka769397\OneDrive - Sprint\TEMPORARY\00-Temp Scheduling Folder\Test\099\Powertax BU *.xlsx
Add Sheet Name
"
]]>
'
]]>
Container 46
Create Summary By Year
C:\Users\ka769397\OneDrive - Sprint\TEMPORARY\00-Temp Scheduling Folder\Test\099\Powertax Summary.xlsx|||Summary
Create
Powertax Summary.xlsx
Table=Summary
Create Depreciation Schedule Tab
Error
[tax_year] = 2018
Simple
=
tax_year
True
fixed
2019-12-26 10:01:17
0
2018
2019-12-26 10:01:17
2019-12-26 10:01:17
[tax_year] = 2018
Warning
All
ByName
C:\Users\ka769397\OneDrive - Sprint\TEMPORARY\00-Temp Scheduling Folder\Test\099\Powertax Summary.xlsx|||DeprSchedule
Create
Powertax Summary.xlsx
Table=DeprSchedule
Create List of Tax Classes to be used by VBA code
Unique: Tax_Class_Number
C:\Users\ka769397\OneDrive - Sprint\TEMPORARY\00-Temp Scheduling Folder\Test\099\Powertax Summary.xlsx|||TaxClasses
Create
Powertax Summary.xlsx
Table=TaxClasses
Horizontal
Question
Folder Browse (40)
Powertax Report Update v0-8
NoCondition
(Always Run)
UpdateValue
Simple
3
UpdateValue
Simple
11
UpdateValue
Simple
5
Dynamic
{{INPUT}}
41/Directory
Update Directory with Folder Browse
Expression
UpdateValue
Simple
93
Tab
Questions
Tab (26)
FolderBrowse
Select the folder containing the data you wish to process (The workflow will save the output summary to this same folder)
Folder Browse (40)
Macro