tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 42120d1240666675-div-0-error-messages-in-formulas-book2
Sheet: Sheet1

Open/Transfer/Reopen | OPEN
Restaurant #
Benchmark Sales | 5000 |  |  |  |  |  |  |  |  |  |  |  | Open | Transfer | Reopen
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Sales % Lift |  | OPEN |  | 1332
Wk 1 (Net 3) | 444 | 444 | 444 |  |  |  |  | 1332 |  |  | TRANSFER
Wk 2 (Net 3) |  |  |  |  |  |  |  | 0 |  |  | REOPEN
Wk 3 (Net 3) |  |  |  |  |  |  |  | 0 |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Open/Transfer/Reopen | TRANSFER |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Restaurant # |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Benchmark Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Sales % Lift |  | OPEN |  |  |  | #N/A
Wk 1 (Net 3) |  |  |  |  |  |  |  | 0 |  |  | TRANSFER | Averages | 1332 | #N/A | #N/A
Wk 2 (Net 3) |  |  |  |  |  |  |  | 0 |  |  | REOPEN |  | 1 | 0 | 0
Wk 3 (Net 3) |  |  |  |  |  |  |  | 0 |  |  |  |  | 1332 | #N/A | #N/A
Open/Transfer/Reopen | REOPEN
Restaurant #
Benchmark Sales
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Sales % Lift |  | OPEN
Wk 1 (Net 3) |  |  | 444 |  |  |  |  | 444 |  |  | TRANSFER
Wk 2 (Net 3) |  |  |  |  |  |  |  | 0 |  |  | REOPEN
Wk 3 (Net 3) |  |  |  |  |  |  |  | 0
Spreadsheet: 465514d1465729561-my-macro-to-delete-accents-does-not-work-spread-sheet
Sheet: Feuil6

DEPUTADOS | valor doaca da empresa [NAME]
BRUNO COVAS | 227486
JUTAHY JUNIOR | 531875
NILSON LEITAO | 511550
PAULO ABI-ACKEL | 425000
ELMAR NASCIMENTO | 201580
[NAME] | 250000
ALEX MANENTE | 400
BEBETO | 50000
DANILO FORTE | 400000
FERNANDO COELHO FILHO | 30000
PAULO PEREIRA DA SILVA | 240925
EDUARDO BOLSONARO | 567
PASTOR MARCO FELICIANO | 9837
JHONATAN DE JESUS | 10000
MARCELO SQUASSONI | 770
MARCELO ARO | 30000
MARCOS MONTES | 100000
PAULO MAGALHAES | 19898
WELITON PRADO | 166500
FLAVIO NOGUEIRA | 100000
LEONARDO PICCIANI | 199000
WASHINGTON REIS | 500000
OSMAR TERRA | 190000
LUCIO VIEIRA LIMA | 732000
PAULO MALUF | 648940
AGUINALDO RIBEIRO | 271900
ROBERTO BRITTO | 7423
JERONIMO GOERGEN | 100000
BENITO GAMA | 211890
ARLINDO CHINAGLIA | 412000
[NAME] | 187500
PAULO TEIXEIRA | 285000
VICENTE CANDIDO | 254125
ZE GERALDO | 145500
BACELAR | 4493
EDIO LOPES | 680732
[NAME] | 494407
[NAME] | 350000
SILVIO COSTA | 100000
Spreadsheet: 298743d1392897097-combining-identical-addresses-consolidate-names
Sheet: Sheet1

COLUMN A | COLUMN B
[NAME], MARTIN | PO BOX 452, TYLER, ID 83765
[NAME], SARAH | PO BOX 452, TYLER, ID 83765
KESEY, WILLIAM | 287 SOUTH BILLINGS ST, SHANE, ID 83772
TANDLE, GARRET | PO BOX 24, SADDLE, MT 88970
TANDLE, SUE | PO BOX 24, SADDLE, MT 88970
 |  |  |  |  |  |  |  |  |  | COLUMN A | COLUMN B
 |  |  |  |  |  |  |  |  |  | [NAME], MARTIN | PO BOX 452, TYLER, ID 83765
 |  |  |  |  |  |  |  |  |  | [NAME], SARAH | PO BOX 452, TYLER, ID 83765
 |  |  |  |  |  |  |  |  |  | KESEY, WILLIAM | 287 SOUTH BILLINGS ST, SHANE, ID 83772
 |  |  |  |  |  |  |  |  |  | TANDLE, GARRET | PO BOX 24, SADDLE, MT 88970
 |  |  |  |  |  |  |  |  |  | TANDLE, SUE | PO BOX 24, SADDLE, MT 88970
 |  |  |  |  |  |  |  |  |  | This is the consolidation I need:
 |  |  |  |  |  |  |  |  |  | COLUMN A | COLUMN B
 |  |  |  |  |  |  |  |  |  | MARTIN AND SARAH JOHNSON | PO BOX 452, VICTOR, ID 83455
 |  |  |  |  |  |  |  |  |  | [NAME] | 287 SOUTH BILLINGS ST, SHANE, ID 83772
 |  |  |  |  |  |  |  |  |  | GARRET & SUE TANDLE | PO BOX 24, SADDLE, MT 88970
Spreadsheet: 373615d1422494999-take-corresponding-name-and-points-and-make-a-summary-of-points-sujra-time-sheets-places
Sheet: Senior (Girls)

 | SR Girls Date | Event |  |  |  |  | Event |  |  |  |  | Event |  |  |  |  | Event |  |  |  |  | Event |  |  | All Around Points
# | Contestant | Barrels | Place | Points | # | Contestant | Poles | Place | Points | # | Contestant | Goat tying | Place | Points | # | Contestant | Breakaway | Place | Points | # | Contestant | Team Roping | Place | Points | Total:
1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1
2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2
3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3
4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4
5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5
6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6
7 | Riggun |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7
8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8
9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9
10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10
11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11
12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12
13 |  |  |  |  | 13 |  |  |  |  | 13 |  |  |  |  | 13 |  |  |  |  | 13
14 |  |  |  |  | 14 |  |  |  |  | 14 |  |  |  |  | 14 |  |  |  |  | 14
15 |  |  |  |  | 15 |  |  |  |  | 15 |  |  |  |  | 15 |  |  |  |  | 15
16 | Diesel |  |  |  | 16 |  |  |  |  | 16 |  |  |  |  | 16 |  |  |  |  | 16
17 |  |  |  |  | 17 |  |  |  |  | 17 |  |  |  |  | 17 |  |  |  |  | 17
18 |  |  |  |  | 18 |  |  |  |  | 18 |  |  |  |  | 18 |  |  |  |  | 18
19 |  |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | 19
20 | Colton |  |  |  | 20 |  |  |  |  | 20 |  |  |  |  | 20 |  |  |  |  | 20
21 |  |  |  |  | 21 |  |  |  |  | 21 |  |  |  |  | 21 |  |  |  |  | 21
22 |  |  |  |  | 22 |  |  |  |  | 22 |  |  |  |  | 22 |  |  |  |  | 22
23 |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  | 23
24 |  |  |  |  | 24 |  |  |  |  | 24 |  |  |  |  | 24 |  |  |  |  | 24
25 |  |  |  |  | 25 |  |  |  |  | 25 |  |  |  |  | 25 |  |  |  |  | 25
26 |  |  |  |  | 26 |  |  |  |  | 26 |  |  |  |  | 26 |  |  |  |  | 26
27 |  |  |  |  | 27 |  |  |  |  | 27 |  |  |  |  | 27 |  |  |  |  | 27
28 |  |  |  |  | 28 |  |  |  |  | 28 |  |  |  |  | 28 |  |  |  |  | 28
29 |  |  |  |  | 29 |  |  |  |  | 29 |  |  |  |  | 29 |  |  |  |  | 29
30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30
 | Larson
 | Lincoln
 | Treydon
Spreadsheet: 848458d1699196289-profitability-calculation-with-formulas-and-formatting-book3-fusionista-
Sheet: Sheet5

 | Initial investment: | 1000 |  | Length of period: |  | 20
 | Income 1st year: | 5
 | Income change per year.: | 0.03
 | Invstment value change per year.: | 0.02
 |  | 0
 | Initial investment
 | Income
 | Ending value
 | Total cash flow
 | IRR
 | Example of 3 year period:
 |  | 0 | 1 | 2 | 3
 | Initial investment | -1000
 | Income |  | 5 | 5.15 | 5.3045
 | Ending value |  |  |  | 1040.4
 | Total cash flow | -1000 | 5 | 5.15 | 1045.7045
 | IRR | 0.01837191317310838
 | Example of 20 year period:
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Initial investment | -1000
 | Income |  | 5 | 5.15 | 5.3045 | 5.463635 | 5.627544049999999 | 5.796370371499999 | 5.970261482644999 | 6.14936932712435 | 6.33385040693808 | 6.523865919146222 | 6.719581896720609 | 6.921169353622227 | 7.128804434230894 | 7.342668567257819 | 7.562948624275555 | 7.789837083003822 | 8.023532195493935 | 8.264238161358753 | 8.512165306199517 | 8.767530265385501
 | Ending value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1456.811172527798
 | Total cash flow | -1000 | 5 | 5.15 | 5.3045 | 5.463635 | 5.627544049999999 | 5.796370371499999 | 5.970261482644999 | 6.14936932712435 | 6.33385040693808 | 6.523865919146222 | 6.719581896720609 | 6.921169353622227 | 7.128804434230894 | 7.342668567257819 | 7.562948624275555 | 7.789837083003822 | 8.023532195493935 | 8.264238161358753 | 8.512165306199517 | 1465.578702793184
 | IRR | 0.0245278895159291
 |  | 2 | 4 | 8 | 12 | 16 | 20 | period
 | 0.01 |  | 0.01266304071268798 | 0.01412772609729629 | 0.01476510311425616 | 0.01520295338302846 | 0.01556699424829122
 |  | 0.01500757371276262 | 0.02007922522165395 | 0.02269973443003148 | 0.02364371174088697 | 0.02416938327722007 | 0.02452867126438507
 |  | 0.01993589399586604 | 0.02747854427081875 | 0.03126921175718977 | 0.03253553933571074 | 0.0331691256019222 | 0.03354940007113627
 |  | 0.02484069303872261 | 0.03486116937052186 | 0.03983576618179319 | 0.04143871662971033 | 0.04219787191943536 | 0.04262065995954023
 |  | 0.02972204028685432 | 0.04222726946293287 | 0.04839904001770368 | 0.05035174729240754 | 0.05125183784306264 | 0.05173513986574729
 |  | 0.03458026926210667 | 0.04957701095241651 | 0.05695870693282457 | 0.05927323012398444 | 0.06032772496638872 | 0.06088656900278511
 | Investment value change per year
Spreadsheet: holden_salisbury__12296__$ Calculator
Sheet: Calculator

 |  |  | MWH | BID | ASK |  |  |  |  |  |  |  | 1999-01-01 00:00:00 | 1999-02-01 00:00:00 | 1999-03-01 00:00:00 | 1999-04-01 00:00:00 | 1999-05-01 00:00:00 | 1999-06-01 00:00:00
 | On [NAME] |  | 32 | 150 | 180 |  |  |  |  |  |  | HLH | 400 | 384 | 432 | 416 | 400 | 416
 |  |  |  |  |  |  |  |  |  |  |  | LLH | 344 | 288 | 312 | 304 | 344 | 304
 | [NAME] |  | 72 | 85 | 125 |  |  |  |  |  |  | FLAT | 744 | 672 | 744 | 720 | 744 | 720
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ` | S
 | Flat
 |  |  |  |  |  |  |  |  |  |  |  |  | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | HLH | 416 | 416 | 400 | 416 | 400 | 416
 |  |  |  |  |  |  |  |  |  |  |  | LLH | 328 | 328 | 320 | 328 | 320 | 328
 |  |  |  |  |  |  |  |  |  |  |  | FLAT | 744 | 744 | 720 | 744 | 720 | 744
 |  |  | MWH | BID | ASK
 | On [NAME] |  | 432 | 15.75 | 25.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00
 | Flat |  | 744 | 14.5 | 20 |  |  |  |  |  |  | HLH | 400 | 400 | 432 | 400 | 416 | 416
 |  |  |  |  |  |  |  |  |  |  |  | LLH | 344 | 296 | 312 | 320 | 328 | 304
 | [NAME] |  |  |  |  |  |  |  |  |  |  | FLAT | 744 | 696 | 744 | 720 | 744 | 720
 |  |  |  |  |  |  |  |  |  |  |  |  | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | HLH | 400 | 432 | 400 | 416 | 400 | 400
 |  |  | MWH | BID | ASK |  |  |  |  |  |  | LLH | 344 | 312 | 320 | 328 | 320 | 344
 | Flat |  | 744 | 14.3 | 22.5 |  |  |  |  |  |  | FLAT | 744 | 744 | 720 | 744 | 720 | 744
 | [NAME] |  | 312 | 12.3 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Q2-99 | Q3-99 | Q4-99 | Q1-00 | Q2-00
 | On [NAME] |  |  |  |  |  |  |  |  |  |  | HLH
 |  |  |  |  |  |  |  |  |  |  |  | LLH
 |  |  |  |  |  |  |  |  |  |  |  | FLAT
 | Quarterly Calculator
 | Q3
 | Input Monthly Prices:
 | July | August | September |  |  | October | November | December |  |  | January | February | March |  |  | April | May | June
 | 156 | 171 | 151 |  |  | 134 | 100 | 75 |  |  | 120 | 79 | 79 |  |  | 60 | 52 | 54
 | Q3 price |  |  |  |  | Q4 price |  |  |  |  | Q1 price |  |  |  |  | Q2 price
Spreadsheet: mary_fischer__25375__DATABASE 7
Sheet: Sheet1

DESKTOP DATABASE 7 IDENTIFICATION
1 | POWER |  |  |  | 41 | TEMP SHAFT BEARING (ROTOR BEARING)
2 | TOWER DEFLECTION |  |  |  | 42 | HIGH SPEED RUNNING NUMBER
3 | POWER FACTOR |  |  |  | 43 | DIGITAL 1
4 | REACTIVE POWER |  |  |  | 44 | DIGITAL 2
5 | VOLTAGE PHASE A_N |  |  |  | 45 | PARK POWER
6 | VOLTAGE PHASE B_N |  |  |  | 46 | TOWER ACCELERATION
7 | VOLTAGE PHASE C_N |  |  |  | 47 | DRIVE TRAIN ACCELERATION
8 | CURRENT PHASE A |  |  |  | 48 | TEMP GEARBOX BEARING B  (NOT MONITORED)
9 | CURRENT PHASE B |  |  |  | 49 | T-TRANSFORMER 1 (NOT MONITORED)
10 | CURRENT PHASE C |  |  |  | 50 | T-TRANSFORMER 2 (NOT MONITORED)
11 | GENERATOR SPEED |  |  |  | 51 | T-TRANSFORMER 3 (NOT MONITORED)
12 | ROTOR SPEED |  |  |  | 52 | RESERVE 4
13 | BLADE 1 ACTUAL VALUE |  |  |  | 53 | RESERVE 5
14 | WIND SPEED |  |  |  | 54 | RESERVE 6
15 | NACELLE POSITION |  |  |  | 55 | RESERVE 7
16 | NACELLE REVOLUTION |  |  |  | 56 | RESERVE 8
17 | GEN./GEARBOX SPEED  (WATCHDOG SPEED) |  |  |  | 57 | SCOPE CH 1
18 | WIND DEVIATION 1 SEC. |  |  |  | 58 | SCOPE CH 2
19 | BLADE 2 ACTUAL VALUE |  |  |  | 59 | SCOPE CH 3
20 | BLADE 3 ACTUAL VALUE |  |  |  | 60 | SCOPE CH 4
21 | BLADE 1 SET VALUE |  |  |  | 61 | DI 1 MAIN
22 | BLADE 2 SET VALUE |  |  |  | 62 | [NAME]
23 | BLADE 3 SET VALUE |  |  |  | 63 | DI 1 TOP
24 | POWER FACTOR SET VALUE (COS PHI) |  |  |  | 64 | DI 2 TOP
25 | N-SET 1 |  |  |  | 65 | DI 3 TOP
26 | N-SET 2 |  |  |  | 66 | DI 4 TOP
27 | TORQUE ACTUAL VALUE |  |  |  | 67 | DO 1 MAIN
28 | TORQUE SET VALUE |  |  |  | 68 | DO 2 MAIN
29 | OPERATING STATE ( NUMERICAL STATE OF TURBINE OPERATION) |  |  |  | 69 | DO 1 TOP
30 | CHANNEL 30 ( EMPTY) |  |  |  | 70 | DO 2 TOP
31 | WIND DEVIATION 10 SEC.
32 | TEMP GENERATOR 1 (WINDING TEMP)
33 | TEMP GENERATOR 2 (WINDING TEMP)
34 | TEMP BEARING A (FRONT GENERATOR)
35 | TEMP BEARING B (REAR  GENERATOR)
36 | TEMP GEARBOX (OIL SUMP)
37 | TEMP OUTSIDE
38 | TEMP NACELLE
39 | TEMP GENERATOR COOLING AIR (TEMP FROM HEAT EXCHANGE GEN.)
40 | TEMP GEARBOX BEARING A (HIGH SPEED SHAFT)
Spreadsheet: 0caea0df-d0f7-4821-970f-c4f7fe4d0c1b
Sheet: Sheet1

Q1  Have you observed/experienced any instances where the College has not honored the published statement of Academic Freedom as found in the Faculty/Staff Handbook?   (see reverse side of this form) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Responses received at Faculty Forum 1/9/07
Yes | No | Blank |  | Comments
6 | 125 | 3
0.04477611940298507 | 0.9328358208955224 | 0.02238805970149254 | N | I have not read the statement.  Would've been better to provide the statements here rather than as a "surprise" at the end.  Poor page design!
0.04580152671755725 | 0.9541984732824428 |  | Y | In observing adjunct faculty issues were raised and comments that were inappropriate for the topic of human sexuality
 |  |  | Y | Interference with structure/method of internet courses
 |  |  | blk | No comment
 |  |  | Y | Questions about who "owns" on-line classes, review of on-line class content
 |  |  | Y | Some faculty feel empowered to use their classroom as a pulpit for personal political opinions without response from college.
 |  |  | blk | Some self-censorship among faculty
 |  |  | Y | VP Larson should not change the catalog descriptions without faculty input
Additional comments received
 | 1
Spreadsheet: 71062d1271794187-how-to-create-a-multi-pick-list-dct-attributes-table-draft-v01
Sheet: List

=DataType | =Obligation | =EntryMode | =EntryModeCapture | =Lookup Table | When | [NAME] | Search Mode | Occurrence | Modifiable
Alpha | Mandatory | GUI-evident | Manual | Yes | At Capture | GUI-evident | GUI-evident | Non-repeatable | Yes
Number | Optional | Non-evident | Manual AND | No | At Event | Properties tab | [NAME] | Repeatable | No
Alphanumeric | Conditional |  | Inherited |  |  | Non-Evident | Non-evident | Overwrite
Date |  |  | System-Generated
Logical
MULTI-PICK LIST:
=purpose | =Obligation | =Properties Tab(s)
Identification | Mandatory | General
Description | Optional | Specific
Discovery | Conditional | Audit
Authentication |  | Categories
Management |  | Category Audit
Audit |  | Classification
 |  | Holds
 |  | Provenance
 |  | Ratings
 |  | Records [NAME]
 |  | References
 |  | Versions
 |  | webDAV
 |  | Xreferences
Spreadsheet: 8f959aa0-acc8-4cde-9f09-72a935f3286f
Sheet: Sheet1

Unnamed: 0 | Instructions for Proper Submittal
1) | Complete all forms that are required for your Land Application Program's submittal of an Annual Land Application Report. If the report is incomplete it will be sent back.
2) | The forms must be filled out correctly and completely or the report will be sent back.
3) | The state supplied forms ( ACF, DMSD, RSSF, RSSF-B, FSF, MFLSF, and PVRF ) are the only approved forms that may be used for submittal of the Annual Land Application Report. If other unapproved adaptations are used the report will be sent back. If you have any questions on whether or not an adaptation is appropriate please contact the Land Application Unit.
4) | The previous state forms may be used for the Annual Land Application Report for calendar year 2002. All Annual Land Application Reports submitted for calendar years after 2002 must use the updated forms or the report will be sent back.
5) | These forms can be filled out electronically or by hand as with the Non-Discharge Spray Forms. If filling out electronically fill out the forms in the order that they are presented.
6) | The ACF, [NAME], RSSF, RSSF-B, and PVRF have been changed aesthetically but require the same information to be submitted as in the previous forms.
7) | The FRS, has been changed to include new information to be submitted. Please review carefully. If you have any questions please contact the Land Application Unit.
8) | The MFLSF is a newly created form to calculate the equations needed to be performed on the FSF form. Please review carefully. If you have any questions please contact the Land Application Unit.
9) | If you have any questions regarding the changes in the FSF Form, the newly created MFLSF Form, or how to utilize these forms for your program please contact [NAME] at (919) 715-6189 or [EMAIL]
*** Please note that adjustments may have to be made to your printers properties when printing***
Spreadsheet: 85164d1285214226-create-new-simple-stock-card-control-example_stock-control
Sheet: balance

date updated | item | balance b/f | stock in | stock out | balance
2010-06-10 00:00:00 | product1 | 5 | 0 | 0 | 5 |  | if qty below 10 will highlight to RED
2010-06-10 00:00:00 | product2 | 10 | 20 | 3 | 27
2010-06-10 00:00:00 | product3 | 5 | 5 | 0 | 10 |  | Total up all the same product from stock in / out and put to the right column
2010-06-10 00:00:00 | product4 | 15 | 0 | 0 | 15
2010-06-10 00:00:00 | product5 | 15 | 0 | 0 | 15
2010-09-23 00:00:00 | product1 | 5 | 60 | 5 | 60
2010-09-23 00:00:00 | product2 | 27 | 20 | 0 | 47
2010-09-23 00:00:00 | product3 | 10 | 0 | 1 | 9
2010-09-23 00:00:00 | product4 | 15 | 0 | 0 | 15
2010-09-23 00:00:00 | product5 | 15 | 0 | 0 | 15
Spreadsheet: 172154d1344008070-auto-move-a-row-to-a-second-sheet-when-all-fields-are-entered-and-a-field-says-complete-returns2-for-public
Sheet: Sheet2

Customer | Products | Reasons for overdue | Fault reasons | [NAME]
me | apple | courier | bad weather | Open
you | banana | customer | courier | Closed
him | orange | us | bad crop | quarantine
her | mango | supplier | no explaination | pending
DO NOT ADD BELOW THIS LIST - RIGHT CLICK CELL ABOVE, CLICK 'INSERT', THEN SHIFT CELLS DOWN. SELECT ALL FROM CELL ABOVE TO ROW 2 (NOT INCLUDING TITLE CELL) AND SORT BY A-Z. DO NOT EXPAND SELECTION WHEN THIS CHOICE COMES UP (CLICK - CONTINUE WITH CURRENT SELECTION). | DO NOT ADD BELOW THIS LIST - RIGHT CLICK CELL ABOVE, CLICK 'INSERT', THEN SHIFT CELLS DOWN. SELECT ALL FROM CELL ABOVE TO ROW 2 (NOT INCLUDING TITLE CELL) AND SORT BY A-Z. DO NOT EXPAND SELECTION WHEN THIS CHOICE COMES UP (CLICK - CONTINUE WITH CURRENT SELECTION). | DO NOT ADD BELOW THIS LIST - RIGHT CLICK CELL ABOVE, CLICK 'INSERT', THEN SHIFT CELLS DOWN. SELECT ALL FROM CELL ABOVE TO ROW 2 (NOT INCLUDING TITLE CELL) AND SORT BY A-Z. DO NOT EXPAND SELECTION WHEN THIS CHOICE COMES UP (CLICK - CONTINUE WITH CURRENT SELECTION). | DO NOT ADD BELOW THIS LIST - RIGHT CLICK CELL ABOVE, CLICK 'INSERT', THEN SHIFT CELLS DOWN. SELECT ALL FROM CELL ABOVE TO ROW 2 (NOT INCLUDING TITLE CELL) AND SORT BY A-Z. DO NOT EXPAND SELECTION WHEN THIS CHOICE COMES UP (CLICK - CONTINUE WITH CURRENT SELECTION). | DO NOT ADD BELOW THIS LIST - RIGHT CLICK CELL ABOVE, CLICK 'INSERT', THEN SHIFT CELLS DOWN. SELECT ALL FROM CELL ABOVE TO ROW 2 (NOT INCLUDING TITLE CELL) AND SORT BY A-Z. DO NOT EXPAND SELECTION WHEN THIS CHOICE COMES UP (CLICK - CONTINUE WITH CURRENT SELECTION).
Spreadsheet: 138028d1327491123-excel-2007-multiple-count-from-a-number-of-cells-into-1-cell-muliple-counts-witin-one-column-100112-2
Sheet: Sheet1

MONTH | ACTION | ACTIONS | type | PLACEMENT
JAN | OPERATOR | 1 | DOWN | Front
JAN | OUTSOURCE | 2 | DEGRADED | back
JAN | REPAIR | 1 | DOWN | Front
JAN | REPAIR | 2 | DEGRADED | back
JAN | OPERATOR | 1 | DEGRADED | Front
JAN | OUTSOURCE | 2 | DOWN | back
FEB | REPAIR | 1 | DOWN | Front
JAN | REPAIR | 1 | DEGRADED | back
MAR | REPAIR | 1 | DEGRADED | back
How many Calls in:
 | January that are Down & degraded, with 1 as an action, and are placed in the Front
How do i add all the scenarios together to get the right answer in 1 formula???
solution
3
I am currently using this formula, but When I have added the red bits it now doesn't work?!!?
IF(B83=0,"",(SUMPRODUCT(('Raw Data'!$B$2:$B$2000='Response Time'!A83)*('Raw Data'!$P$2:$P$2000="Operator")*('Raw Data'!$AS$2:$AS$2000=1))+SUMPRODUCT(('Raw Data'!$B$2:$B$2000='Response Time'!A83)*('Raw Data'!$P$2:$P$2000="Repair")*('Raw Data'!$AS$2:$AS$2000=1))+SUMPRODUCT(('Raw Data'!$B$2:$B$2000='Response Time'!A83)*('Raw Data'!$N$2:$N$2000="DOWN")*('Raw Data'!$AS$2:$AS$2000=1))+SUMPRODUCT(('Raw Data'!$B$2:$B$2000='Response Time'!A83)*('Raw Data'!$AD$2:$AD$2000="FRONT")*('Raw Data'!$AS$2:$AS$2000=1))))
Spreadsheet: john_griffith__15866__11_12_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 59 | 400 | 500 | 41.9 | 52.5 | 1.75 | 2001-11-12 10:30:00
 | HU F2 | 60 | 725 | 825 | 43.8 | 49.9 | 1.77 | 2001-11-12 10:30:00
 | HU G2 | 62 | 1000 | 1100 | 44.4 | 48.9 | 1.82 | 2001-11-12 10:30:00
 | [NAME] | 62 | 1150 | 1275 | 43.9 | 48.7 | 1.8 | 2001-11-12 10:30:00
 | [NAME] | 68 | 1375 | 1500 | 42.7 | 46.6 | 1.91 | 2001-11-12 10:30:00
 | [NAME] | 68 | 1475 | 1600 | 41.4 | 45 | 1.85 | 2001-11-12 10:30:00
 | [NAME] | 68 | 1550 | 1700 | 39.9 | 43.8 | 1.79 | 2001-11-12 10:30:00
 | HU N2 | 68 | 1575 | 1725 | 38.1 | 41.7 | 1.71 | 2001-11-12 10:30:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: drew_fossum__8994__Fixed3_103100
Sheet: Elpaso_6

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
EL PASO ENERGY MARKETING COMPANY_6
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | IF-DEMARC |  | (4) | (4) | (4)
2002-06-01 00:00:00 |  | ENA | 3.3 |  | -2000000
2002-07-01 00:00:00 |  | ENA | 3.3 |  | -3000000
2002-08-01 00:00:00 |  | ENA | 3.3 |  | -3000000
2002-09-01 00:00:00 |  | ENA | 3.3 |  | -3000000
2002-10-01 00:00:00 |  | ENA | 3.3 |  | -4000000
2002-06-01 00:00:00 |  | EL PASO | 2.32 |  | -2000000
2002-07-01 00:00:00 |  | EL PASO | 2.32 |  | -3000000
2002-08-01 00:00:00 |  | EL PASO | 2.32 |  | -3000000
2002-09-01 00:00:00 |  | EL PASO | 2.32 |  | -3000000
2002-10-01 00:00:00 |  | EL PASO | 2.32 |  | -4000000
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 99104d1297859928-vlookup-result-not-clickable-hyperlink-concept-structuur-hyperlink-documentatie
Sheet: orignal template

 |  |  |  |  |  |  |  |  |  |  |  |  |  | En |  | LCP/DCS=1 |  | [NAME] | 1
 |  |  |  |  |  |  |  |  | En |  | Omkasting=1 |  |  | En |  | LCP/DCS=0 |  | [NAME] | 2
 |  |  |  |  | En |  | MCP=1 |  |  |  |  |  |  | En |  | LCP/DCS=1 |  | [NAME] | 3
 |  |  |  |  |  |  |  |  | En |  | Omkasting=0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | En |  | LCP/DCS=0 |  | [NAME] | 4
 | Als |  | KA2S=1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | En |  | LCP/DCS=1 |  | [NAME] | 5
 |  |  |  |  |  |  |  |  | En |  | Omkasting=1
 |  |  |  |  | En |  | MCP=0 |  |  |  |  |  |  | En |  | LCP/DCS=0 |  | [NAME] | 6
 |  |  |  |  |  |  |  |  | En |  | Omkasting=0 |  |  | En |  | LCP/DCS=1 |  | [NAME] | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | En |  | LCP/DCS=0 |  | [NAME] | 8