tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730650d1619807906-formula-to-alamgamate-and-edit-payment-project
Sheet: Sheet1

Incorrect Entry:
Date | Code | Status | Paid | Breakdown
2021-04-30 00:00:00 | 12345 | Paid | 100 | Allocated to invoices
 |  |  |  | 86642,86643,86644,
 |  |  |  | on 30/04/21
A formula to create the following:
Date | Code | Status | Paid | Breakdown
2021-04-30 00:00:00 | 12345 | Paid | 100 | Allocated to invoices 86642, 86643, 86644, on 30/04/21
It's to amalgamate all three rows into the first row in column E and to add a space inbetween the 866 numbers.
Date | Code | Status | Paid | Breakdown
2021-04-30 00:00:00 | 12345 | Paid | 100 | Allocated to invoices
 |  |  |  | 86642,86643,86644,
 |  |  |  | on 30/04/21
Spreadsheet: 386125d1427621809-help-with-show-values-as-of-row-total-pivot
Sheet: Sheet1

Category | 1 | 2 | 3 | 4 | 5 | 6 | 7 | total 1-7 |  |  | Row Labels | Sum of 1 | Sum of 2 | Sum of 3 | Sum of 4 | Sum of 5 | Sum of 6 | Sum of 7 | Sum of total 1-7
q | 29 | 21 | 126 | 65 | 114 | 100 | 935 | 1390 |  |  | a | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
w | 8 | 2 | 51 | 14 | 32 | 16 | 41 | 164 |  |  | e | 7 | 14 | 48 | 56 | 108 | 87 | 831 | 1151
e | 7 | 14 | 48 | 56 | 108 | 87 | 831 | 1151 |  |  | i | 105 | 62 | 425 | 223 | 439 | 394 | 2487 | 4135
r | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | o | 1 | 1 | 11 | 13 | 10 | 18 | 85 | 139
t | 102 | 37 | 111 | 80 | 159 | 104 | 1012 | 1605 |  |  | p | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
y | 73 | 56 | 127 | 234 | 335 | 206 | 2499 | 3530 |  |  | q | 29 | 21 | 126 | 65 | 114 | 100 | 935 | 1390
u | 11 | 10 | 53 | 26 | 73 | 28 | 55 | 256 |  |  | r | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
i | 105 | 62 | 425 | 223 | 439 | 394 | 2487 | 4135 |  |  | s | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
o | 1 | 1 | 11 | 13 | 10 | 18 | 85 | 139 |  |  | t | 102 | 37 | 111 | 80 | 159 | 104 | 1012 | 1605
p | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | u | 11 | 10 | 53 | 26 | 73 | 28 | 55 | 256
a | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | w | 8 | 2 | 51 | 14 | 32 | 16 | 41 | 164
s | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | y | 73 | 56 | 127 | 234 | 335 | 206 | 2499 | 3530
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 336 | 203 | 952 | 711 | 1270 | 953 | 7945 | 12370
Spreadsheet: tracy_geaccone__40252__C0366-112458
Sheet: Dept_100169

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
CHURN/RELOCATION - Dept. 100169
April, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-03-16 00:00:00 | CHU01604009830000 |  | [NAME] | Phone-Lucent w/Expand Module/EB  4081/EB  4173 | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-03-16 00:00:00 | CHU01604009830001 |  | [NAME] | Boxes/EB  4081/EB  4173 | 1 | 95 | /EACH | 95
 |  |  |  |  |  |  | Ticket Total |  | 95
2001-03-16 00:00:00 | CHU01604009830002 |  | [NAME] | PC CPU/EB  4081/EB  4173 | 1 | 50 | /EACH | 50
 |  |  |  |  |  |  | Ticket Total |  | 50
2001-03-16 00:00:00 | CHU01604009830003 |  | [NAME] | Flat Screen/EB  4081/EB  4173 | 1 | 25 | /EACH | 25
 |  |  |  |  |  |  | Ticket Total |  | 25
2001-03-16 00:00:00 | CHU01604009830004 |  | [NAME] | Local Printer/EB  4081/EB  4173 | 1 | 25 | /EACH | 25
 |  |  |  |  |  |  | Ticket Total |  | 25
2001-03-16 00:00:00 | CHU01604009831000 |  | [NAME] | Phone-Lucent/EB  4078/EB  4145a | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-03-16 00:00:00 | CHU01604009831001 |  | [NAME] | Boxes/EB  4078/EB  4145a | 1 | 95 | /EACH | 95
 |  |  |  |  |  |  | Ticket Total |  | 95
2001-03-16 00:00:00 | CHU01604009831002 |  | [NAME] | [NAME]4078/EB  4145a | 1 | 50 | /EACH | 50
 |  |  |  |  |  |  | Ticket Total |  | 50
2001-03-16 00:00:00 | CHU01604009831003 |  | [NAME] | PC Monitor/EB  4078/EB  4145a | 1 | 25 | /EACH | 25
 |  |  |  |  |  |  | Ticket Total |  | 25
2001-03-16 00:00:00 | CHU01604009832000 |  | SHASHI [NAME] | Pick up and delete phone/EB  4084/OLD Terminate | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-03-16 00:00:00 | CHU01604009833000 |  | n/a n/a | Fax Machine/EB  4081/EB  4145m | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-03-16 00:00:00 | CHU01604009834000 |  | n/a n/a | Phone-Lucent/EB  4173/EB  4145u | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
2001-03-16 00:00:00 | CHU01604009834001 |  | n/a n/a | Phone Modification/EB  4173/EB  4145u | 1 | 10 | /EACH | 10
 |  |  |  |  |  |  | Ticket Total |  | 10
2001-03-16 00:00:00 | CHU01604009835000 |  | n/a n/a | Fax Line/EB  4081/OLD Terminate | 1 | 75 | /EACH | 75
 |  |  |  |  |  |  | Ticket Total |  | 75
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 825
 |  |  |  |  |  |  | Total for Dept_100169 |  | 825
Spreadsheet: 734133d1622003494-i-would-like-a-cell-to-auto-fill-based-on-the-value-of-another-d-and-d-nerd-help
Sheet: Monster List

 | Monster Name | Type | Level | Physical Save | Mental Save | Size | MV | # Attacks | Damage
Example: | Carrion Crawler | Aberrant | 6 | 10 | 12 | Large | 14 | 1 | 2d4
 | [NAME]
 | Beholder
 | Red Dragon
Spreadsheet: 870772d1717212296-finding-an-average-feedback-rating-for-each-name-example
Sheet: Sheet1

Row Labels | 4 | 5 | 6 | 7 | 8 | 9 | 10 | (blank) | Grand Total
NAME1 | 1 |  | 2 | 1 | 1 | 3 | 6 |  | 14
NAME2 |  |  | 1 |  | 1 | 2 | 6 |  | 10
NAME3 |  |  | 1 | 1 | 1 | 3 | 8 |  | 14
NAME4 | 1 | 2 | 1 | 1 | 3 | 7 | 18 |  | 33
NAME5 |  |  |  |  |  | 1 | 4 |  | 5
Spreadsheet: 805677d1668822528-conditional-formatting-time-hours-and-min-greater-than-or-less-than-time-in-another-cell-conditional-formatting-time-hours-and-min-greater-than-or-less-than-time-hours-and-min-in-another
Sheet: Teacher Aide 6

Teacher Aide Timetable and Work Pattern Calculator
Name: | Teacher Aide 6
Start Date: | 2023-02-03 00:00:00
Finish Date: | 2023-12-01 00:00:00
 | Monday | Tuesday | Wednesday | Thursday | Friday
Period 1 | 08:40:00 | 08:40:00 | 08:40:00 | 08:40:00 | 08:40:00
 | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00
Transition | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00 | 09:40:00
 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00
Period 2 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00 | 09:45:00
 | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00
[NAME] | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00 | 10:45:00
 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00
Interval | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00 | 11:05:00
 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00
Period 3 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00 | 11:25:00
 | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00
[NAME] | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00 | 12:25:00
 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00
Period 4 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00 | 12:40:00
 | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00
Break | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00 | 13:40:00
 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00
Period 5 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00 | 14:15:00
 | 15:15:00 | 15:15:00 | 15:15:00 | 15:15:00 | 15:15:00
Total (Hours:Mins)
10/20 Minute Paid Break for Less/More Than 5 Hours
Total for Week
Spreadsheet: 116427d1311824047-lookup-values-have-to-be-ascending-bank-money
Sheet: Bank Printout

 | Date
 | 2011-07-27 00:00:00
 | denomination | quantity | total
 | 100
 | 50
 | 20
 | 10
 | 5
 | 2
 | 1
 | 0.5
 | 0.2
 | 0.1
 |  | Total
Spreadsheet: 163016d1340148458-need-formula-to-recognize-blank-cells-as-zero-2012-2013-quarterly-stats_working-copy
Sheet: IMG's By Quarter

 |  | IMG Totals By Quarter
 | Quarter 1 |  |  |  | Quarter 2
 | Values |  |  |  | Values
Row Labels | Count of Training Level | Sum of Months |  | Row Labels | Count of Training Level2 | Sum of Months2
IMG | 25 | 81.25 |  | IMG | 35 | 103.75
FM | 16 | 52 |  | FM | 20 | 61.5
PGY1 | 9 | 29.25 |  | PGY1 | 10 | 32
PGY2 | 7 | 22.75 |  | PGY2 | 10 | 29.5
SM | 9 | 29.25 |  | SM | 15 | 42.25
PGY1 | 7 | 22.75 |  | PGY1 | 6 | 17
PGY2 | 1 | 3.25 |  | PGY2 | 7 | 18.75
PGY3 | 1 | 3.25 |  | PGY3 | 1 | 3.25
Grand Total | 25 | 81.25 |  | PGY4 | 1 | 3.25
 |  |  |  | Grand Total | 35 | 103.75
 | Quarter 3 |  |  |  | Quarter 4
 | Values |  |  |  | Values
Row Labels | Count of Training Level3 | Sum of Months3 |  | Row Labels | Count of Training Level4 | Sum of Months4
IMG | 49 | 118.5 |  | IMG | 37 | 117.5
FM | 35 | 76.25 |  | FM | 24 | 75.25
PGY1 | 19 | 39.25 |  | PGY1 | 13 | 42.25
PGY2 | 16 | 37 |  | PGY2 | 11 | 33
SM | 14 | 42.25 |  | SM | 13 | 42.25
PGY1 | 4 | 13 |  | PGY1 | 4 | 13
PGY2 | 7 | 22.25 |  | PGY2 | 6 | 19.5
PGY3 | 2 | 3.75 |  | PGY3 | 2 | 6.5
PGY4 | 1 | 3.25 |  | PGY4 | 1 | 3.25
Grand Total | 49 | 118.5 |  | Grand Total | 37 | 117.5
Spreadsheet: 815362d1674903721-i-want-to-apply-one-single-formula-with-25-if-conditions-if-function-issue-v1
Sheet: Sheet1

 |  |  |  | A | B
A | B | Result |  | 5 | 1
1 | 1 | 1
1 | 2 | 3
1 | 3 | 6
1 | 4 | 10
1 | 5 | 15
2 | 1 | 2
2 | 2 | 5
2 | 3 | 9
2 | 4 | 14
2 | 5 | 19
3 | 1 | 4
3 | 2 | 8
3 | 3 | 13
3 | 4 | 18
3 | 5 | 22
4 | 1 | 7
4 | 2 | 12
4 | 3 | 17
4 | 4 | 21
4 | 5 | 24
5 | 1 | 11
5 | 2 | 16
5 | 3 | 20
5 | 4 | 23
5 | 5 | 25
Spreadsheet: 63420d1264346081-results-from-multiple-sheets-to-table-example
Sheet: 69

Quote No. |  |  |  | Job Name
 |  |  |  | Type / Plot | Cheltenham |  | 69
Labour Times
Actual |  | Esimate |  | Plot / Type | Labour price | Total | Fixings | Profit
 | hrs |  | hrs | Joists 1st floor
 | hrs |  | hrs | Joists 2nd floor
 | hrs |  | hrs | Roof
 | hrs |  | hrs | Low Level
 | hrs |  | hrs | Garage Roof
 | hrs |  | hrs | First Fix
 | hrs |  | hrs | External doors
 | hrs |  | hrs | Second Fix
 | hrs |  | hrs | Final fix
 | hrs |  | hrs | Snag
 | hrs |  | hrs | [NAME]
 | hrs |  | hrs | Total
Plot Notes
Gr | 1st | 2nd | Qty | Item | labour total | my total | fixings | Time
42 |  |  |  | Joist & Decking TJI psm 1st floor
 |  |  |  | Trad System in & out
 |  |  |  | Total Joist 1st floor
 |  |  |  | Joist & Decking TJI psm 2nd floor
 |  |  |  | Trad System in & out
 |  |  |  | Total Joist 2nd floor
42 |  |  |  | Trusses psm
 |  |  |  | Trad System in & out
1 |  |  |  | Pediment [NAME]
1 |  |  |  | [NAME]
 |  |  |  | [NAME]made Fibreglass
 |  |  |  | Attic Trusses psm
 |  |  |  | Velux
 |  |  |  | Valley pr/m Trusses
 |  |  |  | Hip pr/m
 |  |  |  | Hand cut section
 |  |  |  | Total Roof
6 |  |  |  | Low Levels
 |  |  |  | Garage Roof
 |  |  |  | Trad System in & out
 |  |  |  | Total Garage Roof
 |  |  |  | Stairs -Straight Flight
 |  |  |  | Stairs -Kite over Garage wall
 |  |  |  | Stairs-Double kite
 |  |  |  | Stairs-Double 1/4 Landing
1 |  |  |  | Stairs-Kite
2 |  |  |  | Block casing
2 | 6 |  |  | [NAME] casing
1 | 1 |  |  | Plasterboard catch noggins(per floor)
2 | 2 |  |  | Soil boxing
 |  |  |  | Metal Studding pm
6 | 20 |  |  | Studding pm
2 | 3 |  |  | Window board
2 |  |  |  | Fix gas & electric Box
 |  |  |  | Mastic Joists
 |  |  |  | Temp handrail
 |  |  |  | Protect Stairs
 |  |  |  | Total 1st Fix
1 |  |  |  | Front/Back Door & Frame & Lock
 |  |  |  | Fire door
3 | 6 |  |  | Lightweight Doors
34 | 46 |  |  | Skirting
1.3 | 4 |  |  | Pipe Boxings p/m
 |  |  |  | Plant on door stops
 |  |  |  | Arcs
 |  |  |  | Drilling and cutting latches
1.3 |  |  |  | Strings hand rails, spindles per flight
 |  |  |  | Total 2nd Fix
 | 2 |  |  | Bath/Shower Panel
 | 1 |  |  | [NAME]
 |  |  |  | Ply Bathroom Floors PSM
 |  |  |  | Door furniture
 |  |  |  | Intumescent strips
 |  |  |  | Re-hang doors
 |  |  |  | Total Final Fix
 |  |  |  | Snag price
Spreadsheet: 746696d1630951873-how-many-names-are-common-between-lists-and-how-many-are-not-in-any-list-sales-sample
Sheet: Sales

[NAME]
Leanne
[NAME]
Imogen
Rochelle
[NAME]
Riley
Victoria
Lily
[NAME]
Violet
Nova
[NAME]
[NAME]
Zoe
Stella
Everly
Isla
Leah
Lillian
Addison
Willow
[NAME]
Paisley
[NAME]
Naomi
Eliana
Brooklyn
Elena
[NAME]
Spreadsheet: 113769d1309603103-copy-values-from-multiple-files-copy-of-anm-lan-till-ngbys-sommarpool-2010
Sheet: Blad1

Tidstämpel | Namn: | Personnummer: | [NAME] | Söndag | Har möjlighet att skjutsa [NAME] till och från tävlingen:
2011-07-01 14:16:45 | [NAME] | 197810030192 | p12 | klass 1, elit | Nej
2011-07-01 15:40:58 | Tore | 199810250211 | P13 | Klass2 | Ja två från gullmarsplan
2011-07-01 17:20:52 | whooptidoo | 197810030192 | klass1 | pa | nope
2011-07-01 17:23:44 | [NAME] | 199910100123 | p9 | p8 | nej
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: MK

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: andy_zipper__615__11_20_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 53 | 375 | 475 | 64.1 | 81.2 | 2.42 | 2001-11-20 14:58:00
 | HU F2 | 53 | 730 | 810 | 55.2 | 61.3 | 1.94 | 2001-11-20 14:58:00
 | HU G2 | 54 | 1000 | 1100 | 53.9 | 59.3 | 1.92 | 2001-11-20 14:58:00
 | [NAME] | 56 | 1125 | 1225 | 49.5 | 53.9 | 1.82 | 2001-11-20 14:58:00
 | [NAME] | 62 | 1350 | 1450 | 47.4 | 51 | 1.92 | 2001-11-20 14:58:00
 | [NAME] | 63 | 1450 | 1550 | 45 | 48.2 | 1.85 | 2001-11-20 14:58:00
 | [NAME] | 63 | 1500 | 1625 | 42.6 | 46.1 | 1.76 | 2001-11-20 14:58:00
 | HU N2 | 63 | 1550 | 1700 | 41.2 | 45.2 | 1.71 | 2001-11-20 14:58: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: tracy_geaccone__40395__NNG3rdCEEM
Sheet: O&M

PRINT: O&M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | 2nd | 3rd | 4th
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  |  |  |  | Quarter | Quarter | Quarter | Quarter |  | Total
Direct Costs
Commercial (Formerly Mrkting, Bus.Srv., [NAME].Affairs & Admin.)
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marketing Services
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Operations
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Finance & Accounting
Variable Pay, Annual Incentive and PBA |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
O.I. Amortization | Link D.T. | 46 | 46 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Functional vs. Entity Actual Variance |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Management Overview ("Stretch" Adjustment)
Information Technology (Formerly Systems)
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Miscellaneous General & Administrative
Item 1 |  | 0 | 0 | 0 | 0 | 0
Item 2
Reorg. Incremental Factor (Restated vs. [NAME]) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Direct Costs
ETS Allocations
Legal
Human Resources
Executive & Other
Other
Other
Hyperion Timing Entry / Reversal
Total ETS Allocations
Corporate Direct & Allocated
Corporate Direct and Allocated
Other
Hyperion Timing / Reversal
Total Corporate Direct & Allocated
Total GPG / Corporate Allocation
TOTAL O&M EXPENSE
TOTAL RESTATED PLAN O&M EXPENSE |  | 14171 | 13745 | 11573 | 14768 | 14307 | 12558 | 15242 | 14376 | 11959 | 15122 | 14378 | 12949
CURRENT vs. RESTATED PLAN O&M VARIANCE
 |  | 12956 | 12697 | 18141 | 11575 | 12385 | 13491 | 13076
Spreadsheet: kate_symes__19034__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-05 00:00:00 |  | 335.73 | 4960 | 244.29 | 1400
 | 2001-04-04 00:00:00 |  | 303.95 | 3040 | 218.33 | 1800 | 354.42 | 1401 | 291.47 | 1225
 | 2001-04-03 00:00:00 |  | 293.57 | 5600 | 196.67 | 1800 | 343.76 | 487 | 308.73 | 315
 | 2001-04-02 00:00:00 |  | 278.14 | 4592 | 201.82 | 2200 | 343.33 | 2990 | 231.25 | 880
 | 2001-04-01 00:00:00 |  |  |  |  |  |  |  | 286.97 | 2045 |  | 201.82 | 6600
 | 2001-03-31 00:00:00 |  | 183.81 | 8944 | 119.54 | 3448 | 276.25 | 800 | 246.67 | 150
 | 2001-03-30 00:00:00 |  | 181.46 | 7680 | 119.54 | 3448 | 246.39 | 2630 | 195.61 | 570
 | 2001-03-29 00:00:00 |  | 188.08 | 5488 | 115.18 | 2408 | 218.64 | 2360 | 189.31 | 725
 | 2001-03-28 00:00:00 |  | 163.85 | 6240 | 84.65 | 2368 | 193.33 | 790 | 225 | 200
 | 2001-03-27 00:00:00 |  | 159.55 | 4400 | 95 | 200 | 158.05 | 665 | 92 | 500
 | 2001-03-26 00:00:00 |  | 324.62 | 5200 | 196.15 | 1560 | 125.58 | 1943 | 95.04 | 605
 | 2001-03-25 00:00:00 |  |  |  |  |  |  |  | 86.42 | 965 |  | 197.59 | 3480
 | 2001-03-24 00:00:00 |  | 304.64 | 6640 | 198.68 | 760 | 190.9 | 2680 | 187.34 | 1463
 | 2001-03-23 00:00:00 |  | 305.27 | 5840 | 202.5 | 400 | 405.31 | 3225 | 358.35 | 1365
 | 2001-03-22 00:00:00 |  | 373.61 | 7200 | 222.62 | 840 | 401.04 | 3938 | 388.28 | 1215
 | 2001-03-21 00:00:00 |  | 441.52 | 3680 | 243.61 | 720 | 491.64 | 1345 | 382.76 | 870
 | 2001-03-20 00:00:00 |  | 399.53 | 5120 | 308.69 | 560 | 483.98 | 1040 | 363.65 | 1000
 | 2001-03-19 00:00:00 |  | 458.18 | 14320 | 290 | 200 | 410.04 | 1220 | 293.22 | 885
 | 2001-03-18 00:00:00 |  |  |  |  |  |  |  | 256.06 | 3083 |  | 310 | 1200
 | 2001-03-17 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 357.5 | 360 | 276.3 | 270
 | 2001-03-16 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 394.78 | 335 | 330 | 360
 | 2001-03-15 00:00:00 |  | 216.79 | 7600 | 168.33 | 1200 | 254.45 | 627 | 261.36 | 550
 | 2001-03-14 00:00:00 |  | 213.33 | 7200 | 178.33 | 600 | 246.45 | 900 | 222.58 | 1035
 | 2001-03-13 00:00:00 |  | 217.05 | 8800 | 174.4 | 1000 | 234.06 | 1946 | 237.07 | 870
 | 2001-03-12 00:00:00 |  | 270 | 6800 | 205 | 200 | 237.03 | 3775 | 219.92 | 1945
 | 2001-03-11 00:00:00 |  |  |  |  |  |  |  | 239.18 | 2715 |  | 205 | 600
 | 2001-03-10 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 294.74 | 950 | 265.54 | 925
 | 2001-03-09 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 366.94 | 1070 | 296.17 | 1600
 | 2001-03-08 00:00:00 |  | 276.67 | 6000 | 200 | 200 | 346.11 | 3730 | 314.25 | 2395
 | 2001-03-07 00:00:00 |  | 340.26 | 7600 | 263.33 | 600 | 350.64 | 3925 | 325.92 | 1567
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960 | 357.4 | 2896 | 344.21 | 1295
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: b7899bef-f9cf-4e2c-986c-2196e3321cf3
Sheet: Sheet1

GENERAL | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Condemning and taking private properties for the improvement of [NAME], in Kansas City, Platte County, Missouri. |  |  |  | For the improvement of [NAME], located in Kansas City, Platte County, Missouri.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | City Manager
 |  |  |  |  | Programs, |  |  |  | Public Works
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
Discussion (continued) |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
Details
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME], ROW Services
Reviewed by:
 | [NAME], Public Works
Reference Numbers
Spreadsheet: 103404d1301144294-conditional-formatting-code-to-change-font-size-conditional-font-formatting-1-sample-invoice
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Invoice No.
 |  |  | NAME |  |  |  |  |  |  | PRINT DATE
 |  |  | ADDRESS |  |  |  |  |  |  | ORDER DATE
 |  |  | CITY |  | STATE |  | ZIP |  |  | NAME
 |  |  | PHONE |  |  |  | FAX |  |  | DEL. DATE
 |  |  | QTY | [NAME] |  |  |  | PRODUCT |  | UNIT PRICE | TOTAL
 |  |  | 2 | 20 OZ   COKE |  |  |  | COKE |  | 17.5
 |  |  | 2 | 20 OZ   DIET COKE |  |  |  | COKE |  | 17.5
 |  |  |  | 20 OZ   SPRITE |  |  |  | COKE |  | 17.5
 |  |  |  | 20 OZ   COKE ZERO |  |  |  | COKE |  | 17.5
 |  |  | 5 | 20 OZ   CHERRY COKE |  |  |  | COKE |  | 17.5
 |  |  | 2 | 20 OZ   FANTA ORANGE |  |  |  | COKE |  | 17.5
 |  |  |  | 20 OZ   FANTA GRAPE |  |  |  | COKE |  | 17.5
 |  |  |  | 20 OZ   FANTA STRAWBERRY |  |  |  | COKE |  | 17.5
 |  |  | 5 | 20 OZ   MOUNTAIN DEW |  |  |  | PEPSI |  | 17.2
 |  |  | 4 | 20 OZ   DR. PEPPER |  |  |  | PEPSI |  | 17.2
 |  |  |  | 20 OZ   DIET MOUNTAIN DEW |  |  |  | PEPSI |  | 17.2
 |  |  | 4 | 20 OZ   DIET DR. PEPPER |  |  |  | PEPSI |  | 17.2
 |  |  | 1 | 20 OZ   WHITE OUT MOUNTAIN DEW |  |  |  | PEPSI |  | 17.2
 |  |  |  | 20 OZ   LIPTON BRISK |  |  |  | PEPSI |  | 17.2
 |  |  |  | 20 OZ   A&W ROOT BEER |  |  |  | 7UP |  | 16
 |  |  |  | 20 OZ   LEMONADE |  |  |  | 7UP |  | 16
 |  |  | 1 | 20 OZ   SUNNY DELIGHT |  |  |  | 7UP |  | 16
 |  |  |  | 20 OZ   MIXED GATORADE |  |  |  | GATORADE
 |  |  |  | 20 OZ   GL FREEZE |  |  |  | GATORADE
 |  |  |  | 20 OZ   VARIET PK (FP LL ORG) |  |  |  | GATORADE
 |  |  |  | 20 OZ   ORANGE |  |  |  | GATORADE
 |  |  |  | 20 OZ   FRUIT PUNCH |  |  |  | GATORADE
 |  |  |  | 20 OZ   LEMON LIME |  |  |  | GATORADE
 |  |  |  | 20 OZ   FIERCE |  |  |  | GATORADE
 |  |  |  | 20 OZ   X FACTOR |  |  |  | GATORADE
 |  |  |  | 20 OZ   G2 VARIETY PK |  |  |  | GATORADE
 |  |  |  | TOTAL CASES DELIVERED
 |  |  |  |  |  |  |  |  |  | Shipping & Handling
 |  |  |  |  |  |  |  |  | Taxes
 |  |  |  |  |  |  |  |  |  | SUB TOTAL
 |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 826159d1681832847-index-match-named-range-test-sheet-3-aligw
Sheet: Sheet1

record id | Name | [NAME]