Supplemental Material to Accompany the Manuscript,
"The Marketing and Analytics of Consumer Trip Chaining"

Additional Materials

The manuscript, "The Marketing and Analytics of Consumer Trip Chaining," is available here: Manuscript (Apr 26, 2025).pdf

 

A short video for evaluating a Trip Chain is recommended for viewing. Select the video to play in a new window or download the video using the appropriate keys for your computer / browser. Evaluating a Trip Chain (Jan 13 2025).mov

Some important notes to get started with the examples referenced in the Manuscript in these two documents: Important Notes (Jan 13, 2025).pdf and Data Structures (May 16, 2025).pdf

An example of the distance matrix spreadsheet between all nodes is available here: Distance Matrix (Apr 26, 2025).xlsx

1. Spreadsheets and Narratives relating to the status of the search at points referenced in the Manuscript are below:

Table 1 NNR Solution n=32.xlsx
Table 2: Starting Solution.xlsx Ending Solution.xlsx
Table 3: Starting Solution.xlsx Ending Solution.xlsx
Table 5 Best-found Concatenated SCs.xlsx
Table 5 Best-found Long sub-chain.xlsx
Table 5 Best-found Short sub-chain.xlsx
Table 5 First Long sub-chain.xlsx
Table 5 First Short sub-chain.xlsx
Table 6 Row 1.xlsx
Table 6 Row 2.xlsx
Table 6 Row 3.xlsx
Table 6 Row 4.xlsx
Table 6 Row 5.xlsx
Table 6 Row 6.xlsx
Table 7 Row 1 Veh 1.xlsx Table 7 Row 1 Veh 2.xlsx
Table 7 Row 2 Veh 1.xlsx Table 7 Row 2 Veh 2.xlsx
Table 7 Row 3 Veh 1.xlsx Table 7 Row 3 Veh 2.xlsx
Table 7 Row 4 Veh 1.xlsx Table 7 Row 4 Veh 2.xlsx
Table 7 Row 5 Veh 1.xlsx Table 7 Row 5 Veh 2.xlsx
Table 7 Row 6 Veh 1.xlsx Table 7 Row 6 Veh 2.xlsx
Table 9 Row 1.xlsx
Table 9 Row 2.xlsx
Table 9 Row 3.xlsx
Table 9 Row 4.xlsx
Table 9 Row 5.xlsx
Table 9 Row 6.xlsx
Table 9 Row 7.xlsx
Table 10 Row 1.xlsx
Table 10 Row 2.xlsx
Table 10 Row 3.xlsx
Table 10 Row 4.xlsx
Table 10 Row 5.xlsx
Table 10 Row 6.xlsx

2. Brief videos to orient a reader to using the worksheet "TCP Model" are below. Select the video to play in a new window or download the video using the appropriate keys for your computer / browser.
a. Orientation to worksheet VRP model. (249mb)
b. Data input. (307mb)
c. Evaluating a route of interest. (280mb)
d. Type 1 perturbation analysis. (355mb)
e. Type 2 perturbation analysis. (325mb)
f. Composing the candidate list. (298mb)
g. Finding best type 1 infeasible perturbations. (543mb)
h. Finding best type 2 infeasible perturbations. (499mb)
i. Testing a candidate list. (613mb)



Updated: Apr 26, 2025.
If problems or questions about using this webpage: mongrelworkshelp@gmail.com