{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cyflwyniad","Marchnad Drydan","Cost cynhyrchu","Sheet1","Cost dosbarthu","Llif Arian Rhwydwaith Gwres","Astudiaethau Achos"],"not_rendered":{"charts":1,"images":17,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cyflwyniad","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"Pecyn Cymorth Ynni Mwynglawdd_Cyflwyniad"]
[]
[]
[]
[]
[]
[]
[]
[null,"Pwrpas"]
[null,"Bwriad y llyfr gwaith hwn yw rhoi dealltwriaeth elfennol o economeg rhwydweithiau gwres. "]
[null,"Y gynulleidfa darged yw staff awdurdodau lleol nad oes ganddynt lawer o ddealltwriaeth o economeg ynni na rhwydweithiau gwres. "]
[]
[null,"Sgematig Rhwydwaith Gwres"]
[]
[]
[null,null,null,null,null,null,"Cwsmer"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mae'r blwch coch hwn yn dynodi rhwydwaith gwres. Mae gwres yn llifo o'i gwmpas. Bydd cwsmeriaid yn tynnu gwres o'r rhwydwaith. Bydd generaduron yn ychwanegu gwres i'r rhwydwaith.",null,null,"Dosbarthwr",null,"Cyflenwr"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Generadur"]
[]
[]
[]
[null,"Mae angen talu'r generadur am gost y gwres y mae'n ei gynhyrchu."]
[null,"Mae angen talu'r dosbarthwr i dalu costau cyfalaf a gweithredol y rhwydwaith gwres."]
[null,"Mae'r cyflenwr yn prynu gwres o'r generadur, yn talu'r dosbarthwr am ddefnyddio eu rhwydwaith, ac yn codi tâl ar y cwsmeriaid. "]
[null,"Mae'r marchnadoedd trydan a nwy yn dilyn y model hwn ac yn cael eu gwahanu'n fwriadol fel bod y Cynhyrchydd, y Dosbarthwr a'r Cyflenwyr i gyd yn gwmnïau gwahanol."]
[null,"Ar gyfer rhwydweithiau gwres, mae un cwmni fel arfer, sef y Energy Services Company (ESCo), sy'n gweithredu fel Cynhyrchydd, Dosbarthwr a Chyflenwr."]

{"sheet":"Marchnad Drydan","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Pecyn Cymorth Ynni Mwynglawdd_Marchnad Drydan y DU"]
[]
[null,"Marchnad Drydan"]
[null,"Ar fil trydan masnachol, gallwch weld dadansoddiad o daliadau sy'n disgyn yn fras i Gynhyrchu, Dosbarthu a Threthiant."]
[null,"(Gelwir cynhyrchu hefyd yn Gost \"Cyfanwerthu\".)"]
[]
[null,"Mae’r tabl isod yn dangos sut y rhagwelir y bydd hyn yn newid erbyn 2025."]
[null,"Pris Trydan y kWh\n",2019,null,null,2022,null,null,2025]
[null,"Cost Cyfanwerthu Trydan",5,null,null,30,null,null,9,"Cynhyrchu yw'r peth mawr sy'n anhysbys - mae'n dibynnu ar brisiau nwy byd-eang."]
[null,"Cost Dosbarthu Trydan",2,null,null,2,null,null,2,"Mae dosbarthiad yn farchnad a reoleiddir - mae'r costau hyn yn weddol sefydlog dros amser. "]
[null,"Treth Trydan",5,null,null,5,null,null,1,"Mae trethiant yn cael ei yrru gan bolisi. Mae llywodraeth y DU wedi datgan y bydd yn lleihau’r dreth ar drydan erbyn diwedd 2024. "]
[null,"Pris Cyflenwi Trydan",{"$f":"SUM(C9:C11)","v":12},null,null,{"$f":"SUM(F9:F11)","v":37},null,null,{"$f":"SUM(I9:I11)","v":12}]
[null,"Treth/Cyfanswm",{"$f":"C11/C12","v":0.41666666666666669},null,null,{"$f":"F11/F12","v":0.13513513513513514},null,null,{"$f":"I11/I12","v":8.3333333333333329E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yr achos economaidd dros wifren breifat"]
[null,"Mantais allweddol gwifren breifat yw ei fod yn osgoi trethiant yn gyfreithlon."]
[null,"(Mae hefyd yn osgoi talu costau dosbarthu i drydydd parti, ond bydd angen gosod cysylltiad ffisegol ar wahân a fydd yn costio cymaint, os nad mwy.)"]
[null,"Yn 2019, roedd y fantais o osgoi trethiant dros 40% o'r bil trydan. Erbyn 2025, pan fydd y llywodraeth wedi lleihau trethiant ar drydan, bydd y budd hwn yn llai na 10% o gyfanswm y bil. "]
[null,"(Mae manteision eraill i wifrau preifat fel sicrwydd cyflenwad a sicrwydd pris i'r ddau barti.)"]
[null,"Yr hyn y mae hyn yn ei olygu yw y bydd y dadansoddiad cost a budd o wifren breifat yn dangos achos busnes llawer gwannach o 2025 ymlaen. "]

{"sheet":"Cost cynhyrchu","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Pecyn Cymorth Ynni Mwynglawdd_Cost Cynhyrchu Gwres"]
[]
[null,"Cost Cynhyrchu Gwres"]
[null,"Cost gwres o bwmp gwres",null,"Pan fydd gwres yn cael ei gynhyrchu gan bwmp gwres (boed ffynhonnell aer, ffynhonnell ddaear, ffynhonnell ddŵr neu ynni mwynglawdd), gyrrwr cost y gwres yw'r Pris Cyflenwi Trydan ynghyd â pherfformiad y system."]
[null,"Cost gwres o Orsaf Bŵer",null,"Pan fydd gwres yn cael ei gynhyrchu gan Orsaf Bŵer (boed yn Ynni o Wastraff neu fiomas), y gost sy’n gyrru cost gwres yw’r Gost Cyfanwerthu Trydan."]
[null,"Pris Trydan y kWh",2025]
[null,"Cost Cyfanwerthu Trydan",{"$f":"+'Marchnad Drydan'!I9","v":9},"--> yn gyrru cost gwres o orsaf ynni"]
[null,"Cost Dosbarthu Trydan",{"$f":"+'Marchnad Drydan'!I10","v":2}]
[null,"Treth Trydan",{"$f":"+'Marchnad Drydan'!I11","v":1}]
[null,"Pris Cyflenwi Trydan",{"$f":"SUM(C7:C9)","v":12},"--> yn gyrru cost gwres o bwmp gwres"]
[]
[null,null,null,"I gael gwres o orsaf bŵer (boed yn Ynni o Wastraff neu fiomas), mae angen i chi ddargyfeirio gwres oddi wrth y tyrbinau. Mae hyn yn golygu bod llai o drydan yn gallu cael ei gynhyrchu a'i werthu. Gelwir y gymhareb gwres:trydan yn \"z-factor\" ac fel arfer mae tua 6:1. Felly i gynhyrchu 6 uned o wres, byddem yn colli allan ar 1 uned o drydan. Gyda chost cyfanwerthu trydan o 9c/kWh, byddai hyn yn golygu cost cynhyrchu gwres o 9c/6=1.5c/kWh."]
[]
[null,null,null,"Yn dibynnu ar y pwmp gwres a ddefnyddir, tymheredd y dŵr mwynglawdd, tymheredd y rhwydwaith a dyfnder y pwll; gallai pwmp gwres ynni mwynglawdd fod ag effeithlonrwydd cyfartalog (COP) o rhwng 2 a 4. Yn COP2 byddai cost gwres yn 12c/2=6c/kWh; yn COP4 byddai cost gwres yn 12c/4=3c/kWh.  Gall y Coal Authority hefyd godi ffi am fynediad i'r pyllau glo. "]
[]
[null,null,null,"Mae'r ffigurau hyn yn dangos costau uniongyrchol cynhyrchu gwres. Bydd rhai costau anuniongyrchol, megis cynnal a chadw offer a chostau gweinyddol. Hefyd, efallai y bydd y gwerthwr gwres yn dymuno gwneud elw arno. Bydd y pris y bydd yr Energy Service Company yn ei dalu am y gwres felly ychydig yn uwch na'r ffigurau a nodir yma. "]

{"sheet":"Sheet1","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"W=J/s"]
[null,null,null,"W=K.kg/m3.J/kg/K.m3/s"]
[null,null,null,"W=kgm2/s3"]
[null,"P",{"$f":"C5*C6*C7*C8/C9","v":75461.538461538454},"W"]
[null,"h",100,"m"]
[null,"r",1000,"kg/m3"]
[null,"g",9.81,"m/s2"]
[null,"Q",0.05,"m3/s"]
[null,"sig",0.65]
[]
[null,"H",{"$f":"+(C13*C12*C6*C8)/(1-1/C14)","v":1120000},"W"]
[null,"c",4200,"J/kg/K"]
[null,"dT",4,"K"]
[null,"COP",4]

{"sheet":"Cost dosbarthu","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Pecyn Cymorth Ynni Mwynglawdd_Cost Gwres"]
[]
[null,"Cost Dosbarthu"]
[]
[null,"Bydd rhwydweithiau gwres yn costio rhwng £1000 a £2000 y metr i'w gosod. "]
[null,"Mewn ardaloedd o ddwysedd isel bydd yn rhatach gosod pympiau gwres unigol na rhwydwaith gwres. "]
[null,"Bydd teras deulawr yn costio dros £10,000 y tŷ a bron yn bendant bydd yn fwy addas ar gyfer pympiau gwres unigol. "]
[null,"Bydd tŷ teras 4 llawr neu uwch yn dal i gostio dros £10,000 y tŷ, ond gyda’r galw uwch am wres gallai wneud economeg y rhwydwaith gwres yn ymarferol."]
[null,"Mae gan ganol dinasoedd, canolfannau diwydiannol, a champysau penodol (prifysgol/GIG) ofynion gwres digon uchel i warantu rhwydwaith gwres."]

{"sheet":"Llif Arian Rhwydwaith Gwres","index":5,"n_rows":196,"n_cols":30,"rows_kept":196,"cut":false,"hidden":false,"merged":[]}
[null,"Llif Arian Rhwydwaith Gwres",null,null,null,null,null,null,null,"Blwyddyn 0","Blwyddyn 1","Blwyddyn 2","Blwyddyn 3","Blwyddyn 4","Blwyddyn 5","Blwyddyn 6","Blwyddyn 7","Blwyddyn 8","Blwyddyn 9","Blwyddyn 10","Blwyddyn 11","Blwyddyn 12","Blwyddyn 13","Blwyddyn 14","Blwyddyn 15","Blwyddyn 16","Blwyddyn 17","Blwyddyn 18","Blwyddyn 19","Blwyddyn 20"]
[]
[null,"Cyflwyniad"]
[null,"Bwriad hyn yw addysgu am yr agweddau ar fodel rhwydwaith gwres, gan gyfeirio'n benodol at Ynni Mwynglawdd."]
[null,"Nid yw'n fodel gweithredol a dylid ei ddefnyddio at ddibenion addysgol yn unig."]
[null,"Rydyn ni'n mynd i ddefnyddio testun glas i ddynodi mewnbynnau ar y model hwn. Bydd fformiwlâu mewn testun du."]
[null,"Fel arfer byddem yn gosod yr holl fewnbynnau ar eu tab eu hunain. Yma, rydyn ni'n gadael y mewnbynnau ar y dudalen hon i'w gwneud hi'n haws i'r darllenydd ddilyn y stori."]
[null,"Mae llinellau'r model wedi'u lliwio mewn llwyd."]
[]
[null,"Llifau egni"]
[null,"Galw am ynni"]
[null,"Y cam cyntaf yw edrych ar y galw am ynni."]
[]
[null,"Dros amser, bydd prosiect rhwydwaith gwres yn adeiladu:"]
[null,"Mae tŷ cyffredin yn y DU yn defnyddio 12,000kWh o nwy y flwyddyn. Ond dim ond 80% effeithlon yw'r boeler nwy arferol, felly mae hynny'n cyfateb i alw am wres o 10,000kWh y flwyddyn. "]
[null,"Niferoedd tai ôl-osod domestig",null,null,null,null,null,null,"#",null,100,200,300,400,500,{"$f":"+O16","v":500},{"$f":"+P16","v":500},500,500,500,500,500,500,500,500,500,500,500,500,500]
[null,"Galw gwres ôl-osod domestig",10000,"kWh/blwyddyn fesul tŷ",null,null,null,null,"kWh/blwyddyn",null,{"$f":"+$C$17*K16","v":1000000},2000000,3000000,4000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000,5000000]
[null,"Fel arfer bydd angen llai na 5000kWh y flwyddyn o wres ar adeiladau newydd. "]
[null,"Niferoedd tai newydd domestig",null,null,null,null,null,null,"#",null,100,200,300,400,500,{"$f":"+O19","v":500},{"$f":"+P19","v":500},{"$f":"+Q19","v":500},{"$f":"+R19","v":500},{"$f":"+S19","v":500},{"$f":"+T19","v":500},{"$f":"+U19","v":500},{"$f":"+V19","v":500},{"$f":"+W19","v":500},{"$f":"+X19","v":500},{"$f":"+Y19","v":500},{"$f":"+Z19","v":500},{"$f":"+AA19","v":500},{"$f":"+AB19","v":500},{"$f":"+AC19","v":500}]
[null,"Galw am wres cartrefi newydd",4000,"kWh/blwyddyn fesul tŷ",null,null,null,null,"kWh/blwyddyn",null,{"$f":"+$C$20*K19","v":400000},800000,1200000,1600000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000,2000000]
[null,"Bydd model Techno-Economig cywir yn cynnwys dadansoddiad manylach o'r holl fathau o eiddo."]
[]
[null,"Mae gan eiddo masnachol fwy o amrywiaeth ac mae'n gyffredin edrych ar eu harwynebedd llawr a maint eu cysylltiad gwres (wedi'i fesur mewn kW) yn ogystal â'r amcangyfrif blynyddol o ddefnydd."]
[null,"Ysgol",150000,"kWh/blwyddyn y",null,200,"Cysylltiad kW",null,"#",null,0,1,{"$f":"+L24","v":1},{"$f":"+M24","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Swyddfeydd",50000,"kWh/blwyddyn y",null,60,"Cysylltiad kW",null,"#",null,0,1,1,2,2,3,{"$f":"+P25","v":3},{"$f":"+Q25","v":3},3,3,3,3,3,3,3,3,3,3,3,3]
[]
[null,"Maint cysylltiad masnachol",null,null,null,null,null,null,"kW",null,{"$f":"+SUMPRODUCT($F$24:$F$25,K24:K25)","v":0},260,260,320,320,380,380,380,380,380,380,380,380,380,380,380,380,380,380,380]
[null,"Galw gwres masnachol",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+SUMPRODUCT($C$24:$C$25,K24:K25)","v":0},200000,200000,250000,250000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000]
[]
[null,"Rydym bellach yn gwybod cyfanswm y galw am wres y mae'n rhaid ei gyflenwi bob blwyddyn i eiddo cwsmeriaid.",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K17+K28+K20","v":1400000},3000000,4400000,5850000,7250000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000,7300000]
[null,"Mae'r rhwydwaith gwres ei hun yn gyfres o bibellau wedi'u claddu yn y ddaear. Byddant yn colli gwres i'r ddaear."]
[null,"Colli gwres",0.2,"o alw am wres",null,null,null,null,"kWh/blwyddyn",null,{"$f":"+$C$32*K30","v":280000},600000,880000,1170000,1450000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000,1460000]
[null,"Mae hyn wedyn yn dweud wrthym beth yw cyfanswm y gwres y mae'n rhaid ei gyflenwi i fodloni'r galw hwnnw",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K30+K32","v":1680000},3600000,5280000,7020000,8700000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000]
[]
[null,"Sylwch: byddai'r enghraifft yr wyf wedi'i llunio yn gwneud rhwydwaith gwres bach iawn - dim ond 1000 o gartrefi, ysgol ac ychydig o swyddfeydd. "]
[null,"Mae'n annhebygol y byddai prosiect ynni mwynglawdd yn gweithio ar y raddfa fach hon oherwydd y gost cyfalaf uchel."]
[]
[null,"Cyflenwad ynni"]
[null,"Nawr ein bod yn gwybod faint o ynni gwres y mae angen inni ei gyflenwi, rydym yn edrych ar o ble y daw’r gwres hwnnw."]
[null,"Bydd rhwydwaith gwres carbon isel yn cael y rhan fwyaf o'i wres yn dod o bympiau gwres, gorsafoedd pŵer, neu wres gwastraff diwydiannol."]
[null,"Yna fel arfer bydd ganddynt foeleri nwy ar gyfer cwrdd â’r llwythi brig uchaf (h.y. 7yb pan fydd pawb yn gwresogi eu cartrefi ac yn cael cawod ar yr un pryd) ac fel cyflenwad wrth gefn."]
[null,"Fodd bynnag, bydd y boeleri nwy yn dod i ben yn raddol yn y pen draw, wrth i ni symud tuag at sero net."]
[null,"At ddibenion addysgol, byddwn yn cymryd mai'r ynni mwynglawdd yw'r brif ffynhonnell gwres, a bod yr holl wres ychwanegol yn cael ei brynu i mewn (o orsaf Ynni o Wastraff cyfagos, dyweder). "]
[]
[null,"Gadewch i ni dybio bod gan ein mwynglawdd allbwn thermol uchaf o ",null,null,null,null,400,"kW"]
[null,"Felly os yw'n gweithio'n gyson am yr holl 8760 awr o'r flwyddyn byddai'n cynhyrchu",null,null,null,null,{"$f":"8760*G45","v":3504000},"kWh/blwyddyn o wres"]
[null,"Ond am 10% o'r amser nid yw'n gweithio oherwydd cynnal a chadw, felly gall gynhyrchu, mewn gwirionedd, dim ond hyd at ",null,null,null,null,{"$f":"+G46*90%","v":3153600},"kWh/blwyddyn o wres"]
[]
[null,"Bydd y model techno-economaidd yn dod yn fanwl ar y pwynt hwn, gan edrych ar ddata fesul awr, galwadau ar yr oriau brig, tymheredd, storfeydd thermol, cyfraddau llif a mwy. "]
[null,"Symudwn heibio i hynny yma ac yn cymryd yn ganiataol y gall gwres y pwll gwrdd o leiaf",null,null,null,null,0.7,"o alw am wres"]
[]
[null,"Felly nawr rydyn ni'n gwybod o ble mae'n gwres yn dod:"]
[null,"Galw am wres",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K33","v":1680000},3600000,5280000,7020000,8700000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000,8760000]
[null,"Cyflenwad gwres o fwynglawdd",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+MIN($G$47,$G$50*K53)","v":1176000},2520000,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600]
[null,"Cyflenwad gwres o orsaf Ynni o Wastraff gerllaw",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K53-K54","v":504000},1080000,2126400,3866400,5546400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400]
[]
[null,"Nawr mae angen i ni feddwl am yr holl ofynion trydan yn ein rhwydwaith gwres."]
[null,"Mae angen trydan arnom ar gyfer (a) y pwmp gwres, (b) i bwmpio hylif o amgylch twll turio'r mwynglawdd, (c) i bwmpio dŵr o amgylch y rhwydwaith gwres."]
[null,"Po ddyfnaf yw'r twll turio, y mwyaf o bwmpio sydd ei angen. Yn ddelfrydol, rydych chi eisiau dŵr cynnes mor agos at yr arwyneb â phosib. "]
[]
[null,"Bydd effeithlonrwydd y pwmp gwres yn dibynnu ar wahanol ffactorau, yn enwedig tymheredd y rhwydwaith gwres, tymheredd y ffynhonnell wres, cyfaint arwyneb y cyfnewidydd gwres, a'r nwy oerydd a ddefnyddir. "]
[null,"Yn y gaeaf, pan fydd angen y rhan fwyaf o wres, mae tymheredd yr aer ar gyfartaledd fel arfer yn is na 5°C. Mae hyn yn lleihau effeithlonrwydd blynyddol cyfartalog pwmp gwres ffynhonnell aer."]
[null,"Bydd tymheredd dŵr ffynhonnell mwynglawdd rhwng 10°C a 20°C, hyd yn oed yn nyfnder y gaeaf. Bydd hynny'n rhoi effeithlonrwydd blynyddol uchel i bympiau gwres ffynhonnell mwynglawdd."]
[]
[null,"Byddwn yn tybio yma cyfernod perfformiad tymhorol (SCOP) ar gyfer y pwmp gwres ffynhonnell mwynglawdd"]
[null,"Effeithlonrwydd blynyddol pwmp gwres ffynhonnell mwynglawdd",null,null,null,4,"SCOP"]
[null,"Cyflenwad gwres o fwynglawdd",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K54","v":1176000},2520000,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600,3153600]
[null,"Trydan sydd ei angen ar gyfer y pwmp gwres",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K67/$F$66","v":294000},630000,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400]
[]
[null,"Mae'r trydan ar gyfer pwmpio hylif o amgylch y twll turio yn dibynnu'n bennaf ar ddyfnder y twll turio."]
[null,"Ar sero dyfnder, ni fydd angen unrhyw drydan, ar 200m, mae'r system gyffredinol SCOP yn debygol o ostwng o 4 i lawr i 2.5, gan niweidio economeg y prosiect yn ddifrifol."]
[null,"Fodd bynnag, mae tyllau turio dyfnach yn aml yn golygu tymereddau cynhesach, felly mae cydbwysedd i'w gael i wneud y mwyaf o effeithlonrwydd o un pen i'r llall."]
[]
[null,"Dyfnder y twll turio",null,null,null,50,"m"]
[null,"Trydan sydd ei angen ar gyfer pwmpio o amgylch y twll turio",null,null,null,{"$f":"+F74/1000","v":0.05},"o'r gwres a gyflwynir",null,"kWh/blwyddyn",null,{"$f":"+K67*$F$75","v":58800},126000,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680]
[]
[null,"Angen trydan ar gyfer pympiau gwres ynghyd â phwmpio tyllau turio",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K68+K75","v":352800},756000,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080,946080]
[null,"SCOP gan gynnwys trydan ar gyfer pwmpio twll turio",null,null,null,null,null,null,"SCOP #",null,{"$f":"+K67/K77","v":3.3333333333333335},3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335,3.3333333333333335]
[]
[null,"Byddwn yn defnyddio fformiwla rheol gyffredinol arall i amcangyfrif y trydan sydd ei angen ar gyfer pwmpio o amgylch y rhwydwaith gwres"]
[null,"Trydan sydd ei angen ar gyfer pwmpio o amgylch y rhwydwaith gwres",null,null,null,0.02,"o'r gwres a gyflwynir",null,"kWh/blwyddyn",null,{"$f":"+K53*$F$81","v":33600},{"$f":"+L53*$F$81","v":72000},105600,140400,174000,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200]
[]
[null,"Gallwn ddod â'r tri gofyniad trydan hyn at ei gilydd:"]
[null,"Trydan sydd ei angen ar gyfer y pwmp gwres",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K68","v":294000},{"$f":"+L68","v":630000},788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400,788400]
[null,"Trydan sydd ei angen ar gyfer pwmpio o amgylch y twll turio",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K75","v":58800},{"$f":"+L75","v":126000},157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680,157680]
[null,"Trydan sydd ei angen ar gyfer pwmpio o amgylch y rhwydwaith gwres",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K81","v":33600},{"$f":"+L81","v":72000},105600,140400,174000,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200,175200]
[null,"Cyfanswm y trydan sydd ei angen",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"SUM(K84:K86)","v":386400},{"$f":"SUM(L84:L86)","v":828000},1051680,1086480,1120080,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280]
[]
[null,"Rydym bellach yn gwybod cyfanswm ein ffynonellau ynni i fodloni’r galw am wres:"]
[null,"Cyfanswm y trydan sydd ei angen",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K87","v":386400},{"$f":"+L87","v":828000},1051680,1086480,1120080,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280,1121280]
[null,"Cyflenwad gwres o orsaf Ynni o Wastraff gerllaw",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K55","v":504000},{"$f":"+L55","v":1080000},2126400,3866400,5546400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400,5606400]
[]
[null,"Rydym wedi defnyddio lefel flynyddol o fanylion yn y model hwn, sy'n helpu i hysbysu ac addysgu. Gallai model manwl edrych ar fanylion dyddiol neu fesul awr."]
[null,"Gall storfa thermol fawr leihau'r gofynion brig yn sylweddol dros gyfnod o 24 awr, gan wneud model dyddiol yn un sy'n rhesymol ddigonol."]
[null,"Mae mwyafrif helaeth y modelau yn edrych ar fanylion yr awr a dylent ystyried lle storio."]
[]
[null,"Llif arian"]
[null,"Costau Ynni"]
[null,"Yn gyntaf byddwn yn edrych ar Gyfanswm Trydan Sydd ei Angen."]
[null,"Gallai hynny ddod o solar ar y safle, gwynt neu gynhyrchydd trydan arall gerllaw."]
[null,"Neu gellid ei brynu naill ai’n breifat drwy Gytundeb Prynu Pŵer, neu drwy’r cyflenwad trydan rheolaidd. "]
[null,"Gallai hyd yn oed fod yn gyfuniad o'r holl ffynonellau trydan uchod."]
[null,"Gallai'r tariff amrywio yn ôl amser o'r dydd, neu efallai na fydd. Gallai fod yn gysylltiedig â marchnadoedd cyfanwerthu, neu beidio. "]
[null,"Bydd model manwl fesul awr yn cynnwys proffiliau ar gyfer unrhyw fath o genhedlaeth â chwmpas (e.e. solar PV) a phrisiau troshaen o amser o’r dydd."]
[null,"Yma, byddwn yn tybio bod yr holl drydan yn cael ei fewnforio gan gyflenwr ar gyfradd safonol."]
[null,"Tariff cyflenwad trydan",null,null,null,null,{"$f":"+'Marchnad Drydan'!I12","v":12},"y kWh","£",null,{"$f":"+$G$106/100*K90","v":46368},{"$f":"+$G$106/100*L90","v":99360},126201.59999999999,130377.59999999999,134409.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001,134553.60000000001]
[]
[null,"Nawr rydym yn edrych ar y cyflenwad gwres ychwanegol. Tybiwn fod hyn yn dod o orsaf Ynni o Wastraff gerllaw. "]
[null,"Tybir mai eu cost uniongyrchol o wres yw trydan cyfanwerthol/\"z-factor\"",null,null,null,null,6,"z-factor"]
[null,"Cyflenwad gwres o orsaf Ynni o Wastraff gerllaw",null,null,null,null,{"$f":"+'Marchnad Drydan'!I9/G109","v":1.5},"y kWh","£",null,{"$f":"+$G$110/100*K91","v":7560},16200,31896,57996,83196,84096,84096,84096,84096,84096,84096,84096,84096,84096,84096,84096,84096,84096,84096,84096]
[]
[]
[null,"Refeniw"]
[null,"Bydd gan yr unedau domestig bris amrywiol am bob kWh o wres ynghyd â thâl sefydlog fesul eiddo. Gall y tâl sefydlog amrywio yn dibynnu ar ba mor fawr yw'r eiddo. "]
[null,"Bydd gan yr unedau masnachol newidyn a thâl sefydlog yn dibynnu ar ba mor fawr yw eu cysylltiad gwres (a nodir yn aml mewn £/kW/blwyddyn)."]
[null,"Mae angen gosod y tariffau hyn yn ddigon uchel i dalu costau+elw, ond eto'n ddigon isel i fod yn rhatach na ffynonellau gwres eraill."]
[null,"Yn draddodiadol, nwy yw'r ffynhonnell wres amgen, sy'n anodd oherwydd ei gost isel. Mae'r ffynhonnell \"gwrthffeithiol\" a dderbynnir bellach yn dod yn bwmp gwres ffynhonnell aer."]
[null,"Tâl Sefydlog Domestig",null,null,null,null,400,"£/tŷ/blwyddyn"]
[null,"Tâl Amrywiol Domestig",null,null,null,null,8,"y kWh"]
[null,"Tâl Sefydlog Masnachol",null,null,null,null,20,"£/blwyddyn/kW"]
[null,"Tâl amrywiadwy masnachol",null,null,null,null,8,"y kWh"]
[]
[null,"Niferoedd tai ôl-osod domestig",null,null,null,null,null,null,null,null,{"$f":"+K16","v":100},200,300,400,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500]
[null,"Niferoedd tai newydd domestig",null,null,null,null,null,null,null,null,{"$f":"+K19","v":100},200,300,400,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500]
[null,"Rhifau tai domestig",null,null,null,null,null,null,"#",null,{"$f":"SUM(K123:K124)","v":200},{"$f":"SUM(L123:L124)","v":400},600,800,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Galw am wres domestig",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K17+K20","v":1400000},2800000,4200000,5600000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000,7000000]
[null,"Maint cysylltiad masnachol",null,null,null,null,null,null,"kW",null,{"$f":"+K27","v":0},260,260,320,320,380,380,380,380,380,380,380,380,380,380,380,380,380,380,380]
[null,"Galw gwres masnachol",null,null,null,null,null,null,"kWh/blwyddyn",null,{"$f":"+K28","v":0},200000,200000,250000,250000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000,300000]
[]
[null,"Tâl Sefydlog Domestig",null,null,null,null,null,null,"£",null,{"$f":"+$G$118*K125","v":80000},160000,240000,320000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000,400000]
[null,"Tâl Amrywiol Domestig",null,null,null,null,null,null,"£",null,{"$f":"+$G$119/100*K126","v":112000},224000,336000,448000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000,560000]
[null,"Tâl Sefydlog Masnachol",null,null,null,null,null,null,"£",null,{"$f":"+$G$120*K127","v":0},5200,5200,6400,6400,7600,7600,7600,7600,7600,7600,7600,7600,7600,7600,7600,7600,7600,7600,7600]
[null,"Tâl amrywiadwy masnachol",null,null,null,null,null,null,"£",null,{"$f":"+$G$121/100*K128","v":0},16000,16000,20000,20000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000]
[null,"Cyfanswm refeniw cwsmeriaid",null,null,null,null,null,null,"£",null,{"$f":"SUM(K130:K133)","v":192000},405200,597200,794400,986400,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600]
[null,"Os oes cynhyrchwyr trydan eraill ar y safle, efallai y bydd rhywfaint o refeniw yma hefyd o werthu trydan. Nid ydym yn cynnwys hynny yn y model hwn. "]
[]
[null,"Refeniw_Ffioedd Cysylltu"]
[null,"Mae'n gyffredin i ddatblygwr dalu ffi cysylltu pan fydd eu hadeilad yn cysylltu â rhwydwaith gwres. "]
[]
[null,"Cysylltiadau ôl-osod domestig yn ystod y flwyddyn",null,null,null,null,null,null,"#",null,{"$f":"+K123-J123","v":100},{"$f":"+L123-K123","v":100},100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cysylltiadau cartref newydd yn ystod y flwyddyn",null,null,null,null,null,null,"#",null,{"$f":"+K124-J124","v":100},100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cysylltiadau masnachol yn ystod y flwyddyn",null,null,null,null,null,null,"kW",null,{"$f":"+K127-J127","v":0},{"$f":"+L127-K127","v":260},0,60,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Ffi cysylltu ôl-osod domestig",null,null,null,null,0,"£/tŷ","£",null,{"$f":"+K140*$G144","v":0},{"$f":"+L140*$G144","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ffi cysylltu cartref newydd",null,null,null,null,1000,"£/tŷ","£",null,{"$f":"+K141*$G145","v":100000},{"$f":"+L141*$G145","v":100000},100000,100000,100000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ffi cysylltu masnachol",null,null,null,null,200,"£/kW","£",null,{"$f":"+K142*$G146","v":0},{"$f":"+L142*$G146","v":52000},0,12000,0,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cyfanswm ffioedd cysylltu",null,null,null,null,null,null,"£",null,{"$f":"SUM(K144:K146)","v":100000},{"$f":"SUM(L144:L146)","v":152000},100000,112000,100000,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Mae triniaethau cyfrifyddu gwahanol ar gyfer y ffioedd cysylltu hyn. Weithiau cânt eu trin fel \"Rhagdaliadau\" a'u lledaenu dros gyfnod y contract. Weithiau cânt eu cydnabod fel incwm yn y flwyddyn y cânt eu derbyn. "]
[]
[null,"Mae Vital yn amcangyfrif £1.2m ar gyfer y dosbarthiad. Amcangyfrifodd Stephen £1.9m ar gyfer Tudor. Yna mae sbardun yn ôl i'r ysgol. "]
[]
[null,"Costau cyfalaf"]
[null,"Gallai prosiect ffynhonnell mwynglawdd gynnwys dau dwll turio echdynnu, ynghyd ag un twll turio ail-chwistrellu. Hefyd bydd angen drilio twll turio archwiliadol. Ac ni fydd pob twll turio yn llwyddiannus. "]
[null,"Y sefyllfa orau fyddai dim tyllau turio; sefyllfa gwael fyddai tua 6."]
[null,"Gall cost tyllau turio amrywio o £500/m i £2000/m."]
[null,"Byddai gorfod drilio 3 twll turio i ddyfnder o 200m ar £1000/m felly yn costio £600,000."]
[null,"Yng Nghaerau, amcangyfrifir mai’r gost ar gyfer tyllau turio oedd £750,000 ar gyfer brig 140kW, sydd dros £5000/kW. Roedd angen £700,000 pellach i gyflenwi gwres i un adeilad."]
[]
[null,"Mae gofynion gwres uwch yn golygu naill ai tyllau turio lletach (ar gyfer pympiau mwy) neu fwy o dyllau turio."]
[null,"Yn Heerlen, y gost a adroddwyd oedd £6m ar gyfer system 1.2MW, sef cyfanswm o £5000/kW fel cost gyfannol."]
[null,"Ni ddylai pwmp gwres ffynhonnell aer mawr fod yn fwy na £750/kW i gyd yn gynwysedig."]
[]
[null,"Cyfalaf Tybiedig ar gyfer ein prosiect"]
[null,"Pwmp Gwres Ffynhonnell Mwynglawdd",null,null,{"$f":"G45","v":400},"kW",10000,"£/kW","£",{"$f":"E165*G165","v":4000000}]
[null,"Gweddill yr orsaf",null,null,{"$f":"3*(Y16+Y19)+Y27","v":3380},"kW",750,"£/kW","£",{"$f":"E166*G166","v":2535000}]
[]
[null,"Cysylltiadau ôl-osod domestig yn ystod y flwyddyn",null,null,null,null,null,null,"#",null,{"$f":"K140","v":100},{"$f":"L140","v":100},100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cysylltiadau cartref newydd yn ystod y flwyddyn",null,null,null,null,null,null,"#",null,{"$f":"K141","v":100},100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cysylltiadau masnachol yn ystod y flwyddyn",null,null,null,null,null,null,"kW",null,{"$f":"K142","v":0},260,0,60,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cost Rhwydwaith Gwres ôl-osod domestig",null,null,null,null,10000,"£/tŷ","£",null,{"$f":"+K168*$G172","v":1000000},{"$f":"+L168*$G172","v":1000000},1000000,1000000,1000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cost Rhwydwaith Gwres cartref newydd",null,null,null,null,5000,"£/tŷ","£",null,{"$f":"+K169*$G173","v":500000},500000,500000,500000,500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cost Rhwydwaith Gwres masnachol",null,null,null,null,1000,"£/kW","£",null,0,260000,0,60000,0,60000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cyfanswm cost Rhwydwaith Gwres",null,null,null,null,null,null,"£",null,{"$f":"SUM(K172:K174)","v":1500000},{"$f":"SUM(L172:L174)","v":1760000},1500000,1560000,1500000,60000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Mae cost cyfalaf ôl-osod rhwydweithiau gwres i dai presennol yn debygol o fod yn rhy ddrud, ac eithrio blociau o fflatiau."]
[null,"Mae eiddo domestig newydd yn economaidd dichonadwy ar gyfer rhwydweithiau gwres, er bod cartrefi ar wahân yn dal yn fwy tebygol o fod â phympiau gwres unigol. "]
[]
[null,"Cyfanswm Cyfalaf",null,null,null,null,null,null,"£",{"$f":"+J165+J166+J175","v":6535000},{"$f":"+K165+K166+K175","v":1500000},1760000,1500000,1560000,1500000,60000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bydd rhai costau cyfalaf hefyd i amnewid rhannau sy’n torri, ond rydym yn eithrio hynny o’r model symlach hwn."]
[]
[null,"Costau cynnal a chadw"]
[null,"Gall costau cynnal a chadw ar brosiectau ynni mwynglawdd fod yn uchel iawn. Yn ôl papur diweddar gan WSP, yr amcangyfrif yw 5% i 13% o gost cyfalaf y tyllau turio."]
[null,"Ar gyfer gweddill yr orsaf, tybiaeth nodweddiadol ar gyfer cynnal a chadw yw 2% o gyfalaf. Ar gyfer y rhwydwaith gwres, dylai'r gwaith cynnal a chadw fod yn llai nag 1%."]
[null,"Cynnal a Chadw Tyllau Turio",0.08,null,null,null,null,null,"£",null,{"$f":"$C185*SUM($J165:K165)","v":320000},{"$f":"$C185*SUM($J165:L165)","v":320000},{"$f":"$C185*SUM($J165:M165)","v":320000},{"$f":"$C185*SUM($J165:N165)","v":320000},{"$f":"$C185*SUM($J165:O165)","v":320000},{"$f":"$C185*SUM($J165:P165)","v":320000},{"$f":"$C185*SUM($J165:Q165)","v":320000},{"$f":"$C185*SUM($J165:R165)","v":320000},{"$f":"$C185*SUM($J165:S165)","v":320000},{"$f":"$C185*SUM($J165:T165)","v":320000},{"$f":"$C185*SUM($J165:U165)","v":320000},{"$f":"$C185*SUM($J165:V165)","v":320000},{"$f":"$C185*SUM($J165:W165)","v":320000},{"$f":"$C185*SUM($J165:X165)","v":320000},{"$f":"$C185*SUM($J165:Y165)","v":320000},{"$f":"$C185*SUM($J165:Z165)","v":320000},{"$f":"$C185*SUM($J165:AA165)","v":320000},{"$f":"$C185*SUM($J165:AB165)","v":320000},{"$f":"$C185*SUM($J165:AC165)","v":320000},{"$f":"$C185*SUM($J165:AD165)","v":320000}]
[null,"Cynnal a Chadw Gweddill yr Orsaf",0.02,null,null,null,null,null,"£",null,{"$f":"$C186*SUM($J166:K166)","v":50700},{"$f":"$C186*SUM($J166:L166)","v":50700},{"$f":"$C186*SUM($J166:M166)","v":50700},{"$f":"$C186*SUM($J166:N166)","v":50700},{"$f":"$C186*SUM($J166:O166)","v":50700},{"$f":"$C186*SUM($J166:P166)","v":50700},{"$f":"$C186*SUM($J166:Q166)","v":50700},{"$f":"$C186*SUM($J166:R166)","v":50700},{"$f":"$C186*SUM($J166:S166)","v":50700},{"$f":"$C186*SUM($J166:T166)","v":50700},{"$f":"$C186*SUM($J166:U166)","v":50700},{"$f":"$C186*SUM($J166:V166)","v":50700},{"$f":"$C186*SUM($J166:W166)","v":50700},{"$f":"$C186*SUM($J166:X166)","v":50700},{"$f":"$C186*SUM($J166:Y166)","v":50700},{"$f":"$C186*SUM($J166:Z166)","v":50700},{"$f":"$C186*SUM($J166:AA166)","v":50700},{"$f":"$C186*SUM($J166:AB166)","v":50700},{"$f":"$C186*SUM($J166:AC166)","v":50700},{"$f":"$C186*SUM($J166:AD166)","v":50700}]
[null,"Cynnal a Chadw Rhwydwaith Gwres",0.01,null,null,null,null,null,"£",null,{"$f":"$C187*SUM($J175:K175)","v":15000},{"$f":"$C187*SUM($J175:L175)","v":32600},{"$f":"$C187*SUM($J175:M175)","v":47600},{"$f":"$C187*SUM($J175:N175)","v":63200},{"$f":"$C187*SUM($J175:O175)","v":78200},{"$f":"$C187*SUM($J175:P175)","v":78800},{"$f":"$C187*SUM($J175:Q175)","v":78800},{"$f":"$C187*SUM($J175:R175)","v":78800},{"$f":"$C187*SUM($J175:S175)","v":78800},{"$f":"$C187*SUM($J175:T175)","v":78800},{"$f":"$C187*SUM($J175:U175)","v":78800},{"$f":"$C187*SUM($J175:V175)","v":78800},{"$f":"$C187*SUM($J175:W175)","v":78800},{"$f":"$C187*SUM($J175:X175)","v":78800},{"$f":"$C187*SUM($J175:Y175)","v":78800},{"$f":"$C187*SUM($J175:Z175)","v":78800},{"$f":"$C187*SUM($J175:AA175)","v":78800},{"$f":"$C187*SUM($J175:AB175)","v":78800},{"$f":"$C187*SUM($J175:AC175)","v":78800},{"$f":"$C187*SUM($J175:AD175)","v":78800}]
[null,"Cyfanswm cost cynnal a chadw",null,null,null,null,null,null,"£",null,{"$f":"SUM(K185:K187)","v":385700},{"$f":"SUM(L185:L187)","v":403300},418300,433900,448900,449500,449500,449500,449500,449500,449500,449500,449500,449500,449500,449500,449500,449500,449500,449500]
[]
[null,"Crynodeb Llif Arian"]
[null,"Refeniw",null,null,null,null,null,null,null,{"$f":"J134","v":0},{"$f":"K134","v":192000},405200,597200,794400,986400,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600,991600]
[null,"Costau ynni",null,null,null,null,null,null,null,{"$f":"-J106-J110","v":0},{"$f":"-K106-K110","v":-53928},-115560,-158097.59999999998,-188373.59999999998,-217605.6,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001,-218649.60000000001]
[null,"Costau cynnal a chadw",null,null,null,null,null,null,null,{"$f":"-J188","v":0},{"$f":"-K188","v":-385700},-403300,-418300,-433900,-448900,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500,-449500]
[null,"Costau cyfalaf",null,null,null,null,null,null,null,{"$f":"-J179","v":-6535000},{"$f":"-K179","v":-1500000},-1760000,-1500000,-1560000,-1500000,-60000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ffioedd Cysylltu",null,null,null,null,null,null,null,{"$f":"J147","v":0},{"$f":"K147","v":100000},152000,100000,112000,100000,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cyfanswm llif arian (cyn cyllid neu dreth)",null,null,null,null,null,null,null,{"$f":"SUM(J191:J195)","v":-6535000},{"$f":"SUM(K191:K195)","v":-1647628},-1721660,-1379197.6,-1275873.6000000001,-1080105.6000000001,275450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002,323450.40000000002]

{"sheet":"Astudiaethau Achos","index":6,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"A Review of the Performance of Minewater Heating and Cooling Systems David B. Walls, David Banks, Adrian J. Boyce and Neil M. Burnside"]
[]
[null,"Prosiect Dŵr Mwynglawdd","Lleoliad","Blwyddyn gosod","Dyfnder m","Tyllau turio","Llif l/e","Tymh C","kW","Math","Nodiadau"]
[null,"Shettleton Housing Association ","Glasgow",1999,"Bas","1+1",3,null,65,null,"Allan o ddefnydd oherwydd costau cynnal a chadw"]
[null,"Lumphinnans","Fife",2000,170,"1+1",3,null,null,null,"Allan o ddefnydd oherwydd materion cynnal a chadw"]
[null,"Markham","Bolsover",null,"Dwfn",1,null,null,20,null,"Cost uchel pwmpio o amgylch y twll turio"]
[null,"Caphouse","Wakefield",null,null,null,null,null,10,"Ymchwil","Allan o ddefnydd: ymchwil yn unig"]
[null,"Dawdon","Sir Durham",2011,null,null,1,null,12,"Peilot","Gweithredol"]
[null,"Dawdon","Sir Durham",2025,null,null,150,20,6000,"Cysyniad","I gyflenwi Seaham Garden Village"]
[null,"Abbotsford Road","Gateshead",null,120,"3+3",100,null,2400,"Fel y Cynlluniwyd"]
[null,"Abbotsford Road","Gateshead",null,120,"1+3",30,11,null,"Perfformiad gwirioneddol","Gweithredol, ond cynhyrchiant isel"]
[null,"Nest Road","Gateshead",null,"130-280","1+1+2wedi methu",60,null,1200,null,"Gweithredol"]
[null,"Crynant","Gorllewin Morgannwg",null,65,null,2,12,35,null,"Allan o ddefnydd oherwydd materion cynnal a chadw"]
[null,"Egremont","Cumbria",null,250,1,50,null,"100+","Treial","Potensial am dros 1MW o wres, ond dim galw am wres yn y lleoliad"]
[null,"Folldal","Norwy",null,600,1,null,null,18,null,"Ers hynny mae wedi'i ddisodli gan bwmp gwres Awyr-Aer"]
[null,"Kongsberg","Norwy",null,250,1,null,null,12,null,"Gweithredol"]
[null,"Osinnikovskaya","Rwsia",null,null,null,null,null,130,null,"Gweithredol"]
[null,"Novoshakhtinsk","Rwsia",null,390,1,28,23,{"$f":"384*2","v":768},null,"Gweithredol"]
[null,"Mieres","Sbaen",null,360,null,100,23,3900,null,"Gweithredol"]
[null,"Heerlen","Yr Iseldiroedd",2005,700,"4+1",null,28,null,null,"Gweithredol"]
[null,"Bytom","Gwlad Pwyl",2020,null,null,"1 allan o 50",28,9,"Peilot","Gweithredol"]
[null,"Czeladz","Gwlad Pwyl",2011,210,1,"6 allan o 400",15,{"$f":"2*59","v":118},null,"Gweithredol"]
[null,"Sobieski","Gwlad Pwyl",2015,500,null,"18 allan o 350",15,420,null,"Gweithredol"]
[null,"Jeremenko","Gweriniaeth Tsiec",2006,null,null,null,29,91,null,"Gweithredol"]