tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13d00d37-e734-47af-a93b-d82121a3c364
Sheet: Sheet1

NEW HAMPSHIRE - GENERAL ELECTION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2010-11-02 00:00:00 | UNITED STATES SENATOR
Belknap County | [NAME], r | [NAME], d | [NAME], lib | [NAME], ind | [NAME]
Alton | 1716 | 545 | 19 | 46 | 2
Barnstead | 1066 | 465 | 18 | 32 | 3
Belmont | 1439 | 602 | 22 | 73 | 1
Center Harbor | 360 | 150 | 2 | 11 | 1
Gilford | 2103 | 956 | 21 | 64 | 1
Gilmanton | 1000 | 467 | 14 | 33 | 2
[NAME] | 734 | 353 | 9 | 17 | 0
[NAME] | 444 | 242 | 9 | 17 | 1
[NAME] 3 | 497 | 300 | 5 | 19 | 0
[NAME] | 473 | 283 | 0 | 3 | 1
[NAME] | 358 | 189 | 6 | 18 | 0
[NAME] 6 | 727 | 301 | 5 | 18 | 0
Meredith | 1837 | 879 | 24 | 56 | 2
New Hampton | 560 | 318 | 11 | 26 | 2
Sanbornton | 765 | 486 | 9 | 37 | 4
[NAME] | 738 | 428 | 17 | 33 | 3
TOTALS | 14817 | 6964 | 191 | 503 | 23
 | UNITED STATES SENATOR
Carroll County | [NAME], r | [NAME], d | [NAME], lib | [NAME], ind | [NAME]
Albany | 151 | 122 | 4 | 9
[NAME] | 725 | 518 | 7 | 24
[NAME] | 238 | 119 | 8 | 5
Chatham | 90 | 49 | 2 | 4 | 1
Conway | 1796 | 1291 | 31 | 81 | 4
Eaton | 114 | 105 | 0 | 0
[NAME] | 326 | 184 | 7 | 29
Freedom | 468 | 216 | 7 | 21
Hale's Location | 92 | 18 | 0 | 0
Hart's Location | 6 | 10 | 0 | 0
[NAME] | 282 | 260 | 1 | 10
[NAME] | 559 | 412 | 13 | 30
Moultonborough | 1562 | 602 | 13 | 37 | 7
Ossipee | 964 | 421 | 15 | 62 | 1
Sandwich | 406 | 403 | 4 | 16
Tamworth | 636 | 443 | 8 | 23 | 2
Tuftonboro | 852 | 361 | 9 | 23 | 1
Wakefield | 1249 | 456 | 12 | 43 | 2
Wolfeboro | 2034 | 1023 | 28 | 48
TOTALS | 12550 | 7013 | 169 | 465 | 18
Spreadsheet: 105804d1303090919-referencing-other-worksheets-and-then-some-chapterfinancialrecordstemplate
Sheet: July

 | July 2010 Account Register
 | Number | Date | Description of Transaction | C | Debit   (-) | Credit (+) | Balance
Spreadsheet: 158236d1338080094-excel-2007-sorting-the-data-with-text-12052012-new
Sheet: 12052012

DUNIA ALHAMD SDN BHD
 | DAILY SALES REPORT |  |  | 2012-05-12 00:00:00
 | OR NUMBER | PARTICULAR | BAWANG MERAH |  |  |  |  | BAWANG KECIL
 |  |  | QTY | AMOUNT | TOTAL | Supplier |  | QTY | AMOUNT | TOTAL
 | 22598 | CASH | 4 | 4 |  | HB1
 | 22599 | CASH | 33 | 3.909 |  | HB1
 | 22600 | CASH | 1 | 4.5 |  | KUMAR
 | 22601 | CASH | 4 | 4 |  | HB1
 | 22602 | CASH | 2 | 4.5 |  | SB1
 | 22604 | CASH | 1 | 4.5 |  | KUMAR
 | 22605 | CASH | 1 | 4 |  | KUMAR
 | 22606 | CASH | 1 | 4 |  | KUMAR
 | 22610 | CASH | 30 | 4 |  | HB1
 | 22611 | CASH | 12 | 4 |  | HB1
 | 22613 | CASH | 2 | 4 |  | HB1
 | 22614 | CASH | 12 | 4 |  | HB1
 | 22617 | CASH | 2 | 4.5 |  | HB1
 | 22619 | CASH | 1 | 5 |  | HB1
 | 22623 | CASH | 3 | 5 |  | SB1
 | 22624 | CASH | 1 | 4 |  | HB1
 | 22625 | CASH | 5 | 4 |  | HB1
 |  | CREDIT | 200 | 4 |  | SB1
 |  | CREDIT | 20 | 4 |  | HB1
 |  | CREDIT | 50 | 4.2 |  | SB1
 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  | plz calculate the amount of Cash and Credit of supplier individually.
 |  | Supplier | Cash | credit
 |  | hb1
 |  | sb1
 |  | kumar
Spreadsheet: 812461d1673166437-list-of-upcoming-birthday-this-month-and-next-month-book1-9
Sheet: Upcoming Birthday

 |  | DATE
 |  |  |  |  |  |  |  |  |  |  | UPCOMING BIRTHDAY THIS MONTH AND NEXT MONTH
 |  | NAME | BIRHTDATE | DAY | MONTH | BIRTHDAY2 | AGE |  |  | NAME | BIRHTDATE | DAY | MONTH | BIRTHDAY2 | AGE
Spreadsheet: 543990d1508712715-need-help-using-text-to-column-s666-example
Sheet: Sheet2

Date Time |  | Systolic | Diastolic | Pulse
2017-10-22 16:38:00 | 16:38:00 | 120 | 80 | 78
2017-10-22 11:42:00 | 11:42:00 | 120 | 80 | 78
2017-10-21 11:51:00 | 11:51:00 | 120 | 80 | 78
2017-10-21 05:59:00 | 05:59:00 | 120 | 80 | 78
Spreadsheet: 85312d1285334072-lookup-match-pricing-sheet-example
Sheet: Pricing Sheet

 | 1
 | Unit Type | [NAME] | Height | Unit Ref | Price
 | PW1 | 1600 | 1205 | A03 | 285.14
Provision of Egress Window
Insulated Panel in Lieu of [NAME]
Low Threshold to Doors
Provision of Obscure Glass to Outer Pane
Provision of 6.4mm Laminated Glass to Both Panes
Provision of 4mm Toughened Glass to Both Panes
[NAME] Within Sealed Unit
Georgian Timber Astrigals
Provision of 4mm Self Cleaning Glass to Outer Pane
Aluminium Fixed Blade Louvres in Lieu of [NAME]
Hole For Extract Fan any Diameter
Removing and Reinstalling of Exisitng Extract Fan
Single Window Winding Gear
Provision of Cat Flap
8mm Overlay to W/Board up to 200mm
8mm Overlay to W/Board from 200mm up to 400mm
Removal of Secondary Glazing
L' Shaped Reveal Liner Not Exceeding 250mm in Width
Provision of 4mm Low 'e' Inner / 6.4mm Laminated Outer
Provision of Baypole
Provision of Coupler
Render per cheek making good
Render external reveals/m
Plastering reveals  / meter
Door Installation Including Survey
Total Window Cost |  |  |  |  | 285.14
Number of unit
Spreadsheet: 162585d1339991786-complex-if-and-logic-help-needed-commscalc-example
Sheet: Example

User defined Values |  |  | User Defined Ramps:
Quota | 1000 |  | Ramps / Accelerators | Low Value | High Value | Multiplier
Commission | 100 |  | Ramp 1 | 0 | 1 | 1
Base Amount | 100 |  | Ramp 2 | 1.01 | 1.5 | 2.4
 |  |  | Ramp 3 | 1.51 | 99.99 | 2.7
Calculator | Sales $ | Achievement % | Commission $ | Answer should be
Q1 | 200 |  |  | 20
Q2 | 200 |  |  | 40
Q3 | 300 |  |  | 70
Q4 | 300 |  |  | 100
Total |  |  |  | 100
EXAMPLE:
In this example the sales person has a quota of 1000 and manually inputs their quarterly achievement / Forecast (in GREEN). The Quarterly achievement is automatically calculated and the commission dollar value is calculated based on the Ramp Multipliers.
Commission Calculations based on example ramps
Nought to 100% | if achievement is between 0 and 100 then multiply achievement by commision multiplied by the ramp.
101% -150% | IF achievement is greater than 151% of quota then multiply 50 by ramp by commission value ELSE if achievement is greater than 100% of quota then subtract 100 from the  total achievment then multiply commission by ramp else 0
150%-9999% | IF achievement is greater than 151% of quota then multiply subtract 150 from the  total achievment then multiply commission by ramp 3 else 0
Spreadsheet: 838717d1691304066-transpose-rows-data-into-multiple-columns-data-transpose_rows_to_multicolumns-1-
Sheet: Sheet1

Group | Value |  |  | Group
Group_01 | Val_A
Group_01 | Val_B
Group_01 | Val_C
Group_02 | Val_X
Group_02 | Val_Y
Group_02 | Val_Z
Group_03 | Val_L
Group_03 | Val_M
Group_03 | Val_N
Group_04 | Val_Z
Group_05 | Val_L
Group_05 | Val_X
Spreadsheet: 886179d1736208261-index-match-problem-for-same-values-consumable-usage-2025
Sheet: DASHBOARD

 | Consumable Spend [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-05 00:00:00
 | DAILY SUMMARY |  |  |  |  | WEEKLY SUMMARY |  |  |  |  | MONTHLY SUMMARY |  |  |  |  | MONTHLY SUMMARY
 | A4:A20 |  |  |  |  | A4:A20 |  |  |  |  | A4:A20 |  |  |  |  | A4:A20
 | B4:[NAME] |  |  |  |  | B4:[NAME] |  |  |  |  | B4:[NAME] |  |  |  |  | B4:[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $O$4:$O$20
 | Top 30 Spend for previous day |  |  |  |  | Top 30 Spend for current week |  |  |  |  | Top 30 Spend for current month |  |  |  |  | Top 30 Spend for current year
 | Rank | Value | Part no. | Description |  | Rank | Value | Part no. | Description |  | Rank | Value | Part no. | Description |  | Rank | Value | Part no. | Description
1 | 1 |  |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  |  | 1 | 1
 | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3
 | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4
 | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5
 | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6
 | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7
 | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8
 | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9
 | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10
 | Should be
 | Top 30 Spend for previous day
 | Rank | Value | Part no. | Description
 | 1
 | 2
 | 3 |  | 9901100 | PART 23
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 879435d1726937566-how-counta-deals-with-blanks-and-arrays-counta
Sheet: Non_Count

 |  |  |  |  |  |  |  |  |  | Count of
 |  |  | A |  | A | False
 |  |  | C |  | B | False
 |  |  | C |  | C | False
 |  |  | A |  | D | False
 |  |  | C
 |  |  | C
 |  |  | B
 |  |  | A
 |  |  | D
 |  |  | D
 |  |  | C
 |  |  | B
 |  |  | A
 |  |  | B
 |  |  | A
 |  |  | B
 |  |  | A
 |  |  | C
 |  |  | A
 |  |  | D
 |  |  | C
 |  |  | A
 |  |  | D
 |  |  | B
 |  |  | A
 |  |  | A
 |  |  | C
 |  |  | A
 |  |  | C
 |  |  | D
 |  |  | A
 |  |  | D
 |  |  | C
 |  |  | A
 |  |  | C
 |  |  | C
 |  |  | A
 |  |  | A
 |  |  | C
 |  |  | D
 |  |  | D
 |  |  | B
 |  |  | B
 |  |  | A
 |  |  | C
 |  |  | A
 |  |  | A
 |  |  | A
 |  |  | C
 |  |  | A
Spreadsheet: john_griffith__16198__1_30_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | EXP |  |  | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 51 | 530 | 630 | 48.9 | 58.2 | 1.72 | 2002-01-30 13:49:00
 | HO J2 | 51 | 750 | 850 | 48.2 | 54.7 | 1.65 | 2002-01-30 13:49:00
 | HO K2 | 52 | 900 | 1000 | 45.4 | 50.5 | 1.57 | 2002-01-30 13:49:00
 | HO M2 | 52 | 1000 | 1100 | 43 | 47.4 | 1.48 | 2002-01-30 13:49:00
 | HO N2 | 52 | 1080 | 1180 | 41.9 | 45.8 | 1.43 | 2002-01-30 13:49:00
 | HO Q2 | 53 | 1150 | 1250 | 39.9 | 43.4 | 1.39 | 2002-01-30 13:49:00
 | HO U2 | 54 | 1200 | 1325 | 37.8 | 41.8 | 1.35 | 2002-01-30 13:49:00
 | [NAME] | 55 | 1250 | 1400 | 36.4 | 40.8 | 1.33 | 2002-01-30 13:49:00
 | HO X2 | 56 | 1300 | 1450 | 35 | 39.1 | 1.3 | 2002-01-30 13:49:00
 | [NAME] | 57 | 1350 | 1500 | 34.1 | 37.9 | 1.29 | 2002-01-30 13:49:00
 | HO F3 | 58 | 1400 | 1550 | 33.3 | 36.9 | 1.28 | 2002-01-30 13:49:00
 | [NAME] | 58 | 1400 | 1600 | 31.9 | 36.5 | 1.25 | 2002-01-30 13:49:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: drew_fossum__8870__Fixed2
Sheet: Sempra_1

[NAME]
FUEL HEDGING BOOK
Sempra_1
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso SJ |  | (4) | (4) | (4)
Jun-1999 |  |  | 1.945 |  |  | 1.96
Jul-1999 |  |  | 1.945 |  |  | 2.05
Aug-1999 |  |  | 1.945 |  |  | 2.26
Sep-1999 |  |  | 1.945 |  |  | 2.63
Oct-1999 |  |  | 1.945 |  |  | 2.37
Nov-1999 |  |  | 1.945 |  |  | 2.84
Dec-1999 |  |  | 1.945 |  |  |  | 2.08
Jan-2000 |  |  | 1.945
Feb-2000 |  |  | 1.945
Mar-2000 |  |  | 1.945
Apr-2000 |  |  | 1.945
May-2000 |  |  | 1.945
 |  |  |  |  |  | TW Index
Jun-1999 |  | Engage | 1.945 |  |  | 2.07
Jul-1999 |  | Engage | 1.945 |  |  | 2.11
Aug-1999 |  | Engage | 1.945 |  |  | 2.51
Sep-1999 |  | Engage | 1.945 |  |  | 2.36
Oct-1999 |  | Engage | 1.945 |  |  | 2.62
Nov-1999 |  | Engage | 1.945 |  |  | 2.17
Dec-1999 |  | Engage | 1.945 |  |  |  | 2.09
Jan-2000 |  | Engage | 1.945
Feb-2000 |  | Engage | 1.945
Mar-2000 |  | Engage | 1.945
Apr-2000 |  | Engage | 1.945
May-2000 |  | Engage | 1.945
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 118359d1313620038-excel-lookup-with-multiple-queries-complex-index-match-function-nosoupforyou
Sheet: Sheet1

ProjectName | EmpName | DateWorked | HoursWorked
Project1 | [NAME] | 2011-08-17 00:00:00 | 8
Project1 | [NAME] | 2011-08-17 00:00:00 | 10
Project2 | [NAME] | 2011-08-17 00:00:00 | 12
Project1 | [NAME] | 2011-08-17 00:00:00 | 10
Project2 | [NAME] | 2011-08-17 00:00:00 | 14
Project1 | [NAME] | 2011-08-18 00:00:00 | 6
Project1 | [NAME] | 2011-08-18 00:00:00 | 9
Project2 | [NAME] | 2011-08-18 00:00:00 | 7
Project1 | [NAME] | 2011-08-18 00:00:00 | 10
Project2 | [NAME] | 2011-08-18 00:00:00 | 12
Spreadsheet: 795107d1662520115-filter-to-match-up-range-and-spill-data-in-range-array-filter-test-t1-
Sheet: LAX

 |  | Matching Column |  | Extract 1 |  |  |  |  |  | Extract 2 |  |  |  |  |  | Extract 3 | Extract 4
 |  |  | papa [NAME] (618506401) | 0 | 186428.8 | 255395 | -68966.2 |  |  |  | aa | cc |  |  |  | 65
 |  |  | Kapish Trading,USA (115942707) | 160592.78 | 0 | 0 | 160592.78 |  |  |  | dd | ee |  |  |  |  | 95
 |  |  | Aakash Foods Products,Canada (302987641) | 77439.32 | 532507.73 | 384449.43 | 225497.62 |  |  |  | ff | gg |  |  |  | 63 | 99
 |  |  | Jamesh & Beverage Ind. (300669661) | 0 | 1250150.75 | 1250150.75 | 0 |  |  |  | hh | ii |  |  |  | 446
 |  |  | Lotus ShapeUdhyog (300496383) | 952813.58 | 1603397.76 | 1645894 | 910317.34 |  |  |  | jj | kk
Spreadsheet: 768327d1644928415-geomean-with-if-condition-geomean
Sheet: Sheet1

 |  |  |  |  | Category | Price | Version
 |  |  |  |  | A | 45 | N
 |  |  |  |  | A | 25 | N
 |  |  |  |  | A | 50 | Y
 |  |  |  |  | A | 4 | N
 |  |  |  |  | B | 545 | N
 |  |  |  |  | B | 52 | Y
 |  |  |  |  | B | 2 | Y
 |  |  |  |  | C | 21 | N
 |  |  |  |  | C | 21 | N
 |  |  |  |  | C | 4 | Y
 |  |  |  |  | D | 8 | Y
 |  |  |  |  | Geomean of price by product for version Y
 |  |  |  |  | A
 |  |  |  |  | B
 |  |  |  |  | C
 |  |  |  |  | D
Spreadsheet: 65863d1266507069-index-match-elec-toolkit-v10
Sheet: Motor-Cables

 |  |  |  |  |  |  |  |  |  |  | No. Motor Poles | 4
 |  |  |  |  |  |  |  |  |  |  | Motor Speed | 1500 | rpm
 | Supply Voltage | 400 | V |  |  |  | Voltage | 230 | V
 | Type | 3Ph |  |  |  |  | Type | 1Ph + N
 | Starter Type | DOL |  |  |  |  | Power | 0.25 | KW
 | CPD | BS88 |  |  |  |  | Current |  | A |  | Flow | 18.5 | l/s
 | Motor Power | 41 | KW |  |  |  | Power Factor | 0.9 | Manually Entered |  | Head | 15 | m
 | FL Current |  | A |  |  |  | Motor Efficiency | 1 | Manually Entered |  | Pump Effy | 75 | %
 | Power Factor | 0.9 |  |  |  |  | Apparent Power | 0.2777777777777778 | KVA |  | Motor Effy | 85 | %
 | Motor Efficiency | 92.5 | % |  |  |  | Current = | 1.207729468599034 | Amps |  | Power at Shaft | 3.6284605 | KW
 | Apparent Power | 45.55555555555556 | KVA |  |  |  |  |  |  |  | Power at Motor | 4.268777058823529 | KW
 | Motor Torque | 261.0333333333334 | Nm
 | CPD Rating (ln) | 125 | A
 | FL Current | 71.08516827860257 | Amps
 |  |  |  |  | 3 Ph Motor Details In Use
 |  |  |  |  |  |  |  |  |  | Cable Size |  | mm2
 |  |  |  |  |  |  |  |  |  | Cable Makeup | b
 |  |  |  | Supply Voltage | 400 | V | Length of cable | 100 | m | Cable Rating (lt) |  | A
 |  |  |  | Design Current Ib | 71.08516827860257 | A | Permissible Volt Drop | 5 | % | Min. Cable Capacity (lz) |  | A
 |  |  |  | Type | 3Ph |  | [NAME] | 2.813526433758225 | mV/a/m | Sep. [NAME] |  | mm2
 |  |  |  | Type of Cable | Single-core 70°C thermoplastic non-arm Cu Table 4D1 |  |  |  |  | Device (ln/lr) | 125 | A
 |  |  |  | Instalation Method Selection (Step 1) | In conduit |  |  |  |  | Voltage Drop |  | V
 |  |  |  | Instalation Method Selection (Step 2) | 1 - In conduit in a thermally insulated wall |  | Single or [NAME] | Single |  | [NAME] for Voltage Drop |  | m
 |  |  |  | Configuration | Not Applicable |  |  |  |  | Zs at Load End |  | Ω
 |  |  |  |  |  |  |  |  |  | [NAME] |  | Ω
 |  |  |  | Ambient/ground temperature oC | 30 | oC |  |  |  | Earth Fault Current |  | KA
 |  |  |  | Thermal insulation rating factor ([NAME]) | 0.8 |  |  |  |  | Earth Fault Discon. Time |  | s
 |  |  |  | CPD/installation condition rating factor (Cc) | 0.725 |  |  |  |  | Min. Phase Fault Current |  | KA
 |  |  |  |  |  |  |  |  |  | PSCC |  | KA
 |  |  |  |  |  |  |  |  |  | Icu |  | KA
 |  |  |  |  |  |  | Ambient/ground temperature rating factor (Ca) | 1 | Tables 4B1 - 4B2
 |  |  |  |  |  |  | Thermal insulation rating factor ([NAME]) | 0.8
 |  |  |  |  |  |  | CPD/installation condition rating factor (Cc) | 0.725
Spreadsheet: john_griffith__16087__1_17_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 53 | 340 | 440 | 46.3 | 60 | 1.77 | 2002-01-17 13:41:00
 | [NAME] | 55 | 675 | 775 | 47.3 | 54.3 | 1.76 | 2002-01-17 13:41:00
 | [NAME] | 62 | 980 | 1080 | 46.6 | 51.4 | 1.91 | 2002-01-17 13:41:00
 | [NAME] | 63 | 1130 | 1230 | 43.9 | 47.8 | 1.82 | 2002-01-17 13:41:00
 | [NAME] | 63 | 1290 | 1390 | 43.6 | 47 | 1.79 | 2002-01-17 13:41:00
 | HU N2 | 64 | 1350 | 1450 | 40.9 | 43.9 | 1.71 | 2002-01-17 13:41:00
 | [NAME] | 63 | 1400 | 1500 | 39.6 | 42.4 | 1.62 | 2002-01-17 13:41:00
 | HU U2 | 61 | 1400 | 1530 | 38 | 41.5 | 1.52 | 2002-01-17 13:41:00
 | [NAME] | 58 | 1375 | 1500 | 37 | 40.4 | 1.41 | 2002-01-17 13:41:00
 | [NAME] |  |  |  | 34 | 37.8 | 1.31 | 2002-01-15 14:58:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 462755d1464180226-icon-sets-to-compare-to-numbers-in-cells-icon-sets-to-compare-2-cells
Sheet: Sheet1

 |  |  |  | year 1 | this column will be closed to only show the arrows | year 2
 |  |  |  | 1 |  | 2
 |  |  |  | 2 |  | 1
 |  |  |  | 3 |  | 4
 |  |  |  | 3 |  | 2
 |  |  |  | 4 |  | 8
 |  |  |  | 5 |  | 9
 |  |  |  | 9 |  | 1
Spreadsheet: 215656d1361447077-search-a-list-of-names-and-automatically-return-any-names-not-already-included-in-table-unique-items
Sheet: Sheet1

BREAKDOWN OF SALES DAY BOOK - Customer A
Product A
Date | Invoice Number | Customer | Net Sales | Cases Sold | Average Selling Price |  | Cost Per Case | MAM | MAM % |  | Carriage Costs |  |  | 0
2013-01-02 00:00:00 | 332352 | [NAME] | 100
2013-01-02 00:00:00 | 332353 | [NAME] | 100
2013-01-03 00:00:00 | 332364 | Hayley | 300
2013-01-03 00:00:00 | 332365 | [NAME] | 200
 |  | Total |  |  |  |  | 3.35
Product B
Date | Invoice Number | Customer | Net Sales | Cases Sold | Average Selling Price |  | Cost Per Case | MAM | MAM % |  | Carriage Costs |  | NEED TO INCLUDE SOME KIND OF FORUMLA IN THE TABLE TO LOOKUP THE ENTIRE C:C COLUMN
2013-01-02 00:00:00 | 332352 | [NAME] | 250 |  |  |  |  |  |  |  |  |  | FOR ANY NEW CUSTOMER NAMES THAT ARENT IN THE TABLE AND INSERT THIS INTO THE ABOVE TABLE
2013-01-02 00:00:00 | 332353 | [NAME] | 100
2013-01-03 00:00:00 | 332364 | [NAME] | 150
2013-01-03 00:00:00 | 332365 | [NAME] | 50
 |  | Total |  |  |  |  | 2.39
Product C
Date | Invoice Number | Customer | Net Sales | Cases Sold | Average Selling Price |  | Cost Per Case | MAM | MAM % |  | Carriage Costs |  |  |  | Name
2013-01-02 00:00:00 | 332353 | [NAME] | 110 |  |  |  |  |  |  |  |  |  | A
2013-01-03 00:00:00 | 332364 | [NAME] | 125 |  |  |  |  |  |  |  |  |  | B
2013-01-03 00:00:00 | 332365 | [NAME] | 150 |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  | Total |  |  |  |  | 2.52
Spreadsheet: 480877d1474121333-would-like-help-to-create-a-sales-spreadsheet-quote
Sheet: Sheet1

 | RRP | 19995 |  | This is free text entry. No formulas required
 | Delivery | 495 |  | Free text entry. No formulas required
 | [NAME] | 1000 |  | Free text entry. No formulas required
 | Total |  |  | This cell should calculate b3, b4 & b5
 | Px SIV | 10000 |  | Free text entry, No formulas required
 | Discount | 1000
 | Total Allowance |  |  | C8+C9
 | Balance |  |  | C6-C10
 | Margin | 0.15 |  | Free text entry
 | Charges | 150 |  | Free text entry
 | Profit |  |  | [NAME] required
Spreadsheet: 0a81487c-a7b1-4a36-9321-419de9ffd87d
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
DSP | Test | DSP | Disopyramide, Serum | Disopyramide, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Therapeutic: 2.0-5.0 mcg/mL Toxic: > or =7.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80299 |  |  |  |  | Rochester
DSP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
DSP | Result | 8220 | Disopyramide, S | Disopyramide, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3576-6 | Disopyramide:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 217255d1362018608-help-with-payment-file-payment-file-2
Sheet: Sheet1

Tickets Price : | 55
Tickets | payment type | amount | fees | total
2 | paypal | 110 | 3.22 | 106.78
2 | gift | 110 | 0 | 110
tickets | payment type | amount | fees | total
1 | paypal | 55 | 1.895 | 53.105
2 | paypal | 110 | 3.49 | 106.51
2 | gift | 110 | 0 | 110
1 | gift | 55 | 0 | 55
 |  | 0 | 0 | 0
 |  | 0 | 0 | 0
Totals |  | 330 | 5.385 | 324.615
Spreadsheet: 30106d1225404419-use-a-selection-from-a-list-box-to-display-a-range-cascading-validation-lookup
Sheet: Sheet1

 |  | [NAME] | Select Product | Select Feature
 |  | Data validation with  Manufacturers | Data validation with secondList | Data validdation with thirdList
Data entry here >>>>> |  | Bravo | Bravotwo | Feature B2 2
 |  | Range Name "secondList" is dynamically assigned the name in C3
 |  | Range Name "thirdList" is dynamically assigned the name in D3
 |  | Manufacturers | Product lists per Manufacturer
 |  | Alpha | Alpha | Bravo | [NAME] | Delta
 |  | Bravo | Alphaone | Bravoone | Charlieone | Deltaone
 |  | [NAME] | Alphatwo | Bravotwo | Charlietwo | Deltatwo
 |  | Delta | [NAME] | Bravothree |  | Deltathree
 |  |  | Alphafour |  |  | Deltafour
 |  |  | Features lists
 |  |  | Alphaone | Bravoone | Charlieone | Deltaone
 |  |  | Feature Alphaone1 | Feature bravo1 1 | C1 feature 1 | D1 F1
 |  |  | Feature Alphaone2 | Feature bravo1 2 | C1 feature 2 | D1 F2
 |  |  | Feature Alphaone3 | Feature bravo1 3 | C1 feature 3 | D1 F3
 |  |  |  | Feature bravo1 4 |  | D1 F4
 |  |  | Alphatwo | Bravotwo | Charlietwo | Deltatwo
 |  |  | [NAME] | Feature B2 1 | Charlie2 feature 1 | [NAME]
 |  |  | [NAME] | Feature B2 2 | Charlie2 feature 2 | [NAME]
 |  |  | [NAME] | Feature B2 3 | Charlie2 feature 3 | [NAME]
 |  |  | [NAME] | Feature B2 4 | Charlie2 feature 4 | [NAME]
 |  |  |  | Feature B2 5 |  | [NAME]
 |  |  | [NAME] | Bravothree |  | Deltathree
 |  |  | Feature Alphathree 1 | Feature Brav3 1 |  | D3 Feature 1
 |  |  | Feature Alphathree 2 | Feature Brav3 2 |  | D3 Feature 2
 |  |  | Feature Alphathree 3 | Feature Brav3 3 |  | D3 Feature 3
 |  |  | Feature Alphathree 4 | Feature Brav3 4
 |  |  |  |  |  | Deltafour
 |  |  |  |  |  | Deltafour F1
 |  |  |  |  |  | Deltafour F2
 |  |  |  |  |  | Deltafour F3
 |  |  |  |  |  | [NAME]
Spreadsheet: 66915d1267593638-second-sheet-data-adjust-according-to-first-sheet-order-plan-new
Sheet: Order In

ORDER IN-FLOW
DATE | 40/2 | 40/3 | 20/2 | 20/3 | 60/3 | 60/2 | 50/2 | 12/2 | 16/3 | 20/4 | 12/3 | 12/5 | 45/2pp | 40/2pp | 29/3pp | 29/2pp | 60/2pp | 16/2pp | 12/2pp | 16/3pp | 16/4pp | 13/4pp | 29/2CP | 29/3CP | 16/2CP | 12/2CP | 16/3CP | 18/4CP | 16/4CP | 13/4CP | TP150D | TP300D | 70/2 cot | 20/6 cot | 30/2 cot | LFP135 | LFP90/100 | LFP60 | [NAME] | TOTAL
02.03.10 | 1162.5 | 0 | 909 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 636 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2707.5
03.03.10
04.03.10
05.03.10
06.03.10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL | 1162.5 | 0 | 909 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 636 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2707.5
% | 42.93628808864266 | 0 | 33.57340720221607 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23.49030470914127 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0