tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 803394d1667428225-help-with-formulas-to-manipulate-data-into-a-certain-format-copy-of-lightspeed-import-demo
Sheet: Inventory

Custom SKU | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64
[PHONE] |  |  | 3 |  |  |  |  |  | 3
[PHONE] |  |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  | 5
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  | 3 | 3
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  | 3 | 3
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  | 5
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  | 6
[PHONE] |  |  | 6
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  | 6
[PHONE] |  |  | 3
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  |  | 6
[PHONE] |  |  | 6
[PHONE] |  |  |  | 6
[PHONE] |  |  | 6
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  | 6
[PHONE] |  |  |  | 6
[PHONE] |  |  |  |  |  | 6
[PHONE] |  |  |  |  |  |  |  |  | 5
[PHONE] |  |  |  |  |  | 6
Spreadsheet: mark_taylor__24725__ClickInTradingProducts
Sheet: EastEurPower

Short Description Boxes: |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR OPTIONS
Eastern European Power Physical |  | Location |  | Term |  | Load Profile |  | Currency |  | Units |  | Option Type |  | Option Strike |  | Expiration Date
 |  | Bulgaria-Turkey Border |  | Year 2000 |  | Baseload |  | USD |  | MWh |  | Call
 |  | Romania |  |  |  |  |  | GBP |  |  |  | Put
 |  | Bulgaria-Greece Border |  |  |  |  |  | EUR
 |  | Russia-Finland Border
Spreadsheet: 0241bcd6-4040-433e-aaf2-08a5e85292ec
Sheet: PERSI-T1

Temporary Help PERSI Eligible Appointment -T1 Positions |  |  |  |  |  |  |  |  |  | Start Over
PCN# | PCN# | PCN# | PCN# | PCN# | Suffix | Employee Class | Title | Account Code
1st Job New Title | 2nd Job Same Title | 3rd Job Same Title | 4th Job Same Title | 5th Job Same Title
**9900 | XX9600 | XX9800 | XX9840 | XX9860 | 05 | T1 | TH-Clerical/Tutors | E4110
**9901 | XX9601 | XX9801 | XX9841 | XX9861 | 05 | T1 | TH-Instructor/Coach | E4110
**9902 | XX9602 | XX9802 | XX9842 | XX9862 | 05 | T1 | TH-Laborer | E4110
**9903 | XX9603 | XX9803 | XX9843 | XX9863 | 05 | T1 | TH-Childcare Provider | E4110
**9904 | XX9604 | XX9804 | XX9844 | XX9864 | 05 | T1 | TH-Logging | E4110
**9905 | XX9605 | XX9805 | XX9845 | XX9865 | 05 | T1 | TH-Dairy | E4110
**9906 | XX9606 | XX9806 | XX9846 | XX9866 | 05 | T1 | TH-Farming | E4110
**9907 | XX9607 | XX9807 | XX9847 | XX9867 | 05 | T1 | TH-Cattle/Sheep | E4110
**9908 | XX9608 | XX9808 | XX9848 | XX9868 | 05 | T1 | TH-Drivers | E4110
**9909 | XX9609 | XX9809 | XX9849 | XX9869 | 05 | T1 | TH-Research-Lab | E4110
**9910 | XX9610 | XX9810 | XX9850 | XX9870 | 05 | T1 | TH-Research-Non-Lab | E4110
** Replace with the first 2 letters of department budget.
Each additional job within the same [NAME] should begin with the characters 'XX'.
Check T1 Positions for Posn (PCN#), also watch for Suffix.
Check PCN - Titles to ensure correctness and accuracy
Spreadsheet: 831905d1685982070-formula-to-get-the-alphabets-only-from-a-cell-get-alphabets
Sheet: Sheet1

 | Numbers |  | Expected
 | 2BD00002688 |  | BD |  |  | Get alphabets only from the value in cell B as shown in column D
 | BLR72205 |  | BLR
 | [NAME] |  | BLR
 | BLR72207 |  | BLR
 | BLR72208 |  | BLR
 | BLR72209 |  | BLR
 | BLRE0000090 |  | BLRE
 | BLRRE000142 |  | BLRR
 | BSCR001057 |  | BSCR
 | D0000377187 |  | D
 | E0000001168 |  | E
 | E0000001169 |  | E
 | E0000001170 |  | E
 | EKA00034636 |  | EKA
 | FTW000375 |  | FTW
 | PSCR026895 |  | PSCR
 | PSI028497 |  | PS
 | PSVC001672 |  | PSVC
 | SCR014168 |  | SCR
 | SER121816 |  | SER
 | SER681352 |  | SER
 | TS208463 |  | TS
 | TS209003 |  | TS
 | TS209005 |  | TS
 | TS209034 |  | TS
Spreadsheet: 734827d1622534041-help-with-formula-to-extract-multiple-values-from-table-test-workbook
Sheet: Output

Trade | Address | Start | End |  |  |  |  |  | Help with formula to extract multiple values from table
 |  |  |  |  |  |  |  |  | GDay guys. First post on here. I will preface this with saying that Im not an excel expert but have a good understanding of using formulas
Framers |  |  |  |  |  |  |  |  | That being said i have a task that i have no idea how to solve. Have tried using various lookup methods but cant get it to do what i want
Mark |  |  |  |  |  |  |  |  | I have a table (list of jobs and trades allocated to work on that job) that i want to pull data from and group together on another sheet. See attached excel sheet
 |  |  |  |  |  |  |  |  | The list of jobs will get added to over time so i need something that can search a growing list
 |  |  |  |  |  |  |  |  | What i want to do is search the framer column (F) on my Table sheet for a specific name (eg [NAME]) and then pull the address (column A), start date (column G) and finish date (column H) and then list them in order of date on a separate sheet. The output has been done manually
 |  |  |  |  |  |  |  |  | Then i want to do the same for various other trades like brick layers
ian |  |  |  |  |  |  |  |  | I have no idea if this is even possible or if maybe it can be done with a pivot table?
[NAME]
Bricklayers
[NAME] | 123 Sample St | 2018-04-30 00:00:00 | 2018-05-11 00:00:00
[NAME] | Test st 1 | 2021-06-01 00:00:00 | 2021-06-10 00:00:00
 | Test st 5 | 2021-06-07 00:00:00 | 2021-06-20 00:00:00
[NAME] | Test st 2 | 2021-06-02 00:00:00 | 2021-06-11 00:00:00
FORECAST
Address | Ready
Spreadsheet: 727550d1617956594-dynamic-array-formula-for-nearest-non-blank-nearest-non-blank
Sheet: NearestNonblank

Data source |  | Upwards | Downwards |  | Value of nearest non-blank
Non-blank
Non-blank again
Another one
Yet another
Spreadsheet: 189508d1351200862-match-data-between-sheets-match-sample-question
Sheet: Data

281a39 | hi
281b02 | yes
281b71 | love
281d56 | money
283344 | dog
284091 | fi
284c57 | fum
284c58 | blow
290204 | nice
290354 | kind
290386 | valiant
Spreadsheet: 5c600cc7-519f-4f54-b3a2-d417dbdd9ad4
Sheet: Sheet1

unit type | unit number | 2013 date | members 2012 | 2012 unit potential | Raised in 2012 | Proposed unit 2013 goal | Plus from old [NAME] | New Proposed unit 2013 goal
p | 24 |  | 9 | 100 | 55 | 250 |  | 125
t | 24 |  | 9 | 100 | 50 | 250 |  | 125
p | 61 |  | 114 | 3000 | 6344 | 6500 | 300 | 6800
t | 61 | 2013-04-11 00:00:00 | 29 | 1555 | 1237 | 2000 | 300 | 2300
t | 90 |  | 41 | 1230 | 1200 | 3000 |  | 3000
p | 90 |  | 88 | 2000 | 475 | 1000 |  | 1000
p | 98 |  | 12 | 490 | 1630 | 2000 |  | 2000
t | 100 |  | 35 | 1220 | 1930 | 2000 |  | 2000
p | 230 |  | 63 | 1890 |  | 2000 | 300 | 2300
p | 316 |  | 21 | 200 | 350 | 500 |  | 500
t | 316 |  | 7 | 200 | 350 | 500 |  | 500
p | 319 | 2013-02-23 00:00:00 | 25 | 100 | 125 | 125 | 100 | 225
t | 319 |  | 25 | 100 | 100 | 125 |  | 250
t | 338 |  | 9 | 200 |  | 200 |  | 200
t | 343 | 2013-02-13 00:00:00 | 19 | 300 | 87.24 | 200 |  | 200
p | 343 | 2013-02-15 00:00:00 | 38 | 300 |  | 200 |  | 200
p | 380 | 2013-02-08 00:00:00 | 45 | 1350 | 670 | 1000 |  | 1000
t | 380 | 2013-04-27 00:00:00 | 27 | 1240 | 880 | 1000 | 500 | 1500
t | 500 | 2013-01-28 00:00:00 | 44 | 2265 | 1060 | 3000 | 250 | 3250
p | 508 |  | 10 | 200 |  | 200 |  | 200
t | 508 |  | 10 | 200 |  | 200 |  | 200
t | 524 |  | 12 | 360 | 100 | 500 |  | 500
t | 538 | 2013-03-10 00:00:00 | 10 | 250 | 295 | 500 |  | 500
p | 538 | 2013-02-23 00:00:00 | 14 | 250 | 340 | 300 |  | 300
t | 544 | 2013-03-02 00:00:00 | 32 | 960 | 705 | 2000 |  | 2000
p | 544 |  | 51 | 1530 | 1215 | 1000 |  | 1000
p | 587 |  | 6 | 100 |  | 100 |  | 100
t | 587 |  | 6 | 100 |  | 100 |  | 100
t | 666 | 2013-02-04 00:00:00 | 13 | 390 | 485 | 500 |  | 500
p | 1517 |  | 5 | 100 |  | 125 |  | 125
t | 1517 |  | 5 | 100 |  | 125 |  | 125
p | 1616 |  | 5 | 100 |  | 100 |  | 100
t | 1616 |  | 5 | 100 |  | 100 |  | 100
p | 1650 |  | 5 | 375 | 375 | 250 | 500 | 750
t | 1650 |  | 5 | 300 | 300 | 250 |  | 250
p | 1869 | 2013-02-09 00:00:00 | 7 | 200 | 225 | 225 | 210 | 435
t | 1869 | 2013-02-09 00:00:00 | 6 | 200 | 200 | 200 |  | 200
p | 1909 |  | 23 | 500 |  | 500 |  | 500
t | 1946 |  | 31 | 2000 | 2475 | 3000 |  | 3000
p | 1946 |  | 29 | 605 | 350 | 600 |  | 600
p | 3838 |  | 15 | 200 |  | 200 |  | 200
p | 4700 |  | 34 | 2825 | 250 | 3000 |  | 3000
crew | 4501 |  |  | 100 | 100 | 100 |  | 100
TOTAL |  |  | 1026 | 31015 | 23958.24 | 40025 |  | 42360
43 units |  |  | members | Sum of 2012 unit potential | Raised in 2012 |  |  | Sum of Unit Goals
Spreadsheet: john_griffith__16194__1_30_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | EXP |  |  | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 55 | 540 | 640640 | 46.2 | 1599.9 | 28.46 | 2002-01-30 12:19:00
 | [NAME] | 62 | 880 | 980 | 46.6 | 51.9 | 1.92 | 2002-01-30 12:19:00
 | [NAME] | 63 | 1100 | 1200 | 45.8 | 50 | 1.9 | 2002-01-30 12:19:00
 | [NAME] | 63 | 1220 | 1320 | 43.3 | 46.9 | 1.79 | 2002-01-30 12:19:00
 | HU N2 | 63 | 1310 | 1410 | 42 | 45.2 | 1.73 | 2002-01-30 12:19:00
 | [NAME] | 62 | 1320 | 1420 | 39.2 | 42.2 | 1.59 | 2002-01-30 12:19:00
 | HU U2 | 60 | 1340 | 1470 | 38 | 41.7 | 1.5 | 2002-01-30 12:19:00
 | [NAME] | 58 | 1300 | 1475 | 35.9 | 40.7 | 1.4 | 2002-01-30 12:19:00
 | [NAME] |  |  |  | 35.2 | 38.3 | 1.36 | 2002-01-29 15:00: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: 166929d1341847625-return-a-list-of-everyone-who-matches-pt-count-responses
Sheet: Sheet1

current
Registrant Name | Sponsor 1 | Sponsor 2
Attendee A | I have never booked a meeting with this supplier, but am interested in learning more about them. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee B | I see little potential for booking meeting with this supplier. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee C | I see little potential for booking meeting with this supplier. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee D | I see little potential for booking meeting with this supplier. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee E | I have never booked a meeting with this supplier, but am interested in learning more about them. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee F | I have booked a meeting with this supplier, but it was more than 3 years ago. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee G | I have never booked a meeting with this supplier, but am interested in learning more about them. | I have never booked a meeting with this supplier, but am interested in learning more about them.
Attendee H | I have never booked a meeting with this supplier, but am interested in learning more about them. | I have booked a meeting with this supplier, but it was more than 3 years ago.
would like to: | sponsor 1
I see little potential for booking meeting with this supplier. | Attendee B, Attendee C, Attendee D
I have never booked a meeting with this supplier, but am interested in learning more about them. | Attendee A, Attendee E, [NAME], Attendee H | Attendee A, Attendee B, Attendee C, Attendee D, Attendee E, [NAME], Attendee G
I have booked a meeting with this supplier, but it was more than 3 years ago. | Attendee F | Attendee H
Count of Sponsor 1 | Column Labels
Row Labels | Attendee A | Attendee B | Attendee C | Attendee D | Attendee E | Attendee F | Attendee G | Attendee H | Grand Total
I have booked a meeting with this supplier, but it was more than 3 years ago. |  |  |  |  |  | 1 |  |  | 1
I have never booked a meeting with this supplier, but am interested in learning more about them. | 1 |  |  |  | 1 |  | 1 | 1 | 4
I see little potential for booking meeting with this supplier. |  | 1 | 1 | 1 |  |  |  |  | 3
Grand Total | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
Count of Sponsor 2 | Column Labels
Row Labels | Attendee A | Attendee B | Attendee C | Attendee D | Attendee E | Attendee F | Attendee G | Attendee H | Grand Total
I have booked a meeting with this supplier, but it was more than 3 years ago. |  |  |  |  |  |  |  | 1 | 1
I have never booked a meeting with this supplier, but am interested in learning more about them. | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 7
Grand Total | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
Spreadsheet: 788208d1658328052-auto-numerology-calculator-not-being-able-to-solve-the-issue-name-numerology-calculator-tms
Sheet: CHALDEAN NUMEROLOGY

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHALDEAN NUMEROLOGY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | 7
Spreadsheet: 761935d1641307586-find-future-on-hand-quantity-for-duplicate-values-sample-excel-forum
Sheet: Sample

Part | Total OH | Reqd | Required Date | Remaining OH
102 | 10 | 5 | 2021-02-15 00:00:00 | 5
101 | 12 | 12 | 2021-03-15 00:00:00 | 0
112 | 10 | 14 | 2021-05-15 00:00:00 | -4
118 | 5 | 8 | 2021-07-13 00:00:00 | -3
105 | 3 | 9 | 2021-07-15 00:00:00 | -6
108 | 3 | 6 | 2021-10-29 00:00:00 | -3
105 | 3 | 20 | 2021-11-15 00:00:00 | -26
114 | 4 | 7 | 2021-11-15 00:00:00 | -3
101 | 12 | 4 | 2021-11-18 00:00:00 | -4
117 | 10 | 16 | 2021-12-06 00:00:00 | -6
109 | 4 | 4 | 2021-12-07 00:00:00 | 0
106 | 0 | 3 | 2021-12-10 00:00:00 | -3
102 | 10 | 8 | 2021-12-14 00:00:00 | -3
103 | 5 | 10 | 2021-12-15 00:00:00 | -5
116 | 15 | 14 | 2021-12-15 00:00:00 | 1
102 | 10 | 5 | 2021-12-21 00:00:00 | -8
120 | 2 | 2 | 2021-12-21 00:00:00 | 0
113 | 6 | 25 | 2022-01-05 00:00:00 | -19
110 | 22 | 21 | 2022-01-07 00:00:00 | 1
104 | 6 | 30 | 2022-01-07 00:00:00 | -24
Spreadsheet: 732122d1620778513-returning-unique-value-with-multiple-criteria-returning-unique-value-with-multiple-criteria
Sheet: Pivot Table

Row Labels | Count of CREW
2017 | 27
ABC | 11
DEF | 10
GHI | 5
JKL | 1
2018 | 20
ABC | 8
DEF | 8
GHI | 2
JKL | 2
2019 | 25
ABC | 9
DEF | 10
GHI | 3
JKL | 3
2020 | 16
ABC | 4
DEF | 7
GHI | 3
JKL | 2
Grand Total | 88
Spreadsheet: 811057d1672250054-ref-error-when-index-formula-is-dragged-down-exam-results-tracker-2022-23
Sheet: Tracker

Year 11 | Pupil Detials | Pupil Details |  |  |  |  |  |  |  |  | FS Quals | 600/221/0 | 600/221/1 | 600/221/5 | 600/221/3 | 600/221/0 |  |  |  | 600/221/0 | 600/221/0 | GCSE Quals |  |  |  |  | VOC Quals
Pupil Name |  | UCI | ULN | UPN | Exam No. | Gender | DOB | PP | FSM | LAC |  | AQA FS ENG | WRI | REA | SPE | Edex FS ENG | WRI | REA | SPE | AQA FS Maths | Edex FS Maths |  | GCSE Englsh | GCSE Maths | GCSE Art
[NAME]
[NAME]
Inset Rows Above Red Line
Spreadsheet: 539076d1505949817-how-to-use-dates-as-reference-in-allocation-of-a-certain-amount-based-on-different-forecasting-claims-1-
Sheet: Sheet1

Pre Construction | 0.01 | 119
Council | 0.04 | 7
Slab | 0.15 | 28
Frame | 0.25 | 21
Enclosed | 0.3 | 49
Fix | 0.15 | 28
PCI | 0.1 | 56
Total
Job Number | Client Name | Total Claim | Start Date | Pre Construction | Council | Slab | Frame | Enclosed | Fix | PCI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-07-10 00:00:00 | 2017-07-17 00:00:00 | 2017-07-24 00:00:00 | 2017-07-31 00:00:00 | 2017-08-07 00:00:00 | 2017-08-14 00:00:00 | 2017-08-21 00:00:00 | 2017-08-28 00:00:00 | 2017-09-04 00:00:00 | 2017-09-11 00:00:00 | 2017-09-18 00:00:00 | 2017-09-25 00:00:00 | 2017-10-02 00:00:00 | 2017-10-09 00:00:00 | 2017-10-16 00:00:00 | 2017-10-23 00:00:00 |  | TOTAL
24086 | Villareal | 536580 | 2016-11-29 00:00:00 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
24121 | Prado | 845457 | 2016-12-22 00:00:00
24165 | Suñiga | 616326 | 2016-12-15 00:00:00
Spreadsheet: 858850d1707368239-flatten-a-random-matrix-example-data-dj
Sheet: Sheet1

 |  |  |  | Red | Blue
a | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | a\2Red | a\3Red | a\1Blue | a\2Blue | a\3Blue
b | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b\4Blue
c | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c\6Red | c\5Blue | c\6Blue
a | 1Red |  | 1Red
a | 2Red | a | 2Red
a | 3Red | a | 3Red
a | 1Blue | a | 1Blue
a | 2Blue | a | 2Blue
a | 3Blue | a | 3Blue
b | 4Red | b | 4Red
b | 4Blue | b | 4Blue
c | 5Red | c | 5Red
c | 6Red | c | 6Red
c | 5Blue | c | 5Blue
c | 6Blue | c | 6Blue
Spreadsheet: 58357d1258628972-excel-2007-school-survey-problem-707854
Sheet: Sheet4

Count of Sex | Column Labels
Row Labels | Alternative Rock | Classic | Country | Country | County | Dance | Every Kind | Heavy Metal | Hip-Hop | Japanese \ Forean | Metal | Pop | Pop | [NAME] | R&B | Rap | Reggae | Rock | Rock | Techno | Grand Total
Cassettes |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  | 1 |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 4
Cheap MP3 | 1 |  | 1 | 2 | 1 | 1 | 8 | 1 | 6 |  | 1 | 7 | 1 |  | 1 | 3 | 1 | 1 | 2 |  | 38
Crapy MP3 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  | 2
Ipod Shuffle |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
I-pod Shuffle |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
MP3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 2
MP4 |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  | 1 | 3
Old Thingy Magiee |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1
Philipe |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Raido |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  |  |  |  | 1 |  |  | 4
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Sony MP3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Tape Player |  |  |  |  |  |  | 1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 3
Walk-Man | 1 |  |  |  |  |  |  |  | 1 |  |  | 3 | 1 |  | 1 | 1 |  | 2 |  |  | 10
Grand Total | 2 | 1 | 2 | 2 | 1 | 1 | 14 | 1 | 11 | 1 | 4 | 14 | 2 | 1 | 2 | 5 | 1 | 6 | 2 | 1 | 74
Spreadsheet: 754082d1635937636-date-range-on-master-sheet-to-populate-month-sheets-following-sample-comm-sheet
Sheet: Apr21

NAME | ROLE | CLIENT | START DATE | END DATE | DAYS WORKED | RESOURCE RATE | SECOND RATE | SELL RATE | TOTAL VALUE FOR IDPP PER MONTH | COMM EARNED PER PROJECT | 2020-02-01 00:00:00 |  | 2020-03-01 00:00:00 |  | 2020-04-01 00:00:00 |  | 2020-05-01 00:00:00 |  | 2020-06-01 00:00:00 |  | 2020-07-01 00:00:00 |  | 2020-08-01 00:00:00 |  | 2020-09-01 00:00:00 |  | 2020-10-01 00:00:00 |  | 2020-11-01 00:00:00 |  | 2020-12-01 00:00:00 |  | 2021-01-01 00:00:00 |  | 2021-02-01 00:00:00 |  | 2021-03-01 00:00:00 |  | 2021-04-01 00:00:00 |  | 2021-05-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2021-07-01 00:00:00 |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00 |  | 2021-11-01 00:00:00
COMM. CALCULATION
[NAME] | Desktop Support | The Company | 2021-03-01 00:00:00 | 2021-06-30 00:00:00 | 21 | 140 | 200 | 250 |  |  | 1
Spreadsheet: 815642d1675124940-format-and-datedif-question-datedifexample
Sheet: Sheet1

random date/time |  |  | sorted and formatted |  |  | days between | months between
Spreadsheet: 91611d1291300523-vlookup-isna-and-iserror-faster-formula-tempfsrtemp
Sheet: FSR_NGP

AUTONO | ESN | CODE | SEG | DOI | WARR | SE CODE | SE NAME | COMPL_SRNO | FSR NO | HRS | TYPE OF SERVICE (W, CSP, PS, AMC, PM, C) | NATURE OF COMPLAINT | ACTION TAKEN | DATE & TIME ATTENDED (format mm/dd/yyyy hr:[NAME]) | DATE & TIME COMPLETED (format mm/dd/yyyy hr:[NAME]) | DURATION | [NAME] | LEVEL | TA BILL FROM - TO DATE |  | TA BILL AMT | TA BILL AMOUNT (WITH [NAME]) | MONTH&YEAR | SECODE
NGP/10-11/0001 | 022105/0601898 | I0056:  TOWERS LTD:  :  H:  G:  IN25044:  [NAME]:  WABC | G | 2006-03-09 00:00:00 | PW | P0001 | PANDURANG | 2044705 | 17884 | 22 | PM | ANKD | OK | 2010-04-01 14:00:00 | 2010-04-01 15:00:00 | 01:00:00 | CLOSED |  |  |  |  | 0 | 42010 | P0001
NGP/10-11/0002 | 022105/0702481 | I0056:  TOWERS LTD:  [NAME]:  H:  G:  IN24276:  KEABC:  WASABC | G | 2007-04-20 00:00:00 | PW | P0001 | PANDURANG | 2044706 | 17883 | 23 | PM | ANKD | OK | 2010-04-01 12:00:00 | 2010-04-01 13:00:00 | 01:00:00 | CLOSED |  |  |  |  | 0 | 42010 | P0001
NGP/10-11/0003 | 393005/0800650 | I0056:  TOWERS LTD:  :  R:  G:  IN23987:  REKHIABC:  WARABC | G | 2008-05-10 00:00:00 | W | N0001 | NARAYAN | 2044707 | 17882 | 24 | PM | ANJA | OK | 2010-04-01 15:30:00 | 2010-04-01 17:00:00 | 01:30:00 | CLOSED |  |  |  |  | 0 | 42010 | P0001
NGP/10-11/0004 | 4H2676/0800152 | K0240:  [NAME]:  OTHER:  R40:  I:  :  CHANABC:  CHANABC | I | 2008-04-12 00:00:00 | PW | R0001 | RAMESHWAR | 2044708 | 17858 | 29 | PS | ANJA | OK | 2010-04-01 16:00:00 | 2010-04-01 18:00:00 | 02:00:00 | CLOSED |  |  |  |  | 0 | 42010 | C0001