{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Overview","Resiliency Scorecard","Drop down options"],"not_rendered":{"charts":7,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Overview","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1]]}
["Introduction"]
[null,"The S. D Bechtel, Jr. Foundation has a strong commitment to building and scaling organizations that are capable of continuing to get results after the Foundation’s sunset in 2020. The Resiliency Scorecard is an aid for assessing an organization’s ability to adapt to change and to achieve long-term success in a dynamic context.  The factors described in the Scorecard are indicators of adaptability, resiliency and sustainability.  \n\n"]
["Instructions"]
[null,"The Scorecard identifies seven factors related to organizational resiliency: (1) Culture & Learning, (2) Talent, (3) Context, (4) Planning & Execution, (5) Reputation & Communications, (6) Partnerships, and (7) Financial Footing. For each factor, there are 2-4 descriptors to guide your self-assessment. \n\nUse the drop-down menu to rate your organization against each element of the seven resiliency factors as: Exceptional (5), Capable (3), Poor (1), or Not Applicable. \n\nThe Scorecard will automatically show ratings for each factor. You can use the comments section to record the reasons for your ratings to help in planning capacity-building efforts and documenting trends over time.\n\n"]
["Overall Summary & Comments"]

{"sheet":"Resiliency Scorecard","index":1,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["RESILIENCY FACTOR"]
["1. Culture & Learning",null,null,null,null,"Assessment"]
["a.","There is a shared sense of the organization's values, mission, and vision",{"$f":"IF(F3=\"5 Exceptional\",1,(IF(F3=\"4 -\",2,(IF(F3=\"3 Capable\",3,(IF(F3=\"2 -\",4,(IF(F3=\"1 Poor\",5,\"\")))))))))","v":""}]
["b.","The organization balances optimism with realism",{"$f":"IF(F4=\"5 Exceptional\",1,(IF(F4=\"4 -\",2,(IF(F4=\"3 Capable\",3,(IF(F4=\"2 -\",4,(IF(F4=\"1 Poor\",5,\"\")))))))))","v":""}]
["c. ","The culture is one that encourages experimentation and learning",{"$f":"IF(F5=\"5 Exceptional\",1,(IF(F5=\"4 -\",2,(IF(F5=\"3 Capable\",3,(IF(F5=\"2 -\",4,(IF(F5=\"1 Poor\",5,\"\")))))))))","v":""}]
["d. ","The organization measures what it is accomplishing and applies that \nknowledge to decision-making",{"$f":"IF(F6=\"5 Exceptional\",1,(IF(F6=\"4 -\",2,(IF(F6=\"3 Capable\",3,(IF(F6=\"2 -\",4,(IF(F6=\"1 Poor\",5,\"\")))))))))","v":""}]
[null,null,{"$f":"AVERAGE(C3:C6)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C7-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C7-1)*25","v":{"$error":"#DIV/0!"}}]
["2. Talent",null,null,null,null,"Assessment"]
["a. ","Leadership is distributed so that the organization is not overly dependent on a single individual, and there is a senior leader capable of stepping in for the CEO if needed",{"$f":"IF(F9=\"5 Exceptional\",1,(IF(F9=\"4 -\",2,(IF(F9=\"3 Capable\",3,(IF(F9=\"2 -\",4,(IF(F9=\"1 Poor\",5,\"\")))))))))","v":""}]
["b. ","The priorities of board and staff leadership are well-aligned",{"$f":"IF(F10=\"5 Exceptional\",1,(IF(F10=\"4 -\",2,(IF(F10=\"3 Capable\",3,(IF(F10=\"2 -\",4,(IF(F10=\"1 Poor\",5,\"\")))))))))","v":""}]
["c. ","The organization is able to attract and retain talented staff",{"$f":"IF(F11=\"5 Exceptional\",1,(IF(F11=\"4 -\",2,(IF(F11=\"3 Capable\",3,(IF(F11=\"2 -\",4,(IF(F11=\"1 Poor\",5,\"\")))))))))","v":""}]
["d. ","The board is engaged and effective",{"$f":"IF(F12=\"5 Exceptional\",1,(IF(F12=\"4 -\",2,(IF(F12=\"3 Capable\",3,(IF(F12=\"2 -\",4,(IF(F12=\"1 Poor\",5,\"\")))))))))","v":""}]
[null,null,{"$f":"AVERAGE(C9:C11)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C13-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C13-1)*25","v":{"$error":"#DIV/0!"}}]
["3. Context (Outside-in Thinking)",null,null,null,null,"Assessment"]
["a. ","The organization is knowledgeable about key players and stakeholders in its field",{"$f":"IF(F15=\"5 Exceptional\",1,(IF(F15=\"4 -\",2,(IF(F15=\"3 Capable\",3,(IF(F15=\"2 -\",4,(IF(F15=\"1 Poor\",5,\"\")))))))))","v":""}]
["b. ","The organization has a clear understanding of its position, current role, and potential \nimpact in its field",{"$f":"IF(F16=\"5 Exceptional\",1,(IF(F16=\"4 -\",2,(IF(F16=\"3 Capable\",3,(IF(F16=\"2 -\",4,(IF(F16=\"1 Poor\",5,\"\")))))))))","v":""}]
["c. ","The organization is strong in relation to others in the field",{"$f":"IF(F17=\"5 Exceptional\",1,(IF(F17=\"4 -\",2,(IF(F17=\"3 Capable\",3,(IF(F17=\"2 -\",4,(IF(F17=\"1 Poor\",5,\"\")))))))))","v":""}]
["d. ","The organization routinely assesses external opportunities and threats that may affect the relevance and/or power of its strategy or programs",{"$f":"AVERAGE(C15:C17)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C18-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C18-1)*25","v":{"$error":"#DIV/0!"}}]
["4. Planning & Execution",null,null,null,null,"Assessment"]
["a. ","The organization has a clear strategy for the next 2-3 years",{"$f":"IF(F20=\"5 Exceptional\",1,(IF(F20=\"4 -\",2,(IF(F20=\"3 Capable\",3,(IF(F20=\"2 -\",4,(IF(F20=\"1 Poor\",5,\"\")))))))))","v":""}]
["b. ","The organization uses scenario thinking and is able to adjust and adapt its strategy as circumstances require",{"$f":"IF(F21=\"5 Exceptional\",1,(IF(F21=\"4 -\",2,(IF(F21=\"3 Capable\",3,(IF(F21=\"2 -\",4,(IF(F21=\"1 Poor\",5,\"\")))))))))","v":""}]
["c. ","The organization has the capabilities and skills to execute against plans",{"$f":"IF(F22=\"5 Exceptional\",1,(IF(F22=\"4 -\",2,(IF(F22=\"3 Capable\",3,(IF(F22=\"2 -\",4,(IF(F22=\"1 Poor\",5,\"\")))))))))","v":""}]
["d. ","The organization has a track record of accomplishing what it sets out to do",{"$f":"IF(F23=\"5 Exceptional\",1,(IF(F23=\"4 -\",2,(IF(F23=\"3 Capable\",3,(IF(F23=\"2 -\",4,(IF(F23=\"1 Poor\",5,\"\")))))))))","v":""}]
[null,null,{"$f":"AVERAGE(C20:C23)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C24-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C24-1)*25","v":{"$error":"#DIV/0!"}}]
["5. Reputation & Communications",null,null,null,null,"Assessment"]
["a.","The organization has a clear and compelling story which it uses to communicate about its mission and its impact",{"$f":"IF(F26=\"5 Exceptional\",1,(IF(F26=\"4 -\",2,(IF(F26=\"3 Capable\",3,(IF(F26=\"2 -\",4,(IF(F26=\"1 Poor\",5,\"\")))))))))","v":""}]
["b.","The organization has built and actively maintains a strong reputation with key audiences and/or constituencies",{"$f":"IF(F27=\"5 Exceptional\",1,(IF(F27=\"4 -\",2,(IF(F27=\"3 Capable\",3,(IF(F27=\"2 -\",4,(IF(F27=\"1 Poor\",5,\"\")))))))))","v":""}]
[null,null,{"$f":"AVERAGE(C26:C27)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C28-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C28-1)*25","v":{"$error":"#DIV/0!"}}]
["6. Partnerships",null,null,null,null,"Assessment"]
["a.","The organization routinely and successfully collaborates, coordinates, and communicates with others in its field",{"$f":"IF(F30=\"5 Exceptional\",1,(IF(F30=\"4 -\",2,(IF(F30=\"3 Capable\",3,(IF(F30=\"2 -\",4,(IF(F30=\"1 Poor\",5,\"\")))))))))","v":""}]
["b.","The organization engages in high-yield strategic partnerships",{"$f":"IF(F31=\"5 Exceptional\",1,(IF(F31=\"4 -\",2,(IF(F31=\"3 Capable\",3,(IF(F31=\"2 -\",4,(IF(F31=\"1 Poor\",5,\"\")))))))))","v":""}]
["c.","Leaders participate in network and/or coalition activities selectively and strategically",{"$f":"IF(F32=\"expert\",1,(IF(F32=\"Proficient\",2,(IF(F32=\"adequate\",3,(IF(F32=\"poor\",4,(IF(F32=\"not at all\",5,\"\")))))))))","v":""}]
[null,null,{"$f":"AVERAGE(C30:C32)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C33-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C33-1)*25","v":{"$error":"#DIV/0!"}}]
["7. Financial Footing",null,null,null,null,"Assessment"]
["a. ","The organization has reliable and recurring revenue that covers the full cost of programs and operations",{"$f":"IF(F35=\"5 Exceptional\",1,(IF(F35=\"4 -\",2,(IF(F35=\"3 Capable\",3,(IF(F35=\"2 -\",4,(IF(F35=\"1 Poor\",5,\"\")))))))))","v":""}]
["b. ","The organization has adequate unrestricted funds and cash reserves",{"$f":"IF(F36=\"5 Exceptional\",1,(IF(F36=\"4 -\",2,(IF(F36=\"3 Capable\",3,(IF(F36=\"2 -\",4,(IF(F36=\"1 Poor\",5,\"\")))))))))","v":""}]
["c. ","The organization has a clear financial strategy that promotes long-term sustainability",{"$f":"IF(F37=\"5 Exceptional\",1,(IF(F37=\"4 -\",2,(IF(F37=\"3 Capable\",3,(IF(F37=\"2 -\",4,(IF(F37=\"1 Poor\",5,\"\")))))))))","v":""}]
["d. ","The organization's dependency on S.D. Bechtel, Jr. Foundation funding is declining over time"]
[null,null,{"$f":"AVERAGE(C35:C38)","v":{"$error":"#DIV/0!"}},{"$f":"100-(C39-1)*25","v":{"$error":"#DIV/0!"}},{"$f":"(C39-1)*25","v":{"$error":"#DIV/0!"}}]

{"sheet":"Drop down options","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Rating","%"]
["Highly Effective",100]
["Effective",75]
["Needs Improvement",50]
["Seriously Lacking",25]
["No capacity",0]
[]
["Assessment"]
[]
["5 Exceptional"]
["4 -"]
["3 Capable"]
["2 -"]
["1 Poor"]
["N/A"]