tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 55350d1255471510-vlookup-and-workbook-sheet-referencing-in-2007-book2
Sheet: Sheet2

200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500 | 1550 | 1600 | 1650 | 1700 | 1750 | 1800 | 1850 | 1900 | 1950 | 2000 | 2050 | 2100 | 2150 | 2200 | 2250 | 2300 | 2350 | 2400 | 2450 | 2500 | 2550 | 2600 | 2650 | 2700 | 2750 | 2800 | 2850 | 2900 | 2950 | 3000
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 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 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
 |  | I need the data in the yellow to match the same data in yellow on sheet 1
 |  | for example cell a5 on this sheet should reference along with g12 on page one
 |  | I want both the carrier and the rate show up
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 4

 | Dec 14 |  | Dec 21 |  | Dec 28 |  | Jan 4
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 744032d1628871439-formula-result-not-accurate-weld-weight-calculation-v2
Sheet: Consumable Cost

 |  |  | .045" ER70S-6 SuperArc® L-59
 |  | US Pound / Drum | 1000
 |  | Cost | 3720
 |  | Cost Per Pound | 3.72
 |  |  | .045" ER70S-6 SuperArc® L-56
 |  | US Pound / Drum | 1000
 |  | Cost | 3650
 |  | Cost Per Pound | 3.65
 |  |  | .052" ER70S-6 SuperArc® L-59
 |  | US Pound / Drum | 1000
 |  | Cost | 3670
 |  | Cost Per Pound | 3.67
 |  |  | .052" ER70S-6 SuperArc® L-56
 |  | US Pound / Drum | 1000
 |  | Cost | 3600
 |  | Cost Per Pound | 3.6
Spreadsheet: 79749d1279925651-mix-up-letters-totals
Sheet: Sheet1

 |  |  |  |  |  | Total1 | Total6
 |  |  |  |  |  | Total2 | Total4
 |  |  |  |  |  | Total3 | Total8
 |  |  |  |  |  | Total4 | Total2
 |  |  |  |  |  | Total5 | Total10
 |  |  |  |  |  | Total6 | Total14
 |  |  |  |  |  | Total7 | Total13
 |  |  |  |  |  | Total8 | Total7
 |  |  |  |  |  | Total9 | Total1
 |  |  |  |  |  | Total10 | Total15
 |  |  |  |  |  | Total11 | Total12
 |  |  |  |  |  | Total12 | Total9
 |  |  |  |  |  | Total13 | Total11
 |  |  |  |  |  | Total14 | Total3
 |  |  |  |  |  | Total15 | Total5
 |  |  |  |  |  | Before | After
 |  |  |  |  |  | I would like H column mix to happen in column G
Spreadsheet: 525699d1498842106-formulas-to-sum-distinct-values-with-condition-any-and-all-sample-c
Sheet: Formulas

Location | No. of Distinct Names | No. of Distinct Names with 1 or more cat. 'B' | No. Of Distinct Names with only cat. 'A' |  | Answer Key 1+ 'B': | Answer 'A' Only:
East |  |  |  |  | 2 | 1
North |  |  |  |  | 2 | 0
South |  |  |  |  | 1 | 1
West |  |  |  |  | 3 | 1
Spreadsheet: 5a398dcd-27b3-4993-a4cd-900e02c1719d
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
9738 | Test | 9738 | Bone Histomorphometry, Qualitative | Bone Histomorphometry, QL | A specimen slide(s) will be forwarded upon request at no additional charge. | [NAME], leak proof vial: ScwLkPf |  |  |  | Varies | [NAME] of preference is anterior iliac crest Container/Tube: Metal-free container (Supply T173)  Collection Instructions: Fix specimen in 70% ethanol. Additional Information: For further information, see Bone Histomorphometry Fact Sheet (Supply T579) in Bone Histomorphometry in Special Instructions.  Forms: Bone Histomorphometry Information Sheet (Supply T352) in Special Instructions |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide an interpretive report. All results will be called to the physician designated on the Bone Histomorphometry Information Sheet. | Monday through Friday; 8 a.m. - 5 p.m. | 26 days | 30 days | 1 | 88323 |  |  |  |  | Rochester
BHQL | Test | BHQL | Bone Histomorphometry, Qualitative | Bone Histomorphometry, QL |  |  |  |  |  |  | [NAME] of preference is anterior iliac crest Container/Tube: Metal-free container (Supply T173)  Collection Instructions: Fix specimen in 70% ethanol. Additional Information: For further information, see Bone Histomorphometry Fact Sheet (Supply T579) in Bone Histomorphometry in Special Instructions.  Forms: Bone Histomorphometry Information Sheet (Supply T352) in Special Instructions |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | All results will be called to the physician designated on the Bone Histomorphometry Information Sheet. | Monday through Friday; 8 a.m. - 5 p.m. | 26 days | 30 days |  | Profile |  |  |  |  | Rochester
BHQL | [NAME] | VARIES | Varies |  |  |  | Ambient
BHQL | Result | BHQL | Bone Histomorphometry, QL | Bone Histomorphometry, QL | Alphanumeric
BHQL | Billing Component | BHQL |  | IMMUNOFLUORESCENT STUDY |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88346
BHQL | Billing Component | BHQL |  | SPECIAL STAINS GROUP 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88313
Spreadsheet: 108990d1305903590-formula-that-returns-first-day-of-the-month-book4
Sheet: Sheet1

START_DATE | What I Need is This
2011-04-16 00:00:00 | 2011-04-01 00:00:00
2011-04-18 00:00:00 | 2011-04-01 00:00:00
2011-04-19 00:00:00 | 2011-04-01 00:00:00
2011-04-20 00:00:00 | 2011-04-01 00:00:00
2011-04-21 00:00:00 | 2011-04-01 00:00:00
2011-04-22 00:00:00 | 2011-04-01 00:00:00
2011-05-23 00:00:00 | 2011-05-01 00:00:00
2011-05-25 00:00:00 | 2011-05-01 00:00:00
2011-05-26 00:00:00 | 2011-05-01 00:00:00
2011-08-27 00:00:00 | 2011-08-01 00:00:00
2011-08-28 00:00:00 | 2011-08-01 00:00:00
2011-08-29 00:00:00 | 2011-08-01 00:00:00
2011-08-30 00:00:00 | 2011-08-01 00:00:00
Spreadsheet: 164136d1340655742-index-match-from-2-sources-of-files-index-and-match-from-2-sources-of-files
Sheet: 2010

CBS | PO# | Line item amount
ABC | 598983 | 798525
ABC | 598983 | 54432
ABC | 598983 | 236250
DEF | 598983 | 79852.5
DEF | 578923 | 68970
DEF | 578923 | 1900000
DEF | 578923 | 3952
DEF | 578923 | 26125
BCD | 578923 | 12160
BCD | 578923 | 24320
ABC | 30517444 | 1820000
ABC | 30517444 | 2280
ABC | 30525566 | 325000
ABC | 30533491 | 780000
HIJ | 552793 | 325000
HIJ | 586216 | 780000
HIJ | 586216 | 555750
HIJ | 586216 | 51336
HIJ | 586216 | 34960
HIJ | 586216 | 4048
Spreadsheet: 865112d1712174801-calculate-lengths-of-inner-mid-outer-arcs-of-elbow-curve-elbow-dimensions-formulae
Sheet: Sheet1

 | Elbow Dimensions |  |  |  |  |  |  |  |  |  | Degree |  | 90
 | [NAME]. | R1 | R2 | R3 | T1 | T2 | Inner | Midline | Outer
 | 3 |  |  |  | 1 | 1 |  |  |  |  | CLR |  | 5
 | 4 |  |  |  | 1 | 1
 | 5 |  |  |  | 1 | 1
 | 6 |  |  |  | 1 | 1
 | 7 |  |  |  | 1 | 1
 | 8 |  |  |  | 1 | 1
 | 9 |  |  |  | 1 | 1
 | 10 |  |  |  | 1 | 1
 | 11 |  |  |  | 1 | 1
 | 12 |  |  |  | 1 | 1
 | 14 |  |  |  | 1 | 1
Spreadsheet: 691940d1597957503-help-with-nps-improvement-calculation-nps
Sheet: Sheet1

July EOM NPS | Week 1 NPS | %Improvement
-100 | -100
50 | -100
-11.1111111111111 | 100
-50 | 100
-25 | 100
-33.3333333333333 | 100
-57.1428571428571 | -100
41.6666666666667 | -100
50 | -100
-20 | -33.33
22.2222222222222 | -100
-14.2857142857143 | -100
100 | 100
-42.8571428571429 | -100
66.6666666666667 | 100
-28.5714285714286 | -100
-46.1538461538462 | -11.11
-37.5 | -100
-83.3333333333333 | -100
-100 | -100
-50 | -50
-40 | -100
-66.6666666666667 | -100
-60 | -100
-100 | 100
100 | -100
-83.3333333333333 | -100
-100 | -100
-25 | -33.33
-100 | -100
-11.1111111111111 | -33.33
-100 | 100
-86.9565217391304 | -100
-100 | -100
-100 | 100
-25 | 100
-90.9090909090909 | -50
-100 | -100
100 | -100
-77.7777777777778 | -100
50 | -100
-75 | -100
-100 | -100
-79.1666666666667 | -100
Spreadsheet: 154808d1336572181-excel-2007-looking-up-a-value-in-a-matrix-based-on-three-criteria-example-1-
Sheet: Price List

 |  | USD Direct | [NAME] | USD Estore | EUR Direct | EUR Resale | [NAME] | GBP Direct | GBP Resale | GBP Estore
 | 1112 | 10 | 8 | 9 | 7 | 5 | 6 | 11 | 9 | 10
 | 1114 | 11 | 9 | 10 | 8 | 6 | 7 | 12 | 10 | 11
 | 1113 | 12 | 10 | 11 | 9 | 7 | 8 | 13 | 11 | 12
 | 1111 | 13 | 11 | 12 | 10 | 8 | 9 | 14 | 12 | 13
Spreadsheet: 820988d1678375335-data-selection-using-drop-down-options-book1-andyd1234-
Sheet: 0303

[NAME] | Status | Contract Value |  |  | count | value
123 | Won | 132500 |  | won
124 | In Process | 155000 |  | lost
127 | Lost | 76000 |  | in process
128 | Won | 145000
130 | Won | 30000
131 | In Process | 35000
134 | Won | 86000
137 | Lost | 90000
139 | Lost | 40000
141 | Won | 200000
143 | In Process | 50000
Spreadsheet: 599638d1543233542-ststistic-bettter-solution-car-gps
Sheet: 2 Nov

 |  |  | ID LOCATION
Driver | car | Location | PA | LO | BE | WI | MA
[NAME] | Car Blue | London
Carmen | Car Red | Paris
Sue | Car Green | Berlin
[NAME] | Car Black | Madrid
[NAME] | [NAME] | [NAME]
Spreadsheet: rick_buy__32698__DOUG
Sheet: 0200

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF FEBRUARY 29, 2000
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 5714782.94 |  | 882079.46 |  | 4368505.61 |  | 4030388.46 |  |  |  |  | LAST PAYMENT 2/22/00
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 3360451.57
PUERTO QUETZAL | A/R |  | 2896377.45 |  | 0 |  | 0 |  | 0 |  | 22240.62 |  |  | LAST PAYMENT 2/28/00
463 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
416 | PER CENT
DABHOL POWER CO | A/R |  | 0 |  | 0 |  | 144874.81 |  | 0 |  |  |  |  | LAST PAYMENT 1/31/00
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 144874.81
EMPRESA ENERGETICA | A/R |  | 0 |  | 1217777.54 |  | 1581340.62 |  | -189.2 |  | 1100305.79 |  |  | LAST PAYMENT 2/8/00
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1486817.27
EGEMINSA | A/R |  | 613143.35 |  | 1138414.35 |  | 536193.6 |  | 807306.43 |  | 928072.54 |  |  | LAST PAYMENT 2/24/00
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 691008
TOTALS | A/R
 | PER CENT
Spreadsheet: 736550d1623734266-combining-similar-areas-of-data-oly-ans
Sheet: Sheet2

Rio
 | Gymnastics | Swimming | Cycling
Canada | 0 | 3 | 0
UK | 1 | 1 | 3
USA | 2 | 3 | 1
Germany | 0 | 1 | 2
Spreadsheet: 191275d1352030888-how-to-list-the-cheapest-supplier-for-certain-products-book1-coloured
Sheet: Sheet1

 | supplier1 | supplier2 | supplier3 | supplier4 | [NAME] | supplier6 | WHO IS THE CHEAPEST
product1 | 90 | 80 | 50 | 60 | 85 | 75
product2 | 80 | 90 | 50 | 20 | 70 | 10
product3 | 50 | 60 | 80 | 70 | 20 | 90
product4 | 20 | 60 | 40 | 60 | 70 | 75
Spreadsheet: 851656d1701842030-need-help-converting-a-google-sheet-formula-to-excel-scheduling-test-2-
Sheet: Calculations

HS | Boards | SQFT | [NAME] = sign when pasting
No Smoothing | 90 | 2880 | (((F4*G4)/144)*E4)/(IF(J4=Calculations!$A2,Calculations!$C$2,IF(J4=Calculations!$A$3,Calculations!$C$3,IF(J4=Calculations!$A$4,Calculations!$C$4,IF(J4=Calculations!$A$5,Calculations!$C$5,IF(J4=Calculations!$A$6,Calculations!$C$6,IF(J4=Calculations!$A$7,Calculations!$C$7)))))))*I4+0.2
Light Smoothing | 60 | 1920
Heavy Smoothing | 40 | 1280
[NAME] | 30 | 960
[NAME] | 20 | 640
[NAME] | 15 | 480
[NAME] |  |  | [NAME] = sign when pasting
2 Pass |  | 2880 | (((F7*G7)/144)*E7)/(IF(J7=Calculations!$A$11,Calculations!$C$11,IF(J7=Calculations!$A$12,Calculations!$C$12,IF(J7=Calculations!$A$13,Calculations!$C$13,IF(J7=Calculations!$A$14,Calculations!$C$14,IF(J7=Calculations!$A$15,Calculations!$C$15,I
3 Pass |  | 1920
4 Pass |  | 1280
Backlit |  | 960
DS |  | 960
FU or [NAME] |  | 640
DS White |  | 480
8 Pass |  | 640
8 Pass + White |  | 480
5 Layer |  | 240
 |  | 640
3Rs | SQFT |  | [NAME] = sign when pasting
2 Pass | 1784 |  | (((F4*G4)/144)*E4)/(IF(J4=Calculations!$A$24,Calculations!$B$24,IF(J4=Calculations!$A$25,Calculations!$B$25,IF(J4=Calculations!$A$26,Calculations!$B$26,IF(J4=Calculations!$A$27,Calculations!$B$27,IF(J4=Calculations!$A$28,Calculations!$B$28))))))*I4+0.2
3 Pass | 1254
5-Pass | 704
Backlit | 241
2-Sided | 330
GS | Boards | SQFT | [NAME] = sign when pasting
Light Smoothing | 25 | 800 | (((F5*G5)/144)*E5)/(IF(J5=Calculations!$A$11,Calculations!$C$11,IF(J5=Calculations!$A$12,Calculations!$C$12,IF(J5=Calculations!$A$13,Calculations!$C$13,IF(J5=Calculations!$A$14,Calculations!$C$14,IF(J5=Calculations!$A$15,Calculations!$C$15,IF(J5=Calculations!$A$16,Calculations!$C$16,IF(J5=Calculations!$A$17,Calculations!$C$17))))))))*I5+0.2
Heavy Smoothing | 15 | 480
[NAME] | 10 | 320
[NAME] | 10 | 320
[NAME] | 6 | 192
#REF! | gs
#REF! | hs
#REF! | 3r
#REF! | tauro
Spreadsheet: 328459d1403901290-pivot-table-forecast-at-completion-based-on-actuals-to-date-ytd_calc_data
Sheet: PT-Rept

Month | (All)
Project ID | (All)
WorkStream ID | (All)
 |  |  |  |  | Chose the month to see the Forecast at Completion (FAC) | Full Year
Row Labels | Plan Hrs | Actual Hrs | Planned Costs | Actual Costs | Forecast at Completion - Hrs | Forcast at Completion - Cost
OA01 | 329 | 69 | 13160 | 2760 | FAC at June = Actuals upto May + Planned from June to Dec | FAC at June = Actuals upto May + Planned from June to Dec
Name 1 | 154 | 13 | 6160 | 520
Name 11 | 126 | 0 | 5040 | 0
Name 4 | 49 | 56 | 1960 | 2240
OA02 | 119 | 7 | 4760 | 280
Name 12 | 98 | 0 | 3920 | 0
Name 2 | 7 | 7 | 280 | 280
Name 5 | 14 | 0 | 560 | 0
OA03 | 293 | 55 | 11720 | 2200
OA04 | 76 | 28 | 3040 | 1120
OA05 | 223 | 38 | 8920 | 1520
OA06 | 273 | 38 | 10920 | 1520
Name 2 | 35 | 38 | 1400 | 1520
Name 8 | 98 | 0 | 3920 | 0
Name 9 | 140 | 0 | 5600 | 0
OA07 | 154 | 36 | 6160 | 1440
OA08 | 84 | 20 | 3360 | 800
OA09 | 203 | 7 | 8120 | 280
Name 10 | 98 | 0 | 3920 | 0
Name 5 | 7 | 7 | 280 | 280
Name 6 | 98 | 0 | 3920 | 0
OA10 | 7 | 7 | 280 | 280
OA11 | 182 | 50 | 7280 | 2000
OA12 | 315 | 60 | 12600 | 2400
OA13 | 70 | 0 | 2800 | 0
OA14 | 546 | 0 | 21840 | 0
Grand Total | 2874 | 415 | 114960 | 16600
Spreadsheet: 167252d1341934387-excel-2007-counting-multiple-periods-presenting-results-at-the-end-of-each-one-0afspirossample-count
Sheet: SAMPLE

 |  |  |  |  |  | Expected Results
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1 |  | 12
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 2 |  | 22
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3 |  | 11
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4 |  | 21
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5 |  | 6
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6 |  | 11
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7 |  | 7
 |  |  |  |  |  | 0
Spreadsheet: 741674d1627262460-split-data-into-3-collumns-with-vlookup-vlookup
Sheet: Sheet1

Date | ID | Name | Amount | Level 1 | Income | COST OF GOODS SOLD | EXPENSE |  |  |  |  | Income
2013-09-01 00:00:00 | 4000 | Service | 209777.65 | INCOME |  |  |  |  |  |  |  | COST OF GOODS SOLD
2013-09-01 00:00:00 | 4900 | Returns & Allowances | -1349.77 | INCOME |  |  |  |  |  |  |  | EXPENSE
2013-09-01 00:00:00 | 4910 | Discounts |  | INCOME
2013-09-01 00:00:00 | 4920 | Damaged Goods |  | INCOME
2013-09-01 00:00:00 | 5100 | Material Handling | 11174.97 | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5110 | Processing Labor | 39423.65 | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5130 | Direct Labor Payroll Tax | 4365.75 | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5140 | Temporary Labor Expense |  | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5200 | Direct Labor Group Insurance |  | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5210 | Direct Labor WC Insurance |  | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5300 | Beginning Inventory | 17983.77 | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5310 | Material | 35223.14 | COST OF GOODS SOLD
2013-09-01 00:00:00 | 5315 | Supplies | 9429.09 | COST OF GOODS SOLD
2013-09-01 00:00:00 | 6060 | Officer Salary - President | 9692.3 | EXPENSE
2013-09-01 00:00:00 | 6061 | Officer [NAME] - Vice President | 3230.64 | EXPENSE
2013-09-01 00:00:00 | 6071 | Office Manager [NAME] | 4998.24 | EXPENSE
2013-09-01 00:00:00 | 6110 | Auto Expenses | 8865.7 | EXPENSE
2013-09-01 00:00:00 | 6111 | Vehicle Registration |  | EXPENSE
2013-09-01 00:00:00 | 6115 | Auto Expenses Lease | 1277.34 | EXPENSE
2013-09-01 00:00:00 | 6120 | Bank Service Charges | 225.99 | EXPENSE
Spreadsheet: 273287d1382654299-need-help-with-a-if-and-formula-with-today-please-calendar-projection-for-seannormand
Sheet: Sheet1

 | 2013-10-05 00:00:00 | 2014-03-05 00:00:00
 |  |  |  |  | -Formulas writen in E1:T1 automatically showing headers for 1 month increments from today's date
Spreadsheet: 853667d1703606563-need-help-to-get-required-output-excel-question
Sheet: Sheet1

Product | [NAME] | Date | Inventory per Batch | Quantity to be consumed | Total Quantity | Column7 | Column8 | Required Output | Remaining per Batch
M1 | O2 | [NAME] | 12 | 7 | 36 | 1 | 1 | 7 | 5
M1 | O3 | Date5 | 12 | 7 | 36 | 1 | 2 | 0 | 5
M1 | O3 | Date5 | 12 | 7 | 36 | 1 | 3 | 0 | 5
M1 | O2 | [NAME] | 12 | 1 | 36 | 2 | 1 | 1 | 4
M1 | O3 | Date5 | 12 | 1 | 36 | 2 | 2 | 0 | 4
M1 | O3 | Date5 | 12 | 1 | 36 | 2 | 3 | 0 | 4
M1 | O2 | [NAME] | 12 | 17 | 36 | 3 | 1 | 4 | 0
M1 | O3 | Date5 | 12 | 17 | 36 | 3 | 2 | 12 | 0
M1 | O3 | Date5 | 12 | 17 | 36 | 3 | 3 | 1 | 11
M1 | O2 | [NAME] | 12 | 11 | 36 | 4 | 1 | 0 | 0
M1 | O3 | Date5 | 12 | 11 | 36 | 4 | 2 | 0 | 0
M1 | O3 | Date5 | 12 | 11 | 36 | 4 | 3 | 11 | 0
Product | [NAME] | Date | Inventory per Batch | Quantity to be consumed | Total Quantity | Column7 | Column8 | Required Output | Remaining per Batch
M1 | O2 | [NAME] | 12 | 54 | 60 | 1 | 1 | 12 | 0
M1 | O3 | Date5 | 12 | 54 | 60 | 1 | 2 | 12 | 0
M1 | O3 | Date5 | 12 | 54 | 60 | 1 | 3 | 12 | 0
M1 | O2 | [NAME] | 12 | 54 | 60 | 1 | 4 | 12 | 0
M1 | O3 | Date5 | 12 | 54 | 60 | 1 | 5 | 6 | 6
M1 | O3 | Date5 | 12 | 6 | 60 | 2 | 1 | 0 | 0
M1 | O2 | [NAME] | 12 | 6 | 60 | 2 | 2 | 0 | 0
M1 | O3 | Date5 | 12 | 6 | 60 | 2 | 3 | 0 | 0
M1 | O3 | Date5 | 12 | 6 | 60 | 2 | 4 | 0 | 0
M1 | O2 | [NAME] | 12 | 6 | 60 | 2 | 5 | 6 | 0
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12222 | 11345
2 | 12888 | 11487
3 | 11891 | 11488
4 | 11899 | 11090
5 | 11842 | 11492
6 | 11356 | 11494
7 | 11348 | 11494
8 | 10845 | 11494
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 442176.52
2001-08-08 00:00:00
CBS Volume
 |  |  | -235778
Spreadsheet: 767310d1644405243-need-help-with-filtering-values-with-3-decimal-places-annual-leave-balances-with-more-than-2-decimal-places-aligw
Sheet: Sheet1

Incorrect Basic
0.9734 |  |  | 1st | by B largest to smallest
7.4828 |  |  | 2nd | by A smallest to largest
10.8594
1
1
1
7.5
12