{"text_format":"3","workbook":"xlsx","n_sheets":37,"sheets":["Arweiniad","List of Records Submitted","Engraifft o Gofnod","Register","Data","LEADER","Manylion y Prosiect","Cofnod 1","Cofnod 2","Cofnod 3","Cofnod 4","Cofnod 5","Cofnod 6","Cofnod 7","Cofnod 8","Cofnod 9","Cofnod 10","Cofnod 11","Cofnod 12","Cofnod 13","Cofnod 14","Cofnod 15","Cofnod 16","Cofnod 17","Cofnod 18","Cofnod 19","Cofnod 20","Cofnod 21","Cofnod 22","Cofnod 23","Cofnod 24","Cofnod 25","Cofnod 26","Cofnod 27","Cofnod 28","Cofnod 29","Cofnod 30"],"not_rendered":{"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"Arweiniad","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"merged":[[19,0,20,0]]}
["Angen Tystiolaeth o Dendro Cystadleuol - Canllawiau Cyffredinol"]
[]
["Pan fo eitem yn werth >£500 ond <£5,000 mae'n rhaid i chi gyflwyno (drwy WEFO Ar-lein): "]
["Cofnod Tendro Cystadleuol ar gyfer eitemau dros £500 a than £5,000"]
["Copi o 1 dyfynbris / anfoneb"]
[]
["Pan fo eitem yn werth £5,000 mae'n rhaid i chi gyflwyno (drwy WEFO Ar-lein):"]
["Cofnod Tendro Cystadleuol ar gyfer eitemau dros £5,000"]
["Copi o 3 dyfynbris "]
["* Sicrhewch fod modd cymharu dyfynbrisiau h.y. maent yn rhoi dyfynbris ar gyfer yr un nwyddau / gwasanaethau ac fe ddaethant i law tua'r un pryd"]
[]
[]
["Ar gyfer senarios lle bydd angen tystiolaeth bellach, cyflwynwch yr wybodaeth hon ynghyd â'ch Cofnod Tendro Cystadleuol a'ch dyfynbrisiau etc.:"]
["Sylwer: mae'r rhain yn enghreifftiau o'r math o dystiolaeth ychwanegol sydd ei hangen a gall y panel Tendro Cystadleuol ofyn am ragor o wybodaeth os oes angen"]
[]
["Senario","Y dystiolaeth sydd ei hangen"]
["Rydych wedi cael llai na 3 dyfynbris","Rhowch esboniad ynghylch pam y darparwyd llai na 3 dyfynbris - sut rydych wedi profi'r farchnad (ynghyd â thystiolaeth) etc., gall hyn fod drwy roi'r hysbyseb ar GwerthwchiGymru. Os felly, rhowch dystiolaeth o'r hysbyseb a nifer y dyfynbrisiau a gafwyd (sgrinlun o'r blwch post o dystiolaeth GwerthwchiGymru o'r ymatebion a gafwyd), a thystiolaeth o gyflenwyr yn gwrthod rhoi dyfynbris."]
["Mae'r eitem yn bwrpasol / arbenigol a dim ond un cyflenwr y gellir ei ddefnyddio","Rhowch esboniad pam mai'r cyflenwr yw'r unig gyflenwr y gellir ei ddefnyddio.  Rhowch dystiolaeth o ran sut rydych wedi profi'r farchnad."]
["Dewis peidio â defnyddio'r dyfynbris isaf","Rhowch esboniad pam na ddewiswyd y dyfynbris rhataf e.e. tystiolaeth o'r sgôr a roddwyd wrth asesu tendrau / dyfynbrisiau."]
["Defnyddio Fframwaith Caffael","Rhowch gopi o'r fframwaith caffael a thystiolaeth bod y cyflenwr a ddewiswyd yn rhan o'r fframwaith hwnnw\n"]
[null,"Rhowch dystiolaeth gan eich Tîm Caffael eich hun sy'n cadarnhau eich bod wedi dilyn rheolau Caffael Cyhoeddus y sefydliad."]
[]
[]
[]
["Beth i'w gwblhau ar y Tabiau Cofnod Tendro Cystadleuol"]
[]
["Dylech gyflwyno templed newydd bob tro y byddwch yn cyflwyno Gwybodaeth Tendro Cystadleuol (dim ond cofnodion ar gyfer yr eitemau rydych yn gofyn i ni eu hystyried ar yr achlysur hwnnw y dylech eu cynnwys)"]
[]
["Tab","Beth i'w gwblhau"]
["Cofnod - Enghraifft","Enghraifft yn unig yw hon"]
["Manylion y Prosiect","Llenwch Enw'r Ymgeisydd / Teitl y Prosiect / Rhif Cyfeirnod Cwsmer (CRN) / Rhif Adnabod / Prosiect LEADER  / Dyddiad Cwblhawyd y Ffurflen - bydd hyn wedyn yn llenwi'r cofnodion yn awtomatig lle bo'n briodol. "]
["Cofnod 1 i Gofnod 30","Bydd y Rhif Adnabod a Rhif Cyfeirnod Cwsmer (CRN) yn llenwi'n awtomatig.  Llenwch weddill y cofnod, gan lenwi'r holl flychau perthnasol."]

{"sheet":"List of Records Submitted","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4]]}
[]
["Applicant Name",{"$f":"'Manylion y Prosiect'!C3","v":0}]
["Project Title ",{"$f":"'Manylion y Prosiect'!C4","v":0}]
["CRN",{"$f":"'Manylion y Prosiect'!C5","v":0}]
["Case ID",{"$f":"'Manylion y Prosiect'!C6","v":0}]
["LEADER project",{"$f":"'Manylion y Prosiect'!C7","v":0}]
["Date Form Submitted",{"$f":"'Manylion y Prosiect'!C8","v":0}]
[]
["Date Record Submitted","Record Reference","Item Reference","Item Value","CT Panel Decision Required","Reason",null,"Panel Code"]
[{"$f":"IF(D10=\"\",\"\",$B$7)","v":""},{"$f":"IF(D10=\"\",\"\",G10)","v":""},{"$f":"IF(D10=\"\",\"\",IFERROR(INDIRECT(\"'\"&G10&\"'!$B$9\"),\"\"))","v":""},{"$f":"IF((INDIRECT(\"'\"&G10&\"'!$B$24\"))=\"\",\"\",INDIRECT(\"'\"&G10&\"'!$B$24\"))","v":""},{"$f":"IF(D10=\"\",\"\",IF(F10=\"\",\"No\",\"Yes\"))","v":""},{"$f":"IFERROR((IF(D10<5000,(VLOOKUP(H10,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H10,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 1",{"$f":"IFERROR(INDIRECT(\"'\"&G10&\"'!$F$27\"),\"\")","v":""}]
[{"$f":"IF(D11=\"\",\"\",$B$7)","v":""},{"$f":"IF(D11=\"\",\"\",G11)","v":""},{"$f":"IF(D11=\"\",\"\",IFERROR(INDIRECT(\"'\"&G11&\"'!$B$9\"),\"\"))","v":""},{"$f":"IF((INDIRECT(\"'\"&G11&\"'!$B$24\"))=\"\",\"\",INDIRECT(\"'\"&G11&\"'!$B$24\"))","v":""},{"$f":"IF(D11=\"\",\"\",IF(F11=\"\",\"No\",\"Yes\"))","v":""},{"$f":"IFERROR((IF(D11<5000,(VLOOKUP(H11,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H11,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 2",{"$f":"IFERROR(INDIRECT(\"'\"&G11&\"'!$F$27\"),\"\")","v":""}]
["","","","","",{"$f":"IFERROR((IF(D12<5000,(VLOOKUP(H12,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H12,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 3",{"$f":"IFERROR(INDIRECT(\"'\"&G12&\"'!$F$27\"),\"\")","v":""}]
["","","","","",{"$f":"IFERROR((IF(D13<5000,(VLOOKUP(H13,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H13,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 4",""]
["","","","","",{"$f":"IFERROR((IF(D14<5000,(VLOOKUP(H14,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H14,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 5",""]
["","","","","",{"$f":"IFERROR((IF(D15<5000,(VLOOKUP(H15,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H15,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 6",""]
["","","","","",{"$f":"IFERROR((IF(D16<5000,(VLOOKUP(H16,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H16,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 7",""]
["","","","","",{"$f":"IFERROR((IF(D17<5000,(VLOOKUP(H17,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H17,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 8",""]
["","","","","",{"$f":"IFERROR((IF(D18<5000,(VLOOKUP(H18,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H18,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 9",""]
["","","","","",{"$f":"IFERROR((IF(D19<5000,(VLOOKUP(H19,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H19,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 10",""]
["","","","","",{"$f":"IFERROR((IF(D20<5000,(VLOOKUP(H20,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H20,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 11",""]
["","","","","",{"$f":"IFERROR((IF(D21<5000,(VLOOKUP(H21,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H21,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 12",""]
["","","","","",{"$f":"IFERROR((IF(D22<5000,(VLOOKUP(H22,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H22,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 13",""]
["","","","","",{"$f":"IFERROR((IF(D23<5000,(VLOOKUP(H23,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H23,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 14",""]
["","","","","",{"$f":"IFERROR((IF(D24<5000,(VLOOKUP(H24,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H24,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 15",""]
["","","","","",{"$f":"IFERROR((IF(D25<5000,(VLOOKUP(H25,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H25,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 16",""]
["","","","","",{"$f":"IFERROR((IF(D26<5000,(VLOOKUP(H26,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H26,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 17",""]
["","","","","",{"$f":"IFERROR((IF(D27<5000,(VLOOKUP(H27,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H27,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 18",""]
["","","","","",{"$f":"IFERROR((IF(D28<5000,(VLOOKUP(H28,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H28,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 19",""]
["","","","","",{"$f":"IFERROR((IF(D29<5000,(VLOOKUP(H29,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H29,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 20",""]
["","","","","",{"$f":"IFERROR((IF(D30<5000,(VLOOKUP(H30,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H30,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 21",""]
["","","","","",{"$f":"IFERROR((IF(D31<5000,(VLOOKUP(H31,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H31,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 22",""]
["","","","","",{"$f":"IFERROR((IF(D32<5000,(VLOOKUP(H32,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H32,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 23",""]
["","","","","",{"$f":"IFERROR((IF(D33<5000,(VLOOKUP(H33,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H33,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 24",""]
["","","","","",{"$f":"IFERROR((IF(D34<5000,(VLOOKUP(H34,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H34,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 25",""]
["","","","","",{"$f":"IFERROR((IF(D35<5000,(VLOOKUP(H35,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H35,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 26",""]
["","","","","",{"$f":"IFERROR((IF(D36<5000,(VLOOKUP(H36,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H36,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 27",""]
["","","","","",{"$f":"IFERROR((IF(D37<5000,(VLOOKUP(H37,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H37,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 28",""]
["","","","","",{"$f":"IFERROR((IF(D38<5000,(VLOOKUP(H38,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H38,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 29",""]
["","","","","",{"$f":"IFERROR((IF(D39<5000,(VLOOKUP(H39,Data!$J$27:$K$32,2,FALSE)),(VLOOKUP(H39,Data!$J$18:$K$24,2,FALSE)))),\"\")","v":""},"Cofnod 30",""]
[null,"Register Link"]

{"sheet":"Engraifft o Gofnod","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",123456]
["Rhif Cyfeirnod Cwsmer (CRN)","A012345678"]
["Categori'r Gwariant","Ystadau"]
["Math o Wariant","Paratoi Safle",{"$nulls":4},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":"opt3_"}]
["Cyfalaf / Refeniw","Gwirioneddol"]
["Manylion yr Eitem","Gwaith ar sylfaen yr adeilad"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)","123-001"]
["Cost yr Eitem",{"v":35000,"d":"£35,000"}]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect.","Dim yn un o'r partneriaid"]
["Nifer o ddyfynbrisiau sydd ei angen","3 dyfynbris ysgrifenedig"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru","Ydy"]
["Eitem wedi ei brynu","Ydy"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr","James Ltd, 1 The Lane, Cymru \n","Harriet Ltd, 1 The Road, Cymru\n","Other Ltd, 1 The Street, Cymru \n"]
["Dyddiad (a dull) y cyswllt","Wedi e-bostio’r fanyleb a’r cais am ddyfynbris ar 01/01/2018 (gweler yr e-bost ynghlwm).","Wedi e-bostio’r fanyleb a’r cais am ddyfynbris ar 01/01/2018 (gweler yr e-bost ynghlwm).","Wedi e-bostio’r fanyleb a’r cais am ddyfynbris ar 01/01/2018 (gweler yr e-bost ynghlwm).",null,"Is there coflict of interest?"]
["Gwrthdaro Buddiannau","Dim Gwrthdaro","Dim Gwrthdaro","Dim Gwrthdaro",null,{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)",123456,123456,123456]
["Dyddiad y Dyfynbris ","2021-07-01","2021-07-01","2021-07-01"]
["Meini Prawf Asesu ","• Yn bodloni’r fanyleb \n• Pris","• Yn bodloni’r fanyleb \n• Pris","• Yn bodloni’r fanyleb \n• Pris",null,"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"v":35000,"d":"£35,000"},{"v":40000,"d":"£40,000"},{"v":37000,"d":"£37,000"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod ","Yn bodloni’r fanyleb, ac y dyfynbris rhataf.","Yn bodloni’r fanyleb ond nid y dyfynbris rhataf.","Yn bodloni’r fanyleb ond nid y dyfynbris rhataf."]
["Dyddiad y Llythyr Gwrthod neu Ddewis ","2021-08-30","2021-08-30","2021-08-30",null,"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Register","index":3,"n_rows":36,"n_cols":18,"rows_kept":36,"hidden":true,"merged":[[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16]]}
[]
[{"$nulls":9},"7. Procurement Tendering Completed",null,"8. Quote 1 (selected)",null,"9. Quote 2",null,"10. Quote 3",null,"Advertised on Sell2Wales"]
[null,"1. Category of expenditure","2. Type","3. Item detail\n(free text description of specific item)",null,null,"4. Actual/In Kind/Simplified","5. Item Reference","6. Item Cost","Yes/No/TBC","Type","Supplier","Value","Supplier","Value","Supplier","Value","Yes/No"]
["Cofnod 1",{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$5\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$5\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$6\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$6\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$8\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$8\")))","v":""},null,null,{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$7\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$7\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$9\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$9\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$24\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$24\")))","v":""},{"$f":"IF(I4=\"\",\"\",\"Yes\")","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$12\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$12\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$17\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$17\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$24\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$24\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$C$17\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$C$17\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$C$24\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$C$24\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$D$17\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$D$17\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$D$24\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$D$24\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A4&\"'!$B$13\"))=\"\",\"\",(INDIRECT(\"'\"&A4&\"'!$B$13\")))","v":""}]
["Cofnod 2",{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$5\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$5\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$6\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$6\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$8\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$8\")))","v":""},null,null,{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$7\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$7\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$9\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$9\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$24\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$24\")))","v":""},{"$f":"IF(I5=\"\",\"\",\"Yes\")","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$12\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$12\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$17\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$17\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$24\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$24\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$C$17\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$C$17\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$C$24\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$C$24\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$D$17\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$D$17\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$D$24\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$D$24\")))","v":""},{"$f":"IF((INDIRECT(\"'\"&A5&\"'!$B$13\"))=\"\",\"\",(INDIRECT(\"'\"&A5&\"'!$B$13\")))","v":""}]
["Cofnod 3","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 4","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 5","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 6","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 7","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 8","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 9","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 10","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 11","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 12","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 13","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 14","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 15","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 16","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 17","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 18","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 19","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 20","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 21","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 22","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 23","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 24","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 25","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 26","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 27","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 28","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 29","","","",null,null,"","","","","","","","","","","",""]
["Cofnod 30","","","",null,null,"","","","","","","","","","","",""]
[{"$nulls":11},"Copy and paste this section only using paste values."]
[]
[{"$nulls":11},"","","","","","",""]

{"sheet":"Data","index":4,"n_rows":138,"n_cols":30,"rows_kept":138,"hidden":true}
[{"$nulls":18},"Accommodation","Administration","Estates","HR","ICT","Legal & Professional","Marketing & Promotion","Overheads","Staff","Travel & Transport (used for project staff expense claims)","Plant Machinery & Other Equipment","Irrecoverable VAT"]
[null,"Llety","Eligible under - Revenue A, Capital B, Both D",null,"Refeniw","1 dyfynbris ysgrifenedig",{"$nulls":12},"opt1","opt2","opt3","opt4","opt5","opt6","opt7","opt8","opt9","opt10","opt11","opt12"]
["Accommodation","Yswiriant Adeiladau","A","Llety","Cyfalaf","3 dyfynbris ysgrifenedig",{"$nulls":3},"A","B","D",{"$nulls":6},"Yswiriant Adeiladau","Gwasanaethau Canolog","Cynllunio a Rheoli","Recriwtio","Telegyfathrebiadau Gweithredol","Costau Achredu","Hysbysebu a Hyrwyddo","Gorbenion","Costau Cyflog Net","Danfoniadau","Gosodiadau a Ffitiadau","TAW cost prosiect nad yw'r ymgeisydd yn gallu ei hadennill"]
["Accommodation","Atgyweirio Adeiladau ","A","Llety",null,"Caffael Cyhoeddus",null,null,"Actual","Revenue - Actual","Capital - Actual","Revenue - Actual",{"$nulls":6},"Atgyweirio Adeiladau ","Defnyddiau traul","Materion a Gwelliannau Amgylcheddol","Hyfforddiant","Atgyweirio Cyfrifiaduron","Taliadau Banc a Chyflogres","Celf a Dylunio",null,"Cyfraniadau pensiwn","Tanwydd","Prynu Offer a Pheiriannau"]
["Accommodation","Sbwriel, Glanhau a Golchdy","A","Llety",null,"MIS (under £500 each)",null,null,"In Kind","Revenue - In Kind","Capital - In Kind","Revenue - In Kind",{"$nulls":6},"Sbwriel, Glanhau a Golchdy","Prydlesi Cyfarpar (nid yw elw a wneir yn gymwys)","Tirlunio","Cyrsiau Hyfforddi","Cynnal a Chadw Cyfrifiaduron","Ffioedd Ymgynghori","Digwyddiadau Busnes ",null,"Cyfraniadau Yswiriant Gwladol Cyflogwyr","Yswiriant a Threth","Prynu Offer Swyddfa"]
["Accommodation","Trydan","A","Llety",null,"Ydy",{"$nulls":5},"Capital - Actual",{"$nulls":6},"Trydan","Ffacs","Rhagbaratoadau ","Deunyddiau Hyfforddi","Cronfeydd Data","Cost Cyllid","Gweithgareddau Cymunedol",null,"Manteision Cytundebol","Milltiredd","Costau gosod sy'n gysylltiedig â phrynu Gosodiadau a Ffitiadau"]
["Accommodation","Nwy ac Olew","A","Llety",null,"Nac ydy",{"$nulls":5},"Capital - In Kind",{"$nulls":6},"Nwy ac Olew","Yswiriant","Adeiladau","Taliadau Diswyddo ","Gwasanaethau e-Fasnach","Llog sy'n Daladwy","Confensiynau",null,null,"Chynhaliaeth","Costau gosod sy'n gysylltiedig â phrynu Offer a Pheiriannau"]
["Accommodation","Ardrethi","A","Llety",null,"TBC",{"$nulls":12},"Ardrethi","Cyfnodolion, Cyfeirlyfrau  a Chyhoeddiadau","Prynu Adeiladau","Tâl Salwch Statudol","Defnyddiau traul TGCh","Yswiriant","Adloniant",null,null,"Teithio"]
["Accommodation","Rhent","A","Llety",{"$nulls":14},"Rhent","Ffonau Symudol","Costau Adeiladu","Tâl Mamolaeth Statudol","Rhentu Offer TGCh (nid yw elw a wneir yn gymwys)","Gwasanaethau Caffael ","Digwyddiadau a Gwobrau",null,null,"Lletygarwch"]
["Accommodation","Atgyweirio","A","Llety",{"$nulls":14},"Atgyweirio","Llungopïo","Seilwaith",null,"Costau Rhyngrwyd","Ffioedd Cyfreithiol a Phroffesiynol","Arddangosfeydd a Chynadleddau",null,null,"Teithio a Chynhaliaeth"]
["Accommodation","Llogi Ystafelloedd","A","Llety",null,"Programme",{"$nulls":12},"Llogi Ystafelloedd","Postio","Costau Gosod",null,"Trwyddedau","Ffioedd Rheoli","Gwybodaeth a Chyngor",null,null,"Prydlesu Cerbydau (nid yw elw a wneir yn gymwys)"]
["Accommodation","Diogelwch","A","Llety",null,"Case",{"$nulls":12},"Diogelwch","Offer Swyddfa","Prynu Tir hyd at 10% o gost y prosiect",null,"Rhentu Llinell","Tanysgrifiadau","Marchnata a Hyrwyddo",null,null,"Costau Rhedeg Cerbydau"]
["Accommodation","Biliau Dŵr ","A","Llety",{"$nulls":14},"Biliau Dŵr ","Ffôn","Prydlesu Eiddo  ",null,"Telegyfathrebiadau Goddefol","Astudiaethau","Costau Cyfryngau "]
["Accommodation","Cyfleustodau","A","Llety",{"$nulls":14},"Cyfleustodau",null,"Ffioedd Proffesiynol sy'n gysylltiedig â phrynu tir ac adeiladau",null,"Meddalwedd","Caffael patentau, trwyddedau, hawlfreintiau, nodau masnach","Cyfarfodydd a Chynadleddau"]
[null,"Gweinyddu",{"$nulls":18},"Darparu Gwasanaethau",null,"Datblygu Meddalwedd","Ffioedd, Penseiri, Peirianwyr ac Ymgynghorwyr a Ffioedd","Nwyddau a Brandio"]
["Administration","Gwasanaethau Canolog","A","Gweinyddu",null,"Lists",{"$nulls":7},"1. Category of expenditure",{"$nulls":6},"Archwilio Safleoedd",null,"Trwyddedau Meddalwedd","Ffioedd Proffesiynol sy'n gysylltiedig â phrynu tir ac adeiladau","Gwaith Partneriaeth"]
["Administration","Defnyddiau traul","A","Gweinyddu",null,"1 dyfynbris ysgrifenedig","Yes","Ydy",{"$nulls":5},"Llety","opt1_",{"$nulls":5},"Paratoi Safle",null,"Prynu ac Uwchraddio Meddalwedd","Archwiliadau Safle","Cysylltiadau Cyhoeddus ac Argraffu"]
["Administration","Prydlesi Cyfarpar (nid yw elw a wneir yn gymwys)","A","Gweinyddu",null,"3 dyfynbris ysgrifenedig","Not Required","Nac ydy",null,{"$f":"\"1\"","v":"1"},"Conflict of Interest",null,null,"Gweinyddu","opt2_",{"$nulls":5},"Gwaith Safle",null,"Cymorth","Costau Dylunio Technegol","Argraffu a Reprograffeg"]
["Administration","Ffacs","A","Gweinyddu",null,"Caffael Cyhoeddus","TBC","Yes with 10% Penalty",null,{"$f":"\"2\"","v":"2"},"Cheapest quote not Selected",null,null,"Ystadau","opt3_",{"$nulls":5},"Osodedig (Turnkey)",null,"Gweinyddu Gwefannau",null,"Cyhoeddusrwydd"]
["Administration","Yswiriant","A","Gweinyddu",null,"MIS (under £500 each)",null,"Yes with 25% Penalty",null,{"$f":"\"3\"","v":"3"},"Less than 3 quotes obtained",null,null,"Adnoddau dynol","opt4_",{"$nulls":7},"Costau Gwefannau ",null,"Ymchwil"]
["Administration","Cyfnodolion, Cyfeirlyfrau  a Chyhoeddiadau","A","Gweinyddu",{"$nulls":5},{"$f":"\"4\"","v":"4"},"Conflict of Interest / Cheapest quote not selected ",null,null,"TGCH","opt5_",{"$nulls":7},"Prynu Caledwedd",null,"Cyfieithiadau a Phrawfddarllen"]
["Administration","Ffonau Symudol","A","Gweinyddu",{"$nulls":5},{"$f":"\"5\"","v":"5"},"Conflict of Interest / Less than 3 quotes obtained",null,null,"Cyfreithiol a Phroffesiynol","opt6_"]
["Administration","Llungopïo","A","Gweinyddu",null,"Dim Gwrthdaro",{"$nulls":3},{"$f":"\"6\"","v":"6"},"Conflict of Interest / Cheapest quote not selected / Less than 3 quotes obtained",null,null,"Marchnata a Hyrwyddo","opt7_"]
["Administration","Postio","A","Gweinyddu",null,"Oes",{"$nulls":3},{"$f":"\"7\"","v":"7"},"Cheapest quote not Selected / Less than 3 quotes obtained",null,null,"Gorbenion","opt8_"]
["Administration","Offer Swyddfa","A","Gweinyddu",{"$nulls":9},"Staff","opt9_"]
["Administration","Ffôn","A","Gweinyddu",{"$nulls":9},"Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)","opt10_"]
[null,"Estates",{"$nulls":7},{"$f":"\"1\"","v":"1"},"Conflict of Interest",null,null,"Offer, Peiriannau a Chyfarpar Arall","opt11_"]
["Estates","Cynllunio a Rheoli","D","Ystadau",{"$nulls":5},{"$f":"\"2\"","v":"2"},"Cheapest quote not Selected",null,null,"TAW na ellir ei hadennill","opt12_"]
["Estates","Materion a Gwelliannau Amgylcheddol","A","Ystadau",{"$nulls":5},{"$f":"\"4\"","v":"4"},"Conflict of Interest / Cheapest quote not selected "]
["Estates","Tirlunio","A","Ystadau",{"$nulls":5},{"$f":"\"5\"","v":"5"},"Conflict of Interest"]
["Estates","Rhagbaratoadau ","D","Ystadau",{"$nulls":5},{"$f":"\"6\"","v":"6"},"Conflict of Interest / Cheapest quote not selected "]
["Estates","Adeiladau","B","Ystadau",{"$nulls":5},{"$f":"\"7\"","v":"7"},"Cheapest quote not Selected"]
["Estates","Prynu Adeiladau","B","Ystadau"]
["Estates","Costau Adeiladu","B","Ystadau"]
["Estates","Seilwaith","B","Ystadau"]
["Estates","Costau Gosod","B","Ystadau"]
["Estates","Prynu Tir hyd at 10% o gost y prosiect","B","Ystadau"]
["Estates","Prydlesu Eiddo  ","B","Ystadau"]
["Estates","Ffioedd Proffesiynol sy'n gysylltiedig â phrynu tir ac adeiladau","B","Ystadau"]
["Estates","Darparu Gwasanaethau","D","Ystadau"]
["Estates","Archwilio Safleoedd","D","Ystadau"]
["Estates","Paratoi Safle","D","Ystadau"]
["Estates","Gwaith Safle","D","Ystadau"]
["Estates","Osodedig (Turnkey)","B","Ystadau"]
[null,"HR"]
["HR","Recriwtio","A","Adnoddau dynol"]
["HR","Hyfforddiant","A","Adnoddau dynol"]
["HR","Cyrsiau Hyfforddi","A","Adnoddau dynol"]
["HR","Deunyddiau Hyfforddi","A","Adnoddau dynol"]
["HR","Taliadau Diswyddo ","A","Adnoddau dynol"]
["HR","Tâl Salwch Statudol","A","Adnoddau dynol"]
["HR","Tâl Mamolaeth Statudol","A","Adnoddau dynol"]
[null,"ICT"]
["ICT","Telegyfathrebiadau Gweithredol","A","TGCH"]
["ICT","Atgyweirio Cyfrifiaduron","A","TGCH"]
["ICT","Cynnal a Chadw Cyfrifiaduron","A","TGCH"]
["ICT","Cronfeydd Data","A","TGCH"]
["ICT","Gwasanaethau e-Fasnach","A","TGCH"]
["ICT","Defnyddiau traul TGCh","A","TGCH"]
["ICT","Rhentu Offer TGCh (nid yw elw a wneir yn gymwys)","A","TGCH"]
["ICT","Costau Rhyngrwyd","A","TGCH"]
["ICT","Trwyddedau","A","TGCH"]
["ICT","Rhentu Llinell","A","TGCH"]
["ICT","Telegyfathrebiadau Goddefol","A","TGCH"]
["ICT","Meddalwedd","A","TGCH"]
["ICT","Datblygu Meddalwedd","D","TGCH"]
["ICT","Trwyddedau Meddalwedd","D","TGCH"]
["ICT","Prynu ac Uwchraddio Meddalwedd","D","TGCH"]
["ICT","Cymorth","A","TGCH"]
["ICT","Gweinyddu Gwefannau","A","TGCH"]
["ICT","Costau Gwefannau ","A","TGCH"]
["ICT","Prynu Caledwedd","B","TGCH"]
[null,"Legal & Professional"]
[null,"Costau Achredu","A","Cyfreithiol a Phroffesiynol"]
[null,"Taliadau Banc a Chyflogres","A","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Ymgynghori","A","Cyfreithiol a Phroffesiynol"]
[null,"Cost Cyllid","A","Cyfreithiol a Phroffesiynol"]
[null,"Llog sy'n Daladwy","A","Cyfreithiol a Phroffesiynol"]
[null,"Yswiriant","A","Cyfreithiol a Phroffesiynol"]
[null,"Gwasanaethau Caffael ","A","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Cyfreithiol a Phroffesiynol","A","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Rheoli","A","Cyfreithiol a Phroffesiynol"]
[null,"Tanysgrifiadau","A","Cyfreithiol a Phroffesiynol"]
[null,"Astudiaethau","A","Cyfreithiol a Phroffesiynol"]
[null,"Caffael patentau, trwyddedau, hawlfreintiau, nodau masnach","B","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd, Penseiri, Peirianwyr ac Ymgynghorwyr a Ffioedd","B","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Proffesiynol sy'n gysylltiedig â phrynu tir ac adeiladau","B","Cyfreithiol a Phroffesiynol"]
[null,"Archwiliadau Safle","B","Cyfreithiol a Phroffesiynol"]
[null,"Costau Dylunio Technegol","B","Cyfreithiol a Phroffesiynol"]
[null,"Marketing & Promotion_"]
[null,"Hysbysebu a Hyrwyddo","A","Marchnata a Hyrwyddo"]
[null,"Celf a Dylunio","A","Marchnata a Hyrwyddo"]
[null,"Digwyddiadau Busnes ","A","Marchnata a Hyrwyddo"]
[null,"Gweithgareddau Cymunedol","A","Marchnata a Hyrwyddo"]
[null,"Confensiynau","A","Marchnata a Hyrwyddo"]
[null,"Adloniant","A","Marchnata a Hyrwyddo"]
[null,"Digwyddiadau a Gwobrau","A","Marchnata a Hyrwyddo"]
[null,"Arddangosfeydd a Chynadleddau","A","Marchnata a Hyrwyddo"]
[null,"Gwybodaeth a Chyngor","A","Marchnata a Hyrwyddo"]
[null,"Marchnata a Hyrwyddo","A","Marchnata a Hyrwyddo"]
[null,"Costau Cyfryngau ","A","Marchnata a Hyrwyddo"]
[null,"Cyfarfodydd a Chynadleddau","A","Marchnata a Hyrwyddo"]
[null,"Nwyddau a Brandio","A","Marchnata a Hyrwyddo"]
[null,"Gwaith Partneriaeth","A","Marchnata a Hyrwyddo"]
[null,"Cysylltiadau Cyhoeddus ac Argraffu","A","Marchnata a Hyrwyddo"]
[null,"Argraffu a Reprograffeg","A","Marchnata a Hyrwyddo"]
[null,"Cyhoeddusrwydd","A","Marchnata a Hyrwyddo"]
[null,"Ymchwil","A","Marchnata a Hyrwyddo"]
[null,"Cyfieithiadau a Phrawfddarllen","A","Marchnata a Hyrwyddo"]
[null,"Overheads_"]
[null,"Gorbenion","A","Gorbenion"]
[null,"Staff"]
[null,"Costau Cyflog Net","A","Staff"]
[null,"Cyfraniadau pensiwn","A","Staff"]
[null,"Cyfraniadau Yswiriant Gwladol Cyflogwyr","A","Staff"]
[null,"Manteision Cytundebol","A","Staff"]
[null,"Travel & Transport (used for project staff expense claims)"]
[null,"Danfoniadau","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Tanwydd","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Yswiriant a Threth","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Milltiredd","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Chynhaliaeth","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Teithio","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Lletygarwch","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Teithio a Chynhaliaeth","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Prydlesu Cerbydau (nid yw elw a wneir yn gymwys)","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Costau Rhedeg Cerbydau","A","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Plant Machinery & Other Equipment"]
[null,"Gosodiadau a Ffitiadau","B","Offer, Peiriannau a Chyfarpar Arall"]
[null,"Prynu Offer a Pheiriannau","B","Offer, Peiriannau a Chyfarpar Arall"]
[null,"Prynu Offer Swyddfa","B","Offer, Peiriannau a Chyfarpar Arall"]
[null,"Costau gosod sy'n gysylltiedig â phrynu Gosodiadau a Ffitiadau","B","Offer, Peiriannau a Chyfarpar Arall"]
[null,"Costau gosod sy'n gysylltiedig â phrynu Offer a Pheiriannau","B","Offer, Peiriannau a Chyfarpar Arall"]
[null,"Flat Rate"]
[null,"Cost wedi'i symleiddio wedi'i gosod ar 15% o Gyfanswm Costau Staff ","A"]
[null,"Irrecoverable VAT"]
[null,"TAW cost prosiect nad yw'r ymgeisydd yn gallu ei hadennill","D","TAW na ellir ei hadennill"]
[null,"TOTAL to match Delivery Profile"]

{"sheet":"LEADER","index":5,"n_rows":124,"n_cols":32,"rows_kept":124,"hidden":true}
[{"$nulls":18},"Accommodation","Administration","Estates","Grants","HR","ICT","Legal & Professional","Marketing & Promotion","Overheads","Procurement","Staff","Travel & Transport (used for project staff expense claims)","Flat Rate","Irrecoverable VAT"]
[null,"Accommodation","Eligible under - Revenue A, Capital B, Both D",null,"Capital","1 written quote",{"$nulls":12},"opt13_","opt14_","opt15_","opt16_","opt17_","opt18_","opt19_","opt20_","opt21_","opt22_","opt23_","opt24_","opt25_","opt26_"]
["Accommodation","Yswiriant Adeiladau","D","Llety","Revenue","3 written quotes",{"$nulls":3},"A","B","D",{"$nulls":6},"Yswiriant Adeiladau","Gwasanaethau Canolog","Cynllunio a Rheoli","Grantiau (dim grantiau i fusnesau masnachol)","Recriwtio","Telegyfathrebiadau Gweithredol","Costau Achredu","Hysbysebu a Hyrwyddo","Gorbenion","Gweithgarwch Caffael","Costau cyflogau net","Danfoniadau","Cost syml yn sefydlog ar 15% o Gyfanswm Costau Staff ","TAW cost y prosiect nad oes modd i’r ymgeisydd ei adennill"]
["Accommodation","Atgyweirio Adeiladau ","D","Llety",null,"Public Procurement",{"$nulls":3},"Actual","Simplified","Gwirioneddol",{"$nulls":6},"Atgyweirio Adeiladau ","Defnyddiau traul","Materion a Gwelliannau Amgylcheddol",null,"Hyfforddiant","Atgyweirio Cyfrifiaduron","Taliadau Banc a Chyflogres","Celf a Dylunio",null,null,"Cyfraniadau pensiwn","Tanwydd"]
["Accommodation","Sbwriel, Glanhau a Golchdy","D","Llety",null,"MIS (under £500 each)",{"$nulls":5},"Mewn Nwyddau",{"$nulls":6},"Sbwriel, Glanhau a Golchdy","Prydlesi Cyfarpar (nid yw elw a wneir yn gymwys)","Tirlunio",null,"Cyrsiau Hyfforddi","Cynnal a Chadw Cyfrifiaduron","Ffioedd Ymgynghori","Digwyddiadau Busnes ",null,null,"Cyfraniadau Yswiriant Gwladol Cyflogwyr","Yswiriant a Threth"]
["Accommodation","Trydan","D","Llety",null,"Yes",{"$nulls":12},"Trydan","Ffacs","Rhagbaratoadau ",null,"Deunyddiau Hyfforddi","Cronfeydd Data","Cost Cyllid","Gweithgareddau Cymunedol",null,null,"Manteision Cytundebol","Milltiredd"]
["Accommodation","Nwy ac Olew","D","Llety",null,"No",{"$nulls":12},"Nwy ac Olew","Yswiriant","Darparu Gwasanaethau",null,"Taliadau Diswyddo, Salwch a Mamolaeth ","Gwasanaethau e-Fasnach","Llog sy'n Daladwy","Confensiynau",null,null,"Dileu swyddi ","Chynhaliaeth"]
["Accommodation","Ardrethi","D","Llety",null,"TBC",{"$nulls":12},"Ardrethi","Cyfnodolion, Cyfeirlyfrau  a Chyhoeddiadau","Archwilio Safleoedd",null,null,"Defnyddiau traul TGCh","Yswiriant.","Adloniant",null,null,"Tâl Salwch Statudol","Teithio"]
["Accommodation","Rhent","D","Llety",{"$nulls":14},"Rhent","Ffonau Symudol","Paratoi Safle",null,null,"Rhentu Offer TGCh (nid yw elw a wneir yn gymwys)","Gwasanaethau Caffael ","Digwyddiadau a Gwobrau",null,null,"Tâl Mamolaeth Statudol","Lletygarwch"]
["Accommodation","Atgyweirio","D","Llety",{"$nulls":14},"Atgyweirio","Llungopïo","Gwaith Safle",null,null,"Costau Rhyngrwyd","Ffioedd Cyfreithiol a Phroffesiynol","Arddangosfeydd a Chynadleddau",{"$nulls":3},"Teithio a Chynhaliaeth"]
["Accommodation","Llogi Ystafelloedd","D","Llety",null,"Programme",{"$nulls":12},"Llogi Ystafelloedd","Postio",{"$nulls":3},"Trwyddedau","Ffioedd Rheoli","Gwybodaeth a Chyngor",{"$nulls":3},"Prydlesu Cerbydau (nid yw elw a wneir yn gymwys)"]
["Accommodation","Diogelwch","D","Llety",null,"Case",{"$nulls":12},"Diogelwch","Offer Swyddfa",{"$nulls":3},"Rhentu Llinell","Tanysgrifiadau","Marchnata a Hyrwyddo",{"$nulls":3},"Costau Rhedeg Cerbydau"]
["Accommodation","Biliau Dŵr ","D","Llety",{"$nulls":14},"Biliau Dŵr ","Ffôn",{"$nulls":3},"Telegyfathrebiadau Goddefol","Astudiaethau","Costau Cyfryngau "]
["Accommodation","Cyfleustodau","D","Llety",{"$nulls":14},"Cyfleustodau","Cyfarpar Amddiffyn Personol",{"$nulls":3},"Meddalwedd","Gwerthuso, Ymchwil a Strategaeth","Cyfarfodydd a Chynadleddau"]
[null,null,"D",{"$nulls":20},"Datblygu Meddalwedd",null,"Nwyddau a Brandio"]
["Administration","Gwasanaethau Canolog","D","Gweinyddu",null,"Lists",{"$nulls":7},"1. Category of expenditure",{"$nulls":9},"Trwyddedau Meddalwedd",null,"Gwaith Partneriaeth"]
["Administration","Defnyddiau traul","D","Gweinyddu",null,"1 written quote","Yes","Yes","Yes",{"$nulls":4},"Llety","opt13_",{"$nulls":8},"Prynu ac Uwchraddio Meddalwedd",null,"Cysylltiadau Cyhoeddus ac Argraffu"]
["Administration","Prydlesi Cyfarpar (nid yw elw a wneir yn gymwys)","D","Gweinyddu",null,"3 written quotes","Not Required","No","No",{"$nulls":4},"Gweinyddu","opt14_",{"$nulls":8},"Cymorth",null,"Argraffu a Reprograffeg"]
["Administration","Ffacs","D","Gweinyddu",null,"Public Procurement","TBC",null,"Yes with 10% Penalty",{"$nulls":4},"Ystadau","opt15_",{"$nulls":8},"Gweinyddu Gwefannau",null,"Cyhoeddusrwydd"]
["Administration","Yswiriant","D","Gweinyddu",null,"MIS (under £500 each)",null,null,"Yes with 25% Penalty",{"$nulls":4},"Grantiau","opt16_",{"$nulls":8},"Costau Gwefannau ",null,"Ymchwil"]
["Administration","Cyfnodolion, Cyfeirlyfrau  a Chyhoeddiadau","D","Gweinyddu",{"$nulls":9},"Adnoddau dynol","opt17_",{"$nulls":10},"Cyfieithiadau a Phrawfddarllen"]
["Administration","Ffonau Symudol","D","Gweinyddu",{"$nulls":9},"TGCH","opt18_"]
["Administration","Llungopïo","D","Gweinyddu",{"$nulls":9},"Cyfreithiol a Phroffesiynol","opt19_"]
["Administration","Postio","D","Gweinyddu",{"$nulls":9},"Marchnata a Hyrwyddo","opt20_"]
["Administration","Offer Swyddfa","D","Gweinyddu",{"$nulls":9},"Gorbenion","opt21_"]
["Administration","Ffôn","D","Gweinyddu",{"$nulls":9},"Caffael","opt22_"]
["Administration","Cyfarpar Amddiffyn Personol","D","Gweinyddu",{"$nulls":9},"Staff","opt23_"]
[null,null,"D",{"$nulls":10},"Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)","opt24_"]
["Estates","Cynllunio a Rheoli","D","Ystadau",{"$nulls":9},"Cyfradd Safonol","opt25_"]
["Estates","Materion a Gwelliannau Amgylcheddol","D","Ystadau",{"$nulls":9},"TAW na ellir ei hadennill","opt26_"]
["Estates","Tirlunio","D","Ystadau"]
["Estates","Rhagbaratoadau ","D","Ystadau"]
["Estates","Darparu Gwasanaethau","D","Ystadau"]
["Estates","Archwilio Safleoedd","D","Ystadau"]
["Estates","Paratoi Safle","D","Ystadau"]
["Estates","Gwaith Safle","D","Ystadau"]
[null,null,"D"]
[null,"Grantiau (dim grantiau i fusnesau masnachol)","D","Grantiau"]
[null,null,"D"]
["HR","Recriwtio","D","Adnoddau dynol"]
["HR","Hyfforddiant","D","Adnoddau dynol"]
["HR","Cyrsiau Hyfforddi","D","Adnoddau dynol"]
["HR","Deunyddiau Hyfforddi","D","Adnoddau dynol"]
["HR","Taliadau Diswyddo, Salwch a Mamolaeth ","D","Adnoddau dynol"]
[null,null,"D"]
["ICT","Telegyfathrebiadau Gweithredol","D","TGCH"]
["ICT","Atgyweirio Cyfrifiaduron","D","TGCH"]
["ICT","Cynnal a Chadw Cyfrifiaduron","D","TGCH"]
["ICT","Cronfeydd Data","D","TGCH"]
["ICT","Gwasanaethau e-Fasnach","D","TGCH"]
["ICT","Defnyddiau traul TGCh","D","TGCH"]
["ICT","Rhentu Offer TGCh (nid yw elw a wneir yn gymwys)","D","TGCH"]
["ICT","Costau Rhyngrwyd","D","TGCH"]
["ICT","Trwyddedau","D","TGCH"]
["ICT","Rhentu Llinell","D","TGCH"]
["ICT","Telegyfathrebiadau Goddefol","D","TGCH"]
["ICT","Meddalwedd","D","TGCH"]
["ICT","Datblygu Meddalwedd","D","TGCH"]
["ICT","Trwyddedau Meddalwedd","D","TGCH"]
["ICT","Prynu ac Uwchraddio Meddalwedd","D","TGCH"]
["ICT","Cymorth","D","TGCH"]
["ICT","Gweinyddu Gwefannau","D","TGCH"]
["ICT","Costau Gwefannau ","D","TGCH"]
[null,null,"D"]
[null,"Costau Achredu","D","Cyfreithiol a Phroffesiynol"]
[null,"Taliadau Banc a Chyflogres","D","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Ymgynghori","D","Cyfreithiol a Phroffesiynol"]
[null,"Cost Cyllid","D","Cyfreithiol a Phroffesiynol"]
[null,"Llog sy'n Daladwy","D","Cyfreithiol a Phroffesiynol"]
[null,"Yswiriant.","D","Cyfreithiol a Phroffesiynol"]
[null,"Gwasanaethau Caffael ","D","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Cyfreithiol a Phroffesiynol","D","Cyfreithiol a Phroffesiynol"]
[null,"Ffioedd Rheoli","D","Cyfreithiol a Phroffesiynol"]
[null,"Tanysgrifiadau","D","Cyfreithiol a Phroffesiynol"]
[null,"Astudiaethau","D","Cyfreithiol a Phroffesiynol"]
[null,"Gwerthuso, Ymchwil a Strategaeth","D","Cyfreithiol a Phroffesiynol"]
[null,null,"D"]
[null,"Hysbysebu a Hyrwyddo","D","Marchnata a Hyrwyddo"]
[null,"Celf a Dylunio","D","Marchnata a Hyrwyddo"]
[null,"Digwyddiadau Busnes ","D","Marchnata a Hyrwyddo"]
[null,"Gweithgareddau Cymunedol","D","Marchnata a Hyrwyddo"]
[null,"Confensiynau","D","Marchnata a Hyrwyddo"]
[null,"Adloniant","D","Marchnata a Hyrwyddo"]
[null,"Digwyddiadau a Gwobrau","D","Marchnata a Hyrwyddo"]
[null,"Arddangosfeydd a Chynadleddau","D","Marchnata a Hyrwyddo"]
[null,"Gwybodaeth a Chyngor","D","Marchnata a Hyrwyddo"]
[null,"Marchnata a Hyrwyddo","D","Marchnata a Hyrwyddo"]
[null,"Costau Cyfryngau ","D","Marchnata a Hyrwyddo"]
[null,"Cyfarfodydd a Chynadleddau","D","Marchnata a Hyrwyddo"]
[null,"Nwyddau a Brandio","D","Marchnata a Hyrwyddo"]
[null,"Gwaith Partneriaeth","D","Marchnata a Hyrwyddo"]
[null,"Cysylltiadau Cyhoeddus ac Argraffu","D","Marchnata a Hyrwyddo"]
[null,"Argraffu a Reprograffeg","D","Marchnata a Hyrwyddo"]
[null,"Cyhoeddusrwydd","D","Marchnata a Hyrwyddo"]
[null,"Ymchwil","D","Marchnata a Hyrwyddo"]
[null,"Cyfieithiadau a Phrawfddarllen","D","Marchnata a Hyrwyddo"]
[null,null,"D"]
[null,"Gorbenion","D","Gorbenion"]
[null,null,"D"]
[null,"Gweithgarwch Caffael","D","Caffael"]
[null,null,"D"]
[null,"Costau cyflogau net","D","Staff"]
[null,"Cyfraniadau pensiwn","D","Staff"]
[null,"Cyfraniadau Yswiriant Gwladol Cyflogwyr","D","Staff"]
[null,"Manteision Cytundebol","D","Staff"]
[null,"Dileu swyddi ","D","Staff"]
[null,"Tâl Salwch Statudol","D","Staff"]
[null,"Tâl Mamolaeth Statudol","D","Staff"]
[null,null,"D"]
[null,"Danfoniadau","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Tanwydd","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Yswiriant a Threth","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Milltiredd","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Chynhaliaeth","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Teithio","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Lletygarwch","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Teithio a Chynhaliaeth","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Prydlesu Cerbydau (nid yw elw a wneir yn gymwys)","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[null,"Costau Rhedeg Cerbydau","D","Teithio a Thrafnidiaeth (ar gyfer hawlio treuliau staff y prosiect)"]
[]
[null,"Cost syml yn sefydlog ar 15% o Gyfanswm Costau Staff ","B","Cyfradd Safonol"]
[]
[null,"TAW cost y prosiect nad oes modd i’r ymgeisydd ei adennill","A","TAW na ellir ei hadennill"]
[null,"TOTAL to match Delivery Profile"]

{"sheet":"Manylion y Prosiect","index":6,"n_rows":8,"n_cols":2,"rows_kept":8}
[]
[]
[null,"Enw'r Ymgeisydd"]
[null,"Teitl y Prosiect"]
[null,"Rhif Cyfeirnod Cwsmer (CRN)"]
[null,"Rhif Adnabod"]
[null,"Prosiect LEADER?"]
[null,"Dyddiad Cwblhawyd y Ffurflen"]

{"sheet":"Cofnod 1","index":7,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 2","index":8,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 3","index":9,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 4","index":10,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 5","index":11,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 6","index":12,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 7","index":13,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 8","index":14,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 9","index":15,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 10","index":16,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 11","index":17,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 12","index":18,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 13","index":19,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 14","index":20,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 15","index":21,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 16","index":22,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 17","index":23,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 18","index":24,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 19","index":25,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 20","index":26,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 21","index":27,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 22","index":28,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 23","index":29,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 24","index":30,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 25","index":31,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 26","index":32,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 27","index":33,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 28","index":34,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 29","index":35,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Cofnod 30","index":36,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[0,0,0,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[26,1,26,3]]}
["Cofnod Tendro Cystadleuol"]
[]
["Rhif Adnabod",{"$f":"'List of Records Submitted'!$B$5","v":0}]
["Rhif Cyfeirnod Cwsmer (CRN)",{"$f":"'List of Records Submitted'!B4:E4","v":0}]
["Categori'r Gwariant"]
["Math o Wariant",{"$nulls":5},{"$f":"IF('List of Records Submitted'!B6=\"Ydy\",VLOOKUP(B5,LEADER!$N$17:$O$30,2,FALSE),VLOOKUP(B5,Data!$N$17:$O$28,2,FALSE))","v":{"$error":"#N/A"}}]
["Cyfalaf / Refeniw"]
["Manylion yr Eitem"]
["Cyfeirnod yr Eitem (ar y Cofrestr Wariant)"]
["Cost yr Eitem"]
["Corff sy’n cydlynu’r tendro, os yw’n un o bartneriaid y prosiect."]
["Nifer o ddyfynbrisiau sydd ei angen"]
["Wedi ei hysbysebu ar Gwerthwch i Gymru"]
["Eitem wedi ei brynu"]
[]
[null,"Dyfynbris 1 (DEWISWYD)","Dyfynbris 2","Dyfynbris 3"]
["Enw a chyfeiriad y cyflenwr"]
["Dyddiad (a dull) y cyswllt",{"$nulls":4},"Is there coflict of interest?"]
["Gwrthdaro Buddiannau",{"$nulls":4},{"$f":"IF(OR(B19=\"Oes\",C19=\"Oes\",D19=\"Oes\"),\"Yes\",\"No\")","v":"No"}]
["Os oes, beth yw’r gwrthdaro a sut mae’n cael ei liniaru?"]
["Rhif Cofrestru’r Cwmni a Rhif TAW (os yn berthnasol)"]
["Dyddiad y Dyfynbris "]
["Meini Prawf Asesu ",{"$nulls":4},"Less than 3 Quotes",null,"Selected quote is not cheapest"]
["Cost y Dyfynbris (heb TAW)",{"$nulls":4},{"$f":"IF(B24=\"\",\"No\",IF(AND(D24>1,C24>1),\"No\",\"Yes\"))","v":"No"},null,{"$f":"IF(B24=\"\",\"No\",IF(AND(B24<=(IF(C24=\"\",100000000,C24)),B24<=((IF(D24=\"\",1000000000,D24)))),\"No\",\"Yes\"))","v":"No"}]
["Rheswm dros y Dewis/Gwrthod "]
["Dyddiad y Llythyr Gwrthod neu Ddewis ",{"$nulls":4},"Referral code"]
["Tystiolaeth pellach fel y nodir yn y tab Arweiniad",{"$nulls":4},{"$f":"IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"Yes\"),\"6\",(IF(AND(H24=\"Yes\",F24=\"Yes\",F19=\"No\"),\"7\",IF(AND(F19=\"Yes\",F24=\"Yes\",H24=\"No\"),\"5\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"Yes\"),\"4\",IF(AND(F24=\"Yes\",F19=\"No\",H24=\"No\"),\"3\",IF(AND(H24=\"Yes\",F19=\"No\",F24=\"No\"),\"2\",IF(AND(F19=\"Yes\",F24=\"No\",H24=\"No\"),\"1\",\"\"))))))))","v":""},{"$f":"F27","v":""},{"$f":"VLOOKUP(G27,Data!J18:K24,2,FALSE)","v":{"$error":"#N/A"}}]