{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["N點"],"not_rendered":{"charts":0,"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":"N點","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,10,5,12]]}
[null,null,null,"起始里程=",0]
[null,null,null,"抽樣數N=",10]
[null,null,null,"輸入長度 L=",1000]
[null,null,null,"寬度 W=",7]
[null,null,null,"工程起、迄點各扣除長度 =",7,null,null,null,null,null,"黏滯度取樣位置"]
[null,null,null,"鋪築兩邊各扣除寛度 =",1]
[null,null,"亂數","項   目","縱距","橫距","里程","橫距",null,null,"項   目","縱距","里程"]
[1,"第1點：",{"$f":"$E$5+INT(((E$3-$E$5*2)/E2*RAND()))","v":87},{"$f":"IF(A8<=$E$2,B8,\"\")","v":"第1點："},{"$f":"IF(A8<=$E$2,C8,\"\")","v":87},{"$f":"IF(A8<=$E$2,H8,\"\")","v":3.2448052168559371},{"$f":"IF(A8<=$E$2,E8+$E$1,\"\")","v":87},{"$f":"$E$6+RAND()*($E$4-$E$6*2)","v":3.2448052168559371},null,null,"第1點：",{"$f":"E$5+INT((E3-E$5*2)/5*RAND())","v":77},{"$f":"$E$1+L8","v":77}]
[{"$f":"1+A8","v":2},"第2點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A9-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":174},{"$f":"IF(A9<=$E$2,B9,\"\")","v":"第2點："},{"$f":"IF(A9<=$E$2,C9,\"\")","v":174},{"$f":"IF(A9<=$E$2,H9,\"\")","v":2.9334220785506009},{"$f":"IF(A9<=$E$2,E9+$E$1,\"\")","v":174},{"$f":"$E$6+RAND()*($E$4-$E$6*2)","v":2.9334220785506009},null,null,"第2點：",{"$f":"E$5+INT(((E$3-E$5*2)/5+(E$3-E$5*2)/5*RAND()))","v":311},{"$f":"$E$1+L9","v":311}]
[{"$f":"1+A9","v":3},"第3點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A10-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":290},"第3點：",290,{"$f":"IF(A10<=$E$2,H10,\"\")","v":4.4087563928935838},290,4.4087563928935838,null,null,"第3點：",{"$f":"E$5+INT(((E$3-E$5*2)*2/5+(E$3-E$5*2)/5*RAND()))","v":544},544]
[4,"第4點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A11-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":313},"第4點：",313,{"$f":"IF(A11<=$E$2,H11,\"\")","v":5.6934460468944721},313,5.6934460468944721,null,null,"第4點：",{"$f":"E$5+INT(((E$3-E$5*2)*3/5+(E$3-E$5*2)/5*RAND()))","v":624},624]
[5,"第5點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A12-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":482},"第5點：",482,{"$f":"IF(A12<=$E$2,H12,\"\")","v":2.5915536007978925},482,2.5915536007978925,null,null,"第5點：",{"$f":"E$5+INT(((E$3-E$5*2)*4/5+(E$3-E$5*2)/5*RAND()))","v":953},953]
[6,"第6點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A13-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":533},"第6點：",533,{"$f":"IF(A13<=$E$2,H13,\"\")","v":5.0707036171918549},533,5.0707036171918549]
[7,"第7點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A14-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":616},"第7點：",616,{"$f":"IF(A14<=$E$2,H14,\"\")","v":4.6023872006190016},616,4.6023872006190016]
[8,"第8點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A15-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":760},"第8點：",760,{"$f":"IF(A15<=$E$2,H15,\"\")","v":3.4837115961308518},760,3.4837115961308518]
[9,"第9點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A16-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":866},"第9點：",866,{"$f":"IF(A16<=$E$2,H16,\"\")","v":4.6557651529847206},866,4.6557651529847206]
[10,"第10點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A17-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":915},"第10點：",915,{"$f":"IF(A17<=$E$2,H17,\"\")","v":4.5244230188172621},915,4.5244230188172621]
[{"$f":"1+A17","v":11},"第11點：",{"$f":"$E$5+INT(((E$3-$E$5*2)*(A18-1)/$E$2+(E$3-$E$5*2)/$E$2*RAND()))","v":1059},{"$f":"IF(A18<=$E$2,B18,\"\")","v":""},{"$f":"IF(A18<=$E$2,C18,\"\")","v":""},{"$f":"IF(A18<=$E$2,H18,\"\")","v":""},{"$f":"IF(A18<=$E$2,E18+$E$1,\"\")","v":""},5.1805954472189963]
[12,"第12點：",1147,"","",{"$f":"IF(A19<=$E$2,H19,\"\")","v":""},"",5.4626794834106676]
[13,"第13點：",1270,"","",{"$f":"IF(A20<=$E$2,H20,\"\")","v":""},"",2.1488834036930751]
[14,"第14點：",1291,"","",{"$f":"IF(A21<=$E$2,H21,\"\")","v":""},"",2.1816998313236038]
[15,"第15點：",1432,"","",{"$f":"IF(A22<=$E$2,H22,\"\")","v":""},"",4.8266575835269334]
[16,"第16點：",1497,"","",{"$f":"IF(A23<=$E$2,H23,\"\")","v":""},"",4.6474505006161762]
[17,"第17點：",1593,"","",{"$f":"IF(A24<=$E$2,H24,\"\")","v":""},"",3.1466101986251074]
[18,"第18點：",1706,"","",{"$f":"IF(A25<=$E$2,H25,\"\")","v":""},"",5.9486484241264073]
[19,"第19點：",1810,"","",{"$f":"IF(A26<=$E$2,H26,\"\")","v":""},"",5.7536976276732261]
[20,"第20點：",1971,"","",{"$f":"IF(A27<=$E$2,H27,\"\")","v":""},"",4.7876751393804486]