Excel Cross Tabulation
5164
£250(approx. $310)
- Posted:
- Proposals: 1
- Remote
- #18469
- Archived
Description
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.
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.
James G.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
29 Mar 2010
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies