{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Macros Required","Welcome","Input","Format Print","Scratch"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":137,"comments":1,"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":"Macros Required","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Macros Required - \"&title","v":"Macros Required - Shift Scheduler"}]
[]
[null," Macros must be enabled for this application to function."]
[]
[null,"Please refer to your spreadsheet Help for details on how to enable macros."]
[]
[null,"Suitability must be independently assessed and use indicates acceptance of any and all associated risk."]

{"sheet":"Welcome","index":1,"n_rows":107,"n_cols":3,"rows_kept":107,"cut":false,"hidden":false,"merged":[[22,1,22,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,15,2],[20,1,20,2],[21,1,21,2],[5,1,5,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"Shift Scheduler"]
[]
[null,"Build: 20220225 by bizpep.com"]
[]
[null,"Shift Scheduler will build a roster structure to your specifications, allocate staff automatically, and generate a printable roster, all at the click of a button. It is compact and user friendly allowing you to add staff and shifts (maximum 150) with ease. Default values for continuous shifts mean that the only shift data required is the start date/time and length for the first shift, everything else is automated."]
[]
[null,"To start use the sheet tabs to select the Input sheet."]
[null,"Input is in the blue cells. Non-input cells are protected to maintain formula integrity."]
[null,"help"]
[]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Current license subscriptions can be managed directly from your PayPal account.\",\"In evaluation mode functionality is restriced.\")","v":"In evaluation mode functionality is restriced."}]
[null,{"$f":"IF(Scratch!B55=TRUE,\"On renewal new License Details will be emailed. You can purchase at new license at:\",\"To fully enable this application please purchase a license at:\")","v":"To fully enable this application please purchase a license at:"}]
[null,"https://bizpep.com/shiftscheduler.html?display=license"]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Current license details fully enable your application\",\"License Details are sent by email, on reciept input license details to fully enable your application.\")","v":"License Details are sent by email, on reciept input license details to fully enable your application."}]
[]
[]
[null,"Application License Details:"]
[null,"Licensed Email Address:"]
[null,"License Code:"]
[null,"License Valid to Date:",{"$f":"IF(Scratch!B55=TRUE,Scratch!C55,\"Not Licensed, for Evaluation Only.\")","v":"Not Licensed, for Evaluation Only."}]
[]
[null,"Suitability must be independently assessed and use indicates acceptance of any and all associated risk."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Licensed to \"&Welcome!C11, Welcome!C13&\" In evaluation mode functionality is limited.\")","v":" In evaluation mode functionality is limited."}]
[]
[]
[null,{"$f":"IFERROR(AND(ISTEXT(Welcome!C18),LEN(Welcome!C18)>6),FALSE)","v":false}]
[null,{"$f":"IFERROR(AND(ISNUMBER(INT(Welcome!C19)),LEN(Welcome!C19)>8),FALSE)","v":false},{"$f":"IFERROR(Welcome!C19/Scratch!E57/E41,FALSE)","v":false}]
[]
[]
[]
[null,null,{"$f":"MID(Welcome!$C$18,B58,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B59,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B60,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B61,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B62,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B63,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B64,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B65,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B66,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B67,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B68,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B69,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B70,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B71,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B72,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B73,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B74,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B75,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B76,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B77,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B78,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B79,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B80,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B81,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B82,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B83,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B84,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B85,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B86,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B87,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B88,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B89,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B90,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B91,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B92,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B93,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B94,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B95,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B96,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B97,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B98,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B99,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B100,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B101,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B102,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B103,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B104,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B105,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B106,1)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"MID(Welcome!$C$18,B107,1)","v":{"$error":"#VALUE!"}}]

{"sheet":"Input","index":2,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,4,1,9],[2,4,3,9],[38,1,38,9],[39,1,39,9],[5,1,5,9],[37,1,37,9],[6,1,6,9],[13,3,13,6],[14,1,15,1],[9,1,9,2],[10,1,10,2],[11,1,11,2],[45,1,45,9],[46,1,46,9],[40,1,40,9],[41,1,41,9],[42,1,42,9],[43,1,43,9],[44,1,44,9]]}
[]
[null,null,null,null,"Build business with bizpeponline.com.  "]
[null,null,null,null,"Business support software and tools designed to your specifications. "]
[]
[]
[null,{"$f":"\"Input -\"&title","v":"Input -Shift Scheduler"}]
[null,"help"]
[null,"Blue cells require input, yellow cells contain formula that can be overwritten. Mouse over the red markers for additional information."]
[]
[null,"Staff Roster Period Limits",null,"Max Hours",999999]
[null,"Staff Shift Limits ",null,"Max Cont Hrs",999999,"Min Break Hrs ",0]
[null,"Days Worked in a Row",null,"Max Number",7,"Build Attempts",5]
[]
[null,null,"Next Initiation","Roster Title"]
[null,null,null,{"$f":"MID(D16,1,3) & \" \" & TEXT(D19,\"hh:mm\") &\"-\" &TEXT( D21,\"hh:mm\")","v":" 00:00-00:00"}," 00:00-00:00"," 00:00-00:00"," 00:00-00:00"," 00:00-00:00"]
[null,null,null,{"$f":"IF(D17=1,\"Sunday\",IF(D17=2,\"Monday\",IF(D17=3,\"Tuesday\",IF(D17=4,\"Wednesday\",IF(D17=5,\"Thursday\",IF(D17=6,\"Friday\",IF(D17=7,\"Saturday\",\"\")))))))","v":""},"","","",""]
[null,null,null,{"$f":"IF(D18,WEEKDAY(D18,1),0)","v":0},0,0,0,0]
[null,"Start Date",null,null,{"$f":"D20","v":"00:00:00"},{"$f":"E20","v":"00:00:00"},{"$f":"F20","v":"00:00:00"},{"$f":"G20","v":"00:00:00"}]
[null,"Start Time",null,null,{"$f":"D21","v":"00:00:00"},{"$f":"E21","v":"00:00:00"},{"$f":"F21","v":"00:00:00"},{"$f":"G21","v":"00:00:00"}]
[null,"End Date",null,{"$f":"INT((D22*HrCon)+D19+D18)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"End Time",null,{"$f":"IF(+D19+(D22*HrCon)=1,0,MOD(+D19+(D22*HrCon),1))","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Length Hrs",null,null,{"$f":"D22","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},{"$f":"G22","v":0}]
[null,"Shift Requirement",null,null,{"$f":"D23","v":0},{"$f":"E23","v":0},{"$f":"F23","v":0},{"$f":"G23","v":0},null,"Total Hours"]
[null,"Staff 1",null,null,null,null,null,null,null,{"$f":"MAX($D25:$I25)","v":0}]
[null,"Cumulative Hours Worked",null,{"$f":"IF(D24=\"Yes\",D$22+C25,C25)","v":0},0,0,0,0]
[null,"Continuous Hours Worked",null,{"$f":"IF(D24=\"Yes\",D$22+C26,IF(D$18+D$19<=C$20+C$21,IF(D$20+D$21<=C$20+C$21,C26,0),0))","v":0},0,0,0,0]
[null,"Earliest Start for Following Shifts",null,{"$f":"IF(D24<>\"YES\",IF(C26=0,C27,IF(C26<MaxCont,C27+MinBk*HrCon,C27)),IF(D26<MaxCont,D$20+D$21,D$20+D$21+MinBk*HrCon))","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Latest Finish for Preceding Shifts",null,{"$f":"IF(D24=\"YES\",(D$18+D$19)-MinBk*HrCon,IF(E24=\"YES\",IF(AND(D$18+D$19<E$18+E$19,C$18+C$19<D$18+D$19),IF(E28=E$18+E$19,E28-MinBk*HrCon,E28),E28),E28))","v":"1900-12-30"},{"$f":"IF(E24=\"YES\",(E$18+E$19)-MinBk*HrCon,IF(F24=\"YES\",IF(AND(E$18+E$19<F$18+F$19,D$18+D$19<E$18+E$19),IF(F28=F$18+F$19,F28-MinBk*HrCon,F28),F28),F28))","v":"1900-12-30"},{"$f":"IF(F24=\"YES\",(F$18+F$19)-MinBk*HrCon,IF(G24=\"YES\",IF(AND(F$18+F$19<G$18+G$19,E$18+E$19<F$18+F$19),IF(G28=G$18+G$19,G28-MinBk*HrCon,G28),G28),G28))","v":"1900-12-30"},{"$f":"IF(G24=\"YES\",(G$18+G$19)-MinBk*HrCon,IF(H24=\"YES\",IF(AND(G$18+G$19<H$18+H$19,F$18+F$19<G$18+G$19),IF(H28=H$18+H$19,H28-MinBk*HrCon,H28),H28),H28))","v":"1900-12-30"},{"$f":"IF(H24=\"YES\",IF(H26>=MaxCont,(H$18+H$19)-MinBk*HrCon,(H$18+H$19)),IF(I24=\"YES\",IF(AND(H$18+H$19<I$18+I$19,G$18+G$19<H$18+H$19),IF(I28=I$18+I$19,I28-MinBk*HrCon,I28),I28),I28))","v":"1900-12-30"},{"$f":"H$20 + H$21 + 365","v":"1900-12-30"}]
[null,"Preceding Days Worked in a Row",null,{"$f":"IF(D$17<>E$17,IF(D31=\"Set\",C29+1,0),C29)","v":0},0,0,0,{"$f":"IF(H$17<>I$17,IF(H31=\"Set\",G29+1,0),G29)","v":0}]
[null,"Following Days Worked in a Row",null,{"$f":"IF(D$17<>C$17,IF(D32=\"Set\",E30+1,0),E30)","v":0},0,0,0,{"$f":"IF(H$17<>G$17,IF(H32=\"Set\",I30+1,0),I30)","v":0}]
[null,"Preceding Days Worked Marker",null,{"$f":"IF(D24=\"Yes\",\"Set\",IF(D$17=C$17,IF(C31=\"Set\",\"Set\",\"Clear\"),\"Clear\"))","v":"Clear"},"Clear","Clear","Clear","Clear"]
[null,"Following Days Worked Marker",null,{"$f":"IF(D24=\"Yes\",\"Set\",IF(D$17=E$17,IF(E32=\"Set\",\"Set\",\"Clear\"),\"Clear\"))","v":"Clear"},"Clear","Clear","Clear",{"$f":"IF(H24=\"Yes\",\"Set\",IF(H$17=I$17,IF(I32=\"Set\",\"Set\",\"Clear\"),\"Clear\"))","v":"Clear"}]
[null,"Linked Days Worked in a Row",null,{"$f":"IF(D$16<>C$16,C29+E30,C33)","v":0},0,0,0,{"$f":"IF(H$16<>G$16,G29+I30,G33)","v":0}]
[]
[null,"Number Allocated",null,{"$f":"COUNTIF(D$24:D$34,\"YES\")","v":0},{"$f":"COUNTIF(E$24:E$34,\"YES\")","v":0},{"$f":"COUNTIF(F$24:F$34,\"YES\")","v":0},{"$f":"COUNTIF(G$24:G$34,\"YES\")","v":0},{"$f":"COUNTIF(H$24:H$34,\"YES\")","v":0},null,{"$f":"SUM(J$24:J34)","v":0}]
[null,"Variance",null,{"$f":"+D$35-D$23","v":0},{"$f":"+E$35-E$23","v":0},{"$f":"+F$35-F$23","v":0},{"$f":"+G$35-G$23","v":0},{"$f":"+H$35-H$23","v":0},null,{"$f":"SUM($D36:$I36)","v":0}]
[]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,4.1666666666666664E-2]
[]
[null,{"$f":"IF(B$23>B$35,IF(B63<MaxRow,IF($J54+B$22<=MaxHours,IF(A56+B$22<=MaxCont,IF(A57<=B$18+B$19,IF(C58>=B$20+B$21,\"YES\",\"NO\"),\"NO\"),\"NO\"),\"NO\"),\"NO\"),\"NO\")","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(B51=\"YES\",IF(B53>=MaxCont,(B$18+B$19)-MinBk*HrCon,(B$18+B$19)),IF(C51=\"YES\",IF(AND(B$18+B$19<C$18+C$19,A$18+A$19<B$18+B$19),IF(C55=C$18+C$19,C55-MinBk*HrCon,C55),C55),C55))","v":"00:00:00"}]
[null,{"$f":"IF(B$17<>C$17,IF(B58=\"Set\",A56+1,0),A56)","v":0}]
[null,{"$f":"IF(B$17<>A$17,IF(B59=\"Set\",C57+1,0),C57)","v":0}]
[null,{"$f":"IF(B50=\"Yes\",\"Set\",IF(B$17=C$17,IF(C58=\"Set\",\"Set\",\"Clear\"),\"Clear\"))","v":"Clear"}]
[null,{"$f":"IF(B$16<>A$16,A55+C56,A59)","v":0}]

{"sheet":"Format Print","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Roster Title"]
[]
[]
[]
[null,"Staff 1"]

{"sheet":"Scratch","index":4,"n_rows":107,"n_cols":10,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E42:E46)","v":345}]
[null,{"$f":"1","v":1},"s",{"$f":"IFERROR(CODE(C42),0)","v":115},{"$f":"B42*D42","v":115}]
[null,{"$f":"B42+1","v":2},"s",{"$f":"IFERROR(CODE(C43),0)","v":115},{"$f":"B43*D43","v":230}]
[null,3,null,0,0]
[null,4,null,0,0]
[null,5,null,0,0]
[]
[]
[]
[null," In evaluation mode functionality is limited."]
[]
[null,"Locked",500000]
[null,{"$f":"IFERROR(AND(ISTEXT(Welcome!C18),LEN(Welcome!C18)>6),FALSE)","v":false},null,"emall len >6"]
[null,{"$f":"IFERROR(AND(ISNUMBER(INT(Welcome!C19)),LEN(Welcome!C19)>8),FALSE)","v":false},{"$f":"IFERROR(Welcome!C19/Scratch!E57/E41,FALSE)","v":false},"code len>8","yyyymmdd=code/emailchsum/i"]
[null,{"$f":"IFERROR(AND(ISNUMBER(C54),LEN(C54)=8,TODAY()<C55+7),FALSE)","v":false},{"$f":"IFERROR(DATE(MID(C54,1,4),MID(C54,5,2),MID(C54,7,2)),FALSE)","v":false},null,"yyyymmdd len=8",null,"IF(ISNUMBER(C55),IF(C55>TODAY()+3650,2,IF(C55>TODAY()-2,1,0)),0)"]
[null,null,{"$f":"IF(ISNUMBER(C55),IF(C55>TODAY()+3650,2,IF(C55>TODAY()-2,1,0)),0)","v":0},"status",">today+36500days=2",null,null,null,null,{"$f":"I56*J57*E41","v":0}]
[null,null,null,null,{"$f":"SUM(E58:E107)","v":0},null,null,null,null,{"$f":"SUM(J58:J107)","v":0}]
[null,{"$f":"1","v":1},{"$f":"MID(Welcome!$C$18,B58,1)","v":""},{"$f":"IFERROR(CODE(C58),0)","v":0},{"$f":"B58*D58","v":0},null,{"$f":"1","v":1},{"$f":"MID($G$56,G58,1)","v":""},{"$f":"IFERROR(CODE(H58),0)","v":0},{"$f":"G58*I58","v":0}]
[null,{"$f":"B58+1","v":2},{"$f":"MID(Welcome!$C$18,B59,1)","v":""},0,0,null,{"$f":"G58+1","v":2},{"$f":"MID($G$56,G59,1)","v":""},0,0]
[null,3,{"$f":"MID(Welcome!$C$18,B60,1)","v":""},0,0,null,3,"",0,0]
[null,4,{"$f":"MID(Welcome!$C$18,B61,1)","v":""},0,0,null,4,"",0,0]
[null,5,{"$f":"MID(Welcome!$C$18,B62,1)","v":""},0,0,null,5,"",0,0]
[null,6,{"$f":"MID(Welcome!$C$18,B63,1)","v":""},0,0,null,6,"",0,0]
[null,7,{"$f":"MID(Welcome!$C$18,B64,1)","v":""},0,0,null,7,"",0,0]
[null,8,{"$f":"MID(Welcome!$C$18,B65,1)","v":""},0,0,null,8,"",0,0]
[null,9,{"$f":"MID(Welcome!$C$18,B66,1)","v":""},0,0,null,9,"",0,0]
[null,10,{"$f":"MID(Welcome!$C$18,B67,1)","v":""},0,0,null,10,"",0,0]
[null,11,{"$f":"MID(Welcome!$C$18,B68,1)","v":""},0,0,null,11,"",0,0]
[null,12,{"$f":"MID(Welcome!$C$18,B69,1)","v":""},0,0,null,12,"",0,0]
[null,13,{"$f":"MID(Welcome!$C$18,B70,1)","v":""},0,0,null,13,"",0,0]
[null,14,{"$f":"MID(Welcome!$C$18,B71,1)","v":""},0,0,null,14,"",0,0]
[null,15,{"$f":"MID(Welcome!$C$18,B72,1)","v":""},0,0,null,15,"",0,0]
[null,16,{"$f":"MID(Welcome!$C$18,B73,1)","v":""},0,0,null,16,"",0,0]
[null,17,{"$f":"MID(Welcome!$C$18,B74,1)","v":""},0,0,null,17,"",0,0]
[null,18,{"$f":"MID(Welcome!$C$18,B75,1)","v":""},0,0,null,18,"",0,0]
[null,19,{"$f":"MID(Welcome!$C$18,B76,1)","v":""},0,0,null,19,"",0,0]
[null,20,{"$f":"MID(Welcome!$C$18,B77,1)","v":""},0,0,null,20,"",0,0]
[null,21,{"$f":"MID(Welcome!$C$18,B78,1)","v":""},0,0,null,21,"",0,0]
[null,22,{"$f":"MID(Welcome!$C$18,B79,1)","v":""},0,0,null,22,"",0,0]
[null,23,{"$f":"MID(Welcome!$C$18,B80,1)","v":""},0,0,null,23,"",0,0]
[null,24,{"$f":"MID(Welcome!$C$18,B81,1)","v":""},0,0,null,24,"",0,0]
[null,25,{"$f":"MID(Welcome!$C$18,B82,1)","v":""},0,0,null,25,"",0,0]
[null,26,{"$f":"MID(Welcome!$C$18,B83,1)","v":""},0,0,null,26,"",0,0]
[null,27,{"$f":"MID(Welcome!$C$18,B84,1)","v":""},0,0,null,27,"",0,0]
[null,28,{"$f":"MID(Welcome!$C$18,B85,1)","v":""},0,0,null,28,"",0,0]
[null,29,{"$f":"MID(Welcome!$C$18,B86,1)","v":""},0,0,null,29,"",0,0]
[null,30,{"$f":"MID(Welcome!$C$18,B87,1)","v":""},0,0,null,30,"",0,0]
[null,31,{"$f":"MID(Welcome!$C$18,B88,1)","v":""},0,0,null,31,"",0,0]
[null,32,{"$f":"MID(Welcome!$C$18,B89,1)","v":""},0,0,null,32,"",0,0]
[null,33,{"$f":"MID(Welcome!$C$18,B90,1)","v":""},0,0,null,33,"",0,0]
[null,34,{"$f":"MID(Welcome!$C$18,B91,1)","v":""},0,0,null,34,"",0,0]
[null,35,{"$f":"MID(Welcome!$C$18,B92,1)","v":""},0,0,null,35,"",0,0]
[null,36,{"$f":"MID(Welcome!$C$18,B93,1)","v":""},0,0,null,36,"",0,0]
[null,37,{"$f":"MID(Welcome!$C$18,B94,1)","v":""},0,0,null,37,"",0,0]
[null,38,{"$f":"MID(Welcome!$C$18,B95,1)","v":""},0,0,null,38,"",0,0]
[null,39,{"$f":"MID(Welcome!$C$18,B96,1)","v":""},0,0,null,39,"",0,0]
[null,40,{"$f":"MID(Welcome!$C$18,B97,1)","v":""},0,0,null,40,"",0,0]
[null,41,{"$f":"MID(Welcome!$C$18,B98,1)","v":""},0,0,null,41,"",0,0]
[null,42,{"$f":"MID(Welcome!$C$18,B99,1)","v":""},0,0,null,42,"",0,0]
[null,43,{"$f":"MID(Welcome!$C$18,B100,1)","v":""},0,0,null,43,"",0,0]
[null,44,{"$f":"MID(Welcome!$C$18,B101,1)","v":""},0,0,null,44,"",0,0]
[null,45,{"$f":"MID(Welcome!$C$18,B102,1)","v":""},0,0,null,45,"",0,0]
[null,46,{"$f":"MID(Welcome!$C$18,B103,1)","v":""},0,0,null,46,"",0,0]
[null,47,{"$f":"MID(Welcome!$C$18,B104,1)","v":""},0,0,null,47,"",0,0]
[null,48,{"$f":"MID(Welcome!$C$18,B105,1)","v":""},0,0,null,48,"",0,0]
[null,49,{"$f":"MID(Welcome!$C$18,B106,1)","v":""},0,0,null,49,"",0,0]
[null,50,{"$f":"MID(Welcome!$C$18,B107,1)","v":""},0,0,null,50,"",0,0]