tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158005d1337952177-excluding-a-part-of-an-array-formula-examplesheet3
Sheet: Sheet1

A |  | 1 |  | 2 |  | 1 | I want the formula to count the times each number from a letter is lower than the other letter
A |  | 4 |  | 1 |  | 1 | So the formula in B1 would compare the two in C1 and C2 as they are both in A rows and as C1 is smaller than C2 would give a 1
b |  | 3 |  | 6 |  | 0 | But then the same formula moved down to B2 would be a 0 as C2 is larger than C1
b |  | 2 |  | 3 |  | 2 | If possible it would be good if the one formula also did the E column of numbers, but if it needs a seperate formula to keep it simple that's fine
C |  | 5 |  | 4 |  | 2 | The G column is just to show what the numbers would be if the formula is done exactly as I want it
C |  | 6 |  | 5 |  | 0
 |  |  |  |  |  | 2 |  | 4 |  |  | 1 |  |  | 0 | 1 | 1 | 1
 |  |  |  |  |  | 2 |  | 3 |  |  | 6 |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 2 |  | 2 |  |  | 3 |  |  | 1 | 1 | 2 | 2
 |  |  |  |  |  | 2 |  | 5 |  |  | 4 |  |  | 1 | 1 | 2 | 2
 |  |  |  |  |  | 2 |  | 6 |  |  | 5 |  |  | 0 | 0 | 0 | 0
Spreadsheet: 154204d1336307548-return-count-value-based-on-several-conditions-country-count
Sheet: Sheet1

Date of order | Send to country | Country list | Total 2012 | Jan'2012 | [NAME] | Mar'2012 | Apr'2012 | May'2012
2012-01-01 00:00:00 | Spain | Spain
2012-01-01 00:00:00 | Spain | Italy
2012-01-02 00:00:00 | Netherlands | France
2012-02-01 00:00:00 | Portugal | Germany
2012-02-01 00:00:00 | Belgium | Portugal
2012-02-01 00:00:00 | Spain | Netherlands
2012-03-01 00:00:00 | England | Belgium
2012-03-01 00:00:00 | Netherlands | England
2012-03-05 00:00:00 | Poland | Ireland
2012-03-05 00:00:00 | Belgium | Poland
2012-03-06 00:00:00 | Poland
2012-04-05 00:00:00 | Ireland
2012-04-05 00:00:00 | Germany
2012-04-05 00:00:00 | Germany
2012-04-10 00:00:00 | Italy
2012-04-12 00:00:00 | Spain
2012-04-30 00:00:00 | Italy
2012-05-01 00:00:00 | Netherlands
2012-05-10 00:00:00 | England
2012-02-15 00:00:00 | England
2012-05-12 00:00:00 | England
2012-05-13 00:00:00 | Belgium
2012-05-11 00:00:00 | Spain
2012-05-12 00:00:00 | Poland
Spreadsheet: 727387d1617876040-convert-a-formula-result-to-fit-between-a-range-of-values-depth-ranges
Sheet: Sheet1

 |  |  |  |  |  | This what the calculation result is |  |  |  |  |  |  | this is the range that it would fall in |  |  | Depth range categories required
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  | this would be, so rounded up |  |  | From | To
 |  |  | 1.56 |  | 1.901999999999999 |  |  |  |  |  |  |  | 1.75 |  |  | 0.5 | 0.75
 |  |  | 1.569000000000001 |  | 1.768000000000001 |  |  |  |  |  |  |  | 1.75
 |  |  | 1.768000000000001 |  | 1.901999999999999 |  |  |  |  |  |  |  | 2
 |  |  | 1.901999999999999 |  | 2.052 |  |  |  |  |  |  |  | 2
 |  |  | 2.052 |  | 2.396 |  |  |  |  |  |  |  | 2.25
 |  |  | 2.396 |  | 1.478 |  |  |  |  |  |  |  | 2
 |  |  | 2.396 |  | 2.256 |  |  |  |  |  |  |  | 2.5
 |  |  | 1.563 |  | 2.066999999999999 |  |  |  |  |  |  |  | 2
 |  |  | 2.066999999999999 |  | 2.256 |  |  |  |  |  |  |  | 2.25
 |  |  | 2.256 |  | 2.326 |  |  |  |  |  |  |  | 2.5
 |  |  | 2.326 |  | 2.389999999999999 |  |  |  |  |  |  |  | 2.5
 |  |  | 2.389999999999999 |  | 2.505 |  |  |  |  |  |  |  | 2.5
 |  |  | 2.505 |  | 2.484000000000001 |  |  |  |  |  |  |  | 2.5
 |  |  | 2.484000000000001 |  | 2.34 |  |  |  |  |  |  |  | 2.5
 |  |  | 1.635000000000001 |  | 2.137 |  |  |  |  |  |  |  | 2
 |  |  | 2.137 |  | 1.526000000000001 |  |  |  |  |  |  |  | 2
 |  |  | 2.137 |  | 1.905999999999999 |  |  |  |  |  |  |  | 2.25
 |  |  | 2.137 |  | 2.129 |  |  |  |  |  |  |  | 2.25
 |  |  | 2.129 |  | 2.332 |  |  |  |  |  |  |  | 2.25
 |  |  | 2.332 |  | 2.496
 |  |  | 2.496 |  | 2.34 |  |  |  |  |  |  |  | Also when a range is an exact caegroy
 |  |  | 2.34 |  | 2.441 |  |  |  |  |  |  |  | I would want it to fall into the lower range
 |  |  | 2.441 |  | 1.499999999999999 |  |  |  |  |  |  |  | for example
 |  |  | 1.589 |  | 1.700000000000001
 |  |  | 1.700000000000001 |  | 1.817000000000001 |  |  |  |  |  |  |  | When the result is 1.75
 |  |  | 1.817000000000001 |  | 1.800000000000001 |  |  |  |  |  |  |  | it would be in the range 1.50 - 1.75
 |  |  | 1.800000000000001 |  | 2.061 |  |  |  |  |  |  |  | and not 1.75 - 2.00
 |  |  | 1.529999999999999 |  | 2.061
 |  |  | 2.061 |  | 2.038
 |  |  | 2.038 |  | 1.656999999999999
 |  |  | 2.038 |  | 1.6
 |  |  | 1.6 |  | 1.5
 |  |  | 1.474 |  | 1.911999999999999
 |  |  | 1.911999999999999 |  | 1.899999999999999
 |  |  | 1.899999999999999 |  | 1.92
 |  |  | 1.92 |  | 1.591
 |  |  | 1.591 |  | 1.5
 |  |  | 1.5 |  | 2.739999999999999
 |  |  | 2.739999999999999 |  | 0.7690000000000001
 |  |  | 0.7690000000000001 |  | 3.03
 |  |  | 3.03 |  | 3.146
 |  |  | 3.146 |  | 1.5
 |  |  | 1.59 |  | 1.569000000000001
 |  |  | 2.18 |  | 2.256
 |  |  | 2.03 |  | 2.137
 |  |  | 1.73 |  | 1.800000000000001
Spreadsheet: 0fc03274-0ca7-4519-b53a-66ec2f274c52
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Greatworshipsongs.Com Csr | 645757157821 | Greatworshipsongs.Com Band | Let Everything That Has Breath | 2008-05-06 | Compact Disc | Praise | 12.99 | N | To Be Retired
Spreadsheet: 151854d1335166380-excel-2007-how-to-get-sum-of-a-criteria-within-specified-dates-attachment
Sheet: Sheet1

Sr No. | Product | Qty | Receipt date |  |  | Need answer as below
1 | Pen | 10 | 01.03.12
2 | Pencil | 15 | 01.03.12 |  |  | Product | receipt from date | receipt to date | Qty
3 | Eraser | 20 | 01.03.12 |  |  | pen | 01.03.12 | 05.03.12 | ?
4 | Pen | 25 | 02.03.12
5 | Pencil | 30 | 02.03.12
6 | Eraser | 18 | 02.03.12
7 | Pen | 20 | 03.03.12
8 | Pencil | 17 | 03.03.12
9 | Eraser | 16 | 03.03.12
10 | Pen | 22 | 04.03.12
11 | Pencil | 40 | 04.03.12
12 | Eraser | 52 | 04.03.12
13 | Pen | 70 | 05.03.12
14 | Pencil | 55 | 06.03.12
15 | Eraser | 12 | 06.03.12
16 | Pen | 14 | 06.03.12
17 | Pencil | 16 | 07.03.12
18 | Eraser | 12 | 07.03.12
19 | Pen | 18 | 07.03.12
20 | Pencil | 16 | 08.03.12
21 | Eraser | 5 | 08.03.12
Spreadsheet: 835012d1688226647-getting-data-from-another-cell-sample_data
Sheet: Sheet1

product | name | value | type |  |  | product | name | store* | sold*
1 | a | 93309.5859375 | store |  |  | 1
1 | a | 2333017 | sold |  |  | 2
2 | b | 5727581 | store |  |  | 3
2 | b | 1362215.75 | sold |  |  | 4
3 | c | 103031.53125 | store |  |  | 5
3 | c | 21325.849609375 | sold
4 | d | 5031.3701171875 | store
3.7 | d | 13443.16015625 | sold
5 | e | 9578.8203125 | store
4.5 | e | 13868.4501953125 | sold
Spreadsheet: 147538d1332850915-summary-sheet-820474-summary-sheet-summarysheettest
Sheet: Raw Data

Project | First Name | Team | % Time on project | Working Pattern
P1 | Adrian | A Team | 100 | FT
P1 | Betty | B Team | 100 | FT
P1 | [NAME] | A Team | 100 | FT
P1 | [NAME] | A Team | 20 | PT
P1 | Katrina | C Team | 60 | PT
P1 | [NAME] | A Team | 50 | PT
P2 | [NAME] | A Team | 100 | FT
P2 | [NAME] | A Team | 50 | PT
P2 | [NAME] | B Team | 10 | PT
P3 | [NAME] | C Team | 100 | FT
P3 | Fred | A Team | 100 | FT
P3 | Grant | A Team | 100 | FT
P3 | [NAME] | B Team | 100 | FT
P3 | Ivor | A Team | 100 | FT
P3 | Katrina | C Team | 40 | PT
P3 | [NAME] | B Team | 90 | PT
P3 | [NAME] | A Team | 50 | PT
P3 | [NAME] | A Team | 100 | PT
 |  |  |  |  |  | Project | P1
 |  |  |  |  |  | Sum of % Time on project | Column Labels
 |  |  |  |  |  | Row Labels | FT | PT | Grand Total
 |  |  |  |  |  | A Team | 200 | 70 | 270
 |  |  |  |  |  | Adrian | 100 |  | 100
 |  |  |  |  |  | [NAME] | 100 |  | 100
 |  |  |  |  |  | [NAME] |  | 20 | 20
 |  |  |  |  |  | [NAME] |  | 50 | 50
 |  |  |  |  |  | B Team | 100 |  | 100
 |  |  |  |  |  | Betty | 100 |  | 100
 |  |  |  |  |  | C Team |  | 60 | 60
 |  |  |  |  |  | Katrina |  | 60 | 60
 |  |  |  |  |  | Grand Total | 300 | 130 | 430
 |  |  |  |  |  | Choose to filter on the Project: All or P1, [NAME], P3 or a combination
 |  |  |  |  |  | Choose to filter on the Team: All or A Team, B Team, C Team or a combination
 |  |  |  |  |  | You could move the Working Pattern into the column labels to filter on that, if you wish
Spreadsheet: 364455ea-0670-4d8b-bb61-6eca1fa152fa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Calculate Daily Protein Needs | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Enter Weight in lbs
 |  |  | Calculating Your Daily Protein Needs
 |  |  |  |  |  |  | Enter body weight
 |  |  |  |  |  |  | 160 | lbs
 |  |  |  |  | Enter Activity Level
 |  |  |  |  |  | Activity Level | Strength
 |  |  |  |  |  | Data | Total
 |  |  |  |  |  | Minimum daily protein needs | 0.6
 |  |  |  |  |  | Maximum daily protein needs | 0.9
 |  |  |  | Your protein needs are between
 |  |  |  | 96 | g |  | and | 144 | g
 |  | Enter Weight in kg
 |  | Calculating Your Daily Protein Needs
 |  |  |  | Enter body weight
 |  |  |  |  |  |  | 70 | [NAME]
 |  |  |  | Enter Activity Level
 |  |  |  |  |  | Activity Level | Endurance
 |  |  |  |  |  | Data | Total
 |  |  |  |  |  | Minimum daily protein needs | 0.6
 |  |  |  |  |  | Maximum daily protein needs | 0.9
 |  |  |  | Your protein needs are between
 |  |  |  | 92.39999999999999 | g |  | and | 138.6 | g
Spreadsheet: 763728d1642352712-find-some-with-consecutive-days-log-book-new-for-excel-forum-1-
Sheet: LogBook

 |  |  |  |  |  |  |  |  |  |  | 3 | Consecutive days
 |  |  |  |  |  |  |  |  |  |  |  | Consecutive days Block No. | Block length | [NAME] | Offset Blocks | Result for block |  | MAX
183 | 2012-09-16 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
184 | 2012-09-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
185 | 2012-09-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
186 | 2012-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | 5.2
187 | 2012-09-21 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
188 | 2012-09-23 00:00:00 |  |  |  |  |  |  |  |  |  | 4.2
189 | 2012-09-24 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
190 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  |  | 4.8
191 | 2012-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
192 | 2012-09-29 00:00:00 |  |  |  |  |  |  |  |  |  | 1
193 | 2012-09-30 00:00:00 |  |  |  |  |  |  |  |  |  | 3.1
194 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
195 | 2012-10-02 00:00:00 |  |  |  |  |  |  |  |  |  | 5.8
196 | 2012-10-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
197 | 2012-10-05 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
198 | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 10
199 | 2012-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 20
200 | 2012-10-09 00:00:00 |  |  |  |  |  |  |  |  |  | 30
201 | 2012-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
202 | 2012-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
Spreadsheet: d232e966-61cd-40e3-81f7-a1b6f8b2145b
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Fervent Records | 80688732226 | Cadia | Cadia | 2008-02-26 | Compact Disc | Ac | 5 | N | To Be Retired
Word Records | 80688742423 | Cadia | Trust In Me Now | 2008-04-29 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Miller

School |  |  | Scholarship | Experiation Date
[NAME] |  |  | Hino Motors Scholarship | March 7th
 |  |  | Foodland Scholarship Program | March 12th
 |  |  | Ohio Association of Garden Clubs Scholarship | March 15th
 |  |  | [NAME] Memorial Scholarship | March 29th
 |  |  | [NAME] | March 31st
 |  |  | Minority Journalism Scholarship | March 31st
 |  |  | [NAME] | April  5th
 |  |  | Ohio State Fair Scholarship | July 1st
Spreadsheet: 751429d1634110116-highlight-or-list-volunteers-who-having-been-assigned-volunteer-schedulefilterandisna
Sheet: Locations

 |  |  | Monday [NAME] | Monday Volunteers Unused | Tuesday [NAME] | Wednesday [NAME] | Thursday [NAME] | Friday [NAME]
 | Region 1 |  |  | Region 1 Unused
 | Location 1 |  |  |  |  |  | Volunteer 9
 | Location 2 |  | Volunteer 16 | Volunteer 5
 | Location 3 |  | Volunteer 12 | Volunteer 10
 | Region 2 |  |  | Region 2 Unused
 | Location 4
 | Location 5 |  | Volunteer 7
 | Location 6
 | Region 3 |  |  | Region 3 Unused
 | Location 7
 | Location 8
 | Region 4 |  |  | Region 4 Unused
 | Location 9
 | Location 10
 | Region 5 |  |  | Region 5 Unused
 | Location 11
 | Location 12
 | Location 13
 |  |  |  |  | Tue Volunteers Unused | Wed Volunteers Unused | Thur Volunteers Unused | Fri Volunteers Unused
 |  |  |  |  | Volunteer 7 | Volunteer 3 | Volunteer 4 | Volunteer 9
 |  |  |  |  | Volunteer 16 | Volunteer 16 |  | Volunteer 1
 |  |  |  |  |  | Volunteer 4 |  | Volunteer 8
 |  |  |  |  |  | Volunteer 9 |  | Volunteer 13
Spreadsheet: 837409d1690144338-formula-to-pull-from-one-tab-to-another-efhelp-solution-
Sheet: Raw data

Document Number | Name | Revision : Name | Status | Item | PWO Quantity | Total SOH | Open PO Qty
1 | HU16860 | HU16860 V1 | Closed | BULK-16860 | 199980 | 16560 | 864380
1 | HU16860 | HU16860 V1 | Closed | BOT-100Clear | 1111 | 71567 | 59646
1 | HU16860 | HU16860 V1 | Closed | CAP-38mmGold | 1111 | 75112 | 8700
1 | HU16860 | HU16860 V1 | Closed | LAB-HU-16860 | 1111 | 8229
2 | CU16860 | CU16860 V1 | Closed | BULK-16860 | 199980 | 16560 | 864380
2 | CU16860 | CU16860 V1 | Closed | BOT-100Clear | 1111 | 71567 | 59646
2 | CU16860 | CU16860 V1 | Closed | CAP-38mmSilver | 1111 | 78150 | 145275
2 | CU16860 | CU16860 V1 | Closed | LAB-CU-16860 | 1111
Spreadsheet: 57448d1257603049-list-only-oldest-5-or-10-open-complaints-complaintlog-mockup
Sheet: Dashboard

 |  | COMPLAINT ANALYSIS FOR LOHMANN TECHNOLOGIES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Analysis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] vs. Total |  | Valid vs origin |  |  | [NAME] vs. [NAME] |  |  | [NAME] vs. Defect
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Valid | TPE | KY | VA | Graphics | Technical | Bag | Open Side Adhesive | Closed Side Adhesive | Carrier | Liner | [NAME] | Packaging | Physical Defects | Foreign material | Slitting Issues | Wrinkles | Release | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2004 | 53 | 18 | 15 | 3 |  | 11 | 6 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 7 | 1 | 1 | 4 | 1 | 0 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2005 | 32 | 15 | 11 | 4 |  | 8 | 5 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 11 | 1 | 0 | 0 | 0 | 0 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2006 | 40 | 22 | 11 | 11 |  | 6 | 14 | 0 | 4 | 0 | 1 | 5 | 3 | 2 | 1 | 3 | 1 | 0 | 0 | 2 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2007 | 52 | 36 | 17 | 16 | 2 | 19 | 10 | 5 | 0 | 6 | 9 | 5 | 0 | 1 | 4 | 0 | 1 | 0 | 2 | 8 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008 | 63 | 34 | 9 | 7 | 18 | 29 | 5 | 0 | 2 | 4 | 13 | 0 | 1 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009 | 69 | 52 | 4 | 7 | 41 | 44 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009 | total |  |  |  |  | total |  |  | 4 | 7 | 10 | 4 | 3 | 10 | 5 | 6 | 14 | 6 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009 | valid only |  |  |  |  | valid only |  |  | 2 | 5 | 7 | 3 | 3 | 7 | 5 | 6 | 9 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c | s | t | u | w
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | open
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Open | Need Form | Initial QC | Need RA Sample | Final QC | Needs [NAME] | Needs Admin Approval
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 1 | 0 | 0 | 1
Spreadsheet: 0e26dee2-3d59-4bf4-8733-b59e20dedf48
Sheet: spontaneous reactions

ID | Reaction ID | Name | Preferred Name | Definition | Eqaution | Balanced | Reversiblity | direction | compartment | [NAME] | bits | E-val
R0072 | R03314 | NO NAME | NO NAME | L-Glutamate 5-semialdehyde <=> (S)-1-Pyrroline-5-carboxylate + H2O | C01165 <=> C03912 + C00001 | True | r |  | c | Arginine and proline metabolism
R0108 | R04861 | NO NAME | NO NAME | 3-Sulfinylpyruvate + H2O <=> Sulfite + Pyruvate | C05527 + C00001 <=> C00094 + C00022 | True | irev | yes | c | Cysteine and methionine metabolism
R0405 | [NAME] | NO NAME | NO NAME | Tetrahydrofolate + Formaldehyde <=> 5,10-Methylenetetrahydrofolate | C00101 + C00067 <=> C00143 | False | irev | yes | c | Methane metabolism
R0898 | R05001 | NO NAME | NO NAME | 2-Hydroxyphenylacetate <=> 2,6-Dihydroxyphenylacetate | C05852 <=> C06207 | False | r |  | c | Phenylalanine metabolism
R0778 | R02434 | NO NAME | NO NAME | L-Cysteate + NADH + H+ <=> 3-Sulfino-L-alanine + H2O + NAD+ | C00506 + C00004 + C00080 <=> C00606 + C00001 + C00003 | True | irev | no | c | Taurine and hypotaurine metabolism
R0801 | R01913 | NO NAME | NO NAME | Pyridoxine <=> 1-Deoxy-D-xylulose + 4-Hydroxy-L-threonine | C00314 <=> C06257 + C06056 | False | irev | no | c | [NAME] metabolism
R0920 | [NAME] | NO NAME | NO NAME | Indole-3-acetate + Oxygen <=> 3-Methyldioxyindole + CO2 | C00954 + C00007 <=> C05834 + C00011 | True | irev | yes | c | Tryptophan metabolism
R0827 | R04293 | NO NAME | NO NAME | Quinolinate + H2O <=> 2-Amino-3-carboxymuconate semialdehyde | C03722 + C00001 <=> C04409 | True | irev | no | c | Tryptophan metabolism
R0866 | R01652 | NO NAME | NO NAME | 4-Methyl-2-oxopentanoate + CO2 <=> (2S)-2-Isopropyl-3-oxosuccinate | C00233 + C00011 <=> C04236 | True | irev | no | c | [NAME], leucine and isoleucine biosynthesis
R0931 | R03383 | NO NAME | NO NAME | (R)-Methylmalonyl-CoA + H2O <=> Methylmalonate + CoA | C01213 + C00001 <=> C02170 + C00010 | True | irev | no | c | [NAME], leucine and isoleucine degradation
R0932 | R08375 | NO NAME | NO NAME | [NAME] diphosphate <=> Dolichyl diphosphate | C05859 <=> C00621 | False | irev | yes | c | Terpenoid backbone biosynthesis
R0941 | [NAME] | NO NAME | NO NAME | 3-Hexaprenyl-4-hydroxybenzoate + Oxygen <=> 3-Hexaprenyl-4,5-dihydroxybenzoate | C13425 + C00007 <=> C05200 | False | irev | yes | c | Ubiquinone and other terpenoid-quinone biosynthesis
R0943 | R06866 | NO NAME | NO NAME | 3-Hexaprenyl-4-hydroxy-5-methoxybenzoate <=> 2-Hexaprenyl-6-methoxyphenol + CO2 | C05313 <=> C05802 + C00011 | True | irev | yes | m | Ubiquinone and other terpenoid-quinone biosynthesis
Spreadsheet: 102478d1300399364-excel-2007-formula-to-return-most-recent-item-not-exceeding-present-date-example
Sheet: Example

Item  # | Date Received | Amount
2a | 2011-01-01 00:00:00 | 2
2a | 2011-01-11 00:00:00 | 4
5b | 2011-01-13 00:00:00 | 7
3c | 2011-02-02 00:00:00 | 23
2a | 2011-02-05 00:00:00 | 67
5b | 2011-03-12 00:00:00 | 34
3c | 2011-03-13 00:00:00 | 9
 |  |  | Answers should be
Item  # | Date Received
3c
3c
3c |  |  | n/a
5b
5b
5b |  |  | n/a
Spreadsheet: 455641d1460448798-summary-ageing-formula-ageing-example-1-
Sheet: Output

FLAT | DUE AMT | >120 | 91-120 | 61-90 | 30-60 | 0-30 | FUTURE DUES
Spreadsheet: 197109d1354211967-if-and-concatenate-on-data-range-copy-of-job-title-list
Sheet: Sheet1

NAME | JOB TITLE
[NAME] | Doctor
[NAME] | Doctor
[NAME] | Nurse
[NAME] | Surgeon
[NAME] | Surgeon
 |  |  | [NAME] | Names
 |  |  | Doctor | [NAME], [NAME]
 |  |  | Nurse | [NAME]
 |  |  | Surgeon | [NAME], [NAME]
Spreadsheet: 691619d1597782830-formula-help-please-value-needed-with-multiple-criteria-sum-or-sumif-book1-etaf
Sheet: Sheet1

 | Claim Date | Claim Number | [NAME] | Redemption Type | [NAME] | Wallet Value | Voucher Value | Total Value
 | 2020-02-12 00:00:00 | 1003 | Claim Fulfilled | Reward Credit | Payment Complete |  | 4500 | 5100
 | 2020-02-14 00:00:00 | 1005 | Claim Fulfilled | Reward Credit | Payment Complete |  |  | 5000
 |  |  | sum of [NAME], providing the criteria which is populated in D4 is "Claim Fulfilled" AND [NAME] is "Reward Credit".
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: MUa

[NAME]. A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 772341d1647225762-highlight-rows-2-3-then-6-7-then-10-11-etc-custom-table-format-tms2
Sheet: Sheet1

a | b | c
1 | 2 | 3
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
31 | 32 | 33
34 | 35 | 36
37 | 38 | 39
40 | 41 | 42
43 | 44 | 45
46 | 47 | 48
Spreadsheet: danny_mccarty__4657__NNG_Wkly1228
Sheet: Current Month - CE

 | NORTHERN NATURAL GAS COMPANY - COMMERCIAL GROUP
 | CURRENT MONTH FORECAST VS 2001 3RD CURRENT ESTIMATE
 | As of December 28, 2001
 | ($000's Omitted)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue
 |  |  |  |  | Forecast |  |  | 3rd CE |  |  |  |  |  | Revenue |  | [NAME]
 | DEMAND: |  | Units | Rate | Revenue |  |  | Units | Rate | Revenue |  | Units | Rate | [NAME] |  | Price |  | Volume
 | North
 | Central
 | Power |  |  |  | 0 |  |  |  |  | 0
 | Total Midwest
 | Pricing & Structuring
 | Offshore
 | Storage |  |  |  | 1157 |  |  |  |  | 1154
 | Subtotal - Demand Revenues
 | COMMODITY:
 | North
 | Central
 | Power |  |  | 0 |  |  |  | 0 | 0 | 0
 | Total Midwest
 | Pricing & Structuring
 | Offshore
 | Storage |  |  |  | 968
 | Subtotal - Commodity Revenues
 | Other Revenues:
 | DDVC/Penalties |  |  |  | 0
 | Margin Stretch |  |  |  | 0 |  |  |  |  | 0
 | Other - Executive |  |  |  | 0 |  |  |  |  | 0
 | Reserves |  |  |  |  |  |  |  |  | 0
 | PPA's |  |  |  | 0 |  |  |  |  | 0
 | Subtotal - Other Revenues
 | Less: SLA Rate Filing Subject to Refund |  |  |  | -762 |  |  |  |  | 0
 | Total - Revenues
 | Less: [NAME] |  |  |  | -125 |  |  |  |  | -84
 | Total - Margins
 | Recurring IBIT Stretch |  |  |  | 0 |  |  |  |  | 86
 | Structured Products - Non-Recurring |  |  |  | 331
 | Other |  |  |  | 0 |  |  |  |  | 0
 | Grand Total Margin
Spreadsheet: 144809d1331147276-transfering-a-list-of-data-based-on-a-list-selection-smiproducttest
Sheet: Sheet1

 |  |  | PRODUCT |  |  | PERFORMANCE
 |  |  |  |  |  | 0
 | PRODUCT |  | [NAME] | FUJITSU12K | FUJITSU18K | [NAME] | LG12K | LG18K
 | [NAME] |  | 9000 | 12000 | 18000 | 8000 | 11000 | 17000
 | FUJITSU12K |  | 8000 | 11000 | 17000 | 7000 | 10000 | 16000
 | FUJITSU18K |  | 7000 | 10000 | 16000 | 6000 | 9000 | 15000
 | [NAME] |  | 6000 | 9000 | 15000 | 5000 | 8000 | 14000
 | LG12K
 | LG18K