Excel Cross Tabulation

  • Posted
  • Proposals 1
  • Remote
  • #18469
  • Archived
Nilesh P. has already sent a proposal.
  • 1


Experience Level: Expert
Need an Excel workbook constructed that will generate 1) a cross tabulation of all possible pairs of elements from an original parameter list of elements 2) a list of unique angular distances and the associated element pairs and 3) the ability to save the current crosstab as a named reference crosstab and 4) automatic comparison of the current crosstab against one or more reference crosstabs as identified by saved name in a list within the workbook,

The cell value in this cross tabulation of pairs is the angular distance between each pair of elements within a 360d circle. The crosstab is generated from a list of elements where the position in the 360d circle is given as degrees and minutes within one of twelve 30d sectors. Each element is taken as the comparator and all other elements are measured for the angular distance from the comparator.

From the above crosstab the unique angles are tabulated with the element pairs that have that unique angle.

A means of saving and recalling these crosstabs by name is required.

One or more reference crosstabs should be selectable and for each reference crosstab a comparison with the current crosstab is made. The difference in each corresponding cell in the reference and current crosstabs are compared using a global variable (lambda) and a new crosstab is generated showing only those cells with a difference equal or less than lambda.

A fully worked out sample and more detailed requirements are in the workbook. Do not ask to bid unless you have studied it.

Clarification Board

    There are no clarification messages.