tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 105766d1303048254-using-controls-or-index-i-think-help-please-style-question
Sheet: Select

Schedule | of | Investments
DIAMOND | HILL | SELECT | FUND
2011-02-28 00:00:00
Net | Assets: | $ | 45390239 |  |  |  |  |  |  |  |  |  |  |  |  | SELECT
Cusip | Ticker | Security | Description | Shares | Market | Value | % | of | Net | Assets |  |  |  |  | Ticker | $ Holdings | Rank | % Growth | Sector
205887102 | CAG | CONAGRA | FOODS | INC | 77143 | 1786632 | 0.0394
871829107 | SYY | SYSCO | CORP | 60105 | 1670318 | 0.0368
46625H100 | JPM | JPMORGAN | CHASE | & | CO | 34970 | 1632749 | 0.036
37411105 | APA | APACHE | CORP | 12900 | 1607598 | 0.0354
260003108 | DOV | [NAME] | CORP | 24115 | 1549389 | 0.0341
949746101 | WFC | WELLS | FARGO | & | CO | 47610 | 1535899 | 0.0338
25179M103 | DVN | DEVON | ENERGY | CORP | 16565 | 1514704 | 0.0334
585055106 | MDT | MEDTRONIC | 36501 | 1457120 | 0.0321
913017109 | UTX | UNITED | TECHNOLOGIES | CORP | 17315 | 1446495 | 0.0319
674599105 | OXY | OCCIDENTAL | PETROLEUM | CORP | 14055 | 1433188 | 0.0316
171798101 | XEC | CIMAREX | ENERGY | CO | 11945 | 1387173 | 0.0306
452308109 | ITW | ILLINOIS | TOOL | WORKS | INC | 24938 | 1349146 | 0.0297
742718109 | PG | PROCTER | & | GAMBLE | CO | 20565 | 1296623 | 0.0286
91324P102 | UNH | UNITEDHEALTH | GROUP | INC | 28352 | 1207228 | 0.0266
717081103 | PFE | PFIZER | 62215 | 1197017 | 0.0264
9158106 | APD | AIR | PRODUCTS | & | CHEMICALS | 12975 | 1193700 | 0.0263
71813109 | BAX | BAXTER | INTL | 22390 | 1190029 | 0.0262
902973304 | USB | US | BANCORP | DELAWARE | 42760 | 1185735 | 0.0261
2824100 | ABT | ABBOTT | LABS | 23670 | 1138527 | 0.0251
744320102 | PRU | PRUDENTIAL | FINANCIAL | INC | 16950 | 1115819 | 0.0246
478160104 | JNJ | [NAME] | & | [NAME] | 18015 | 1106842 | 0.0244
G0585R106 | AGO | ASSURED | GUARANTY | LTD | 74630 | 1084374 | 0.0239
594918104 | MSFT | MICROSOFT | 40055 | 1064662 | 0.0235
58933Y105 | MRK | MERCK | & | CO | INC | 32670 | 1064062 | 0.0234
32511107 | APC | ANADARKO | PETROLEUM | CORP | 12025 | 984006 | 0.0217
8.9417e+113 | TRV | TRAVELERS | COS | INC | 16260 | 974462 | 0.0215
88579Y101 | MMM | 3M | CO | 10310 | 950891 | 0.0209
580135101 | MCD | MCDONALD'S | CORP | 12095 | 915350 | 0.0202
370334104 | GIS | GENERAL | MILLS | INC | 24505 | 910116 | 0.0201
713448108 | PEP | PEPSICO | INC | 13815 | 876147 | 0.0193
931142103 | WMT | WAL-MART | STORES | INC | 16290 | 846754 | 0.0187
04621X108 | AIZ | ASSURANT | INC | 17895 | 727074 | 0.016
G0450A105 | ACGL | [NAME] | CAPITAL | GROUP | 7810 | 706805 | 0.0156
Y93691106 | VRGY | VERIGY | LTD | 53730 | 696878 | 0.0154
30225X103 | EXH | EXTERRAN | HLDGS | INC | 24815 | 563301 | 0.0124
845467109 | SWN | SOUTHWESTERN | ENERGY | CO | 11680 | 461126 | 0.0102
701094104 | PH | PARKER-HANNIFIN | CORP | 5140 | 458385 | 0.0101
17275R102 | CSCO | CISCO | SYSTEMS | INC | 22470 | 417043 | 0.0092
Spreadsheet: 109229d1306159444-countif-max-if-sumif-with-date-example
Sheet: Days Out Summary

FY11
 | Type of Work Order | Total Number of Work Orders | Average Total Days Open | Max Days Open | [NAME] | Min Days Open
Total | Closed | 313 | 38.87859424920128 | 169 | #N/A | 0
Total | Open | 79 | 61.65822784810127 | 216 | #N/A | 3
District | Type of Work Order |  | Average Total Days Open | Max Days Open |  | Min Days Open
1 | Closed |  | 31.68535825545171
 | Open |  | 9.436
2 | Closed |  | 34.54716981132076
 | Open |  | 11.67924528301887
Commander | Type of Work Order |  | Average Total Days Open | Max Days Open |  | Min Days Open
Beach | Closed |  | 44.47236180904522
 | Open |  | 10.68844221105528
Buschy | Closed |  | 29.3125
 | Open |  | 0
[NAME] | Closed |  | 35.9
 | Open |  | 17.1
Osborne | Closed |  | 33.56666666666667
 | Open |  | 16.1
Feeney | Closed |  | 11.68292682926829
 | Open |  | 1.48780487804878
Wilmore | Closed |  | 50.71428571428572
 | Open |  | 19.42857142857143
System Type | Type of Work Order |  | Average Total Days Open | Max Days Open |  | Min Days Open
Access Control | Closed |  | 83.14285714285714
 | Open |  | 0
Alarm | Closed |  | 10.97228381374723
 | Open |  | 3.64079822616408
Barrier | Closed |  | 57
 | Open |  | 0
CCTV | Closed |  | 20.92
 | Open |  | 13.6
Comms | Closed |  | 26
 | Open |  | 0
GSA | Closed |  | 11.5
 | Open |  | 21.43333333333333
Metal Detector | Closed |  | 51.5
 | Open |  | 0
[NAME] | Closed |  | 28.25
 | Open |  | 63.75
Spreadsheet: 91219d1290978984-lookup-closest-match-sample-1-
Sheet: Sheet1

Item | Date | Cost
1648 | 2010-07-14 00:00:00 | 8 | 8
1648 | 2010-07-02 00:00:00 | 9.25 | 9.25
1648 | 2010-06-17 00:00:00 | 0 | 9.25
1648 | 2010-04-22 00:00:00 | 9.25 | 9.25
1648 | 2010-03-19 00:00:00 | 9.25 | 9.25
1649 | 2009-01-26 00:00:00 | 0 | 0
1649 | 2008-08-01 00:00:00 | 8 | 8
1649 | 2008-07-25 00:00:00 | 8 | 8
1650 | 2010-08-16 00:00:00 | 0 | 0
11026 | 2008-03-25 00:00:00 | 14.95 | 14.95
11030 | 2008-03-25 00:00:00 | 0 | 0
1648 | 2010-07-14 00:00:00 | 0 | 9.25
1648 | 2010-07-14 00:00:00 | 9.25 | 9.25
Spreadsheet: 695279d1600123898-formula-to-extract-value-from-2-rows-below-excel-file
Sheet: Sheet2

Category | Identifier | Value | Type | Country | Instrument | Bid | Ask |  |  |  | helper
Spreadsheet: 811312d1672402792-mround-but-to-round-to-nearest-quarter-book4
Sheet: Sheet1

0.1432
0.20456
0.26592
0.32728
0.38864
0.45
0.51136
0.57272
0.63408
0.69544
0.7568
0.81816
0.87952
0.94088
1.00224
1.0636
1.12496
1.18632
1.24768
1.30904
1.3704
Spreadsheet: 107023d1304174615-percentage-used-formula-percentused
Sheet: Sheet1

UNIT 3
Date | Time | Battery | [NAME] |  |  | Date | Time | Battery | [NAME]
2011-04-26 00:00:00 | 00:06:30 | 1 | 1.1 |  |  | 2011-04-26 00:00:00 | 00:06:30 | 0.8 | 1.1
2011-04-28 00:00:00 | 01:45:55 | 0.9 | 74.1
2011-04-29 00:00:00 | 01:58:34 | 0.86 | 69.9
Totaled | 03:50:59 | 0.14 | 145.1 | or if it doesn’t start at 100%>>>>>>> |  | Totaled | 00:06:30 | 0.2 | 1.1
 |  | amount used |  |  |  |  |  | amount used
Spreadsheet: 24f3dd62-be66-42f4-afbc-c5ebcd24fd09
Sheet: zestawienie

 | ZESTAWIENIE WYDATKÓW <<[NAME] nazwę akcji, jednostkę, datę>>
 | L.p. | [NAME] | [NAME] | Saldo | Rodzaj i numer dokumentu | Data wystawienia | Wydatki razem | Żywność | KwZZŻ | Materiały i sprzęt | Przejazdy uczestników | Usługi transportowe | [NAME] telekomunik. | Ubezpieczenia | Pozostałe usługi | Podróże służbowe | Pozostałe wydatki
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 |  | RAZEM:
 |  | kwota słownie: |  |  | <<wpisz tu kwotę>>
 |  | [NAME] (do [NAME] punktów)
 | 1. | Niniejszym zestawieniem rozliczam [NAME] |  |  |  |  | 0
 |  | otrzymaną na konto osobiste w dniu |  |  |  | [NAME]
 | 2. | [NAME] |  |  |  | otrzymałem.
 |  |  |  |  |  | podpis
Spreadsheet: 274422d1383115476-sum-if-formula-sample
Sheet: calculations

 | Calculations | SUMIFS("tblFailed[Grand [NAME]))
 | Selected year | September | September
 | Selected Product | TalkTalk Plus TV | TalkTalk Plus TV | 1
 | Selected Region | Manila (Transcom) | Manila (Transcom)
 |  |  |  |  |  | Data for the chart
 | Product-wise Sales | Sales ($)
 | LOBS | Manila ([NAME]) | Manila (Transcom) | All Regions |  | LOBS | Manila ([NAME]) | Manila (Transcom) | All Regions | Highlighted
 | AOL Collections (ST) |  |  |  |  | AOL Collections (ST)
 | Collections (ST) |  |  |  |  | Collections (ST)
 | CS&B (ST) |  |  |  |  | CS&B (ST)
 | Customer Service Management |  |  |  |  | Customer Service Management
 | HM 1st Line (ST) |  |  |  |  | HM 1st Line (ST)
 | HM Loyalty (ST) |  |  |  |  | HM Loyalty (ST)
 | Logistic Ops |  |  |  |  | Logistic Ops
 | Onetel Collections |  |  |  |  | Onetel Collections
 | Onetel CS&B/Tech |  |  |  |  | Onetel CS&B/Tech
 | Other |  |  |  |  | Other
 | [NAME] (ST) |  |  |  |  | [NAME] (ST)
 | TalkTalk Plus TV |  |  |  |  | TalkTalk Plus TV
 | TalkTalk TV |  |  |  |  | TalkTalk TV
 | Tech Inbound |  |  |  |  | Tech Inbound
 | Tech Inbound MBORC |  |  |  |  | Tech Inbound MBORC
 | TT Mobile (ST) |  |  |  |  | TT Mobile (ST)
 | TTB Migration |  |  |  |  | TTB Migration
 | TTB SME - Credit Control |  |  |  |  | TTB SME - Credit Control
 | TUK Collections (ST) |  |  |  |  | TUK Collections (ST)
 | TV Customer Service Management |  |  |  |  | TV Customer Service Management
 | TV Fault Management |  |  |  |  | TV Fault Management
 | TV FM Escalations |  |  |  |  | TV FM Escalations
 | TV Self Install |  |  |  |  | TV Self Install
 | Unassigned |  |  |  |  | Unassigned
 | Monthly Break Down |  |  |  |  | Title
 | Month | Manila - Edsa | Manila - Tiende | All |  | Transfer Failure in Manila (Transcom) - September
 | January | #N/A | #N/A | #N/A
 | February | #N/A | #N/A | #N/A |  | 1
 | March | #N/A | #N/A | #N/A |  | Hide help
 | April | #N/A | #N/A | #N/A
 | May | #N/A | #N/A | #N/A
 | June | #N/A | #N/A | #N/A
 | July | #N/A | #N/A | #N/A
 | August | #N/A | #N/A | #N/A
 | September | #N/A | #N/A | #N/A
 | October | #N/A | #N/A | #N/A
 | December | #N/A | #N/A | #N/A
Spreadsheet: 755544d1636949298-how-to-sum-values-if-criteria-matches-file-1
Sheet: Sheet1

Auto+Hide
 | SG. AKAR (P23)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 |  |  | 2022
 | No | [NAME] | Customer | corporate | Location | Project | 2021 |  |  | 2022 |  |  |  | CRC Name | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JULY | AUG | SEPT | OCT | NOV | DEC
 |  |  |  |  |  |  | OCT | NOV | DEC | JAN | FEB | MAR |  | Eng
 | 17 | Eng | [NAME] | Corporate | [NAME] | 1 Unit Residential | 30 | 30
 | 18 | Eng | [NAME] | Corporate | Lambak [NAME] | Primary School Hall | 80
 | 41 | Eng | Walltique | Corporate | [NAME] | [NAME] | 20 | 20 | 20 | 20 | 20 | 20
 | 42 | Eng | WLW Developer | Corporate | [NAME] | 9 Units High End Bungalow | 50 | 50 | 50 | 50 | 50 | 50
 | 43 | Eng | WLW Developer | Corporate | Empire | [NAME] at Empire Group | 50 | 50 | 50 | 50 | 50 | 50
 | 44 | Eng | WLW Developer | Corporate | Seri, [NAME] | The One Mall
 | 45 | Eng | WLW Developer | Corporate | Stadium | Football | 50 | 50 | 50 | 50 | 50 | 50
Spreadsheet: chris_germany__2698__May00_FOM_Final
Sheet: FOM May Storage

 |  |  | May 2000
 |  | First-of-the Month Baseload Storage Injections/(Withdrawals)
 |  |  | Monthly | Daily
 |  |  | Inj/(WD) | Inj/(WD)
LDC |  | Pipe/Service | Dth# | Dth#
Atlanta Gas Light
 | IBSS
 |  | Transco / AGL City Gate## |  | 2286
 |  | Sonat / ANR Shadyside |  | 4006
 | DAS | [NAME] WSS | 65503
 |  | Transco ESS | 3968
 |  | Tennessee FS-MA | -17190
 |  | Tennessee FS-PA | -43230
 |  | CNG | 0
 |  | SONAT | 144491
Columbia Gas of Ohio
 |  | TCO FSS | 1089109
##IBSS injections on [NAME] at AGL citygate are not included in Transco citygate requirements in "Total Reqs" worksheet.
Spreadsheet: 845137d1696664414-generate-a-receipt-from-repeat-customer-file-hotel
Sheet: Data

Direct |  | 1 |  | BACS
Booking |  | 2 |  | Cheque |  | 2 [NAME]
 |  | 3 |  | Cash |  | 3 [NAME]
 |  | 4 |  |  |  | 4 Karen Douglas
 |  | 5 |  |  |  | 5 [NAME]
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
Spreadsheet: 880933d1728776892-can-a-pivot-table-be-tweaked-to-produce-user-defined-results-which-may-not-be-normal-pkg-data-maheshk5277-
Sheet: Pivot

L1_SITE_NAME | L1_PRODUCT_NAME | [NAME] | L1_SKU NUMBER | L3_COMPONENT_SUB_TYPE | L3_PACKAGING MATERIAL DESCRIPTION |  | When any particular filter on Column F (in this case "Push through 20um Aluminium hard HSL 7g/m2") is applied, I want the clolumn E (L3_COMPONENT TYPE) to show its corresponding 'Film' results also.  The filter currently gives the result (which is obvious) for all rows where the selection is appearing. However, because any single product (i.e. SKU) will have both film & foil for its blister pack construction. Hence need to explore if there is any way to produce the results where the 'selection' appears but also the corresponding'foil' result also will appear for the SKUs which have the selected entity as 'Foil'
Site 1 | VAL | Valaciclovir | P-132327-01 | Film | PVC 300
Site 1 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132328-01 | Film | PVC 300
Site 1 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 1 | VAL | Valaciclovir | P-132333-01 | Film | PVC 250
Site 1 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132352-01 | Film | PVC 250
Site 2 | VAL | Valaciclovir | P-132352-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132353-01 | Film | PVC 250
Site 2 | VAL | Valaciclovir | P-132353-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 2 | VAL | Valaciclovir | P-132369-01 | Film | PVC 300
Site 2 | VAL | Valaciclovir | P-132369-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 3 | VAL | Valaciclovir | P-132463-01 | Film | PVC 300
Site 3 | VAL | Valaciclovir | P-132463-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132327-01 | Film | PVC 300
Site 4 | VAL | Valaciclovir | P-132327-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132328-01 | Film | PVC 300
Site 4 | VAL | Valaciclovir | P-132328-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132333-01 | Film | PVC 250
Site 4 | VAL | Valaciclovir | P-132333-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132352-01 | Film | PVC 250
Site 4 | VAL | Valaciclovir | P-132352-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Site 4 | VAL | Valaciclovir | P-132353-01 | Foil | [NAME] through 20µm Aluminium hard HSL 7g/m²
Spreadsheet: 838433d1691005468-artificial-grand-total-above-pivot-that-still-aligns-with-unit-after-slicers-used-sample-data
Sheet: Pivot

UnitID | (All)
"Artificial" Grand Total Row
 | Column Labels
 | Sum of Paid | Sum of PO Amount | Total Sum of Paid | Total Sum of PO Amount
Row Labels | DEF | DEF
FY16 | 200 | 9000 | 200 | 9000
Store 3 | 200 | 9000 | 200 | 9000
B Street Food Company | 200 | 9000 | 200 | 9000
[NAME] | 200 | 9000 | 200 | 9000
FY19 | 2000 | 60000 | 2000 | 60000
Store 3 | 2000 | 60000 | 2000 | 60000
B Street Food Company | 2000 | 60000 | 2000 | 60000
[NAME] | 2000 | 60000 | 2000 | 60000
Grand Total | 2200 | 69000 | 2200 | 69000
Spreadsheet: e253567e-ae4f-4a5b-adb6-8f50977d7d60
Sheet: Sheet1

 |  |  | City School-Karachi, Pakistan |  |  |  |  | Maiden Erlegh School, UK
 |  |  | Temp C | Humidity % | Pressure mb | Wind direction | Remarks | Temp C | Humidity % | Pressure mb | Wind direction | Remarks
Monday | 2011-10-03 00:00:00 | 10:00:00 | 29 | 71 | 997 | W | Partially cloudy | 20 | 69 | 1020.3 | SW | Partially cloudy
Monday |  | 12:00:00 | 29 | 71 | 997 | W | Partially sunny | 23.6 | 56 | 1019.6 | SSW | Partially cloudy
Monday |  | 14:00:00 | 29 | 71 | 995 | W | Partially cloudy | 24.8 | 49 | 1018.6 | WNW | Partially cloudy
Tuesday |  | 10:00:00 | 28 | 71 | 997 | W | Partially cloudy | 15.1 | 92 | 1021.3 | W | Cloudy
Tuesday |  | 12:00:00 | 28.9 | 70 | 996 | W | Partially cloudy | 15.5 | 94 | 1021.6 | WNW | Rain
Tuesday |  | 14:00:00 | 29.5 | 70 | 995 | W | Sunny | 17.9 | 75 | 1021 | W | Cloudy
Wednesday |  | 10:00:00 | 28 | 74 | 1000 | W | Sunny | 16.9 | 84 | 1019 | WSW | Cloudy
Wednesday |  | 12:00:00 | 29.8 | 71 | 1000 | W | Sunny | 17.8 | 77 | 1019 | W | Cloudy
Wednesday |  | 14:00:00 | 30.3 | 68 | 999 | W | Sunny | 18.7 | 77 | 1017.3 | W | Cloudy
Thursday |  | 10:00:00 | 28.6 | 73 | 1003 | W | Partially cloudy | 11.5 | 65 | 1012.2 | WNW | Cloudy
Thursday |  | 12:00:00 | 29.2 | 70 | 1002 | W | Partially cloudy | 12.3 | 63 | 1012.9 | WNW | Rainy
Thursday |  | 14:00:00 | 30.3 | 64 | 1001 | W | Partially cloudy | 14.4 | 54 | 1012.2 | WNW | Cloudy
Friday |  | 10:00:00 | 29.1 | 71 | 1002 | W | Sunny | 11.7 | 80 | 1019 | WNW | Partially cloudy
Friday |  | 12:00:00 | 31.2 | 66 | 1002 | W | Sunny | 13.9 | 73 | 1019.6 | W | Partially cloudy
Friday |  | 14:00:00 | 31.6 | 62 | 999 | W | Sunny | 15.7 | 61 | 1020 | WSW | Partially cloudy
Monday | 2011-10-10 00:00:00 | 10:00:00 | 29 | 71 | 1003 | To West | Sunny | 16.8 | 80 | 1019 | WNW | Partially cloudy
Monday |  | 12:00:00 | 31 | 64 | 1002 | To West | Sunny | 17.2 | 81 | 1019 | WNW | Partially cloudy
Monday |  | 14:00:00 | 31 | 54 | 1001 | To West | Sunny | 18.2 | 73 | 1018 | W | Partially cloudy
Tuesday |  | 10:00:00 | 28.5 | 66 | 1004 | To near West | Sunny | 15.5 | 90 | 1020 | W | Partially cloudy
Tuesday |  | 12:00:00 | 31.1 | 55 | 1003 | To near West | Sunny | 17 | 84 | 1020 | SW | Partially cloudy
Tuesday |  | 14:00:00 | 32.6 | 48 | 1002 | To near West | Sunny | 17.6 | 80 | 1020 | W | Partially cloudy
Wednesday |  | 10:00:00 | 29 | 61 | 1004 | Near to west | Sunny | 15.1 | 86 | 1021.3 | W | Partially cloudy
Wednesday |  | 12:00:00 | 31.9 | 53 | 1002 | Near to west | Sunny | 16.1 | 86 | 1021 | WNW | Partially cloudy
Wednesday |  | 14:00:00 | 32.9 | 46 | 1000 | Near to west | Sunny | 18.6 | 77 | 1020.7 | WNW | Partially cloudy
Spreadsheet: e6977f6a-a5f1-4ee2-9ab3-af92c6a2cb63
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
6036 | 11084 | Margit | Vanek | HUN | 66 | 00:00:00 | 00:00:00 | [NAME] | 00:00:58 | 00:08:36 | 1 | 00:22:22
6036 | 17056 | Szandra | Szalay | HUN | 63 | 00:00:00 | 00:00:00 | 00:13:16 | 00:01:00 | 00:08:46 | 2 | 00:23:02
6036 | 39913 | Gaia | Peron | ITA | 65 | 00:00:00 | 00:00:00 | 00:12:46 | 00:01:02 | 00:09:20 | 3 | 00:23:07
6036 | 5854 | Birgit | Cals-Berk | NED | 61 | 00:00:00 | 00:00:00 | 00:13:29 | 00:01:00 | 00:09:22 | 4 | 00:23:51
6036 | 17670 | Sara | Vilic | AUT | 0 | 00:00:00 | 00:00:00 | 00:13:13 | 00:01:04 | 00:10:24 | 5 | 00:24:41
6036 | 7013 | Evgenia | Sukhoruchenkova | RUS | 62 | 00:00:00 | 00:00:00 | 00:14:38 | 00:01:10 | 00:09:26 | 6 | 00:25:14
Spreadsheet: 266361d1379592919-count-the-number-of-varying-rows-if-the-date-cell-on-that-row-is-a-particular-month-rdow1988
Sheet: Sheet1

Event# | Date | Unique Count
1 | 2013-06-24 00:00:00
1 | 2013-06-24 00:00:00
2 | 2013-06-24 00:00:00
2 | 2013-06-24 00:00:00
2 | 2013-06-24 00:00:00
3 | 2013-07-18 00:00:00
3 | 2013-07-18 00:00:00
3 | 2013-07-18 00:00:00
3 | 2013-07-18 00:00:00
4 | 2013-08-12 00:00:00
4 | 2013-08-12 00:00:00
5 | 2013-08-15 00:00:00
6 | 2013-08-28 00:00:00
Spreadsheet: 769260d1645441571-wastage-calculator-help-minimisecutlengths
Sheet: Sheet1

 |  | Length Required | 4.6
 |  | Cut Lengths
 |  | Waste
 |  | Lengths | Use | Length Used
 |  | 0.62 | 1 |  |  |  | 1
 |  | 0.75 | 1 |  |  |  | 1
 |  | 0.86 | 1 |  |  |  | 1
 |  | 0.86 | 1 |  |  |  | 1
 |  | 1.05 | 1 |  |  |  | 1
 |  | 1.05 | 1 |  |  |  | 1
 |  | 1.23 | 1 |  |  |  | 1
 |  | 1.26 | 1 |  |  |  | 1
 |  | 1.85 | 1 |  |  |  | 1
 |  | 1.87 | 1 |  |  |  | 1
 |  | 1.87 | 1 |  |  |  | 1
 |  | 1.99 | 1 |  |  |  | 1
 |  | 2.05 | 1 |  |  |  | 1
Spreadsheet: 787207d1657689706-formula-to-highlight-the-mandatory-fields-which-is-not-filled-cf-highlight-mandatory-fields-data-load-aligw
Sheet: Sheet1

Mat.Type | Mandatory fields
FER | MATNR
FER | MBRSH
FER | MTART
FER | WERKS
FER | VKORG
FER | VTWEG
FER | MATKL
FER | [NAME]
FER | MAKTX
FER | BSTME
[NAME] | MATNR
[NAME] | MBRSH
[NAME] | MTART
[NAME] | WERKS
[NAME] | VKORG
[NAME] | VTWEG
[NAME] | MATKL
HAL | MATNR
HAL | MBRSH
HAL | MTART
HAL | WERKS
HAL | VKORG
HAWA | MATNR
HAWA | MBRSH
HAWA | MTART
HAWA | WERKS
HAWA | VKORG
HAWA | VTWEG
HAWA | MATKL
HAWA | [NAME]
HAWA | MAKTX
HAWA | BSTME
Spreadsheet: 770496d1646122751-adding-an-activity-duration-in-hours-to-a-start-date-with-time-time-duration-work-hours-aligw
Sheet: Schedule

 |  |  |  |  |  |  | day_start | day_end
 |  |  |  |  |  |  | 6:00:00 | 18:00:00
 |  |  |  | Details
 | SN |  |  |  | Description |  |  |  |  | ind. Start |  |  |  |  |  |  | Work hours |  | Planned End (Based on formula) | AliGW | Planned End (Required Result)
 | 1 |  |  |  | Header
 | 2 |  |  |  | Header
 | 3 |  |  |  | Main Activity Header
 | 4 |  |  |  | Main Asset
 | 5 |  |  |  | ERECT SCAFFOLDING |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 8 |  |  |  | 2022-01-17 14:00:00
 | 6 |  |  |  | ELECTRICAL ISOLATION |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 12 |  |  |  | 2022-01-17 18:00:00
 | 7 |  |  |  | FAN BELT DRIVEN |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 13 |  |  |  | 2022-01-18 07:00:00
 | 8 |  |  |  | RIGGING ASSITANCE |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 24 |  |  |  | 2022-01-18 18:00:00
 | 9 |  |  |  | REINSTATE ELECTRICAL CONNECTION |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 36 |  |  |  | 2022-01-19 18:00:00
 | 10 |  |  |  | REMOVE SCAFFOLDING |  |  |  |  | 2022-01-17 06:00:00
Spreadsheet: 55988d1256136606-help-with-an-if-statement-new-check-sheet
Sheet: Sheet1

UPS | Target
Bag 1
Bag 2
Parcel
Frieght
Goods In - Check Sheet |  |  |  |  |  |  |  |  | Parcels:
 |  |  |  |  |  |  |  |  | Weight:
Code | Postcode | Advice No | P&P | Label | No. Par | [NAME] | Wgt | Courier | Pack Type | Del Type
W01 | DN226BE | 71150 | WR | WR | 1 | 1 | 1 | Target | 0
Spreadsheet: 213868d1360679735-count-if-the-data-mathces-new
Sheet: Summary

 |  |  |  |  | Total OF Date 1, DAte2, Date3
 |  |  |  |  | MF8330 |  | X543 |  | c5045 |  | x940
 |  |  |  | Black
 |  |  |  | [NAME]
 |  |  |  | Magenta
 |  |  |  | Yellow
Spreadsheet: 065c8af7-72ec-4afb-871e-165048fc002d
Sheet: ID-CPA-016 

 |  |  | Prescribed Grazing - 528 , Brush Management - 314 |  |  |  |  |  |  |  |  |  | ID-CPA-016 100 point
 |  |  | Upland Wildlife Habitat Management - 645
 |  |  | Line Point Intercept |  |  |  |  |  |  |  |  |  | Idaho
Natural Resources Conservation Service |  |  |  |  |  |  |  |  |  |  |  |  | January 2014
 | Observer |  |  |  | Location
 | Plot # |  | Line # |  | Recorder |  |  |  | Line Length |  | m or ft?
 | Direction |  | Date |  |  |  |  | Intercept (Point) Spacing Interval |  |  |  | Intercept and height units
 | Top |  | Lower Canopy Layers |  |  | Soil |  | Top |  | Lower Canopy Layers |  |  | Soil
Pt. | Canopy | Ht. | Code1 | Code2 | Code3 | Surface | Pt. | Canopy | Ht. | Code1 | Code2 | Code3 | Surface
1 |  |  |  |  |  |  | 51
2 |  |  |  |  |  |  | 52
3 |  |  |  |  |  |  | 53
4 |  |  |  |  |  |  | 54
5 |  |  |  |  |  |  | 55
6 |  |  |  |  |  |  | 56
7 |  |  |  |  |  |  | 57
8 |  |  |  |  |  |  | 58
9 |  |  |  |  |  |  | 59
10 |  |  |  |  |  |  | 60
11 |  |  |  |  |  |  | 61
12 |  |  |  |  |  |  | 62
13 |  |  |  |  |  |  | 63
14 |  |  |  |  |  |  | 64
15 |  |  |  |  |  |  | 65
16 |  |  |  |  |  |  | 66
17 |  |  |  |  |  |  | 67
18 |  |  |  |  |  |  | 68
19 |  |  |  |  |  |  | 69
20 |  |  |  |  |  |  | 70
21 |  |  |  |  |  |  | 71
22 |  |  |  |  |  |  | 72
23 |  |  |  |  |  |  | 73
24 |  |  |  |  |  |  | 74
25 |  |  |  |  |  |  | 75
26 |  |  |  |  |  |  | 76
27 |  |  |  |  |  |  | 77
28 |  |  |  |  |  |  | 78
29 |  |  |  |  |  |  | 79
30 |  |  |  |  |  |  | 80
31 |  |  |  |  |  |  | 81
32 |  |  |  |  |  |  | 82
33 |  |  |  |  |  |  | 83
34 |  |  |  |  |  |  | 84
35 |  |  |  |  |  |  | 85
36 |  |  |  |  |  |  | 86
37 |  |  |  |  |  |  | 87
38 |  |  |  |  |  |  | 88
39 |  |  |  |  |  |  | 89
40 |  |  |  |  |  |  | 90
41 |  |  |  |  |  |  | 91
42 |  |  |  |  |  |  | 92
43 |  |  |  |  |  |  | 93
44 |  |  |  |  |  |  | 94
45 |  |  |  |  |  |  | 95
46 |  |  |  |  |  |  | 96
47 |  |  |  |  |  |  | 97
48 |  |  |  |  |  |  | 98
49 |  |  |  |  |  |  | 99
50 |  |  |  |  |  |  | 100
 |  |  |  |  |  | Notes:
% canopy cover = |  |  |  | Average Height:
% bare ground =
% basal cover =
 | Unknown Species Codes: |  | [NAME] (do not use litter):
 | AF# [NAME] annual forb |  | Species Code (for basal intercept)
 | PF# = perennial forb |  | R = rock fragment (>5 mm (~1/4 in) |  |  |  | *Bare ground occurs ONLY when Top canopy = NONE, Lower canopy layers are empty (no L), and Soil surface = S.
 | AG# = annual graminoid |  | diameter)
 | PG# = perennial graminoid |  | BR = bedrock, M = moss
 | SH# = shrub |  | LC = visible lichen crust on soil
 | TR# = tree |  | S = soil without any other soil surface code
 |  |  | EL = embedded litter (see page 10)
 |  |  | D = duff