<html><head></head><body>Limited response<br><br>Sajitha,<br>We should fill in the google doc. Resequencing we will be doing anytime we want to see the data from a different perspective. It is ok.<br><br>Archana the elist works like a Google group. <br>-- <br>Sent from my mobile phone. Please excuse brevity and errors. <br><br><div class="gmail_quote">On August 2, 2021 11:28:17 PM GMT+05:30, Archana Mehendale <mehendalearchana@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr">Hi Sajitha,<div><br></div><div>The spreadsheet you've shared looks good to start with and I am okay with either working offline or on Google Sheet.</div><div><br></div><div>Regarding the ORF study, I agree, let us first look at actual studies and look at the literature reviews separately, if required.</div><div><br></div><div>@ all - Instead of replying to Sajitha's email, I have copied it below and am sending this to the group id which Guru has created. But Guru, I am not sure if this works like Google-groups where messages are distributed to all members, including the sender.<br></div><div><br></div><div>Thank you,</div><div>Archana</div><div><br><div>----</div><div> Hi Archana and colleagues<div><br></div><div>Here is the revised Excel file with one example, using the Oxfam study. </div><div>Explanatory notes: </div><div>I put 13 categories , Col G (there is a drop down menu, which is linked to the second work sheet). I think this carries the major issues we would want to cover,but we can add a few more if we wish (I don't think we shoudl exceed 15). If the study did not cover that issue, I left ithe cell blank. </div><div><br></div><div>In Col H, I tried to identify sub-categories for some of the main categories (also with a drop down menu but I am not yet sure that they are exhaustive/ meaningful. We will have to see after we categorize a few studies. For this example, I have used the sub-cateogry to identify the MAIN thing that the report talks about.</div><div><br></div><div>In Col I, I have put the main findings which relate to the Category / issue in Col G. </div><div><br></div><div>If this is a good working model, we can start with this. </div><div><br></div><div>A few other questions:</div><div><br></div><div><b>Archana</b> - I tried to use the Observer Research Foundation article you had "alllotted" to me, but as it is itself a review of several articles, it would not be appropriate to put its "findings" in this format. So, I suggest we use this excel file for unique studies, not reviews of studies For the review articles, it is probably best to prepare a one page summary . Is that okay? (Also, I did not find the ORF review very illuminating, and it often used newspaper articles to reference studies, which was disconcerting, to say the least. Ours should be sharper and have a clear narrative). I will go through the ones you have suggested.<br></div><div><br></div><div><b>Guru</b> - please advise what is the best way for us to enter the studies. If we do it directly on a Googlesheet, there will be a problem of re-organizing the studies in some sequence. If we each work on our separate files to summarize the studies allocated by Archana, can someone put them together in an order (eg chronological or type of study)</div><div><br style="color:rgb(29,34,40);font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px"></div></div></div></div>
</blockquote></div></body></html>