tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104276d1301928756-pivot-chart-legend-format-example
Sheet: Sheet1

FY10 Work Order Submitted Summary
Commander | (All)
InspectorLastName | (All)
Count of WorkOrderNum | MonthNotified
System | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | Grand Total
Access Control | 1 |  | 2 | 1 | 2 | 2 | 3 | 1 | 2 | 14
Alarm |  | 5 | 12 |  | 8 | 26 | 10 | 14 | 22 | 97
Barrier |  |  |  |  |  | 1 | 1 | 1 |  | 3
CCTV | 16 | 3 | 1 |  |  | 5 | 3 | 4 | 5 | 37
GSA |  | 1 |  |  |  | 1 | 6 | 1 | 8 | 17
Grand Total | 17 | 9 | 15 | 1 | 10 | 35 | 23 | 21 | 37 | 168
FY10 Work Order Resolved Summary
Commander | (All)
InspectorLastName | (All)
Count of WorkOrderNum | MonthResolved
System |  | 2010-03-01 00:00:00 | 2010-05-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-03-01 00:00:00 | 2011-10-01 00:00:00 | Grand Total
Access Control | 5 |  |  |  | 2 |  | 1 | 4 | 2 |  | 14
Alarm | 21 | 6 | 1 |  | 19 |  | 6 | 38 | 5 | 1 | 97
Barrier |  |  |  |  |  |  |  | 2 | 1 |  | 3
CCTV | 6 | 2 |  | 1 | 11 |  | 9 | 3 | 5 |  | 37
GSA |  |  |  |  | 9 | 2 | 5 | 1 |  |  | 17
Grand Total | 32 | 8 | 1 | 1 | 41 | 2 | 21 | 48 | 13 | 1 | 168
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 3 MONTHS ENDED 3-31-2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/99 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2000
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 774001d1648152117-apply-filter-selections-across-different-tabs-example-2
Sheet: Category 2

Client (Parent) | Client (Site)  *indicates network | * | [NAME] | Manager | Contact | # Collections Category 2 | $ Collections Category 2 | Agreement | Start date | End date | Type | Next year Type | Collection 1 | Collection 2 | Collection 3
Parent 1 | [NAME] | * | 150 | [NAME] | [NAME] | 1 | 5 | 1 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | Standard | Standard | a | c | d
Parent 1 | Smithville blvd |  | 200 | [NAME] | [NAME] | 1 | 20 | 1 | 2022-01-02 00:00:00 | 2023-01-02 00:00:00 | Standard | Standard | n | b | l
Parent 2 | Coronado ave |  | 50 | [NAME] | [NAME] | 1 | 10 | 1 | 2022-01-03 00:00:00 | 2023-01-03 00:00:00 | Standard | Standard | a | b | l
Parent 2 | Lorne st |  | 45 | [NAME] | [NAME] | 2 | 14 | 1 | 2022-01-04 00:00:00 | 2023-01-04 00:00:00 | Standard | Standard | a | b | l
Parent 3 | [NAME] |  | 32 | [NAME] | [NAME] | 2 | 20 | 1 | 2022-01-05 00:00:00 | 2023-01-05 00:00:00 | Standard | Standard | n | b | d
Parent 3 | Purveyor St |  | 100 | [NAME] | [NAME] | 4 | 10 | 1 | 2022-01-06 00:00:00 | 2023-01-06 00:00:00 | Standard | Standard | n | c | d
Parent 4 | Fifth av |  | 25 | [NAME] | [NAME] | 3 | 5 | 1 | 2022-01-07 00:00:00 | 2023-01-07 00:00:00 | Standard | Standard | n | c | d
Parent 5 | Sixth av |  | 30 | [NAME] | [NAME] | 2 | 5 | 1 | 2022-01-08 00:00:00 | 2023-01-08 00:00:00 | Standard | Standard | n | c | d
Parent 5 | [NAME] |  | 20 | [NAME] | [NAME] | 1 | 5 | 1 | 2022-01-09 00:00:00 | 2023-01-09 00:00:00 | Standard | Standard | a | b | d
Spreadsheet: 122800d1317153235-useing-the-lookup-function-in-a-landscape-table-native-plant-list
Sheet: Large Tree

COMMON NAME | SCIENTIFIC NAME | TYPE
American basswood | Tilia americana var. [NAME] | TL
American holly | Ilex opaca | TL
black cherry | Prunus serotina | TL
black gum | Nyssa sylvatica | TL
catalpa | Catalpa bignonioides | TL
eastern red cedar | Juniperus virginiana | TL
Georgia hackberry, dwarf hackberry | [NAME] occidentalis | TL
hackberry, sugarberry | Celtis laevigata | TL
live oak | Quercus virginiana | TL
loblolly pine | Pinus taeda | TL
longleaf pine | Pinus palustris | TL
mockernut hickory | Carya alba | TL
[NAME] | Quercus lyrata | TL
pignut hickory | Carya glabra | TL
[NAME] | Pinus serotina | TL
red maple | Acer rubrum | TL
red mulberry | [NAME] | TL
river birch | Betula nigra | TL
sand hickory | Carya pallida | TL
shortleaf pine | Pinus echinata | TL
silver maple | Acer saccharinum | TL
slash pine | Pinus elliottii | TL
southern magnolia | Magnolia grandiflora | TL
Spanish oak, southern red oak | Quercus falcata | TL
spruce pine | Pinus glabra | TL
sweet-bay | Magnolia virginiana | TL
sweetgum | Liquidambar styraciflua | TL
sycamore, plane-tree | Platanus occidentalis | TL
tulip-tree, yellow-poplar | Liriodendron tulipifera | TL
[NAME] | Quercus laevis | TL
white ash | Fraxinus americana | TL
white oak | Quercus alba | TL
willow oak | Quercus phellos | TL
Spreadsheet: 758934d1639158792-problem-using-mid-function-to-parse-a-string-with-slash-midfunctionparseproblem
Sheet: Sheet2

[NAME] to Parse: | ‎12/‎10/‎2021
 | (mm/dd/yyyy) |  | Function | Decimal Code | Character
Cell [NAME] | [NAME] | 1 | =CODE(MID($B$1,C3,1))
=MID($B$1,1,1) |  | 2 | =CODE(MID($B$1,C3,2))
=MID($B$1,1,2) - month |  | 3 | =CODE(MID($B$1,C3,3))
=MID($B$1,1,3) |  | 4 | =CODE(MID($B$1,C3,4))
=MID($B$1,1,4) |  | 5 | =CODE(MID($B$1,C3,5))
=MID($B$1,1,5) |  | 6 | =CODE(MID($B$1,C3,6))
=MID($B$1,1,6) |  | 7 | =CODE(MID($B$1,C3,7))
=MID($B$1,1,7) |  | 8 | =CODE(MID($B$1,C3,8))
=MID($B$1,1,8) |  | 9 | =CODE(MID($B$1,C3,9))
=MID($B$1,1,9) |  | 10 | =CODE(MID($B$1,C3,10))
=MID($B$1,1,10) |  | 11 | =CODE(MID($B$1,C3,11))
=MID($B$1,1,11) |  | 12 | =CODE(MID($B$1,C3,12))
=MID($B$1,1,12) |  | 13 | =CODE(MID($B$1,C3,13))
=MID($B$1,1,13)
=MID($B$1,1,14)
=MID($B$1,4,2) - day
[NAME])
=MID($B$1,7,4) - year
=MID($B$1,9,5)
Spreadsheet: 690027d1596808662-help-with-forecasting-formula-for-a-retailer-i-am-stumped-please-help-example-for-phasing-help
Sheet: Dashboard example

Key Forecast | Cateogry | Type | Group | Gender | Start week* | RID MERCH | [NAME] | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5
 | Footwear | ENDUR | SHOES | U | 38 | 2020-09-01 00:00:00 | 1300
 | Socks | Running Socks | SOCKS | U | 41 | 2020-07-15 00:00:00 | 1154
Spreadsheet: 28844d1223392316-sumproduct-formula-product-log
Sheet: Component Usage

 | Week 1 | Week 2 | Week 3 | Week 4
component 1 | 32 | 18 | 18 | 42
component 2 | 16 | 9 | 8 | 22
component 3 | 16 | 9 | 10 | 20
component 4 | 17 | 10 | 9 | 23
component 5 | 15 | 8 | 9 | 19
Spreadsheet: fd613739-c1b8-42a4-90bb-79861304c21e
Sheet: Sheet1

Justice of the Supreme Court - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 6/20/2013 1:37:02 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | Carol  Kapsner | write-in | TOTALS
Precinct 01 | 70 | 0 | 70
Precinct 02 | 205 | 0 | 205
Precinct 03 | 406 | 0 | 406
Precinct 04 | 70 | 0 | 70
Precinct 05 | 106 | 0 | 106
Precinct 06 | 88 | 0 | 88
TOTAL | 945 | 0 | 945
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 122701d1317075324-pivot-table-value-dummy1
Sheet: Pivot

 | Manager | Woods, [NAME]
 | Count of 1 - Month (Behavior Segment) | Column Labels
 | Row Labels | 3 - Showing Potential | 4 - Improvement Needed | 5 - Missing All Metrics | Grand Total
 | Lavergne, [NAME] | 1 | 1 |  | 2
 | Piper, Leah |  |  | 2 | 2
 | [NAME], [NAME] |  |  | 1 | 1
 | Grand Total | 1 | 1 | 3 | 5
Spreadsheet: rick_buy__32764__Daily Treas By BU Q3
Sheet: Q3 to Date

 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | 3rd Quarter 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-08-24 00:00:00
 |  |  |  |  | Total |  |  | MTD |  |  |  |  |  | Most
 |  |  |  |  | Q3 to Date |  | Sept | August | July |  |  |  |  | Current Day
 | Enron Transportation Services
 | Portland General Electric
 | Total Distribution
 | Enron North America
 | Enron South America
 | Total Americas
 | Europe
 | Global Markets
 | Industrial Markets
 | Networks
 | Other
 | Total Traditional Wholesale
 | Global Assets
 | EGEP
 | Other Wholesale (EE&CC)
 | Total Wholesale
 | Enron Energy Services
 | Enron Broadband Services
 | Corp
 | Other
 | Total Enron*
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the business units
Spreadsheet: john_hodge__16248__THORNBOROUGH SUMMARY
Sheet: Misc Notes

Misc Estimate Notes and Assumptions
Pipeline Lateral
Designed in accordance with ENRON Engineering Standards and 49 CFR Part 192.
Costs are based on 2001 construction.
Terrain is flat with no wetlands, stream crossings or foreign pipeline crossings.
Pipeline installed with conventional lay methods.
Although the pipeline route appears to be located in a Class 1 location (.72 design factor)
 | at this time, a .6 design factor (Class II) was used  -considering the area appears
 | to be in a high growth area.
No directional drills were included in estimate (none expected).
Contractor install time 14 workings days - barring any rain delays, etc.
Estimate does not include delays caused by the U.S. Fish & Wildlife endangered
 | species habitat conflicts.
Estimate include cost of Archaeology survey and not Archaeology dig if so required by [NAME].
Expediting materials is not included (either during mfg'ing or shipment).
Wetlands mitigation is not expected nor included.
Construction install cost was not completed or reviewed by a contractor.
No condemnations are included in estimate.
Hot tap includes TDW split tee and hot tap valve - all below grade.  Valve extensions include.
 | No abovegrade valve at hot tap location included.
Check valve (wafer type) included on 8"/18" tie-over line.
Pig launcher/receivers not included.
[NAME]
Designed in accordance with ENRON Engineering Standards and 49 CFR Part 192.
Costs are based on 2001 construction.
[NAME] station to be located inside of Customer's property - only minor ROW costs
 | included in estimate.
115 volt power will be made available by Customer at meter station.
Small building included with gas chromatograph.
Estimate accuracy is +/-10%.
Run switching included with meter runs.
Gas chromatograph costs included in meter station estimate.
No station ESD included with meter station estimate.
No pressure or control valves included.
No gas detection included in building
Expediting materials is not included (either during mfg'ing or shipment).
Spreadsheet: 137311d1327056924-vlookup-and-sum-a1
Sheet: Sheet1

Budget line | Spend | Orders | Entity | Distance
1005 | 242525 | 333 | MER200 | 4.6 | 5 [NAME] | North West | 727575 |  |  | 727575
1006 | 34434 | 5454 | MER200 | 18 | 25 [NAME] | North West | 103302
1010 | 5667 | 656 | MER350 | 154 | 250 MILES | South West | 17001
1018 | 776878 | 767 | HEY554 | 18 | 25 [NAME] | North West | 2330634
1022 | 87 | 77 | MER200 | 16 | 25 [NAME] | North West | 261
1028 | 9 | 6 | MER350 | 3 | 5 [NAME] | North West | 27
1034 | 898 | 76 | HEY554 | 2 | 5 [NAME] | North West | 2694
1042 | 89797 | 676 | MER200 | 1 | 5 [NAME] | North West | 269391
1005 | 242525 | 333 | MER200 | 4.6 | 5 [NAME] | North West | 727575
1006 | 34434 | 5454 | MER200 | 18 | 25 [NAME] | North West | 103302
1010 | 5667 | 656 | MER350 | 154 | 250 MILES | South West | 17001
1018 | 776878 | 767 | HEY554 | 18 | 25 [NAME] | North West | 2330634
1022 | 87 | 77 | MER200 | 16 | 25 [NAME] | North West | 261
1028 | 9 | 6 | MER350 | 3 | 5 [NAME] | North West | 27
1034 | 898 | 76 | HEY554 | 2 | 5 [NAME] | North West | 2694
1042 | 89797 | 676 | MER200 | 1 | 5 [NAME] | North West | 269391
1005 | 242525 | 333 | MER200 | 4.6 | 5 [NAME] | North West | 727575
1006 | 34434 | 5454 | MER200 | 18 | 25 [NAME] | North West | 103302
1010 | 5667 | 656 | MER350 | 154 | 250 MILES | South West | 17001
1018 | 776878 | 767 | HEY554 | 18 | 25 [NAME] | North West | 2330634
1022 | 87 | 77 | MER200 | 16 | 25 [NAME] | North West | 261
1028 | 9 | 6 | MER350 | 3 | 5 [NAME] | North West | 27
1034 | 898 | 76 | HEY554 | 2 | 5 [NAME] | North West | 2694
1042 | 89797 | 676 | MER200 | 1 | 5 [NAME] | North West | 269391
See attached example) I am trying to Lookup Values from a budget lines. In column A there will be around 50,000 lines which will contain 1 of around 150 codes. I would like to [NAME] these codes and Sum the value against it in Column B, help would be much appreciated!
Spreadsheet: 172211d1344026706-adding-reminders-tigeravatar-example-for-psilver1
Sheet: Bag 14

Item | Expiration Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bag 14
Item 01 | 2012-08-15 00:00:00
Item 02 | 2012-08-05 00:00:00
Item 03 | 2012-08-10 00:00:00
Item 04 | 2012-08-11 00:00:00
Item 05 | 2012-08-13 00:00:00
Item 06 | 2012-08-17 00:00:00
Item 07 | 2012-08-14 00:00:00
Item 08 | 2012-08-08 00:00:00
Item 09 | 2012-08-08 00:00:00
Item 10 | 2012-08-15 00:00:00
Item 11 | 2012-08-09 00:00:00
Item 12 | 2012-08-16 00:00:00
Item 13 | 2012-08-17 00:00:00
Item 14 | 2012-08-14 00:00:00
Item 15 | 2012-08-13 00:00:00
Item 16 | 2012-08-05 00:00:00
Item 17 | 2012-08-14 00:00:00
Item 18 | 2012-08-07 00:00:00
Item 19 | 2012-08-12 00:00:00
Item 20 | 2012-08-08 00:00:00
Spreadsheet: 91884d1291588564-summarising-data-using-combo-box-example-2-
Sheet: SSAGYONG

Manufacturer | Fuel Type |  | Model
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | [NAME]
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Kyron
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | [NAME]
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Kyron
Spreadsheet: 735595d1623086324-conditional-formatting-trouble-book1
Sheet: CWD_TIL's

 | Quantity of Selected TIL's |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT MODIFY THESE
TIL# | TIL Title | Issue Date | Serial# | Equipment ID | Disposition Status | Disposition Note | Category | Plant | Equipment Name | Outage Status | TIL Status | Site Name | Recurring TIL | TIL Count | Open TIL's | Closed TIL's | Completed Date | Responsibility | Work Type | Notes
1554 | SIGNAGE REQUIREMENTS FOR ENCLOSURES PROTECTED BY [NAME] | 2006-09-25 00:00:00 | 297865 | SY0047461 | [NAME] |  | S - Safety | COTTONWOOD | Unit 1 CT | D - Annual | Active/Open | COTTONWOOD | True
1554 | SIGNAGE REQUIREMENTS FOR ENCLOSURES PROTECTED BY [NAME] | 2006-09-25 00:00:00 | 297866 | SY0047463 | [NAME] |  | S - Safety | COTTONWOOD | Unit 2 CT | D - Annual | Active/Open | COTTONWOOD | false
1554 | SIGNAGE REQUIREMENTS FOR ENCLOSURES PROTECTED BY [NAME] | 2006-09-25 00:00:00 | 297867 | SY0047465 | [NAME] |  | S - Safety | COTTONWOOD | Unit 3 CT | D - Annual | Active/Open | COTTONWOOD | false
1554 | SIGNAGE REQUIREMENTS FOR ENCLOSURES PROTECTED BY [NAME] | 2006-09-25 00:00:00 | 297868 | SY0047467 | [NAME] |  | S - Safety | COTTONWOOD | Unit 4 CT | D - Annual | Active/Open | COTTONWOOD | false
Spreadsheet: 21037d1208081327-excel-import-stock-branches
Sheet: STK BR1

code | des | qty
[PHONE] | AL FELAIJ HAND BRUSH | 1
161726 | ATLAS LUNGY SHAMS 200x200 | 1
RED1840 | BABY WEAR LUCKY BABY 3PCS | 1
COS100 | PERT PLUS 200 | 5
COS200 | PENTINE 200 | 6
130756 | BOYS SPORTS WATCH RMB TA431/9 | 1
190695 | COLOUR BALLOONS 50Pcs RMB | 1
152269 | DOUBLE ALU.KETTLE 3LTR-A3020W | 1
152268 | DOUBLE CIRCLE ALU.COFFEE POT-18CM | 1
151661 | EGG BEATER STEEL 12 INCH-HAQ | 1
MAJ002 | ELECTRIC MAJMUR IBEX WOOD-MINI | 1
1258 | PONDS | 5
Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Hose Diameters

Bowsmith Premium Plus Tubing is fabricated exclusively from a single virgin Linear Low Density Polyethylene (LLDPE) base resin and compounded with a suitable virgin carbon concentrate resin to provide a minimum of 2%carbon black property mixed and dispersed in the finished extrudate. Base resin conforms to the requirements of Specification ASTM D1248 for Type I, Class C, Category 3, [NAME] tubing, and to ASTM D3350 for PE 213111C.
Size Designation Key
Dimensions
[NAME]* | Outside [NAME], (in.) |  | Wall Thickness, (in.) |  | [NAME]. (in.) (Nominal) | ASAE-S435 Pressure Rating, (PSI)
 | [NAME]. | Min. | [NAME]. | Min.
625P48 | 0.625 | 0.615 | 0.048 | 0.043 | 0.53 | 66.5
625P50 | 0.625 | 0.615 | 0.05 | 0.045 | 0.525 | 70.7
700P48 | 0.7 | 0.69 | 0.048 | 0.043 | 0.605 | 58.8
700P50 | 0.7 | 0.69 | 0.05 | 0.045 | 0.6 | 62.5
700P55 | 0.7 | 0.69 | 0.055 | 0.05 | 0.59 | 70
720P48 | 0.72 | 0.71 | 0.048 | 0.043 | 0.625 | 57
795P52 | 0.795 | 0.785 | 0.053 | 0.048 | 0.69 | 57.1
835P52 | 0.835 | 0.825 | 0.053 | 0.048 | 0.73 | 54.7
935P62 | 0.935 | 0.923 | 0.063 | 0.056 | 0.811 | 57.4
3/4"-50 | 0.935 | 0.923 | 0.059 | 0.052 | 0.818 | 53.5
1195P72 | 1.195 | 1.181 | 0.073 | 0.066 | 1.05 | 52.6
1"-45 | 1.195 | 1.181 | 0.069 | 0.062 | 1.057 | 49.6
Spreadsheet: 75303d1275902709-sumif-example
Sheet: Sheet1

PPC |  | BB |  | SATV |  | PATV |  | TNS |  | T-O |  | Total Rank
[NAME] | 1 | Pauline | 1 | [NAME] | 1 | [NAME] | 1 | Reena | 1 | Reena | 1 | Reena
Pauline | 2 | Reena | 2 | Pauline | 2 | [NAME] | 2 | Ash | 2 | [NAME] | 2 | [NAME] | 0 |  | I would like to be able to change the prder or names that are entered here
[NAME] | 3 | [NAME] | 3 | Reena | 3 | Pauline | 3 | [NAME] | 3 | [NAME] | 3 | [NAME] | 0
Ash | 4 | [NAME] | 4 | [NAME] | 4 | Ash | 4 | Pauline | 4 | Pauline | 4 | Pauline | 0
Reena | 5 | Ash | 5 | Ash | 5 | Reena | 5 | [NAME] | 5 | Ash | 5 | Ash | 0
[NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 0
Lynda | 7 | Lynda | 7 | Lynda | 7 | Lynda | 7 | Lynda | 7 | Lynda | 7 | Lynda | 0
Carol | 8 | Carol | 8 | Carol | 8 | Carol | 8 | Carol | 8 | Carol | 8 | Carol | 0 |  | I would like these cells to add the total rankings for each person
[NAME] | 9 | [NAME] | 9 | [NAME] | 9 | [NAME] | 9 | [NAME] | 9 | [NAME] | 9 | [NAME] | 0
[NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 10 | [NAME] | 0
[NAME] | 11 | [NAME] | 11 | [NAME] | 11 | [NAME] | 11 | [NAME] | 11 | [NAME] | 11 | [NAME] | 0
[NAME] | 12 | [NAME] | 12 | [NAME] | 12 | [NAME] | 12 | [NAME] | 12 | [NAME] | 12 | [NAME] | 0
[NAME] | 13 | [NAME] | 13 | [NAME] | 13 | [NAME] | 13 | [NAME] | 13 | [NAME] | 13 | [NAME] | 0
Gina | 14 | Gina | 14 | Gina | 14 | Gina | 14 | Gina | 14 | Gina | 14 | Gina | 0
0 | 15 | 0 | 15 | 0 | 15 | 0 | 15 | 0 | 15 | 0 | 15 | 0
0 | 16 | 0 | 16 | 0 | 16 | 0 | 16 | 0 | 16 | 0 | 16 | 0
0 | 17 | 0 | 17 | 0 | 17 | 0 | 17 | 0 | 17 | 0 | 17 | 0
0 | 18 | 0 | 18 | 0 | 18 | 0 | 18 | 0 | 18 | 0 | 18 | 0
0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0 | 19 | 0
0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0
0 | 21 | 0 | 21 | 0 | 21 | 0 | 21 | 0 | 21 | 0 | 21 | 0
0 | 22 | 0 | 22 | 0 | 22 | 0 | 22 | 0 | 22 | 0 | 22 | 0
0 | 23 | 0 | 23 | 0 | 23 | 0 | 23 | 0 | 23 | 0 | 23 | 0
0 | 24 | 0 | 24 | 0 | 24 | 0 | 24 | 0 | 24 | 0 | 24 | 0
0 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | 25 | 0
0 | 26 | 0 | 26 | 0 | 26 | 0 | 26 | 0 | 26 | 0 | 26 | 0
0 | 27 | 0 | 27 | 0 | 27 | 0 | 27 | 0 | 27 | 0 | 27 | 0
0 | 28 | 0 | 28 | 0 | 28 | 0 | 28 | 0 | 28 | 0 | 28 | 0
0 | 29 | 0 | 29 | 0 | 29 | 0 | 29 | 0 | 29 | 0 | 29 | 0
0 | 30 | 0 | 30 | 0 | 30 | 0 | 30 | 0 | 30 | 0 | 30 | 0
0 | 31 | 0 | 31 | 0 | 31 | 0 | 31 | 0 | 31 | 0 | 31 | 0
0 | 32 | 0 | 32 | 0 | 32 | 0 | 32 | 0 | 32 | 0 | 32 | 0
0 | 33 | 0 | 33 | 0 | 33 | 0 | 33 | 0 | 33 | 0 | 33 | 0
Spreadsheet: 62274d1263247046-pull-every-instance-index-match-criteria-into-consecutive-rows-directors-intervention-report-template
Sheet: Intervention

Date | Log Entry Text | Follow-Up
Subtype
Sub-subtype
Action Status
Reporter
Level
Spreadsheet: 271365d1381920726-inventory-and-stock-sheet-running-total-calculation-inventory-data
Sheet: Inventory

Entered | Entered By | Products | Transaction | Qty | Price | Total
2013-10-16 16:15:32 | Yuvraj-PC | Dual Media Convertor | Purchase | 5 | 3000 | 15000
2013-10-16 16:15:52 | Yuvraj-PC | Single Media Convertor | Purchase | 4 | 1800 | 7200
Spreadsheet: 842532d1694588749-transpose-a-table-my-request
Sheet: Sheet1

Limousine | blue | red | yellow | pink | white | black
Volkwagon | yellow | silver | purple
This is how I want to rearrange it:
Limousine | blue
Limousine | red
Limousine | yello
Limousine | pink
Limousine | white
Limousine | black
Volkswagon | blue
Volkswagon | silver
Volkswagon | purple
Spreadsheet: matt_motley__26408__proposal to UAMPS
Sheet: UAMPS Restructuring

 |  | Imputed Price |  | Imputed Price
 |  |  | LLH Converted |  | LLH Converted
Delivery | Current |  | to HLH |  | to HLH | Net Remaining
Month | Deal W/Enron | Washington | Washinton | Fallon | Fallon | Contract
 | HLH | Blocks (HLH) | Blocks (LLH) | Blocks (HLH) | Blocks (LLH) | Volume
2001-11-01 00:00:00
2001-12-01 00:00:00 | 50
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00 |  | 13 | 6
2002-08-01 00:00:00 |  | 13 | 5
2002-09-01 00:00:00 |  | 11 | 5
2002-10-01 00:00:00 |  | 9 | 4
2002-11-01 00:00:00 |  | 8 | 5
2002-12-01 00:00:00 |  | 8 | 5
2003-01-01 00:00:00 |  | 6 | 3
2003-02-01 00:00:00 |  | 6 | 3
2003-03-01 00:00:00 |  | 6 | 3 | 9 | 3
2003-04-01 00:00:00 |  | 10 | 3 | 10 | 3
2003-05-01 00:00:00 |  | 10 | 4 | 10 | 3
2003-06-01 00:00:00 |  | 11 | 4 | 10 | 3
2003-07-01 00:00:00 |  | 13 | 5 | 13 | 3
2003-08-01 00:00:00 |  | 13 | 5 | 13 | 2
2003-09-01 00:00:00 |  | 11 | 5 | 10 | 3
2003-10-01 00:00:00
2003-11-01 00:00:00
2003-12-01 00:00:00
2004-01-01 00:00:00
2004-02-01 00:00:00
2004-03-01 00:00:00
2004-04-01 00:00:00
2004-05-01 00:00:00
2004-06-01 00:00:00
2004-07-01 00:00:00
2004-08-01 00:00:00
2004-09-01 00:00:00
2004-10-01 00:00:00
2004-11-01 00:00:00
2004-12-01 00:00:00
2005-01-01 00:00:00
2005-02-01 00:00:00
2005-03-01 00:00:00
2005-04-01 00:00:00
2005-05-01 00:00:00
2005-06-01 00:00:00
2005-07-01 00:00:00
2005-08-01 00:00:00
2005-09-01 00:00:00
2005-10-01 00:00:00
2005-11-01 00:00:00
2005-12-01 00:00:00
2006-01-01 00:00:00
2006-02-01 00:00:00
2006-03-01 00:00:00
2006-04-01 00:00:00
2006-05-01 00:00:00
2006-06-01 00:00:00
2006-07-01 00:00:00
2006-08-01 00:00:00
2006-09-01 00:00:00
2006-10-01 00:00:00
2006-11-01 00:00:00
2006-12-01 00:00:00
2007-01-01 00:00:00
2007-02-01 00:00:00
2007-03-01 00:00:00
2007-04-01 00:00:00
2007-05-01 00:00:00
2007-06-01 00:00:00
2007-07-01 00:00:00
2007-08-01 00:00:00
2007-09-01 00:00:00
2007-10-01 00:00:00
2007-11-01 00:00:00
2007-12-01 00:00:00