tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848687d1699361640-is-sumproduct-the-correct-formula-example-data
Sheet: Sheet1

Sum of months between the two criteria above for a selected employee
Full Name | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
Spiderman | 106 | 106 | 77 | 106 | 101 | 96 | 101 | 101 | 96 | 110 | 101 | 101
Iron Man | 88 | 88 | 64 | 88 | 84 | 80 | 84 | 84 | 80 | 92 | 84 | 84
Captain America | 21 | 21 | 15 | 21 | 20 | 19 | 20 | 20 | 19 | 22 | 20 | 20
Wolverine | 106 | 106 | 77 | 106 | 101 | 96 | 101 | 101 | 96 | 110 | 101 | 101
[NAME] | 114 | 114 | 83 | 114 | 109 | 104 | 109 | 109 | 104 | 120 | 109 | 109
[NAME] | 51 | 51 | 37 | 51 | 48 | 46 | 48 | 48 | 46 | 53 | 48 | 48
Black Widow | 84 | 84 | 61 | 84 | 80 | 76 | 80 | 80 | 76 | 87 | 80 | 80
For example
1.  Total for Iron Man between Oct 23 and Jan 24
2.  Total for Ant Man between Jan 24 and Apr 24
Name | From | To |  | Result
Iron Man | 2023-10-01 00:00:00 | 2024-01-01 00:00:00
[NAME] | 2024-01-01 00:00:00 | 2024-04-01 00:00:00
Spreadsheet: 735189d1622744150-formula-to-convert-range-and-provide-outcome-according-to-2-parameters-formulas
Sheet: Sheet1

 | Range | Score |  | 1) | I'm working on a score system which provide a score number. I need then a formula which convert the number (included in the range provided) in the respective letter
 | from 17 to 23 | A
 | from 23.01 to 29 | B
 | from 29.01 to 35 | C
 | from 35.01 to 41 | D
 | from 41.01 to 47 | E
 | from 47.01 to 53 | F
 | from 53.01 to 59 | G
 | from 59.01 to 65 | H
 | from 65.01 to 71 | I
 | from 71.05 to 77 | J
 | from 77.01 to 83 | K
 | from 83.01 to 89 | L
 | from 89.01 to 95 | M
 | from 95.01 to 101 | N
 | from 101.1 to 104 | O
 |  |  |  | 2) | Once the above formula is created, I need then a formula which assign to the letter the correspdondent settlment and collateral result (e.g. H will give the outcome 7 days and 10%)
Settltement | day after | A | B | C | D | E
 | 7 days | F | G | H | I | J
 | 30 days | K | L | M | N | O
 |  | 0 | 0.05 | 0.1 | 0.15 | 0.2
 |  | Collateral
Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: B-SHEET

Date: | 2022-01-26 00:00:00
 | AVERAGESBY DATE
 | PVR NEW |  | NEW F&I |  | TOTAL NEW
 | TARGET |  | TARGET |  | TARGET
 | PVR USED |  | USED F&I |  | TOTAL USED
 | TARGET |  | TARGET |  | TARGET
 |  |  | OVERALL F&I
 | Del Front End Gross
 | Del Back End Gross
 |  |  |  | TOTAL GROSS
 | Del Avg Front End |  |  |  | -
 | Del Avg Back End |  |  | - | -
F&I AVERAGE |  |  |  |  | Total Back End Gross
Turns Per F&I |  | New | Used | Combined AVG | New | Used | TOTAL
Spreadsheet: 170c13f3-5fe4-4ad8-9aed-901c620e0b6a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Retail Trade and Food Services
 |  | 44X72: Retail Trade and Food Services: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: December 7, 2013 (5:51 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 146376 | 147079 | 159336 | 163669 | 170068 | 168663 | 169890 | 170364 | 164617 | 173655 | 171547 | 208838
1993 | 153221 | 150087 | 170439 | 176456 | 182231 | 181535 | 183682 | 183318 | 177406 | 182737 | 187443 | 224540
1994 | 161349 | 162841 | 192319 | 189569 | 194927 | 197946 | 193355 | 202388 | 193954 | 197956 | 202520 | 241111
1995 | 175344 | 172138 | 201279 | 196039 | 210478 | 211844 | 203411 | 214248 | 202122 | 204044 | 212190 | 247491
1996 | 185019 | 192380 | 212110 | 211718 | 226936 | 217511 | 218111 | 226062 | 209250 | 222663 | 223953 | 258081
1997 | 200389 | 197556 | 225133 | 220329 | 234190 | 227365 | 231521 | 235252 | 222807 | 232251 | 228284 | 271054
1998 | 207853 | 203863 | 230313 | 234503 | 245027 | 244067 | 241431 | 240462 | 231243 | 244234 | 240991 | 288969
1999 | 218126 | 220650 | 253550 | 250783 | 262113 | 260918 | 262051 | 265089 | 253905 | 258040 | 264106 | 317659
2000 | 236422 | 250580 | 279515 | 264417 | 283706 | 281288 | 271146 | 283944 | 269155 | 270899 | 276507 | 319958
2001 | 250746 | 247772 | 280449 | 274925 | 296013 | 287881 | 279098 | 294763 | 261924 | 291596 | 287537 | 326202
2002 | 255598 | 253086 | 285261 | 284747 | 300402 | 288854 | 295433 | 307256 | 273189 | 287540 | 290705 | 337006
2003 | 268335 | 259060 | 293703 | 294262 | 312404 | 301014 | 309942 | 317079 | 293912 | 304060 | 301299 | 357634
2004 | 281493 | 282478 | 319111 | 315223 | 328445 | 321081 | 328040 | 326362 | 313566 | 319768 | 324315 | 387243
2005 | 293308 | 295109 | 339190 | 335678 | 345401 | 351002 | 351889 | 355773 | 333363 | 336214 | 343910 | 405788
2006 | 318682 | 314189 | 362141 | 351811 | 373727 | 366795 | 362393 | 376006 | 346423 | 349007 | 357224 | 418473
2007 | 329169 | 323456 | 374439 | 358806 | 391816 | 376944 | 372665 | 388357 | 354241 | 368982 | 378233 | 426699
2008 | 343241 | 344577 | 373623 | 369688 | 398816 | 379387 | 384666 | 383879 | 351578 | 350920 | 336629 | 385504
2009 | 311345 | 300589 | 329806 | 331186 | 349193 | 345933 | 349588 | 354942 | 326138 | 340151 | 340992 | 402229
2010 | 316127 | 312513 | 362497 | 358296 | 367552 | 360583 | 363815 | 364503 | 347868 | 357197 | 367894 | 429102
2011 | 337608 | 339459 | 389616 | 383323 | 394799 | 391511 | 387259 | 397392 | 377707 | 382545 | 394377 | 455526
2012 | 358313 | 376066 | 418324 | 397263 | 423323 | 405484 | 400379 | 422544 | 390169 | 404534 | 416397 | 468589
Spreadsheet: 51799d1251397447-collecting-data-from-another-sheet-ve-1
Sheet: WERKBLAD

 | 3 | 12
 | $D$19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not OK
 |  | 1 | religious minorities were ....... during the ten-year regime. |  |  |  |  | test | west | test | ghjghj | [NAME] | [NAME] ghjgjhg | in het west is alles best, nietwaar
 |  | 2 | i felt hurt by his ........ |  |  |  |  | kreeft | beleefd | hkjhjkh | [NAME] | fd | fgd | in het west is alles best, nietwaar
 |  | 3 | he was ....... to depressions even as a teenager. |  |  |  |  | voeden | nourish | 0 | to feed | 0 | to provide people or living things with food in order to make them grow and keep them healthy | de kreeft is zeer beleefd mijn vriend
 |  | 4 | there are many ....... families in st. [NAME]. |  |  |  |  | levenloos | inanimate | [in-an-uh-mit | lifeless | from anima "life, breath" | possessing none of the characteristics of life that an animal or plant has | children need plenty of good fresh food to nourish them.
 |  | 5 | a good manager, must know how to ....... responsibility downwards. |  |  |  |  | ten koste [NAME] | at the expense of | ik-spens | 0 | 0 | at the sacrifice of; to the detriment of. | he looks at me as if i'm an inanimate object.
 |  | 6 | all their work was for ........ |  |  |  |  | niets | naught | nawt | nothing | 0 | 1: complete failure. 2: a quantity of no importance. | we can't speed up production at the expense of quality
 |  | 7 | there's no room for ....... if we want to stay in this competition! |  |  |  |  | zelfgenoegzaamheid | complacency | [NAME]-see | 0 | 0 | the feeling you have when you are satisfied with yourself | all their work was for naught.
 |  | 8 | the judge ....... the young man for fighting in the street. |  |  |  |  | waarschuwen | admonished | 0 | 0 | 0 | To notify (someone) of imminent danger or risk | there's no room for complacency if we want to stay in this competition!
 |  | 9 | redemption is a ....... theme in literature. |  |  |  |  | gelijkstaan met | amounts to | uh-mount | same as | 0 | to be the same as something, or to have the same effect as something | the judge admonished the young man for fighting in the street.
 |  | 10 | the report criticizes the banks for being ....... in their lending. |  |  |  |  |  |  |  |  |  |  | borrowing money and not returning it amounts to stealing.
Spreadsheet: 00cd9b07-4752-43db-b3ff-f1c130969de3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Balance on goods and services ; |  |  | Original | A592264J | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A592265K | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | [NAME] | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A592267R | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Credits, Non-rural and other goods ; |  |  | Original | A592268T | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A592269V | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A592270C | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A592271F | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A592272J | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A592273K | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other goods ; |  |  | Original | A592274L | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A592275R | 1971-07-01 00:00:00 | 2009-06-01 00:00:00 | 456 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: benjamin_rogers__911__PJM Eastern Hub Pricing
Sheet: MW Daily Pivot

Average of MW Daily
Year | Month | Total
1998 | 10 | 22.41259271127206
 | 11 | 22.44181815060702
 | 12 | 20.77400007247925
 | 4 | 20.79999996366955
 | 5 | 30.40200004577637
 | 6 | 38.28363643993031
 | 7 | 54.02458302179972
 | 8 | 32.21740743849013
 | 9 | 27.6451850467258
1998 Total |  | 30.06809521629697
1999 | 1 | 23.67454511469061
 | 10 | 24.54482762566928
 | 11 | 21.45769236637996
 | 12 | 22.09133335749308
 | 2 | 18.62074053729022
 | 3 | 21.03777772408944
 | 4 | 24.83359992980957
 | 5 | 26.70428582600185
 | 6 | 47.14416718482971
 | 7 | 120.7123071230375
 | 8 | 53.14620688865925
 | 9 | 26.26037018387406
1999 Total |  | 35.66521869599819
2000 | 1 | 28.95344839424923
 | 10 | 36.40592610394513
 | 11 | 42.93130451699962
 | 12 | 59.02724134510961
 | 2 | 26.15043474280316
 | 3 | 26.70199996948242
 | 4 | 28.37566661834717
 | 5 | 46.51111150670935
 | 6 | 41.9651722085887
 | 7 | 33.92387131721743
 | 8 | 43.4051724137931
 | 9 | 29.0792591660111
2000 Total |  | 37.11373866582714
2001 | 1 | 46.91903181998961
 | 2 | 35.3848147922092
 | 3 | 41.89821434020996
 | 4 | 46.97000122070312
2001 Total |  | 41.78374988382513
Grand Total |  | 35.49583948149475
Spreadsheet: 157198d1337651214-running-balance-weighted-average-formula-workbook
Sheet: Sheet2

 |  | Date | Rate | Additions | Running Balance | Percentage | Weighted Average Rate
1 | a | 2012-01-01 00:00:00 | 0.12 | 2000000 |  |  | Would be 12%
1 | b | 2012-01-01 00:00:00 | 0.13 | 3000000 |  |  | Would be 13%
 | a |  | 0.07 | 200000 |  |  | Should be (200000/2200000*7%)+(2000000/2200000*12%) - is there a formula for this?
 | b |  | 0.03 | 500000 |  |  | Sumproduct can multiply columns D and E in each row but I also want to divide by the running balance in the row that the formula is in
 | a |  | 0.05 | 4200000 |  |  | I would also have two if functions in the formula so that I can include the columns
 | b |  | 0.14 | 3500000 |  |  | and drag the formula down without including the new rows that I add as part of the previous rows formula.
 | a |  | 0.11 | 600000 |  |  | I would include rows greater than or equal to the value in column A - would be something like (A:A, ">="&A6) and rows that equal the value in column B  - (B:B, B6)
 | b |  | 0.19 | 2000000
 | a |  | 0.06 | 500000
 | b |  | 0.04 | 800000
 | a |  | 0.02 | 900000
 | b |  | 0.08 | 1200000
 | a |  | 0.09 | 1500000
 | b |  | 0.04 | 1300000
 | a |  | 0.03 | 1300000
 | b |  | 0.06 | 700000
Spreadsheet: sally_beck__35151__MgmtSum-Q3-0914_Global
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  | 3RD QTR 2000 EARNINGS ESTIMATE
 |  |  |  |  |  |  |  |  |  |  |  | Results based on activity through September 14, 2000
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME]
Liquids |  | 14561 | 20000 | -5439 |  | 14096 | 14096 | 0 |  | 465 | 5904 | -5439
Coal |  | -5915.184999999999 | 12747 | -18662.185 |  | 6632.291999999999 | 4881.7 | -1750.591999999999 |  | -12547.477 | 7865.3 | -20412.777
Emissions |  | 2380 | 750 | 1630 |  | 415.01 | 340.5 | -74.51 |  | 1964.99 | 409.5 | 1555.49
Weather |  | 3721.8 | 3215 | 506.8 |  | 1655.8 | 1655.8 | 0 |  | 2066 | 1559.2 | 506.8
Global Risk Markets |  | 0 | 7712 | -7712 |  | 2028.2 | 1618.2 | -410 |  | -2028.2 | 6093.8 | -8122
Financial Trading |  | 13848.419 | 8947 | 4901.419 |  | 3591.107 | 3377.4 | -213.7069999999999 |  | 10257.312 | 5569.6 | 4687.712
Agricultural Trading |  | -47.714 | 0 | -47.714 |  | 101.936 | 0 | -101.936 |  | -149.65 | 0 | -149.65
Overview |  | 0 | 6786 | -6786 |  | 0 | 0 | 0 |  | 0 | 6786 | -6786
Office of the Chairman |  | 0 | 0 | 0 |  | 350 | 0 | -350 |  | -350 | 0 | -350
Total Commercial |  | 28548.32 | 60157 | -31608.68 | 0 | 28870.345 | 25969.6 | -2900.744999999999 |  | -322.025 | 34187.4 | -34509.425
Other Interest Related Charges |  | -538.419 | -538.419 | 0 |  | 0 | 0 | 0 |  | -538.419 | -538.419 | 0
Capital Charge Offset |  | 0 | 0 | 0 |  | -665 | -783 | -118 |  | 665 | 783 | -118
Global Markets EBIT |  | 28009.901 | 59618.581 | -31608.68 |  | 28205.345 | 25186.6 | -3018.744999999999 |  | -195.444 | 34431.981 | -34627.425
Interest Expense/(Income) |  | 0 | 0 | 0 |  | -1336 | -1336 | 0 |  | 1336 | 1336 | 0
Global Markets Pre-tax Income |  | 28009.901 | 59618.581 | -31608.68 |  | 26869.345 | 23850.6 | -3018.744999999999 |  | 1140.556 | 35767.981 | -34627.425
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 99ae44b0-8fbe-449c-8768-2eb6a7fa8e7d
Sheet:  Deliverables

 |  | Replacement Deliverables Price Sheet
 | PHASE I – PROJECT PLANNING
 | Number | Deliverable |  |  | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | 1 | Project Facility Plan - Data Center
 |  | Infrastructure Assets Inventory
 |  | Computing Environment Plan
 |  | Project Facility Plan - DDI Project Office
 |  | Project Facility Plan - Operations
 |  | Project Management Plan
 |  | Incoming Orientation Plan
 |  | Requirements Traceability Matrix (RTM)
 |  | Training Master Plan
 |  | Staffing Master Plan
 |  | Performance Management Plan
 |  | Data Center Computing Environment Specifications Plan
 |  | Systems Engineering Management Plan (SEMP)
 |  | Test and Evaluation Management Plan (TEMP)
 |  | Technical Architecture Specifications
 |  | Information Arcchitecture Speccifications
 |  | Business Architecture Specifications
 |  | Phase 1 Completion Report
 | Phase I Subtotal
 | Phase II - DEVELOPMENT, CONFIGURATION, AND UAT TEST
 | Number | Deliverable |  |  | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 |  | Technical Architecture
 |  | Information Architecture
 |  | Business Architecture
 |  | End-to-End Integration Test
 |  | User Acceptance Test
 | Phase II Subtotal
 | Phase III Operations Readiness, [NAME], and Facilities Rollout
 | Number | Deliverable |  |  | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 |  | Implementation Master Plan
 |  | Detailed Training Plan
 |  | Detailed Data Conversion Plan
 |  | Detailed End-to-End Integraion
 |  | Detailed User Acceptance Test Plan
 |  | Detailed Performance Management Plan (Operations)
 |  | Detailed Operations Readiness Review Plan
 |  | Operations Readiness Report and State Approvals
 |  | Final Acceptance Certification
 | Phase III Subtotal
 | Phase V Operations and CMS Certification
 | Number | Deliverable |  |  | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 |  | Federal Certification Review Package
 | Phase IV Subtotal
 | Phase VI Turnover (Contract Closeout)
 | Number | Deliverable |  |  | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 |  | Turnover Plan - Detailed Planning
 |  | Turnover Management and Status Reporting
 |  | Turnover Deliverables and Archive Complete
 |  | Turnover Final Status Report
 | Phase VI Subtotal
 | [NAME]
Spreadsheet: 159061d1338485464-excel-2007-formula-which-returns-the-working-days-of-a-month-stopping-at-the-end-of-it-daddy_workingdays
Sheet: 2012 - Working Days

 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
1
2 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | Holidays
3 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00
4 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00
6 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00
7 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-15 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00
9 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00
11 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00
12 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-17 00:00:00
13 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
14 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00
15
16
17
18
19
20
21
22
23
Spreadsheet: 825585d1681404560-trying-to-figure-out-the-proper-vlookup-to-aggregate-some-data-example-excel-copy
Sheet: Sheet2

Project | Project Indicator | CR # | CR Name | Date Created | Date Approved Internally | Date Submitted to Client | CR Hours | [NAME] | Contingency CR Revenue Impact | Date Added to Revenue Schedule | Date Approved by Client | Status | CR Type
A | 475 | 3 | a | 2023-04-14 00:00:00 |  |  | 10 | 1000 | 0 | 0 |  | Approved | Client CR
B | 100 | 1 | b | 2023-04-13 00:00:00 |  |  | 40 | 0 |  |  |  | Approved | Internal CR
C | 475 | 4 | c | 2023-04-12 00:00:00 |  |  | 58 | 0 |  |  |  | Drafting | Internal CR
D | 475 | 2 | d | 2023-04-07 00:00:00 | 2023-04-10 00:00:00 | 2023-04-10 00:00:00 | 100 | 23000 |  |  |  | Pending Client Approval | Client CR
E | 475 | 2 | e | 2023-03-27 00:00:00 |  | N/A | 30 | 4000 |  |  |  | Approved | Client CR
Spreadsheet: 59155d1259618666-reduce-sheet-to-rows-with-certain-value-name-list
Sheet: Sheet1

Dr | [NAME] | Gray | Pediatrician
Dr | [NAME] | Smith | Internal Medicine
Dr | [NAME] | Jones | Emergency Medicine
Dr | [NAME] | Town | Cardiology
Dr | [NAME] | Jones | Dir of Emergency Medicine
Spreadsheet: 684998d1593655196-excel-function-to-filter-and-extract-data-filter-and-extract-data-copy
Sheet: Filter

Unique ID | Name | Address | Postal Code | Country | Date of Birth | [NAME]
2 | Candice | 935 Dead End Alley | 124897 | Canada | 1960-10-02 00:00:00 | [EMAIL]
5 | Dollar | 34 Azerbike Creset | 677834 | United States | 2000-08-17 00:00:00 | [EMAIL]
7 | Garb | 93 Blizzard Fall | 552335 | China | 1980-02-27 00:00:00 | [EMAIL]
Unique ID I type in | The red autopopulates based on the typed out filter
Spreadsheet: 293695d1391066156-dependant-drop-down-lists-po-template
Sheet: PO Template

ITEM # | Product | Colour | Pack Size | QTY | UNIT PRICE | TOTAL
1 | Heatsafe7 | Grey | 50
2 | Steelguard873BY | Yellow | 20
3 | Zincguard100 | Green | 20
Spreadsheet: 220500d1363182052-group-up-same-values-and-provide-total-sample-data1
Sheet: PROJECT BAY DETAIL

SALESMAN |  |  |  |  |  |  | Uprights |  | GREY
CUSTOMER/CONTACT |  |  |  |  |  | COLOURS | Bracing |  | GALV | GV
QUOTE/JOB NO |  |  |  |  |  |  | Beams |  | ORANGE
 | BAY TYPE A |  |  |  | BAY TYPE B |  |  |  | BAY TYPE C |  |  |  | BAY TYPE D |  |  |  | BAY TYPE E
 | Type |  |  |  | Type |  |  |  | Type |  |  |  | Type |  |  |  | Type
Frame Type/Height | 08 | 6000 |  |  | 08 | 5025 |  |  | 08 | 6000 |  |  | 08 | 5025
Frame Depth |  | 1100 |  |  |  | 1100 |  |  |  | 1100 |  |  |  | 1100
Bracing Pitch |  | 750 |  |  |  | 750 |  |  |  | 750 |  |  |  | 750
Spliced (Y/N)
Lower Section Type/Height
Upper Section Type/Height
Baseplate |  | STD |  |  |  | STD |  |  |  | STD |  |  |  | STD |  |  |  | STD
[NAME] |  | SINGLE |  |  |  | SINGLE |  |  |  | SINGLE |  |  |  | SINGLE |  |  |  | SINGLE
Beam Type 1 - No. of Levels |  | 2 |  |  |  | 2 |  |  |  | 3 |  |  |  | 3
Beam Clear Entry |  | 2700 |  |  |  | 2700 |  |  |  | 2700 |  |  |  | 2700
Beam Type |  | C100S |  |  |  | C100S |  |  |  | C100S |  |  |  | C100S
[NAME] load (kgs) |  | 2500 |  |  |  | 2500 |  |  |  | 2500 |  |  |  | 2500
Beam Type 2 - No. of Levels |  | 2 |  |  |  | 1
Beam Type |  | U110H |  |  |  | U70S
[NAME] (kgs) |  | 2000 |  |  |  | 1500
No. of Pallets per bay
Number of row spacers | 600mm
Number of row spacers | 750mm
Number of row spacers
Number of row spacers
TOTAL NO. of Beam Levels
Spreadsheet: 687718d1595362395-sumifs-or-sumif-or-rearrange-the-sum-excel-forumn
Sheet: Sheet1

 |  | AVG RATE - JAN-20 |  |  | MAR-20 DAYS |  |  | APR-20 DAYS |  |  | MAY-20 DAYS |  |  | JUNE-20 DAYS
HOSPICE MCAID |  | 185.2 |  |  | 31 |  |  | 30 |  |  | 29 |  |  | 15
MCAID |  | 184.2 |  |  | 3651 |  |  | 3521 |  |  | 3493 |  |  | 3630
MCARE |  | 590.15 |  |  | 308 |  |  | 312 |  |  | 390 |  |  | 291
ANTHEM |  | 385 |  |  |  |  |  |  |  |  |  |  |  | 21
PVT |  | 190 |  |  | 338 |  |  | 254 |  |  | 248 |  |  | 210
MR |  | 615.9 |  |  | 14 |  |  | 3 |  |  | 71 |  |  | 30
PVT INSURANCE |  | 235 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30
 |  |  | 920312.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WRONG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62970.81 | CORRECT