Prevent merging query multiple times

Craigc3814

Board Regular
Joined
Mar 7, 2016
Messages
211
The current code that I have is FUNCTIONAL (thanks in large part to help from here I apologize for forgetting your @ as you were a tremendous help). What I would like to do is speed up the code that I have for future reference as I assume I will be working on this project even more now that I have shown management that what I did works.

The portion of the code in Bold/Italic below is what I am referencing. I am merging this query 3 times for one particular calculation. If I could instead do some form of a table reference rather than merging I assume the code will run faster? I am working on changing the source data around (cannot share the actual data) so that I can post it with this.


let
Source = Excel.CurrentWorkbook(){[Name="tblProjects"]}[Content],
allColumns.Type = Table.TransformColumnTypes(Source,{{"Budget ID", type any}, {"Project Name", type text}, {"Renamed", type text}, {"Division/Department", type text}, {"Project Manager", type text}, {"Spending Geometry", type text}, {"Status", type text}, {"Est. Start Date", type date}, {"Est. End Date", type date}, {"EAC", type number}}),
activeProjects.Filter = Table.SelectRows(allColumns.Type, each ([Status] = "Deferred" or [Status] = "Future" or [Status] = "In Progress")),
startDate.Sort = Table.Sort(activeProjects.Filter,{{"Est. Start Date", Order.Ascending}}),
monthsDuration.Add = Table.AddColumn(startDate.Sort, "Duration", each ([Est. End Date]-[Est. Start Date])/30.5),
duration.Type = Table.TransformColumnTypes(monthsDuration.Add,{{"Duration", Int64.Type}}),
today.Add = Table.AddColumn(duration.Type, "Today's Date", each DateTime.LocalNow()),
today.Type = Table.TransformColumnTypes(today.Add,{{"Today's Date", type date}}),
#"Calculated Start of Month1" = Table.TransformColumns(today.Type,{{"Today's Date", Date.StartOfMonth, type date}}),
monthsLeft.Add = Table.AddColumn(#"Calculated Start of Month1", "Months Remaining", each if[Est. Start Date]<[#"Today's Date"] then ([Est. End Date]-[#"Today's Date"])/30.5 else [Duration]),
monthsLeft.Type = Table.TransformColumnTypes(monthsLeft.Add,{{"Months Remaining", Int64.Type}}),
pctCPt.Add = Table.AddColumn(monthsLeft.Type, "Percentage Complete", each if 1-([Months Remaining]/[Duration]) < 0 then 0 else 1-([Months Remaining]/[Duration])),
pctCpt.Type = Table.TransformColumnTypes(pctCPt.Add,{{"Percentage Complete", Percentage.Type}}),
pctCpt.Roundoff = Table.TransformColumns(pctCpt.Type,{{"Percentage Complete", each Number.Round(_, 2), Percentage.Type}}),
#"Filtered Rows1" = Table.SelectRows(pctCpt.Roundoff, each [Months Remaining] > 0),
monthsLeft.List = Table.TransformColumns(#"Filtered Rows1", {"Months Remaining", each List.Numbers(_,_,0), type list}),
monthsLeft.ListExpand = Table.ExpandListColumn(monthsLeft.List, "Months Remaining"),
countColumnAdd = Table.AddColumn(monthsLeft.ListExpand, "Instance", each 1),
TableType = Value.Type(Table.AddColumn(countColumnAdd, "Running Count", each null, type number)),
fnGrouping = (MyTable as table) as table =>
let
Source = Table.Buffer(MyTable),
TableType = Value.Type(Table.AddColumn(Source, "Running Count", each null, type number)),
Cumulative = List.Skip(List.Accumulate(Source[Instance],{0},(cumulative,instance) => cumulative & {List.Last(cumulative) + instance})),
RunningCount = Table.FromColumns(Table.ToColumns(Source)&{Cumulative},TableType)
in
RunningCount,
rowsGrouped = Table.Group(countColumnAdd, {"Project Name"}, {{"AllData", fnGrouping, TableType}}),
groupsExpanded = Table.ExpandTableColumn(rowsGrouped, "AllData", {"Budget ID", "Project Manager", "Division/Department", "Spending Geometry", "Status", "Renamed", "EAC", "Current Milestone", "EAC Change Category", "Baseline EAC", "Baseline Milestone", "Est. Start Date", "Est. End Date", "Schedule Change Category", "Duration", "Today's Date", "Months Remaining", "Running Count"}, {"Budget ID", "Project Manager", "Division/Department", "Spending Geometry", "Status", "Renamed", "EAC", "Current Milestone", "EAC Change Category", "Baseline EAC", "Baseline Milestone", "Est. Start Date", "Est. End Date", "Schedule Change Category", "Duration", "Today's Date", "Months Remaining", "Running Count"}),
#"Month Math" = Table.AddColumn(groupsExpanded, "Month Math", each [Running Count]-1),
#"Budget Month" = Table.AddColumn(#"Month Math", "Budget Month", each if[Est. Start Date]<[#"Today's Date"] then Date.AddMonths([#"Today's Date"],[Month Math]) else Date.AddMonths([Est. Start Date],[Month Math])),
#"Calculated End of Month" = Table.TransformColumns(#"Budget Month",{{"Budget Month", Date.EndOfMonth, type date}}),
#"Removed Columns" = Table.RemoveColumns(#"Calculated End of Month",{"Running Count", "Month Math"}),
#"Added Custom" = Table.AddColumn(#"Removed Columns", "Project Month", each ([Budget Month]-[Est. Start Date])/30.5),
#"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"Project Month", Int64.Type}}),
#"Added Custom1" = Table.AddColumn(#"Changed Type", "Percentage Complete", each [Project Month]/[Duration]),
#"Merged Queries" = Table.NestedJoin(#"Added Custom1",{"Budget ID"},Actuals,{"Budget ID"},"Actuals",JoinKind.LeftOuter),
#"Changed Type1" = Table.TransformColumnTypes(#"Merged Queries",{{"Percentage Complete", Percentage.Type}}),
#"Rounded Off" = Table.TransformColumns(#"Changed Type1",{{"Percentage Complete", each Number.Round(_, 3), Percentage.Type}}),
#"Expanded Actuals" = Table.ExpandTableColumn(#"Rounded Off", "Actuals", {"Lifetime Actuals"}, {"Actuals.Lifetime Actuals"}),
#"Replaced Value" = Table.ReplaceValue(#"Expanded Actuals",null,0,Replacer.ReplaceValue,{"Actuals.Lifetime Actuals"}),
#"Added Custom2" = Table.AddColumn(#"Replaced Value", "ETC", each [EAC]-[Actuals.Lifetime Actuals]),
#"Sorted Rows" = Table.Sort(#"Added Custom2",{{"Project Name", Order.Ascending}, {"Project Month", Order.Ascending}}),
#"Added Custom3" = Table.AddColumn(#"Sorted Rows", "Previous Month % Complete", each ([Duration]-[Months Remaining])/[Duration]),
#"Rounded Off1" = Table.TransformColumns(#"Added Custom3",{{"Previous Month % Complete", each Number.Round(_, 3), type number}}),
#"Changed Type2" = Table.TransformColumnTypes(#"Rounded Off1",{{"Previous Month % Complete", Percentage.Type}}),
#"Merged Queries1" = Table.NestedJoin(#"Changed Type2",{"Percentage Complete"},#"Spending Curves",{"Percentage Complete"},"Spending Curves",JoinKind.LeftOuter),
#"Expanded Spending Curves" = Table.ExpandTableColumn(#"Merged Queries1", "Spending Curves", {"Trapezoid Current", "Back Loaded Current", "Front Loaded Current"}, {"Trapezoid Current", "Back Loaded Current", "Front Loaded Current"}),
#"Merged Queries2" = Table.NestedJoin(#"Expanded Spending Curves",{"Previous Month % Complete"},#"Spending Curves",{"Percentage Complete"},"Spending Curves",JoinKind.LeftOuter),
#"Expanded Spending Curves1" = Table.ExpandTableColumn(#"Merged Queries2", "Spending Curves", {"Trapezoid Current", "Back Loaded Current", "Front Loaded Current"}, {"Trapezoid Current.1", "Back Loaded Current.1", "Front Loaded Current.1"}),
#"Added Custom4" = Table.AddColumn(#"Expanded Spending Curves1", "Prev pct Complete", each ([Project Month]-1)/[Duration]),
#"Rounded Off2" = Table.TransformColumns(#"Added Custom4",{{"Prev pct Complete", each Number.Round(_, 3), type number}}),
#"Changed Type3" = Table.TransformColumnTypes(#"Rounded Off2",{{"Prev pct Complete", Percentage.Type}}),
#"Merged Queries3" = Table.NestedJoin(#"Changed Type3",{"Prev pct Complete"},#"Spending Curves",{"Percentage Complete"},"Spending Curves",JoinKind.LeftOuter),
#"Expanded Spending Curves2" = Table.ExpandTableColumn(#"Merged Queries3", "Spending Curves", {"Trapezoid Current", "Back Loaded Current", "Front Loaded Current"}, {"Trapezoid Current.2", "Back Loaded Current.2", "Front Loaded Current.2"}),
#"Added Custom5" = Table.AddColumn(#"Expanded Spending Curves2", "Month Spend", each if [Spending Geometry]="Back-Loaded" then (1/(1-[Back Loaded Current.1]))*([Back Loaded Current]-[Back Loaded Current.2])*[ETC] else if [Spending Geometry]="Linear" then [ETC]/[Months Remaining] else if [Spending Geometry]="Trapezoid" then (1/(1-[Trapezoid Current.1]))*([Trapezoid Current]-[Trapezoid Current.2])*[ETC] else null),
#"Changed Type4" = Table.TransformColumnTypes(#"Added Custom5",{{"Month Spend", type number}})
in
#"Changed Type4"
 

Craigc3814

Board Regular
Joined
Mar 7, 2016
Messages
211
Here is the spending curve table

Percentage CompleteTrapezoid CurrentBack Loaded CurrentFront Loaded Current
0.00%0.00%0.00%
0.10%0.00%0.00%
0.20%0.00%0.00%
0.30%0.00%0.00%
0.40%0.00%0.00%
0.50%0.00%0.00%
0.60%0.00%0.00%
0.70%0.00%0.00%
0.80%0.00%0.04%
0.90%0.00%0.05%
1.00%0.00%0.05%
1.10%0.00%0.06%
1.20%0.00%0.06%
1.30%0.00%0.07%
1.40%0.00%0.07%
1.50%0.00%0.08%
1.60%0.00%0.08%
1.70%0.00%0.08%
1.80%0.01%0.09%
1.90%0.03%0.10%
2.00%0.04%0.11%
2.10%0.06%0.12%
2.20%0.07%0.13%
2.30%0.09%0.14%
2.40%0.10%0.15%
2.50%0.12%0.16%
2.60%0.13%0.17%
2.70%0.15%0.18%
2.80%0.16%0.19%
2.90%0.18%0.20%
3.00%0.19%0.21%
3.10%0.21%0.22%
3.20%0.22%0.23%
3.30%0.24%0.24%
3.40%0.27%0.25%
3.50%0.29%0.27%
3.60%0.32%0.28%
3.70%0.35%0.30%
3.80%0.38%0.31%
3.90%0.41%0.33%
4.00%0.43%0.34%
4.10%0.46%0.36%
4.20%0.49%0.37%
4.30%0.52%0.39%
4.40%0.55%0.40%
4.50%0.57%0.42%
4.60%0.60%0.43%
4.70%0.63%0.45%
4.80%0.66%0.46%
4.90%0.69%0.48%
5.00%0.71%0.49%
5.10%0.76%0.51%
5.20%0.80%0.53%
5.30%0.84%0.55%
5.40%0.88%0.57%
5.50%0.92%0.58%
5.60%0.97%0.60%
5.70%1.01%0.62%
5.80%1.05%0.64%
5.90%1.09%0.66%
6.00%1.13%0.68%
6.10%1.18%0.70%
6.20%1.22%0.72%
6.30%1.26%0.73%
6.40%1.30%0.75%
6.50%1.34%0.77%
6.60%1.39%0.79%
6.70%1.43%0.81%
6.80%1.47%0.84%
6.90%1.52%0.86%
7.00%1.56%0.89%
7.10%1.61%0.91%
7.20%1.65%0.94%
7.30%1.70%0.96%
7.40%1.74%0.99%
7.50%1.79%1.02%
7.60%1.83%1.04%
7.70%1.88%1.07%
7.80%1.92%1.09%
7.90%1.96%1.12%
8.00%2.01%1.14%
8.10%2.05%1.17%
8.20%2.10%1.19%
8.30%2.14%1.22%
8.40%2.18%1.25%
8.50%2.23%1.28%
8.60%2.27%1.31%
8.70%2.31%1.34%
8.80%2.35%1.36%
8.90%2.39%1.39%
9.00%2.44%1.42%
9.10%2.48%1.45%
9.20%2.52%1.48%
9.30%2.56%1.51%
9.40%2.61%1.54%
9.50%2.65%1.57%
9.60%2.69%1.59%
9.70%2.73%1.62%
9.80%2.77%1.65%
9.90%2.82%1.68%
10.00%2.86%1.71%
10.10%2.90%1.72%
10.20%2.94%1.73%
10.30%2.98%1.74%
10.40%3.03%1.76%
10.50%3.07%1.77%
10.60%3.11%1.78%
10.70%3.15%1.79%
10.80%3.19%1.80%
10.90%3.24%1.81%
11.00%3.28%1.82%
11.10%3.32%1.83%
11.20%3.36%1.85%
11.30%3.40%1.86%
11.40%3.45%1.87%
11.50%3.49%1.88%
11.60%3.53%1.89%
11.70%3.57%2.28%
11.80%3.62%2.29%
11.90%3.66%2.30%
12.00%3.71%2.31%
12.10%3.75%2.33%
12.20%3.79%2.34%
12.30%3.84%2.35%
12.40%3.88%2.36%
12.50%3.93%2.37%
12.60%3.97%2.38%
12.70%4.02%2.39%
12.80%4.06%2.40%
12.90%4.11%2.42%
13.00%4.15%2.43%
13.10%4.20%2.44%
13.20%4.24%2.45%
13.30%4.29%2.93%
13.40%4.33%2.97%
13.50%4.37%3.02%
13.60%4.41%3.06%
13.70%4.45%3.10%
13.80%4.50%3.14%
13.90%4.54%3.19%
14.00%4.58%3.23%
14.10%4.62%3.27%
14.20%4.66%3.32%
14.30%4.71%3.36%
14.40%4.75%3.40%
14.50%4.79%3.45%
14.60%4.83%3.49%
14.70%4.87%3.53%
14.80%4.92%3.57%
14.90%4.96%3.62%
15.00%5.00%3.66%
15.10%5.04%3.67%
15.20%5.08%3.68%
15.30%5.13%3.69%
15.40%5.17%3.71%
15.50%5.21%3.72%
15.60%5.25%3.73%
15.70%5.29%3.74%
15.80%5.34%3.75%
15.90%5.38%3.76%
16.00%5.42%3.77%
16.10%5.46%3.78%
16.20%5.50%3.80%
16.30%5.55%3.81%
16.40%5.59%3.82%
16.50%5.63%3.83%
16.60%5.67%3.84%
16.70%5.71%4.47%
16.80%5.76%4.48%
16.90%5.80%4.49%
17.00%5.85%4.50%
17.10%5.89%4.52%
17.20%5.94%4.53%
17.30%5.98%4.54%
17.40%6.03%4.55%
17.50%6.07%4.56%
17.60%6.12%4.57%
17.70%6.16%4.58%
17.80%6.21%4.59%
17.90%6.25%4.61%
18.00%6.29%4.62%
18.10%6.34%4.63%
18.20%6.38%4.64%
18.30%6.43%5.37%
18.40%6.47%5.38%
18.50%6.51%5.39%
18.60%6.55%5.40%
18.70%6.60%5.42%
18.80%6.64%5.43%
18.90%6.68%5.44%
19.00%6.72%5.45%
19.10%6.76%5.46%
19.20%6.81%5.47%
19.30%6.85%5.48%
19.40%6.89%5.49%
19.50%6.93%5.51%
19.60%6.97%5.52%
19.70%7.02%5.53%
19.80%7.06%5.54%
19.90%7.10%5.55%
20.00%7.14%6.34%
20.10%7.18%6.35%
20.20%7.23%6.36%
20.30%7.27%6.37%
20.40%7.31%6.39%
20.50%7.35%6.40%
20.60%7.39%6.41%
20.70%7.44%6.42%
20.80%7.48%6.43%
20.90%7.52%6.44%
21.00%7.56%6.45%
21.10%7.61%6.46%
21.20%7.65%6.48%
21.30%7.69%6.49%
21.40%7.73%6.50%
21.50%7.77%6.51%
21.60%7.82%6.52%
21.70%7.86%7.40%
21.80%7.90%7.47%
21.90%7.95%7.54%
22.00%7.99%7.61%
22.10%8.04%7.69%
22.20%8.08%7.76%
22.30%8.13%7.83%
22.40%8.17%7.90%
22.50%8.21%7.97%
22.60%8.26%8.04%
22.70%8.30%8.11%
22.80%8.35%8.18%
22.90%8.39%8.26%
23.00%8.44%8.33%
23.10%8.48%8.40%
23.20%8.53%8.47%
23.30%8.57%8.54%
23.40%8.61%8.61%
23.50%8.66%8.68%
23.60%8.70%8.76%
23.70%8.74%8.83%
23.80%8.78%8.90%
23.90%8.82%8.97%
24.00%8.87%9.04%
24.10%8.91%9.11%
24.20%8.95%9.19%
24.30%8.99%9.26%
24.40%9.03%9.33%
24.50%9.08%9.40%
24.60%9.12%9.47%
24.70%9.16%9.54%
24.80%9.20%9.62%
24.90%9.24%9.69%
25.00%9.29%9.76%
25.10%9.33%9.84%
25.20%9.37%9.91%
25.30%9.41%9.99%
25.40%9.45%10.07%
25.50%9.50%10.14%
25.60%9.54%10.22%
25.70%9.58%10.30%
25.80%9.62%10.37%
25.90%9.66%10.45%
26.00%9.71%10.52%
26.10%9.75%10.60%
26.20%9.79%10.68%
26.30%9.83%10.75%
26.40%9.87%10.83%
26.50%9.92%10.91%
26.60%9.96%10.98%
26.70%10.00%11.06%
26.80%10.04%11.15%
26.90%10.09%11.23%
27.00%10.13%11.32%
27.10%10.18%11.41%
27.20%10.22%11.49%
27.30%10.27%11.58%
27.40%10.31%11.66%
27.50%10.36%11.75%
27.60%10.40%11.84%
27.70%10.45%11.92%
27.80%10.49%12.01%
27.90%10.54%12.10%
28.00%10.58%12.18%
28.10%10.63%12.27%
28.20%10.67%12.35%
28.30%10.71%12.44%
28.40%10.76%12.53%
28.50%10.80%12.61%
28.60%10.84%12.70%
28.70%10.88%12.78%
28.80%10.92%12.87%
28.90%10.97%12.96%
29.00%11.01%13.04%
29.10%11.05%13.13%
29.20%11.09%13.21%
29.30%11.13%13.30%
29.40%11.18%13.38%
29.50%11.22%13.47%
29.60%11.26%13.56%
29.70%11.30%13.64%
29.80%11.34%13.73%
29.90%11.39%13.81%
30.00%11.43%13.90%
30.10%11.47%13.99%
30.20%11.51%14.08%
30.30%11.55%14.17%
30.40%11.60%14.26%
30.50%11.64%14.36%
30.60%11.68%14.45%
30.70%11.72%14.54%
30.80%11.76%14.63%
30.90%11.81%14.72%
31.00%11.85%14.81%
31.10%11.89%14.90%
31.20%11.93%14.99%
31.30%11.97%15.09%
31.40%12.02%15.18%
31.50%12.06%15.27%
31.60%12.10%15.36%
31.70%12.14%15.45%
31.80%12.19%15.55%
31.90%12.23%15.65%
32.00%12.28%15.75%
32.10%12.32%15.86%
32.20%12.37%15.96%
32.30%12.41%16.06%
32.40%12.46%16.16%
32.50%12.50%16.26%
32.60%12.54%16.36%
32.70%12.59%16.46%
32.80%12.63%16.56%
32.90%12.68%16.67%
33.00%12.72%16.77%
33.10%12.77%16.87%
33.20%12.81%16.97%
33.30%12.86%17.07%
33.40%12.90%17.17%
33.50%12.94%17.27%
33.60%12.98%17.37%
33.70%13.03%17.47%
33.80%13.07%17.57%
33.90%13.11%17.67%
34.00%13.15%17.77%
34.10%13.19%17.87%
34.20%13.24%17.98%
34.30%13.28%18.08%
34.40%13.32%18.18%
34.50%13.36%18.28%
34.60%13.40%18.38%
34.70%13.45%18.48%
34.80%13.49%18.58%
34.90%13.53%18.68%
35.00%13.57%18.78%
35.10%13.61%18.79%
35.20%13.66%18.80%
35.30%13.70%18.81%
35.40%13.74%18.83%
35.50%13.78%18.84%
35.60%13.82%18.85%
35.70%13.87%18.86%
35.80%13.91%18.87%
35.90%13.95%18.88%
36.00%13.99%18.89%
36.10%14.03%18.90%
36.20%14.08%18.92%
36.30%14.12%18.93%
36.40%14.16%18.94%
36.50%14.20%18.95%
36.60%14.24%18.96%
36.70%14.29%20.57%
36.80%14.32%20.69%
36.90%14.35%20.80%
37.00%14.37%20.92%
37.10%14.40%21.04%
37.20%14.43%21.15%
37.30%14.46%21.27%
37.40%14.49%21.39%
37.50%14.52%21.51%
37.60%14.55%21.62%
37.70%14.58%21.74%
37.80%14.61%21.86%
37.90%14.64%21.97%
38.00%14.67%22.09%
38.10%14.70%22.21%
38.20%14.73%22.32%
38.30%14.76%22.44%
38.40%14.78%22.55%
38.50%14.79%22.67%
38.60%14.80%22.78%
38.70%14.82%22.90%
38.80%14.83%23.01%
38.90%14.85%23.13%
39.00%14.86%23.24%
39.10%14.87%23.36%
39.20%14.89%23.47%
39.30%14.90%23.59%
39.40%14.92%23.70%
39.50%14.93%23.82%
39.60%14.94%23.93%
39.70%14.96%24.05%
39.80%14.97%24.16%
39.90%14.99%24.28%
40.00%15.00%24.39%
40.10%15.03%24.51%
40.20%15.07%24.63%
40.30%15.10%24.75%
40.40%15.14%24.87%
40.50%15.17%24.99%
40.60%15.20%25.11%
40.70%15.24%25.23%
40.80%15.27%25.35%
40.90%15.31%25.46%
41.00%15.34%25.58%
41.10%15.37%25.70%
41.20%15.41%25.82%
41.30%15.44%25.94%
41.40%15.47%26.06%
41.50%15.51%26.18%
41.60%15.54%26.30%
41.70%15.58%26.42%
41.80%15.65%26.55%
41.90%15.72%26.69%
42.00%15.79%26.82%
42.10%15.86%26.95%
42.20%15.94%27.08%
42.30%16.01%27.22%
42.40%16.08%27.35%
42.50%16.15%27.48%
42.60%16.22%27.61%
42.70%16.30%27.75%
42.80%16.37%27.88%
42.90%16.44%28.01%
43.00%16.51%28.14%
43.10%16.58%28.28%
43.20%16.66%28.41%
43.30%16.73%28.54%
43.40%16.83%28.67%
43.50%16.93%28.80%
43.60%17.03%28.93%
43.70%17.14%29.06%
43.80%17.24%29.18%
43.90%17.34%29.31%
44.00%17.44%29.44%
44.10%17.54%29.57%
44.20%17.64%29.70%
44.30%17.75%29.83%
44.40%17.85%29.96%
44.50%17.95%30.09%
44.60%18.05%30.21%
44.70%18.15%30.34%
44.80%18.25%30.47%
44.90%18.36%30.60%
45.00%18.46%30.73%
45.10%18.59%30.86%
45.20%18.73%31.00%
45.30%18.86%31.13%
45.40%19.00%31.27%
45.50%19.14%31.40%
45.60%19.27%31.53%
45.70%19.41%31.67%
45.80%19.54%31.80%
45.90%19.68%31.94%
46.00%19.81%32.07%
46.10%19.95%32.21%
46.20%20.08%32.34%
46.30%20.22%32.47%
46.40%20.36%32.61%
46.50%20.49%32.74%
46.60%20.63%32.88%
46.70%20.76%33.01%
46.80%20.93%33.15%
46.90%21.10%33.29%
47.00%21.27%33.43%
47.10%21.44%33.57%
47.20%21.61%33.70%
47.30%21.78%33.84%
47.40%21.95%33.98%
47.50%22.12%34.12%
47.60%22.29%34.26%
47.70%22.46%34.40%
47.80%22.63%34.54%
47.90%22.80%34.68%
48.00%22.97%34.81%
48.10%23.14%34.95%
48.20%23.31%35.09%
48.30%23.64%35.37%
48.40%23.81%35.51%
48.50%23.98%35.66%
48.60%24.15%35.80%
48.70%24.32%35.94%
48.80%24.49%36.09%
48.90%24.66%36.23%
49.00%24.83%36.37%
49.10%25.00%36.52%
49.20%25.17%36.66%
49.30%25.34%36.81%
49.40%25.51%36.95%
49.50%25.68%37.09%
49.60%25.85%37.24%
49.70%26.02%37.38%
49.80%26.19%37.52%
49.90%26.36%37.67%
50.00%26.53%37.81%
50.10%26.69%37.96%
50.20%26.86%38.11%
50.30%27.03%38.25%
50.40%27.20%38.40%
50.50%27.37%38.55%
50.60%27.54%38.70%
50.70%27.71%38.85%
50.80%27.88%39.00%
50.90%28.05%39.14%
51.00%28.22%39.29%
51.10%28.39%39.44%
51.20%28.56%39.59%
51.30%28.73%39.74%
51.40%28.90%39.89%
51.50%29.07%40.03%
51.60%29.24%40.18%
51.70%29.41%40.33%
51.80%29.59%40.49%
51.90%29.77%40.66%
52.00%29.95%40.82%
52.10%30.13%40.98%
52.20%30.31%41.14%
52.30%30.49%41.31%
52.40%30.67%41.47%
52.50%30.85%41.63%
52.60%31.03%41.79%
52.70%31.21%41.96%
52.80%31.39%42.12%
52.90%31.57%42.28%
53.00%31.75%42.44%
53.10%31.93%42.61%
53.20%32.11%42.77%
53.30%32.29%42.93%
53.40%32.46%43.09%
53.50%32.63%43.25%
53.60%32.80%43.40%
53.70%32.97%43.56%
53.80%33.14%43.72%
53.90%33.31%43.88%
54.00%33.47%44.03%
54.10%33.64%44.19%
54.20%33.81%44.35%
54.30%33.98%44.51%
54.40%34.15%44.66%
54.50%34.32%44.82%
54.60%34.49%44.98%
54.70%34.66%45.14%
54.80%34.83%45.29%
54.90%35.00%45.45%
55.00%35.17%45.61%
55.10%35.34%45.77%
55.20%35.51%45.94%
55.30%35.68%46.10%
55.40%35.85%46.26%
55.50%36.02%46.42%
55.60%36.19%46.59%
55.70%36.36%46.75%
55.80%36.53%46.91%
55.90%36.69%47.08%
56.00%36.86%47.24%
56.10%37.03%47.40%
56.20%37.20%47.57%
56.30%37.37%47.73%
56.40%37.54%47.89%
56.50%37.71%48.05%
56.60%37.88%48.22%
56.70%38.05%48.38%
56.80%38.23%48.55%
56.90%38.41%48.72%
57.00%38.59%48.90%
57.10%38.77%49.07%
57.20%38.95%49.24%
57.30%39.13%49.41%
57.40%39.31%49.59%
57.50%39.49%49.76%
57.60%39.67%49.93%
57.70%39.85%50.10%
57.80%40.03%50.28%
57.90%40.21%50.45%
58.00%40.39%50.62%
58.10%40.57%50.79%
58.20%40.75%50.97%
58.30%40.93%51.22%
58.40%41.10%51.39%
58.50%41.27%51.56%
58.60%41.44%51.74%
58.70%41.61%51.91%
58.80%41.78%52.08%
58.90%41.95%52.25%
59.00%42.12%52.43%
59.10%42.29%52.60%
59.20%42.46%52.77%
59.30%42.63%52.94%
59.40%42.80%53.12%
59.50%42.97%53.29%
59.60%43.14%53.46%
59.70%43.31%53.63%
59.80%43.47%53.81%
59.90%43.64%53.98%
60.00%43.81%54.15%
60.10%43.98%54.33%
60.20%44.15%54.50%
60.30%44.32%54.68%
60.40%44.49%54.86%
60.50%44.66%55.04%
60.60%44.83%55.21%
60.70%45.00%55.39%
60.80%45.17%55.57%
60.90%45.34%55.74%
61.00%45.51%55.92%
61.10%45.68%56.10%
61.20%45.85%56.27%
61.30%46.02%56.45%
61.40%46.19%56.63%
61.50%46.36%56.81%
61.60%46.53%56.98%
61.70%46.69%57.16%
61.80%46.87%57.35%
61.90%47.06%57.55%
62.00%47.24%57.74%
62.10%47.42%57.93%
62.20%47.60%58.13%
62.30%47.78%58.32%
62.40%47.96%58.51%
62.50%48.14%58.71%
62.60%48.32%58.90%
62.70%48.50%59.09%
62.80%48.68%59.28%
62.90%48.86%59.48%
63.00%49.04%59.67%
63.10%49.22%59.86%
63.20%49.40%60.06%
63.30%49.58%60.25%
63.40%49.75%60.44%
63.50%49.92%60.62%
63.60%50.08%60.81%
63.70%50.25%61.00%
63.80%50.42%61.18%
63.90%50.59%61.37%
64.00%50.76%61.56%
64.10%50.93%61.74%
64.20%51.10%61.93%
64.30%51.27%62.11%
64.40%51.44%62.30%
64.50%51.61%62.49%
64.60%51.78%62.67%
64.70%51.95%62.86%
64.80%52.12%63.05%
64.90%52.29%63.23%
65.00%52.46%63.42%
65.10%52.63%63.61%
65.20%52.80%63.80%
65.30%52.97%63.99%
65.40%53.14%64.18%
65.50%53.31%64.38%
65.60%53.47%64.57%
65.70%53.64%64.76%
65.80%53.81%64.95%
65.90%53.98%65.14%
66.00%54.15%65.33%
66.10%54.32%65.52%
66.20%54.49%65.71%
66.30%54.66%65.91%
66.40%54.83%66.10%
66.50%55.00%66.29%
66.60%55.17%66.48%
66.70%55.34%66.67%
66.80%55.52%66.88%
66.90%55.70%67.09%
67.00%55.88%67.29%
67.10%56.06%67.50%
67.20%56.24%67.71%
67.30%56.42%67.92%
67.40%56.60%68.13%
67.50%56.78%68.34%
67.60%56.96%68.54%
67.70%57.14%68.75%
67.80%57.32%68.96%
67.90%57.50%69.17%
68.00%57.68%69.38%
68.10%57.86%69.58%
68.20%58.04%69.79%
68.30%58.22%70.00%
68.40%58.39%70.19%
68.50%58.56%70.37%
68.60%58.73%70.56%
68.70%58.90%70.74%
68.80%59.07%70.93%
68.90%59.24%71.12%
69.00%59.41%71.30%
69.10%59.58%71.49%
69.20%59.75%71.67%
69.30%59.92%71.86%
69.40%60.08%72.04%
69.50%60.25%72.23%
69.60%60.42%72.42%
69.70%60.59%72.60%
69.80%60.76%72.79%
69.90%60.93%72.97%
70.00%61.10%73.16%
70.10%61.27%73.35%
70.20%61.44%73.53%
70.30%61.61%73.72%
70.40%61.78%73.91%
70.50%61.95%74.09%
70.60%62.12%74.28%
70.70%62.29%74.46%
70.80%62.46%74.65%
70.90%62.63%74.84%
71.00%62.80%75.02%
71.10%62.97%75.21%
71.20%63.14%75.40%
71.30%63.31%75.58%
71.40%63.47%75.77%
71.50%63.64%75.95%
71.60%63.81%76.14%
71.70%63.98%76.31%
71.80%64.16%76.47%
71.90%64.34%76.64%
72.00%64.52%76.80%
72.10%64.70%76.97%
72.20%64.88%77.13%
72.30%65.06%77.30%
72.40%65.24%77.46%
72.50%65.42%77.63%
72.60%65.60%77.79%
72.70%65.78%77.96%
72.80%65.96%78.12%
72.90%66.14%78.29%
73.00%66.32%78.45%
73.10%66.50%78.62%
73.20%66.68%78.78%
73.30%66.86%78.95%
73.40%67.03%79.10%
73.50%67.20%79.26%
73.60%67.37%79.41%
73.70%67.54%79.57%
73.80%67.71%79.72%
73.90%67.88%79.88%
74.00%68.05%80.03%
74.10%68.22%80.19%
74.20%68.39%80.34%
74.30%68.56%80.50%
74.40%68.73%80.65%
74.50%68.90%80.81%
74.60%69.07%80.96%
74.70%69.24%81.12%
74.80%69.41%81.27%
74.90%69.58%81.43%
75.00%69.75%81.58%
75.10%69.92%81.72%
75.20%70.08%81.87%
75.30%70.25%82.01%
75.40%70.42%82.16%
75.50%70.59%82.30%
75.60%70.76%82.45%
75.70%70.93%82.59%
75.80%71.10%82.74%
75.90%71.27%82.88%
76.00%71.44%83.03%
76.10%71.61%83.17%
76.20%71.78%83.32%
76.30%71.95%83.46%
76.40%72.12%83.61%
76.50%72.29%83.75%
76.60%72.46%83.90%
76.70%72.63%84.04%
76.80%72.81%84.18%
76.90%72.99%84.33%
77.00%73.17%84.47%
77.10%73.35%84.61%
77.20%73.53%84.75%
77.30%73.71%84.90%
77.40%73.89%85.04%
77.50%74.07%85.18%
77.60%74.25%85.32%
77.70%74.43%85.47%
77.80%74.61%85.61%
77.90%74.79%85.75%
78.00%74.97%85.89%
78.10%75.15%86.04%
78.20%75.33%86.18%
78.30%75.51%86.32%
78.40%75.68%86.44%
78.50%75.85%86.57%
78.60%76.02%86.69%
78.70%76.19%86.81%
78.80%76.36%86.94%
78.90%76.53%87.06%
79.00%76.69%87.18%
79.10%76.86%87.31%
79.20%77.03%87.43%
79.30%77.20%87.56%
79.40%77.37%87.68%
79.50%77.54%87.80%
79.60%77.71%87.93%
79.70%77.88%88.05%
79.80%78.05%88.17%
79.90%78.22%88.30%
80.00%78.39%88.42%
80.10%78.56%88.53%
80.20%78.73%88.63%
80.30%78.90%88.74%
80.40%79.07%88.85%
80.50%79.24%88.96%
80.60%79.41%89.06%
80.70%79.58%89.17%
80.80%79.75%89.28%
80.90%79.92%89.39%
81.00%80.08%89.49%
81.10%80.25%89.60%
81.20%80.42%89.71%
81.30%80.59%89.81%
81.40%80.76%89.92%
81.50%80.93%90.03%
81.60%81.10%90.14%
81.70%81.27%90.35%
81.80%81.45%90.46%
81.90%81.63%90.57%
82.00%81.81%90.68%
82.10%81.99%90.79%
82.20%82.17%90.90%
82.30%82.35%91.01%
82.40%82.53%91.12%
82.50%82.71%91.23%
82.60%82.89%91.34%
82.70%83.07%91.45%
82.80%83.25%91.56%
82.90%83.43%91.67%
83.00%83.61%91.78%
83.10%83.79%91.89%
83.20%83.97%92.00%
83.30%84.15%92.11%
83.40%84.32%92.20%
83.50%84.49%92.29%
83.60%84.66%92.39%
83.70%84.83%92.48%
83.80%85.00%92.57%
83.90%85.17%92.66%
84.00%85.34%92.76%
84.10%85.51%92.85%
84.20%85.68%92.94%
84.30%85.85%93.03%
84.40%86.02%93.13%
84.50%86.19%93.22%
84.60%86.36%93.31%
84.70%86.53%93.40%
84.80%86.69%93.50%
84.90%86.86%93.59%
85.00%87.03%93.68%
85.10%87.19%93.76%
85.20%87.34%93.85%
85.30%87.49%93.93%
85.40%87.64%94.01%
85.50%87.80%94.09%
85.60%87.95%94.18%
85.70%88.10%94.26%
85.80%88.25%94.34%
85.90%88.41%94.43%
86.00%88.56%94.51%
86.10%88.71%94.59%
86.20%88.86%94.68%
86.30%89.02%94.76%
86.40%89.17%94.84%
86.50%89.32%94.92%
86.60%89.47%95.01%
86.70%89.63%95.09%
86.80%89.77%95.17%
86.90%89.92%95.24%
87.00%90.06%95.32%
87.10%90.20%95.40%
87.20%90.35%95.47%
87.30%90.49%95.55%
87.40%90.64%95.63%
87.50%90.78%95.71%
87.60%90.92%95.78%
87.70%91.07%95.86%
87.80%91.21%95.94%
87.90%91.36%96.01%
88.00%91.50%96.09%
88.10%91.64%96.17%
88.20%91.79%96.24%
88.30%91.93%96.32%
88.40%92.05%96.38%
88.50%92.17%96.44%
88.60%92.29%96.51%
88.70%92.41%96.57%
88.80%92.53%96.63%
88.90%92.64%96.69%
89.00%92.76%96.75%
89.10%92.88%96.81%
89.20%93.00%96.88%
89.30%93.12%96.94%
89.40%93.24%97.00%
89.50%93.36%97.06%
89.60%93.47%97.12%
89.70%93.59%97.18%
89.80%93.71%97.25%
89.90%93.83%97.31%
90.00%93.95%97.37%
90.10%94.05%97.42%
90.20%94.15%97.47%
90.30%94.25%97.53%
90.40%94.36%97.58%
90.50%94.46%97.63%
90.60%94.56%97.68%
90.70%94.66%97.73%
90.80%94.76%97.78%
90.90%94.86%97.84%
91.00%94.97%97.89%
91.10%95.07%97.94%
91.20%95.17%97.99%
91.30%95.27%98.04%
91.40%95.37%98.09%
91.50%95.47%98.15%
91.60%95.58%98.20%
91.70%95.68%98.25%
91.80%95.77%98.29%
91.90%95.86%98.34%
92.00%95.95%98.38%
92.10%96.04%98.43%
92.20%96.13%98.47%
92.30%96.22%98.51%
92.40%96.31%98.56%
92.50%96.40%98.60%
92.60%96.49%98.64%
92.70%96.58%98.69%
92.80%96.67%98.73%
92.90%96.76%98.78%
93.00%96.85%98.82%
93.10%96.94%98.86%
93.20%97.03%98.91%
93.30%97.12%98.95%
93.40%97.19%98.98%
93.50%97.25%99.01%
93.60%97.32%99.04%
93.70%97.39%99.07%
93.80%97.46%99.10%
93.90%97.53%99.13%
94.00%97.59%99.16%
94.10%97.66%99.19%
94.20%97.73%99.23%
94.30%97.80%99.26%
94.40%97.86%99.29%
94.50%97.93%99.32%
94.60%98.00%99.35%
94.70%98.07%99.38%
94.80%98.14%99.41%
94.90%98.20%99.44%
95.00%98.27%99.47%
95.10%98.32%99.49%
95.20%98.37%99.51%
95.30%98.42%99.53%
95.40%98.47%99.55%
95.50%98.53%99.57%
95.60%98.58%99.59%
95.70%98.63%99.61%
95.80%98.68%99.63%
95.90%98.73%99.66%
96.00%98.78%99.68%
96.10%98.83%99.70%
96.20%98.88%99.72%
96.30%98.93%99.74%
96.40%98.98%99.76%
96.50%99.03%99.78%
96.60%99.08%99.80%
96.70%99.14%99.82%
96.80%99.17%99.84%
96.90%99.21%99.85%
97.00%99.24%99.86%
97.10%99.28%99.87%
97.20%99.32%99.88%
97.30%99.35%99.89%
97.40%99.39%99.90%
97.50%99.42%99.91%
97.60%99.46%99.93%
97.70%99.50%99.94%
97.80%99.53%99.95%
97.90%99.57%99.96%
98.00%99.60%99.97%
98.10%99.64%99.98%
98.20%99.68%99.99%
98.30%99.71%100.00%
98.40%99.73%100.00%
98.50%99.75%100.00%
98.60%99.76%100.00%
98.70%99.78%100.00%
98.80%99.80%100.00%
98.90%99.81%100.00%
99.00%99.83%100.00%
99.10%99.85%100.00%
99.20%99.86%100.00%
99.30%99.88%100.00%
99.40%99.90%100.00%
99.50%99.92%100.00%
99.60%99.93%100.00%
99.70%99.95%100.00%
99.80%99.97%100.00%
99.90%99.98%100.00%
100.00%100.00%100.00%

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
 

Craigc3814

Board Regular
Joined
Mar 7, 2016
Messages
211
Here are some example from the data tab

Budget IDProject NameProject ManagerDivision/DepartmentSpending GeometryStatusRenamed EAC
858 RelocationTBDLinearFuture $ 1,530,000,000
G18516MPITBDLinearCanceled $ 897,500,600
X_0285UpgradeTBDLinearFuture $ 727,000,000
435ImprovementsTBDLinearCanceled $ 250,000,000
781UpdatesTBDLinearCanceled $ 201,500,000
D18116SolidTBDETrapezoidFuture $ 197,810,000
X_0284RemovalTBDLinearFuture $ 192,000,000
H09133DiggingJohnENTrapezoidIn Progress $ 175,788,837
New_110ImplementTBDLinearFuture $ 100,000,000
H09142 bBradEsLinearIn Progress $ 93,044,904
775 HandleTBDLinearCanceled $ 90,000,000

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Forum statistics

Threads
1,086,139
Messages
5,388,081
Members
402,101
Latest member
wawezzer

Some videos you may like

This Week's Hot Topics

Top