tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 194247d1353087000-summing-number-in-text-sum_s_cells-example
Sheet: Sheet1 (2)

Name | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 | Sick Days Taken
Cullen
Spreadsheet: 0609ae67-ebef-4eb2-a162-f9bb125e8a73
Sheet: Sheet1

Digital Game and Simulation Design | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Certificate
Name |  |  | Student ID Number |  |  |  | Date Entered: | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date: | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Course |  |  |  | Credits | Semester Taken
Computer Literacy |  |  |  | 0-3
DGD 131 3D Texturing and Lighting I |  |  |  | 3
DGD 132 Introduction to Digital 3D Graphics |  |  |  | 3
DGD 231 3D Texturing and Lighting II |  |  |  | 3
DGD 232 3D Character Development |  |  |  | 3
DGD 233 3D Character Rigging |  |  |  | 3
DGD 234 3D Animation |  |  |  | 3
DGD 235 3D Special Effects |  |  |  | 3
DGD 236 Game Engines I |  |  |  | 3
DGD 237 Game Engines II |  |  |  | 3
Total hours for Certificate |  |  |  | 27-30
Spreadsheet: 50ff25b5-e01c-48b7-aa95-d78557b4b458
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
 | OPERATING COSTS:     BladeUPS    vs.   Other UPS Systems
 |  |  |  |  | [NAME] (VA) = | 60000
 |  |  |  |  | Load Power Factor = | 1
 |  |  |  |  | Unit [NAME] = | 60000
 |  |  |  |  | Energy cost per kW Hr ((usage charge + taxes)/kW/hr) = | 0.0794
 |  |  |  |  | Demand charge per kW/hr = | 0.02
 |  |  |  |  | Total Cost per kW/hr = | 0.0994 |  |  |  |  |  |  |  |  |  |  |  |  | 48000 | 48000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.44 | 0.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 109090.9090909091 | 21120
 |  |  |  |  | Competitive product efficiency from chart = | 0.915
 |  |  |  |  | BladeUPS efficiency from chart = | 0.975
 |  |  |  |  | Loss in watts with competitive product = | 5099.999999999998
 |  |  |  |  | Loss in watts with BladeUPS = | 1500.000000000001
 |  |  |  |  | Extra wattage used  to operate competitors product = | 3599.999999999997
 |  |  |  |  | Loss in Btu/hr with competitive product = | 17401.92057899999
 |  |  |  |  | Loss in Btu/hr with BladeUPS = | 5118.211935000005
 |  |  |  |  | Extra Btu/hr used to operate competitors product | 12283.70864399999
 |  |  |  |  | Daily energy savings using BladeUPS = | 8.588159999999993
 |  |  |  |  | Yearly energy savings using BladeUPS = | 3134.678399999998
 |  |  |  |  | * Cooling efficiency ratio = | 1
 |  |  |  |  | Daily cooling savings using BladeUPS = | 8.588159999999993
 |  |  |  |  | Yearly cooling savings using BladeUPS = | 3134.678399999998
 | Total yearly combined savings using BladeUPS = |  |  |  |  | 6269.356799999995
 |  |  | * Cooling efficiency ratio is the ratio of dollars spent to cool IT equipment, when compared to dollars spent to power that same equipment. Most data centers operate their cooling efficiency between 80 to 120%. If you have a highly efficient cooling strategy use 90% or lower. If your cooling strategy is know to be inefficient, use 100% or higher. If you know your actual cooling efficiency input that value.
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Eskom- Collection Status  - Sum

[NAME] (14 day Eskom collection Process )
Week | France | Germany | UK | Average
WE03 | 0.782608695652174 | 0.8285714285714286 | 0.9090909090909091
WE04 | 0.782608695652174 | 0.8285714285714286 | 0.9090909090909091
WE05 | 0.7857142857142857 | 0.8055555555555556 | 0.7692307692307693
WE06 | 0.6052631578947368 | 0.8888888888888888 | 0.6666666666666666
WE07 | 0.8478260869565217 | 0.8205128205128205 | 0.7435897435897436
WE08 | 0.8679245283018868 | 0.8536585365853658 | 0.85
WE09 | 0.8695652173913043 | 0.8409090909090909 | 0.7555555555555555
WE10 | 0.82 | 0.8409090909090909 | 0.7555555555555555
WE11 | 0.8695652173913043 | 0.8409090909090909 | 0.7555555555555555
WE12 | 0.87 | 0.85 | 0.85
WE13 | 0.78 | 0.84 | 0.78
WE14 | 0.8939393939393939 | 0.7413793103448276 | 0.8125
WE15 | 0.83 | 0.81 | 0.82
WE16 | 0.92 | 0.8135593220338984 | 0.7380952380952381
WE17 | 0.8860759493670886 | 0.7580645161290323 | 0.8
WE18 | 0.9 | 0.75 | 0.7777777777777778
WE19 | 0.95 | 0.7121212121212122 | 0.7857142857142857
WE20 | 0.9358974358974359 | 0.7538461538461538 | 0.7727272727272727
WE21 | 0.961038961038961 | 0.7611940298507462 | 0.7916666666666666
WE22 | 0.961038961038961 | 0.7611940298507462 | 0.7916666666666666
WE23 | 0.961038961038961 | 0.7611940298507462 | 0.7916666666666666
WE24 | 0.82 | 0.71 | 0.77
WE25 | 0.9518072289156626 | 0.7647058823529411 | 0.7777777777777778
WE26 | 0.9659090909090909 | 0.7714285714285715 | 0.8245614035087719
WE27 | 0.7678571428571429 | 0.726027397260274 | 0.7666666666666667
WE28 | 0.7094017094017094 | 0.717948717948718 | 0.78125
WE29 | 0.8974358974358975 | 0.6746987951807228 | 0.7352941176470589
WE30 | 0.8934426229508197 | 0.6363636363636364 | 0.7222222222222222
WE31 | 0.8373983739837398 | 0.5280898876404494 | 0.6027397260273972
WE32 | 0.782608695652174 | 0.4354838709677419 | 0.4455445544554456
WE33 | 0.7236842105263158 | 0.4084507042253521 | 0.4
WE34 | 0.6932515337423313 | 0.4013157894736842 | 0.4336283185840708
WE35 | 0.6932515337423313 | 0.4013157894736842 | 0.4336283185840708
WE36 | 0.6932515337423313 | 0.4013157894736842 | 0.4336283185840708
WE37 | 0.6932515337423313 | 0.4013157894736842 | 0.4336283185840708
WE38 | 0.704225352112676 | 0.38125 | 0.396551724137931
WE39 | 0.7553956834532374 | 0.4050632911392405 | 0.36
WE40
WE41
WE42
WE43
WE44
WE45
WE46
WE47
WE48
WE49
WE50
WE51
WE52
Spreadsheet: 887511d1737735700-sort-and-sum-costs-by-month-and-by-type-forum-example-sheet
Sheet: Sheet3

ITEM | Date | cost |  |  | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | totals
Books | 2024-04-15 00:00:00 | 2 |  | Books
Books | 2024-05-31 00:00:00 | 6 |  | Toys
Toys | 2024-10-10 00:00:00 | 9 |  | Food
Food | 2025-02-01 00:00:00 | 4 |  | Craft
Toys | 2024-07-09 00:00:00 | 9
Toys | 2025-01-16 00:00:00 | 2 |  | Totals
Books | 2024-10-30 00:00:00 | 3
Toys | 2024-08-22 00:00:00 | 6
Craft | 2024-06-25 00:00:00 | 6
Books | 2024-09-04 00:00:00 | 12 |  | Sum of cost | Column Labels
Toys | 2024-11-20 00:00:00 | 5 |  |  | 2024 |  |  |  |  |  |  |  | 2025 |  |  | Grand Total
Food | 2025-03-01 00:00:00 | 4 |  | Row Labels | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Jan | Feb | Mar
Toys | 2024-09-22 00:00:00 | 8 |  | Books | 8 | 6 |  |  |  | 12 | 3 |  |  |  |  | 29
Food | 2024-06-05 00:00:00 | 8 |  | Craft |  | 8 | 6 |  |  |  |  |  | 10 |  |  | 24
Craft | 2025-01-08 00:00:00 | 10 |  | Food |  |  | 8 |  |  |  |  |  |  | 7 | 4 | 19
Craft | 2024-05-06 00:00:00 | 1 |  | Toys |  |  |  | 13 | 6 | 8 | 14 | 5 | 2 |  |  | 48
Books | 2024-04-01 00:00:00 | 6 |  | Grand Total | 8 | 14 | 14 | 13 | 6 | 20 | 17 | 5 | 12 | 7 | 4 | 120
Craft | 2024-05-06 00:00:00 | 7
Toys | 2024-07-10 00:00:00 | 4
Toys | 2024-10-20 00:00:00 | 5
Food | 2025-02-13 00:00:00 | 3
Total
Spreadsheet: 847079d1698168417-excel-formula-with-multiple-conditions-downgrade-template-travisty123-
Sheet: Sell Rates

 |  | CUSTOMER SELL RATES & INFO
 | Downgrade Material
 | Customer Name | BLK/PTD Tonne Rate | [NAME] | Notes
 | [NAME] |  |  | *185x65x3.0mm GAL at $1000.00 per tonne.
 | Len's Mobile Welding |  |  | Likes Gal material (75x75x2.5mm/3.0mm/4.0mm). NEEDING 150x50x2.0mm GAL (prefer 12000mm).
 | Ron & Catharine Collins |  |  | Wants popular sized steel.
 | Tait Steel
 | Taroom Welding Worx |  |  | Remain firm on rates. Generally doesn't buy anything from us.
 | Valley Steel & Fencing |  |  | *Pays a higher rate GAL tonne rate as he will only buy a truck load (24T) of GAL, not mixed, which requires additional time and handling of material to make up a truck load (24T).
 | [NAME] |  |  | Standard cash sales #12001. Likes Gal material (100x100x5.0mm, 89x89x5.0mm & 50x50x5.0mm). Ph number is 07 4665 9213 / 0429 659 213.
 | [NAME] |  |  | 07 4595 2452 / [EMAIL] - Interested in 89x89 SQ / 100x100 SQ 2.5mm-3.0[NAME]
 | [NAME] |  |  | 50x25x1.6mm or 2mm Downgrade. These guys are always chasing this size in downgrade. Around sizing can be 38x25x1.6mm.
 | [NAME] |  |  | [NAME] (Pref PTD) & 50x50x5/6mm PTD & GAL (Pref PTD).
 | COD: Double D Cattle Co |  |  | 50NB Pipe - doesn't matter what thickness nor coating type. Contact Dennis - 0428 927 734 - [EMAIL]
 | [NAME] |  |  | All Painted: 65x35x3 RHS, 100x50x3 or 4mm RHS, 50x50x2.5 or 3mm RHS, [NAME] (not sure if they even make this size anymore)
 | [NAME] |  |  | $975+g.s.t. for Gal 185 x 65
Spreadsheet: 877916d1724851734-index-and-match-function-not-working-help-aop-per-tech
Sheet: Jul

TECH | HOURS | AVG-PER DAY | OBJ RATE | % OF TOTAL HOURS | OBJECTIVE |  |  | Column1 | Column2
ANZOR KHATAEV, | 330.7 |  |  |  |  |  |  | AOP $
BRANDON HAASE, | 14.4 |  |  |  |  |  |  | ELR
[NAME], | 1 |  |  |  |  |  |  | AOP HOURS
CHASE FRY, | 100.2 |  |  |  |  |  |  | WORKING DAYS
[NAME], | 208.61
[NAME], | 244.7 |  |  |  |  |  |  | TOTAL HOURS
[NAME], | 168.2
[NAME], | 466.64
COELLO VALLEJO, | 215.98
DIEGO MERCADO, | 327.82
DONOVAN OCONNOR, | 230.4
EVAN SHEPHERD, | 0.4
FLORES GUARDADO, | 310.35
GIANCARLO PACHECO, | 2.4
GILBERTO GALENOCAMPOS, | 188.9
[NAME], | 209.1
GRIFFYN BRODHUN, | 85.2
GUARDADO RODAS, | 276.07
[NAME], | 193.84
[NAME], | 0.5
[NAME], | 178.3
[NAME], | 117
JOSHUA MATUDAN, | 134.26
MASON SHAWN, | 470.8
[NAME], | 702.85
[NAME], | 105.93
[NAME], | 50.6
QUINN SANBORN, | 7.1
[NAME], | 459.38
RYAN GUAGENTI, | 260.75
SEAN BRADLEY, | 209.05
[NAME], | 249.3
SHANE GILLESPIE, | 316.05
SHAWN GROOVER, | 294.6
SIMON NELSON, | 205.78
SUBLET TECH, | 4.5
[NAME], | 395.88
THOAI LE, | 500.67
TRAVIS GREGORY, | 434.91
TYLER BIXLER, | 376.28
TYLER MUNGER, | 364.8
URBINA GOMEZ, | 156.48
[NAME], | 279.6
WYLIE ROWE, | 105.5
Spreadsheet: 702724d1604504159-max-function-with-condition-doch-dzka
Sheet: 2020

09:00:00 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Day | In | Out | Hours | Overtime | Weekend | Day | In | Out | Hours | Overtime | Weekend | Day | In | Out | Hours | Overtime | Weekend
 | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 2 |  |  |  |  |  | 2 | 06:52:00 | 16:52:00 |  |  |  | 2
 | 3 |  |  |  |  |  | 3 | 06:50:00 |  |  |  |  | 3
 | 4 |  |  |  |  |  | 4 |  |  |  |  |  | 4
 | 5 |  |  |  |  |  | 5 |  |  |  |  |  | 5
 | 6 |  |  |  |  |  | 6 |  |  |  |  |  | 6
 | 7 |  |  |  |  |  | 7 |  |  |  |  |  | 7
 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8
 | 9 |  |  |  |  |  | 9 |  |  |  |  |  | 9
 | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10
 | 11 |  |  |  |  |  | 11 |  |  |  |  |  | 11
 | 12 | 06:52:00 | 17:02:00 |  |  |  | 12 |  |  |  |  |  | 12
 | 13 | 06:54:00 | 17:01:00 |  |  |  | 13 |  |  |  |  |  | 13
 | 14 | 06:51:00 | 16:54:00 |  |  |  | 14 |  |  |  |  |  | 14
 | 15 | 06:54:00 | 17:00:00 |  |  |  | 15 |  |  |  |  |  | 15
 | 16 | 06:57:00 | 16:30:00 |  |  |  | 16 |  |  |  |  |  | 16
 | 17 |  |  |  |  |  | 17 |  |  |  |  |  | 17
 | 18 |  |  |  |  |  | 18 |  |  |  |  |  | 18
 | 19 | 06:55:00 | 17:02:00 |  |  |  | 19 |  |  |  |  |  | 19
 | 20 | 06:53:00 | 16:55:00 |  |  |  | 20 |  |  |  |  |  | 20
 | 21 | 06:55:00 | 17:00:00 |  |  |  | 21 |  |  |  |  |  | 21
 | 22 | 06:54:00 | 16:55:00 |  |  |  | 22 |  |  |  |  |  | 22
 | 23 | 06:56:00 | 16:27:00 |  |  |  | 23 |  |  |  |  |  | 23
 | 24 |  |  |  |  |  | 24 |  |  |  |  |  | 24
 | 25 |  |  |  |  |  | 25 |  |  |  |  |  | 25
 | 26 | 06:55:00 | 15:06:00 |  |  |  | 26 |  |  |  |  |  | 26
 | 27 | 06:51:00 | 13:20:00 |  |  |  | 27 |  |  |  |  |  | 27
 | 28 | 06:53:00 | 15:40:00 |  |  |  | 28 |  |  |  |  |  | 28
 | 29 | 06:49:00 | 15:57:00 |  |  |  | 29 |  |  |  |  |  | 29
 | 30 | 06:49:00 | 15:20:00 |  |  |  | 30 |  |  |  |  |  | 30
 | 31 |  |  |  |  |  |  |  |  |  |  |  | 31
 | Total |  |  |  |  |  | Total |  |  |  |  |  | Total
 |  | weekday |  |  | weekend |  |  | holiday |  |  | annual leave |  |  | sick leave
Spreadsheet: kate_symes__18192__Deal Correction 2-28
Sheet:  Current Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-02-28 00:00:00 | 2001-02-28 00:00:00 | 2001-02-27 00:00:00 | LTNW | MD | Houston | Amerex | Energy type: from CAISO to Firm | Incorrect Deal Blotter settings | 532917/9 | Mid-C | Q2-01/H01 | On [NAME] | 25 | 230/227 | Avista/Dynegy
2001-02-28 00:00:00 | 2001-02-28 00:00:00 | 2001-02-27 00:00:00 | STCA | JR | Houston | Prebon | Index: from NP-15 to SP-15 |  | 533084/085 | SP-15 | H01 | On [NAME] | 2 | DJ SP Index -1.95/2 | EES/Sempra
 |  |  | Grand Count
Spreadsheet: 604323d1546517271-need-help-with-separating-data-on-a-pivot-report-book3
Sheet: Sheet1

Sum of Total Cost | Column Labels
Row Labels | 2019-04-01 00:00:00 | Grand Total
Beef | 60000 | 60000
Calves | 60000 | 60000
Assumption 7 | 20000 | 20000
Unable to sell stock | 20000 | 20000
Unable to transport stock | 20000 | 20000
Dairy | 5600.000000000001 | 5600.000000000001
Milk | 5600.000000000001 | 5600.000000000001
Assumption 9 | 2800 | 2800
Unable to sell stock | 2800 | 2800
Grand Total | 65600 | 65600
Spreadsheet: 39858d1238112099-inserting-a-line-on-my-reference-sheet-test-for-help
Sheet: Website

Website
Sponsor Company Name | Sponsor Company Contact Name | Sponsor Contact Email | Sponsor Address | Sponsor Phone | Description | Quantity | Column1 | Column2
1 | 1 | 1 | 1 | 1 | Link on Web Site | 1
3 | 3 | 3 | 3 | 3 | Link on Web Site | 1
4 | 4 | 4 | 4 | 4 | Link on Web Site | 1
5 | 5 | 5 | 5 | 5 | Recognition on Web Site | 1
6 | 6 | 6 | 6 | 6 | Recognition on Web Site | 1
Spreadsheet: 846915d1698066628-vlookup-not-update-if-lookup-value-is-not-found-sampleworkbook
Sheet: export

Room | [NAME]? | [NAME] | Days Elapsed
 |  | 2023-10-21 00:00:00
 |  | 2023-09-24 00:00:00
 |  | 2023-10-10 00:00:00
 |  | 2023-10-21 00:00:00
 |  | 2023-10-21 00:00:00
 |  | 2023-10-20 00:00:00
 |  | 2023-10-24 00:00:00
 |  | 2023-10-30 00:00:00
Spreadsheet: 47865d1247036883-sorting-non-unique-rows-of-data-into-another-worksheet-example
Sheet: 240

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | ID-2 | GJ | 1/2/2009 |  | 6346 |  | 240
01 | ID-2 | GJ | 1/2/2009 |  | 345 |  | 240
01 | ID-2 | GJ | 1/2/2009 |  | 234 |  | 240
Spreadsheet: daren_farmer__5520__hpl1010
Sheet: Sheet1

HPLN1010.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 10, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-10-10 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
ENA (S) |  | Oasis Sealy |  | HPL | 0 | 10
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 764315d1642688304-find-and-delete-phrases-example
Sheet: Sheet1

ID | Active | First Name | Middle Name | Last Name
1234 | Active | [NAME] |  | PORTER, AIF
4258 | Active | JACK | MICHELLE | LAMAINA AIF
1258 | Active | GARRETT | IRENE | PERRY(R)
1477 | Active | FRANK | KEVIN | ONEILL (R)
112 | Active | MARY | FRANCIS | JUMET,  CFA, CLA
9563 | Active | BUD | LEO | DO CARMO%
9999 | Active | SCOTT | FRANCIS | CUNNINGHAM,PFS
9874 | Active | [NAME] | C. | HAARSTICK
8525 | Active | JANIS | ANN | YANKER
Spreadsheet: 192098d1352307318-calculating-value-between-two-points-solar110712
Sheet: July

 |  | Service Dates: |  | 2012-07-03 00:00:00 |  |  | thru | 2012-08-01 00:00:00
 | PG&E RATES & USAGE
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | Baseline |  | 101-130% |  | 131-200% |  | 201-300% |  | 301%+
 | 1048.14 |  | 1048.14 | 1362.582 | 1362.582 | 2096.28 | 2096.28 | 3144.42 | 3144.42
 | 0.12845 |  | 0.14602 |  | 0.29561 |  | 0.33561 |  | 0.33561
 | 1029.71 |  | 0 |  | 0 |  | 0 |  | 0
 | CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | 132.2662495 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 1029.71 |  |  | 448 |  |  |  | 581.71
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings
 |  |  |  | Billed |  | Min
 | 132.2662495 |  |  | 57.68 |  | 4.48 |  | 70.1062495
 |  |  |  |  | 62.16
 | Date | Solar | Date | Solar | Date | Solar |  | Total
 | 2012-07-01 00:00:00 |  | 2012-07-12 00:00:00 | 11.19 | 2012-07-23 00:00:00 | 18.55 |  | Solar | 581.71
 | 2012-07-02 00:00:00 |  | 2012-07-13 00:00:00 | 18.58 | 2012-07-24 00:00:00 | 20.1
 | 2012-07-03 00:00:00 | 20.38 | 2012-07-14 00:00:00 | 20.88 | 2012-07-25 00:00:00 | 20.03
 | 2012-07-04 00:00:00 | 20.9 | 2012-07-15 00:00:00 | 21.01 | 2012-07-26 00:00:00 | 21.15 | [NAME] |  | 0.9482573486880159
 | 2012-07-05 00:00:00 | 20.79 | 2012-07-16 00:00:00 | 20.89 | 2012-07-27 00:00:00 | 21.11 | Estimate |  | 613.4516129032259
 | 2012-07-06 00:00:00 | 20.54 | 2012-07-17 00:00:00 | 21.66 | 2012-07-28 00:00:00 | 21 | Actual |  | 581.71
 | 2012-07-07 00:00:00 | 20.55 | 2012-07-18 00:00:00 | 18.74 | 2012-07-29 00:00:00 | 20.74 | Estimate
 | 2012-07-08 00:00:00 | 20.58 | 2012-07-19 00:00:00 | 18.79 | 2012-07-30 00:00:00 | 19.89 |  |  | Jul | Aug
 | 2012-07-09 00:00:00 | 20.21 | 2012-07-20 00:00:00 | 20.75 | 2012-07-31 00:00:00 | 7.2 | Proposed Prod |  | 634 | 631
 | 2012-07-10 00:00:00 | 19.73 | 2012-07-21 00:00:00 | 20.34 | 2012-08-01 00:00:00 | 18.93 | Days |  | 31 | 31
 | 2012-07-11 00:00:00 | 17.74 | 2012-07-22 00:00:00 | 18.76 | 2012-08-02 00:00:00 |  | Per Day |  | 20.45161290322581 | 20.35483870967742
 |  |  |  |  |  |  | Billed Days |  | 29 | 1
 |  |  |  |  |  |  | Total |  | 593.0967741935484 | 20.35483870967742
 |  |  |  |  |  |  |  | T2 | -18.43000000000006
 |  |  |  |  |  |  |  |  | 0.01757
 |  |  |  |  |  |  |  | T3 | -332.8720000000001
 |  |  |  |  |  |  |  |  | 0.14959
 |  |  |  |  |  |  |  | T4 | -1066.57
 |  |  |  |  |  |  |  |  | 0.04000000000000004
Spreadsheet: 011ab6e2-0da6-4dcb-8d89-8c94ed6c8e78
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | URUGUAY 2013 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Apellido | Nombre | fecha/nac | Nac. | Nro ITF | Inst.Mayor
 | 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
 | 28
 | 30
Spreadsheet: 132098d1323472767-lookup-returning-values-but-shifts-one-spot-down-r_data
Sheet: Sheet1

ARI |  |  |  | Top row won't work!!!!
ATL |  |  |  | <---- on the other page, ARI is 5, 7 -- it shifts each value down one.
BAL
BUF
CAR
CHI
CIN
CLE
DAL
DEN
DET
GB
HOU
IND
JAC
KC
MIA
MIN
NE
NO
NYG
NYJ
OAK
PHI
PIT
SD
SEA
SF
STL
TB
TEN
WAS
Spreadsheet: 155039d1336658224-excel-2007-how-to-create-a-list-that-returns-unique-values-test-hot-list
Sheet: HOT COMP

HOT LIST COMPILATION
Structure of Data Set - This just looks if a university is rated as 'hot'.  The array starts on line 4 and ends on line 56, so if you add a sheet ensure you format it correctly.  If you add a state, just add a column to this page, copy any of the other column's formulas and change the sheet it is pointing to and copy it down.
# | Michigan | Illinois | DC | PA | MAINE | CONN | ALABAMA | NY | TEXAS | MASS | OKLAHOMA | KANSAS | CALI | INDIANA | WV
1
Spreadsheet: 271911d1382105028-sum-values-from-different-sheets-to-summary-sheet-sum-values
Sheet: Summary

Our Global Company
[NAME], Previous Fiscal Year
Sales Group: | Consulting: | Marketing: | Outsourcing: | Bundling:
Northeast
Southeast
Northwest
Southwest
TOTAL
Total Revenue:
1. I want to sum the qtr1+qtr2+qtr3+qtr4 in cell b5 in summary sheet.
2. If I drag down the formula to right & down it should give me the correct sum result.
Spreadsheet: 229245d1366340462-copying-worksheets-issue-1234-rss-fee-proposal
Sheet: RSS Fee Detail

 |  |  |  |  |  |  |  |  | Project Number
 | Exchange Rate |  |  | Currency Used: | HKD |  |  |  | Proposal Date:
 | 8.034 | USD to MOP
 | 7.7756 | USD to HKD |  | CN | SD | DD | CD | Submission | CA
 | 1.03 | HKD to MOP |  | Concept Design | Schematic Design | Design Development | Construction Documentation |  | Tender and Contract Adminstration
 |  |  | Phase Duration | 1 | 1 | 1 | 1 | N/A | 1
 | ID - Interior Consultant Team |  | Firm Name |  |  |  |  |  |  | TOTAL
 | Interior Design
 | FFE Specification
 | Lighting Design
 | Renderings
 | On Site Supervision (ID RSS)
 | Other:
 | Other:
 | Macau Tax Estimate |  | 0.12
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Interior Design Fee Total
 | LC - Lead Consultant Team |  | Firm Name
 | Architecture
 | Interior Design Production
 | Structural Design
 | MEP Design
 | ELV Engineering
 | Fire Services Design
 | Fire Safety Engineering
 | Lighting Design
 | Acoustic Consultant
 | Traffic Design
 | Audio / Visual Consultant
 | [NAME]
 | Facade Consultant
 | Landscape
 | Renderings
 | Other:
 | Other:
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Lead Consultant Design Fee Total
 | DC - Direct Consultants |  | Firm Name
 | [NAME]
 | Signage and Graphics
 | Creative Consultant
 | Cost Planning / Review
 | Statutory Consultant
 | Other:
 | Other:
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Direct Consultant Design Fee Total
 | RSS - Site Survey Team |  | Firm Name | CN | SD | DD | CD | Submission | CA
 | RSS Arch / ID (Lead Consultant) |  | AED |  |  |  |  | 123456 |  |  | Currency Converter
 | RSS Structural |  | ARUPS |  |  |  |  | 2345678 |  |  | USD | 1
 | RSS MEP |  | PBA |  |  |  |  | 2345678 | 2345678 |  | USD
 | 3rd Party Life Safety Checker |  | RJA |  |  |  |  | 2345678 |  |  | MOP
 | RSS Fire Safety |  |  |  |  |  |  | 2345678 | 2345678 |  | HKD
 | RSS Statutory Consultant |  | MPS |  |  |  |  | 2345678
 | Other:
 | Other:
 |  | Subtotal by Phase
 |  |  |  |  |  |  |  | Resident Site Surveyor Fee Total