tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a2a75fcc-228e-4ee3-a067-cd77901124a4
Sheet: Sheet1

Steel Machinability Estimator* for Carbide Tooling Applications | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
*This machinability estimator was developed for carbon and alloy steels using uncoated carbide tools.  The machinability estimates resulting from  this estimator are for use only as a guideline or relative comparison of workpiece materials in selecting materials and/or machining set-ups and are in no way intended to represent an absolute value.   The estimator is to be used only for steels that have a carbon content of not less than 0.10% nor more than 0.90%.  Extrapolations beyond these levels have not been verified.  The estimator will not return a value if the Ito-Bessyo Carbon Equivalent is outside the range of study.  AISI neither warrents the use of this estimator, nor is it responsible for the use and application of the estimator by any entity.  This information is provided by AISI solely as a service to the public.
Steel Chemistry | C | Si | Mn | S | Ni | Cr | Mo | Cu | V
Enter decimal % Chemical Content
(e.g. %Carbon as 0.20)
The Ito-Bessyo Carbon Equivalent is: | 0 | False
I-B must be between 0.1 and 0.8 to calculate a valid V30
The estimated V30 for this steel is: | Not Valid | SFPM
Spreadsheet: 144350d1330942463-sum-copy-of-example-1
Sheet: Sheet1

Deparment | Spend |  | Hospital | Dept | Spent
[NAME] | 41439
Northampton GH- Patient Care | 32155
Newcastle NHS Trust- Patient Care | 11206
London Probation- Patient Care | 25817
Royal Berkshire NHS- Patient Care | 14305
Nottingham UH- Acute Health | 23889
Northampton GH- Acute Health | 32823
Newcastle NHS Trust- Acute Health | 24697
London Probation- Acute Health | 13310
Royal Berkshire NHS- Acute Health | 28180
[NAME] | 17774
Northampton GH-Home Call | 41199
Newcastle NHS Trust-Home Call | 46496
London Probation-Home Call | 40016
Royal Berkshire NHS-Home Call | 25711
 |  |  | Row Labels | Sum of Spent
 |  |  | [NAME] | 79143
 |  |  | Acute Health | 13310
 |  |  | Home Call | 40016
 |  |  | Patient Care | 25817
 |  |  | Newcastle NHS Trust | 82399
 |  |  | Acute Health | 24697
 |  |  | Home Call | 46496
 |  |  | Patient Care | 11206
 |  |  | Northampton GH | 106177
 |  |  | Acute Health | 32823
 |  |  | Home Call | 41199
 |  |  | Patient Care | 32155
 |  |  | [NAME] | 83102
 |  |  | Acute Health | 23889
 |  |  | Home Call | 17774
 |  |  | Patient Care | 41439
 |  |  | Royal Berkshire NHS | 68196
 |  |  | Acute Health | 28180
 |  |  | Home Call | 25711
 |  |  | Patient Care | 14305
 |  |  | Grand Total | 419017
Spreadsheet: 300839d1393583791-help-conditional-formatting-to-highlight-match-for-whole-page-sequences
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 8 | 0.5 | 16 | 4 | 15 | 0.3 | 50 | 4.5 | 6 | 0.2 | 30
differences
differences differences
diff diff diff
diff diff diff diff
Added in two's
ODD differences
ODD diff diff
ODD diff diff diff
Even differences
Even diff diff
Even diff diff diff
divided by next
divided by previous
odd divided
Even divided
DIVIDED
2's
3's
4's
5's
6's
7's
8's
9's
MULTIPLED
2's
3's
4's
5's
6's
7's
8's
9's
Squared
Square Root
Running POWERs
Spreadsheet: 0b13fa88-726e-4b80-9a70-cc7aaa03942f
Sheet: 60 Month Lease

60 MONTHS |  |  |  | 60 MONTHS
GS-30F-0008L AutoFlex, Inc. |  |  |  | GS-30F-0019P The Bancorp Bank ([NAME])
751-1 |  |  | Autoflex | 751-1 |  |  | Bancorp Bank (Jefferson)
Item # | Make | Model | 60 Months | Item # | Make | Model | 60 Months Price
8E | Mitusbishi | 8E Imiev | 378 | 8E | Ford | 8E Focus BEV | 504
8E | Nissan | 8E Leaf | 488 | 8P | Ford | 8P Cmax PHEV | 436
8E | Ford | 8E Focus BEV | 539
8P | Ford | 8P Cmax PHEV | 471
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: we

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 683801d1592949271-if-function-too-many-arguments-darkwarrior92-sample
Sheet: Sheet1

Date | Shift Start | Clock In | Shift End | Clock Out | [NAME] | Expected
June 6th 2020 | 09:00:00 | 09:05:00 | 17:00:00 | 17:11:00 |  | OK
June 5th 2020 | 09:00:00 | 09:23:00 | 17:00:00 | 17:01:00 |  | NOT OK
June 4th 2020 | 09:00:00 | 09:06:00 | 17:00:00 | 16:19:00 |  | NOT OK
June 3rd 2020 | 09:00:00 |  | 17:00:00 | 17:04:00 |  | NOT OK
June 2nd 2020 | 09:00:00 | 09:01:00 | 17:00:00 |  |  | NOT OK
June 1st 2020 |  |  |  |  |  | ON LEAVE
Spreadsheet: 0a6985b1-786c-4dcf-8148-1d6206fb5350
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52
 | Months
 | Mondays | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 5 | 12 | 19 | 26 | 3 | 10 | 17 | 24 | 7 | 14 | 21 | 28 | 5 | 12 | 19 | 26
 | Microcycle | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 49 | 50 | 51 | 52
Race Schedule | World Series Events,  Major [NAME] and  International Events
 | Priority
 | Swim
 | Bike
 | Run
 | Strength
 | Total Volume
 | Primary Emphasis
 | Secondary Emphasis
 | Maintenance
 | Medical Control
 | Med Screen/Education
 | Blood Chemistry
 | Body Composition
 | Sport Sci Services
 | [NAME] (LT)
 | Biomechanical Screen
 | o2 [NAME]
 | Swim Technique Analysis
 | Pedal Mechanics/Bike Fit
 | Nutrition Assessment
 | Sports Psyc
Spreadsheet: 793435d1661475448-countif-with-and-and-or-problem-hd
Sheet: Sheet1

2 | 1 | 2 |  |  |  | I have 3 columns A,B,C that each have a number in them for each (of 100) candidates
2 | 0 | 2 | True |  |  | I need a total of the number of people that have:
2 | 1 | 2 | True |  |  | - greater than 0 in column A and greater than 0 in column B
2 | 2 | 2 | True |  |  | OR
1 | 1 | 0 | True |  |  | - greater than 0 in column A and greater than 0 in column C
0 | 2 | 1 | False
0 | 0 | 1 | False |  |  | Please try this formula:
2 | 1 | 0 | True
0 | 2 | 1 | False
1 | 0 | 0 | False
2 | 0 | 1 | True
1 | 0 | 0 | False
0 | 2 | 1 | False
0 | 0 | 0 | False
0 | 2 | 0 | False
1 | 0 | 1 | True
1 | 0 | 1 | True
1 | 0 | 1 | True
1 | 2 | 2 | True
0 | 1 | 2 | False
0 | 0 | 1 | False
2 | 1 | 0 | True
2 | 0 | 1 | True
1 | 1 | 2 | True
2 | 2 | 1 | True
1 | 1 | 0 | True
0 | 0 | 1 | False
2 | 0 | 2 | True
0 | 1 | 1 | False
2 | 1 | 2 | True
0 | 0 | 2 | False
2 | 0 | 0 | False
0 | 0 | 1 | False
1 | 1 | 2 | True
2 | 0 | 0 | False
2 | 0 | 0 | False
2 | 0 | 0 | False
2 | 2 | 2 | True
2 | 2 | 0 | True
2 | 1 | 2 | True
2 | 2 | 0 | True
2 | 2 | 1 | True
1 | 1 | 1 | True
2 | 1 | 0 | True
2 | 1 | 2 | True
2 | 0 | 2 | True
2 | 1 | 2 | True
1 | 0 | 0 | False
1 | 2 | 0 | True
2 | 0 | 1 | True
0 | 1 | 0 | False
1 | 0 | 0 | False
0 | 1 | 1 | False
1 | 0 | 1 | True
0 | 2 | 0 | False
2 | 1 | 0 | True
0 | 0 | 1 | False
0 | 0 | 1 | False
2 | 0 | 0 | False
0 | 0 | 2 | False
0 | 1 | 1 | False
2 | 0 | 0 | False
2 | 0 | 2 | True
1 | 0 | 1 | True
0 | 1 | 2 | False
0 | 2 | 2 | False
1 | 2 | 1 | True
1 | 0 | 2 | True
0 | 2 | 0 | False
2 | 1 | 0 | True
0 | 1 | 2 | False
0 | 0 | 0 | False
0 | 1 | 1 | False
1 | 2 | 0 | True
0 | 1 | 2 | False
1 | 0 | 1 | True
0 | 2 | 2 | False
0 | 1 | 1 | False
0 | 0 | 2 | False
1 | 0 | 2 | True
1 | 2 | 2 | True
1 | 2 | 0 | True
0 | 0 | 2 | False
2 | 2 | 2 | True
1 | 0 | 0 | False
2 | 0 | 2 | True
2 | 2 | 0 | True
1 | 2 | 0 | True
2 | 2 | 0 | True
0 | 0 | 0 | False
1 | 0 | 1 | True
1 | 2 | 1 | True
0 | 2 | 2 | False
0 | 2 | 0 | False
1 | 0 | 0 | False
2 | 0 | 1 | True
2 | 2 | 1 | True
2 | 2 | 1 | True
2 | 2 | 2 | True
1 | 2 | 2 | True
Spreadsheet: a513c10c-37f6-4985-9cfc-522baf8fb40a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5647 | 29856 | Baiba | Medne | LAT | 86 | 00:10:04 | [NAME] | 01:13:05 | 00:00:41 | 00:16:37 | 1 | 01:41:23
5647 | 40902 | Irena | Klingorova | CZE | 85 | 00:10:16 | 00:00:56 | 01:14:32 | [NAME] | 00:19:56 | 2 | 01:46:36
Spreadsheet: 0a39ef43-c72c-4cea-b2b8-b617c529d15a
Sheet: Fiber parts

 | [NAME]
UOM | [NAME] | PART NUMBER | PRICE
PK | sanding pads (pack of 50) | FPF1-V | 43.29
PK | polishing pads (pack of 50) | 501523-1 | 7.51
EA | ST Hot Melt Connectors MM | 5492458-1 | 2.27
EA | SC Hot Melt Connectors MM | 5504657-9 | 5.9
EA | ST Hot Melt Connectors SM | 5502579-2 | 3.33
EA | SC Hot Melt Connectors | 5504655-1 | 7.26
EA | SC Hot Melt Connectors | 5504655-1 | 7.26
EA | SC Connectors | 5504655-1 | 7.26
EA | ST 6 pack | 1278567-1 | 50.42
EA | SC 6 pack | RMG-06ADPC1 | 37.7
EA | SC 12 pack | RMG-12ADPC3 | 49.83
EA | 6 strand fan out kits | 06FANID2L | 18.07
EA | 12 strand Fan out kits | 12FANID2L | 30.33
EA | 12 strand RIC | RMG-12ADPC4 | 60.65
EA | 4U RIC | RMG-4000-000B | 303.71
EA | Fiberware 6 strand fan out kits | 06FANID2L | 18.07
EA | FIS SC 6 pack | RMG-06ADPC1 | 37.7
EA | FIS SC 12 pack | RMG-12ADPC3 | 49.83
EA | FIS ST 6 pack | 1278567-1 | 50.42
EA | 12 port SC RIC | RMG-12ADPC3 | 37.7
EA | 24 port SC RIC | RMG-24ADPQ3 | 95.36
EA | 6 FSP series RIC (36 to 72) 2U | RMG-2000-000B | 225.38
EA | 12 FSP series RIC (72 to 144) 3U | RMG-4000-000B | 303.71
EA | SC 6 pack | RMG-06ADPC1 | 38.51
EA | SC 12 pack | RMG-12ADPC3 | 49.83
EA | 4 FSP wall mount (24 to 48) DOUBLE DOOR | [NAME] | 104.02
EA | 4 FSP wall mount (24 to 48)   SINGLE DOOR | WMG-2000-00B | 65.02
EA | ICC blank adapter panels | RMG-00ADP00 | 8.69
EA | 12 strand fan out kits | 12FANID2L | 30.33
EA | SC 6 pack | RMG-06ADPC1 | 37.7
EA | SC 12 pack | RMG-12ADPC3 | 49.83
EA | 12 port RIC, 1RU | RMG-1000-000B | 178.43
EA | 24 Port Wall Mount | 1278323-2 | 127.14
EA | lock and key | 559501-2 | 8.87
EA | 36 port RIC | RMG-1000-000B | 178.11
EA | 72 port RIC, 3RU, no lock | RMG-2000-000B | 225.38
EA | Siecor ST 6 pack | 1278567-1 | 50.42
EA | 12 port RIC w/slide out drawer | 1-1657014-7 | 148.37
EA | Wall Mount 24 to 96 port | [NAME] | 104.02
EA | Wall Mount with thumb latch | [NAME] | 104.02
EA | 24 port RIC | RMG-1000-000B | 178.11
EA | 36 port RIC | RMG-1000-000B | 178.11
EA | 48 port RIC | RMG-2000-000B | 225.38
EA | 72 port RIC | RMG-2000-000B | 225.38
EA | ST 6 pack | 1278567-1 | 51.46
EA | SC 6 pack Duplex Adapter | RMG-06ADPC1 | 37.7
EA | 6 duplex SC adapters (12 ports) | RMG-06ADPC1 | 37.7
EA | Blank Adapter Plate | 559523-1 | 8.61
FT | Orange innerduct (per foot) | 180524 | 2.3
EA | MM SC/SC jumper cords | PAT-SCSC-R20C003M | 31.59
EA | MM SC/ST jumper cords | PAT-SCTC-R20C003M | 31.59
EA | SM SC/ST jumper cords | PAT-SCTC-RS0C003M | 38.59
EA | SM SC/SC jumper cords | PAT-SCSC-RS0C003M | 35.33
EA | SM ST/ST jumper cords | PAT-TCTC-RS0C003M | 38.59
Spreadsheet: 228554d1366142215-have-selected-data-appear-times
Sheet: Sheet1

Time | 5/1 | 5/2 | 5/3
09:00:00 | JS | BF | RH
09:30:00 | JS | BF | RH
10:00:00 | JS | BF | RH
10:30:00 | JS | BF | RH
11:00:00 | JS | BF | RH
11:30:00 | JS | BF | RH
12:00:00 | JS | BF | RH
12:30:00 | JS | JW | KW
01:00:00 | JS | JW | KW
01:30:00 | JS | JW | KW
02:00:00 | JS | JW | KW
02:30:00 | JS | JW | KW
03:00:00 | JS | JW | KW
Spreadsheet: 789133d1658926796-conditional-formatting-data-in-between-data-between
Sheet: vroege shift

 |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE |  |  |  |  |  | WAVE
 |  |  |  |  | X06 |  |  |  |  |  | X07 |  |  |  |  |  | X08 |  |  |  |  |  | X09 |  |  |  |  |  | X10 |  |  |  |  |  | X11 |  |  |  |  |  | X12 |  |  |  |  |  | X13 |  |  |  |  |  | X14
 |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE |  |  |  |  |  | SCHEDULE
 |  |  |  |  | 6345 |  |  |  |  |  | 6346 |  |  |  |  |  | 6347 |  |  |  |  |  | 6348 |  |  |  |  |  | 6349 |  |  |  |  |  | 6350 |  |  |  |  |  | 6351 |  |  |  |  |  | 6352 |  |  |  |  |  | 6353
 |  |  |  |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38 |  | 36/37 |  | IP |  | 38
 |  |  |  |  | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean | release | clean
 |  |  |  | 05:45:00
 |  |  |  | 06:00:00
 |  |  |  | 06:15:00
 |  |  |  | 06:30:00
 |  |  |  | 06:45:00
 |  |  |  | 07:00:00
 |  |  |  | 07:15:00
 |  |  |  | 07:30:00
 |  |  |  | 07:45:00
 |  |  |  | 08:00:00
 |  |  |  | 08:15:00
 |  |  |  | 08:30:00
 |  |  |  | 08:45:00
 |  |  |  | 09:00:00
 |  |  |  | 09:15:00
 |  |  |  | 09:30:00
 |  |  |  | 09:45:00
 |  |  |  | 10:00:00
 |  |  |  | 10:15:00
 |  |  |  | 10:30:00
 |  |  |  | 10:45:00
 |  |  |  | 11:00:00
 |  |  |  | 11:15:00
 |  |  |  | 11:30:00
 |  |  |  | 11:45:00
 |  |  |  | 12:00:00
 |  |  |  | 12:15:00
 |  |  |  | 12:30:00
 |  |  |  | 12:45:00
 |  |  |  | 13:00:00
 |  |  |  | 13:15:00
 |  |  |  | 13:30:00
 |  |  |  | 13:45:00
 |  |  |  | 14:00:00
 |  |  |  | 14:15:00
Spreadsheet: 1163b0e0-5129-43bf-a57c-ecddc30bec3c
Sheet: Sheet1

Species | Original Number | Phage 14/1 | Phage F77 | Phage PNM | Phage PT 6 | Phage PT 8 | Phage PL | Phage 9/3
P. aeruginosa | 47 814 | cl | cl | scl | - | - | - | -
P. aeruginosa | 12 438 | cl | cl | ol | - | - | - | -
P. aeruginosa | 13 352 | cl | cl | ol | - | - | - | -
P. aeruginosa | 4 366 | cl | cl | ol | - | - | - | -
P. aeruginosa | 16 132 | - | - | cl | - | - | - | -
P. aeruginosa | 16 120 | - | - | cl | - | - | - | -
P. aeruginosa | 6t6 | cl | cl | cl | - | - | - | -
P. aeruginosa | 608210022 | cl | cl | cl | - | - | - | -
P. aeruginosa | 662 | cl | ol | ol | - | - | - | -
P. aeruginosa | 794 | cl | ol | ol | - | - | - | -
P. aeruginosa | 47 | cl | ol | ol | - | - | - | -
P. aeruginosa | 8631 | cl | ol | cl | ol | ol | ol | ol
P. aeruginosa | 9728 | cl | ol | scl | - | - | - | -
P. aeruginosa | 750 | cl | ol | ol | ol | - | - | -
P. aeruginosa | 4362 | cl | cl | cl | ol | - | - | -
P. aeruginosa | 4364 | cl | cl | cl | ol | - | - | -
P. aeruginosa | 608210020 | - | - | - | - | - | - | -
P. aeruginosa | 7S58 | - | - | cl | - | - | - | -
P. aeruginosa | 7296 | cl | ol | cl | - | - | - | -
P. aeruginosa | 7326 | cl | ol | ol | - | - | - | -
P. aeruginosa | 380 | ol | ol | cl | - | - | - | -
P. aeruginosa | 754 | cl | cl | cl | - | - | - | -
P. aeruginosa | 776 | cl | cl | cl | - | - | - | -
Spreadsheet: 1482dd40-c719-476e-99da-bdff71e62242
Sheet: AH

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program
 | TOTAL
 | COURSE
5 | AH 090 | 1 | X | 1
1 | AH 101 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
3 | AH 198 | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 170694d1343364145-conditional-formatting-question-conditional-formating
Sheet: Sheet1

Used | Account | 588685
0 | 123456
0 | 154320
0 | 192900 |  |  |  | Hi,  The VLOOKUP used in cell C1 relies on column A being in [NAME].  What is unsure, is how the "1" is placed in the Used Column.  Is the "1" the result of a formula?
0 | 241125
0 | 301406
0 | 376758
0 | 470948
1 | 588685
2 | 735856
3 | 919820
4 | 1149775
5 | 1437219
6 | 1796524
7 | 2245655
8 | 2807069
9 | 3508836
10 | 4386045
11 | 5482556
12 | 6853195
13 | 8566494
14 | 1070811
15 | 588685
16 | 735856
17 | 919820
18 | 2807069
19 | 3508836
20 | 4386045
21 | 5482556
Spreadsheet: 117382d1312751673-how-to-sum-sub-sums-in-adjacent-column-sum-sub-sums-in-adjacent-column
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Total 'S' | 4 |  | Row # | SUM
 |  |  |  |  |  | 67 |  |  | Total 'F' | 4 |  | 9 | 311
 |  |  |  |  |  | 76 |  |  | MIN | 4 |  | 14 | 140
s |  |  |  |  |  | 77 |  |  |  |  |  | 19 | 298
 |  |  |  |  |  | 28 |  |  |  |  |  | 23 | 263
 |  |  |  |  |  | 49
 |  |  |  |  |  | 31
 |  |  |  |  |  | 81
f |  |  |  |  |  | 45
 |  |  |  |  |  | 57
 |  |  |  |  |  | 51
 |  |  |  |  |  | 86
s |  |  |  |  |  | 69
f |  |  |  |  |  | 71
 |  |  |  |  |  | 85
s |  |  |  |  |  | 48
 |  |  |  |  |  | 69
 |  |  |  |  |  | 94
f |  |  |  |  |  | 87
s |  |  |  |  |  | 86 |  |  |  |  |  |  | `
 |  |  |  |  |  | 33
 |  |  |  |  |  | 88
f |  |  |  |  |  | 56
 |  |  |  |  |  | 82
 |  |  |  |  |  | 64
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Summary

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
INVOICE
 | BILL TO:EOC - Executive
 | 1400 Smith Street
 | Houston, TX 77251
 | ATTN:[NAME]
 | DATE OF SERVICES |  | INVOICE DATE |  | INVOICE NO.
 | June, 2001 |  | Tuesday, July 03, 2001 |  | [PHONE]
 | COMPANY | RC NO | DESCRIPTIONS | AMOUNT
 | 0366-112458 | 100150 | TRAVEL | 624.7
 |  | 100152 | SHIPPING/RECEIVING | 40.96
 |  | 100154 | FORMS MANAGEMENT | 64.3
 |  | 100158 | PHONE OPERATORS | 7.5
 |  | 100159 | MAIL CENTER | 28.68
 |  | 100164 | FACILITY MAINT. | 6.6
 |  | 100166 | SECURITY CHARGES | 11.55
 |  | 100169 | CHURN/RELOCATION | 210
 |  | 100182 | BUILDING SERVICES | 4.95
 |  | 100186 | FACILITY OPERATIONS | 7.92
 |  | 100187 | CONVENIENCE COPIERS | 12.58
 |  | 100192 | CAFETERIA | 28.16
 |  | 100193 | ENRON BUILDING | 343.74
 |  | 100196 | PARKING | 110.92
 | Total:
Spreadsheet: 743104d1628227752-help-on-calculating-interest-in-savings-account-test1
Sheet: Sheet1

 | Savings Plan Rate | 0.05 |  |  |  | 60th Birthday
 | FD Rate | 0.085 |  |  |  | No. of months
 | Deposit Amt | 1000 |  |  |  | Months for FD
 | Period | 60
 | Date SA open | 2021-08-05 00:00:00
 | DOB | 1975-01-08 00:00:00
Savings Plan Calculation - FV() |  |  |  |  | FD  Calculation - FV ()
Savings Plan Calculation - Manual |  |  |  |  | FD  Calculation - Manual
Month |  | Capital | Interest |  | Month |  | Capital | Interest
0 |  |  |  |  | 0
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Spreadsheet: 91802d1291467073-auto-fill-columns-b-c-d-based-on-column-data-of-a-master-list-in-a-2nd-sheet-price-list
Sheet: Price List

No | Model No | Description | Price
1 | MPC2600 | Black Toner 12000 | 10
2 | MPC3000 | [NAME] 6000 | 20
3 | MPC4000 | Black Toner 2000 | 15
4 | MFD3400 | [NAME] | 69
5 | [NAME] | Black Toner | 40
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -23046 | -20000 |  |  |  |  |  |  |  | San Juan
2 | -75534 | -75068 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -83709 | -75300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -83059 | -80207 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -83684 | -85233 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -69154 | -85233 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -66976 | -58000 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -80299 | -76101 |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 | -90279 | -85236 |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10 | -88269 | -85551
11 | -87741 | -85279
12 | -87886 | -85278
13 | -88952 | -85210
14 | -88235 | -89219 |  |  |  | 9/1 - 9/25
15 | -85950 | -88693
16 | -82812 | -88636
17 | -87300 | -80337
18 | -88174 | -85299
19 | -88659 | -85300 |  |  |  | Accumulated @ 9/25/01
20 | -87403 | -88439
21 | -69371 | -78692 |  |  |  | Equilalent volumes at 9/25/01
22 | -54199 | -52800
23 | -24310 | -17500
24 | -82802 | -49936
25 | -79875 | -80236
26 | -83734 | -62597
27 | -86304 | -81278
28 | -86591 | -84540
29 | -72379 | -80300
30 | -55008 | -80300
31 | -82100 | -80300
2001-11-30 00:00:00 |  |  | 51989
2001-12-31 00:00:00
CBS Volume
 |  |  | 116707
Spreadsheet: 863994d1711370992-sumproduct-pricing-table-threshold-calculation-issue-pricing-threshold-table
Sheet: Bag price Luggage Logistics

threshold |  | price
min | [NAME]
1 | 10 | 4 |  | 1 | 10 | 4
 | 50 | 3 |  | 1 | 40 | 3
 | 200 | 2 |  | 1 | 5 | 2
 | 9999 | 1 |  | 0 | 0 | 1
 |  |  |  |  |  | Result
 | check | 55
 | result
Spreadsheet: 139401d1328218579-count-occurances-using-two-dropdowns-based-on-criteria-accros-multiple-sheets-test
Sheet: town2

 |  | area 2 | area 9 | area 24 | area 25 |  |  |  | area4 | area5
apple |  | 1 | 3 | 1 | 6 |  |  |  | 3 | 0 | FURNITURE
pears |  | 2 | 7 | 5 | 3 |  |  |  | 4 | 5 | chair
oranges |  | 4 | 9 | 8 | 2 |  |  |  | 3 | 2 | cupboard
motorcar |  | 14 | 11 | 12 | 34 |  |  | 3 | orange | bike | desk
boat |  | 24 | 33 | 45 | 28 |  |  | 4 | peach | bus
bike |  | 34 | 100 | 1 | 2 |  |  | 5
bus |  | 41 | 4 | 5 | 6 |  |  | 6
chair |  | 43 | 6 | 4 | 5 |  |  | 7
cupboard |  | 47 | 9 | 3 | 2
desk |  | 4 | 1 | 6 | 6
Spreadsheet: 830530d1684957334-picking-the-last-value-chronolgically-based-on-a-time-column-sample-table
Sheet: Sheet2

Date/Time | Result | L
2022-07-06 11:30:00 | 1.4
2022-07-06 13:26:00 | 1.3
2022-07-06 16:24:00 | 1.2
2022-07-06 17:57:00 | 1.3
2022-07-07 05:55:00 | 1.5
2022-07-07 07:48:00 | 1
2022-07-07 11:54:00 | 1.9
2022-07-07 13:35:00 | 0.9
2022-07-07 16:45:00 | 1.3
2022-07-07 18:20:00 | 1.2
Spreadsheet: sally_beck__33985__Weekly Operating Report 4-4 - Revised
Sheet: WE 4-4 EOL Data

EOL
 | Week ending 04/04 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas | 16972 | 2417136104.16 | MMBTU
Power | 2674 | 20730564 | MHtz
EGM
Liquids | 1131 | 54572000.00999999 | BBL
Coal | 1 | 23250 | TONNE
Coal International | 2 | 90000 | TONNE
Weather | 0 | 0 | HDD/CDD
IR/FX | 0 | 0 | USD
Emissions | 8 | 20000 | CONTRACTS
EIM
Pulp & Paper | 0 | 0 | TONNE
Steel | 0 | 0 | TONNE
Number of new EOL Counterparties | 12
Non-EOL
 | Week ending 04/04 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas | 3413 | 2183780891.11 | MMBTU
Power | 2588 | 30791701.30000001 | MHtz
EGM
Liquids | 1861 | 140912891.09 | BBL
Coal | 16 | 1104750 | TONNE
Coal International | 1 | 15000 | TONNE
Weather | 10 | 50000 | HDD/CDD
IR/FX | 537 | 0 | USD
Emissions | 9 | 159000 | CONTRACTS
EIM
Pulp & Paper | 387 | 201955 | TONNE
Steel | 0 | 0 | TONNE
Clickpaper
 | Week ending 04/04 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EIM
Lumber | 3 | 352000 | Board Feet
Newsprint
Pulp (recycled paper) | 4 | 1420 | [NAME]
Number of new CP Counterparties | 1
Lumber Converted |  | 352
EIM TOTAL |  | 203727