2016/11
DISPENSER
932170
SCHWARZ READY MIX
14500 S MERIDIAN AVE
OKLAHOMA CITY
OK
73173-8810
10374.78
Reportable
Oklahoma
2016/12
DISPENSER
932170
SCHWARZ READY MIX
14500 S MERIDIAN AVE
OKLAHOMA CITY
OK
73173-8810
3094.44
Reportable
Oklahoma
2017/03
DISPENSER
932170
SCHWARZ READY MIX
14500 S MERIDIAN AVE
OKLAHOMA CITY
OK
73173-8810
831.79
Reportable
Oklahoma
2016/01
DISPENSER
1177209
DOLESE BROS CO
1727 N MISSISSIPPI
ADA
OK
74820-1610
4.46
Reportable
Pontotoc
2016/05
DISPENSER
1177209
DOLESE BROS CO
1727 N MISSISSIPPI
ADA
OK
74820-1610
942.66
Reportable
Pontotoc
2016/07
DISPENSER
1177209
DOLESE BROS CO
1727 N MISSISSIPPI
ADA
OK
74820-1610
433.08
Reportable
Pontotoc
2017/05
DISPENSER
1177209
DOLESE BROS CO
1727 N MISSISSIPPI
ADA
OK
74820-1610
461.89
Reportable
Pontotoc
2017/07
DISPENSER
1177209
DOLESE BROS CO
1727 N MISSISSIPPI
ADA
OK
74820-1610
23580.09
Reportable
Pontotoc
2016/08
DISPENSER
1148184
M-S CONCRETE/SEPTEC
19524 US HWY 412
COLCORD
OK
74338-3522
1025.64
Reportable
Delaware
2016/09
DISPENSER
4219268
EAGLE REDI MIX CONCRETE LLC
19524 US HWY 412
WEST SILOAM SPRINGS
OK
74338-3522
1593.66
Reportable
Delaware
2016/11
DISPENSER
4219268
EAGLE REDI MIX CONCRETE LLC
19524 US HWY 412
WEST SILOAM SPRINGS
OK
74338-3522
12682.94
Reportable
Delaware
2017/02
DISPENSER
4219268
EAGLE REDI MIX CONCRETE LLC
19524 US HWY 412
WEST SILOAM SPRINGS
OK
74338-3522
2425.87
Reportable
Delaware
2017/10
DISPENSER
4219268
EAGLE REDI MIX CONCRETE LLC
19524 US HWY 412
WEST SILOAM SPRINGS
OK
74338-3522
17005.23
Reportable
Delaware
2017/11
DISPENSER
4219268
EAGLE REDI MIX CONCRETE LLC
19524 US HWY 412
WEST SILOAM SPRINGS
OK
74338-3522
922.47
Reportable
Delaware
2016/12
DISPENSER
1174438
H C RUSTIN CORP
2402 E WASHINGTON
IDABEL
OK
74745-5431
1789.65
Reportable
McCurtain
2017/03
DISPENSER
1174438
H C RUSTIN CORP
2402 E WASHINGTON
IDABEL
OK
74745-5431
1523.41
Reportable
McCurtain
2017/05
DISPENSER
1174438
H C RUSTIN CORP
2402 E WASHINGTON
IDABEL
OK
74745-5431
1104.93
Reportable
McCurtain
2017/06
DISPENSER
1174438
H C RUSTIN CORP
2402 E WASHINGTON
IDABEL
OK
74745-5431
14613.74
Reportable
McCurtain
2017/07
DISPENSER
1174438
H C RUSTIN CORP
2402 E WASHINGTON
IDABEL
OK
74745-5431
2350.03
Reportable
McCurtain
2016/11
DISPENSER
935216
SCHWARZ READY MIX
2610 12TH AVE NW
NORMAN
OK
73069-8535
10318.34
Reportable
[Null]
2016/12
DISPENSER
935216
SCHWARZ READY MIX
2610 12TH AVE NW
NORMAN
OK
73069-8535
2973.16
Reportable
[Null]
2016/04
DISPENSER
935214
SCHWARZ READY MIX
4004 S KELLY AVE
EDMOND
OK
73013-3800
42.49
Reportable
Oklahoma
2017/01
DISPENSER
935214
SCHWARZ READY MIX
4004 S KELLY AVE
EDMOND
OK
73013-3800
10853.91
Reportable
Oklahoma
2017/02
DISPENSER
935214
SCHWARZ READY MIX
4004 S KELLY AVE
EDMOND
OK
73013-3800
2662.31
Reportable
Oklahoma
2017/04
DISPENSER
935214
SCHWARZ READY MIX
4004 S KELLY AVE
EDMOND
OK
73013-3800
2021.4
Reportable
Oklahoma
2016/05
DISPENSER
3299063
DOLESE BROS CO
4989 S US HIGHWAY 69
MCALESTER
OK
74501-6360
306.48
Reportable
Pittsburg
2017/02
DISPENSER
3299063
DOLESE BROS CO
4989 S US HIGHWAY 69
MCALESTER
OK
74501-6360
16722.75
Reportable
Pittsburg
2017/03
DISPENSER
3299063
DOLESE BROS CO
4989 S US HIGHWAY 69
MCALESTER
OK
74501-6360
963.33
Reportable
Pittsburg
2016/10
DISPENSER
943362
CORESLAB STRUCTURES (OKLA) INC
817 SE 55TH ST
OKLAHOMA CITY
OK
73129-5600
18485.11
Reportable
Oklahoma
2016/11
DISPENSER
943362
CORESLAB STRUCTURES (OKLA) INC
817 SE 55TH ST
OKLAHOMA CITY
OK
73129-5600
1118
Reportable
Oklahoma
2017/03
DISPENSER
943362
CORESLAB STRUCTURES (OKLA) INC
817 SE 55TH ST
OKLAHOMA CITY
OK
73129-5600
4563.33
Reportable
Oklahoma
2017/04
DISPENSER
943362
CORESLAB STRUCTURES (OKLA) INC
817 SE 55TH ST
OKLAHOMA CITY
OK
73129-5600
204.7
Reportable
Oklahoma
2017/05
DISPENSER
943362
CORESLAB STRUCTURES (OKLA) INC
817 SE 55TH ST
OKLAHOMA CITY
OK
73129-5600
199.26
Reportable
Oklahoma
2017/06
DISPENSER
943362
CORESLAB STRUCTURES (OKLA) INC
817 SE 55TH ST
OKLAHOMA CITY
OK
73129-5600
964.62
Reportable
Oklahoma
UniqueValue
This creates Record ID
Note: if address changes in any way, a new record ID would be created. Really depends on clean data for address.
Unique Value
Creates proper date formatting for ease of use
Date = datetimeparse([G/R Yr/Mo],"%Y/%m")
Current Return Year = DateTimeNow()
Di...
Sorts data by Date and record ID
Record ID - Ascending
Date - Ascending
[CY/PY] = "Prior Return Year"
Simple
=
CY/PY
True
fixed
2018-12-07 10:58:21
0
Prior Return Year
2018-12-07 10:58:21
2018-12-07 10:58:21
All data for prior year, current year.
Note: This is hardcoded.
[CY/PY] = "Prior Return Year"
Gets prior year book value
Creates unique list of all possible record IDs
Join Book value to clean template created in prior step
Warning
All
ByName
Creates Right Join
Establishes minimum date for each record id, so we know which dates to fill in.
Adds in Minimum Date for each year so we know which values to fill in with prior book value
Adds in prior book value to fill in where necessary
Fills in book value where necessary
Book Value = if [Date]<[Min_Date] then [Prior Book Value] else [Book Value] endi...
Drops unnecessary fields
C:\Users\cbennett022\AppData\Local\Temp\Engine_37524_95dcedaeaa014ab08ce9169b82dc98af_\Engine_16896_54edf9dea235427eaf775431494fc55f_.yxdb
Date Gen
Date
10
"2017-01-01"
[Date Gen]<="2017-12-01"
datetimeadd([date gen],1,"months")
Creates sets of records with dates for each ID
Note: this is hardcoded. If years change, would need to change this value.
Warning
All
ByName
Horizontal
Cbennett022V2