tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63033d1264001379-auto-sort-pool-league-player-data
Sheet: Calculations

Total de Jour sjoués avant [NAME] | Total de Jours Jour joués après Noël |  |  |  | [NAME] avant Noël | [NAME] après Noël | Jour joués avant [NAME] | Jour joués après Noël | total of days: points | total of days: days played |  |  |  | 2009-09-14 00:00:00 | 2009-09-21 00:00:00 | 2009-09-28 00:00:00 | 2009-10-05 00:00:00 | 2009-10-12 00:00:00 | 2009-10-19 00:00:00 | 2009-10-26 00:00:00 | 2009-11-02 00:00:00 | 2009-11-09 00:00:00 | 2009-11-16 00:00:00 | 2009-11-23 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00 | 2010-04-05 00:00:00 | 2010-04-12 00:00:00 | 2010-04-19 00:00:00 | 2010-04-26 00:00:00 |  | added | Average |  |  |  | 2009-09-14 00:00:00 | 2009-09-21 00:00:00 | 2009-09-28 00:00:00 | 2009-10-05 00:00:00 | 2009-10-12 00:00:00 | 2009-10-19 00:00:00 | 2009-10-26 00:00:00 | 2009-11-02 00:00:00 | 2009-11-09 00:00:00 | 2009-11-16 00:00:00 | 2009-11-23 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | Total de points | Total De jours | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00 | 2010-04-05 00:00:00 | 2010-04-12 00:00:00 | 2010-04-19 00:00:00 | 2010-04-26 00:00:00 | Total de points | Total De jours |  | jour joués par joueurs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arrêt de Noël
 |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] | [NAME] |  | Total de Jours |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
jours | jours |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
Password Protect is   "  Moose  " |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  | 25
Spreadsheet: 115992d1311450602-excel-2008-dsum-or-subtotal-with-dynamic-criteria-from-a-large-list-sample_truck_log
Sheet: TruckLoadingLog

 | Truck Loading Log |  |  |  |  | Date:
 | Customer: |  |  | Bay: |  | Van:
 | Commodity |  | Tag # | Gross |  | Tare | Net |  | Loaded
1) | Commodity 1 |  | 100 | 1500 |  | 45 |  |  | 1 | G
2) | Commodity 1 |  | 123 | 1345 |  | 42 |  |  | 1 | P
3) | Commodity 1 |  | 143 | 2000 |  | 45 |  |  | 1 | G
4) | Commodity 1 |  | 136 | 1234 |  | 80 |  |  | 2 | P
5)
6) | Commodity 14 |  | 157 | 2000 |  | 0 |  |  | 2 | B
7) | Commodity 14 |  | 547 | 1432 |  | 0 |  |  | 1 | B
8) | Commodity 14 |  | 857 | 1322 |  | 0 |  |  | 1 | B
9)
10) | Commodity 7 |  | 432 | 526 |  | 77 |  |  | 2 | P
11) | Commodity 7 |  | 654 | 639 |  | 74 |  |  | 1 | P
12) | Commodity 7 |  | 321 | 776 |  | 63 |  |  | 1 | G
13) | Commodity 7 |  | 109 | 653 |  | 68 |  |  | 1 | G
14) | Commodity 7 |  | 987 | 537 |  | 61
15) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
16) | Commodity 31 |  | 478 | 1432 |  | 0 |  |  | 1 | B
17) | Commodity 31 |  | 353 | 2240 |  | 0 |  |  | 1 | B |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
18) | Commodity 31 |  | 121 | 1356 |  | 0 |  |  | 1 | B
19) | Commodity 31 |  | 456 | 1453 |  | 0 |  |  | 2 | B |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
20) | Commodity 31 |  | 789 | 1643 |  | 0 |  |  | 2 | B
21) | Commodity 31 |  | 980 | 1568 |  | 0 |  |  | 1 | B |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
22)
23) | Commodity 26 |  | 128 | 1100 |  | 40 |  |  | 1 | G |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
24) | Commodity 26 |  | 727 | 1010 |  | 43 |  |  | 1 | G
25) | Commodity 26 |  | 356 | 1254 |  | 39 |  |  | 1 | G |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
26) | Commodity 26 |  | 764 | 1222 |  | 41 |  |  | 1 | P
27) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
28) | Commodity 12 |  | 1364 | 1553 |  | 82 |  |  | 1 | G
29) | Commodity 12 |  | 1242 | 1437 |  | 85 |  |  | 2 | P |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
30) | Commodity 12 |  | 6543 | 423 |  | 78 |  |  | 1 | P
31)
32)
33)
34) |  |  |  |  |  |  |  |  |  |  |  | Total Gross |  | Total Tare |  | Total Net
35)
36)
37)
38) |  |  |  |  |  |  |  |  |  |  |  | Total Units Loaded:
39)
40) |  |  |  |  |  |  |  |  |  |  |  | Bales: |  | Gaylords: |  | Pallets:
41)
Spreadsheet: 69973d1270638738-multiple-drop-down-list-lists-example
Sheet: Sheet1

Criteria 1 | [NAME] | LIST OUTCOME FROM CRITERIA 1 AND 2
2 | 10
 |  |  |  |  | All Possible Outcomes determined by criteria in A2 and B2 which would be displayed in C2
Possibilities for criteria 1 | Possibilities for criteria 2
 |  |  |  |  | 1 AND 10 | 1 AND 11 | 1 AND 12 | 1 AND 13 | 2 AND 10 | 2 AND 11 | 2 AND 12 | 2 AND 13 | 3 AND 10
1 | 10 |  |  |  | A | D | G | J | M | P | S | V | Y
2 | 11 |  |  |  | B | E | H | K | N | Q | T | W | Z
3 | 12 |  |  |  | C | F | I | L | O | R | U | X
4 | 13
 |  |  |  |  | 3 AND 11 | 3 AND 12 | 3 AND 13 | 4 AND 10 | 4 AND 11 | 4 AND 12 | 4 AND 13
 |  |  |  |  | AA | DD | GG | JJ | MM | PP | SS
 |  |  |  |  | BB | EE | HH | KK | NN | QQ | TT
 |  |  |  |  | CC | FF | II | LL | OO | RR | UU
Spreadsheet: 823855d1680176197-index-match-value-result-only-if-it-contains-certain-text-example
Sheet: Sheet2

item | code | bom
cola55 | 333567 | BOTTLE P30 BOSTON CLEAR   500ML
cola55 | 300037 | LABEL TACTILE
cola55 | 553388 | OUTER BOSTON BOTTLE PUMP
cola55 | 111000 | PALLET STANDARD RED 1200X1000  LPR
cola55 | 455705 | SCREWCAP PCR SK38/23 BLAC**PET IHS
juice82 | 125478 | (B) SCREWCAP DOME WHITE 5**ML
juice82 | 456678 | BOTTLE PCR 30% VEYRON CLEAR   300ML
juice82 | 300037 | LABEL TACTILE
juice82 | 348409 | OUTER CAPPED  BOTTLE
juice82 | 111000 | PALLET STANDARD RED 1200X1000  LPR
[NAME] | 664589 | DRUM POLY BLUE 205LT UN S   EACH
[NAME] | 300037 | LABEL TACTILE
[NAME] | 348409 | OUTER CAPPED  BOTTLE
[NAME] | 111000 | PALLET STANDARD RED 1200X1000  LPR
[NAME] | 455705 | SCREWCAP PCR SK38/23 BLAC**PET IHS
water03 | 669587 | DRUM GUN METAL GREY ONECA**   20LTR
water03 | 304447 | LABEL front
water03 | 553388 | OUTER BOSTON BOTTLE PUMP
water03 | 111000 | PALLET STANDARD RED 1200X1000  LPR
water03 | 875291 | TRIGGER TS5 RED 170MM DIP TUBE
Spreadsheet: 770693d1646227194-using-columns-searching-of-mins-and-maxs-number-and-using-them-in-a-formula-glenns-formula-allocate-points
Sheet: Sheet1

Given HCP |  |  |  | Use this col. |  |  |  |  |  |  |  |  | Example:
-4 | Hole HCP -> | 17 | 15 | 1 | 5 | 13 | 7 | 3 | 11 | 9 |  |  | Because the given hcp is -2 in a nine hole play (as this is) the hcp 1 would be used.
Par |  | 4 | 5 | 4 | 4 | 4 | 5 | 3 | 5 | 3 | score |  | This person would get -1 on there score making the point from 1 to 2 points.
Score |  | 4 | 4 | 6 | 3 | 2 | 5 | 1 | 5 | 1 |  |  | All without changing their score posted.
 |  |  |  |  |  |  |  |  |  |  | Total points
Points
 |  |  | 3 | -1 | 3 | 5 | 2 | 4 | 2 | 5
Given HCP |  | Use this col. | Use this col. |  |  |  |  |  |  |  |  |  | Example:
4 | Hole HCP -> | 17 | 15 | 1 | 5 | 13 | 7 | 3 | 11 | 9 |  |  | Because the given hcp is 4 in a nine hole play (as this is) the hcp 17 and hcp 15 would be used.
Par |  | 4 | 4 | 4 | 4 | 4 | 5 | 3 | 5 | 3 | score |  | This person would get +1 on each said hole their score making the point from 2 to 1 points and 1 to 0 respectfully.
Score |  | 3 | 5 | 2 | 4 | 3 | 4 | 1 | 6 | 3 |  |  | All without changing their score posted.
 |  |  |  |  |  |  |  |  |  |  | Total points
Points |  |  |  |  |  |  |  |  |  |  |  |  | I need to be able to change the "Given HCP" at will changing the holes used based on HCP.
Spreadsheet: mark_whitt__25155__zRemote Trading Office Asset Inventory == Template
Sheet: IT EQUIPMENT

IT Equipment
(workstations, laptops, pda, monitors, plasmas, servers, racks, routers, switches, WAN circuits, IPC, Avaya, and Nicelog)
QTY | [NAME] | MODEL # | MANUFACTURER | LEASED (enter company name) | [NAME] (enter company name)
1 | Compaq Armada M300 | M300 | Compaq
3 | [NAME] P600 | P600 | Compaq
2 | Compaq Deskpro | P450 | Compaq
4 | NEC MultiSync LCD 1830 | LCD 1830 | NEC
1 | 27 inch Monitor
1 | TV | 27" | Panasonic
Spreadsheet: 884459d1733646952-transpose-alphanumeric-lists-jambon95-match-lists-spill-365-aligw
Sheet: Themes

Company Name | Ticker | Theme | Subtheme |  |  |  | Digitalisation* | AI | Cloud | Cybersecurity | Software | Infrastructure | Energy transition | Utilities | EVs | Renewables | Miners | Infrastructure | Demographic change | Healthcare | Consumer discretionary | Multipolarity | Reshoring | Defence
Alibaba Group Holding Ltd | 9988 HK | Digitalisation | AI |  |  | TICKER_AND_EXCH_CODE
Alibaba Group Holding Ltd | 9988 HK | Digitalisation | Cloud |  |  | 1299 HK |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 0
Alibaba Group Holding Ltd | 9988 HK | Digitalisation | Infrastructure |  |  | 9988 HK | 3 | 1 | 1 | 0 | 0 | 2 | 2 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 1
Alibaba Group Holding Ltd | 9988 HK | Energy transition | EVs |  |  | 3319 HK | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Alibaba Group Holding Ltd | 9988 HK | Energy transition | Infrastructure |  |  | 2020 HK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
Alibaba Group Holding Ltd | 9988 HK | Multipolarity | Reshoring |  |  | BHARTI IN | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Alibaba Group Holding Ltd | 9988 HK | Multipolarity | Defence |  |  | 3998 HK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
AIA Group Ltd | 1299 HK | Demographic change | Healthcare |  |  | 293 HK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
AIA Group Ltd | 1299 HK | Demographic change | Consumer discretionary
A-Living Smart City Services Co Ltd | 3319 HK | Digitalisation | Infrastructure
ANTA Sports Products Ltd | 2020 HK | Demographic change | Consumer discretionary
Bharti Airtel Ltd | BHARTI IN | Digitalisation | Infrastructure
Bosideng International Holdings Ltd | 3998 HK | Demographic change | Consumer discretionary
Cathay Pacific Airways Ltd | 293 HK | Demographic change | Consumer discretionary
Spreadsheet: 863599d1711020345-split-and-organize-values-from-array-to-new-array-new-test
Sheet: Feuil1

 | /LABEL A|value01/[NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value06/LABEL G|value07/LABEL Y|value99
 | /LABEL Y|value99/LABEL A|value12/[NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value08
 | [NAME] C|value03/LABEL Z|value26/LABEL G|value07
START WITH SPILLING ARRAY IN B6
 | /LABEL Y|value99/LABEL A|value12/[NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value08
 | [NAME] C|value03/LABEL Z|value26/LABEL G|value07
EXPECTED RESULT (spilling array in B10, 2 rows)
common: | [NAME] C|value03/LABEL Y|value99
specific: | /LABEL A|value01/LABEL D|value04/LABEL E|value05/LABEL F|value06/LABEL G|value07***/LABEL A|value12/LABEL D|value04/LABEL E|value05/[NAME]
 |  |  |  |  | [NAME] | LABEL C|value03 | LABEL D|value04 | LABEL E|value05 | LABEL F|value06 | [NAME] | LABEL Y|value99
 |  |  |  | LABEL Y|value99 | LABEL A|value12 | [NAME] | LABEL C|value03 | LABEL D|value04 | LABEL E|value05 | LABEL F|value08
 |  |  |  | [NAME] | LABEL Y|value99 | LABEL C|value03 | [NAME] | [NAME]
Spreadsheet: 125316d1318964525-excel-2007-if-0-and-sumif-or-sumproduct-inventory-help
Sheet: Sheet2

Meat | Cooked | sum of Amount Ordered and Extra | Sum of Stock and Gone | Traffic | Expected Answer
Chicken | BBQ | 20 | 33 | 20 | 20
Chicken | Fried | 21 | 24 | 21 | 21 | 3= green
Lamb | BBQ | 13 | 12 | 13 | 13 | 2= Yellow
Lamb | Roasted | 0 | 16 | 0
Beef | Baked | 25 | 16 | 25 | 25
Beef | BBQ | 14 | 0 | 14
Spreadsheet: 800302d1665586666-using-if-function-inside-iferror-not-working-doubt-weight-or-cr-zero
Sheet: Sheet1

Age | Weight | Crcl | Magic
60 | 70 | 45
80 | 70 | 0
Spreadsheet: 874954d1721478502-pulling-data-from-multiple-tables-across-multiple-sheets-book_test-bsb-
Sheet: 15 Min Exception

Hc2 | Hc | CON # | INCIDENT # | NATURE | PRIORITY CODE | ADDRESS | CITY | UNIT | UNIT ASSIGNED | UNIT ON SCENE | RT: | NOTES:
 |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  | CORRECTED
Spreadsheet: 134361d1325250375-solved-reconcile-two-sets-of-data-test1301211
Sheet: employer deduction report

EMP. NO. | SURNAME | FIRST NAMES | (=N=) LOAN DEDUCTION | (=N=) LOAN BALANCE | REMARK
04157 | ADEDO, | ABIODUN MOSES | 12333.33 | 24666.7
02558 | ADEEGBE, | EMMANUEL SUNDAY | 8633.33 | 86333.34
13923 | ADENMOSUN, | [NAME] | 17143.33 | 120003.35
02664 | AJALA, | SALIU | 6348.49 | 19045.47
20635 | AJIBODU, | ABOSEDE OLUWATOBI | 4316.67 | 8633.3
20628 | AKINSOLA, | SUNDAY OLASUNKANMI | 4316.67 | 8633.3
07639 | ALIMI, | NAJEEM | 3700 | 40700
20625 | AYINLA, | ALIU | 5180 | 10360
09797 | AYODEJI, | FATAI ADESINA | 7893.33 | 15786.7
30238 | AZEEZ, | NURENI AKANBI | 4316.67 | 8633.3
30234 | BABATUNDE, | [NAME] | 5180 | 10360
20617 | BAKARE, | MUSILIU | 3946.67 | 11839.97
07473 | BANKOLE, | OLATUNDE | 6166.67 | 36999.98
20621 | BUSARI, | MOTUNRAYO OLUFUNKE | 4316.67 | 8633.3
20627 | FATUNMBI, | BABATUNDE MICHAEL | 4810 | 9620
30235 | IGOR, | LINUS | 5920 | 65120
10831 | JAYEOLA, | SUNDAY OLUWASEGUN | 11100 | 44400
11619 | KELANI, | RASAKI | 5180 | 10360
03533 | KINOSHI, | ABAYOMI OLALEKAN | 21953.33 | 153673.35
Spreadsheet: 814601d1674504784-calculating-number-of-personnel-by-status-and-hire-date-emp_counts
Sheet: EmpList

Name | ID | xxx | Status | yyy | Stat | Hire Date | Birthdate
[NAME] | 1 | a | L B | 15 | Mgr | 1999-10-04 00:00:00 | 1961-06-13 00:00:00
[NAME] | 2 | b | B | 20 | Emp1 | 1999-10-04 00:00:00 | 1962-09-06 00:00:00
[NAME] | 3 | c | B | 30 | Emp2 | 1999-10-04 00:00:00 | 1963-03-24 00:00:00
Julie | 4 | d | B | 40 | Xyz | 1999-10-04 00:00:00 | 1963-04-08 00:00:00
Spreadsheet: 115089d1310722532-help-please-monthly-updating-example-1-
Sheet: Assunta  

INDIVIDUAL STAFF FILE
General Information
Employee Name: | Assunta | ACF Start Date: | 2007-06-01 00:00:00
Employee ID Number: | ALK0001 | Contract Start Date: | 2010-10-18 00:00:00
Base: | Alek | Contract End Date: | 2011-09-30 00:00:00
Position | [NAME]
Category: | Employee
Level: | 3
LEAVE DATA | [NAME] | Leave Accrued 2011 | Leave Balance
 | 6 | 12 | 12
[NAME] | Dates of Leave | Type
6 | 17-Jan-11 to 22-Jan-11 | Annual
PREVIOUS POSTS | Start Date | End Date
[NAME] | 2007-06-01 00:00:00 | 2010-08-30 00:00:00
DISCIPLINARY
EVALUATION
COMMENTS
Spreadsheet: 825932d1681653489-convert-from-a-vertical-list-to-a-horizontal-list-cant-use-transpose-final-version-aligw
Sheet: Sheet1

Student ID | Last Name | First Name | [NAME] | Course
12345 | Smith | [NAME] | [EMAIL] | Test Course 1
12345 | Smith | [NAME] | [EMAIL] | Test Course 2
12345 | Smith | [NAME] | [EMAIL] | Test Course 3
12345 | Smith | [NAME] | [EMAIL] | Test Course 4
12345 | Smith | [NAME] | [EMAIL] | Test Course 5
12345 | Smith | [NAME] | [EMAIL] | Test Course 6
12345 | Smith | [NAME] | [EMAIL] | Test Course 7
32423 | Thomson | [NAME] | [EMAIL] | Test Course 8
32423 | Thomson | [NAME] | [EMAIL] | Test Course 9
32423 | Thomson | [NAME] | [EMAIL] | Test Course 10
32423 | Thomson | [NAME] | [EMAIL] | Test Course 11
32423 | Thomson | [NAME] | [EMAIL] | Test Course 12
32423 | Thomson | [NAME] | [EMAIL] | Test Course 13
32423 | Thomson | [NAME] | [EMAIL] | Test Course 14
32423 | Thomson | [NAME] | [EMAIL] | Test Course 15
32423 | Thomson | [NAME] | [EMAIL] | Test Course 16
32423 | Thomson | [NAME] | [EMAIL] | Test Course 17
32423 | Thomson | [NAME] | [EMAIL] | Test Course 18
32423 | Thomson | [NAME] | [EMAIL] | Test Course 19
Spreadsheet: 288976d1389363005-how-do-i-create-a-summary-sheet-looking-up-multipule-values-how-do-i-create-a-summary-sheet-looking-up-multipule-values-summary
Sheet: Summary Sheet

ARC |  |  |  |  |  |  | KNL
Device Code | Gnd | 1st | 2nd | Total |  |  | Device Code | Gnd | 1st | 2nd | Total
270 |  |  |  |  |  |  | 270
280 |  |  |  |  |  |  | 280
520 |  |  |  |  |  |  | 520
745 |  |  |  |  |  |  | 745
755 |  |  |  |  |  |  | 755
760 |  |  |  |  |  |  | 760
780-NHS |  |  |  |  |  |  | 780-NHS
790 |  |  |  |  |  |  | 790
 |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Device Code | Gnd | 1st | 2nd | Total |  |  | Device Code | Gnd | 1st | 2nd | Total
E4300 |  |  |  |  |  |  | E4300
E5520 |  |  |  |  |  |  | E5520
 |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Device Code | Gnd | 1st | 2nd | Total |  |  | Device Code | Gnd | 1st | 2nd | Total
V30 |  |  |  |  |  |  | V30
V30L |  |  |  |  |  |  | V30L
V30LE |  |  |  |  |  |  | V30LE
 |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Device Code | Gnd | 1st | 2nd | Total |  |  | Device Code | Gnd | 1st | 2nd | Total
HIPS Terminal |  |  |  |  |  |  | HIPS Terminal
 |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Device Code | Gnd | 1st | 2nd | Total |  |  | Device Code | Gnd | 1st | 2nd | Total
Z90 |  |  |  |  |  |  | Z90
 |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Device Code | Gnd | 1st | 2nd | Total |  |  | Device Code | Gnd | 1st | 2nd | Total
X90L |  |  |  |  |  |  | X90L
X90M7 |  |  |  |  |  |  | X90M7
 |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Spreadsheet: 84003d1284011748-billing-forecast-cash-flow-test2
Sheet: Dashboard

 | Values
Row Labels | Count of Project Type | Sum of 2010 Capital Utilization | Sum of 2010 YTD Implied Cash Flow- CW Capital | Sum of 2010 PROJECTED Spend
ADA / Emergency | 27 | #REF! | 284530.72 | #REF!
ADA Planned | 77 | #REF! | 0 | #REF!
ATM | 94 | #REF! | 1597899.73 | #REF!
Consolidation | 33 | 7604.21 | 854.21 | 6750
Consolidation Cap Add | 23 | #REF! | 181477.49 | #REF!
FPP | 1 | 101162.03 | 101162.03 | 0
Lighting | 9 | #REF! | -169036.36 | #REF!
Major [NAME] | 20 | #REF! | 687061.22 | #REF!
Minor Renovation | 216 | 7059310.719999999 | 3795269.08 | 3264041.64
New Store | 66 | #REF! | 11129268.94 | #REF!
Non-Transition Signage | 21 | #REF! | 533884.8200000001 | #REF!
RCI / Emergency | 269 | #REF! | 9347190.46000001 | #REF!
RCI / Planned | 272 | #REF! | 3295733.01 | #REF!
Grand Total | 1128 | #REF! | 30785295.34999998 | #REF!
Spreadsheet: 472500d1469623034-sum-when-values-are-equal-to-solved-book1
Sheet: Sheet1

year | list1 |  | year |  | list1 |  |  |  |  |  |  |  |  |  |  | value
2013 | Public |  | 2013 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2014 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2013 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2014 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2013 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2014 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2013 |  | Public |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2014 |  | Employee |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2013 |  | Employee |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2014 |  | Employee |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2013 |  | Employee |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2014 |  | Employee |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | 2013 |  | Employee |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 122748d1317129692-date-count-by-month-with-multiple-criteria-multiple-date-ranges
Sheet: Sheet1

 |  |  |  | I need a formula that counts the dates by month based on the Status.  For example I need the Count of January dates with a Status of 50 and all the January Dates with a status of 60 and so forth.  Thanks
 | Date | Status
 | 2011-01-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 60
 | 2011-04-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 300
 | 2011-04-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 60
 | 2011-01-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 300
 | 2011-06-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 60
 | 2011-06-01 00:00:00 | 50
 | 2011-06-01 00:00:00 | 60
 | 2011-01-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 300
 | 2011-04-01 00:00:00 | 300
Spreadsheet: c8125e12-b3e8-464b-a064-02710fef4e52
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43769991 | 2014-10-28 00:14:37 | ALLIES | 1 | 6 | 4 | 1611169 | Baron Von Funck | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43770174 | 2014-10-28 00:33:10 | AXIS | 1 | 6 | 1 | 1611169 | Baron Von Funck | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43770407 | 2014-10-28 00:51:13 | AXIS | 1 | 5 | 2 | 890676 | rssblackdragon | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43770567 | 2014-10-28 01:04:17 | ALLIES | 1 | 5 | 0 | 890676 | rssblackdragon | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43770759 | 2014-10-28 01:27:21 | ALLIES | 1 | 7 | 5 | 1266695 | Robben1 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43770978 | 2014-10-28 01:52:57 | ALLIES | 1 | 6 | 4 | 1628311 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
43771213 | 2014-10-28 02:11:43 | AXIS | 1 | 6 | 1 | 1628311 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
43771464 | 2014-10-28 02:36:07 | AXIS | 1 | 6 | 2 | 1657843 | etienne.anctil | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux