tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35164__MgmtSum-Q3-0921_Global
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-09-01 00:00:00 | 3RD QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD | Results based on activity through September 21, 2000
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
 | Liquids |  | 4333 | 0 | 0 | -374 | 0 | 3959 |  | 0 | 3959 | 20000 | -16041
COAL | Coal |  | 2919 | -7361.073 | 2.307 | 0 | 0 | -4439.766000000001 |  | 0 | -4439.766000000001 | 12747 | -17186.766 |  |  | 9507.2 | -8596.058 | 18103.258
SO2 | Emissions |  | 2458 | 0 | 0 | 0 | 0 | 2458 |  | 0 | 2458 | 750 | 1708 |  |  | 645.9 | 2279.39 | -1633.49
WEATHER | Weather |  | 3238.305 | 0 | 0 | 0 | 0 | 3238.305 |  | 0 | 3238.305 | 3215 | 23.30499999999984 |  |  | 2332.4 | 2355.705 | -23.30499999999984
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 7712 | -7712 |  |  | #REF! | #REF! | #REF!
ECT_INV_IRFX | Equity Trading |  | 13252.119 | 0 | 0 | 0 | 0 | 13252.119 |  | 0 | 13252.119 |  | 4305.119000000001
 | FX / Int Rate Trading |  | 1903 | 0 | 0 | 0 | 0 | 1903 |  | 0 | 1903 | 0 | 1903 |  |  | #REF! | #REF! | #REF!
 | Soft Commodities Trading |  | -25.469 | 0 | 0 | 0 | 0 | -25.469 |  | 0 | -25.469 | 0 | -25.469
 | Grain Trading |  | -32.627 | 0 | 0 | 0 | 0 | -32.627 |  | 0 | -32.627 | 0 | -32.627
 | Meat Trading |  | 1.198 | 0 | 0 | 0 | 0 | 1.198 |  | 0 | 1.198 | 0 | 1.198
 | Financial Trading |  | 15098.221 | 0 | 0 | 0 | 0 | 15098.221 |  | 0 | 15098.221 | 8947 | 6151.221000000001
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | Overview |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 6786 | -6786
 | Subtotal Gross Margin |  | 28046.526 | -7361.073 | 2.307 | -374 | 0 | 20313.76 | 0 | 0 | 20313.76 | 60157 | -39843.24 |  |  | #REF! | #REF! | #REF!
 | Other Interest Related Charges |  | 0 | 0 | 0 | -516.832 | 0 | -516.832 |  | 0 | -516.832 | -538.419 | 21.58699999999999
 | EGM Gross Margin |  | 28046.526 | -7361.073 | 2.307 | -890.832 | 0 | 19796.928 | 0 | 0 | 19796.928 | 59618.581 | -39821.65300000001
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 767901d1644706092-removing-blanks-array-formulas-removing-blanks-array-formulas-
Sheet: Removing Blanks

 |  |  |  | PLAYER RANKINGS
CONFIRMED PLAYERS |  |  |  | 1 | 2 | 3 | 4 |  | PRESENT |  | Y |  | SINCE ONLY 4 PLAYERS CAN PLAY AT A TIME (2vs2 ON ONE SINGLE COURT), WITH 12 PLAYERS PRESENT, 8 PEOPLE WOULD BE SITTING OUT. THAT IS WHAT THIS "SITTER'S CALCULATOR" IS FOR…WHICH I THEN USE TO MANUALLY POPULATE A LIST OF SITTERS FOR THE PLAYERS TO SEE.
1 |  | 1 |  |  |  |  |  |  | 1 | NATHAN | Y
2 |  | 4 |  |  |  |  |  |  | 2 | ESTHER | Y
3 |  | 2 |  |  |  |  |  |  | 3 | JOE | Y
4 |  | 4 |  |  |  |  |  |  | 4 | CHRIS | Y
5 |  | 3 |  |  |  |  |  |  | 5 | ANDY | Y
6 |  | 2 |  |  |  |  |  |  | 6 | VANESSA | Y
7 |  | 1 |  |  |  |  |  |  | 7 | [NAME] | Y
8 |  | 4 |  |  |  |  |  |  | 8 | SARA | Y
9 |  | 3 |  |  |  |  |  |  | 9 | TOM | Y
10 |  | 1 |  |  |  |  |  |  | 10 | VIKAS | Y
11 |  | 2 |  |  |  |  |  |  | 11 | MINH | Y |  | THESE ARE 4 OF THE 8 DIFFERENT ARRAY FORMULAS I'VE TRIED. ONLY THE FIRST ONE HAS WORKED FOR ME
12 |  | 3 |  |  |  |  |  |  | 12 | STEVE | Y
 |  |  |  |  |  |  |  |  |  |  |  |  | SITTERS CALCULATOR
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | THE ONLY WAY [NAME] TO MAKE THIS FORMULA WORK & NOT DISPLAY THE #[NAME]! [NAME] IS LIKE THIS…
 |  |  |  |  |  |  |  |  |  |  |  |  | SITTERS CALCULATOR
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | BY CREATING A "DUMMY" VERSION OF THE COLUMN, HIDDEN BELOW (SHOWING THE #[NAME]! ERROR, BUT THEN THE "FINAL" VERSION THAT I WANT TO LOOK AT (ABOVE) POINTING TO THE "DUMMY" AND NOT RETURNING THE ERROR.
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | SITTERS CALCULATOR
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
Spreadsheet: 102607d1300556660-2-way-lookup-index-or-any-command-2-way-value-lookup
Sheet: ChildTable 

17-27A1 | Month | [NAME] #1 |  |  | [NAME] #2 |  |  | [NAME] #3 |  |  | Initial Abstraction
 |  | R1 | T1 | K1 | R2 | T2 | K2 | R3 | T3 | K3 | [NAME] | Rec. | Init.
 | Jan |  | 2 | 3 | 0 | 2 | 3 | 0 | 2 | 3 | 0 | 0 | 0
 | Feb | 0.0025 | 0.75 | 1 | 0.002 | 1 | 2 | 0.005 | 2.5 | 5 | 0 | 0 | 0
 | Mar | 0.008 | 0.75 | 1 | 0.009 | 1.5 | 2 | 0.058 | 4 | 7 | 0 | 0 | 0
 | Apr | 0.006 | 1 | 1 | 0.008 | 1.25 | 2 | 0.02 | 2.5 | 5 | 0 | 0 | 0
 | May | 0.009 | 0.75 | 1 | 0.015 | 1 | 2 | 0.03 | 2.5 | 5 | 0 | 0 | 0
 | Jun | 0.006 | 0.75 | 1 | 0.008 | 1 | 2 | 0.008 | 2.5 | 5 | 0 | 0 | 0
 | Jul | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | Aug | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | Sep | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | Oct | 0.006 | 0.75 | 1 | 0.006 | 1 | 2 | 0.012 | 2.5 | 5 | 0 | 0 | 0
 | Nov | 0.004 | 0.75 | 1 | 0.005 | 1 | 1.5 | 0.009 | 2.5 | 5 | 0 | 0 | 0
 | Dec | 0.006 | 0.75 | 1 | 0.0065 | 1 | 2 | 0.015 | 2.5 | 5 | 0 | 0 | 0
 |  |  | The yellow highlighted need to be inserted with a correct formula
 | Sum of Value | Column Labels
 | Row Labels | K1 | K2 | K3 | R1 | R2 | R3 | T1 | T2 | T3 | Grand Total
 | 17-27A1 | 11 | 18.5 | 45 | 0.0048 | 0.006000000000000001 | 0.0157 | 8.25 | 10.75 | 23.5 | 117.0265
 | Jan | 3 | 3 | 3 | 0 | 0 | 0 | 2 | 2 | 2 | 15
 | Feb | 1 | 2 | 5 | 0.0003 | 0.0002 | 0.0005 | 0.75 | 1 | 2.5 | 12.251
 | Mar | 1 | 2 | 7 | 0.0008 | 0.0009 | 0.0058 | 0.75 | 1.5 | 4 | 16.2575
 | Apr | 1 | 2 | 5 | 0.0006 | 0.0008 | 0.002 | 1 | 1.25 | 2.5 | 12.7534
 | May | 1 | 2 | 5 | 0.0009 | 0.0015 | 0.003 | 0.75 | 1 | 2.5 | 12.2554
 | Jun | 1 | 2 | 5 | 0.0006 | 0.0008 | 0.0008 | 0.75 | 1 | 2.5 | 12.2522
 | Oct | 1 | 2 | 5 | 0.0006 | 0.0006 | 0.0012 | 0.75 | 1 | 2.5 | 12.2524
 | Nov | 1 | 1.5 | 5 | 0.0004 | 0.0005 | 0.0009 | 0.75 | 1 | 2.5 | 11.7518
 | Dec | 1 | 2 | 5 | 0.0006 | 0.0007 | 0.0015 | 0.75 | 1 | 2.5 | 12.2528
 | Grand Total | 11 | 18.5 | 45 | 0.0048 | 0.006000000000000001 | 0.0157 | 8.25 | 10.75 | 23.5 | 117.0265
Spreadsheet: 89348d1289156151-averaging-the-average-of-non-unique-cells-with-unique-cells-attendance
Sheet: Sheet1

Date | Animal |  | [NAME] | [NAME] | Jake | [NAME] | Lauren | Nate | [NAME] | Tara
2010-01-05 00:00:00 | English |  | 1 |  | 1 |  | 1 |  | 1 | 1
2010-01-05 00:00:00 | History |  | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  |  | Example1: |  |  | Example2:
2010-01-05 00:00:00 | Physics |  | 1 | 1 |  | 1 |  | 1 |  | 1 |  |  | Name | Attendance |  | Name | Attendance
2010-01-06 00:00:00 | English |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | [NAME] |  |  | [NAME] | 0.68
2010-01-06 00:00:00 | Art |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  | [NAME] |  |  | [NAME] | 0.513
2010-01-07 00:00:00 | English |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  | Jake |  |  | Jake | 0.827
2010-01-08 00:00:00 | History |  | 1 |  | 1 | 1 |  |  | 1 | 1 |  |  | [NAME] |  |  | [NAME] | 0.553
2010-01-09 00:00:00 | Geometry |  |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  | Lauren |  |  | Lauren | 0.627
2010-01-09 00:00:00 | Physics |  | 1 |  | 1 | 1 | 1 |  |  | 1 |  |  | Nate |  |  | Nate | 0.453
2010-01-09 00:00:00 | English |  |  |  | 1 |  |  | 1 | 1 | 1 |  |  | [NAME] |  |  | [NAME] | 0.893
2010-01-09 00:00:00 | History |  | 1 |  | 1 | 1 | 1 |  | 1 | 1 |  |  | Tara |  |  | Tara | 0.82
2010-01-09 00:00:00 | Geometry |  |  | 1 |  | 1 | 1 | 1 | 1
Spreadsheet: 674734d1587998669-sumifs-issues-test
Sheet: Formula

 | Jun
 | Green | Amber | Red
Set 1
Set 2
Set 3
Set 4
Set 5
set 6
Set 7
Set 8
Set 9
Set 10
Spreadsheet: 487921d1478306223-sorting-entry
Sheet: Sheet1

Sl | Code | Category | Item | c>NO | Admn.No | Name | Class | C.No | Admn.No | Name | Class
70 | 329 | SENIOR BOYS | 100 M | 201 | 1093 | MUHD. SUHAIL P | C2 | 214 | 1087 | SAINUL ABITH | C2 | I need the sorting like this
71 | 330 | SENIOR BOYS | 200 M | 601 | 1006 | SYAMDEV K | C2 | 402 | 1011 | AMEERALI. T.P | H2 | For all students with out repeating their names
72 | 331 | SENIOR BOYS | 400 M | 402 | 1011 | AMEERALI. T.P | H2 | 602 | 1043 | MUHD. IRSHAD P | C2 | Name | Ad.No | Items
73 | 332 | SENIOR BOYS | 800 M | 605 | 1228 | IRSHAD. P | C1 | 206 | 1053 | ABDUL MALIK A | C2 | MUHD. SUHAIL P | 1093 | 100M | LONG JUMP
74 | 333 | SENIOR BOYS | 1500 M | 605 | 1228 | IRSHAD. P | C1 | 206 | 1053 | ABDUL MALIK A | C2 | IRSHAD. P | 1228 | 800m | 1500M | 5000M
75 | 334 | SENIOR BOYS | 5000 M | 605 | 1228 | IRSHAD. P | C1 | 604 | 1086 | ABDUL JALEEL AT | C2
76 | 337 | SENIOR BOYS | LONGJUMP | 201 | 1093 | MUHD. SUHAIL P | C2 | 210 | 914 | MOHD. HASHIR.P.P | H2
77 | 338 | SENIOR BOYS | HIGH JUMP | 210 | 914 | MOHD. HASHIR.P.P | H2 | 408 | 1251 | ASHIQ AJMAL K C | C1
78 | 341 | SENIOR BOYS | SHOTPUT | 412 | 1216 | MUHD. SARTHAS.OK | C1 | 609 | 1081 | ANAS.M | H2
79 | 342 | SENIOR BOYS | DISCUS THROW | 412 | 1216 | MUHD. SARTHAS.OK | C1 | 609 | 1081 | ANAS.M | H2
80 | 343 | SENIOR BOYS | JAVALIN THROW | 409 | 1179 | SREEJITH. P | C1 | 411 | 1094 | MUHD. NIYAS A C | C2
81 | 346 | SENIOR BOYS | 4 X 100 RELAY | 211 | 1226 | AJITH. N.K | C1 | 0 | #N/A | #N/A | #N/A
82 | 348 | SENIOR GIRLS | 100 M | 422 | 1205 | LATHEEFA. [NAME] | H1 | 616 | 900 | ARIFA. [NAME] | H2
83 | 349 | SENIOR GIRLS | 200 M | 415 | 1034 | SUJIMOL. [NAME] | H2 | 416 | 1242 | ASNA .E .T | C1
84 | 350 | SENIOR GIRLS | 400 M | 422 | 1205 | LATHEEFA. [NAME] | H1 | 615 | 1092 | JAYASREE | C2
85 | 351 | SENIOR GIRLS | 800 M | 616 | 900 | ARIFA. [NAME] | H2 | 415 | 1034 | SUJIMOL. [NAME] | H2
86 | 352 | SENIOR GIRLS | 1500 M | 224 | 1265 | RAIHA MILAN. V.K | C1 | 416 | 1242 | ASNA .E .T | C1
87 | 353 | SENIOR GIRLS | 3000 M | 422 | 1205 | LATHEEFA. [NAME] | H1 | 224 | 1265 | RAIHA MILAN. V.K | C1
88 | 354 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
89 | 357 | SENIOR GIRLS | LONGJUMP | 416 | 1242 | ASNA .E .T | C1 | 0 | #N/A | #N/A | #N/A
90 | 361 | SENIOR GIRLS | SHOTPUT | 419 | 1188 | SABANA ASMIN. M.A | C1 | 219 | 1037 | SHIBILA MUHD..A | H2
91 | 362 | SENIOR GIRLS | DISCUS THROW | 219 | 1037 | SHIBILA MUHD..A | H2 | 419 | 1188 | SABANA ASMIN. M.A | C1
92 | 363 | SENIOR GIRLS | JAVALIN THROW | 420 | 1211 | FAIROOSA. M | H1 | 615 | 1092 | JAYASREE | C2
93 | 366 | SENIOR GIRLS | 4 X 100 RELAY | 419 | 1188 | SABANA ASMIN. M.A | C1 | 615 | 1092 | JAYASREE | C2
Spreadsheet: 106972d1304106248-type-of-lookup-function-sample
Sheet: TELE DONT TOUCH

Loan # | Consultant | Disburse Date | [NAME]? | Loan Amount | Borrower | Investor | LP/BP | Costs Paid | Units | Date | Source | Type | Title | Fee | Fee | Gross | Comm. Rate | Comm. Rate | Comm. Rate | BONUS | Proc | PROC | Check Amt | Bonus Chk
Spreadsheet: 164850d1340908088-excel-2007-consolidating-text-data-trial-for-excel-file-example-for-forum
Sheet: Sheet4

West | iTime
[NAME] | 0
Math Call Kara 4444 | 0
Math [NAME] 3333 | 0
[NAME] | 0
[NAME] | 0
Math [NAME] 3333 | 0
Math [NAME] 4678 | Math [NAME] 4678
Math [NAME] 5678 | Math [NAME] 5678
Math Smith James 2364 | Math Smith James 2364
 | 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
 | 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
 | 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
 | 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
Spreadsheet: 231182d1366974401-moving-row-to-another-sheet-inactive
Sheet: Sheet1

Name | Address | Telephone | [NAME]
Iron Man | Stark Co. | (001) 123-1313 | [EMAIL] | Inactive |  | Active
[NAME] | [NAME] house | [NAME] phone | [NAME] email | Active |  | Inactive
[NAME] | idk | 123123? | what's an email? | Inactive
Insert something here | whatever | whatever | [EMAIL] | Inactive
huh? | wut? | wait what? | *blank* | Active
Spreadsheet: 451146d1458058886-new-to-index-index-formula-not-working-aprils-traveler-print-out-index
Sheet: Sheet1

 |  | WO# | 72376-01 | 14
Row | Pn# | Step # | Op Description | Machine | Vendor | Operation
8 | PP1081730 | 10 | ASSEMBLE COMPONENTS PP1081730-1, 6X5XE, PP1081730-3 AND 020622 | ASSEMBLY | 0 | ASSEMBLY
9 | PP1081730 | 20 | WELD COMPONENTS PP1081730-1, 6X5XE, PP1081730-3 AND 020622 | WELDER | 0 | WELD
10 | PP1081730 | 30 | INSPECT WELD OF COMPONENTS | INSPECT | 0 | INSPECT
11 | PP1081730 | 40 | [NAME] 1ST OP MILLING OF WELDED COMPONENTS | VF5D | 0 | MILL 1ST OP
12 | PP1081730 | 50 | INSPECT MILL OP | INSPECT | 0 | INSPECT
13 | PP1081730 | 60 | ASSEMBLE REMAINING COMPONENTS 5XL9, 5XL4A5-6, 5XL4B5-6, 5XL4C5-6, PP1081730-7, 020322A9-10, 020322B9-10, 020322C9-10 AND 020322D9-10 | ASSEMBLY | 0 | ASSEMBLY
14 | PP1081730 | 70 | WELD REMAINING COMPONENTS 5XL9, 5XL4A5-6, 5XL4B5-6, 5XL4C5-6, PP1081730-7, 020322A9-10, 020322B9-10, 020322C9-10 AND | WELDER | 0 | WELD
15 | PP1081730 | 80 | INSPECT WELD OP | INSPECT | 0 | INSPECT
16 | PP1081730 | 90 | STRESS RELIEVE PER SPEC MP917 | 0 | COLEMAN | 0
17 | PP1081730 | 100 | INSPECT STRESS RELIEVE | INSPECT | 0 | INSPECT
18 | PP1081730 | 110 | COMPLETE 2ND MILL OP AND MARKING REQUIREMENT | VF5C | 0 | MILL 2ND OP
19 | PP1081730 | 120 | INSPECT 2ND MILL OP | INSPECT | 0 | INSPECT
20 | PP1081730 | 130 | HYDROSTATIC LEAK TEST PER QSA 22 | 0 | ELEMENT | 0
21 | PP1081730 | 140 | 1ST ARTICLE REQUIRED | 1ST ARTICL | 0 | 1ST ARTICLE
Spreadsheet: 729769d1619332623-formula-to-search-the-name-of-cell-c7-from-master-sheet-form-for-help_v1
Sheet: FORM

 | Department | Engineering
 | Job Level | LV_09
NO | EMP ID | NAME
1
2
3
4
5
Spreadsheet: 848594d1699295026-get-data-from-web-pq-3tables
Sheet: Table 3

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10
[NAME] | [NAME]
Fastforrentet lån med afdrag (årgang 2056)30 år / 5,0 %DK0004626918 | 30 år / 5,0 % | SE DETALJER | Fastforrentet lån med afdrag (årgang 2056) | DK0004626918 | 97,750 | 97,642 | 97,632 | 97,436 | 97,009
Fastforrentet lån med op til 10 års afdragsfrihed (årgang 2056)30 år / 5,0 %DK0004627056 | 30 år / 5,0 % | SE DETALJER | Fastforrentet lån med op til 10 års afdragsfrihed (årgang 2056) | DK0004627056 | 97,000 | 96,988 | 96,881 | 96,684 | 96,250
[NAME] med op til 30 års afdragsfrihed (årgang 2056)30 år / 5,0 %DK0004626405 | 30 år / 5,0 % | SE DETALJER | [NAME] med op til 30 års afdragsfrihed (årgang 2056) | DK0004626405 | 95,550 | 95,465 | 95,429 | 95,228 | 94,782
Fastforrentet lån med afdrag (årgang 2056)30 år / 4,0 %DK0004627130 | 30 år / 4,0 % | SE DETALJER | Fastforrentet lån med afdrag (årgang 2056) | DK0004627130 | 93,200 | 93,960 | 93,127 | 93,007 | 92,788
Fastforrentet lån med afdrag (årgang 2046)20 år / 4,0 %DK0004626835 | 20 år / 4,0 % | SE DETALJER | Fastforrentet lån med afdrag (årgang 2046) | DK0004626835 | 94,550 | 94,375 | 94,479 | 94,362 | 94,154
Fastforrentet lån med afdrag (årgang 2036)10 år / 3,0 %DK0004626751 | 10 år / 3,0 % | SE DETALJER | Fastforrentet lån med afdrag (årgang 2036) | DK0004626751 | 94,810 | 94,700 | 94,791 | 94,761 | 94,801
Spreadsheet: 775523d1649164165-unique-count-and-output-total-count-for-ids-that-meet-condition-test15v2
Sheet: Sheet1

Serial number |  | Status | ID | Expected | [NAME]
8304013772222700 |  | ISSUED | 568154112108 | 2
8304013772222700 |  | ISSUED | 568154112108 | 2
8336013926733800 |  | ISSUED | 568154112108 | 2
8336013926733800 |  | ISSUED | 568154112108 | 2
3130002954967539 |  | RENEWED | 561448899106 | 1
3130002954967539 |  | RENEWED | 561448899106 | 1
5121000063401700 |  | ISSUED | 559371321100 | 1
8328014380747500 |  | ISSUED | 578954125102 | 3
9192018767647000 |  | ISSUED | 578954125102 | 3
9192018767627000 |  | ISSUED | 578954125102 | 3
0344024411523300 |  | ISSUED | 578923232107 | 1
0344024410593300 |  | ISSUED | 578871123104 | 1
9182018896990400 |  | ISSUED | 579497650100 | 1
0338025304809400 |  | ISSUED | 578899478102 | 1
5121000040271700 |  | REMOTE CANCELLED | 560567694101 | 1
6011003631952200 |  | EXPIRED | 560567694101 | 1
9192018578757000 |  | REMOTE CANCELLED | 560567694101 | 1
9192018578717000 |  | ISSUED | 560567694101 | 1
9192018579187000 |  | REMOTE CANCELLED | 560567694101 | 1
9192018578737000 |  | ASSIGNED | 560567694101 | 1
9192018578727000 |  | ASSIGNED | 560567694101 | 1
2015015612958124 |  | ISSUED | 561874035104 | 1
2015018321958125 |  | RENEWED | 558862935103 | 1
8328014621737500 |  | ISSUED | 578721906104 | 1
8328014621737500 |  | ISSUED | 578721906104 | 1
3270023086970269 |  | REMOTE CANCELLED | 560738520104 | 0
Spreadsheet: 329511d1404325948-trouble-with-sumif-formula-on-totals-tab-example-payroll-2
Sheet: Totals

Starting Weekday | Ending Week Day
2014-06-23 00:00:00
Client/Event | Total Frequency | Total Hours Billed | Payment Amount |  | Total Hours Billed To Clients
Becky | ? | ? | ? |  | Total Amount Payments Received
Kelly | ? | ? | ? |  | Total Amount Paid to Trainers
[NAME] | ? | ? | ? |  | Total Profit:
[NAME] | ? | ? | ?
Muffy | ? | ? | ?
[NAME] | ? | ? | ? |  | # 60 Minute Sessions
Leo | ? | ? | ? |  | # 45 Minute Sessions
Client | ? | ? | ? |  | # 30 Minute Sessions
Client | ? | ? | ? |  | # [NAME]
Client | ? | ? | ? |  | # Hours Office Work
Client | ? | ? | ? |  | # [NAME]
Client | ? | ? | ?
Client | ? | ? | ?
 |  |  |  |  | [NAME] | Total Hours | Total Amount Paid to [NAME]
 |  |  |  |  | Ceci
 |  |  |  |  | Kilee
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
 |  |  |  |  | New Hire
Spreadsheet: 788424d1658471136-conditional-formatting-with-and-or-functuion-planning-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Proposal Schedule
Sl. | Type | Client | PROJECT NAME | SCOPE | FROM | From1 | Bid Dur. | TO1 | TO | NOA | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 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
1 |  |  | Project ABC | PKG1 | 2022-05-26 00:00:00 | 2022-11-01 00:00:00 |  | 2022-12-01 00:00:00 | 2022-09-30 00:00:00 | 2022-07-01 00:00:00
2 |  |  | Project 12 | JP2 | 2022-05-26 00:00:00 | 2022-11-01 00:00:00 |  | 2022-12-01 00:00:00 | 2022-09-30 00:00:00 | 2023-04-15 00:00:00
3 |  |  | Project X | Upgrade AM | 2022-05-26 00:00:00 | 2022-12-01 00:00:00 |  | 2023-02-01 00:00:00 | 2022-09-30 00:00:00 | 2023-04-15 00:00:00
4 |  |  | [NAME] | Pipeline, | 2022-06-13 00:00:00 | 2023-02-01 00:00:00 |  | 2023-05-01 00:00:00 | 2022-08-04 00:00:00 | 2022-03-01 00:00:00
5 |  |  | Project Y3 | Modificaton | 2022-06-13 00:00:00 | 2023-01-01 00:00:00 |  | 2024-02-01 00:00:00 | 2022-08-04 00:00:00 | 2022-03-01 00:00:00
Spreadsheet: 701374d1603726486-how-to-stack-data-from-multiple-columns-on-a-different-sheet-client-outreach-individual-draft-michelle-1-
Sheet: SA

 | MICHELLE
 | DATE | CLIENT | TASK | SA NOTES | COMPLETED | RESULT
Sample |  | [NAME] | THANK YOU | Mention POA, WE, and GC |  | Will commit to POA, WE, GC
What I want the spreadsheet to do |  | These cells will populate from MGMT sheet Column C - probably using an HLOOKUP function | These cells will populate from MGMT sheet to return the  HEADING of the referenced column. I1 If [NAME] was from I, L1 if date was from L, O1 if date was from O, R1 if date was from R, U1 if date was from R
Spreadsheet: 717246d1612540658-sumproduct-numbers-only-in-a-filtered-range-20210112_stages-of-files_o-new-2
Sheet: Register

 |  |  |  |  |  |  |  |  | Stage 1 – Referral Received at OPPT |  |  |  | Files held within OPPT
 |  |  |  |  |  |  |  |  | Stage 2 – Case allocated to  SME |  |  |  | OPPT files held externally
 |  |  |  |  |  |  |  |  | Stage 3 – Investigation in progress
 | OPTAG |  |  |  |  |  |  |  | Stage 4 – Pending - Awaiting further information |  |  |  | Live Tasks within 20 working days
 | Stages of Files |  |  |  |  |  |  |  | Stage 5 – Advice provided. Referral cleared |  |  |  | Live Tasks over 20 working days
 | Date File Received | Name | Member  No: / Nino: | File Week  Number | Scheme | Category | Allocated to OPPT Department | Primary SME | Secondary SME | Case History | Status | Duration Working Days | Registered  By | File  Location | Date File Returned | mo
 | 2021-01-12 00:00:00 |  |  | 1 | AFCS | GIP Calculations | OPTAG | [NAME] | Q |  | Stage 3 |  | [NAME] | 6421 Cab 2
 | 2021-01-16 00:00:00 |  |  | 1 | AFCS | Civil Litigation | OPTAG | [NAME] | W |  | Stage 1 |  | [NAME] | 6421 Cab 4
 | 2020-11-16 00:00:00 |  |  | 1 | AFCS | Civil Litigation | OPTAG | [NAME] | Q |  | Stage 3 |  | [NAME] | A16 / Dr Braidwood
 | 2020-11-12 00:00:00 |  |  | 1 | AFCS | GIP Calculations | OPTAG | [NAME] | W |  | Stage 3 |  | [NAME] | A16 / Dr Braidwood
 | 2021-01-16 00:00:00 |  |  | 1 | AFCS | Civil Litigation | OPTAG | [NAME] | W |  | Stage 1 |  | [NAME] | A16 / Dr Braidwood
 | 2020-11-16 00:00:00 |  |  | 1 | AFCS | Civil Litigation | OPTAG | [NAME] | Q |  | Stage 3 |  | [NAME] | N/A File not required
 | 2021-01-12 00:00:00 |  |  | 1 | AFCS | GIP Calculations | OPTAG | [NAME] | W |  | Stage 4 |  | [NAME] | N/A File not required
 | 2021-01-16 00:00:00 |  |  | 1 | AFCS | Civil Litigation | OPTAG | [NAME] | W |  | Stage 5 |  | [NAME] | A16 / Dr Braidwood | 2021-01-18 00:00:00
 | 2020-11-16 00:00:00 |  |  | 1 | AFCS | Civil Litigation | OPTAG | [NAME] | Q |  | Stage 3 |  | [NAME] | N/A File not required
Spreadsheet: 195082d1353417525-text-to-columns-book2
Sheet: Sheet1

Micro company, |  | Micro company, | 24 street, | Mr [NAME], | +1 258 3652 3625, | +1 258 3652 3625, | [EMAIL], | www.clientdomain.com, | ,
24 street, |  | Second company | 24 street, | Mr [NAME], | +1 258 3652 3625, | +1 258 3652 3625, | [EMAIL], | www.clientdomain.com, | 0
Mr [NAME],
+1 258 3652 3625,
+1 258 3652 3625,
[EMAIL],
www.clientdomain.com,
,
Second company
24 street,
Mr [NAME],
+1 258 3652 3625,
+1 258 3652 3625,
[EMAIL],
www.clientdomain.com,