tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79095d1279309030-sum-if-formula-example_1
Sheet: Panel Monthly TTV Macro

TTV by Month
January 2009 - Present
Tickers | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00
AIQ
CXS
DEXO
DPS
MEG
MHP
NLY
PNC
[NAME]
SRZ
TWC
WLP
AUO
BVF
CNI
CTC
ENB
FRO
GMK
JHX
LUX
MDZ
MGA
MIM
PSO
PTI
RUK
SFL
SI
STM
Average
AIQ
CXS
DEXO
DPS
MEG
MHP
NLY
PNC
[NAME]
SRZ
TWC
WLP
AUO
BVF
CNI
CTC
ENB
FRO
GMK
JHX
LUX
MDZ
MGA
MIM
PSO
PTI
RUK
SFL
SI
STM
Average
Spreadsheet: 49019d1248290786-selecting-fromula-select-formula-example
Sheet: Main

geometry | formula | param1 | param2 | param3 | param4
circle | these cells show | 40
circle | the value calculated | 50
rectangle | with the appropriate | 30 | 20
rectangle | formula using the | 10 | 60
triangle | params on the right | …
 |  |  |  |  |  | what I want is to maintain all formulas on the formula sheet, and select several types and sizes of geometries on this main page (to do other stuff)
Spreadsheet: 815743d1675178066-partial-matche-example-booklet-ans-1a
Sheet: Sheet1

Table Array | Lookup Value | Multiple Returns |  |  | [NAME] result |  |  |  | Final Result Required:
123-789-789 | 123-123 | 123-123-123, 123-123-456, 123-123-789 |  |  |  |  |  |  | 123-123 | 123-123-123
123-123-456 | 123-456 | 123-456-123 |  |  | 123-123 | 123-123-456 |  |  | 123-123 | 123-123-456
123-456-123 | 123-789 | 123-789-123, 123-789-456 |  |  | 123-123 | 123-123-789 |  |  | 123-123 | 123-123-789
000-123-123 | 000-123 | 000-123-123, 000-123-456, 000-123-789, 000-123-000 |  |  | 123-456 | 123-456-123 |  |  | 123-456 | 123-456-123
123-789-123 |  |  |  |  | 123-789 | 123-789-123 |  |  | 123-789 | 123-789-123
123-789-456 |  |  |  |  | 123-789 | 123-789-456 |  |  | 123-789 | 123-789-456
000-123-456 |  |  |  |  | 000-123 | 000-123-123 |  |  | 000-123 | 000-123-123
123-123-123 |  |  |  |  | 000-123 | 000-123-456 |  |  | 000-123 | 000-123-456
000-123-789 |  |  |  |  | 000-123 | 000-123-789 |  |  | 000-123 | 000-123-789
000-123-000 |  |  |  |  | 000-123 | 000-123-000 |  |  | 000-123 | 000-123-000
Spreadsheet: 124d13fa-99d2-4aeb-a94f-fbd338e6d109
Sheet: Sheet1

Table 8--Oilseed prices received by U.S. farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybeans2 | Cottonseed3 | Sunflowerseed2 | Canola4 | Peanuts3 | Flaxseed4
year
 | $/bushel | $[NAME] | $/cwt. | $/cwt. | Cents/pound | $/bushel
2000/01 | 4.54 | 105 | 6.89 | 6.71 | 27.4 | 3.3
2001/02 | 4.38 | 90.5 | 9.62 | 8.77 | 23.4 | 4.29
2002/03 | 5.53 | 101 | 12.1 | 10.6 | 18.2 | 5.77
2003/04 | 7.34 | 117 | 12.1 | 10.6 | 19.3 | 5.88
2004/05 | 5.74 | 107 | 13.7 | 10.7 | 18.9 | 8.07
2005/06 | 5.66 | 96 | 12.1 | 9.62 | 17.3 | 5.94
2006/07 | 6.43 | 111 | 14.5 | 11.9 | 17.7 | 5.8
2007/08 | 10.1 | 162 | 21.7 | 18.3 | 20.5 | 13
2008/09 | 9.97 | 223 | 21.8 | 18.7 | 23 | 12.7
2009/10 | 9.59 | 158 | 15.1 | 16.2 | 21.7 | 8.15
2010/11 | 11.3 | 161 | 23.3 | 19.3 | 22.5 | 12.2
2011/121 | 11.40-12.60 | 245-275 | 28.15-30.15 | 22.50-24.50 | 29.00-31.00 | 13.30-14.50
2010/11
September | 9.98 | 154 | 18.1 | 17.4 | 19.9 | 10.8
October | 10.2 | 158 | 19.9 | 18.2 | 21.4 | 11.8
November | 11.1 | 162 | 18.7 | 19.1 | 22.3 | 12.6
December | 11.6 | 163 | 20.6 | 19.5 | 24 | 13.1
January | 11.6 | 165 | 21.9 | 20.3 | 23 | 13.8
February | 12.7 | 172 | 27.4 | 20.4 | 23.5 | 15.3
March | 12.7 |  | 28.3 | 23.4 | 23.4 | 13.7
April | 13.1 |  | 28.8 | 24.8 | 23.1 | 13.5
May | 13.2 |  | 30 | 23.5 | 22.8 | 14.2
June | 13.2 |  | 29 | 25.1 | 23.3 | 15.4
July | 13.2 |  | 30.4 | 24.3 | 23.9 | 15.4
August | 13.4 | 213 | 32.2 | 23.1 | 23.2 | 14.3
2011/12
September | 12.2 | 245 | 32.9 | 23.2 | 23.2 | 13.5
October | 11.7 | 245 | 29.6 | 22.7 | 28.3 | 13.9
November | 11.7 | 269 | 29 | 23.3 | 33.1 | 14
December | 11.5 | 264 | 29.6 | 23 | 30.8 | 13.6
January | 11.9 | 281 | 28.7 | 23.3 | 33.6 | 13.6
February1 | 12.3 | 275 | 27.8 | 24.5 | 32.1 | 13.2
1 Preliminary.  2 September-August.  3August-July. 4 July-June.
NA = Not available.
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Last update: | 2012-03-13 08:08:34.220000
Spreadsheet: 683728d1592916869-formula-that-returns-a-value-under-specific-conditions-region-issuev4
Sheet: Sheet1 (2)

Entered Account # | Entered Date | Region (as returned from formula) |  |  |  | [NAME] that Returns a Value under Specific Conditions
ABC | 2018-02-01 00:00:00 | Boston | Returned Regsion from matched row in array because Span Duration - 365 or 366 |  |  | My problem is as below: I have some data that was dumped from a database and I need to return the "Region" from that data (for the "Entered Account #" and "Entered Date") under the following conditions: 1.  IF "Span Duration is = 365 or 366 and  2.  "Entered Date" is >= the "From Date" and  3.  "Entered Date" is <= the "To Date"THEN return "Region" from the "matched" row. BUT only perform steps 1-3 when the "Entered Account #" is = the "Account #" from the Database Data.  Need to check all the date spans within that "Account #". That's Part 1. Part 2 is:  IF < 365, THEN use the "Region" from the next row in the database data but ONLY if that next row is for the same "Account #" ELSE return "no match found" I tried using all kinds of combinations of INDIRECT, ADDRESS, CELL, COLUMN, ROW, iNDEX and am not having any luck.   I can't use a macro for this and was wondering if it is able to be done with a formula. I'm probably/definitely biting off more than I can chew :) but any help you can provide will be hugely appreciated.  Thanks!
ABC | 2020-03-01 00:00:00 | Sacramento | Returned Regsion from matched row in array because Span Duration - 365 or 366
ABC | 2020-02-01 00:00:00 | Sacramento | Returned Regsion from matched row in array because Span Duration - 365 or 366
DEF | 2018-06-15 00:00:00 | Sarasota | [NAME] from next tow after matched row in array because Span Duration <365
ABC | 2019-02-01 00:00:00 | New York | Returned Regsion from matched row in array because Span Duration - 365 or 366
DEF | 2019-02-01 00:00:00 | Sarasota | Returned Regsion from matched row in array because Span Duration - 365 or 366
DEF | 2017-01-01 00:00:00 | no match found | Entered Date nor present in any Date Span for DEF
DEF | 2020-02-01 00:00:00 | Denver | Returned Regsion from matched row in array because Span Duration - 365 or 366
Database Data
Account # | Span Duration (Days) | From Date | To Date | Region
ABC |  | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | Boston
ABC |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | New York
ABC |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Sacramento
DEF |  | 2018-01-01 00:00:00 | 2018-06-30 00:00:00 | Wichita
DEF |  | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | Sarasota
DEF |  | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | Denver
Spreadsheet: 64687b70-1472-4d93-bbe1-c89b60f1562a
Sheet: SBC Rural

REGIONAL DIRECTORY 2014/2015
SAN BENITO COUNTY RURAL SCHOOLS
[NAME], Superintendent | [NAME], Cienega Union K-8 Year Round Principal | [NAME], [NAME]. [NAME] Principal
460 Fifth Street | 11936 Cienega Road | 211 Old Hernandez Road
Hollister, CA 95023 | Hollister, CA 95023 | Paicines, CA 95043
O: [PHONE] x127 | O:[PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
TBD, Panoche Elementary SD K-8 RY Round, Principal/Teacher | [NAME], Tres Pinos Elem SD Principal | [NAME], Willow Grove USD Teacher/Principal
31441 Panche Road, | 5635 Airline Hwy PO Box 188 | 11655 Airline Hwy, PO Box 46
Paicines, CA 95043 | [NAME], CA 95075 | Paicines, CA 95043
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
 | [EMAIL] | [EMAIL]
Spreadsheet: 178106d1346661452-division-formula-copy-of-div
Sheet: Sheet1

Target | Achieved | % Achieved |  |  |  |  |  | Achieved > Target |  | Achieved | Required | Makes
-0.1696494236655516 | -9.489910621875 | -55.93836051328706 |  |  |  |  |  | 0 |  | 55.93836051328706 | -54.93836051328706 | 1
-1 | 1 | -1 | Calculation should equate positive 200% |  |  |  |  | 1 |  | -1 | 2 | 1
12.73003443010886 | 11.1473208645 | 0.875670912415959 |  |  |  |  |  | 0 |  | 0.875670912415959 | 0.124329087584041 | 1
3.009428117205542 | -0.41804655625 | -0.1389122916277477 |  |  |  |  |  | 0 |  | -0.1389122916277477 | 1.138912291627748 | 1
0.169649423665552 | -9.489910621875 | -55.93836051328693 |  |  |  |  |  | 0 |  | -55.93836051328693 | 56.93836051328693 | 1
-1 | -0.5 | 0.5 | Calculation should equate positive 150% |  |  |  |  | 1 |  | 0.5 | 0.5 | 1
-1 | 0 | 0 | Calculation should equate positive 200% |  |  |  |  | 1 |  | 0 | 1 | 1
-1 | 1 | -1 | Calculation should equate positive 300% |  |  | ??? |  | 1 |  | -1 | 2 | 1
-0.22 | 0.125 | -0.5681818181818182 |  |  |  |  |  | 1 |  | -0.5681818181818182 | 1.568181818181818 | 0.9999999999999999
0.125 | -0.22 | -1.76 |  |  |  |  |  | 0 |  | -1.76 | 2.76 | 0.9999999999999998
1 | 1 | 1 |  |  |  |  |  | 1 |  | 1 | 0 | 1
Spreadsheet: phillip_allen__28900__noi
Sheet: Pro Forma

 |  |  |  | Stagecoach Apartments
 |  |  |  | 2001 Pro Forma Operating Statement
Gross Possible Rents |  |  |  |  | 258640
Less vacancies (10%)
Laundry Income |  |  |  |  | 3600
 | Total Income
Utilities($4,500/month)
Materials($1,800/month)
Manager ($260/week)
Maintenance ($280/week)
Services($100/month) |  |  |  |  | 1200
Property tax |  |  |  |  | 12000
Insurance |  |  |  |  | 4000
 | Total Expenses
 | Net Operating Income
Spreadsheet: 07c512ac-b498-4758-a299-f744fb262a3d
Sheet: _wht1174

 |  | Dixon County Organic Winter Wheat Variety Test - 2011
 |  | Brand | Variety | Grain Yield (bu/a) | Moisture (%) | [NAME] (lb/bu) | Plant Height (inches) | Heading   Date (June) | Grain Protein (%) | [NAME] (1000/lb)
 |  | Husker Genetics | Overland | 53.3 | 12.1 | 59.5 | 31 | 11.3 | 11.9 | 12.68
 |  | ---- | Wahoo | 52.1 | 12.2 | 57.6 | 33 | 10.2 | 12.1 | 12.7
 |  | ---- | Hallam | 51.5 | 12 | 55.9 | 33 | 12 | 11.8 | 12.34
 |  | ---- | NE05430 | 51.4 | 12 | 58.7 | 34 | 11.5 | 12 | 10.61
 |  | ---- | Goodstreak | 51.3 | 12.4 | 60.2 | 38 | 13.8 | 12.9 | 12.94
 |  | ---- | NW03666 (W) | 49.8 | 11.8 | 57 | 30 | 14.8 | 12.2 | 12.51
 |  | ---- | Darrell | 49.4 | 12.2 | 59 | 32 | 9.5 | 12.2 | 12.81
 |  | ----- | [NAME] | 49.1 | 12.6 | 60.3 | 33 | 12.5 | 13.6 | 10.96
 |  | ----- | SD07165 | 49 | 12.2 | 58.1 | 30 | 10 | 11.8 | 14.11
 |  | ----- | NE06545 | 48.3 | 12.3 | 57.6 | 29 | 9.200000000000003 | 11.8 | 13.06
 |  | NuPride | Camelot | 48.1 | 12 | 59.6 | 31 | 14 | 12.3 | 11.58
 |  | ---- | NE05496 | 47.8 | 11.8 | 58.2 | 30 | 11.5 | 12.2 | 13.28
 |  | ----- | Expedition | 47.5 | 12.3 | 58.9 | 31 | 12 | 11.8 | 12.81
 |  | ---- | NE99495 | 47.1 | 12.3 | 58 | 30 | 12.2 | 12.4 | 13.15
 |  | ---- | Pronghorn | 47 | 12.3 | 59.5 | 34 | 9.700000000000003 | 12.5 | 13.23
 |  | ---- | NE05548 | 46.9 | 12.1 | 58.2 | 34 | 8.5 | 12.7 | 13.56
 |  | ---- | Millennium | 46.4 | 12.5 | 59 | 33 | 11.8 | 12.3 | 13.23
 |  | ---- | NE03490 | 45.6 | 12.1 | 57.7 | 28 | 12.8 | 11.6 | 13.31
 |  | ----- | NW07505 (W) | 45.1 | 12 | 57.6 | 31 | 13.5 | 11.9 | 13.41
 |  | ----- | NE07444 | 44.9 | 12.3 | 58.7 | 31 | 10.2 | 12.3 | 13.74
 |  | ---- | NW03681 (W) | 44.8 | 12 | 59.3 | 30 | 13 | 13 | 12.95
 |  | ---- | McGill | 44.8 | 12.1 | 58.5 | 32 | 8.700000000000003 | 11.8 | 14.64
 |  | ----- | NE08457 | 44.4 | 12.1 | 58.8 | 28 | 10.2 | 12.3 | 15.46
 |  | ---- | Buckskin | 44.3 | 12 | 59.3 | 38 | 11.5 | 12.3 | 12.6
 |  | ---- | NE02558 | 43.7 | 12.4 | 57.8 | 30 | 9 | 12.2 | 13.29
 |  | ---- | NE05425 | 43.7 | 11.6 | 58.2 | 29 | 9.5 | 12.5 | 12.7
 |  | ----- | NI08708 | 42.8 | 12 | 56.3 | 28 | 11.3 | 12.1 | 13.02
 |  | ---- | NE04424 | 41.7 | 12.1 | 58.5 | 29 | 12 | 12.1 | 12.68
 |  | ---- | Alliance | 41.3 | 12.4 | 58.7 | 31 | 13.2 | 11.4 | 13.86
 |  | ---- | Alice (W) | 40.7 | 12.2 | 58.2 | 27 | 10.8 | 12.3 | 13.61
 |  | ---- | [NAME] | 40.5 | 11.6 | 57.3 | 28 | 12.7 | 12.3 | 12.49
 |  | ---- | Danby (W) | 40.3 | 12.1 | 58.5 | 30 | 14.3 | 12 | 14.8
 |  | ----- | NX05M4180-6 | 38.1 | 11.3 | 55.2 | 29 | 8.200000000000003 | 11.8 | 13.54
 |  | ---- | Hatcher | 36.8 | 12.2 | 57.6 | 28 | 12.5 | 12.6 | 13.95
 |  | ---- | [NAME] 92 | 35.8 | 11.9 | 58.4 | 26 | 10.8 | 13 | 13.13
 |  | ---- | Clarkscream (W) | 31.1 | 12 | 58.9 | 39 | 9.5 | 14 | 13.13
 |  | Average of all entries |  | 45.2 | 12.1 | 58.3 | 31 | 11.33888888888889 | 12.3 | 13.11
 |  | Difference required for significance at 5% |  | 7.2 | 0.4 | 0.8 | 2 | 2.7 | 0.5 | 1.3
Spreadsheet: 464332d1464982263-round-formula-result-to-nearest-10-copy-of-copy-of-sulphur-compound-002-002-
Sheet: Sheet1

 |  |  | 0.5 | 1 | 2 | 24
 |  | Time | 1/2 Hour | 1 Hour | 2 hours | 24 hours
 |  | Time Cast
 |  | [NAME] (lbs)
 |  | Cube 1 | 23450 | 25360 | 28260 | 34120
 |  | Cube 2 | 23500 | 26150 | 27840 | 33550
 |  | Cube 3 | 23370 | 25940 | 28650 | 33500
 |  | Width cube 1 | 2 | 2 | 1.99 | 1.99
 |  | Length cube 1 | 1.98 | 1.99 | 2 | 2
 |  | Width cube 2 | 2 | 2 | 2 | 1.99
 |  | Length cube 2 | 2 | 1.99 | 2 | 2
 |  | Width cube 3 | 2 | 1.99 | 1.99 | 2
 |  | Length cube 3 | 2 | 2 | 2 | 1.99
 |  | [NAME] (psi)
 |  | Cube 1 | 5921.717171717171 | 6371.859296482412 | 7100.502512562814 | 8572.86432160804
 |  | Cube 2 | 5875 | 6570.35175879397 | 6960 | 8429.64824120603
 |  | Cube 3 | 5842.5 | 6517.587939698493 | 7198.492462311558 | 8417.085427135678
 |  | Average Compressive Strength (psi) | 5879.739057239058 | 6486.599664991624 | 7086.331658291457 | 8473.199329983248
 |  |  | 5000 psi minimum at 2 hours specified
Spreadsheet: 817702d1676398462-look-up-between-2-columns-to-return-result-from-a-3rd-lookup
Sheet: Sheet1

Date Received | Project Number | Remit Number | Job Title
 | 159333 | AR4102 | TEST
 | 159333 | AR4103 | TEST
 | 159333 | AR4104 | TEST
 | 159333 | [NAME] | TEST
 | 159333 | GER1383 | TEST
 | 159333 | GER1384 | TEST
 | 159336 | GER1385 | TEST
 | 159336 | GER1386 | TEST
 | 159336 | WAR2139 | TEST
 | 159336 | WAR2140 | TEST
 | 159336 | WAR2141 | TEST
Spreadsheet: 841419d1693588480-count-blank-cells-in-a-named-range-on-a-worksheet-counting-blank-cells
Sheet: Sheet1

0 | 1 | 2 |  |  |  |  |  | <<==
 |  |  | <<== |  | [3 times] |  |  | <<==
 |  |  | <<== |  | [3 times] |  |  | <<==
 |  |  | <<== |  | [no formula]
Spreadsheet: 54bd73f5-6ac5-4cb5-8739-c734da180ac7
Sheet: Spring 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Administrative Licensure
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 116848d1312227147-formula-for-cell-contents-using-index-and-match-help1
Sheet: Sheet1

Member | Allowable | Actual | Ratio | Case
C3020 | 30 | 25 | 0.2 | 1601 |  | C3021
E2-1 | 31 | 26 | 0.3 |  |  | 1602
F1-1 | 32 | 27 | 0.4 |  |  | F1-1
F2-1 | 33 | 28 | 0.5
C3020 | 34 | 29 | 0.21 | 1602
E2-1 | 35 | 30 | 0.22
F1-1 | 36 | 31 | 0.23
F2-1 | 37 | 32 | 0.24
C3020 | 38 | 33 | 0.211 | 1603
E2-1 | 39 | 34 | 0.221
F1-1 | 40 | 35 | 0.231
F2-1 | 41 | 36 | 0.241
C3021 | 42 | 37 | 0.1 | 1602
E2-1 | 43 | 38 | 0.11
F1-1 | 44 | 39 | 0.12
F2-1 | 45 | 40 | 0.13
Spreadsheet: 219368d1362738896-combining-multiple-worksheets-fame
Sheet: 3

3.01 | 3.003 | 3.027 | TIC | 2200 | 0.02 | 1344 | 0.04 | 1.64 |  | RAVI
3.06 | 3.027 | 3.09 | TIC | 21333 | 0.22 | 10042 | 0.3 | 2.12 | V | RAJU
3.354 | 3.343 | 3.377 | TIC | 2908 | 0.03 | 3659 | 0.11 | 0.79 |  | RAMU
3.607 | 3.587 | 3.67 | TIC | 8897 | 0.09 | 3049 | 0.09 | 2.92 |  | KRISHNA
Spreadsheet: 133742d1324573543-sorting-filtering-by-specific-information-data_base
Sheet: Data

 | Client ID | College 1 | College 2 | College 3 | College 4 | College 5 |  | Select range B3 to G3
 | client01 | college1 |  | college3 |  | college5
 | client02 |  | college2 |  | college4 | college5 |  | Click Data -> Filter -> Autofilter
 | client03 | college1 |  | college3
 | [NAME] |  | college2 |  |  | college5 |  | To see which College a client have choosen, click on the drop-down arrow
 | client05 | college1 | college2 | college3 | college4 | college5 |  | next to "Client ID" and select a client.
 | client06 |  |  |  |  | college5
 | client07 | college1 | college2 | college3 | college4 | college5 |  | If you now whish to see what clients have choosen a particular college, you must
 | client08 | college1 |  |  |  |  |  | first reset you data. Click on "Client ID" and select "All"
 | client09 |  |  | college3 | college4 | college5
 | client10 | college1 |  |  |  | college5 |  | Then click on drop-down arrow to the college you wish to see.
 | client11 | college1 | college2 | college3 | college4 | college5
 | client12 |  |  |  |  | college5 |  | The problem with this is that you will other colleges as well.
 |  |  |  |  |  |  |  | This problem can be overcome by hiding the columns you are not
 |  |  |  |  |  |  |  | interested in. I.e. if you whish to see which clients has applied to college 3 you could hide
 |  |  |  |  |  |  |  | column C,D,F and G
 |  |  |  |  |  |  |  | If you upload a workbook with the layout of your database one could write a macro that
 |  |  |  |  |  |  |  | does all these things.
Spreadsheet: 487302d1478015022-formula-to-consolidate-tables-consolidatetables3
Sheet: Main Contacts

Main contacts
Cde | Name | Surname | email | [NAME]
A16 | [NAME] | Smith | [EMAIL] | [PHONE]
R6O | [NAME] | Jones | [EMAIL] | [PHONE]
69U | [NAME] | Wilson | [EMAIL] | [PHONE]
Spreadsheet: 872801d1719240932-table-based-on-single-value-create-table-based-on-single-value
Sheet: Sheet1

Value: | 20 | <<< Select a value between 2 and 20
 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 747872d1631741380-trimmean-with-if-statement-bo-backtesting_temp
Sheet: DATA

TICKER | WEEK | DATE | TIME | ENTRY | LOW | HIGH | EXIT | G/L | MAX GAIN | STRATEGY | SETUP | EXIT REASON | ENTRY ATTEMPT | SPACE | MARKET CAP | FLOAT | CHART
BPTH |  | 2021-02-10 00:00:00 | 09:30:00 | 17 |  | 19 | 16.7 |  |  | BO | PMH | Failed |  | Biotech | 46630000 | 6910000
BPTH |  | 2021-02-10 00:00:00 | 09:34:00 | 17 |  | 24.06 | 19.5 |  |  | BO | PMH | 5x20 | 1 | Biotech | 46630000 | 6910000
FSR |  | 2021-02-12 00:00:00 | 09:14:00 | 17.99 |  | 18.98 | 17.69 |  |  | BO | PMH | Failed |  | Automotive | 5620000000 | 157760000 | ..\Charts\fsr-20210212.png
AUVI |  | 2021-02-12 00:00:00 | 09:36:00 | 24.69 |  | 26.92 | 24.39 |  |  | BO | PMH | Failed | 1 | Consumer Furnishings | 89370000 | 4170000
IMGN |  | 2021-02-12 00:00:00 | 09:36:00 | 8.64 |  | 10.42 | 9.8 |  |  | BO | PM Consolidation | 5x20 | 1 | Biotech | 1280000000 | 198840000 | ..\Charts\imgn-20210212.png
FSR |  | 2021-02-12 00:00:00 | 09:44:00 | 18.18 |  | 19.89 | 18.93 |  |  | BO | Pivot | 5x20 | 2 | Automotive | 5620000000 | 157760000 | ..\Charts\fsr-20210212.png
BNGO |  | 2021-02-12 00:00:00 | 10:00:00 | 12 |  | 12.88 | 12.2 |  |  | BO | PMH | 5x20 | 1 | Healthcare Research | 1940000000 | 275800000 | ..\Charts\bngo-20210212.png
OCGN |  | 2021-02-12 00:00:00 | 11:15:00 | 9.83 |  | 13.51 | 11.28 |  |  | D&R | Consolidation | 5x20 | 1 | Biotech | 1560000000 | 192500000
BNGO |  | 2021-02-12 00:00:00 | 11:40:00 | 12.88 |  | 13.6 | 13.1 |  |  | BO | HOD | 5x20 | 1 | Healthcare Research | 1940000000 | 275800000 | ..\Charts\bngo-20210212.png
TRCH |  | 2021-02-16 00:00:00 | 09:06:00 | 4 |  | 4.78 | 4.43 |  |  | BO | PMH | 5x20 | 1 |  |  |  | ..\Charts\trch-20210216.png
APHA |  | 2021-02-16 00:00:00 | 09:08:00 | 19.05 |  | 19.45 | 18.9 |  |  | BO | PMH | Failed |  | Biotech | 330090000 | 42910000 | ..\Charts\apha-20210216.png
MVIS |  | 2021-02-16 00:00:00 | 09:36:00 | 20.65 |  | 21.5 | 22.25 |  |  | BO | PMH | 5x20 | 1 | Technology | 2580000000 | 156900000 | ..\Charts\mvis-20210216.png
SCKT |  | 2021-02-16 00:00:00 | 09:36:00 | 10.7 |  | 13.7 | 10.7 |  |  | BO | PMH | 5x20 | 2 | Computer Hardware | 49420000 | 5730000 | ..\Charts\sckt-20210216.png
APHA |  | 2021-02-16 00:00:00 | 11:08:00 | 19.55 |  | 21.65 | 21 |  |  | BO | HOD | 5x20 | 2 | Biotech | 330090000 | 42910000 | ..\Charts\apha-20210216.png
SCKT |  | 2021-02-16 00:00:00 | 11:12:00 | 13.8 |  | 26 | 25.3 |  |  | BO | PMH | Profit | 2 | Computer Hardware | 49420000 | 5730000 | ..\Charts\sckt-20210216.png
FLDM |  | 2021-02-17 00:00:00 | 09:56:00 | 5.46 |  | 6.35 | 6.15 |  |  | BO | Consolidation | 5x20 | 1 | Healthcare | 468220000 | 74010000
CAN |  | 2021-02-19 00:00:00 | 09:30:00 | 19.25 | 19.2 | 24.9 | 23.6 |  |  | BO | PM Consolidation | 5x20 | 1 | Computer Hardware | 1380000000 | 128090000 | ..\Charts\can-20210219.png
VCNX |  | 2021-02-19 00:00:00 | 09:30:00 | 6.33 |  | 9.56 | 6.9 |  |  | BO | PMH | 5x20 | 1 | Biotech | 77480000 | 24330000 | ..\Charts\vcnx-20210219.png
CAN |  | 2021-03-01 00:00:00 | 09:40:00 | 17.74 |  | 21.83 | 21.83 |  |  | BO | PM Consolidation | 5x20 |  | Computer Hardware | 1380000000 | 128090000
Spreadsheet: 274892d1383251384-income-for-overlapping-months-to-be-split-daily-ef517_sales-by-month-2
Sheet: Simplify from Pete Formula

Data From Report |  |  |  | Monthly sales income
Opening Date | Closed Date | Period | Revenue Rentals
2013-09-01 00:00:00 | 2013-09-05 00:00:00 | 5 | 83.01689999999999
2013-10-15 00:00:00 | 2013-10-27 00:00:00 | 13 | 305.09496
2013-10-15 00:00:00 | 2013-10-22 00:00:00 | 8 | 85.38135
2013-09-01 00:00:00 | 2013-11-10 00:00:00 |  | 619.70325
2013-10-28 00:00:00 | 2013-11-10 00:00:00 | 14 | 350
Spreadsheet: 727269d1617810884-reference-data-from-another-tab-and-return-values-mom-stats_v2_eh
Sheet: Auto vetting stats

Period | All work | Total cost | Cost PP
2019
November
December
2020
January
February
March
2020-04-01 00:00:00 | 64531 | 4475 | 6.9
2020-05-01 00:00:00 | 93503 | £6,384.72 | 6.8
2020-06-01 00:00:00 | 63753 | 5329.080086888001 | 8.4
2020-07-01 00:00:00 | 89709 | 5558.54 | 6.2
2020-08-01 00:00:00 | 118560 | 6885.579207920002 | 5.8
2020-09-01 00:00:00 | 142281 | 8676.68 | 6.1
2020-10-01 00:00:00 | 104517 | 6788.83 | 6.5
2020-11-01 00:00:00 | 84051 | 5490.32 | 6.5
2020-12-01 00:00:00 | 87980 | 5906.28 | 6.7
2021-01-01 00:00:00 | 114830 | 6494.67 | 5.7
2021-02-01 00:00:00 | 93834 | 5301.48 | 5.6
2021-03-01 00:00:00 | 110566 | 5571.70708584 | 5
Spreadsheet: 757034d1637948510-conditional-formatting-based-on-cell-color-sample-etaf
Sheet: Summary

 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Avg |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Avg
Week 1 | 1 | 2 | 3 | 3 | 2 | 1 | 4 |  |  |  |  |  | Week 1 | 1 | 2 | 3 | 3 | 2 | 1 | 4
Week 2 |  |  |  |  |  |  |  |  |  |  |  |  | Week 2
Week 3 |  |  |  |  |  |  |  |  |  |  |  |  | Week 3
Week 4 |  |  |  |  |  |  |  |  |  |  |  |  | Week 4
Week 5 |  |  |  |  |  |  |  |  |  |  |  |  | Week 5
Week 6 |  |  |  |  |  |  |  |  |  |  |  |  | Week 6
Week 7 |  |  |  |  |  |  |  |  |  |  |  |  | Week 7
Week 8 |  |  |  |  |  |  |  |  |  |  |  |  | Week 8
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Notice

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Eligibility Determination
Activity Name | Notice
Activity Description / Purpose | Send notification of benefits to appropriate parties.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Interface with WMS upon budget approval