tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705806d1606314845-conditional-formatting-not-highlighting-highest-distinct-values-testing-sheet-2
Sheet: SHEET 1

 |  | # | NAME |  |  |  |  |  |  |  |  |  |  |  | LAST VALUE
 |  | 1 |  | 102 |  |  |  |  | 100 | 1 | 2 | 3 | 1000 |  | 1000 |  |  |  | 96
 |  |  |  | 101 |  |  |  |  | 100 | 4 | 5 | 6 | 1000 |  | 2000 |  |  |  | 96
 |  |  |  | 100 |  |  |  |  | 100 | 4 | 5 | 6 | 1000 |  | 5000 |  |  |  | 97
 |  |  |  | 103 |  |  |  |  | 100 | 1 | 2 | 3 | 1000 |  | 3000 |  |  |  | 94
 |  |  |  | 101 |  |  |  |  | 100 | 2 | 3 | 4 | 1000 |  | 4000 |  |  |  | 95
 |  |  |  | 105 |  |  |  |  | 100 | 100 | 100 | 100 | 1000 |  | 1000 |  |  |  | 96
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 2000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 3000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 5000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  |  |  | -100 |  |  |  |  |  | 100 | 100 | 100 | 1000 |  | 1000
 |  | # | NAME |  | LAST VALUE
Spreadsheet: 734866d1622554218-buy-now-pay-later-payment-formula-for-three-months-book2
Sheet: A

 |  | M1 | M2 | M3 | M4 | M5 | M6 | M7
 |  | 1000000
 | Repayments
Spreadsheet: susan_bailey__39385__Nevada Power Company
Sheet: tagg1

Buyer | [NAME] | Deal No. | Type | Deal Date | Status | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | Price
NPC | ENA | V31150.1 | Swap | 2001-04-11 00:00:00 | Executed | 10000 MMBtu/day | NG | NGI-SOCAL | NX3 | 2001-11-01 00:00:00 | 2002-10-31 00:00:00 | US 5.30000
Spreadsheet: 121548d1316137781-pivot-table-to-roll-up-data-and-display-in-pivot-chart-tickets
Sheet: Sheet1

Date | Request | Assigned To | Duration | Date&Name | Count of Date&Name | Duration*Count
2011-01-02 00:00:00 | Printer | [NAME] | 1.5
2011-01-02 00:00:00 | Toner | [NAME] | 1
2011-01-02 00:00:00 | [NAME] | [NAME] | 0.25
2011-01-02 00:00:00 | Keyboard | [NAME] | 0.5
2011-01-02 00:00:00 | Power Cable | [NAME] | 2
2011-01-03 00:00:00 | Missing mouse | [NAME] | 2
2011-01-03 00:00:00 | Printer | [NAME] | 4
2011-01-03 00:00:00 | Toner | [NAME] | 3
2011-01-03 00:00:00 | [NAME] | [NAME] | 2
2011-01-03 00:00:00 | Keyboard | [NAME] | 1
 |  |  |  | 2.5
 |  |  | 1.5
 |  |  | 1
 |  |  | 2
 |  |  | 1
 |  |  |  | 3
Spreadsheet: 65171d1265892586-adding-up-stock-records
Sheet: Alta Vista (OPTH)

OPTH | Company | Range | Model | Colour | Size | Single Cost | Actual Price | Current Balance
OPTH | Capitol | Alta Vista | 1011 | 2 | 52 x 18 | 5 | 15 | 0
OPTH | Capitol | Alta Vista | 1011 | 3 | 52 x 18 | 5 | 15 | 1
OPTH | Capitol | Alta Vista | 1013 | 1 | 52 x 20 | 5 | 15 | 0
OPTH | Capitol | Alta Vista | 1013 | 2 | 52 x 20 | 5 | 15 | 1
OPTH | Capitol | Alta Vista | 1019 | 1 | 49 x 18 | 5 | 15 | 1
OPTH | Capitol | Alta Vista | 1019 | 2 | 49 x 18 | 5 | 15 | 0
OPTH | Capitol | Alta Vista | 1023 | 1 | 51 x 18 | 5 | 15 | 0
OPTH | Capitol | Alta Vista | 1023 | 2 | 51 x 18 | 6 | 16 | 2
OPTH | Capitol | Alta Vista | 1039 | 1 | 51 x 18 | 6 | 16 | 1
OPTH | Capitol | Alta Vista | 1039 | 2 | 51 x 18 | 6 | 16 | 0
OPTH | Capitol | Alta Vista | 1023 | 3 | 51 x 18 | 6 | 16 | 1
OPTH | Capitol | Alta Vista | 3005 | 1 | 50 x 19 | 6 | 16 | 1
OPTH | Capitol | Alta Vista | 3005 | 2 | 50 x 19 | 6 | 16 | 1
OPTH | Capitol | Alta Vista | 3005 | 3 | 50 x 19 | 7 | 17 | 0
OPTH | Capitol | Alta Vista | 3009 | 1 | 52 x 17 | 7 | 17 | 0
OPTH | Capitol | Alta Vista | 3009 | 2 | 52 x 17 | 7 | 17 | 0
OPTH | Capitol | Alta Vista | 3009 | 3 | 52 x 17 | 7 | 17 | 1
OPTH | Capitol | Alta Vista | 3021 | 1 | 50 x 17 | 7 | 17 | 2
OPTH | Capitol | Alta Vista | 3021 | 2 | 50 x 17 | 8 | 18 | 1
OPTH | Capitol | Alta Vista | 3021 | 3 | 50 x 17 | 8 | 18 | 0
OPTH | Capitol | Alta Vista | 3023 | 1 | 51 x 17 | 8 | 18 | 0
OPTH | Capitol | Alta Vista | 3023 | 2 | 51 x 17 | 8 | 18 | 0
OPTH | Capitol | Alta Vista | 3023 | 3 | 51 x 17 | 9 | 19 | 1
OPTH | Capitol | Alta Vista | 8007 | 1 | 51 x 20 | 9 | 19 | 0
OPTH | Capitol | Alta Vista | 8007 | 2 | 51 x 20 | 9 | 19 | 1
OPTH | Capitol | Alta Vista | 8007 | 3 | 51 x 20 | 9 | 19 | 0
OPTH | Capitol | Alta Vista | 8009 | 1 | 54 x 18 | 9 | 19 | 1
OPTH | Capitol | Alta Vista | 8009 | 2 | 54 x 18 | 9 | 19 | 1
 |  |  |  |  | Totals | 192 | 472 | 17
Spreadsheet: 734431d1622153548-lookup-help-using-offset-and-match-spreadsheet-for-chat
Sheet: CFS flock calculator

 |  |  |  |  |  | Autofill
DropDn | Autofill | DropDn | DropDn | MM-DD | 2% included | ft2 | DropDn | MM-DD |  |  |  |  |  | kg/m2 |  |  | MM-DD |  |  |  |  | [NAME] | kg/m2 |  |  | kg/m2 | Weighted Calculations
Cycle | [NAME] | Farm Name | Barn ID | PMT date | Chick # | [NAME] | Thin-out? | THIN Date | [NAME] # | [NAME] shipped | CDX #, Thin | DOA #, Thin | Calc. flock kgs | Calc. SD, Thin | % CDX, [NAME] | % DOA, [NAME] | FINAL Date | FINAL Bird # | FINAL kgs shipped | CDX #, Final | DOA #, Final | Calc. AVG WT. | Calc. SD @ FINAL | % CDX, FINAL | % DOA, FINAL | WEIGHTED SD | % Mortality | % CDX | % DOA | COMMENTS
A-170 |  | Wing Ranch | Barn 1 | 2021-05-01 00:00:00 | 15000 |  | No |  |  |  |  |  |  |  |  |  | 2021-06-15 00:00:00 | 14900 | 44975
 |  | Star City Colony | Barn 4 | 2021-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95495
 |  | Arm River Farming | Barn 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72781
 |  | Callicoon Farms | Barn 3
 |  | =OFFSET(BarnLookup,MATCH(C4,ProdList,0)-1,1,1,COUNTA(OFFSET(BarnLookup,MATCH(C4,ProdList,0)-1,1,1,15)))
 |  | =OFFSET((BarnLookup,MATCH(C4,ProdList,0)-1,1,1,COUNTA(OFFSET(BarnLookup,MATCH(C4,ProdList,0)-1,1,1,15))))-1,1,1,15)
Spreadsheet: 197831d1354570612-lookup-and-enter-multiple-values-material
Sheet: Formulas

PRODUCT | COMPONENT | MATERIAL NUMBER | LAYER A % | LAYER A PARTS % | LAYER B % | LAYER B PARTS % | LAYER C % | LAYER C PARTS %
HYFOL 14 | 110359P |  | 25 | 47.7 | 50 | 37.8 | 25 | 47.7 | LUPOLEN 2420F
HYFOL 14 | 165679-U |  | 25 | 30 | 50 | 30 | 25 | 30 | DOWLEX 2042N
HYFOL 14 | 155011-U |  | 25 | 22 | 50 | 22 | 25 | 22 | [NAME]
HYFOL 14 | 131653-U |  | 25 |  | 50 | 10.2 | 25 |  | REMAFIN PELM75
HYFOL 14 | PLA0050133 |  | 25 | 0.3 | 50 |  | 25 | 0.3 | ARX 741 PA
HYFOL 14US | PEA0050915 |  | 25 | 47.7 | 50 | 37.8 | 25 | 47.7 | EN1807AA
HYFOL 14US | [NAME] |  | 25 | 30 | 50 | 30 | 25 | 30 | DOWLEX 2042N
HYFOL 14US | NA 960-000 |  | 25 | 22 | 50 | 22 | 25 | 22 | PROFAX SV258
HYFOL 14US | 10919 |  | 25 |  | 50 | 10.2 | 25 |  | REMAFIN PELM75
HYFOL 14US | 100691-U |  | 25 | 0.3 | 50 |  | 25 | 0.3 | ARX 741 PA
Spreadsheet: 33d5cf30-7c84-423d-935b-9fedf9ca5f77
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
DOE Digital Photo Archive |  |  | 1087666 |  |  |  | Collection | Still Images or Photos |  |  | USDOE | 99 GENERAL AND [NAME] |  | The DOE Digital Photo Archive is a resource made available to the DOE community as well as the general public for the purposes of enhancing communication, education, and ultimately the overall mission of the Department of Energy (DOE). The images in the Archive are downloadable as low resolution JPG files and may easily and quickly be requested in high resolution.  The database can be browsed or is searchable by science program, sites by name, geographic locations, etc.  Each photo has a caption or brief summary, and most are not copyrighted. |  | DOE Headquarters, Energy Technology Visuals Collection |  |  |  | http://www.osti.gov/dataexplorer/servlets/purl/1087666
Spreadsheet: 48539d1247754725-strategy-for-combinging-two-tables-exampleload
Sheet: FINAL

MONTH | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH 6
OPERATION | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7 | Operation8 | Operation9 | Operation10 | Operation11 | Operation12 | Operation13 | Operation14 | Operation15 | Operation16 | Operation17 | Operation18 | Operation19 | Operation20 | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7 | Operation8 | Operation9 | Operation10 | Operation11 | Operation12 | Operation13 | Operation14 | Operation15 | Operation16 | Operation17 | Operation18 | Operation19 | Operation20 | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7 | Operation8 | Operation9 | Operation10 | Operation11 | Operation12 | Operation13 | Operation14 | Operation15 | Operation16 | Operation17 | Operation18 | Operation19 | Operation20 | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7 | Operation8 | Operation9 | Operation10 | Operation11 | Operation12 | Operation13 | Operation14 | Operation15 | Operation16 | Operation17 | Operation18 | Operation19 | Operation20 | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7 | Operation8 | Operation9 | Operation10 | Operation11 | Operation12 | Operation13 | Operation14 | Operation15 | Operation16 | Operation17 | Operation18 | Operation19 | Operation20 | Operation1 | Operation2 | Operation3 | Operation4 | Operation5 | Operation6 | Operation7 | Operation8 | Operation9 | Operation10 | Operation11 | Operation12 | Operation13 | Operation14 | Operation15 | Operation16 | Operation17 | Operation18 | Operation19 | Operation20
ITEM
ITEM1
ITEM2
ITEM3
ITEM4
ITEM5
ITEM6
ITEM7
ITEM8
ITEM9
ITEM10
ITEM11
ITEM12
ITEM13
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MONTH 1 TOTAL | 0
MONTH 2 TOTAL | 0
MONTH 3 TOTAL | 0
MONTH 4 TOTAL | 0
MONTH 5 TOTAL | 0
MONTH 6 TOTAL | 0
Spreadsheet: 686314d1594493176-matching-addresses-to-phone-numbers-real-estate-address-1
Sheet: First 

 |  |  | Paste Here |  |  |  |  |  |  | Paste Here |  |  |  |  |  |  | Paste Here
1 |  |  | Phone Number | First Name | Last Name | Address | City | State | Zip
2 |  |  | 7575390705 | Gloria | Colbert | 1210 Lake Kennedy Dr | Suffolk | VA | 23434
3
4 |  |  | 7575390073 | Echoe | Edmond | 400 [NAME] | Suffolk | VA | 23434
5
6 |  |  | 8045392944 |  | GRAHAM SALLIE R EST | 823 Seminole Dr | Suffolk | VA | 23434
7
8 |  |  | 7577457021 | ANNA | SMITH | 2701 E Washington St | Suffolk | VA | 23434
 |  |  | 7577616402 | [NAME] | Butler | 2849 E Washington St | Suffolk | VA | 23434
 |  |  | 7574833327 | LEOTIS | [NAME] | 3408 Holland Rd | Suffolk | VA | 23434
 |  |  | 7575397274 | [NAME] | Manley | 2313 Manning Rd | Suffolk | VA | 23434
 |  |  | 7576579927 | [NAME] | Eller | 3917 Holland Rd | Suffolk | VA | 23434
 |  |  | 7578091221 | R Linwood | [NAME] | 1462 Whaleyville Blvd | Suffolk | VA | 23434
 |  |  | 7578091221 | R Linwood | [NAME] | 1462 Whaleyville Blvd | Suffolk | VA | 23434
Spreadsheet: louise_kitchen__22633__SepQTD Orig w notes Faith
Sheet: summary by team

Enron North America
For Quarter Ended September 30
Summary by Team
Team |  | Total |  | %Total
Canada Total |  | 51953386
ERCOT Orig Total |  | 18070000
West Orig Total |  | 15025521
West Gas Total |  | 9264480
Derivatives Total |  | 7764437
Development Total |  | 2579000
Central Gas Total |  | 2457722
Southeast Orig Total |  | 1695425
Mexico Origination Total |  | 1449375
East Gas Total |  | 821765
Northeast Orig Total
Midwest Orig Total |  | 299540
Enron Capital Res Total |  | 28200
Texas Gas Total |  | 1240
Gas Assets Total |  | 0
Total
Spreadsheet: 772707d1647439910-need-help-with-lookup-values-between-tabs-book1
Sheet: CCV67

 |  |  |  | CADDY INVENTORY CHECKLIST
 |  |  |  | CCV | 67 | DATE
FRONT CAB
ITEM |  | TAG NR | CHECKED | COMMENT
1 | TYRE PRESSURE MONITOR
2 | TABLET + CAR CHARGER
RIGGING |  | TAG NR
ITEM |  | TAG NR | CHECKED | COMMENT
1 | GENERATOR
2 | POWER WASHER
3 | VACUUM CLEANER
4 | HOSE REEL + HOSE
5 | HP GUN
6 | WATERTANK 1-3
7 | EXTENSION CORD 1
8 | EXTENSION CORD 2
9 | FIRE EXTINGUISHER
9 | STEPLADDER
WINDSCREEN KIT |  | TAG NR
ITEM |  | CHECKED | COMMENT
1 | W/S DRILL
2 | BRIDGE
3 | CURING LAMP
4 | W/S MIRROR
5 | GAS [NAME]
6 | SCRAPER
7 | DRILL BITS | QUANTITY:
8 | RESIN | QUANTITY:
POLISHER KIT
ITEM |  | TAG NR | CHECKED | COMMENT
1 | POLISHER A
2 | POLISHER B
3 | WHITE MOP | QUANTITY:
4 | BLACK MOP | QUANTITY:
5 | BLUE MOP | QUANTITY:
 |  | TAG NR | CHECKED | COMMENT
PDR LIGHT + STAND
PDR KIT |  | TAG NR
ITEM |  | CHECKED | COMMENT
1 | DENT PULLER | QUANTITY: | 31
2 | SLIDING HAMMER | QUANTITY: | 32
3 | GLUE GUN | QUANTITY: | 33
4 | GLASS PLATE | QUANTITY: | 34
5 | WINDOW WEDGE | QUANTITY: | 35
6 | HAMMER | QUANTITY: | 36
7 | PUNCH | QUANTITY: | 37
8 | DENT TOOLS | QUANTITY: | 38
9 | TOOL HANDLES | QUANTITY: | 39
10 | [NAME] | QUANTITY: | 40
11 | BONNET RING | QUANTITY: | 41
12 | PLUGS LARGE | QUANTITY: | 42
13 | PLUGS MEDIUM | QUANTITY: | 43
14 | PLUGS SMALL | QUANTITY: | 44
15 | GLUE STICKS | QUANTITY: | 45
PAINT [NAME] |  | TAG NR
ITEM |  | CHECKED | COMMENT
PA SAMPLES
[NAME]
PC SAMPLES
PD SAMPLES
PE SAMPLES
PF [NAME]
PG SAMPLES
PH SAMPLES
TONER [NAME] |  | TAG NR
ITEM |  | CHECKED | COMMENT
M-TONER KIT
S - TONER KIT
**DECLERATION**
I HEREBY DECLARE THAT I HAVE PHYSICALLY CHECKED THE VEHICLE AND ALL EQUIPMENT BEFORE LEAVING THE
DEPOT. ALL DAMAGES AND DEFAULT HAVE BEEN REPORTED AND / FIXED. I TAKE FULL RESPONSIBILITY FOR THE
VEHICLE AND ALL EQUIPMENT.
 | NAME |  |  | SIGNATURE
 | VERIFIED BY MANAGER: |  | NAME
 | SIGNATURE:
Spreadsheet: 766266d1643821636-read-partial-text-from-another-cell-chas_tes4
Sheet: Lookup

ProjectIdentifier | ProjectName | ProjectOwnerName | PortfolioManager | Phase | PhaseStatus | PortfolioName | EnterpriseProjectTypeName
1554 | Permission to Publish | [NAME] | TBC | Delivery (Build) | In Progress | Corporate | IS Project
2168 | Workplace Risk Assesment Tool | [NAME] | PMO | Qualify Demand | In Progress | Site Asset Science | IS Project
2286 | Digital Signature Software | Rust Barker | TBC | Roadmap |  | Andarta | IS Project
2138 | Digitisation Core Programme | [NAME] | PMO | Idea Review | Cancelled |  | IS Project
2047 | Digital Index - Release 1 | Smith Dawn | TBC | Delivery (Build) | In Progress | Digitisation | IS Project
1563 | Workspace Management - Phase 2 | Jones [NAME] | PMO | Delivery (Build) | In Progress | Site Asset Science | IS Project
1454 | Digital Index - Phase 1_Plan | [NAME] | TBC | Transition (Transition & Closure) | Completed | Digitisation | IS Project
1183 | Digital Radio Implementation | [NAME] | PMO | Delivery (Build) | In Progress | IS Change | IS Project
Spreadsheet: 879159d1726604955-sumproduct-w-index-match-that-uses-indirect-breaks-with-sort-of-underlying-non-working-allocation-and-risk-data1
Sheet: Models

 |  | Ticker | Unused | Aggressive | Moderate Aggressive | Moderate | Moderate Conservative | Conservative
 |  | AGG |  |  | 0.085 | 0.145 | 0.215 | 0.345
 |  | CPITX |  |  | 0.045 | 0.045 | 0.045 | 0.095
 |  | APDPX |  |  | 0.025 | 0.06 | 0.06 | 0.08
 |  | [NAME] |  | 0.2 | 0.15 | 0.15 | 0.1 | 0.05
 |  | BLNDX |  | 0.09 | 0.07 | 0.05 | 0.05 | 0.05
 |  | DIVO |  | 0.04 | 0.05 | 0.05 | 0.05 | 0.05
 |  | SFHYX |  |  |  | 0.04 | 0.05 | 0.05
 |  | HMEZX |  |  |  | 0.03 | 0.05 | 0.05
 |  | RDMIX |  |  |  |  | 0.05 | 0.05
 |  | SVARX |  |  |  |  | 0.05 | 0.05
 |  | JHEQX |  |  |  | 0.035 | 0.045 | 0.045
 |  | CBHIX |  |  |  |  | 0.045 | 0.045
 |  | Cash |  | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
 |  | TLT |  | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
 |  | ITOT |  |  | 0.27 | 0.2 | 0.1
 |  | PRWCX |  |  | 0.035 | 0.035 | 0.05
 |  | IXUS |  | 0.08 | 0.05 | 0.04
 |  | PNAIX |  | 0.04 | 0.05 | 0.04
 |  | IVVB |  | 0.04 | 0.04 | 0.04
 |  | LBFIX |  | 0.05 | 0.05
 |  | GPGCX |  | 0.04 | 0.04
 |  | IVV |  | 0.23
 |  | IJH |  | 0.07
 |  | BFGIX |  | 0.04
 |  | IJR |  | 0.04
Spreadsheet: 742576d1627894795-relative-references-to-tables-in-different-workbooks-same-folder-with-indirect-report-02
Sheet: Report 02

 | Report 02 : Volume |  | Direct |  | Indirect Formula |  | References for indirect formula
 |  |  |  |  |  |  |  | Table | Result Column | Group | Group Column |  | Group | Result |  | Group | Result
 | [NAME], average |  |  |  |  |  | Source.xlsx | Volume | litres | [NAME] | Group
 | [NAME], average |  |  |  |  |  | Source.xlsx | Volume | litres | [NAME] | Group
 | [NAME], average |  |  |  |  |  | Source.xlsx | Volume | litres | [NAME] | Group
Spreadsheet: 164922d1340961429-look-values-with-a-twist-0alook-up-query-v2
Sheet: Data

Account | Cost Center | Amount | Amount
1006109 |  | 0 | 2461.62
1006109 |  | 0 | 262776.51
1006109 |  | 0 | 103308
2203015 |  | 0 | 648.38
2206001 |  | 0 | 35226.13
2206001 | SS | 0 | 10179.58
5000001 | 1405801100 | 8861.25 | 0
5000001 | 1505800650 | 37980.95 | 0
5000001 | 1705800001 | 58436.78 | 0
5000001 | 1705800002 | 130282.09 | 0
5000001 | 1705800012 | 10081.42 | 0
5000001 | 1705800022 | 26357 | 0
5000001 | 1805800005 | 6988.5 | 0
5000001 | 1805800018 | 23385.01 | 0
5000001 | 1805800035 | 6524.8 | 0
5000001 | 1805807100 | 11818.58 | 0
5000001 | 1905800002 | 17259.92 | 0
5000001 | 2305800001 | 19736.79 | 0
5010015 | 1405801100 | 3545 | 0
5010015 | 1505800650 | 6779 | 0
5010015 | 1805800018 | 3803 | 0
5010015 | 1805807100 | 5352 | 0
5010015 | 2305800001 | 2182 | 0
5030008 | 1405801100 | 1205.17 | 0
5030008 | 1505800650 | 4017.03 | 0
5030008 | 1705800001 | 5070.39 | 0
5030008 | 1705800002 | 12388.41 | 0
5030008 | 1705800012 | 839.74 | 0
5030008 | 1705800022 | 2372.13 | 0
5030008 | 1805800005 | 936.4 | 0
5030008 | 1805800018 | 2697.59 | 0
5030008 | 1805800035 | 628.43 | 0
5030008 | 1805807100 | 1663.54 | 0
5030008 | 1905800002 | 1482.26 | 0
5030008 | 2305800001 | 1925.04 | 0
Spreadsheet: jason_wolfe__13510__daily usage values2
Sheet: monthly

Monthly summary of daily gas usage at Palo Alto's citygate
 | daily usage (MCF/day)
 | average daily | maximum use day | minimum use day
1997-07-01 00:00:00
1997-08-01 00:00:00
1997-09-01 00:00:00
1997-10-01 00:00:00
1997-11-01 00:00:00
1997-12-01 00:00:00
1998-01-01 00:00:00
1998-02-01 00:00:00
1998-03-01 00:00:00
1998-04-01 00:00:00
1998-05-01 00:00:00
1998-06-01 00:00:00
1998-07-01 00:00:00
1998-08-01 00:00:00
1998-09-01 00:00:00
1998-10-01 00:00:00
1998-11-01 00:00:00
1998-12-01 00:00:00
1999-01-01 00:00:00
1999-02-01 00:00:00
1999-03-01 00:00:00
1999-04-01 00:00:00
1999-05-01 00:00:00
1999-06-01 00:00:00
1999-07-01 00:00:00
1999-08-01 00:00:00
1999-09-01 00:00:00
1999-10-01 00:00:00
1999-11-01 00:00:00
1999-12-01 00:00:00
2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00
2000-04-01 00:00:00
2000-05-01 00:00:00
2000-06-01 00:00:00
2000-07-01 00:00:00
2000-08-01 00:00:00
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
Spreadsheet: 466022d1465986220-how-to-do-addtion-in-pivot-and-make-it-decnding-order-sort
Sheet: Sheet5 (2)

Row Labels | BEARISH | BULLISH
INFY | 9
YESBANK | 8 | 1
AXISBANK | 8
RECLTD | 1 | 7
SBIN |  | 8
HDFC | 7
HEROMOTOCO | 7
SYNDIBANK |  | 7
ASHOKLEY | 6
AUROPHARMA | 3 | 3
BANKBARODA | 1 | 5
BHARTIARTL | 6
CAIRN | 6
COALINDIA | 6
IBREALEST |  | 6
ICICIBANK |  | 6
ITC |  | 6
KPIT | 6
LICHSGFIN | 4 | 2
MARUTI | 6
PNB |  | 6
RELIANCE | 5 | 1
[NAME] |  | 6
TATAMOTORS |  | 6
TCS | 6
TECHM | 6
UPL | 5 | 1
ADANIPORTS |  | 5
ASIANPAINT | 5
BPCL | 5
DLF |  | 5
[NAME] |  | 5
HINDPETRO | 5
IDEA | 5
IFCI |  | 5
JUSTDIAL |  | 5
LT | 5
M&M | 5
NTPC | 5
ONGC | 5
PETRONET |  | 5
PFC | 1 | 4
TATAGLOBAL | 5
TITAN |  | 5
UNIONBANK |  | 5
WIPRO | 3 | 2
ADANIENT |  | 4
AMBUJACEM | 4
APOLLOTYRE |  | 4
BHEL |  | 4
CROMPGREAV |  | 4
[NAME] |  | 4
HCLTECH | 4
HINDUNILVR | 4
IDBI |  | 4
IGL |  | 4
INDUSINDBK | 4
INFRATEL | 2 | 2
JINDALSTEL |  | 4
JISLJALEQS | 3 | 1
JUBLFOOD |  | 4
KOTAKBANK | 4
L&TFH |  | 4
NMDC | 1 | 3
POWERGRID | 3 | 1
RELCAPITAL |  | 4
RPOWER |  | 4
SUNPHARMA |  | 4
TATASTEEL |  | 4
WOCKPHARMA | 1 | 3
ZEEL | 4
AJANTPHARM | 1 | 2
ALBK |  | 3
ANDHRABANK |  | 3
ARVIND | 2 | 1
BANKINDIA |  | 3
BHARATFORG | 1 | 2
BIOCON | 3
[NAME] | 1 | 2
CIPLA |  | 3
DABUR |  | 3
DRREDDY | 3
GRANULES | 1 | 2
HDFCBANK | 2 | 1
HDIL |  | 3
IBULHSGFIN | 2 | 1
IRB | 3
JETAIRWAYS |  | 3
JSWSTEEL | 3
KSCL | 3
ORIENTBANK |  | 3
SKSMICRO | 3
SRF | 3
SRTRANSFIN | 2 | 1
SUNTV |  | 3
TATAMTRDVR |  | 3
TATAPOWER | 3
ULTRACEMCO | 3
UNITECH |  | 3
VEDL |  | 3
VOLTAS | 1 | 2
ADANIPOWER |  | 2
BAJAJ-AUTO | 2
BAJFINANCE | 2
BEL | 1 | 1
CASTROLIND | 2
CUMMINSIND |  | 2
DHFL |  | 2
GLENMARK | 2
HAVELLS | 1 | 1
HEXAWARE | 2
HINDALCO | 2
[NAME] | 2
M&MFIN | 1 | 1
[NAME] | 2
NCC |  | 2
NHPC |  | 2
SAIL |  | 2
UCOBANK |  | 2
ACC | 1
[NAME] |  | 1
APOLLOHOSP |  | 1
BATAINDIA |  | 1
CEATLTD | 1
CENTURYTEX |  | 1
COLPAL | 1
ENGINERSIN |  | 1
FEDERALBNK |  | 1
IDFC | 1
IOC | 1
JPASSOCIAT |  | 1
KTKBANK |  | 1
MOTHERSUMI | 1
PCJEWELLER |  | 1
PIDILITIND | 1
PTC |  | 1
SIEMENS | 1
SOUTHBANK |  | 1
STAR |  | 1
TATACHEM | 1
TV18BRDCST |  | 1
TVSMOTOR | 1
ABIRLANUVO
BEML
CANBK
DIVISLAB
EICHERMOT
[NAME]
GMRINFRA
GODREJIND
GRASIM
HINDZINC
INDIACEM
IOB
JSWENERGY
MARICO
MCDOWELL-N
RCOM
TATAELXSI
TORNTPHARM
Spreadsheet: 816731d1675795408-how-to-use-lookup-get-multiple-results-and-add-the-results-to-a-single-cell-textjoin-pd-sample
Sheet: OT

PSID | Rcd | Name | Earn ID | PP | Fund | Dept | S/C | Acct | Monthly Base | Shift | Stipend | Total Monthly Pay | Enhanced OT Rate | Hours | Amount Due
 |  | BEST, R | OTPR | 2023-01-01 00:00:00 | 90000 | 43425 | 0 | 601933 |  | 445.1 |  |  |  | 6
 |  | CALDERA, M | OTPR | 2023-01-01 00:00:00 | 90000 | 43425 | 0 | 601933 |  | 5.4 |  |  |  | 6
 |  | CALDERA, M | OTPR | 2023-01-01 00:00:00 | 48541 | 43425 | 0 | 601933 |  | 5.4 |  |  |  | 4