{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Trail density","Removal Assays","ant density and trail width","Introduction Assays","Other observations","pod size"],"read":"whole","date_system":"1900"}

{"sheet":"Trail density","index":0,"n_rows":25,"n_cols":8,"rows_kept":25}
["Date","Time","Observation","Trail length","Number of P. pruinosus individuals on trail",null,"Coordinates","Associated file"]
["2022-04-19","06:40:00","Porcellionides pruinosus seen from end of foraging trail all the way to Messor nest entrace","unknown","~60",null,"31.271800, 34.826000","IMG_0016.MOV"]
["2022-04-23","06:50:00","One leg of a foraging trail from one nest monitored for trail density of P. pruinosus for two hours","73 ft",12,null,"31.272400, 34.825900","IMG_0228.MOV"]
["\"","07:00:00","\"","\"",11,null,"\""]
["\"","07:10:00","\"","\"",7,null,"\""]
["\"","07:20:00","\"","\"",2,null,"\""]
["\"","07:30:00","\"","\"",7,null,"\""]
["\"","07:40:00","\"","\"",7,null,"\""]
["\"","07:50:00","\"","\"",9,null,"\""]
["\"","08:00:00","\"","\"",10,null,"\""]
["\"","08:10:00","\"","\"",5,null,"\""]
["\"","08:20:00","\"","\"",3,null,"\""]
["\"","08:30:00","\"","\"",2,null,"\""]
["\"","08:40:00","\"","\"",2,null,"\""]
["\"","08:50:00","\"","\"",1,null,"\""]
["\"","09:00:00","\"","\"",3,null,"\""]
["\"","09:10:00","\"","\"",1,null,"\""]
["\"","09:20:00","\"","\"",2,null,"\""]
["\"","09:30:00","\"","\"",0,null,"\""]
["2022-04-25","06:25:00","Same foraging trail from nest monitored on April 23","73 ft",6,null,"31.272400, 34.825900"]
["\"","07:20:00",null,"\"",5,null,"\""]
["\"","07:42:00",null,"\"",3,null,"\""]
["\"","07:59:00",null,"\"",2,null,"\""]
["\"","08:36:00",null,"\"",4,null,"\""]
["\"","08:52:00",null,"\"",2,null,"\""]

{"sheet":"Removal Assays","index":1,"n_rows":13,"n_cols":13,"rows_kept":13}
["Date","Time","Surface Temp at this time celsius","Surface humidity","Image file","Coordinates","Distance isopod removed from trail (inches)","Returned to trail y/n","Time to return to trail in seconds","Time observed in seconds","Time stayed in trail seconds","Approx distance stayed in trail","Notes"]
["2022-04-12","07:33:00",16.621,68.1,"IMG_9795.MOV","31.271800, 34.825700",8,"y",188,null,30,"0.25m","Good example of isopod returning to the trail"]
["2022-04-12","07:49:00",18.122,64.59,"IMG_9796.MOV","31.271700, 34.825800",8,"y",243,null,30,"0.25m"]
["2022-04-14","07:49:00",18.622,58.69,"IMG_9907.MOV","31.271800, 34.825800",5,"n"]
["2022-04-14","08:41:00",27.125,44.527,"IMG_9912.MOV","31.271800, 34.825600",5,"y",99,null,8,"0.25m"]
["2022-04-20","07:23:00",15.119,78.11,"IMG_0040.MOV","31.271900, 34.825800",5,"y",215,null,30,"0.25m","crossed the trail to the other side without joining, then went back and started following trail"]
["2022-04-24","06:40:00",17.121,77.565,"IMG_0276.MOV","31.272100, 34.826500",10,"y",180,null,24,"0.25m"]
["2022-04-24","06:50:00",17.622,82.416,"IMG_0277-0278.MOV","31.272000, 34.826500",10,"n",null,434]
["2022-04-24","07:40:00",17.622,75.919,"IMG_0286.MOV","31.272100, 34.826600",5,"n",null,417]
["2022-04-25","07:24:00",22.124,64.59,"IMG_0303.MOV","31.271900, 34.825700",0,"y",0,null,30,"0.25m","picked up from trail and placed back on trail instead of removing (observed for 1:18)"]
["2022-04-25","07:27:00",22.124,64.59,"IMG_204.MOV","31.271900, 34.825600",0,"y",0,{"$nulls":3},"picked up from trail and placed back on trail instead of removing (observed for 1:24)"]
["2022-04-25","07:54:00",25.125,62.249,"IMG_305.MOV","31.271900, 34.825700",5,"n",null,114]
["2022-04-25","08:56:00",30.624,53.858,"IMG_320.MOV","31.271900, 34.825700",5,"n",null,138]

{"sheet":"ant density and trail width","index":2,"n_rows":13,"n_cols":7,"rows_kept":13}
["Still from video","Date","pixels in 1 inch","width of trail in pixels","width of trail in inches","width of trail in m","number of ants in 2 square inches"]
["IMG_9795.MOV","2022-04-12",25.75,98.02,{"$f":"D2/C2","v":{"v":3.8066019417475725,"d":"3.81"}},{"$f":"CONVERT(E2,\"in\",\"m\")","v":{"v":0.09668768932038833,"d":"0.10"}},6]
["IMG_9796.MOV","2022-04-12",{"v":69,"d":"69.00"},208.04,{"$f":"D3/C3","v":{"v":3.015072463768116,"d":"3.02"}},{"$f":"CONVERT(E3,\"in\",\"m\")","v":{"v":0.07658284057971014,"d":"0.08"}},4]
["IMG_9907.MOV","2022-04-14",{"v":95.5,"d":"95.50"},720.03,{"v":7.5395811518324605,"d":"7.54"},{"v":0.1915053612565445,"d":"0.19"},0]
["IMG_9912.MOV","2022-04-14",95.39,222.99,{"v":2.3376664220568193,"d":"2.34"},{"v":0.059376727120243215,"d":"0.06"},1]
["IMG_0040.MOV","2022-04-20",121.02,458.01,{"v":3.784581060981656,"d":"3.78"},{"v":0.09612835894893407,"d":"0.10"},3]
["IMG_0276.MOV","2022-04-24",{"v":57,"d":"57.00"},220.01,{"v":3.8598245614035087,"d":"3.86"},{"v":0.09803954385964912,"d":"0.10"},2]
["IMG_0277-0278.MOV","2022-04-24",25.02,76.03,{"v":3.03876898481215,"d":"3.04"},{"v":0.07718473221422861,"d":"0.08"},4]
["IMG_0286.MOV","2022-04-24",54.51,266.19,{"v":4.883324160704458,"d":"4.88"},{"v":0.12403643368189322,"d":"0.12"},4]
["IMG_0303.MOV","2022-04-25",67.19,144.17,{"v":2.1457062062806966,"d":"2.15"},{"v":0.05450093763952969,"d":"0.05"},2]
[]
[{"$nulls":5},{"$f":"AVERAGE(F2:F10)","v":{"v":0.09711584718012455,"d":"0.10"}},{"$f":"AVERAGE(G2:G10)","v":{"v":2.888888888888889,"d":"2.89"}}]
["Average"]

{"sheet":"Introduction Assays","index":3,"n_rows":12,"n_cols":8,"rows_kept":12}
["Date","Time","Image file","Coordinates","Distance isopod found from trail initially","Stayed in trail y/n","Observation length (minutes)","Notes"]
["2022-04-14","09:10:00","IMG_9921.MOV","31.272200, 34.826900","5 meters","y","01:00:00"]
["2022-04-20","06:53:00","IMG_0033.MOV","31.271800, 34.825800","from foraging trail of nest A to foraging trail of nest B","y","01:00:00","Porcellionides  from foraging trail from nest A was moved to foraging trail of nest B - stays within foraging boundary of new trail for at least one minute"]
["2022-04-20","07:02:00","IMG_0034.MOV","31.271900, 34.825700","from foraging trail of nest B to foraging trail of nest A","no","02:16:00","strayed from trail"]
["2022-04-20","07:06:00","IMG_0035.MOV","31.271800, 34.825800","same individual as above, returned to trail from nest B","no","03:07:00"]
[]
[]
[]
[]
[]
[]
["Description of assay: isopod removed from one trail of nest A and placed into a different trail from nest B. If the isopod stays on the new trail, and continues walking in it then it's considered a \"yes\" return "]

{"sheet":"Other observations","index":4,"n_rows":16,"n_cols":5,"rows_kept":16}
["Date","Time","Observation","Coordinates","Associated file"]
["2022-04-13","06:05:00","P. pruinosus seen INSIDE M. ebeninus nest with borescope, before foraging trails were established",null,"isopod inside messor nest clip.mov"]
["2022-04-14","18:25:00","Hemilepistus reaumuri seen crossing Messor trail and repelled (aversion)","31.271900, 34.825700","IMG_9941- aversion from messor towards hemilepistus.MOV"]
["2022-04-17","morning","P. pruinosus seen on soil surface unassociated with Messor"]
["2022-04-19","06:40:00","P. pruinosus and Hemilepistus aversion","31.271800, 34.826000","IMG_0016_aversion_clip.MOV"]
["2022-04-20","morning","Samples of Porcellionides and Messor were collected into 100% EtOH "]
["2022-04-20","09:26:00","A third M. ebeninus nest on a far hill found with P. pruinosus in their trails","31.271400, 34.825800"]
["2022-04-20","09:29:00","A fourth M. ebeninus nest on a far hill found with P. pruinosus  in their trails","31.271500, 34.825800"]
["2022-04-21","06:40:00","M. ebeninus slowly forming foraging trails, no P. pruinosus on the trails"]
["2022-04-21","07:10:00","Borescope used to view inside of M. ebeninus nest - P. pruinosus seen inside the nest, and still none on the slowly forming foraging trails"]
["2022-04-21","07:48:00","P. pruinosus seen in M. ebeninus foraging trails"]
["2022-04-22","06:30:00","P. pruinosus seen in M. ebeninus foraging trails"]
["2022-04-23","06:00:00","Increase in ambient temperature from previous days - M. ebeninus foraging trails formed earlier, and P. pruinosus on trails with them"]
["2022-04-23","09:30:00","Borescope used to view inside of M. ebeninus nest - P. pruinosus seen inside the nest"]
["2022-04-26","morning","Another M. ebeninus nest has multiple P. pruinosus on its foraging trails - on the far hill - total nests with isopods on trails is now at least 5"]
["April-May 2023",null,"At least two nests of M. ebeninus have multiple P. pruinosus on their foraging trails, seen throughout the entire two months. No assays performed due to other fieldwork focus"]

{"sheet":"pod size","index":5,"n_rows":15,"n_cols":6,"rows_kept":15}
["pHoto","length of pod in pixels","pixels in 1in","pod in inches","pod in meters"]
["From video IMG_0040.tif",45.71,113.02,{"$f":"B2/C2","v":{"v":0.40444169173597594,"d":"0.40"}},{"$f":"CONVERT(D2,\"in\",\"m\")","v":{"v":0.010272818970093788,"d":"0.01"}}]
[]
[]
[]
[]
["in other photo:"]
["photo","pod in meters (from 0040)","#pixels in one pod length in this photo","pixels in 1m","pixels in 0.05m","length of trail in pixels"]
["From video IMG_0016.tif",0.01,43.83,{"$f":"C9/B9","v":{"v":4383,"d":"4383.00"}},{"$f":"D9*0.05","v":219.15},315.3]
[]
[]
[]
[]
["Conversion:",8,{"$f":"(B14*C15)/B15","v":{"v":3520,"d":"3520.00"}}]
[null,0.05,{"v":22,"d":"22.00"}]