tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715735d1611846581-help-reducing-the-amount-of-formulas-to-show-the-sum-attendance-sample-for-excel-help
Sheet: Annual Employee Report

Change the employee | à | Employee
 |  | Jones, [NAME]
Enter the rolling start date | à | Start Date
 |  | 2021-01-01 00:00:00
 |  | End Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Start Date |  |  |  | End Date
 |  |  |  | See Data Table More than 1 Time Entry |  |  |  |  | Holiday |  |  |  | Weekends |  |  |  |  | NA / Not Employed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEARLY SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00 | 1900-01-30 00:00:00 | 1900-01-31 00:00:00 |  | 1> |  |  |  |  |  |  |  | Total Negative | Work Days
 |  |  |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Negative |  |  | Work Days
Spreadsheet: 30036d1225318021-placing-info-in-a-seperate-tab-and-highlighting-names-934889-ver-1
Sheet: asdf

Totals |  |  |  | 0 | 0 | 76 | 28.16 | -47.84 | -62.94736842105263 | 49 | 22
ID | Name | pgk | trdc | cvcb | dfg | Invested | Returned | Profit | % ROI | Owed | Recovered | Sent | Returned | Duration
1235 | [NAME] |  |  |  |  | 20 | 21.16 | 1.16 | 5.800000000000001 |  |  | 2008-08-09 20:19:00 | 2008-08-10 22:08:00 | 0 yrs, 0 mnths, 1 days, 01 hrs,  49 mins.
3456 | [NAME] |  |  |  |  | 10 | 0 | -10 | -100 | 10 | 10 | 2008-08-12 14:06:00 | 2008-08-16 14:06:00 | 0 yrs, 0 mnths, 4 days, 00 hrs,  00 mins.
43567 | [NAME] |  |  |  |  | 20 | 5 | -15 | -75 | 15 | 5 | 2008-08-11 15:08:00 | 2008-09-02 17:08:00 | 0 yrs, 0 mnths, 22 days, 02 hrs,  00 mins.
912 | Mark |  |  |  |  | 10 | 0 | -10 | -100 | 10 |  | 2008-08-12 14:06:00 |  | #N/A
2345 | [NAME] |  |  |  |  | 10 | 2 | -8 | -80 | 8 | 4 | 2008-09-05 20:19:00 | 2008-09-09 20:09:00 | 0 yrs, 0 mnths, 3 days, 23 hrs,  50 mins.
235 | Sue |  |  |  |  | 6 | 0 | -6 | -100 | 6 | 3 | 2008-08-11 15:08:00 |  | #N/A
Totals |  |  |  | 0 | 0 | 76 | 28.16 | -47.84 | -62.94736842105263 | 49 | 22
ID | Name | pgk | trdc | cvcb | dfg | Invested | Returned | Profit | % ROI | Owed | Recovered | Sent | Returned | Duration
 |  |  |  |  |  |  |  |  | Total owed: |  | 27
Spreadsheet: d8dbe52c-3169-4f9f-acc7-a5d95e20bc05
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 10/2/2014 5:25:46 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
District 37 | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 23464d1213003143-update-master-sheet-from-daily-report-june_oil
Sheet: MASTER SHEET To be Updated

 | FOR JUNE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-01-06 00:00:00 |  |  | 2008-02-06 00:00:00 |  |  | 2008-03-06 00:00:00 |  |  | 2008-04-06 00:00:00 |  |  | 2008-05-06 00:00:00 |  |  | 2008-06-06 00:00:00 |  |  | 2008-07-06 00:00:00 |  |  | 2008-08-06 00:00:00 |  |  | 2008-09-06 00:00:00 |  |  | 2008-10-06 00:00:00 |  |  | 2008-11-06 00:00:00 |  |  | 2008-12-06 00:00:00 |  |  | 13/6/2008 |  |  | 14/6/2008 |  |  | 15/6/2008 |  |  |  | 16/6/2008 |  |  | 17/6/2008 |  |  | 18/6/2008 |  |  | 19/6/2008 |  |  | 20/6/2008 |  |  | 21/6/2008 |  |  | 22/6/2008 |  |  | 23/6/2008 |  |  | 24/6/2008
S.No | Site ID | Site Name | Date Of OnAir | TELCOM | Dist | [NAME] | SUPERVISOR NAME | Electricty Status | A | D G Status | KVA | Tower Type | Sec Agency | No. Of  Caretaker/sec/dost |  | Readings for last filling date of previous month |  |  | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt) | [NAME]  reading | Stock ( Lt) | Filling (Lt)
1 | PHAN-02 | [NAME] | 2004-10-15 00:00:00 |  | XYZ | ROB-South Central | JHON
2 | PHPHA-01 | Patiala | 2004-10-15 00:00:00 |  | ABC | ROB-Greater | Roshan
3 | PHKHI-01 | KhelKuda-1 | 2004-10-15 00:00:00 |  | MNC | ROB-Greater | Roshan
4 | PHDIH-01 | [NAME] Harbour-1 | 2004-10-15 00:00:00 |  | JKL | ROB-Greater | JHON
5 | PHPHA-01 | Patiala | 2004-10-15 00:00:00 |  | MOP | ROB-Greater | JHON
6 | PHDIH-02 | [NAME] Harbour-2 | 2004-10-16 00:00:00 |  | JKL | ROB-Greater | Roshan
7 | PHKHI-02 | halim | 2004-10-17 00:00:00 |  | MOP | ROB-Greater | Roshan
8 | PHKHI-01 | KhelKuda-1 | 2004-10-18 00:00:00 |  | JKL | ROB-Greater | JHON
Spreadsheet: 744852d1629485207-copy-formulas-to-certain-days-on-another-worksheet-forum-sample
Sheet: Jan WH Data

2022-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Normal Hours | OT | Stand Up in £ | Sat | [NAME] in £
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st |  |  |  | OT
Employee 1 |  | H | 5 | 9 | 9 | 7 | 11
Overtime
Employee 2
Overtime
Employee 3
Overtime
Employee 4
Overtime
Employee 5
Overtime
Employee 6
Overtime
Employee 7
Overtime
Employee 8
Overtime
Employee 9
Overtime
Employee 10
Overtime
Spreadsheet: 24c83947-13a1-4a9d-a7e2-f7538ef5ba23
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
PENTS | Test | PENTS | Pentobarbital, Serum | Pentobarbital, S | Gas Chromatography-Mass Spectrometery (GC-MS) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Container/Tube: Red top  [NAME]: 2 mL Collection Instructions: Spin down within 2 hours of draw. | 0.7 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic range Hypnotic: 1-5 mcg/mL Therapeutic coma: 20-50 mcg/mL Reducing intracranial pressure: 30-40 mcg/mL This degree of sedation requires artificial respiratory support. Toxic concentration: >10 mcg/mL The concentration at which toxicity occurs varies; results should be interpreted in light of clinical situation. | Tuesday | 2 days | 8 days | 1 | 82205 |  |  |  |  | Rochester
PENTS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
PENTS | Result | 8239 | Pentobarbital, S | Pentobarbital, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3924-8 | Pentobarbital:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 23

TABLE 23
USE A SEPARATE SHEET FOR METRO & COUNTY
EXISTING OFFICE SITE PROFILE
Identity | Name | Street | City | County | State | Zip | Telephone
Building
Owner/Broker
Company
Contact
Zoning Classification
Site Characteristics
Acreage
Total
Usable
No. of [NAME] for Expansion
[NAME]
Topography
Elevation
Watertable (Ft. Below Ground)
100 Year Flood Plain (Yes or No)
% of Site Wetlands
Phase One Environment Audit Complete (Yes or No)
Transportation
[NAME]
Name
Two or Four Lane
Distance to Four Lane Highway
Internal Site Access
Mass Transit Service
Light Rail (Miles from Site)
Bus (Miles from Site)
Distance to Nearest Airport (Miles from Site)
Effective Property Tax Rate per $100 | Tax Rate ($)
Real Property Tax
City
County
School
Special District
Total
Personal Property Tax (Rate per $100)
City
County
School
Special District
Total
Water
Provider
Size of Main
Distance of Main from Site in Ft.
Pressure
Residual
Static
Booster Pump Required (yes or No)
On-site Storage
Elevated (Yes or No)
Capacity in Gallons
Sewer
Provider
Sewer Main
Size
Distance from Site in Ft.
Use of Lift Required (Yes or No)
Treatment Plant
Type
Rated Capacity (mgd)
Peak Demand (mgd)
Storm Drainage System
Protective Services
Fire Insurance Class Rating
Distance to Nearest Station
Fire Station Volunteer or Full-Time
Police
24 Hour police [NAME]
Electric Power
Service Provider
Service Voltage to Site/Building
Transmission Voltage
Distribution Voltage
Secondary Voltage
Power Quality
Total interruptions per year
Number of instantaneous delays
Total outage duration (hours/year)
Dual Feed Available from 1 Substation
Dual Feed Available from 2 Substations
Natural Gas
Provider
Size of Gas Line
Distance from Site in Ft.
Gas Pressure
Heat Valve (BTU per Cubic Foot)
Selling Price per Acre
Telecommunications Service
Local Exchange Carrier
Nearest Central Office (C.O.)
Location
Distance in Miles
Switch
ADSL Available from C.O.
DSL Available from C.O.
Type (e.g., Analog or Digital)
C.O. on a Fiber Ring (Yes or No)
Dual Service Provided from Two Central Offices
Fiber Available (Yes or No)
ISDN Available from C.O.
Competitive Local Exchange Carrier Allowed to Serve Site
Points of Presence (POPs)
List All Major Long Distance Carriers
Closest Major [NAME] POPs
Location
Distance in Miles
Is this Building in a classified Zone | Yes | No
State Enterprise Zone
Enterprise Community
Empowerment Zone
Foreign Trade Zone
Specialized Local Zones
Summarize statutory incentives that could apply to a new tenant
Include each package: still photograph, aerial photograph, plot map, topography map, & a highway map
Spreadsheet: 273806d1382913468-why-is-my-vlookup-returning-n-a-when-looking-up-from-a-pivot-table-july-13-csau_leave-provision-report_july-2013
Sheet: LSL GL Pivot Table

Pers.No. | Sum of Debit Amount
13100007 | 48618.82
13100009 | 1308.56
13100010 | 8276.36
13100015 | 60194.87
13100016 | 11035.97
13100018 | 18613.78
13100019 | 88933.76
13100021 | 184841.38
13100029 | 30043.95
13100031 | 68474.86
13100034 | 19602.96
13100037 | 122728.6
13100040 | 150040.84
13100041 | 94989.55
13100050 | 100430.44
13100052 | 31130.58
13100054 | 9844.76
13100062 | 204174.32
13100063 | 79024.5
13100074 | 74908.11
13100079 | 34576.37
13100081 | 44100.58
13100082 | 36218.21
13100083 | 150022.44
13100084 | 149279.26
13100085 | 99903.87
13100087 | 145418.04
13100090 | 35988.45
13100092 | 24570.99
13100093 | 28851.83
13100095 | 81742.87
13100098 | 35851.13
13100099 | 59356.11
13100104 | 119141.56
13100106 | 98640.86
13100107 | 67381.1
13100108 | 96525.97
13100110 | 49868.01
13100114 | 76468.27
13100117 | 25023.16
13100118 | 129254.46
13100120 | 106120.19
13100121 | 106031.45
13100127 | 23806.78
13100129 | 4064.8
13100133 | 76458.72
13100134 | 329883.74
13100141 | 20540.43
13100142 | 19269.26
13100146 | 65452.88
13100148 | 62404.65
13100150 | 27003.93
13100153 | 13367.31
13100154 | 21162.32
13100155 | 51813.15
13100162 | 39487.25
13100163 | 20654.05
13100167 | 17089.38
13100169 | 51075.31
13100171 | 18262.52
13100173 | 15453.9
13100174 | 25929.95
13100185 | 9672.78
13100193 | 23322.96
13100195 | 55387.15
13100203 | 11024.53
13100207 | 30892.28
13100212 | 43267.03
13100213 | 1370.76
13100226 | 30435.03
13100229 | 34293.6
13100231 | 11371.85
13100237 | 1039.8
13100240 | 41579.81
13100241 | 7172.92
13100246 | 33400.47
13100250 | 71107.16
13100254 | 47204.52
13100255 | 47204.52
13100262 | 10310.79
13100265 | 46310.15
13100269 | 10489.61
13100273 | 67054.88
13100275 | 16624.45
13100279 | 8497.21
13100284 | 32172.72
13100289 | 29423.8
13100293 | 26868.97
13100294 | 9800.65
13100306 | 9992.47
13100307 | 29375.64
13100311 | 34407.84
13100314 | 9305.32
13100317 | 25231.02
13100319 | 15845.33
13100320 | 9664.97
13100327 | 37306.85
13100328 | 18903.44
13100333 | 40556.25
13100335 | 32857.58
13100336 | 18135.22
13100337 | 31736.15
13100340 | 28864.86
13100341 | 25108.65
13100345 | 17917.18
13100348 | 8521.56
13100350 | 8148.96
13100354 | 10806.97
13100355 | 4984.66
13100364 | 1114.64
13100378 | 3551.45
13100380 | 7476.87
13100389 | 2492.21
13100390 | 1408.19
13100392 | 2616.87
13100399 | 3551.45
13100400 | 1620.08
13100403 | 1831.73
13100404 | 1869.16
13100405 | 59153.31
13100406 | 6806.98
13100408 | 648.08
13100416 | 3427.03
13100421 | 20661.74
13100429 | 1345.73
13100431 | 1015.5
13100432 | 2554.66
13100434 | 1086.7
13100446 | 2778.95
13100450 | 3239.92
13100451 | 2431.13
13100456 | 2118.47
13100861 | 69791.38
Spreadsheet: 8df4ae39-a114-450f-879d-ec4ffc201e97
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Police
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2340 |  | 212652 |  | A |  |  |  | 142806 |  | Inc
 |  | 2340 |  | 212652 |  | B |  |  |  | 72269 |  | Inc
 |  | 2340 |  | 212652 |  | C |  |  |  | 44838 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 259913
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  |  |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2340 |  | 212652 |  | 601100 |  |  |  | 142806 |  | Inc
 |  | 2340 |  | 212652 |  | 614250 |  |  |  | 72269 |  | Inc
 |  | 2340 |  | 212652 |  | 626250 |  |  |  | 44838 |  | Inc
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 259913
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 0
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 136849d1326844869-multiple-if-statement-vlookupsampler
Sheet: Sheet1

2012-01-18 00:00:00 |  |  |  |  | Code | Titles | %
 |  |  |  |  | a | Fraud Investigation 1 | 0.19
 |  |  |  |  | b | Fraud Investigation 2 | 0.18
 |  |  |  |  | c | Fraud Investigation 3 | 1.18
 |  |  |  |  | d | Fraud Investigation 4 | 2.18
 |  |  |  |  | e | Fraud Investigation 5 | 3.18
 |  |  |  |  | f | Fraud Investigation 6 | 4.18
 |  |  |  |  | g | Fraud Investigation 7 | 5.18
 |  |  |  |  | h | Fraud Investigation 8 | 6.18
 |  |  |  |  | i | Fraud Investigation 9 | 7.18
 |  |  |  |  | j | Fraud Investigation 10 | 8.18
 |  |  |  |  | k | Fraud Investigation 11 | 9.18
 |  |  |  |  | l | Fraud Investigation 12 | 10.18
 |  |  |  |  | m | Fraud Investigation 13 | 11.18
Code | A |  | 10
answer here | 1.9
Without code | Fraud Investigation 9 |  | 10
anser here | 71.8
Sorry cannot get the idea in second issue maybe a sample output with or wothout formulas.
Spreadsheet: 268514d1380660634-creating-a-total-sum-for-each-month-pt-group-sum-calc-field
Sheet: Sheet1

Date | Value 1 | Value 2 | Value 3
2013-08-09 00:00:00 | 2.5 | 4.5 |  |  |  | Would Like a formula to display this:
2013-08-11 00:00:00 | 5.4 | 2.3 | 1.1 |  |  | (Totals for the months)
2013-08-20 00:00:00 | 2.3 |  |  |  |  |  | Value 1 | Value 2+3 |  | Row Labels | Sum of Value 1 | Sum of Field1
2013-08-26 00:00:00 | 8.9 |  | 2.3 |  |  | 2013-08-13 00:00:00 |  |  |  | Aug | 19.1 | 10.2
2013-09-10 00:00:00 | 9.1 | 2.1 |  |  |  | 2013-09-13 00:00:00 |  |  |  | Sep | 16.3 | 8.7
2013-09-12 00:00:00 | 1 |  | 4.3 |  |  | 2013-10-13 00:00:00 |  |  |  | Oct | 2.6 | 0
2013-09-20 00:00:00 | 2.5 |  | 0.2 |  |  |  |  |  |  | Grand Total | 38.00000000000001 | 18.9
2013-09-25 00:00:00 | 3.7 |  | 2.1
2013-10-01 00:00:00 | 2.6
Spreadsheet: 115118d1310735804-extract-unique-data-and-concatenate-book
Sheet:  SHIRTDATA

No. | Item Code | Description | DATE
1 | A-456-11 | Shirt 1 | 2011-07-04 00:00:00
2 | A-456-11 | Shirt 2 | 2011-07-04 00:00:00
3 | A-456-11 | Shirt 3 | 2011-07-04 00:00:00
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
Spreadsheet: 672412d1586865055-vlookup-hlookup-for-question-2
Sheet: DC Inventory

DC-ID | ITEM | ITEM | Concat | Check # | PACK | SIZE | OH Inventory $ Value | TOTAL OO + OH | OO | OO - Forward Buy | OH | OH - Forward Buy | Weeks Supply | Avg DC Movement | Wk 4 Movement | Wk 3 Movement | Wk 2 Movement | Wk 1 Movement
DC- 10 | 134820-0 | 134820 |  | 0 | 36 | 1.5OZ | 37941 | 2284 | 288 | 0 | 1996 | 0 | 24.6 | 93 | 196 | 31 | 0 | 18
DC- 20 | 134820-0 | 134820 |  | 0 | 36 | 1.5OZ | 27966 | 1843 | 228 | 0 | 1615 | 0 | 23.9 | 77 | 0 | 0 | 0 | 10
DC- 10 | 135080-0 | 135080 |  | 0 | 24 | 2.8OZ | 33954 | 1406 | 0 | 0 | 1406 | 0 | 6.1 | 229 | 182 | 212 | 0 | 21
DC- 20 | 134950-5 | 134950 |  | 5 | 36 | 1.55O | 20350 | 1712 | 456 | 0 | 1256 | 0 | 20.6 | 83 | 49 | 0 | 0 | 7
DC- 04 | 134820-0 | 134820 |  | 0 | 36 | 1.5OZ | 32182 | 2178 | 924 | 0 | 1254 | 0 | 19.6 | 111 | 610 | 72 | 0 | 5
Spreadsheet: 02d1dae1-973a-43a7-8632-adf467bd0460
Sheet: BO

Table | Bolivia |  | Latin America and the Caribbean
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 1229.193 | 291.0302783589875 | 422.627693 | 102.71532 |  | 2393.460120180591
2003 | 1321.55 | 291.1044984366297 | 459.47309 | 119.992533 |  | 2433.715602145802
2004 | 1145.65 | 289.1498442476673 | 303.478293 | 93.909728 |  | 2357.855769016113
2005 | 1500.206 | 293.9306365245369 | 400.615294 | 65.24365 |  | 2416.146029208169
2006 | 1717.295 | 284.1222671858834 | 303.575031 | 117.760853 |  | 2371.180107659012
2007 | 1625.649 | 276.954971109867 | 456.2994849999999 | 67.007242 |  | 2391.496115836234
2008 | 1519.4012 | 295.878856749932 | 437.582533 | 13.006401 |  | 2380.175944321341
2009 | 1657.7924 | 299.9080703684252 | 382.737636 | 21.914164 |  | 2430.518292638888
2010(e) | 1588.35 | 292.9457804182088 | 380.3360803221955 | 33.97593566666666 |  | 2416.577002926743
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 1886.114345063821 | 297.389066964045 | 406.9543545038047 | 0 | 150.5998139653621 | 2627.779602608657
2016 | 2127.854418190605 | 320.432969450753 | 431.4635529051571 | 0 | 120.2689567267698 | 2948.129303797279
2021 | 2392.138012683503 | 344.9205240889887 | 445.4282557993359 | 0 | 90.26734046049506 | 3294.384493502093
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
(grain production), FAOSTAT (root and tuber production and imports), and the World Food Program (food aid).
*NG stands for nutritional gap and describes the amount of grain equivalent needed to support nutritional standards on
a national average level. DG stands for distributional gap and it describes that amount of grain equivalent needed to allow each
income quintile to reach the nutrional requirement.
Spreadsheet: 116155d1311629962-excel-2007-circular-reference-issue-example
Sheet: Sheet1

 |  | General 6thFloor
 |  | Number | Description | Vendor | Added | Proposed Completion Date | Completion Date | Approved by MHR | "X"
 | 1 | 200 | Hardware screws flat and in polished nickel | CNY
 |  | 201 | Panic Buttons are loose or missing | MHR | 2011-07-11 00:00:00
 |  | 202 | Mirror spacers to be removed | CNY | 2011-07-11 00:00:00
 |  | 203 | [NAME] to be fixed to stop rod movement | CNY | 2011-07-11 00:00:00
Spreadsheet: 785476d1656435008-consolidate-stock-vs-requirement-stock-vs-requirement
Sheet: Sheet1

Option-1
Table:1 (Stock Report) |  |  |  | Table:2 (Requirement report) |  |  |  |  |  | OUTPUT REQUIREMENT
Material Code | Description | Stock |  | Material Code | Store Code | Priority | Description | Requirement |  | Material Code | Description | Shoftfall | Stores
AAA1234 | Apples | 10 |  | AAA1234 | ST1 | 1 | Apples | 10 |  | AAA1234 | Apples | 5 | ST2(5)
[NAME] | Oranges | 12 |  | AAA1234 | ST2 | 2 | Apples | 5 |  | AAA3456 | Grapes | 10 | ST1(1)/ST2(4)/ST3(3)/ST4(2)
AAA3456 | Grapes | 0 |  | [NAME] | ST1 | 2 | Oranges | 4
BBB1234 | Papaya | 2 |  | [NAME] | ST2 | 1 | Oranges | 1
BBB2345 | [NAME] | 5 |  | [NAME] | ST3 |  | Oranges | 0
 |  |  |  | AAA3456 | ST1 | 1 | Grapes | 1
 |  |  |  | AAA3456 | ST2 | 2 | Grapes | 4
 |  |  |  | AAA3456 | ST3 | 3 | Grapes | 3
 |  |  |  | AAA3456 | ST4 | 4 | Grapes | 2
 |  |  |  | BBB1234 | ST1 | 1 | Papaya | 1
 |  |  |  | BBB1234 | ST2 | 2 | Papaya | 1
Option-2
Table:1 (Stock Report) |  |  |  | Table:2 (Requirement report) |  |  |  |  |  | OUTPUT REQUIREMENT
Material Code | Description | Stock |  | Material Code | Store Code | Description | Requirement |  |  | Material Code | Description | Shoftfall | Stores
AAA1234 | Apples | 10 |  | AAA1234 | ST1 | Apples | 10 |  |  | AAA1234 | Apples | 5 | ST1/ST2
[NAME] | Oranges | 12 |  | AAA1234 | ST2 | Apples | 5 |  |  | AAA3456 | Grapes | 10 | ST1/ST2/ST3
AAA3456 | Grapes | 0 |  | [NAME] | ST1 | Oranges | 4
BBB1234 | Papaya | 2 |  | [NAME] | ST2 | Oranges | 1
BBB2345 | [NAME] | 5 |  | [NAME] | ST3 | Oranges | 0
 |  |  |  | AAA3456 | ST1 | Grapes | 1
 |  |  |  | AAA3456 | ST2 | Grapes | 4
 |  |  |  | AAA3456 | ST3 | Grapes | 3
 |  |  |  | AAA3456 | ST4 | Grapes | 2
 |  |  |  | BBB1234 | ST1 | Papaya | 1
 |  |  |  | BBB1234 | ST2 | Papaya | 1
Spreadsheet: 44882d1243609001-print-only-used-area-print-active-cells-only
Sheet: Six

 | To Print Active Cells Only
Member | Name | Age
1 | Fred | 62 |  | Insert another row, now record another macro the same way as last time.
2 | [NAME] | 35 |  | Only this time, name it MacroSortMEMBER.
3 | [NAME] | 31 |  | I've used "a" as the key.
4 | [NAME] | 45 |  | Now highlight from A6:C30, go to Data-Sort select [NAME] By "A".
5 |  |  |  | Then click out of the range so the cells are no longer highlighted.
6 | Betty | 67 |  | Go to Tools-Stop Recording.
7 | [NAME] | 87
8 | Toby | 34 |  | Go through the same process sorting Column "B"
9 |  |  |  | I've used MacroSORT [NAME] and "s" as the key.
10
11 |  |  |  | Go through the same process sorting Column "C".
12 | [NAME] | 23 |  | I've used MacroSORTAGE and "d" as the key.
13 | [NAME] | 21
14 | [NAME] | 34 |  | Now make three more buttons, assigning the appropiate macro each button.
15 | [NAME] | 56
16 |  |  |  | I've named them all sort and sat them at the top of each Column I want to sort.
17
18 |  |  |  | Now when you push the "Print Now" Button that youv'e created it will print only the
19 |  |  |  | active cells in the order that you have sorted them in.
20
21 |  |  |  | You can still use the Ctrl and "z or a or s or d" keys.
22
23
24
25