tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772152d1647022062-assign-points-in-a-calendar-2022-hourly-calendars-test
Sheet: Data

Employee Name | FILE# | Occur Date | Points | CODE | Comments |  |  |  |  |  |  |  | Employee 1
Employee 1 | 1636 | 2022-01-08 00:00:00 | 1 | ED-1 |  |  |  |  |  |  |  |  | Employee 2
Employee 1 | 1636 | 2022-01-19 00:00:00 | 0.25 | LA-0.25 |  |  |  |  |  |  |  |  | Employee 3
Employee 2 | 2624 | 2022-01-02 00:00:00 | 0.25 | LA-0.25
Employee 2 | 2624 | 2022-01-24 00:00:00 | 0.33 | A-0.33
Employee 3 | 2483 | 2022-01-13 00:00:00 | 0.33 | LA-0.33
Employee 3 | 2483 | 2022-01-14 00:00:00 | 1 | A-1
Employee 3 | 2483 | 2022-02-05 00:00:00 | 1 | ED-1
Spreadsheet: 03362bed-de48-4ee4-b959-e3e471adfc80
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
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 24. Output of the Professional, scientific and technical services industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  691 Scientific research services ; |  |  | Original | A2314187F | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  692 Architectural, engineering and technical services ; |  |  | Original | A3343916F | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6921  Architectural services ; |  |  | Original | A2314196J | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6922 Surveying and mapping services ; |  |  | Original | A2314199R | 1997-12-01 00:00:00 | 2012-12-01 00:00:00 | 61 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6923 Engineering design and engineering consulting services ; |  |  | Original | [NAME]T | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6924 Other specialised design services ; |  |  | Original | A2314235L | 1998-03-01 00:00:00 | 2012-12-01 00:00:00 | 60 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  693 Legal and accounting services ; |  |  | Original | A2314220W | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6931 Legal services ; |  |  | Original | A2314223C | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6932  Accounting services ; |  |  | Original | A2314226K | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  695 Market research and statistical services ; |  |  | Original | A3343918K | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6962 Management advice and related consulting services ; |  |  | Original | A3343920W | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  697 Veterinary services ; |  |  | Original | A4406512L | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  700 Computer system design and related services ; |  |  | Original | A3343922A | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: vkaminski__40928__656
Sheet: Sheet1

Name | E-Mail | [NAME] | 656 |  | Revised 3/5/01
CHILKINA, Elena | [EMAIL] | 826470
DEMIANENKO, Elena | [EMAIL] | 443441
DIKEMAN, George | [EMAIL] | 716742
GANGUZZA, [NAME] | [EMAIL] | 716646
GAUDETTE, [NAME] | [EMAIL] | 716619
GUO, [NAME] | [EMAIL] | 716862
HAMEL, [NAME] | [EMAIL] | 716732
[NAME], [NAME] | [EMAIL] | 151137
HOWARD, [NAME] | [EMAIL] | 716805
ISRANI, Rakhi | [EMAIL] | 247817
JETT, [NAME] | [EMAIL] | 716733
[NAME], Grant | [EMAIL] | 603370
LAMAS-DIAZ, [NAME] | [EMAIL] | 716833
[NAME] | [EMAIL] | 716622
[NAME] | [EMAIL] | 716901
LITTON, Todd | [EMAIL] | 716648
[NAME], [NAME] | [EMAIL] | 716948
MAUE, [NAME] | [EMAIL] | 716806
NAZARETH, [NAME] | [EMAIL] | 716764
NELSON, [NAME] | [EMAIL] | 717286
PAN, Cuiping | [EMAIL] | 565937
[NAME], Rishad | [EMAIL] | 716954
PLANCK, Jeffery | [EMAIL] | 230232
SMITH, Shauywn | [EMAIL] | 106040
SO, [NAME] | [EMAIL] | 716654
TAYLOR, Orlando | [EMAIL] | 716836
VANSTONE, [NAME] | [EMAIL] | 716726
WANKHADE, Sanjay | [EMAIL] | 716879
WESTMORELAND, [NAME] | [EMAIL] | 603050
WHEELOCK, [NAME] | [EMAIL] | 716526
WU, [NAME] | [EMAIL] | 716817
YOSHIURA, Paulo | [EMAIL] | 716873
ZHANG, Ning | [EMAIL] | 355549
Spreadsheet: geir_solberg__11290__1-03act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 85155d1285209147-excel-2007-auto-import-upon-opening-highcariesdatabase
Sheet: Oct 09

Name | Rank | SSN | Unit | Phone | Acc/Decl | Educate | Pro/OHI | Fluoride Tx | 3-6mo Fl | Fl Overdue | Oper Com | 3-6mo Eval | Eval overdue | Prgrm Com | Date Com | Appt
doe, [NAME] | SSgt | 123456789 | [NAME] | [PHONE] | A | Y | Y | Y | 2010-01-10 00:00:00 | Y | Y | 2010-01-10 00:00:00 | Y |  |  | Y
adams, terry | A1C | 459123456 | 102nd Something | 111-123-111 | D |  |  |  |  |  |  |  |  |  |  | Y
snooky, pam | Col | 11111111 | 123rd work stinks | [PHONE] |  | Y | Y | N | 2010-02-11 00:00:00 | Y |  | 2010-06-10 00:00:00 | Y
smith, [NAME] | [NAME] | 222222222 | 93rd Horse | [PHONE] |  | Y | Y | Y |  | N | Y |  | N | Y | 2010-10-02 00:00:00 | Y
Metrics |  | Total
Total Patients
Accept |  | 1
Declined |  | 1
Fl overdue |  | 2
Assess overdue |  | 2
Appts |  | 3
Completed |  | 1
Spreadsheet: 109452d1306306134-expense-sheet-pulling-out-taxes-junk
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Sales
Tax Rate: | 0.1 | 0.15 | 0.2 | 0.1 | 0.05 | 0.075
Category 1 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Category 2 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000
Category 3 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
Category 4 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000
Category 5 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Tax Calculations
Category 1
Category 2
Category 3
Category 4
Category 5
Ex Tax Values
Category 1
Category 2
Category 3
Category 4
Category 5
Spreadsheet: 481710d1474612610-add-new-data-to-correct-column-481704d1474608619-add-new-data-to-correct-column-sample-1
Sheet: Course Data

xxxx
Course data
Index | Type | Indicator | Full | Code | Full Course Name | Short Course Name | Course Name
1 | AAAA |  |  |  |  |  | Beginner
2 | AAAB |  |  |  |  |  | [NAME]
3 | AAAA |  |  |  |  |  | Expert
4 | AAAB |  |  |  |  |  | Amateur
5 | AAAC |  |  |  |  |  | Professional
6 | AAAC |  |  |  |  |  | Newbie
7 | AAAB |  |  |  |  |  | Beginner
8 | AAAA |  |  |  |  |  | [NAME]
9 | AAAA |  |  |  |  |  | Local
10 | AAAB |  |  |  |  |  | Foreign
11 | AAAC |  |  |  |  |  | Alien
12 | AAAC |  |  |  |  |  | Out There
13 | AAAD |  |  |  |  |  | Beginner
14 | DAAA |  |  |  |  |  | [NAME]
 |  | New Types are created and new courses are added.
 |  | I can formulaically (Index Match) add the new [NAME] to row 8 on tab Validation Data, but how do I add the new Course Names to the correct Type column in Validation data?
Spreadsheet: 60665d1261160539-hide-cells-depend-by-amount-days-in-month-book1
Sheet: Sheet1

CONTACT_NUMBER | OPPORTUNITY_TYPE | QUARTER | CON_TYPE | CONTRACT_TYPE_DESCRIPTION_LINE | CURR_CODE | Comment
379159 | OUTSOURCE | 201002 | C4P | SMARTnet | Onsite | Premium 2x7x4 USD
389859 | OUTSOURCE | 201002 | SNT | SMARTnet | 85xNBD | USD
379159 | OUTSOURCE | 201002 | C4P | SMARTnet | Osite | Premium 4x7x4 USD
388859 | OUTSOURCE | 201002 | SNT | SMARTnet | 85xNBD | USD
388459 | OUTSOURCE | 201002 | SNT | SMARTnet | 85xNBD | USD
388459 | OUTSOURCE | 201002 | SNT | SMARTnet | 85xNBD | USD
Spreadsheet: 761307d1640810299-conditional-formatting-to-change-colour-based-on-percentage-bands-bobs-project-list1
Sheet: Event Planning Tracker

 | EVENT PLANNING - TRACKER
 | Status |  | % Complete
 |  |  | 0.25
 |  |  | 1
 |  |  | 1
 |  |  | 0.5
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0.5
 |  |  | 1
 |  |  | 0.25
 |  |  | 0.25
 |  |  | 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
Spreadsheet: 34699d1232013315-excell-formula-rate-list
Sheet: Sheet1

 | Discount %
 | Rate List
 | Daily | Weekly | Two weeks | Three weeks | Monthly
 | 100 | 200 | 300 | 400 | 500
 | 50 | 60 | 70 | 80 | 90
 | 10 | 20 | 30 | 40 | 50
Spreadsheet: 56091d1256218867-vlookup-with-same-values-what-i-need-is-under-column-mewingarrayhelp
Sheet: 1901

 | 1901-01-01 00:00:00 | 1901-01-02 00:00:00 | 1901-01-03 00:00:00 | 1901-01-04 00:00:00 | 1901-01-05 00:00:00
Mercury
Venus
Mars |  | 120 mars
Jupiter |  |  |  |  | 50 jupiter
Saturn |  |  |  |  | 180 saturn
Uranus
Neptune |  |  |  |  | 75 neptune
Pluto
 |  |  |  | Date | Aspect | Column1
 |  |  |  | 1901-01-01 00:00:00 | 90 mercury
 |  |  |  | 1901-01-02 00:00:00 | 120 mars
 |  |  |  | 1901-01-05 00:00:00 | 50 jupiter
 |  |  |  | 1901-01-05 00:00:00 | 75 neptune
 |  |  |  | 1901-01-05 00:00:00 | 180 saturn
 |  |  |  | what i need is under column F, 01/05/1901, to display Jupiter in F6 and also populate Neptune in F9 and Saturn in F7
Spreadsheet: 68922d1269455059-merge-two-files-merge
Sheet: Sheet1

 |  |  | Table 1 |  |  |  |  |  | Table 2
 |  | Code | Modifier | Amount |  |  | Acct# | Code | Amount | Due
 |  | 51725 |  | 290.18 |  |  | 123 | 51725 | 500 | 500
 |  | 51725 | TC | 209.88
 |  | 51725 | 26 | 80.31
 |  |  |  |  |  | Result wanted
 |  |  |  | Code | Modifier | Amount | Acct | Amount | Due
 |  |  |  | 51725 |  | 290.18 | 123 | 500 | 500
 |  |  |  | 51725 | TC | 209.88 | 123 | 0 | 0
 |  |  |  | 51725 | 26 | 80.31 | 123 | 0 | 0
Spreadsheet: 285525b2-a374-471d-a09f-480466792b48
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 49. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (ACT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413727L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413728R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413729T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413730A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413731C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413732F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413733J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413734K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413735L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413736R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 709234d1608219175-return-1st-column-value-based-combination-lookup-in-2rd-column-book2-18-
Sheet: Sheet1

 |  |  |  | Selections | z1 |  | Result
 |  |  |  |  | z6
id | value
a | z1
a | z2
a | z3
b | z4
b | z3
c | z1
c | z3
c | z4
d | z5
d | z3
d | z4
d | z6
d | z2
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 13d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 99871 | 912736 | 852614 | 27855 | 84965 | 116548
Europe | - | - | 844939 | - | - | 112289
North America/Asia | 99871 | 912736 | 7675 | 27855 | 84965 | 4259
Other | - | - | - | - | - | -
Index | 923073 | 3910415 | 6390850 | 480148 | 1852064 | 1662537
Asia | - | - | 207936 | - | - | 50885
Europe | - | - | 5500440 | - | - | 1464033
North America | 923073 | 3910415 | 182689 | 480148 | 1852064 | 62290
Other | - | - | 499785 | - | - | 85329
OTHER* | - | - | 871526 | - | - | 383388
TOTAL | 1022944 | 4823151 | 8114990 | 508003 | 1937029 | 2162473
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 689839d1596698571-index-and-match-on-multiple-similar-tables-example1804
Sheet: Sheet1

Question 3: Use INDEX and MATCH for looking up a specific table and then within that specific table looking up a value that is at the intersection of a row and column. Need to find out Shipping/Unit on the basis of Region, Shipping Method & Customer Type
 | Customer Type 10
 |  | Shipping Method - Standard |  |  |  |  |  |  | Region
 | Region | Rail | Truck | Plane | Ship |  |  |  | West
 | NW | 0.125 | 0.135 | 1.525 | 0.225 |  |  |  | Shipping Method
 | West | 0.205 | 0.145 | 2.025 | 0.245 |  |  |  | Plane
 | SW | 0.265 | 0.165 | 2.125 | 0.225 |  |  |  | Customer Type
 | MidWest | 0.305 | 0.185 | 2.275 | 0.225 |  |  |  | Customer Type 30
 | East | 0.475 | 0.425 | 3.525 | 0.375 |  |  |  | Shipping per Unit
 | Customer Type 20
 |  | Shipping Method - Preferred
 | Region | Rail | Truck | Plane | Ship
 | NW | 0.115 | 0.125 | 1.375 | 0.205
 | West | 0.185 | 0.135 | 1.825 | 0.215
 | SW | 0.245 | 0.155 | 1.915 | 0.205
 | MidWest | 0.275 | 0.165 | 2.055 | 0.205
 | East | 0.435 | 0.385 | 3.175 | 0.345
 | Customer Type 30
 |  | Shipping Method - Most Preferred
 | Region | Rail | Truck | Plane | Ship
 | NW | 0.105 | 0.115 | 1.245 | 0.175
 | West | 0.175 | 0.125 | 1.645 | 0.165
 | SW | 0.215 | 0.135 | 1.725 | 0.185
 | MidWest | 0.255 | 0.155 | 1.845 | 0.185
 | East | 0.385 | 0.345 | 2.865 | 0.305
Spreadsheet: tracy_geaccone__40311__EREC IC 0907
Sheet: IT Infrastructure Services

 | IT Infrastructure Services
 | Service Category | Service | Service Options | Unit / Available driver
 | Customer Support | Resolution Center |  | # of users
 |  | Desktop support | General | # of general users
 |  |  | Traders | # of trader users
 |  |  | Executive | # of executive users
 |  |  | Remote | # of remote users
 |  | Desktop Hardware Support |  | # of users
 |  | Printer Management Support |  | # [NAME] users
 | Production Operations Services | Production Operations Management |  | # of users
 |  | Enterprise Command Center |  | # of users
 |  | Change & Configuration Management |  | # of users
 |  | [NAME] (Future Service) |  | TBD
 |  | Security Administration |  | # of users
 |  | Data Center Operations |  | % of Total Square Feet Occupied
 |  | IT Security Policy, Monitoring, and Investigation |  | # of users
 |  | Software - Desktop Maintenance & Support |  | Actual Spend
 |  | Software - Server Maintenance & Support |  | Actual Spend
 |  | Application Storage Support |  | % of Total storage costs
 |  | User & Data Volume Support |  | # of users
 |  | Remote Infrastructure Operation & Support |  | % of remote infrastructure support costs
 |  | Remote Trading Management |  | % of remote trading infrastructure support costs
 |  | UNIX Application Infrastructure |  | # of UNIX servers used
 |  | General UNIX Infrastructure |  | # of users
 |  | NT Application Infrastructure |  | # of NT servers used
 |  | General NT Infrastructure |  | # of users
 |  | Remedy |  | # of users
 |  | Email Administration |  | # of users
 |  | Market Data Admin. Support |  | % of Actual Usage
 |  | Market Data Feeds |  | % of Actual Usage
 |  | Disk Space Allocations (E-mail) |  | # of Stored Megabytes
 |  | Messaging Operations (Exchange) |  | # of users
 |  | Web Operations |  | # of users
 |  | Terminal Server Operations |  | # of users
 |  | Distributed Applications Management |  | # of users
 |  | EDI |  | % of Usage of 1000 characters
 | Data Communications Support | LAN Support |  | # of users
 |  | [NAME] |  | # of users
 |  | DMZ Security |  | # of users
 |  | 24x7 Support |  | # of users
 | Voice Communications Support | Telephony support |  | # of users
 |  | Communication Trading Support |  | #of Traders
 |  | Long Distance |  | % of Total Usage
 |  | 800 (Inbound) |  | % of Total Usage
 |  | Calling Card |  | % of Total Usage
 |  | Audio Conferencing |  | % of Total Usage
 |  | Video Conferencing |  | # of video hrs
 |  | Internet Access |  | # of users
 |  | EOL Internet Access |  | # of users
 |  | ETS - Omaha Internet Access |  | # of users
 |  | MAN |  | # of Houston users
 |  | Remote Access (dial/VPN) |  | # of users
 |  | [NAME] |  | % of Total Usage
 |  | Voice Circuit |  | # of users
 |  | [NAME] |  | % of Total Usage
 |  | Communications - Churns |  | Usage per Churn
 | Special Services Support | Business Administration Project Management |  | # of users
 |  | Technical Architecture Oversight |  | # of users
Spreadsheet: 199414d1355212303-creation-of-interconnected-drop-down-lists-using-data-validation-list_validation_workfile
Sheet: Sheet1

 |  |  | Source Data
 |  | STATE | DISTRICT | CITY
 |  | State 1 | District 1 | City 1
 |  |  |  | City 2
 |  |  |  | City 3 |  |  | Select State | state 2
 |  |  | District 2 | City 4 |  |  | Select District
 |  |  |  | City 5 |  |  | Select City
 |  |  |  | City 6
 |  |  | District 3 | City 7
 |  |  |  | City 8
 |  |  |  | City 9
 |  |  | District 4 | City 10
 |  |  |  | City 11
 |  |  |  | City 12
 |  |  | District 5 | City 13
 |  |  |  | City 14
 |  |  |  | City 15
 |  | State 2 | District 6 | City 16
 |  |  |  | City 17
 |  |  |  | City 18
 |  |  | District 7 | City 19
 |  |  |  | City 20
 |  |  |  | City 21
 |  |  | District 8 | City 22
 |  |  |  | City 23
 |  |  |  | City 24
 |  |  | District 9 | City 25
 |  |  |  | City 26
 |  |  |  | City 27
 |  |  | District 10 | City 28
 |  |  |  | City 29
 |  |  |  | City 30
Spreadsheet: 139824d1328489073-excel-2007-totalling-selected-cells-qtr_summary
Sheet: Summary

 |  | Enter an Year | 2011
 |  | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Total
 | Distance travelled | 4681 | 16119 | 14266 | 16904 | 51970
 | Gross Takings | 8320.400000000052 | 27900.15000000001 | 25654.69999999998 | 31316.99999999999 | 93192.25000000003
 | Commission | 3390.562999999995 | 11369.311125 | 10518.42900000001 | 12839.97 | 38118.27312500001
 | Accounts and EFT | 1595.300000000003 | 6705.900000000005 | 6016.899999999992 | 7912.800000000005 | 22230.90000000001
 | Cash Takings | 6725.10000000002 | 21194.25000000001 | 19637.8 | 23404.2 | 70961.35000000003
 | GST Component | 308.2329999999997 | 1033.573738636364 | 956.2208181818187 | 1167.27 | 3465.297556818183
 | D W allow | 40 | 60 | 100 | 70 | 270
 | Total Expenses | 5025.863000000027 | 18135.211125 | 16635.32899999999 | 20822.77 | 60619.17312500001
 | Net Pay In | 3294.537000000026 | 9764.938875 | 9019.370999999992 | 10494.23 | 32573.07687500002
 | Net Earnings | 3122.329999999994 | 10395.73738636366 | 9662.208181818192 | 11742.7 | 34922.97556818184
 | Hours worked | 173.5 | 586.0500000000009 | 522.16 | 587.4499999999999 | 1869.160000000001
 | My Income per hr | 286.3526852606851 | 984.0124711710423 | 923.6517020527801 | 1142.961151013752 | 3336.97800949826
 | Income per km | 28.54982519739292 | 96.17706358563456 | 90.74638030256847 | 108.8915673341843 | 324.3648364197802
 | Total | 36991.7285104582 | 124344.3117847567 | 114003.5160823553 | 138514.242718348 | 413853.7990959181
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: Amoco Abo

 | [NAME]
Day | Measured | Scheduled | Imbal
1 | 12775 | 10600
2 | 13246 | 10600
3 | 13132 | 10600
4 | 12791 | 10600
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  | 1002068.76
2001-02-04 00:00:00
Spreadsheet: 216717d1361864185-drop-down-data-validation-cell-from-multiple-sources-temp
Sheet: Sheet1

 | Source 1 |  | Source 2 |  | Drop Down List
 | a |  | ab
 | b |  | cd
 | c |  | ef
 | d |  | gh
 | e |  | ij
 | f |  | kl
 | g |  | mn
 | h |  | op
 | i |  | qr
 | j |  | st
Spreadsheet: 865065d1712149719-how-to-merge-2-columns-example-for-merging-data
Sheet: Sheet1

A | B | [NAME]
Microsoft | microsoft.com | microsoft.com
Apple |  | Apple
Dell |  | Dell
 | lenovo.com | lenovo.com
Nvidia |  | Nvidia
 | openai.com | openai.com
Google | google.com | google.com
Facebook | facebook.com | facebook.com
Spreadsheet: 80edf7ca-46b3-4287-8c89-65621ee5ab8b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
OPEN DIVISION CIF-SS/FORD 2014 BOYS BASKETBALL CHAMPIONSHIPS
 | FINALS | SEMIFINALS | QUARTERFINALS | 1ST ROUND | QUARTERFINALS | SEMIFINALS | FINALS
 | FRIDAY | TUES., MAR. 4 | FRI., FEB. 28 | FRI., FEB. 21 | FRI., FEB. 28 | TUES., MAR. 4 | SATURDAY
 | [NAME] 7 | 7:00 P.M. | 7:00 P.M. | 7:00 P.M. | 7:00 p.m. | 7:00 p.m. | [NAME] 8
 |  |  |  |  |  |  | HONDA CENTER
 |  |  |  | *[NAME] (1) - Trinity #1
 |  |  | *Cantwell SH |  | [NAME]
 |  |  | 59 | [NAME] (16) - Camino Real #2 | 66 (OT)
 |  | *Chaminade | @ Whittier HS |  |  | *[NAME]
 |  | 53-34 | F | *Mayfair (8) - Suburban #1 |  | 77-59 | PLEASE REPORT SCORES TO:
 |  |  |  |  |  |  | www.cifsshome.org
 |  |  | Chaminade |  | *Mayfair |  | Home Campus
 |  |  | 64 | Chaminade (9) - Mission #2 | 72
 | *Sierra Canyon |  |  |  |  |  | [NAME]
 | 52-47 |  |  | *Sierra Canyon (5) - Alpha #1 |  | F | 62-49
 |  |  | Sierra Canyon |  | *J.W. North
 |  |  | 56 | North J.W. (12) - Inland Valley #1 | 65
 |  | Sierra Canyon |  |  |  | [NAME]
 |  | 53-45 |  | *Centennial/Corona (4) - Big VIII #1 |  | 78-76
 |  |  | *Serra |  | Centennial/Cor
 |  |  | 61 | Serra (13) - Del Rey #2 | 71
 |  |  |  |  |  |  | Saturday, March 8 - 6:30 p.m. - Honda Center
 |  |  |  | *Loyola (3) - Mission #1
 | CONSOLATION |  |  |  |  |  | CHAMPION
 | CHAMPION |  | St. [NAME] |  | Loyola
 |  |  | 67 | St. [NAME] (14) - Trinity #2 | 70
 |  | St. [NAME] | F |  | F | Redondo Union
 |  | 58-52 |  | *Redondo Union (6) - Bay #1 |  | 65-54
 |  |  | *Compton |  | *Redondo Union
 |  |  | 56 | [NAME] (11) - Moore #2 | 65
 | Bishop
 | Montgomery |  |  |  |  |  | [NAME]
 | 64-63 | F |  | *[NAME] (7) - Sierra #1 |  |  | 70-61
 |  |  | Bish Montgomery |  | [NAME]
 |  |  | 58 | [NAME] (10) - Del Rey #1 | 69
 |  | *Bishop
 |  | Montgomery | F |  | F | *[NAME]
 |  | 71-59 |  | *[NAME] (2) - Baseline #1 |  | 59-48
 |  |  | *Cathedral |  | *Etiwanda
 |  |  | 45 | Cathedral (15) - Camino Real #1 | 55
 | *Denotes Host Team
 | 2014 BOYS BASKETBALL OPEN DIVISION