{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","012345678909876543210","Chart Tab","Data","Pivot Tables","Sheet8"],"not_rendered":{"charts":6,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":5},"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":"Instructions","index":0,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,2,2,10],[4,2,4,10],[6,2,6,10],[8,2,8,10],[10,2,10,10],[44,2,44,10],[46,2,46,10],[26,2,26,10],[28,2,28,10],[30,2,30,10],[32,2,32,10],[34,2,34,10],[36,2,36,10],[4,13,4,20],[6,13,6,20],[38,2,38,10],[40,2,40,10],[42,2,42,10],[14,2,14,10],[16,2,16,10],[18,2,18,10],[20,2,20,10],[22,2,22,10],[24,2,24,10],[12,2,12,10]]}
[]
[]
[null,null,"Instructions for Final Project",null,null,null,null,null,null,null,null,null,null,"Instructor Feedback:"]
[]
[null,null,"1.1 Introduction: This project is designed to give you a chance to apply the tools and skills you have acquired throughout the course to a business problem The business could be a real business or a business you have thought of starting up.",null,null,null,null,null,null,null,null,null,null,"\"The problem with the existing chart tools is that they are too general.  If you know something about what kind of data you are working with, you could dramatically imporve the assistance you could give.  My recommendation is to support the kinds of datasets you have worked with.  You are right, this could be a great benefit.\""]
[]
[null,null,"1.2 Project Proposal:  An earlier homework assignment required you to submit an idea for your final project.  Your professor should have indicated if the scope of your project was sufficient.  Remember that you can change the nature of your final project at any time.  You may discuss changes to your project with your professor but it is not required that you do so.",null,null,null,null,null,null,null,null,null,null,"\"Another thing you could do in this space is to automatically format as set of charts for printing.  That is, if a worksheet has multiple charts, you could allow the user to specify how may to show across a page and then re-position and resize them to print appropriately.\""]
[]
[null,null,"1.3 Project Scope:  The final project is a substantial portion of your grade.  It is worth much more than the total of all the prior projects combined.  If you wonder how much effort you should put toward your final project, consider its relative weight to the other class projects."]
[]
[null,null,"1.4 Getting Help:  In other class projects, you were to do entirely your own work.  That is, you could get detailed help on the assignments only from the professor or the teaching assistant.  For your final project, you may get detailed help from any source; however, if others write code for you, please disclose the amount of help in the write up."]
[]
[null,null,"1.5 Project Evaluation: As a general rule, your project will be evaluated based on how well the project works without regard to how efficient your VBA code is.  However, if the grader looks at your code and sees something that demonstrates a lack of understanding of fundamental course concepts (e.g. writing 10 separate “if” statement when you could have used just one inside a loop), you may have points deducted."]
[]
[null,null,"1.6 Project Appearance: You are developing a professional solution and your final product should appear professional.  Use user forms and ribbon modifications where appropriate.  Colors, formatting, alignment, font and other aesthetic considerations should be made as you build your solution."]
[]
[null,null,"2.1 Your write-up must be formatted as a PDF document."]
[]
[null,null,"2.2 Executive summary of the project. This should contain a description of the business along with an overview of the system you built"]
[]
[null,null,"2.3 Implementation documentation. Provide a concise, well-organized documentation of what you actually did for your solution. You may want to use tables or bulleted lists to describe the components of your solution and their role in the overall task. In any case, you should provide a textual description of the elements so it is clear what you have done, why it was included, how it is intended to be used in the task. Screen captures may be helpful in illustrating what you have done."]
[]
[null,null,"2.4 Discussion of learning and conceptual difficulties encountered. Let me know what you learned by going through this project. If there are elements you wanted to include but could not get to work, discuss these in this section. Please be sure that you have tried to solve the problem, including asking the professor for assistance, before giving up."]
[]
[null,null,"2.5 Assistance: If you had substantial help from another person or persons on this project, please disclose the nature and amount of help you received in this section.  If you did not receive substantial assistance, state so here."]
[]
[null,null,"2.6 Write-up detail. The write-up should be of sufficient detail that the professor could grade your project just by examining the write up. That is, the write up should stand on its own merits in discussing the project without needing to refer the reader to any of the workbook for clarification."]
[]
[null,null,"3. Working in teams. You may pair up for the final project; however, if you choose to have two people developing the project, I will expect the scope of the project to be larger than a minimally acceptable project for an individual."]
[]
[null,null,"4. Post your Project. Posting your blog is a five-part process as outlined below:"]
[]
[null,null,"A. Become a Blog Author: Your professor will send you an invitation to become an author of the VBAProjects.blogspot.com blog.  You will need to accept this invitation to have permission to post your executive summary to the blog."]
[]
[null,null,"B. Executive Summary:  Post the executive summary of your project write-up as a blog entry at vbaproject.blogspot.com. "]
[]
[null,null,"C. Upload your Files: Upload your write-up as well as any additional files that are necessary to run your project.  You will need to upload at least two files (your write-up PDF and your Excel workbook).  The URL to use for uploading your files is as follows:"]
[]
[null,null,"http://desk.gove.net/upload/upload.html﻿"]
[]
[null,null,"Here you will need a username and a six-digit code to allow you to upload your files.  Your username is your Route-Y Net ID. Your professor will send you the six-digit code.  "]
[]
[null,null,"After you upload each file, you will see a list of the URLs for all the files you have uploaded.  You will need these URLs to complete your blog posting."]
[]
[null,null,"D. Add links to your blog post:  Immediately after your executive summary on your blog entry, place links to each of the files you have uploaded."]
[]
[null,null,"E. Submit your blog URL to LearningSuite: To facilitate my grading of your project, I need you to submit a link to your blog entry here (the \"final Project\" assignment at LearningSuite).  The blog serves as a location for you to submit your work where others can access it; however, it is very poorly organized for grading purposes.  The link that you submit will allow me to have direct access to your submission from within LearningSuite."]

{"sheet":"012345678909876543210","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Chart Tab","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":3,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Mirs Id","Summary","Caused By Change","Change Id","P1 MTRS Minutes","Open Date & Time","Last Resolved Date & Time","Portfolio"]
["MIRS00000002602","PARENT-Various system accounts were deleted.","Y","undoc. change",113,"2011-01-14","2011-01-14","Enterprise Information Mgmt"]
["MIRS00000002641","PROD-VM outages","Y","CMS2102939",1440,"2011-01-14","2011-01-15","IT Foundations"]
["MIRS00000002643","PARENT: ldschurch.jp is down with the error number 145. (see description for more info)","Y","unathorized chg",35,"2011-01-16","2011-01-16","Member and Leader Work"]
["MIRS00000002681","PARENT: People in England are reporting issues accessing CDOL at type 3 sites.","Y","break fix chg",126,"2011-01-18","2011-01-18","Member and Leader Work"]
["MIRS00000002687","MettingPlace Server is Unavailable","Y","CMS2102899",319,"2011-02-03","2011-02-03","IT Foundations"]
["MIRS00000002722","Web Connectivity and slowness to and from Church Network","Y","undocumented",218,"2011-02-03","2011-02-03","End User Productivity"]
["MIRS00000002805","Broadcasting and streaming is not working.","Y","cms2103192",60,"2011-02-19","2011-02-19","IT Foundations"]
["MIRS00000002922","PARENT CFIS is causing issues with financial systems","Y","CMSUnknown",551,"2011-03-04","2011-03-04","Finance and Legal"]
["MIRS00000003042","Directory driver problems","Y","cms2103409",15,"2011-03-14","2011-03-14","Enterprise Information Mgmt"]
["MIRS00000003081","PARENT LDS.ORG outages","Y","Undocumented",80,"2011-04-08","2011-04-08","IT Foundations"]
["MIRS00000003121","SAN outage - an error in SAN took down about 750 hosts and 1100 services.","Y","CMS2103894",720,"2011-04-12","2011-04-13","IT Foundations"]
["MIRS00000003321","Windows, Database and Linux hosts down","Y","Undocumented",121,"2011-05-15","2011-05-15","IT Foundations"]
["MIRS00000003361","Newly created lds account synchronization errors","Y","CMS2104123",870,"2011-05-15","2011-05-15","Enterprise Information Mgmt"]
["MIRS00000003401","(PARENT)Storage device went down.","Y","Undoc Vendor Ch",265,"2011-05-20","2011-05-20","IT Foundations"]
["MIRS00000003564","Outlook was disconnected because of servers being transferred.","Y","CMS2104495",240,"2011-06-16","2011-06-16","End User Productivity"]
["MIRS00000003601","Web site bsp.blackrock.com is not available","Y","Undocumented",302,"2011-06-20","2011-06-20","IT Foundations"]
["MIRS00000003602","PARENT: Perpetual education fund outage.","Y","CMPossibly",308,"2011-06-20","2011-06-20","Finance and Legal"]
["MIRS00000003641","Cannot Login to Workstations using Novell in the WOB","Y","Undocumented",180,"2011-07-04","2011-07-04","IT Foundations"]
["MIRS00000003642","Users with Leader Role in CDOL cannot log in to the Missionary Recommendation system","Y","CMS2104580",3379,"2011-07-09","2011-07-11","Missionary Work"]
["MIRS00000003881","Data Center Switches Down Affecting Multiple Services","Y","Undocumented",462,"2011-08-12","2011-08-12","IT Foundations"]
["MIRS00000003883","PCI-Thin Clients for processing credit cards not working for Distribution Center","Y","Undocumented",29.85,"2011-08-18","2011-08-18","IT Foundations"]
["MIRS00000004001","PARENT Peoplesoft problems","Y","CMS2007999",255,"2011-09-02","2011-09-02","Finance and Legal"]
["MIRS00000004002","PARENT Unable to Login to IMOS","Y","Undocumented",375,"2011-09-16","2011-09-16","Missionary Work"]
["MIRS00000004003","PARENT lds.org page unavailable after failover test","Y","CMS2105324",75,"2011-09-23","2011-09-23","Member and Leader Work"]
["MIRS00000004081","CMIS is down and causing login issues.","Y","Undocumented",54,"2011-11-07","2011-11-07","Member and Leader Work"]
["MIRS00000004121","The BGB pairing between DR LAN side and black rock router are in an active state (disconnected)","Y","CMS0005939",99,"2011-11-08","2011-11-08","IT Foundations"]
["MIRS00000004122","PARENT: Ldsaccount down affecting several applications","Y","Undocumented",148,"2011-11-08","2011-11-08","IT Foundations"]
["MIRS00000004125","LDS Account service outage","Y","CMS2105990",19,"2011-11-25","2011-11-26","Family History"]
["MIRS00000004162","PARENT IMOS application errors","Y","CMS2106100",181,"2011-11-12","2011-11-12","Missionary Work"]
["MIRS00000004164","LUFAS System down","Y","CMS000????",1146,"2011-11-14","2011-11-15","Other Operations"]
["MIRS00000004166","Worldwide server and temple failure.","Y","CMS2106084",690,"2011-11-19","2011-11-19","IT Foundations"]
["INC000001983086","PARENT WAM authentication issues","Y","Undocumented",66,"2011-12-02T02:23:00","2011-12-02T03:29:00","Enterprise Information Mgmt"]
["INC000001987101","PARENT LDS.org, mormon.org, and other related websites and links affected","Y","CMS2106255",19,"2011-12-06T12:32:00","2011-12-06T12:51:00","Public Affairs"]
["INC000001992537","MLS Issues","Y","Undocumented",121,"2011-12-11T17:16:00","2011-12-11T19:17:00","Emerging Technologies"]
["INC000001993691","LURBS was down (CHQPVUL5029 is down)","Y","CMS2106031",110,"2011-12-12T14:00:00","2011-12-12T15:50:00","Enterprise Information Mgmt"]
["INC000002000082","Multiple Applications Down following Maintenance Window","Y","CMS2106405",218,"2011-12-17T07:00:00","2011-12-17T10:38:00","IT Foundations"]
["INC000002000275","PARENT mail.ldschurch.org  OWA alerts","Y","CMS2106405",180,"2011-12-18T19:30:00","2011-12-18T22:30:00","IT Foundations"]
["INC000002005664","Deseret Trust Corporation Network Issues","Y","Undocumented",35,"2011-12-22T10:00:00","2011-12-22T10:35:00","IT Foundations"]
["MIRS00000004443","CDOL Application Unavailable","Y","CMS2106783",81,"2012-01-31T08:24:00","2012-01-31T09:45:00","Member and Leader Work"]
["MIRS00000004483","LDS.org issues (CDOL Web Services) (SUN)","Y","CMS2106783",169,"2012-02-05T09:20:00","2012-02-05T12:09:00","Member and Leader Work"]
["MIRS00000004486","Infoguide Application is unavailable","Y","CMS2106982",15,"2012-02-13T11:30:00","2012-02-13T11:45:00","Enterprise Information Mgmt"]
["MIRS00000004522","Family History - Connectivity issues","Y","CMS2106931",276,"2012-02-14T08:30:00","2012-02-14T13:06:00","End User Productivity"]
["MIRS00000004528","IMOS Reports unavailable (Business Objects)","Y","CMS2107114",578,"2012-02-24T09:00:00","2012-02-24T18:38:00","Enterprise Information Mgmt"]
["MIRS00000004530","Kronos web portal unavailable","Y","CMS2107067",1170,"2012-02-19T17:00:00","2012-02-20T12:30:00","Finance and Legal"]
["MIRS00000004562","LDS.org and other authentication applications unavailable","Y","CMS2106675",8,"2012-03-10T11:17:00","2012-03-10T11:25:00","IT Foundations"]
["MIRS00000004563","Data Domain outage (Afternoon)","Y","CMS2107421",18,"2012-03-21T12:45:00","2012-03-21T13:03:00","Enterprise Information Mgmt"]
["MIRS00000004564","MLS batch update issue","Y","CMS2106373",690,"2012-03-25T07:00:00","2012-03-25T18:30:00","Enterprise Information Mgmt"]
["MIRS00000004644","Network problems in Africa West","Y","Undocumented",240,"2012-04-11T05:00:00","2012-04-11T09:00:00","IT Foundations"]
["MIRS00000004645","Argentina Area Office intranet access unavailable","Y","Undocumented",195,"2012-04-11T05:00:00","2012-04-11T08:15:00","IT Foundations"]
["MIRS00000004648","IAGS down","Y","CMS2107685",122,"2012-04-20T07:00:00","2012-04-20T09:02:00","Supply Chain"]
["MIRS00000004649","IMOS dashboard function is down","Y","CMS2107685",130,"2012-04-20T08:30:00","2012-04-20T10:40:00","Missionary Work"]
["MIRS00000004721","Multiple Applications Unavailable","Y","CMS2107806",43,"2012-04-25T09:08:00","2012-04-25T09:51:00","IT Foundations"]

{"sheet":"Pivot Tables","index":4,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Note: The reason for having pivot charts located all over the place on this page is that since they are dynamic and change based on the filtered criteria, the needed rows/columns changes. By spacing them this way it ensures data won't overlap when a table is reformed."]
[]
["P1 MTRS Minutes","P1 MTRS Hours","Portfolio","Documentation","Open Date & Time"]
[81,{"$f":"A4/60","v":1.35},"Member and Leader Work","Documented","2012-01-31T08:24:00",null,"Sum of P1 MTRS Hours","Column Labels",null,null,null,"Sum of P1 MTRS Hours","Column Labels"]
[169,2.8166666666666669,"Member and Leader Work","Documented","2012-02-05T09:20:00",null,"Row Labels","Documented","Undocumented","Grand Total",null,"Row Labels","Documented","Undocumented","Grand Total"]
[15,0.25,"Enterprise Information Mgmt","Documented","2012-02-13T11:30:00",null,"End User Productivity",4.5999999999999996,null,4.5999999999999996,null,"Feb",14.483333333333333,null,14.483333333333333]
[276,4.5999999999999996,"End User Productivity","Documented","2012-02-14T08:30:00",null,"Enterprise Information Mgmt",21.683333333333334,null,21.683333333333334,null,"Enterprise Information Mgmt",9.8833333333333329,null,9.8833333333333329]
[578,9.6333333333333329,"Enterprise Information Mgmt","Documented","2012-02-24T09:00:00",null,"Finance and Legal",19.5,null,19.5,null,"End User Productivity",4.5999999999999996,null,4.5999999999999996]
[1170,19.5,"Finance and Legal","Documented","2012-02-19T17:00:00",null,"IT Foundations",0.85,7.25,8.1,null,"Mar",11.933333333333334,null,11.933333333333334]
[8,0.13333333333333333,"IT Foundations","Documented","2012-03-10T11:17:00",null,"Member and Leader Work",4.166666666666667,null,4.166666666666667,null,"Enterprise Information Mgmt",11.8,null,11.8]
[18,0.3,"Enterprise Information Mgmt","Documented","2012-03-21T12:45:00",null,"Missionary Work",2.1666666666666665,null,2.1666666666666665,null,"IT Foundations",0.13333333333333333,null,0.13333333333333333]
[690,11.5,"Enterprise Information Mgmt","Documented","2012-03-25T07:00:00",null,"Supply Chain",2.0333333333333332,null,2.0333333333333332,null,"Apr",0.71666666666666667,7.25,7.9666666666666668]
[240,4,"IT Foundations","Undocumented","2012-04-11T05:00:00",null,"Grand Total",54.999999999999993,7.25,62.249999999999993,null,"IT Foundations",0.71666666666666667,7.25,7.9666666666666668]
[195,3.25,"IT Foundations","Undocumented","2012-04-11T05:00:00",null,null,null,null,null,null,"Grand Total",27.133333333333329,7.25,34.383333333333333]
[122,2.0333333333333332,"Supply Chain","Documented","2012-04-20T07:00:00"]
[130,2.1666666666666665,"Missionary Work","Documented","2012-04-20T08:30:00"]
[43,0.71666666666666667,"IT Foundations","Documented","2012-04-25T09:08:00"]
[]
[]
["Sum of P1 MTRS Hours","Column Labels"]
["Row Labels","End User Productivity","Enterprise Information Mgmt","IT Foundations","Grand Total"]
["Documented",4.5999999999999996,21.683333333333334,0.85,27.133333333333329]
["Feb",4.5999999999999996,9.8833333333333329,null,14.483333333333333,null,null,null,null,null,null,"Sum of P1 MTRS Hours","Column Labels"]
["Mar",null,11.8,0.13333333333333333,11.933333333333334,null,null,null,null,null,null,"Row Labels","End User Productivity","Enterprise Information Mgmt","Finance and Legal","IT Foundations","Member and Leader Work","Missionary Work","Supply Chain","Grand Total"]
["Apr",null,null,0.71666666666666667,0.71666666666666667,null,null,null,null,null,null,"Documented",4.5999999999999996,21.683333333333334,19.5,0.85,4.166666666666667,2.1666666666666665,2.0333333333333332,55.000000000000007]
["Undocumented",null,null,7.25,7.25,null,null,null,null,null,null,"Jan",null,null,null,null,1.35,null,null,1.35]
["Apr",null,null,7.25,7.25,null,null,null,null,null,null,"Feb",4.5999999999999996,9.8833333333333329,19.5,null,2.8166666666666669,null,null,36.800000000000004]
["Grand Total",4.5999999999999996,21.683333333333334,8.1,34.383333333333326,null,null,null,null,null,null,"Mar",null,11.8,null,0.13333333333333333,null,null,null,11.933333333333334]
[null,null,null,null,null,null,null,null,null,null,null,"Apr",null,null,null,0.71666666666666667,null,2.1666666666666665,2.0333333333333332,4.9166666666666661]
[null,null,null,null,null,null,null,null,null,null,null,"Undocumented",null,null,null,7.25,null,null,null,7.25]
[null,null,null,null,null,null,null,null,null,null,null,"Apr",null,null,null,7.25,null,null,null,7.25]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total",4.5999999999999996,21.683333333333334,19.5,8.1,4.166666666666667,2.1666666666666665,2.0333333333333332,62.250000000000007]
[]
[]
[]
[]
["Sum of P1 MTRS Hours","Column Labels"]
["Row Labels","End User Productivity","Enterprise Information Mgmt","Finance and Legal","IT Foundations","Member and Leader Work","Missionary Work","Supply Chain","Grand Total"]
["Documented",4.5999999999999996,21.683333333333334,19.5,0.85,4.166666666666667,2.1666666666666665,2.0333333333333332,54.999999999999993]
["Undocumented",null,null,null,7.25,null,null,null,7.25]
["Grand Total",4.5999999999999996,21.683333333333334,19.5,8.1,4.166666666666667,2.1666666666666665,2.0333333333333332,62.249999999999993]

{"sheet":"Sheet8","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}