{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["How To Guide","Skills Matrix Reception","Skills Matrix Admin","Skills Matrix Nurses","Skills Matrix GPs","Skills VGC","Skills Matrix Blank"],"not_rendered":{"charts":0,"images":8,"macros":0,"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":"How To Guide","index":0,"n_rows":206,"n_cols":1,"rows_kept":206,"cut":false,"hidden":false,"merged":[[83,0,83,22],[85,0,85,22],[144,0,144,22],[22,0,22,22],[24,0,24,22],[123,0,123,22],[125,0,125,22],[26,0,26,22],[28,0,28,22],[46,0,46,22],[48,0,53,22],[60,0,60,22],[63,0,63,22],[65,0,65,22],[0,0,3,22],[5,0,5,22],[7,0,12,22],[14,0,14,22],[16,0,20,22],[205,0,206,22],[87,0,87,22],[186,0,186,22],[188,0,188,22],[190,0,191,22],[146,0,146,22],[167,0,167,22],[180,0,180,22],[182,0,182,22],[184,0,184,22],[151,0,151,22],[103,0,103,22],[148,0,149,22]]}
["Skill matrix - How To Guide"]
[]
[]
[]
[]
["What is the model and objectives of using the Skills Matrix?"]
[]
["- A structured approach to managing your practice workforce so you can quickly adapt to changing demands - whether planned or reactive - to build a more resilient team incorporating quick, timely reviews.\n- It will provide a visual system that gives real-time status at a glance.\n- It will help to identify the optimum levels of versatility across practice teams.\n- It will highlight gaps that can be turned into training / development opportunities.\n- It can be applied across numerous practices, buddy or PCN level, to allow potential distribution and sharing of workforce.\n- It will provide a process to follow so that anyone can pick it up."]
[]
[]
[]
[]
[]
[]
["How does it work?"]
[]
["- The model allows you to build greater resiliance in practice (GRIP). You will decide on the frequency & time at which you come together to review the status. The status will highlight any issues you will need to be aware of. During the review you will agree the action needed based on the visual control system. These decisions will require a “containment” (what do I need to do to address the issue now) followed by a countermeasure (what do I need to plan to do to reduce the risk of it happening again)."]
[]
[]
[]
[]
[]
["Step 1"]
[]
["Decide which team within the practice you want to focus on (Reception, Admin, Nurses, GPs, etc). Engage and communicate to the team, providing them with the purpose and overview of the benefits of this particular tool."]
[]
["Step 2"]
[]
["Review and validate the list of skills / tasks that are populated. Add, edit or delete any tasks specific to your practice."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 3"]
[]
["Prioritise tasks against the criteria (1, 2, 3) in column \"Priority Ranking\"\n\n 1 = Task that must be completed - Urgent. \n 2 = Tasks that can be delayed by 24 hrs\n 3 = Tasks that do not need to be completed for 48 hrs or longer."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Reorder / organise the list in priority order - for example, have all of the number 1s grouped together first, and then all of the number 2s and then the number 3s. "]
[]
[]
["Step 4"]
[]
["Populate the team members"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 5"]
[]
["Assess each team members competency against each skill / task by inputting the relevent number into the cell to the left of the quadrant. Refer to the \"Skills Level Key\"."]
[]
["Majority of key members should be scored between 0 - 3. Only one person should be scored as a 4 who will be the \"Lead Trainer\" for this particular skill / task to reduce variation when training. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This will auto populate the \"Actual\" column which give you a total of how many trained staff you have in that particular skill / task. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 6"]
[]
["Identify who will be the Lead Trainer for for each skill / task. This will be someone who is a \"4\" against that task / skill. Put their initials into column \"Lead Trainer\" against the skill. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 7"]
[]
["Identify the minimum number of people that need to be competent for each task to ensure you can accommodate demand (what is needed) and type this into column \"Minimum\" -  consider Annual leave, sickness, training, etc."]
[]
["For example; On a regular basis for a skill / task, 5 people are needed to be trained which you have, but however due to A/L allowance of 2 people off at the same time and possible sickness, this could potentially drop down to only having 2 people trained who are available, therefore the minimum number suggested would be to have 8 people trained in this skill / task. "]
[]
[]
["It is very important to set these details into the matrix"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Column \"Gap\" will auto calculate the gap from minimum to actual. Green indicates there is no gap, Amber indicates that you are between 50 - 99% to closing the gap, Red shows that the gap between actual and minimum is 0 - 49%. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 8"]
[]
["This will visually highlight any red or amber skills where staff development is required. You can prioritse your training needs and create a training plan to close the gap. "]
[]
["Step 9"]
[]
["Establish the frequency & time to review (daily huddle at the start of shift?)"]
[]
["Step 10"]
[]
["At the daily huddle, you can add or remove individuals from the skills matrix, indicating whether the resource is available or not using the drop down option above the individuals name on row \"Is the resource available\". If you indicate that this person is not available, the skills matrix will also remove the associated levels against each skill. This will then highlight to you if there are any gaps in the skills due to not having this particular resource available"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Due to the visual control (amber / red), you will be able to identify where you have dropped below the minimum requirements for that particular skill / task. This will allow you to make an informed decision about the priority actions needed. Hence you can decide due to the lack of resource, you may pause activity on any level 3 tasks. "]

{"sheet":"Skills Matrix Reception","index":1,"n_rows":68,"n_cols":69,"rows_kept":68,"cut":false,"hidden":false,"merged":[[41,25,42,25],[41,26,42,26],[41,28,42,28],[41,29,42,29],[41,31,42,31],[41,32,42,32],[41,34,42,34],[6,32,6,34],[6,29,6,31],[6,26,6,28],[6,23,6,25],[7,53,8,53],[7,54,8,54],[7,55,8,55],[7,56,8,56],[7,57,8,57],[6,2,6,4],[7,35,8,37],[7,38,8,40],[7,41,8,43],[7,44,8,46],[7,47,8,49],[7,50,8,52],[7,17,8,19],[7,20,8,22],[7,23,8,25],[7,26,8,28],[7,29,8,31],[7,32,8,34],[6,50,6,52],[6,47,6,49],[6,44,6,46],[6,41,6,43],[6,38,6,40],[6,35,6,37],[7,0,8,0],[7,2,8,4],[7,5,8,7],[7,8,8,10],[7,11,8,13],[7,14,8,16],[4,17,5,19],[4,20,5,20],[4,22,5,22],[7,1,8,1],[6,0,6,1],[6,5,6,7],[6,20,6,22],[6,17,6,19],[6,14,6,16],[6,11,6,13],[6,8,6,10],[0,0,3,57],[4,2,5,2],[4,4,5,4],[4,5,5,7],[4,8,5,8],[4,10,5,10],[4,11,5,13],[4,14,5,14],[4,16,5,16],[4,0,5,1],[4,29,5,31],[4,32,5,34],[4,35,5,57],[4,23,5,25],[4,26,5,26],[4,28,5,28],[41,47,42,47],[41,49,42,49],[43,35,44,35],[43,37,44,37],[43,38,44,38],[43,40,44,40],[43,41,44,41],[43,43,44,43],[43,44,44,44],[43,46,44,46],[43,47,44,47],[43,49,44,49],[41,41,42,41],[41,43,42,43],[41,44,42,44],[41,35,42,35],[41,37,42,37],[41,38,42,38],[41,40,42,40],[41,1,42,1],[43,1,44,1],[45,1,46,1],[41,2,42,2],[41,4,42,4],[41,5,42,5],[41,46,42,46],[45,35,46,35],[45,37,46,37],[45,38,46,38],[45,40,46,40],[45,41,46,41],[41,7,42,7],[41,8,42,8],[41,10,42,10],[41,11,42,11],[41,13,42,13],[41,14,42,14],[41,16,42,16],[41,17,42,17],[41,19,42,19],[41,20,42,20],[41,22,42,22],[41,23,42,23],[41,50,42,50],[41,52,42,52],[43,2,44,2],[43,4,44,4],[43,5,44,5],[43,7,44,7],[43,8,44,8],[43,10,44,10],[43,11,44,11],[43,13,44,13],[43,14,44,14],[43,16,44,16],[43,17,44,17],[43,19,44,19],[43,20,44,20],[43,22,44,22],[43,23,44,23],[43,25,44,25],[43,26,44,26],[43,28,44,28],[43,29,44,29],[43,31,44,31],[43,32,44,32],[43,34,44,34],[43,50,44,50],[43,52,44,52],[45,2,46,2],[45,4,46,4],[45,5,46,5],[45,7,46,7],[45,8,46,8],[45,10,46,10],[45,11,46,11],[45,13,46,13],[45,14,46,14],[45,16,46,16],[45,17,46,17],[45,19,46,19],[45,20,46,20],[45,22,46,22],[45,23,46,23],[45,25,46,25],[45,26,46,26],[45,28,46,28],[45,29,46,29],[45,31,46,31],[45,32,46,32],[45,34,46,34],[47,10,48,10],[47,11,48,11],[47,13,48,13],[47,14,48,14],[47,16,48,16],[47,17,48,17],[47,19,48,19],[47,20,48,20],[50,13,51,17],[63,4,64,7],[63,8,64,8],[65,4,66,7],[65,8,66,8],[56,1,57,1],[50,0,51,1],[58,1,59,1],[61,0,62,1],[63,0,64,0],[63,1,64,1],[52,1,53,1],[54,1,55,1],[65,13,66,16],[65,17,66,17],[67,17,68,17],[47,23,48,23],[47,25,48,25],[54,4,55,7],[54,8,55,8],[65,0,66,0],[65,1,66,1],[67,1,68,1],[47,1,48,1],[47,2,48,2],[47,4,48,4],[47,5,48,5],[47,7,48,7],[47,8,48,8],[52,0,53,0],[54,0,55,0],[56,0,57,0],[67,8,68,8],[56,4,57,7],[56,8,57,8],[58,8,59,8],[61,4,62,8],[47,32,48,32],[47,34,48,34],[47,35,48,35],[45,58,46,58],[47,58,48,58],[61,13,62,17],[63,13,64,16],[63,17,64,17],[47,22,48,22],[47,41,48,41],[47,43,48,43],[52,13,53,16],[52,17,53,17],[54,13,55,16],[54,17,55,17],[56,13,57,16],[56,17,57,17],[58,17,59,17],[47,46,48,46],[47,47,48,47],[49,58,50,58],[51,58,52,58],[41,58,42,58],[43,58,44,58],[41,0,46,0],[47,49,48,49],[47,50,48,50],[47,52,48,52],[50,4,51,8],[52,4,53,7],[52,8,53,8],[47,37,48,37],[47,38,48,38],[47,40,48,40],[45,43,46,43],[45,44,46,44],[45,46,46,46],[45,47,46,47],[45,49,46,49],[45,50,46,50],[45,52,46,52],[47,44,48,44],[47,26,48,26],[47,28,48,28],[47,29,48,29],[47,31,48,31]]}
["Skill Matrix"]
[]
[]
[]
["Skills Level Key",null,0,null,{"$f":"IF(C5=1,$BK$6,IF(C5=2,$BL$6,IF(C5=3,$BM$6,IF(C5=4,$BJ$6,$BI$6))))","v":"○"},"Unaware / N/A",null,null,1,null,{"$f":"IF(I5=1,$BK$6,IF(I5=2,$BL$6,IF(I5=3,$BM$6,IF(I5=4,$BJ$6,$BI$6))))","v":"◔"},"Aware of Task",null,null,2,null,{"$f":"IF(O5=1,$BK$6,IF(O5=2,$BL$6,IF(O5=3,$BM$6,IF(O5=4,$BJ$6,$BI$6))))","v":"◑"},"Can Do with Support",null,null,3,null,{"$f":"IF(U5=1,$BK$6,IF(U5=2,$BL$6,IF(U5=3,$BM$6,IF(U5=4,$BJ$6,$BI$6))))","v":"◕"},"Competent",null,null,4,null,{"$f":"IF(AA5=1,$BK$6,IF(AA5=2,$BL$6,IF(AA5=3,$BM$6,IF(AA5=4,$BJ$6,$BI$6))))","v":"●"},"Can Train Others",null,null,"Area",null,null,"Reception Admin"]
[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,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,null,null,"○","●","◔","◑","◕",null,null,null,"Yes"]
["Is the Resource Available →",null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Priority Ranking",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Minimum","Gap","Lead Trainer"]
[]
["Appointment bookings",null,0,{"$f":"IF(AND($C$7=\"Yes\",C10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(C10=1,$BK$6,IF(C10=2,$BL$6,IF(C10=3,$BM$6,IF(C10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($F$7=\"Yes\",F10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(F10=1,$BK$6,IF(F10=2,$BL$6,IF(F10=3,$BM$6,IF(F10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($I$7=\"Yes\",I10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I10=1,$BK$6,IF(I10=2,$BL$6,IF(I10=3,$BM$6,IF(I10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($L$7=\"Yes\",L10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(L10=1,$BK$6,IF(L10=2,$BL$6,IF(L10=3,$BM$6,IF(L10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($O$7=\"Yes\",O10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(O10=1,$BK$6,IF(O10=2,$BL$6,IF(O10=3,$BM$6,IF(O10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($R$7=\"Yes\",R10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R10=1,$BK$6,IF(R10=2,$BL$6,IF(R10=3,$BM$6,IF(R10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($U$7=\"Yes\",U10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(U10=1,$BK$6,IF(U10=2,$BL$6,IF(U10=3,$BM$6,IF(U10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($X$7=\"Yes\",X10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(X10=1,$BK$6,IF(X10=2,$BL$6,IF(X10=3,$BM$6,IF(X10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AA$7=\"Yes\",AA10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AA10=1,$BK$6,IF(AA10=2,$BL$6,IF(AA10=3,$BM$6,IF(AA10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AD$7=\"Yes\",AD10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD10=1,$BK$6,IF(AD10=2,$BL$6,IF(AD10=3,$BM$6,IF(AD10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AG$7=\"Yes\",AG10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG10=1,$BK$6,IF(AG10=2,$BL$6,IF(AG10=3,$BM$6,IF(AG10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AJ10=1,$BK$6,IF(AJ10=2,$BL$6,IF(AJ10=3,$BM$6,IF(AJ10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AM$7=\"Yes\",AM10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AM10=1,$BK$6,IF(AM10=2,$BL$6,IF(AM10=3,$BM$6,IF(AM10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AP$7=\"Yes\",AP10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AP10=1,$BK$6,IF(AP10=2,$BL$6,IF(AP10=3,$BM$6,IF(AP10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AS$7=\"Yes\",AS10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AS10=1,$BK$6,IF(AS10=2,$BL$6,IF(AS10=3,$BM$6,IF(AS10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AV$7=\"Yes\",AV10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AV10=1,$BK$6,IF(AV10=2,$BL$6,IF(AV10=3,$BM$6,IF(AV10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AY$7=\"Yes\",AY10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AY10=1,$BK$6,IF(AY10=2,$BL$6,IF(AY10=3,$BM$6,IF(AY10=4,$BJ$6,$BI$6))))","v":"○"},null,{"$f":"COUNTIF(C10:BB10,\"Yes\")","v":0},0,{"$f":"SUM(BC10)-BD10","v":0},null,{"$f":"IF(BC10>BD10,BE10,(BE10+BD10))","v":0}]
["Book Home visits",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Booking interpretors",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Cancel Clinics",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Close up",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Dealing with Pharmacies",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["F2F patient queries",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Generic emails",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Opening up",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Patient Alerts",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Providing information over the counter / telephone",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Taking Samples over the counter",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Telephone queries",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Accept / Open Post",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Accepting deliveries",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Docman Task",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Give blood results over the phone",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Handing out prescriptions",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Print forms",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Signposting",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Taking preceription requests",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Transport Booking",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Claim forms",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Getting Dr's room ready",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Gold standard framework",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Handing out forms",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Photocopying",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Stocking rooms",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Tasks (EMIS/SystemOne)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Ranking Scores",1,{"$f":"SUMIF($B$10:$B$37,1,C$10:C$37)-COUNTIFS($B$10:$B$37,1,C$10:C$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,F$10:F$37)-COUNTIFS($B$10:$B$37,1,F$10:F$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,I$10:I$37)-COUNTIFS($B$10:$B$37,1,I$10:I$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,L$10:L$37)-COUNTIFS($B$10:$B$37,1,L$10:L$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,O$10:O$37)-COUNTIFS($B$10:$B$37,1,O$10:O$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,R$10:R$37)-COUNTIFS($B$10:$B$37,1,R$10:R$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,U$10:U$37)-COUNTIFS($B$10:$B$37,1,U$10:U$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,X$10:X$37)-COUNTIFS($B$10:$B$37,1,X$10:X$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AA$10:AA$37)-COUNTIFS($B$10:$B$37,1,AA$10:AA$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AD$10:AD$37)-COUNTIFS($B$10:$B$37,1,AD$10:AD$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AG$10:AG$37)-COUNTIFS($B$10:$B$37,1,AG$10:AG$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AJ$10:AJ$37)-COUNTIFS($B$10:$B$37,1,AJ$10:AJ$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AM$10:AM$37)-COUNTIFS($B$10:$B$37,1,AM$10:AM$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AP$10:AP$37)-COUNTIFS($B$10:$B$37,1,AP$10:AP$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AS$10:AS$37)-COUNTIFS($B$10:$B$37,1,AS$10:AS$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AV$10:AV$37)-COUNTIFS($B$10:$B$37,1,AV$10:AV$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,1,AY$10:AY$37)-COUNTIFS($B$10:$B$37,1,AY$10:AY$37,4)","v":0}]
[]
[null,2,{"$f":"SUMIF($B$10:$B$37,2,C$10:C$37)-COUNTIFS($B$10:$B$37,2,C$10:C$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,F$10:F$37)-COUNTIFS($B$10:$B$37,2,F$10:F$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,I$10:I$37)-COUNTIFS($B$10:$B$37,2,I$10:I$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,L$10:L$37)-COUNTIFS($B$10:$B$37,2,L$10:L$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,O$10:O$37)-COUNTIFS($B$10:$B$37,2,O$10:O$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,R$10:R$37)-COUNTIFS($B$10:$B$37,2,R$10:R$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,U$10:U$37)-COUNTIFS($B$10:$B$37,2,U$10:U$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,X$10:X$37)-COUNTIFS($B$10:$B$37,2,X$10:X$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AA$10:AA$37)-COUNTIFS($B$10:$B$37,2,AA$10:AA$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AD$10:AD$37)-COUNTIFS($B$10:$B$37,2,AD$10:AD$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AG$10:AG$37)-COUNTIFS($B$10:$B$37,2,AG$10:AG$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AJ$10:AJ$37)-COUNTIFS($B$10:$B$37,2,AJ$10:AJ$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AM$10:AM$37)-COUNTIFS($B$10:$B$37,2,AM$10:AM$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AP$10:AP$37)-COUNTIFS($B$10:$B$37,2,AP$10:AP$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AS$10:AS$37)-COUNTIFS($B$10:$B$37,2,AS$10:AS$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AV$10:AV$37)-COUNTIFS($B$10:$B$37,2,AV$10:AV$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,2,AY$10:AY$37)-COUNTIFS($B$10:$B$37,2,AY$10:AY$37,4)","v":0}]
[]
[null,3,{"$f":"SUMIF($B$10:$B$37,3,C$10:C$37)-COUNTIFS($B$10:$B$37,3,C$10:C$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,F$10:F$37)-COUNTIFS($B$10:$B$37,3,F$10:F$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,I$10:I$37)-COUNTIFS($B$10:$B$37,3,I$10:I$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,L$10:L$37)-COUNTIFS($B$10:$B$37,3,L$10:L$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,O$10:O$37)-COUNTIFS($B$10:$B$37,3,O$10:O$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,R$10:R$37)-COUNTIFS($B$10:$B$37,3,R$10:R$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,U$10:U$37)-COUNTIFS($B$10:$B$37,3,U$10:U$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,X$10:X$37)-COUNTIFS($B$10:$B$37,3,X$10:X$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AA$10:AA$37)-COUNTIFS($B$10:$B$37,3,AA$10:AA$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AD$10:AD$37)-COUNTIFS($B$10:$B$37,3,AD$10:AD$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AG$10:AG$37)-COUNTIFS($B$10:$B$37,3,AG$10:AG$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AJ$10:AJ$37)-COUNTIFS($B$10:$B$37,3,AJ$10:AJ$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AM$10:AM$37)-COUNTIFS($B$10:$B$37,3,AM$10:AM$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AP$10:AP$37)-COUNTIFS($B$10:$B$37,3,AP$10:AP$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AS$10:AS$37)-COUNTIFS($B$10:$B$37,3,AS$10:AS$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AV$10:AV$37)-COUNTIFS($B$10:$B$37,3,AV$10:AV$37,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$37,3,AY$10:AY$37)-COUNTIFS($B$10:$B$37,3,AY$10:AY$37,4)","v":0}]
[]
[null,"Total",{"$f":"SUM(C42:C47)","v":0},null,null,{"$f":"SUM(F42:F47)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[]
["Vesatility Max Score",null,null,null,"Vesatility Max Score - 1",null,null,null,null,null,null,null,null,"Vesatility Max Score - 2"]
[]
["No. Skills",{"$f":"COUNTA(A10:A41)","v":29},null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B37,1)","v":0},null,null,null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B37,2)","v":0}]
[]
["Max Score",3,null,null,"Max Score",null,null,null,{"$f":"B55","v":3},null,null,null,null,"Max Score",null,null,null,{"$f":"B55","v":3}]
[]
["Number Staff",{"$f":"COUNTA(C8:BA9)","v":0},null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0},null,null,null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0}]
[]
[null,{"$f":"B53*B55*B57","v":0},null,null,null,null,null,null,{"$f":"I53*I55*I57","v":0},null,null,null,null,null,null,null,null,{"$f":"R53*R55*R57","v":0}]
[]
[]
["Team Score",null,null,null,"Team Score - 1",null,null,null,null,null,null,null,null,"Team Score - 2"]
[]
["Total Team Score",{"$f":"SUM(C48:AY49)","v":0},null,null,"Total Team Score",null,null,null,{"$f":"SUM(C42:AY43)","v":0},null,null,null,null,"Total Team Score",null,null,null,{"$f":"SUM(C44:AY45)","v":0}]
[]
["Vesatility Max Score",{"$f":"B59","v":0},null,null,"Vesatility Max Score",null,null,null,{"$f":"I59","v":0},null,null,null,null,"Vesatility Max Score",null,null,null,{"$f":"R59","v":0}]
[]
[null,{"$f":"(B64/B66)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"(I64/I66)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"(R64/R66)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Skills Matrix Admin","index":2,"n_rows":74,"n_cols":69,"rows_kept":74,"cut":false,"hidden":false,"merged":[[6,50,6,52],[6,2,6,4],[6,5,6,7],[69,0,70,0],[71,0,72,0],[62,0,63,0],[51,1,52,1],[53,1,54,1],[47,0,52,0],[47,1,48,1],[47,2,48,2],[60,0,61,0],[60,1,61,1],[6,11,6,13],[6,14,6,16],[6,17,6,19],[6,20,6,22],[6,23,6,25],[6,26,6,28],[6,29,6,31],[6,32,6,34],[6,35,6,37],[6,38,6,40],[6,41,6,43],[0,0,3,57],[4,35,5,57],[7,54,8,54],[7,55,8,55],[7,56,8,56],[7,57,8,57],[4,20,5,20],[4,22,5,22],[4,2,5,2],[4,4,5,4],[4,5,5,7],[4,8,5,8],[4,10,5,10],[4,23,5,25],[4,26,5,26],[4,28,5,28],[4,29,5,31],[4,32,5,34],[4,11,5,13],[4,14,5,14],[4,16,5,16],[4,17,5,19],[4,0,5,1],[6,8,6,10],[6,44,6,46],[6,47,6,49],[7,0,8,0],[7,2,8,4],[7,5,8,7],[7,8,8,10],[7,11,8,13],[7,14,8,16],[7,44,8,46],[7,47,8,49],[7,1,8,1],[6,0,6,1],[7,50,8,52],[7,17,8,19],[7,20,8,22],[7,23,8,25],[7,26,8,28],[7,29,8,31],[7,32,8,34],[7,53,8,53],[7,35,8,37],[7,38,8,40],[7,41,8,43],[47,19,48,19],[47,20,48,20],[47,22,48,22],[47,23,48,23],[47,25,48,25],[47,4,48,4],[47,26,48,26],[47,28,48,28],[47,29,48,29],[47,5,48,5],[47,7,48,7],[47,8,48,8],[47,10,48,10],[47,11,48,11],[47,13,48,13],[47,14,48,14],[47,16,48,16],[47,17,48,17],[47,31,48,31],[47,32,48,32],[47,34,48,34],[47,35,48,35],[47,37,48,37],[47,38,48,38],[47,40,48,40],[47,41,48,41],[47,43,48,43],[47,44,48,44],[47,46,48,46],[47,47,48,47],[47,49,48,49],[47,50,48,50],[47,52,48,52],[49,1,50,1],[49,2,50,2],[49,4,50,4],[49,5,50,5],[49,7,50,7],[49,8,50,8],[49,10,50,10],[49,11,50,11],[49,13,50,13],[49,14,50,14],[49,16,50,16],[49,17,50,17],[49,19,50,19],[49,20,50,20],[49,22,50,22],[49,23,50,23],[49,25,50,25],[49,26,50,26],[49,28,50,28],[49,29,50,29],[49,31,50,31],[49,32,50,32],[49,34,50,34],[49,35,50,35],[49,37,50,37],[49,38,50,38],[49,40,50,40],[49,41,50,41],[49,43,50,43],[49,44,50,44],[49,46,50,46],[49,47,50,47],[49,49,50,49],[49,50,50,50],[49,52,50,52],[51,2,52,2],[51,4,52,4],[51,5,52,5],[51,7,52,7],[51,8,52,8],[51,10,52,10],[51,11,52,11],[51,13,52,13],[51,14,52,14],[51,16,52,16],[51,17,52,17],[51,19,52,19],[51,20,52,20],[51,22,52,22],[51,23,52,23],[51,25,52,25],[51,26,52,26],[51,28,52,28],[51,29,52,29],[51,31,52,31],[51,32,52,32],[51,34,52,34],[51,35,52,35],[51,37,52,37],[51,38,52,38],[51,40,52,40],[51,41,52,41],[51,43,52,43],[51,44,52,44],[51,46,52,46],[51,47,52,47],[51,49,52,49],[51,50,52,50],[51,52,52,52],[53,23,54,23],[53,25,54,25],[53,26,54,26],[53,28,54,28],[53,2,54,2],[53,4,54,4],[53,5,54,5],[53,7,54,7],[53,8,54,8],[53,10,54,10],[53,11,54,11],[53,13,54,13],[53,14,54,14],[53,43,54,43],[53,44,54,44],[53,46,54,46],[53,47,54,47],[53,49,54,49],[53,50,54,50],[53,52,54,52],[56,0,57,1],[56,4,57,8],[56,13,57,17],[53,29,54,29],[53,31,54,31],[53,32,54,32],[53,34,54,34],[53,35,54,35],[53,37,54,37],[53,38,54,38],[53,40,54,40],[53,41,54,41],[53,16,54,16],[53,17,54,17],[53,19,54,19],[53,20,54,20],[53,22,54,22],[58,0,59,0],[58,1,59,1],[58,4,59,7],[58,8,59,8],[58,13,59,16],[58,17,59,17],[60,4,61,7],[60,8,61,8],[60,13,61,16],[60,17,61,17],[73,1,74,1],[73,8,74,8],[73,17,74,17],[62,1,63,1],[62,4,63,7],[62,8,63,8],[62,13,63,16],[62,17,63,17],[64,1,65,1],[64,8,65,8],[64,17,65,17],[67,0,68,1],[67,4,68,8],[67,13,68,17],[69,1,70,1],[69,4,70,7],[69,8,70,8],[69,13,70,16],[69,17,70,17],[71,1,72,1],[71,4,72,7],[71,8,72,8],[71,13,72,16],[71,17,72,17]]}
["Skill Matrix"]
[]
[]
[]
["Skills Level Key",null,0,null,{"$f":"IF(C5=1,$BK$6,IF(C5=2,$BL$6,IF(C5=3,$BM$6,IF(C5=4,$BJ$6,$BI$6))))","v":"○"},"Unaware / N/A",null,null,1,null,{"$f":"IF(I5=1,$BK$6,IF(I5=2,$BL$6,IF(I5=3,$BM$6,IF(I5=4,$BJ$6,$BI$6))))","v":"◔"},"Aware of Task",null,null,2,null,{"$f":"IF(O5=1,$BK$6,IF(O5=2,$BL$6,IF(O5=3,$BM$6,IF(O5=4,$BJ$6,$BI$6))))","v":"◑"},"Can Do with Support",null,null,3,null,{"$f":"IF(U5=1,$BK$6,IF(U5=2,$BL$6,IF(U5=3,$BM$6,IF(U5=4,$BJ$6,$BI$6))))","v":"◕"},"Competent",null,null,4,null,{"$f":"IF(AA5=1,$BK$6,IF(AA5=2,$BL$6,IF(AA5=3,$BM$6,IF(AA5=4,$BJ$6,$BI$6))))","v":"●"},"Can Train Others",null,null,"Area",null,null,"Reception Admin"]
[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,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,null,null,"○","●","◔","◑","◕",null,null,null,"Yes"]
["Is the Resource Available →",null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Priority Ranking",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Minimum","Gap","Lead Trainer"]
[]
["Patient Access / Online (A)",null,0,{"$f":"IF(AND($C$7=\"Yes\",C10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(C10=1,$BK$6,IF(C10=2,$BL$6,IF(C10=3,$BM$6,IF(C10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($C$7=\"Yes\",F10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(F10=1,$BK$6,IF(F10=2,$BL$6,IF(F10=3,$BM$6,IF(F10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($I$7=\"Yes\",I10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I10=1,$BK$6,IF(I10=2,$BL$6,IF(I10=3,$BM$6,IF(I10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($L$7=\"Yes\",L10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(L10=1,$BK$6,IF(L10=2,$BL$6,IF(L10=3,$BM$6,IF(L10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($O$7=\"Yes\",O10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(O10=1,$BK$6,IF(O10=2,$BL$6,IF(O10=3,$BM$6,IF(O10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($R$7=\"Yes\",R10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R10=1,$BK$6,IF(R10=2,$BL$6,IF(R10=3,$BM$6,IF(R10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($U$7=\"Yes\",U10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(U10=1,$BK$6,IF(U10=2,$BL$6,IF(U10=3,$BM$6,IF(U10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($X$7=\"Yes\",X10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(X10=1,$BK$6,IF(X10=2,$BL$6,IF(X10=3,$BM$6,IF(X10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AA$7=\"Yes\",AA10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AA10=1,$BK$6,IF(AA10=2,$BL$6,IF(AA10=3,$BM$6,IF(AA10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AD$7=\"Yes\",AD10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD10=1,$BK$6,IF(AD10=2,$BL$6,IF(AD10=3,$BM$6,IF(AD10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AG$7=\"Yes\",AG10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG10=1,$BK$6,IF(AG10=2,$BL$6,IF(AG10=3,$BM$6,IF(AG10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AJ10=1,$BK$6,IF(AJ10=2,$BL$6,IF(AJ10=3,$BM$6,IF(AJ10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AM$7=\"Yes\",AM10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AM10=1,$BK$6,IF(AM10=2,$BL$6,IF(AM10=3,$BM$6,IF(AM10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AP$7=\"Yes\",AP10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AP10=1,$BK$6,IF(AP10=2,$BL$6,IF(AP10=3,$BM$6,IF(AP10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AS$7=\"Yes\",AS10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AS10=1,$BK$6,IF(AS10=2,$BL$6,IF(AS10=3,$BM$6,IF(AS10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AV$7=\"Yes\",AV10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AV10=1,$BK$6,IF(AV10=2,$BL$6,IF(AV10=3,$BM$6,IF(AV10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AY$7=\"Yes\",AY10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AY10=1,$BK$6,IF(AY10=2,$BL$6,IF(AY10=3,$BM$6,IF(AY10=4,$BJ$6,$BI$6))))","v":"○"},null,{"$f":"COUNTIF(C10:BB10,\"Yes\")","v":0},0,{"$f":"BC10-BD10","v":0},null,{"$f":"IF(BC10>BD10,BE10,(BE10+BD10))","v":0}]
["Prescriptions (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Rotas",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Safeguarding (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Scanning (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Telephone",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Births / Deaths ",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Building reports (Comlpex)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Building reports (Simple)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["GP2GP (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["PDS Patients (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Post/franking (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Referrals (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Registrations (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["SARS Redacting",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Website Updates (A)",null,0,"No","○",0,{"$f":"IF(AND($F$7=\"Yes\",F25>=3),\"Yes\",\"No\")","v":"No"},"○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Building Templates",null,0,"No","○",0,{"$f":"IF(AND($C$7=\"Yes\",F26>=3),\"Yes\",\"No\")","v":"No"},"○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Childhood Imms Claims (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Coding",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["DNAs (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Docman Filing",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Finance (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Friends & Family Result Upload (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Iplato/Mjog (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Medical Reports (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Notes Summarising (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["OOA Patients (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Open Exeter",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Patient Complaints (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Patient Health Questionnaires (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["PPA Claims (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Private Work (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["QOF Processing",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Recalls (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Stationary Ordering",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Workflow (A)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Ranking Scores",1,0,null,null,{"$f":"SUMIF($B$10:$B$47,1,F$10:F$47)-COUNTIFS($B$10:$B$47,1,F$10:F$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,I$10:I$47)-COUNTIFS($B$10:$B$47,1,I$10:I$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,L$10:L$47)-COUNTIFS($B$10:$B$47,1,L$10:L$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,O$10:O$47)-COUNTIFS($B$10:$B$47,1,O$10:O$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,R$10:R$47)-COUNTIFS($B$10:$B$47,1,R$10:R$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,U$10:U$47)-COUNTIFS($B$10:$B$47,1,U$10:U$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,X$10:X$47)-COUNTIFS($B$10:$B$47,1,X$10:X$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AA$10:AA$47)-COUNTIFS($B$10:$B$47,1,AA$10:AA$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AD$10:AD$47)-COUNTIFS($B$10:$B$47,1,AD$10:AD$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AG$10:AG$47)-COUNTIFS($B$10:$B$47,1,AG$10:AG$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AJ$10:AJ$47)-COUNTIFS($B$10:$B$47,1,AJ$10:AJ$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AM$10:AM$47)-COUNTIFS($B$10:$B$47,1,AM$10:AM$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AP$10:AP$47)-COUNTIFS($B$10:$B$47,1,AP$10:AP$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AS$10:AS$47)-COUNTIFS($B$10:$B$47,1,AS$10:AS$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AV$10:AV$47)-COUNTIFS($B$10:$B$47,1,AV$10:AV$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,1,AY$10:AY$47)-COUNTIFS($B$10:$B$47,1,AY$10:AY$47,4)","v":0}]
[]
[null,2,{"$f":"SUMIF($B$10:$B$47,2,C$10:C$47)-COUNTIFS($B$10:$B$47,2,C$10:C$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,F$10:F$47)-COUNTIFS($B$10:$B$47,2,F$10:F$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,I$10:I$47)-COUNTIFS($B$10:$B$47,2,I$10:I$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,L$10:L$47)-COUNTIFS($B$10:$B$47,2,L$10:L$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,O$10:O$47)-COUNTIFS($B$10:$B$47,2,O$10:O$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,R$10:R$47)-COUNTIFS($B$10:$B$47,2,R$10:R$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,U$10:U$47)-COUNTIFS($B$10:$B$47,2,U$10:U$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,X$10:X$47)-COUNTIFS($B$10:$B$47,2,X$10:X$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AA$10:AA$47)-COUNTIFS($B$10:$B$47,2,AA$10:AA$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AD$10:AD$47)-COUNTIFS($B$10:$B$47,2,AD$10:AD$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AG$10:AG$47)-COUNTIFS($B$10:$B$47,2,AG$10:AG$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AJ$10:AJ$47)-COUNTIFS($B$10:$B$47,2,AJ$10:AJ$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AM$10:AM$47)-COUNTIFS($B$10:$B$47,2,AM$10:AM$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AP$10:AP$47)-COUNTIFS($B$10:$B$47,2,AP$10:AP$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AS$10:AS$47)-COUNTIFS($B$10:$B$47,2,AS$10:AS$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AV$10:AV$47)-COUNTIFS($B$10:$B$47,2,AV$10:AV$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,2,AY$10:AY$47)-COUNTIFS($B$10:$B$47,2,AY$10:AY$47,4)","v":0}]
[]
[null,3,{"$f":"SUMIF($B$10:$B$47,3,C$10:C$47)-COUNTIFS($B$10:$B$47,3,C$10:C$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,F$10:F$47)-COUNTIFS($B$10:$B$47,3,F$10:F$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,I$10:I$47)-COUNTIFS($B$10:$B$47,3,I$10:I$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,L$10:L$47)-COUNTIFS($B$10:$B$47,3,L$10:L$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,O$10:O$47)-COUNTIFS($B$10:$B$47,3,O$10:O$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,R$10:R$47)-COUNTIFS($B$10:$B$47,3,R$10:R$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,U$10:U$47)-COUNTIFS($B$10:$B$47,3,U$10:U$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,X$10:X$47)-COUNTIFS($B$10:$B$47,3,X$10:X$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AA$10:AA$47)-COUNTIFS($B$10:$B$47,3,AA$10:AA$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AD$10:AD$47)-COUNTIFS($B$10:$B$47,3,AD$10:AD$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AG$10:AG$47)-COUNTIFS($B$10:$B$47,3,AG$10:AG$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AJ$10:AJ$47)-COUNTIFS($B$10:$B$47,3,AJ$10:AJ$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AM$10:AM$47)-COUNTIFS($B$10:$B$47,3,AM$10:AM$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AP$10:AP$47)-COUNTIFS($B$10:$B$47,3,AP$10:AP$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AS$10:AS$47)-COUNTIFS($B$10:$B$47,3,AS$10:AS$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AV$10:AV$47)-COUNTIFS($B$10:$B$47,3,AV$10:AV$47,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$47,3,AY$10:AY$47)-COUNTIFS($B$10:$B$47,3,AY$10:AY$47,4)","v":0}]
[]
[null,"Total",{"$f":"SUM(C48:C53)","v":0},null,null,{"$f":"SUM(F48:F53)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[]
["Vesatility Max Score",null,null,null,"Vesatility Max Score - 1",null,null,null,null,null,null,null,null,"Vesatility Max Score - 2"]
[]
["No. Skills",{"$f":"COUNTA(A10:A47)","v":36},null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B47,1)","v":0},null,null,null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B47,2)","v":0}]
[]
["Max Score",3,null,null,"Max Score",null,null,null,{"$f":"B61","v":3},null,null,null,null,"Max Score",null,null,null,{"$f":"B61","v":3}]
[]
["Number Staff",{"$f":"COUNTA(C8:BA9)","v":0},null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0},null,null,null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0}]
[]
[null,{"$f":"B59*B61*B63","v":0},null,null,null,null,null,null,{"$f":"I59*I61*I63","v":0},null,null,null,null,null,null,null,null,{"$f":"R59*R61*R63","v":0}]
[]
[]
["Team Score",null,null,null,"Team Score - 1",null,null,null,null,null,null,null,null,"Team Score - 2"]
[]
["Total Team Score",{"$f":"SUM(C54:AY55)","v":0},null,null,"Total Team Score",null,null,null,{"$f":"SUM(C48:AY49)","v":0},null,null,null,null,"Total Team Score",null,null,null,{"$f":"SUM(C50:AY51)","v":0}]
[]
["Vesatility Max Score",{"$f":"B65","v":0},null,null,"Vesatility Max Score",null,null,null,{"$f":"I65","v":0},null,null,null,null,"Vesatility Max Score",null,null,null,{"$f":"R65","v":0}]
[]
[null,{"$f":"(B70/B72)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"(I70/I72)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"(R70/R72)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Skills Matrix Nurses","index":3,"n_rows":70,"n_cols":69,"rows_kept":70,"cut":false,"hidden":false,"merged":[[52,39,53,39],[52,33,53,33],[52,36,53,36],[34,30,35,30],[36,30,37,30],[38,30,39,30],[40,30,41,30],[52,30,53,30],[34,33,35,33],[34,35,35,35],[34,37,35,37],[34,38,35,38],[36,38,37,38],[40,39,41,39],[52,48,53,48],[34,51,35,51],[36,51,37,51],[52,51,53,51],[52,42,53,42],[34,45,35,45],[36,45,37,45],[38,45,39,45],[40,45,41,45],[52,45,53,45],[40,47,41,47],[40,49,41,49],[40,50,41,50],[45,8,46,8],[45,13,46,16],[45,17,46,17],[47,8,48,8],[36,33,37,33],[38,33,39,33],[40,33,41,33],[34,27,35,27],[36,27,37,27],[38,27,39,27],[40,27,41,27],[34,29,35,29],[34,31,35,31],[34,32,35,32],[36,24,37,24],[36,28,37,28],[36,29,37,29],[36,31,37,31],[36,32,37,32],[38,24,39,24],[38,28,39,28],[38,29,39,29],[38,31,39,31],[38,32,39,32],[6,23,6,25],[6,26,6,28],[6,29,6,31],[52,18,53,18],[34,21,35,21],[36,21,37,21],[34,9,35,9],[36,9,37,9],[38,9,39,9],[34,12,35,12],[36,15,37,15],[36,12,37,12],[36,18,37,18],[38,15,39,15],[38,12,39,12],[38,18,39,18],[38,21,39,21],[40,15,41,15],[52,27,53,27],[52,21,53,21],[52,24,53,24],[40,26,41,26],[34,17,35,17],[40,16,41,16],[6,32,6,34],[6,35,6,37],[6,38,6,40],[6,41,6,43],[6,44,6,46],[6,47,6,49],[6,50,6,52],[34,3,35,3],[7,38,8,40],[7,41,8,43],[7,44,8,46],[7,47,8,49],[7,50,8,52],[34,19,35,19],[34,20,35,20],[34,22,35,22],[34,23,35,23],[34,25,35,25],[34,26,35,26],[34,15,35,15],[34,24,35,24],[34,18,35,18],[34,28,35,28],[34,34,35,34],[7,53,8,53],[7,54,8,54],[7,55,8,55],[7,56,8,56],[7,57,8,57],[6,2,6,4],[38,3,39,3],[40,3,41,3],[42,3,43,3],[7,35,8,37],[7,17,8,19],[7,20,8,22],[7,23,8,25],[7,26,8,28],[7,29,8,31],[7,32,8,34],[34,5,35,5],[34,7,35,7],[34,8,35,8],[34,10,35,10],[34,11,35,11],[34,13,35,13],[34,14,35,14],[34,16,35,16],[7,0,8,0],[7,2,8,4],[7,5,8,7],[7,8,8,10],[7,11,8,13],[7,14,8,16],[4,17,5,19],[4,20,5,20],[4,22,5,22],[7,1,8,1],[6,5,6,7],[6,8,6,10],[6,11,6,13],[6,14,6,16],[6,17,6,19],[6,20,6,22],[6,0,6,1],[0,0,3,57],[4,2,5,2],[4,4,5,4],[4,5,5,7],[4,8,5,8],[4,10,5,10],[4,11,5,13],[4,14,5,14],[4,16,5,16],[4,0,5,1],[4,29,5,31],[4,32,5,34],[4,35,5,57],[4,23,5,25],[4,26,5,26],[4,28,5,28],[34,0,39,0],[34,1,35,1],[36,1,37,1],[38,1,39,1],[40,1,41,1],[43,0,44,1],[51,1,52,1],[34,2,35,2],[34,4,35,4],[45,0,46,0],[45,1,46,1],[45,4,46,7],[47,0,48,0],[47,1,48,1],[47,4,48,7],[44,3,45,3],[46,3,47,3],[48,3,49,3],[50,3,51,3],[52,3,53,3],[36,3,37,3],[34,6,35,6],[36,6,37,6],[38,6,39,6],[34,40,35,40],[34,41,35,41],[34,43,35,43],[34,44,35,44],[34,46,35,46],[34,39,35,39],[34,47,35,47],[34,49,35,49],[34,50,35,50],[34,52,35,52],[34,36,35,36],[34,48,35,48],[34,42,35,42],[36,2,37,2],[36,4,37,4],[36,5,37,5],[36,7,37,7],[36,8,37,8],[36,10,37,10],[36,11,37,11],[36,13,37,13],[36,14,37,14],[36,16,37,16],[36,17,37,17],[36,19,37,19],[36,20,37,20],[36,22,37,22],[36,23,37,23],[36,25,37,25],[36,26,37,26],[36,34,37,34],[36,35,37,35],[36,37,37,37],[36,40,37,40],[36,41,37,41],[36,43,37,43],[36,44,37,44],[36,46,37,46],[36,39,37,39],[36,47,37,47],[36,49,37,49],[36,50,37,50],[36,52,37,52],[36,36,37,36],[36,48,37,48],[36,42,37,42],[38,2,39,2],[38,4,39,4],[38,5,39,5],[38,7,39,7],[38,8,39,8],[38,10,39,10],[38,11,39,11],[38,13,39,13],[38,14,39,14],[38,16,39,16],[38,17,39,17],[38,19,39,19],[38,20,39,20],[38,22,39,22],[38,23,39,23],[38,25,39,25],[38,26,39,26],[38,47,39,47],[38,49,39,49],[38,50,39,50],[40,22,41,22],[40,23,41,23],[40,25,41,25],[38,34,39,34],[38,35,39,35],[40,2,41,2],[40,4,41,4],[40,5,41,5],[40,7,41,7],[40,8,41,8],[40,10,41,10],[40,11,41,11],[40,13,41,13],[40,14,41,14],[40,6,41,6],[40,28,41,28],[40,29,41,29],[40,31,41,31],[40,32,41,32],[38,52,39,52],[38,36,39,36],[38,48,39,48],[38,42,39,42],[38,51,39,51],[38,37,39,37],[38,38,39,38],[38,40,39,40],[38,41,39,41],[38,43,39,43],[38,44,39,44],[38,46,39,46],[38,39,39,39],[40,52,41,52],[40,36,41,36],[40,48,41,48],[40,51,41,51],[40,42,41,42],[43,4,44,8],[43,13,44,17],[40,34,41,34],[40,35,41,35],[40,37,41,37],[40,38,41,38],[40,40,41,40],[40,41,41,41],[40,43,41,43],[40,44,41,44],[40,46,41,46],[40,24,41,24],[40,12,41,12],[40,18,41,18],[40,9,41,9],[40,21,41,21],[40,17,41,17],[40,19,41,19],[40,20,41,20],[47,13,48,16],[47,17,48,17],[49,0,50,0],[49,1,50,1],[49,4,50,7],[49,8,50,8],[49,13,50,16],[49,17,50,17],[51,8,52,8],[51,17,52,17],[52,6,53,6],[60,8,61,8],[60,17,61,17],[56,1,57,1],[58,1,59,1],[60,1,61,1],[54,3,55,3],[56,3,57,3],[58,3,59,3],[52,15,53,15],[52,12,53,12],[52,9,53,9],[54,0,55,1],[54,4,55,8],[54,13,55,17],[56,0,57,0],[56,4,57,7],[56,8,57,8],[56,13,57,16],[56,17,57,17],[58,0,59,0],[58,4,59,7],[58,8,59,8],[58,13,59,16],[58,17,59,17],[52,58,53,58],[54,58,55,58],[56,58,57,58],[58,58,59,58],[34,58,35,58],[36,58,37,58],[38,58,39,58],[40,58,41,58],[42,58,43,58],[44,58,45,58],[46,58,47,58],[48,58,49,58],[50,58,51,58]]}
["Skill Matrix"]
[]
[]
[]
["Skills Level Key",null,0,null,{"$f":"IF(C5=1,$BK$6,IF(C5=2,$BL$6,IF(C5=3,$BM$6,IF(C5=4,$BJ$6,$BI$6))))","v":"○"},"Unaware / N/A",null,null,1,null,{"$f":"IF(I5=1,$BK$6,IF(I5=2,$BL$6,IF(I5=3,$BM$6,IF(I5=4,$BJ$6,$BI$6))))","v":"◔"},"Aware of Task",null,null,2,null,{"$f":"IF(O5=1,$BK$6,IF(O5=2,$BL$6,IF(O5=3,$BM$6,IF(O5=4,$BJ$6,$BI$6))))","v":"◑"},"Can Do with Support",null,null,3,null,{"$f":"IF(U5=1,$BK$6,IF(U5=2,$BL$6,IF(U5=3,$BM$6,IF(U5=4,$BJ$6,$BI$6))))","v":"◕"},"Competent",null,null,4,null,{"$f":"IF(AA5=1,$BK$6,IF(AA5=2,$BL$6,IF(AA5=3,$BM$6,IF(AA5=4,$BJ$6,$BI$6))))","v":"●"},"Can Train Others",null,null,"Area",null,null,"Nurses"]
[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,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,null,null,"○","●","◔","◑","◕",null,null,null,"Yes"]
["Is the Resource Available →",null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Priority Ranking",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Minimum","Gap","Lead Trainer"]
[]
["Baby Imms",null,0,{"$f":"IF(AND($C$7=\"Yes\",C10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(C10=1,$BK$6,IF(C10=2,$BL$6,IF(C10=3,$BM$6,IF(C10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($F$7=\"Yes\",F10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(F10=1,$BK$6,IF(F10=2,$BL$6,IF(F10=3,$BM$6,IF(F10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($I$7=\"Yes\",I10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I10=1,$BK$6,IF(I10=2,$BL$6,IF(I10=3,$BM$6,IF(I10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($L$7=\"Yes\",L10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(L10=1,$BK$6,IF(L10=2,$BL$6,IF(L10=3,$BM$6,IF(L10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($O$7=\"Yes\",O10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(O10=1,$BK$6,IF(O10=2,$BL$6,IF(O10=3,$BM$6,IF(O10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($R$7=\"Yes\",R10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R10=1,$BK$6,IF(R10=2,$BL$6,IF(R10=3,$BM$6,IF(R10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($U$7=\"Yes\",U10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(U10=1,$BK$6,IF(U10=2,$BL$6,IF(U10=3,$BM$6,IF(U10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($X$7=\"Yes\",X10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(X10=1,$BK$6,IF(X10=2,$BL$6,IF(X10=3,$BM$6,IF(X10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AA$7=\"Yes\",AA10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AA10=1,$BK$6,IF(AA10=2,$BL$6,IF(AA10=3,$BM$6,IF(AA10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AD$7=\"Yes\",AD10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD10=1,$BK$6,IF(AD10=2,$BL$6,IF(AD10=3,$BM$6,IF(AD10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AG$7=\"Yes\",AG10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG10=1,$BK$6,IF(AG10=2,$BL$6,IF(AG10=3,$BM$6,IF(AG10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AJ10=1,$BK$6,IF(AJ10=2,$BL$6,IF(AJ10=3,$BM$6,IF(AJ10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AM$7=\"Yes\",AM10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AM10=1,$BK$6,IF(AM10=2,$BL$6,IF(AM10=3,$BM$6,IF(AM10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AP$7=\"Yes\",AP10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AP10=1,$BK$6,IF(AP10=2,$BL$6,IF(AP10=3,$BM$6,IF(AP10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AS$7=\"Yes\",AS10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AS10=1,$BK$6,IF(AS10=2,$BL$6,IF(AS10=3,$BM$6,IF(AS10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AV$7=\"Yes\",AV10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AV10=1,$BK$6,IF(AV10=2,$BL$6,IF(AV10=3,$BM$6,IF(AV10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AY$7=\"Yes\",AY10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AY10=1,$BK$6,IF(AY10=2,$BL$6,IF(AY10=3,$BM$6,IF(AY10=4,$BJ$6,$BI$6))))","v":"○"},null,{"$f":"COUNTIF(C10:BB10,\"Yes\")","v":0},0,{"$f":"SUM(BC10)-BD10","v":0},null,{"$f":"IF(BC10>BD10,BE10,(BE10+BD10))","v":0}]
["Blood Test (Nurse for urgent only)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Dressing",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["ECG (Nurse if urgent or no HCA)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Recording fridge temperatures",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["24 hour bp”",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Asthma",null,0,"No","○",0,"No","○",0,"No","○",0,{"$f":"IF(AND($I$7=\"Yes\",L16>=3),\"Yes\",\"No\")","v":"No"},"○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Blood pressure",null,0,"No","○",0,"No","○",0,"No","○",0,{"$f":"IF(AND($L$7=\"Yes\",L17>=3),\"Yes\",\"No\")","v":"No"},"○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Cervical Smear",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Contraception",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["COPD",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Doppler",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Injections**",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Ordering",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Stock take",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Swabs",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Coil Removal Only",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Diabetic Check*",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Diabetic Foot Check",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Ear Syringe",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Spirometry***",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Travel Vaccines****",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Ranking Scores",1,{"$f":"SUMIF($B$10:$B$34,1,C$10:C$34)-COUNTIFS($B$10:$B$34,1,C$10:C$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,F$10:F$34)-COUNTIFS($B$10:$B$34,1,F$10:F$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,I$10:I$34)-COUNTIFS($B$10:$B$34,1,I$10:I$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,L$10:L$34)-COUNTIFS($B$10:$B$34,1,L$10:L$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,O$10:O$34)-COUNTIFS($B$10:$B$34,1,O$10:O$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,R$10:R$34)-COUNTIFS($B$10:$B$34,1,R$10:R$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,U$10:U$34)-COUNTIFS($B$10:$B$34,1,U$10:U$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,X$10:X$34)-COUNTIFS($B$10:$B$34,1,X$10:X$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AA$10:AA$34)-COUNTIFS($B$10:$B$34,1,AA$10:AA$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AD$10:AD$34)-COUNTIFS($B$10:$B$34,1,AD$10:AD$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AG$10:AG$34)-COUNTIFS($B$10:$B$34,1,AG$10:AG$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AJ$10:AJ$34)-COUNTIFS($B$10:$B$34,1,AJ$10:AJ$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AM$10:AM$34)-COUNTIFS($B$10:$B$34,1,AM$10:AM$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AP$10:AP$34)-COUNTIFS($B$10:$B$34,1,AP$10:AP$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AS$10:AS$34)-COUNTIFS($B$10:$B$34,1,AS$10:AS$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AV$10:AV$34)-COUNTIFS($B$10:$B$34,1,AV$10:AV$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,1,AY$10:AY$34)-COUNTIFS($B$10:$B$34,1,AY$10:AY$34,4)","v":0}]
[]
[null,2,{"$f":"SUMIF($B$10:$B$34,2,C$10:C$34)-COUNTIFS($B$10:$B$34,2,C$10:C$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,F$10:F$34)-COUNTIFS($B$10:$B$34,2,F$10:F$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,I$10:I$34)-COUNTIFS($B$10:$B$34,2,I$10:I$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,L$10:L$34)-COUNTIFS($B$10:$B$34,2,L$10:L$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,O$10:O$34)-COUNTIFS($B$10:$B$34,2,O$10:O$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,R$10:R$34)-COUNTIFS($B$10:$B$34,2,R$10:R$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,U$10:U$34)-COUNTIFS($B$10:$B$34,2,U$10:U$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,X$10:X$34)-COUNTIFS($B$10:$B$34,2,X$10:X$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AA$10:AA$34)-COUNTIFS($B$10:$B$34,2,AA$10:AA$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AD$10:AD$34)-COUNTIFS($B$10:$B$34,2,AD$10:AD$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AG$10:AG$34)-COUNTIFS($B$10:$B$34,2,AG$10:AG$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AJ$10:AJ$34)-COUNTIFS($B$10:$B$34,2,AJ$10:AJ$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AM$10:AM$34)-COUNTIFS($B$10:$B$34,2,AM$10:AM$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AP$10:AP$34)-COUNTIFS($B$10:$B$34,2,AP$10:AP$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AS$10:AS$34)-COUNTIFS($B$10:$B$34,2,AS$10:AS$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AV$10:AV$34)-COUNTIFS($B$10:$B$34,2,AV$10:AV$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,2,AY$10:AY$34)-COUNTIFS($B$10:$B$34,2,AY$10:AY$34,4)","v":0}]
[]
[null,3,{"$f":"SUMIF($B$10:$B$34,3,C$10:C$34)-COUNTIFS($B$10:$B$34,3,C$10:C$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,F$10:F$34)-COUNTIFS($B$10:$B$34,3,F$10:F$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,I$10:I$34)-COUNTIFS($B$10:$B$34,3,I$10:I$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,L$10:L$34)-COUNTIFS($B$10:$B$34,3,L$10:L$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,O$10:O$34)-COUNTIFS($B$10:$B$34,3,O$10:O$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,R$10:R$34)-COUNTIFS($B$10:$B$34,3,R$10:R$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,U$10:U$34)-COUNTIFS($B$10:$B$34,3,U$10:U$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,X$10:X$34)-COUNTIFS($B$10:$B$34,3,X$10:X$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AA$10:AA$34)-COUNTIFS($B$10:$B$34,3,AA$10:AA$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AD$10:AD$34)-COUNTIFS($B$10:$B$34,3,AD$10:AD$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AG$10:AG$34)-COUNTIFS($B$10:$B$34,3,AG$10:AG$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AJ$10:AJ$34)-COUNTIFS($B$10:$B$34,3,AJ$10:AJ$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AM$10:AM$34)-COUNTIFS($B$10:$B$34,3,AM$10:AM$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AP$10:AP$34)-COUNTIFS($B$10:$B$34,3,AP$10:AP$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AS$10:AS$34)-COUNTIFS($B$10:$B$34,3,AS$10:AS$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AV$10:AV$34)-COUNTIFS($B$10:$B$34,3,AV$10:AV$34,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$34,3,AY$10:AY$34)-COUNTIFS($B$10:$B$34,3,AY$10:AY$34,4)","v":0}]
[]
[null,"Total",{"$f":"SUM(C35:C40)","v":0},null,null,{"$f":"SUM(F35:F40)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[]
["Vesatility Max Score",null,null,null,"Vesatility Max Score - 1",null,null,null,null,null,null,null,null,"Vesatility Max Score - 2"]
[]
["No. Skills",{"$f":"COUNTA(A10:A34)","v":22},null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B34,1)","v":0},null,null,null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B34,2)","v":0}]
[]
["Max Score",3,null,null,"Max Score",null,null,null,{"$f":"B48","v":3},null,null,null,null,"Max Score",null,null,null,{"$f":"B48","v":3}]
[]
["Number Staff",{"$f":"COUNTA(C8:BA9)","v":0},null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0},null,null,null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0}]
[]
[null,{"$f":"B46*B48*B50","v":0},null,null,null,null,null,null,{"$f":"I46*I48*I50","v":0},null,null,null,null,null,null,null,null,{"$f":"R46*R48*R50","v":0}]
[]
[]
["Team Score",null,null,null,"Team Score - 1",null,null,null,null,null,null,null,null,"Team Score - 2"]
[]
["Total Team Score",{"$f":"SUM(C41:AY42)","v":0},null,null,"Total Team Score",null,null,null,{"$f":"SUM(C35:AY36)","v":0},null,null,null,null,"Total Team Score",null,null,null,{"$f":"SUM(C37:AY38)","v":0}]
[]
["Vesatility Max Score",{"$f":"B52","v":0},null,null,"Vesatility Max Score",null,null,null,{"$f":"I52","v":0},null,null,null,null,"Vesatility Max Score",null,null,null,{"$f":"R52","v":0}]
[]
[null,{"$f":"(B57/B59)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"(I57/I59)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"(R57/R59)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Nursing Matrix"]
["”24hr bp needs to be booked at the same time on consecutive days with Beverley at Woodley only (Mon & Tues or Tues & Weds)"]
["*Diabetic initial check requires 30 mins preferably with HCA, follow up needs 20 mins with Rachel or Beverley"]
["**Injections – Aurelia can do B12, Shingles and Flu"]
["***Spirometry assessment needs 15 mins, then 15 min gap, then 2nd 15 min appointment consecutively – check if unsure"]
["****Anyone wanting travel vaccines must have completed an online form before they book the appointment with Rachel, Beverley or Shena"]

{"sheet":"Skills Matrix GPs","index":4,"n_rows":67,"n_cols":69,"rows_kept":67,"cut":false,"hidden":false,"merged":[[44,51,45,51],[40,48,41,48],[42,48,43,48],[44,48,45,48],[40,45,41,45],[42,45,43,45],[44,45,45,45],[46,45,47,45],[6,0,6,1],[40,51,41,51],[42,51,43,51],[40,42,41,42],[42,42,43,42],[44,42,45,42],[40,39,41,39],[42,39,43,39],[44,39,45,39],[46,39,47,39],[40,36,41,36],[42,36,43,36],[44,36,45,36],[40,33,41,33],[42,33,43,33],[44,33,45,33],[40,21,41,21],[42,21,43,21],[44,21,45,21],[46,21,47,21],[40,18,41,18],[42,18,43,18],[44,18,45,18],[40,15,41,15],[42,15,43,15],[44,15,45,15],[46,15,47,15],[40,41,41,41],[40,43,41,43],[40,44,41,44],[40,46,41,46],[40,47,41,47],[40,49,41,49],[44,31,45,31],[44,29,45,29],[40,6,41,6],[42,6,43,6],[44,6,45,6],[44,30,45,30],[40,27,41,27],[42,27,43,27],[44,27,45,27],[40,24,41,24],[42,24,43,24],[44,24,45,24],[44,28,45,28],[42,41,43,41],[42,43,43,43],[42,44,43,44],[42,46,43,46],[42,47,43,47],[40,50,41,50],[40,52,41,52],[42,11,43,11],[42,20,43,20],[42,22,43,22],[42,23,43,23],[42,25,43,25],[40,12,41,12],[42,12,43,12],[40,30,41,30],[42,30,43,30],[40,23,41,23],[40,25,41,25],[40,26,41,26],[40,28,41,28],[40,29,41,29],[40,31,41,31],[42,31,43,31],[40,13,41,13],[40,14,41,14],[40,16,41,16],[40,17,41,17],[42,13,43,13],[42,14,43,14],[40,35,41,35],[40,37,41,37],[6,32,6,34],[6,35,6,37],[6,38,6,40],[46,33,47,33],[44,32,45,32],[42,35,43,35],[42,37,43,37],[42,38,43,38],[42,40,43,40],[44,35,45,35],[44,37,45,37],[44,38,45,38],[44,40,45,40],[40,38,41,38],[40,40,41,40],[40,32,41,32],[42,32,43,32],[46,40,47,40],[7,56,8,56],[7,57,8,57],[6,2,6,4],[44,3,45,3],[46,3,47,3],[7,35,8,37],[7,38,8,40],[7,41,8,43],[7,44,8,46],[7,47,8,49],[7,50,8,52],[7,17,8,19],[7,20,8,22],[7,23,8,25],[7,26,8,28],[7,29,8,31],[7,32,8,34],[40,11,41,11],[40,19,41,19],[40,20,41,20],[40,22,41,22],[40,34,41,34],[42,34,43,34],[44,34,45,34],[7,1,8,1],[6,14,6,16],[6,17,6,19],[6,20,6,22],[7,53,8,53],[7,54,8,54],[7,55,8,55],[6,41,6,43],[6,44,6,46],[6,47,6,49],[6,50,6,52],[6,5,6,7],[6,8,6,10],[6,11,6,13],[6,23,6,25],[6,26,6,28],[6,29,6,31],[0,0,3,57],[4,0,5,0],[4,2,5,2],[4,4,5,4],[4,5,5,7],[4,8,5,8],[4,10,5,10],[4,11,5,13],[4,14,5,14],[4,16,5,16],[4,29,5,31],[4,32,5,34],[4,35,5,57],[4,23,5,25],[4,26,5,26],[4,28,5,28],[4,20,5,20],[4,22,5,22],[7,0,8,0],[7,2,8,4],[7,5,8,7],[7,8,8,10],[7,11,8,13],[7,14,8,16],[4,17,5,19],[44,25,45,25],[44,26,45,26],[40,0,45,0],[40,1,41,1],[40,2,41,2],[40,4,41,4],[40,5,41,5],[40,7,41,7],[40,8,41,8],[40,10,41,10],[42,1,43,1],[42,2,43,2],[42,4,43,4],[42,5,43,5],[42,7,43,7],[42,8,43,8],[42,10,43,10],[40,3,41,3],[42,3,43,3],[44,12,45,12],[40,9,41,9],[42,9,43,9],[44,9,45,9],[42,16,43,16],[42,17,43,17],[42,19,43,19],[42,49,43,49],[42,26,43,26],[42,28,43,28],[42,29,43,29],[42,50,43,50],[42,52,43,52],[44,1,45,1],[44,2,45,2],[44,4,45,4],[44,5,45,5],[44,7,45,7],[44,8,45,8],[44,10,45,10],[44,11,45,11],[44,13,45,13],[44,14,45,14],[44,16,45,16],[44,17,45,17],[44,19,45,19],[44,20,45,20],[44,22,45,22],[44,23,45,23],[44,41,45,41],[44,43,45,43],[44,46,45,46],[44,47,45,47],[44,49,45,49],[44,50,45,50],[44,52,45,52],[46,1,47,1],[46,2,47,2],[46,4,47,4],[46,5,47,5],[46,7,47,7],[46,8,47,8],[46,10,47,10],[46,11,47,11],[46,13,47,13],[46,14,47,14],[46,16,47,16],[46,17,47,17],[46,19,47,19],[46,20,47,20],[46,22,47,22],[46,23,47,23],[46,50,47,50],[46,52,47,52],[46,34,47,34],[49,0,50,1],[49,4,50,8],[49,13,50,17],[46,30,47,30],[46,36,47,36],[48,3,49,3],[50,3,51,3],[51,0,52,0],[44,44,45,44],[46,6,47,6],[46,9,47,9],[46,42,47,42],[46,48,47,48],[46,51,47,51],[46,12,47,12],[46,18,47,18],[46,24,47,24],[46,41,47,41],[46,43,47,43],[46,44,47,44],[46,46,47,46],[46,47,47,47],[46,31,47,31],[46,32,47,32],[46,27,47,27],[46,49,47,49],[46,25,47,25],[46,26,47,26],[46,28,47,28],[46,29,47,29],[46,38,47,38],[64,8,65,8],[64,13,65,16],[64,17,65,17],[51,1,52,1],[51,4,52,7],[51,8,52,8],[51,13,52,16],[51,17,52,17],[52,3,53,3],[53,13,54,16],[53,17,54,17],[60,0,61,1],[60,4,61,8],[53,0,54,0],[53,1,54,1],[53,4,54,7],[53,8,54,8],[66,1,67,1],[66,8,67,8],[66,17,67,17],[46,35,47,35],[46,37,47,37],[55,0,56,0],[55,1,56,1],[55,4,56,7],[55,8,56,8],[55,13,56,16],[55,17,56,17],[57,1,58,1],[57,8,58,8],[57,17,58,17],[60,13,61,17],[62,0,63,0],[62,1,63,1],[62,4,63,7],[62,8,63,8],[62,13,63,16],[62,17,63,17],[64,0,65,0],[64,1,65,1],[64,4,65,7],[52,58,53,58],[54,58,55,58],[56,58,57,58],[58,58,59,58],[40,58,41,58],[42,58,43,58],[44,58,45,58],[46,58,47,58],[48,58,49,58],[50,58,51,58]]}
["Skill Matrix"]
[]
[]
[]
["Skills Level Key",null,0,null,{"$f":"IF(C5=1,$BK$6,IF(C5=2,$BL$6,IF(C5=3,$BM$6,IF(C5=4,$BJ$6,$BI$6))))","v":"○"},"Unaware / N/A",null,null,1,null,{"$f":"IF(I5=1,$BK$6,IF(I5=2,$BL$6,IF(I5=3,$BM$6,IF(I5=4,$BJ$6,$BI$6))))","v":"◔"},"Aware of Task",null,null,2,null,{"$f":"IF(O5=1,$BK$6,IF(O5=2,$BL$6,IF(O5=3,$BM$6,IF(O5=4,$BJ$6,$BI$6))))","v":"◑"},"Can Do with Support",null,null,3,null,{"$f":"IF(U5=1,$BK$6,IF(U5=2,$BL$6,IF(U5=3,$BM$6,IF(U5=4,$BJ$6,$BI$6))))","v":"◕"},"Competent",null,null,4,null,{"$f":"IF(AA5=1,$BK$6,IF(AA5=2,$BL$6,IF(AA5=3,$BM$6,IF(AA5=4,$BJ$6,$BI$6))))","v":"●"},"Can Train Others",null,null,"Area",null,null,"GPs / AHPs / paramedics/ pharmacists / pharmacist techs / PAs / SPs "]
[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,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,null,null,"○","●","◔","◑","◕",null,null,null,"Yes"]
["Is the Resource Available →",null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Priority Ranking",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Minimum","Gap","Lead / Trainer"]
[]
["Dressings",null,0,{"$f":"IF(AND($C$7=\"Yes\",C10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(C10=1,$BK$6,IF(C10=2,$BL$6,IF(C10=3,$BM$6,IF(C10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($F$7=\"Yes\",F10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(F10=1,$BK$6,IF(F10=2,$BL$6,IF(F10=3,$BM$6,IF(F10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($I$7=\"Yes\",I10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I10=1,$BK$6,IF(I10=2,$BL$6,IF(I10=3,$BM$6,IF(I10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($L$7=\"Yes\",L10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(L10=1,$BK$6,IF(L10=2,$BL$6,IF(L10=3,$BM$6,IF(L10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($O$7=\"Yes\",O10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(O10=1,$BK$6,IF(O10=2,$BL$6,IF(O10=3,$BM$6,IF(O10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($R$7=\"Yes\",R10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R10=1,$BK$6,IF(R10=2,$BL$6,IF(R10=3,$BM$6,IF(R10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($U$7=\"Yes\",U10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(U10=1,$BK$6,IF(U10=2,$BL$6,IF(U10=3,$BM$6,IF(U10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($X$7=\"Yes\",X10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(X10=1,$BK$6,IF(X10=2,$BL$6,IF(X10=3,$BM$6,IF(X10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AA$7=\"Yes\",AA10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AA10=1,$BK$6,IF(AA10=2,$BL$6,IF(AA10=3,$BM$6,IF(AA10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AD$7=\"Yes\",AD10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD10=1,$BK$6,IF(AD10=2,$BL$6,IF(AD10=3,$BM$6,IF(AD10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AG$7=\"Yes\",AG10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG10=1,$BK$6,IF(AG10=2,$BL$6,IF(AG10=3,$BM$6,IF(AG10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AJ10=1,$BK$6,IF(AJ10=2,$BL$6,IF(AJ10=3,$BM$6,IF(AJ10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AM$7=\"Yes\",AM10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AM10=1,$BK$6,IF(AM10=2,$BL$6,IF(AM10=3,$BM$6,IF(AM10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AP$7=\"Yes\",AP10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AP10=1,$BK$6,IF(AP10=2,$BL$6,IF(AP10=3,$BM$6,IF(AP10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AS$7=\"Yes\",AS10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AS10=1,$BK$6,IF(AS10=2,$BL$6,IF(AS10=3,$BM$6,IF(AS10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AV$7=\"Yes\",AV10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AV10=1,$BK$6,IF(AV10=2,$BL$6,IF(AV10=3,$BM$6,IF(AV10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AY$7=\"Yes\",AY10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AY10=1,$BK$6,IF(AY10=2,$BL$6,IF(AY10=3,$BM$6,IF(AY10=4,$BJ$6,$BI$6))))","v":"○"},null,{"$f":"COUNTIF(C10:BB10,\"Yes\")","v":0},0,{"$f":"SUM(BC10)-BD10","v":0},null,{"$f":"IF(BC10>BD10,BE10,(BE10+BD10))","v":0}]
["Patient consultations",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Safeguarding (A /N/ GP)",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["telephone triage",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Antenatal checks",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Care home visits",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Care navigation advice",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Care planning",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Claims / Forms",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Diabetic reviews",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["health education",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Home visits",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Medication queries",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Medication reviews",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Mental health reviews",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["On line consultations",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Postnatal checks",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Referrals",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Results review",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Sick notes",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Sign off presriptions",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Text messaging",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Video consultations",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["CQC- partner skills",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["GP Trainer- partner skills?",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Group Consultations",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC35>BD35,BE35,(BE35+BD35))","v":0}]
["Information Governance- partner skills?",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["minor surgery",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC37>BD37,BE37,(BE37+BD37))","v":0}]
["MSK injections",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC38>BD38,BE38,(BE38+BD38))","v":0}]
["Social prescribing",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC39>BD39,BE39,(BE39+BD39))","v":0}]
["Virtual Consultations",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC40>BD40,BE40,(BE40+BD40))","v":0}]
["Ranking Scores",1,{"$f":"SUMIF($B$10:$B$40,1,C$10:C$40)-COUNTIFS($B$10:$B$40,1,C$10:C$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,F$10:F$40)-COUNTIFS($B$10:$B$40,1,F$10:F$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,I$10:I$40)-COUNTIFS($B$10:$B$40,1,I$10:I$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,L$10:L$40)-COUNTIFS($B$10:$B$40,1,L$10:L$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,O$10:O$40)-COUNTIFS($B$10:$B$40,1,O$10:O$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,R$10:R$40)-COUNTIFS($B$10:$B$40,1,R$10:R$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,U$10:U$40)-COUNTIFS($B$10:$B$40,1,U$10:U$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,X$10:X$40)-COUNTIFS($B$10:$B$40,1,X$10:X$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AA$10:AA$40)-COUNTIFS($B$10:$B$40,1,AA$10:AA$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AD$10:AD$40)-COUNTIFS($B$10:$B$40,1,AD$10:AD$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AG$10:AG$40)-COUNTIFS($B$10:$B$40,1,AG$10:AG$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AJ$10:AJ$40)-COUNTIFS($B$10:$B$40,1,AJ$10:AJ$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AM$10:AM$40)-COUNTIFS($B$10:$B$40,1,AM$10:AM$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AP$10:AP$40)-COUNTIFS($B$10:$B$40,1,AP$10:AP$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AS$10:AS$40)-COUNTIFS($B$10:$B$40,1,AS$10:AS$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AV$10:AV$40)-COUNTIFS($B$10:$B$40,1,AV$10:AV$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AY$10:AY$40)-COUNTIFS($B$10:$B$40,1,AY$10:AY$40,4)","v":0}]
[]
[null,2,{"$f":"SUMIF($B$10:$B$40,2,C$10:C$40)-COUNTIFS($B$10:$B$40,2,C$10:C$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,F$10:F$40)-COUNTIFS($B$10:$B$40,2,F$10:F$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,I$10:I$40)-COUNTIFS($B$10:$B$40,2,I$10:I$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,L$10:L$40)-COUNTIFS($B$10:$B$40,2,L$10:L$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,O$10:O$40)-COUNTIFS($B$10:$B$40,2,O$10:O$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,R$10:R$40)-COUNTIFS($B$10:$B$40,2,R$10:R$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,U$10:U$40)-COUNTIFS($B$10:$B$40,2,U$10:U$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,X$10:X$40)-COUNTIFS($B$10:$B$40,2,X$10:X$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AA$10:AA$40)-COUNTIFS($B$10:$B$40,2,AA$10:AA$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AD$10:AD$40)-COUNTIFS($B$10:$B$40,2,AD$10:AD$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AG$10:AG$40)-COUNTIFS($B$10:$B$40,2,AG$10:AG$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AJ$10:AJ$40)-COUNTIFS($B$10:$B$40,2,AJ$10:AJ$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AM$10:AM$40)-COUNTIFS($B$10:$B$40,2,AM$10:AM$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AP$10:AP$40)-COUNTIFS($B$10:$B$40,2,AP$10:AP$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AS$10:AS$40)-COUNTIFS($B$10:$B$40,2,AS$10:AS$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AV$10:AV$40)-COUNTIFS($B$10:$B$40,2,AV$10:AV$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AY$10:AY$40)-COUNTIFS($B$10:$B$40,2,AY$10:AY$40,4)","v":0}]
[]
[null,3,{"$f":"SUMIF($B$10:$B$40,3,C$10:C$40)-COUNTIFS($B$10:$B$40,3,C$10:C$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,F$10:F$40)-COUNTIFS($B$10:$B$40,3,F$10:F$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,I$10:I$40)-COUNTIFS($B$10:$B$40,3,I$10:I$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,L$10:L$40)-COUNTIFS($B$10:$B$40,3,L$10:L$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,O$10:O$40)-COUNTIFS($B$10:$B$40,3,O$10:O$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,R$10:R$40)-COUNTIFS($B$10:$B$40,3,R$10:R$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,U$10:U$40)-COUNTIFS($B$10:$B$40,3,U$10:U$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,X$10:X$40)-COUNTIFS($B$10:$B$40,3,X$10:X$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AA$10:AA$40)-COUNTIFS($B$10:$B$40,3,AA$10:AA$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AD$10:AD$40)-COUNTIFS($B$10:$B$40,3,AD$10:AD$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AG$10:AG$40)-COUNTIFS($B$10:$B$40,3,AG$10:AG$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AJ$10:AJ$40)-COUNTIFS($B$10:$B$40,3,AJ$10:AJ$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AM$10:AM$40)-COUNTIFS($B$10:$B$40,3,AM$10:AM$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AP$10:AP$40)-COUNTIFS($B$10:$B$40,3,AP$10:AP$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AS$10:AS$40)-COUNTIFS($B$10:$B$40,3,AS$10:AS$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AV$10:AV$40)-COUNTIFS($B$10:$B$40,3,AV$10:AV$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AY$10:AY$40)-COUNTIFS($B$10:$B$40,3,AY$10:AY$40,4)","v":0}]
[]
[null,"Total",{"$f":"SUM(C41:C46)","v":0},null,null,{"$f":"SUM(F41:F46)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[]
["Vesatility Max Score",null,null,null,"Vesatility Max Score - 1",null,null,null,null,null,null,null,null,"Vesatility Max Score - 2"]
[]
["No. Skills",{"$f":"COUNTA(A10:A40)","v":31},null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B40,1)","v":0},null,null,null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B40,2)","v":0}]
[]
["Max Score",3,null,null,"Max Score",null,null,null,{"$f":"B54","v":3},null,null,null,null,"Max Score",null,null,null,{"$f":"B54","v":3}]
[]
["Number Staff",{"$f":"COUNTA(C8:BA9)","v":0},null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0},null,null,null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0}]
[]
[null,{"$f":"B52*B54*B56","v":0},null,null,null,null,null,null,{"$f":"I52*I54*I56","v":0},null,null,null,null,null,null,null,null,{"$f":"R52*R54*R56","v":0}]
[]
[]
["Team Score",null,null,null,"Team Score - 1",null,null,null,null,null,null,null,null,"Team Score - 2"]
[]
["Total Team Score",{"$f":"SUM(C47:AY48)","v":0},null,null,"Total Team Score",null,null,null,{"$f":"SUM(C41:AY42)","v":0},null,null,null,null,"Total Team Score",null,null,null,{"$f":"SUM(C43:AY44)","v":0}]
[]
["Vesatility Max Score",{"$f":"B58","v":0},null,null,"Vesatility Max Score",null,null,null,{"$f":"I58","v":0},null,null,null,null,"Vesatility Max Score",null,null,null,{"$f":"R58","v":0}]
[]
[null,{"$f":"(B63/B65)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"(I63/I65)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"(R63/R65)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Skills VGC","index":5,"n_rows":87,"n_cols":70,"rows_kept":87,"cut":false,"hidden":false,"merged":[[0,0,3,57],[4,0,5,0],[4,2,5,2],[4,4,5,4],[4,5,5,7],[4,8,5,8],[4,10,5,10],[4,11,5,13],[4,14,5,14],[4,16,5,16],[4,29,5,31],[4,32,5,34],[4,35,5,57],[4,22,5,22],[4,23,5,25],[4,26,5,26],[4,28,5,28],[6,0,6,1],[6,2,6,4],[6,5,6,7],[6,8,6,10],[6,11,6,13],[6,14,6,16],[6,17,6,19],[4,17,5,19],[4,20,5,20],[6,38,6,40],[6,41,6,43],[6,44,6,46],[6,47,6,49],[6,50,6,52],[7,0,8,0],[7,1,8,1],[7,2,8,4],[7,5,8,7],[7,8,8,10],[6,20,6,22],[6,23,6,25],[6,26,6,28],[6,29,6,31],[6,32,6,34],[6,35,6,37],[7,35,8,37],[7,38,8,40],[7,41,8,43],[7,44,8,46],[7,11,8,13],[7,14,8,16],[7,17,8,19],[7,20,8,22],[7,23,8,25],[7,26,8,28],[60,9,61,9],[60,10,61,10],[60,11,61,11],[60,12,61,12],[60,13,61,13],[60,14,61,14],[7,57,8,57],[7,47,8,49],[7,50,8,52],[7,53,8,53],[7,54,8,54],[7,55,8,55],[7,56,8,56],[7,29,8,31],[7,32,8,34],[60,21,61,21],[60,22,61,22],[60,23,61,23],[60,24,61,24],[60,25,61,25],[60,26,61,26],[60,15,61,15],[60,0,65,0],[60,1,61,1],[60,2,61,2],[60,3,61,3],[60,4,61,4],[60,5,61,5],[60,6,61,6],[60,7,61,7],[60,8,61,8],[64,7,65,7],[64,8,65,8],[60,16,61,16],[60,17,61,17],[60,18,61,18],[60,19,61,19],[60,20,61,20],[60,35,61,35],[60,36,61,36],[60,37,61,37],[60,38,61,38],[60,27,61,27],[60,28,61,28],[60,29,61,29],[60,30,61,30],[60,31,61,31],[60,32,61,32],[60,51,61,51],[60,52,61,52],[60,58,61,58],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,6,63,6],[62,7,63,7],[60,45,61,45],[60,46,61,46],[60,47,61,47],[60,48,61,48],[60,49,61,49],[60,50,61,50],[60,39,61,39],[60,40,61,40],[60,41,61,41],[60,42,61,42],[60,43,61,43],[60,44,61,44],[60,33,61,33],[60,34,61,34],[62,16,63,16],[62,17,63,17],[62,18,63,18],[62,19,63,19],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,11,63,11],[62,12,63,12],[62,13,63,13],[62,58,63,58],[64,1,65,1],[64,2,65,2],[64,3,65,3],[64,4,65,4],[64,5,65,5],[64,6,65,6],[62,44,63,44],[62,45,63,45],[62,46,63,46],[62,47,63,47],[62,48,63,48],[62,49,63,49],[62,38,63,38],[62,39,63,39],[62,40,63,40],[62,41,63,41],[62,42,63,42],[62,43,63,43],[62,32,63,32],[62,33,63,33],[62,34,63,34],[62,35,63,35],[62,36,63,36],[64,9,65,9],[64,10,65,10],[64,11,65,11],[64,12,65,12],[62,50,63,50],[62,51,63,51],[62,52,63,52],[62,37,63,37],[62,26,63,26],[62,27,63,27],[62,28,63,28],[62,29,63,29],[62,30,63,30],[62,31,63,31],[62,20,63,20],[62,21,63,21],[62,22,63,22],[62,23,63,23],[62,24,63,24],[62,25,63,25],[62,14,63,14],[62,15,63,15],[64,19,65,19],[64,20,65,20],[64,21,65,21],[64,22,65,22],[64,23,65,23],[64,24,65,24],[64,13,65,13],[64,14,65,14],[64,15,65,15],[64,16,65,16],[64,17,65,17],[64,18,65,18],[64,33,65,33],[64,34,65,34],[64,35,65,35],[64,36,65,36],[64,25,65,25],[64,26,65,26],[64,27,65,27],[64,28,65,28],[64,29,65,29],[64,30,65,30],[64,49,65,49],[64,50,65,50],[64,51,65,51],[64,52,65,52],[64,58,65,58],[66,1,67,1],[66,2,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[64,43,65,43],[64,44,65,44],[64,45,65,45],[64,46,65,46],[64,47,65,47],[64,48,65,48],[64,37,65,37],[64,38,65,38],[64,39,65,39],[64,40,65,40],[64,41,65,41],[64,42,65,42],[64,31,65,31],[64,32,65,32],[66,12,67,12],[66,13,67,13],[66,14,67,14],[66,15,67,15],[66,16,67,16],[66,17,67,17],[66,6,67,6],[66,7,67,7],[66,8,67,8],[66,9,67,9],[66,10,67,10],[66,11,67,11],[66,24,67,24],[66,25,67,25],[66,26,67,26],[66,27,67,27],[66,28,67,28],[66,29,67,29],[66,18,67,18],[66,19,67,19],[66,20,67,20],[66,21,67,21],[66,22,67,22],[66,23,67,23],[66,36,67,36],[66,37,67,37],[66,38,67,38],[66,39,67,39],[66,40,67,40],[66,41,67,41],[66,30,67,30],[66,31,67,31],[66,32,67,32],[66,33,67,33],[66,34,67,34],[66,35,67,35],[66,48,67,48],[66,49,67,49],[66,50,67,50],[66,51,67,51],[66,52,67,52],[66,58,67,58],[66,42,67,42],[66,43,67,43],[66,44,67,44],[66,45,67,45],[66,46,67,46],[66,47,67,47],[68,3,69,3],[68,58,69,58],[69,0,70,1],[69,4,70,8],[69,13,70,17],[70,3,71,3],[70,58,71,58],[71,0,72,0],[71,1,72,1],[71,4,72,7],[71,8,72,8],[71,13,72,16],[71,17,72,17],[72,3,73,3],[72,58,73,58],[73,0,74,0],[73,1,74,1],[73,4,74,7],[73,8,74,8],[73,13,74,16],[73,17,74,17],[74,3,75,3],[74,58,75,58],[75,0,76,0],[75,1,76,1],[75,4,76,7],[75,8,76,8],[75,13,76,16],[75,17,76,17],[76,3,77,3],[76,58,77,58],[77,1,78,1],[77,8,78,8],[77,17,78,17],[78,3,79,3],[78,6,79,6],[78,9,79,9],[78,12,79,12],[78,15,79,15],[78,18,79,18],[78,39,79,39],[78,42,79,42],[78,45,79,45],[78,48,79,48],[78,51,79,51],[78,58,79,58],[78,21,79,21],[78,24,79,24],[78,27,79,27],[78,30,79,30],[78,33,79,33],[78,36,79,36],[80,0,81,1],[80,4,81,8],[80,13,81,17],[82,0,83,0],[82,1,83,1],[82,4,83,7],[82,8,83,8],[82,13,83,16],[82,17,83,17],[86,1,87,1],[86,8,87,8],[86,17,87,17],[84,0,85,0],[84,1,85,1],[84,4,85,7],[84,8,85,8],[84,13,85,16],[84,17,85,17]]}
["Skill Matrix VIDEO GROUP CONSULTATIONS"]
[]
[]
[]
["Skills Level Key",null,0,null,{"$f":"IF(C5=1,$BK$6,IF(C5=2,$BL$6,IF(C5=3,$BM$6,IF(C5=4,$BJ$6,$BI$6))))","v":"○"},"Unaware / N/A",null,null,1,null,{"$f":"IF(I5=1,$BK$6,IF(I5=2,$BL$6,IF(I5=3,$BM$6,IF(I5=4,$BJ$6,$BI$6))))","v":"◔"},"Aware of Task",null,null,2,null,{"$f":"IF(O5=1,$BK$6,IF(O5=2,$BL$6,IF(O5=3,$BM$6,IF(O5=4,$BJ$6,$BI$6))))","v":"◑"},"Can Do with Support",null,null,3,null,{"$f":"IF(U5=1,$BK$6,IF(U5=2,$BL$6,IF(U5=3,$BM$6,IF(U5=4,$BJ$6,$BI$6))))","v":"◕"},"Competent",null,null,4,null,{"$f":"IF(AA5=1,$BK$6,IF(AA5=2,$BL$6,IF(AA5=3,$BM$6,IF(AA5=4,$BJ$6,$BI$6))))","v":"●"},"Can Train Others",null,null,"Area",null,null,"VGC - Admin, Facilitator, Technical Facilitator, Presenter"]
[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,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,null,null,"○","●","◔","◑","◕",null,null,null,null,"Yes"]
["Is the Resource Available →",null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Priority Ranking",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Minimum","Gap","Lead Trainer"]
[]
["All",null,0,{"$f":"IF(AND($C$7=\"Yes\",C10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(C10=1,$BK$6,IF(C10=2,$BL$6,IF(C10=3,$BM$6,IF(C10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($F$7=\"Yes\",F10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(F10=1,$BK$6,IF(F10=2,$BL$6,IF(F10=3,$BM$6,IF(F10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($I$7=\"Yes\",I10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I10=1,$BK$6,IF(I10=2,$BL$6,IF(I10=3,$BM$6,IF(I10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($L$7=\"Yes\",L10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(L10=1,$BK$6,IF(L10=2,$BL$6,IF(L10=3,$BM$6,IF(L10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($O$7=\"Yes\",O10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(O10=1,$BK$6,IF(O10=2,$BL$6,IF(O10=3,$BM$6,IF(O10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($R$7=\"Yes\",R10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R10=1,$BK$6,IF(R10=2,$BL$6,IF(R10=3,$BM$6,IF(R10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($U$7=\"Yes\",U10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(U10=1,$BK$6,IF(U10=2,$BL$6,IF(U10=3,$BM$6,IF(U10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($X$7=\"Yes\",X10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(X10=1,$BK$6,IF(X10=2,$BL$6,IF(X10=3,$BM$6,IF(X10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AA$7=\"Yes\",AA10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AA10=1,$BK$6,IF(AA10=2,$BL$6,IF(AA10=3,$BM$6,IF(AA10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AD$7=\"Yes\",AD10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD10=1,$BK$6,IF(AD10=2,$BL$6,IF(AD10=3,$BM$6,IF(AD10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AG$7=\"Yes\",AG10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG10=1,$BK$6,IF(AG10=2,$BL$6,IF(AG10=3,$BM$6,IF(AG10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AJ10=1,$BK$6,IF(AJ10=2,$BL$6,IF(AJ10=3,$BM$6,IF(AJ10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AM$7=\"Yes\",AM10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AM10=1,$BK$6,IF(AM10=2,$BL$6,IF(AM10=3,$BM$6,IF(AM10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AP$7=\"Yes\",AP10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AP10=1,$BK$6,IF(AP10=2,$BL$6,IF(AP10=3,$BM$6,IF(AP10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AS$7=\"Yes\",AS10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AS10=1,$BK$6,IF(AS10=2,$BL$6,IF(AS10=3,$BM$6,IF(AS10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AV$7=\"Yes\",AV10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AV10=1,$BK$6,IF(AV10=2,$BL$6,IF(AV10=3,$BM$6,IF(AV10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AY$7=\"Yes\",AY10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AY10=1,$BK$6,IF(AY10=2,$BL$6,IF(AY10=3,$BM$6,IF(AY10=4,$BJ$6,$BI$6))))","v":"○"},null,{"$f":"COUNTIF(C10:BB10,\"Yes\")","v":0},0,{"$f":"SUM(BC10)-BD10","v":0},null,{"$f":"IF(BC10>BD10,BE10,(BE10+BD10))","v":0}]
["Setting up WhatsApp group",null,0,{"$f":"IF(AND($C$7=\"Yes\",C11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($F$7=\"Yes\",F11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($I$7=\"Yes\",I11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($L$7=\"Yes\",L11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($O$7=\"Yes\",O11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($R$7=\"Yes\",R11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($U$7=\"Yes\",U11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($X$7=\"Yes\",X11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AA$7=\"Yes\",AA11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AD$7=\"Yes\",AD11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AG$7=\"Yes\",AG11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AM$7=\"Yes\",AM11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AP$7=\"Yes\",AP11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AS$7=\"Yes\",AS11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AV$7=\"Yes\",AV11>=3),\"Yes\",\"No\")","v":"No"},"○",0,{"$f":"IF(AND($AY$7=\"Yes\",AY11>=3),\"Yes\",\"No\")","v":"No"},"○",null,0,0,{"$f":"SUM(BC11)-BD11","v":0},null,{"$f":"IF(BC11>BD11,BE11,(BE11+BD11))","v":0}]
["Use of WhatsApp group",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Full understanding of consent and confidentiality",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to help with phone calls to ensure patients have full understanding of VGC and to check attendance",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,{"$f":"SUM(BC15)-BD15","v":0}]
["For Clinicians",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Writing up notes for partner surgeries ",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Following up patients that need review ",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Admin",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to do patient searches",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to set up a new email account for VGC",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to add users to email account",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to text patients",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to email patients",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Use of excel to formulate spreadsheets",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Reviewing notes to pick out clinical information to add to results board",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Collate replies and questionnaire responses",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Collate feedback from session’s chat",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Collate feedback from Email survey",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Review outcome measures",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Facilitator",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Full understanding of consent and confidentiality",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["full understanding of group rules also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Full understanding of use of car park also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Able to mute and video on/off",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Complete form to cross reference participants who have consented with those who are present",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Technical Facilitator",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Formulate and send Microsoft teams invitations",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Upload documents and presentations to Microsoft teams ",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Annotate documents whilst in a VGC also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Use of whiteboard also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Able to mute/ video on/off also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Able to invite patients from lobby",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Able to \"leave\" patients at the end of the VGC",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Able to click forwards/ backwards on slides also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Knowledge of changing presenter for slides also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Presenter",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Full understanding of group rules also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Full understanding of use of car park also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Annotate documents whilst in a VGC also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Use of whiteboard also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Able to mute/ video on/off also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Able to click forwards/ backwards on slides also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
["Knowledge of changing presenter for slides also for presenters",null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
[null,"`",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
["Ranking Scores",1,{"$f":"SUMIF($B$10:$B$60,1,C$10:C$60)-COUNTIFS($B$10:$B$60,1,C$10:C$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,F$10:F$60)-COUNTIFS($B$10:$B$60,1,F$10:F$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,I$10:I$60)-COUNTIFS($B$10:$B$60,1,I$10:I$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,L$10:L$60)-COUNTIFS($B$10:$B$60,1,L$10:L$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,O$10:O$60)-COUNTIFS($B$10:$B$60,1,O$10:O$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,R$10:R$60)-COUNTIFS($B$10:$B$60,1,R$10:R$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,U$10:U$60)-COUNTIFS($B$10:$B$60,1,U$10:U$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,X$10:X$60)-COUNTIFS($B$10:$B$60,1,X$10:X$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AA$10:AA$60)-COUNTIFS($B$10:$B$60,1,AA$10:AA$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AD$10:AD$60)-COUNTIFS($B$10:$B$60,1,AD$10:AD$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AG$10:AG$60)-COUNTIFS($B$10:$B$60,1,AG$10:AG$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AJ$10:AJ$60)-COUNTIFS($B$10:$B$60,1,AJ$10:AJ$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AM$10:AM$60)-COUNTIFS($B$10:$B$60,1,AM$10:AM$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AP$10:AP$60)-COUNTIFS($B$10:$B$60,1,AP$10:AP$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AS$10:AS$60)-COUNTIFS($B$10:$B$60,1,AS$10:AS$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AV$10:AV$60)-COUNTIFS($B$10:$B$60,1,AV$10:AV$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,1,AY$10:AY$60)-COUNTIFS($B$10:$B$60,1,AY$10:AY$60,4)","v":0}]
[]
[null,2,{"$f":"SUMIF($B$10:$B$60,2,C$10:C$60)-COUNTIFS($B$10:$B$60,2,C$10:C$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,F$10:F$60)-COUNTIFS($B$10:$B$60,2,F$10:F$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,I$10:I$60)-COUNTIFS($B$10:$B$60,2,I$10:I$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,L$10:L$60)-COUNTIFS($B$10:$B$60,2,L$10:L$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,O$10:O$60)-COUNTIFS($B$10:$B$60,2,O$10:O$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,R$10:R$60)-COUNTIFS($B$10:$B$60,2,R$10:R$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,U$10:U$60)-COUNTIFS($B$10:$B$60,2,U$10:U$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,X$10:X$60)-COUNTIFS($B$10:$B$60,2,X$10:X$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AA$10:AA$60)-COUNTIFS($B$10:$B$60,2,AA$10:AA$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AD$10:AD$60)-COUNTIFS($B$10:$B$60,2,AD$10:AD$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AG$10:AG$60)-COUNTIFS($B$10:$B$60,2,AG$10:AG$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AJ$10:AJ$60)-COUNTIFS($B$10:$B$60,2,AJ$10:AJ$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AM$10:AM$60)-COUNTIFS($B$10:$B$60,2,AM$10:AM$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AP$10:AP$60)-COUNTIFS($B$10:$B$60,2,AP$10:AP$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AS$10:AS$60)-COUNTIFS($B$10:$B$60,2,AS$10:AS$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AV$10:AV$60)-COUNTIFS($B$10:$B$60,2,AV$10:AV$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,2,AY$10:AY$60)-COUNTIFS($B$10:$B$60,2,AY$10:AY$60,4)","v":0}]
[]
[null,3,{"$f":"SUMIF($B$10:$B$60,3,C$10:C$60)-COUNTIFS($B$10:$B$60,3,C$10:C$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,F$10:F$60)-COUNTIFS($B$10:$B$60,3,F$10:F$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,I$10:I$60)-COUNTIFS($B$10:$B$60,3,I$10:I$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,L$10:L$60)-COUNTIFS($B$10:$B$60,3,L$10:L$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,O$10:O$60)-COUNTIFS($B$10:$B$60,3,O$10:O$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,R$10:R$60)-COUNTIFS($B$10:$B$60,3,R$10:R$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,U$10:U$60)-COUNTIFS($B$10:$B$60,3,U$10:U$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,X$10:X$60)-COUNTIFS($B$10:$B$60,3,X$10:X$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AA$10:AA$60)-COUNTIFS($B$10:$B$60,3,AA$10:AA$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AD$10:AD$60)-COUNTIFS($B$10:$B$60,3,AD$10:AD$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AG$10:AG$60)-COUNTIFS($B$10:$B$60,3,AG$10:AG$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AJ$10:AJ$60)-COUNTIFS($B$10:$B$60,3,AJ$10:AJ$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AM$10:AM$60)-COUNTIFS($B$10:$B$60,3,AM$10:AM$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AP$10:AP$60)-COUNTIFS($B$10:$B$60,3,AP$10:AP$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AS$10:AS$60)-COUNTIFS($B$10:$B$60,3,AS$10:AS$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AV$10:AV$60)-COUNTIFS($B$10:$B$60,3,AV$10:AV$60,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$60,3,AY$10:AY$60)-COUNTIFS($B$10:$B$60,3,AY$10:AY$60,4)","v":0}]
[]
[null,"Total",{"$f":"SUM(C61:C66)","v":0},null,null,{"$f":"SUM(F61:F66)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[]
["Vesatility Max Score",null,null,null,"Vesatility Max Score - 1",null,null,null,null,null,null,null,null,"Vesatility Max Score - 2"]
[]
["No. Skills",{"$f":"COUNTA(A10:A60)","v":44},null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B60,1)","v":0},null,null,null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B60,2)","v":0}]
[]
["Max Score",3,null,null,"Max Score",null,null,null,{"$f":"B74","v":3},null,null,null,null,"Max Score",null,null,null,{"$f":"B74","v":3}]
[]
["Number Staff",{"$f":"COUNTA(C8:BA9)","v":0},null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0},null,null,null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0}]
[]
[null,{"$f":"B72*B74*B76","v":0},null,null,null,null,null,null,{"$f":"I72*I74*I76","v":0},null,null,null,null,null,null,null,null,{"$f":"R72*R74*R76","v":0}]
[]
[]
["Team Score",null,null,null,"Team Score - 1",null,null,null,null,null,null,null,null,"Team Score - 2"]
[]
["Total Team Score",{"$f":"SUM(C67:AY68)","v":0},null,null,"Total Team Score",null,null,null,{"$f":"SUM(C61:AY62)","v":0},null,null,null,null,"Total Team Score",null,null,null,{"$f":"SUM(C63:AY64)","v":0}]
[]
["Vesatility Max Score",{"$f":"B78","v":0},null,null,"Vesatility Max Score",null,null,null,{"$f":"I78","v":0},null,null,null,null,"Vesatility Max Score",null,null,null,{"$f":"R78","v":0}]
[]
[null,{"$f":"(B83/B85)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"(I83/I85)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"(R83/R85)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Skills Matrix Blank","index":6,"n_rows":67,"n_cols":69,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,1,67,1],[66,8,67,8],[66,17,67,17],[64,0,65,0],[64,1,65,1],[64,4,65,7],[64,8,65,8],[64,13,65,16],[64,17,65,17],[55,4,56,7],[55,8,56,8],[55,13,56,16],[55,17,56,17],[56,58,57,58],[57,1,58,1],[62,0,63,0],[62,1,63,1],[62,4,63,7],[62,8,63,8],[62,13,63,16],[62,17,63,17],[57,8,58,8],[57,17,58,17],[58,58,59,58],[60,0,61,1],[60,4,61,8],[60,13,61,17],[48,3,49,3],[48,58,49,58],[49,0,50,1],[49,4,50,8],[49,13,50,17],[50,3,51,3],[50,58,51,58],[51,0,52,0],[51,1,52,1],[51,4,52,7],[51,8,52,8],[51,13,52,16],[51,17,52,17],[52,3,53,3],[52,58,53,58],[53,0,54,0],[53,1,54,1],[53,4,54,7],[53,8,54,8],[53,13,54,16],[53,17,54,17],[54,58,55,58],[55,0,56,0],[55,1,56,1],[46,48,47,48],[46,49,47,49],[46,50,47,50],[46,51,47,51],[46,52,47,52],[46,58,47,58],[46,42,47,42],[46,43,47,43],[46,44,47,44],[46,45,47,45],[46,46,47,46],[46,47,47,47],[46,36,47,36],[46,37,47,37],[46,38,47,38],[46,39,47,39],[46,40,47,40],[46,41,47,41],[46,30,47,30],[46,31,47,31],[46,32,47,32],[46,33,47,33],[46,34,47,34],[46,35,47,35],[46,24,47,24],[46,25,47,25],[46,26,47,26],[46,27,47,27],[46,28,47,28],[46,29,47,29],[46,18,47,18],[46,19,47,19],[46,20,47,20],[46,21,47,21],[46,22,47,22],[46,23,47,23],[46,12,47,12],[46,13,47,13],[46,14,47,14],[46,15,47,15],[46,16,47,16],[46,17,47,17],[46,6,47,6],[46,7,47,7],[46,8,47,8],[46,9,47,9],[46,10,47,10],[46,11,47,11],[44,49,45,49],[44,50,45,50],[44,51,45,51],[44,52,45,52],[44,58,45,58],[46,1,47,1],[46,2,47,2],[46,3,47,3],[46,4,47,4],[46,5,47,5],[44,43,45,43],[44,44,45,44],[44,45,45,45],[44,46,45,46],[44,47,45,47],[44,48,45,48],[44,37,45,37],[44,38,45,38],[44,39,45,39],[44,40,45,40],[44,41,45,41],[44,42,45,42],[44,31,45,31],[44,32,45,32],[44,33,45,33],[44,34,45,34],[44,35,45,35],[44,36,45,36],[44,25,45,25],[44,26,45,26],[44,27,45,27],[44,28,45,28],[44,29,45,29],[44,30,45,30],[44,21,45,21],[44,22,45,22],[44,23,45,23],[44,24,45,24],[44,13,45,13],[44,14,45,14],[44,15,45,15],[44,16,45,16],[44,17,45,17],[44,18,45,18],[44,9,45,9],[44,10,45,10],[44,11,45,11],[44,12,45,12],[42,50,43,50],[42,51,43,51],[42,52,43,52],[42,37,43,37],[42,26,43,26],[42,27,43,27],[42,28,43,28],[42,29,43,29],[42,30,43,30],[42,31,43,31],[42,20,43,20],[42,21,43,21],[42,22,43,22],[42,23,43,23],[42,24,43,24],[42,25,43,25],[42,14,43,14],[42,15,43,15],[44,19,45,19],[44,20,45,20],[42,58,43,58],[44,1,45,1],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[44,6,45,6],[42,44,43,44],[42,45,43,45],[42,46,43,46],[42,47,43,47],[42,48,43,48],[42,49,43,49],[42,38,43,38],[42,39,43,39],[42,40,43,40],[42,41,43,41],[42,42,43,42],[42,43,43,43],[42,32,43,32],[42,33,43,33],[42,34,43,34],[42,35,43,35],[42,36,43,36],[42,16,43,16],[42,17,43,17],[42,18,43,18],[42,19,43,19],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[42,12,43,12],[42,13,43,13],[40,51,41,51],[40,52,41,52],[40,58,41,58],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,6,43,6],[42,7,43,7],[40,45,41,45],[40,46,41,46],[40,47,41,47],[40,48,41,48],[40,49,41,49],[40,50,41,50],[40,39,41,39],[40,40,41,40],[40,41,41,41],[40,42,41,42],[40,43,41,43],[40,44,41,44],[40,33,41,33],[40,34,41,34],[40,16,41,16],[40,17,41,17],[40,18,41,18],[40,19,41,19],[40,20,41,20],[40,35,41,35],[40,36,41,36],[40,37,41,37],[40,38,41,38],[40,27,41,27],[40,28,41,28],[40,29,41,29],[40,30,41,30],[40,31,41,31],[40,32,41,32],[40,0,45,0],[40,1,41,1],[40,2,41,2],[40,3,41,3],[40,4,41,4],[40,5,41,5],[40,6,41,6],[40,7,41,7],[40,8,41,8],[44,7,45,7],[44,8,45,8],[7,23,8,25],[7,26,8,28],[40,9,41,9],[40,10,41,10],[40,11,41,11],[40,12,41,12],[40,13,41,13],[40,14,41,14],[7,57,8,57],[7,47,8,49],[7,50,8,52],[7,53,8,53],[7,54,8,54],[7,55,8,55],[7,56,8,56],[7,29,8,31],[7,32,8,34],[40,21,41,21],[40,22,41,22],[40,23,41,23],[40,24,41,24],[40,25,41,25],[40,26,41,26],[40,15,41,15],[6,38,6,40],[6,41,6,43],[6,44,6,46],[6,47,6,49],[6,50,6,52],[7,0,8,0],[7,1,8,1],[7,2,8,4],[7,5,8,7],[7,8,8,10],[6,20,6,22],[6,23,6,25],[6,26,6,28],[6,29,6,31],[6,32,6,34],[6,35,6,37],[7,35,8,37],[7,38,8,40],[7,41,8,43],[7,44,8,46],[7,11,8,13],[7,14,8,16],[7,17,8,19],[7,20,8,22],[6,0,6,1],[6,2,6,4],[6,5,6,7],[6,8,6,10],[6,11,6,13],[6,14,6,16],[6,17,6,19],[4,17,5,19],[4,20,5,20],[0,0,3,57],[4,0,5,0],[4,2,5,2],[4,4,5,4],[4,5,5,7],[4,8,5,8],[4,10,5,10],[4,11,5,13],[4,14,5,14],[4,16,5,16],[4,29,5,31],[4,32,5,34],[4,35,5,57],[4,22,5,22],[4,23,5,25],[4,26,5,26],[4,28,5,28]]}
["Skill Matrix"]
[]
[]
[]
["Skills Level Key",null,0,null,{"$f":"IF(C5=1,$BK$6,IF(C5=2,$BL$6,IF(C5=3,$BM$6,IF(C5=4,$BJ$6,$BI$6))))","v":"○"},"Unaware / N/A",null,null,1,null,{"$f":"IF(I5=1,$BK$6,IF(I5=2,$BL$6,IF(I5=3,$BM$6,IF(I5=4,$BJ$6,$BI$6))))","v":"◔"},"Aware of Task",null,null,2,null,{"$f":"IF(O5=1,$BK$6,IF(O5=2,$BL$6,IF(O5=3,$BM$6,IF(O5=4,$BJ$6,$BI$6))))","v":"◑"},"Can Do with Support",null,null,3,null,{"$f":"IF(U5=1,$BK$6,IF(U5=2,$BL$6,IF(U5=3,$BM$6,IF(U5=4,$BJ$6,$BI$6))))","v":"◕"},"Competent",null,null,4,null,{"$f":"IF(AA5=1,$BK$6,IF(AA5=2,$BL$6,IF(AA5=3,$BM$6,IF(AA5=4,$BJ$6,$BI$6))))","v":"●"},"Can Train Others",null,null,"Area"]
[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,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,null,null,"○","●","◔","◑","◕",null,null,null,"Yes"]
["Is the Resource Available →",null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Priority Ranking",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Minimum","Gap","Lead / Trainer"]
[]
[null,null,0,{"$f":"IF(AND($C$7=\"Yes\",C10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(C10=1,$BK$6,IF(C10=2,$BL$6,IF(C10=3,$BM$6,IF(C10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($F$7=\"Yes\",F10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(F10=1,$BK$6,IF(F10=2,$BL$6,IF(F10=3,$BM$6,IF(F10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($I$7=\"Yes\",I10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(I10=1,$BK$6,IF(I10=2,$BL$6,IF(I10=3,$BM$6,IF(I10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($L$7=\"Yes\",L10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(L10=1,$BK$6,IF(L10=2,$BL$6,IF(L10=3,$BM$6,IF(L10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($O$7=\"Yes\",O10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(O10=1,$BK$6,IF(O10=2,$BL$6,IF(O10=3,$BM$6,IF(O10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($R$7=\"Yes\",R10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(R10=1,$BK$6,IF(R10=2,$BL$6,IF(R10=3,$BM$6,IF(R10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($U$7=\"Yes\",U10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(U10=1,$BK$6,IF(U10=2,$BL$6,IF(U10=3,$BM$6,IF(U10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($X$7=\"Yes\",X10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(X10=1,$BK$6,IF(X10=2,$BL$6,IF(X10=3,$BM$6,IF(X10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AA$7=\"Yes\",AA10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AA10=1,$BK$6,IF(AA10=2,$BL$6,IF(AA10=3,$BM$6,IF(AA10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AD$7=\"Yes\",AD10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD10=1,$BK$6,IF(AD10=2,$BL$6,IF(AD10=3,$BM$6,IF(AD10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AG$7=\"Yes\",AG10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AG10=1,$BK$6,IF(AG10=2,$BL$6,IF(AG10=3,$BM$6,IF(AG10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AJ$7=\"Yes\",AJ10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AJ10=1,$BK$6,IF(AJ10=2,$BL$6,IF(AJ10=3,$BM$6,IF(AJ10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AM$7=\"Yes\",AM10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AM10=1,$BK$6,IF(AM10=2,$BL$6,IF(AM10=3,$BM$6,IF(AM10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AP$7=\"Yes\",AP10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AP10=1,$BK$6,IF(AP10=2,$BL$6,IF(AP10=3,$BM$6,IF(AP10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AS$7=\"Yes\",AS10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AS10=1,$BK$6,IF(AS10=2,$BL$6,IF(AS10=3,$BM$6,IF(AS10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AV$7=\"Yes\",AV10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AV10=1,$BK$6,IF(AV10=2,$BL$6,IF(AV10=3,$BM$6,IF(AV10=4,$BJ$6,$BI$6))))","v":"○"},0,{"$f":"IF(AND($AY$7=\"Yes\",AY10>=3),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AY10=1,$BK$6,IF(AY10=2,$BL$6,IF(AY10=3,$BM$6,IF(AY10=4,$BJ$6,$BI$6))))","v":"○"},null,{"$f":"COUNTIF(C10:BB10,\"Yes\")","v":0},0,{"$f":"SUM(BC10)-BD10","v":0},null,{"$f":"IF(BC10>BD10,BE10,(BE10+BD10))","v":0}]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC35>BD35,BE35,(BE35+BD35))","v":0}]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC37>BD37,BE37,(BE37+BD37))","v":0}]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC38>BD38,BE38,(BE38+BD38))","v":0}]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC39>BD39,BE39,(BE39+BD39))","v":0}]
[null,null,0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",0,"No","○",null,0,0,0,null,{"$f":"IF(BC40>BD40,BE40,(BE40+BD40))","v":0}]
["Ranking Scores",1,{"$f":"SUMIF($B$10:$B$40,1,C$10:C$40)-COUNTIFS($B$10:$B$40,1,C$10:C$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,F$10:F$40)-COUNTIFS($B$10:$B$40,1,F$10:F$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,I$10:I$40)-COUNTIFS($B$10:$B$40,1,I$10:I$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,L$10:L$40)-COUNTIFS($B$10:$B$40,1,L$10:L$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,O$10:O$40)-COUNTIFS($B$10:$B$40,1,O$10:O$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,R$10:R$40)-COUNTIFS($B$10:$B$40,1,R$10:R$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,U$10:U$40)-COUNTIFS($B$10:$B$40,1,U$10:U$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,X$10:X$40)-COUNTIFS($B$10:$B$40,1,X$10:X$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AA$10:AA$40)-COUNTIFS($B$10:$B$40,1,AA$10:AA$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AD$10:AD$40)-COUNTIFS($B$10:$B$40,1,AD$10:AD$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AG$10:AG$40)-COUNTIFS($B$10:$B$40,1,AG$10:AG$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AJ$10:AJ$40)-COUNTIFS($B$10:$B$40,1,AJ$10:AJ$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AM$10:AM$40)-COUNTIFS($B$10:$B$40,1,AM$10:AM$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AP$10:AP$40)-COUNTIFS($B$10:$B$40,1,AP$10:AP$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AS$10:AS$40)-COUNTIFS($B$10:$B$40,1,AS$10:AS$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AV$10:AV$40)-COUNTIFS($B$10:$B$40,1,AV$10:AV$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,1,AY$10:AY$40)-COUNTIFS($B$10:$B$40,1,AY$10:AY$40,4)","v":0}]
[]
[null,2,{"$f":"SUMIF($B$10:$B$40,2,C$10:C$40)-COUNTIFS($B$10:$B$40,2,C$10:C$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,F$10:F$40)-COUNTIFS($B$10:$B$40,2,F$10:F$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,I$10:I$40)-COUNTIFS($B$10:$B$40,2,I$10:I$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,L$10:L$40)-COUNTIFS($B$10:$B$40,2,L$10:L$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,O$10:O$40)-COUNTIFS($B$10:$B$40,2,O$10:O$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,R$10:R$40)-COUNTIFS($B$10:$B$40,2,R$10:R$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,U$10:U$40)-COUNTIFS($B$10:$B$40,2,U$10:U$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,X$10:X$40)-COUNTIFS($B$10:$B$40,2,X$10:X$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AA$10:AA$40)-COUNTIFS($B$10:$B$40,2,AA$10:AA$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AD$10:AD$40)-COUNTIFS($B$10:$B$40,2,AD$10:AD$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AG$10:AG$40)-COUNTIFS($B$10:$B$40,2,AG$10:AG$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AJ$10:AJ$40)-COUNTIFS($B$10:$B$40,2,AJ$10:AJ$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AM$10:AM$40)-COUNTIFS($B$10:$B$40,2,AM$10:AM$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AP$10:AP$40)-COUNTIFS($B$10:$B$40,2,AP$10:AP$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AS$10:AS$40)-COUNTIFS($B$10:$B$40,2,AS$10:AS$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AV$10:AV$40)-COUNTIFS($B$10:$B$40,2,AV$10:AV$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,2,AY$10:AY$40)-COUNTIFS($B$10:$B$40,2,AY$10:AY$40,4)","v":0}]
[]
[null,3,{"$f":"SUMIF($B$10:$B$40,3,C$10:C$40)-COUNTIFS($B$10:$B$40,3,C$10:C$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,F$10:F$40)-COUNTIFS($B$10:$B$40,3,F$10:F$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,I$10:I$40)-COUNTIFS($B$10:$B$40,3,I$10:I$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,L$10:L$40)-COUNTIFS($B$10:$B$40,3,L$10:L$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,O$10:O$40)-COUNTIFS($B$10:$B$40,3,O$10:O$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,R$10:R$40)-COUNTIFS($B$10:$B$40,3,R$10:R$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,U$10:U$40)-COUNTIFS($B$10:$B$40,3,U$10:U$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,X$10:X$40)-COUNTIFS($B$10:$B$40,3,X$10:X$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AA$10:AA$40)-COUNTIFS($B$10:$B$40,3,AA$10:AA$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AD$10:AD$40)-COUNTIFS($B$10:$B$40,3,AD$10:AD$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AG$10:AG$40)-COUNTIFS($B$10:$B$40,3,AG$10:AG$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AJ$10:AJ$40)-COUNTIFS($B$10:$B$40,3,AJ$10:AJ$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AM$10:AM$40)-COUNTIFS($B$10:$B$40,3,AM$10:AM$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AP$10:AP$40)-COUNTIFS($B$10:$B$40,3,AP$10:AP$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AS$10:AS$40)-COUNTIFS($B$10:$B$40,3,AS$10:AS$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AV$10:AV$40)-COUNTIFS($B$10:$B$40,3,AV$10:AV$40,4)","v":0},null,null,{"$f":"SUMIF($B$10:$B$40,3,AY$10:AY$40)-COUNTIFS($B$10:$B$40,3,AY$10:AY$40,4)","v":0}]
[]
[null,"Total",{"$f":"SUM(C41:C46)","v":0},null,null,{"$f":"SUM(F41:F46)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[]
["Vesatility Max Score",null,null,null,"Vesatility Max Score - 1",null,null,null,null,null,null,null,null,"Vesatility Max Score - 2"]
[]
["No. Skills",{"$f":"COUNTA(A10:A40)","v":0},null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B40,1)","v":0},null,null,null,null,"No. Skills",null,null,null,{"$f":"COUNTIF(B10:B40,2)","v":0}]
[]
["Max Score",3,null,null,"Max Score",null,null,null,{"$f":"B54","v":3},null,null,null,null,"Max Score",null,null,null,{"$f":"B54","v":3}]
[]
["Number Staff",{"$f":"COUNTA(C8:BA9)","v":0},null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0},null,null,null,null,"Number Staff",null,null,null,{"$f":"COUNTA(C8:BA9)","v":0}]
[]
[null,{"$f":"B52*B54*B56","v":0},null,null,null,null,null,null,{"$f":"I52*I54*I56","v":0},null,null,null,null,null,null,null,null,{"$f":"R52*R54*R56","v":0}]
[]
[]
["Team Score",null,null,null,"Team Score - 1",null,null,null,null,null,null,null,null,"Team Score - 2"]
[]
["Total Team Score",{"$f":"SUM(C47:AY48)","v":0},null,null,"Total Team Score",null,null,null,{"$f":"SUM(C41:AY42)","v":0},null,null,null,null,"Total Team Score",null,null,null,{"$f":"SUM(C43:AY44)","v":0}]
[]
["Vesatility Max Score",{"$f":"B58","v":0},null,null,"Vesatility Max Score",null,null,null,{"$f":"I58","v":0},null,null,null,null,"Vesatility Max Score",null,null,null,{"$f":"R58","v":0}]
[]
[null,{"$f":"(B63/B65)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"(I63/I65)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"(R63/R65)","v":{"$error":"#DIV/0!"}}]