{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["交通渋滞シミュレーション"],"not_rendered":{"charts":1,"images":0,"macros":1,"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":"交通渋滞シミュレーション","index":0,"n_rows":182,"n_cols":21,"rows_kept":182,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,15,0,16],[7,15,7,16],[0,19,0,20],[0,18,1,18],[7,14,8,14],[1,14,2,14],[0,1,0,6],[0,7,0,12]]}
["時間","国道",null,null,null,null,null,"県道",null,null,null,null,null,null,null,"国道",null,null,"回数","最大渋滞台数"]
[null,"信号","停車","到着","合計","通過","残留","信号","停車","到着","合計","通過","残留",null,"信号時間","青","赤",null,null,"国道","県道"]
[10,"青",0,{"$f":"RANDBETWEEN(8,12)","v":10},{"$f":"SUM(C3:D3)","v":10},{"$f":"IF(B3=\"赤\",0,IF(E3>20,20,E3))","v":10},{"$f":"E3-F3","v":0},"赤",0,{"$f":"RANDBETWEEN(3,4)","v":3},{"$f":"SUM(I3:J3)","v":3},{"$f":"IF(H3=\"赤\",0,IF(K3>10,10,K3))","v":0},{"$f":"K3-L3","v":3},null,null,60,30,null,1,35,66]
[20,"青",{"$f":"G3","v":0},12,{"$f":"SUM(C4:D4)","v":12},12,{"$f":"E4-F4","v":0},"赤",{"$f":"M3","v":3},{"$f":"RANDBETWEEN(3,4)","v":4},{"$f":"SUM(I4:J4)","v":7},{"$f":"IF(H4=\"赤\",0,IF(K4>10,10,K4))","v":0},{"$f":"K4-L4","v":7},null,null,null,null,null,2,35,56]
[30,"青",{"$f":"G4","v":0},10,10,10,0,"赤",{"$f":"M4","v":7},3,10,0,10,null,null,null,null,null,3,33,54]
[40,"青",0,8,8,8,0,"赤",10,4,14,0,14,null,null,null,null,null,4,35,54]
[50,"青",0,10,10,10,0,"赤",14,4,18,0,18,null,null,null,null,null,5,33,49]
[60,"青",0,9,9,9,0,"赤",18,4,22,0,22,null,null,"最大渋滞台数",null,null,6,35,51]
[70,"赤",0,11,11,0,11,"青",22,4,26,10,16,null,null,"国道","県道",null,7,35,49]
[80,"赤",11,8,19,0,19,"青",16,4,20,10,10,null,"1回",{"$f":"MAX(G3:G182)","v":34},{"$f":"MAX(M3:M182)","v":58},null,8,35,51]
[90,"赤",19,10,29,0,29,"青",10,3,13,10,3,null,"100回平均",{"$f":"AVERAGE(T3:T102)","v":34.42},{"$f":"AVERAGE(U3:U102)","v":49.42},null,9,34,42]
[100,"青",29,12,41,{"$f":"IF(B12=\"赤\",0,IF(E12>20,20,E12))","v":20},{"$f":"E12-F12","v":21},"赤",3,3,6,0,6,null,null,null,null,null,10,34,52]
[110,"青",21,10,31,{"$f":"IF(B13=\"赤\",0,IF(E13>20,20,E13))","v":20},11,"赤",6,4,10,0,10,null,null,null,null,null,11,32,58]
[120,"青",11,8,19,19,0,"赤",10,4,14,0,14,null,null,null,null,null,12,34,39]
[130,"青",0,10,10,10,0,"赤",14,3,17,0,17,null,null,null,null,null,13,34,46]
[140,"青",0,9,9,9,0,"赤",17,3,20,0,20,null,null,null,null,null,14,36,48]
[150,"青",0,9,9,9,0,"赤",20,3,23,0,23,null,null,null,null,null,15,35,46]
[160,"赤",0,10,10,0,10,"青",23,4,27,10,17,null,null,null,null,null,16,35,58]
[170,"赤",10,9,19,0,19,"青",17,3,20,10,10,null,null,null,null,null,17,35,46]
[180,"赤",19,10,29,0,29,"青",10,4,14,10,4,null,null,null,null,null,18,35,47]
[190,"青",29,12,41,20,21,"赤",4,4,8,0,8,null,null,null,null,null,19,36,50]
[200,"青",21,10,31,20,11,"赤",8,4,12,0,12,null,null,null,null,null,20,34,38]
[210,"青",11,9,20,20,0,"赤",12,3,15,0,15,null,null,null,null,null,21,35,47]
[220,"青",0,9,9,9,0,"赤",15,4,19,0,19,null,null,null,null,null,22,34,53]
[230,"青",0,10,10,10,0,"赤",19,3,22,0,22,null,null,null,null,null,23,31,62]
[240,"青",0,9,9,9,0,"赤",22,3,25,0,25,null,null,null,null,null,24,36,47]
[250,"赤",0,12,12,0,12,"青",25,4,29,10,19,null,null,null,null,null,25,34,50]
[260,"赤",12,10,22,0,22,"青",19,4,23,10,13,null,null,null,null,null,26,33,47]
[270,"赤",22,12,34,0,34,"青",13,4,17,10,7,null,null,null,null,null,27,36,42]
[280,"青",34,9,43,20,23,"赤",7,3,10,0,10,null,null,null,null,null,28,35,48]
[290,"青",23,11,34,20,14,"赤",10,4,14,0,14,null,null,null,null,null,29,36,40]
[300,"青",14,11,25,20,5,"赤",14,4,18,0,18,null,null,null,null,null,30,34,52]
[310,"青",5,12,17,17,0,"赤",18,3,21,0,21,null,null,null,null,null,31,34,56]
[320,"青",0,8,8,8,0,"赤",21,4,25,0,25,null,null,null,null,null,32,35,47]
[330,"青",0,8,8,8,0,"赤",25,3,28,0,28,null,null,null,null,null,33,34,36]
[340,"赤",0,12,12,0,12,"青",28,3,31,10,21,null,null,null,null,null,34,32,43]
[350,"赤",12,9,21,0,21,"青",21,3,24,10,14,null,null,null,null,null,35,33,57]
[360,"赤",21,9,30,0,30,"青",14,4,18,10,8,null,null,null,null,null,36,35,50]
[370,"青",30,12,42,20,22,"赤",8,3,11,0,11,null,null,null,null,null,37,34,39]
[380,"青",22,8,30,20,10,"赤",11,4,15,0,15,null,null,null,null,null,38,36,48]
[390,"青",10,10,20,20,0,"赤",15,3,18,0,18,null,null,null,null,null,39,35,53]
[400,"青",0,10,10,10,0,"赤",18,3,21,0,21,null,null,null,null,null,40,34,60]
[410,"青",0,12,12,12,0,"赤",21,3,24,0,24,null,null,null,null,null,41,33,57]
[420,"青",0,10,10,10,0,"赤",24,4,28,0,28,null,null,null,null,null,42,35,47]
[430,"赤",0,11,11,0,11,"青",28,4,32,10,22,null,null,null,null,null,43,36,57]
[440,"赤",11,8,19,0,19,"青",22,3,25,10,15,null,null,null,null,null,44,35,54]
[450,"赤",19,12,31,0,31,"青",15,4,19,10,9,null,null,null,null,null,45,34,43]
[460,"青",31,8,39,20,19,"赤",9,4,13,0,13,null,null,null,null,null,46,34,49]
[470,"青",19,10,29,20,9,"赤",13,3,16,0,16,null,null,null,null,null,47,34,56]
[480,"青",9,10,19,19,0,"赤",16,4,20,0,20,null,null,null,null,null,48,36,38]
[490,"青",0,12,12,12,0,"赤",20,3,23,0,23,null,null,null,null,null,49,36,51]
[500,"青",0,12,12,12,0,"赤",23,4,27,0,27,null,null,null,null,null,50,34,48]
[510,"青",0,8,8,8,0,"赤",27,4,31,0,31,null,null,null,null,null,51,36,45]
[520,"赤",0,8,8,0,8,"青",31,4,35,10,25,null,null,null,null,null,52,36,40]
[530,"赤",8,8,16,0,16,"青",25,3,28,10,18,null,null,null,null,null,53,36,50]
[540,"赤",16,10,26,0,26,"青",18,4,22,10,12,null,null,null,null,null,54,35,44]
[550,"青",26,11,37,20,17,"赤",12,4,16,0,16,null,null,null,null,null,55,34,60]
[560,"青",17,11,28,20,8,"赤",16,3,19,0,19,null,null,null,null,null,56,34,40]
[570,"青",8,8,16,16,0,"赤",19,3,22,0,22,null,null,null,null,null,57,34,55]
[580,"青",0,12,12,12,0,"赤",22,4,26,0,26,null,null,null,null,null,58,36,53]
[590,"青",0,8,8,8,0,"赤",26,4,30,0,30,null,null,null,null,null,59,34,47]
[600,"青",0,10,10,10,0,"赤",30,4,34,0,34,null,null,null,null,null,60,34,48]
[610,"赤",0,10,10,0,10,"青",34,3,37,10,27,null,null,null,null,null,61,33,50]
[620,"赤",10,9,19,0,19,"青",27,3,30,10,20,null,null,null,null,null,62,35,33]
[630,"赤",19,11,30,0,30,"青",20,3,23,10,13,null,null,null,null,null,63,33,44]
[640,"青",30,8,38,20,18,"赤",13,4,17,0,17,null,null,null,null,null,64,33,58]
[650,"青",18,{"$f":"RANDBETWEEN(8,12)","v":9},27,20,7,"赤",17,3,20,0,20,null,null,null,null,null,65,35,33]
[660,"青",7,8,{"$f":"SUM(C68:D68)","v":15},15,{"$f":"E68-F68","v":0},"赤",20,{"$f":"RANDBETWEEN(3,4)","v":3},{"$f":"SUM(I68:J68)","v":23},{"$f":"IF(H68=\"赤\",0,IF(K68>10,10,K68))","v":0},{"$f":"K68-L68","v":23},null,null,null,null,null,66,33,54]
[670,"青",{"$f":"G68","v":0},8,8,8,0,"赤",{"$f":"M68","v":23},3,26,0,26,null,null,null,null,null,67,34,49]
[680,"青",0,12,12,12,0,"赤",26,4,30,0,30,null,null,null,null,null,68,34,47]
[690,"青",0,12,12,12,0,"赤",30,3,33,0,33,null,null,null,null,null,69,35,52]
[700,"赤",0,8,8,0,8,"青",33,4,37,10,27,null,null,null,null,null,70,34,63]
[710,"赤",8,8,16,0,16,"青",27,3,30,10,20,null,null,null,null,null,71,34,53]
[720,"赤",16,12,28,0,28,"青",20,4,24,10,14,null,null,null,null,null,72,33,52]
[730,"青",28,10,38,20,18,"赤",14,3,17,0,17,null,null,null,null,null,73,34,48]
[740,"青",18,9,27,20,7,"赤",17,4,21,0,21,null,null,null,null,null,74,35,59]
[750,"青",7,8,15,{"$f":"IF(B77=\"赤\",0,IF(E77>20,20,E77))","v":15},0,"赤",21,3,24,0,24,null,null,null,null,null,75,36,49]
[760,"青",0,11,11,11,0,"赤",24,4,28,0,28,null,null,null,null,null,76,35,42]
[770,"青",0,9,9,9,0,"赤",28,3,31,0,31,null,null,null,null,null,77,35,52]
[780,"青",0,10,10,10,0,"赤",31,4,35,0,35,null,null,null,null,null,78,35,47]
[790,"赤",0,9,9,0,9,"青",35,3,38,10,28,null,null,null,null,null,79,33,61]
[800,"赤",9,9,18,0,18,"青",28,4,32,10,22,null,null,null,null,null,80,34,53]
[810,"赤",18,11,29,0,29,"青",22,4,26,10,16,null,null,null,null,null,81,35,42]
[820,"青",29,11,40,20,20,"赤",16,4,20,0,20,null,null,null,null,null,82,34,54]
[830,"青",20,12,32,20,12,"赤",20,4,24,0,24,null,null,null,null,null,83,35,47]
[840,"青",12,10,22,20,2,"赤",24,4,28,0,28,null,null,null,null,null,84,34,49]
[850,"青",2,12,14,14,0,"赤",28,4,32,0,32,null,null,null,null,null,85,36,57]
[860,"青",0,11,11,11,0,"赤",32,3,35,0,35,null,null,null,null,null,86,34,55]
[870,"青",0,11,11,11,0,"赤",35,4,39,0,39,null,null,null,null,null,87,35,59]
[880,"赤",0,10,10,0,10,"青",39,3,42,10,32,null,null,null,null,null,88,33,35]
[890,"赤",10,9,19,0,19,"青",32,3,35,10,25,null,null,null,null,null,89,35,48]
[900,"赤",19,9,28,0,28,"青",25,4,29,10,19,null,null,null,null,null,90,33,47]
[910,"青",28,9,37,20,17,"赤",19,4,23,0,23,null,null,null,null,null,91,34,56]
[920,"青",17,11,28,20,8,"赤",23,4,27,0,27,null,null,null,null,null,92,34,53]
[930,"青",8,11,19,19,0,"赤",27,4,31,0,31,null,null,null,null,null,93,34,54]
[940,"青",0,9,9,9,0,"赤",31,3,34,0,34,null,null,null,null,null,94,34,37]
[950,"青",0,9,9,9,0,"赤",34,3,37,0,37,null,null,null,null,null,95,35,50]
[960,"青",0,12,12,12,0,"赤",37,4,41,0,41,null,null,null,null,null,96,34,47]
[970,"赤",0,9,9,0,9,"青",41,3,44,10,34,null,null,null,null,null,97,35,54]
[980,"赤",9,8,17,0,17,"青",34,3,37,10,27,null,null,null,null,null,98,32,48]
[990,"赤",17,9,26,0,26,"青",27,4,31,10,21,null,null,null,null,null,99,36,42]
[1000,"青",26,10,36,20,16,"赤",21,3,24,0,24,null,null,null,null,null,100,35,50]
[1010,"青",16,10,26,20,6,"赤",24,3,27,0,27]
[1020,"青",6,9,15,15,0,"赤",27,4,31,0,31]
[1030,"青",0,9,9,9,0,"赤",31,4,35,0,35]
[1040,"青",0,11,11,11,0,"赤",35,4,39,0,39]
[1050,"青",0,10,10,10,0,"赤",39,4,43,0,43]
[1060,"赤",0,11,11,0,11,"青",43,4,47,10,37]
[1070,"赤",11,10,21,0,21,"青",37,4,41,10,31]
[1080,"赤",21,11,32,0,32,"青",31,3,34,10,24]
[1090,"青",32,11,43,20,23,"赤",24,4,28,0,28]
[1100,"青",23,9,32,20,12,"赤",28,4,32,0,32]
[1110,"青",12,8,20,20,0,"赤",32,3,35,0,35]
[1120,"青",0,10,10,10,0,"赤",35,3,38,0,38]
[1130,"青",0,10,10,10,0,"赤",38,4,42,0,42]
[1140,"青",0,8,8,8,0,"赤",42,4,46,0,46]
[1150,"赤",0,8,8,0,8,"青",46,3,49,10,39]
[1160,"赤",8,8,16,0,16,"青",39,3,42,10,32]
[1170,"赤",16,10,26,0,26,"青",32,3,35,10,25]
[1180,"青",26,9,35,20,15,"赤",25,4,29,0,29]
[1190,"青",15,8,23,20,3,"赤",29,3,32,0,32]
[1200,"青",3,11,14,14,0,"赤",32,4,36,0,36]
[1210,"青",0,11,11,11,0,"赤",36,4,40,0,40]
[1220,"青",0,8,8,8,0,"赤",40,4,44,0,44]
[1230,"青",0,11,11,11,0,"赤",44,3,47,0,47]
[1240,"赤",0,9,9,0,9,"青",47,3,50,10,40]
[1250,"赤",9,10,19,0,19,"青",40,3,43,10,33]
[1260,"赤",19,11,30,0,30,"青",33,4,37,10,27]
[1270,"青",30,12,42,20,22,"赤",27,4,31,0,31]
[1280,"青",22,9,31,20,11,"赤",31,3,34,0,34]
[1290,"青",11,{"$f":"RANDBETWEEN(8,12)","v":8},19,19,0,"赤",34,4,38,0,38]
[1300,"青",0,11,{"$f":"SUM(C132:D132)","v":11},11,{"$f":"E132-F132","v":0},"赤",38,{"$f":"RANDBETWEEN(3,4)","v":3},{"$f":"SUM(I132:J132)","v":41},{"$f":"IF(H132=\"赤\",0,IF(K132>10,10,K132))","v":0},{"$f":"K132-L132","v":41}]
[1310,"青",{"$f":"G132","v":0},9,9,9,0,"赤",{"$f":"M132","v":41},3,44,0,44]
[1320,"青",0,8,8,8,0,"赤",44,3,47,0,47]
[1330,"赤",0,8,8,0,8,"青",47,4,51,10,41]
[1340,"赤",8,9,17,0,17,"青",41,4,45,10,35]
[1350,"赤",17,11,28,0,28,"青",35,4,39,10,29]
[1360,"青",28,9,37,20,17,"赤",29,3,32,0,32]
[1370,"青",17,8,25,20,5,"赤",32,4,36,0,36]
[1380,"青",5,11,16,16,0,"赤",36,3,39,0,39]
[1390,"青",0,8,8,{"$f":"IF(B141=\"赤\",0,IF(E141>20,20,E141))","v":8},0,"赤",39,3,42,0,42]
[1400,"青",0,9,9,9,0,"赤",42,4,46,0,46]
[1410,"青",0,10,10,10,0,"赤",46,3,49,0,49]
[1420,"赤",0,8,8,0,8,"青",49,3,52,10,42]
[1430,"赤",8,8,16,0,16,"青",42,3,45,10,35]
[1440,"赤",16,9,25,0,25,"青",35,4,39,10,29]
[1450,"青",25,10,35,20,15,"赤",29,4,33,0,33]
[1460,"青",15,12,27,20,7,"赤",33,3,36,0,36]
[1470,"青",7,11,18,18,0,"赤",36,3,39,0,39]
[1480,"青",0,8,8,8,0,"赤",39,3,42,0,42]
[1490,"青",0,10,10,10,0,"赤",42,3,45,0,45]
[1500,"青",0,12,12,12,0,"赤",45,4,49,0,49]
[1510,"赤",0,12,12,0,12,"青",49,4,53,10,43]
[1520,"赤",12,10,22,0,22,"青",43,4,47,10,37]
[1530,"赤",22,12,34,0,34,"青",37,3,40,10,30]
[1540,"青",34,11,45,20,25,"赤",30,3,33,0,33]
[1550,"青",25,9,34,20,14,"赤",33,4,37,0,37]
[1560,"青",14,10,24,20,4,"赤",37,4,41,0,41]
[1570,"青",4,12,16,16,0,"赤",41,3,44,0,44]
[1580,"青",0,11,11,11,0,"赤",44,3,47,0,47]
[1590,"青",0,10,10,10,0,"赤",47,4,51,0,51]
[1600,"赤",0,11,11,0,11,"青",51,4,55,10,45]
[1610,"赤",11,11,22,0,22,"青",45,4,49,10,39]
[1620,"赤",22,11,33,0,33,"青",39,4,43,10,33]
[1630,"青",33,12,45,20,25,"赤",33,4,37,0,37]
[1640,"青",25,11,36,20,16,"赤",37,3,40,0,40]
[1650,"青",16,12,28,20,8,"赤",40,4,44,0,44]
[1660,"青",8,9,17,17,0,"赤",44,3,47,0,47]
[1670,"青",0,11,11,11,0,"赤",47,3,50,0,50]
[1680,"青",0,10,10,10,0,"赤",50,4,54,0,54]
[1690,"赤",0,12,12,0,12,"青",54,3,57,10,47]
[1700,"赤",12,11,23,0,23,"青",47,4,51,10,41]
[1710,"赤",23,9,32,0,32,"青",41,4,45,10,35]
[1720,"青",32,12,44,20,24,"赤",35,4,39,0,39]
[1730,"青",24,9,33,20,13,"赤",39,3,42,0,42]
[1740,"青",13,8,21,20,1,"赤",42,4,46,0,46]
[1750,"青",1,11,12,12,0,"赤",46,4,50,0,50]
[1760,"青",0,12,12,12,0,"赤",50,4,54,0,54]
[1770,"青",0,8,8,8,0,"赤",54,4,58,0,58]
[1780,"赤",0,10,10,0,10,"青",58,3,61,10,51]
[1790,"赤",10,9,19,0,19,"青",51,4,55,10,45]
[1800,"赤",19,9,28,0,28,"青",45,4,49,10,39]