tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702129d1604097061-weighted-random-number-based-on-input-cell-example
Sheet: Sheet1

select weighted random number
Lookup of number
Random number alternative
Change This Number | 25 |  |  |  | 0 | 0.14 | 0 should always be 14% (basically, 1 chance per week to be 0)
Any time a 0 is not selected, the chances then move to the remaining numbers and need to average around the cell in B1 based on weights.  A 25 is more likely than a 40, but a 40 is more likely than a 50.  Etc |  |  |  |  |  |  | These totals should be weighted to have more likelihood of being near B1
 |  |  |  |  | This last number should be double B1
Spreadsheet: 882777d1731247902-list-item-with-duplicate-criteria-list-items-with-duplicate-criteria
Sheet: Sheet1

 |  | Main  Datatable |  |  |  |  | Minimum value | 20
 |  | Product | Value |  |  |  |  | No of >= minimum | 1 | 2 | 3 | 4 | 5 |  | Just to explain the logic and the expected results here.
 |  | F | 50 |  |  |  |  |  | B | B | B | B | B |  | I want a certain number of products that are above the minimum value.
 |  | A | 10 |  |  |  |  |  |  | C | C | C | C |  | The challenges is that if there are multiple products with equal values I want all of those included in the same step.
 |  | E | 50 |  |  |  |  |  |  |  | D | D | D |  | This can be seen between 3 and 4, it takes a jump there because E and F has the same value.
 |  | G | 60 |  |  |  |  |  |  |  |  | E | E
 |  | B | 20 |  |  |  |  |  |  |  |  | F | F
 |  | D | 40 |  |  |  |  |  |  |  |  |  | G
 |  | C | 30
 |  |  |  |  |  | Here is my working solution.
 | Minimum value | 20 |  |  |  | It works fine without any "dead" clicks on the spinner button.
 | No of >= minimum | 4 |  |  |  | The issue is that it is so cumbersome! Surely there is a smarter way of doing this without all these helper columns and [NAME] back and forth?
 |  |  | Result
helper 1 | helper 2 | helper 3 | Product | Value
10 | 60 | 30 | C | 30
60 | 20 | 40 | D | 40
20 | 40 | 50 | E | 50
40 | 30 |  | F | 50
30
Spreadsheet: 122897d1317231218-tally-of-2-data-columns-compdeptcount
Sheet: Sheet1

 |  | COMPANY | DEPT
 |  | comp3 | DeptA
 |  | comp2 | DeptB
 |  | comp3 | DeptC
 |  | comp1 | DeptD
 |  | comp2 | DeptA
 |  | comp2 | DeptB
 |  | comp3 | DeptC
 |  | comp1 | DeptD
 |  | comp1 | DeptA
 |  | comp3 | DeptB
 |  | comp2 | DeptC
 |  | comp1 | DeptD
 |  | comp1 | DeptA
 |  | comp2 | DeptB
 |  | comp1 | DeptC
 |  | comp2 | DeptD
 |  | comp1 | DeptA
 |  | comp2 | DeptB
 |  | comp3 | DeptC
 |  | comp3 | DeptD
Spreadsheet: 05d13b4b-dcc4-4c9d-9851-9db68c942c16
Sheet: 2008-09

Table T2
Non-UK Domiciled Student Numbers by Ethnic Group
Ethnic Group | Undergraduate | Graduate | Total
Asian or Asian British
- Bangladeshi | 12 | 16
- Indian | 62 | 150
- Pakistani | 26 | 44
- Other | 199 | 297
Subtotal
Black or Black British
- African | 16 | 73
- Caribbean | 6 | 8
- Other | 9 | 20
Subtotal
Chinese
Chinese | 530 | 457
Subtotal
Mixed
[NAME] and Asian | 24 | 25
[NAME] and Black African | 7 | 11
[NAME] and Black Caribbean | 1 | 4
- Other | 25 | 77
Subtotal
White
[NAME] | 895 | 1552
Subtotal
Other
Other Ethnic Background | 49 | 118
Information Refused | 1456 | 180
Not Known | 641 | 155
Subtotal
Total
This table is concerned with students whose domicile at the time of application is outside the UK irrespective of nationality.
Spreadsheet: 3d81743a-bf5c-410a-9c08-7397e0c33c22
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: October 1, 2014 (4:31 am)
Period | Value
Jan-2002
Feb-2002
Mar-2002
Apr-2002
May-2002
[NAME]
Jul-2002
Aug-2002
Sep-2002
Oct-2002
Nov-2002
Dec-2002
[NAME]
Feb-2003
Mar-2003
Apr-2003
May-2003
Jun-2003
Jul-2003
Aug-2003
Sep-2003
Oct-2003
Nov-2003
Dec-2003
Jan-2004
Feb-2004
Mar-2004
Apr-2004
May-2004
Jun-2004
Jul-2004
Aug-2004
Sep-2004
Oct-2004
Nov-2004
Dec-2004
Jan-2005
Feb-2005
Mar-2005
Apr-2005
May-2005
Jun-2005
Jul-2005
Aug-2005
Sep-2005
Oct-2005
Nov-2005
Dec-2005
Jan-2006
Feb-2006
Mar-2006
Apr-2006
May-2006
Jun-2006
Jul-2006
Aug-2006
Sep-2006
Oct-2006
Nov-2006
Dec-2006
[NAME]
Feb-2007
Mar-2007
Apr-2007
May-2007
Jun-2007
Jul-2007
Aug-2007
Sep-2007
Oct-2007
Nov-2007
Dec-2007
Jan-2008
Feb-2008
Mar-2008
Apr-2008
May-2008
Jun-2008
Jul-2008
Aug-2008
Sep-2008
Oct-2008
Nov-2008
Dec-2008
Jan-2009
Feb-2009
Mar-2009
Apr-2009
May-2009
Jun-2009
Jul-2009
Aug-2009
Sep-2009
Oct-2009
Nov-2009
Dec-2009
[NAME]
[NAME]
Mar-2010
Apr-2010
[NAME]
[NAME]
[NAME]
Aug-2010
Sep-2010
Oct-2010
Nov-2010
Dec-2010
Jan-2011
Feb-2011
Mar-2011
Apr-2011
May-2011
Jun-2011
Jul-2011
Aug-2011
Sep-2011
Oct-2011
Nov-2011
Dec-2011
Jan-2012
Feb-2012
Mar-2012
Apr-2012
May-2012
Jun-2012
Jul-2012
Aug-2012
Sep-2012
Oct-2012
Nov-2012
Dec-2012
Spreadsheet: 40524d1238857019-auto-transfer-data-second-table
Sheet: air cooler

Second table
 |  |  |  |  |  | Description | Service |  | Material |  | Section Size |  |  | Spec. Heat Capacity                        [kJ/(kg.K)] | Heat Duty (chosen)   [kW] | Design Pressure                           [kg/cm2g] | [NAME]. / Min. Allowable        Pressure                          PS   [barg] |  | Design      Temperature            [°C] | Calculated Pressure Drop [NAME]/cm2] | [NAME] of each fan [KW] | Weight [MT] | Remarks
No. | Duty | Client | Value | Name-1 | [NAME] |  | Air Side | Tube Side | Fin | Tube | W [MM] | L [MM] | Tube II | Shell I |  | Tube Side | Shell I | Tube II | Tube | Tube
1 | [NAME] | CLIENT-1 | Value-1 | 28-EA-00-103 | SRU
2 | LSTK-2 | CLIENT-2 | Value-2 | 28-EA-00-205 | Hydrogen
3 | [NAME] | CLIENT-3 | Value-3
4 | LSTK-4 | CLIENT-4 | Value-4
5 | LSTK-5 | CLIENT-5 | Value-5
6 | LSTK-6 | CLIENT-6 | Value-6
7 | LSTK-7 | [NAME] | Value-7
8 | [NAME] | CLIENT-8 | Value-8
9 | LSTK-9 | CLIENT-9 | Value-9
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 2357923 | 975154 | 1661377 | 2421870 | 3512474 | 1585219 | 1097508 | 89913 | 13701438
Fixed-Float | 17452061 | 6829873 | 12945754 | 26241891 | 60906219 | 42096137 | 18988109 | 2001374 | 187461418
FRA | 32914029 | 11900464 | 10929002 | 2628510 | 316319 | - | - | - | 58688324
OIS | 16359503 | 5210287 | 6020322 | 4812689 | 2044498 | 314499 | 186165 | 16460 | 34964423
Swaption | 3222369 | 1557324 | 2410594 | 2877852 | 3839598 | 1824675 | 839482 | 12236 | 16584130
OTHER* | 2208854 | 1121161 | 1442080 | 2065295 | 4404000 | 3810555 | 2310554 | 155205 | 17517704
TOTAL | 74514739 | 27594263 | 35409129 | 41048107 | 75023108 | 49631085 | 23421818 | 2275188 | 328917437
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 329146d1404215696-index-match-and-sumproduct-or-sumif-on-multiple-criteria-o1-book-1-tabkaz
Sheet: Sheet2

 |  |  | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday |  |  |  |  |  |  |  | Data sheet
 | Time | Duration | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu |  |  |  |  | Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00 | 2014-07-08 00:00:00 | 2014-07-09 00:00:00 | 2014-07-10 00:00:00 | Required solution | manual calculation of tue | manual calculation of all days |  | 14:00:00 | 0.226 | 0.59 | 0.56 | 0.09497 | 0.27667 | 0.71325 | 0.20273
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 0.35603 | 0.89 | 0.41 | 0.04118 | 0.32722 | 0.22469 | 0.04751
 | 15:00:00 | 25 | 1 | 5 | 2 | 2 |  | 5 |  | 5 | 1 | 1 |  | 4.45 | 6.60295 |  | 16:00:00 | 0.09624 | 0.00683 | 0.15 | 0.2659 | 0.1042 | 0.13407 | 0.14101
 | 17:00:00 | 30 | 2 | 2 | 2 | 5 | 6 | 1 | 1 | 1 |  | 1 |  |  |  |  | 17:00:00 | 0.12411 | 0.1502 | 0.18 | 0.15454 | 0.08427 | 0.02839 | 0.24431
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | 0.0788 | 0 | 0.1 | 0.12141 | 0.07616 | 0.05667 | 0.2356
 |  |  | Required details
 |  |  | find & match tue rating of 15:00 time in "data sheet" divide by 30 then *no of spot in tue * spot duration,  same way addup for all days i.e wed, thu, fri, sat,sun&mon
 | 15:00:00 | 25 | 4.45 | 4.45 | 2.225 | 1.483333333333333 | 0 | 3.708333333333333 | 0 | 4.45 | 4.45 | 2.225
 | 17:00:00 | 30 | 0.4506 | 0.3004 | 0.4506 | 0.751 | 0.9012 | 0.1502 | 0.1502 | 0.4506 | 0.3004 | 0.4506
Spreadsheet: 799050d1664894208-count-with-criteria-scoresheet-example
Sheet: Sheet1

Question Number | Question Type (T/B) | Subject Area           (MA, SC, SS, LA, AH) | STARTER 1 | STARTER 2 | STARTER 3 | STARTER 4 | ALTERNATE 1 | ALTERNATE 2 | ALTERNATE 3 | ALTERNATE 4 | BONUS POINT | BOUNCEBACK BONUS
1 | T | MA |  | 1
2 | B | SC |  |  |  |  |  |  |  |  | 1
3 | T | AH |  |  |  | 1
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1ST HALF
Number of Tossups Heard
Number of Tossups Correct
Number of Bonuses Heard
Number of Bonuses Correct
Number of Bouncebacks Correct
MA | Number Heard
MA | Number Correct
SC | Number Heard
SC | Number Correct
SS | Number Heard
SS | Number Correct
LA | Number Heard
LA | Number Correct
AH | Number Heard
AH | Number Correct
Spreadsheet: 220775d1363262959-sum-if-formula-financial-accounting-columbia-cu-home-loan-not-working
Sheet: Transactions

 | 2012 Final xxx Accounting-Account Transactions
 | Bank Name: |  | Columbia Credit Union |  |  |  |  |  | Account: | Account: |  | xxxx
 | Accounts Reviewed: |  | Home Equity Loan-Suffix 66 |  |  |  |  | Account Holder: |  | Account Holder: |  | xxxx
 | Account Timeperiod: |  | January 1, 2012 - December 31, 2012
Account | Date | Category | Payee | Check # | Payment Amount | Deposit Amount | Amounts for Report | Cleared Payment | Cleared Deposit | Account Balance | Check Memo
 | 2012-01-01 00:00:00 | Starting Loan Balance | Loan Balance |  |  | 54361.66
 | 2012-01-01 00:00:00 | [NAME] | [NAME] to Checking |  | 330
 | 2012-01-01 00:00:00 | [NAME] | [NAME] to Checking |  | 150
 | 2012-01-13 00:00:00 | [NAME] | [NAME] to Checking |  | 100
 | 2012-01-14 00:00:00 | AP Loan Payments | Payment |  |  | 300
 | 2012-01-18 00:00:00 | [NAME] | [NAME] to Checking |  | 200
 | 2012-01-31 00:00:00 | AP Loan Payments | Payment |  |  | 815.42
 | 2012-01-31 00:00:00 | Loan Interest | Accrued Interest |  | 84.1
 | 2012-01-31 00:00:00 | Loan Interest | Accrued Interest |  | 102.24
 | 2012-01-31 00:00:00 | Loan Fees | Fees |  | 25
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: SPEECH

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.A. Degree Communication | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | SPEECH 050 | 1 | X | 1
1 | SPEECH 100 | 1 | X | 1 | X | 1 | 6 | 1 | 3 | 1
1 | SPEECH 100H | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
5 | SPEECH 101 | 1 | X | 1
4 | SPEECH 110 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | SPEECH 111 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | SPEECH 111H | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | SPEECH 120 | 1 | X | 1 | X | 1 | X | 1
4 | SPEECH 120H | 1 | X | 1 | X | 1 | X | 1
1 | SPEECH 125 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
4 | SPEECH 135 | 1 | X | 1 | X | 1
4 | SPEECH 140 | 1 | X | 1 | X | 1 | X | 1 | 1 | 1
4 | SPEECH 145 | 1 | X | 1 | X | 1
4 | SPEECH 155 | 1 | X | 1
4 | SPEECH 174 | 1 | X | 1 | X | 1
5 | SPEECH 246ABCD | 1
5 | SPEECH 247ABC | 1
5 | SPEECH 248AB | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 722539d1615307948-consolidate-but-calculate-the-difference-subtract-during-consolidate-dia-textbook
Sheet: Sheet1

Name | Sales |  |  |  |  | Unique Books | Difference first vs last
fred's journey | 12
jan's dogs | 14
[NAME]'s adventures | 15
mark's cookbook | 11
fred's journey | 18
[NAME] hams | 14
[NAME] ted talks | 22
julia's child | 25
[NAME]'s folly | 27
[NAME]'s adventures | 24
mark's cookbook | 28
[NAME]'s folly | 30
[NAME] hams | 33
Spreadsheet: 141775d1329436507-dependent-drop-down-dv-optional
Sheet: Backup

Note1 | Result1
Note2 | Result2
[NAME] | Result3
Note4 | [NAME]
Note5 | Result5
Note6 | Result6
Note7 | Result7
[NAME] | Result8
Note9 | Result9
Note10 | Result10
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: Amoco Abo

 | [NAME]
Day | Measured | Scheduled | Imbal
1 | 11993 | 9607
2 | 12115 | 12188
3 | 12273 | 11816
4 | 12309 | 11954
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-07-31 00:00:00 |  |  | 147996
2000-08-04 00:00:00
Spreadsheet: 98530d1297384218-formula-for-chronologically-aligning-days-of-the-week-xa-test-total-cat-inv-combine-total-names-for-excel-study-
Sheet: invoice

 | Your Total Industrial Solution Since 1983
 | CUSTOMER: |  | test |  |  |  |  |  | DATE: | 2011-02-10 00:00:00
 | ADDRESS: |  | 22 |  |  |  |  |  | INVOICE #: | 333
 | CITY: |  | both |  |  |  |  |  | JOB #: | 444
 | LOCATION: |  | north |  |  |  |  |  | PO #: | 11414
ELECTRICAL
 | Tri-State Electrical Contractors, Inc |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | LABOR / EQUIP
 |  |  |  |  |  |  |  |  | MATERIAL
 |  |  | Oklahoma Electrical Contractors License #000025 |  |  |  |  |  | SUB-TOTAL
AUTOMATION
 | Tri-State Automation & Controls, LLC |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | LABOR / EQUIP
 |  |  |  |  |  |  |  |  | MATERIAL
 |  |  |  |  |  |  |  |  | SUB-TOTAL
CONCRETE
 | Tri-State Concrete & Foundations, LLC |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | LABOR / EQUIP
 |  |  |  |  |  |  |  |  | MATERIAL
 |  |  |  |  |  |  |  |  | SUB-TOTAL
CONSTRUCTION
 | Great Plains Construction, LLC |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | LABOR / EQUIP
 |  |  |  |  |  |  |  |  | MATERIAL
 |  |  |  |  |  |  |  |  | SUB-TOTAL
GRAND TOTAL
• | Remit To Address: |  | TRI-STATE |  |  |  |  |  | Office | [PHONE]
 |  |  | 24225 N COUNCIL ROAD |  |  |  |  |  | Fax | [PHONE]
 |  |  | EDMOND, OKLAHOMA 73025-9722 |  |  |  |  |  | Toll Free | [PHONE]
 |  |  |  |  |  |  |  |  | Web Site | www.tsecinc.com
• | Please see reverse side for mandatory terms and conditions of sale |  |  |  |  |  |  |  | Engineer of Record: Garver, LLC
• | Net 10 days.    Delinquent accounts subject to monthly charges on unpaid balance |  |  |  |  |  |  |  | 1016 24th Ave NW, [NAME], OK 73069
• | Caution: Frequent testing of electrical, electronic and programmable operational, control and safety circuits and components are critical
• | If there are no unpaid invoices that are dated earlier than the date on this invoice, and if this invoice is paid within 10 days of this invoice date; then a
 | discount may be applied at | 0.02 |  | resulting in savings of |  | at an adjusted Grand Total of
Spreadsheet: 583226d1532331569-dependent-drop-down-or-vlook-ups-to-be-used-for-multiples-data-interconnected-naroda-project-costing
Sheet: LOBBY

PROJECT COSTING FOR MATERIAL RELATED TO LOBBY AREA
SR NO | ITEMS DESCRIPTION | QTY REQD | VENDOR | SIZE | SPECIFICATION | COST PER PIECE | AMOUNT | GST % | GST AMOUNT | TOTAL COST
1 | POSTER BOXES AT LOBBY AREA
 | WIRING FOR POSTER BOXES AT LOBBY AREA
 | SOFAS AT LOBBY AREA FOR PUBLIC SITTINGS
 | BENCHES AT LOBBY AREA FOR PUBLIC SITTINGS |  |  |  |  |  |  | 0.18
 | TABLE & CHAIRS AT LOBBY AREA FOR PUBLIC SITTINGS
 | PUFFI AT LOBBY AREA FOR PUBLIC SITTINGS
 | DRINKING WATER FACILITY
 | PoE IP CAMERAS WITH VOICE RECORDING
 | PoE IP DOME CAMERAS
 | PoE IP BULLET CAMERAS
 | WIRING FOR CAMERAS AT LOBBY AREAS
 | SMOKE DETECTORS
 | FIRE EXTINGUISHERS
 | LOBBY DUCTING
 | FALL CEILING POP WORK AT LOBBY AREA
 | LOBBY PAINT
TOTAL COST OF EXPENSES FOR THE NEW PROJECT
Spreadsheet: 163886d1340529550-how-to-copy-data-from-cells-without-alt-enter-worksheet
Sheet: Sheet1

S.N. | FORM NO/DATE |  |  | I want this >>> | FORM NO | DATE
1 | 220 11-2-98 | <<<< this is manually entered Alt+Enter to separate form no. and Date |  |  | 220 | 1998-11-02 00:00:00
2 | 221 12-2-98 |  |  |  | 221 | 1998-12-02 00:00:00
3 | 222 13-2-98 |  |  |  | 222 | 13-2-98
4 | 223 15-2-98 |  |  |  | 223 | 1998-05-02 00:00:00
5 | 224 18-2-98 |  |  |  | 224 | 18-2-98
6 | 225 22-2-98 |  |  |  | 225 | 22-2-98
7 | 5020 23-2-98 |  |  |  | 5020 | 23-2-98
8 | 5021 24-2-98 |  |  |  | 5021 | 24-2-98
9 | 5022 28-2-98 |  |  |  | 5022 | 28-2-98
Spreadsheet: 94839d1294607432-retreiving-multiple-matches-values-in-same-row-if-x-is-true-1test
Sheet: Avg

AVERAGE
 |  | Line A |  |  |  |  | Line B |  |  |  |  | Line C |  |  |  |  | Line D
 |  | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5
Saturday | 2011-01-01 00:00:00 | 350 | 400 | 500 | 300 | 450 | 342 | 402 | 502 | 305 | 456 | 344 | 386 | 485 | 275 | 422 | 327 | 376 | 497 | 284 | 442
Sunday | 2011-01-02 00:00:00 | 356 | 406 | 506 | 306 | 456 | 349 | 409 | 509 | 312 | 463 | 364 | 406 | 505 | 295 | 442 | 380 | 429 | 550 | 337 | 495
Monday | 2011-01-03 00:00:00 | 384 | 434 | 534 | 334 | 484 | 376 | 436 | 536 | 339 | 490 | 378 | 420 | 519 | 309 | 456 | 361 | 410 | 531 | 318 | 476
Tuesday | 2011-01-04 00:00:00 | 332 | 382 | 482 | 282 | 432 | 325 | 385 | 485 | 288 | 439 | 340 | 382 | 481 | 271 | 418 | 356 | 405 | 526 | 313 | 471
Wednesday | 2011-01-05 00:00:00 | 326 | 376 | 476 | 276 | 426 | 318 | 378 | 478 | 281 | 432 | 320 | 362 | 461 | 251 | 398 | 325 | 385 | 485 | 288 | 439
Thursday | 2011-01-06 00:00:00 | 356 | 405 | 526 | 313 | 471 | 380 | 429 | 550 | 337 | 495 | 332 | 382 | 482 | 282 | 432 | 364 | 406 | 505 | 295 | 442
Friday | 2011-01-07 00:00:00 | 340 | 382 | 481 | 271 | 418 | 378 | 420 | 519 | 309 | 456 | 325 | 385 | 485 | 288 | 439 | 342 | 402 | 502 | 305 | 456
Saturday | 2011-01-08 00:00:00
Sunday | 2011-01-09 00:00:00
Monday | 2011-01-10 00:00:00
Tuesday | 2011-01-11 00:00:00
Wednesday | 2011-01-12 00:00:00
Thursday | 2011-01-13 00:00:00
Friday | 2011-01-14 00:00:00
Saturday | 2011-01-15 00:00:00
Sunday | 2011-01-16 00:00:00
Monday | 2011-01-17 00:00:00
Tuesday | 2011-01-18 00:00:00
Wednesday | 2011-01-19 00:00:00
Thursday | 2011-01-20 00:00:00
Friday | 2011-01-21 00:00:00
Saturday | 2011-01-22 00:00:00
Sunday | 2011-01-23 00:00:00
Monday | 2011-01-24 00:00:00
Tuesday | 2011-01-25 00:00:00
Wednesday | 2011-01-26 00:00:00
Thursday | 2011-01-27 00:00:00
Friday | 2011-01-28 00:00:00
Saturday | 2011-01-29 00:00:00
Sunday | 2011-01-30 00:00:00
Monday | 2011-01-31 00:00:00
Spreadsheet: 0cbfbe33-f2e7-4d4e-a1f2-54b43ac38542
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTRF | Test | FFTRF | Trypsin, Fecal | Trypsin, F | Semi-quantitative Film Digestion | Stool Container: Stool |  |  | 5 | g | 5 g of random stool. Ship frozen. | 5 grams | Hemolysis:	NA Thawing:	Warm reject; Cold reject Lipemia:	NA Icterus:	NA Other:	Diapers; specimen containing barium | Greater than or equal to 1:96   A fecal trypsin titer greater than or equal to 1:96 is considered normal. Fecal trypsin is measured by serially diluting stool in buffer and identifying the greatest titer at which x-ray film is cleared of its gelatin emulsion.   Test Performed by:      ARUP Laboratories                                   500 [NAME]                                   Salt Lake City, UT 84108 | Sunday through Saturday | 1 day | 3 - 5 days | 1 | 84488 |  |  |  |  | ARUP Laboratories
FFTRF | [NAME] | FECAL | Fecal |  |  |  | Frozen | 7 days
FFTRF | Result | Z2655 | Trypsin, F | Trypsin, F | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 273339d1382685012-shortening-of-long-array-formula-by-short-formula-shortening-array-formula-of-vat
Sheet: Result(Revised)

Date | Name of Party | Particulars | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total
 |  |  | [NAME]. 610
 |  |  | [NAME]. 504
 |  |  | [NAME]. 4409
 |  |  | PP NO.55408
 |  |  | PP NO. 55253
 |  |  | RECEPT NO. 93198
Spreadsheet: 827183d1682526480-unable-to-get-countif-formula-to-calculate-two-columns-vehicle-inventory-5
Sheet: Sheet1

DISTRICT / SITE | PARKING SLOT # | VIN | MAKE | MODEL
1/1 | 120 | JH4KA3170LC006787 | Chevrolet | 2.6
1/1 | 11 | [NAME] | Ford 1.1 | Type III
1/1 | 12 | 2C4GM68475R667819 | Dodge | ORV
1/1 | 65 | 1P4GH44R0RX359386 | Chevrolet | 2.1
1/1 | 12 | 1P4GH44R0RX359386 | Toyota | ORV II
1/1 | 1 | 1GBJ7D1B4BV132373 | Ford 1.0 | Type III
1/4 | 66 | JH4KA2640GC004861 | Toyota | ORV II
1/1 | 41 | JH4CC2640NC004693 | Toyota | ORV II
 | Chevrolet | Toyota | Dodge | Ford 1.0 | Ford 1.1 Type III
Site 1
Site 2
Site 3
Site 4
Spreadsheet: 852015d1702115732-need-formula-to-automatically-sum-all-values-within-a-year-excel-workbook
Sheet: Ark

0.2 | 2018-10-19 00:00:00
0.2 | 2018-12-27 00:00:00
0.2 | 2019-03-28 00:00:00
0.2 | 2019-06-19 00:00:00
0.21 | 2019-09-20 00:00:00
0.21 | 2020-01-01 00:00:00
0.22 | 2020-03-23 00:00:00
0.22 | 2020-06-17 00:00:00
0.22 | 2020-09-22 00:00:00
0.07 | 2020-10-22 00:00:00
0.07 | 2020-11-20 00:00:00
0.08 | 2020-12-18 00:00:00
0.07 | 2021-01-21 00:00:00
0.08 | 2021-02-18 00:00:00
0.08 | 2021-03-23 00:00:00
0.07 | 2021-04-22 00:00:00
0.08 | 2021-05-24 00:00:00
0.08 | 2021-06-22 00:00:00
0.07 | 2021-07-22 00:00:00
0.08 | 2021-08-23 00:00:00
0.08 | 2021-09-22 00:00:00
0.08 | 2021-10-21 00:00:00
0.08 | 2021-11-22 00:00:00
0.08 | 2021-12-21 00:00:00
0.08 | 2022-01-21 00:00:00
0.08 | 2022-02-18 00:00:00
0.08 | 2022-03-23 00:00:00
0.06 | 2022-04-21 00:00:00
0.04 | 2022-04-21 00:00:00
0.04 | 2022-05-12 00:00:00
0.06 | 2022-05-12 00:00:00
0.06 | 2022-06-21 00:00:00
0.02 | 2022-06-21 00:00:00
0.02 | 2022-07-21 00:00:00
0.06 | 2022-07-21 00:00:00
0.06 | 2022-08-23 00:00:00
0.02 | 2022-08-23 00:00:00
0.02 | 2022-09-22 00:00:00
0.07 | 2022-09-22 00:00:00
0.06 | 2022-10-21 00:00:00
0.02 | 2022-10-21 00:00:00
0.02 | 2022-11-22 00:00:00
0.06 | 2022-11-22 00:00:00
0.07 | 2022-12-21 00:00:00
0.02 | 2022-12-21 00:00:00
0.02 | 2023-01-23 00:00:00
0.06 | 2023-01-23 00:00:00
0.06 | 2023-02-20 00:00:00
0.02 | 2023-02-20 00:00:00
0.02 | 2023-03-23 00:00:00
0.07 | 2023-03-23 00:00:00
0.07 | 2023-04-21 00:00:00
0.07 | 2023-05-23 00:00:00
0.08 | 2023-06-21 00:00:00
0.07 | 2023-07-21 00:00:00
0.07 | 2023-08-23 00:00:00
0.08 | 2023-09-29 00:00:00
0.07 | 2023-10-23 00:00:00
0.08 | 2023-11-22 00:00:00
0.08 | 2023-12-29 00:00:00
0.07 | 2024-01-23 00:00:00
0.08 | 2024-02-21 00:00:00
0.08 | 2024-03-20 00:00:00
 | 2018
 | 2019
 | 2020
 | 2021
 | 2022
 | 2023
 | 2024
Spreadsheet: 797137d1663733859-matching-text-to-one-of-multiple-columns-sample-tally-spreadsheet2
Sheet: Entries to Compare

First Name | Last Name | Match | [NAME] | Notes
Abbigail | Wang |  |  | [NAME] should return "[NAME]"
Abbe | [NAME] |  |  | [NAME] should return ""
[NAME] | [NAME] |  |  | [NAME] should return "[NAME]"
Adi | Bells |  |  | [NAME] should return "Adison Bell"
[NAME] | Bell |  |  | [NAME] should return ""
Ade | Pearson |  |  | [NAME] should return ""
[NAME] | Horton |  |  | [NAME] should return ""