tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: judy_townsend__17724__Spinnake03-002 Revision_1
Sheet: Recap

 |  | SPINNAKER EXPLORATION COMPANY LLC
 | Point Name |  |  |  | BaseLoad | Swing | [NAME] | Total
 |  |  |  |  |  |  |  |  | 7372.94
 |  |  |  |  |  |  |  |  | 202059.95
 | GALVESTON ISLE 249-L |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 1057599.63
 | VERMILLION 376/375 |  |  |  |  |  |  |  | 1549859.57
 |  |  |  |  |  |  |  |  | 677005.19
 |  |  |  |  |  |  |  |  | 307628.42
REVISED |  |  |  |  |  |  |  |  | 4588387.5
 |  |  | A-1 & B-1 |  |  |  |  |  | 921659.28
 |  |  |  |  |  |  |  |  | 180962.63
 | Demand Charge |  |  |  |  |  |  | 0
 | Net Payable - Spinnaker
 |  |  |  |  |  |  | Amount PAID | 13845097.59
 |  |  |  |  |  |  | AMOUNT DUE SEC
Spreadsheet: 760373d1640185371-list-missing-number-in-a-sequence-to-another-row-horizontaly-book5-2-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Record | Record2 | Record3 | Record4 | Record5 | Record6 | Record7 | Record8 | Record9 | Record10 | Record11 | Record12 | Record13 | Record14 | Record15 | Record16 | Record17 | Record18 | Record19 | Record20 | Record21 | Record22 | Record23 | Record24 | Record25 | Record26 | Record27 | Record28 | Record29 | Record30 | Record31 | Record32 | Record33 | Record34 | Record35 | Record36 | Record37 | [NAME] | Record39 | Record40 | Record41 | Record42 | Record43 | Record44 | Record45 | Record46 | Record47 | Record48 | Record49 | Record50 | Missing | Missing2 | Missing3 | Missing4 | Missing5 | Missing6 | Missing7 | Missing8 | Missing9 | Missing10 | Missing11 | Missing12 | Missing13 | Missing14 | Missing15 | Missing16 | Missing17 | Missing18 | Missing19 | Missing20 | Missing21 | Missing22 | Missing23 | Missing24 | Missing25 | Missing26 | Missing27 | Missing28 | Missing29 | Missing30 | Missing31 | Missing32 | Missing33 | Missing34 | Missing35 | Missing36 | Missing37 | Missing38 | Missing39 | Missing40 | Missing41 | Missing42 | Missing43 | Missing44 | Missing45 | Missing46 | Missing47 | Missing48 | [NAME] | Missing50
 |  |  |  |  |  |  |  |  |  | 1003 | 1004 | 1004 | 1006 | 1007 | 1008 | 1009 | 1010 | 1011 | 1012 | 1013 | 1014 | 1015 | 1016 | 1017 | 1018 | 1019 | 1020 | 1021 | 1022 | 1023 | 1024 | 1025 | 1026 | 1027 | 1028 | 1029 | 1030 | 1031 | 1032 | 1033 | 1034 | 1035 | 1036 | 1037 | 1038 | 1039 | 1040 | 1041 | 1042 | 1043 | 1044 | 1045 | 1046 | 1047 | 1048 | 1049 | 1050
 |  |  |  |  |  |  |  |  |  | 55 | 55 | 51 | 56 | 52 | 58
Spreadsheet: 269535d1381190344-understanding-mod-function-excelforum-3-
Sheet: Sheet 2

Date | Time | Open | High | Low | Close | Volume |  | Date | Time | Open | High | Low | Close | Volume
 |  |  | 90.7 | 90.64 |  | 2176
 |  |  | 91.29 | 90.64 | 91.21 | 2388
 | 18 |  | 91.22 | 89.46 | 90.68 | 1990
2009-01-02 00:00:00 | 0
Spreadsheet: 54943d1254992689-a-formula-to-work-out-different-sums-in-one-column-sample
Sheet: Sheet1

 |  |  |  |  | 2009-02-01 00:00:00 |  | 5
 | Month | Cash | Credit | Sums |  | 2009-01-01 00:00:00 | ***The Figures in blue in the 'Sums' column, are the expected result of the required formula in column "E"
 | 2009-01-01 00:00:00 | 100 |  | 125 | ←Month Credit | 2009-02-01 00:00:00
 |  | 80 | 75 |  |  | 2009-03-01 00:00:00
 |  |  |  | 425 | ←Month Total | 2009-04-01 00:00:00
 |  | 120 | 50 | 425 | ←Progressive Total | 2009-05-01 00:00:00 | As an example,For March,"Month Credit" is equal to SUM(D18:D21), "Month Total" is SUM(C18:D21), Progressive Total is SUM(C10:D21), and so on for the rest of the months oh the year
 | 2009-02-01 00:00:00 |  |  | 105 | ←Month Credit | 2009-06-01 00:00:00
 |  | 95 | 65 |  |  | 2009-07-01 00:00:00
 |  | 95 |  | 385 | ←Month Total | 2009-08-01 00:00:00
 |  | 90 | 40 | 810 | ←Progressive Total | 2009-09-01 00:00:00
 | 2009-03-01 00:00:00 | 70 |  | 75 | ←Month Credit | 2009-10-01 00:00:00
 |  | 130 | 45 |  |  | 2009-11-01 00:00:00
 |  |  | 30 | 335 | ←Month Total | 2009-12-01 00:00:00 | Calculations to start from the chosen month [in cell 'F7' till the end of December, Cell '[NAME].This is impotant mainly for the progressive sum to be calculated from a particular month
 |  | 60 |  | 1145 | ←Progressive Total
 | 2009-04-01 00:00:00 |  |  | 120 | ←Month Credit
 |  | 50 | 80
 |  |  | 40
 |  | 112 |  | 282 | ←Month Total
 |  |  |  | 1427 | ←Progressive Total
 | 2009-05-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  |  |  | Or, If we ignore cell 'F7' altogether [i.e. no particular month to be selected], can we have one single formula to give us the sums in column E ,and save us the trouble of having to use 3 different formulas for each month {that is 36 formulas for the whole year} !!
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-06-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-07-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-08-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-09-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-10-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-11-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-12-01 00:00:00 |  |  |  | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
Spreadsheet: andy_zipper__128__DYNEGY-ICE VOL Jun7
Sheet: E-Mail

 | 2001-06-07 00:00:00
 | Intercontinental Exchange |  |  |  | Enron's Activity on ICE
 | Commodity | ICE Volume | EOL US Volume (approx) |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  |  | ECC
 | TOTAL CRUDE PRODUCTS (BBL)
 |  |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  |  | EPM | POWER
 |  |  |  |  | ENA | POWER
 |  |  |  |  | ENA | US NATURAL GAS
 |  |  |  |  | ENA | COAL
 |  |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: 867282d1714127056-looking-for-shortcut-to-put-all-tab-names-on-one-tab-plus-data-template-empty
Sheet: Company Name 4

 |  |  |  |  |  | Company Name 4
 |  | Month ending
 |  | Enter month
 | Date | Invoice number | Total | Materials | Labour | Tax | [NAME] | Payable
 |  | Totals
[NAME]
Company No. 06977736
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 2

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 0 | 0 | 10 | 14 | 5 | 9.666666666666666 | 29
CONFLICTS | 0 | 18 | 0 | 0 | 0 | 18 | 18
ID'S | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ISA | 0 | 176 | 266 | 269 | 241 | 238 | 952
Spreadsheet: 817976d1676535200-lookup-nth-instance-and-return-offset-cell-excel-eg-file
Sheet: Sheet1

 | Original Results |  |  |  |  | Required Results
 | [NAME]
 | Earned | From | Date |  |  |  | Earned | From | Date
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4 |  | ABC | 2022-07-31 13:47:26
5 |  |  |  |  |  | 5 |  | SSW | 2022-07-31 13:49:28
6 |  |  |  |  |  | 6 |  | SSW | 2022-07-31 13:50:07
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
9 |  |  |  |  |  | 9 |  | S86 | 2022-08-02 13:52:11
10 |  |  |  |  |  | 10 |  | J13 | 2022-08-04 14:03:03
11 |  |  |  |  |  | 11 |  | J33 | 2022-08-04 14:55:12
12 |  |  |  |  |  | 12 |  | SSW | 2022-07-31 13:29:33
13 |  |  |  |  |  | 13 |  | SSW | 2022-07-31 13:34:50
14 |  |  |  |  |  | 14 |  | SSW | 2022-07-31 13:35:29
15 |  |  |  |  |  | 15 |  | SSW | 2022-07-31 13:44:48
16 |  |  |  |  |  | 16 |  | SSW | 2022-07-31 13:45:46
17 |  |  |  |  |  | 17 |  | SSW | 2022-07-31 13:46:47
18 |  |  |  |  |  | 18 |  | SSW | 2022-07-31 13:48:21
19 |  |  |  |  |  | 19 |  | B77 | 2022-07-31 14:33:15
20 |  |  |  |  |  | 20 |  | k85 | 2022-07-31 14:37:09
21 |  |  |  |  |  | 21 |  | S23 | 2022-07-31 15:36:37
22 |  |  |  |  |  | 22 |  | Bar | 2022-07-31 15:43:26
23 |  |  |  |  |  | 23 |  | Bar | 2022-07-31 15:43:37
24 |  |  |  |  |  | 24 |  | Bar | 2022-07-31 15:43:49
25 |  |  |  |  |  | 25 |  | Bar | 2022-07-31 15:45:15
26 |  |  |  |  |  | 26 |  | D34 | 2022-08-02 13:56:22
27 |  |  |  |  |  | 27 |  | Ber | 2022-08-04 16:27:25
28 |  |  |  |  |  | 28 |  | D10 | 2022-08-04 19:36:52
29 |  |  |  |  |  | 29 |  | w21 | 2022-08-04 20:13:33
30 |  |  |  |  |  | 30 |  | RIV | 2022-08-05 04:54:40
Spreadsheet: 600097d1543463487-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T3 PD

First name | Surname | ID number | Institution | Department | Email address | Assignment: Professionalism | Attendance: Attendance | Assignment: Composite | Assignment: Advanced Sketchup | Assignment: Making a Brick | Assignment: Build a Paper Set | Assignment: Poster | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 85 | 100 | 80 | 80 | - | 85 | 92 | 77.55
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 70 | 92.86 | 75 | - | - | - | 85 | 47.29
Muxin | [NAME] |  |  |  | [EMAIL] | 80 | 78.57 | 85 | 80 | - | 92 | - | 62.41
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 85 | 100 | - | - | - | 92 | - | 40.8
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 80 | 0 | 92 | 80 | - | 88 | 82 | 67.3
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 70 | 92.86 | - | - | - | - | - | 23.29
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 90 | 100 | 95 | 90 | - | 95 | 85 | 82.75
Yichao | Fu |  |  |  | [EMAIL] | 80 | 100 | - | 60 | - | 82 | 86 | 60.2
Junjie (Riol) | He |  |  |  | [EMAIL] | 85 | 92.86 | 78 | 85 | - | 90 | - | 64.24
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 85 | 100 | 90 | 85 | - | 93 | 92 | 81
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 80 | 71.43 | 75 | 80 | - | 95 | - | 60.64
[NAME]) | [NAME] |  |  |  | [NAME] | 85 | 78.57 | - | - | - | - | - | 24.86
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 85 | 85 | - | 85 | 91 | 79.9
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 80 | 78.57 | - | - | - | - | - | 23.86
[NAME]) | [NAME] |  |  |  | [EMAIL] | 80 | 100 | 75 | 75 | - | - | 90 | 62
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 85 | 85.71 | 85 | 85 | 80 | - | 88 | 72.27
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 85 | 92.86 | - | 70 | 75 | 78 | - | 55.99
[NAME]） | Xiao |  |  |  | [EMAIL] | 85 | 100 | 80 | 90 | - | 90 | 90 | 79.5
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 0 | 0 | - | - | - | - | - | 0
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 80 | 100 | 75 | 85 | - | 89 | - | 63.35
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 85 | 100 | 92 | 80 | - | 92 | 88 | 79.8
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 78 | 80 | - | 90 | 88 | 78.4
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 85 | 90 | - | 95 | 90 | 82
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 80 | 85.71 | - | - | - | 92 | - | 38.37
Spreadsheet: 689121d1596131966-assign-unique-value-to-a-state-of-repeating-cycle-book2
Sheet: Book2

Time (minutes) | State | Value I want | Value MOST IDEAL | Value I am getting with Countif
1 | A | 1 | 1.1 | 1 | 1
2 | A
3 | A
4 | A
5 | B | 1 | 1.2 | 1
6 | B
7 | C | 1 | 1.3 | 1
8 | C
9 | C
10 | A | 2 | 2.1 | 5
11 | A
12 | A
13 | A
14 | B | 2 | 2.2 | 3
15 | B
16 | C | 2 | 2.3 | 4
17 | D
18 | C
 | D
 | F
 | A
 | A
 | A
 | C
 | C
 | C
 | C
 | A
 | A
 | A
 | A
 | A
Spreadsheet: 227804d1365818192-help-populating-a-calendar-with-entries-from-multiple-tabs-example-inventory-sheet
Sheet: Calendar

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 1
2 |  |  |  |  |  |  |  |  | Year | 2011
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
Spreadsheet: 2997fdd7-9e10-4c36-aad8-992f810c1ab1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 185 |  |  |  | 185
 | ALLEGHENY |  |  |  | 4875 | 4875
 | ARMSTRONG |  |  |  | 447 | 447
 | BEAVER |  |  |  | 833 | 833
 | BEDFORD |  |  |  | 321 | 321
 | BERKS | 1073 |  |  |  | 1073
 | BLAIR |  |  |  | 665 | 665
 | BRADFORD |  |  | 172 |  | 172
 | BUCKS |  | 1784 |  |  | 1784
 | BUTLER |  |  |  | 832 | 832
 | CAMBRIA |  |  |  | 1220 | 1220
 | CAMERON |  |  |  | 46 | 46
 | CARBON |  |  | 223 |  | 223
 | CENTRE | 345 |  |  | 139 | 484
 | CHESTER |  | 916 |  |  | 916
 | CLARION |  |  |  | 229 | 229
 | CLEARFIELD |  |  |  | 778 | 778
 | CLINTON |  |  | 134 |  | 134
 | COLUMBIA | 211 |  |  |  | 211
 | CRAWFORD |  |  |  | 506 | 506
 | CUMBERLAND | 386 |  |  |  | 386
 | DAUPHIN | 564 |  |  |  | 564
 | DELAWARE |  | 1948 |  |  | 1948
 | ELK |  |  |  | 320 | 320
 | ERIE |  |  |  | 1982 | 1982
 | FAYETTE |  |  |  | 964 | 964
 | FOREST |  |  |  | 32 | 32
 | FRANKLIN | 348 |  |  |  | 348
 | FULTON | 48 |  |  |  | 48
 | GREENE |  |  |  | 295 | 295
 | HUNTINGDON |  |  |  | 264 | 264
 | INDIANA |  |  |  | 577 | 577
 | JEFFERSON |  |  |  | 309 | 309
 | JUNIATA | 82 |  |  |  | 82
 | [NAME] |  |  | 522 |  | 522
 | LANCASTER | 823 |  |  |  | 823
 | [NAME] |  |  |  | 547 | 547
 | LEBANON | 218 |  |  |  | 218
 | LEHIGH | 803 |  |  |  | 803
 | LUZERNE |  |  | 878 |  | 878
 | LYCOMING |  |  | 203 |  | 203
 | MCKEAN |  |  |  | 233 | 233
 | MERCER |  |  |  | 599 | 599
 | MIFFLIN | 223 |  |  |  | 223
 | MONROE |  |  | 422 |  | 422
 | MONTGOMERY |  | 2173 |  |  | 2173
 | MONTOUR | 25 |  |  |  | 25
 | NORTHAMPTON | 544 |  |  |  | 544
 | NORTHUMBERLAND | 296 |  |  |  | 296
 | PERRY | 141 |  |  |  | 141
 | PHILADELPHIA |  | 8679 |  |  | 8679
 | PIKE |  |  | 137 |  | 137
 | POTTER |  |  |  | 156 | 156
 | SCHUYLKILL | 377 |  |  |  | 377
 | SNYDER | 92 |  |  |  | 92
 | [NAME] |  |  |  | 639 | 639
 | SULLIVAN |  |  | 20 |  | 20
 | SUSQUEHANNA |  |  | 214 |  | 214
 | TIOGA |  |  | 155 |  | 155
 | UNION | 72 |  |  |  | 72
 | VENANGO |  |  |  | 349 | 349
 | WARREN |  |  |  | 230 | 230
 | WASHINGTON |  |  |  | 972 | 972
 | WAYNE |  |  | 145 |  | 145
 | WESTMORELAND |  |  |  | 2095 | 2095
 | WYOMING |  |  | 73 |  | 73
 | YORK | 695 |  |  |  | 695
 | Totals | 7551 | 15500 | 3298 | 21454 | 47803
Spreadsheet: 884007d1732872967-if-more-than-3-if-more-than-3
Sheet: Sheet1

Count All | Result |  |  | Result
5 |  |  |  | 2-3
18 |  |  |  | 4-5
1 |  |  |  | 6-7
7 |  |  |  | Above 7
4
8
1
8
8
18
8
8
8
8
8
1
2
2
1
1
3
2
1
1
1
5
1
1
2
3
4
4
1
7
3
18
1
1
1
6
1
1
2
3
1
5
18
1
3
1
2
14
1
4
1
2
18
3
1
1
0
4
2
2
1
4
2
1
1
1
1
1
4
3
8
8
1
1
1
2
1
6
6
1
3
4
10
1
3
1
1
1
1
1
1
5
3
10
1
1
18
2
1
1
1
4
4
1
3
1
0
1
18
10
1
4
2
1
7
2
4
3
3
1
2
2
4
1
3
4
5
1
3
7
18
18
3
6
1
18
1
5
18
1
1
7
7
1
14
1
18
19
1
1
1
19
1
1
9
4
0
0
0
1
0
3
2
2
4
2
4
6
3
1
1
2
1
1
1
1
14
1
1
1
1
1
1
2
1
5
5
13
5
1
1
6
5
2
6
18
18
1
6
3
3
7
2
3
1
1
1
4
9
1
13
13
1
13
1
2
2
2
1
19
6
1
1
7
1
7
2
7
7
1
1
3
1
4
18
1
1
14
2
4
2
1
1
2
7
2
1
3
8
1
8
19
1
1
7
7
14
3
7
5
1
14
18
7
7
1
2
2
19
1
8
3
1
1
4
1
14
14
2
9
1
4
1
14
2
18
1
5
18
1
4
1
2
4
4
2
1
3
14
9
4
5
1
7
1
18
2
1
4
1
11
1
3
2
6
1
18
6
10
11
2
13
3
1
9
4
1
1
5
1
6
18
1
2
3
2
3
1
14
1
1
6
1
10
5
13
6
10
10
7
10
10
18
6
14
1
1
10
3
2
7
9
8
6
9
18
19
18
8
8
3
18
13
3
11
2
3
6
1
2
18
1
3
3
2
2
9
1
1
11
9
10
10
2
5
1
18
18
6
5
1
3
7
1
11
18
1
8
2
14
3
2
18
3
2
2
14
3
7
4
18
2
6
10
7
14
14
18
6
18
1
5
19
2
9
18
13
13
4
3
11
7
5
14
2
4
13
10
5
19
3
3
1
3
8
1
8
19
3
8
1
2
11
1
2
2
3
13
1
1
2
1
3
18
1
1
9
11
5
1
1
1
18
3
10
4
13
5
3
2
1
2
1
1
1
8
1
3
2
2
8
5
6
8
11
3
2
2
14
3
7
3
1
3
3
6
1
14
2
1
1
2
3
1
8
1
10
8
18
19
9
1
1
18
3
3
3
1
2
2
2
8
3
3
9
1
18
3
11
1
19
11
5
2
14
1
5
1
1
1
11
13
18
18
10
18
1
1
9
6
1
2
1
1
4
1
1
2
14
18
8
19
1
4
2
1
14
3
2
1
3
3
1
1
1
2
2
18
1
6
14
1
7
1
1
10
1
10
2
1
1
2
1
7
1
18
2
19
7
14
1
8
1
18
19
2
8
2
1
10
2
1
4
11
3
5
3
5
3
1
8
3
5
1
18
2
1
2
14
11
1
2
14
1
11
2
1
8
19
18
2
4
1
1
1
18
6
2
1
8
6
2
5
6
11
1
9
4
2
1
8
5
1
1
5
1
1
1
18
3
3
6
5
18
6
8
11
1
11
2
2
2
2
6
5
1
18
5
1
8
11
3
1
6
1
2
1
2
2
14
4
1
9
6
2
1
2
2
1
9
3
2
2
1
5
7
18
4
1
4
11
5
2
1
6
14
8
4
6
7
7
5
6
6
1
1
19
8
4
2
2
2
1
11
4
1
1
19
18
7
2
4
5
5
1
1
1
1
5
3
1
1
3
1
1
3
2
2
5
7
2
8
1
1
4
3
8
3
11
8
3
1
5
9
19
4
1
3
1
1
2
2
1
2
1
3
3
3
2
4
1
1
7
2
2
1
2
1
5
1
5
1
1
4
5
7
3
1
19
Spreadsheet: 677230d1589253171-display-different-types-of-error-if-accurate-results-not-found-on-multiple-match-demo-error-displaying
Sheet: SO

OrderNo | Code |  |  |  |  |  |  |  |  |  |  |  | Crossed |  |  |  |  |  |  |  | Code | [NAME] | UOM | Gross Qty |  |  |  |  |  |  |  |  |  |  | Specification |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Merged
HA/6703 | 360264 |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  | 20062 | LD SHEET | KG | 1500 |  |  |  |  |  |  |  |  |  |  | POLY BAG 10X11. INARUWA
HA/6203 | 360242 |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  | 20032 | REPRO SHEET | KG | 21000 |  |  |  |  |  |  |  |  |  |  | CUTTING
HA/6213 | 360646 |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  | 20070 | HD SHEET | KG | 263.2
HA/6256 | 361341 |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  | 20027 | FABRIC | KG | 250
HA/6039 | 360634 |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  | 20049 | PP GRANULE SALES | KG | 3100 |  |  |  |  |  |  |  |  |  |  | reliance >>w | L
Spreadsheet: 53771d1253698001-use-drop-downs-to-populate-other-drop-downs-practice1
Sheet: Assignment

Assignment 1 | [NAME]
Assignment 2 | [NAME]
Assignment 3 | [NAME]
Assignment 4 | [NAME]
Assignment 5 | [NAME]
Assignment 6 | [NAME]
Assignment 7 | [NAME]
Assignment 8 | [NAME]
Assignment 9 | [NAME]
Assignment 10 | [NAME]
Sunday
Spreadsheet: 377985d1424236171-how-to-lock-cells-in-a-protected-worksheet-analyst-appraisal-form
Sheet: SCORE

 | Calculation Sheet
 | 1) | 2) | 3) | 4) | 5) | 6) | 7) | 8) | 9)
Spreadsheet: 52660d1252508874-lookup-ranges-698650_drreamsurferr
Sheet: RATE

EXAMPLE:
KEY
BC00114-B
PERFORMANCE
100404655.1004 |  | [NAME] | 60202327.5502
CHARGEABLE AMOUNT
100000000 | @ | 0.6 | 60000000 |  |  | For example amounts to 100,000,000 Charged @ rate 1, next 100,000,000 charged @ rate 2, Anything over 200,000,000 charged @ rate 3
404655 | @ | 0.5 | 202327.5
0 | @ | 0.45 | 0
100404655 |  |  | 60202327.5
Spreadsheet: 54248d1254263163-help-setting-up-a-functional-sheet-701195-help-setting-up-a-functional-sheet
Sheet: lookups

EMPL # | NAME
200 7100 | sample 1
200 7112 | sample 2
200 7113 | sample 3
200 7088 | sample 4
200 8103 | sample 5
200 8177 | sample 6
200 7100 | sample 7
200 7098 | sample 8
200 8142 | sample 9
204 0790 | sample 10
206 6631 | sample 11
206 4835 | sample 12
200 7089 | sample 13
200 7438 | sample 14
200 7422 | sample 15
207 0281 | sample 16
200 8178 | sample 17
200 7428 | sample 18
200 7421 | sample 19
200 8143 | sample 20
200 8161 | sample 21
200 8186 | sample 22
200 8184 | sample 23
200 8123 | sample 24
207 0418 | sample 25
200 7421 | sample 26
200 7422 | sample 27
200 7438 | sample 28
207 0639 | sample 29
206 9255 | sample 32
207 0566 | sample 33
207 0417 | sample 34
207 0639 | sample 35
207 0638 | sample 36
207 0418 | sample 37
Spreadsheet: 872584d1718959697-dashboard-with-tables-linking-to-specific-person-90paulwilson-hr-dashboard-anon-aligw
Sheet: Data

Absences
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | January | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | January |  |  |  | Commissioning Error
 |  | February | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 |  |  | February |  |  | [NAME] | Customer Service
 |  | March | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | March |  |  | [NAME] | Customer Service
 |  | April | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  | April |  |  | [NAME] | Customer Service
 |  | May | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 |  |  | May |  |  | [NAME] | Install Error
 |  | June | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |  |  | June |  |  | [NAME] | Install Error
 |  | July | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 2 |  |  | July |  |  | [NAME] | Service Error
 |  | August | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 |  |  | August
 |  | September | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | September
 |  | October | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 |  |  | October
 |  | November | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  |  | November
 |  | December | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |  |  | December
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 84444d1284495182-excel-2007-vlookup-for-additional-factor-in-the-table-andy9988
Sheet: Sheet1

PARENTS |  | 100000 | 2031 |  |  | Age | Table
SELF | 26 | 150000 | 2976 |  |  | 0 | _0_35Yrs
SPOUSE | 24 | 200000 | 3827 |  |  | 36 | _36_45Yrs
CHILDREN |  | 250000 | 4582 |  |  | 46 | _46_50Yrs
CHILD 1 | 1 | 300000 | 5338 |  |  | 51 | _51_55Yrs
CHILD 2 | 1 | 350000 | 5999 |  |  | 56 | _56_60Yrs
CHILD 3 | 0 | 400000 | 6660 |  |  | 61 | _61_65Yrs
CHILD 4 | 0 | 450000 | 7321 |  |  | 66 | _66_70Yrs
 |  | 500000 | 7984
Adult | 2
Child | 2 |  | Problem
[NAME] | 26 |  | I had used the Above formula for finding the premium, but I am not being able to develop a formula when I have more than 2 child in calucation.
Total | 4
Table Row | 2A + 2C
Table | _0_35Yrs
Add Child | 0
 |  |  | Calculation Method
 |  |  | Step 1 | Find the Max Age from the family
 |  |  | Step 2 | Find how many Adults (Parents In Our Case) is there ?
 |  |  | Step 3 | Calculate Premium
 | Preblem 1 | If [NAME] from a family is 37 and there are 2 adults and 2 child are there then premium for 100000, will be 2430
 | Preblem 2 | If [NAME] from a family is 37 & there are 3 childred then the premium for 100000 will be 2430 + 235
 |  | if we add one more child in the above case to the family the premium will be 2430 + 235 + 235
 |  | Premium for additional will have to be looked up from same table
 | Note : | Even if child attains the age of 19 still he will be considered as child
 | Prbblem 3 | Is there any way that if the [NAME] age of family member goes above 45 then the referred cell starts blinking. Cell E2 in our case
 |  | So if B14 is greater than or equal to 46 then E2 will start blinking
 |  | I know the conditional formating but it will only change the colour of the cell.
Spreadsheet: darrell_schoolcraft__7361__NNG LAMAR NOMNATION
Sheet: 01-(18)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-18 00:00:00
 |  |  |  | Ending Gas Day: | 2002-01-18 00:00:00
 |  | [NAME] |  |  | 60000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3750
 |  |  | 3400
 |  |  | 3400
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 2200
 |  |  | 2250
Spreadsheet: 130205d1322128691-formula-result-correct-but-display-something-else-why-design-status-dummy
Sheet: Calculation

 |  | Management | Management |  |  |  |  |  |  | Total | Total | Total
Week | Ending | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Planned | Actual | Actual
1 | 2011-09-09 00:00:00
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Completion Code
1 | 0
2 | 0.1
3 | 0.5
4 | 0.75
5 | 1
Status Code
1 | Overdue
2 | Due Next Week
3 | Not Due Yet
4 | Complete this wk
5 | Complete other
Spreadsheet: 66963d1267627575-removing-blank-cells-excel-forum2
Sheet: Sheet2

51500.25 | 648 | -18525.375 | 45063 | 35303.625
45063 |  | -21901.5 | 51500.25 | 33202.125
41934.375 |  | 20935.125 | 39819.375 | 30505.5
-50050.125 |  | -15150.375 | -37726.875 | 39819.375
 |  |  | 41934.375 | 32388.75
 |  |  | -50050.125 | -37726.875
 |  |  | 0 | 41934.375
 |  |  |  | 35986.5
 |  |  | 0 | -34945.875
Spreadsheet: 37991d1236101946-attendee-data-solution-signuplisting
Sheet: Signup

Names | Expo 1 | Key
Name1 | X | 1
[NAME]
Name3 | X | 2
Name4
Name5 | X | 3
Name6
Name7
Name8
Name9 | X | 4
Name10
Name11
Name12
Name13 | X | 5
Name14 | X | 6
Name15
[NAME] | X | 7
Name17
Name18 | X | 8
Name19 | X | 9
 |  |  |  |  | [NAME]
 |  |  | 2 | 2
 |  |  | 3 | 3 | 1
 |  |  | 4 | 4
 |  |  | 5 | 5
 |  |  | 6 | 6