tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 113823d1309706258-pull-column-from-one-sheet-to-another-affiliated-new-order-book
Sheet: Cleaner Isle

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
0 | 31780 | 0-37000-27788 | TIDE ULT PWD 80 LD | 77.04 | 0.25 |  | 4
0 | 33557 | 0-19200-02845 | LYSOL DISINFECT SPRAY SPR |  | 0.25
 |  |  | Bounce
 |  |  | Biz Stain Fighter
 |  |  | Dove White Soap
 |  |  | [NAME] [NAME]
 |  |  | Tide 40 load
 |  |  | Tide 14 load
 |  |  | Woolite Fabric Wash
 |  |  | [NAME]
 |  |  | Clorex Regular
 |  |  | Windex
 |  |  | Windex Refill
 |  |  | Shout Triple-Acting
 |  |  | Clorex Cleaner Orginal Bottle
 |  |  | Clorex Orginal Spray
 |  |  | Clorex Regular
 |  |  | 401 All Purpose [NAME] Can
 |  |  | Lime A Way
 |  |  | Wet Wipes Extra Gentle
 |  |  | Lime A Way Advanced Form Spray Can
 |  |  | Febreeze Extra Strength
 |  |  | Staflo Liquid Starch
 |  |  | Spray Starch Power X
 |  |  | Lyson Power Toilet Bowl Cleaners
 |  |  | Pinesol Orginal
 |  |  | Johnson Scrubbing Bubbles Bathroom Cleaner
 |  |  | Easy Off Heavy Duty [NAME]
 |  |  | Comet With Bleach
 |  |  | Murphy Oil Soap Orginal Formula
 |  |  | Parsons For Kitchen and Bathroom
 |  |  | Favor High [NAME]
 |  |  | Backwoods Cutter Water Resistant
 |  |  | [NAME] Indoor Outdoor
 |  |  | D-Con Kills Mice
Spreadsheet: 158231d1338078230-data-validation-optional-display-book1
Sheet: Sheet1

 | PC | STATUS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PC | STATUS |  | PC_Available
 | pc2 | complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | process |  | pc2
 | pc3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pc2 | complete | 3 | pc3
 | pc2 | complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pc3 |  | 4 | pc5
 | pc4 | process |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pc4 | process
 | pc3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pc5 |  | 6
Spreadsheet: 679255d1590286218-conditional-formatting-depending-on-the-day-of-the-week-conditional-formating-1
Sheet: Sheet1

Saturday |  | Day List |  | Steps to follow up
 |  | Monday | 1 | Conditional Formating
 |  | Tuesday | 2 | New Rule
 |  | Wednesday | 3 | Use a formula to determine which cells to format
 |  | Thursday | 4 | The [NAME] is =A$1="Monday"
 |  | Friday | 5 | Set the Format
 |  | Saturday | 6 | Manage Rules
 |  | Sunday | 7 | Make sure that the formula is aplied as =$[NAME]
 |  |  |  | For Each coloumn do the same
Spreadsheet: 138658d1327788795-win-and-loss-streak-basketball
Sheet: Boxscores

GAME 1 |  | 2011-12-26 00:00:00
Legends | VS | A & T |  | Pistols | VS | C-Ment |  | W Relo | VS | Slump B |  | C Time | VS | Stilts
rose | 13 | Kobe | 29 |  | 25
Dirk | 22 | Gasol | 15 |  | 16
AI | 20 | Gallinari | 15 |  | 20
Thorton | 27 | [NAME] | 27 |  | 13 |  | 75 |  | 84 |  | 74 |  | 99 |  | 75
Varajeao | 14 | Dudlry | 9 |  | 24
 | 96 |  | 95 |  | 98 |  | 75 |  | 84 |  | 74 |  | 99 |  | 75
GAME 2 |  | 2011-12-28 00:00:00
Pistols | VS | Legends |  | A & T | VS | C-Ment |  | W Relo | VS | Stilts |  | C Time | VS | Slump B
 | 81 |  | 85 |  | 62 |  | 90 |  | 110 |  | 81 |  | 68 |  | 66
 | 81 |  | 85 |  | 62 |  | 90 |  | 110 |  | 81 |  | 68 |  | 66
GAME 3 |  | 2011-12-30 00:00:00
Legends | VS | C-Ment |  | A & T | VS | Stilts |  | W Relo | VS | C Time |  | Pistols | VS | Slump B
 | 98 |  | 60 |  | 60 |  | 80
 |  |  |  |  |  |  |  |  | 93 |  | 87 |  | 90 |  | 58
 | 98 |  | 60 |  | 60 |  | 80 |  | 93 |  | 87 |  | 90 |  | 58
GAME 4 |  | 2011-01-01 00:00:00
Pistols | VS | Stilts |  | A & T | VS | Slump B |  | W Relo | VS | Legends |  | C Time | VS | C-Ment
 | 102
 |  |  | 67 |  | 85 |  | 63 |  | 93 |  | 101 |  | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 | 102 |  | 67 |  | 85 |  | 63 |  | 93 |  | 101 |  | 56 |  | 30
GAME 5 |  | 2011-01-02 00:00:00
C-Ment | VS | Stilts |  | Legends | VS | Slump B |  | W Relo | VS | A & T |  | C Time | VS | Pistols
 |  |  |  |  |  |  |  |  |  |  |  |  | 90
 | 83 |  | 50 |  | 81 |  | 55 |  | 117
 |  |  |  |  |  |  |  |  |  |  | 69 |  |  |  | 81
 | 83 |  | 50 |  | 81 |  | 55 |  | 117 |  | 69 |  | 90 |  | 81
GAME 6 |  | 2011-01-04 00:00:00
A & T | VS | Pistols |  | Stilts | VS | Slump B |  | W Relo | VS | C-Ment |  | C Time | VS | Legends
 | 65 |  |  |  |  |  | 80 |  |  |  | 93 |  |  |  | 88
 |  |  | 70 |  | 86 |  |  |  | 116 |  |  |  | 108
 | 65 |  | 70 |  | 86 |  | 80 |  | 116 |  | 93 |  | 108 |  | 88
GAME 7 |  | 2011-01-06 00:00:00
Legends | VS | Stilts |  | C-Ment | VS | Slump B |  | W Relo | VS | Pistols |  | C Time | VS | A & T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 39
 | 54 |  | 67 |  | 89 |  | 65 |  | 98 |  | 88 |  | 95 |  | 45
 | 54 |  | 67 |  | 89 |  | 65 |  | 98 |  | 88 |  | 113 |  | 101
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 11b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 164 | 273 | 33 | 175 | 75 | 40 | 57 | 817
Cross-Currency Fixed-Fixed | 8 | 18 | - | 3 | 2 | 5 | 27 | 63
Cross-Currency Fixed-Float | 2 | 46 | - | 5 | 9 | 2 | 644 | 708
TOTAL | 174 | 337 | 33 | 183 | 86 | 47 | 728 | 1588
Spreadsheet: benjamin_rogers__1244__Simple Cycle (LM6000) Entergy model
Sheet: Cost Details

 |  |  | Simple Cycle Configuration
 | Turbines
 | MW's
 |  |  | (000's)
 | Project Management:
 | Home Office |  | 720.804
 | Salaried Staff |  | 947.891
 | [NAME] Staff |  | 218.756
 | Indirect Costs:
 | Equipment Costs |  | 635.659
 | Small Tools |  | 254.504
 | Indirect Labor |  | 262.371
 | GC Other |  | 893.72
 | per diems |  | 562.5
 | Tax/bond |  | 6.75
 | Engineering:
 | Engr. Labor |  | 713.243
 | Procurement:
 | Major Equipment
 | CTG's |  | 86040
 | CTG Freight |  | 600
 | Inlet air heating |  | 0
 | Duel Fuel |  | 1680
 | SCR's |  | 0
 | STG - 75 MW |  | 0
 | Engineered Equipment
 | Buildings |  | 393.75
 | Valves and specials |  | 384.429
 | Bus Duct |  | 225
 | Dry Transformers |  | 16.794
 | Step-up transformers |  | 2154
 | Power Dist. Xformers |  | 841.032
 | 600V MCC |  | 94.842
 | 600V [NAME] |  | 94.167
 | 5kV swgr |  | 185.634
 | 15kV swgr |  | 1260.048
 | Control Panel |  | 326.62
 | HV Device |  | 46.245
 | DCS |  | 305.55
 | UPS |  | 25.974
 | [NAME]. Mntd [NAME]. |  | 109.94
 | CEMS |  | 0
 | Control Valves |  | 68.875
 | Pumps |  | 271.665
 | [NAME] |  | 0
 | Fin Fan Coolers |  | 0
 | APC equipment |  | 0
 | Gas Compression |  | 2120
 | Fuel Gas Filter |  | 168
 | Chillers |  | 4600
 | Water Treatment |  | 548.1
 | Oil/Water Seperator |  | 82.35
 | Vender Reps |  | 364.75
 | Tank Farm/Oil Filter |  | 2250
 | FLD/shop vessels |  | 532.5
 | Other |  | 566.544
 | Bulk Material |  | 5044.243
 | Construction
 | site |  | 910.904
 | u/g electrical |  | 657.63
 | u/g piping |  | 445.017
 | concrete |  | 1129.472
 | grout |  | 58.075
 | steel |  | 62.727
 | architectual |  | 3.814
 | buildings |  | 157.55
 | a/g piping |  | 1074.572
 | a/g eletrical |  | 1086.685
 | instrumentation |  | 201.616
 | insulation |  | 205.509
 | painting |  | 26.272
 | mech. Equipment |  | 907.944
 | Startup
 | startup |  | 759.528
 | oper training |  | 12.5
 | initial fill/spares |  | 123.25
 | manuels |  | 40.6
 | startup support |  | 112.018
 | Warranty |  | 43.75
 | Owner Adds
 | sales and Used Tax |  | 0
 | SCR air attemperation |  | 0
 | Remote control |  | 0
 | ENA Remote Monitoring |  | 172.7
 | [NAME] |  | 7500
 | Transmission lines |  | 1500
 | Gas Line |  | 1400
 | [NAME] |  | 600
 | Builders Risk |  | 0
 | Subtotal Costs
 | Fixed G&A |  | 2716.188
 | Total Costs
 | Contingency |  | 2770.511
 | Margin |  | 8311.534
 | Total EPC
Spreadsheet: 48ac6137-d133-44a3-8366-3fd04de4f5a5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2855 | 15664 | [NAME] | Toepel | USA | 0 | 00:45:10 | [NAME] | 01:31:19 | 00:03:23 | 00:01:01 | 1 | 03:23:02
2855 | 15665 | [NAME] | Iverson | USA | 0 | 00:52:28 | 00:04:02 | 01:31:38 | 00:04:08 | 00:01:01 | 2 | 03:34:03
2855 | 8172 | [NAME] | Ridgway | USA | 0 | 00:44:58 | 00:00:48 | [NAME] | 00:02:41 | 00:00:00 | DNF | 00:00:00
2855 | 15666 | Tove | Shere | USA | 0 | 00:57:12 | 00:03:10 | 01:16:48 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 0b1934fd-3de1-4b44-b74f-f2f71aff8db6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40154978 | 2014-02-21 00:40:40 | ALLIES | 1 | 6 | 3 | 1527880 | player1527880 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40168902 | 2014-02-21 22:41:32 | AXIS | 1 | 6 | 3 | 62247 | niko the great | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
40169365 | 2014-02-21 23:02:51 | ALLIES | 1 | 6 | 4 | 62247 | niko the great | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
40403371 | 2014-03-07 22:06:53 | AXIS | 0 | 5 | 6 | 1530567 | tommikins | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
40403761 | 2014-03-07 22:25:25 | ALLIES | 0 | 4 | 6 | 1530567 | tommikins | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: 31863d1227847478-aging-report-sample-aging-report
Sheet: Sheet1

 |  |  | Service Dt. |  | Charge | WrtDwm | InsPaid | PatPaid | Adjust | Open
 |  |  |  |  | 3533.32 | 0 | 0 | 0 | 0 | 3533.32
 |  |  | 0-30 | 31-60 | 61-90 | 0ver 120 +
Total |  |  | $ | $ | $ | $
[NAME] |  |  |  |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-06 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-07 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-08 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-09 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-10 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-11 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-12 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-13 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-14 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-15 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-16 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-17 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-18 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
 |  |  | 2008-11-19 00:00:00 |  | 252.38 | 0 | 0 | 0 | 0 | 252.38
Spreadsheet: 858801d1707339966-how-to-analyze-survey-text-data-multiple-answers-are-selected-expected-outcomeupdated
Sheet: Sheet1

Name | department | study IDs
[NAME] | Department Urology | 2022-0234
[NAME] | Department Cardiovascular | 123-4567
[NAME] | Department Cardiovascular | 3456-1234
[NAME] | Department Cardiovascular | 2020-1090
Mandy | Department Cardiovascular | 2020-0444
Mandy | Department Cardiovascular | 2020-0472
Mandy | Department Cardiovascular | 2023-1001
[NAME] | Department Cardiovascular
[NAME] | Department Myloma | 2022-0111
[NAME] | Department Myloma | 2023-0444
[NAME] | Department Myloma | 2019-0335
Celine | Department Lymphoma | 2024-2024
Celine | Department Investigational | 2019-0001
Celine | Department Investigational | nci0923434
Celine | Department Investigational | alliance000114
Spreadsheet: 23ad3d65-ee7b-46ca-a363-1d95f3759edd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: April 19, 2014 (10:56 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
2013 | 306040 | 313234 | 314646 | 340037
Spreadsheet: 707715d1607429874-help-calculating-figures-using-multiple-arguments-excel-formula-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2020-12-08 00:00:00 | 2020-12-09 00:00:00 | 2020-12-10 00:00:00 | 2020-12-11 00:00:00 | 2020-12-12 00:00:00 | 2020-12-13 00:00:00 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00
 |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday
 |  | Code |  | Rev | Cost
 |  | 1 |  | 10 | 5 |  |  | 1 | 2 |  |  | 6 | 6 | 6
 |  | 2 |  | 10 | 5 |  |  |  | 3 |  |  |  |  | 5
 |  | 1 |  | 10 | 5 |  |  |  | 4 | 5 | 5
 |  | 2 |  | 10 | 5 |  |  |  |  |  | 6 |  |  |  | 4 |  | 4
 |  | 1 |  | 10 | 5 |  |  |  | 3 | 3 | 3
 |  | 2 |  | 10 | 5 |  |  |  | 3
 |  | 1 |  | 10 | 5 |  |  | 2 | 3
 |  | 2 |  | 10 | 5 |  |  |  |  | 3
 |  | 1 |  | 10 | 5 |  |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  | 2 |  | 10 | 5 |  |  |  |  |  |  |  |  | 3 | 3 | 3
 |  | 1 |  | 10 | 5 |  |  |  | 6 | 6 | 5 | 4 | 4 | 3
 |  |  |  |  |  | Code 1 | Rev
 |  |  |  |  |  | Code 1 | Cost
Spreadsheet: 149085d1333686284-formula-to-extracting-columns-values-which-fulfills-criteria-of-other-columns-howto_auto2
Sheet: TODO

 | Service attributes
 | payment | registration | pass. reset | cloud | marketing | advertisement | SSO
Must | 1 | 1 | 1 | 0 | 0 | 1 | 0 |  |  |  |  |  | payment | registration | pass. reset |  |  | advertisement
Should | 1 | 0 | 0 | 1 | 1 | 0 | 0 |  |  |  |  |  | payment |  |  | cloud | marketing
Optional | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  | SSO
 | Must | payment,registration,pass. reset,,,advertisement,,,,,,
 | Should | payment,,,cloud,marketing,,,,,,,
 | Optional | ,,,,,,SSO,,,,,
Spreadsheet: ada6062b-c14d-4ab1-88f0-05cd1919433f
Sheet: North, Vista Annex

ATTACHMENT 9 PRICE SCHEDULE
NORTH COUNTY ANNEX
 | Service address:
 | North County Division
 | 325 South Melrose Drive, Annex
 | Vista, CA 92081
 | MODEL | SERIAL # | [NAME] ID# | OLD ID # | PRICE Base Year | PRICE Year 1 | PRICE Year 2 | PRICE Year 3 | PRICE Year 4
1 | [NAME] | 349039 | 2034 | 91466
2 | [NAME] | 874788DI | 2035 | 93244
3 | [NAME] | 874960LI | 2036 | 93243
4 | [NAME] | 874966LI | 2050 | 93245
5 | WIDMER T-3 | 256305 | 3621 | N/A
 |  |  | TOTAL *
 |  |  | * transfer these totals to summary sheet
Spreadsheet: 328529d1403937770-formula-to-sum-by-month-and-financial-year-sum-by-mth-and-financial-year
Sheet: Jan to Dec

If your Financial Year is From Jan to Dec
Year | SubTotal by FinYear Prod1 | SubTotal by FinYear Prod2 | SubTotal by FinYear Prod3 | SubTotal by FinYear Prod4 | Total by FinYear |  | Monthly Total by Fin. Year Across All Products | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
12/13
13/14 | 3137.5 | 900 | 2876 | 1935
1. [NAME] for calculating given income for given month in financial year across all products.
2. [NAME] for calculating given income for given financial year for given product.
In | Prod1 | Prod2 | Prod3 | Prod4
2012-08-01 00:00:00 |  |  | 1760 | 720
2012-11-03 00:00:00 |  | 300 |  | 720
2012-05-05 00:00:00 | 200 |  | 1760
2013-07-02 00:00:00 |  |  |  | 425
2013-09-14 00:00:00 | 2337.5
2014-02-25 00:00:00 |  |  | 1760 | 720
2014-06-02 00:00:00 |  | 550
2014-12-25 00:00:00 |  |  |  | 240
2014-01-02 00:00:00 |  |  | 1116
2014-02-25 00:00:00 | 800
2014-06-02 00:00:00 |  | 350 |  | 550
Spreadsheet: 802869d1667111429-a-formula-to-help-with-a-cumulative-sum-question-hopefully-help-4-
Sheet: Sheet1

 | Employee: | [NAME]
 | Position: | Team 1
 | Entity: | UK
 | Mth Target: | 50000
 | Promotion Target: | 300000
 | Last Promotion: | 2022-05-01 00:00:00
 | BEFORE
 | Period | Monthly Sales | 5 month rolling sales | Simple IF formula
 | 2021-01-01 00:00:00 | 10000
 | 2021-02-01 00:00:00 | 20000
 | 2021-03-01 00:00:00 | 30000
 | 2021-04-01 00:00:00 | 0
 | 2021-05-01 00:00:00 | 0
 | 2021-06-01 00:00:00 | 15000
 | 2021-07-01 00:00:00 | 25000
 | 2021-08-01 00:00:00 | 35000
 | 2021-09-01 00:00:00 | 45000
 | 2021-10-01 00:00:00 | 50000
 | 2021-11-01 00:00:00 | 0
 | 2021-12-01 00:00:00 | 0
 | 2022-01-01 00:00:00 | 50000
 | 2022-02-01 00:00:00 | 120000
 | 2022-03-01 00:00:00 | 65000
 | 2022-04-01 00:00:00 | 100000
 | 2022-05-01 00:00:00 | 0 |  |  |  | What I would like to do, is if cell [NAME] is equal to cell C29, then I do not want the 5month rolling sales to continue.
 | 2022-06-01 00:00:00 | 15000 |  |  |  | I would like it "reset" to zero again, and does not take the previous 4 months any more, and start a new 5 month rolling calculation (see "after" table)
 | 2022-07-01 00:00:00 | 25000
 | 2022-08-01 00:00:00 | 0
 | 2022-09-01 00:00:00 | 0
 | 2022-10-01 00:00:00 | 0
 | 2022-11-01 00:00:00 | 0
 | 2022-12-01 00:00:00 | 0
 | AFTER
 | Period | Monthly Sales | 5 month rolling sales | Simple IF formula
 | 2021-01-01 00:00:00 | 10000
 | 2021-02-01 00:00:00 | 20000
 | 2021-03-01 00:00:00 | 30000
 | 2021-04-01 00:00:00 | 0
 | 2021-05-01 00:00:00 | 0
 | 2021-06-01 00:00:00 | 15000
 | 2021-07-01 00:00:00 | 25000
 | 2021-08-01 00:00:00 | 35000
 | 2021-09-01 00:00:00 | 45000
 | 2021-10-01 00:00:00 | 50000
 | 2021-11-01 00:00:00 | 0
 | 2021-12-01 00:00:00 | 0
 | 2022-01-01 00:00:00 | 50000
 | 2022-02-01 00:00:00 | 120000
 | 2022-03-01 00:00:00 | 65000
 | 2022-04-01 00:00:00 | 100000
 | 2022-05-01 00:00:00 | 0 | 0
 | 2022-06-01 00:00:00 | 15000
 | 2022-07-01 00:00:00 | 25000
 | 2022-08-01 00:00:00 | 40000
 | 2022-09-01 00:00:00 | 60000
 | 2022-10-01 00:00:00 | 70000
 | 2022-11-01 00:00:00 | 80000
 | 2022-12-01 00:00:00 | 145000
Spreadsheet: 344c93da-12a0-4542-b007-51b3678eebfe
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
IODU | Test | IODU | Iodine, Random, Urine | Iodine, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME]: NO Metal cap or glued insert |  |  | 1 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 1 mL	 Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 26-705 mcg/L | Monday, Tuesday, Wednesday, Friday; 5 p.m. | 1 day | 3 days | 1 | 83018 |  |  |  |  | Rochester
IODU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 146 days
IODU | Result | 8639 | Iodine, Random, U | Iodine, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 2495-0 | Iodine:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 805594d1668784458-how-to-extract-multiple-certain-text-value-from-the-long-concatenated-text-value-excel-forum-help-needed__extract-text-from-concat-text-value-2-
Sheet: Extraction List

[NAME] | Clubbed Location | RSE | RSO | ARM | ASM | SIM
Global System(Pali) | Pali | Pradhyuman Chawla-05857 | Paramveer Singh-05086 | Ramesh Kumar-00286 | Vikash Tiwari-01984 | Siddharth Jain-09113
[NAME] ([NAME]) | [NAME] | Rahul Singh-10736 | [NAME] | Ashish Chauhan-91107 | [NAME] | Pranav Jain-09237
Gaurav Marketing (Sirohi) | Sirohi | Manu Deep Purohit-06041 | Harbant Singh-02413 | - | - | [NAME]
[NAME] (Jaisalmer) | [NAME] | [NAME] | Mayur Sain-02466 |  |  | Lokesh Vyas-08831
Adarsh [NAME] (Jalore) | Jalore | [NAME] | Piyush Jangid-05448 |  |  | -
[NAME] (Jodhpur) | Jodhpur 1 | Sandeep Acharya-10351 | Ajay Kumar Joshi-03885
[NAME] (Osian) | Jodhpur 3 | Bharat Kumar-10155 | Namit Sharma-08231
Jeevan Telecommunication Private Limited | [NAME] | Devesh Sankhla-09928 | -
[NAME] (Balotra) | Phalodi | Dhruv Rajpurohit-10222
Sivmor Gadgets Pvt Ltd | Sanchor | Kamal Daswani-10252
Fair Deal (Jodhpur-3) |  | Varun [NAME]
Sohan Communication Private Limited (Jodhpur-4) |  | Jayesh Gehlot-05377
Matoshree (Phalodi) |  | TBA (J-3)
[NAME] (Sanchor) |  | Girish Sakhrani-09115
Sansker Video Gallery (Bali) |  | Shrikant Bissa-10353
New Spice Solutions Private Limited (Smart Dukaan) |  | Himanshu pandey-09973
Vinayak Enterprises (Sirohi) |  | Praveen Sharma-07989
 |  | Ishwar Das Vaishnav-01737
 |  | Ibrahim Khayyat-10239
 |  | Pankaj-09683
 |  | Naveen Verma-03892
 |  | Ashish Harsh-04978
 |  | [NAME]
 |  | Imran Khan-10054
 |  | Yudhishthir Rathi-02961
 |  | MohitKumar-04508
Spreadsheet: 858955d1707423873-formula-to-get-shifts-from-a-difrent-tab-where-to-look-at-name-and-date-sheet-1-1-
Sheet: Rota

 |  |  | If names are in different order than on SHIFT tab then use this formula
 |  |  |  | 2024-01-15 00:00:00
 |  |  | Scot
 |  |  | Eve
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | IF names are in same order as they are in SHIFTS tab then you can use this formula
 |  |  |  | 2024-01-15 00:00:00
 |  |  | Scot
 |  |  | Eve | 0800-1600 | 1200-2000 | 0900-1700 | 0900-1700 | 0900-1700 | 0
 |  |  | [NAME] | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0
 |  |  | [NAME] | 0800-1600 | 0800-1600 | 0800-1600 | 1200-2000 | 0800-1600 | 0
 |  |  | [NAME] | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0
 |  |  | [NAME] | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0
 |  |  | [NAME] | 0900-1700 | 0900-1700 | 0900-1700 | 0900-1700 | 0900-1700 | 0
Spreadsheet: 85910d1285903826-text-into-a-cell-extnmbr-2-
Sheet: Sheet2

nu-mai | 7000 |  |  |  | OR | 7000 |  | 500
poate | 500 |  |  |  |  | 500 |  | 5000
perfect | 5000 |  |  |  |  | 5000 |  | 7000
 |  |  | Total |  |  |  |  | 9000
 |  |  |  |  |  |  |  | 11000
 |  |  |  |  |  |  |  | 13000
 |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  | 17000
 |  |  |  |  |  |  |  | 19000
 |  |  |  |  |  |  |  | 21000
 |  |  |  |  |  |  |  | 23000
Spreadsheet: 782489d1654078479-if-one-cell-contains-a-specific-value-then-return-values-in-other-cells-example
Sheet: Blad1

Q | X | S | O
Q | V | S | O
Q | U | S | O
 | A
Q | X | S | O
Q | V | S | O
Q | U | S | O
 | A
Q | X | S | O
Q | V | S | O
Q | U | S | O
Q | A
Q | X | S | O
Q | V | S | O
Q | U | S | O
 | A
Q | X | S | O
Q | V | S | O
Q | U | S | O
Q | A | S | O
Spreadsheet: 627273d1559801518-calculate-bonus-based-on-total-dollar-value-accumulated-bonus-ans
Sheet: Sheet1

Sno | T sales | Total val | Com | Bonus
1 | 15 | 75000
2 | 15 | 40000
3 | 105 | 40000
4 | 155 | 125000
Spreadsheet: 136790d1326823959-problem-formatting-data-to-properly-make-a-stacked-column-chart-excel_forum_blosoya_help
Sheet: Sheet1

 | Column 1 |  |  | Column 2
Series 1 | 0.69 |  | Series 6 | 2.3
Series 2 | 1 |  | Series 7 | 2.7
Series 3 | 1.7 |  | Series 8 | 6
Series 4 | 2.6 |  | Series 9 | 9
Series 5 | 4.1 |  | Series 10 | 15
Spreadsheet: 788174d1658315434-average-specific-cells-based-on-a-criteria-book7
Sheet: Sheet1

 |  |  | size | volume |  | Sizes | volume |  | Average
 |  |  | 5 |  |  | 0 | 100
 |  |  | 20 | 200 |  | 10 | 200
 |  |  | 250 | 300 |  | 100 | 300
 |  |  | 110 | 300
 |  |  | 30 | 200
 |  |  | 60 | 200