tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678871d1590089771-can-excel-separate-a-24-hour-shift-into-different-parts-on-a-time-sheet-sample-overtime-chart
Sheet: JD

Employee Overtime Chart
Name: | [NAME] |  |  |  | Month: | May 2020
Day | Date | House | Sign In | Sign Out | Awake | Sleep | Exempt | Week 1
Su | 3 | Test 1 | 15:00:00 | 00:00:00 | 7 |  | 2
Mo | 4 | Test 1 | 00:00:00 | 15:00:00 | 9 |  | 6
[NAME] | 5 | Test 2 | 15:00:00 | 00:00:00 | 9 |  | 2
We | 6 | Test 2 | 00:00:00 | 00:00:00 | 16 | 2 | 6
Th | 7 | Test 2 | 00:00:00 | 09:00:00 | 3 | 6
Fr | 8 | Test 3 | 15:00:00 | 00:00:00 | 7 |  | 2
Sa | 9 | Test 3 | 00:00:00 | 22:00:00 | 14 |  | 6
Total
Spreadsheet: 715860d1611891023-sum-multiple-categories-in-the-same-formula-for-each-month-forum-excel-28-jan-2021
Sheet: Épargnes Inv.

 |  |  | Compte |  | Profit /perte | Solde fermeture
 | Solde des comptes (relevé le + récent, solde de fermeture): |  |  | Chèque
 |  |  |  | FTQ (REER)
 |  | + |  | Placement québec (CÉLI)
Profit/perte sur période de 12 mois (selon l'année financière): |  |  |  | Argent métal
 |  |  |  | Urgence
Date | Description | Compte | Solde relevé
2020-01-31 00:00:00 | Solde de fermeture
2020-02-29 00:00:00 | Solde de fermeture
2020-03-31 00:00:00 | Solde de fermeture
2020-04-30 00:00:00 | Solde de fermeture
2020-05-31 00:00:00 | Solde de fermeture
2020-06-30 00:00:00 | Solde de fermeture
2020-07-31 00:00:00 | Solde de fermeture
2020-08-31 00:00:00 | Solde de fermeture
2020-09-30 00:00:00 | Solde de fermeture
2020-10-31 00:00:00 | Solde de fermeture
2020-11-30 00:00:00 | Solde de fermeture
2020-12-31 00:00:00 | Solde de fermeture
Date | Description | Compte | Solde relevé | Montant | Profit /perte | Solde fermeture
2020-01-10 00:00:00 | Deposit | AR |  | 200
2020-01-21 00:00:00 | Deposit | AR |  | 200
2020-01-30 00:00:00 | Deposit | AR |  | 200
2020-03-01 00:00:00 | Deposit | FT |  | 300
2020-03-01 00:00:00 | Deposit | AR |  | 25
2020-03-05 00:00:00 | Withdrawal | AR |  | -30
2020-03-11 00:00:00 | Withdrawal | FT |  | -45
2020-03-13 00:00:00 | Withdrawal | AR |  | 20
2020-03-01 00:00:00 | Deposit | PL |  | 60
2020-03-01 00:00:00 | Deposit | UR |  | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 55
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 77
Spreadsheet: 111402d1307754557-vlookup-prob-modified-
Sheet: Sheet1

ID | NAME | [NAME] | CITY | STATUS
100 | A | test1 | Newyork | N
110 | B | test2 | Washington | N
120 | C | test3 | Boston | N
130 | A | test4 | Washington | N
140 | D | test1 | Boston | Y
150 | B | test2 | Boston | Y
175 | 100 | NOT IN SHET 1 |  | N
SHEET 2
100 | A | test | Newyork
110 | 100 | test2 | Washington
120 | C | test1 | Boston
130 | 150 | test4 | Washington
140 | D | test1 | Boston
150 | B | test2 | Boston
Spreadsheet: 199505d1355240316-sum-based-conditions-in-different-sheets-forumfile
Sheet: decile portfolio's

Portfolio decile | 1
1995-06-01 00:00:00
1995-07-01 00:00:00
1995-08-01 00:00:00
1995-09-01 00:00:00
1995-10-01 00:00:00
1995-11-01 00:00:00
1995-12-01 00:00:00
1996-01-01 00:00:00
1996-02-01 00:00:00
1996-03-01 00:00:00
1996-04-01 00:00:00
1996-05-01 00:00:00
1996-06-01 00:00:00
1996-07-01 00:00:00
1996-08-01 00:00:00
1996-09-01 00:00:00
1996-10-01 00:00:00
1996-11-01 00:00:00
1996-12-01 00:00:00
1997-01-01 00:00:00
1997-02-01 00:00:00
1997-03-01 00:00:00
1997-04-01 00:00:00
1997-05-01 00:00:00
1997-06-01 00:00:00
1997-07-01 00:00:00
1997-08-01 00:00:00
1997-09-01 00:00:00
1997-10-01 00:00:00
1997-11-01 00:00:00
1997-12-01 00:00:00
1998-01-01 00:00:00
1998-02-01 00:00:00
1998-03-01 00:00:00
1998-04-01 00:00:00
1998-05-01 00:00:00
1998-06-01 00:00:00
1998-07-01 00:00:00
1998-08-01 00:00:00
1998-09-01 00:00:00
1998-10-01 00:00:00
1998-11-01 00:00:00
1998-12-01 00:00:00
Spreadsheet: 42276d1240878808-monthly-deposits-681398
Sheet: Sheet1

ID | Transaction Date | Transaction Detail Amount
518518 | 2007-02-16 00:00:00 | 1000
518523 | 2007-03-12 00:00:00 | 222
518518 | 2007-03-20 00:00:00 | 500
518523 | 2007-04-20 00:00:00 | 223
518523 | 2007-05-21 00:00:00 | 223
518538 | 2007-06-06 00:00:00 | 0
518538 | 2007-06-06 00:00:00 | 1236.08
518523 | 2007-06-25 00:00:00 | 223
518538 | 2007-07-02 00:00:00 | 100
518523 | 2007-07-23 00:00:00 | 223
518538 | 2007-07-23 00:00:00 | 100
518523 | 2007-08-20 00:00:00 | 223
518538 | 2007-08-21 00:00:00 | 170
518526 | 2007-11-26 00:00:00 | 100
518534 | 2007-11-26 00:00:00 | 875
518500 | 2007-11-27 00:00:00 | 329
518500 | 2007-12-03 00:00:00 | 360
518500 | 2007-12-10 00:00:00 | 50
518500 | 2007-12-10 00:00:00 | 600
518534 | 2007-12-13 00:00:00 | 375
518526 | 2007-12-14 00:00:00 | 100
518500 | 2008-01-04 00:00:00 | 10
518534 | 2008-01-14 00:00:00 | 375
518526 | 2008-01-24 00:00:00 | 600
518526 | 2008-02-01 00:00:00 | 600
518534 | 2008-02-07 00:00:00 | 375
518534 | 2008-08-31 00:00:00 | 20
518534 | 2008-09-30 00:00:00 | 20
518534 | 2008-10-31 00:00:00 | 40
Spreadsheet: 48756d1248056931-why-are-my-averages-not-coming-out-correct-sample
Sheet: Sheet1

Cost | Sale Price | Profit | Profit Margin
11 | 22
5 | 15
3 | 23
2 | 3
6 | 18
5 | 10
22 | 38
Below line is the numbers above added up and PM based on them |  |  |  | average of the above profit margins
 |  |  |  | average of the total numbers
Spreadsheet: kate_symes__18981__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
Spreadsheet: 130447d1322307505-avoid-repetition-in-cell-doubt
Sheet: CONE

STABBING CONE: Syntax-(SC-Small Dia-Large dia-CONTROL NUMBER) |  |  |  | INPUT AREA |  |  |  |  |  | Remarks
SL No | STOCK CODE- GIVEN | MATERIAL [NAME] | APPROPRIATE STOCK CODE | [NAME] "CN" ( cone) | SMALL DIAMETER | LARGE DIAMETER | CONTROL NUMBER | THICKNESS OF PLT | SERVICES
1 | PI-13T-01 | STABBING CONE: 330/1105mm X 25mm X 800mm WTH  API 2H Gr. 50 (RT2) | CN-330-330-01 | CN | 330 | 330 | 01 | 25 | RT2 - RolledTubular from PL2 primary service plates. NOT Tested for through thickness. | CN-330-330-01 | 0 |  | RT1 - RolledTubular from PL1 critical service plates. Tested for through thickness.
2 | PI-25T-01 | CONE: 324/978.6mm X 25.00mm X 675mm WTH  API 2H Gr. 50 (RT1) | CN-345-978-01 | CN | 345 | 978 | 01 | 25 | RT1 - RolledTubular from PL1 critical service plates. Tested for through thickness. | CN-345-978-01 | 0 |  | RT2 - RolledTubular from PL2 primary service plates. NOT Tested for through thickness.
3 | PI-25T-02 | CONE: 609.6/1066.8mm X 25.00mm X 910mm WTH  API 2H Gr. 50 (RT1) | CN-609-1066-01 | CN | 609 | 543 | 01 | 25 | RT1 - RolledTubular from PL1 critical service plates. Tested for through thickness. | CN-609-543-01 | 0 |  | RT4 - RolledTubular from PL4 gerneral service plates.
4 | PI-25T-03 | CONE: 406.4/508mm X 38.10mm X 300mm WTH  API 2H Gr. 50 (RT2) | CN-406-508-01 | CN | 406 | 508 | 01 | 38 | RT2 - RolledTubular from PL2 primary service plates. NOT Tested for through thickness. | CN-406-508-01 | 0
5 | PI-25T-04 | CONE: 609.6/1066.8mm X 25.00mm X 910mm WTH  API 2H Gr. 50 (RT1) | cn-609-1066-01 | CN | 609 | 788 | 01 | 25 | RT1 - RolledTubular from PL1 critical service plates. Tested for through thickness. | CN-609-788-01 | 0
6 | [NAME] | CONE: 324/978.6mm X 25.00mm X 675mm WTH  API 2H Gr. 50 (RT1) | cn-324-978-01 | CN | 324 | 978 | 01 | 25 | RT1 - RolledTubular from PL1 critical service plates. Tested for through thickness. | CN-324-978-01 | 0
7 | PI-25T-06 | PIPE: CS 323.9MM X 508.0MM X 25MM X 600 mm WTH   API 2W GR 50 (RT2) (9COM# [PHONE]) (INSPECTION LEVEL:1) | cn-324-508-01 | CN | 324 | 978 | 01 | 25 | RT2 - RolledTubular from PL2 primary service plates. NOT Tested for through thickness. | CN-324-978-01 | 0
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
 |  |  | ---
Spreadsheet: 31b42b0b-4b85-409b-b99c-ad52291cc256
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Vermögende Ausländerinnen und Ausländer werden in Zukunft im [NAME] Einkommen und Vermögen besteuert. [NAME] ist nicht mehr möglich.
 | Welche Staatsbürgerschaft haben [NAME]?
Antwort | Schweizer
[NAME] | 0.71
[NAME] | 0.22
Neutral / Weiss nicht | 0.08
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 742827d1628074240-risk-matrix-visualization-function-riskmatrix
Sheet: Tabelle1

1 | 8
2 | 9
3 | 10
4 | 11
5 | 12
6 | 13
7 | 14
Nr. |  | Risk-Description | Probability of occurrence [1 - 5] | Impact [1 - 5] | Risk number
 |  |  |  |  |  |  |  | Risk | Amount |  | Probability of occurrence | 5
1 |  | Strategic Risk
 |  |  |  |  |  |  |  | 0 | 0 |  |  | 4
1.1 |  | A | 1 | 4 |  |  | Low Risk | 1
1.2 |  | B | 3 | 2 |  |  |  | 2 |  |  |  | 3
1.3 |  | C | 1 | 1 |  |  |  | 3
1.4 |  | D | 5 | 4 |  |  |  | 4 |  |  |  | 2
 |  |  |  |  |  |  | Medium Risk | 5
 |  |  |  |  |  |  |  | 6 |  |  |  | 1
 |  |  |  |  |  |  |  | 8
2 |  | Regulatory Risk |  |  |  |  |  | 9 |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | 10
2.1 |  | AA | 2 | 1 |  |  |  | 12 |  |  |  |  | Impact
2.2 |  | BB | 2 | 3 |  |  | High Risk | 15
2.3 |  | CC | 4 | 1 |  |  |  | 16
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 25
3 |  | Financial Risk |  |  |  |  |  | Sum
 |  |  |  |  |  |  |  |  |  |  | Probability of occurrence | 5
3.1 |  | AAA | 4 | 4
 |  |  | 5 | 5 |  |  |  |  |  |  |  | 4
 |  |  | 1 | 1
3.2 |  | BBB | 1 | 2 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 3.1; 1.3
 |  | Task: Use the blank risk matrix on the bottom right to visualize which kind of risk is in each cell by displaying either the Nr.(column A) or the Risk description (column C) in the coloured cells. I already did the task for the yellow cells manually, this however should work automatically as there are many Risk numbers and they are subject to change. Trials with the IF statement did not work. Often, more than one cell shares the same risk number. Thanks for the help!
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Impact
Spreadsheet: 121145d1315864499-stop-duplicates-with-datavalidation-if-entered-by-a-formula-didb
Sheet: Sheet2

 |  | Venue | Description | Status
 |  | Pending | Conf (Gov) FD | Quotation
 |  | Conference 1 | Conf (Corp) FD | Provisional
 |  | Conference 2 | Conf (Gov) HD | Confirmed
 |  | Conference 3 | Conf (Corp) HD | Completed
 |  | Conference 4 | Wedding
 |  | Banquet 1 | Function
 |  | Banquet 2 | Birthday
 |  | Chapel
 |  | Chapel (15h00)
 |  | Chapel (17h00)
 |  | Board Room
 |  | Gazebo
 |  | Transport
Spreadsheet: 842118d1694180701-cannot-figure-out-a-formula-for-a-weighted-average-with-na-as-an-option-test-file
Sheet: Sheet1

 | Weight / Score | Proposed Weights | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Q1 | 3 | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Q2 | 3 | 0.055 | 0.0825 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Q3 | 3 | 0.065 | 0.09749999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA
Q4 | NA | 0.1 | 0
Spreadsheet: 542234d1507759336-check-if-another-column-has-data-for-any-of-the-duplicated-results-locating-duplicates-eba
Sheet: Sheet1

Numbers | Additional Data | Number of Duplicates for Corresponding Number | Does any cell that has this number duplicated have additional data (answered as yes or a sum) and preferably, which cells |  |  | HELP COLUMNS FOR DUPLICATES' ROW NUMBERS (ARRAY FORMULAS)
5 | sdfsf sfs fsf |  | Possible Answers: Yes / 3 / B2, B4, B12
10 |  |  | Possible Answers: Yes / 2 / B6, B10
5 | sfsfsf |  | Possible Answers: Yes / 3 / B2, B4, B12
3 |  |  | Possible Answer: This cell stays blank
10 | hkhkhkhk |  | Possible Answers: Yes / 2 / B6, B10
2 |  |  | Possible Answer: This cell stays blank
5 |  |  | Possible Answers: Yes / 3 / B2, B4, B12
4 |  |  | Possible Answers: No / 0
10 | hjkhkhkhk |  | Possible Answers: Yes / 2 / B6, B10
4 |  |  | Possible Answers: No / 0
5 | sfsfsfsf |  | Possible Answers: Yes / 3 / B2, B4, B12
Spreadsheet: 760310d1640139431-index-formula-with-2-matches-index-with-two-matches
Sheet: Sheet1

BR2 | 5235.98 | BAL |  |  |  |  | Summary of Variances
 | 0 | [NAME] |  |  |  |  | BR1 | [NAME]
 |  |  |  |  |  |  | BR2 | [NAME]
BR2 | 8745.35 | BAL |  |  |  |  | BR3 | [NAME]
 | 45.25 | [NAME]
ELM | 4525.95 | BAL
 | 89.25 | [NAME]
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 61
2 |  |  |  | 61
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
2001-09-30 00:00:00 |  |  |  |  | 15731
2001-10-02 00:00:00
CBS Volume
 |  |  | -8077
Spreadsheet: 195480d1353525554-convert-range-of-numbers-to-either-1-0-dummy-data
Sheet: Sheet1

 | Old Data |  |  |  |  |  |  | New Data
ID | Q3.1_a | Q3.1_b | Q3.1_c | Q3.1_d | Q3.1_e | Q3.1_f | Q3.1_g | New Var 1 | New Var 2 | New Var 3 | New Var 4 | New Var 5 | New Var 6 | New Var 7 | New Var 8 | New Var 9 | New Var 10 | New Var 11 | New Var 12 | New Var 13 | New Var 14 | New Var 15 | New Var 16 | New Var 17 | New Var 18 | New Var 19 | New Var 20 | New Var 21
1 | 2 | 21 |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2 | 9 | 11 | 13 | 21 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
3 | 1 | 11 | 18 |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
4 | 4 | 5 |  |  |  |  |  | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 4 | 7 | 11 | 18 |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
6 | 2 | 6 | 12 |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 6 | 8 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 1 | 4 | 6 | 8 |  |  |  | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 4 | 12 | 19 |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
10 | 11 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 109747d1306511955-excel-2007-lock-unlock-cells-containing-drop-down-validation-based-results-of-another-drop-down-it-recovery-requirements
Sheet: IT Recovery requirements 2

IT Recovery requirements
Hardware and software requirements
Please identify what hardware / software is currently used by the department - including any specialist
equipment - and, other than that identified in sheet 1, what would be required in the event of disaster
(including location - e.g. London, X's home - at which it will be required).
Hardware
Hardware name | Location | Current | Day 1 | 3 days | 1 wk | 1 –3 wks | 3+ Wks
Software
Please list what and how many copies of non-standard PC-based software the function would require in
recovery mode
Important note : Critical software files should be stored to a network drive where they will be backed up by IT.
No critical software files should be held on local computer drives e.g. C:\ drive
Software name | Location | Current | Day 1 | 3 days | 1 Wk | 1 -3 Wks | 3 + Wks
Spreadsheet: 702005d1604043331-summing-values-from-another-excel-tab-based-on-multiple-criteria-book3
Sheet: Summary

=SUMIFS(Datasheet!$C$1:$C$18,Datasheet!$A$1:$A$18,$A4,Datasheet!$A$1:$H$1,B$3)
ProjectID | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
PROJ1
PROJ2
PROJ3
PROJ4
PROJ5
=SUMPRODUCT(DataSheet!$A$1:$H$18*(DataSheet!$A$1:$A$18=$A14)*(Datasheet!$A$1:$H$1=B$13))
ProjectID | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
PROJ1
PROJ2
PROJ3
PROJ4
PROJ5
Spreadsheet: 883601d1732222824-making-an-automatic-on-call-board-recreation-of-the-on-call-board-automatic-2025
Sheet: November

 | November
 |  | 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
 | [NAME]
 | [NAME]
 | Romo
 | [NAME]
 | Orlando
 | Nick
 | [NAME]
 | Zach
 | Pando
 | [NAME]
 | Art
 | Manuel
 | [NAME]
Spreadsheet: 748756d1632325161-help-with-sumproduct-to-calculate-monthly-gross-profit-sumproduct-formula-for-gross-profit-2
Sheet: Sheet1

Kindly asking for help with sumproduct formula to calculate Gross Profit or any other formula which is not sumifs
 |  |  |  |  |  | Desired Outcome |  |  |  |  | Other formula
Date | Details | Amount |  |  |  |  | Jan | feb | Mar |  |  | January | February | March
2021-01-01 00:00:00 | sales | 285 |  |  |  | Sales |  |  |  |  | Sales
2021-01-10 00:00:00 | sales | 320 |  |  |  | Cost of Sales |  |  |  |  | Cost of Sales
2021-01-30 00:00:00 | Cost of sales | 280 |  |  |  | Gross Profit |  |  |  |  | Gross Profit
2021-02-10 00:00:00 | sales | 335
2021-02-15 00:00:00 | Cost of sales | 280
2021-03-13 00:00:00 | sales | 250
2021-03-10 00:00:00 | sales | 255
2021-03-01 00:00:00 | Cost of sales | 255
2021-03-02 00:00:00 | Cost of sales | 280
Spreadsheet: 694653d1599737109-excel-lookup-and-countif-issue-example-100920
Sheet: Company Names & Exchanges

Type | Sector | Exchange | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Code
Public | Retail | NASDAQ | Amazon |  | Amazon | AMZN
Public | Pharma / Biotech | NASDAQ | [NAME] |  | Crispr Therapeutics |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRSP
Public | Pharma / Biotech | NASDAQ | Gilead Sciences |  | Gilead Sciences[B] NASDAQ: GILD |  |  |  | GILD
Public | Pharma / Biotech | LSE | [NAME] |  | GSK GlaxoSmithKline GSK LSE: GSK (very active in AI https://blog.benchsci.com/pharma-companies-using-artificial-intelligence-in-drug-discovery#amgen) | GSK
Spreadsheet: 200091d1355412837-formatting-issues-budget-2nd-review-sample
Sheet: detail

ATTACHMENT 3  (continued)
GRANT BUDGET LINE-ITEM DETAIL
(BUDGET PAGE 2)
SALARIES | AMOUNT
TBD, Coordinator:  $4,605.00 per month @ 10 months @ 40% effort (16 hrs per wk) | 18420
TBD, Registered Nurse:  $4,333.00 per month @ 10 months @ 40% effort (16 hrs per wk) | 17332
TOTAL (ROUNDED) | 35800
PROFESSIONAL FEES/GRANT AWARD | AMOUNT
ANNUAL A-133 Audit | 540
Registered Dietician Consultant:  ([NAME]) 32 hrs per month @ $45 per hr @ 9.75 months | 14040
Fitness Consultant:  (TBD) 32 hrs per month @ $35 per hr @ 9.75 months | 10920
Program Evaluation Consultant:  ([NAME]) approximately 200 total hrours @ $35 each | 7000
TOTAL | 32500
TRAVEL/CONFERENCES & MEETINGS | AMOUNT
Reimbursement for routine mileage ($1,900) at state rate at approximately 404 miles @ 10 months @ .47 cents per mile, plus lodging and per-diem ($500) when over-night travel for TDH technical assistance meeting is required. | 2400
TOTAL | 2400
Spreadsheet: 02344553-0f7c-49b4-b414-484ded140b0e
Sheet: Top 25

Position | Class | Name | Total Points
1 | SN | [NAME] | 282
2 | T1 | [NAME] | 268
3 | F500 | [NAME] | 264
4 | ITB | [NAME] | 264
5 | STU | [NAME] | 246
6 | IT7 | [NAME] | 246
7 | AS | [NAME] | 225
8 | SM | [NAME] | 209
9 | STL | Matthias Krause | 190
10 | SF | [NAME] | 187
11 | T1 | [NAME] | 179
12 | STL | [NAME] | 177
13 | ITA | [NAME] | 177
14 | FP | [NAME] | 174
15 | CFC | [NAME] | 173
16 | F500 | [NAME] | 165
17 | ITS | [NAME] | 161
18 | IT7 | [NAME] | 160
19 | FP | [NAME] | 160
20 | DSR | [NAME] | 156
21 | T2 | [NAME] | 152
22 | SF | [NAME] | 144
23 | SM | [NAME] | 135
24 | STU | Christian Machado | 132
25 | F500 | [NAME] | 127
Spreadsheet: 134331d1325212496-lookup-one-value-in-a-range-and-then-lookup-another-value-beneath-it-multiple-lookup-problem
Sheet: Sheet2

[NAME] | Car Type | Number Sold | Unit Price | Total Sales
Barnhill | Sedan | 5 | 2200
 | Coupe | 4 | 1800 | 7200
Ingle | Sedan | 6 | 2300 | 13800
 | Coupe | 8 | 1700 | 13600
Jordan | Sedan | 3 | 2000 | 6000
 | Coupe | 1 | 1600 | 1600
Pica | Sedan | 9 | 2150 | 19350
 | Coupe | 5 | 1950 | 9750
Sanchez | Sedan | 6 | 2250 | 13500
 | Coupe | 8 | 2000 | 16000
 |  |  |  | #N/A
Spreadsheet: 101470d1299594658-count-formula-with-criteria-copy-of-example
Sheet: Sheet2

 |  |  | January | February | March |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
 |  | [NAME] |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  | [NAME]