{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Theory","Blade pos 1","Blade pos 2","Graphical representation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":1,"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":"Instructions","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS FOR ENTERING DATA INTO THE THEORY WORKSHEET",null,null,null,null,null,null,"Version 1.1"]
[]
[1,"Only enter data into the blue cells. Red cells have formulae"]
[2,"Enter weather data at the top then push the Wavelength button."]
[3,"Change any other data then press the optimise button at the bottom"]
[4,"Check yellow coloured cells to confirm they are all indicated as 'OK' "]
[5,"Adjust parameters until all yellow cells are indicated as 'OK'"]
[]
["Notes"]
["a.","If you would like to review the spreadsheet in greater detai, the password is (Pliosaur)"]
["b.","If you have any suggestions/corrections/improvements please send a note to (enquiries@pliosaurenergy.com).  "]
[]
[]
[null,"Each gear (turbine) can be configured separately (wave/tide ratio) but rpm is set by tidal flow"]
[null,"Turbines are linked so that flow can move between gears, should this be required."]
[null,"Turbine assembly can ballast up/down to optimise wave overtopping"]
[null,"Flow can move front to back for fluid storage (fluid transfer via ducts between gears)"]
[null,"Waves energy recovery can be 180 deg opposite to tidal flow direction (fluid tranfer system)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 1 - Turbine assembly with 7 gears (turbines)"]
[]
["Many thanks"]
[]
["Pliosaur Energy"]

{"sheet":"Theory","index":1,"n_rows":131,"n_cols":10,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
["WEATHER DATA","Bretschneider wave theory"]
["Bretschneider shallow water method"]
[null,"Mid","Low","High"]
["Wind velocity",60,30,80,"km/h",{"$f":"C4*0.621","v":18.63},"mph"]
["Wind velocity (U)",{"$f":"B4*1000/3600","v":16.666666666666668},{"$f":"C4*1000/3600","v":8.3333333333333339},22.222222222222221,"m/s"]
["Water depth high tide (d)",40,40,40,"m"]
["Fetch = Distance wind travels unobstructed",1000,1000,1000,"km","(Y-direction)"]
["Fetch (F)",{"$f":"B7*1000","v":1000000},{"$f":"C7*1000","v":1000000},1000000,"m"]
["Gravity",9.81,{"$f":"B9","v":9.81},{"$f":"B9","v":9.81},"m/s^2"]
["Fx=g*F/(U^2)",{"$f":"(B9*B8)/(B5^2)","v":35315.999999999993},{"$f":"(C9*C8)/(C5^2)","v":141263.99999999997},19865.25]
["Hx=g*d/(U^2)",{"$f":"(B9*B6)/(B5^2)","v":1.4126399999999999},{"$f":"(C9*C6)/(C5^2)","v":5.6505599999999996},0.79461000000000015]
["p1=tanh(0.53*(Hx^0.75))",{"$f":"TANH( 0.53*($B$11^0.75))","v":0.59589092786192099},{"$f":"TANH( 0.53*($C$11^0.75))","v":0.95972592890798858},{"$f":"TANH( 0.53*($D$11^0.75))","v":0.41865334304822599}]
["p2=tanh(0.833*(Hx^0.375))",{"$f":"TANH( 0.833*($B$11^0.375))","v":0.73897386910665097},{"$f":"TANH( 0.833*($C$11^0.375))","v":0.92086702872521509},{"$f":"TANH( 0.833*($D$11^0.375))","v":0.64353978495733288}]
["Wave height (H)",{"$f":"0.283*(B5^2/B9)*B12*(TANH(0.0125*(B10^0.42)/B12))","v":4.4700219827459584},{"$f":"0.283*(C5^2/C9)*C12*(TANH(0.0125*(C10^0.42)/C12))","v":1.8378120751520766},5.7064611320875702,"m","Note this is a Fetch limited calculation",null,null,"1.6.5","equation ref "]
["Wave period (T)",{"$f":"7.54*(B5/B9)*B13*        TANH(0.077*(B10^0.25)/B13)","v":8.4377033105551433},{"$f":"7.54*(C5/C9)*C13*TANH(0.077*(C10^0.25)/C13)","v":5.4545143436035142},9.7793405635424318,"sec","Note this is a Fetch limited calculation",null,null,"1.6.6","equation ref "]
["Storm duration for Fetch limitation",{"$f":"68.8*(B10^0.67)*B5/B9","v":130289.40204837739},{"$f":"68.8*(C10^0.67)*C5/C9","v":164914.66976717862},118148.96472080724,"mins"]
[null,{"$f":"B16/60/24","v":90.478751422484308},{"$f":"C16/60/24","v":114.52407622720737},82.047892167227261,"days"]
[]
["Linearized theory of wave motion","Guide to Wave analysis and forecasting"]
["L=g*T^2/2PI*Tanh(2*PI*d/L)"]
["Wave length (L) manual iteration",108.97238541920335,46.449813349902769,141.08162798702418,"m"]
[null,{"$f":"B9*B15^2/(2*PI())*TANH(2*PI()*B6/B21)","v":108.97238569457078},{"$f":"C9*C15^2/(2*PI())*TANH(2*PI()*C6/C21)","v":46.449813299861702},{"$f":"D9*D15^2/(2*PI())*TANH(2*PI()*D6/D21)","v":141.08170503237952},"m"]
["Iteration difference",{"$f":"wave_length_mid-B22","v":-2.7536742663869518E-7},{"$f":"wave_length_low-C22","v":5.0041066401718126E-8},{"$f":"wave_length_high-D22","v":-7.7045355340032984E-5},"m"]
[null,{"$f":"IF(INT(B22)=INT(B21),\"OK\",\"ITERATE\")","v":"OK"},{"$f":"IF(INT(C22)=INT(C21),\"OK\",\"ITERATE\")","v":"OK"},{"$f":"IF(INT(D22)=INT(D21),\"OK\",\"ITERATE\")","v":"OK"}]
[]
["Wave velocity(C)= L/T",{"$f":"B22/B15","v":12.914934512837373},{"$f":"C22/C15","v":8.515847676582462},{"$f":"D22/D15","v":14.426504948435358},"m/s"]
["Wave number (K)=2PI/L",{"$f":"2*PI()/B22","v":5.7658509237286777E-2},{"$f":"2*PI()/C22","v":0.13526825751952579},{"$f":"2*PI()/D22","v":4.4535790843593354E-2},"m-1"]
["Wave angular frequency (w)=2PI/T",{"$f":"2*PI()/B15","v":0.74465587090738738},{"$f":"2*PI()/C15","v":1.1519238765130118},{"$f":"2*PI()/D15","v":0.64249580698758169},"sec-1"]
["Wave amplitude (a)=H/2",{"$f":"B14/2","v":2.2350109913729792},{"$f":"C14/2","v":0.91890603757603828},{"$f":"D14/2","v":2.8532305660437851},"m"]
[]
["Tidal Flow Rate",2,1,3,"m/s"]
["Fluid density",1025,{"$f":"B32","v":1025},{"$f":"B32","v":1025},"kg/m3"]
[]
["OVERTOPPING VOLUME","Wave overtopping of marine structures (WOMS) - J.P. Kofoed 2002"]
[null,"Wave run-up and overtopping (WRO) - J.W.Van der Meer 1995"]
["Wave direction angle from perpendicular (beta)",0,0,0,"degrees"]
["Berm correction factor (Vb) (not present)",1,1,1,null,"WOMS text under eq 2.1"]
["Slope roughness/impermeable correction factor (Vr) (steel, smooth = 1)",1,1,1,null,"WOMS text under eq 2.1 (Vf in WRO)"]
["Vertical wall top o fslope correction factor (Vv) (not present=1)",1,1,1,null,"WRO paragraph 4.5 "]
["Wave angle correction factor (Vbeta)",{"$f":"1-(0.0033*B36)","v":1},{"$f":"1-(0.0033*C36)","v":1},{"$f":"1-(0.0033*D36)","v":1},null,"WRO eq 14"]
["Ballasting height above datum",0.34416740964860854,-0.16136620809710245,0.48056524982525672,"m","ENTER DATA HERE IF MACRO FAILS!"]
["Crest freeboard (Rc)",0.75,{"$f":"B42","v":0.75},{"$f":"B42","v":0.75},"m"]
["Actual Model Crest Freeboard",{"$f":"B42+B41","v":1.0941674096486085},{"$f":"C42+Ballasting_Low","v":0.58863379190289755},{"$f":"D42+Ballasting_High","v":1.2305652498252568},"m"]
["Water depth (D)",{"$f":"B6","v":40},{"$f":"C6","v":40},{"$f":"D6","v":40},"m"]
["Turbine draught (Dr)",{"$f":"2.55-Ballasting_Mid","v":2.2058325903513913},{"$f":"2.55-Ballasting_Low","v":2.7113662080971022},{"$f":"2.55-Ballasting_High","v":2.069434750174743},"m","dist. leading edge below surface"]
["Significant wave height (Hs)",{"$f":"B14","v":4.4700219827459584},{"$f":"C14","v":1.8378120751520766},{"$f":"D14","v":5.7064611320875702},"m"]
["Wave length",{"$f":"wave_length_mid","v":108.97238541920335},{"$f":"wave_length_low","v":46.449813349902769},{"$f":"wave_length_high","v":141.08162798702418},"m"]
["Gravity",{"$f":"B9","v":9.81},{"$f":"C9","v":9.81},{"$f":"D9","v":9.81},"m/s^2"]
["Wave number (Kp)",{"$f":"2*PI()/B47","v":5.7658509382986764E-2},{"$f":"2*PI()/C47","v":0.1352682573737993},{"$f":"2*PI()/D47","v":4.4535815164802858E-2},"m-1","WOMS page vii"]
["Coeff for draught (k)",0.4,0.4,0.4,"m-1","WOMS just below eq 3.4"]
["Slope angle (Alpha)",45,{"$f":"B51","v":45},{"$f":"B51","v":45},"degrees"]
["Optimal slope angle (Alpha m)",30,30,30,"degrees","WOMS paragraph 3.5.1"]
["Fitting coefficient (Beta)",3,3,3,null,"WOMS paragraph 3.5.1"]
["Lambda s",{"$f":"IF(B43<0.75,0.4*SIN(2*PI()*B43/3)+0.6,1)","v":1},{"$f":"IF(C43<0.75,0.4*SIN(2*PI()*C43/3)+0.6,1)","v":0.97737259727599202},{"$f":"IF(D43<0.75,0.4*SIN(2*PI()*D43/3)+0.6,1)","v":1},null,"WOMS eq 3.6"]
["Lambda dr",{"$f":"1 -  (B50*  (SINH(2*B49*B44*(1-(B45/B44)))    + (2*B49*B44*(1-(B45/B44))))  /   (SINH(2*B49*B44)+(2*B49*B44)))","v":0.68417057260496073},{"$f":"1 -  (C50*  (SINH(2*C49*C44*(1-(C45/C44)))    + (2*C49*C44*(1-(C45/C44))))  /   (SINH(2*C49*C44)+(2*C49*C44)))","v":0.80783632805337791},{"$f":"1 -  (D50*  (SINH(2*D49*D44*(1-(D45/D44)))    + (2*D49*D44*(1-(D45/D44))))  /   (SINH(2*D49*D44)+(2*D49*D44)))","v":0.65958855231349034},null,"WOMS eq 3.4"]
["Lambda (alpha)",{"$f":"COS(RADIANS(B51-B52))^B53","v":0.90122106501343824},{"$f":"COS(RADIANS(C51-C52))^C53","v":0.90122106501343824},{"$f":"COS(RADIANS(D51-D52))^D53","v":0.90122106501343824},null,"WOMS eq 3.3"]
["Lambda m,  profile correction (CC01)",1.18,{"$f":"B57","v":1.18},{"$f":"B57","v":1.18},null,"WOMS page 59"]
["Average wave overtopping discharge",{"$f":"        B57* B54*B55*B56*((B48*B46^3)^0.5)  *                              0.2*EXP(-2.6*B43/B46*(1/B37/B38/B39/B40))","v":2.2793483662190455},{"$f":"       C57*  C54*C55*C56*((C48*C46^3)^0.5)  *                              0.2*EXP(-2.6*C43/C46*(1/C37/C38/C39/C40))","v":0.56983874064612972},{"$f":"        D57* D54*D55*D56*((D48*D46^3)^0.5)  *                              0.2*EXP(-2.6*D43/D46*(1/D37/D38/D39/D40))","v":3.4190324371450544},"m3/s/m","WOMS eq 3.10"]
["Turbine width",20,{"$f":"B59","v":20},{"$f":"B59","v":20},"m"]
["Pontoon width",2.5,{"$f":"B60","v":2.5},{"$f":"B60","v":2.5}]
["Average wave overtopping discharge",{"$f":"B58*(B59+(2*B60))","v":56.983709155476134},{"$f":"C58*(C59+(2*C60))","v":14.245968516153242},85.475810928626359,"m3/s"]
["Turbine diameter",16,{"$f":"B62","v":16},{"$f":"B62","v":16},"m"]
["Core axle diameter",2,{"$f":"B63","v":2},{"$f":"B63","v":2},"m"]
["Number blades",18,{"$f":"B64","v":18},{"$f":"B64","v":18}]
["Blade angle",{"$f":"360/B64","v":20},{"$f":"360/C64","v":20},20,"degree"]
["Blade width",0.15,{"$f":"B66","v":0.15},{"$f":"B66","v":0.15},"m"]
["Blade displacement/ revolution",{"$f":"(((PI()*B62^2/4)-(PI()*B63^2/4)) *B59)  -  (((B62-B63)/2)*B66*B59*B64)","v":3580.4067435231395},{"$f":"B67","v":3580.4067435231395},{"$f":"B67","v":3580.4067435231395},"m3/rev"]
[]
["SOLE TIDAL POWER (UNCORRECTED, WAVE FLOW DISPLACES TIDAL FLOW)"]
["Velocity pressure",{"$f":"0.5*B32*B31^2","v":2050},{"$f":"0.5*C32*C31^2","v":512.5},{"$f":"0.5*D32*D31^2","v":4612.5},"Pa (N/m^2)"]
["Blade length",{"$f":"(B62-B63)/2","v":7},{"$f":"(C62-C63)/2","v":7},{"$f":"(D62-D63)/2","v":7},"m"]
["Blade area",{"$f":"B71*B59","v":140},{"$f":"C71*C59","v":140},{"$f":"D71*D59","v":140},"m^2"]
["Betz limit",0.56999999999999995,{"$f":"B73","v":0.56999999999999995},{"$f":"B73","v":0.56999999999999995},null,"Maximum efficiency possible"]
["Energy conversion losses",0.05,{"$f":"B74","v":0.05},{"$f":"B74","v":0.05}]
["Calculated efficiency",{"$f":"B73-B89","v":0.52714285714285714},{"$f":"C73-C89","v":0.52714285714285714},{"$f":"D73-D89","v":0.52714285714285714}]
["Torque",{"$f":"B70*B72*((B62/2)-(B71/2))","v":1291500},{"$f":"C70*C72*((C62/2)-(C71/2))","v":322875},{"$f":"D70*D72*((D62/2)-(D71/2))","v":2905875},"Nm"]
["TSR (tip speed ratio)",0.8,{"$f":"B77","v":0.8},{"$f":"B77","v":0.8},null,"HYLOW project output (0.8=optimum) "]
["Blade angular velocity ",{"$f":"B31*B77","v":1.6},{"$f":"C31*C77","v":0.8},{"$f":"D31*D77","v":2.4000000000000004},"m/s"]
["Rotor speed",{"$f":"B78/(PI()*B62)*60","v":1.909859317102744},{"$f":"C78/(PI()*C62)*60","v":0.95492965855137202},{"$f":"D78/(PI()*D62)*60","v":2.8647889756541165},"rpm"]
["Predicted Power",{"$f":"B76*B79/9.664/1000000","v":0.25523419992117069},{"$f":"C76*C79/9.664/1000000","v":3.1904274990146336E-2},{"$f":"D76*D79/9.664/1000000","v":0.8614154247339515},"MW"]
["Available tidal power",{"$f":"0.5*B32*B72*B31^3/1000000","v":0.57399999999999995},{"$f":"0.5*C32*C72*C31^3/1000000","v":7.1749999999999994E-2},{"$f":"0.5*D32*D72*D31^3/1000000","v":1.9372499999999999},"MW"]
["Efficiency (TSR derived)",{"$f":"B80/B81","v":0.44465888488008837},{"$f":"C80/C81","v":0.44465888488008837},{"$f":"D80/D81","v":0.44465888488008853},null,"HYLOW research paper 40%"]
[null,{"$f":"IF(B75>B82,\"OK\",\"CHECK\")","v":"OK"},{"$f":"IF(C75>C82,\"OK\",\"CHECK\")","v":"OK"},{"$f":"IF(D75>D82,\"OK\",\"CHECK\")","v":"OK"}]
["FISH GAP"]
["Fish Gap",0.3,{"$f":"B85","v":0.3},{"$f":"B85","v":0.3},"m"]
["Velocity head",{"$f":"B31^2/(2*B9)","v":0.2038735983690112},{"$f":"C31^2/(2*C9)","v":5.09683995922528E-2},{"$f":"D31^2/(2*D9)","v":0.4587155963302752},"m"]
["Flow rate",{"$f":"0.61*B85*B59*(2*B9*B86)^0.5","v":7.32},{"$f":"0.61*C85*C59*(2*C9*C86)^0.5","v":3.66},{"$f":"0.61*D85*D59*(2*D9*D86)^0.5","v":10.98},"m^3/s"]
["Duct Flow rate",{"$f":"0.61*(B71*B59)*(2*B9*B86)^0.5","v":170.79999999999998},{"$f":"0.61*(C71*C59)*(2*C9*C86)^0.5","v":85.399999999999991},{"$f":"0.61*(D71*D59)*(2*D9*D86)^0.5","v":256.2},"m^3/s"]
["Efficiency loss",{"$f":"B87/B88","v":4.2857142857142864E-2},{"$f":"C87/C88","v":4.2857142857142864E-2},{"$f":"D87/D88","v":4.2857142857142858E-2}]
[]
["WAVE TIDAL SYNCHRONISATION"]
["Tidal Blade displacement",{"$f":"B79/60*B67","v":113.96788630225272},{"$f":"C79/60*C67","v":56.983943151126361},{"$f":"D79/60*D67","v":170.95182945337908},"m3/sec"]
["Number wave flow paths/gear",4,{"$f":"B93","v":4},{"$f":"B93","v":4}]
["Rotor speed",{"$f":"B79","v":1.909859317102744},{"$f":"C79","v":0.95492965855137202},{"$f":"D79","v":2.8647889756541165},"rpm"]
["Gear width (Turbine section)",5,{"$f":"B95","v":5},{"$f":"B95","v":5},"m"]
["Gear width  decimal check",{"$f":"IF(OR((ROUND(B99,0)-B99)<-0.05,(ROUND(B99,0)-B99)>0.05),\"CHECK\",\"OK\")","v":"OK"},{"$f":"IF(OR((ROUND(C99,0)-C99)<-0.05,(ROUND(C99,0)-C99)>0.05),\"CHECK\",\"OK\")","v":"OK"},"OK"]
["Optimal overtopping flowrate/wave flow path",{"$f":"B94/60*B67*B95/B59","v":28.491971575563177},{"$f":"C94/60*C67*C95/C59","v":14.245985787781589},{"$f":"D94/60*D67*D95/D59","v":42.737957363344769},"m3/sec"]
["Overtopping flow rate",{"$f":"B61","v":56.983709155476134},{"$f":"C61","v":14.245968516153242},{"$f":"D61","v":85.475810928626359},"m3/sec"]
["Wave flow paths required",{"$f":"B98/B97","v":1.9999917873128015},{"$f":"C98/C97","v":0.99999878761437755},{"$f":"D98/D97","v":1.9999975712909652}]
["Wave flow paths /turbine",{"$f":"B59/B95","v":4},{"$f":"C59/C95","v":4},{"$f":"D59/D95","v":4}]
["Gear Check",{"$f":"IF(ROUND(B99,1)>B100,\"CHECK\",\"OK\")","v":"OK"},{"$f":"IF(ROUND(C99,1)>C100,\"CHECK\",\"OK\")","v":"OK"},"OK"]
[]
["WAVE POWER"]
["Head developed torque /wave flow path ",{"$f":"((B32*B9*(Ballasting_Mid+B42)*B71)-'Graphical representation'!J25)*B95       *Gear_Mid","v":666921.62786996854},{"$f":"((C32*C9*(Ballasting_Low+C42)*C71)-'Graphical representation'!J25)*C95       *Gear_Low","v":155547.652817005},{"$f":"((D32*D9*(Ballasting_High+D42)*D71)-'Graphical representation'!J25)*D95     *Gear_High","v":762929.44679316413},"Nm"]
["Wave Power /wave flow path",{"$f":"B104*B94/9.664/1000000","v":0.13180116771158823},{"$f":"C104*C94/9.664/1000000","v":1.5370143521627685E-2},0.22616223803548741,"MW"]
["Fluid losses",0.05,{"$f":"B106","v":0.05},{"$f":"B106","v":0.05}]
["Wave power uncorrected",{"$f":"B99*B105*(1-B106)","v":0.25042119033234295},{"$f":"C99*C105*(1-C106)","v":1.4601618642732329E-2},{"$f":"D99*D105*(1-D106)","v":0.42970773044926874},"MW"]
["Wave Power corrected for head loss between waves",{"$f":"Available_Power_Mid*(1-((B117/2)/B43))","v":0.19892562637392433},{"$f":"Available_Power_Low*(1-((C117/2)/C43))","v":1.1500875268076341E-2},{"$f":"Available_Power_High*(1-((D117/2)/D43))","v":0.30748933879665147},"MW"]
[]
["TIDAL POWER "]
["Tidal Power ",{"$f":"B80","v":0.25523419992117069},{"$f":"C80","v":3.1904274990146336E-2},0.8614154247339515,"MW"]
[]
["COMBINED TIDAL AND WAVE POWER"]
["Total Power",{"$f":"B111+B108","v":0.45415982629509499},{"$f":"C111+C108","v":4.3405150258222676E-2},{"$f":"D111+D108","v":1.1689047635306029},"MW"]
[]
["DECK AREA"]
["Allowable head loss",0.45,0.25,0.7,"m"]
["Wave period",{"$f":"B15","v":8.4377033105551433},{"$f":"C15","v":5.4545143436035142},{"$f":"D15","v":9.7793405635424318},"sec"]
["Time to reach overtopping threshold",{"$f":"(B118/2)+(B43/B29)*(B118/2)","v":6.2842240427802798},{"$f":"(C118/2)+(C43/C29)*(C118/2)","v":4.4742864271179723},{"$f":"(D118/2)+(D43/D29)*(D118/2)","v":6.9985283612618003},"sec"]
["Storage capacity required",{"$f":"B119*B61","v":358.09839512164189},{"$f":"C119*C61","v":63.74054357297441},{"$f":"D119*D61","v":598.2048869858429},"m3"]
["Deck storage area",{"$f":"(B120/B117)+ (B59*B62)","v":1115.7742113814265},{"$f":"(C120/C117)+ (C59*C62)","v":574.96217429189767},{"$f":"(D120/D117)+ (D59*D62)","v":1174.5784099797756},"m^2"]
["Length pontoon required",{"$f":"B121/B59","v":55.788710569071327},{"$f":"C121/C59","v":28.748108714594885},{"$f":"D121/D59","v":58.728920498988785},"m"]
["Pontoon length available",60,{"$f":"B123","v":60},{"$f":"B123","v":60},"m"]
["Pontoon length check",{"$f":"IF(B122>B123,\"CHECK\",\"OK\")","v":"OK"},{"$f":"IF(C122>C123,\"CHECK\",\"OK\")","v":"OK"},"OK"]
[]
["WIND POWER IF DIRECTION IS ALLIGNED WITH TIDAL FLOW AND TURBINE",null,null,null,null,30,"mph"]
["Wind velocity",{"$f":"F127","v":13.411166666666666},{"$f":"F127","v":13.411166666666666},{"$f":"F127","v":13.411166666666666},"m/s",{"$f":"1609.34*F126/60/60","v":13.411166666666666},"m/s"]
["Air density",1.2250000000000001,{"$f":"B128","v":1.2250000000000001},{"$f":"B128","v":1.2250000000000001},"kg/m3"]
["Wind power available",{"$f":"0.5*B128*B72*B127^3/1000000","v":0.20683965650485428},{"$f":"0.5*C128*C72*C127^3/1000000","v":0.20683965650485428},{"$f":"0.5*D128*D72*D127^3/1000000","v":0.20683965650485428},"MW"]
["Efficiency estimate",0.2,{"$f":"B130","v":0.2},{"$f":"B130","v":0.2}]
["Potential Power Available",{"$f":"B129*B130","v":4.1367931300970856E-2},{"$f":"C129*C130","v":4.1367931300970856E-2},4.1367931300970856E-2,"MW"]

{"sheet":"Blade pos 1","index":2,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Net effect ",null,null,null,null,null,null,null,null,null,null,null,"suction acting on the underside of the blades balanced"]
[null,"+ve Hydrostatic head acting on driven blade = h1+h2"]
[null,"Head acts along full length"]
[null,"-ve head acts on pre-driven blade"]
[null,"new blade pressure balanced"]
[]
[]
[]
[]
[]
[]
["h1"]
[]
["h2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"water level"]

{"sheet":"Blade pos 2","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Net effect "]
[null,"+ve Hydrostatic head acting on driven blade = h1+h2"]
[null,"Head acts along full length"]
[null,"-ve head acts on new blade"]
[null,"pre-driven blade pressure balanced"]
[]
[]
[]
[]
[]
[]
["h1"]
[]
["h2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"water level"]

{"sheet":"Graphical representation","index":4,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"y"]
[]
[null,{"$f":"J12","v":8},null,null,"B"]
[null,null,null,null,null,null,null,null,"blade angle ",{"$f":"Theory!B65","v":20},"degrees"]
[null,null,null,null,null,null,null,null,"core diameter",{"$f":"Theory!B63","v":2},"m"]
["blade",null,null,null,null,null,null,null,"h1",{"$f":"Theory!B42","v":0.75},"m"]
["length",null,null,null,null,null,null,null,"Blade length + 1/2 core dia",{"$f":"Theory!B62/2","v":8},"m"]
[null,null,null,null,null,null,null,null,"A",{"$f":"J7/SIN(RADIANS(J5))","v":2.1928533001223154},"m"]
[null,{"$f":"J9","v":2.1928533001223154},"D",null,null,null,null,"A","A",20,"degrees"]
[null,null,null,null,null,null,null,null,"B",{"$f":"DEGREES(ASIN(J7/J8))","v":5.3793789911120742},"degrees"]
[null,null,null,null,null,null,null,null,"B",{"$f":"J8","v":8},"m"]
[null,null,null,null,null,null,null,null,"C",{"$f":"J7/SIN(RADIANS(J11+J5))","v":1.7498425501298123},"m"]
[null,1.75,null,null,"C",null,null,null,"C",{"$f":"J11+J5","v":25.379378991112073},"degrees"]
[null,null,null,null,null,null,null,null,"D",20,"degrees"]
[null,null,null,null,null,null,null,null,"D",{"$f":"J9","v":2.1928533001223154},"m"]
[null,null,null,"0",{"$f":"J11","v":5.3793789911120742},null,20,null,"Head A blade root",{"$f":"Theory!B32*Theory!B9*(J7-((J6/2)*SIN(RADIANS(J10))))","v":4102.3394538245693},"Pa"]
[null,null,null,"Blade",null,"Blade",null,null,"Head B blade root",{"$f":"Theory!B32*Theory!B9*(J7-((J6/2)*SIN(RADIANS(J11))))","v":6598.7578125},"Pa"]
[null,null,null,"Position",null,"Position",null,null,"Head C blade root",{"$f":"Theory!B32*Theory!B9*(J7-((J6/2)*SIN(RADIANS(J14))))","v":3231.6568860581701},"Pa"]
[null,null,null,2,null,1,null,null,"Head D blade root",{"$f":"J17","v":4102.3394538245693},"Pa"]
[null,null,null,null,null,null,null,null,"-ve torque A",{"$f":"J17/2*(J9-$J$6/2)","v":2446.7445778583074},"Nm/m","1 m width"]
[null,null,null,null,null,null,null,null,"-ve torque B",{"$f":"J18/2*(J12-$J$6/2)","v":23095.65234375},"Nm/m"]
[null,null,null,null,null,null,null,null,"-ve torque C",{"$f":"J19/2*(J13-$J$6/2)","v":1211.6169202932133},"Nm/m"]
[null,null,null,null,null,null,null,null,"-ve torque D",{"$f":"J20/2*(J16-$J$6/2)","v":2446.7445778583074},"Nm/m"]
[null,null,null,null,null,null,null,null,"Av negative torque",{"$f":"((((J21+J22)/2)*(J10-J11))   +   (((J19+J20)/2)*(J11-0)))/J5","v":10322.451272026969},"Nm/m"]