{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":22,"n_cols":37,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,19,17,19]]}
["Instructions:  ",null,"Enter frequencies in increasing order in column B.  Errors indicated in upper right half."]
[null,null,"Cells contain the ratio of the frequencies.  An integer ratio indicates a harmonic relationship."]
[null,null,"Colored cells show pairs of  frequencies which are (nearly) harmonic, as per the KEY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1=diagonal"]
[null,null,"If you enable macros: Click on a ratio to higlight (orange) the corresponding frequencies.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2=error"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3=out of bounds"]
[null,"Frequencies",{"$f":"TRANSPOSE(B7:B22)","v":230},700,930,1170,1400,0,0,0,0,0,0,0,0,0,0,0,null,"KEY",null,"DON'T TOUCH: SPREADSHEET USES THESE FOR CALCULATION"]
["Enter",230,{"$f":"IF($B7*C$6=0,\"\",IF(ROW()-COLUMN()<ROW($B$6)-1,IF($B7>C$6,\"Error!\",\"\"),$B7/C$6))","v":""},{"$f":"IF($B7*D$6=0,\"\",IF(ROW()-COLUMN()<ROW($B$6)-1,IF($B7>D$6,\"Error!\",\"\"),$B7/D$6))","v":""},"","","","","","","","","","","","","","",null,"ratio is less than …",null,{"$f":"IF($B7*C$6=0,3,IF($B7=C$6,1,IF(OR($B7<C$6,ROW()-COLUMN()<ROW($U$6)-COLUMN($U$6)),2,ABS(MOD(C7+0.5,1)-0.5))))","v":1},{"$f":"IF($B7*D$6=0,3,IF($B7=D$6,1,IF(OR($B7<D$6,ROW()-COLUMN()<ROW($U$6)-COLUMN($U$6)),2,ABS(MOD(D7+0.5,1)-0.5))))","v":2},2,2,2,3,3,3,3,3,3,3,3,3,3,3]
["peak ",700,{"$f":"IF($B8*C$6=0,\"\",IF(ROW()-COLUMN()<ROW($B$6)-1,IF($B8>C$6,\"Error!\",\"\"),$B8/C$6))","v":3.0434782608695654},"","","","","","","","","","","","","","","",null,0.01,null,{"$f":"IF($B8*C$6=0,3,IF($B8=C$6,1,IF(OR($B8<C$6,ROW()-COLUMN()<ROW($U$6)-COLUMN($U$6)),2,ABS(MOD(C8+0.5,1)-0.5))))","v":4.347826086956541E-2},1,2,2,2,3,3,3,3,3,3,3,3,3,3,3]
["frequencies",930,4.0434782608695654,1.3285714285714285,"","","","","","","","","","","","","","",null,0.02,null,4.347826086956541E-2,0.32857142857142851,1,2,2,3,3,3,3,3,3,3,3,3,3,3]
["here",1170,5.0869565217391308,1.6714285714285715,1.2580645161290323,"","","","","","","","","","","","","",null,0.05,null,8.6956521739130821E-2,0.32857142857142829,0.25806451612903225,1,2,3,3,3,3,3,3,3,3,3,3,3]
["in",1400,6.0869565217391308,2,1.5053763440860215,1.1965811965811965,"","","","","","","","","","","","",null,0.1,null,8.6956521739130821E-2,0,0.4946236559139785,0.19658119658119655,1,3,3,3,3,3,3,3,3,3,3,3]
["increasing",null,"","","","","","","","","","","","","","","","",null," … from an integer",null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["order.",null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,"","","","","","","","","","","","","","","","",null,"Numbers in KEY can be adjusted, to vary how perfectly pairs must be related ",null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["Initial",null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["numbers",null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["are just",null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["examples.",null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,null,"","","","","","","","","","","","","","","","",null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]