{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Список турниров"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Список турниров","index":0,"n_rows":132,"n_cols":10,"rows_kept":132,"cut":false,"hidden":false,"merged":[[18,7,18,8],[18,1,18,2],[4,1,4,2],[65,4,65,5],[65,0,65,2]],"flags":["formulas_cached_only"]}
[]
[null,null,"Ячейки, данные в которых меняются"]
[null,null,"Ячейки с формулами, их лучше не трогать"]
[]
[null,"Список турниров:"]
["№№ п.п.","Время","ID турнира","БИ*","Информация","Место","Выигрыш","Остаток (несделанные ребаи или аддоны)","Дополнительный заработок (нокауты или кэшауты)","Общий выигрыш турнира"]
[1,"2012-04-22","PokerFest #1",215,{"$nulls":5},0]
[2,"2012-04-23","PokerFest #7",205,{"$nulls":5},0]
[3,"2012-04-25","PokerFest #13",99,{"$nulls":5},0]
[4,"2012-04-27","PokerFest #19",279,{"$nulls":5},0]
[5,"2012-04-28","PokerFest #22",99,{"$nulls":5},0]
[6,"2012-04-29","PokerFest #23",215,{"$nulls":5},0]
[7,"2012-04-30","PokerFest #29",205,{"$nulls":5},0]
[8,"2012-05-02","PokerFest #35",55,{"$nulls":5},0]
[9,"2012-05-03","PokerFest #38",155,{"$nulls":5},0]
[10,"2012-05-04","PokerFest #41",279,{"$nulls":5},0]
[11,"2012-05-05","PokerFest #44",215,{"$nulls":5},0]
[12,"2012-05-06","PokerFest #47",640,{"$nulls":5},0]
[null,"Сумма БИ",null,2661,null,null,null,"Общий профит сессии",null,0]
["*если турнир с ребаями, в ячейку пишем БИ с учетом ребаев и аддонов, или, например, \"=22+20+20\""]
["В этой таблице не обязательно вбивать все ячейки (главное указать \"БИ\" и \"Выигрыш\", т.к. они учитываются в дальнейших расчетах)"]
[]
[null,"Стоимость сессии:"]
[]
[null,"Сумма БИ",2661]
[null,"Округленная стоимость БИ**",2661]
[null,"** стоимость округляется вверх (например 181,2 округлиться до 182)"]
[]
[null,"Коэф:",1.1]
[]
[null,"Стоимость долей:"]
[null,"%","$","$ с коф."]
[null,1,26.61,29.28]
[null,2,53.22,58.55]
[null,2.5,66.53,73.18]
[null,3,79.83,87.82000000000001]
[null,5,133.05,146.35999999999999]
[null,10,266.1,292.71]
[null,15,399.15,439.07]
[null,20,532.2,585.42]
[null,"Список процентов можете менять по своему усмотрению (на подсчеты это никак не влияет)"]
[]
[null,"Дольщики:"]
[]
["№№ п.п.","Ник в покерруме","Ник на форуме PokerStrategy","Доля в %","Оплата***","Доля в $","Доход после сессии (без БИ)","Общая доля (к переводу)"]
[1,"com4com\\888","com4com",3,null,87.82000000000001,"","`"]
[2,"BuYakov\\Pokerstars","BuYakov",2,58.55,58.55,-58.55,0]
[3,{"$nulls":4},0,"",""]
[4,{"$nulls":4},0,"",""]
[5,{"$nulls":4},0,"",""]
[6,{"$nulls":4},0,"",""]
[7,{"$nulls":4},0,"",""]
[8,{"$nulls":4},0,"",""]
[9,{"$nulls":4},0,"",""]
[10,{"$nulls":4},0,"",""]
[11,{"$nulls":4},0,"",""]
[12,{"$nulls":4},0,"",""]
[13,{"$nulls":4},0,"",""]
[14,{"$nulls":4},0,"",""]
[15,{"$nulls":4},0,"",""]
[16,{"$nulls":4},0,"",""]
[17,{"$nulls":4},0,"",""]
[18,{"$nulls":4},0,"",""]
[19,{"$nulls":4},0,"",""]
[20,{"$nulls":4},0,"",""]
["Долей продано",null,null,5,"Всего к переводу",null,null,0]
[]
["*** в столбце можно ставить любые значки или писать пометки о брони, оплате"]
["*** зеленый - оплачено, желтый - бронь"]
[]
[null,"Итоги сессии:"]
[]
[null,"Количество ИТМ:",0]
[null,"Профит сессии:",0]
[null,"Чистый профит:",0]
[null,"ROI сессии:",-1]
[null,"Мой доход:",13.305000000000012]
[null,"Доход игроков:",-58.55]
[null,"Выплаты игрокам:",0]
[]
[]
[null,"Выплаты:"]
[]
[null,"Для форума:"]
["№№ п.п.","Ник на форуме PokerStrategy","К выплате"]
[1,"com4com","`"]
[2,"BuYakov",0]
[3,"",""]
[4,"",""]
[5,"",""]
[6,"",""]
[7,"",""]
[8,"",""]
[9,"",""]
[10,"",""]
[11,"",""]
[12,"",""]
[13,"",""]
[14,"",""]
[15,"",""]
[16,"",""]
[17,"",""]
[18,"",""]
[19,"",""]
[20,"",""]
["Если не отображается чья-то доля, то проверьте вбит ли его \"ник на форуме Pokerstrategy\" в таблице \"Дольщики\""]
["Зеленый - выплачено"]
[]
[null,"Для оплаты в руме:"]
["№№ п.п.","Ник в покерруме","К выплате"]
[1,"com4com\\888","`"]
[2,"BuYakov\\Pokerstars",0]
[3,"",""]
[4,"",""]
[5,"",""]
[6,"",""]
[7,"",""]
[8,"",""]
[9,"",""]
[10,"",""]
[11,"",""]
[12,"",""]
[13,"",""]
[14,"",""]
[15,"",""]
[16,"",""]
[17,"",""]
[18,"",""]
[19,"",""]
[20,"",""]
["Если не отображается чья-то доля, то проверьте вбит ли его \"ник в покерруме\" в таблице \"Дольщики\""]
["Зеленый - выплачено"]