{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":62,"n_cols":23,"rows_kept":62,"flags":["formulas_cached_only"]}
[" #","Lot #","Vendor","City","Date","$ Price","Type","Ct Wt","Cut","Color","Clarity","Cert","Price  /Ct","Const $ Adj *","Const $/CT","Subj Ref $/Ct   /","Comp Ref $/Ct *"," Ratio","Adj Price/CT","Subj  Ct Wt","Adj Price","Rounded","1 -Ratio"]
[1,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[2,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[3,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[4,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[5,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[6,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[7,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[8,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[9,{"$nulls":11},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"$",null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[{"$nulls":18},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Subject:",{"$nulls":8},"Reference Source: ",null,null,"(Rap, Guide, Palmieri, etc.)"]
[{"$nulls":19},"Mean"]
["Col A-L: Enter data for each comparable sale",{"$nulls":10},"Enter the source of the reference price above after \"Reference Source:)",{"$nulls":7},"Median"]
["Col M: Divide “$ Price” by “Ct Wt” (Col F/Col H) to convert transaction prices to Price/ct",{"$nulls":10},"Enter the (same) Rap or other reference for the Subject in every row under /Subj Ref",{"$nulls":7},"Mode"]
["Col N: Enter the adjustment to convert to constant dollars in Const $ Adj (US BLS Inflation Calculator)  ",{"$nulls":10},"Enter the Subject carat weight in every row under Subj Wt",{"$nulls":7},"Range"]
["Col 0: Multiply “Price/Ct” x “Const $ Adj” (Col M x Col N) to find \"Constant Dollars /Ct\""]
["Col P: Enter the per/carat reference price for Subject (from an industry matrix) in every row under Subj Ref",{"$nulls":17},"Indicated Value:"]
["Col Q: Enter the per/carat reference price for each comp (from the same matrix) under Com Ref $/Ct"]
["Col R: Calculate Ratio of subject/comp by dividing “Subject Reference $/Ct” by “Comp Reference $/Ct” (Col P/Col Q)"]
["Col S: Multiply each “Constant $/Ct” by “Ratio” (Col O x Col R) to get Adjusted $/Ct"]
["Col T: Enter the Subject Carat Weight into every row"]
["Col U: Multiply each “Adjusted $/Ct” times the “Subject Ct Weight” (Col S x Col T) to get each Adjusted Price—what"]
["          that comp would have sold for had its value attributes been the same as the subject "]
[]
[null,"Analysis"]
[null,"Col U: SORT data by adjusted price, low to high"]
[null,"Col V: It may be necessary to round the adjusted prices to a significant figure to find the Mode"]
[null,"Col W: Subtract “1” from each Ratio (Col R). The results closest to “1”, either higher or lower, are more reliable."]
[]
[null,"Of the sample selected: "]
[null,"What is the range?"]
[null,"What is the mode?"]
[null,"What is the median?"]
[null,"What is the mean?"]
[null,"Analyze the amount of adjustment in \"Ratio\""]
[null,"The comps that needed least adjustment are the most reliable. (Ratios closest + or - \"1\")"]
[]
[null,"Opinion of value"]
[null,"Do not use the mean as the indicated value. (Rejected by IRS.) Use the least adjusted, (above), the mode if there is one, and/or median."]
[null,"Formula to round to a significant figure is \"  =ROUND(COLrow, -3) \" for nearest thousand; -2 for nearest hundred might help establish a mode"]
[null,"What is your opinion of value? (Rounded to a significant figure.)"]
[null,"What is your degree of confidence: a reasonable degree of jewelry appraisal probability or certainty?"]
[null,"State your opinion of the (kind of value), to a reasonable degree of jewelry appraisal probability (more than 50% probable) or certainty (more than 80% certain). "]
[null,"Never state the % on an appraisal or in testimony. Probability and Certainty are legally understood measures."]
[]
[null,"Write a narrative explaining the similarities and differences between each comp and the subject, how and why you adjusted each"]
[null,"transaction price, your analysis of the results, and how you formed your opinion of value. "]
[null,"This is best done by breaking it into 2 parts."]
[null,"======================================"]
[null,"Comparison of comps to subject:"]
[null,"Comp 1 (compare and explain differences to subject, and explain significance) “Comp #1 weighed more than the subject but was lower in color."]
[null,"The larger size is more desirable, but the lower color is less desirable. I adjusted the transaction price down for weight and up for color to make "]
[null,"the comp equivalent to the subject”"]
[null,"Comp 2 (compare and explain differences to subject, and explain significance) etc. “Comp #2 weighed the same as the subject, but the color was "]
[null,"better while the clarity was lower. I adjusted the transaction price to compensate down for color and up for clarity.”"]
[]
[null,"Analysis of sales data:"]
[null,"In order to analyze the sales, I converted all transaction prices to $/carat"]
[null,"I adjusted the selling price of each comparator to 20xx dollars by . . . "]
[null,"Next, I adjusted the selling price of each comp for any differences in value attributes to make it equivalent to the subject"]
[null,"Etc, etc . . ."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}