tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702009d1604045114-vlookup-match-function-requires-tweaking-to-distinguish-between-2-data-lookup-ranges-lookup-match-function
Sheet: Question

 |  |  |  | Option "2018" data (value 1) |  |  |  | Option "2019" data (value 2)
Product | Product (1) | Product (2) |  | Product (1) | 1 | 2 |  | Product (2) | 1 | 2
Type 1 |  |  |  | Type 1 | A11 | A21 |  | Type 1 | B11 | B21
Type 2 |  |  |  | Type 2 | A12 | A22 |  | Type 2 | B12 | B22
Type 3 |  |  |  | Type 3 | A13 | A23 |  | Type 3 | B13 | B23
Type 4 |  |  |  | Type 4 | A14 | A24 |  | Type 4 | B14 | B24
Type 5 |  |  |  | Type 5 | A15 | A25 |  | Type 5 | B15 | B25
 | 2
Spreadsheet: 90179d1289936686-sum-total-question-yesterdays-totals
Sheet: 1115

11/15/2010  Performance Data
 |  | 1st Work |  |  |  |  | QC |  |  |  | SC | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT | MMIG, RSCH & UPDT | All Other DA | IA  Forms Pkgs | IA  Trans | EDIT w/pass | PASS | FAIL | IA QC | SURINQ  &  Death Cert
 |  |  |  |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 17 | 2 |  |  |  |  |  |  |  | 125 | 1 | meeting | 7 | 17.85714285714286
 | Dustin |  | 15 | 6 |  |  |  |  |  |  |  | 123 | 1.5 | trending/meeting | 6.5 | 18.92307692307692
 | Sharron |  | 12 | 12 |  |  |  |  |  |  |  | 120 |  |  | 8.5 | 14.11764705882353
 | Roxy |  | 6 | 12 |  |  |  |  |  |  |  | 78 |  |  | 6 | 13
 | [NAME] |  |  |  |  |  | 3 | 14 |  |  |  | 102 |  |  | 8.5 | 12
 | Ana |  | 4 | 17 |  |  |  |  |  |  |  | 79 |  |  | 8 | 9.875
 | Maria | 35 | 2 | 10 |  |  |  |  |  |  |  | 79 |  |  | 8.5 | 9.294117647058824
 | [NAME] |  | 9 | 10 | 4 | 3 |  |  |  |  |  | 123 | 1 | emails | 9.75 | 12.61538461538461
 | Petra |  |  |  |  |  | 7 | 5 | 2 |  |  | 84 | 2.75 | CISS/PVC/meeting | 8.5 | 9.882352941176471
 | Regina |  |  |  |  |  | 3 | 13 | 4 |  |  | 120 | 2 | SWT | 8 | 15
 | Noy |  |  |  |  |  |  |  |  |  |  | 0 |  | out of office |  | #N/A
 | [NAME] |  |  |  |  |  |  |  |  | 20 |  | 60 | 2.5 | catch up on emails | 5.5 | 10.90909090909091
 | [NAME] |  |  |  |  |  |  |  |  |  | 37 | 59.2 |  |  | 5.5 | 10.76363636363636
 | Michelle |  |  |  |  |  |  |  |  |  | 30 | 48 |  |  | 2 | 24
 | Keisha |  |  |  |  |  |  |  |  |  |  | 0 |  | out of office |  | #N/A
 | [NAME] |  |  |  | 2 | 14 |  |  |  |  |  | 90 |  |  | 7 | 12.85714285714286
TEAM TOTALS | Pts Earned: | 1 | 7 | 3 | 3 | 6 | 6 | 6 | 6 | 3 | 1.6 |  |  |  |  | #N/A
 | TASK VOLUME: | 35 | 65 | 69 | 6 | 17 | 13 | 32 | 6 | 20 | 67 | 1290.2 | 10.75 |  | 99.25 | 12.99949622166247
 | Pts Earned: | 35 | 455 | 207 | 18 | 102 | 78 | 192 | 36 | 60 | 107.2
Spreadsheet: 864569d1711693422-extract-duplicate-values-in-range-with-criteria-locker-lotto-test
Sheet: Sheet1

 |  |  | Mon | Tue | Wed | Thu | Fri |  | North Division
 |  | Week 1 | 277 | 196 | 98 | 139 | 14 |  | Lockers |  | 1 | to | 150
 |  | Week 2 | 249 | 189 | 115 | 111 | 160 |  | 14 | 84 | 127
 |  | Week 3 | 123 | 71 | 84 | 145 | 237
 |  | Week 4 | 63 | 218 | 264 | 239 | 228
 |  | Week 5 | 14 | 11 | 234 | 164 | 194 |  | South Division
 |  | Week 6 | 84 | 174 | 240 | 74 | 242 |  | Lockers |  | 151 | to | 300
 |  | Week 7 | 240 | 14 | 68 | 86 | 33 |  | 196 | 240 | 277
 |  | Week 8 | 221 | 69 | 263 | 127 | 254
 |  | Week 9 | 127 | 277 | 250 | 117 | 144
 |  | Week 10 | 136 | 196 | 278 | 180 | 18
Spreadsheet: sally_beck__33979__ANLB
Sheet: sally_beck__33979__ANLB

Table name |  | Short text
Field name | Short text |  | Key | Type | Lngth
ANLB |  | Depreciation terms
MANDT | Client |  | X | CLNT | 3
BUKRS | Company code |  | X | [NAME] | 4
ANLN1 | Main asset number |  | X | [NAME] | 12
ANLN2 | Asset sub-number |  | X | [NAME] | 4
AFABE | Real depreciation area |  | X | NUMC | 2
BDATU | Date validity ends |  | X | [NAME] | 8
ADATU | Date for beginning of validity |  |  | [NAME] | 8
ERNAM | Name of person who created object |  |  | [NAME] | 12
ERDAT | Date on which the record was created |  |  | [NAME] | 8
AENAM | Name of accounting clerk who changed record |  |  | [NAME] | 12
AEDAT | Change date |  |  | [NAME] | 8
XLOEV | Indicator: account marked for deletion? |  |  | [NAME] | 1
[NAME] | Indicator: Is account blocked for posting? |  |  | [NAME] | 1
FELEI | Screen layout for Asset Accounting |  |  | [NAME] | 4
XNEGA | Indicator: Negative values allowed |  |  | [NAME] | 1
XGWGK | Indicator: Low-value asset amount and quantity check |  |  | NUMC | 1
XUNTA | Indicator: Depreciate main asset number totally |  |  | [NAME] | 1
AFABG | Depreciation calculation start date |  |  | [NAME] | 8
ZINBG | Start date for interest calculation |  |  | [NAME] | 8
SAFBG | Start date for special depreciation |  |  | [NAME] | 8
INVSL | Investment support key |  |  | [NAME] | 2
AFASL | Depreciation key (external) |  |  | [NAME] | 4
NDJAR | Planned useful life in years |  |  | NUMC | 3
NDPER | Planned useful life in periods |  |  | NUMC | 3
NAPRZ | Ordinary depreciation percentage rate |  |  | DEC | 7
SAPRZ | Special depreciation percentage rate |  |  | DEC | 7
WBIND | Index series for replacement values |  |  | [NAME] | 5
ALIND | Index series for replacement values by age |  |  | [NAME] | 5
APROP | Variable depreciaiton portion |  |  | DEC | 7
UMJAR | Depreciation key for the changeover year |  |  | NUMC | 4
NDURJ | Original useful life in years |  |  | NUMC | 3
NDURP | Original useful life in periods |  |  | NUMC | 3
SCHRW | Asset scrap value |  |  | CURR | 13
LGJAN | Last fiscal year for the annual values in Asset Acct. |  |  | NUMC | 4
PERFY | Period scaling in depreciation start year |  |  | NUMC | 3
ANUPD | Indicator: Type of change to table |  |  | [NAME] | 1
AUFWTG | Revaluation |  |  | NUMC | 2
XAFBE | Indicator: Depreciation area is deactivated |  |  | [NAME] | 1
[NAME] | Group asset |  |  | [NAME] | 12
ANLGR2 | Sub-number of a group asset |  |  | [NAME] | 4
VYEAR | Acquisition year of the asset (manually changeable) |  |  | NUMC | 4
VMNTH | Asset Accounting: Acquis. month (in depreciation area) |  |  | NUMC | 3
INBDA | Asset Accounting:  Date of operating readiness |  |  | [NAME] | 8
ABGDAT_B | Value date of last retirement for the depreciation area |  |  | [NAME] | 8
J_1AARVKEY | Inflation adjustment AA - revaluation key |  |  | [NAME] | 4
J_1AALTDAT | Date of last revaluation |  |  | [NAME] | 8
J_1AALTIDX | Index used for last revaluation |  |  | [NAME] | 5
Spreadsheet: 686677d1594746534-formula-help-to-average-cells-based-on-set-number-of-entries-excel-help_2
Sheet: Sheet1

Given Date: | 2020-12-01 00:00:00
Project | Booking Date | SM
Project A | 2019-06-01 00:00:00 | 0.9
Project B | 2019-07-01 00:00:00 | 0.4
Project C | 2019-08-01 00:00:00 | 0.541
Project D | 2019-08-01 00:00:00 | 0.579
Project E | 2019-08-01 00:00:00 | 0.695
Project F | 2019-11-01 00:00:00 | 0.723
Project G | 2020-01-01 00:00:00 | 0.675
Project H | 2020-06-01 00:00:00 | 0.765
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
 | Average
Spreadsheet: 815253d1674833559-merge-if-statements-for-a-quotation-spreadsheet-quote-sheet
Sheet: COGS

Item | Supplier | Rate | Qty | Item Total | Freight | Labor | Quote | Customs |  | Credit | Item | Total |  | [NAME]'s
 |  |  |  |  |  | 0.75 | Type | Broker | Bond | Card | Cost | Cost |  | Single UPS or B
 |  |  |  |  |  |  | Single | UPS | Fee | Fee 2.5% | (Cdn) | (Cdn)
 | Acme |  | 1 |  | 24 | 0.75 |  | 60.15 |  |  |  |  |  | Multiple UPS or B
 | Acme |  | 1 |  | 39 | 0.75
I would like to merge the two different fromulas inO3 & O5 into the I column (Broker) so that it automatcially detects which formula it should use based on:
Customs Broker (drop down list),
Quote Type - multiplie or single item quote (drop down list),
And detect if the item total is over the Custom's Broker's Value For Duty threshold (B = $6000.00, UPS = $2500.00)
*Notes*
- This a slimmed down version of my actual quotation spreadsheet.
- I have a 5% exchange rate cushion on the current exchange to deal with currency fluctiations.
- Freight is a rough cost column.  For multiple, I will divide freight cost by item quantity in the future.It's just a mocked up at this point in time.
- Bond Fee is currently mocked up as well.
Spreadsheet: 841844d1693989744-filter-formula-alphanumeric-book3-3-
Sheet: Sheet1

69045 | 1 | 69045 | Hello
ABCD | 2 | ABCD | Hello
A23C_ | 3 | A23C_
a2s |  | a2s | Hello
sssss | 5 | sssss | Hello
1j21iej1 | 6 | 1j21iej1 | Hello
 | 7 | [NAME]_	Y_x001D_,<_x0005_ | Hello
 | 8 | L_x000D_tKy_x0004__x0005_!’“9;A | Hello
 | 9 | ~xf…[NAME]_	y9I7VP | Hello
 | 10 | H,‘$$_x000D_T}ˆf_x000E_ | Hello
 | 11 | _x0002_x_x0003_`_x000E_5e†63zXB
 | 12 | I-?+,_x0010_#7)Y2v | Hello
 | 13 | ‡Ž1A 1P T`, | Hello
 | 14 | [|Oh 9F‡_x0006_ C-_x0016_
 | 15 | B(k/9\`V/_x0017_OE? | Hello
 | 16 | €[NAME]o_x0006_>Poy_x000F__x000B_\I7 | Hello
 | 17 | M_x0019_†_x001E_x_x0005_O-m_x0001_Š_d | Hello
 | 18 | _x000D_W•_x0016_G1Œd8•€R2 | Hello
 | 19 | CK_x0016_O`#Y_x001A_ˆ_x001D__x000E_‚l | Hello
 | 20 | ':TE_x0004_DuŠ8€d_x0004_
 | 21 | _x0001_K}%“~_x0014_ f_x001A__5_x0002_ | Hello
 | 22 | €h‰/_x0002_:6& _x0002_N‹‰ | Hello
 | 23 | XP.9e_x000E_.O/Œ_x0019_g_x000F_ | Hello
 | 24 | SZ_x0014_G‘+3_x0014__x0011_	=Y# | Hello
 | 25 | BEj1F*_x000B_{_x0014_9(|_x000D_ | Hello
 | 26 | "_x001B_ƒ_x0004__x000E_ƒ+aP-G<+
 | 27 | EDŽ8vj	_[NAME] | Hello
 | 28 | kZ’B|”V_x001D_X#Œ2j | Hello
 | 29 | B_x001A_$7.`<_x0012_y0G*Š | Hello
 | 30 | ;v…_x0015__x000E__x0011__x001F_^uCf)„ | Hello
 | 31 | _x001F_(^‚	YLc]_x0019_i€ | Hello
 | 32 | _x001B_tO'51Xm_x0018__x0017__x0003_@~ | Hello
 | 33 | _x0002_: [o+m$=  _x0006_ | Hello
 | 34 | w•K_x0018_dm–_x000E__x0018_OG_x001E_g | Hello
 | 35 | _x001E_-_x0015_fFHTuh>_x0010_Z_x001A_
 |  | _x001D_h!_x000C_{"mZ0†4_x000B_ˆ | Hello
 | 37 | “Az%_x0016_1‚Z_x0015_OZ@z | Hello
 | 38 | aj-^4B	+d&2•o | Hello
 | 39 | @^_x0007_%[e_x001D_Q_x001C_k;_x0004_‡ | Hello
 | 40 | 3_x0013_[oMjR_x0008_ƒQ ~N | Hello
 | 41 | l0Tpn_x0002_Wo4jP_x001E_
 | 42 | ?_x001D_ˆ’/5_x0015_”Tba_x0011_ | Hello
 | 43 | C=_x000E_phM,Ml~N‰_x0011_ | Hello
 | 44 | _x0017_Št\_x0014_a8–_x0013_“B_x0012_) | Hello
 |  | q"*}e;_x000F_Ž‘j*ŠA | Hello
 | 46 | _[NAME]…_x001E__x0006_k[p‰ | Hello
 | 47 | e'_YK]_x0014_–‹S‰_x0013_ | Hello
 | 48 | u%oZ€…_x0003_5|S_x0001_RS | Hello
 | 49 | x‘g+_x0010__x0014_""~y.‘ | Hello
 | 50 | NC‘h/8^	_x0003_}
 | 51 | -ˆz_x000B_‰d_x0010_fX_x0003_%v€ | Hello
 |  | 6…ƒ_x000F__x0015_^e7.Œ_x001F_Q( | Hello
 | 53 | P‘>‹_x0015_R†_x0006_V{+Y‘ | Hello
 | 54 | _x0004_/l61_x0002_i`vNRh7 | Hello
 | 55 | _x0013__x0003_i_x0014_{„OdU‡Z | Hello
 | 56 | [NAME] | Hello
 | 57 | (Š>_x0012_,T0‹ _x001A_j0% | Hello
Spreadsheet: 45654d1244473600-comparing-2-colums-000-basic
Sheet: EXTRA

Extra
Date | Amount | Code | Posted to
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
 |  | 99 | Un-Designated
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 33

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
33 | 2007-02-16 00:00:00 | 7.5 | 2.69 | 12.5 | 5.6 | 9.5 | 4.4 |  |  |  | 18.5 |  | 4.46595469986155 | 4.2 | 0 | 19 |  |  |  |  | 0.7
Well #33 | 2013-10-11 00:00:00 | 6.2 | 2.02 | 10.72 | 4.05 | 4.6 | 0.8 |  |  | 6.3 | 12.6 |  | 1.7 | 3.1 | 0.04 | 6.8 |  | <0.10 | <0.02 |  | -1.3
Well - 33 | 2014-02-13 00:00:00 | 7.4 | 3.3 | 14.74 | 6.44 | 10.6 | 5 |  |  | 1.5 | 26.4 |  | 3.3 | 8.9 | 0.06 | 15.3 |  | <0.10 | <0.02 |  | 0.7
Well 33 | 2017-05-03 00:00:00 | 7.93 | 2.041 | 10.5 | 4.47 | 5.15 | 2.825513548077692 | 2.825513548077692 | 0 | 1.1 | 16.142 | 1306 | 1.88 | 4.19 | 0.008 | 15.062 | 0.004 | 0.071 | 0.025 | 0.016
W33 | 2018-05-29 00:00:00 | 7.93 | 3.837 | 18.7 | 7.89 | 12.4 |  | 5.087522979777796 | 0 | 2.09 | 29.856 | 2455.68 |  |  | 0.046 | 14.895 | 0.089 | 0.002 | 0 | 0.01
Spreadsheet: 112859d1308838230-overall-rating-based-on-an-alphabetical-score-pd-ratings
Sheet: Sheet1

 | Consultant Name | Sales Achieved | Sales Target | % of target | [NAME] | Adherence Achieved | Adherence Target | Rating | QA Achieved | Rating | Leads Achieved | Target | % of target | Rating |  | Overall PD Rating |  |  |  |  |  |  |  |  |  |  |  | Sales |  |  | QA |  |  | FINAL
 |  | 1223 | 1070 |  |  | 0.89 | 0.75 |  | 0.8723 |  | 270 | 192 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | D |  | 0 | D |  | 1 | D
 |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 | C |  | 0.9 | C |  | 2 | D
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | B |  | 0.95 | B |  | 3 | D
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.01 | [NAME] |  | 0.96 | [NAME] |  | 4 | D
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 | A |  | 1 | A |  | 5 | C
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | C
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | C
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adherence |  |  | OVERALL |  |  | 8 | C
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | D |  | D | 1 |  | 9 | B
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7 | C |  | C | 2 |  | 10 | B
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | B |  | B | 3 |  | 11 | B
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.76 | [NAME] |  | [NAME] | 4 |  | 12 | [NAME]
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.85 | A |  | A | 5 |  | 13 | [NAME]
 |  | 0 | 0 |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leads |  |  |  |  |  | 19 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | D |  |  |  |  | 20 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.01 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 | A
Spreadsheet: af310ae1-a105-43b1-a533-becc6770cb5f
Sheet: Sheet1

MASTER OF ARTS IN RELIGION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | 1= [NAME] concentration
 |  |  |  | 2=Secondary concentration
 |  |  | required |  | completed
 | Total Courses |  | 37.5
 | (18 in area of concentration; 9 in secondary area)
 | Thesis Research Practicum |  | 1.5
 | Thesis |  | 12
 | TOTAL ACADEMIC CREDITS |  | 51 |  | 0
Spreadsheet: lindy_donoho__21972__TW2010ProjCap&Rev
Sheet: Rates

HISTORICAL AVERAGE RATES
 | 1Qtr | 2Qtr | 3Qtr | 4Qtr | Annual
West | 0.2577395738036288 | 0.2556540614556103 | 0.262556423525552 | 0.2499368055220567 |  | *
East | 0.07765127986911959 | 0.05354242068597122 | 0.05169424094639299 | 0.05369964655378881
[NAME] | 0.04427150301078417 | 0.04449944721939635 | 0.04326539005011056 | 0.0392327525316379
San Juan | 0.1041950912069369 | 0.1041509866477608 | 0.1049705386976516 | 0.1039459391648738
Assume historical 2000 & 2001 averages for capacity rolling-off 2002 thru 2010.
 |  |  |  |  | Fuel | Hist ave
 |  |  |  |  | value now | rate
 |  |  |  |  | captured | w/fuel
 |  |  |  | Hist ave | in rate | factor
*Historical Average West Rate for 2007 - 2010 (Case 2) |  |  |  | 0.2565 | 0.0839
("fuel value" calculated using 2007 average price of $3.27 at 2.5%)
MAX RATES
West | 0.2868
East | 0.102
[NAME] | 0.102
San Juan | 0.102
Spreadsheet: 803345d1667403069-date-and-time-string-text-to-actual-date-time-sample-hd
Sheet: Sheet1

Order Date Time String | Order Date Time | Hour
Jan 17 2022 12:30AM
Jan 31 2022 12:42AM
Jan  1 2022 12:42PM
Jan 17 2022  1:03AM
Jan  1 2022  5:15AM
Jan  1 2022  5:34AM
Jan  1 2022  5:34AM
Jan  1 2022  5:54AM
Jan  1 2022  5:54AM
Jan  1 2022  6:00AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Jan  1 2022  6:27AM
Spreadsheet: 713808d1610954686-getting-top-10-values-without-pivot-rejection-details
Sheet: Sheet1

REJECT Contributor | QTY, kgs |  |  | Top | Contributor | QTY
High Moisture | 86 |  |  | 1
Off Color | 278 |  |  | 2
High Moisture | 294 |  |  | 3
Off Sieve | 604 |  |  | 4
High Moisture | 180 |  |  | 5
High Moisture | 961 |  |  | 6
[NAME] | 484 |  |  | 7
Off Color | 110 |  |  | 8
Off Sieve | 205 |  |  | 9
High Discolored Specks Count | 297 |  |  | 10
Off Color | 211
Off Sieve | 553
High Moisture | 472
Off Sieve | 1278
High Moisture | 456
Off Color | 236
High Moisture | 53
High Moisture | 75
Off Color | 72
High Moisture | 368
Off Color | 168
High Moisture | 477
Off Color | 361
High Moisture | 664
High Moisture | 313
High Moisture | 50
High Moisture | 40
Off Color | 563
High Moisture | 143
High Moisture | 393
High Moisture | 168
High Moisture | 123
Off Color | 390
High Moisture | 264
Off Color | 127
High Moisture | 205
High Moisture | 239
High Moisture | 938
[NAME] | 777
High Moisture | 444
Off Color | 85
High Moisture | 338
High Moisture | 1215
High Moisture | 274
Off Color | 53
High Moisture | 769
Off Color | 827
High Moisture | 324
High Moisture | 770
High Moisture | 832
High Moisture | 313
High Moisture | 98
High Moisture | 119
High Moisture | 1954
Off Color | 120
High Moisture | 1003
Off Color | 398
High Moisture | 690
Spreadsheet: 790119d1659540062-lookup-a-value-in-tab-and-insert-corresponding-data-into-new-tabs-resource-db-excelforum-separate-tab
Sheet: SAP

 | Name | Surname | [NAME] |  |  |  | SAP
1 |  | surname5 | email5
2 | name23 | surname23 | email23
3 | name25 | surname25 | email25
4 | name31 | surname31 | email31
5 | name38 | surname38 | email38
6 | name59 | surname59 | email59
7 | name62 | surname62 | email62
etc… | name92 | [NAME] | email92
 | name103 | surname103 | email103
 | name108 | surname108 | email108
 | [NAME] | surname112 | email112
 | name131 | surname131 | email131
 | name139 | surname139 | email139
 | name146 | surname146 | email146
 | [NAME] | surname157 | email157
 | name159 | surname159 | email159
 | name160 | surname160 | email160
 | [NAME] | surname163 | email163
 | name177 | surname177 | email177
Spreadsheet: 118323d1313607866-reverse-table-lookup-login-map
Sheet: Sheet1

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  | k | { | c | K | g | + | N
 |  |  |  |  | 107 | 123 | 99 | 75 | 103 | 43 | 78
 |  |  |  |  | m | o | l | i | v | e | r
 | 33 | ! | H | k{cKg+N
 | 35 | # | d | moliver
 | 36 | $ | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This takes the input we give in  E6 and breaks it apart, searhes column C (the second column), finds that letter and displays the corresponding Column B value in the line below.  I want to go backwards.  I want to take input and look in column D, (the third column), find that character, and display the corresponding value in from Column B below.  Basically undoing what I did in the first step.
 | 37 | % | I
 | 38 | & | b
 | 40 | ( | A
 | 41 | ) | J
 | 42 | * | E
 | 43 | + | e
 | 44 | , | a
 | 45 | - | K
 | 46 | . | q
 | 48 | 0 | 0
 | 49 | 1 | L
 | 50 | 2 | F
 | 51 | 3 | f
 | 52 | 4 | C
 | 53 | 5 | M
 | 54 | 6 | c
 | 55 | 7 | s
 | 56 | 8 | p
 | 57 | 9 | N
 | 58 | : | G
 | 59 | ; | g
 | 60 | < | x
 | 61 | = | O
 | 65 | A | P
 | 67 | C | h
 | 68 | D | D
 | 69 | E | Q
 | 71 | G | t
 | 73 | I | R
 | 75 | K | i
 | 77 | M | S
 | 78 | N | r
 | 79 | O | z
 | 81 | Q | T
 | 83 | S | j
 | 85 | U | U
 | 87 | W | u
 | 89 | Y | V
 | 91 | [ | k
 | 93 | ] | W
 | 94 | ^ | y
 | 97 | a | X
 | 98 | b | 1
 | 99 | c | l
 | 100 | d | 2
 | 101 | e | Y
 | 102 | f | 3
 | 103 | g | v
 | 104 | h | 4
 | 105 | i | Z
 | 106 | j | 5
 | 107 | k | m
 | 108 | l | 6
 | 110 | n | 7
 | 112 | p | 8
 | 114 | r | 9
 | 115 | s | n
 | 119 | w | w
 | 123 | { | o
Spreadsheet: b29357ac-1288-4872-847c-e2f85e943fc7
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
EduStream | 1 | AFB Compliance review | None | -- Pick One -- | 1.1.r1 | AFB | OneTime | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 1 | New infrastructure build out | None | -- Pick One -- | 1.2.r1 | Infrastructure | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 1 | Expand availability of quality accessible content | None | -- Pick One --
EduStream | 4 | Ability to brand locally | None | -- Pick One --
EduStream | 3 | EduStream Help Desk | None | -- Pick One -- | 1.5.r1 | Help Desk | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 4 | Test User Group | None | -- Pick One -- | 1.6.r1 | Test Group | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 1 | Alternate authentication methods | None | -- Pick One -- | 1.7.r1 | Authentication | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 3 | Deep Web Search (Federated Search) | None | -- Pick One -- | 1.8.r1 | Deep web search | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 2 | Encoding to various formats | None | -- Pick One -- | 1.9.r1 | Encoding Formats | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 1 | Legal documents/contracts | None | -- Pick One -- | 2.1.r1 | Contracts | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 1 | Training | None | -- Pick One --
EduStream | 1 | Hosting services with CCCTC and CENIC | None | -- Pick One -- | 2.3.r1 | [NAME] | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 2 | Reporting and Metrics capability | None | -- Pick One --
EduStream | 1 | ADA compliant content | None | -- Pick One -- | 3.1.r1 | [NAME] | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 3 | Non-proprietary content | None | -- Pick One -- | 3.2.r1 | Student Environment | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EduStream | 4 | Ingestion Formats | None | -- Pick One -- | 3.9.r1 | Ingestion | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0