tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862572d1710258474-index-match-using-2-criteria-wont-work-useindexmatch
Sheet: Result

The Corrcect Row = 35 and Correct Column=5
Option 1
XX Dividends Total Trust |  | =INDEX(Inc_Transactions!$F:$F,MATCH("XX Dividends Total"& "Trust",Inc_Transactions!$D:$D&Inc_Transactions!$E:$E,0))
This is the problem. It's only finding the first occurence of "XX Dividends Total". |  | =MATCH("XX Dividends Total"& "Trust",Inc_Transactions!$D:$D&Inc_Transactions!$E:$E,0)
This is also a problem since it's finding only the first row of "Trust" |  | =MATCH("Trust",Inc_Transactions!$E:$E,0)
 |  | =MATCH("XX Dividends Total ",Inc_Transactions!$D:$D,0)
Option 2
Another formula I tried: |  | =INDEX(Inc_Transactions!$F:$F,MATCH("XX Dividends"&"|"&"Trust",Inc_Transactions!$D:$D&"|"&Inc_Transactions!$E:$E,0))
Just MATCH portion of formula |  | =MATCH("XX Dividends"&"|"&"Trust",Inc_Transactions!$D:$D&"|"&Inc_Transactions!$E:$E,0)
Option 3
And still another: |  | =INDEX(Inc_Transactions!$F:$F,MATCH(1,INDEX(("XX Dividends Total"=Inc_Transactions!$D:$D)*("Trust"=Inc_Transactions!$E:$E),0,1)))
Just Match portion???????? |  | =MATCH(1,INDEX(("XX Dividends Total"=Inc_Transactions!$D:$D)*("Trust"=Inc_Transactions!$E:$E),0,1),0)
Then removing the "1" (not sure what it does) before the INDEX |  | =MATCH(INDEX(("XX Dividends Total"=Inc_Transactions!$D:$D)*("Trust"=Inc_Transactions!$E:$E),0,1),0)
Spreadsheet: 273641d1382810394-need-help-formula-to-transfering-value-book1
Sheet: Sheet1

#2 outboard valves |  |  |  |  |  |  |  | #2outboard seats
Date | slurry hours | suction | discharge | Data suc | Data dis | Suction Hours | [NAME] | Date | slurry hours | suction | discharge | Data suc | Data dis | Suction Hours | [NAME]
2012-01-24 00:00:00 | 96557 | x | x |  |  | 498 | 816 | 2011-12-25 00:00:00 | 96134 | x |  |  |  | 1530
2012-06-02 00:00:00 | 98157 | x | x |  |  |  |  | 2012-01-24 00:00:00 | 96557 |  | x
2012-08-07 00:00:00 |  | x | x |  |  |  |  | 2012-06-01 00:00:00 | 98157 |  | x
2012-09-02 00:00:00 |  | x |  |  |  |  |  | 2012-08-07 00:00:00 |  |  | x
2013-01-05 00:00:00 |  | x | x |  |  |  |  | 2012-09-02 00:00:00 |  | x
2013-03-29 00:00:00 |  | x | x |  |  |  |  | 2013-01-05 00:00:00 |  | x | x
2013-05-28 00:00:00 |  | x | x |  |  |  |  | 2013-03-29 00:00:00 |  |  | x
2013-06-23 00:00:00 |  |  | x |  |  |  |  | 2013-05-28 00:00:00 |  | x | x
2013-08-19 00:00:00 |  | x | x |  |  |  |  | 2013-06-23 00:00:00 |  |  | x
2013-10-14 00:00:00 |  | x | x |  |  |  |  | 2013-08-19 00:00:00 |  | x | x
 |  |  |  |  |  |  |  | 2013-10-14 00:00:00 |  |  | x
Spreadsheet: andy_zipper__163__DYNEGY-ICE VOL Apr6
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  |  | ENRON PERCENTAGE: |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Count of Deal ID | Sum of Total Quantity |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 920000 |  | Dorland , C | Firm-LD Peak | MWhs | 3 | 36000
Grand Total |  |  | 1 | 920000 |  | Fischer, M | Firm-LD Peak | MWhs | 2 | 20800
 |  |  |  |  |  | [NAME], R | Firm-LD Peak | MWhs | 1 | 17600
 |  |  |  |  |  | Motley, M | Firm-LD Peak | MWhs | 1 | 10400
 |  |  |  |  |  | Grand Total |  |  | 7 | 84800
Spreadsheet: 708099d1607614887-average-last-3-cells-in-a-column-that-are-not-blank-excel-help-3-
Sheet: Sheet1

Week
1 | 1
2 | 2
3 | 3
4
5 | 5
6 | 2
7 | 3
8
9
10 | 13
11
12 | 17
13 | 24
Spreadsheet: 137712d1327331648-excel-2007-formula-help-when-entering-a-neg-longitude-west-latlon
Sheet: Sheet1

Latitude [NAME]
[NAME] to Deg. Dec
Latitude |  |  |  | Longitude
Deg | min | sec |  | Deg | min | sec
41 | 24 | 33.9001 |  | -81 | 3 | 24.83
Results
Latitude |  |  |  | Longitude
 |  |  |  |  |  |  |  | [NAME] in |  | cells
[NAME].Sec to [NAME] sec
Latitude |  |  |  | Longitude
41.409417 |  |  |  | 81.85498
Results
Latitude |  |  |  | Longitude
Deg | min | sec |  | Deg | min | sec
 | 24 | 34 |  |  | 51 | 18
Spreadsheet: 794528d1662099053-need-a-formula-to-find-the-most-recent-value-unless-its-zero-sample-workbook
Sheet: Sheet1

OVERVIEW
 | END - 2021 | END - JAN | END - FEB | END - MAR | END - APR | END - MAY | END - JUN | END - JUL | END - AUG | END - SEP | END - OCT | END - NOV | END - DEC | ANNUAL GROWTH
Assets
Liabilities
NET WORTH
ASSET | END - 2021 | END - JAN | END - FEB | END - MAR | END - APR | END - MAY | END - JUN | END - JUL | END - AUG | END - SEP | END - OCT | END - NOV | END - DEC
Account 1 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Account 2 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Account 3 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
MONTHLY TOTAL
LIABILITY | END - 2021 | END - JAN | END - FEB | END - MAR | END - APR | END - MAY | END - JUN | END - JUL | END - AUG | END - SEP | END - OCT | END - NOV | END - DEC
Liability 1 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Liability 2 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Liability 3 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
MONTHLY TOTAL
Spreadsheet: 465060d1465427697-multiple-workbooks-same-analysis-sample-day-2-with-stats-
Sheet: Stat Analysis

Stats
 |  |  |  |  | Total
 |  |  |  |  | ←As %
No | RP | RT | Other | Total
 |  |  |  | ←As %
Spreadsheet: 46ae9849-5177-4dd5-8986-5b2d280a875f
Sheet: Sheet1

B | B | B | B | B | B | A | A | A | A | A | A | J | J | J | J | J | J | O | O | O | O | O | O
A | A | J | J | O | O | B | B | J | J | O | O | A | A | B | B | O | O | A | A | J | J | B | B
J | O | A | O | J | A | J | O | B | O | J | B | B | O | A | O | B | A | J | B | A | B | J | A
O | J | O | A | A | J | O | J | O | B | B | J | O | B | O | A | A | B | B | J | B | A | A | J
J | J | B | J | J | J | J | J | O | O | B | J | O | O | O | O | O | O | O | J | B | B | B | J
J | J | A | A | A | J | J | J | J | J | A | J | A | A | A | A | A | A | J | J | A | A | A | J
J | J | O | J | J | J | J | J | J | J | O | J | J | J | J | J | J | J | J | J | O | O | O | J
O | O | A | B | O | O | O | O | O | O | A | O | O | O | O | O | O | O | O | O | A | A | A | O
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: InfoTrac

InfoTRAC
2010-2011
COUNTER-Compliant?: | Yes
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Literature Resource Center |  |  |  |  |  |  |  |  |  |  |  |  |  | Access fee only.
[NAME] | 162 | 85 | 421 | 527 | 974 | 1013 | 242 | 406 | 772 | 1082 | 407 | 154 |  | 2105
Sessions | 69 | 28 | 123 | 182 | 256 | 251 | 81 | 145 | 219 | 246 | 123 | 42
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Successful Full-Text Article Requests | 65 | 65 | 92 | 146 | 282 | 284 | 115 | 126 | 310 | 360 | 289 | 81
Spreadsheet: 786464d1657203818-calculate-workdays-without-overlap-in-a-single-row-oeter-example
Sheet: Sheet1

Fully Submitted | Total STC (which includes overlap, not what I want) | Expected STC Days (excluding overlap) | TOTAL STC DAYS (Excluding overlap) | STC Start 1 | STC End 1 | STC  Days 1 ([NAME]. Weekends / Holidays) | Who, Why? | STC Start 2 | STC End 2 | STC  Days 1 ([NAME]. Weekends / Holidays)2 | Who, Why?2 | STC Start 3 | STC End 3 | STC  Days 1 ([NAME]. Weekends / Holidays)3 | Who, Why?3 | STC Start 4 | STC End 4 | STC  Days 1 ([NAME]. Weekends / Holidays)4 | Who, Why?4
2022-04-01 00:00:00 |  | 5 |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00
2022-04-01 00:00:00 |  | 5 |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00
2022-04-01 00:00:00 |  | 8 |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 |  |  | 2022-07-08 00:00:00 | 2022-07-13 00:00:00
2022-04-01 00:00:00 |  | 11 |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 |  |  | 2022-07-08 00:00:00 | 2022-07-13 00:00:00 |  |  | 2022-07-20 00:00:00 | 2022-07-22 00:00:00
2022-04-01 00:00:00 |  | 15 |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 |  |  | 2022-07-08 00:00:00 | 2022-07-13 00:00:00 |  |  | 2022-07-12 00:00:00 | 2022-07-22 00:00:00
Spreadsheet: 126060d1319497872-i-need-help-compiling-a-total-in-excel-from-multiple-worksheets-in-the-same-workbook-goodwill
Sheet: 5-14-2011

[NAME] |  | 2011-05-14 00:00:00
Quan. | Item | Net  Value | Gross Value
1 | [NAME] | 10
2 | Leather [NAME] | 10
1 | [NAME] | 5
3 | Caulking Gun | 8
2 | Angle Levels | 10
1 | [NAME] | 8
18 | Belts for Sander | 6
1 | Short Level | 15
1 | Grid Ceiling Punch NEW | 50
2 | Shot Lights | 20
1 | Wallboard Sanding Block | 15
3 | Steel Wool | 7
1 | [NAME] | 25
10 | Bungy Cords | 3
8 | Drawer File Adapters | 2
3 | Hammer | 5
1 | CD Radio | 25
1 | Lincoln Cents Partial Set Old | 20
2 | Specialty Bits for Rosetts | 50
35 | [NAME] | 4
7 | Hole Saw Parts | 6
2 | [NAME] | 5
1 | [NAME] | 35
1 | [NAME] template | 15
1 | [NAME] | 10
1 | Paint Mixer Paddle | 15
2 | Sanding Blocks | 3
1 | Steel Wire | 3
1 | Elastic Auto Net | 5
1 | [NAME] | 5
16 | Caulking Tubes | 4
2 | [NAME] | 4
1 | [NAME] | 50
10 | Blades for 10" | 5
1 | Tool Box Plastic | 15
1 | Paint Mate Painter | 40
Spreadsheet: 69819d1270495075-date-formula-date-analysis-example-revised-2-
Sheet: Sheet2

Analysis Year               Incept | Analysis   Valued                      As Of | Months of Development | What I want to see | DATEDIF | DATEDIF+1 | YEARFRAC
2008-10-01 00:00:00 | 2009-10-01 00:00:00 |  | 12
2008-10-01 00:00:00 | 2009-10-19 00:00:00 |  | 12
2008-10-01 00:00:00 | 2009-10-20 00:00:00 |  | 12
2008-10-01 00:00:00 | 2009-10-21 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-10-31 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-01 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-14 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-15 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-20 00:00:00 |  | 13
2008-10-01 00:00:00 | 2009-11-21 00:00:00 |  | 14
2008-10-01 00:00:00 | 2009-11-30 00:00:00 |  | 14
Analysis Year               Incept | Analysis   Valued                      As Of | Months of Development | What I want to see
2008-09-24 00:00:00 | 2009-11-23 00:00:00 |  | 14
2008-10-01 00:00:00 | 2009-11-23 00:00:00 |  | 14
2008-10-05 00:00:00 | 2009-11-23 00:00:00 |  | 13
2008-11-09 00:00:00 | 2009-11-30 00:00:00 |  | 13
2008-11-10 00:00:00 | 2009-11-30 00:00:00 |  | 12
2008-11-11 00:00:00 | 2009-11-30 00:00:00 |  | 12
Spreadsheet: 720880d1614344976-lookup-values-and-if-a-match-is-made-do-a-conditional-formatting-match-and-shade
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friends |  |  |  |  |  |  |  |  |  | Enemy |  |  |  |  |  |  |  | Neutral
 |  |  | P | 2 |  | NN | 9 |  |  | E | ANTI |  |  |  |  |  |  |  | 1 | 9 | 2 | 5 | 3 | 6 | 1 |  |  | 1 | 8 |  |  |  |  |  |  | 1 | 4 | 7
 |  |  | P | 2 |  | FN |  |  |  | E | ANTI |  |  |  |  |  |  |  | 2 | 1 | 5 | 3 | 2 |  |  |  |  | 2 | 8 | 4 | 9 |  |  |  |  | 2 | 6 | 7
 |  |  | L | 7 |  | NN |  |  |  | F | OK |  |  |  |  |  |  |  | 3 | 1 | 5 | 6 | 2 |  |  |  |  | 6 |  |  |  |  |  |  |  | 3 | 4 | 8 | 9
 |  |  | L | 7 |  | FN |  |  |  | F | OK |  |  |  |  |  |  |  | 4 | 7 | 1 | 5 | 6 | 4 |  |  |  | 2 | 8 | 2 | 9 |  |  |  |  | 4 | 3
 |  |  | P1 | 2 |  | L2 | 8 |  |  | E | ANTI |  |  |  |  |  |  |  | 5 | 1 | 2 | 3 | 6 | 5 |  |  |  | 5 |  |  |  |  |  |  |  | 5 | 7 | 8 | 9 | 4
 |  |  | P2 | 9 |  | L1 | 3 |  |  | F | OK |  |  |  |  |  |  |  | 6 | 1 | 5 | 7 | 6 | 4 |  |  |  | 6 | 3 |  |  |  |  |  |  | 6 | 8 | 9 | 2
 |  |  | L2 | 6 |  | NN | 6 |  |  | N | NETRAL |  |  |  |  |  |  |  | 7 | 4 | 6 | 1 | 5 | 3 |  |  |  | 7 |  |  |  |  |  |  |  | 7 | 8 | 9 | 2 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | 3 | 6 | 7 |  |  |  |  | 8 | 1 | 2 | 8 |  |  |  |  | 8 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | 5 | 3 |  |  |  |  |  | 9 | 4 | 2 |  |  |  |  |  | 9 | 9 | 7 | 6 | 8
 |  | Need help with a lookup function that if the contents of Y3 = AB , read from table and indicate "E"
 |  | and must shade red and in AF3 must indicate 'ANTI'
 |  | if the match is red from the friendly column, must indicate "F" and next cell ok
 |  | if the match is from the Netral table, it must indicate N ans next to it write Netral
 |  | I thank you for the help
Spreadsheet: 222737d1363918623-need-to-create-multiple-invoices-with-multiple-items-sample-data
Sheet: Customer Info

Customer | Adress 1 | Adress 2 | Adress 3 | Post Code
AA Com | 234 | qertqrt | qertqrt | qertqrt
Ahsun | 12 | qretdfgwrty | qretdfgwrty | qretdfgwrty
[NAME] | 4 | ghjtyusd | ghjtyusd | ghjtyusd
Bamma Telecom | 54 | aaertdfg | aaertdfg | aaertdfg
[NAME] | 7 | werfsdgy | werfsdgy | werfsdgy
Cash | 34 | dv | dv | dv
[NAME] | 7 | dfgdfb | dfgdfb | dfgdfb
Coms R Us | 42 | ertsdgb | ertsdgb | ertsdgb
Hafiz Sidiq | 99 | ertergz | ertergz | ertergz
Home & Away | 7 | zxvartasv | zxvartasv | zxvartasv
[NAME] | 8 | zxcbsertads | zxcbsertads | zxcbsertads
Jeetu | 485 | sdfatsd | sdfatsd | sdfatsd
[NAME] | 867 | 4utuyjyn | 4utuyjyn | 4utuyjyn
[NAME] | 345 | [NAME] | [NAME] | [NAME]
[NAME] | 87 | dfbdsfysd | dfbdsfysd | dfbdsfysd
Nasir | 34 | zdfg | zdfg | zdfg
Ocean Supermarket | 7 | dafg | dafg | dafg
Rainbow | 34 | dfgwrtyfsg | dfgwrtyfsg | dfgwrtyfsg
Raj Kumar | 9 | bsdf | bsdf | bsdf
Raz | 2 | ertdfgfdgysreg | ertdfgfdgysreg | ertdfgfdgysreg
[NAME] | 753 | dfgserdfgdf | dfgserdfgdf | dfgserdfgdf
Santosh | 21 | bsdf | bsdf | bsdf
[NAME] | 324 | [NAME] | [NAME] | [NAME]
[NAME] | 87 | ertdfgfdgysreg | ertdfgfdgysreg | ertdfgfdgysreg
Srinavas | 3453 | ghjtyusd | ghjtyusd | ghjtyusd
Stanley | 890 | bfg | bfg | bfg
Star Comm | 89 | hse | hse | hse
Sukhdev | 67 | rtd | rtd | rtd
Tanveer Babar | 45 | gd | gd | gd
Spreadsheet: 15f492db-dec5-465e-9095-effff4b151d2
Sheet: general_report

Uponor North America
Displaying 6 issues at 07/Nov/11 11:13 AM.
Issue Type | Key | Summary | Notes for Technical Bulletin | Status | Resolution | Created | Updated | Fix Version/s
Task | CCN-7 | Siemans CO2/VOC Sensor EOL | Database has been modified to support the AERASGARD RLQ-CO2 / VOC sensor. IE: The VOC AIC has been inverted | Closed | Fixed | 2009-10-07 09:36:00 | 2011-10-31 17:53:00 | 44.00.00
Bug | CCN-25 | sometimes DER's do not correctly update under the DSM RTR during installation | Default Databases have cleared Datalinks that contain no data. This should allow datalinks to connect properly at commissioning. | Closed | Fixed | 2010-03-03 17:11:00 | 2011-10-31 15:26:00 | 44.00.00
Improvement | CCN-40 | Create clean default data bases for all controllers | Created Default DB process to clear Datalinks and network numbers | Closed | Fixed | 2010-09-21 12:12:00 | 2011-10-31 15:28:00 | 44.00.00
Bug | CCN-87 | WM1 Icons for Air Cooling not displayed correctly for Air Zones that share an Air Handler. | Fixed Air Cooling Icon display on the thermostat when using Dampers connected to a common AirHandler | Closed | Fixed | 2011-07-14 17:18:00 | 2011-11-02 12:44:00 | 44.00.00
Bug | CCN-46 | [NAME] is pointed to Delta 10K curve. [NAME] needs to be on the J curve AIC | Update the Snowmelt Slab sensor to work with a more accurate conversion table (AIC): 10K J curve | Closed | Fixed | 2011-01-05 12:00:00 | 2011-11-02 13:17:00 | 44.00.00
Improvement | CCN-96 | Change outdoor sensor to Teal AIC | Update the outdoor sensor Conversion table to match the sensor manufacturer. Will improve accuracy around 0C/32F. | Closed | Fixed | 2011-10-31 10:37:00 | 2011-11-02 13:03:00 | 44.00.00
Generated at Mon Nov 07 11:13:27 CST 2011 by Logan Grauer using JIRA 4.3.4#620-r152668.
Spreadsheet: 781635d1653458945-find-similar-codes-of-words-keep-aligw
Sheet: Data

Title 1 | Code |  | Title2 | Expected answer
Color | 1 |  | fresh ginger does not keep well
Donkeys | 2 |  | good SuperMarket
SuperMarket | 3 |  | Nice key
Book | 4 |  | big mark
key | 5 |  | Good book
Mark | 6 |  | Red color
keep | 7 |  | Donkeys do not have ears
Spreadsheet: 392841d1430764166-countif-x-every-nth-column-rc-sheet
Sheet: WEST Sunday

 |  | AT2 WESTBOUND Sunday Pick - Feb 22, 2015 |  |  |  |  |  |  |  | Survey Date |  |  |  |  |  |  |  | Survey Date
 |  |  |  |  |  |  |  |  |  | Service Type |  | Checker |  |  |  |  |  | Service Type |  | Checker
 |  |  |  |  |  |  |  |  |  | Trip # |  | Weather |  | Operator |  |  |  | Trip # |  | Weather |  | Operator
 |  | Stops Updated | 2019-01-02 00:00:00 | Total [NAME] |  |  |  |  |  | Run # |  | Traffic |  | Bus |  |  |  | Run # |  | Traffic |  | Bus
 |  | BUS STOP |  | TP # [NAME] | TP # [NAME] | Stop Total Boards | Stop Total Alights | Stop Total Load |  | TIMEPOINT |  |  |  | PASSENGERS |  |  |  | TIMEPOINT |  |  |  | PASSENGERS
Seq | TP? | ON | AT |  |  |  |  |  |  | SCHEDULED | ARRIVE | DEPART | DELAY? | ON | OFF | ONBOARD |  | SCHEDULED | ARRIVE | DEPART | DELAY? | ON | OFF | ONBOARD
1 | Y | BRADDOCK METRO | BAY E |  |  |  |  |  |  |  |  |  | 9 | 5 | 3 | 10 |  |  |  |  | -6 | 2 | 6 | 5
2 | n | MADISON | WEST ST.
3 | N |  | FAYETTE
4 | N |  | HENRY
5 | n |  | PATRICK
6 | N | N. COLUMBUS | MADISON
7 | N |  | MONTGOMERY
8 | N | POWHATAN | SECOND ST.
9 | N | BASHFORD LN. | POWHATAN
10 | N |  | ABINGDON
11 | N |  | PITT
12 | N | PITT | BELLVUE
13 | N | SECOND ST. | PITT
14 | N |  | FAIRFAX
15 | n | FAIRFAX ST. | SECOND ST.
16 | N |  | MONTGOMERY ST.
17 | N |  | MADISON ST.
18 | y |  | PENDLETON
19 | N |  | ORONOCO
20 | N |  | QUEEN
21 | N |  | KING ST.
22 | N | KING ST. | ROYAL
23 | N |  | PITT
24 | N |  | ST. ASAPH
25 | y |  | WASHINGTON
26 | n |  | COLUMBUS
27 | N |  | ALFRED
28 | N |  | PATRICK
29 | N |  | FAYETTE
30 | n |  | WEST ST.
31 | N |  | PEYTON ST.
32 | N |  | HARVARD
33 | N |  | DIAGONAL RD.
34 | y | KING ST. METRO | BAY E
35 | N | KING ST. | 1921
36 | N |  | ROSEMONT
37 | N |  | WALNUT
38 | N |  | [NAME]
39 | n |  | WEST VIEW
40 | N | [NAME] | PUTNAM PL.
41 | N |  | ROBINSON CT.
42 | N |  | TAYLOR RUN PKWY.
43 | N |  | CLOVERWAY DR.
44 | N |  | [NAME].
45 | N |  | 1211
46 | N |  | KINGSTON AVE.
47 | N |  | QUAKER LN.
48 | N | SEMINARY RD. | QUAKER LN.
49 | N |  | [NAME] PKWY.
50 | N |  | 3823
51 | N |  | ST. STEPHENS
52 | n |  | CHAPEL HILL
53 | y |  | [NAME].
54 | N |  | 4501
55 | N |  | N. PICKETT
56 | N |  | 4649
57 | N |  | KENMORE AVE.
58 | y | SOUTHERN TOWERS | [NAME]
59 | N |  | [NAME]
60 | N |  | Berkeley Building
61 | y | MARK CENTER AVE. | [NAME].
62 | N | [NAME]. | BEAUREGARD
63 | N | BEAUREGARD ST. | [NAME].
64 | N |  | 1698
65 | N | RAYBURN AVE. | WINSTON CT.
66 | N |  | HARDING AVE.
67 | N |  | DUNSTER CT.
68 | N | READING AVE. | MERTON CT.
69 | N |  | BEAUREGARD
70 | N | BEAUREGARD ST. | ROANOKE AVE.
71 | y |  | SANGER AVE.
72 | N |  | MORGAN
73 | N | ARMISTEAD | BEAUREGARD
74 | N |  | MIDBLOCK
75 | N |  | QUANTRELL
76 | N | QUANTRELL AVE. | ARMISTEAD
77 | N |  | MAYFLOWER SQ. #2
78 | N | LINCOLNIA RD. | [NAME]
79 | y |  | BRECKINRIDGE
80 | n
81 | n
82 | n
83 | y
84 | n
85 | n
86 | n
87 | n
88 | n
89 | y
90 | n
91 | n
92 | n
93 | n
94 | y
95 | n
96 | n
97 | n
98 | n
99 | n
100 | y
Spreadsheet: d7d239bb-8994-40cc-b4b9-3f2540c6f313
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | State Senate District 3 - Democratic
2012-09-11 00:00:00 | Ballard, d | Bradley, r | [NAME]
Albany | 42
[NAME] | 211 | 1
[NAME] | 52 | 3
Chatham | 17
Conway | 477 | 2 | 2
Eaton | 50
[NAME] | 83 |  | 1
Freedom | 112 |  | 1
Hale's Location | 5
Hart's Location | 8
[NAME] | 116 |  | 1
[NAME] | 172 | 1 | 1
[NAME] | 65 | 1 | 1
Milton | 204 | 3 | 1
Moultonborough | 238
Ossipee | 149 | 1
Sandwich | 188
Tamworth | 198 | 1 | 2
Tuftonboro | 127 | 2
Wakefield | 193 | 1
Waterville Valley | 34
Wolfeboro | 452
Totals | 3193 | 16 | 10
 | State Senate District 4 - Democratic
 | [NAME], d | Woods, r | [NAME]
[NAME] | 676 |  | 2
[NAME] | 501 | 4 | 1
[NAME] | 308
[NAME] | 363 | 11 | 1
[NAME] | 360 | 11
[NAME] | 229
[NAME] 6 | 227 |  | 1
[NAME] | 194 | 1
[NAME] | 133 | 1
[NAME] | 126 |  | 2
[NAME] 3 | 90 |  | 1
[NAME] | 118 |  | 2
[NAME] 5 | 82 | 1
Totals | 3407 | 29 | 10
Spreadsheet: 731314d1620287892-formula-to-populate-orders-master-fifo_model_for_many_products_no_vba_v5
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21