tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815813d1675215368-consolidating-data-eye-exams
Sheet: Sheet1

EXAM
NAME | OTHER* | KIDS | STUDENTS | ADULTS | SENIORS | PRICE
 | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  | X
 |  |  |  |  | X
 |  |  |  |  | X
 |  |  |  | X
 |  |  |  | X
Spreadsheet: 781462d1653351243-returning-all-values-that-mett-criteria-property-inspection-form-address-a-v4-test
Sheet: Sheet2

Report for C |  |  | Report for R
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room |  |  | Room
Item |  |  | Item
Comment |  |  | Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Room
Item
Comment
Spreadsheet: 771359d1646644169-count-average-only-if-specific-cells-not-blank-excel_average_example
Sheet: Sheet2

 | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9
[NAME] | 1 | 2 | 3 | 4 |  | 6 | 7 |  | 9
[NAME] | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
silvia | 12 | 10 | 8 | 6 | 4 | 2 | 3 | 5 | 7
[NAME] | 12 | 14 | 16 | 18 | 20 | 19 | 17 | 15 | 13
Spreadsheet: 108520d1305578111-sumifs-help-test-file
Sheet: Sheet2

 | Jan | Feb | Mar | Apr
Investment Dossier | 0 | 949840 | 949840
Third Party Project Budget | 0 | 0 | 0
Regulatory Reference | 0 | 0 | 0
Last Purchase | 0 | 0 | 3083.52668213457
No valid reference available | 0 | 0 | 2648
Combined
Spreadsheet: 275370d1383490747-nested-if-function-e09m2june_jriley
Sheet: Tulsa

OKC - June Temperatures
In °F
Tulsa
Date | High | Low
2013-06-01 00:00:00 | 89 | 70
2013-06-02 00:00:00 | 82 | 67
2013-06-03 00:00:00 | 72 | 58
2013-06-04 00:00:00 | 80 | 53
2013-06-05 00:00:00 | 84 | 56
2013-06-06 00:00:00 | 87 | 69
2013-06-07 00:00:00 | 93 | 73
2013-06-08 00:00:00 | 87 | 67
2013-06-09 00:00:00 | 91 | 71
2013-06-10 00:00:00 | 90 | 66
2013-06-11 00:00:00 | 86 | 64
2013-06-12 00:00:00 | 85 | 63
2013-06-13 00:00:00 | 89 | 68
2013-06-14 00:00:00 | 83 | 70
2013-06-15 00:00:00 | 93 | 75
2013-06-16 00:00:00 | 94 | 70
2013-06-17 00:00:00 | 94 | 73
2013-06-18 00:00:00 | 94 | 78
2013-06-19 00:00:00 | 94 | 80
2013-06-20 00:00:00 | 94 | 77
2013-06-21 00:00:00 | 96 | 80
2013-06-22 00:00:00 | 99 | 79
2013-06-23 00:00:00 | 100 | 78
2013-06-24 00:00:00 | 101 | 76
2013-06-25 00:00:00 | 101 | 75
2013-06-26 00:00:00 | 101 | 76
2013-06-27 00:00:00 | 101 | 75
2013-06-28 00:00:00 | 94 | 70
2013-06-29 00:00:00 | 96 | 67
2013-06-30 00:00:00 | 99 | 75
Monthly Records
High/Low
Date
Spreadsheet: 767047d1644254203-how-to-lookup-multiple-values-1-criteria-sample
Sheet: Sheet1

 | Contract # | Months Due | Contract # | Month Due
 | 1 |  | 1 | March
 | 2 |  | 2 | January
 | 3 |  | 2 | April
 | 4 |  | 3 | February
 |  |  | 1 | June
 |  |  | 4 | March
 |  |  | 4 | May
 |  |  | 2 | July
 |  |  | 3 | April
 |  |  | 3 | July
 |  |  | 3 | September
 |  |  | 2 | September
 |  |  | 4 | August
 |  |  | 4 | November
Spreadsheet: 816039d1675331479-convert-barcode-to-another-barcode-within-specified-conditions-barcode-reformat
Sheet: Sheet1

95019-07-09 |  |  | 01 | [NAME]
 |  |  | 02 | XS
 |  |  | 03 | S
 |  |  | 04 | M
 |  |  | 05 | L
 |  |  | 06 | XL
 |  |  | 07 | XXL
 |  |  | 08 | XXXL
 |  |  | 09 | XXXX
 |  |  | 10 | XXXXXL
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T7

الجدول 7: السكان في العراق بحسب [NAME] تعداد 1997
Table 7: Population of Iraq by age groups, 1997 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | … | … | … | … | 1218197 | 1188647 | 693650 | 678488 | 1911847 | 1867135 | 3778982
5-9 | … | … | … | … | 1124600 | 1087118 | 567526 | 544208 | 1692126 | 1631326 | 3323452
10-14 | … | … | … | … | 955442 | 918804 | 469604 | 448068 | 1425046 | 1366872 | 2791918
15-19 | … | … | … | … | 883604 | 846938 | 409832 | 399830 | 1293436 | 1246768 | 2540204
20-24 | … | … | … | … | 713054 | 706362 | 306213 | 322115 | 1019267 | 1028477 | 2047744
25-29 | … | … | … | … | 591288 | 606625 | 258096 | 268456 | 849384 | 875081 | 1724465
30-34 | … | … | … | … | 499004 | 509079 | 181806 | 201197 | 680810 | 710276 | 1391086
35-39 | … | … | … | … | 327146 | 359495 | 86760 | 126752 | 413906 | 486247 | 900153
40-44 | … | … | … | … | 316790 | 323836 | 112632 | 130766 | 429422 | 454602 | 884024
45-49 | … | … | … | … | 239218 | 244225 | 88217 | 106065 | 327435 | 350290 | 677725
50-54 | … | … | … | … | 197065 | 184976 | 66790 | 71642 | 263855 | 256618 | 520473
55-59 | … | … | … | … | 162203 | 153921 | 52862 | 55215 | 215065 | 209136 | 424201
60-64 | … | … | … | … | 99247 | 113184 | 35597 | 43538 | 134844 | 156722 | 291566
65-69 | … | … | … | … | 86028 | 103180 | 37398 | 43858 | 123426 | 147038 | 270464
70-74 | … | … | … | … | 53298 | 75045 | 28715 | 36055 | 82013 | 111100 | 193113
75+ | … | … | … | … | 76326 | 105103 | 49043 | 56202 | 125369 | 161305 | 286674
غير محدد    Not stated | … | … | … | … | … | … | … | … | … | … | …
المجموع    Total | ... | ... | ... | ... | 7542510 | 7526538 | 3444741 | 3532455 | 10987251 | 11058993 | 22046244
Spreadsheet: c609d134-5cd3-4493-9945-e7fde236b178
Sheet: Sheet1

Unnamed: 0 | [NAME]  rajona  13. atklātais  čempionāts  telpu  lidmodeļiem | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  | PEANUT  modeļu  klase
 | 28.01.2012. | Jaunākā  grupa |  |  |  |  |  |  | Rubene
N. |  |  |  |  |  |  |  |  |  |  | 2
p. |  |  | Skola, | St. |  | Lidojuma   [NAME] |  |  |  |  | lidoj. | [NAME] | Vie-
k. | Vārds,  uzvārds | [NAME] | int. izgl. iest. | summa | 1 | 2 | 3 | 4 | 5 | 6 | summa | tāts | ta
1 | Kristaps Skrastiņš | [NAME] | VJC "Vinda" | 38.5 | 00:26:00 | 00:33:00 | 00:32:00 | 00:36:00 | [NAME] | 00:34:00 | 71 | 269.5 | 1
5 | Vladislavs Saiko | [NAME] | RJTC | 34 | 00:20:00 | 00:17:00 | 00:18:00 | 00:20:00 | 00:32:00 | 00:00:00 | 52 | 170 | 2
6 | Vladislavs Saiko | Pilatus PC-6 porter | RJTC | 26 | [NAME] | 00:33:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 42 | 104 | 3
3 | Nikita Sidorenkovs | Pilatus | RJTC | 21 | 00:17:00 | 00:05:00 | [NAME] | 00:12:00 | 00:05:00 | [NAME] | 29 | 42 | 4
4 | Igors [NAME] | Pilatus | RJTC | 27 | 00:06:00 | 00:03:00 | 00:05:00 | 00:03:00 | 00:05:00 | 00:00:00 | 11 | 27 | 5
2 | [NAME] | Pilatus | RJTC | 22 | 00:05:00 | [NAME] | 00:03:00 | 00:06:00 | 00:05:00 | 00:12:00 | 18 | 22 | 6
 |  |  | Vecākā  grupa
4 | [NAME] | Pilatus | RJTC | 27 | 00:13:00 | 00:12:00 | 00:27:00 | 00:18:00 | [NAME] | 00:28:00 | 55 | 135 | 1
1 | [NAME] | ITOH | VJC "Vinda" | 39 | 00:17:00 | 00:14:00 | 00:12:00 | 00:00:00 | 00:00:00 | 00:00:00 | 31 | 117 | 2
2 | [NAME] | Mig-3 | RJTC | 54 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 0 | 54 | 3
3 | [NAME] | PIPER | VJC "Vinda" | 40 | 00:05:00 | [NAME] | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 40 | 4
Spreadsheet: 217516d1362087350-sort-formula-allow-for-duplicates-excel-array-sort-problem-2
Sheet: Sheet1

 | a | 100
 | b | 400
 | a | 200
 | c | 600
 | a | 300
 | b | 500
 | a | 100
 | b | 400
 | a | 200
 | c | 600
 | a | 300
 | b | 500
Spreadsheet: eric_saibi__9944__110101R
Sheet: Zimmer A

Owner Name |  | Cinergy Corporation
Station Name |  | [NAME] Power Station
Unit Name |  | Zimmer A High Pressure
NERC Region |  | ECAR
State |  | OH
Fuel Type |  | Coal
Capacity |  | 900 MW
Start Date |  | 2001-10-31 00:00:00
End Date |  | 2001-10-31 00:00:00
Prv. Start Date |  | 2001-10-31 00:00:00
Prv. End Date |  | 2001-11-01 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1009921
Unit ID |  | 1003896
Outage ID |  | 18773
Spreadsheet: joe_parks__14949__BridgeDPR0426
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1912.136574600001 | 1912.136574600001 | 7203.136574600001
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1912.136574600001 | 1912.136574600001 | 7203.136574600001
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 82363d1282371018-look-up-the-part-code-having-end-with-desired-character-1234
Sheet: CNDDRSCCR

 |  |  | 12391-GW8-6810C
 |  |  | 91302-KEV-9000C
Part Code | Part name
12301-GB6-9000 | COVER CYLINDER HEAD
12331-GB0-9100 | COVER R CYLINDER HEAD SIDE
12341-GB6-9100 | COVER L CYLINDER HEAD SIDE
[PHONE] | HOLE CAP TAPPET ADJUSTING
12391-GW8-6810C | GASKET CYL HEAD COVER
12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER
98056-57718-01 | SPARK PLUG
90201-GF6-0000 | NUT CAP 7MM
90442-GF6-0000 | WASHER SEALING 7 MM
90443-GF6-0000 | WASHER A SEALING 7 MM
[PHONE] | WASHER SEALING 12 MM
91302-KEV-9000C | O-RING 30.8X3
95701-06110-00 | BOLT FLANGE 6X110
96001-06020-00 | BOLT FLANGE SH.6X20
12191-KRS-C100 | GASKET CYLINDER
90701-GF6-0000 | PIN DOWEL SPECIAL 8X14
Spreadsheet: 36434d1234311496-hourly-census-formula-census-1-
Sheet: Volume

Day | Date | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00
Thu | 2009-02-05 00:00:00 | 2 | 7 | 12 | 16 | 26 | 31 | 35 | 30 | 29 | 31 | 30 | 27 | 26 | 26 | 26 | 24 | 27 | 2 | 2 | 1 | 0 | 0 | 0 | 1
Fri | 2009-02-06 00:00:00 | 6 | 12 | 13 | 16 | 22 | 22 | 26 | 29 | 27 | 25 | 26 | 25 | 27 | 32 | 32 | 36 | 27 | 22 | 10 | 9 | 8 | 4 | 2 | 2
Spreadsheet: tracy_geaccone__40323__3rd quarter curr est
Sheet: CashCorpCE

DETAIL OF CHANGE IN CASH FROM CORPORATE
(Millions of Dollars)
 |  |  |  |  | 2001
 |  |  |  |  | 3rd CE |  | 2nd CE |  | [NAME]
Cash from Corporate Information
 | Net Income After Financing Costs |  |  |  |  |  | 90.51170331657842
 | Price Risk Management Activities |  |  |  |  |  | 18.2
 | Other Non-Cash Items |  |  |  |  |  | 101.9941598702856 |  |  | (1)
 | Net (Gain) / Loss from Sale of Assets |  |  |  |  |  | 8.367
 | Net Production Payments |  |  |  | 0 |  | 0
 | Equity Earnings |  |  |  | 0 |  | 0
 | Equity Distributions |  |  |  | 0 |  | 0
 | Working Capital Changes |  |  |  |  |  | -244.684028448232
 | Proceeds from Sale of Assets |  |  |  |  |  | 26.7 |  |  | (2)
 | Capital Expenditures |  |  |  |  |  | -219.9527380952381
 | Dividends to EPC |  |  |  |  |  |  |  |  | (3)
 | Change in Third Party Debt |  |  |  |  |  | 279.6473536586332
 | Other Cash Changes |  |  |  |  |  |  |  |  | (4)
 |  | (Increase) / Decrease in Cash From Corporate
Cash From Corporate Variance Analysis
Please explain variances.
(1) |  | 3rd current estimate includes PCA adjusment of ($86.0) mm, 2nd current estimate include PCA of ($94.7) [NAME]
(2) |  | Sale of Pelton Round Butte, to be booked as accounts receivable.
(3) |  | 3rd and 4th quarter dividends reflected as loan to Corp.
(4) |  | COLI losses  $12.5 mm
Spreadsheet: 91802d1291467073-auto-fill-columns-b-c-d-based-on-column-data-of-a-master-list-in-a-2nd-sheet-price-list
Sheet: Input Sheet

No | Quantity | Model No | Description | Unit Price | Price
2 | 5
4 | 3
1 | 80
 |  |  |  | Total:
 |  | =IF($A2="","",VLOOKUP($A2,PriceList,COLUMN()-1,FALSE))
 |  | (in cells C2 to E14)
 |  |  |  |  | =IF(B2="","",B2*E2)
 |  |  |  |  | (in cells F2 to F14)
Data Validation in cells A2 to A14 |  |  |  | List: PartNumber
Data Validation in cells B2 to B14 |  |  |  | Whole Number: 1 to 1000
And protect sheet: blank password
Spreadsheet: 63c708b2-8347-4ce1-b78e-72be030f521e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CENTA | Test | CENTA | Centromere Antibodies, Serum | Centromere Antibodies, S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 1.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.350 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative (titer of <1:40) Positives will be titered. | Monday through Friday, Sunday 3rd shift | 1 day /2 days if positive | 4 days | 1 | 86255 |  |  |  |  | New England
CENTA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CENTA | Result | 11216 | Anti-Centromere Antibody | Anti-Centromere Antibody | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16570-4 | Centromere Ab:ACnc:Pt:Ser:[NAME]:IF
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5471 | 5741 | 1041 | 1125 | 1062 | 872 | 1490 | 1123
2 | 5369 | 5741 | 815 | 1125 | 1031 | 872 | 1504 | 1123
3 | 5302 | 5741 | 762 | 1125 | 986 | 872 | 1644 | 1123
4 | 3429 | 5741 | 400 | 1125 | 953 | 872 | 1516 | 1123
5 | 5207 | 5741 |  | 1125 | 927 | 872 | 1465 | 1123
6 | 5669 | 5741 | 358 | 1125 | 921 | 872 | 1438 | 1123
7 | 6151 | 5741 |  | 1125 | 821 | 872 | 1413 | 1123
8 | 6148 | 5741 | 678 | 1125 | 1002 | 872 | 1398 | 1123
9 | 5873 | 5741 | 803 | 1125 | 979 | 872 | 1695 | 1123
10 | 5548 | 5741 | 1069 | 1124 | 985 | 872 | 1531 | 1123
11 | 5525 | 5741 | 1322 | 125 | 994 | 872 | 1481 | 1123
12 | 5676 | 5741 | 1071 | 125 | 969 | 872 | 1439 | 1123
13 | 5786 | 5741 | 746 | 125 | 983 | 872 | 1427 | 1123
14 | 6107 | 5741 | 962 | 125 | 617 | 872 | 1418 | 1123
15 | 6068 | 5741 | 777 | 125 | 811 | 872 | 1663 | 1123
16 | 6099 | 5741 | 484 | 95 | 1066 | 662 | 1472 | 1123
17 | 5842 | 4241 | 584 | 125 | 1015 | 872 | 1444 | 1123
18 | 5631 | 4241 | 401 | 125 | 1000 | 872 | 1409 | 1123
19 | 5880 | 4241 | 494 | 125 | 985 | 872 | 1397 | 1123
20 | 5162 | 4241 | 540 | 125 | 986 | 872 | 1373 | 1123
21 | 3353 | 4241 | 424 | 125 | 946 | 872 | 1650 | 1123
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 406899.92
2002-01-21 00:00:00
CBS Volume
 |  |  | 166968
Spreadsheet: 34052d1231170765-generate-statement-with-cell-values-sample
Sheet: Sheet2

Master [NAME] |  |  | Vlookup |  |  | Tax to Find
Firm | Tax |  | Firm | Tax |  | Firm | Tax
AAA | 10 |  | AAA | 10
BBB | 30 |  | BBB | 30
CCC | 15 |  | CCC | 15
 |  |  | ZZZ | #N/A
 |  |  | DDD | #N/A
 |  |  |  |  |  | * I wan in the "Tax To Find" to display firm without tax info in master copy ,
 |  |  |  |  |  | eg. In this case , it should display ZZZ , DDD . Den I need to go find the tax bracket
Spreadsheet: 826765d1682255452-help-with-lookup-function-table-example
Sheet: Sheet3

Row | Difference | Tree | Expected | Cherry 14.12.22 | Return value
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
Spreadsheet: 35843d1233582468-excel-2007-budgeting-question-post
Sheet: Sheet1

 | budget | Per Pay Period | Year to Date
tithing | 0.1 | 105.986 | 105.986
savings | 0.5 | 529.93 | 529.93 |  | [NAME]
living | 0.4 | 423.944 | 423.944 |  | 17
 |  | 1059.86
Pay Period | hours | wages | milage | pre tax | tax | total pay
1-10 to 1-23 | 74.5 | 1266.5 | 100 | 1366.5 | 306.64 | 1059.86
Total | 74.5 | 1266.5 | 100 | 1366.5 | 306.64 | 1059.86
Spreadsheet: 480691d1474029337-formula-for-see-data-excel-formula
Sheet: Main

 |  |  |  |  | September
 |  |  |  |  | Names | Location | Grade | Level | Date
 |  |  |  |  |  | C Road | C | 2 | 2016-09-20 00:00:00
 |  |  |  |  |  | D Road | D | 2 | 2016-09-20 00:00:00
 |  |  |  |  |  | B Road | B | 2 | 2016-09-20 00:00:00
 |  |  |  |  | Looking for a formula for automate my sheet.
 |  |  |  |  | This is a temporary file given for example. In this file In Main sheet If I select Particular month then below table data should be change automatically.
 |  |  |  |  | this data should be pulled from Data sheet. All data should be pulled for particular months
 |  |  |  |  | In Data sheet every month data will be added, So kindly help how can do this.
Spreadsheet: 224541d1364601000-how-can-i-search-one-tab-against-information-from-another-tab-subtest
Sheet: Retained Experts

[NAME] | [NAME]
Hale | [NAME]
Spreadsheet: 693114d1598782596-running-count-of-ref-codes-across-all-sheets-of-monthly-data-book2
Sheet: Sheet1

Running Count of Codes | ref Code
 | A1
 | A2
 | A3
 | A1
 | A2
 | A4
 | A6
 | B1
 | A4
Spreadsheet: 736525d1623696678-ratios-in-excel-ratios
Sheet: Sheet1

 |  | Students | Managers | Grand Total |  | GCD | #1 | #2 | Ratio
 | Department 1 | 1826.639999999999 | 566.33 | 2392.969999999999
 | Department 2 | 181.86 | 128.9 | 310.76
 | Department 3 | 494.24 | 124.33 | 618.5699999999999
 | Department 4 | 1676.719999999995 | 245.68 | 1922.399999999995
 | Department 5 | 239.39 | 95 | 334.39
 | Department 6 | 296.11 | 146.16 | 442.27
 | Grand Total | 4714.959999999994 | 1306.4 | 6021.359999999995
 | I need the ratio of students to managers in each department |  |  |  |  | Trying to get the ratios in column J to show  more simply i.e.  1:5 or 16:9
Spreadsheet: 178141d1346675610-hide-data-skate1991-example
Sheet: Sheet1

Month | Company | Client | Revenue(£) | Supplier Cost | Margin | Margin %
January |  | Client 1 | 47.5 | 117.9 |  |  | Total January 2012 | 39709.67 | 34355.89 | 5353.78 | 0.1348230796176347
January |  | Client 2 | 127.5 | 129.2
January |  | Client 3 | 21.05000000000001 | 399.5
January |  | Client 4 | 255 | 276.3
January |  | Client 5 | 1692.5 | 3051.2
January |  | Client 6 | 175 | 305.25
January |  | Client 7 | 403.75 | 464.2
January |  | Client 8 | 480 | 513.65
January |  | Client 9 | 2572.5 | 3637.5
January |  | Client 10 | 2302.5 | 2332.53
January |  | Client 11 | 630 | 1269.75
January |  | Client 12 | 71.25 | 124.9
February |  | Client 1 | 340 | 1134.2 |  |  | Total February 2012 | 42899.2 | 40665.41000000002 | 2233.79 | 0.05207066798448407
February |  | Client 2 | 67.5 | 101.2
February |  | Client 3 | 230 | 330
February |  | Client 4 | 71.25 | 139.5
February |  | Client 5 | 1335 | 2442
February |  | Client 6 | 1710 | 3428.2
February |  | Client 7 | 586 | 880.5
February |  | Client 8 | 67.5 | 120
February |  | Client 9 | 237.5 | 316.4
February |  | Client 10 | 350 | 406.2
February |  | Client 11 | 2900 | 4164.2
February |  | Client 12 | 47.5 | 80
February |  | Client 13 | 1155 | 1705.77
February |  | Client 14 | 127.5 | 151.55
February |  | Client 15 | 90 | 104.4
March |  | Client 1 | 242.5 | 322.9 |  |  | Total March 2012 | 42261.59 | 35796.57 | 6465.02 | 0.1502
March |  | Client 2 | 451.25 | 590.2
March |  | Client 3 | 213.75 | 351.4
March |  | Client 4 | 641.25 | 847.6
March |  | Client 5 | 2870 | 2889.95
March |  | Client 6 | 2131.5 | 3277.95
March |  | Client 7 | 71.25 | 105
March |  | Client 8 | 1477 | 1502.35
March |  | Client 9 | 2950 | 3927.5
March |  | Client 10 | 303.04 | 458.92
March |  | Client 11 | 1210 | 2283
March |  | Client 12 | 712.5 | 750.83
Total
Spreadsheet: john_griffith__15765__10_18_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | EXP |  |  | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 21.5 | 265 | 275 | 57 | 59.1 | 0.78 | 2001-10-18 11:08:00
 | CL F2 | 21.5 | 363 | 375 | 54 | 55.7 | 0.74 | 2001-10-18 11:08:00
 | CL G2 | 22 | 425 | 435 | 49.3 | 50.5 | 0.69 | 2001-10-18 11:08:00
 | CL H2 | 22 | 465 | 475 | 47.1 | 48.2 | 0.66 | 2001-10-18 11:08:00
 | CL J2 | 22 | 485 | 500 | 44.2 | 45.6 | 0.62 | 2001-10-18 11:08:00
 | CL K2 | 22 | 505 | 525 | 41.9 | 43.5 | 0.59 | 2001-10-18 11:08:00
 | CL M2 | 22 | 525 | 535 | 40.6 | 41.3 | 0.57 | 2001-10-18 11:08:00
 | CL N2 | 22 | 525 | 540 | 37.9 | 39 | 0.53 | 2001-10-18 11:08:00
 | CL Q2 | 22 | 525 | 545 | 35.9 | 37.3 | 0.51 | 2001-10-18 11:08:00
 | CL U2 | 22 | 525 | 550 | 34.3 | 35.9 | 0.49 | 2001-10-18 11:08:00
 | [NAME] | 22 | 535 | 555 | 33.3 | 34.5 | 0.47 | 2001-10-18 11:08:00
 | [NAME] | 21.5 | 535 | 560 | 31.7 | 33.2 | 0.44 | 2001-10-18 11:08:00
 | CL M3 | 21.5 | 535 | 570 | 26.9 | 28.7 | 0.38 | 2001-10-18 11:08:00
 | CL Z3 | 21.5 | 535 | 570 | 24.1 | 25.6 | 0.34 | 2001-10-18 11:08:00