{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions for Judges","SCORING","RUBRIC","Scoring Supplemental Info.","TeamList"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":13,"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":"Instructions for Judges","index":0,"n_rows":162,"n_cols":3,"rows_kept":162,"cut":false,"hidden":false,"merged":[[161,1,161,24],[0,1,0,25],[138,2,138,24],[144,2,144,24],[149,2,149,24],[151,2,151,24],[155,2,155,24]]}
[null,"Instructions for the Judges"]
[]
[]
[null,"Before Team Presentations - Template Setup:"]
[null,"1.) Please fill in your name and competition class (drop down list) you are judging in cells B2 & B3"]
[null,"2. ) Save a copy of this file with your name or initials on it via Save As into the dropbox folder or a folder of your choosing"]
[null,"- This will be the main file you work out of "]
[null,"- Make sure to save as macro enabled workbook"]
[null,"- You can leave team number blank for now"]
[null,"- This essentially creates a template for you as you judge each team.  The \"Finish & Save\" button will reset the sheet back to this state each time."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.) If you would like for the team number list to only show teams you are judging complete step 4.  If not you are ready to start listening to the team's presentations "]
[null,"a.) It will default to list of all teams competing if you skip step 4"]
[]
[null,"4.) Optional"]
[null,"a.) Go to the TeamList Tab"]
[null,"b.) In column J enter the team numbers 1 after the other in the format shown in the instructions (EX # or RNG #) starting in cell J2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scoring the Presentations:"]
[]
[null,"1.) Pick the team number from the drop down.  If you didn't add the filter in step 4 above, the list will show all teams for that class similar to picture below."]
[null,"It will automatically fill in the Team Name to the right"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.) Enter scores in column D and comments for individual questions can be entered in column J. Weighting is automatically calculated for you."]
[null,"It will round any score higher than the rubric scores to the highest rubric score."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. ) There are two boxes at the bottom for general comments as well."]
[null,"4.) There are also several other buttons here for your use:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Save File:","This one and the one at the top are there for you to save as you go so you don't lose your work.  It will save a file in the same directory as this file with your name and the team number in the filename "]
[null,null,"(your main template, save as from step #2 in setup phase)."]
[null,null,"Example: 2018_productPresentation_EX1_Ebaker.xlsm"]
[null,null,"It does not run any of the other checks built into this file other than making sure cells B2,B3,and B4 are filled out as it needs that info to save."]
[]
[null,"Finish & Save:","Press this one when you are finished and ready to move to the next team."]
[null,null,"As long as it doesn't find any errors in scores above it will save the file with your name and the team number in the filename and then clear the team number from cell B4 as well as all the scores and comments from the template."]
[null,null,"Don't worry you didn't just delete your scores as long as it said file save successful (check the folder)."]
[null,null,"It also runs the checks for missing scores, incorrect formats on scores, and that you filled out cells B2, B3, and B4."]
[null,null,"It does not run the spell checker."]
[]
[null,"For both of the save buttons:","If the file exists it will prompt you to overwrite.  If you click overwrite, it saves the last iterations with \"Backup_\" in front of the filename just in case.  Each time you overwrite the backup gets overwritten to 1 version prior to the main one."]
[]
[null,"Spell Check:","The normal spell checker won't run with the cells locked so this button will allow you to run the spell check on the comment cells.  (It also won't make you go through spell checking all the questions and headers.)"]
[null,"Check for missing scores:","It does exactly what it says; it also checks to make sure you put a number in for each score and that the score didn't get entered as text. "]
[null,null,"After fixing the scores click the button again to remove the red coloring."]
[null,null,"The Finish & Save button also runs through this macro as well."]
[null,"Remove All Red Backgrounds:","If the missing scores macro finds a missing score or a non-numerical entry in column D (other than the comments at the bottom) it makes the cell red.  If you wanted to manually remove the red, this button resets the cells back to the default color."]
[null,null,"It does not fix the score for you."]
[]
[]
[null,"Note:"]
[null,"It is highly suggested you use the macros within this file to help the scorekeepers out with data validation and to make sure you don't accidentally save over anyone else's file."]
[null,"The normal save/save as methods in excel still work if you want to use those.  Just make sure you save each file with the team number and judge's name or initials and that you did not miss any scores and you reset team number for each team"]

{"sheet":"SCORING","index":1,"n_rows":91,"n_cols":10,"rows_kept":91,"cut":false,"hidden":false,"merged":[[91,0,95,9],[96,0,100,9],[11,1,12,1]]}
["Лист оценки технической документации 2019 MATE Russia-Far East ROV Competition Navigator"]
["ФИО судьи:  "]
["Класс","Navigator"]
["Название команды/организации"]
["Категория","Критерий","Требования",null,"Очки","Макс очки","%","Вес","Баллы за категорию","Комментарии"]
[null,null,null,null,null,"by category"]
["Общая",null,null,null,{"$f":"SUM(E9:E26)","v":0},{"$f":"RUBRIC_SCALE*14","v":56},{"$f":"E7/F7","v":0},0.2,{"$f":"SCORE_SCALE*H7*G7","v":0}]
[null,"Общие требования"]
[null,"Требования выполняются на 100% = 4 очка\nТребования выполняются на 75% = 3 очка\nТребования выполняются на 50% = 2 очка\nТребования выполняются на 25% = 1 очко","Не более 10 стр, размер шрифта не менее 12 пт (только  Times New Roman, Arial, Calibri), все измерения в системе СИ (кроме тех, которые традиционно используют другие системы, например дюймовые трубы ПВХ США)",null,{"$f":"IF(ABS(D9)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D9))","v":0}]
[null,"Используйте эту шкалу далее","На титульной странице есть название компании, название и местоположение организации (город, край), члены команды и их роли, наставники. ",null,{"$f":"IF(ABS(D10)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D10))","v":0}]
[null,null,"Аннотация обеспечивает ясное и обобщенное описание работы. Размер аннотации до 150 слов.",null,{"$f":"IF(ABS(D11)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D11))","v":0}]
[null,"Использование изображений"]
[null,null,"Есть фото собранного аппарата",null,{"$f":"IF(ABS(D13)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D13))","v":0}]
[null,null,"Рациональное исопльзование фотографий, диаграмм для описания аппапарата и процесса его разработки.",null,{"$f":"IF(ABS(D14)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D14))","v":0}]
[null,null,"Имеется хотя бы один хорошо выполненный чертеж или эскиз",null,{"$f":"IF(ABS(D15)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D15))","v":0}]
[null,null,"На диаграммах и рисунках используется разумная маркировка, подписи, размеры и др.",null,{"$f":"IF(ABS(D16)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D16))","v":0}]
[null,"Понимание"]
[null,null,"Демонстрируют четкое понимание технических и научных концепций и их взаимосвязи с проектированием и использованием ТНПА",null,{"$f":"IF(ABS(D18)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D18))","v":0}]
[null,null,"В документе четко описывается процесс проектирования и изготовления ТНПА и его частей",null,{"$f":"IF(ABS(D19)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D19))","v":0}]
[null,"Дизайн документа"]
[null,null,"Тщательное внимание к грамматике и орфографии",null,{"$f":"IF(ABS(D21)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D21))","v":0}]
[null,null,"Документ тщательно подготовлен, с уделением особого внимания способам донесения информации и эстетической стороны",null,{"$f":"IF(ABS(D22)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D22))","v":0}]
[null,null,"Документ отображает профессионализм компании",null,{"$f":"IF(ABS(D23)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D23))","v":0}]
[null,"Благодарности и ссылки"]
[null,null,"Документ содержит правильно документированный список ссылок: книги, журналы, веб-сайты и т. д., используемых в качестве источников. Приведеные компании, физические лица, которые предоставили средства, оборудование и или техническую/моральную поддержку.",null,{"$f":"IF(ABS(D25)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D25))","v":0}]
[null,null,"Документ отражает адекватное признание вкладов компаний и частных лиц, которые предоставили команде средства, оборудование и/или другую поддержку.",null,{"$f":"IF(ABS(D26)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D26))","v":0}]
["Командная работа",null,null,null,{"$f":"SUM(E29:E33)","v":0},{"$f":"RUBRIC_SCALE*4","v":16},{"$f":"E27/F27","v":0},0.1,{"$f":"SCORE_SCALE*H27*G27","v":0}]
[null,"Усилия компания"]
[null,null,"Документ наглядно демонстрирует, что ТНПА и документ были сделаны  усилиями компании, а не наставниками или профессионалами",null,{"$f":"IF(ABS(D29)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D29))","v":0}]
[null,"Проектное управление"]
[null,null,"Команда разработала и поддерживала график разработки ТНПА",null,{"$f":"IF(ABS(D31)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D31))","v":0}]
[null,null,"Описывает используемые процессы планирования и организации работы",null,{"$f":"IF(ABS(D32)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D32))","v":0}]
[null,null,"Описывает способы управления ресурсами, процессами и протоколами для достижения целей проекта и решения повседневных операционных задач и проблем",null,{"$f":"IF(ABS(D33)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D33))","v":0}]
["Обоснование разработки",null,null,null,{"$f":"SUM(E36:E49)","v":0},{"$f":"RUBRIC_SCALE*10","v":40},{"$f":"E34/F34","v":0},0.3,{"$f":"SCORE_SCALE*H34*G34","v":0}]
[null,"Наполнение"]
[null,null,"Логично описывает поэтапный процесс планирования и проектирования.",null,{"$f":"IF(ABS(D36)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D36))","v":0}]
[null,null,"Описывает, как в процессе проектирования идеи создавались, оценивались и выбирались",null,{"$f":"IF(ABS(D37)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D37))","v":0}]
[null,null,"Обсуждается наука и/или техника/технологии, лежащие в основе решения задач",null,{"$f":"IF(ABS(D38)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D38))","v":0}]
[null,null,"Предоставляет четкое описание и разумное обоснование выбора решений, связанных со стоимостью, размером и весом.",null,{"$f":"IF(ABS(D39)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D39))","v":0}]
[null,"Понимание"]
[null,null,"Демонстрируют понимание научную и промышленную составляющую миссии",null,{"$f":"IF(ABS(D41)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D41))","v":0}]
[null,null,"Приводят четкое описание и разумное обоснование выбора вариантов для выполнения задач миссии",null,{"$f":"IF(ABS(D42)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D42))","v":0}]
[null,"Свое против покупного, повторно используемое против нового"]
[null,"Обоснование"]
[null,null,"Процесс принятия решения об использовании новых или повторно используемых компонентов четко сформулирован и разумно обоснован",null,{"$f":"IF(ABS(D45)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D45))","v":0}]
[null,null,"Процесс принятия решения об использовании собственных или коммерческих компонентов четко сформулирован и разумно обоснован",null,{"$f":"IF(ABS(D46)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D46))","v":0}]
[null,"Понимание"]
[null,null,"Продемонстрировано полное понимание принципов работы новых или повторно используемых компонентов",null,{"$f":"IF(ABS(D48)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D48))","v":0}]
[null,null,"Продемонстрировано глубокое понимание принципов работы собственных или коммерческих компонентов",null,{"$f":"IF(ABS(D49)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D49))","v":0}]
["Электрическая схема",null,null,null,{"$f":"SUM(E52:E53)","v":0},{"$f":"RUBRIC_SCALE*2","v":8},{"$f":"E50/F50","v":0},0.05,{"$f":"SCORE_SCALE*H50*G50","v":0}]
[null,"System Integration Diagrams (электрическая схема)"]
[null,null,"Сделана с использование  средст CAD, разделяет поверхностное оборудование и сам ТНПА, включает предохранитель выключатель и показывает его местоположение, а также использует электрические, гидравлические и/или пневматические символы ANSI, NEMA или IEC",null,{"$f":"IF(ABS(D52)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D52))","v":0}]
[null,null,"SID имеет соответствующий уровень детализации: это системный уровень схема подключения (не схема уровня компонентов)",null,{"$f":"IF(ABS(D53)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D53))","v":0}]
["Безопасность",null,null,null,{"$f":"SUM(E56:E59)","v":0},{"$f":"RUBRIC_SCALE*3","v":12},{"$f":"E54/F54","v":0},0.1,{"$f":"SCORE_SCALE*H54*G54","v":0}]
[null,"Наполнение"]
[null,null,"Описывает особенности (features) и философию безопасности",null,{"$f":"IF(ABS(D56)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D56))","v":0}]
[null,null,"Описывает, как аппарат был разработан, чтобы соответствовать требованиям безопасности",null,{"$f":"IF(ABS(D57)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D57))","v":0}]
[null,"Процедуры"]
[null,null,"Описывает шаги для выявления и устранения проблем безопасности",null,{"$f":"IF(ABS(D59)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D59))","v":0}]
["Критический анализ",null,null,null,{"$f":"SUM(E62:E70)","v":0},{"$f":"RUBRIC_SCALE*7","v":28},{"$f":"E60/F60","v":0},0.1,{"$f":"SCORE_SCALE*H60*G60","v":0}]
[null,"Тестирование и решение тех проблем"]
[null,null,"Описывает как собранный аппарат тестировался",null,{"$f":"IF(ABS(D62)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D62))","v":0}]
[null,null,"Описывает стратегии и методы устранения неполадок",null,{"$f":"IF(ABS(D63)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D63))","v":0}]
[null,"Вызовы/проблемы"]
[null,null,"Описывает, по крайней мере, одну существенную техническую проблему, и процесс ее решения",null,{"$f":"IF(ABS(D65)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D65))","v":0}]
[null,null,"Описывает использование прототипирования и тестирования для оценки вариантов при разрботке",null,{"$f":"IF(ABS(D66)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D66))","v":0}]
[null,"Усвоенные уроки"]
[null,null,"Описывает усвоенные технические уроки",null,{"$f":"IF(ABS(D68)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D68))","v":0}]
[null,null,"Описывает усвоенные межличностные и управленческие уроки",null,{"$f":"IF(ABS(D69)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D69))","v":0}]
[null,null,"Описывает развитие навыков",null,{"$f":"IF(ABS(D70)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D70))","v":0}]
["Будущие улучшения",null,null,null,{"$f":"SUM(E73)","v":0},{"$f":"RUBRIC_SCALE*1","v":4},{"$f":"E71/F71","v":0},0.05,{"$f":"SCORE_SCALE*H71*G71","v":0}]
[null,"Рефлексия"]
[null,null,"Обеспечивает продуманное и логичное обсуждение, по крайней мере, одного потенциального усовершенствования ТНПА, процесса разработки или управления проектом",null,{"$f":"IF(ABS(D73)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D73))","v":0}]
["Учет",null,null,null,{"$f":"SUM(E76:E78)","v":0},{"$f":"RUBRIC_SCALE*3","v":12},{"$f":"E74/F74","v":0},0.1,{"$f":"SCORE_SCALE*H74*G74","v":0}]
[null,"Бюджет"]
[null,null,"Тщательное и точное описание бюджетного планирования",null,{"$f":"IF(ABS(D76)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D76))","v":0}]
[null,null,"Четкое разделение между купленными, повторно использованными и пожертвованными товарами (компонентами)",null,{"$f":"IF(ABS(D77)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D77))","v":0}]
[null,null,"Все источники дохода указаны и произведена справедливая оценка  рыночной стоимости пожертвований (предметов, услуг и времени)",null,{"$f":"IF(ABS(D78)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D78))","v":0}]
[]
[null,null,null,null,{"$f":"SUM(E7:E78)/2","v":0},{"$f":"SUM(F7:F78)","v":176},null,{"$f":"SUM(H7:H78)","v":1.0000000000000002},{"$f":"SUM(I7:I78)","v":0},"Base Score"]
[null,null,null,null,"Raw Score","Max Points\n(cat)",null,"Total %\n(check:100)"]
[null,null,null,null,null,null,null,"Weight"]
["Дололнительные очки",null,null,"0-4 pts\neach",{"$f":"SUM(E84:E85)","v":0},{"$f":"RUBRIC_SCALE*2","v":8},null,1,{"$f":"E83*H83","v":0},"Discretionary points"]
[null,null,"В документе описывается исключительный дизайн аппарата, датчиков, полезной нагрузки, программного обеспечения или других функций",null,{"$f":"IF(ABS(D84)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D84))","v":0}]
[null,null,"Документы описывают значительные усилия по проектированию и изготовлению каждого компонента ТНПА",null,{"$f":"IF(ABS(D85)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D85))","v":0}]
["Штрафные очки",null,null,"0-4 pts\neach",{"$f":"-1*ABS(SUM(E87:E88))","v":0},{"$f":"RUBRIC_SCALE*2","v":8},null,1,{"$f":"E86*H86","v":0},"Deduction points"]
[null,null,"Имеются доказательства того, что работа выполнялась наставниками, родителями или другими людьми, не являющимися членами команды",null,{"$f":"IF(ABS(D87)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D87))","v":0}]
[null,null,"Значительное злоупотребление коммерческими или повторно используемыми компонентами без достаточного обоснования",null,{"$f":"IF(ABS(D88)>RUBRIC_SCALE,RUBRIC_SCALE,ABS(D88))","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I80:I88)","v":0},"Final Score"]
["Other Comments"]

{"sheet":"RUBRIC","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,5,4,5],[9,5,11,5]]}
["Scoring Rubric (applies to all score Items)","Outcome","Criteria","Score",null,"Discretionary Points Rubric ","Degree","Points"]
[null,"Missing","Not included, can’t evaluate",0,null,"Criteria:","None",0]
[null,"Needs work","Effort made, meets some key requirements. Understanding or treatment of key requirements needs more depth",1,null," - Novelty\n - Depth of Understanding\n - Depth of Analysis\n - Effectiveness (functions as intended)\n - Quality of Implementation","Minor",1]
[null,"Partially meets requirement","Response demonstrates understanding and addresses most key requirements",2,null,null,"Fair",2]
[null,"Meets requirement","Response demonstrates thorough understanding and addresses all key requirements",3,null,null,"Good",3]
[null,"Exceeds requirement","Response extends beyond key requirements, demonstrating exceptional depth and breadth of understanding",4,null,null,"Extraordinary",4]
[]
[null,null,null,null,null,"Deductions Rubric ","Degree","Deduction"]
[null,null,null,null,null,"Criteria:","None",0]
[null,null,null,null,null,"  - Extent to which team relied on outside help, existing work and/or purchased components and services","Minor",1]
[null,null,null,null,null,null,"Fair",2]
[null,null,null,null,null,null,"Medium",3]
[null,null,null,null,null,null,"Extreme",4]
["SCORE_SCALE",50]
["RUBRIC_SCALE",4]

{"sheet":"Scoring Supplemental Info.","index":3,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,1,2,3],[7,1,7,3],[10,1,10,3],[12,1,12,3],[51,1,51,3]]}
[null,"Technical Report Rubric Supplemental Information"]
[]
[null,"PHOTOGRAPH OF YOUR COMPLETED ROV"]
[null,"In your technical documentation you must include at least one photo(s) of your completed, assembled vehicle, in addition to any photos of individual systems and/or payload.   "]
[null,"You are permitted to make modifications that may change the look of your vehicle between the time you submit your report and the competition."]
[null,"NOTE:  Reports will not be re-evaluated and rescored for any changes to your vehicle from the time that you submit your documentation and the competition. "]
[]
[null,"SID"]
[null,"See the Design and Building Specifications section of the competition manual for guidance on creating your system interconnetion diagram (SID).  "]
[]
[null,"ACCOUNTING"]
[]
[null,"Budget"]
[null,"At the beginning of the project, companies should establish a budget.  "]
[null,"A budget is different than a project costing sheet (see the next bullet) in that it is a projection of the cost of the project."]
[null,"Companies should create categories and realistically estimate what they think that they will spend in each."]
[null,"If well-thought through, the project costing will align with the budget (i.e., the amount budgeted for a certain category will be the actual amount spent!)."]
[null,"The budget can be included as an appendix."]
[null,"Budgets typically don't provide estimates for every part, either just the overall categories or the categories and larger purchases."]
[null,"How the budget is split up will be different for each company, though it is suggested that the company goes further than just a budget of parts and travel (for example, break it up into the overall components, chassis, electrical, travel, etc.)"]
[null,"Including items being re-used in the budget can be helpful to figure out how much the team estimates it will need to raise funds for."]
[]
[null,"Example Budget:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project costing"]
[null,"Project costing is an accounting of your income, donations, and expenditures."]
[null,"Items must be listed as one of the following:  purchased, re-used, parts donated, or cash donated."]
[null,"For re-used or donated items, report the item’s current market value and note the source or organization that made the donation."]
[]
[]
[null,"Example Project Costing:"]

{"sheet":"TeamList","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,11,11,11]]}
["Team Number","Team Name",null,"Team Number","Team Name",null,"Competition Class",null,null,"Judge Assignment"]
["NAV 1","Arab Academy for Science and Technology Invictus",null,null,"not used - do not delete",null,"Navigator",null,null,null,null,"Instructions:"]
["NAV 2","Garrett College Project Kraken",null,null,null,null,null,null,null,null,null,"To filter based off assignment enter team numbers 1 per cell in the format NAV space #\n\nTable will automatically grow based off number of cells below heading (don't skip a row)",null,null,"DO NOT DELETE"]
["NAV 3","The Center for Robotics Development RC ROV",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(TeamList!$J$2:$J$2)=0,CompetitionClass,\"JudgeFilter\")","v":"Navigator"}]
["NAV 4","Technologico Monterrey TecXotic"]
["NAV 5","Norwegian University Science and Tech Vortex NTNU"]
["NAV 6","Jesuit High School Robotics"]
["NAV 7","Hong Kong University of Science and Technology EPOXSEA"]
["NAV 8","University of Sheffield Avalon"]
["NAV 9","Memorial University of Newfoundland Eastern Edge Robotics"]
["NAV 10","Long Beach City College VX Industries"]
["NAV 11","Purdue University IEEE"]
["NAV 12","Effat University Zoom Engineers"]
["NAV 13","SVKMs NMIMS Team Screwdriver"]
["NAV 14","Faculty of Engineering Alexandria Univeristy Vortex"]
["NAV 15","Clatsop Community College Lazarus"]
["NAV 16","Istanbul Technical University"]
["NAV 17","Copiah Lincoln Community College SURE"]
["NAV 18","Bauman Moscow Technical University Hydronautics"]
["NAV 19","Sea Tech 4H Club Daedalus"]
["NAV 20","Northern Illinois University NIU Robotics"]
["NAV 21","Highway 68 ROV Club Sea Sweepers"]
["NAV 22","Dalhousie University Tigersharks"]
["NAV 23","Faculty of Engineering Alexandria University TORPEDO"]
["NAV 24","Milwaukee School of Engineering MSEO ROV"]
["NAV 25","University of Stavanger UiS Subsea"]