I fill gaps with my own data in the sheet. For growth i normally take the average analyst growth projection over the past 5 years, because this value often fluctuates a lot over the years, i also cap growth at 10% for my calculations, because even that is often not sustainable. 7-8% is the range that most quality companies can sustain over a long period, so thats my go to if i get N/A's. Dividend growth of the past several years is also a good predictor if that number is low. In the end i try to get an average growth rate that makes sense for the next 5 years and typically its very conservative.
Valuation change is either the mean of the past several years (i try to go back 5-10 years if growth has not come down massively since then) or a number that i think is appropriate. I try to average several numbers here, like fair value bases on P/E, EV/EBITDA, Bookvalue and dividend yield. For financials or cyclical stocks for example (0.434+RoE*14.12) is a good estimation of its fair value. (got that number from a book, where RoE is past 5 years average). But you can go on gurufocus.com and get a reasonable average from there. For very defensive stocks like PEP, KO, MDLZ i take upper limits of value, otherwise you will never get high enough estimated returns on them. But they often return to these numbers faster than "normal" companies.
https://companiesmarketcap.com/ is also a good free site to see what valuation metric is appropriate for a company.
Quality in my ranking is typically measured as a rank of last quarters RoE and gross profit/assets. Value in the ranking is a mix of EV/EBITDA, shareholder yield, EV/EBITDA projected 3 years in the future, FCF/Mktcap, P/E,P/B etc. Using several value metrics has improved returns over the past 20 years in the backtest.
My smallcap strategy is a system based on NCAV (liquidation value). You want companies that buyback shares or at least don't issue a lot of shares, and where NCAV is stable or growing. NCAV is a good proxy of liquidation value of a company, its typically the lowest value you can assign to a company with no earnings. You can basically liquidate the company and pull out that money. And it is very easy to calculate (net current assets-total liabilites-preferred equity)/shares outstanding.
So if a company also earns money, the true business value should be higher than NCAV. You will see a lot of takeovers in this segment, because companies are so cheap. Typically companies lose money when i buy them, but one quarter of earnings or cashflow or a takeover and the stock price shoots up. There are several books on this topic, for example Evan Bleeker's: Benjamin Graham’s Net-Net Stock Strategy. There are also some free papers on the performance of NCAV stocks in the net:
https://greenbackd.com/2010/01/21/monti ... -strategy/