tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57436d1257561844-summing-total-with-pushbutton-testtt2
Sheet: Class A2

 | Surname | Forename | BGC | SMC | Gender | Score A | Score B | Score C
 | Five | [NAME] | Y | 3 | B | 4 | 4 | 4
 | Six | [NAME] | N | 5 | B | 5 | 5 | 5
 | Seven | Jojo | Y | 7 | G | 6 | 6 | 6
Spreadsheet: 714805d1611379580-how-to-find-offset-of-value-found-in-matrix-example-5-ans
Sheet: Sheet1

 |  | Customer | Total [NAME] |  |  |  |  |  |  |  |  |  |  |  | Option 1 | Option 2 | Option 3 | Cost 1 | Cost 2 | Cost 3
 |  | [NAME] |  | Apple |  |  | Ford |  |  |  |  |  |  | ABC Co. | Apple | Samsung | [NAME] | 1000 | 800 | 750
 |  | [NAME] |  |  | Fruit | Blue |  |  |  |  |  |  |  | DEF Co. | Chocolate | Fruit | Pastry | 0.8 | 1.75 | 1.35
 |  | [NAME] |  | [NAME] | Chocolate |  | GMC |  |  |  |  |  |  | GHI Co. | Red | Blue | Yellow | 5 | 8 | 3
 |  | Sidney |  |  | Pastry | Red |  | Small |  |  |  |  |  | JKL Co. | GMC | Ford | Dodge | 300 | 100 | 200
 |  | Samantha |  |  |  |  | GMC |  |  |  |  |  |  | MNO Co. | Small | Normal | Large | 20 | 30 | 40
 |  | Customer | Total [NAME]
 |  | [NAME] | 0 | Apple |  |  | Ford
 |  | [NAME] | 0 |  | Fruit | Blue
 |  | [NAME] | 0 | [NAME] | Chocolate |  | GMC
 |  | Sidney | 0 |  | Pastry | Red |  | Small
 |  | Samantha | 0 |  |  |  | GMC
Spreadsheet: 64126d1264993953-excel-2007-formula-for-multiple-criteria-mandy1010
Sheet: Results

AHGFE | 1
BAHGF | 2
CBAHG | 3
ABCDE | 0
 |  |  | Should Return
Search for: | Total | Amt: | Total | Amt:
933 W Out Full 551 SN |  |  | 20 | 2000
933 WO Out Full 551 SN |  |  | 200 | 4500
933 WO Out Full 571 PT |  |  | 150 | 4500
939 WO Out Full 551 SN |  |  | 20 | 1500
939 WO Out LUP 551 SN |  |  | 0 | 0
939 WO Out PEP 551 SN |  |  | 0 | 0
999 W Out Full 551 SN |  |  | 50 | 7500
Spreadsheet: 820495d1678127828-count-not-matching-filter-book-copy
Sheet: Sheet1

 |  | No Loto | PPE | [NAME] | No/wrong fire extinguisher. | Wrong info on permit | Area not specified | Signiture not applied. | Test
 |  | No Permit Displayed | No Ventilation. | No Fire Watch | Poor Visibility | Coshh | Time not specified. | Weather/tempreture | test1
 |  | Unsafe practices | [NAME]. | Spills | Dust | No dates attached. | [NAME] not attached.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SUMPRODUCT(SUBTOTAL(3,OFFSET(C8:E35,ROW(C8:E35)-MIN(ROW(C8:E35)),,1))+0)
Contractor | Permit Number | Hazards/none-compliance's/failures
emcore |  | No Loto |  |  |  |  | No Loto
emcore |  | PPE |  |  |  |  | No Permit Displayed
emcore |  | [NAME] |  |  |  |  | Unsafe practices |  |  | =SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B18,ROW(B2:B18)-MIN(ROW(B2:B18)),,1)),ISNUMBER(SEARCH("Test",B2:B18))+0)
SPS |  | No Loto |  |  |  |  | [NAME]
SPS |  | PPE |  |  |  |  | No Fire Watch
 |  | Test |  |  |  |  | Spills
 |  | Test |  |  |  |  | Poor Visibility.
 |  |  |  |  |  |  | No/wrong fire extinguisher.
 |  |  |  |  |  |  | [NAME].
 |  |  |  |  |  |  | Dust
 |  |  |  |  |  |  | PPE
 |  |  |  |  |  |  | Wrong info on permit.
 |  |  |  |  |  |  | COSHH
 |  |  |  |  |  |  | No Ventilation.
 |  |  |  |  |  |  | No dates attached.
 |  |  |  |  |  |  | Area not specified
 |  |  |  |  |  |  | Time not specified.
 |  |  |  |  |  |  | [NAME] not attached.
 |  |  |  |  |  |  | Signiture not applied.
Spreadsheet: 329536d1404330569-lookup-formula-to-pull-multiple-answers-to-a-row-lookup-scenario
Sheet: Sheet1

 |  |  |  |  |  |  | Table to lookup from:
A |  |  |  |  |  |  | A | B
100007 |  |  |  |  |  |  | 100007 | 101
100012 |  |  |  |  |  |  | 100007 | 101
100014 |  |  |  |  |  |  | 100007 | 361
100015 |  |  |  |  |  |  | 100012 | 83
100016 |  |  |  |  |  |  | 100012 | 257
100024 |  |  |  |  |  |  | 100012 | 329
100032 |  |  |  |  |  |  | 100014 | 298
100037 |  |  |  |  |  |  | 100014 | 343
100039 |  |  |  |  |  |  | 100014 | 308
100042 |  |  |  |  |  |  | 100015 | 83
100044 |  |  |  |  |  |  | 100015 | 83
100045 |  |  |  |  |  |  | 100015 | 80
100046 |  |  |  |  |  |  | 100016 | 264
100047 |  |  |  |  |  |  | 100016 | 286
100050 |  |  |  |  |  |  | 100016 | 125
100056 |  |  |  |  |  |  | 100024 | 118
 |  |  |  |  |  |  | 100024 | 395
 |  |  |  |  |  |  | 100024 | 391
 |  |  |  |  |  |  | 100032 | 174
 |  |  |  |  |  |  | 100037 | 170
 |  |  |  |  |  |  | 100039 | 376
 |  |  |  |  |  |  | 100039 | 352
 |  |  |  |  |  |  | 100042 | 407
 |  |  |  |  |  |  | 100044 | 273
 |  |  |  |  |  |  | 100044 | 295
 |  |  |  |  |  |  | 100045 | 167
 |  |  |  |  |  |  | 100046 | 335
 |  |  |  |  |  |  | 100047 | 307
 |  |  |  |  |  |  | 100047 | 321
 |  |  |  |  |  |  | 100050 | 387
 |  |  |  |  |  |  | 100050 | 448
 |  |  |  |  |  |  | 100050 | 684
 |  |  |  |  |  |  | 100056 | 286
 |  |  |  |  |  |  | 100056 | 227
Spreadsheet: 680743d1591177560-table-generator-example
Sheet: Sheet1

 | Start | 0
 | End | 10 |  | X | Y
 | Interval | 1 |  | 0
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 479417d1473351575-mid-function-problem-mid
Sheet: Sheet1

2016-07-28 00:00:00 | THU | -5.9
2016-07-29 00:00:00 | fri
 |  | 4
2016-08-01 00:00:00 | mon
2016-08-02 00:00:00 | tue
2016-08-03 00:00:00 | wed
2016-08-04 00:00:00 | thu
2016-08-05 00:00:00 | fri
 |  | -202.15
2016-08-08 00:00:00 | mon
2016-08-09 00:00:00 | tue
2016-08-10 00:00:00 | wed
2016-08-11 00:00:00 | thu
2016-08-12 00:00:00 | fri
 |  | 6.9 |  |  | figures in yellow cell are weekly figures so they has to be seperately averaged
2016-08-15 00:00:00 | mon
2016-08-16 00:00:00 | tue
2016-08-17 00:00:00 | wed
2016-08-18 00:00:00 | thu
2016-08-19 00:00:00 | fri
 |  | -17.9
2016-08-22 00:00:00 | mon
2016-08-23 00:00:00 | tue
2016-08-24 00:00:00 | wed
2016-08-25 00:00:00 | thu | 13
 |  |  |  |  | figures in red cell are month wise(Last thursday of the month)----first is difference of 25AUG in comparison to 28jul , and second is average of (30 jun, 28 jul)
2016-08-26 00:00:00 | fri | 11
2016-08-27 00:00:00 | sat
 | in formulas | first is difference of 26AUG in comparison to 25AUG , so should come -30~ and second is average of 5 weeks( 30-jul, 6aug, 13 aug, 20aug, AND 26 aug
 |  | mid function IS USED AS ONLY RELEVANT NUMBERS FROM A STRING HAS TO BE CONSIDERED
 |  | BUT THIS CREATED PROBLEM WHEN THE NUMBER OF NUMERALS TO BE CONSIDERED ARE NOT ENOUGH AND HAS OTHER CHARACTER/SYMBOLS BEHIND THE SIGN(WHICH IS NORMAL)
 |  | In future the case can come where there may be character/symbols ahead of it and delimiter used is # , so if possible make that version also
 |  | So has to make formula such that only numerals that are at starting of value is considered(till 1 places after decimal, if there is decimal)
Spreadsheet: 840741d1692949703-formula-needed-for-different-price-when-brought-at-different-qty-book2-24-
Sheet: Sheet1

No of apple | Price | Average Price |  |  |  |  |  |  | Manual Trial & Error |  | [NAME] | Apple Left |  |  | Manual Trial & Error |  | [NAME] | Apple Left
1 | 6 |  |  |  |  |  |  | No of apple | Multiple | Amount |  |  |  | No of apple | Multiple | Amount |  | 87
3 | 17 |  |  |  | No of Apples | 87 |  | 13 | 6 |  |  |  |  | 12 | 7 |  | 84 | 3
5 | 25 |  |  |  | Price |  |  |  | 1 |  |  |  |  | 3 | 1 | 17 | 3 | 0
12 | 55 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Total Price |  |  |  |  |  | Total Price | 402
 |  |  |  |  |  |  |  | Is it possible to compute in a single formula?
Spreadsheet: 97579145-1928-48a3-b44c-b37898cc8aa1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6787 | 51831 | L.waldo | [NAME] | USA | 615 | 00:19:18 | 00:05:07 | 00:58:56 | 00:03:43 | 00:37:59 | 1 | 02:05:02
6787 | 8022 | [NAME] | Marriott | CAN | 616 | 00:42:24 | 00:04:58 | [NAME] | 00:04:40 | 00:35:25 | 2 | 02:24:07
6787 | 30564 | [NAME] | Kirillov | RUS | 614 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 1482dd40-c719-476e-99da-bdff71e62242
Sheet: EDU

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program
 | TOTAL
 | COURSE
5 | EDU 290 | 1 | X | 1
 | TOTAL | 1 |  | 1
 | PERCENTAGE
Spreadsheet: vkaminski__40816__Val
Sheet: Sheet2

ENE Price | Shares Delivered | Value
48.55 | 18012590
49.55 | 17003509
50.55 | 16034351
51.55 | 15102794
52.55 | 14206691
53.55 | 13344056
54.55 | 12513049
55.55 | 11711960
56.55 | 10939204
57.55 | 10193303
58.55 | 9472881
59.55 | 8776654
60.55 | 8103425
61.55 | 7452071
62.55 | 6821543
63.55 | 6210860
64.55 | 5619097
65.55 | 5045390
66.55 | 4488924
67.55 | 3948934
68.55 | 3424698
69.55 | 2915538
70.55 | 2420812
71.55 | 1939914
72.55 | 1472273
73.55 | 1017349
74.55 | 574629
75.55 | 143630
 |  | 0
ExercisePrice =
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: Condo FHA Refi

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Final Approval |  | True | False | Team Rosa | Final Approval
CD |  | True | False | Team Rosa | CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
Spreadsheet: 494243d1482272547-help-with-if-statements-or-filters-purchase-orders-greater-than-or-equal-to-15k
Sheet: Pivot Table

Sum of Extended Amount
Ordered Item | Extended Amount | Total
2102-1605 | 985 | 47280
2102-1605 Total |  | 47280
2102-1610 | 1850 | 131350
 | 3700 | 125800
 | 5550 | 22200
 | 7400 | 44400
 | 11100 | 22200
 | 12950 | 25900
2102-1610 Total |  | 371850
48230000 | 600 | 21600
 | 900 | 22500
48230000 Total |  | 44100
482315540 | 4500 | 18000
482315540 Total |  | 18000
482316535 | 1800 | 36000
482316535 Total |  | 36000
482316540 | 1800 | 48600
 | 3600 | 82800
 | 5400 | 43200
 | 9000 | 18000
482316540 Total |  | 192600
482316545 | 1800 | 18000
 | 2700 | 24300
 | 3600 | 28800
 | 6300 | 18900
 | 9000 | 18000
482316545 Total |  | 108000
482316550 | 1800 | 16200
482316550 Total |  | 16200
482318500 | 2380 | 16660
482318500 Total |  | 16660
482802635 | 2980 | 20860
 | 5960 | 23840
482802635 Total |  | 44700
482802640 | 2980 | 20860
 | 5960 | 17880
482802640 Total |  | 38740
482802645 | 2980 | 17880
482802645 Total |  | 17880
48321060 | 2550 | 22950
48321060 Total |  | 22950
48321064 | 2550 | 28050
48321064 Total |  | 28050
48321074 | 2550 | 43350
48321074 Total |  | 43350
48552312 | 5358.18 | 16074.54
48552312 Total |  | 16074.54
48670230 | 2200 | 15400
48670230 Total |  | 15400
48670232 | 2200 | 30800
48670232 Total |  | 30800
48670234 | 2200 | 24200
48670234 Total |  | 24200
48811114 | 1125 | 30375
48811114 Total |  | 30375
48811234 | 1200 | 38400
48811234 Total |  | 38400
48811237 | 1200 | 26400
48811237 Total |  | 26400
48824012 | 675 | 15525
48824012 Total |  | 15525
488515530 | 2980 | 29800
 | 5960 | 41720
 | 8940 | 17880
488515530 Total |  | 89400
488515535 | 2980 | 23840
 | 5960 | 47680
 | 8940 | 17880
488515535 Total |  | 89400
76310 | 1221.84 | 19549.44
76310 Total |  | 19549.44
77101064 | 800 | 38400
77101064 Total |  | 38400
77101074 | 800 | 40000
77101074 Total |  | 40000
77101084 | 800 | 27200
77101084 Total |  | 27200
77102060 | 900 | 63900
77102060 Total |  | 63900
77102064 | 900 | 46800
77102064 Total |  | 46800
77102070 | 900 | 47700
77102070 Total |  | 47700
77102074 | 900 | 17100
77102074 Total |  | 17100
77102080 | 900 | 15300
77102080 Total |  | 15300
77701208 | 3189.61 | 15948.05
77701208 Total |  | 15948.05
77701408 | 3189.61 | 15948.05
77701408 Total |  | 15948.05
Grand Total |  | 1770180.08
Spreadsheet: 766659d1643987855-pivot-data-to-statements-to-email-sample-johanvd-
Sheet: 1.Raw Data

Name | Surname | Company | Amount
Test 1 | Test 1 | Test 1 | 100
Test 2 | Test 2 | Test 2 | 101
Test 3 | Test 3 | Test 3 | 102
Test 4 | Test 4 | Test 4 | 103
Test 5 | Test 5 | Test 5 | 104
Test 6 | Test 6 | Test 6 | 105
Test 7 | Test 7 | Test 7 | 106
Test 8 | Test 8 | Test 8 | 107
Test 9 | Test 9 | Test 9 | 108
Test 10 | Test 10 | Test 10 | 109
Test 11 | Test 11 | Test 11 | 110
Test 12 | Test 12 | Test 12 | 111
Test 13 | Test 13 | Test 13 | 112
Test 14 | Test 14 | Test 14 | 113
Test 15 | Test 15 | Test 15 | 114
Test 16 | Test 16 | Test 16 | 115
Test 1 | Test 1.2 | Test 1.2 | 100.2
Test 2 | Test 2 | Test 2 | 101
Test 3 | Test 3 | Test 3 | 102
Test 4 | Test 4 | Test 4 | 103
Test 5 | Test 5 | Test 5 | 104
Test 6 | Test 6 | Test 6 | 105
Test 7 | Test 7 | Test 7 | 106
Test 8 | Test 8 | Test 8 | 107
Test 9 | Test 9 | Test 9 | 108
Test 10 | Test 10 | Test 10 | 109
Test 11 | Test 11 | Test 11 | 110
Test 12 | Test 12 | Test 12 | 111
Test 13 | Test 13 | Test 13 | 112
Test 14 | Test 14 | Test 14 | 113
Test 15 | Test 15 | Test 15 | 114
Test 16 | Test 16 | Test 16 | 115
Spreadsheet: 132174d1323565311-if-and-or-statement-or-equivalent-question-book1
Sheet: Sheet1

75 | 86 | 87
77 | 77 | 90
88 | 90 | 90
90 | 82 | 70
95 | 96 | 72
85 | 85 | 70
35 | 75 | 90
Spreadsheet: 01766c01-6b4e-4245-9675-5d77b2c5f255
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Date Created: | 2010-02-16 21:30:46.870000 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2 |  | Manufacturer | E-Flite |  | MSH
 |  | Model | Blade 400 |  | Protos
 |  | Average Crash Cost:
 |  | Head | 16.93225 |  | 42.24733333333334
 |  | Tail | 0.987 |  | 6.188499999999999
 |  | Airframe | 5.880500000000001 |  | 22.634
 |  | DriveTrain | 4.670999999999999 |  | 2.396
 |  | Electronics | 0 |  | 0
 |  | Misc | 0.1695 |  | 0
 |  | Total Average Crash Cost | 28.64025 |  | 73.46583333333334
 |  | Full part break down of parts inc in above | Cost (with crash rating multiplier and quantity applied) | Part # - Part Desc | Cost (with crash rating multiplier and quantity applied) | Part # - Part Desc
 |  |  | 0.21125 | B400 HEAD [NAME] | 2.395 | MS Heli Spindle
 |  |  | 11.25 | [NAME] ROTOR BLADE SET WOOD WHITE | 0.978 | MS Heli Tail Shaft
 |  |  | 0.7635 | [NAME] BLADE GRIP/HOLDER SET | 2.0965 | MS Heli Flybar Rod
 |  |  | 1.945 | B400 SPINDLE/FEATHERING SHAFT (2) | 0.6725 | MS Heli Head [NAME]
 |  |  | 0.429 | B400 HEAD BLOCK/ROTOR HOUSING SET | 0.4483333333333333 | MS Heli Servo Rod Set
 |  |  | 0.2995 | [NAME] SET | 1.107 | MS Heli Tail Control Rod Set
 |  |  | 1.356 | [NAME] (2) | 3.6225 | MS Heli Boom
 |  |  | 0.1695 | B400 BALL LINK SET (20) | 1.7975 | MS Heli Tail Boom Brace
 |  |  | 0.678 | [NAME] ROD/PUSHROD SET | 0.4995000000000001 | MS Heli Main Blade Holders
 |  |  | 0.678 | [NAME] STRUT SET WHITE | 3.045 | MS Heli Flybar Carrier
 |  |  | 0.678 | [NAME] SKID SET BLACK | 3.595 | MS Heli Tail Box
 |  |  | 2.145 | [NAME] (2) | 0.5085 | MS Heli Tail Blade Holders
 |  |  | 0.219 | [NAME] | 4.673999999999999 | MS Heli Fin Set Assembly
 |  |  | 2.307 | [NAME] WITH ONEWAY BEARING | 1.545 | MS Heli Canopy Mounting Post
 |  |  | 1.4975 | B400 TAIL BOOM (2) | 10.995 | MS Heli Canopy (White)
 |  |  | 0.339 | B400 TAIL BOOM BRACE SUPPORT SET | 32.193 | MS Heli SAB Carbon Fiber Main Blades
 |  |  | 0.339 | B400 TAIL CASE SET | 2.396 | MS Heli Solid Steel Main Shaft (2)
 |  |  | 0.389 | B400 TAIL ROTOR SHAFT AND DRIVE PULLEY | 0.8975 | MS Heli Mixers Plastic Only
 |  |  | 0.259 | B400 TAIL ROTOR BLADE SET
 |  |  | 0.438 | B400 CANOPY MNT ROD & GROMMET SET
 |  |  | 2.25 | B400 BODY/CANOPY WHITE W/DECALS
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: sf

Smith. [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: 168062d1342203815-more-excel-work-with-duplicates-filled-positions-by-department
Sheet: Category Lookups

Category | Department
Accounting/Finance | Finance
Business Development | SPBD
Claims | Claims
Compliance | Compliance
Human Resources | HROD
Information Technology | information Systems
Medical Management | Medical Management
Member Operations | Member Operations
Network Development | Network Development
Transportation | Member Operations
Spreadsheet: 168260d1342353517-conditional-format-condtional-formats
Sheet: Soution-2

RANK | RATEE | Assigned To | Date Assigned | Days in your Que | Dates due to Mgt | Days due to CSS | CLOSE OUT
Superintendent | [NAME] | [NAME] | 2012-05-01 00:00:00 |  |  |  | 2012-07-12 00:00:00
[NAME] | [NAME] | [NAME] | 2012-05-20 00:00:00 |  |  |  | 2012-06-09 00:00:00
 | RED | =E3<50
 | YELLOW | =AND(E3>50,E3<=60)
 | GREEN | =E3>60
I ve changed th formula and now condiotnal formula check trhe Day in your que! I think it will solve the problem or ???
So here, I have a [NAME] and a Super…  Foremam:  the report was assined to [NAME] on 20 Jun 2012.  It has been in her que for 25 days.  The report wil close out on 25 August.  So if today's date is 50 days or less then the close out date, the cell will turn red. And for superintendent will turn red if today's date is within 45 days of the closeout date.                   Do we need a cell that has (TODAY) - the Close out date???
 |  |  |  |  |  |  |  | Foreman 50 & 40
 |  |  |  |  |  |  |  | Super 45 & 35
Spreadsheet: 100734d1298997252-excel-2007-vlookup-pic-doodles
Sheet: Invoices

Raw Data Index Page | Column to |  |  |  | Data needing
 | look up by |  |  |  | to be transferred
 | v |  |  |  | v
 |  |  |  |  |  |  |  |  | I needed to insert a blank row here to make Pivot Tables work |  | PO # | 764580 | <<[NAME] this down and select PO#
Invoice Number | PO # | Line # | Ticket Date | Sub-Total | Total | Tonnes | Date Sent for Payment | Date Paid On | Payment Notes
19127520 | 764593 |  | 2011-01-26 00:00:00 | 6068.31 | 6371.7255 |  | 2011-02-22 00:00:00 |  |  |  | Sum of Total
19159005 | 764593 |  | 2011-02-02 00:00:00 | 5037.54 | 5289.417 |  | 2011-02-22 00:00:00 |  |  |  | Ticket Date | Total | This is just one of many possible ways of doing a pivot table
19159006 | 764593 |  | 2011-01-27 00:00:00 | 6086.31 | 6390.625500000001 |  | 2011-02-22 00:00:00 |  |  |  | 2011-01-26 00:00:00 | 8336.3595
19159007 | 764593 |  | 2011-01-31 00:00:00 | 7135.08 | 7491.834 |  | 2011-02-22 00:00:00 |  |  |  | 2011-01-27 00:00:00 | 3099.0225
19166615 | 764593 |  | 2011-02-02 00:00:00 | 7135.08 | 7491.834 |  | 2011-02-22 00:00:00 |  |  |  | 2011-01-31 00:00:00 | 8140.209
19166732 | 764580 |  | 2011-01-26 00:00:00 | 7939.39 | 8336.3595 |  | 2011-02-22 00:00:00 |  |  |  | 2011-02-01 00:00:00 | 13385.358
19173174 | 744447 |  | 2010-12-20 00:00:00 | 15731.55 | 16518.1275 |  | 2011-02-22 00:00:00 |  |  |  | Grand Total | 32960.949
19173175 | 764593 |  | 2011-02-03 00:00:00 | 6083.31 | 6387.4755 |  | 2011-02-22 00:00:00
19173273 | 764580 |  | 2011-01-27 00:00:00 | 2951.45 | 3099.0225 |  | 2011-02-22 00:00:00
19173274 | 764580 |  | 2011-01-31 00:00:00 | 7752.58 | 8140.209 |  | 2011-02-22 00:00:00
19173747 | 764596 |  | 2011-01-26 00:00:00 | 12746.49 | 13383.8145 |  | 2011-02-26 00:00:00
19173750 | 764596 |  | 2011-01-27 00:00:00 | 6606.62 | 6936.951 |  | 2011-02-22 00:00:00
19179848 | 764593 |  | 2011-02-04 00:00:00 | 6086.31 | 6390.625500000001 |  | 2011-02-22 00:00:00
19179849 | 764593 |  | 2011-02-05 00:00:00 | 6086.31 | 6390.625500000001 |  | 2011-02-22 00:00:00
19179922 | 764580 |  | 2011-02-01 00:00:00 | 12747.96 | 13385.358 |  | 2011-02-22 00:00:00
19180206 | 764596 |  | 2011-01-31 00:00:00 | 14703.16 | 15438.318 |  | 2011-02-22 00:00:00
19180207 | 764596 |  | 2011-02-01 00:00:00 | 19669.84 | 20653.332 |  | 2011-02-22 00:00:00
19189629 | 764593 |  | 2011-02-06 00:00:00 | 6086.31 | 6390.625500000001 |  | 2011-02-22 00:00:00
19189630 | 764593 |  | 2011-02-07 00:00:00 | 6086.31 | 6390.625500000001 |  | 2011-02-22 00:00:00
Spreadsheet: lisa_gang__22477__Hanson Scheduling Model_6_12
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-06-12 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 14.22 | 13.188 | 13.86 | 15.144 | 16.536 | 16.14 | 17.04 | 19.656 | 20.556 | 22.26 | 25.08 | 20.256 | 24.744 | 26.484 | 25.854 | 24.642 | 23.838 | 22.14 | 2.448 | 8.016 | 12.816 | 13.572 | 13.932 | 13.908 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 27.51023590669259 | 27.51023590669259 | 27.51023590669259 | 27.51023590669259 | 28.26023590669259 | 28.26023590669259 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 28.46023590669258 | 22.83523590669258 | 22.83523590669258 | 23.58523590669258 | 22.70523590669259 | 22.70523590669259 | 22.70523590669259 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 44115d1242758210-formula-producing-inconsistent-results-sauder-cash-flow-template
Sheet: Sheet2

Current Age | 60
Bucket 1 GR | 0.03
Bucket 2 GR | 0.05
Bucket 3 GR | 0.06
Bucket 4 GR | 0.06
Retirment Age | 66
Percentage of Net Worth in Cash | 0.02405509548795384
Percentage of Net Worth in Non Qaulified Accounts | 0.1943379638942947
Percentage of Net Worth in Qualified Accounts | 0.7816069406177515
Net Worth Total | 1799494
Tax Treatment | 0.2636327767694696
Pension | 12520
Social Security | 40800
Net Income Need | 200000
Bucket 1 Initial Value | 43287
Bucket 2 Initial Value | 349710
Bucket 3 Initial Value | 1239509
Bucket 4 Initial Value | 166988