tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 672264d1586810639-how-to-check-data-in-cells-of-colum-for-0-if-so-return-data-from-another-cell-copy-of-jh-siding-pricing-sheet-1-
Sheet: Sheet1

 |  |  | ExteriorRepair
 |  |  | Restoration Experts
 |  |  | The [NAME]'s
 |  |  | 2010-07-19 00:00:00 |  |  |  |  |  |  |  |  |  | \
 |  |  | 30 Day Price | 25298.02349034295
 |  |  | Advertised Discount | 0 |  |  | 5 Year | 7 Year | 10 Year
 |  |  | Referral Discount | 0 |  |  | 503.4306674578248 | 384.5299570532129 | 295.9868748370125
 | LessCoupon |  |  |  |  |  | AMT. DUE | 25298.02349034295
 |  |  |  |  |  |  | DOWN PAYMENT
 |  |  |  |  |  |  | Remaining: | 0
 |  |  | JUST: | 25298.02349034295 |  |  | AMT. FINANCED | 25298.02349034295
 |  |  | Product/Service | Units |  |  | Price
 |  |  | [NAME] side | 1 |  |  | 2227.759418374091
Spreadsheet: 250191d1373864106-condition-formatting-for-a-negative-number-considers-it-still-positive-wow-characters
Sheet: Cainine

Item |  | [NAME] | steamed crab surprise | mogu fish | mad brew | sea mist | black pep | Banq grill | [NAME]. Pot | [NAME] |  |  |  |  | Fire Spirit Salmon
 |  |  |  |  |  |  |  | 5 | 5 | 5
 |  |  |  | 1 | 1 |  | 1
 |  |  |  | 5 |  |  |  |  |  | 60 |  |  |  |  | 10
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  | 300
 |  |  | 5
 |  |  |  |  |  |  |  |  | 300
 |  |  |  | 25
 |  |  |  |  |  |  | 5 |  | 60
 |  |  |  |  | 50
 |  |  | 5 |  |  |  |  | 60
 |  |  |  | 5
 |  | 5
 |  |  |  |  |  | 5
 |  | 25
 |  | 5 |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  | 60
 |  | 1 | 1 |  |  | 1
 |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  | 5
 |  |  | 25 |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  | 60
Spreadsheet: 846136d1697449580-repeating-block-quarterly-dates-test
Sheet: Sheet1

2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-03-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-06-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-09-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
2019-12-01 00:00:00
Spreadsheet: 34989d1232464429-interpolating-factors-yearmonthsearly
Sheet: Sheet1

ASH S | ASH STREET
SMITH STREE | SMITH STREET
BLACKSTONE ST | BLACKSTONE STREET
S. SOUTH ST | S. SOUTH STREET
Dog ave | Dog STREET
60g | 60
42.5g& | 42.5
227g | 227
355ml | 355
2L | 2
Spreadsheet: 120995d1315746489-combining-two-data-sets-help-1-
Sheet: Lookup Tables

Estimated year 11 Coursework Grade |  |  |  |  | SiN
0 | U |  |  |  | 0 | U
18 | F |  |  |  | 15 | G
24 | E |  |  |  | 20 | F
30 | D |  |  |  | 26 | E
36 | C |  |  |  | 32 | D
41 | B |  |  |  | 39 | C
47 | A |  |  |  | 44 | B
52 | A* |  |  |  | 50 | A
 |  |  |  |  | 54 | A*
Spreadsheet: andy_zipper__467__11_26_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 18.5 | 220 | 230 | 67.3 | 70.3 | 0.8 | 2001-11-26 10:45:00
 | CL G2 | 19 | 340 | 350 | 60.4 | 62.2 | 0.73 | 2001-11-26 10:45:00
 | CL H2 | 19 | 400 | 420 | 57 | 59.9 | 0.7 | 2001-11-26 10:45:00
 | CL J2 | 19 | 440 | 460 | 53.9 | 56.4 | 0.66 | 2001-11-26 10:45:00
 | CL K2 | 19.5 | 480 | 505 | 50.4 | 53.1 | 0.63 | 2001-11-26 10:45:00
 | CL M2 | 19.5 | 500 | 520 | 48.1 | 50 | 0.6 | 2001-11-26 10:45:00
 | CL N2 | 19.5 | 515 | 535 | 45.7 | 47.5 | 0.57 | 2001-11-26 10:45:00
 | CL Q2 | 20 | 540 | 560 | 43.7 | 45.4 | 0.56 | 2001-11-26 10:45:00
 | CL U2 | 20 | 545 | 565 | 41.7 | 43.3 | 0.53 | 2001-11-26 10:45:00
 | [NAME] | 20 | 555 | 580 | 40.3 | 42.1 | 0.52 | 2001-11-26 10:45:00
 | CL X2 | 20 | 555 | 580 | 38.5 | 40.3 | 0.5 | 2001-11-26 10:45:00
 | [NAME] | 20 | 555 | 585 | 37 | 39.1 | 0.48 | 2001-11-26 10:45:00
 | CL M3 | 20.5 | 560 | 600 | 30.4 | 32.6 | 0.41 | 2001-11-26 10:45:00
 | CL Z3 | 20.5 | 560 | 600 | 27 | 29 | 0.36 | 2001-11-26 10:45:00
 | CL M4 | 21 | 560 | 600 | 24.1 | 25.9 | 0.33 | 2001-11-26 10:45:00
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: Duke

Duke Energy Field Services
Contract  24268
2002-01-31 00:00:00 |  | 1529476.6
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-02-10 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 933
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -1
500267
Duke Energy Trading and Marketing
Contract  24693
2002-01-31 00:00:00 |  | 275313.72
2002-02-10 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 377700 | 117857 | 193435
2002-01-31 00:00:00 |  | 855876.1
2002-02-10 00:00:00
500241
500391 | 842
500392 | 907
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
24268
24693
24361
21665
22664
23995
22051
20379
26357
21544
24532
Spreadsheet: 26552d1218714899-drivers-hours-spreadsheet-driving-hours-2008-template
Sheet: Sheet2

Jan | Surname | Forename | [NAME] | Arrive | Reg | Start date | End Date | start km | end km | [NAME] | start | end | total driving | breaks | Mode switch correctly used
1 | x | x | x | x | x | x | x | x | x | x | 2257 | 0237 | 3H40 | N/A
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 | x | x | x | x | x | x | x | x | x | x | 1010 | 1530 | 2H40 | 2H40 | Y
25 | x | x | x | x | x | x | x | x | x | x | 0855 | 1500 | 2H10 | N/A
26 | off
27 | x | x | x | x | x | x | x | x | x | x | 0735 | 1925 | 5H50 | 6H
28
29 | x | x
30 | x | x |  |  |  |  |  |  |  |  | 0800 | 1700 | N/A | N/A
31
Feb | Surname | Forename | [NAME] | Arrive | Reg | Start date | End Date | start km | end km | [NAME] | start | end | total driving | breaks | Mode switch correctly used
1 |  |  | x | x | x | x | x | x | x | x | 0150 | 1657 | 9H |  | NOT USED CORRECTLY
2 |  |  | x | x | x | x | x | x | x | x
3 | x | x | x | x | x | x | x | x | x | x | 0800 | 1700 | 3H30 |  | NOT USED CORRECTLY
4
5 | x | x | x | x | x | x | x | x | x | x | 0800 | 2300 | 2H
6 | x | x | x | x | x | x | x | x | x | x | 0800 | 2300 | 2H
7 | x | x | x | x | x | x | x | x | x | x | 0330 | 1600 | 13H
8 | x | x | x | x | x | x | x | x | x | x | 0700 | 1400 | 8.5H
9 |  |  | DAY OFF
10
11
12 | x | x |  |  |  | x | x
13 | x | x | DAYOFF |  |  |  | DAYOFF
14 | x | x | x | x | x | x | x | x | x | x | 1015 | 1830 | 4H20
15 | x | x | x | x | x | x | x | x | x | x
16 | x | x | x | x | x | x | x | x | x | x |  | 2135
17 | x | x | x | x | x | x | x | x | x | x | 0745 | 2200
18 | x | x | x | x | x | x | x | x | x | x | 0745 | 0230
19
20 | x | x | x | x | x | x | x | x | x | x | 1255 | 1725 | 4H30
21
22
23
24
25
26
27
28
March | Surname | Forename | [NAME] | Arrive | Reg | Start date | End Date | start km | end km | [NAME] | start | end | total driving | breaks | Mode switch correctly used
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
37
April | Surname | Forename | [NAME] | Arrive | Reg | Start date | End Date | start km | end km | [NAME] | start | end | total driving | breaks | Mode switch correctly used
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
MAY | Surname | Forename | [NAME] | Arrive | Reg | Start date | End Date | start km | end km | [NAME] | start | end | total driving | breaks | Mode switch correctly used
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
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: Jandra re Sheet

40mm RE Sheet
 | % Passing Sieve |  |  |  |  |  |  | % Passing | 40mm Re Sheet |  | RMS Specification |  | Deviation | % Retained | [NAME] |  | Deviation | Result | Spec
Sieve mm | 40mm Re Sheet | CRB20 | dust | 14mm | CRS40 |  |  | Blend Result | Passing Lower | Passing Upper | Passing Lower | Passing Upper | Passing | Blend Result | Lower | Upper | Retained | ABC
26.5 | 94 | 100 | 100 | 100 | 88 | 100 | 100 | 92.8 | 90 | 95 | 100 | 100 | 0
19 | 99 | 100 | 100 | 100 | 99 | 100 | 100 | 99.1 | 95 | 100 | 95 | 100 | 0 | -6.299999999999997
13.2 | 87 | 86 | 100 | 94 | 89 | 90 | 100 | 88.9 | 77 | 93 | 78 | 92 | 0 | 10.19999999999999 | 6 | 18 | 0
9.5 | 63 | 76 | 100 | 11 | 47 | 72 | 100 | 61.9 | 48 | 67 | 63 | 83 | 0 | 27.00000000000001 | 7 | 17 | 10.00000000000001
6.7 | 62 | 54 | 100 | 0 | 59 | 57 | 100 | 64.9 | 50 | 70 | 50 | 70 |  |  | 10 | 21
4.75 | 48 | 57 | 100 | 0 | 33 | 46 | 100 | 48.7 | 31 | 48 | 44 | 64 | 0.7000000000000028 | 13.2 | 13 | 25 | 0
2.36 | 33 | 29 | 74 | 0 | 26 | 30 | 100 | 35 | 29 | 49 | 33 | 49 | 0 | 13.7 | 7 | 19 | 0
0.425 | 7 | 17 | 23 | 0 | 11 | 8 | 100 | 9.8 | 10 | 18 | 14 | 23 | -0.1999999999999993 | 25.2 | 14 | 30 | 0 | 28 | 35-55
0.075 | 1 | 8 | 9 | 0 | 4 | 4 | 100 | 2.7 | 8 | 12 | 7 | 14 | -5.3 | 7.100000000000001 | 6 | 13 | 0 | 27.55102040816326 | 35-55
0.0135 | 3.5 | 6 | 17 | 0 | 0 | 2 | 40 | 3.8 | 3 | 7 | 3 | 7 | 0 | -1.1 | 3 | 8 | -4.1 | 140.7407407407407 | 35-60
PI | 3 | 6 | 0 | 0 |  |  |  | 1.285714285714286 | 6 | 12 | 2 | 6
Ratio | 60 | 0 | 10 | 0 | 30 | 0 | 0 | 100 | Min CBR | 80
 |  |  |  |  |  |  |  |  | Note: Pre-treatment required
Spreadsheet: 814996d1674681706-range-criteria-problem-in-the-function-countifs-sample
Sheet: see_this_page

 | Who | Tümü
 | January |  |  | April |  |  |  |  |  |  |  | December
2023 | OCAK | ŞUBAT | MART | NİSAN | MAYIS | HAZİRAN | [NAME] | AĞUSTOS | EYLÜL | EKİM | KASIM | ARALIK | TOTAL
Spreadsheet: 775923d1649383236-finding-highest-rated-department-by-the-sum-of-total-sales-and-employee-id-excel-training-help-different-tabs
Sheet: Data

Employee ID | Department | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | Total Sales | Helper | Row Labels | Count of Jan-16
1006 | Development | 1 | 9 | 3 |  |  | Development | 2
1007 | Finance | 2 | 7 | 5 |  |  | Finance | 2
1009 | Finance | 6 | 1 | 4 |  |  | MD | 2
1100 | Finance | 54 | 67 | 7 |  |  | Support | 5
3900 | Support | 5 | 2 | 1 |  |  | Grand Total | 11
4500 | Support | 41 | 45 | 7
133 | Support | 66 | 77 | 21
133 | Support | 44 | 33 | 88
133 | Support | 8 | 7 | 5
1007 | Support | 2 | 7 | 5
1007 | Support | 55 | 87 | 5
99 | MD | 5 | 56 | 5
100 | Support | 2 | 2 | 56
100 | Support | 1 | 56 | 5
1009 | Finance | 3 | 6 | 5
1009 | Development | 2 | 5 | 1
1009 | Development | 500 | 700 | 700
3900 | MD | 77 | 23 | 29
3900 | MD | 55 | 33 | 44
3900 | Development | 99 | 66 | 99
3900 | Development | 7 | 8 | 9
1100 | Finance | 54 | 67 | 7
1006 | Development | 76 | 8 | 78
1006 | Finance | 34 | 44 | 65
1006 | Finance | 22 | 28 | 7
1006 | MD | 9 | 110 | 21
1006 | MD | 45 | 34 | 8
1007 | MD | 78 | 78 | 8
1100 | Finance | 54 | 67 | 7
1100 | Finance | 54 | 67 | 7
1100 | MD | 98 | 106 | 99
1100 | MD | 3 | 2 | 3
1100 | Development | 101 | 101 | 101
1100 | Development | 6 | 4 | 3
Spreadsheet: 2d2e5ac0-5f49-4a14-9097-979a24c3c20c
Sheet: Sheet1

SAN ANTONIO INDEPENDENT SCHOOL DISTRICT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
SERVER PURCHASE REQUEST FORM
This form must be completed before submitting a request to purchase systems that will operate as servers within SAISD.  Fax request to (210) 886-9478 Attn: [NAME], Director of Network and Technical Services or  [NAME] to [EMAIL] (Signature must be included).
POINT OF CONTACT INFORMATION
First/Last Name: |  |  |  |  |  |  |  |  |  | Title:
Campus/Department: |  |  |  |  |  |  |  |  |  | Phone:
SERVER INFORMATION
Purpose of Server/Application:
Brand/Model: |  |  |  |  |  |  |  |  |  |  | Operating System:
Location of Server (Building/Room#):
Who will Install and Configure?:
Who will Manage and Maintain?:
NETWORK INFORMATION
What type of traffic will the server generate (data, graphics, video, etc.)
Will access be required from outside SAISD? |  |  |  |  |  |  |  |  |  |  | Yes |  |  | No
Will server management be required from outside SAISD? |  |  |  |  |  |  |  |  |  |  | Yes |  |  | No
 | If Yes, VPN Account Request Form will need to be submitted.
Will a static IP address be required? |  |  |  |  |  |  | Yes |  | No
Are any ports required to be opened? |  |  |  |  |  |  | Yes |  | No | If Yes, Specify: ___________
Will a DNS entry be required? |  |  |  |  |  |  | Yes |  | No | If Yes, Specify: ______________________
Signature of Requestor: |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Network and Technical Services Use Only
SPECIAL REQUIREMENTS
Date Received: |  |  |  |  |  |  |  | Analyst Assigned:
Approved: |  |  | Not Approved: |  |  |  |  | Reason:
Will the server be installed in an existing or new [NAME]?
 |  | If new [NAME], explain where will it be installed?
Will the server be installed to an existing or a new UPS?
 |  | Specify Brand and Model # of UPS Unit:
Will the server need special electrical requirements? |  |  |  |  |  |  |  |  |  |  | Yes |  |  | No
 |  | If Yes, explain?
IP Address: |  |  |  |  |  |  |  | DNS Entry:
Subnet Mask: |  |  |  |  |  |  |  | Ports Opened:
Gateway:
Spreadsheet: 376514d1423619473-need-help-finding-a-formula-to-give-me-the-weekly-results-in-a-range-and-start-end-dates-1recordslogtest
Sheet: Sheet1

DAILY RECORDS LOG |  |  |  |  |  | Week | Daily Weight | Weekly |  |  |  |  | today=
Date | Weight | Protein | Carbs | Fat | Calories | Number | Change | change
2015-02-20 00:00:00 | 221 | 16 | 40.2 | 5 | 2345
2015-02-19 00:00:00 | 222 | 112.2599999999999 | 57.4 | 60.69999999999999 | 2345
2015-02-18 00:00:00 | 222 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12
2015-02-17 00:00:00 | 222.5 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12 |  |  |  |  | weeks | from | to | weight change
2015-02-16 00:00:00 | 222 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12 |  |  |  |  | week 1 | 2015-01-20 00:00:00 | 2015-01-26 00:00:00 | -2.5
2015-02-15 00:00:00 | 222.5 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12 |  |  |  |  | week 2 | 2015-01-27 00:00:00 | 2015-02-02 00:00:00 | -2.5
2015-02-14 00:00:00 | 222.5 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12 |  |  |  |  | week 3 | 2015-02-03 00:00:00 | 2015-02-09 00:00:00 | -4
2015-02-13 00:00:00 | 222 | 16 | 40.2 | 5 | 290 |  |  |  |  | week 4 | 2015-02-10 00:00:00 | 2015-02-16 00:00:00 | -1
2015-02-12 00:00:00 | 223 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12 |  |  |  |  | week 5 | 2015-01-27 00:00:00 | 2015-02-02 00:00:00 | -1
2015-02-11 00:00:00 | 223 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12
2015-02-10 00:00:00 | 223.5 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12
2015-02-09 00:00:00 | 223 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12
2015-02-08 00:00:00 | 224.5 | 109.26 | 55.4 | 56.7 | 2554
2015-02-07 00:00:00 | 225 | 109.26 | 55.4 | 56.7 | 2676
2015-02-06 00:00:00 | 225.5 | 109.26 | 55.4 | 56.7 | 2543
2015-02-05 00:00:00 | 225 | 109.26 | 55.4 | 56.7 | 2654
2015-02-04 00:00:00 | 226 | 109.26 | 55.4 | 56.7 | 2543
2015-02-03 00:00:00 | 226 | 109.26 | 55.4 | 56.7 | 2675
2015-02-02 00:00:00 | 227 | 109.26 | 55.4 | 56.7 | 2564
2015-02-01 00:00:00 | 227 | 109.26 | 55.4 | 56.7 | 2564
2015-01-31 00:00:00 | 227.5 | 109.26 | 55.4 | 56.7 | 2564
2015-01-30 00:00:00 | 228.5 | 109.26 | 55.4 | 56.7 | 2564
2015-01-29 00:00:00 | 228 | 109.26 | 55.4 | 56.7 | 2564
2015-01-28 00:00:00 | 228.5 | 109.26 | 55.4 | 56.7 | 2564
2015-01-27 00:00:00 | 229 | 109.26 | 55.4 | 56.7 | 2564
2015-01-26 00:00:00 | 229.5 | 109.26 | 55.4 | 56.7 | 2564
2015-01-25 00:00:00 | 230 | 109.26 | 55.4 | 56.7 | 2564
2015-01-24 00:00:00 | 230 | 109.26 | 55.4 | 56.7 | 2564
2015-01-23 00:00:00 | 230.5 | 109.26 | 55.4 | 56.7 | 2564
2015-01-22 00:00:00 | 231 | 109.26 | 55.4 | 56.7 | 2564
2015-01-21 00:00:00 | 230.5 | 109.26 | 55.4 | 56.7 | 2564
2015-01-20 00:00:00 | 232 | 109.26 | 55.4 | 56.7 | 2564
Spreadsheet: 24486d1214921349-plotting-with-3-columns-data-x-y-and-values-plot
Sheet: plot

x | y | z
1 | 1 | 0.191850392857143
1 | 2 | 0.343870875
1 | 3 | 0.373216464285714
1 | 4 | 0.439175392857143
2 | 1 | 0.0218835357142857
2 | 2 | 0.136193589285714
2 | 3 | 0.146259946428571
2 | 4 | 0.181633303571429
 |  | x
 |  | 1 | 2
 | 1 | 0.191850392857143 | 0.0218835357142857
y | 2 | 0.343870875 | 0.136193589285714
 | 3 | 0.373216464285714 | 0.146259946428571
 | 4 | 0.439175392857143 | 0.181633303571429
Spreadsheet: 751371d1634062674-highlight-or-list-volunteers-who-having-been-assigned-volunteer-schedule
Sheet: Locations

 |  |  | Monday [NAME] | Tuesday [NAME] | Wednesday [NAME] | Thursday [NAME] | Friday [NAME]
 | Location 1 |  | Volunteer 2 | Volunteer 10 | Volunteer 1 | Volunteer 9 | Volunteer 7
 | Location 2 |  | Volunteer 16 |  | Volunteer 4
 | Location 3 |  |  |  |  |  | Volunteer 8
 | Location 4 |  |  | Volunteer 7 | Volunteer 3
 | Location 5 |  |  |  |  |  | Volunteer 13
 | Location 6
 | Location 7 |  |  | Volunteer 16
 | Location 8
 | Location 9
 | Location 10
 | Location 11
 | Location 12
 | Location 13
 |  |  | Mon Volunteers Unused | Tue Volunteers Unused | Wed Volunteers Unused | Thur Volunteers Unused | Fri Volunteers Unused
Spreadsheet: 138226d1327578110-help-with-min-max-formula-vsum-min-max
Sheet: Sheet2

Budget line | Max PO Value | Min PO Value | Mode |  |  | SUMIF…………..
1005 | 0 | 0 | 0 |  |  | 1005 | 0
1006 | 0 | 0 | 0 |  |  | 1006 | 0
1010 | 0 | 0 | 0 |  |  | 1010 | 4743249.390000001
1018 | 0 | 0 | 0 |  |  | 1018 | 0
1022 | 0 | 0 | 0 |  |  | 1022 | 1680852.87
1028 | 0 | 0 | 0 |  |  | 1028 | 0
1034 | 0 | 0 | 0 |  |  | 1034 | 291652.38
1042 | 0 | 0 | 0 |  |  | 1042 | 0
Spreadsheet: 37829d1235904432-help-with-formula-book1
Sheet: Sheet1

naziv | vrijednost | najveca vrijednost
s | 4 | 4
a | 5 | 5
a | 3 | 5
a | 1 | 5
b | 5 | 5
b | 2 | 5
g | 6 | 6
g | 3 | 6
f | 7 | 7
f | 4 | 7
d | 8 | 8
d | 6 | 8
d | 4 | 8
q | 9 | 9
q | 2 | 9
Spreadsheet: 860461d1708540638-splitting-names-in-a-cell-and-take-corresponding-values-testbook-dj
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total |  | Site | Year | Month | Quarter | Byline | Count
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  | site, year, month, quarter, should auto populate |  |  |  |  | 100 |  | The formula in column Q slows down when there's lots of data. It also correctly splits the names which have a , in between them along with the values. but I want the corresponding site name, year, month and quarter to display too.
Red | 2020 | Dec | Q4 | [NAME] | 90 | External |  |  |  |  |  |  |  |  | [NAME] | 90
Red | 2020 | Dec | Q1 | [NAME] | 80 | External |  |  |  |  |  |  |  |  | [NAME] | 80
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal |  |  |  |  |  |  |  |  | [NAME] | 70
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External |  |  |  |  |  |  |  |  | [NAME] | 60
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal |  |  |  |  |  |  |  |  | [NAME] | 50
Yellow | 2020 | Dec | Q2 | Mark | 60 | External |  |  |  |  |  |  |  |  | Mark | 60
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal |  |  |  |  |  |  |  |  | [NAME] | 70
Blue | 2020 | Dec | Q4 | Mark | 81 | External |  |  |  |  |  |  |  |  | Mark | 81
Green | 2020 | Dec | Q4 | [NAME] | 91 | Internal |  |  |  |  |  |  |  |  | [NAME] | 91
Green | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  |  |  |  |  | [NAME] | 100
Green | 2023 | Jan | Q1 | [NAME], [NAME] | 2 | Internal |  |  |  |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
 | 2020 | Dec | Q4 | [NAME] | 100 | Internal | 100 | 0 | 100 |  |  |  |  |  | [NAME] | 100
Red | 2020 | Dec | Q4 | [NAME] | 90 | External | 0 | 90 | 90 |  |  |  |  |  | [NAME] | 90
Red | 2020 | Dec | Q1 | [NAME] | 80 | External | 0 | 80 | 80 |  |  |  |  |  | [NAME] | 80
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal | 70 | 0 | 70 |  |  |  |  |  | [NAME] | 70
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External | 0 | 60 | 60 |  |  |  |  |  | [NAME] | 60
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal | 50 | 0 | 50 |  |  |  |  |  | [NAME] | 50
Yellow | 2020 | Dec | Q2 | Mark | 60 | External | 0 | 60 | 60 |  |  |  |  |  | Mark | 60
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal | 70 | 0 | 70 |  |  |  |  |  | [NAME] | 70
Blue | 2020 | Dec | Q4 | Mark | 81 | External | 0 | 81 | 81 |  |  |  |  |  | Mark | 81
Green | 2020 | Dec | Q4 | [NAME] | 91 | Internal | 91 | 0 | 91 |  |  |  |  |  | [NAME] | 91
Green | 2020 | Dec | Q4 | [NAME] | 100 | Internal | 100 | 0 | 100 |  |  |  |  |  | [NAME] | 100
Green | 2023 | Jan | Q1 | [NAME] | 2 | Internal | 2 | 0 | 2 |  |  |  |  |  | [NAME] | 2
Green | 2023 | Jan | Q1 | [NAME] | 2 | Internal | 2 | 0 | 2 |  |  |  |  |  | [NAME] | 2
Spreadsheet: 807085d1669733876-calculate-sum-each-month-based-on-two-variables-sales-team-goals-asm-commission-calculator-2023
Sheet: Team Seth

SALES TEAM | Team Seth
Row Labels | Sum of JAN | Sum of FEB | Sum of MAR | Sum of APR | Sum of MAY | Sum of JUN | Sum of JUL | Sum of AUG | Sum of SEP | Sum of OCT | Sum of NOV | Sum of DEC
[NAME] | 420 | 657 | 346 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1850 | 2115 | 3010 | 1926 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1110 | 2100 | 2900 | 1230 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1211 | 3245 | 1335 | 575 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total | 4591 | 8117 | 7591 | 3731 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SALES TEAM | Team Seth
SALES PERSON | Sum of JAN | Sum of FEB | Sum of MAR | Sum of APR | Sum of MAY | Sum of JUN | Sum of JUL | Sum of AUG | Sum of SEP | Sum of OCT | Sum of NOV | Sum of DEC
[NAME] | 0 | 0 | 0 | 0
[NAME] | 5 | 8 | 17 | 6
[NAME] | 7 | 6 | 10 | 4
[NAME] | 7 | 9 | 4 | 3
Grand Total | 19 | 23 | 31 | 13
Spreadsheet: 110354d1307038353-if-function-book1
Sheet: Sheet1

Date | Full Name | Science | SS | Reading | Math | Writing
2010-08-23 00:00:00 | [NAME] | 590 | 580 | 630
2011-03-08 00:00:00 | [NAME] | 590 | 680 | 630 | 550 | 590
2011-03-24 00:00:00 | [NAME] | 525
2011-03-28 00:00:00 | [NAME] |  |  |  | 510
2009-09-21 00:00:00 | [NAME] | 470 | 650 | 490 | 420
2009-10-21 00:00:00 | [NAME] |  |  |  | 390
2011-04-26 00:00:00 | [NAME] | 500 | 520 | 470
2011-04-27 00:00:00 | [NAME] |  |  |  | 410
2011-04-28 00:00:00 | [NAME] |  |  |  |  | 490
2011-05-16 00:00:00 | [NAME] |  |  |  | 390
2011-05-19 00:00:00 | [NAME] | 500 | 440 | 470
2011-05-23 00:00:00 | [NAME] |  |  |  | 530 | 500
2011-05-26 00:00:00 | [NAME] |  | 460 | 450
2011-05-26 00:00:00 | [NAME] amber |  |  |  |  | 530
2011-03-29 00:00:00 | [NAME] |  | 250
2011-05-24 00:00:00 | [NAME] |  | 500 |  | 395
2011-04-28 00:00:00 | [NAME] |  |  | 400
2011-04-18 00:00:00 | Aiken [NAME] | 510 |  | 480
2011-03-01 00:00:00 | [NAME] | 480 | 550 | 500
2011-03-03 00:00:00 | [NAME] |  |  |  | 410
2010-10-27 00:00:00 | [NAME] |  |  |  | 350
2010-11-02 00:00:00 | [NAME] | 450
2010-11-04 00:00:00 | [NAME] |  | 550 | 540
2010-11-09 00:00:00 | [NAME] | 460
2010-11-02 00:00:00 | [NAME] Amanda | 490 | 570 | 500 | 460
2010-11-11 00:00:00 | [NAME] Amanda |  |  |  |  | 530
2010-11-15 00:00:00 | [NAME] Amanda |  |  |  | 430
2010-11-22 00:00:00 | [NAME] Amanda | 570
2011-03-29 00:00:00 | [NAME] Amanda |  |  |  | 440
2009-07-10 00:00:00 | [NAME] | 450 | 430 | 480 | 450
2010-04-19 00:00:00 | [NAME] |  |  | 410 | 400
2010-09-09 00:00:00 | [NAME] | 440