tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: November

 |  |  |  | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri
S.no | Employee Name | SID | Process | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-17 00:00:00 | 2012-11-18 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-24 00:00:00 | 2012-11-25 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 6db20d96-ab42-4ba3-939c-36cbde66aaa0
Sheet: Totals

Total Cost Estimate
DISCLAIMER: This is a sample worksheet making assumptions for a specific scenario, and without considering partner discounts. You can use this worksheet as a sample to get you started.
These costs derive information from each of the other spreadsheets. Try adjusting the number of users on each page and see the results here. Also make note of the potential "revenues" on Storage sheet to offset these costs.
VM Cost / month
Storage
Storage tx
Bandwidth
Cache
Service Bus
Access Control
Total cost per month |  |  | Estimated costs if you use every aspect of Azure for a fictional business that hosts media
Revenue projection per month |  |  | Shot in the dark at revenue per media upload
Spreadsheet: 328270d1403850163-eliminating-duplicates-eliminating-duplicates
Sheet: Sheet1

Inputs | Required Output by formula |  | Inputs | Required Output by formula
A | A |  | 2014-01-01 00:00:00 | 2014-01-01 00:00:00
A | B |  | 2014-01-01 00:00:00 | 2014-01-02 00:00:00
A | C |  | 2014-01-02 00:00:00 | 2014-01-03 00:00:00
B | D |  | 2014-01-02 00:00:00 | 2014-01-04 00:00:00
B | E |  | 2014-01-02 00:00:00 | 2014-01-05 00:00:00
C | F |  | 2014-01-02 00:00:00
D |  |  | 2014-01-03 00:00:00
D |  |  | 2014-01-04 00:00:00
E |  |  | 2014-01-04 00:00:00
F |  |  | 2014-01-05 00:00:00
Spreadsheet: 109069d1305975431-finding-rank-a-much-quicker-way-book2
Sheet: DATA_SHEET

[NAME] | 296 | 885 | 556 | 45 | 658 | 938 | 396 | 767 | 452 | 814 | 385 | 768
Territory1Data2 | 205 | 416 | 417 | 599 | 156 | 688 | 520 | 589 | 208 | 591 | 33 | 45
Territory1Data3 | 157 | 743 | 490 | 162 | 459 | 822 | 164 | 942 | 549 | 70 | 582 | 463
Territory1Data4 | 201 | 84 | 608 | 966 | 896 | 629 | 321 | 484 | 90 | 565 | 662 | 455
Territory1Data5 | 950 | 298 | 973 | 382 | 151 | 883 | 711 | 760 | 476 | 282 | 71 | 478
[NAME] | 932 | 259 | 436 | 323 | 571 | 600 | 886 | 791 | 368 | 827 | 75 | 960
Territory1Data7 | 950 | 530 | 958 | 197 | 443 | 916 | 658 | 652 | 759 | 701 | 395 | 523
Territory1Data8 | 804 | 545 | 877 | 127 | 941 | 493 | 87 | 694 | 544 | 480 | 320 | 668
Territory1Data9 | 267 | 176 | 718 | 412 | 739 | 37 | 217 | 797 | 90 | 815 | 464 | 952
Territory1Data10 | 749 | 13 | 979 | 90 | 94 | 894 | 791 | 856 | 545 | 396 | 758 | 210
Territory1Data11 | 682 | 188 | 21 | 538 | 136 | 514 | 750 | 906 | 96 | 360 | 390 | 560
Territory1Data12 | 320 | 810 | 68 | 270 | 776 | 371 | 941 | 443 | 746 | 423 | 700 | 792
Territory1Data13 | 74 | 349 | 718 | 503 | 366 | 955 | 989 | 106 | 595 | 217 | 460 | 185
Territory2Data1 | 493 | 932 | 650 | 408 | 987 | 852 | 419 | 708 | 482 | 631 | 434 | 96
Territory2Data2 | 946 | 901 | 82 | 655 | 2 | 219 | 949 | 175 | 831 | 670 | 53 | 415
Territory2Data3 | 406 | 71 | 450 | 456 | 588 | 533 | 88 | 590 | 955 | 713 | 779 | 901
Territory2Data4 | 888 | 403 | 664 | 453 | 16 | 52 | 37 | 526 | 692 | 732 | 276 | 758
Territory2Data5 | 97 | 399 | 486 | 435 | 634 | 334 | 131 | 623 | 239 | 892 | 827 | 940
[NAME] | 687 | 89 | 803 | 977 | 360 | 993 | 642 | 916 | 745 | 427 | 993 | 952
Territory2Data7 | 161 | 993 | 573 | 13 | 734 | 273 | 881 | 317 | 956 | 571 | 283 | 325
Territory2Data8 | 469 | 390 | 118 | 614 | 610 | 287 | 614 | 119 | 504 | 367 | 592 | 371
Territory2Data9 | 821 | 322 | 682 | 490 | 615 | 448 | 338 | 761 | 313 | 606 | 64 | 918
Territory2Data10 | 607 | 441 | 91 | 230 | 805 | 948 | 737 | 74 | 786 | 459 | 359 | 76
Territory2Data11 | 816 | 72 | 127 | 793 | 220 | 288 | 489 | 769 | 75 | 39 | 623 | 501
Territory2Data12 | 9 | 717 | 229 | 736 | 624 | 411 | 378 | 349 | 544 | 424 | 463 | 145
Territory2Data13 | 875 | 818 | 551 | 314 | 997 | 188 | 254 | 256 | 812 | 550 | 880 | 117
Spreadsheet: 672720d1586970693-filter-with-multiple-or-criteria-help
Sheet: Team D

Team D
Brand | Inititative | Priority | Status | Launch Timing | Exp. Team / Business Team
 | Test 456 | 2 | In Progress | Q2 | Ops Marketing  International   Domestic Team A   Team D Team E
AB | Test 1122 | 3 | In Progress | Q2 | Team D
AB | Test 3120 | 3 | In Progress | Q2 | Team D
All Teams
Brand | Inititative | Priority | Status | Launch Timing | Exp. Team / Business Team
 | Test 2121 | 1 | Next on Deck | Q3 | All Teams
AB | Test 4119 | 1 | Requires Discovery | TBD | All Teams
EF | Test 6783 | 3 | On Hold | Q2 | All Teams
Spreadsheet: 489251d1479156665-trying-to-match-up-data-that-only-matches-in-the-middle-of-one-workbook-copy-of-2017-deadlines-and-programs
Sheet: Stine

[NAME] | Item Desc | Invoice $ | Low Net
35986-000-BG00 | CN ST R9417RIB VT3P P250 (BG)
35987-000-BG00 | CN ST R9417RIB VT3P P1250 (BG)
35990-000-BG00 | CN ST R9422RIB VT3P P125O(BG)
36006-000-BG00 | CN ST R9733E RIB VT3P P250(BG)
36010-000-BG00 | CN ST R9739 RIB VT3P P1250 (BG
36011-000-BG00 | CN ST R9740 RIB VT3P P250 (BG)
36012-000-BG00 | CN ST R9741 VT3P P250 (BG)
 |  | Invoice $ | Low Net
43501-BG00 | SB ST 35RF22 RR2 (BG)
43504-BG00 | SB ST 24RE03 RR2
43504-MB40 | SB ST 24RE03 RR2 (MB40)
43504-OPI-BG00 | SB ST 24RE03 RR2 [NAME] (BG)
43509-OPI-BG00 | SB ST 37RD22 RR2 PS+INOC(BG)
43512-BG00 | SB ST 3900-2 RR (BG)
43521-MB40 | SB ST 44LH22 LL (MB40)
43522-BG00 | SB ST 47LF32 LL(BG)
43523-MB40 | SB ST 47RC32 RR2 (MB)
43524-BG00 | SB ST 47RF32 RR2 (BG)
43524-OPX-BG00 | SB ST 47RF32 RR2 PS XTRA (BG)
43524-PXI-BG00 | SB ST 47RF32 RR2 PS XTRA+INOC
43526-BG00 | SB ST 48RD00 RR2 (BG)
43526-MB40 | SB ST 48RD00 RR2 (MB40)
43528-MB40 | SB ST 44LE02 LL (MB40)
43534-BG00 | SB ST 49LD02 LL (BG)
43534-MB40 | SB ST 49LD02 LL (MB40)
43534-OPI-BG00 | SB ST 49LD02 LL PS+INOC (BG)
43534-OPS-BG00 | SB ST 49LD02LL PROSHIELD (BG)
43534-OPX-BG00 | SB ST 49LD02LL PS XTRA (BG)
43534-PXI-BG00 | SB ST 49LD02 LL PS XTRA+IN(BG)
43540-0000 | SB ST 51RD02 RR2 (MB40)
43540-BG00 | SB ST 51RD02 RR2 (BG)
43540-OPS-MB40 | SB ST 51RD02 RR2 PROSHIELD(MB4
43541-BG00 | SB ST 51RH20 RR2 (BG)
43541-MB40 | SB ST 51RH20 RR2 (MB)
43543-MB40 | SB ST 52LD08 LL (MB40)
43545-MB40 | SB ST 55RI02 RR2 (MB40)
43546-BG00 | SB ST 54LE23 LL (BG)
43546-MB40 | SB ST 54LE23 LL (MB40)
43546-OPI-BG00 | SB ST 54LE23 LL PS+INOC (BG)
43546-OPS-BG00 | SB ST 54LE23 LL PROSHIELD (BG)
43546-PXP-BG00 | SB ST 54LE23 LL PS XTRA P (BG)
43547-0000 | SB ST 58LC23 LL (MB40)
43547-0010 | SB ST 58LC23 LL (BG)
43548-MB40 | SB ST 54LD00 LL (MB40)
43560-MB40 | SB ST 51LE20 LL (MB40)
43565-0010 | SB ST 4782-4 RR (BG)
43575-0000 | SB ST 4782-4 RR (MB40)
43595-MB40 | SB ST [PHONE] RR2 (MB40)
43650-BG00 | SB ST 61RF00 RR2 (BG)
43650-MB40 | SB ST 61RF00 RR2 (MB40)
43650-OAI-MB40 | SB ST 61RF00 [NAME]
43650-OPI-BG00 | SB ST 61RF00 [NAME] (BG)
43650-OPS-MB40 | SB ST 61RF00 [NAME]
43650-PXA-BG00 | SB ST 61RF00 RR PS XTRA A (BG)
43650-PXI-BG00 | SB ST 61RF00 RR PS XTRA+INOC(B
43655-0000 | SB ST 6202-4 RR (MB40)
43655-0010 | SB ST 6202-4 RR (BG)
43656-OAI-BG00 | SB ST 6202-4 RR PS XTRA A+INOC
43656-OPI-BG00 | SB ST 6202-4 RR PS+INOC (BG)
43656-OPI-MB40 | SB ST 6202-4 RR PS+INOC (MB40)
43656-OPS-BG00 | SB ST 6202-4 RR PROSHIELD (BG)
43656-OPX-BG00 | SB ST 6202-4 RR PS XTRA (BG)
43656-PXA-BG00 | SB ST 6202-4 RR PS XTRA A (BG)
43656-PXA-MB40 | SB ST 6202-4 RR PS XTRA A
43656-PXI-BG00 | SB ST 6202-4 RR PS XTRA+INO(BG
Spreadsheet: 842535d1694590080-cannot-figure-out-a-formula-for-a-weighted-average-with-na-as-an-option-test-file-3-
Sheet: Sheet1

 | Weight / Score | Proposed Weights | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Q1 | 3 | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Q2 | 0 | 0.055 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Q3 | 3 | 0.065 | 0.1344827586206896 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA
Q4 | NA | 0.1 | 0
 | 0.25 |  |  | This should still equal 25%
Q5 | 3 | 0.05
Q6 | 3 | 0.05 | 0.0625
Q7 | NA | 0.05 | 0
Q8 | 2 | 0.05 | 0.06249999999999999
Q9 | 3 | 0.05 | 0.0625
 | 0.3 |  |  | This should still equal 30%
Q10 | 3 | 0.03
Q11 | 3 | 0.02 | 0.02608695652173913
Q12 | NA | 0.02 | 0
Q13 | NA | 0.05 | 0
Q14 | 3 | 0.07 | 0.09130434782608697
Q15 | 3 | 0.07 | 0.09130434782608697
Q16 | 3 | 0.02 | 0.02608695652173913
Q17 | 3 | 0.02 | 0.02608695652173913
Spreadsheet: 113277d1309230726-best-way-to-get-adjusted-score-esc-hcp-adjusted-sheet
Sheet: Sheet1

Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back | Gross | HCP | NET
Par | 4 | 3 | 4 | 4 | 5 | 4 | 3 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4 | 5
Fred | 5 | 6 | 4 | 4 | 6 | 9 | 4 | 4 | 6 |  | 5 | 5 | 4 | 5 | 4 | 4 | 7 | 8 | 5 |  |  | 24
[NAME] | 6 | 4 | 4 | 4 | 12 | 8 | 5 | 7 | 9 |  | 6 | 6 | 5 | 5 | 8 | 7 | 5 | 5 | 10 |  |  | 33
[NAME] | 4 | 4 | 5 | 8 | 5 | 5 | 5 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 4 | 5 | 4 | 5 |  |  | 12
George | 4 | 3 | 4 | 4 | 5 | 6 | 6 | 4 | 5 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  | 9
Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back | Gross | HCP | NET
Par | 4 | 3 | 4 | 4 | 5 | 4 | 3 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4 | 5
Fred | 5 | 6 | 4 | 4 | 6 | 8 | 4 | 4 | 6 |  | 5 | 5 | 4 | 5 | 4 | 4 | 7 | 8 | 5 |  |  | 24
[NAME] | 6 | 4 | 4 | 4 | 9 | 8 | 5 | 7 | 9 |  | 6 | 6 | 5 | 5 | 8 | 7 | 5 | 5 | 9 |  |  | 33
[NAME] | 4 | 4 | 5 | 7 | 5 | 5 | 5 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 4 | 5 | 4 | 5 |  |  | 12
George | 4 | 3 | 4 | 4 | 5 | 6 | 5 | 4 | 5 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  | 9
Fred's HCP is 24.  Most he can score on a hole is a 8.
[NAME]'s HCP is 33.  Most he can score on a hole is a 9.
[NAME]'s HCP is 12.  Most he can score on a hole is a 7.
George's HCP is 9.  Most he can score on a hole is double bogey (2 over Par).
And a golfer with a HCP of 40 plus.  Most he can score on a hole is 10
Spreadsheet: 704915d1605803850-copy-paste-values-from-equation-data-on-a-separate-sheet-in-the-same-workbook-example-2-
Sheet: Sheet2

Total time* | PL Sum** | PL CHK 1 | PL CHK 2 | PL CHK 3 | [NAME]* | Rot CHK 1 | Rot CHK 2 | Rot CHK 3 | * Adjust ranges accordingly
 |  |  |  |  |  |  |  |  | ** Adjust to range from CHK1 Tto CHK3
Sensor | PL: A/V (cm) | PL: V Puncture (cm) | PL: [NAME] (cm) | [NAME] (cm) | Rot: A/V (*) | Rot: V Puncture(*) | Rot: Guidewire (*) | [NAME] (*) | Acc Sum | Time (s)
R Forearm
R Dorsum | Yadda | [NAME] | Poo | 1 | 2 | 3 | 4 | 5 | 6 | 7
R Thumb
L Forearm
L Dorsum
Spreadsheet: 274601d1383158453-converting-a-time-from-text-into-a-number-then-seconds-converttime-ex
Sheet: Sheet1

 |  |  |  |  |  | Data >> | Seconds |  |  | day | hours | minutes | sec
 |  |  |  |  |  | 1.11:29:14 |  |  |  | 1 | 11 | 29 | 14
 |  |  |  |  |  | 01:26:41
 |  |  |  |  |  | 00:56:56
Spreadsheet: 118487d1313726359-start-dates-end-dates-and-of-days-schedulingexample
Sheet: Sheet1

Start Date | End Date | Days | Start Date | End Date | Days
2011-05-12 00:00:00 | 2011-05-18 00:00:00 |  | 2011-05-12 00:00:00 | 2011-05-18 00:00:00 | 6
2011-05-13 00:00:00 |  | 12 | 2011-05-13 00:00:00 | 2011-05-25 00:00:00 | 12
 | 2011-05-16 00:00:00 | 4 | 2011-05-12 00:00:00 | 2011-05-16 00:00:00 | 4
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: CIAO

CIAO
2009-2010
COUNTER-Compliant?: | No
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
CIAO
No of Visitors | 1 | 6 | 7 | 12 | 8 | 9 | 4 | 2 | 2 | 0 | 0 | 0 |  | 1035
No of Visits | 2 | 9 | 15 | 13 | 16 | 13 | 9 | 2 | 2 | 0 | 0 | 0 |  | 1035
No of Views | 6 | 44 | 51 | 25 | 18 | 14 | 16 | 2 | 4 | 0 | 0 | 0 |  | 1035
No of Google Searches | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1035 | N/A
[NAME] | 6 | 36 | 37 | 16 | 14 | 4 | 9 | 1 | 2 | 0 | 0 | 0 |  | 1035
Average Visit Duration | 9 min 21 sec | 9 min 24 sec | 4 min 51 sec | 35 sec | 21 sec | 10 sec | 1 min 15 sec | n/a | 18 sec | n/a | n/a | n/a | —
Spreadsheet: 92693d1292260354-vlookup-w-3-colums-ex1-1-
Sheet: Sheet1

Date | Amount | [NAME] | Merge | Cert
2010-05-05 00:00:00 | 10000 | 630 |  | 7001234
2010-06-06 00:00:00 | 5000 | 420 |  | 7001235
2010-07-07 00:00:00 | 5000 | 580 |  | 7001236
2010-08-08 00:00:00 | 10000 | 340 |  | 7001237
2010-09-09 00:00:00 | 12000 | 341 |  | 7001238
Spreadsheet: 719215d1613561668-formula-with-four-criteria-to-satisfy-sample-workbook
Sheet: SAMPLE WORKBOOK

 | FORMULA |  | 1 OR 9 | AMOUNT |  |  | Variables
 |  |  | 9 | -10 |  |  | 9- | 0001
 |  |  | 1 | 50 |  |  | 9+ | 0009
 |  |  | 9 | 20 |  |  | 1- | 0009
 |  |  | 1 | -50 |  |  | 1+ | 0001
Spreadsheet: 215086d1361261960-valuation-of-inventory-with-their-sale-value-datafile
Sheet: Valuation

Item\Site | Category | Bharatpur |  | Bikaner |  | [NAME]
 |  | Qty | Amount | Qty | Amount | Qty | Amount |  | FIFO Method
choclate | Edible | 300 | 6000 | 628 | 44070 | 0 | 0 | Everything is fine in my working but the major issue is:
buiscuit | Edible | 500 | 3500 | 0 | 0 | 0 | 0
Pepsi | Drink | 0 | 0 | 0 | 0 | 0 | 0 | my Senior want to know:
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1.Rate of issue of item in "item transfer to Project"
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 2.Amount of issue of item in "item transfer to Project"
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 3..Rate of Issue of item in "item transfer to site"
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 4. Amount of issue of item in "item transfer to site"
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 5. In summary with valuation sheet I have comment in column "S" what I             have required
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 6. If I have get completed the above five issues then the valuation part will be completed….
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Thanks
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Regard
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [NAME]
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 149825d1334156974-count-of-values-based-on-criteria-which-as-exactly-in-pivot-book1
Sheet: Sheet1

Rep | Value |  |  | # of 0's | # of 1's
ABC | 0 |  | ABC
ABC | 1 |  | BCA
ABC | 0 |  | CAB
ABC | 1 |  |  |  |  |  |  |  |  | Sum of Value | Value
BCA | 1 |  |  |  |  |  |  |  |  | Rep | 0 | 1 | Grand Total
BCA | 1 |  |  |  |  |  |  |  |  | ABC | 0 | 2 | 2
BCA | 0 |  |  |  |  |  |  |  |  | BCA | 0 | 2 | 2
CAB | 1 |  |  |  |  |  |  |  |  | CAB |  | 3 | 3
CAB | 1 |  |  |  |  |  |  |  |  | Grand Total | 0 | 7 | 7
CAB | 1
Spreadsheet: 795286d1662602973-need-help-to-find-a-formula-to-repeat-a-previous-value-until-there-there-is-new-value-help-in-formula-1-
Sheet: Sheet1

 | Year | Month | Name | Science Score | [NAME] to display
 | 2022 | Jan | [NAME] | 90 | 90
 | 2022 | Feb | [NAME] |  | 90
 | 2022 | March | [NAME] |  | 90
 | 2022 | March | Mark | 75 | 75
 | 2022 | April | Mark |  | 75
 | 2022 | April | [NAME] | 50 | 50
 | 2022 | May | Mark |  | 75
 | 2022 | May | [NAME] |  | 50
 | 2022 | Jun | Mark | 60 | 60
 | 2022 | Jun | [NAME] |  | 50
 | 2022 | July | Mark |  | 60
 | 2022 | Aug | Mark |  | 60
Spreadsheet: 594152d1539598846-capture-a-image-in-excel-gate-pass-db
Sheet: Sheet1

Sl. No | Student Name | STUDENT IMAGE | Adm. No | Class | Address | DOB | Mobile | Gender | Admission Date | Father Name | Mother Name | TAKEN BY (NAME & IMAGE) |  | REASON TO GO | RELATION | CONTACT NO OF WHO TAKEN
1 | AKSHITA SHRMA |  | 4362 | I A (2018-19) |  | 2018-09-06 00:00:00 |  | Female | 2018-07-06 00:00:00 | MR. ABHISHEK SHARMA
2 | ADITYA TOMAR 4354 |  | 4354 | I C (2018-19) |  | 2012-04-23 00:00:00 |  | Male | 2018-07-02 00:00:00 | MR. AVDESH TOMAR
3 | ATUL TOPPO |  | 4353 | I B (2018-19) |  | 2012-04-06 00:00:00 |  | Male | 2018-07-02 00:00:00 | MR. MARTIN TOPPO
4 | RITU GURJAR |  | 4349 | I C (2018-19) |  | 2011-05-28 00:00:00 |  | Male | 2018-07-02 00:00:00 | MR. YOGENDRA SINGH GURJAR
5 | NAMAN SHARMA 4348 |  | 4348 | I A (2018-19) |  | 2012-07-01 00:00:00 |  | Male | 2018-06-27 00:00:00 | MR. VIJAY SHARMA
6 | [NAME] |  | 4332 | I B (2018-19) |  | 2012-11-11 00:00:00 |  | Male | 2018-04-25 00:00:00 | MR. VIVEK AGRAWAL
7 | KUNAL DANGAS |  | 4325 | I A (2018-19) |  | 2012-06-02 00:00:00 |  | Male | 2018-04-23 00:00:00 | MR. [NAME]
8 | [NAME]  4309 |  | 4309 | I B (2018-19) |  | 2012-10-22 00:00:00 |  | Male | 2018-04-16 00:00:00 | MR. JITENDRA SHARMA
9 | KRISHNA MIDDHA |  | 4304 | I B (2018-19) |  | 2012-05-24 00:00:00 |  | Male | 2018-04-13 00:00:00 | MR. MANISH MIDDHA
10 | SAUBHYA SHARMA |  | 4297 | I B (2018-19) |  | 2012-05-30 00:00:00 |  | Male | 2018-04-12 00:00:00 | MR. RAVIKANT SHARMA
11 | SIDDHI GARG |  | 4296 | I A (2018-19) |  | 2012-09-30 00:00:00 |  | Female | 2018-04-11 00:00:00 | MR. GIRJESH GARG
12 | AARADHYA PARMAR |  | 4177 | I A (2018-19) |  | 2012-04-06 00:00:00 |  | Female | 2018-04-02 00:00:00 | MR. [NAME]
13 | AASTHA BHARDWAJ |  | 4178 | I B (2018-19) |  | 2012-09-16 00:00:00 |  | Female | 2018-04-02 00:00:00 | MR. [NAME]
14 | AASTIK [NAME] |  | 4179 | I C (2018-19) |  | 2012-06-12 00:00:00 |  | Male | 2018-04-02 00:00:00 | MR. SUNIL [NAME]
Spreadsheet: 102113d1300148678-lookup-based-on-multiple-criteria-cap-analysis
Sheet: Analysis

Member ID | Plan | Sex | Age |  |  |  |  |  |  |  |  | Capitation Received |  | Age Factor | Co pay Factor | Final Result
1 | HMOHRA | F | 64 | 30 | 30 | 30 | 30 | 30 | 30 | 150 | 50 | 167.95
2 | HMOCOM | M | 19 | 20 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | HMOCOM | F | 1 | 15 | 15 | 15 | 15 | 0 | 15 | 15 | 35 | 184.34
4 | HMOCOM | F | 16 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | HMOCOM | F | 11 | 20 | 30 | 20 | 30 | 0 | 30 | 30 | 50 | 53.32
6 | HMOCOM | F | 42 | 20 |  | 0 | 20 | 0 | 20 | 20 | 100 | 138.62
7 | HMOCOM | F | 12 | 10 | 20 | 0 | 10 | 0 | 10 | 10 | 50 | 68.49
8 | HMOCOM | M | 47 | 30 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | HMOCOM | M | 8 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | HMOHRA | M | 52 | 30 | 50 | 0 | 50 | 0 | 50 | 50 | 75 | 0
11 | HMOCOM | F | 0 | 20 | 20 | 0 | 20 | 20 | 20 | 20 | 50 | 258.75
12 | HMOCOM | F | 45 | 20 | 25 | 0 | 25 | 0 | 25 | 25 | 25 | 140.91
13 | HMOCOM | M | 53 | 30 | 40 | 30 | 40 | 0 | 40 | 40 | 75 | 104.76
14 | HMOHRA | M | 34 | 30 | 50 | 0 | 50 | 0 | 0 | 150 | 35 | 66.18
15 | HMOCOM | F | 13 | 20 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | HMOCOM | M | 55 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 50 | 134.72
17 | HMOCOM | F | 13 | 10 | 10 | 10 | 10 | 0 | 10 | 10 | 35 | 67.25
18 | HMOCOM | F | 43 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | HMOCOM | F | 20 | 25 | 35 | 25 | 35 | 0 | 35 | 35 | 100 | 92.11
20 | HMOCOM | M | 71 | 20 | 25 | 20 | 25 | 0 | 0 | 100 | 35 | 146.88
21 | HMOCOM | F | 19 | 30 | 40 | 30 | 40 | 0 | 40 | 40 | 35 | 62.18
22 | HMOHRA | F | 56 | 20 | 25 | 0 | 25 | 0 | 0 | 150 | 35 | 175.35
Spreadsheet: 57241d1257359776-2-way-text-look-up-2_waytext_lookup
Sheet: Sheet1

ORGINAL DATA
[NAME] |  |  |  |  |  |  |  | DATA NEED TO BE TURNED SIDEWAYS INTO THESE COLUMNS
Company: | [NAME] and Compan
Address: | 777 North Central Avenue |  |  |  |  |  |  | Company: | Address: | Address: | Address: | Phone: | Fax: | Website: | Chapter: | Specialties: | Languages:
 | Suite |  |  |  |  | [NAME] |  | [NAME] and Compan | 777 North Central Avenue | Suite | LA, CA 92586 | 555555555 | 44444444 | http://www.bobobobobobo.com | LAVAAA | Social Security Disability | Spanish, Armenian, [NAME]
 | LA, CA 92586 |  |  |  |  | [NAME] |  | Attorney | 3 Amhurst Court | LA, CA 92586 |  | 66667777 | 77777 | 0 | Greater Inland Empire | FEHA Disability | Spanish
Phone: | 555555555
Fax: | 44444444
Website: | http://www.bobobobobobo.com
Chapter: | LAVAAA
Specialties: | Social Security Disability
Languages: | Spanish, Armenian, [NAME]
[NAME]
Company: | Attorney
Address: | 3 Amhurst Court
 | LA, CA 92586
Phone: | 66667777
Fax: | 77777
Website:
Chapter: | Greater Inland Empire
Specialties: | FEHA Disability
Languages: | Spanish
Spreadsheet: 06da0fa5-91da-4128-83ca-1673800a2ec7
Sheet: Sheet1

Crime Index | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Year | Age and Sex
 | Under 18 |  |  | 18 and over
 | Total | Male | Female | Total | Male | Female
1993 | 1279.511841356605 | 1934.277838830287 | 591.6785780938391 | 1098.853591737692 | 1774.467287487654 | 476.0943233793479
1994 | 1343.437114310695 | 2005.682654012137 | 647.0737733127611 | 1069.847332267123 | 1704.929106982694 | 482.8603031372854
1995 | 1303.78639823503 | 1932.208468705076 | 642.8905810833144 | 1076.611231592292 | 1712.008472854248 | 488.4447336023209
1996 | 1259.398706697012 | 1836.807695597668 | 652.0812732848468 | 1004.796462330173 | 1580.857691966897 | 470.8258391265038
1997 | 1204.211614046071 | 1738.741519164472 | 642.0190516924544 | 997.9614022726473 | 1555.496165736761 | 480.3384352855105
1998 | 1044.70121786839 | 1497.301412083541 | 568.6310984004828 | 932.1003177759005 | 1446.65344222086 | 453.4959686484813
1999 | 918.9383191335105 | 1306.931051627497 | 510.8458924102341 | 848.1839893513154 | 1309.508165631779 | 418.0715145106815
2000 | 853.8499169904526 | 1195.662115215428 | 494.3374066452216 | 797.5595501896033 | 1229.95136811845 | 393.7157249628722
2001 | 802.2630810037381 | 1105.514067265657 | 483.8677921282541 | 789.2052933406189 | 1213.207501686741 | 391.9802224679117
Spreadsheet: 42706d1241269020-transfer-data-to-3-worksheets-copy-of-time-sheet-test
Sheet: Datasheet

Start Time | Finish Time | Start Place | Finish Place | Total Hours
dfg | dfg | dfg | dfg | dfg
dd | dd | dd | dd | dd
dd | dd | dd | dd | dd
ss | ss | ss | ss | ss
Spreadsheet: 864672d1711755150-hyperlink-todays-date-book11-nocoder-
Sheet: mar

 |  | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00 | 2024-03-25 00:00:00 | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00
Apr
Months
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Spreadsheet: 105670d1302959494-dependent-list-problem-dependent-list
Sheet: Sheet3

Drop 1 | Drop 2
Red Fruit |  | "=INDIRECT(VLOOKUP(A2,NameLookup,2,0))"
FruitList
Red Fruit | RedFruit
Yellow & Orange Fruit | YOFruit
Green Fruit | GreenFruit
RedFruit | YOFruit | GreenFruit
choice 1 | choice 3 | choice 4
choice 2 | choice 4 | choice 5