tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863363d1710869861-adjust-formula-with-blanks-no-blanks-test-etaf-2
Sheet: Sheet2

Countries | Code | 1 | 2 | 3 | 4 | 5 | 6
Afghanistan | AFG | Low income | 1234137 | 0 | 0.0105999994277954
Albania | ALB | Upper middle income | 83227 | 0.692341995239258 | 0.692341995239258
Algeria | DZA | Lower middle income | 988272 | 0 | 0.7907399749755859 |  |  |  |  | you'll see that for column H, I want to adjust the figures in column G so that, if a country doesn't have a percent (column F), it pulls from the income classification that the country is considered.  For example, I want Andorra - row 6 to show the amount in D6*B22, since it is considered a high-income country.
American Samoa | ASM | High income | 2327 | 0 | 0.683929901123047
Andorra | AND | High income | 1691 | 0 | 0
Angola | AGO | Lower middle income | 2334213.5 | 0 | 0.396110191345215
[NAME] and [NAME] | ATG | High income | 2104.5 | 0 | 0.7025360107421881
Argentina | ARG | Upper middle income | 1988442.5 | 0 | 0.76186653137207
Armenia | ARM | Upper middle income | 109181 | 0.287847690582275 | 0.287847690582275
Aruba | ABW | High income | 2112.5 | 0 | 1.03520858764648
Australia | AUS | High income | 618596.5 | 0 | 1.60214385986328
Austria | AUT | High income | 258173 | 0 | 1.02857139587402
Azerbaijan | AZE | Upper middle income | 421042 | 0.462895889282227 | 0.462895889282227
Bahamas, The | BHS | High income | 9258 | 0 | 0.397394790649414
Bahrain | BHR | High income | 58957 | 0 | 0.526030311584473
Bangladesh | BGD | Lower middle income | 8772784.5 | 0.3638068771362299 | 0.3638068771362299
Barbados | BRB | High income | 6023 | 0.751266479492188 | 0.751266479492188
Belarus | BLR | Upper middle income | 277425 | 0.9676632690429691 | 0.9676632690429691
High income | 0.837960662841797
Upper middle income | 0.779466094970703
Lower middle income | 0.584978103637695
Low income | 0.201464595794678
World | 0.608573989868164
Spreadsheet: 0b251aef-23ea-4191-91a2-ed554b9c99ee
Sheet: J-Term 2012

Course | Professor | Title | Author | Price | ISBN | Publisher
1.217  Technological Tools in Biblical Studies | [NAME] | From the Garden to the City | Dyer | 11.9 | 9780825426681 | Kregel/Ing
2.301  Theology of [NAME] | [NAME] | God and Human Dignity | Burrow | 25.5 | 9780268021955 | [NAME]
 |  | The Authbiography of M. Luther King Jr. | [NAME] | 13.6 | 9780446676502 | Little Brown
 |  | [NAME]:  Inconvenient Hero | [NAME] | 13.6 | 9781570757365 | Orbis
 |  | King's Dream | Sundquist | 12.75 | 9780300158595 | [NAME].
 |  | A Testament of Hope | Washington | 20.4 | 9780060646912 | HarperCollins
 |  | At. [NAME]'s Edge     RECOMMENDED | Branch | 17 | 9780684857138 | S & S
3.106A  Portraits of Mission Stategies | Avery | [NAME] | Bliese/Van Gelden | 14.4 | 9780806651095 | A/F
3.106A  Portraits of Mission Stategies |  | If This is the Way the World Works | Avery | 15.3 | 9781566993555 | Alban
3.106B  Portraits of Mission Strategies |  | A Failure of Nerve | Friedman | 23.8 | 9780802827234 | Eerdmans
3.517 Caring for Dying and Bereaved | Billman | Is God Still at the Bedside? | Evans | 30 | 9780822328605 | [NAME].
 |  | Passed On | Holloway | 35.95 | 9780800696610 | A/F
 |  | Grief: comtemporary Theory | [NAME] | 17 | 9780800634551 | A/F
Choose 1 of 4 |  | Clothed in Nothingness | Hummel | 15.3 | 9780664244934 | [NAME].
Choose 1 of 4 |  | All Our Losses, All Our Griefs | Mitchell | 16.95 | 9780829813531 | Pilgrim
Choose 1 of 4 |  | Rachel' Cry | Billman | 16.15 | 9780195397697 | Oxford
Choose 1 of 4 |  | How We Grieve | Tattig | 22.9 | 9780814623336 | Liturgical Pr.
3.548  Understanding & Preventing Sexual Abuse in the Church | Eshbach/Wood | CANCELLED
3.741  Preaching Controversial Topics | [NAME] | Confronting the Controversies | [NAME] | 10.2 | 9781606081426 | Wipf & Stock
 |  | Preaching Justics | [NAME] | 17 | 9780664233327 | [NAME].
 |  | Prophetic Preaching | [NAME] | 17 | 9780060608521 | HarperC
4.204  Diaconal Ministry Formation Event | Oldenburg | Life Together | [NAME] | 11.75 | 9786000111137 | A/F
 |  | From Word and Sacrament | Larson | 19.4 | 9780664229474 | [NAME].
 |  | [NAME] | Thompson | 12.75 | 9780078050893 | McGraw-Hill
4.301 Multicultural | Strobert | Race & Ethnic Relations [NAME]. | [NAME] | 40 | 9780061626005 | HarperCollins
6.108 STM  Gnosticism & Early Christianity | Bohleke | The Nag Hammadi Scriptures, [NAME]. 1 | [NAME] | 19.8 | 9780310252368 | Zondervan
6.211  STM  Pentecostalism | Erling | CANCELLED
CTS  Old Testatment Foundations | Schramm | A Short Intro to the Hebrew Bible | [NAME] | 37.05
Spreadsheet: 229769d1366566706-terribly-slow-excelsheet-dummyrapportage-20130322-clean
Sheet: V&I

Afdelingsrapportage V&I |  |  |  |  |  | Stand per |  |  |  |  | Rapportagedatum:
Speerpunten
[NAME] (speerpuntnr. programmabegroting) |  |  | Beleidsprodukt | [NAME] | Financieel | Planning | Risico's | Toelichting (alleen bij kruisje; duimpje of resultaten)
2.1 Aantrekkelijk ondernemingsklimaat (inclusief goede bereikbaarheid)
Openbaar vervoer (2.1) |  |  | 211
[NAME] (2.2) |  |  | 211
Infrastructuur (2.3) |  |  | 211
3.2 Aantrekkelijke leefomgeving
Water en riolering (3.11) |  |  | 325
Overig
Milieu en duurzaamheid onderdeel energie gemeentelijke gebouwen
Financieel (x € 1.000)
Beleidsproduct
 |  |  | [NAME] |  |  | [NAME]
 |  |  | cijfers deze maand | Begroting  Primitief | Begroting bijgesteld  t/m vorige maand | Voorgestelde mutaties begroting B&W akkoord Incidenteel | Voorgestelde mutaties begroting B&W akkoord Structureel | Begroting na voorgestelde mutaties | Aanvullende afwijkingen / nog niet geaccordeerd | Toelichting / link naar collegevoorstel
112
Subtotaal 112
113
Subtotaal 113
122
Subtotaal 122
123
Subtotaal 123
131
Subtotaal 131
132
Subtotaal 132
311
Subtotaal 311
422
Subtotaal 422
 | Totaal
Indicatoren
n.v.t.
Informatie college aan raad
Actuele informatie
Subprogr | BP | Omschrijving
Toezeggingen en moties
Datum | BP | Afspraak/toezegging |  | Status (wijziging, nieuw, afgedaan of vervallen) |  |  |  | Toelichting
Planning MJRA
Nr. | BP | Omschrijving |  | Planning    PB2013 | Vorige planning | Actuele    planning | Toelichting (wijziging, nieuw of vervallen)
Bedrijfsvoering
Omschrijving |  |  |  | Resultaat of afwijking
Standaard
 | Ziekteverzuim
 | [NAME] (in FTE) en verwachte invuldatum
Innovatieve aanbestedingen
Vastgoedbeheer en -management
Bezuinigingen technisch onderhoud gebouwen
Centraal beheer digitaal kaartmateriaal
Opstellen teamplannen
Integratie teams
Optimaliseren en intensiveren intern samenwerkingsverband
Intensiveren informatie-uitwisseling
Over de heg
Zelfredzame teams
Bestuurlijke profilering
Leesbare besluiten
Verbeteren dienstverlening
Telefonische bereikbaarheid
Samenwerking met BOR
Functioneringsgesprekken
Opleiding
Ziekteverzuim
Bezuinigingen
[NAME] (in FTE) en verwachte invuldatum
Spreadsheet: 740416d1626336662-using-index-match-to-return-values-in-ascending-order-index-match-example
Sheet: Company

 | Customer No. | Customer Name | Inv. No. | Ref. No.
 | AAA |  | 31895 | RO098789654 | Branch 1
 | ABA |  | 31896 | RO0874144 | Branch 1
 | AA |  | 31897 | RO0865137 | Branch 1
 | C |  | 31898 | RO061558 | Branch 1
Spreadsheet: 815084d1674733552-formula-to-use-for-conditional-formatting-example-rota
Sheet: Certifcate

Full | Forklift | Truck
[NAME]
[NAME] | 2025-01-31 00:00:00
[NAME] | 2024-05-31 00:00:00
[NAME] | 2024-07-31 00:00:00
[NAME] | 2024-04-30 00:00:00 | 22/06/2005
[NAME] R | 2024-05-31 00:00:00 | 26/04/2004
Alister | 2024-08-31 00:00:00 | 13/08/2009
[NAME] | 2024-05-31 00:00:00 | 01/11/2009
[NAME] |  | 04/08/2021
Ian | 2024-07-31 00:00:00 | 01'08/2009
[NAME] | 2025-01-31 00:00:00
[NAME] | 2024-08-31 00:00:00 | 17/08/2009
[NAME] | 2025-08-31 00:00:00 | 22/08/2022
[NAME] | 2024-08-31 00:00:00 | 11/06/2003
[NAME] | 2025-07-31 00:00:00 | 24/08/2022
[NAME] | 2025-07-31 00:00:00
Shaun | 2024-08-31 00:00:00 | 07/09/2021
[NAME] | 2024-07-31 00:00:00 | 13/02/2004
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.6

Table 1.6: Population by age groups, nationality, residence and sex in Oman, 2012
 | Nationals |  | Non-nationals |  | Urban |  | Rural |  | Total
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 148368 | 143073 | 16038 | 15362 | … | … | … | … | 164406 | 158435 | 322841
5-9 | 114540 | 110523 | 17929 | 16712 | … | … | … | … | 132469 | 127235 | 259704
10-14 | 96711 | 91941 | 14576 | 13360 | … | … | … | … | 111287 | 105301 | 216588
15-19 | 118754 | 111452 | 9557 | 8423 | … | … | … | … | 128311 | 119875 | 248186
20-24 | 126158 | 121668 | 136043 | 25817 | … | … | … | … | 262201 | 147485 | 409686
25-29 | 115848 | 112934 | 322785 | 47838 | … | … | … | … | 438633 | 160772 | 599405
30-34 | 90210 | 89228 | 244894 | 42013 | … | … | … | … | 335104 | 131241 | 466345
35-39 | 61793 | 59876 | 172550 | 36436 | … | … | … | … | 234343 | 96312 | 330655
40-44 | 42124 | 39785 | 135047 | 23516 | … | … | … | … | 177171 | 63301 | 240472
45-49 | 32906 | 33021 | 89668 | 14220 | … | … | … | … | 122574 | 47241 | 169815
50-54 | 28884 | 30846 | 61033 | 8756 | … | … | … | … | 89917 | 39602 | 129519
55-59 | 20744 | 24068 | 35704 | 4312 | … | … | … | … | 56448 | 28380 | 84828
60-64 | 17732 | 18666 | 10606 | 1963 | … | … | … | … | 28338 | 20629 | 48967
65-69 | 14804 | 14653 | 2395 | 908 | … | … | … | … | 17199 | 15561 | 32760
70-74 | 13342 | 11951 | 583 | 488 | … | … | … | … | 13925 | 12439 | 26364
75-79 | 9238 | 7085 | 237 | 288 | … | … | … | … | 9475 | 7373 | 16848
80+ | 10758 | 8853 | 124 | 260 | … | … | … | … | 10882 | 9113 | 19995
Not stated | 4 | 19 | … | … | … | … | … | … | 4 | 19 | 23
Total |  |  |  |  | … | … | … | …
Spreadsheet: 113c0ad9-91b0-4abb-be1e-54d04d26d1be
Sheet: Sheet1

DATE | Berth 1: | VESSEL | ETA | ETB | ETD | Destination | CGO QTY x 1000 | Berth 2&3: | VESSEL.1 | ETA.1 | ETB.1 | ETD.1 | Destination.1 | Products | CGO QTY x 1000.1 | [NAME] | VESSEL.2 | ETA.2 | ETB.2 | ETD.2 | Destination.2 | Products.1 | CGO QTY x 1000.2
2007-10-15/21 |  | AQUAHOPE | 2200/15 | 2130/17 | 0000/19 | China | 170PB fines |  | LOWLANDS LONGEVITY | AM/15 | 1330/15 | 2330/16 | China |  | 160PB fines |  | CHANNEL NAVIGATOR | /16 | 0200/20 | 0400/21 | China
 |  | [NAME] | /15 | 1400/20 | 2100/21 | - |  |  | CHS BRIGHT | 0500/15 | 0030/17 | 0200/18 | China |  | 160PB fines | 2007-10-22/28 | AGILITY | 0200/23 | 2030/24 | 0930/26 | CHINA | PB fines and PB lump | 160
 |  | CAPE VICTORY | 2200/16 | 2200/21 | 0700/23 | China | 60PB lump & 100PB fines |  | CHANNEL ALLIANCE | 0600/19 | 0800/19 | - | - |  | - |  | C.S.ENTREPRENEUR | 1200/23 | 0100/29 | 0001/31 | TAIWAN | - | -
2007-10-22/28 |  | NORTHGATE | 0001/23 | 0200/23 | 0900/24 | CHINA | - |  | [NAME] | /19 | - | - | Japan |  | - |  | OCEAN CASTLE | 1030/27 | 0100/31 | 1400/01 | CHINA | PB fines and yandi fines | 170
 |  | SOUTHERN EXPLORER | 0600/23 | 0700/26 | 1000/27 | CHINA | 160 |  | PACIFIC GLORY | 2315/16 | - | - | Japan |  | 60 fines & 60yandi fines | 2007-11-19/25 | PEACE BLOSSOM | /20/11 | 0845/20/11 | 0900/22/11 | - | - | -
 |  | CAPE ALLIANCE | 0400/21 | 1100/27 | 2130/28 | JAPAN | - | 2007-10-22/28 | MANASOTA | 0300/23 | 0500/23 | 0900/24 | CHINA | PB fines | 160 |  | VOUTAKOS | AM/21/11 | 0600/21/11 | 2140/23/11 | CHINA | PB fines | 160
 |  | COPPERSMITH | 0800/24 | 2230/28 | 2230/29 | CHINA | 160 |  | PACIFIC OAK | /24 | 1000/24 | 2200/25 | JAPAN | fines and yandi fines | 200 |  | QUORN | /21/11 | - | - | - | - | -
Spreadsheet: 68461d1269000291-inserting-rows-per-new-entry-test23-1-
Sheet: Sheet1

 | Name | Age | Location | Student # | Team | Color | Animal |  |  | Name | Age | Location | Student # | Team | Color | Animal
 | Eagle | 25 | Beach | 11111 | Fire | Red | Tiger |  |  | Eagle | 25 | Beach | 11111 | Fire | Red | Tiger
 | [NAME] | 25 | Town | 22222 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 | Pao | 23 | Office | 33333 | Water | Blue | Shark |  |  | [NAME] | 25 | Town | 22222 | Water | Blue | Shark
 | Carol | 25 | Airplane | 44444 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 | [NAME] | 25 | Beach | 55555 | Earth | [NAME] | Elephant |  |  | Pao | 23 | Office | 33333 | Earth | [NAME] | Elephant
 | Von | 22 | Office | 66666 | Earth | [NAME] | Elephant |  |  | Pao | 23 | Office | 33333 | Earth | [NAME] | Elephant
 |  |  |  |  | Earth | [NAME] | Elephant |  |  | Pao | 23 | Office | 33333 | Earth | [NAME] | Elephant
 |  |  |  |  | Earth | [NAME] | Elephant |  |  | Pao | 23 | Office | 33333 | Earth | [NAME] | Elephant
 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Wind | White | [NAME] |  |  | Carol | 25 | Airplane | 44444 | Wind | White | [NAME]
 |  |  |  |  | Wind | White | [NAME] |  |  | Carol | 25 | Airplane | 44444 | Wind | White | [NAME]
 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Heart | Pink | [NAME] |  |  | [NAME] | 25 | Beach | 55555 | Heart | Pink | [NAME]
 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Sand | Black | Bird |  |  | Von | 22 | Office | 66666 | Sand | Black | Bird
 |  |  |  |  | Sand | Black | Bird |  |  | Von | 22 | Office | 66666 | Sand | Black | Bird
 |  |  |  |  | Sand | Black | Bird |  |  | Von | 22 | Office | 66666 | Sand | Black | Bird
 | THIS |  |  |  |  |  |  |  |  | TO THIS
Spreadsheet: 100487d1298853812-chart-issue-connor-phillips-cs111-project-2-1-
Sheet: Sheet1

 | NBA Regular Season Scoring 2010-2011
Rank Based on Points) | Player | Games | Points (Total) | Points (Per Game) | >22.00 Points (Per Game)
 | [NAME] | 47 | 1363
 | [NAME] | 52 | 1322
 | [NAME] | 50 | 1320
 | Amar'e Stoudemire | 50 | 1314
 | Monta Ellis | 50 | 1260
 | [NAME] | 52 | 1224
 | [NAME] | 48 | 1211
 | [NAME] | 49 | 1206
 | Blake Griffin | 51 | 1154
 | [NAME] | 51 | 1147
 | [NAME] | 51 | 1142
 | LaMarcus Aldridge | 52 | 1122
 | [NAME] | 52 | 1111
 | [NAME] | 45 | 1106
 | [NAME] | 49 | 1070
 | [NAME] | 54 | 1049
 | [NAME] | 51 | 1021
 | [NAME] | 50 | 1011
 | [NAME] | 52 | 1007
 | [NAME] | 48 | 1001
 | [NAME] | 41 | 997
 | [NAME] | 52 | 977
 | [NAME] | 46 | 974
 | [NAME] | 52 | 973
 | [NAME] | 42 | 971
 | [NAME] | 51 | 969
 | [NAME] | 51 | 937
 | [NAME] | 47 | 934
 | [NAME] | 49 | 919
 | [NAME] | 53 | 905
 | [NAME] | 51 | 893
 | [NAME] | 51 | 890
 | [NAME] | 50 | 888
 | [NAME] | 52 | 887
 | [NAME] | 53 | 884
 | [NAME] | 48 | 875
 | [NAME] | 43 | 866
 | [NAME] | 52 | 853
 | [NAME] | 50 | 860
 | [NAME] | 49 | 852
 |  | Total | Total | Average
 | Top 40:
 | Maximum
 | Minimum:
Spreadsheet: 65029d1265805327-mark-matches-between-colums-test
Sheet: Sheet1

NAME | ID # | trip date | Name authorized | ID # authorized | authorization date | Match
[NAME] | civ12345 | 2010-01-14 00:00:00 | [NAME] | 12345 | 2010-01-14 00:00:00
[NAME] | mil123456 | 2010-01-17 00:00:00 | [NAME] | mil123456 | 2010-01-17 00:00:00
[NAME] | mil123456 | 2010-01-12 00:00:00 | [NAME] | mil123456 | 2010-01-17 00:00:00
[NAME] | cnt456789 | 2010-01-13 00:00:00 | [NAME] | 456789 | 2010-01-13 00:00:00
Spreadsheet: 951570f0-9e61-4a87-a71a-8a97dc3241a7
Sheet: Sheet1

DEVON ENERGY CORPORATION AND SUBSIDIARIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
CONSOLIDATED BALANCE SHEETS
 | December 31, |  |  | December 31,
 | 2011 | 2010 | Check Subtotals | 2011 |  | 2010
ASSETS | (In millions, except |  | Total current assets | 0 |  | 0
 | share data) |  | Net PP&E | 0 |  | 0
Current assets:
Cash and cash equivalents | 5555 | 2866 | Total assets | 0 |  | 0
Short-term investments | 1503 | 145 | Total current liabilities | 0 |  | 0
Accounts receivable | 1379 | 1202 | Stockholders' equity | 0 |  | 0
Current assets held for sale | 21 | 563 | Total Liabilities and stockholders' equity | 0 |  | 0
Other current assets | 847 | 779
Total current assets | 9305 | 5555
Property and equipment, at cost:
Oil and gas, based on full cost accounting:
Subject to amortization | 61696 | 56012 | Balance | 0 |  | 0
Not subject to amortization | 3982 | 3434
Total oil and gas | 65678 | 59446
Other | 5098 | 4429
Total property and equipment, at cost | 70776 | 63875
Less accumulated depreciation, depletion and amortization | -46002 | -44223
Property and equipment, net | 24774 | 19652
Goodwill | 6013 | 6080
Long-term assets held for sale | 132 | 859
Other long-term assets | 893 | 781
Total assets | 41117 | 32927
LIABILITIES AND STOCKHOLDERS' EQUITY
Current liabilities:
Accounts payable | 1471 | 1411
Revenues and royalties payable | 678 | 538
Short-term debt | 3811 | 1811
Current liabilities associated with assets held for sale | 48 | 305
Other current liabilities | 730 | 518
Total current liabilities | 6738 | 4583
Long-term debt | 5969 | 3819
Asset retirement obligations | 1496 | 1423
Liabilities associated with assets held for sale | 0 | 26
Other long-term liabilities | 721 | 1067
Deferred income taxes | 4763 | 2756
Stockholders' equity:
Common stock, $0.10 par value.  Authorized 1.0 billion shares;
issued 404.1 million and 431.9 million shares in 2011 and 2010, respectively | 40 | 43
Additional paid-in capital | 3507 | 5601
Retained earnings | 16308 | 11882
Accumulated other comprehensive earnings | 1575 | 1760 | [NAME] |  |  | Accumulated OCI Check
Treasury stock, at cost. 0.4 million shares in 2010 | 0 | -33 |  | 2011 |  |  | 2011
Total stockholders' equity | 21430 | 19253 | Change in retained earnings | 4426 |  | Change in accumulated OCI | -185
Commitments and contingencies (Note 18) |  |  | Current year Net Income | 4704 |  | Current year OCI | -185
Total liabilities and stockholders' equity | 41117 | 32927 | Current year Common Stock Dividends | -278 |  |  | 0
 |  |  |  | 0
Parentheticals
Common stock, par value | 0.1 | 0.1
Common Stock, shares authorized | 1000000000 | 1000000000
Common Stock, shares issued | 404100000 | 431900000
Treasury stock, at cost | 0 | 400000
Spreadsheet: 872521d1718889054-help-with-complex-formula-sor-template
Sheet: SOR Code Rates

SOR Code | Item | Description | Item Type | Star Rate | Trade | Unit | Unit Price | Scope
Rate 1 | Upto 0.1m2 | seal floor or wall (one face) Opening up to 0.1m2 | SOR | No | General Building | ITEM | 10 | Excluded
Rate 2 | upto 0.2m2 | seal floor or wall (one face) Opening up to 0.2m2 | SOR | No | General Building | ITEM | 20 | Excluded
Rate 3 | upto 0.4m2 | seal floor or wall (one face) Opening up to 0.4m2 | SOR | No | General Building | ITEM | 100 | Excluded
Rate 4 | upto 0.6m2 | seal floor or wall (one face) Opening up to 0.6m2 | SOR | No | General Building | ITEM | 200 | Excluded
Rate 5 | upto 0.8m2 | seal floor or wall (one face) Opening up to 0.8m2 | SOR | No | General Building | ITEM | 250 | Excluded
Rate 6 | Upto 0.9m2 | seal floor or wall (one face) Opening up to 0.9m2 | SOR | No | General Building | ITEM | 290 | Excluded | 325
Spreadsheet: 203574d1357167343-conditional-highlight-a-range-of-cells-based-on-one-cells-value-with-a-relative-reference-conditional-highlight-a-group-of-cells
Sheet: Sheet1

 | FT Shift:1 | Times: | 04:00:00 | 12:00:00 |  | FT Shift:1 | Times: | 04:00:00 | 12:00:00
 | Shift Name: | Counter 106 - Priority |  |  |  | Shift Name: | Counter 106 - Priority
 | [CHECKIN] |  | 04:00:00 | 05:00:00 |  | [CHECKIN] |  | 04:00:00 | 05:00:00
 | [MEAL] |  | 05:00:00 | 05:15:00 |  | [MEAL] |  | 05:00:00 | 05:15:00
 | [CHECKIN] |  | 05:15:00 | 09:00:00 |  | [CHECKIN] |  | 05:15:00 | 09:00:00
 | [MEAL] |  | 09:00:00 | 09:30:00 |  | [MEAL] |  | 09:00:00 | 09:30:00
 | [CHECKIN] |  | 09:30:00 | 12:00:00 |  | [CHECKIN] |  | 09:30:00 | 12:00:00
 | FT Shift:2 | Times: | 04:30:00 | 12:30:00 |  | FT Shift:2 | Times: | 04:30:00 | 12:30:00
 | Shift Name: | Counter 105 - Priority International |  |  |  | Shift Name: | Counter 105 - Priority International
 | [CHECKIN] |  | 04:30:00 | 05:15:00 |  | [CHECKIN] |  | 04:30:00 | 05:15:00
 | [MEAL] |  | 05:15:00 | 05:30:00 |  | [MEAL] |  | 05:15:00 | 05:30:00
 | [CHECKIN] |  | 05:30:00 | 09:30:00 |  | [CHECKIN] |  | 05:30:00 | 09:30:00
 | [MEAL] |  | 09:30:00 | 10:00:00 |  | [MEAL] |  | 09:30:00 | 10:00:00
 | [CHECKIN] |  | 10:00:00 | 12:30:00 |  | [CHECKIN] |  | 10:00:00 | 12:30:00
 | FT Shift:3 | Times: | 04:00:00 | 12:00:00 |  | FT Shift:3 | Times: | 04:00:00 | 12:00:00
 | Shift Name: | Couner 104 - Priority Business |  |  |  | Shift Name: | Couner 104 - Priority Business
 | [CHECKIN] |  | 04:00:00 | 05:30:00 |  | [CHECKIN] |  | 04:00:00 | 05:30:00
 | [MEAL] |  | 05:30:00 | 05:45:00 |  | [MEAL] |  | 05:30:00 | 05:45:00
 | [CHECKIN] |  | 05:45:00 | 09:00:00 |  | [CHECKIN] |  | 05:45:00 | 09:00:00
 | [MEAL] |  | 09:00:00 | 09:30:00 |  | [MEAL] |  | 09:00:00 | 09:30:00
 | [CHECKIN] |  | 09:30:00 | 12:00:00 |  | [CHECKIN] |  | 09:30:00 | 12:00:00
 | FT Shift:4 | Times: | 04:00:00 | 12:00:00 |  | FT Shift:4 | Times: | 04:00:00 | 12:00:00
 | Shift Name: | Counter 112 - CI / Queue Director |  |  |  | Shift Name: | Counter 112 - CI / Queue Director
 | [CHECKIN] |  | 04:00:00 | 05:30:00 |  | [CHECKIN] |  | 04:00:00 | 05:30:00
 | [MEAL] |  | 05:30:00 | 05:45:00 |  | [MEAL] |  | 05:30:00 | 05:45:00
 | [CHECKIN] |  | 05:45:00 | 08:00:00 |  | [CHECKIN] |  | 05:45:00 | 08:00:00
 | [MEAL] |  | 08:00:00 | 08:30:00 |  | [MEAL] |  | 08:00:00 | 08:30:00
 | [OTHER] |  | 08:30:00 | 09:00:00 |  | [OTHER] |  | 08:30:00 | 09:00:00
 | [OTHER] |  | 09:00:00 | 12:00:00 |  | [OTHER] |  | 09:00:00 | 12:00:00
Spreadsheet: 763843d1642428147-what-formula-will-pick-the-value-from-the-colored-font-cell-need-help
Sheet: Sheet2

B000001FK3 | 10 | B000001FK3 | 10
B00000DCH2 | 10 | B00000DCH2 | 10
B000024LSD | 10 | B000024LSD | 10
B000025AZ7 | 10 | B000025AZ7 | 10
B0000265PW | 10 | B0000265PW | 10
B00002MV0W | 10 | B00002MV0W | 10
[NAME] | 5 | [NAME] | 5
B000058USU | 5 | B000058USU | 5
[NAME] | 5 | [NAME] | 5
B00005OM5L | 5 | B00005OM5L | 5
B0001GAVNY | 5 | B0001GAVNY | 5
B0001NPU0G | 5 | B0001NPU0G | 5
B0002ISG7E | 5 | B0002ISG7E | 5
B00081MWUM | 5 | B00081MWUM | 5
[NAME] | 5 | [NAME] | 5
[NAME] | 5 | [NAME] | 5
B000HEZ7N4 | 5 | B000HEZ7N4 | 5
B000IHYWIG | 3 | B000IHYWIG | 3
B000JJSRU2 | 3 | B000JJSRU2 | 3
B000PSJ9ZE | 3 | B000PSJ9ZE | 3
B000VJVGF8 | 3 | B000VJVGF8 | 3
B001AGNRYO | 3 | B001AGNRYO | 3
B001ECPV8Y | 3 | B001ECPV8Y | 3
B001MYKYOU | 3 | B001MYKYOU | 3
B002J8LVOA | 3 | B002J8LVOA | 3
B00316QY6Y | 3 | B00316QY6Y | 3
B0032BVEQS | 3 | B0032BVEQS | 3
B003JIOHCW | 2 | B003JIOHCW | 2
B003JMRA8G | 2 | B003JMRA8G | 2
[NAME] | 2 | [NAME] | 2
Spreadsheet: 781873d1653595860-sum-values-depending-on-several-criteria-text-and-number-criteria-test
Sheet: Šumarija-rekapitulacija

[NAME]
Šumarija: Ogulin
Plan sječa za |  | 2023. |  |  |  |  | godinu
Šumarija po vrsti prihoda
 |  |  |  |  |  |  | T-3 |  | Kontrola i ev. popravak
[NAME] prihoda | [NAME] drveća |  | Tarifa | Površina (ha)
 |  |  |  |  | Etat | Do [NAME]
Glavni redovni |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ime sheet-ova
 |  | Cer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 535_rekapitulacija
 |  | O. bukva |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 536_rekapitulacija
 |  | O. grab |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 537_rekapitulacija
 |  | C. grab |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 538_rekapitulacija
 |  | G. javor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 539_rekapitulacija
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 540_rekapitulacija
 |  | O. voće
 |  | OTB
 |  | OMB
 |  | [NAME]
 |  | Smreka
 |  | B. bor
 |  | C. bor
 |  | Borovac
 |  | E. ariš
 |  | Ukupno:
Glavni slučajni |  | [NAME]
 |  | Smreka
 |  | Ukupno:
Ukupno glavni prihod |  | [NAME]
 |  | Cer
 |  | O. bukva
 |  | O. grab
 |  | C. grab
 |  | G. javor
 |  | [NAME]
 |  | O. voće
 |  | OTB
 |  | OMB
 |  | [NAME]
 |  | Smreka
 |  | B. bor
 |  | C. bor
 |  | Borovac
 |  | E. ariš
 |  | Sveukupno:
Prethodni redovni |  | Cer
 |  | O. bukva
 |  | O. grab
 |  | G. javor
 |  | OTB
 |  | [NAME]
 |  | OMB
 |  | B. bor
 |  | C. bor
 |  | Smreka
 |  | Borovac
 |  | OC
 |  | Ukupno:
Glavni i prethodni prihod |  | [NAME]
 |  | Cer
 |  | O. bukva
 |  | O. grab
 |  | C. grab
 |  | G. javor
 |  | [NAME]
 |  | O. voće
 |  | OTB
 |  | OMB
 |  | [NAME]
 |  | Smreka
 |  | B. bor
 |  | C. bor
 |  | Borovac
 |  | E. ariš
 |  | OC
 |  | Sveukupno:
Datum: |  |  |  |  |  |  | Upravitelj: