{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["APEX","Help","API"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"APEX","index":0,"n_rows":29,"n_cols":29,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,14,23,15],[0,21,0,22],[7,19,7,22],[5,26,5,28]]}
[null,"APEX Tracker",null,null,null,null,{"$f":"SUM(G4:G23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(B4:B23)","v":1},20]
[null,"Aeromir.com Version 1.10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average/Act",{"$f":"IF(COUNTA(B4:B23)>0,G1/COUNTA(B4:B23),\"\")","v":0},1,0.9]
[null,"Account","Type","Acct Size","Previous","Current","PnL","Auto Liq","Trailing DD","Drawdown","Dist to DD %","PnL","To Target","% to Tgt","Days to Tgt","Contracts","Start Date","Days",null,"Daily",{"$f":"IFERROR(U2*$U$1,\"\")","v":0},{"$f":"IFERROR(U2*V1,\"\")","v":0},{"$f":"IFERROR(V3*$W$2,\"\")","v":0}]
[null,1,"EVAL",50000,50000,50000,{"$f":"IF(AND(F4>0,F4>0),F4-E4,\"\")","v":0},47500,{"$f":"F4-H4","v":2500},{"$f":"IF(H4>0,INDEX($X$10:$X$16,MATCH(D4,$T$10:$T$16,0))-I4,\"\")","v":0},{"$f":"IF(AND(H4>0,J4>0),(INDEX(API!$K$4:$K$10,MATCH(D4,API!$I$4:$I$10,0))-I4)/INDEX(API!$K$4:$K$10,MATCH(D4,API!$I$4:$I$10,0)),\"\")","v":""},{"$f":"IF(AND(D4>0,F4>0),F4-D4,\"\")","v":0},{"$f":"IF(AND(D4>0,F4>0),\nIF(AND((INDEX($U$10:$U$16, MATCH(D4, $T$10:$T$16, 0))-L4)<=0,L4>0),\n\"STOP\",\nINDEX($U$10:$U$16, MATCH(D4, $T$10:$T$16, 0))-L4+IF(C4=\"PA\",$Y$7,0)\n),\n\"\")","v":3000},{"$f":"IF(AND(D4>0,F4>0,M4<>\"STOP\"),(INDEX($U$10:$U$16, MATCH(D4, $T$10:$T$16, 0))-M4+IF(C4=\"PA\",$Y$7,0))/(INDEX($U$10:$U$16, MATCH(D4, $T$10:$T$16, 0))+IF(C4=\"PA\",$Y$7,0)),\"\")","v":0},{"$f":"IFERROR(IF(AND(B4>0,G4>0),M4/G4,\"\"),\"\")","v":""},{"$f":"IF(AND(D4>0,F4>0),INDEX($Y$10:$Y$16, MATCH(D4, $T$10:$T$16, 0))&\"(\"&INDEX($Z$10:$Z$16, MATCH(D4, $T$10:$T$16, 0)) &\")\",\"\")","v":"10(100)"},"2024-06-13",{"$f":"IF(AND(B4<>\"\",Q4<>\"\"),IF(Q4=TODAY(),0,NETWORKDAYS(Q4,TODAY())),\"\")","v":0},null,"Weekly",{"$f":"IFERROR(U3*5,\"\")","v":0},{"$f":"IFERROR(V3*5,\"\")","v":0},{"$f":"IFERROR(V4*$W$2,\"\")","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(F5>0,F5>0),F5-E5,\"\")","v":""},null,{"$f":"F5-H5","v":0},{"$f":"IF(H5>0,INDEX($X$10:$X$16,MATCH(D5,$T$10:$T$16,0))-I5,\"\")","v":""},{"$f":"IF(AND(H5>0,J5>0),(INDEX(API!$K$4:$K$10,MATCH(D5,API!$I$4:$I$10,0))-I5)/INDEX(API!$K$4:$K$10,MATCH(D5,API!$I$4:$I$10,0)),\"\")","v":""},{"$f":"IF(AND(D5>0,F5>0),F5-D5,\"\")","v":""},{"$f":"IF(AND(D5>0,F5>0),\nIF(AND((INDEX($U$10:$U$16, MATCH(D5, $T$10:$T$16, 0))-L5)<=0,L5>0),\n\"STOP\",\nINDEX($U$10:$U$16, MATCH(D5, $T$10:$T$16, 0))-L5+IF(C5=\"PA\",$Y$7,0)\n),\n\"\")","v":""},{"$f":"IF(AND(D5>0,F5>0,M5<>\"STOP\"),(INDEX($U$10:$U$16, MATCH(D5, $T$10:$T$16, 0))-M5+IF(C5=\"PA\",$Y$7,0))/(INDEX($U$10:$U$16, MATCH(D5, $T$10:$T$16, 0))+IF(C5=\"PA\",$Y$7,0)),\"\")","v":""},{"$f":"IFERROR(IF(AND(B5>0,G5>0),M5/G5,\"\"),\"\")","v":""},{"$f":"IF(AND(D5>0,F5>0),INDEX($Y$10:$Y$16, MATCH(D5, $T$10:$T$16, 0))&\"(\"&INDEX($Z$10:$Z$16, MATCH(D5, $T$10:$T$16, 0)) &\")\",\"\")","v":""},null,{"$f":"IF(AND(B5<>\"\",Q5<>\"\"),IF(Q5=TODAY(),0,NETWORKDAYS(Q5,TODAY())),\"\")","v":""},null,"Monthly",{"$f":"IFERROR(U3*250/12,\"\")","v":0},{"$f":"IFERROR(V3*250/12,\"\")","v":0},{"$f":"IFERROR(V5*$W$2,\"\")","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(F6>0,F6>0),F6-E6,\"\")","v":""},null,{"$f":"F6-H6","v":0},{"$f":"IF(H6>0,INDEX($X$10:$X$16,MATCH(D6,$T$10:$T$16,0))-I6,\"\")","v":""},{"$f":"IF(AND(H6>0,J6>0),(INDEX(API!$K$4:$K$10,MATCH(D6,API!$I$4:$I$10,0))-I6)/INDEX(API!$K$4:$K$10,MATCH(D6,API!$I$4:$I$10,0)),\"\")","v":""},{"$f":"IF(AND(D6>0,F6>0),F6-D6,\"\")","v":""},"","",{"$f":"IFERROR(IF(AND(B6>0,G6>0),M6/G6,\"\"),\"\")","v":""},"",null,{"$f":"IF(AND(B6<>\"\",Q6<>\"\"),IF(Q6=TODAY(),0,NETWORKDAYS(Q6,TODAY())),\"\")","v":""},null,"Annual",{"$f":"IFERROR(U3*250,\"\")","v":0},{"$f":"IFERROR(V3*250,\"\")","v":0},{"$f":"IFERROR(V6*$W$2,\"\")","v":0},null,"PA Account Target",null,"Max Contracts Points"]
[null,null,null,null,null,null,{"$f":"IF(AND(F7>0,F7>0),F7-E7,\"\")","v":""},null,null,"",{"$f":"IF(AND(H7>0,J7>0),(INDEX(API!$K$4:$K$10,MATCH(D7,API!$I$4:$I$10,0))-I7)/INDEX(API!$K$4:$K$10,MATCH(D7,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,null,null,null,null,null,100,null,"$/Point",20,"Target"]
[null,null,null,null,null,null,{"$f":"IF(AND(F8>0,F8>0),F8-E8,\"\")","v":""},null,null,"",{"$f":"IF(AND(H8>0,J8>0),(INDEX(API!$K$4:$K$10,MATCH(D8,API!$I$4:$I$10,0))-I8)/INDEX(API!$K$4:$K$10,MATCH(D8,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,"Get your own APEX Trader Funding account",null,null,null,null,null,null,"Type","Minis",500]
[null,null,null,null,null,null,{"$f":"IF(AND(F9>0,F9>0),F9-E9,\"\")","v":""},null,null,"",{"$f":"IF(AND(H9>0,J9>0),(INDEX(API!$K$4:$K$10,MATCH(D9,API!$I$4:$I$10,0))-I9)/INDEX(API!$K$4:$K$10,MATCH(D9,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,"Account Size","Profit Target","Days to Pass","Months to Pass","Drawdown","Minis","Micros","Profit","Drawdown","Points"]
[null,null,null,null,null,null,{"$f":"IF(AND(F10>0,F10>0),F10-E10,\"\")","v":""},null,null,"",{"$f":"IF(AND(H10>0,J10>0),(INDEX(API!$K$4:$K$10,MATCH(D10,API!$I$4:$I$10,0))-I10)/INDEX(API!$K$4:$K$10,MATCH(D10,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,25000,1500,{"$f":"IFERROR(IF(AND($U$2>0,$U$2>0),U10/$U$2,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND($U$2>0,$U$2>0),V10/(250/12),\"\"),\"\")","v":""},1500,4,40,{"$f":"U10/($AB$7*IF($AB$8=\"Minis\",Y10,Z10))","v":18.75},{"$f":"X10/($AB$7*IF($AB$8=\"Minis\",Y10,Z10))","v":18.75},{"$f":"$AC$8/($AB$7*IF($AB$8=\"Minis\",Y10,Z10))","v":6.25}]
[null,null,null,null,null,null,{"$f":"IF(AND(F11>0,F11>0),F11-E11,\"\")","v":""},null,null,"",{"$f":"IF(AND(H11>0,J11>0),(INDEX(API!$K$4:$K$10,MATCH(D11,API!$I$4:$I$10,0))-I11)/INDEX(API!$K$4:$K$10,MATCH(D11,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,50000,3000,"","",2500,10,100,{"$f":"U11/($AB$7*IF($AB$8=\"Minis\",Y11,Z11))","v":15},{"$f":"X11/($AB$7*IF($AB$8=\"Minis\",Y11,Z11))","v":12.5},{"$f":"$AC$8/($AB$7*IF($AB$8=\"Minis\",Y11,Z11))","v":2.5}]
[null,null,null,null,null,null,{"$f":"IF(AND(F12>0,F12>0),F12-E12,\"\")","v":""},null,null,"",{"$f":"IF(AND(H12>0,J12>0),(INDEX(API!$K$4:$K$10,MATCH(D12,API!$I$4:$I$10,0))-I12)/INDEX(API!$K$4:$K$10,MATCH(D12,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,75000,4250,"","",2750,12,120,17.708333333333332,11.458333333333334,2.0833333333333335]
[null,null,null,null,null,null,{"$f":"IF(AND(F13>0,F13>0),F13-E13,\"\")","v":""},null,null,"",{"$f":"IF(AND(H13>0,J13>0),(INDEX(API!$K$4:$K$10,MATCH(D13,API!$I$4:$I$10,0))-I13)/INDEX(API!$K$4:$K$10,MATCH(D13,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,100000,6000,"","",3000,14,140,21.428571428571427,10.714285714285714,1.7857142857142858]
[null,null,null,null,null,null,{"$f":"IF(AND(F14>0,F14>0),F14-E14,\"\")","v":""},null,null,"",{"$f":"IF(AND(H14>0,J14>0),(INDEX(API!$K$4:$K$10,MATCH(D14,API!$I$4:$I$10,0))-I14)/INDEX(API!$K$4:$K$10,MATCH(D14,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,150000,9000,"","",5000,17,170,26.470588235294116,14.705882352941176,1.4705882352941178]
[null,null,null,null,null,null,{"$f":"IF(AND(F15>0,F15>0),F15-E15,\"\")","v":""},null,null,"",{"$f":"IF(AND(H15>0,J15>0),(INDEX(API!$K$4:$K$10,MATCH(D15,API!$I$4:$I$10,0))-I15)/INDEX(API!$K$4:$K$10,MATCH(D15,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,250000,15000,"","",6500,27,270,27.777777777777779,12.037037037037036,0.92592592592592593]
[null,null,null,null,null,null,{"$f":"IF(AND(F16>0,F16>0),F16-E16,\"\")","v":""},null,null,"",{"$f":"IF(AND(H16>0,J16>0),(INDEX(API!$K$4:$K$10,MATCH(D16,API!$I$4:$I$10,0))-I16)/INDEX(API!$K$4:$K$10,MATCH(D16,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,300000,20000,"","",7500,35,350,28.571428571428573,10.714285714285714,0.7142857142857143]
[null,null,null,null,null,null,{"$f":"IF(AND(F17>0,F17>0),F17-E17,\"\")","v":""},null,null,"",{"$f":"IF(AND(H17>0,J17>0),(INDEX(API!$K$4:$K$10,MATCH(D17,API!$I$4:$I$10,0))-I17)/INDEX(API!$K$4:$K$10,MATCH(D17,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(F18>0,F18>0),F18-E18,\"\")","v":""},null,null,"",{"$f":"IF(AND(H18>0,J18>0),(INDEX(API!$K$4:$K$10,MATCH(D18,API!$I$4:$I$10,0))-I18)/INDEX(API!$K$4:$K$10,MATCH(D18,API!$I$4:$I$10,0)),\"\")","v":""},{"$f":"IF(AND(D18>0,F18>0),F18-D18,\"\")","v":""},{"$f":"IF(AND(D18>0,F18>0),\nIF(AND((INDEX($U$10:$U$16, MATCH(D18, $T$10:$T$16, 0))-L18)<=0,L18>0),\n\"STOP\",\nINDEX($U$10:$U$16, MATCH(D18, $T$10:$T$16, 0))-L18+IF(C18=\"PA\",$Y$7,0)\n),\n\"\")","v":""},{"$f":"IF(AND(D18>0,F18>0,M18<>\"STOP\"),(INDEX($U$10:$U$16, MATCH(D18, $T$10:$T$16, 0))-M18+IF(C18=\"PA\",$Y$7,0))/(INDEX($U$10:$U$16, MATCH(D18, $T$10:$T$16, 0))+IF(C18=\"PA\",$Y$7,0)),\"\")","v":""},"",{"$f":"IF(AND(D18>0,F18>0),INDEX($Y$10:$Y$16, MATCH(D18, $T$10:$T$16, 0))&\"(\"&INDEX($Z$10:$Z$16, MATCH(D18, $T$10:$T$16, 0)) &\")\",\"\")","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(F19>0,F19>0),F19-E19,\"\")","v":""},null,null,"",{"$f":"IF(AND(H19>0,J19>0),(INDEX(API!$K$4:$K$10,MATCH(D19,API!$I$4:$I$10,0))-I19)/INDEX(API!$K$4:$K$10,MATCH(D19,API!$I$4:$I$10,0)),\"\")","v":""},{"$f":"IF(AND(D19>0,F19>0),F19-D19,\"\")","v":""},{"$f":"IF(AND(D19>0,F19>0),\nIF(AND((INDEX($U$10:$U$16, MATCH(D19, $T$10:$T$16, 0))-L19)<=0,L19>0),\n\"STOP\",\nINDEX($U$10:$U$16, MATCH(D19, $T$10:$T$16, 0))-L19+IF(C19=\"PA\",$Y$7,0)\n),\n\"\")","v":""},{"$f":"IF(AND(D19>0,F19>0,M19<>\"STOP\"),(INDEX($U$10:$U$16, MATCH(D19, $T$10:$T$16, 0))-M19+IF(C19=\"PA\",$Y$7,0))/(INDEX($U$10:$U$16, MATCH(D19, $T$10:$T$16, 0))+IF(C19=\"PA\",$Y$7,0)),\"\")","v":""},"",{"$f":"IF(AND(D19>0,F19>0),INDEX($Y$10:$Y$16, MATCH(D19, $T$10:$T$16, 0))&\"(\"&INDEX($Z$10:$Z$16, MATCH(D19, $T$10:$T$16, 0)) &\")\",\"\")","v":""},null,"",null,"Previous","Current","Today PnL"]
[null,null,null,null,null,null,{"$f":"IF(AND(F20>0,F20>0),F20-E20,\"\")","v":""},null,null,"",{"$f":"IF(AND(H20>0,J20>0),(INDEX(API!$K$4:$K$10,MATCH(D20,API!$I$4:$I$10,0))-I20)/INDEX(API!$K$4:$K$10,MATCH(D20,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,"",null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(AND(F21>0,F21>0),F21-E21,\"\")","v":""},null,null,"",{"$f":"IF(AND(H21>0,J21>0),(INDEX(API!$K$4:$K$10,MATCH(D21,API!$I$4:$I$10,0))-I21)/INDEX(API!$K$4:$K$10,MATCH(D21,API!$I$4:$I$10,0)),\"\")","v":""},"",{"$f":"IF(AND(D21>0,F21>0),\nIF(AND((INDEX($U$10:$U$16, MATCH(D21, $T$10:$T$16, 0))-L21)<=0,L21>0),\n\"STOP\",\nINDEX($U$10:$U$16, MATCH(D21, $T$10:$T$16, 0))-L21+IF(C21=\"PA\",$Y$7,0)\n),\n\"\")","v":""},{"$f":"IF(AND(D21>0,F21>0,M21<>\"STOP\"),(INDEX($U$10:$U$16, MATCH(D21, $T$10:$T$16, 0))-M21+IF(C21=\"PA\",$Y$7,0))/(INDEX($U$10:$U$16, MATCH(D21, $T$10:$T$16, 0))+IF(C21=\"PA\",$Y$7,0)),\"\")","v":""},"","",null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(F22>0,F22>0),F22-E22,\"\")","v":""},null,null,"",{"$f":"IF(AND(H22>0,J22>0),(INDEX(API!$K$4:$K$10,MATCH(D22,API!$I$4:$I$10,0))-I22)/INDEX(API!$K$4:$K$10,MATCH(D22,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(F23>0,F23>0),F23-E23,\"\")","v":""},null,null,"",{"$f":"IF(AND(H23>0,J23>0),(INDEX(API!$K$4:$K$10,MATCH(D23,API!$I$4:$I$10,0))-I23)/INDEX(API!$K$4:$K$10,MATCH(D23,API!$I$4:$I$10,0)),\"\")","v":""},"","","","","",null,""]
[null,null,"Total",{"$f":"SUM(D4:D23)","v":50000},{"$f":"SUM(E4:E23)","v":50000},{"$f":"SUM(F4:F23)","v":50000},{"$f":"IF(AND(F24>0,F24>0),F24-D24,\"\")","v":0},null,null,null,"Average",{"$f":"SUM(L4:L23)/COUNT(L4:L23)","v":0},{"$f":"SUM(M4:M23)/COUNT(L4:L23)","v":3000},null,"To Target",null,"Per account"]
[null,null,null,null,null,{"$f":"IF(G25>=0,\"PA Profit\",\"PA Loss\")","v":"PA Profit"},{"$f":"SUMIF($C$4:$C$23, \"PA\", G4:G23)","v":0},{"$f":"IF(COUNTIF($C$4:$C$23,\"PA\")>0,G25/COUNTIF($C$4:$C$23,\"PA\"),\"\")","v":""},"Average",null,{"$f":"IF(L25>=0,\"PA Profit\",\"PA Loss\")","v":"PA Profit"},{"$f":"SUMIF($C$4:$C$23, \"PA\", L4:L23)","v":0},{"$f":"IF(COUNTIF($C$4:$C$23,\"PA\")>0,L25/COUNTIF($C$4:$C$23,\"PA\"),\"\")","v":""},"Average",{"$f":"IF(AND(API!D26>0,L25>0),L25/API!D26,\"\")","v":""},{"$f":"IF(AND(O25<>0,O25<>\"\"),(L25/O25)*(1-O25),\"\")","v":""},{"$f":"P25/API!E26","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(G26>=0,\"EVAL Profit\",\"EVAL Loss\")","v":"EVAL Profit"},{"$f":"SUMIF($C$4:$C$23, \"EVAL\", G4:G23)","v":0},{"$f":"IF(COUNTIF($C$4:$C$23,\"EVAL\")>0,G26/COUNTIF($C$4:$C$23,\"EVAL\"),\"\")","v":0},"Average",null,{"$f":"IF(L26>=0,\"EVAL Profit\",\"EVAL Loss\")","v":"EVAL Profit"},{"$f":"SUMIF($C$4:$C$23, \"EVAL\", L4:L23)","v":0},{"$f":"IF(COUNTIF($C$4:$C$23,\"EVAL\")>0,L26/COUNTIF($C$4:$C$23,\"EVAL\"),\"\")","v":0},"Average",{"$f":"IF(AND(API!D25<>0,L26>0),L26/API!D25,\"\")","v":""},{"$f":"IF(AND(O26<>0,O26<>\"\"),(L26/O26)*(1-O26),\"\")","v":""},{"$f":"P26/API!E25","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"IF(G27>=0,\"Total Profit\",\"Total Loss\")","v":"Total Profit"},{"$f":"G26+G25","v":0},{"$f":"IF(COUNTA($B$4:$B$23)>0,G27/COUNTA($B$4:$B$23),\"\")","v":0},"Average",null,{"$f":"IF(L27>=0,\"Total Profit\",\"Total Loss\")","v":"Total Profit"},{"$f":"L26+L25","v":0},{"$f":"IF(COUNTA($B$4:$B$23)>0,L27/COUNTA($B$4:$B$23),\"\")","v":0},"Average"]
[]
[null,null,null,null,null,null,0]

{"sheet":"Help","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Help"]
[]
[null,"Get your own APEX Trader Funding account"]
[]
[null,"This spreadsheet helps you monitor APEX Trader Funding accounts"]
[]
[null,"Created by Tom Nunamaker, Aeromir.com"]
[]
[null,"Cells with a blue background are cells for you to enter data. The rest of the spreadsheet should populate itself based on your inputs."]
[]
[null,"The \"Save\" button saves the previous balance and moves the current balance to the previous balance. Click this button when you are done trading for the day."]
[null,"NOTE: Clicking on the Save button multiple times will not over write your previous balance data."]
[]
[null,"The \"Restore\" button retrieves the previous balance. I added this in case you accidentally click the \"Save\" button and you want to restore today's data."]
[]
[null,"The \"Reset\" button resets the average profit per account to a formula.   You can enter a value and the cell will be a RED font so you know it is NOT a formula. Click the Reset button to restore the formula."]
[]
[null,"To delete a row, delete the data in columns B through E and column G"]

{"sheet":"API","index":2,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,14,2,19]]}
[null,"API "]
[null,"Version",1.1000000000000001]
[null,"PREVIOUS","Account Size","PROFIT TARGET","DRAWDOWN","Type",null,null,"Size","Target","Trail","Minis","Micros","Contracts","DEVELOPER NUMBERS"]
[null,50000,50000,{"$f":"IF(C4>0,VLOOKUP(C4, $I$4:$K$10, 2, FALSE),\"\")","v":3000},{"$f":"IF(C4>0,VLOOKUP(C4, $I$4:$K$10, 3, FALSE),\"\")","v":2500},{"$f":"IF(C4>0,APEX!C4,\"\")","v":"EVAL"},null,null,25000,1500,1500,4,40,{"$f":"L4&\"(\"&M4&\")\"","v":"4(40)"},1,"EVAL",25000,25000,25000,null,23500]
[null,null,null,{"$f":"IF(C5>0,VLOOKUP(C5, $I$4:$K$10, 2, FALSE),\"\")","v":""},{"$f":"IF(C5>0,VLOOKUP(C5, $I$4:$K$10, 3, FALSE),\"\")","v":""},{"$f":"IF(C5>0,APEX!C5,\"\")","v":""},null,null,50000,3000,2500,10,100,{"$f":"L5&\"(\"&M5&\")\"","v":"10(100)"}]
[null,null,null,"","",{"$f":"IF(C6>0,APEX!C6,\"\")","v":""},null,null,75000,4250,2750,12,120,"12(120)"]
[null,null,null,"","",{"$f":"IF(C7>0,APEX!C7,\"\")","v":""},null,null,100000,6000,3000,14,140,"14(140)"]
[null,null,null,"","",{"$f":"IF(C8>0,APEX!C8,\"\")","v":""},null,null,150000,9000,5000,17,170,"17(170)"]
[null,null,null,"","",{"$f":"IF(C9>0,APEX!C9,\"\")","v":""},null,null,250000,15000,6500,27,270,"27(270)"]
[null,null,null,"","",{"$f":"IF(C10>0,APEX!C10,\"\")","v":""},null,null,300000,20000,7500,35,350,"35(350)"]
[null,null,null,"","",{"$f":"IF(C11>0,APEX!C11,\"\")","v":""}]
[null,null,null,"","",{"$f":"IF(C12>0,APEX!C12,\"\")","v":""}]
[null,null,null,"","",{"$f":"IF(C13>0,APEX!C13,\"\")","v":""}]
[null,null,null,"","",{"$f":"IF(C14>0,APEX!C14,\"\")","v":""},null,null,"Input Mode",null,2,"1=PnL  2=Auto Liq  3=drawdown"]
[null,null,null,"","",{"$f":"IF(C15>0,APEX!C15,\"\")","v":""},null,null,"Show Hide Status",null,1,"1=show.  0=hide"]
[null,null,null,"","",{"$f":"IF(C16>0,APEX!C16,\"\")","v":""},null,null,"Show Hide Col D Status",null,1,"1=show.  0=hide"]
[null,null,null,"","",{"$f":"IF(C17>0,APEX!C17,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(C18>0,VLOOKUP(C18, $I$4:$K$10, 2, FALSE),\"\")+IF(F18=\"PA\",100,0),\"\")","v":""},"",{"$f":"IF(C18>0,APEX!C18,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(C19>0,VLOOKUP(C19, $I$4:$K$10, 2, FALSE),\"\")+IF(F19=\"PA\",100,0),\"\")","v":""},"",{"$f":"IF(C19>0,APEX!C19,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(C20>0,VLOOKUP(C20, $I$4:$K$10, 2, FALSE),\"\")+IF(F20=\"PA\",100,0),\"\")","v":""},"",{"$f":"IF(C20>0,APEX!C20,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(C21>0,VLOOKUP(C21, $I$4:$K$10, 2, FALSE),\"\")+IF(F21=\"PA\",100,0),\"\")","v":""},"",{"$f":"IF(C21>0,APEX!C21,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(C22>0,VLOOKUP(C22, $I$4:$K$10, 2, FALSE),\"\")+IF(F22=\"PA\",100,0),\"\")","v":""},"",{"$f":"IF(C22>0,APEX!C22,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(C23>0,VLOOKUP(C23, $I$4:$K$10, 2, FALSE),\"\")+IF(F23=\"PA\",100,0),\"\")","v":""},"",{"$f":"IF(C23>0,APEX!C23,\"\")","v":""}]
[null,{"$f":"SUM(B4:B23)","v":50000},{"$f":"SUM(C4:C23)","v":50000},{"$f":"SUM(D4:D23)","v":3000},{"$f":"SUM(E4:E23)","v":2500}]
[null,null,"Eval Target",{"$f":"SUMIFS(D4:D23, F4:F23, \"EVAL\")","v":3000},{"$f":"COUNTIF(F4:F23, \"EVAL\")","v":1}]
[null,"Accounts","PA Target",{"$f":"SUMIFS(E4:E23, F4:F23, \"PA\")+COUNTIF(F4:F23, \"PA\")*600","v":0},{"$f":"COUNTIF(F4:F23, \"PA\")","v":0}]
[null,{"$f":"COUNT(B4:B23)","v":1}]