{smcl} {* *! version 1.22 25jan2013}{...} {cmd:help xls2row} {right: ({browse "http://web.missouri.edu/~kolenikovs/stata/":Stas Kolenikov's webpage})} {hline} {title:Title} {p2colset 5 12 14 2}{...} {p2col :{hi:xls2row} {hline 2}}Convert a range of cells of an Excel file to {cmd:ipfraking}-compatible matrix{p_end} {p2colreset}{...} {title:Syntax} {p 8 11 2} {cmd:xls2row }{it:matrix_name}{cmd: using }{it:filename} [{cmd:,} {it:options}] {synoptset 43 tabbed}{...} {synopthdr} {synoptline} {synopt :{cmd:cellrange()}}range of cells in Excel file, e.g., B2:D15{p_end} {synopt :{cmd:sheet()}}the name of the sheet in Excel file to take values from{p_end} {synopt :{cmd:over(}{it:varname}{cmd:)}}label the columns of the resulting row vector with the values of {it:varname}{p_end} {synopt :{cmd:scale(}{it:#}{cmd:)}}scale the entries of the row vector so that they sum up to the specified value{p_end} {title:Description} {pstd}{cmd:xls2row} is a utility program in {cmd:ipfraking} package that reads the calibration totals from an Excel file and stores them in the matrix {it:matrix_name}. The name of the Excel file, the range of cells and the name of the sheet to take the values from are required. Mathematically speaking, {cmd:xls2row} performs a vec-transformation of the matrix, i.e., stores the result by columns. The rowname of the resulting matrix is the convention name {cmd:_one}. {p_end} {pstd}CAUTION: {cmd:xls2row} relies on {help preserve} as an intermediate step. It is advisable to run {cmd:xls2row} upfront before loading potentially large datasets that would otherwise be written to disk and restored back a number of times.{p_end} {title:Author} {pstd}Stanislav Kolenikov{p_end} {pstd}Senior Survey Statistician{p_end} {pstd}Abt SRBI{p_end} {pstd}skolenik at gmail dot com{p_end} {title:Also see} {psee}{help import excel}, {help matrix rownames}, {help ipfraking} if installed.