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

{"sheet":"Sheet1","index":0,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[54,0,56,2],[40,0,40,2],[26,0,26,2],[0,0,0,2],[53,0,53,1],[39,0,39,1],[25,0,25,1],[10,0,10,1]]}
["Mobile Readiness Calculator\nCopyright 2017 OnPoint Digital Inc."]
[null,"Take this survey to help determine whether your organization's mobility needs are better served using (a) a branded app installed via an App Store onto each user's device (the native app approach), (b) using a mobile friendly web site (the mobile \"web app\" approach), or (c) either or both could be viable solutions.","Click in the box to select your response from the drop down menu"]
["A","Ecosystem/Operating Environment","Provide Responses for each"]
[1,"Do workers/users in your broader ecosystem typically use mobile devices for personal communications, Internet access and/or as productivity tools already?",null,{"$f":"IF(C4=\"Yes, our average user is mobile ready\",3,IF(C4=\"No, our average user is not mobile ready\",1,IF(C4=\"Natives\",3,IF(C4=\"Casual\",2,IF(C4=\"Newbie\",1,IF(C4=\"Several\",3,IF(C4=\"Some\",2,IF(C4=\"Few\",1,IF(C4=\"Continuous\",3,IF(C4=\"Steady\",2,IF(C4=\"Occasional\",1,IF(C4=\"Company Issued\",5,IF(C4=\"Company Shared\",3,IF(C4=\"BYOD\",3,IF(C4=\"Personal\",1,IF(C4=\"Combination\",5,\"\"))))))))))))))))","v":""},"3,1","Yes, our average user is mobile ready","No, our average user is not mobile ready"," "]
[2,"Estimate the average \"mobile IQ\" of your broader ecosystem via the choices: Digital Natives (High), Casuals (Medium) or Newbies (Low) ",null,{"$f":"IF(C5=\"yes\",3,IF(C5=\"No\",1,IF(C5=\"Our typical user is a Digital Native\",3,IF(C5=\"Our typical user is a Casual user\",2,IF(C5=\"Our typical users are Newbies\",1,IF(C5=\"Several\",3,IF(C5=\"Some\",2,IF(C5=\"Few\",1,IF(C5=\"Continuous\",3,IF(C5=\"Steady\",2,IF(C5=\"Occasional\",1,IF(C5=\"Company Issued\",5,IF(C5=\"Company Shared\",3,IF(C5=\"BYOD\",3,IF(C5=\"Personal\",1,IF(C5=\"Combination\",5,\"\"))))))))))))))))","v":""},"3,2,1","Our typical user is a Digital Native","Our typical user is a Casual user","Our typical users are Newbies"," "]
[3,"Estimate how often are mobile devices used for work-related purposes by your broader ecosystem via the choices:  Continuous (Email, messaging, browsing, several apps, searches), Steady (email, browsing, some apps) or Occasional (just calls & emails)",null,{"$f":"IF(C6=\"yes\",3,IF(C6=\"No\",1,IF(C6=\"Natives\",3,IF(C6=\"Casual\",2,IF(C6=\"Newbie\",1,IF(C6=\"Several\",3,IF(C6=\"Some\",2,IF(C6=\"Few\",1,IF(C6=\"Typical patterns for mobile use are continuous\",3,IF(C6=\"Typical patterns for mobile use are steady\",2,IF(C6=\"Typical patterns for mobile use are occasional\",1,IF(C6=\"Company Issued\",5,IF(C6=\"Company Shared\",3,IF(C6=\"BYOD\",3,IF(C6=\"Personal\",1,IF(C6=\"Combination\",5,\"\"))))))))))))))))","v":""},"3,2,1","Typical patterns for mobile use are continuous","Typical patterns for mobile use are steady","Typical patterns for mobile use are occasional"]
[4,"Quantify the number of native apps adopted by your organization that are deployed in support of your ecosystem via the choices: Several (6 or more), Some (3 to 5) or Few (2 or less)",null,{"$f":"IF(C7=\"Natives\",3,IF(C7=\"Casual\",2,IF(C7=\"Newbie\",1,IF(C7=\"Typical users use several apps everyday\",3,IF(C7=\"Typical users use some apps everyday\",2,IF(C7=\"Typical users use a few apps everyday\",1,IF(C7=\"Continuous\",3,IF(C7=\"Steady\",2,IF(C7=\"Occasional\",1,IF(C7=\"Company Issued\",5,IF(C7=\"Company Shared\",3,IF(C7=\"BYOD\",3,IF(C7=\"Personal\",1,IF(C7=\"Combination\",5,\"\"))))))))))))))","v":""},"3,2,1","Typical users use several apps everyday","Typical users use some apps everyday","Typical users use a few apps everyday"]
[5,"Is the identity of your target community of users known in advance (e.g., current employees) or do you need to support a broader, public community via self registration?",null,{"$f":"IF(C8=\"Y\",1,IF(C8=\"N\",0,IF(C8=\"Tablets\",1,IF(C8=\"Handsets\",3,IF(C8=\"Laptops\",1,IF(C8=\"Combination\",5,IF(C8=\"Wi-Fi\",1,IF(C8=\"Device Data Plan\",3,IF(C8=\"Yes\",3,IF(C8=\"No\",1,IF(C8=\"Private Store/MDM\",3,IF(C8=\"Public Store/App Store/Google Play\",1,IF(C8=\"Known Users\",5,IF(C8=\"Self-Registrants\",1,\"\"))))))))))))))","v":""},"5,1","Known Users","Self-Registrants"]
[6,"Are your users' devices typically modern (less than 2 years old) or would they include legacy devices?",null,{"$f":"IF(C9=\"Users' devices are typically the latest and greatest\",5,IF(C9=\"Users' devices are typically older with limited capabilities\",1,))","v":0},"5,1","Users' devices are typically the latest and greatest","Users' devices are typically older with limited capabilities"]
[null,"Your Ecosystem/Operating Environment Score:",{"$f":"SUM(D4:D9)","v":0}]
["Section A Score Range (6-22)                                                                                            Native App: 18 or Higher , Mixed Use: 15-17, Mobile Web:  14 or less",null,{"$f":"IF(C10>=18,\"Native App\",IF(C10>=15,\"Mixed Use\",IF(C10<15,\"Mobile Web\" )))","v":"Mobile Web"},null,null,26]
[]
["B","Mobile Devices, Access Profiles & Security"]
[7,"What are the typical types of devices Issued/Supported and/or recommended for use across your mobile environment? ","Enter Responses Below"]
[null,"- Apple iOS (iPhone, iPad, iPod Touch Media Player)",null,{"$f":"IF(C15=\"Yes\",2,IF(C15=\"No\",0,IF(C15=\"Tablets\",1,IF(C15=\"Handsets\",3,IF(C15=\"Laptops\",1,IF(C15=\"Combination\",5,IF(C15=\"Wi-Fi\",1,IF(C15=\"Device Data Plan\",3,IF(C15=\"Yes\",3,IF(C15=\"No\",1,IF(C15=\"Private Store/MDM\",3,IF(C15=\"Public Store/App Store/Google Play\",1,IF(C15=\"Known Users\",5,IF(C15=\"Self-Registrants\",1,\"\"))))))))))))))","v":""},"2,0","Yes","No"]
[null,"- Google Android OS (handsets, tablets)",null,{"$f":"IF(C16=\"Yes\",2,IF(C16=\"No\",0,IF(C16=\"Tablets\",1,IF(C16=\"Handsets\",3,IF(C16=\"Laptops\",1,IF(C16=\"Combination\",5,IF(C16=\"Wi-Fi\",1,IF(C16=\"Device Data Plan\",3,IF(C16=\"Yes\",3,IF(C16=\"No\",1,IF(C16=\"Private Store/MDM\",3,IF(C16=\"Public Store/App Store/Google Play\",1,IF(C16=\"Known Users\",5,IF(C16=\"Self-Registrants\",1,\"\"))))))))))))))","v":""},"2,0","Yes","No"]
[null,"- Microsoft Windows 10 OS (handsets, tablets, laptops)",null,{"$f":"IF(C17=\"Yes\",-3,IF(C17=\"No\",0,IF(C17=\"Tablets\",1,IF(C17=\"Handsets\",3,IF(C17=\"Laptops\",1,IF(C17=\"Combination\",5,IF(C17=\"Wi-Fi\",1,IF(C17=\"Device Data Plan\",3,IF(C17=\"Yes\",3,IF(C17=\"No\",1,IF(C17=\"Private Store/MDM\",3,IF(C17=\"Public Store/App Store/Google Play\",1,IF(C17=\"Known Users\",5,IF(C17=\"Self-Registrants\",1,\"\"))))))))))))))","v":""},"-3,0","Yes","No"]
[null,"- BlackBerry Handsets BBOS (handsets)",null,{"$f":"IF(C18=\"Yes\",2,IF(C18=\"No\",0,IF(C18=\"Tablets\",1,IF(C18=\"Handsets\",3,IF(C18=\"Laptops\",1,IF(C18=\"Combination\",5,IF(C18=\"Wi-Fi\",1,IF(C18=\"Device Data Plan\",3,IF(C18=\"Yes\",3,IF(C18=\"No\",1,IF(C18=\"Private Store/MDM\",3,IF(C18=\"Public Store/App Store/Google Play\",1,IF(C18=\"Known Users\",5,IF(C18=\"Self-Registrants\",1,\"\"))))))))))))))","v":""},"2,0","Yes","No"]
[8,"What is the preferred form factor for mobile delivered content via these choices: Tablets, Handsets, Laptops or Any Combination?",null,{"$f":"IF(C19=\"Y\",1,IF(C19=\"N\",0,IF(C19=\"Tablets\",1,IF(C19=\"Handsets\",3,IF(C19=\"Laptops\",1,IF(C19=\"Combination\",5,IF(C19=\"Wi-Fi\",1,IF(C19=\"Device Data Plan\",3,IF(C19=\"Yes\",3,IF(C19=\"No\",1,IF(C19=\"Private Store/MDM\",3,IF(C19=\"Public Store/App Store/Google Play\",1,IF(C19=\"Known Users\",5,IF(C19=\"Self-Registrants\",1,\"\"))))))))))))))","v":""},"1,3,1,5","Tablets","Handsets","Laptops","Combination"]
[9,"How will access to mobile sites and apps be supported via these choices:  Corporate or personal Wi-Fi, Device's Data Plan or Combination?",null,"","1,3,5","Wi-Fi","Device Data Plan","Combination"]
[10,"Does your IT team recommend or mandate the use of Single Sign-On (SSO) to control mobile access?",null,"","3,1","Yes","No"]
[11,"Does your IT team use a Mobile Device Management (MDM) platform as a Private App Store, can users freely install apps from public sites like Apple's iTunes App Store or Google Play Store, or do you support both:",null,"","3,1,5","Private Store/MDM","Public (iTunes, Google Play, etc.)","Combination"]
[12,"Detail how mobile devices are provisioned/supplied to workers in your environment via the choices: Company Issued (to each person by IT),  Company Shared (shared across a group/department via IT),  Bring Your Own Device (User supplied but IT controlled), Personal Devices (User supplied, no restrictions) or any Combination:",null,{"$f":"IF(C23=\"yes\",3,IF(C23=\"No\",1,IF(C23=\"Natives\",3,IF(C23=\"Casual\",2,IF(C23=\"Newbie\",1,IF(C23=\"Several\",3,IF(C23=\"Some\",2,IF(C23=\"Few\",1,IF(C23=\"Continuous\",3,IF(C23=\"Steady\",2,IF(C23=\"Occasional\",1,IF(C23=\"Our company supports a wide variety of company issued devices\",5,IF(C23=\"Our company supports a wide variety of company shared devices\",3,IF(C23=\"Our company supports a wide variety of user supplied, IT controlled devices (BYOD)\",3,IF(C23=\"Our company supports a wide variety of personal devices\",1,IF(C23=\"Our company supports a combination of company and user supplied devices\",5,\"\"))))))))))))))))","v":""},"5,3,3,1,5","Our company supports a wide variety of company issued devices","Our company supports a wide variety of company shared devices","Our company supports a wide variety of user supplied, IT controlled devices (BYOD)","Our company supports a wide variety of personal devices","Our company supports a combination of company and user supplied devices"]
[13,"How available is internet service/bandwidth in the user's environment?",null,{"$f":"IF(C24=\"Abundant, no problems\",1,IF(C24=\"Restricted, some issues\",3,IF(C24=\"Scarce, problematic\",5,\"\")))","v":""},"1,3,5","Abundant, no problems","Restricted, some issues","Scarce, problematic"]
[null,"Your Mobile Devices, Access Profiles & Security Score:",{"$f":"SUM(D15:D24)","v":0}]
["Section B Score Range (3-34)                                                                                            Native App: 25 or Higher , Mixed Use: 15-24, Mobile Web:  14 or less",null,{"$f":"IF(C25>=25,\"Native App\",IF(C25>=15,\"Mixed Use\",IF(C25<15,\"Mobile Web\" )))","v":"Mobile Web"}]
[]
["C","Supported Content Types"]
[14,"Which of the following types of mobile friendly content do you wish to distribute to your target audience?","Enter Responses Below",null,"Y/N"]
[null,"- Media Files (video clips)",null,{"$f":"IF(C30=\"Yes\",2,IF(C30=\"No\",1,\"\"))","v":""},"2,1","Yes","No"]
[null,"- Media Files (audio clips)",null,{"$f":"IF(C31=\"Yes\",2,IF(C31=\"No\",1,\"\"))","v":""},"2,1","Yes","No"]
[null,"- Web Content (HTML files or online web sites)",null,{"$f":"IF(C32=\"Yes\",1,IF(C32=\"No\",1,\"\"))","v":""},"1,1","Yes","No"]
[null,"- Digital Documents (PDFs, ePUBs) Editable",null,{"$f":"IF(C33=\"Yes\",5,IF(C33=\"No\",1,\"\"))","v":""},"5,1","Yes","No"]
[null,"- Digital Documents (PDFs, ePUBs) Non-editable",null,{"$f":"IF(C34=\"Yes\",1,IF(C34=\"No\",1,\"\"))","v":""},"2,1","Yes","No"]
[null,"- Packaged Courses (Off the Shelf, Vendor Managed, e.g., Skillsoft, Lynda)",null,{"$f":"IF(C35=\"Yes\",-9,IF(C35=\"No\",1,\"\"))","v":""},"-9, 1","Yes","No"]
[null,"- Custom Courses (Custom or Internally Developed)",null,{"$f":"IF(C36=\"Yes\",1,IF(C36=\"No\",1,\"\"))","v":""},"1,1","Yes","No"]
[null,"- Assessments (Tests, Quizzes, Surveys)",null,{"$f":"IF(C37=\"Yes\",3,IF(C37=\"No\",1,\"\"))","v":""},"3,1","Yes","No"]
[15,"What level of tracking (and reporting) do you require for your content/courseware delivered to your mobile users?",null,{"$f":"IF(C38=\"Full\",5,IF(C38=\"Basic\",3,IF(C38=\"None\",0,\"\")))","v":""},"5,3,0","Full","Basic","None"]
[null,"Your Supported Content Types Score :",{"$f":"SUM(D29:D38)","v":0}]
["Section C Score Range (-2 to 22)                                                                                           Native App: 16 or Higher , Mixed Use: 12-15 Mobile Web: 11 or less",null,{"$f":"IF(C39>=16,\"Native App\",IF(C39>=12,\"Mixed Use\",IF(C39<12,\"Mobile Web\" )))","v":"Mobile Web"}]
[]
["D","Other Mobile Features"]
[16,"Consider each of the following application features of an advanced mobile experience and tell us whether you would consider them as: \"Essential\", \"Nice to Have\" or \"Not Needed\" to support your target audience?","Enter Responses Below"]
[null,"- Messaging Services (Email, Alerts, Push Notifications)",null,{"$f":"IF(C44=\"Essential\",8,IF(C44=\"Not Needed\",0,IF(C44=\"Nice to Have\",3,\"\")))","v":""},"8,3,0","Essential","Nice to Have","Not Needed"]
[null,"- Social Networking (Chat, Forums, Likes)",null,{"$f":"IF(C45=\"Essential\",5,IF(C45=\"Not Needed\",0,IF(C45=\"Nice to Have\",3,\"\")))","v":""},"5,3,0","Essential","Nice to Have","Not Needed"]
[null,"- Gamification (Points, Badges, Leaderboards)",null,"","5,3,0","Essential","Nice to Have","Not Needed"]
[null,"- Appraisals (Performance Reviews, Observations)",null,"","5,3,0","Essential","Nice to Have","Not Needed"]
[null,"- User-Generated Content (Videos, Images)",null,{"$f":"IF(C48=\"Essential\",8,IF(C48=\"Not Needed\",0,IF(C48=\"Nice to Have\",3,\"\")))","v":""},"8,3,0","Essential","Nice to Have","Not Needed"]
[null,"- Mentoring/Coaching (OJT Assistance)",null,"","5,3,0","Essential","Nice to Have","Not Needed"]
[null,"- News Feeds (Industry/Market Information, RSS Feeds)",null,"","1,1,1","Essential","Nice to Have","Not Needed"]
[null,"- Document Management (Access to Policies, Procedures & Materials)",null,{"$f":"IF(C51=\"Essential\",-1,IF(C51=\"Not Needed\",1,IF(C51=\"Nice to Have\",1,\"\")))","v":""},"-1,1,1","Essential","Nice to Have","Not Needed"]
[null,"- Ecommerce",null,{"$f":"IF(C52=\"Essential\",-1,IF(C52=\"Not Needed\",1,IF(C52=\"Nice to Have\",1,\"\")))","v":""},"-1,1,1","Essential","Nice to Have","Not Needed"]
[null,"Your Other Mobile Features Score:",{"$f":"SUM(D43:D52)","v":0}]
["Section D Score Range (-1 to 39)                                                                                            Native App: 18 or Higher , Mixed Use: 12-17, Mobile Web:  11 or less",null,{"$f":"IF(C53>=18,\"Native App\",IF(C53>=12,\"Mixed Use\",IF(C53<12,\"Mobile Web\" )))","v":"Mobile Web"}]
[]
[]
[]
[null,"Your Total Mobile Readiness Score: (6-117)                                         Native App: 84 or Higher , Mixed Use: 55 to 83, Mobile Web:  54 to 45, Not Ready for Mobile: 44 or less",{"$f":"C53+C39+C25+C10","v":0}]
[null,"Your Overall Recommendation:",{"$f":"IF(C58>=84,\"Native App\",IF(C58>=55,\"Mixed Use\",IF(C58>=45,\"Mobile Web\",IF(C58<=44,\"Not Ready for Mobile\"))))","v":"Not Ready for Mobile"}]
[null,null,"CTL+T to reset form for another try"]
[null,null,"Note:  Macros must be enabled!"]