tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220309d1363117016-if-function-with-2-columns-confusion-glucometer-expenditure-edited
Sheet: Sheet1

[NAME]
Date | Office | PO/Invoice | Debit | Credit |  | Balance
2013-01-01 00:00:00 | Clinic-A | Inventory from 2012 | 36.1
2013-03-04 00:00:00 | Clinic-A | 2013-215 |  | 54.5
2013-03-06 00:00:00 | Clinic-C | 2013-250 |  | 32.3
2013-03-12 00:00:00 | Clinic-B | 2013-324 | 87.5
2013-03-12 00:00:00 | Clinic-F | 2013-325
2013-03-12 00:00:00 | Clinic-K | 2013-326
Spreadsheet: 04ac40d8-7e78-4352-97ce-9873fa4e62e3
Sheet: 4.2(UK) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(UK): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | UK - Unknown
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | na | na | na | na
Notes:
Spreadsheet: 841103d1693350805-average-for-different-scenarios-formula-toupdate
Sheet: Scenario4

Long (purchased |  |  |  |  | [NAME] left part (yellow) with explanation
Entry Date | Exit Date | # of  Contracts | Strike Purchased |  | Date | Long | Short | Margin | Calculation
2023-08-14 00:00:00 | 2023-08-17 00:00:00 | 2 | 100 |  | 2023-08-14 00:00:00 | 1000 | 100 | 105 | (105-100)*2 (number of contracts) * 100 => 5 * 2 * 100 => 1000
2023-08-15 00:00:00 | 2023-08-17 00:00:00 | 1 | 105 |  | 2023-08-15 00:00:00 | 500 | 102.5 | 105 | (105-102.50 [average between 105&100])*2 (number of contracts) * 100 => 2.5 * 2 * 100 => 500 | (Closed one of the two 100 contracts and bought one 105 contract with it)
2023-08-17 00:00:00 | 2023-08-18 00:00:00 | 2 | 110 |  | 2023-08-16 00:00:00 | 1500 | 102.5 | 110 | (110-102.50)*2 (number of contracts) * 100 => 7.5 * 2 * 100 => 1500
 |  |  |  |  | 2023-08-17 00:00:00 | 1000 | 110 | 115 | (115-110) * 2 (number of contracts) * 100 => 5 * 2 * 100 => 1000
Short (sold) |  |  |  |  | 2023-08-18 00:00:00 | Closed
Entry  Date | Exit Date | # of  Contracts | Strike Sold |  |  | Average | Current
2023-08-14 00:00:00 | 2023-08-16 00:00:00 | 2 | 105 |  |  | 1000 | 1000
2023-08-16 00:00:00 | 2023-08-17 00:00:00 | 2 | 110
2023-08-17 00:00:00 | 2023-08-18 00:00:00 | 2 | 115
Spreadsheet: frank_ermis__11124__West NatGas Prices 1030
Sheet: Gas Average FinIdx

FinIdx Curves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS PRICES- Fin Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month | 2001-10-01 00:00:00
 |  |  |  |  | 2001-10-31 00:00:00 |  |  |  | Date Start |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | 2002-01-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Date End |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-03-01 00:00:00
 |  | WEST REGION BASIS NOTIONAL |  | Intra-Month | Basis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IntraMonth Match |  | Basis Match
 |  | NGI-PGE/CG |  | NGI-PGE/CG | GD-PG&E/CITIGAT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | GDP-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | GDP-MALIN-CTYGA
 |  | NGI-SOCAL |  | NGI-SOCAL | GDP-CAL BORDER
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | GDP-ELPO/SANJUA
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | GDP-ELPO/PERM2
 |  | WAHA |  | IF-WAHA-TX | GDP-WAHA
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | GDP-NGPL/OK
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | GDP-KERN/OPAL
 |  | STANFIELD |  | NW-STANFIELD | GD-NW STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | GDP-NTHWST/CANB
 |  | AECO |  | CGPR-AECO/USIM | [NAME]
 |  | CIG |  | IF-CIG/RKYMTN | GDP-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | GDP-HEHUB | NG
Spreadsheet: 165044d1340996273-countif-based-on-formatting-use-din-array-nopasswordthistime
Sheet: LookupByTeam

 |  |  |  | Course 1 | Course 2 | Course 4 | Course 5 | Course 6
 |  |  | OOD
 |  |  |  | 1 | 1 | 1 | 1
 | Team 1 |  |  | Annual | Annual | Annual | Annual
 |  |  | No of staff to be trained |  |  |  |  |  | <- counts the number of cells below which do not contain "N/A" or a date within brackets (15/03/12) (Feb-12)
 |  |  | No of staff trained |  |  |  |  |  | <- Counts the number of cells with a date which is less than the date in row 5
 |  |  | Percentage of target achieved |  |  |  |  |  | <-Calculates the percentage
 | TEAM 1 | Name 1 | Name 1 | N/A | N/A |  | 2011-03-31 00:00:00 | N/A
 | TEAM 1 | Name 133 | Name 133 | (15/02/11) | N/A |  | 2011-12-31 00:00:00 | N/A
 | TEAM 1 | Name 265 | Name 265 | (Feb-12) | N/A | (Due aug 13) | 2011-03-31 00:00:00 | N/A
 | TEAM 1 | Name 397 | Name 397 | 2012-05-15 00:00:00 | N/A | 2011-11-01 00:00:00 |  | N/A
 | TEAM 1 | Name 529 | Name 529 | (booked) | N/A |  | 2011-12-31 00:00:00 | N/A
 | TEAM 1 | Name 661 | Name 661 |  | N/A | 2010-12-07 00:00:00 | 2012-03-15 00:00:00 | N/A
 | TEAM 1 | Name 793 | Name 793 | 2012-02-16 00:00:00 | N/A |  | 2011-12-31 00:00:00 | N/A
Spreadsheet: 749506d1632843632-gantt-chart-mark-cells-within-date-range-gantt-chart-with-conditions-hennair-
Sheet: Personalkonzept

Title
PersonC
Anzeigen ab: | 2021-08-01 00:00:00
[NAME]: | 78
Kompetenz
Stab T
Spreadsheet: 682649d1592236649-rank-values-with-non-sequential-data-and-ignore-text-rank-non-sequential-and-ignore-text
Sheet: Sheet1

 | This is the cell want formula for | 10 columns between each Annual Savings column per Company
Annual Savings | Rank | Annual Savings | Annual Savings | Annual Savings | Annual Savings | Annual Savings | Annual Savings | Annual Savings
-2076.953506999999 | 3 | No Quote | No Quote | No Quote | -26565.98694562424 | 58284.46723088475 | 7064.825699999996 | No Quote
[NAME] in Annual Savings is =IFERROR(IF($Q11="","",($E11-Q11)*$F11),"No Quote")
Annual Savings | Rank | Annual Savings | Annual Savings | Annual Savings | Annual Savings | Annual Savings | Annual Savings | Annual Savings
-2076.953506999999 |  | No Quote | No Quote | No Quote | -26565.98694562424 | 58284.46723088475 | 7064.825699999996 | No Quote | Rank should be 3
-5816.500566924007 |  | No Quote | No Quote | -11138.5224 | 3139.845501221122 | 11989.90577466654 | 7954.517599999999 | -1110.779914048069 | Rank should be 5
-66.01720607999981 |  | No Quote | No Quote | No Quote | 99.34104707648353 | 532.7974308801813 | 454.1124000000002 | No Quote | Rank should be 4
39780.34610088001 |  | No Quote | No Quote | No Quote | 64212.16061981845 | 344390.1107984563 | 230817.7256000001 | No Quote | Rank should be 4
29136.30476904001 |  | No Quote | No Quote | No Quote | 47030.89000163806 | 252241.5265624173 | 169057.7448 | No Quote | Rank should be 4
Spreadsheet: 558666d1517257060-attendance-tracker-ref-errors-attendance-tracker-workbook
Sheet: Company Holidays

 | Company Holidays |  | Year | 2018
 | Holiday | Date | Day of Week
 | New Year's Day
 | [NAME]
 | President's Day
 | Memorial Day
 | Independence Day
 | Labor Day
 | Columbus Day
 | Veteran's Day
 | Thanksgiving Day
 | Christmas Day
Spreadsheet: 156258d1337246039-one-lookup-value-multiple-matches-book1
Sheet: Statement

[NAME]
Statement
Date
Address | Month Paid | Date Paid | Amount Paid | Other Income | Management Fee | Total
 | May
 | May
 | May
 | May
 | May
Total Income
Property Maintenance
Spreadsheet: 801016d1666029285-need-to-add-match-mode-of-positive-1-to-xlookup-rows-and-columns-formula-find-nearest-match
Sheet: MILEAGE

 | DISTANCES
 | SITES | DEPOT | Site 2 | Site 3 | Site 4 | Site 5 | Site 6 | Site 7 | Site 8 | Site 9 | Site 10
 | DEPOT |  | 43 | 44 | 26 | 47 | 36 | 29 | 37 | 24 | 50
 | Site 2 | 43 |  | 21 | 17 | 47 | 14 | 29 | 15 | 32 | 26
 | Site 3 | 44 | 21 |  | 30 | 16 | 15 | 30 | 29 | 22 | 20
 | Site 4 | 26 | 17 | 30 |  | 37 | 30 | 40 | 22 | 38 | 42
 | Site 5 | 47 | 47 | 16 | 37 |  | 40 | 24 | 31 | 23 | 29
 | Site 6 | 36 | 14 | 15 | 30 | 40 |  | 40 | 24 | 31 | 23
 | Site 7 | 29 | 29 | 30 | 40 | 24 | 40 |  | 35 | 34 | 17
 | Site 8 | 37 | 15 | 29 | 22 | 31 | 43 | 35 |  | 22 | 16
 | Site 9 | 24 | 32 | 22 | 38 | 23 | 49 | 34 | 22 |  | 31
 | Site 10 | 50 | 26 | 20 | 42 | 29 | 20 | 17 | 16 | 31
Spreadsheet: 1cc0e7e7-0498-4070-a10c-0d9a4736d5b6
Sheet: Sheet1

amino acid | [NAME] | S. cerevisiae | C. trachomatis | E. coli K12 | G. obscuriglobus | Gemmata MC
Gly | GGG | 0.12 | 0.17 | 0.15 | 0.36 | 0.33
Gly | GGA | 0.22 | 0.51 | 0.11 | 0.1 | 0.05
Gly | GGT | 0.47 | 0.2 | 0.34 | 0.13 | 0.09
Gly | GGC | 0.19 | 0.13 | 0.4 | 0.41 | 0.51
[NAME] | GAG | 0.3 | 0.31 | 0.31 | 0.5700000000000001 | 0.65
[NAME] | GAA | 0.7 | 0.69 | 0.69 | 0.43 | 0.35
Asp | GAT | 0.65 | 0.74 | 0.63 | 0.22 | 0.15
Asp | GAC | 0.35 | 0.26 | 0.37 | 0.78 | 0.84
Val | GTG | 0.19 | 0.17 | 0.37 | 0.43 | 0.48
Val | GTA | 0.21 | 0.31 | 0.15 | 0.06 | 0.06
Val | GTT | 0.39 | 0.38 | 0.26 | 0.15 | 0.11
Val | GTC | 0.21 | 0.14 | 0.22 | 0.36 | 0.33
Ala | GCG | 0.11 | 0.11 | 0.36 | 0.49 | 0.5
Ala | GCA | 0.29 | 0.29 | 0.21 | 0.08 | 0.08
Ala | GCT | 0.38 | 0.48 | 0.16 | 0.05 | 0.05
Ala | GCC | 0.22 | 0.12 | 0.27 | 0.38 | 0.35
Arg | AGG | 0.21 | 0.04 | 0.02 | 0.04 | 0.01
Arg | AGA | 0.48 | 0.31 | 0.04 | 0.01 | 0
Ser | AGT | 0.16 | 0.1 | 0.15 | 0.07 | 0.07
Ser | AGC | 0.11 | 0.13 | 0.28 | 0.28 | 0.36
Lys | AAG | 0.42 | 0.2 | 0.23 | 0.75 | 0.83
Lys | AAA | 0.58 | 0.8 | 0.77 | 0.25 | 0.16
[NAME] | AAT | 0.59 | 0.6000000000000001 | 0.45 | 0.19 | 0.1
[NAME] | AAC | 0.41 | 0.4 | 0.55 | 0.81 | 0.89
Met | ATG | 1 | 1 | 1 | 1 | 1
[NAME] | ATA | 0.27 | 0.17 | 0.07 | 0.04 | 0
[NAME] | ATT | 0.46 | 0.5 | 0.51 | 0.18 | 0.1
[NAME] | ATC | 0.26 | 0.33 | 0.42 | 0.79 | 0.89
[NAME] | ACG | 0.14 | 0.13 | 0.27 | 0.43 | 0.42
[NAME] | ACA | 0.3 | 0.36 | 0.13 | 0.07 | 0.06
[NAME] | ACT | 0.34 | 0.36 | 0.17 | 0.06 | 0.04
[NAME] | ACC | 0.22 | 0.15 | 0.44 | 0.43 | 0.46
Trp | TGG | 1 | 1 | 1 | 1 | 1
End | TGA | 0.3 | 0.1 | 0.29 | 0.65 | 0.33
[NAME] | TGT | 0.63 | 0.62 | 0.45 | 0.25 | 0.09
[NAME] | TGC | 0.37 | 0.38 | 0.55 | 0.75 | 0.9
End | TAG | 0.23 | 0.36 | 0.07 | 0.14 | 0
End | TAA | 0.47 | 0.53 | 0.64 | 0.22 | 0.66
Tyr | TAT | 0.56 | 0.59 | 0.5700000000000001 | 0.09 | 0.07
Tyr | TAC | 0.44 | 0.41 | 0.43 | 0.91 | 0.92
Leu | TTG | 0.29 | 0.16 | 0.13 | 0.1 | 0.1
Leu | TTA | 0.28 | 0.27 | 0.13 | 0.02 | 0
Phe | TTT | 0.59 | 0.58 | 0.5700000000000001 | 0.14 | 0.04
Phe | TTC | 0.41 | 0.42 | 0.43 | 0.86 | 0.95
Ser | TCG | 0.1 | 0.07 | 0.15 | 0.31 | 0.32
Ser | TCA | 0.21 | 0.12 | 0.12 | 0.06 | 0.05
Ser | TCT | 0.26 | 0.42 | 0.15 | 0.04 | 0.03
Ser | TCC | 0.16 | 0.16 | 0.15 | 0.24 | 0.14
Arg | CGG | 0.04 | 0.05 | 0.1 | 0.36 | 0.34
Arg | CGA | 0.07 | 0.19 | 0.06 | 0.08 | 0.03
Arg | CGT | 0.14 | 0.25 | 0.38 | 0.05 | 0.05
Arg | CGC | 0.06 | 0.16 | 0.4 | 0.46 | 0.54
Gln | CAG | 0.31 | 0.3 | 0.65 | 0.69 | 0.8
Gln | CAA | 0.69 | 0.7 | 0.35 | 0.31 | 0.19
His | CAT | 0.64 | 0.7 | 0.5700000000000001 | 0.09 | 0.03
His | CAC | 0.36 | 0.3 | 0.43 | 0.91 | 0.96
Leu | CTG | 0.11 | 0.11 | 0.5 | 0.36 | 0.45
Leu | CTA | 0.14 | 0.14 | 0.04 | 0.03 | 0.01
Leu | CTT | 0.13 | 0.21 | 0.1 | 0.05 | 0.06
Leu | CTC | 0.06 | 0.12 | 0.1 | 0.44 | 0.36
Pro | CCG | 0.12 | 0.07 | 0.52 | 0.59 | 0.68
Pro | CCA | 0.42 | 0.26 | 0.19 | 0.07 | 0.02
Pro | CCT | 0.31 | 0.56 | 0.16 | 0.03 | 0.04
Pro | CCC | 0.16 | 0.11 | 0.12 | 0.31 | 0.25
GC content (%) |  | 39.78 | 41.73 | 51.82 | 65.66 | 66.73
Spreadsheet: 863511d1710961945-performance-scoring-excel-formula-format-product-performance-scoring-example
Sheet: Sheet1

 | # | Category | Product | Revenue | Quantity | Conversion Rate % | Total View | Margin % | Revenue Score | Quantity Score | Conversion Rate% Score | Total View Score | Margin% Score | Total Score ?
 | 27 | T-shirt | T-shirt Model 3 | 97810 | 1986 | 0.19 | 37914 | 0.39
 | 9 | Panth | Panth Model 9 | 73726 | 3579 | 0.04 | 49253 | 0.39
 | 3 | Panth | Panth Model 3 | 37069 | 4966 | 0.12 | 47206 | 0.32
 | 15 | Socks | Socks Model 6 | 70925 | 2717 | 0.1 | 46110 | 0.37
 | 33 | T-shirt | T-shirt Model 9 | 70347 | 2889 | 0.19 | 22031 | 0.38
 | 1 | Panth | [NAME] | 29635 | 4464 | 0.15 | 39783 | 0.35
 | 2 | Panth | Panth Model 2 | 54336 | 4115 | 0.05 | 26344 | 0.5
 | 20 | Jacket | Jacket Model 3 | 40680 | 4649 | 0.03 | 41477 | 0.4
 | 23 | Jacket | Jacket Model 6 | 31132 | 1699 | 0.14 | 46594 | 0.47
 | 34 | T-shirt | T-shirt Model 10 | 20946 | 4366 | 0.06 | 41228 | 0.45
 | 7 | Panth | [NAME] | 52750 | 3150 | 0.12 | 34368 | 0.34
 | 25 | T-shirt | T-shirt Model 1 | 89687 | 1758 | 0.03 | 40893 | 0.44
 | 40 | T-shirt | T-shirt Model 16 | 56971 | 2812 | 0.03 | 30143 | 0.45
 | 14 | Socks | Socks Model 5 | 47977 | 3416 | 0.14 | 25364 | 0.35
 | 37 | T-shirt | T-shirt Model 13 | 41545 | 4973 | 0.07 | 19532 | 0.43
 | 5 | Panth | Panth Model 5 | 93906 | 2563 | 0.08 | 40293 | 0.22
 | 21 | Jacket | Jacket [NAME] | 31089 | 4345 | 0.13 | 39802 | 0.29
 | 12 | Socks | Socks Model 3 | 30539 | 4689 | 0.03 | 27746 | 0.48
 | 18 | Jacket | Jacket Model 1 | 55221 | 2751 | 0.12 | 16498 | 0.37
 | 17 | Socks | Socks Model 8 | 15846 | 3242 | 0.12 | 25536 | 0.44
 | 38 | T-shirt | T-shirt Model 14 | 34774 | 4019 | 0.15 | 25974 | 0.31
 | 39 | T-shirt | T-shirt Model 15 | 35374 | 1906 | 0.09 | 49587 | 0.33
 | 13 | Socks | Socks Model 4 | 98069 | 2214 | 0.09 | 27829 | 0.21
 | 26 | T-shirt | T-shirt Model 2 | 33399 | 4474 | 0.08 | 30722 | 0.31
 | 29 | T-shirt | T-shirt Model 5 | 84036 | 1355 | 0.1 | 40882 | 0.28
 | 11 | Socks | Socks Model 2 | 97459 | 1258 | 0.19 | 9778 | 0.32
 | 24 | Jacket | Jacket Model 7 | 43630 | 3168 | 0.18 | 25381 | 0.25
 | 10 | Socks | Socks Model 1 | 82823 | 1925 | 0.09 | 30151 | 0.25
 | 31 | T-shirt | T-shirt Model 7 | 54843 | 2075 | 0.05 | 42801 | 0.26
 | 30 | T-shirt | T-shirt Model 6 | 90004 | 1527 | 0.03 | 27595 | 0.4
 | 19 | Jacket | Jacket [NAME] | 94769 | 1731 | 0.16 | 14341 | 0.21
 | 22 | Jacket | Jacket Model 5 | 88176 | 1654 | 0.07 | 5309 | 0.39
 | 28 | T-shirt | T-shirt Model 4 | 45737 | 1566 | 0.04 | 40482 | 0.37
 | 8 | Panth | Panth Model 8 | 54821 | 1575 | 0.03 | 33395 | 0.34
 | 6 | Panth | [NAME] | 55834 | 3734 | 0.03 | 22932 | 0.24
 | 4 | Panth | [NAME] | 88158 | 1881 | 0.04 | 15540 | 0.3
 | 36 | T-shirt | T-shirt Model 12 | 35750 | 1610 | 0.03 | 12652 | 0.49
 | 16 | Socks | Socks Model 7 | 23857 | 2265 | 0.1 | 6301 | 0.31
 | 35 | T-shirt | T-shirt Model 11 | 40686 | 2190 | 0.05 | 25452 | 0.22
 | 32 | T-shirt | T-shirt Model 8 | 54522 | 1231 | 0.08 | 20502 | 0.25
Spreadsheet: 753936d1635848152-if-cell-equals-return-specific-range-examplefile-rangegrab
Sheet: ExampleSheet1

 |  |  |  |  | This information is found in ExampleSheet2.
 | [NAME] |  |  |  | If [NAME] is selected in B3, I want the following to be shown in B4:B18. | If [NAME] is selected in B3, I want the following to be shown in B4:B18. | If [NAME] is selected in B3, I want the following to be shown in B4:B18. | If [NAME] is selectedin B3, I want the following to be shown in B4:B18.
Name 1 |  |  |  |  | 1
Name 2 |  |  |  |  | 5 | 64 | 1 | 1
Random 1 |  |  |  |  | 7 | 35 | 1 | 5
Random 2 |  |  |  |  | 1 | 34 | 5 | 32
Name 3 |  |  |  |  | 7 | 12 | 6 | 61
Name 4 |  |  |  |  | 12 | 12 | 7 | 7
Random 3 |  |  |  |  | 12 | 12 | 7 | 12
Random 4 |  |  |  |  | 12 | 11 | 7 | 12
Name 5 |  |  |  |  | 11 | 8 | 8 | 12
Name 6 |  |  |  |  | 6 | 7 | 11 | 11
Random 5 |  |  |  |  | 64 | 7 | 12 | 6
Random 6 |  |  |  |  | 34 | 7 | 12 | 16
Name 7 |  |  |  |  | 35 | 6 | 12 | 34
Name 8 |  |  |  |  | 7 | 5 | 34 | 35
Random 7 |  |  |  |  | 8 | 1 | 35 | 7
 |  |  |  |  |  | 1 | 64 | 8
Spreadsheet: 187568d1350507905-grouping-values-based-on-a-criteria-in-a-column-and-multiple-rows-over-a-range-test1
Sheet: Test Sheet

Name | Role | Nov-12 | Dec-12 | [NAME]
Test1 | R1 | 1 | 1 | 1
Test2 | R1 | 1 | 1
Test3 | R1 | 1
Test4 | R1
Test5 | R2 | 1 | 1 | 1
Test6 | R2 | 1
[NAME] | R2 | 1 | 1 | 1
Test8 | R2
Test9 | R2 | 1 | 1
Test10 | R3 | 1
Test11 | R3 |  | 1
Test12 | R3 | 1
Expected Output
Role | Nov-12 | Dec-12 | [NAME]
R1 | 3 | 2 | 1
R2 | 4 | 3 | 2
R3 | 2 | 1
Spreadsheet: kevin_hyatt__19633__KevinHyatt
Sheet: Assets

SAP FIXED ASSETS SYSTEM
Project Systems Asset Determination Table.
PS Asset # | [NAME] | PS Asset # | [NAME]
01 | ABSORBERS / ADSORBERS | 28 | ISOM UNITS
02 | [NAME] | 29 | CATALYST
03 | AIR CLEANERS | 30 | GAS LINE PACK
04 | AIR COMPRESSORS | 31 | GAS LOSS
05 | AUXILLARY POWER SUPPLY EQUIPMENT | 32 | GAS UNDERGROUND-NON-RECOVERABLE
06 | BUTANE ISOMERIZATION | 33 | PIPE COATING
07 | OLEFLEX | 34 | STORAGE GAS WELLS
08 | FLARE SYSTEM | 35 | HEAT EXCHANGE EQUIPMENT
09 | LOADING FACILITIES | 36 | HOISTING SYSTEM - YARD
10 | BOILERS | 37 | LAND IMPROVEMENTS
11 | BRIDGES - AERIAL XING STRUCTURE | 38 | LAND AND LAND RIGHTS
12 | BUILDINGS | 39 | METERING EQUIPMENT
13 | CATHODIC PROTECTION EQUIPMENT | 40 | ODERIZERS
14 | COMMUNICATIONS EQUIPMENT | 41 | OIL CHARGING SYSTEM
15 | COMPRESSORS AND DRIVERS | 42 | PIPELINE LAUNCHERS & RECEIVERS
16 | COMPUTER | 43 | PLATFORMS - OFFSHORE
17 | CONDENSERS | 44 | PUMPS
18 | CONTROL EQUIPMENT | 45 | [NAME]
19 | COOLING SYSTEMS - PACKAGED UNITS | 46 | REVETMENTS
20 | DEHYDRATOR | 47 | SEPERATORS, SCRUBBERS, GAS CLEANERS
21 | DETECTION EQUIPMENT | 48
22 | DISPOSAL TREATMENT - EQUIP / FACILITY | 49 | GENERAL PLANT ADDITIONS
23 | DRAINAGE AND SEWERAGE SYSTEMS | 50 | TANKS, RESERVIORS, & VESSLES
24 | ELECTRICAL | 51 | VALVES - 2 INCH AND OVER
25 | FRACTIONATION TOWER | 52 | VAPORIZERS
26 | GAS PROCESSING UNIT | 53 | WATER SUPPLY TREATMENT SYSTEMS
27 | GAS TREATING UNITS / SYSTEMS | 54 | GAS PIPE
 |  | 99 | ALLOCABLE MATERIALS (BOLTS, GASKETS, ECT)
Spreadsheet: 229769d1366566706-terribly-slow-excelsheet-dummyrapportage-20130322-clean
Sheet: P&O

Afdelingsrapportage P&O |  |  |  |  |  | Stand per |  |  |  |  | Rapportagedatum:
Speerpunten
Onderwerp |  |  | Beleidsprodukt | [NAME] | Financieel | Planning | Risico's | Toelichting (alleen bij kruisje; duimpje of resultaten)
Organisatieontwikkelingen
Ontwikkeling van medewerkers en leidinggevenden
[NAME]
Implementeren E-HRM
Gezondheidsmanagement
HR21 functiewaarderingssysteem implementeren
[NAME]
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
Subprogr | BP | Omschrijving |  |  | Plan | Actuele waarde | Toelichting |  |  |  |  | Rapportage-moment
 |  | Goed benutten ontwikkelbudget (opleidingsplan is [NAME]. [NAME]) |  |  | 1 |  |  |  |  |  |  | maand
 |  | Stageplaatsen |  |  | 72 |  |  |  |  |  |  | maand
 |  | [NAME] |  |  | 2 |  |  |  |  |  |  | maand
 |  | Projectenpool omvang medewerkers |  |  | 80 |  |  |  |  |  |  | maand
 |  | Projectenpool aantal projecten |  |  | 32 |  |  |  |  |  |  | maand
 |  | % kantoorpersoneel heeft een PMO aangeboden gekregen |  |  | 0.5
 |  | Formatie concern |  |  |  |  | [NAME] afd.plan (komt uit directiemonitor)
 |  | In/uitstroom concern
 |  | Ziekteverzuim concern
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
Permanente aandachtspunten
Weerstandsvermogen
Wetgeving
Afdeling P&O
Ziekteverzuim
[NAME] (in FTE) en verwachte invuldatum
Spreadsheet: 683290d1592596740-time-card-calculation-time_card2c-revised
Sheet: Flex Employee

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime | Sick Time Hrs | Sick Time Hrs. hide | Holiday Hrs. | Holiday Hrs. hide | Vacation Hrs. | Vacation Hrs. hide |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0700 |  | 30 | 1530
 | 0700 |  | 30 | 1537
 | 0700 |  | 30 | 1555
 |  |  |  | Total  Hrs.
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Biweekly Total  Hrs.
Grand Total Pay: |  |  |  |  |  |  | Rate / Hour: |  | 52
Grand Total Pay w/ Shift Differential: |  |  |  |  |  |  | Total Pay: