{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Template 1","Template 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Template 1","index":0,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Enter your original data:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nightingale Rose Diagram Excel Template"]
["Series 1","Series 2","Series 3","Series 4","Series 5","Series 6","Series 7","Series 8","Series 9","Series 10","Series 11",null,null,null,null,null,"How To?"]
[0.88,0.41,0.3,0.4,0.51,0.32,0.7,0.21,0.11,0.13,0.54,null,null,null,null,null,"1. fill your data"]
[0.12,0.59,0.7,0.6,0.49,0.68,0.3,0.28000000000000003,0.28999999999999998,0.34,0.46,null,null,null,null,null,"2. fill color with the data"]
[null,null,null,null,null,null,null,0.22,0.23,0.3,null,null,null,null,null,null,"3. change the Backgroud and Center color"]
[null,null,null,null,null,null,null,0.28999999999999998,0.18,0.12,null,null,null,null,null,null,"4. click Creat Diagram"]
[null,null,null,null,null,null,null,null,0.12,7.0000000000000007E-2,null,null,null,null,null,null,"5. Add labels"]
[null,null,null,null,null,null,null,null,7.0000000000000007E-2,0.04,null,null,null,null,null,null,"6. Use: Select the diagram range, Home - Copy - Copy as Picture"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: ","don't change the formulas!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"don't delete or insert rows!"]
[]
[]
["Backgroud:",null,"Center:"]
[]
["Diagram Data (Auto complete, don't change the formulas)"]
[{"$f":"IF(A2=\"\",\"\",A2)","v":"Series 1"},"Series 2","Series 3","Series 4","Series 5","Series 6","Series 7","Series 8","Series 9","Series 10","Series 11",{"$f":"IF(L2=\"\",\"\",L2)","v":""},"","",""]
[{"$f":"IF(A3=\"\",\"\",A3)","v":0.88},0.41,0.3,0.4,0.51,0.32,0.7,0.21,0.11,0.13,0.54,{"$f":"IF(L3=\"\",\"\",L3)","v":""},"","",""]
[{"$f":"IF(A4=\"\",\"\",SUM(A$3:A4))","v":1},{"$f":"IF(B4=\"\",\"\",SUM(B$3:B4))","v":1},{"$f":"IF(C4=\"\",\"\",SUM(C$3:C4))","v":1},{"$f":"IF(D4=\"\",\"\",SUM(D$3:D4))","v":1},{"$f":"IF(E4=\"\",\"\",SUM(E$3:E4))","v":1},{"$f":"IF(F4=\"\",\"\",SUM(F$3:F4))","v":1},{"$f":"IF(G4=\"\",\"\",SUM(G$3:G4))","v":1},{"$f":"IF(H4=\"\",\"\",SUM(H$3:H4))","v":0.49},{"$f":"IF(I4=\"\",\"\",SUM(I$3:I4))","v":0.39999999999999997},{"$f":"IF(J4=\"\",\"\",SUM(J$3:J4))","v":0.47000000000000003},{"$f":"IF(K4=\"\",\"\",SUM(K$3:K4))","v":1},{"$f":"IF(L4=\"\",\"\",SUM(L$3:L4))","v":""},{"$f":"IF(M4=\"\",\"\",SUM(M$3:M4))","v":""},{"$f":"IF(N4=\"\",\"\",SUM(N$3:N4))","v":""},{"$f":"IF(O4=\"\",\"\",SUM(O$3:O4))","v":""}]
[{"$f":"IF(A5=\"\",\"\",SUM(A$3:A5))","v":""},{"$f":"IF(B5=\"\",\"\",SUM(B$3:B5))","v":""},{"$f":"IF(C5=\"\",\"\",SUM(C$3:C5))","v":""},{"$f":"IF(D5=\"\",\"\",SUM(D$3:D5))","v":""},{"$f":"IF(E5=\"\",\"\",SUM(E$3:E5))","v":""},{"$f":"IF(F5=\"\",\"\",SUM(F$3:F5))","v":""},{"$f":"IF(G5=\"\",\"\",SUM(G$3:G5))","v":""},{"$f":"IF(H5=\"\",\"\",SUM(H$3:H5))","v":0.71},{"$f":"IF(I5=\"\",\"\",SUM(I$3:I5))","v":0.63},{"$f":"IF(J5=\"\",\"\",SUM(J$3:J5))","v":0.77},{"$f":"IF(K5=\"\",\"\",SUM(K$3:K5))","v":""},{"$f":"IF(L5=\"\",\"\",SUM(L$3:L5))","v":""},{"$f":"IF(M5=\"\",\"\",SUM(M$3:M5))","v":""},{"$f":"IF(N5=\"\",\"\",SUM(N$3:N5))","v":""},{"$f":"IF(O5=\"\",\"\",SUM(O$3:O5))","v":""}]
[{"$f":"IF(A6=\"\",\"\",SUM(A$3:A6))","v":""},{"$f":"IF(B6=\"\",\"\",SUM(B$3:B6))","v":""},{"$f":"IF(C6=\"\",\"\",SUM(C$3:C6))","v":""},{"$f":"IF(D6=\"\",\"\",SUM(D$3:D6))","v":""},{"$f":"IF(E6=\"\",\"\",SUM(E$3:E6))","v":""},{"$f":"IF(F6=\"\",\"\",SUM(F$3:F6))","v":""},{"$f":"IF(G6=\"\",\"\",SUM(G$3:G6))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H$3:H6))","v":1},{"$f":"IF(I6=\"\",\"\",SUM(I$3:I6))","v":0.81},{"$f":"IF(J6=\"\",\"\",SUM(J$3:J6))","v":0.89},{"$f":"IF(K6=\"\",\"\",SUM(K$3:K6))","v":""},{"$f":"IF(L6=\"\",\"\",SUM(L$3:L6))","v":""},{"$f":"IF(M6=\"\",\"\",SUM(M$3:M6))","v":""},{"$f":"IF(N6=\"\",\"\",SUM(N$3:N6))","v":""},{"$f":"IF(O6=\"\",\"\",SUM(O$3:O6))","v":""}]
[{"$f":"IF(A7=\"\",\"\",SUM(A$3:A7))","v":""},{"$f":"IF(B7=\"\",\"\",SUM(B$3:B7))","v":""},{"$f":"IF(C7=\"\",\"\",SUM(C$3:C7))","v":""},{"$f":"IF(D7=\"\",\"\",SUM(D$3:D7))","v":""},{"$f":"IF(E7=\"\",\"\",SUM(E$3:E7))","v":""},{"$f":"IF(F7=\"\",\"\",SUM(F$3:F7))","v":""},{"$f":"IF(G7=\"\",\"\",SUM(G$3:G7))","v":""},{"$f":"IF(H7=\"\",\"\",SUM(H$3:H7))","v":""},{"$f":"IF(I7=\"\",\"\",SUM(I$3:I7))","v":0.93},{"$f":"IF(J7=\"\",\"\",SUM(J$3:J7))","v":0.96},{"$f":"IF(K7=\"\",\"\",SUM(K$3:K7))","v":""},{"$f":"IF(L7=\"\",\"\",SUM(L$3:L7))","v":""},{"$f":"IF(M7=\"\",\"\",SUM(M$3:M7))","v":""},{"$f":"IF(N7=\"\",\"\",SUM(N$3:N7))","v":""},{"$f":"IF(O7=\"\",\"\",SUM(O$3:O7))","v":""}]
[{"$f":"IF(A8=\"\",\"\",SUM(A$3:A8))","v":""},{"$f":"IF(B8=\"\",\"\",SUM(B$3:B8))","v":""},{"$f":"IF(C8=\"\",\"\",SUM(C$3:C8))","v":""},{"$f":"IF(D8=\"\",\"\",SUM(D$3:D8))","v":""},{"$f":"IF(E8=\"\",\"\",SUM(E$3:E8))","v":""},{"$f":"IF(F8=\"\",\"\",SUM(F$3:F8))","v":""},{"$f":"IF(G8=\"\",\"\",SUM(G$3:G8))","v":""},{"$f":"IF(H8=\"\",\"\",SUM(H$3:H8))","v":""},{"$f":"IF(I8=\"\",\"\",SUM(I$3:I8))","v":1},{"$f":"IF(J8=\"\",\"\",SUM(J$3:J8))","v":1},{"$f":"IF(K8=\"\",\"\",SUM(K$3:K8))","v":""},{"$f":"IF(L8=\"\",\"\",SUM(L$3:L8))","v":""},{"$f":"IF(M8=\"\",\"\",SUM(M$3:M8))","v":""},{"$f":"IF(N8=\"\",\"\",SUM(N$3:N8))","v":""},{"$f":"IF(O8=\"\",\"\",SUM(O$3:O8))","v":""}]
[{"$f":"IF(A9=\"\",\"\",SUM(A$3:A9))","v":""},{"$f":"IF(B9=\"\",\"\",SUM(B$3:B9))","v":""},{"$f":"IF(C9=\"\",\"\",SUM(C$3:C9))","v":""},{"$f":"IF(D9=\"\",\"\",SUM(D$3:D9))","v":""},{"$f":"IF(E9=\"\",\"\",SUM(E$3:E9))","v":""},{"$f":"IF(F9=\"\",\"\",SUM(F$3:F9))","v":""},{"$f":"IF(G9=\"\",\"\",SUM(G$3:G9))","v":""},{"$f":"IF(H9=\"\",\"\",SUM(H$3:H9))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I$3:I9))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J$3:J9))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K$3:K9))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L$3:L9))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M$3:M9))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N$3:N9))","v":""},{"$f":"IF(O9=\"\",\"\",SUM(O$3:O9))","v":""}]
[{"$f":"IF(A10=\"\",\"\",SUM(A$3:A10))","v":""},{"$f":"IF(B10=\"\",\"\",SUM(B$3:B10))","v":""},{"$f":"IF(C10=\"\",\"\",SUM(C$3:C10))","v":""},{"$f":"IF(D10=\"\",\"\",SUM(D$3:D10))","v":""},{"$f":"IF(E10=\"\",\"\",SUM(E$3:E10))","v":""},{"$f":"IF(F10=\"\",\"\",SUM(F$3:F10))","v":""},{"$f":"IF(G10=\"\",\"\",SUM(G$3:G10))","v":""},{"$f":"IF(H10=\"\",\"\",SUM(H$3:H10))","v":""},{"$f":"IF(I10=\"\",\"\",SUM(I$3:I10))","v":""},{"$f":"IF(J10=\"\",\"\",SUM(J$3:J10))","v":""},{"$f":"IF(K10=\"\",\"\",SUM(K$3:K10))","v":""},{"$f":"IF(L10=\"\",\"\",SUM(L$3:L10))","v":""},{"$f":"IF(M10=\"\",\"\",SUM(M$3:M10))","v":""},{"$f":"IF(N10=\"\",\"\",SUM(N$3:N10))","v":""},{"$f":"IF(O10=\"\",\"\",SUM(O$3:O10))","v":""}]

{"sheet":"Template 2","index":1,"n_rows":17,"n_cols":28,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Indicator","Market capitalization of listed companies (% of GDP)","Olympic gold medals at London 2012","Box office revenues, $billion","Internet users (per 100 people)","Unemployment rate, %","GDP per capita, $","Urban population, % of total population","Average annual household income","Life expectancy at birth, males","Life expectancy at birth, females","Billionaires, US$","Population","Exports, $ trillion","GDP growth"]
["China",46.3,38,2.7,38.299999999999997,6.4,9100,47,10220,72.959999999999994,77.27,317,1349585838,2.0499999999999998,7.8]
["US",104.3,46,10.8,77.900000000000006,8.1999999999999993,49800,82,84300,76.19,81.17,409,316668567,1.6120000000000001,2.2000000000000002]
[]
["Diagram data (Auto complete, don't change the formulas)"]
["CHINA",{"$f":"IF(OR(B$2=\"\",B$3=\"\"),\"\",IF(B2=MAX(B$2:B$3),1,B2/MAX(B$2:B$3)))","v":0.44391179290508148},{"$f":"IF(OR(C$2=\"\",C$3=\"\"),\"\",IF(C2=MAX(C$2:C$3),1,C2/MAX(C$2:C$3)))","v":0.82608695652173914},0.25,0.4916559691912708,0.78048780487804892,0.18273092369477911,0.57317073170731703,0.12123368920521946,0.95760598503740646,0.95195269188123688,0.77506112469437649,1,1,1,{"$f":"IF(OR(P$2=\"\",P$3=\"\"),\"\",IF(P2=MAX(P$2:P$3),1,P2/MAX(P$2:P$3)))","v":""},"","","","","","",{"$f":"IF(OR(W$2=\"\",W$3=\"\"),\"\",IF(W2=MAX(W$2:W$3),1,W2/MAX(W$2:W$3)))","v":""},"","","","",""]
["US",{"$f":"IF(OR(B$2=\"\",B$3=\"\"),\"\",IF(B3=MAX(B$2:B$3),1,B3/MAX(B$2:B$3)))","v":1},{"$f":"IF(OR(C$2=\"\",C$3=\"\"),\"\",IF(C3=MAX(C$2:C$3),1,C3/MAX(C$2:C$3)))","v":1},1,1,1,1,1,1,1,1,1,0.2346412937092483,0.78634146341463429,0.2820512820512821,{"$f":"IF(OR(P$2=\"\",P$3=\"\"),\"\",IF(P3=MAX(P$2:P$3),1,P3/MAX(P$2:P$3)))","v":""},"","","","","","",{"$f":"IF(OR(W$2=\"\",W$3=\"\"),\"\",IF(W3=MAX(W$2:W$3),1,W3/MAX(W$2:W$3)))","v":""},"","","","",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"How To?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1. fill your data in Row 1:3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2. fill color in A6 and A7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3. click Creat Diagram"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Add labels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Use: Select the diagram range, Home - Copy - Copy as Picture"]